| # |
type |
message |
| 1 | Context | initialization |
| 2 | Controller | initialization |
| 3 | Routing | match route [opportunityShortterm] "/opportunity/shortterm" |
| 4 | Request | request parameters array ( 'module' => 'opportunity', 'action' => 'shortterm',) |
| 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 "opportunityActions->executeShortterm()" |
| 12 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 13 | Creole | prepareStatement(): SELECT opportunity.PRF_NUMBER, opportunity.WEBREGION_ID, opportunity.COUNTRY_CODE, opportunity.TITLE, opportunity.NPL_CODE, opportunity.DESCRIPTION, opportunity.TERM, opportunity.WEBSITE, opportunity.PRIORITY, opportunity.DATE_MODIFIED, opportunity.DATE_CREATED, UPPER(opportunity.COUNTRY_CODE), UPPER(opportunity.TITLE) FROM opportunity WHERE opportunity.TERM=? ORDER BY UPPER(opportunity.COUNTRY_CODE) ASC,UPPER(opportunity.TITLE) ASC |
| 14 | Creole | executeQuery(): [5.75 ms] SELECT opportunity.PRF_NUMBER, opportunity.WEBREGION_ID, opportunity.COUNTRY_CODE, opportunity.TITLE, opportunity.NPL_CODE, opportunity.DESCRIPTION, opportunity.TERM, opportunity.WEBSITE, opportunity.PRIORITY, opportunity.DATE_MODIFIED, opportunity.DATE_CREATED, UPPER(opportunity.COUNTRY_CODE), UPPER(opportunity.TITLE) FROM opportunity WHERE opportunity.TERM='1' ORDER BY UPPER(opportunity.COUNTRY_CODE) ASC,UPPER(opportunity.TITLE) ASC |
| 15 | View | initialize view for "opportunity/shortterm" |
| 16 | View | render "sf_app_dir\modules/opportunity/templates/shorttermSuccess.php" |
| 17 | View | initialize view for "global/_banner" |
| 18 | View | render "sf_app_dir\templates/_banner.php" |
| 19 | PartialHelper | call "hppage->executePrayer()" |
| 20 | 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 |
| 21 | Creole | executeQuery(): [2430.94 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 |
| 22 | View | initialize view for "hppage/_prayer" |
| 23 | View | render "sf_app_dir\modules/hppage/templates/_prayer.php" |
| 24 | View | initialize view for "global/_languages" |
| 25 | View | render "sf_app_dir\templates/_languages.php" |
| 26 | View | initialize view for "global/_navigation" |
| 27 | View | render "sf_app_dir\templates/_navigation.php" |
| 28 | View | initialize view for "category/_go-serve" |
| 29 | View | render "sf_app_dir\modules/category/templates/_go-serve.php" |
| 30 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 31 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='AO' |
| 32 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 33 | Creole | executeQuery(): [2430.64 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='BD' |
| 34 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 35 | Creole | executeQuery(): [0.91 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='BF' |
| 36 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 37 | Creole | executeQuery(): [0.83 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='BJ' |
| 38 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 39 | Creole | executeQuery(): [0.87 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='BO' |
| 40 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 41 | Creole | executeQuery(): [0.83 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='BW' |
| 42 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 43 | Creole | executeQuery(): [1.21 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='CI' |
| 44 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 45 | Creole | executeQuery(): [0.80 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='CL' |
| 46 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 47 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='CN' |
| 48 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 49 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='ET' |
| 50 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 51 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='GH' |
| 52 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 53 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='KE' |
| 54 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 55 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='LR' |
| 56 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 57 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='MN' |
| 58 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 59 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='MW' |
| 60 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 61 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='MZ' |
| 62 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 63 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='NA' |
| 64 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 65 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='NE' |
| 66 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 67 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='NG' |
| 68 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 69 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='NP' |
| 70 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 71 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='PE' |
| 72 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 73 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='SD' |
| 74 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 75 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='TH' |
| 76 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 77 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='US' |
| 78 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 79 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='UY' |
| 80 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 81 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='ZA' |
| 82 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 83 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='ZM' |
| 84 | Creole | prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=? |
| 85 | Creole | executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='ZZ' |
| 86 | View | initialize view for "global/_donate-resources-email" |
| 87 | View | render "sf_app_dir\templates/_donate-resources-email.php" |
| 88 | View | decorate content with "sf_app_dir\templates/layout.php" |
| 89 | View | render "sf_app_dir\templates/layout.php" |