No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
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 `Highlight`.`id`, `Highlight`.`updated`, `Highlight`.`created`, `Highlight`.`published`, `Highlight`.`target`, `Highlight`.`position`, (`I18n__title`.`content`) AS `Highlight__i18n_title`, (`I18n__subtitle`.`content`) AS `Highlight__i18n_subtitle`, (`I18n__excerpt`.`content`) AS `Highlight__i18n_excerpt`, (`I18n__url`.`content`) AS `Highlight__i18n_url`, (`I18n__legend`.`content`) AS `Highlight__i18n_legend` FROM `stecna_staging`.`highlights` AS `Highlight` INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Highlight`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Highlight' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subtitle` ON (`Highlight`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Highlight' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__excerpt` ON (`Highlight`.`id` = `I18n__excerpt`.`foreign_key` AND `I18n__excerpt`.`model` = 'Highlight' AND `I18n__excerpt`.`field` = 'excerpt' AND `I18n__excerpt`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__url` ON (`Highlight`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Highlight' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'fra') INNER JOIN `stecna_staging`.`i18n` AS `I18n__legend` ON (`Highlight`.`id` = `I18n__legend`.`foreign_key` AND `I18n__legend`.`model` = 'Highlight' AND `I18n__legend`.`field` = 'legend' AND `I18n__legend`.`locale` = 'fra') WHERE `Highlight`.`published` = '1' ORDER BY `Highlight`.`position` ASC | 3 | 3 | 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` = 'highlight' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` IN (1, 3, 4) ORDER BY `Thumbnail`.`position` ASC | 3 | 3 | 0 | |
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`, (`I18n__text`.`content`) AS `Schedule__i18n_text`, `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`.`schedules` AS `Schedule` LEFT JOIN `stecna_staging`.`places` AS `Place` ON (`Schedule`.`place_id` = `Place`.`id`) INNER JOIN `stecna_staging`.`i18n` AS `I18n__text` ON (`Schedule`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'Schedule' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'fra') WHERE `Schedule`.`place_id` = 1 AND CONCAT(`Schedule`.`date_start`, " ", `Schedule`.`hour_start`) <= '2023-03-30 21:58:46' AND CONCAT(`Schedule`.`date_end`, " ", `Schedule`.`hour_end`) >= '2023-03-30 21:58:46' ORDER BY `Schedule`.`date_start` ASC LIMIT 1 | 0 | 0 | 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 `Place`.`id` = 1 ORDER BY `Place`.`created` ASC LIMIT 1 | 1 | 1 | 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`, (`I18n__text`.`content`) AS `Schedule__i18n_text`, `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`.`schedules` AS `Schedule` LEFT JOIN `stecna_staging`.`places` AS `Place` ON (`Schedule`.`place_id` = `Place`.`id`) INNER JOIN `stecna_staging`.`i18n` AS `I18n__text` ON (`Schedule`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'Schedule' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'fra') WHERE `Schedule`.`place_id` = 2 AND CONCAT(`Schedule`.`date_start`, " ", `Schedule`.`hour_start`) <= '2023-03-30 21:58:46' AND CONCAT(`Schedule`.`date_end`, " ", `Schedule`.`hour_end`) >= '2023-03-30 21:58:46' ORDER BY `Schedule`.`date_start` ASC LIMIT 1 | 0 | 0 | 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 `Place`.`id` = 2 ORDER BY `Place`.`created` ASC LIMIT 1 | 1 | 1 | 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`.`published` = '1' AND ((`Event`.`date_end` >= '2023-03-30') OR (((`Event`.`date_end` IS NULL) AND (`Event`.`date_start` >= '2023-03-30')))) ORDER BY `Event`.`position` ASC LIMIT 4 | 0 | 0 | 0 | |
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 | 0 | |
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 |
1 duplicate queries run.
Utilisation de la Mémoire au niveau maximum 20,55 MB
Message | Memory use |
---|---|
Component initialization | 11,15 MB |
Controller action start | 12,61 MB |
Controller render start | 13,93 MB |
View render complete | 18,09 MB |
Total du Temps de Requête 238 (ms)
Message | Temps en ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 75,61 | |
Event: Controller.initialize | 2,37 | |
Event: Controller.startup | 2,99 | |
Controller action | 41,02 | |
Event: Controller.beforeRender | 28,02 | |
» Processing toolbar data | 10,54 | |
Rendering View | 9,17 | |
» Event: View.beforeRender | 0,07 | |
» Rendering APP/View/Pages/home.ctp | 1,80 | |
» Event: View.afterRender | 0,06 | |
» Event: View.beforeLayout | 0,06 | |
» Rendering APP/View/Layouts/default.ctp | 5,23 | |
» » Rendering APP/View/Elements/header.ctp | 2,15 | |
» » » Rendering APP/View/Elements/lang-switcher.ctp | 0,25 | |
» » Rendering APP/View/Elements/footer.ctp | 1,70 | |
» » Rendering APP/View/Elements/js-app.ctp | 0,21 | |
Event: View.afterLayout | 0,00 |
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 |
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/ |
Environment Variable | Value |
---|---|
Php Version | 5.3.3 |
Redirect Status | 200 |
Http Host | staging.steichencollections-cna.bunkerpalace.com |
Http X Real Ip | 44.200.171.156 |
Http X Forwarded For | 44.200.171.156 |
Http X Accel Internal | /internal-nginx-static-location |
Http Connection | close |
Http User Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Http Accept Language | en-US,en;q=0.5 |
Http If Modified Since | Tue, 07 Feb 2023 17:10:08 GMT |
Http Accept Encoding | br,gzip |
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 | 44.200.171.156 |
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 | 49494 |
Redirect Url | / |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.0 |
Request Method | GET |
Query String | |
Request Uri | / |
Script Name | /webroot/index.php |
Php Self | /webroot/index.php |
Request Time | 1680206325 |