Banc en inox

Ouvrage à façon

Mobiliers urbains

PMR - Accessibilité

Accès rapide

History
Request History
4 previous requests available
====
Session
Session
- Config
  userAgentc4329dfdd671036df9e358e1241bbe3e
  time1337339695
  timeout10
====
Request
Request

Cake Params
- pass
  015
  1Banc_en_inox
- named(empty)
- id15
- slugBanc_en_inox
- plugin(null)
- controllerproducts
- actionview
- url
  exthtml
  urlmobilier-urbain/produit/15-Banc_en_inox
- form(empty)
- isAjax(false)
$_GET
- urlmobilier-urbain/produit/15-Banc_en_inox
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- 0/mobilier-urbain/produit/:id-:slug
- 1#^/mobilier-urbain/produit(?:/([0-9]+))(?:-([^\/]+))?[\/]*$#
- 2
  0id
  1slug
- 3
  plugin(null)
  controllerproducts
  actionview
- 4
  pass
  0id
  1slug
  id[0-9]+
====

Sql Log

Sql Logs

default

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	14
2	DESCRIBE `acos`	7	7	14
3	DESCRIBE `aros_acos`	7	7	14
4	DESCRIBE `products`	11	11	15
5	DESCRIBE `catalogs`	9	9	16
6	DESCRIBE `product_images`	4	4	19
7	DESCRIBE `tags`	7	7	15
8	DESCRIBE `activities`	13	13	15
9	DESCRIBE `animations`	5	5	17
10	DESCRIBE `animation_frames`	6	6	15
11	DESCRIBE `animation_frame_attachments`	7	7	15
12	DESCRIBE `animation_frame_links`	5	5	16
13	DESCRIBE `post_categories`	10	10	15
14	DESCRIBE `posts`	11	11	15
15	DESCRIBE `posts_tags`	2	2	16
16	DESCRIBE `projects`	19	19	17
17	DESCRIBE `project_images`	5	5	17
18	DESCRIBE `materials`	3	3	19
19	DESCRIBE `materials_projects`	2	2	16
20	DESCRIBE `sectors`	3	3	19
21	DESCRIBE `projects_sectors`	2	2	15
22	DESCRIBE `activities_projects`	2	2	15
23	DESCRIBE `projects_tags`	2	2	15
24	DESCRIBE `activities_tags`	2	2	16
25	DESCRIBE `products_tags`	2	2	16
26	SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `aros` AS `Aro` LEFT JOIN `aros` AS `Aro0` ON (`Aro0`.`alias` = 'ROOT') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC	1	1	0
27	SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `acos` AS `Aco` LEFT JOIN `acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') LEFT JOIN `acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'Products') LEFT JOIN `acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY `Aco`.`lft` DESC	3	3	1
28	SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `aros_acos` AS `Permission` LEFT JOIN `aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 1 AND `Permission`.`aco_id` IN (212, 210, 1) ORDER BY `Aco`.`lft` desc	2	2	1
29	SELECT `Product`.`id`, `Product`.`catalog_id`, `Product`.`title`, `Product`.`intro`, `Product`.`description`, `Product`.`image`, `Product`.`meta_title`, `Product`.`meta_key`, `Product`.`meta_desc`, `Product`.`created`, `Product`.`modified`, `Catalog`.`id`, `Catalog`.`title`, `Catalog`.`intro`, `Catalog`.`description`, `Catalog`.`meta_title`, `Catalog`.`meta_key`, `Catalog`.`meta_desc`, `Catalog`.`created`, `Catalog`.`modified` FROM `products` AS `Product` LEFT JOIN `catalogs` AS `Catalog` ON (`Product`.`catalog_id` = `Catalog`.`id`) WHERE `Product`.`id` = 15 LIMIT 1	1	1	5
30	SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`title`, `ProductImage`.`file` FROM `product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (15)	0	0	2
31	SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`description`, `Tag`.`meta_title`, `Tag`.`meta_key`, `Tag`.`meta_desc`, `Tag`.`slug`, `ProductsTag`.`tag_id`, `ProductsTag`.`product_id` FROM `tags` AS `Tag` JOIN `products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 15 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1	0	0	1

toggle (5) query explains for default

Query: SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `acos` AS `Aco` LEFT JOIN `acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') LEFT JOIN `acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'Products') LEFT JOIN `acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY `Aco`.`lft` DESC

id	select_type	table	type	rows	Extra
1	SIMPLE	Aco	ALL	236	Using temporary; Using filesort
1	SIMPLE	Aco0	ALL	236
1	SIMPLE	Aco1	ALL	236
1	SIMPLE	Aco2	ALL	236	Using where

Query: SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `aros_acos` AS `Permission` LEFT JOIN `aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 1 AND `Permission`.`aco_id` IN (212, 210, 1) ORDER BY `Aco`.`lft` desc

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Permission	ALL					51	Using where; Using temporary; Using filesort
1	SIMPLE	Aro	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	Aco	eq_ref	PRIMARY	PRIMARY	4	608880_cfparis.Permission.aco_id	1

Query: SELECT `Product`.`id`, `Product`.`catalog_id`, `Product`.`title`, `Product`.`intro`, `Product`.`description`, `Product`.`image`, `Product`.`meta_title`, `Product`.`meta_key`, `Product`.`meta_desc`, `Product`.`created`, `Product`.`modified`, `Catalog`.`id`, `Catalog`.`title`, `Catalog`.`intro`, `Catalog`.`description`, `Catalog`.`meta_title`, `Catalog`.`meta_key`, `Catalog`.`meta_desc`, `Catalog`.`created`, `Catalog`.`modified` FROM `products` AS `Product` LEFT JOIN `catalogs` AS `Catalog` ON (`Product`.`catalog_id` = `Catalog`.`id`) WHERE `Product`.`id` = 15 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Product	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	Catalog	const	PRIMARY	PRIMARY	4	const	1

Query: SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`title`, `ProductImage`.`file` FROM `product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (15)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`description`, `Tag`.`meta_title`, `Tag`.`meta_key`, `Tag`.`meta_desc`, `Tag`.`slug`, `ProductsTag`.`tag_id`, `ProductsTag`.`product_id` FROM `tags` AS `Tag` JOIN `products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 15 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

====

Timer

Memory

Peak Memory Use 18.46 MB

Message	Memory use
Component intitailization	13.21 MB
Controller action start	13.28 MB
Controller render start	14.73 MB
View render complete	18.02 MB

Timers

Total Request Time: 6526 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	5296.78
Component initialization and startup	243.09
Controller action	62.56
Render Controller Action	355.68
» Rendering View	353.68
» » Rendering APP/views/products/view.ctp	228.29
» » Rendering APP/views/layouts/default.ctp	122.54
» » » Rendering APP/views/elements/contact_btn.ctp	8.52
» » » Rendering APP/views/elements/menus/top2.ctp	12.45
» » » Rendering APP/views/elements/breadcrumbs.ctp	12.62
» » » Rendering APP/views/elements/login_button.ctp	10.78
» » » Rendering APP/views/elements/search.ctp	14.94
» » » Rendering APP/views/elements/menus/bottom.ctp	17.73

====

Log

Logs

error.log

There were no log entries made this request

debug.log

There were no log entries made this request

====
Variables
View Variables
- product
  Product
  id15
  catalog_id6
  titleBanc en inox
  intro
  description
  image4d7d4a9a-ea24-4574-9e24-0d28cf9287ea.jpg
  meta_title
  meta_key
  meta_desc
  created2011-03-13 23:52:10
  modified2011-03-13 23:52:10
  Catalog
  id6
  titleGamme de bancs
  intro
  description
  meta_title
  meta_key
  meta_desc
  created2011-03-13 23:50:47
  modified2011-03-13 23:50:47
  ProductImage(empty)
  Tag(empty)
- h1TitleBanc en inox
- crumbs
  0
  titleAccueil
  url/
  1
  titleMobilier Urbain
  url
  controlleractivities
  actionview
  id2
  0mobiliers-urbains
  2
  titleCatalogues
  url
  controllercatalogs
  actionindex
  3
  titleGamme de bancs
  url
  controllercatalogs
  actionview
  06
  4
  titleBanc en inox
  url(null)
- selectedMenus
  main2
- loggedIn(false)
- currentUser(null)
- isAdmin(false)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0html
  1form
  2head
  3javascript
  4markup
  5yaml
  6phpthumb
  7myProject
  8adminButtons
  9staticText
  10text
  11cache
  12rss
  13time
  14wysiwyg
  15tinymce
  16toolbar
  17htmlToolbar
  18number
  19simpleGraph
  20session
====

Banc en inox

Banc en inox

Ouvrage à façon

Mobiliers urbains

PMR - Accessibilité

Accès rapide

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Memory

Timers

Logs

error.log

debug.log

View Variables