Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`status`, `Event`.`publish_at`, `Event`.`unpublish_at`, `Event`.`title`, `Event`.`venue`, `Event`.`event_date`, `Event`.`description`, `Event`.`tags`, `Event`.`author`, `Event`.`stick_to_top_panel`, `Event`.`stick_to_top_panel_until`, `Event`.`stick_to_landing_top`, `Event`.`stick_to_landing_top_until`, `Event`.`seo_meta_keywords`, `Event`.`seo_meta_description`, `Event`.`slug`, `Event`.`nid`, `Event`.`display_type`, `Event`.`tatlerball2015`, `Event`.`tatlerball2016`, `Event`.`author_id`, `Event`.`copyright`, `Event`.`source`, `Author`.`id`, `Author`.`created`, `Author`.`modified`, `Author`.`type`, `Author`.`category`, `Author`.`status`, `Author`.`publish_at`, `Author`.`unpublish_at`, `Author`.`name`, `Author`.`bio`, `Author`.`seo_meta_keywords`, `Author`.`seo_meta_description`, `Author`.`slug` FROM `at_cn`.`events` AS `Event` LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Event`.`author_id` = `Author`.`id`) WHERE `Event`.`status` = '1' AND `Event`.`publish_at` <= NOW() AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) AND NOT (`Event`.`id` = 'landing') AND `Event`.`stick_to_top_panel` = '1' AND (`Event`.`stick_to_top_panel_until` IS NOT NULL AND `Event`.`stick_to_top_panel_until` > NOW()) ORDER BY `Event`.`publish_at` DESC LIMIT 3 | 0 | 0 | 4 | maybe slow |
SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`status`, `Event`.`publish_at`, `Event`.`unpublish_at`, `Event`.`title`, `Event`.`venue`, `Event`.`event_date`, `Event`.`description`, `Event`.`tags`, `Event`.`author`, `Event`.`stick_to_top_panel`, `Event`.`stick_to_top_panel_until`, `Event`.`stick_to_landing_top`, `Event`.`stick_to_landing_top_until`, `Event`.`seo_meta_keywords`, `Event`.`seo_meta_description`, `Event`.`slug`, `Event`.`nid`, `Event`.`display_type`, `Event`.`tatlerball2015`, `Event`.`tatlerball2016`, `Event`.`author_id`, `Event`.`copyright`, `Event`.`source`, `Author`.`id`, `Author`.`created`, `Author`.`modified`, `Author`.`type`, `Author`.`category`, `Author`.`status`, `Author`.`publish_at`, `Author`.`unpublish_at`, `Author`.`name`, `Author`.`bio`, `Author`.`seo_meta_keywords`, `Author`.`seo_meta_description`, `Author`.`slug` FROM `at_cn`.`events` AS `Event` LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Event`.`author_id` = `Author`.`id`) WHERE `Event`.`status` = '1' AND `Event`.`publish_at` <= NOW() AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) ORDER BY `Event`.`publish_at` DESC LIMIT 3 | 3 | 3 | 6 | maybe slow |
SELECT `Image`.`id`, `Image`.`name`, `Image`.`filesize`, `Image`.`type`, `Image`.`caption`, `Image`.`object_type`, `Image`.`object_id`, `Image`.`source`, `Image`.`square_url`, `Image`.`square300_url`, `Image`.`square120_url`, `Image`.`thumb_url`, `Image`.`banner_url`, `Image`.`large_url`, `Image`.`popup_url`, `Image`.`h195_url`, `Image`.`carousel_large_url`, `Image`.`created`, `Image`.`alt`, `Image`.`people`, `Image`.`tags`, `Image`.`sort`, `Image`.`status`, `Image`.`publish_at`, `Image`.`unpublish_at`, `Image`.`carousel_fw_url`, `Image`.`mobile_cover` FROM `at_cn`.`images` AS `Image` WHERE `Image`.`object_type` = 'event' AND `Image`.`object_id` IN (1045, 1044, 1042) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 20 | 20 | 3 | maybe slow |
SELECT `Video`.`id`, `Video`.`title`, `Video`.`description`, `Video`.`source`, `Video`.`object_type`, `Video`.`object_id`, `Video`.`ext`, `Video`.`type`, `Video`.`size`, `Video`.`group`, `Video`.`width`, `Video`.`height`, `Video`.`filesize`, `Video`.`created`, `Video`.`status`, `Video`.`publish_at`, `Video`.`unpublish_at`, `Video`.`tags`, `Video`.`slug`, `Video`.`event`, `Video`.`behindscene`, `Video`.`old_source`, `Video`.`youtube` FROM `at_cn`.`videos` AS `Video` WHERE `Video`.`object_type` = 'event' AND `Video`.`object_id` IN (1045, 1044, 1042) ORDER BY `Video`.`created` DESC | 0 | 0 | 3 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `at_cn`.`tags` AS `Tag` JOIN `at_cn`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (1045, 1044, 1042) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Event' | 15 | 15 | 7 | maybe slow |
SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`status`, `Event`.`publish_at`, `Event`.`unpublish_at`, `Event`.`title`, `Event`.`venue`, `Event`.`event_date`, `Event`.`description`, `Event`.`tags`, `Event`.`author`, `Event`.`stick_to_top_panel`, `Event`.`stick_to_top_panel_until`, `Event`.`stick_to_landing_top`, `Event`.`stick_to_landing_top_until`, `Event`.`seo_meta_keywords`, `Event`.`seo_meta_description`, `Event`.`slug`, `Event`.`nid`, `Event`.`display_type`, `Event`.`tatlerball2015`, `Event`.`tatlerball2016`, `Event`.`author_id`, `Event`.`copyright`, `Event`.`source`, `Author`.`id`, `Author`.`created`, `Author`.`modified`, `Author`.`type`, `Author`.`category`, `Author`.`status`, `Author`.`publish_at`, `Author`.`unpublish_at`, `Author`.`name`, `Author`.`bio`, `Author`.`seo_meta_keywords`, `Author`.`seo_meta_description`, `Author`.`slug` FROM `at_cn`.`events` AS `Event` LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Event`.`author_id` = `Author`.`id`) WHERE `Event`.`status` = '1' AND `Event`.`publish_at` <= NOW() AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) ORDER BY `Event`.`event_date` DESC LIMIT 18 | 18 | 18 | 9 | maybe slow |
SELECT `Image`.`id`, `Image`.`name`, `Image`.`filesize`, `Image`.`type`, `Image`.`caption`, `Image`.`object_type`, `Image`.`object_id`, `Image`.`source`, `Image`.`square_url`, `Image`.`square300_url`, `Image`.`square120_url`, `Image`.`thumb_url`, `Image`.`banner_url`, `Image`.`large_url`, `Image`.`popup_url`, `Image`.`h195_url`, `Image`.`carousel_large_url`, `Image`.`created`, `Image`.`alt`, `Image`.`people`, `Image`.`tags`, `Image`.`sort`, `Image`.`status`, `Image`.`publish_at`, `Image`.`unpublish_at`, `Image`.`carousel_fw_url`, `Image`.`mobile_cover` FROM `at_cn`.`images` AS `Image` WHERE `Image`.`object_type` = 'event' AND `Image`.`object_id` IN (1044, 1043, 1042, 1045, 1041, 1040, 1038, 1039, 1036, 1037, 1034, 1033, 1035, 1031, 1032, 1029, 1027, 1028) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 277 | 277 | 42 | maybe slow |
SELECT `Video`.`id`, `Video`.`title`, `Video`.`description`, `Video`.`source`, `Video`.`object_type`, `Video`.`object_id`, `Video`.`ext`, `Video`.`type`, `Video`.`size`, `Video`.`group`, `Video`.`width`, `Video`.`height`, `Video`.`filesize`, `Video`.`created`, `Video`.`status`, `Video`.`publish_at`, `Video`.`unpublish_at`, `Video`.`tags`, `Video`.`slug`, `Video`.`event`, `Video`.`behindscene`, `Video`.`old_source`, `Video`.`youtube` FROM `at_cn`.`videos` AS `Video` WHERE `Video`.`object_type` = 'event' AND `Video`.`object_id` IN (1044, 1043, 1042, 1045, 1041, 1040, 1038, 1039, 1036, 1037, 1034, 1033, 1035, 1031, 1032, 1029, 1027, 1028) ORDER BY `Video`.`created` DESC | 0 | 0 | 3 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `at_cn`.`tags` AS `Tag` JOIN `at_cn`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (1044, 1043, 1042, 1045, 1041, 1040, 1038, 1039, 1036, 1037, 1034, 1033, 1035, 1031, 1032, 1029, 1027, 1028) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Event' | 71 | 71 | 15 | maybe slow |
SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`status`, `Event`.`publish_at`, `Event`.`unpublish_at`, `Event`.`title`, `Event`.`venue`, `Event`.`event_date`, `Event`.`description`, `Event`.`tags`, `Event`.`author`, `Event`.`stick_to_top_panel`, `Event`.`stick_to_top_panel_until`, `Event`.`stick_to_landing_top`, `Event`.`stick_to_landing_top_until`, `Event`.`seo_meta_keywords`, `Event`.`seo_meta_description`, `Event`.`slug`, `Event`.`nid`, `Event`.`display_type`, `Event`.`tatlerball2015`, `Event`.`tatlerball2016`, `Event`.`author_id`, `Event`.`copyright`, `Event`.`source`, `Author`.`id`, `Author`.`created`, `Author`.`modified`, `Author`.`type`, `Author`.`category`, `Author`.`status`, `Author`.`publish_at`, `Author`.`unpublish_at`, `Author`.`name`, `Author`.`bio`, `Author`.`seo_meta_keywords`, `Author`.`seo_meta_description`, `Author`.`slug` FROM `at_cn`.`events` AS `Event` LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Event`.`author_id` = `Author`.`id`) WHERE `Event`.`status` = '1' AND MONTH(`Event`.`event_date`) = 11 AND YEAR(`Event`.`event_date`) = 2024 AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) ORDER BY `Event`.`event_date` DESC | 0 | 0 | 4 | maybe slow |
SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`status`, `Event`.`publish_at`, `Event`.`unpublish_at`, `Event`.`title`, `Event`.`venue`, `Event`.`event_date`, `Event`.`description`, `Event`.`tags`, `Event`.`author`, `Event`.`stick_to_top_panel`, `Event`.`stick_to_top_panel_until`, `Event`.`stick_to_landing_top`, `Event`.`stick_to_landing_top_until`, `Event`.`seo_meta_keywords`, `Event`.`seo_meta_description`, `Event`.`slug`, `Event`.`nid`, `Event`.`display_type`, `Event`.`tatlerball2015`, `Event`.`tatlerball2016`, `Event`.`author_id`, `Event`.`copyright`, `Event`.`source`, `Author`.`id`, `Author`.`created`, `Author`.`modified`, `Author`.`type`, `Author`.`category`, `Author`.`status`, `Author`.`publish_at`, `Author`.`unpublish_at`, `Author`.`name`, `Author`.`bio`, `Author`.`seo_meta_keywords`, `Author`.`seo_meta_description`, `Author`.`slug` FROM `at_cn`.`events` AS `Event` LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Event`.`author_id` = `Author`.`id`) WHERE `Event`.`status` = '1' AND MONTH(`Event`.`event_date`) = 10 AND YEAR(`Event`.`event_date`) = 2024 AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) ORDER BY `Event`.`event_date` DESC | 0 | 0 | 4 | maybe slow |
SELECT `Calendar`.`id`, `Calendar`.`created`, `Calendar`.`modified`, `Calendar`.`category`, `Calendar`.`status`, `Calendar`.`publish_at`, `Calendar`.`unpublish_at`, `Calendar`.`from_date`, `Calendar`.`to_date`, `Calendar`.`title`, `Calendar`.`description`, `Calendar`.`seo_meta_keywords`, `Calendar`.`seo_meta_description`, `Calendar`.`slug`, `Image`.`id`, `Image`.`name`, `Image`.`filesize`, `Image`.`type`, `Image`.`caption`, `Image`.`object_type`, `Image`.`object_id`, `Image`.`source`, `Image`.`square_url`, `Image`.`square300_url`, `Image`.`square120_url`, `Image`.`thumb_url`, `Image`.`banner_url`, `Image`.`large_url`, `Image`.`popup_url`, `Image`.`h195_url`, `Image`.`carousel_large_url`, `Image`.`created`, `Image`.`alt`, `Image`.`people`, `Image`.`tags`, `Image`.`sort`, `Image`.`status`, `Image`.`publish_at`, `Image`.`unpublish_at`, `Image`.`carousel_fw_url`, `Image`.`mobile_cover` FROM `at_cn`.`calendars` AS `Calendar` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Calendar`.`id` AND `Image`.`object_type` = 'calendar') WHERE `Calendar`.`from_date` <= '2024-12-23' AND `Calendar`.`to_date` >= '2024-11-23' AND `Calendar`.`status` = '1' AND `Calendar`.`publish_at` <= NOW() AND (`Calendar`.`unpublish_at` IS NULL OR `Calendar`.`unpublish_at` > NOW()) ORDER BY `Calendar`.`from_date` DESC | 0 | 0 | 7 | maybe slow |
SELECT `Celebrity`.`id`, `Celebrity`.`created`, `Celebrity`.`modified`, `Celebrity`.`status`, `Celebrity`.`publish_at`, `Celebrity`.`unpublish_at`, `Celebrity`.`name`, `Celebrity`.`last_name`, `Celebrity`.`description`, `Celebrity`.`ref_id`, `Celebrity`.`new_entry_2013`, `Celebrity`.`seo_meta_keywords`, `Celebrity`.`seo_meta_description`, `Celebrity`.`slug`, `Celebrity`.`tags`, `Celebrity`.`region`, `Celebrity`.`category`, `Celebrity`.`type`, `Celebrity`.`related`, `Image`.`id`, `Image`.`name`, `Image`.`filesize`, `Image`.`type`, `Image`.`caption`, `Image`.`object_type`, `Image`.`object_id`, `Image`.`source`, `Image`.`square_url`, `Image`.`square300_url`, `Image`.`square120_url`, `Image`.`thumb_url`, `Image`.`banner_url`, `Image`.`large_url`, `Image`.`popup_url`, `Image`.`h195_url`, `Image`.`carousel_large_url`, `Image`.`created`, `Image`.`alt`, `Image`.`people`, `Image`.`tags`, `Image`.`sort`, `Image`.`status`, `Image`.`publish_at`, `Image`.`unpublish_at`, `Image`.`carousel_fw_url`, `Image`.`mobile_cover` FROM `at_cn`.`celebrities` AS `Celebrity` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Celebrity`.`id` AND `Image`.`object_type` = 'celebrity') WHERE `Celebrity`.`status` = '1' AND `Celebrity`.`publish_at` <= NOW() AND (`Celebrity`.`unpublish_at` IS NULL OR `Celebrity`.`unpublish_at` > NOW()) AND `Celebrity`.`type` LIKE "%300list%" ORDER BY RAND() ASC LIMIT 6 | 6 | 6 | 10 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `at_cn`.`tags` AS `Tag` JOIN `at_cn`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (766, 238, 765, 233, 825, 764) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 3 | maybe slow |