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 `Document`.`id`, `Document`.`updated`, `Document`.`created`, `Document`.`published`, `Document`.`document_category_id`, (`I18n__title`.`content`) AS `Document__i18n_title`, (`I18n__subtitle`.`content`) AS `Document__i18n_subtitle`, (`I18n__tags`.`content`) AS `Document__i18n_tags`, (`I18n__body`.`content`) AS `Document__i18n_body`, (`I18n__subbody`.`content`) AS `Document__i18n_subbody`, `DocumentCategory`.`id`, `DocumentCategory`.`created`, `DocumentCategory`.`updated`, `DocumentCategory`.`position` FROM `stecna_staging`.`documents` AS `Document` LEFT JOIN `stecna_staging`.`document_categories` AS `DocumentCategory` ON (`Document`.`document_category_id` = `DocumentCategory`.`id`) INNER JOIN `stecna_staging`.`i18n` AS `I18n__title` ON (`Document`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Document' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subtitle` ON (`Document`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Document' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'eng') INNER JOIN `stecna_staging`.`i18n` AS `I18n__tags` ON (`Document`.`id` = `I18n__tags`.`foreign_key` AND `I18n__tags`.`model` = 'Document' AND `I18n__tags`.`field` = 'tags' AND `I18n__tags`.`locale` = 'eng') INNER JOIN `stecna_staging`.`i18n` AS `I18n__body` ON (`Document`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Document' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'eng') INNER JOIN `stecna_staging`.`i18n` AS `I18n__subbody` ON (`Document`.`id` = `I18n__subbody`.`foreign_key` AND `I18n__subbody`.`model` = 'Document' AND `I18n__subbody`.`field` = 'subbody' AND `I18n__subbody`.`locale` = 'eng') WHERE `Document`.`id` = 3 AND `Document`.`published` = '1' ORDER BY `Document`.`created` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
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` = (3) AND `Asset`.`foreign_model` = "Document" ORDER BY `Asset`.`position` ASC | 0 | 0 | 2 | maybe slow |
SELECT `ExternalVideo`.`id`, `ExternalVideo`.`foreign_id`, `ExternalVideo`.`foreign_model`, `ExternalVideo`.`updated`, `ExternalVideo`.`created`, `ExternalVideo`.`videoID`, `ExternalVideo`.`videoType`, `ExternalVideo`.`embed`, `ExternalVideo`.`thumbnail`, `ExternalVideo`.`position` FROM `stecna_staging`.`external_videos` AS `ExternalVideo` WHERE `ExternalVideo`.`foreign_model` = 'document' AND `ExternalVideo`.`foreign_id` = (3) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE 1 = 1 ORDER BY `Alert`.`position` ASC LIMIT 1 | 0 | 0 | 1 | maybe slow |