| # |
type |
message |
| 1 |  Context | initialization |
| 2 | Controller | initialization |
| 3 | Routing | match route [categoryWebregion] "/category/:stripped_title/webregion/:webregion_id" |
| 4 | Request | request parameters array ( 'stripped_title' => 'people-groups', 'webregion_id' => 'asia-pacific', 'module' => 'category', 'action' => 'show',) |
| 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 | Action | call "categoryActions->executeShow()" |
| 12 | Creole | connect(): DSN: array ( 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 13 | Creole | prepareStatement(): SELECT category.ID, category.SUBCAT_OF_ID, category.TITLE, category.STRIPPED_TITLE, category.SUMMARY, category.DAYS_NEW, category.IS_LINKABLE, category.LISTING_ORDER, category.IS_FEED_VISIBLE, category.BANNER_URL FROM category WHERE category.STRIPPED_TITLE=? |
| 14 | Creole | applyLimit(): SELECT category.ID, category.SUBCAT_OF_ID, category.TITLE, category.STRIPPED_TITLE, category.SUMMARY, category.DAYS_NEW, category.IS_LINKABLE, category.LISTING_ORDER, category.IS_FEED_VISIBLE, category.BANNER_URL FROM category WHERE category.STRIPPED_TITLE='people-groups', offset: 0, limit: 1 |
| 15 | Creole | executeQuery(): [0.00 ms] SELECT category.ID, category.SUBCAT_OF_ID, category.TITLE, category.STRIPPED_TITLE, category.SUMMARY, category.DAYS_NEW, category.IS_LINKABLE, category.LISTING_ORDER, category.IS_FEED_VISIBLE, category.BANNER_URL FROM category WHERE category.STRIPPED_TITLE='people-groups' LIMIT 1 |
| 16 | Creole | prepareStatement(): SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.STRIPPED_TITLE=? |
| 17 | Creole | applyLimit(): SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.STRIPPED_TITLE='asia-pacific', offset: 0, limit: 1 |
| 18 | Creole | executeQuery(): [0.67 ms] SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.STRIPPED_TITLE='asia-pacific' LIMIT 1 |
| 19 | Creole | prepareStatement(): SELECT content.ID, content.TITLE, content.STRIPPED_TITLE, content.BYLINE, content.SUMMARY, content.BODY, content.SIDEBAR, content.CATEGORY_ID, content.WEBREGION_ID, content.COUNTRY_CODE, content.CREATED_ON, content.UPDATED_ON, content.DATE_START, content.DATE_END, content.DATE_DISPLAY, content.TAGS, content.COMMENTS, content.IS_APPROVED, content.IS_PUBLISHED, content.IS_DELETED, content.LISTING_ORDER, content.PROJECT_ID, content.BANNER_URL, content.BANNER_CAPTION, UPPER(content.TITLE) FROM content LEFT JOIN category ON (content.CATEGORY_ID=category.ID) WHERE content.CATEGORY_ID=? AND content.IS_PUBLISHED=? AND (content.DATE_START IS NULL OR content.DATE_START<=?) AND (content.DATE_END IS NULL OR content.DATE_END>=?) AND content.WEBREGION_ID=? ORDER BY content.DATE_DISPLAY DESC,UPPER(content.TITLE) ASC |
| 20 | Creole | executeQuery(): [21.28 ms] SELECT content.ID, content.TITLE, content.STRIPPED_TITLE, content.BYLINE, content.SUMMARY, content.BODY, content.SIDEBAR, content.CATEGORY_ID, content.WEBREGION_ID, content.COUNTRY_CODE, content.CREATED_ON, content.UPDATED_ON, content.DATE_START, content.DATE_END, content.DATE_DISPLAY, content.TAGS, content.COMMENTS, content.IS_APPROVED, content.IS_PUBLISHED, content.IS_DELETED, content.LISTING_ORDER, content.PROJECT_ID, content.BANNER_URL, content.BANNER_CAPTION, UPPER(content.TITLE) FROM content LEFT JOIN category ON (content.CATEGORY_ID=category.ID) WHERE content.CATEGORY_ID=9 AND content.IS_PUBLISHED=1 AND (content.DATE_START IS NULL OR content.DATE_START<='2012-05-16 19:34:50') AND (content.DATE_END IS NULL OR content.DATE_END>='2012-05-16 19:34:50') AND content.WEBREGION_ID=3 ORDER BY content.DATE_DISPLAY DESC,UPPER(content.TITLE) ASC |
| 21 | View | initialize view for "category/show" |
| 22 | View | render "sf_app_dir\modules/category/templates/showSuccess.php" |
| 23 | View | initialize view for "global/_banner" |
| 24 | View | render "sf_app_dir\templates/_banner.php" |
| 25 | PartialHelper | call "hppage->executePrayer()" |
| 26 | Creole | prepareStatement(): SELECT hppagecontent.HPPAGE_ID, hppagecontent.HPCONTENT_ID, hpcontent.ID, hpcontent.HPSLOT_ID, hpcontent.TITLE, hpcontent.SUMMARY, hpcontent.IMAGE, hpcontent.LINK, hpcontent.CREATED_ON, hpcontent.LISTING_ORDER FROM hppagecontent, hpcontent WHERE hpcontent.HPSLOT_ID=? AND hppagecontent.HPCONTENT_ID=hpcontent.ID ORDER BY hpcontent.LISTING_ORDER ASC,hpcontent.CREATED_ON DESC |
| 27 | Creole | executeQuery(): [1.09 ms] SELECT hppagecontent.HPPAGE_ID, hppagecontent.HPCONTENT_ID, hpcontent.ID, hpcontent.HPSLOT_ID, hpcontent.TITLE, hpcontent.SUMMARY, hpcontent.IMAGE, hpcontent.LINK, hpcontent.CREATED_ON, hpcontent.LISTING_ORDER FROM hppagecontent, hpcontent WHERE hpcontent.HPSLOT_ID=5 AND hppagecontent.HPCONTENT_ID=hpcontent.ID ORDER BY hpcontent.LISTING_ORDER ASC,hpcontent.CREATED_ON DESC |
| 28 | View | initialize view for "hppage/_prayer" |
| 29 | View | render "sf_app_dir\modules/hppage/templates/_prayer.php" |
| 30 | View | initialize view for "global/_languages" |
| 31 | View | render "sf_app_dir\templates/_languages.php" |
| 32 | View | initialize view for "global/_navigation" |
| 33 | View | render "sf_app_dir\templates/_navigation.php" |
| 34 | View | initialize view for "webregion/_asia-pacific" |
| 35 | View | render "sf_app_dir\modules/webregion/templates/_asia-pacific.php" |
| 36 | View | initialize view for "global/_donate-resources-email" |
| 37 | View | render "sf_app_dir\templates/_donate-resources-email.php" |
| 38 | View | decorate content with "sf_app_dir\templates/layout.php" |
| 39 | View | render "sf_app_dir\templates/layout.php" |
vars & config
logs & msgs
4
6868.2 KB
392 ms
