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' => 'asia-pacific', '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='asia-pacific', offset: 0, limit: 1
15	Creole	executeQuery(): [0.71 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
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(): [29.51 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=3 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(): [3.25 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/_asia-pacific"
32	View	render "sf_app_dir\modules/webregion/templates/_asia-pacific.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(): [1.02 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'
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(): [1.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'
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.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='IN'
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.86 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'
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.68 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'
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.51 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='PK'
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.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='PH'
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.48 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='SG'
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.58 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='KR'
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.57 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'
53	View	initialize view for "global/_donate-resources-email"
54	View	render "sf_app_dir\templates/_donate-resources-email.php"
55	View	decorate content with "sf_app_dir\templates/layout.php"
56	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: asia-pacific
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 Asia-Pacific
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    red: 
    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: 1328736397.846
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: f4l31iodq2i4i2n1ls8j6bfh17
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=f4l31iodq2i4i2n1ls8j6bfh17
  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: ccc02-01
  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/asia-pacific
  OS: Windows_NT
  PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
  PATH_INFO: /opportunity/webregion/asia-pacific
  PATH_TRANSLATED: D:\www\LocalUser\domain16\web\frontend_dev.php\opportunity\webregion\asia-pacific
  PHP_FCGI_MAX_REQUESTS: 10000
  PHP_SELF: /frontend_dev.php/opportunity/webregion/asia-pacific
  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.216
  REMOTE_HOST: 38.107.179.216
  REMOTE_PORT: 59846
  REMOTE_USER: 
  REQUEST_METHOD: GET
  REQUEST_TIME: 1328736397
  REQUEST_URI: /frontend_dev.php/opportunity/webregion/asia-pacific
  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-cbbc64a2-f0cd-4967-902d-1260b58ef6c1
  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: 1328736374

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.71 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
[29.51 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=3 ORDER BY UPPER(country.TITLE) ASC,UPPER(opportunity.TITLE) ASC
[3.25 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
[1.02 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'
[1.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'
[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='IN'
[0.86 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'
[0.68 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'
[0.51 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='PK'
[0.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='PH'
[0.48 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='SG'
[0.58 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='KR'
[0.57 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'

type	calls	time (ms)
Configuration	11	47.30
Action "opportunity/webregion"	1	128.92
Database	13	40.58
View "Success" for "opportunity/webregion"	1	256.75
Partial "global/_banner"	1	60.29
Component "hppage/prayer"	1	27.00
Partial "hppage/_prayer"	1	3.06
Partial "global/_languages"	1	1.79
Partial "global/_navigation"	1	16.68
Partial "webregion/_asia-pacific"	1	3.80
Partial "global/_donate-resources-email"	1	1.17

Creative Access

Bangladesh

China

India

Mongolia

Nepal

Pakistan

Philippines

Singapore

South Korea

Thailand

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers