Pere Pons S.A - Company

Company

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent533a84a373356ed4c6bc733be879a931
  time1337536641
  timeout10
- Message(empty)
- Auth
  redirect/debug_kit/toolbar_access/history_state/4
====
Request
+ –
Request

Cake Params
- controllersections
- actionview
- named(empty)
- pass
  0empresa
  112
- plugin(null)
- url
  exthtml
  url/sections/view/empresa/12
- form(empty)
- isAjax(false)
$_GET
- url/sections/view/empresa/12
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys
  0controller
  1action
- options(empty)
- defaults
  plugin(null)
  actionindex
- template/:controller/:action/*
- _greedy(true)
- _compiledRoute#^/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `contents`	12	12	0
SHOW FULL COLUMNS FROM `i18n`	6	6	0
SHOW FULL COLUMNS FROM `configurations`	3	3	0
SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'eng'	15	15	0
SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14)	55	55	0
SHOW FULL COLUMNS FROM `sections`	13	13	0
SELECT `Section`., `ParentSection`., `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'eng' ORDER BY `Section`.`sort` ASC	3	3	0
SELECT `Section`., `ParentSection`., `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`id` = 12 AND `I18n__title`.`locale` = 'eng' LIMIT 1	1	1	0
SELECT `Section`., `ParentSection`., `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` = 12 AND `I18n__title`.`locale` = 'eng' ORDER BY `Section`.`sort` ASC	2	2	1	maybe slow
SELECT `Section`.`lft`, `Section`.`rght` FROM `sections` AS `Section` WHERE `Section`.`id` = 12 LIMIT 1	1	1	0
SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE 1 = 1 AND `Section`.`lft` <= 1 AND `Section`.`rght` >= 6 AND `I18n__title`.`locale` = 'eng' ORDER BY `Section`.`lft` asc	1	1	1
SHOW FULL COLUMNS FROM `content_files`	8	8	0
SHOW FULL COLUMNS FROM `content_links`	5	5	0
SELECT `Content`., `Section`., `I18n__title`.`content`, `I18n__text`.`content`, `Content`.`id` FROM `contents` AS `Content` LEFT JOIN `i18n` AS `I18n__title` ON (`Content`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Content' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__text` ON (`Content`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'Content' AND `I18n__text`.`field` = 'text') LEFT JOIN `sections` AS `Section` ON (`Content`.`section_id` = `Section`.`id`) WHERE `section_id` = 12 AND `I18n__title`.`locale` = 'eng' AND `I18n__text`.`locale` = 'eng'	0	0	1	maybe slow
SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'eng'	15	15	0
SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14)	55	55	0
SELECT `Section`., `ParentSection`., `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'eng' ORDER BY `Section`.`sort` ASC	3	3	0
SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE `Section`.`parent_id` = 12 AND `I18n__title`.`locale` = 'eng' ORDER BY `Section`.`sort` ASC	2	2	0
SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'eng'	15	15	0
SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14)	55	55	0
SELECT `Section`., `ParentSection`., `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'eng' ORDER BY `Section`.`sort` ASC	3	3	0
SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE `Section`.`parent_id` = 13 AND `I18n__title`.`locale` = 'eng' ORDER BY `Section`.`sort` ASC	6	6	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

+ –

Memory

Peak Memory Use 11.66 MB

Message	Memory use
Component intitailization	7.49 MB
Controller action start	7.92 MB
Controller render start	8.12 MB
Component intitailization #2	9.79 MB
Controller action start #2	9.82 MB
Component intitailization #3	9.85 MB
Controller action start #3	9.88 MB
View render complete	9.76 MB

Timers

Total Request Time: 554 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	312.94
Component initialization and startup	28.16
Controller action	26.49
Render Controller Action	60.06
» Rendering View	56.92
» » Rendering APP/views/sections/view.ctp	21.37
» » » Rendering APP/views/elements/submenu.ctp	1.19
» » Rendering APP/views/layouts/default.ctp	35.03
» » » Rendering APP/views/elements/menu.ctp	33.30
» » » » Component initialization and startup #2	9.86
Controller action #2	0.00
» » » » » Component initialization and startup #3	9.57
Controller action #3	0.00

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- section
  Section
  id12
  parent_id(null)
  lft1
  rght6
  slugempresa
  iconeDSCF0742.JPG
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize399532
  sort0
  active1
  created2011-03-15 12:43:13
  modified2011-04-08 06:15:57
  localeeng
  titleCompany
  ParentSection
  id(null)
  parent_id(null)
  lft(null)
  rght(null)
  slug(null)
  icone(null)
  dir(null)
  mimetype(null)
  filesize(null)
  sort(null)
  active(null)
  created(null)
  modified(null)
- path
  0
  Section
  id12
  parent_id(null)
  lft1
  rght6
  slugempresa
  iconeDSCF0742.JPG
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize399532
  sort0
  active1
  created2011-03-15 12:43:13
  modified2011-04-08 06:15:57
  localeeng
  titleCompany
- submenu
  0
  Section
  id14
  parent_id12
  lft2
  rght3
  slugpresentació
  iconeDSCF0668.jpg
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize409837
  sort0
  active1
  created2011-03-15 15:50:28
  modified2011-03-15 15:50:28
  localeeng
  titlePresentation
  ParentSection
  id12
  parent_id(null)
  lft1
  rght6
  slugempresa
  iconeDSCF0742.JPG
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize399532
  sort0
  active1
  created2011-03-15 12:43:13
  modified2011-04-08 06:15:57
  1
  Section
  id15
  parent_id12
  lft4
  rght5
  slughistòria
  iconeDSCF0676.jpg
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize623676
  sort0
  active1
  created2011-03-15 15:50:56
  modified2011-03-15 15:50:56
  localeeng
  titleHistory
  ParentSection
  id12
  parent_id(null)
  lft1
  rght6
  slugempresa
  iconeDSCF0742.JPG
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize399532
  sort0
  active1
  created2011-03-15 12:43:13
  modified2011-04-08 06:15:57
- contents(empty)
- sectionTitleCompany
- titleCompany
- menu_active12
- menu
  0
  Section
  id12
  parent_id(null)
  lft1
  rght6
  slugempresa
  iconeDSCF0742.JPG
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize399532
  sort0
  active1
  created2011-03-15 12:43:13
  modified2011-04-08 06:15:57
  localeeng
  titleCompany
  ParentSection
  id(null)
  parent_id(null)
  lft(null)
  rght(null)
  slug(null)
  icone(null)
  dir(null)
  mimetype(null)
  filesize(null)
  sort(null)
  active(null)
  created(null)
  modified(null)
  1
  Section
  id13
  parent_id(null)
  lft7
  rght20
  slugproductes
  iconeDSCF0683.jpg
  diruploads/section/icone
  mimetypeimage/jpeg
  filesize297980
  sort1
  active1
  created2011-03-15 12:50:02
  modified2011-04-08 06:15:57
  localeeng
  titleProducts
  ParentSection
  id(null)
  parent_id(null)
  lft(null)
  rght(null)
  slug(null)
  icone(null)
  dir(null)
  mimetype(null)
  filesize(null)
  sort(null)
  active(null)
  created(null)
  modified(null)
  2
  Section
  id22
  parent_id(null)
  lft21
  rght22
  slugindex
  icone
  dir
  mimetype
  filesize0
  sort2
  active1
  created2011-04-08 00:12:52
  modified2011-04-08 06:15:57
  localeeng
  title
  ParentSection
  id(null)
  parent_id(null)
  lft(null)
  rght(null)
  slug(null)
  icone(null)
  dir(null)
  mimetype(null)
  filesize(null)
  sort(null)
  active(null)
  created(null)
  modified(null)
- session_active(false)
- pageTitlePere Pons S.A
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1number
  2htmlToolbar
  3toolbar
  4ajax
  5javascript
  6time
  7session
  8form
  9html
====

Company

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables