Log and debug messages

#	type	message
1	Context	initialization
2	Controller	initialization
3	Routing	match route [opportunityWebregion] "/opportunity/webregion/:webregion_id"
4	Request	request parameters array ( 'webregion_id' => 'africa-europe', 'module' => 'opportunity', 'action' => 'webregion',)
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->executeWebregion()"
12	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
13	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=?
14	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='africa-europe', offset: 0, limit: 1
15	Creole	executeQuery(): [0.68 ms] SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.STRIPPED_TITLE='africa-europe' LIMIT 1
16	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(country.TITLE), UPPER(opportunity.TITLE) FROM opportunity LEFT JOIN country ON (opportunity.COUNTRY_CODE=country.CODE) WHERE opportunity.WEBREGION_ID=? ORDER BY UPPER(country.TITLE) ASC,UPPER(opportunity.TITLE) ASC
17	Creole	executeQuery(): [83.86 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(country.TITLE), UPPER(opportunity.TITLE) FROM opportunity LEFT JOIN country ON (opportunity.COUNTRY_CODE=country.CODE) WHERE opportunity.WEBREGION_ID=1 ORDER BY UPPER(country.TITLE) ASC,UPPER(opportunity.TITLE) ASC
18	View	initialize view for "opportunity/webregion"
19	View	render "sf_app_dir\modules/opportunity/templates/webregionSuccess.php"
20	View	initialize view for "global/_banner"
21	View	render "sf_app_dir\templates/_banner.php"
22	PartialHelper	call "hppage->executePrayer()"
23	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
24	Creole	executeQuery(): [0.00 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
25	View	initialize view for "hppage/_prayer"
26	View	render "sf_app_dir\modules/hppage/templates/_prayer.php"
27	View	initialize view for "global/_languages"
28	View	render "sf_app_dir\templates/_languages.php"
29	View	initialize view for "global/_navigation"
30	View	render "sf_app_dir\templates/_navigation.php"
31	View	initialize view for "webregion/_africa-europe"
32	View	render "sf_app_dir\modules/webregion/templates/_africa-europe.php"
33	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=?
34	Creole	executeQuery(): [0.93 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'
35	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=?
36	Creole	executeQuery(): [0.67 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='AT'
37	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=?
38	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='BJ'
39	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=?
40	Creole	executeQuery(): [0.85 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'
41	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=?
42	Creole	executeQuery(): [0.90 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'
43	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=?
44	Creole	executeQuery(): [0.85 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'
45	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=?
46	Creole	executeQuery(): [0.81 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='CF'
47	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=?
48	Creole	executeQuery(): [0.92 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'
49	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=?
50	Creole	executeQuery(): [0.79 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='FR'
51	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=?
52	Creole	executeQuery(): [0.97 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'
53	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=?
54	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='GN'
55	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=?
56	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'
57	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=?
58	Creole	executeQuery(): [15.63 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'
59	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=?
60	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='MG'
61	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=?
62	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'
63	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=?
64	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='ML'
65	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=?
66	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'
67	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=?
68	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'
69	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=?
70	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'
71	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=?
72	Creole	executeQuery(): [0.97 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'
73	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=?
74	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='SN'
75	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=?
76	Creole	executeQuery(): [0.93 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'
77	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=?
78	Creole	executeQuery(): [0.94 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='SS'
79	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=?
80	Creole	executeQuery(): [0.67 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'
81	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=?
82	Creole	executeQuery(): [0.79 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='TZ'
83	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=?
84	Creole	executeQuery(): [0.79 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='TG'
85	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=?
86	Creole	executeQuery(): [0.81 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'
87	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=?
88	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='ZW'
89	View	initialize view for "global/_donate-resources-email"
90	View	render "sf_app_dir\templates/_donate-resources-email.php"
91	View	decorate content with "sf_app_dir\templates/layout.php"
92	View	render "sf_app_dir\templates/layout.php"

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    action: webregion
    module: opportunity
    webregion_id: africa-europe
attributeHolder: 
  symfony/default:

Response

---
cookies: 
httpHeaders: 
  Content-Type: text/html; charset=utf-8
parameterHolder: 
  helper/asset/auto/httpmeta: 
    Content-Type: text/html; charset=utf-8
  helper/asset/auto/javascript: 
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    language: en
    robots: index, follow
    title: Opportunities in Africa &amp; Europe
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    blue: 
    site: 
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
mod_hppage_enabled: 1
mod_hppage_is_internal: 
mod_hppage_view_class: sfPHP
mod_opportunity_enabled: 1
mod_opportunity_is_internal: 
mod_opportunity_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: D:\www\LocalUser\domain16\apps\frontend\config
sf_app_config_dir_name: config
sf_app_dir: D:\www\LocalUser\domain16\apps\frontend
sf_app_i18n_dir: D:\www\LocalUser\domain16\apps\frontend\i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: D:\www\LocalUser\domain16\apps\frontend\lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: D:\www\LocalUser\domain16\apps\frontend\modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: D:\www\LocalUser\domain16\apps\frontend\templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: D:\www\LocalUser\domain16\cache\frontend
sf_bin_dir: D:\www\LocalUser\domain16\batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: 
sf_check_symfony_version: 
sf_compressed: 
sf_config_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\config
sf_config_dir: D:\www\LocalUser\domain16\config
sf_config_dir_name: config
sf_data_dir: D:\www\LocalUser\domain16\data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: D:\www\LocalUser\domain16\data\doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 4095
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 
sf_i18n_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\i18n
sf_lib_dir: D:\www\LocalUser\domain16\lib
sf_lib_dir_name: lib
sf_log_dir: D:\www\LocalUser\domain16\log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate: 
sf_login_action: login
sf_login_module: default
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: D:\www\LocalUser\domain16\lib\model
sf_module_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_orm: propel
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: D:\www\LocalUser\domain16\plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: D:\www\LocalUser\domain16\cache
sf_root_dir: D:\www\LocalUser\domain16
sf_routing_defaults: 
  sf_culture: en
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: C:\PHP\pear\data/symfony
sf_symfony_lib_dir: C:\PHP\pear/symfony
sf_template_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\template
sf_test: 
sf_test_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\test
sf_test_dir: D:\www\LocalUser\domain16\test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1337583049.1813
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: D:\www\LocalUser\domain16\web\uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:  &darr;&nbsp;
sf_validation_error_suffix:  &nbsp;&darr;
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: D:\www\LocalUser\domain16\web
sf_web_dir_name: web

Globals

---
cookie: 
  symfony: quiup0m8jud9o4un947vebm862
env: 
files: 
get: 
post: 
server: 
  ALLUSERSPROFILE: C:\Documents and Settings\All Users
  APPL_MD_PATH: /LM/w3svc/1384502356/root
  APPL_PHYSICAL_PATH: D:\www\LocalUser\domain16\web\
  APP_POOL_ID: DefaultAppPool
  AUTH_PASSWORD: 
  AUTH_TYPE: 
  AUTH_USER: 
  CERT_COOKIE: 
  CERT_FLAGS: 
  CERT_ISSUER: 
  CERT_SERIALNUMBER: 
  CERT_SUBJECT: 
  COMPUTERNAME: U15301843
  CONTENT_LENGTH: 0
  CONTENT_TYPE: 
  ClusterLog: C:\WINDOWS\Cluster\cluster.log
  ComSpec: C:\WINDOWS\system32\cmd.exe
  CommonProgramFiles: C:\Program Files\Common Files
  DOCUMENT_ROOT: D:\www\LocalUser\domain16\web
  FCGI_ROLE: RESPONDER
  FP_NO_HOST_CHECK: NO
  GATEWAY_INTERFACE: CGI/1.1
  HTTPS: off
  HTTPS_KEYSIZE: 
  HTTPS_SECRETKEYSIZE: 
  HTTPS_SERVER_ISSUER: 
  HTTPS_SERVER_SUBJECT: 
  HTTP_ACCEPT: text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
  HTTP_CACHE_CONTROL: no-cache
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=quiup0m8jud9o4un947vebm862
  HTTP_HOST: www.sim.org
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc03-02
  INSTANCE_ID: 1384502356
  INSTANCE_META_PATH: /LM/W3SVC/1384502356
  LOCAL_ADDR: 74.208.112.55
  LOGON_USER: 
  NUMBER_OF_PROCESSORS: 2
  ORIG_PATH_INFO: /frontend_dev.php/opportunity/webregion/africa-europe
  OS: Windows_NT
  PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
  PATH_INFO: /opportunity/webregion/africa-europe
  PATH_TRANSLATED: D:\www\LocalUser\domain16\web\frontend_dev.php\opportunity\webregion\africa-europe
  PHP_FCGI_MAX_REQUESTS: 10000
  PHP_SELF: /frontend_dev.php/opportunity/webregion/africa-europe
  PROCESSOR_ARCHITECTURE: x86
  PROCESSOR_IDENTIFIER: x86 Family 15 Model 107 Stepping 2, AuthenticAMD
  PROCESSOR_LEVEL: 15
  PROCESSOR_REVISION: 6b02
  Path: C:\Program Files\Windows Resource Kits\Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\PHP
  ProgramFiles: C:\Program Files
  QUERY_STRING: 
  REMOTE_ADDR: 38.107.179.232
  REMOTE_HOST: 38.107.179.232
  REMOTE_PORT: 34509
  REMOTE_USER: 
  REQUEST_METHOD: GET
  REQUEST_TIME: 1337583049
  REQUEST_URI: /frontend_dev.php/opportunity/webregion/africa-europe
  SCRIPT_FILENAME: D:\www\LocalUser\domain16\web\frontend_dev.php
  SCRIPT_NAME: /frontend_dev.php
  SERVER_NAME: www.sim.org
  SERVER_PORT: 80
  SERVER_PORT_SECURE: 0
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SOFTWARE: Microsoft-IIS/6.0
  SystemDrive: C:
  SystemRoot: C:\WINDOWS
  TEMP: C:\WINDOWS\TEMP
  TMP: C:\WINDOWS\TEMP
  URL: /frontend_dev.php
  USERPROFILE: C:\Documents and Settings\Default User
  _FCGI_X_PIPE_: \\.\pipe\IISFCGI-2ef496c0-fcef-4332-bb7b-feeebd013de0
  windir: C:\WINDOWS
session: 
  symfony/user/sfUser/attributes: 
  symfony/user/sfUser/authenticated: 
  symfony/user/sfUser/credentials: 
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1337582883

Php

---
php: 5.2.5
os: Windows NT U15301843 5.2 build 3790
extensions: 
  - bcmath
  - calendar
  - com_dotnet
  - ctype
  - session
  - filter
  - ftp
  - hash
  - iconv
  - json
  - odbc
  - pcre
  - Reflection
  - date
  - libxml
  - standard
  - tokenizer
  - zlib
  - SimpleXML
  - dom
  - SPL
  - wddx
  - xml
  - xmlreader
  - xmlwriter
  - cgi-fcgi
  - curl
  - gd
  - mbstring
  - mcrypt
  - mysql
  - mysqli
  - xmlrpc
  - xsl

SQL queries

[0.68 ms] SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.STRIPPED_TITLE='africa-europe' LIMIT 1
[83.86 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(country.TITLE), UPPER(opportunity.TITLE) FROM opportunity LEFT JOIN country ON (opportunity.COUNTRY_CODE=country.CODE) WHERE opportunity.WEBREGION_ID=1 ORDER BY UPPER(country.TITLE) ASC,UPPER(opportunity.TITLE) ASC
[0.00 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
[0.93 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'
[0.67 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='AT'
[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='BJ'
[0.85 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'
[0.90 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'
[0.85 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'
[0.81 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='CF'
[0.92 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'
[0.79 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='FR'
[0.97 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'
[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='GN'
[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'
[15.63 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'
[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='MG'
[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'
[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='ML'
[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'
[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'
[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'
[0.97 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'
[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='SN'
[0.93 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'
[0.94 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='SS'
[0.67 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'
[0.79 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='TZ'
[0.79 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='TG'
[0.81 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'
[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='ZW'

type	calls	time (ms)
Configuration	11	-28.70
Action "opportunity/webregion"	1	242.47
Database	31	116.27
View "Success" for "opportunity/webregion"	1	534.16
Partial "global/_banner"	1	46.57
Component "hppage/prayer"	1	10.21
Partial "hppage/_prayer"	1	22.09
Partial "global/_languages"	1	-22.45
Partial "global/_navigation"	1	31.26
Partial "webregion/_africa-europe"	1	24.87
Partial "global/_donate-resources-email"	1	2.91

Angola

Austria

Benin

Botswana

Burkina Faso

Côte d'Ivoire

Central African Republic

Ethiopia

France

Ghana

Guinea

Kenya

Liberia

Madagascar

Malawi

Mali

Mozambique

Namibia

Niger

Nigeria

Senegal

South Africa

South Sudan

Sudan

Tanzania

Togo

Zambia

Zimbabwe

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers