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` = '/project/timeline/index' 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` = 'index' AND `FrontpagePage`.`status` = 1 LIMIT 1 | 0 | 0 | 0 | |
SELECT `TimelineItem`.`id`, `TimelineItem`.`organisation_id`, `TimelineItem`.`image_id`, `TimelineItem`.`archive_item_id`, `TimelineItem`.`title`, `TimelineItem`.`content`, `TimelineItem`.`date`, `TimelineItem`.`created`, `TimelineItem`.`created_by`, `TimelineItem`.`modified`, `TimelineItem`.`modified_by`, `TimelineItem`.`status`, `ArchiveItem`.`id`, `ArchiveItem`.`ref`, `ArchiveItem`.`title`, `ArchiveItem`.`subtitle`, `ArchiveItem`.`image_id`, `Organisation`.`id`, `Organisation`.`name`, `Organisation`.`icon`, `Organisation`.`color`, `Organisation`.`timeline` FROM `fourcornersarchive_live`.`timeline_items` AS `TimelineItem` LEFT JOIN `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` ON (`TimelineItem`.`archive_item_id` = `ArchiveItem`.`id`) LEFT JOIN `fourcornersarchive_live`.`organisations` AS `Organisation` ON (`TimelineItem`.`organisation_id` = `Organisation`.`id`) WHERE `TimelineItem`.`status` = '1' ORDER BY `TimelineItem`.`date` ASC, `TimelineItem`.`organisation_id` ASC LIMIT 100 | 81 | 81 | 1 | |
SELECT `Organisation`.`id`, `Organisation`.`name`, `Organisation`.`color` FROM `fourcornersarchive_live`.`organisations` AS `Organisation` WHERE ((`Organisation`.`timeline` = 1) OR (`Organisation`.`id` IN (4, 5, 2, 3, 1))) | 5 | 5 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 1569 LIMIT 1 | 1 | 1 | 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` = 6139 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` = 6139 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 1813 LIMIT 1 | 1 | 1 | 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` = 2988 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` = 2988 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 39 LIMIT 1 | 1 | 1 | 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` = 6152 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` = 6152 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2726 LIMIT 1 | 1 | 1 | 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` = 6158 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` = 6158 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 43 LIMIT 1 | 1 | 1 | 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` = 2990 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` = 2990 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2722 LIMIT 1 | 1 | 1 | 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` = 6115 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` = 6115 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 72 LIMIT 1 | 1 | 1 | 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` = 6159 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` = 6159 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 4 LIMIT 1 | 1 | 1 | 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` = 2984 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` = 2984 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 1914 LIMIT 1 | 1 | 1 | 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` = 2987 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` = 2987 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 12 LIMIT 1 | 1 | 1 | 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` = 2981 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` = 2981 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 46 LIMIT 1 | 1 | 1 | 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` = 2977 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` = 2977 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 91 LIMIT 1 | 1 | 1 | 1 | |
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` = 6154 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` = 6154 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2064 LIMIT 1 | 1 | 1 | 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` = 5916 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` = 5916 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2711 LIMIT 1 | 1 | 1 | 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` = 6140 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` = 6140 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 23 LIMIT 1 | 1 | 1 | 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` = 2982 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` = 2982 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2718 LIMIT 1 | 1 | 1 | 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` = 6141 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` = 6141 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2104 LIMIT 1 | 1 | 1 | 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` = 2985 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` = 2985 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 56 LIMIT 1 | 1 | 1 | 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` = 2976 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` = 2976 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2720 LIMIT 1 | 1 | 1 | 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` = 2989 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` = 2989 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2933 LIMIT 1 | 1 | 1 | 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` = 6147 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` = 6147 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2306 LIMIT 1 | 1 | 1 | 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` = 2979 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` = 2979 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 186 LIMIT 1 | 1 | 1 | 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` = 6142 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` = 6142 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2932 LIMIT 1 | 1 | 1 | 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` = 6149 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` = 6149 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 61 LIMIT 1 | 1 | 1 | 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` = 6143 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` = 6143 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 35 LIMIT 1 | 1 | 1 | 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` = 2983 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` = 2983 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 98 LIMIT 1 | 1 | 1 | 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` = 2978 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` = 2978 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2934 LIMIT 1 | 1 | 1 | 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` = 6151 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` = 6151 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 64 LIMIT 1 | 1 | 1 | 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` = 6144 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` = 6144 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `ArchiveItem`.`ref` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`id` = 2617 LIMIT 1 | 1 | 1 | 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` = 6145 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` = 6145 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 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 `Collection`.`id`, `Collection`.`color` FROM `fourcornersarchive_live`.`collections` AS `Collection` WHERE 1 = 1 | 9 | 9 | 0 | |
SELECT `Menu`.`id` FROM `fourcornersarchive_live`.`menus` AS `Menu` WHERE `Menu`.`name` = 'Main menu' LIMIT 1 | 1 | 1 | 1 | |
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 `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 `TimelineItem`.`date` FROM `fourcornersarchive_live`.`timeline_items` AS `TimelineItem` WHERE `TimelineItem`.`status` = 1 GROUP BY date | 21 | 21 | 0 | |
SELECT `Organisation`.`id`, `Organisation`.`name`, `Organisation`.`icon`, `Organisation`.`color` FROM `fourcornersarchive_live`.`organisations` AS `Organisation` WHERE `Organisation`.`timeline` = 1 AND `Organisation`.`status` = 1 | 3 | 3 | 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 `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 `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 | |
6 duplicate queries run.