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 `BlogPost`.`slug` FROM `fourcornersarchive_live`.`blog_posts` AS `BlogPost` WHERE 1 = 1 | 29 | 29 | 0 | |
SELECT `BlogPost`.`slug` FROM `fourcornersarchive_live`.`blog_posts` AS `BlogPost` WHERE 1 = 1 | 29 | 29 | 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` = '/news-and-events/tag:interview' 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 `BlogPost`.`slug` FROM `fourcornersarchive_live`.`blog_posts` AS `BlogPost` WHERE 1 = 1 | 29 | 29 | 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` = 'tag:interview' AND `FrontpagePage`.`status` = 1 LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`used`, `Tag`.`tag_object_count`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`created_by`, `Tag`.`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`.`tags` AS `Tag` LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`Tag`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`Tag`.`modified_by` = `ModifiedBy`.`id`) WHERE `Tag`.`slug` = 'interview' LIMIT 1 | 1 | 1 | 1 | |
SELECT `TagObject`.`id`, `TagObject`.`tag_id`, `TagObject`.`object`, `TagObject`.`object_id`, `TagObject`.`sorting` FROM `fourcornersarchive_live`.`tags_objects` AS `TagObject` WHERE `TagObject`.`tag_id` = (7607) | 4 | 4 | 0 | |
SELECT `BlogPost`.`id`, `BlogPost`.`uid`, `BlogPost`.`date`, `BlogPost`.`time`, `BlogPost`.`tags`, `BlogPost`.`allow_comments`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`image_id`, `BlogPost`.`excerpt`, `BlogPost`.`meta_title`, `BlogPost`.`meta_keywords`, `BlogPost`.`meta_description`, `BlogPost`.`created`, `BlogPost`.`created_by`, `BlogPost`.`modified`, `BlogPost`.`modified_by`, `BlogPost`.`status`, `BlogPost`.`blog_comment_count`, (CONCAT(date, " ", time)) AS `BlogPost__date_time`, `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`.`blog_posts` AS `BlogPost` LEFT JOIN `fourcornersarchive_live`.`users` AS `CreatedBy` ON (`BlogPost`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `fourcornersarchive_live`.`users` AS `ModifiedBy` ON (`BlogPost`.`modified_by` = `ModifiedBy`.`id`) inner JOIN `fourcornersarchive_live`.`tags_objects` AS `TagsObject` ON (`TagsObject`.`object_id` = `BlogPost`.`id`) inner JOIN `fourcornersarchive_live`.`tags` AS `Tag` ON (`Tag`.`id` = `TagsObject`.`tag_id` AND `Tag`.`id` = '7607') WHERE `BlogPost`.`status` = 1 ORDER BY `BlogPost`.`date` desc, `BlogPost`.`time` desc LIMIT 5 | 3 | 3 | 1 | maybe slow |
SELECT `BlogContent`.`id`, `BlogContent`.`blog_post_id`, `BlogContent`.`image_id`, `BlogContent`.`image_alignment`, `BlogContent`.`image_link`, `BlogContent`.`document_id`, `BlogContent`.`uid`, `BlogContent`.`sorting`, `BlogContent`.`title`, `BlogContent`.`content`, `BlogContent`.`created`, `BlogContent`.`created_by`, `BlogContent`.`modified`, `BlogContent`.`modified_by`, `BlogContent`.`status` FROM `fourcornersarchive_live`.`blog_contents` AS `BlogContent` WHERE `BlogContent`.`status` = 1 AND `BlogContent`.`blog_post_id` IN (32, 27, 22) ORDER BY `BlogContent`.`sorting` asc | 3 | 3 | 0 | |
SELECT `BlogComment`.`id`, `BlogComment`.`blog_post_id`, `BlogComment`.`uid`, `BlogComment`.`name`, `BlogComment`.`email`, `BlogComment`.`created`, `BlogComment`.`comment`, `BlogComment`.`ip` FROM `fourcornersarchive_live`.`blog_comments` AS `BlogComment` WHERE `BlogComment`.`blog_post_id` IN (32, 27, 22) | 1 | 1 | 0 | |
SELECT `BlogRelate`.`id`, `BlogRelate`.`uid`, `BlogRelate`.`date`, `BlogRelate`.`time`, `BlogRelate`.`tags`, `BlogRelate`.`allow_comments`, `BlogRelate`.`title`, `BlogRelate`.`slug`, `BlogRelate`.`image_id`, `BlogRelate`.`excerpt`, `BlogRelate`.`meta_title`, `BlogRelate`.`meta_keywords`, `BlogRelate`.`meta_description`, `BlogRelate`.`created`, `BlogRelate`.`created_by`, `BlogRelate`.`modified`, `BlogRelate`.`modified_by`, `BlogRelate`.`status`, `BlogRelate`.`blog_comment_count`, (CONCAT(date, " ", time)) AS `BlogRelate__date_time`, `BlogPostsBlogRelate`.`id`, `BlogPostsBlogRelate`.`blog_post_id`, `BlogPostsBlogRelate`.`blog_relate_id` FROM `fourcornersarchive_live`.`blog_posts` AS `BlogRelate` JOIN `fourcornersarchive_live`.`blog_posts_blog_relates` AS `BlogPostsBlogRelate` ON (`BlogPostsBlogRelate`.`blog_post_id` IN (32, 27, 22) AND `BlogPostsBlogRelate`.`blog_relate_id` = `BlogRelate`.`id`) ORDER BY `BlogRelate`.`title` asc | 1 | 1 | 1 | |
SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`meta_title`, `BlogCategory`.`meta_keywords`, `BlogCategory`.`meta_description`, `BlogCategory`.`slug`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`created_by`, `BlogCategory`.`modified`, `BlogCategory`.`modified_by`, `BlogCategory`.`status`, `BlogCategoriesBlogPost`.`id`, `BlogCategoriesBlogPost`.`blog_category_id`, `BlogCategoriesBlogPost`.`blog_post_id` FROM `fourcornersarchive_live`.`blog_categories` AS `BlogCategory` JOIN `fourcornersarchive_live`.`blog_categories_blog_posts` AS `BlogCategoriesBlogPost` ON (`BlogCategoriesBlogPost`.`blog_post_id` IN (32, 27, 22) AND `BlogCategoriesBlogPost`.`blog_category_id` = `BlogCategory`.`id`) WHERE `BlogCategory`.`status` = 1 | 3 | 3 | 0 | |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`used`, `Tag`.`tag_object_count`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`created_by`, `Tag`.`modified_by`, `TagObject`.`id`, `TagObject`.`tag_id`, `TagObject`.`object`, `TagObject`.`object_id`, `TagObject`.`sorting` FROM `fourcornersarchive_live`.`tags` AS `Tag` JOIN `fourcornersarchive_live`.`tags_objects` AS `TagObject` ON (`TagObject`.`object_id` IN (32, 27, 22) AND `TagObject`.`tag_id` = `Tag`.`id`) WHERE `TagObject`.`object` = 'BlogPost' ORDER BY `TagObject`.`sorting` asc | 10 | 10 | 1 | maybe slow |
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` = 6650 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` = 6650 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 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` = 6623 LIMIT 1 | 1 | 1 | 3 | maybe slow |
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` = 6623 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 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` = 4201 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` = 4201 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Blog.categories' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `BlogCategory`.`slug`, `BlogCategory`.`name` FROM `fourcornersarchive_live`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`status` = 1 AND `BlogCategory`.`blog_post_count` > 0 ORDER BY `BlogCategory`.`name` asc | 2 | 2 | 0 | |
SELECT `FrontpageElement`.`html` FROM `fourcornersarchive_live`.`frontpage_elements` AS `FrontpageElement` WHERE `FrontpageElement`.`path` = 'Blog.tag_list' AND NOT (`FrontpageElement`.`html` IS NULL) LIMIT 1 | 0 | 0 | 0 | |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`used`, `Tag`.`tag_object_count`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`created_by`, `Tag`.`modified_by` FROM `fourcornersarchive_live`.`tags` AS `Tag` inner JOIN `fourcornersarchive_live`.`tags_objects` AS `TagObject` ON (`Tag`.`id` = `TagObject`.`tag_id`) inner JOIN `fourcornersarchive_live`.`blog_posts` AS `BlogPost` ON (`TagObject`.`object_id` = `BlogPost`.`id` AND `BlogPost`.`status` = 1) WHERE `TagObject`.`object` = 'BlogPost' GROUP BY `Tag`.`id` ORDER BY `Tag`.`name` asc | 73 | 73 | 2 | |
SELECT `TagObject`.`id`, `TagObject`.`tag_id`, `TagObject`.`object`, `TagObject`.`object_id`, `TagObject`.`sorting` FROM `fourcornersarchive_live`.`tags_objects` AS `TagObject` WHERE `TagObject`.`tag_id` IN (1364, 48202, 896, 7419, 36832, 8136, 49616, 50886, 6598, 1625, 8132, 1031, 7829, 49598, 50899, 50900, 49578, 955, 1289, 1653, 49882, 50903, 49262, 925, 798, 49596, 1674, 799, 7840, 49615, 7698, 49579, 47680, 49592, 50915, 773, 1514, 7428, 7607, 7192, 7625, 8124, 7550, 6934, 49875, 49752, 42920, 7627, 895, 51018, 50913, 4401, 772, 4206, 1102, 1085, 42629, 777, 771, 1224, 1504, 47798, 49597, 49590, 48689, 1598, 50904, 1535, 6662, 50888, 49768, 50887, 1639) | 2724 | 2724 | 7 | |
SELECT MAX(`Tag`.`used`) FROM `fourcornersarchive_live`.`tags` AS `Tag` WHERE 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT MIN(`Tag`.`used`) FROM `fourcornersarchive_live`.`tags` AS `Tag` WHERE 1 LIMIT 1 | 1 | 1 | 1 | |
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 | 0 | |
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 | 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` = '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 | |
11 duplicate queries run.