Wiedereröffnung "The Bitter Years"

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentdbcdea7749c7019e72ab04c4ac4dfb8f
  time1713996190
  countdown10
- _Token(array)
  keyecec3afd500e6201260980b18b2fd159e317ebee
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  ecec3afd500e6201260980b18b2fd159e317ebee1713983590
====
Request
+
Request

Cake Params
- plugin(null)
- controllerevents
- actiondisplay
- named(empty)
- pass(array)
  02
  1reouverture-the-bitter-years
- langdeu
- id2
- slugreouverture-the-bitter-years
- _Token(array)
  keyecec3afd500e6201260980b18b2fd159e317ebee
  unlockedFields(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- 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
====

Sql Logs

default

Total Time: 22 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') WHERE `Event`.`id` = 2 AND `Event`.`published` = '1' ORDER BY `Event`.`position` ASC LIMIT 1	1	1	4	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` = (2) 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` = 'deu') 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` = 'deu') WHERE `Asset`.`id` = 41 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') WHERE `Event`.`published` = '1' AND `Event`.`id` != 2 AND ((`Event`.`date_end` >= '2024-04-24') OR (((`Event`.`date_end` IS NULL) AND (`Event`.`date_start` >= '2024-04-24')))) 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') WHERE 1 = 1 ORDER BY `Place`.`created` ASC	2	2	8	maybe slow
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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') 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` = 'deu') WHERE 1 = 1 ORDER BY `Collection`.`position` ASC	2	2	4	maybe slow
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` = 'deu') 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` = 'deu') WHERE 1 = 1 ORDER BY `Alert`.`position` ASC LIMIT 1	0	0	1	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 19.92 MB

Message	Memory use
Component initialization	11.13 MB
Controller action start	12.60 MB
Controller render start	13.65 MB
View render complete	17.87 MB

Timers

Total Request Time: 259 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	84.05
Event: Controller.initialize	3.91
Event: Controller.startup	4.19
Controller action	34.40
Event: Controller.beforeRender	42.15
» Processing toolbar data	10.03
Rendering View	9.57
» Event: View.beforeRender	0.09
» Rendering APP/View/Events/display.ctp	1.07
» » Rendering APP/View/Elements/event-date.ctp	0.44
» Event: View.afterRender	0.07
» Event: View.beforeLayout	0.07
» Rendering APP/View/Layouts/default.ctp	6.17
» » Rendering APP/View/Elements/header.ctp	2.66
» » » Rendering APP/View/Elements/lang-switcher.ctp	0.29
» » Rendering APP/View/Elements/footer.ctp	2.01
» » Rendering APP/View/Elements/js-app.ctp	0.23
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- title_for_layoutWiedereröffnung "The Bitter Years"
- event(array)
 Event(array)
 id2
 date_start2016-07-21
 date_end2016-07-23
 start_time18:00:00
 published(true)
 featured(false)
 place_id2
 event_category_id3
 created2016-07-01 12:46:22
 updated2016-07-18 14:41:57
 position0
 localedeu
 titleWiedereröffnung "The Bitter Years"
 subtitleNeue Kapitel der Sammlung
 bodyTage der offenen Tür vom 21.-23. Juli gefolgt vom Open-Air Kino um 22:00 Uhr Führungen, Büchermarkt, Photomat, Musik, Foodtruck Entdecken Sie am Donnerstag, 21. Juli ab 18:00 Uhr neue Kapitel der Sammlung THE BITTER YEARS in einer gemütlichen Atmosphäre und sehen Sie anschließend den Film It Happened One Night (Frank Capra, 1934) im Open-Air Kino vor dem CNA. Freitag 22. und Samstag 23. Juli, offene Tür von 12:00 bis 22:00 Uhr, anschließend Open-Air Kino. Öffnungszeiten der Sammlung: Donnerstag 21. Juli: 18:00 – 22:00 Uhr Freitag 22. und Samstag 23. Juli: 12:00 – 22:00 Uhr <a href="http://staging.steichencollections-cna.bunkerpalace.com/files/settings/Programme%20ouverture%20et%20portes%20ouvertes.pdf">Das Programm herunterladen</a>.
 excerpt
 legend
 url(array)
 controllerevents
 actiondisplay
 id2
 slugwiedereroeffnung-the-bitter-years
 EventCategory(array)
 id3
 created2016-07-13 16:17:17
 updated2016-07-18 14:17:01
 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)
 id41
 filenameevent/2/BunkerThumb.jpg
 filesize2392571
 filetypeimage/jpeg
 typethumb
 anchor_x50
 anchor_y50
 foreign_modelevent
 foreign_id2
 thumbnail(true)
 created2016-07-13 16:22:29
 updated2016-07-13 16:26:36
 position7
 extras
 localedeu
 titleLucille Burroughs, Tochter eines Baumwollarbeiters, Hale County, Alabama. 1935
 descriptionWalker Evans © Library of Congress
- events(empty)
- categories(array)
 1Konferenz
 2Führung
 3Wiedereröffnung
 4Projektion
- 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.221.129.19
Http X Forwarded For	18.221.129.19
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	18.221.129.19
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	47066
Redirect Url	/webroot/deu/evenements/2_reouverture-the-bitter-years
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/deu/evenements/2_reouverture-the-bitter-years
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time	1713981790

====

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
====

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 22 ms Total Queries: 20 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 22 ms
Total Queries: 20 queries