Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`favicon_id`, `AppPreference`.`animated_favicon_id`, `AppPreference`.`apple_touch_icon_id`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `fourcornersarchive_live`.`app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `fourcornersarchive_live`.`app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1) | 4 | 4 | 0 | |
SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`favicon_id`, `AppPreference`.`animated_favicon_id`, `AppPreference`.`apple_touch_icon_id`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `fourcornersarchive_live`.`app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `fourcornersarchive_live`.`app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1) | 4 | 4 | 0 | |
SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`new`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status` FROM `fourcornersarchive_live`.`frontpage_rewrites` AS `FrontpageRewrite` WHERE `FrontpageRewrite`.`old` = '/' AND `FrontpageRewrite`.`status` = 1 LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`new`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status` FROM `fourcornersarchive_live`.`frontpage_rewrites` AS `FrontpageRewrite` WHERE `FrontpageRewrite`.`old` LIKE '%*' AND `FrontpageRewrite`.`status` = 1 | 0 | 0 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`layout`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`frontpage_user_landing_page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `fourcornersarchive_live`.`frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`slug` = 'home' AND `FrontpagePage`.`status` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`layout`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`frontpage_user_landing_page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `fourcornersarchive_live`.`frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`id`, `FrontpageContainer`.`frontpage_page_id`, `FrontpageContainer`.`sorting`, `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents`, `FrontpageContainer`.`created`, `FrontpageContainer`.`modified` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`frontpage_page_id` = (1) ORDER BY `FrontpageContainer`.`sorting` asc | 4 | 4 | 0 | |
SELECT `FrontpageRow`.`id`, `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`sorting`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents`, `FrontpageRow`.`created`, `FrontpageRow`.`modified` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`frontpage_container_id` IN (1, 2, 6, 16) ORDER BY `FrontpageRow`.`sorting` asc | 6 | 6 | 0 | |
SELECT `FrontpageCol`.`id`, `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`sorting`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents`, `FrontpageCol`.`created`, `FrontpageCol`.`modified` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`frontpage_row_id` IN (1, 3, 11, 43, 58, 61) ORDER BY `FrontpageCol`.`sorting` asc | 10 | 10 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 43 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 16 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 16 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 58 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 61 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_col_id`, `FrontpageContent`.`title`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_wrap`, `FrontpageContent`.`image_responsive`, `FrontpageContent`.`image_alt`, `FrontpageContent`.`image_link`, `FrontpageContent`.`document_id`, `FrontpageContent`.`document_title`, `FrontpageContent`.`embed`, `FrontpageContent`.`related_page_id`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`frontpage_element_id`, `FrontpageContent`.`form_id`, `FrontpageContent`.`options`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`layout`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`frontpage_user_landing_page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `FrontpageCol`.`id`, `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`sorting`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents`, `FrontpageCol`.`created`, `FrontpageCol`.`modified`, `RelatedPage`.`id`, `RelatedPage`.`level`, `RelatedPage`.`sorting`, `RelatedPage`.`name`, `RelatedPage`.`title`, `RelatedPage`.`slug`, `RelatedPage`.`meta_title`, `RelatedPage`.`meta_keywords`, `RelatedPage`.`meta_description`, `RelatedPage`.`in_sitemap`, `RelatedPage`.`sitemap_modified`, `RelatedPage`.`sitemap_changes`, `RelatedPage`.`sitemap_priority`, `RelatedPage`.`in_routes`, `RelatedPage`.`layout`, `RelatedPage`.`logged_in_only`, `RelatedPage`.`logged_out_only`, `RelatedPage`.`frontpage_user_landing_page`, `RelatedPage`.`layout_file`, `RelatedPage`.`layout_file_recursive`, `RelatedPage`.`view_file`, `RelatedPage`.`view_file_recursive`, `RelatedPage`.`use_url_as_view`, `RelatedPage`.`meta_title_template`, `RelatedPage`.`options`, `RelatedPage`.`options_local`, `RelatedPage`.`tags`, `RelatedPage`.`notes`, `RelatedPage`.`created`, `RelatedPage`.`created_by`, `RelatedPage`.`modified`, `RelatedPage`.`modified_by`, `RelatedPage`.`status`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`filter_params`, `Image`.`mp4_video_ready`, `Image`.`webm_video_ready`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`mp3_audio_ready`, `Image`.`ogg_audio_ready`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Image`.`google_drive_file_id`, `Document`.`id`, `Document`.`parent_id`, `Document`.`uid`, `Document`.`name`, `Document`.`caption`, `Document`.`ext`, `Document`.`size`, `Document`.`width`, `Document`.`height`, `Document`.`created`, `Document`.`created_by`, `Document`.`modified`, `Document`.`modified_by`, `Document`.`sorting`, `Document`.`status`, `Document`.`path`, `Document`.`tags`, `Document`.`crop_params`, `Document`.`filter_params`, `Document`.`mp4_video_ready`, `Document`.`webm_video_ready`, `Document`.`flash_video_ready`, `Document`.`video_thumbnail_ready`, `Document`.`mp3_audio_ready`, `Document`.`ogg_audio_ready`, `Document`.`object`, `Document`.`object_id`, `Document`.`object_alias`, `Document`.`google_drive_file_id`, `FrontpageElement`.`id`, `FrontpageElement`.`name`, `FrontpageElement`.`path`, `FrontpageElement`.`html`, `FrontpageElement`.`locked`, `FrontpageElement`.`created`, `FrontpageElement`.`modified`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`frontpage_contents` AS `FrontpageContent` LEFT JOIN `fourcornersarchive_live`.`frontpage_pages` AS `FrontpagePage` ON (`FrontpageContent`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` ON (`FrontpageContent`.`frontpage_col_id` = `FrontpageCol`.`id`) LEFT JOIN `fourcornersarchive_live`.`frontpage_pages` AS `RelatedPage` ON (`FrontpageContent`.`related_page_id` = `RelatedPage`.`id`) LEFT JOIN `fourcornersarchive_live`.`assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `fourcornersarchive_live`.`assets` AS `Document` ON (`FrontpageContent`.`document_id` = `Document`.`id`) LEFT JOIN `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` ON (`FrontpageContent`.`frontpage_element_id` = `FrontpageElement`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`FrontpageContent`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`FrontpageContent`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageContent`.`frontpage_page_id` = 1 AND `FrontpageContent`.`status` = 1 ORDER BY `FrontpageContent`.`sorting` ASC | 13 | 13 | 1 | maybe slow |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 100 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 58 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 73 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 61 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContainer`.`options`, `FrontpageContainer`.`options_rows`, `FrontpageContainer`.`options_cols`, `FrontpageContainer`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_containers` AS `FrontpageContainer` WHERE `FrontpageContainer`.`id` = 16 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 103 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageRow`.`frontpage_container_id`, `FrontpageRow`.`options`, `FrontpageRow`.`options_cols`, `FrontpageRow`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_rows` AS `FrontpageRow` WHERE `FrontpageRow`.`id` = 43 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 101 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageCol`.`frontpage_row_id`, `FrontpageCol`.`options`, `FrontpageCol`.`options_contents` FROM `fourcornersarchive_live`.`frontpage_cols` AS `FrontpageCol` WHERE `FrontpageCol`.`id` = 102 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`filter_params`, `Asset`.`mp4_video_ready`, `Asset`.`webm_video_ready`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`mp3_audio_ready`, `Asset`.`ogg_audio_ready`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`size`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`assets` AS `Asset` LEFT JOIN `fourcornersarchive_live`.`asset_folders` AS `AssetFolder` ON (`Asset`.`parent_id` = `AssetFolder`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 6982 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `fourcornersarchive_live`.`asset_categories` AS `AssetCategory` JOIN `fourcornersarchive_live`.`asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 6982 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`filter_params`, `Asset`.`mp4_video_ready`, `Asset`.`webm_video_ready`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`mp3_audio_ready`, `Asset`.`ogg_audio_ready`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`size`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`assets` AS `Asset` LEFT JOIN `fourcornersarchive_live`.`asset_folders` AS `AssetFolder` ON (`Asset`.`parent_id` = `AssetFolder`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 6983 LIMIT 1 | 1 | 1 | 1 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `fourcornersarchive_live`.`asset_categories` AS `AssetCategory` JOIN `fourcornersarchive_live`.`asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 6983 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`filter_params`, `Asset`.`mp4_video_ready`, `Asset`.`webm_video_ready`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`mp3_audio_ready`, `Asset`.`ogg_audio_ready`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`size`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`assets` AS `Asset` LEFT JOIN `fourcornersarchive_live`.`asset_folders` AS `AssetFolder` ON (`Asset`.`parent_id` = `AssetFolder`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 6984 LIMIT 1 | 1 | 1 | 1 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `fourcornersarchive_live`.`asset_categories` AS `AssetCategory` JOIN `fourcornersarchive_live`.`asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 6984 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Project.archive/search' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Medium`.`id`, `Medium`.`icon`, `Medium`.`name` FROM `fourcornersarchive_live`.`medium` AS `Medium` WHERE `Medium`.`status` = '1' AND `Medium`.`archive_item_count` > 0 ORDER BY `Medium`.`name` asc | 8 | 8 | 0 | |
SELECT `Theme`.`id`, `Theme`.`name` FROM `fourcornersarchive_live`.`themes` AS `Theme` WHERE `Theme`.`status` = '1' AND `Theme`.`archive_item_count` > 0 ORDER BY `Theme`.`name` asc | 10 | 10 | 0 | |
SELECT `Collection`.`id`, `Collection`.`name` FROM `fourcornersarchive_live`.`collections` AS `Collection` WHERE `Collection`.`status` = '1' AND `Collection`.`archive_item_count` > 0 ORDER BY `Collection`.`name` asc | 8 | 8 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`filter_params`, `Asset`.`mp4_video_ready`, `Asset`.`webm_video_ready`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`mp3_audio_ready`, `Asset`.`ogg_audio_ready`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`size`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`assets` AS `Asset` LEFT JOIN `fourcornersarchive_live`.`asset_folders` AS `AssetFolder` ON (`Asset`.`parent_id` = `AssetFolder`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 6830 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `fourcornersarchive_live`.`asset_categories` AS `AssetCategory` JOIN `fourcornersarchive_live`.`asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 6830 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`filter_params`, `Asset`.`mp4_video_ready`, `Asset`.`webm_video_ready`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`mp3_audio_ready`, `Asset`.`ogg_audio_ready`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`size`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`assets` AS `Asset` LEFT JOIN `fourcornersarchive_live`.`asset_folders` AS `AssetFolder` ON (`Asset`.`parent_id` = `AssetFolder`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 6820 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `fourcornersarchive_live`.`asset_categories` AS `AssetCategory` JOIN `fourcornersarchive_live`.`asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 6820 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`filter_params`, `Asset`.`mp4_video_ready`, `Asset`.`webm_video_ready`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`mp3_audio_ready`, `Asset`.`ogg_audio_ready`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`size`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`assets` AS `Asset` LEFT JOIN `fourcornersarchive_live`.`asset_folders` AS `AssetFolder` ON (`Asset`.`parent_id` = `AssetFolder`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 6821 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `fourcornersarchive_live`.`asset_categories` AS `AssetCategory` JOIN `fourcornersarchive_live`.`asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 6821 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/image' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`filter_params`, `Asset`.`mp4_video_ready`, `Asset`.`webm_video_ready`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`mp3_audio_ready`, `Asset`.`ogg_audio_ready`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`size`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`role_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`notify_me`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`role_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`notify_me`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `fourcornersarchive_live`.`assets` AS `Asset` LEFT JOIN `fourcornersarchive_live`.`asset_folders` AS `AssetFolder` ON (`Asset`.`parent_id` = `AssetFolder`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 6818 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `fourcornersarchive_live`.`asset_categories` AS `AssetCategory` JOIN `fourcornersarchive_live`.`asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 6818 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/content' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/document' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/embed' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.content/item/element' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`favicon_id`, `AppPreference`.`animated_favicon_id`, `AppPreference`.`apple_touch_icon_id`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `fourcornersarchive_live`.`app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `fourcornersarchive_live`.`app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1) | 4 | 4 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.document/header' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'App.icons' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.og' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Project.design-styles' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Collection`.`id`, `Collection`.`color` FROM `fourcornersarchive_live`.`collections` AS `Collection` WHERE 1 = 1 | 9 | 9 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.admin_preview' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.cookie_compliance' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.page/header' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.menu' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Menu`.`id` FROM `fourcornersarchive_live`.`menus` AS `Menu` WHERE `Menu`.`name` = 'Main menu' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`parent_id`, `MenuItem`.`nleft`, `MenuItem`.`nright`, `MenuItem`.`level`, `MenuItem`.`object`, `MenuItem`.`object_id`, `MenuItem`.`name`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`class`, `MenuItem`.`created`, `MenuItem`.`created_by`, `MenuItem`.`modified`, `MenuItem`.`modified_by`, `MenuItem`.`status`, `MenuItem`.`target` FROM `fourcornersarchive_live`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 1 AND `level` IN (0, 1, 2) ORDER BY `nleft` ASC | 9 | 9 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`layout`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`frontpage_user_landing_page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `fourcornersarchive_live`.`frontpage_pages` AS `FrontpagePage` WHERE 1 = 1 | 13 | 13 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.menu' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`layout`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`frontpage_user_landing_page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `fourcornersarchive_live`.`frontpage_pages` AS `FrontpagePage` WHERE 1 = 1 | 13 | 13 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Project.filter' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.page/footer' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.social_icons' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageSocialMedia`.`url`, `FrontpageSocialMedia`.`slug` FROM `fourcornersarchive_live`.`frontpage_social_media` AS `FrontpageSocialMedia` WHERE `FrontpageSocialMedia`.`status` = 1 ORDER BY `FrontpageSocialMedia`.`sorting` asc | 3 | 3 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.social_icons' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageSocialMedia`.`url`, `FrontpageSocialMedia`.`slug` FROM `fourcornersarchive_live`.`frontpage_social_media` AS `FrontpageSocialMedia` WHERE `FrontpageSocialMedia`.`status` = 1 ORDER BY `FrontpageSocialMedia`.`sorting` asc | 3 | 3 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Frontpage.menu' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Menu`.`id` FROM `fourcornersarchive_live`.`menus` AS `Menu` WHERE `Menu`.`name` = 'Footer menu' LIMIT 1 | 0 | 0 | 0 | |
SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`parent_id`, `MenuItem`.`nleft`, `MenuItem`.`nright`, `MenuItem`.`level`, `MenuItem`.`object`, `MenuItem`.`object_id`, `MenuItem`.`name`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`class`, `MenuItem`.`created`, `MenuItem`.`created_by`, `MenuItem`.`modified`, `MenuItem`.`modified_by`, `MenuItem`.`status`, `MenuItem`.`target` FROM `fourcornersarchive_live`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = '' ORDER BY `nleft` ASC | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'debug_toolbar' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'history_panel' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'session_panel' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'request_panel' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'sql_log_panel' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
90 duplicate queries run.