| # |
type |
message |
| 1 | Context | initialization |
| 2 | Controller | initialization |
| 3 | Routing | match route [home] "/" |
| 4 | Request | request parameters array ( 'module' => 'content', 'action' => 'index',) |
| 5 | Controller | dispatch request |
| 6 | Filter | executing filter "sfRenderingFilter" |
| 7 | Filter | executing filter "sfWebDebugFilter" |
| 8 | Filter | executing filter "sfCommonFilter" |
| 9 | Filter | executing filter "sfFlashFilter" |
| 10 | Filter | executing filter "sfExecutionFilter" |
| 11 | Creole | connect(): DSN: array ( 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'username' => '****', ), FLAGS: 0 |
| 12 | Creole | prepareStatement(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? |
| 13 | Creole | applyLimit(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8, offset: 0, limit: 1 |
| 14 | Creole | executeQuery(): [12.92 ms] SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8 LIMIT 1 |
| 15 | Action | call "contentActions->executeIndex()" |
| 16 | Creole | prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college_program WHERE college_program.PROGRAM_ID=? AND college_program.DEGREE_ID=degree.ID ORDER BY UPPER(degree.NAME) ASC |
| 17 | Creole | executeQuery(): [302.71 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college_program WHERE college_program.PROGRAM_ID=123 AND college_program.DEGREE_ID=degree.ID ORDER BY UPPER(degree.NAME) ASC |
| 18 | View | initialize view for "content/index" |
| 19 | View | render "sf_root_dir/apps/frontend/modules/content/templates/indexSuccess.php" |
| 20 | PartialHelper | call "featured->executeFeaturedSchools()" |
| 21 | Creole | prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 22 | Creole | executeQuery(): [22.21 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='online_school' AND content_module.NAME='home' AND content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8 AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 23 | Creole | prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=? AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 24 | Creole | executeQuery(): [19.74 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=82 AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 25 | View | initialize view for "featured/_featuredSchools" |
| 26 | View | render "sf_root_dir/apps/frontend/modules/featured/templates/_featuredSchools.php" |
| 27 | PartialHelper | call "featured->executeFeaturedCampusSchools()" |
| 28 | Creole | prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 29 | Creole | executeQuery(): [2.71 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='campus_school' AND content_module.NAME='home1' AND content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8 AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 30 | Creole | prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=? AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 31 | Creole | executeQuery(): [2.57 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=83 AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 32 | View | initialize view for "featured/_featuredCampusSchools" |
| 33 | View | render "sf_root_dir/apps/frontend/modules/featured/templates/_featuredCampusSchools.php" |
| 34 | PartialHelper | call "featured->executeFeaturedCampusSchools()" |
| 35 | Creole | prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 36 | Creole | executeQuery(): [2.66 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='campus_school' AND content_module.NAME='home2' AND content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8 AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 37 | Creole | prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=? AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 38 | Creole | executeQuery(): [2.79 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=83 AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 39 | View | initialize view for "featured/_featuredCampusSchools" |
| 40 | View | render "sf_root_dir/apps/frontend/modules/featured/templates/_featuredCampusSchools.php" |
| 41 | PartialHelper | call "featured->executeFeaturedCampusSchools()" |
| 42 | Creole | prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 43 | Creole | executeQuery(): [1.58 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='campus_school' AND content_module.NAME='home3' AND content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8 AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 44 | Creole | prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=? AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 45 | Creole | executeQuery(): [2.59 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=83 AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 46 | View | initialize view for "featured/_featuredCampusSchools" |
| 47 | View | render "sf_root_dir/apps/frontend/modules/featured/templates/_featuredCampusSchools.php" |
| 48 | PartialHelper | call "featured->executeFeaturedCampusSchools()" |
| 49 | Creole | prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 50 | Creole | executeQuery(): [1.81 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='campus_school' AND content_module.NAME='home4' AND content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8 AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 51 | Creole | prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=? AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 52 | Creole | executeQuery(): [2.90 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL FROM college, content_item WHERE content_item.CONTENT_GROUP_ID=83 AND college.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 53 | View | initialize view for "featured/_featuredCampusSchools" |
| 54 | View | render "sf_root_dir/apps/frontend/modules/featured/templates/_featuredCampusSchools.php" |
| 55 | PartialHelper | call "guide->executeMcsguide()" |
| 56 | Creole | prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 57 | Creole | executeQuery(): [2.35 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='article' AND content_module.NAME='home' AND content_page.MODULE_NAME='content' AND content_page.ACTION_NAME='index' AND content_page.SITE_ID=8 AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 58 | Creole | prepareStatement(): SELECT guide.ID, guide.NAME, guide.ARTICLE, guide.TYPE_ID, guide.ORDER_NO FROM guide, content_item WHERE content_item.CONTENT_GROUP_ID=? AND guide.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 59 | Creole | executeQuery(): [7.68 ms] SELECT guide.ID, guide.NAME, guide.ARTICLE, guide.TYPE_ID, guide.ORDER_NO FROM guide, content_item WHERE content_item.CONTENT_GROUP_ID=84 AND guide.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 60 | View | initialize view for "guide/_mcsguide" |
| 61 | View | render "sf_root_dir/apps/frontend/modules/guide/templates/_mcsguide.php" |
| 62 | View | decorate content with "sf_root_dir/apps/frontend/templates/nurse.php" |
| 63 | View | render "sf_root_dir/apps/frontend/templates/nurse.php" |
| 64 | View | initialize view for "global/_header" |
| 65 | View | render "sf_root_dir/apps/frontend/templates/_header.php" |
| 66 | View | initialize view for "global/_footer" |
| 67 | View | render "sf_root_dir/apps/frontend/templates/_footer.php" |