So So Summer

History
+
Historique des Requêtes
4 Des requêtes antérieures sont disponibles
====
Session
+
Session
- Config(array)
  userAgent4a535a9d0ddc0e7f29687b56e27577b1
  time1713486300
  countdown10
- _Token(array)
  keyb13a93fabc6b9a4c2c6f6af2b18ba99ec083aa4b
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  b13a93fabc6b9a4c2c6f6af2b18ba99ec083aa4b1713473700
====
Request
+
Requête

Cake Params
- plugin(null)
- controllerevents
- actiondisplay
- named(empty)
- pass(array)
  03
  1so-so-summer
- langfra
- id3
- slugso-so-summer
- _Token(array)
  keyb13a93fabc6b9a4c2c6f6af2b18ba99ec083aa4b
  unlockedFields(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Route actuelle
- nameI18nRoute
- keys(array)
  0slug
  1lang
  2id
- options(array)
  pass(array)
  0id
  1slug
  id[0-9]+
  __promote(true)
  langfra|eng|deu
- defaults(array)
  controllerevents
  actiondisplay
  plugin(null)
- template/:lang/evenements/:id_:slug
====

Logs Sql

default

Total Time: 7 ms
Total Queries: 20 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Translation`.`id`, `Translation`.`key`, `Translation`.`fra`, `Translation`.`eng`, `Translation`.`deu` FROM `stecna_staging`.`translations` AS `Translation` WHERE 1 = 1 ORDER BY `Translation`.`key` ASC	57	57	0
SELECT `Post`.`id`, `Post`.`updated`, `Post`.`created`, `Post`.`published`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__body`.`content`) AS `Post__i18n_body` FROM `stecna_staging`.`posts` AS `Post` INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__body` ON (`Post`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Post' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'fra') WHERE 1 = 1 ORDER BY `Post`.`created` ASC	2	2	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`updated`, `Setting`.`type`, `Setting`.`key`, `Setting`.`val`, `Setting`.`label`, `Setting`.`position`, `Setting`.`advanced` FROM `stecna_staging`.`settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`position` ASC	16	16	0
SELECT `Event`.`id`, `Event`.`date_start`, `Event`.`date_end`, `Event`.`start_time`, `Event`.`published`, `Event`.`featured`, `Event`.`place_id`, `Event`.`event_category_id`, `Event`.`created`, `Event`.`updated`, `Event`.`position`, (`I18n__title`.`content`) AS `Event__i18n_title`, (`I18n__subtitle`.`content`) AS `Event__i18n_subtitle`, (`I18n__body`.`content`) AS `Event__i18n_body`, (`I18n__excerpt`.`content`) AS `Event__i18n_excerpt`, (`I18n__legend`.`content`) AS `Event__i18n_legend`, `EventCategory`.`id`, `EventCategory`.`created`, `EventCategory`.`updated`, `Place`.`id`, `Place`.`published`, `Place`.`featured`, `Place`.`created`, `Place`.`updated`, `Place`.`color`, `Place`.`position`, `Place`.`mon_opening`, `Place`.`mon_closing`, `Place`.`tue_opening`, `Place`.`tue_closing`, `Place`.`wed_opening`, `Place`.`wed_closing`, `Place`.`thu_opening`, `Place`.`thu_closing`, `Place`.`fri_opening`, `Place`.`fri_closing`, `Place`.`sat_opening`, `Place`.`sat_closing`, `Place`.`sun_opening`, `Place`.`sun_closing`, `Place`.`lat`, `Place`.`long` FROM `stecna_staging`.`events` AS `Event` LEFT JOIN `stecna_staging`.`event_categories` AS `EventCategory` ON (`Event`.`event_category_id` = `EventCategory`.`id`) LEFT JOIN `stecna_staging`.`places` AS `Place` ON (`Event`.`place_id` = `Place`.`id`) INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Event`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Event' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subtitle` ON (`Event`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Event' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__body` ON (`Event`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Event' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__excerpt` ON (`Event`.`id` = `I18n__excerpt`.`foreign_key` AND `I18n__excerpt`.`model` = 'Event' AND `I18n__excerpt`.`field` = 'excerpt' AND `I18n__excerpt`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__legend` ON (`Event`.`id` = `I18n__legend`.`foreign_key` AND `I18n__legend`.`model` = 'Event' AND `I18n__legend`.`field` = 'legend' AND `I18n__legend`.`locale` = 'fra') WHERE `Event`.`id` = 3 AND `Event`.`published` = '1' ORDER BY `Event`.`position` ASC LIMIT 1	1	1	2	maybe slow
SELECT `Thumbnail`.`id`, `Thumbnail`.`filename`, `Thumbnail`.`filesize`, `Thumbnail`.`filetype`, `Thumbnail`.`type`, `Thumbnail`.`anchor_x`, `Thumbnail`.`anchor_y`, `Thumbnail`.`foreign_model`, `Thumbnail`.`foreign_id`, `Thumbnail`.`thumbnail`, `Thumbnail`.`created`, `Thumbnail`.`updated`, `Thumbnail`.`position`, `Thumbnail`.`extras` FROM `stecna_staging`.`assets` AS `Thumbnail` WHERE `Thumbnail`.`foreign_model` = 'event' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` = (3) ORDER BY `Thumbnail`.`position` ASC	1	1	0
SELECT `Asset`.`id`, `Asset`.`filename`, `Asset`.`filesize`, `Asset`.`filetype`, `Asset`.`type`, `Asset`.`anchor_x`, `Asset`.`anchor_y`, `Asset`.`foreign_model`, `Asset`.`foreign_id`, `Asset`.`thumbnail`, `Asset`.`created`, `Asset`.`updated`, `Asset`.`position`, `Asset`.`extras`, (`I18n__title`.`content`) AS `Asset__i18n_title`, (`I18n__description`.`content`) AS `Asset__i18n_description` FROM `stecna_staging`.`assets` AS `Asset` INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Asset`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Asset' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__description` ON (`Asset`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Asset' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'fra') WHERE `Asset`.`id` = 44 ORDER BY `Asset`.`position` ASC LIMIT 1	1	1	1
SELECT `EventCategory`.`id`, (`I18n__title`.`content`) AS `EventCategory__i18n_title` FROM `stecna_staging`.`event_categories` AS `EventCategory` INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`EventCategory`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'EventCategory' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') WHERE 1 = 1 ORDER BY `EventCategory`.`created` ASC	4	4	1	maybe slow
SELECT `Event`.`id`, `Event`.`date_start`, `Event`.`date_end`, `Event`.`start_time`, `Event`.`published`, `Event`.`featured`, `Event`.`place_id`, `Event`.`event_category_id`, `Event`.`created`, `Event`.`updated`, `Event`.`position`, (`I18n__title`.`content`) AS `Event__i18n_title`, (`I18n__subtitle`.`content`) AS `Event__i18n_subtitle`, (`I18n__body`.`content`) AS `Event__i18n_body`, (`I18n__excerpt`.`content`) AS `Event__i18n_excerpt`, (`I18n__legend`.`content`) AS `Event__i18n_legend`, `EventCategory`.`id`, `EventCategory`.`created`, `EventCategory`.`updated`, `Place`.`id`, `Place`.`published`, `Place`.`featured`, `Place`.`created`, `Place`.`updated`, `Place`.`color`, `Place`.`position`, `Place`.`mon_opening`, `Place`.`mon_closing`, `Place`.`tue_opening`, `Place`.`tue_closing`, `Place`.`wed_opening`, `Place`.`wed_closing`, `Place`.`thu_opening`, `Place`.`thu_closing`, `Place`.`fri_opening`, `Place`.`fri_closing`, `Place`.`sat_opening`, `Place`.`sat_closing`, `Place`.`sun_opening`, `Place`.`sun_closing`, `Place`.`lat`, `Place`.`long` FROM `stecna_staging`.`events` AS `Event` LEFT JOIN `stecna_staging`.`event_categories` AS `EventCategory` ON (`Event`.`event_category_id` = `EventCategory`.`id`) LEFT JOIN `stecna_staging`.`places` AS `Place` ON (`Event`.`place_id` = `Place`.`id`) INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Event`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Event' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subtitle` ON (`Event`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Event' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__body` ON (`Event`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Event' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__excerpt` ON (`Event`.`id` = `I18n__excerpt`.`foreign_key` AND `I18n__excerpt`.`model` = 'Event' AND `I18n__excerpt`.`field` = 'excerpt' AND `I18n__excerpt`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__legend` ON (`Event`.`id` = `I18n__legend`.`foreign_key` AND `I18n__legend`.`model` = 'Event' AND `I18n__legend`.`field` = 'legend' AND `I18n__legend`.`locale` = 'fra') WHERE `Event`.`published` = '1' AND `Event`.`id` != 3 AND ((`Event`.`date_end` >= '2024-04-18') OR (((`Event`.`date_end` IS NULL) AND (`Event`.`date_start` >= '2024-04-18')))) ORDER BY `Event`.`position` ASC LIMIT 2	0	0	2	maybe slow
SELECT `Place`.`id`, (`I18n__title`.`content`) AS `Place__i18n_title` FROM `stecna_staging`.`places` AS `Place` INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Place`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Place' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') WHERE 1 = 1 ORDER BY `Place`.`created` ASC	2	2	1	maybe slow
SELECT `Place`.`id`, `Place`.`published`, `Place`.`featured`, `Place`.`created`, `Place`.`updated`, `Place`.`color`, `Place`.`position`, `Place`.`mon_opening`, `Place`.`mon_closing`, `Place`.`tue_opening`, `Place`.`tue_closing`, `Place`.`wed_opening`, `Place`.`wed_closing`, `Place`.`thu_opening`, `Place`.`thu_closing`, `Place`.`fri_opening`, `Place`.`fri_closing`, `Place`.`sat_opening`, `Place`.`sat_closing`, `Place`.`sun_opening`, `Place`.`sun_closing`, `Place`.`lat`, `Place`.`long`, (`I18n__title`.`content`) AS `Place__i18n_title`, (`I18n__subtitle`.`content`) AS `Place__i18n_subtitle`, (`I18n__body`.`content`) AS `Place__i18n_body`, (`I18n__subbody`.`content`) AS `Place__i18n_subbody`, (`I18n__schedules`.`content`) AS `Place__i18n_schedules`, (`I18n__address`.`content`) AS `Place__i18n_address`, (`I18n__excerpt`.`content`) AS `Place__i18n_excerpt` FROM `stecna_staging`.`places` AS `Place` INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Place`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Place' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subtitle` ON (`Place`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Place' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__body` ON (`Place`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Place' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subbody` ON (`Place`.`id` = `I18n__subbody`.`foreign_key` AND `I18n__subbody`.`model` = 'Place' AND `I18n__subbody`.`field` = 'subbody' AND `I18n__subbody`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__schedules` ON (`Place`.`id` = `I18n__schedules`.`foreign_key` AND `I18n__schedules`.`model` = 'Place' AND `I18n__schedules`.`field` = 'schedules' AND `I18n__schedules`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__address` ON (`Place`.`id` = `I18n__address`.`foreign_key` AND `I18n__address`.`model` = 'Place' AND `I18n__address`.`field` = 'address' AND `I18n__address`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__excerpt` ON (`Place`.`id` = `I18n__excerpt`.`foreign_key` AND `I18n__excerpt`.`model` = 'Place' AND `I18n__excerpt`.`field` = 'excerpt' AND `I18n__excerpt`.`locale` = 'fra') WHERE 1 = 1 ORDER BY `Place`.`created` ASC	2	2	0
SELECT `Schedule`.`id`, `Schedule`.`created`, `Schedule`.`updated`, `Schedule`.`date_start`, `Schedule`.`date_end`, `Schedule`.`type`, `Schedule`.`place_id`, `Schedule`.`hour_start`, `Schedule`.`hour_end` FROM `stecna_staging`.`schedules` AS `Schedule` WHERE `Schedule`.`place_id` IN (1, 2)	7	7	0
SELECT `Collection`.`id`, `Collection`.`created`, `Collection`.`updated`, `Collection`.`place_id`, `Collection`.`published`, `Collection`.`featured`, `Collection`.`position`, `Collection`.`color` FROM `stecna_staging`.`collections` AS `Collection` WHERE `Collection`.`place_id` IN (1, 2)	2	2	0
SELECT `Event`.`id`, `Event`.`date_start`, `Event`.`date_end`, `Event`.`start_time`, `Event`.`published`, `Event`.`featured`, `Event`.`place_id`, `Event`.`event_category_id`, `Event`.`created`, `Event`.`updated`, `Event`.`position` FROM `stecna_staging`.`events` AS `Event` WHERE `Event`.`place_id` IN (1, 2)	5	5	0
SELECT `Asset`.`id`, `Asset`.`filename`, `Asset`.`filesize`, `Asset`.`filetype`, `Asset`.`type`, `Asset`.`anchor_x`, `Asset`.`anchor_y`, `Asset`.`foreign_model`, `Asset`.`foreign_id`, `Asset`.`thumbnail`, `Asset`.`created`, `Asset`.`updated`, `Asset`.`position`, `Asset`.`extras`, (`I18n__title`.`content`) AS `Asset__i18n_title`, (`I18n__description`.`content`) AS `Asset__i18n_description` FROM `assets` AS `Asset` INNER JOIN `i18n` AS `I18n__title` ON (`Asset`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = "Asset" AND `I18n__title`.`field` = "title" AND `I18n__title`.`locale` = "fra") INNER JOIN `i18n` AS `I18n__description` ON (`Asset`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = "Asset" AND `I18n__description`.`field` = "description" AND `I18n__description`.`locale` = "fra") WHERE `Asset`.`foreign_id` IN (1, 2) AND `Asset`.`foreign_model` = "Place" ORDER BY `Asset`.`position` ASC	8	8	0
SELECT `Thumbnail`.`id`, `Thumbnail`.`filename`, `Thumbnail`.`filesize`, `Thumbnail`.`filetype`, `Thumbnail`.`type`, `Thumbnail`.`anchor_x`, `Thumbnail`.`anchor_y`, `Thumbnail`.`foreign_model`, `Thumbnail`.`foreign_id`, `Thumbnail`.`thumbnail`, `Thumbnail`.`created`, `Thumbnail`.`updated`, `Thumbnail`.`position`, `Thumbnail`.`extras` FROM `stecna_staging`.`assets` AS `Thumbnail` WHERE `Thumbnail`.`foreign_model` = 'place' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` IN (1, 2) ORDER BY `Thumbnail`.`position` ASC	0	0	0
SELECT `Collection`.`id`, `Collection`.`created`, `Collection`.`updated`, `Collection`.`place_id`, `Collection`.`published`, `Collection`.`featured`, `Collection`.`position`, `Collection`.`color`, (`I18n__title`.`content`) AS `Collection__i18n_title`, (`I18n__subtitle`.`content`) AS `Collection__i18n_subtitle`, (`I18n__chapo`.`content`) AS `Collection__i18n_chapo`, (`I18n__body`.`content`) AS `Collection__i18n_body`, (`I18n__subbody`.`content`) AS `Collection__i18n_subbody`, `Place`.`id`, `Place`.`published`, `Place`.`featured`, `Place`.`created`, `Place`.`updated`, `Place`.`color`, `Place`.`position`, `Place`.`mon_opening`, `Place`.`mon_closing`, `Place`.`tue_opening`, `Place`.`tue_closing`, `Place`.`wed_opening`, `Place`.`wed_closing`, `Place`.`thu_opening`, `Place`.`thu_closing`, `Place`.`fri_opening`, `Place`.`fri_closing`, `Place`.`sat_opening`, `Place`.`sat_closing`, `Place`.`sun_opening`, `Place`.`sun_closing`, `Place`.`lat`, `Place`.`long` FROM `stecna_staging`.`collections` AS `Collection` LEFT JOIN `stecna_staging`.`places` AS `Place` ON (`Collection`.`place_id` = `Place`.`id`) INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Collection`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Collection' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subtitle` ON (`Collection`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Collection' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__chapo` ON (`Collection`.`id` = `I18n__chapo`.`foreign_key` AND `I18n__chapo`.`model` = 'Collection' AND `I18n__chapo`.`field` = 'chapo' AND `I18n__chapo`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__body` ON (`Collection`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Collection' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subbody` ON (`Collection`.`id` = `I18n__subbody`.`foreign_key` AND `I18n__subbody`.`model` = 'Collection' AND `I18n__subbody`.`field` = 'subbody' AND `I18n__subbody`.`locale` = 'fra') WHERE 1 = 1 ORDER BY `Collection`.`position` ASC	2	2	0
SELECT `History`.`id`, `History`.`collection_id`, `History`.`position`, `History`.`created` FROM `stecna_staging`.`histories` AS `History` WHERE `History`.`collection_id` IN (1, 2)	22	22	0
SELECT `Thumbnail`.`id`, `Thumbnail`.`filename`, `Thumbnail`.`filesize`, `Thumbnail`.`filetype`, `Thumbnail`.`type`, `Thumbnail`.`anchor_x`, `Thumbnail`.`anchor_y`, `Thumbnail`.`foreign_model`, `Thumbnail`.`foreign_id`, `Thumbnail`.`thumbnail`, `Thumbnail`.`created`, `Thumbnail`.`updated`, `Thumbnail`.`position`, `Thumbnail`.`extras` FROM `stecna_staging`.`assets` AS `Thumbnail` WHERE `Thumbnail`.`foreign_model` = 'collection' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` IN (1, 2) ORDER BY `Thumbnail`.`position` ASC	2	2	0
SELECT `Asset`.`id`, `Asset`.`filename`, `Asset`.`filesize`, `Asset`.`filetype`, `Asset`.`type`, `Asset`.`anchor_x`, `Asset`.`anchor_y`, `Asset`.`foreign_model`, `Asset`.`foreign_id`, `Asset`.`thumbnail`, `Asset`.`created`, `Asset`.`updated`, `Asset`.`position`, `Asset`.`extras`, (`I18n__title`.`content`) AS `Asset__i18n_title`, (`I18n__description`.`content`) AS `Asset__i18n_description` FROM `assets` AS `Asset` INNER JOIN `i18n` AS `I18n__title` ON (`Asset`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = "Asset" AND `I18n__title`.`field` = "title" AND `I18n__title`.`locale` = "fra") INNER JOIN `i18n` AS `I18n__description` ON (`Asset`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = "Asset" AND `I18n__description`.`field` = "description" AND `I18n__description`.`locale` = "fra") WHERE `Asset`.`foreign_id` IN (1, 2) AND `Asset`.`foreign_model` = "Collection" ORDER BY `Asset`.`position` ASC	13	13	0
SELECT `Alert`.`id`, `Alert`.`created`, `Alert`.`updated`, `Alert`.`position`, `Alert`.`collection_id`, (`I18n__title`.`content`) AS `Alert__i18n_title`, (`I18n__body`.`content`) AS `Alert__i18n_body`, `Collection`.`id`, `Collection`.`created`, `Collection`.`updated`, `Collection`.`place_id`, `Collection`.`published`, `Collection`.`featured`, `Collection`.`position`, `Collection`.`color` FROM `stecna_staging`.`alerts` AS `Alert` LEFT JOIN `stecna_staging`.`collections` AS `Collection` ON (`Alert`.`collection_id` = `Collection`.`id`) INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Alert`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Alert' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__body` ON (`Alert`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Alert' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'fra') WHERE 1 = 1 ORDER BY `Alert`.`position` ASC LIMIT 1	0	0	0

Query Explain:

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

====

Timer

Mémoire

Utilisation de la Mémoire au niveau maximum 19,93 MB

Message	Memory use
Component initialization	11,15 MB
Controller action start	12,62 MB
Controller render start	13,67 MB
View render complete	17,90 MB

Timers

Total du Temps de Requête 263 (ms)

Message	Temps en ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	86,46
Event: Controller.initialize	2,40
Event: Controller.startup	3,05
Controller action	49,82
Event: Controller.beforeRender	30,16
» Processing toolbar data	10,31
Rendering View	9,59
» Event: View.beforeRender	0,09
» Rendering APP/View/Events/display.ctp	1,03
» » Rendering APP/View/Elements/event-date.ctp	0,40
» Event: View.afterRender	0,07
» Event: View.beforeLayout	0,07
» Rendering APP/View/Layouts/default.ctp	6,21
» » Rendering APP/View/Elements/header.ctp	2,74
» » » Rendering APP/View/Elements/lang-switcher.ctp	0,29
» » Rendering APP/View/Elements/footer.ctp	1,98
» » Rendering APP/View/Elements/js-app.ctp	0,22
Event: View.afterLayout	0,00

====

Log
+

Logs

Il n'y avait pas d'entrées de log faîtes pour cette requête

====
Variables
+
Variables du View
- title_for_layoutSo So Summer
- event(array)
 Event(array)
 id3
 date_start2016-08-04
 date_end2016-08-25
 start_time(null)
 published(true)
 featured(false)
 place_id2
 event_category_id4
 created2016-07-13 18:26:01
 updated2016-07-18 14:27:38
 position2
 localefra
 titleSo So Summer
 subtitlesoirées d'août au Pomhouse
 bodyComme chaque année plongez dans le passé à travers nos archives et savourez l’été sur la terrasse du Pomhouse. Profitez-en pour découvrir le nouveau volet de la collection The Bitter Years. Tous les jeudis en août de 18h à 23h Entrée gratuite, fresh food and dirty drinks par Vagabond Barrr 04/08/2016 – DJ Blondies 11/08/2016 – DJ Young D 18/08/16 – DJ Ralitt & Isaac 25/08/16 à 19h Conférence et signature de livre de la photographe américaine Darcy Padilla. Soirée de clôture à 20h avec DJ Citade de Deus
 excerpt
 legend
 url(array)
 controllerevents
 actiondisplay
 id3
 slugso-so-summer
 EventCategory(array)
 id4
 created2016-07-13 18:21:00
 updated2016-07-18 14:17:11
 Place(array)
 id2
 published(true)
 featured(false)
 created2016-06-21 09:54:58
 updated2016-07-20 15:53:39
 colordark
 position1
 mon_opening(null)
 mon_closing(null)
 tue_opening(null)
 tue_closing(null)
 wed_opening12:00:00
 wed_closing18:00:00
 thu_opening18:00:00
 thu_closing22:00:00
 fri_opening12:00:00
 fri_closing18:00:00
 sat_opening12:00:00
 sat_closing18:00:00
 sun_opening12:00:00
 sun_closing18:00:00
 lat49.4740781003514
 long6.08174800872803
 Thumbnail(array)
 id44
 filenameevent/3/BunkerThumb.jpg
 filesize2725347
 filetypeimage/jpeg
 typethumb
 anchor_x50
 anchor_y50
 foreign_modelevent
 foreign_id3
 thumbnail(true)
 created2016-07-13 18:26:33
 updated2016-07-13 18:26:33
 position9
 extras
 localefra
 titleBunkerThumb.jpg
 descriptionBunkerThumb.jpg
- events(empty)
- categories(array)
 1Conférence
 2Visite guidée
 3Réouverture
 4Projection
- places(array)
 1The Family of Man
 2The Bitter Years
- $request->data(empty)
- $this->validationErrors(array)
 Translation(empty)
 Log(empty)
 User(empty)
 Aro(empty)
 Aco(empty)
 Post(empty)
 I18nModel(empty)
 Permission(empty)
 Setting(empty)
 Attempt(empty)
 Event(empty)
 EventCategory(empty)
 Place(empty)
 Thumbnail(empty)
 Asset(empty)
 Schedule(empty)
 Collection(empty)
 History(empty)
 Alert(empty)
 log(empty)
- Loaded Helpers(array)
 0Html
 1Form
 2Js
 3Text
 4Number
 5Time
 6Session
 7Paginator
 8BunkerData
 9Cache
 10SimpleGraph
 11DebugTimer
 12Toolbar
 13HtmlToolbar
====

Environment

App Constants

Constant	Value
WEBSITE_ENV	staging
BD_SITE_NAME	Steichen Collections CNA
ELFINDER_DIR	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/files
ELFINDER_URL	http://staging.steichencollections-cna.bunkerpalace.com/files
ASSETS_URL	http://staging.steichencollections-cna.bunkerpalace.com/assets
ASSETS_DIR	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/assets
ASSETS_CACHE_DIR	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/cache
FILES_DIR	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/files
SETTINGS_FILES_DIR	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/files/settings
BD_GOOGLE_EMAIL	800741430328-qmqpv9bi0gpfk03m1shkvign7ie6m3hn@developer.gserviceaccount.com
BD_INLINE_EDITING
ALLOWED_ASSETS_DISPLAY	/.*/i
DEFAULT_LANGUAGE	fra

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/
APP_DIR	20160930083047
APPLIBS	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/Lib/
CACHE	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/tmp/cache/
CAKE	/var/lib/bunkerdata3/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/lib/bunkerdata3/lib
CORE_PATH	/var/lib/bunkerdata3/lib/
CAKE_VERSION	2.6.4
CSS	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://staging.steichencollections-cna.bunkerpalace.com
IMAGES	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/tmp/logs/
ROOT	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases
TESTS	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/Test/
TMP	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/tmp/
VENDORS	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/releases/20160930083047/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.3.3
Redirect Redirect Status	200
Redirect Status	200
Http Host	staging.steichencollections-cna.bunkerpalace.com
Http X Real Ip	18.116.13.113
Http X Forwarded For	18.116.13.113
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http Accept	/
Http User Agent	claudebot
Path	/sbin:/usr/sbin:/bin:/usr/bin
Server Signature	<address>Apache Server at staging.steichencollections-cna.bunkerpalace.com Port 80</address>
Server Software	Apache
Server Name	staging.steichencollections-cna.bunkerpalace.com
Server Addr	37.187.28.164
Server Port	80
Remote Addr	18.116.13.113
Document Root	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/current
Server Admin	root@localhost
Script Filename	/var/www/vhosts/steichencollections-cna.lu/staging.steichencollections-cna.lu/current/webroot/index.php
Remote Port	44347
Redirect Url	/webroot/fra/evenements/3_so-so-summer
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/fra/evenements/3_so-so-summer
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time	1713471899

====

Include
+
Included Files

Include Paths
- 2-> /var/lib/bunkerdata3/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/AclBehavior.php
  2CORE/Model/Behavior/TreeBehavior.php
  3CORE/Model/Behavior/TranslateBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/SecurityComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/PaginatorComponent.php
  5CORE/Controller/Component/AclComponent.php
  6CORE/Controller/Component/Acl/DbAcl.php
  7CORE/Controller/Component/Acl/AclInterface.php
  Config(array)
  0CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Component.php
  1CORE/Controller/Controller.php
  2CORE/Controller/ComponentCollection.php
  Datasource(array)
  0CORE/Model/Datasource/Database/Mysql.php
  1CORE/Model/Datasource/DboSource.php
  2CORE/Model/Datasource/DataSource.php
  3CORE/Model/Datasource/CakeSession.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  4CORE/Model/Aro.php
  5CORE/Model/AclNode.php
  6CORE/Model/Aco.php
  7CORE/Model/I18nModel.php
  8CORE/Model/Permission.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Core/Object.php
  6CORE/Event/CakeEventListener.php
  7CORE/Event/CakeEvent.php
  8CORE/Event/CakeEventManager.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/ClassRegistry.php
  4CORE/Utility/Debugger.php
  5CORE/Utility/String.php
  6CORE/Utility/Set.php
  7CORE/Utility/Security.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/database.php
  3APP/Config/routes.php
  Controller(array)
  0APP/Controller/EventsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Translation.php
  1APP/Model/AppModel.php
  2APP/Model/Post.php
  3APP/Model/Event.php
  4APP/Model/EventCategory.php
  5APP/Model/Place.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  Acl(array)
  Config(array)
  0Acl/Config/bootstrap.php
  Attempt(array)
  Component(array)
  0Attempt/Controller/Component/AttemptComponent.php
  Model(array)
  0Attempt/Model/Attempt.php
  BunkerData(array)
  Config(array)
  0BunkerData/Config/bootstrap.php
  1BunkerData/Config/routes.php
  Model(array)
  0BunkerData/Model/BunkerDataAppModel.php
  1BunkerData/Model/User.php
  2BunkerData/Model/Setting.php
  3BunkerData/Model/Asset.php
  Behavior(array)
  0BunkerData/Model/Behavior/LogableBehavior.php
  1BunkerData/Model/Behavior/ThumbnailBehavior.php
  2BunkerData/Model/Behavior/AttachmentBehavior.php
  3BunkerData/Plugin/Searchable/Model/Behavior/SearchableBehavior.php
  4BunkerData/Model/Behavior/SortableBehavior.php
  Controller(array)
  0BunkerData/Controller/BunkerDataAppController.php
  Component(array)
  0BunkerData/Plugin/DebugKit/Controller/Component/ToolbarComponent.php
  1BunkerData/Plugin/Elasticsearch/Controller/Component/SearcherComponent.php
  Plugin(array)
  0BunkerData/Plugin/DebugKit/Lib/DebugMemory.php
  1BunkerData/Plugin/DebugKit/Lib/Panel/HistoryPanel.php
  2BunkerData/Plugin/DebugKit/Lib/DebugPanel.php
  3BunkerData/Plugin/DebugKit/Lib/Panel/SessionPanel.php
  4BunkerData/Plugin/DebugKit/Lib/Panel/RequestPanel.php
  5BunkerData/Plugin/DebugKit/Lib/Panel/SqlLogPanel.php
  6BunkerData/Plugin/DebugKit/Lib/Panel/TimerPanel.php
  7BunkerData/Plugin/DebugKit/Lib/Panel/LogPanel.php
  8BunkerData/Plugin/DebugKit/Lib/Log/Engine/DebugKitLog.php
  9BunkerData/Plugin/DebugKit/Lib/Panel/VariablesPanel.php
  10BunkerData/Plugin/DebugKit/Lib/Panel/EnvironmentPanel.php
  11BunkerData/Plugin/DebugKit/Lib/Panel/IncludePanel.php
  12BunkerData/Plugin/DebugKit/Lib/DebugTimer.php
  I18n(array)
  Plugin(array)
  0I18n/Lib/Routing/Route/I18nRoute.php
  Config(array)
  0I18n/Config/routes.php
====

Historique des Requêtes

Session

Requête

Cake Params

Post data

Query string

Cookie

Route actuelle

Logs Sql

default

Total Time: 7 ms Total Queries: 20 queries

Query Explain:

Mémoire

Timers

Logs

Variables du View

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 7 ms
Total Queries: 20 queries