Log and debug messages

#	type	message
1	Context	initialization
2	Controller	initialization
3	Routing	match route [default] "/:module/:action/*"
4	Request	request parameters array ( 'module' => 'book', 'action' => 'list', 'page' => '6',)
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 "bookActions->executeList()"
12	Doctrine Statement	executeQuery : SELECT COUNT(DISTINCT b.id) AS num_results FROM books b LEFT JOIN book_tags b2 ON b.id = b2.book_id LEFT JOIN tags t ON t.id = b2.tag_id LEFT JOIN publishers p ON b.publisher_id = p.id WHERE b.category_id = ? GROUP BY b.id - (1 )
13	View	initialize view for "book/list"
14	ViewConfig	set component "category_menu" (category/list)
15	ViewConfig	set component "highlight" (book/highlight)
16	View	render "sf_app_dir/modules/book/templates/listSuccess.php"
17	PartialHelper	call "category->executeTitle()"
18	View	initialize view for "category/_title"
19	View	render "sf_app_dir/modules/category/templates/_title.php"
20	Doctrine Statement	executeQuery : SELECT DISTINCT b3.id FROM books b3 LEFT JOIN book_tags b4 ON b3.id = b4.book_id LEFT JOIN tags t2 ON t2.id = b4.tag_id LEFT JOIN publishers p2 ON b3.publisher_id = p2.id WHERE b3.category_id = ? ORDER BY b3.title ASC LIMIT 20 OFFSET 100 - (1 )
21	Doctrine Statement	executeQuery : SELECT b.id AS b__id, b.title AS b__title, b.edition AS b__edition, b.series AS b__series, b.author AS b__author, b.price AS b__price, b.descript AS b__descript, b.isbn AS b__isbn, b.published_at AS b__published_at, b.created_at AS b__created_at, b.category_id AS b__category_id, b.publisher_id AS b__publisher_id, b.image_id AS b__image_id, t.id AS t__id, t.name AS t__name, t.icon AS t__icon, t.is_private AS t__is_private, t.is_approved AS t__is_approved, p.id AS p__id, p.publisher_id AS p__publisher_id, p.name AS p__name FROM books b LEFT JOIN book_tags b2 ON b.id = b2.book_id LEFT JOIN tags t ON t.id = b2.tag_id LEFT JOIN publishers p ON b.publisher_id = p.id WHERE b.id IN ('61393', '58229', '35048', '38854', '35813', '65488', '10128', '25272', '25273', '27864', '44331', '22778', '35249', '5110', '5733', '64540', '6090', '64518', '64789', '58693') AND b.category_id = ? ORDER BY b.title ASC - (1 )
22	View	decorate content with "sf_app_dir/templates/layout.php"
23	View	render "sf_app_dir/templates/layout.php"
24	PartialHelper	call "book->executeHighlight()"
25	Doctrine Statement	executeQuery : SELECT b.id AS b__id, b.title AS b__title, b.edition AS b__edition, b.series AS b__series, b.author AS b__author, b.price AS b__price, b.descript AS b__descript, b.isbn AS b__isbn, b.published_at AS b__published_at, b.created_at AS b__created_at, b.category_id AS b__category_id, b.publisher_id AS b__publisher_id, b.image_id AS b__image_id, i.id AS i__id, i.name AS i__name, i.height AS i__height, i.width AS i__width, RAND() AS b__0 FROM books b LEFT JOIN images i ON b.image_id = i.id WHERE (b.image_id != 0 AND b.image_id IS NOT NULL AND b.created_at >= ?) ORDER BY b__0 LIMIT 1 - (2008-12-08 )
26	View	initialize view for "book/_highlight"
27	View	render "sf_app_dir/modules/book/templates/_highlight.php"
28	PartialHelper	call "ads->executeView()"
29	Doctrine Statement	executeQuery : SELECT a.id AS a__id, a.client_name AS a__client_name, a.startdate AS a__startdate, a.enddate AS a__enddate, a.viewings AS a__viewings, a.clicks AS a__clicks, a.url AS a__url, a.image AS a__image, a.created_at AS a__created_at FROM advertising a WHERE (a.startdate <= ? AND a.enddate >= ?) - (2009-01-07, 2009-01-07 )
30	View	initialize view for "ads/_view"
31	View	render "sf_app_dir/modules/ads/templates/_view.php"
32	PartialHelper	call "category->executeList()"
33	Doctrine Query	executeQuery : SELECT c.id AS c__id, c.cmatch AS c__cmatch, c.name AS c__name, c.dewey AS c__dewey FROM categories c ORDER BY c.dewey ASC
34	View	initialize view for "category/_list"
35	View	render "sf_app_dir/modules/category/templates/_list.php"

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    action: list
    module: book
    page: 6
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/prototype/js/builder: /sf/prototype/js/builder
    /sf/prototype/js/effects: /sf/prototype/js/effects
    /sf/prototype/js/prototype: /sf/prototype/js/prototype
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
    functions: functions
  helper/asset/auto/meta: 
    description: ----- Librairie monette ltée __ Calgary&#039;s French Bookstore -----
    keywords: ----- Librairie monette ltée __ Calgary&#039;s French Bookstore -----
    language: fr
    robots: index, follow
    title: ----- Librairie monette ltée __ Calgary&#039;s French Bookstore -----
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    main: 
    template: 
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
app_book_category_list_max: 20
app_news_list_max: 4
mod_ads_enabled: 1
mod_ads_is_internal: 
mod_ads_view_class: sfPHP
mod_book_enabled: 1
mod_book_is_internal: 
mod_book_view_class: sfPHP
mod_category_enabled: 1
mod_category_is_internal: 
mod_category_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: monette
sf_app_config_dir: /srv/htdocs/svnapache/websites/monette/apps/monette/config
sf_app_config_dir_name: config
sf_app_dir: /srv/htdocs/svnapache/websites/monette/apps/monette
sf_app_i18n_dir: /srv/htdocs/svnapache/websites/monette/apps/monette/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: /srv/htdocs/svnapache/websites/monette/apps/monette/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: /srv/htdocs/svnapache/websites/monette/apps/monette/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: /srv/htdocs/svnapache/websites/monette/apps/monette/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: /srv/htdocs/svnapache/websites/monette/cache/monette
sf_bin_dir: /srv/htdocs/svnapache/websites/monette/batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: /srv/htdocs/svnapache/websites/monette/cache/monette/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: /srv/htdocs/svnapache/websites/monette/cache/monette/dev/config
sf_config_dir: /srv/htdocs/svnapache/websites/monette/config
sf_config_dir_name: config
sf_data_dir: /srv/htdocs/svnapache/websites/monette/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: /srv/htdocs/svnapache/websites/monette/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: 1
sf_i18n_cache: 1
sf_i18n_cache_dir: /srv/htdocs/svnapache/websites/monette/cache/monette/dev/i18n
sf_i18n_debug: 
sf_i18n_default_culture: fr_FR
sf_i18n_source: XLIFF
sf_i18n_untranslated_prefix: [T]
sf_i18n_untranslated_suffix: [/T]
sf_lib_dir: /srv/htdocs/svnapache/websites/monette/lib
sf_lib_dir_name: lib
sf_log_dir: /srv/htdocs/svnapache/websites/monette/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: users
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: /srv/htdocs/svnapache/websites/monette/lib/model
sf_module_cache_dir: /srv/htdocs/svnapache/websites/monette/cache/monette/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_orm: doctrine
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: /srv/htdocs/svnapache/websites/monette/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: /srv/htdocs/svnapache/websites/monette/cache
sf_root_dir: /srv/htdocs/svnapache/websites/monette
sf_routing_defaults: 
  sf_culture: fr_FR
sf_secure_action: secure
sf_secure_module: users
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
sf_stats: 
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: /usr/share/pear/data/symfony
sf_symfony_lib_dir: /usr/share/pear/symfony
sf_template_cache_dir: /srv/htdocs/svnapache/websites/monette/cache/monette/dev/template
sf_test: 
sf_test_cache_dir: /srv/htdocs/svnapache/websites/monette/cache/monette/dev/test
sf_test_dir: /srv/htdocs/svnapache/websites/monette/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1231324930.6169
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: /srv/htdocs/svnapache/websites/monette/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: /srv/htdocs/svnapache/websites/monette/web
sf_web_dir_name: web

Globals

---
cookie: 
env: 
  CONSOLE: /dev/console
  HOME: /
  INIT_VERSION: sysvinit-2.86
  LANG: C
  PATH: /sbin:/usr/sbin:/bin:/usr/bin
  PREVLEVEL: N
  PWD: /
  RUNLEVEL: 5
  SELINUX_INIT: YES
  SHLVL: 3
  TERM: linux
  _: /usr/sbin/httpd
  previous: N
  runlevel: 5
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: /srv/htdocs/svnapache/websites/monette/web
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
  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_HOST: monette.nobletdesign.com
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
  PATH: /sbin:/usr/sbin:/bin:/usr/bin
  PATH_INFO: /book/list/page/6/category_id
  PATH_TRANSLATED: redirect:/index.php/list/page/6/category_id
  PHP_SELF: /monette_dev.php/book/list/page/6/category_id
  QUERY_STRING: 
  REMOTE_ADDR: 38.103.63.58
  REMOTE_PORT: 35192
  REQUEST_METHOD: GET
  REQUEST_TIME: 1231324930
  REQUEST_URI: /monette_dev.php/book/list/page/6/category_id
  SCRIPT_FILENAME: /srv/htdocs/svnapache/websites/monette/web/monette_dev.php
  SCRIPT_NAME: /monette_dev.php
  SERVER_ADDR: 24.72.122.184
  SERVER_ADMIN: root@localhost
  SERVER_NAME: monette.nobletdesign.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache/2.2.3 (CentOS) Server at monette.nobletdesign.com Port 80</address>
    
  SERVER_SOFTWARE: Apache/2.2.3 (CentOS)
session:

Php

---
php: 5.2.6
os: Linux platinum.nobletdesign.com 2.6.18-92.1.18.el5 #1 SMP Wed Nov 12 09:19:49 EST 2008 x86_64
extensions: 
  - libxml
  - xml
  - wddx
  - tokenizer
  - sysvshm
  - sysvsem
  - sysvmsg
  - session
  - pcre
  - SimpleXML
  - sockets
  - SPL
  - shmop
  - standard
  - Reflection
  - pspell
  - posix
  - iconv
  - hash
  - gmp
  - gettext
  - ftp
  - filter
  - exif
  - date
  - curl
  - ctype
  - calendar
  - bz2
  - zlib
  - openssl
  - apache2handler
  - dbase
  - dom
  - gd
  - imap
  - json
  - ldap
  - mbstring
  - mssql
  - mysql
  - mysqli
  - PDO
  - pdo_mysql
  - pdo_pgsql
  - pdo_sqlite
  - pgsql
  - xmlreader
  - xmlwriter
  - xsl
  - zip

SQL queries

SELECT COUNT(DISTINCT b.id) AS num_results FROM books b LEFT JOIN book_tags b2 ON b.id = b2.book_id LEFT JOIN tags t ON t.id = b2.tag_id LEFT JOIN publishers p ON b.publisher_id = p.id WHERE b.category_id = ? GROUP BY b.id - (1 )
SELECT DISTINCT b3.id FROM books b3 LEFT JOIN book_tags b4 ON b3.id = b4.book_id LEFT JOIN tags t2 ON t2.id = b4.tag_id LEFT JOIN publishers p2 ON b3.publisher_id = p2.id WHERE b3.category_id = ? ORDER BY b3.title ASC LIMIT 20 OFFSET 100 - (1 )
SELECT b.id AS b__id, b.title AS b__title, b.edition AS b__edition, b.series AS b__series, b.author AS b__author, b.price AS b__price, b.descript AS b__descript, b.isbn AS b__isbn, b.published_at AS b__published_at, b.created_at AS b__created_at, b.category_id AS b__category_id, b.publisher_id AS b__publisher_id, b.image_id AS b__image_id, t.id AS t__id, t.name AS t__name, t.icon AS t__icon, t.is_private AS t__is_private, t.is_approved AS t__is_approved, p.id AS p__id, p.publisher_id AS p__publisher_id, p.name AS p__name FROM books b LEFT JOIN book_tags b2 ON b.id = b2.book_id LEFT JOIN tags t ON t.id = b2.tag_id LEFT JOIN publishers p ON b.publisher_id = p.id WHERE b.id IN ('61393', '58229', '35048', '38854', '35813', '65488', '10128', '25272', '25273', '27864', '44331', '22778', '35249', '5110', '5733', '64540', '6090', '64518', '64789', '58693') AND b.category_id = ? ORDER BY b.title ASC - (1 )
SELECT b.id AS b__id, b.title AS b__title, b.edition AS b__edition, b.series AS b__series, b.author AS b__author, b.price AS b__price, b.descript AS b__descript, b.isbn AS b__isbn, b.published_at AS b__published_at, b.created_at AS b__created_at, b.category_id AS b__category_id, b.publisher_id AS b__publisher_id, b.image_id AS b__image_id, i.id AS i__id, i.name AS i__name, i.height AS i__height, i.width AS i__width, RAND() AS b__0 FROM books b LEFT JOIN images i ON b.image_id = i.id WHERE (b.image_id != 0 AND b.image_id IS NOT NULL AND b.created_at >= ?) ORDER BY b__0 LIMIT 1 - (2008-12-08 )
SELECT a.id AS a__id, a.client_name AS a__client_name, a.startdate AS a__startdate, a.enddate AS a__enddate, a.viewings AS a__viewings, a.clicks AS a__clicks, a.url AS a__url, a.image AS a__image, a.created_at AS a__created_at FROM advertising a WHERE (a.startdate <= ? AND a.enddate >= ?) - (2009-01-07, 2009-01-07 )
SELECT c.id AS c__id, c.cmatch AS c__cmatch, c.name AS c__name, c.dewey AS c__dewey FROM categories c ORDER BY c.dewey ASC

type	calls	time (ms)
Configuration	16	10.09
Action "book/list"	1	344.01
Database (Doctrine)	11	0.13
View "Success" for "book/list"	1	784.41
Component "category/title"	1	0.09
Partial "category/_title"	1	0.78
Component "book/highlight"	1	297.82
Partial "book/_highlight"	1	1.18
Component "ads/view"	1	7.54
Partial "ads/_view"	1	1.09
Component "category/list"	1	10.37
Partial "category/_list"	1	14.24

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers