Visite guidée gratuite "The Family of Man"

History
+
Historique des Requêtes
4 Des requêtes antérieures sont disponibles
====
Session
+
Session
- Config(array)
  userAgentdbcdea7749c7019e72ab04c4ac4dfb8f
  time1713619701
  countdown10
- _Token(array)
  key3109fd3ca3f42a95f90766dc44d56c4e22d6aa52
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  3109fd3ca3f42a95f90766dc44d56c4e22d6aa521713607101
====
Request
+
Requête

Cake Params
- plugin(null)
- controllerevents
- actiondisplay
- named(empty)
- pass(array)
  01
  1gratis-fuehrung-the-family-of-man
- langfra
- id1
- sluggratis-fuehrung-the-family-of-man
- _Token(array)
  key3109fd3ca3f42a95f90766dc44d56c4e22d6aa52
  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` = 1 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` = (1) 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` = 40 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` != 1 AND ((`Event`.`date_end` >= '2024-04-20') OR (((`Event`.`date_end` IS NULL) AND (`Event`.`date_start` >= '2024-04-20')))) 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,16 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 241 (ms)

Message	Temps en ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	81,16
Event: Controller.initialize	2,41
Event: Controller.startup	3,05
Controller action	32,51
Event: Controller.beforeRender	30,03
» Processing toolbar data	10,18
Rendering View	9,65
» 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,25
» » Rendering APP/View/Elements/header.ctp	2,77
» » » 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,23
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_layoutVisite guidée gratuite "The Family of Man"
- event(array)
  Event(array)
  id1
  date_start2016-03-01
  date_end2017-01-01
  start_time(null)
  published(true)
  featured(false)
  place_id1
  event_category_id2
  created2016-07-01 12:15:58
  updated2016-07-15 09:02:31
  position1
  localefra
  titleVisite guidée gratuite "The Family of Man"
  subtitletous les dimanches à 15h!
  body<p>Visite gratuite de la collection chaque dimanche à 15 heures.<br /> La langue de visite est décidée sur place selon les participants.<br /> (Participants max. 20 personnes)</p>
  excerpt
  legend
  url(array)
  controllerevents
  actiondisplay
  id1
  slugvisite-guidee-gratuite-the-family-of-man
  EventCategory(array)
  id2
  created2016-07-12 14:24:33
  updated2016-07-18 14:16:52
  Place(array)
  id1
  published(true)
  featured(false)
  created2016-06-21 09:53:00
  updated2016-07-20 15:54:15
  colorlight
  position0
  mon_opening(null)
  mon_closing(null)
  tue_opening(null)
  tue_closing(null)
  wed_opening12:00:00
  wed_closing18:00:00
  thu_opening12:00:00
  thu_closing18: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
  lat50.0543696544699
  long6.03005647659302
  Thumbnail(array)
  id40
  filenameevent/1/BunkerThumb.jpg
  filesize4526224
  filetypeimage/jpeg
  typethumb
  anchor_x50
  anchor_y50
  foreign_modelevent
  foreign_id1
  thumbnail(true)
  created2016-07-13 16:13:53
  updated2016-07-13 16:28:51
  position6
  extras
  localefra
  title
  description© CNA/Romain Girtgen
- 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	3.135.219.166
Http X Forwarded For	3.135.219.166
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
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	3.135.219.166
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	43353
Redirect Url	/webroot/fra/evenements/1_gratis-fuehrung-the-family-of-man
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/fra/evenements/1_gratis-fuehrung-the-family-of-man
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time	1713605301

====

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