Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Story`.`id`, `Story`.`created`, `Story`.`modified`, `Story`.`status`, `Story`.`publish_at`, `Story`.`unpublish_at`, `Story`.`type`, `Story`.`luxury_news`, `Story`.`advertorial`, `Story`.`people_story`, `Story`.`top_list`, `Story`.`title`, `Story`.`deck`, `Story`.`author`, `Story`.`content`, `Story`.`video_link`, `Story`.`tags`, `Story`.`stick_to_top_panel`, `Story`.`stick_to_top_panel_until`, `Story`.`stick_to_landing_top`, `Story`.`stick_to_landing_top_until`, `Story`.`seo_meta_keywords`, `Story`.`seo_meta_description`, `Story`.`slug`, `Story`.`category`, `Story`.`columnist_id`, `Story`.`nid`, `Story`.`pview`, `Story`.`display_type`, `Story`.`source`, `Story`.`region`, `Story`.`region_id`, `Story`.`user_id`, `Story`.`region_modified`, `Story`.`full_advertorial`, `Story`.`to_tatler_tv`, `Story`.`tatlerball2015`, `Story`.`tatlerball2016`, `Story`.`author_id`, `Story`.`copyright`, `Columnist`.`id`, `Columnist`.`created`, `Columnist`.`modified`, `Columnist`.`type`, `Columnist`.`category`, `Columnist`.`status`, `Columnist`.`publish_at`, `Columnist`.`unpublish_at`, `Columnist`.`name`, `Columnist`.`bio`, `Columnist`.`seo_meta_keywords`, `Columnist`.`seo_meta_description`, `Columnist`.`slug`, `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`.`stories` AS `Story` LEFT JOIN `at_cn`.`columnists` AS `Columnist` ON (`Story`.`columnist_id` = `Columnist`.`id`) LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Story`.`author_id` = `Author`.`id`) WHERE `Story`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND `Story`.`slug` = 'bvlgarihotelbeijing0527' LIMIT 1 | 1 | 1 | 3 | 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` = 'story' AND `Image`.`object_id` = (6477) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 1 | 1 | 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` = 62671 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 4 | maybe slow |
SELECT `Gallery1`.`id`, `Gallery1`.`name`, `Gallery1`.`filesize`, `Gallery1`.`type`, `Gallery1`.`caption`, `Gallery1`.`object_type`, `Gallery1`.`object_id`, `Gallery1`.`source`, `Gallery1`.`square_url`, `Gallery1`.`square300_url`, `Gallery1`.`square120_url`, `Gallery1`.`thumb_url`, `Gallery1`.`banner_url`, `Gallery1`.`large_url`, `Gallery1`.`popup_url`, `Gallery1`.`h195_url`, `Gallery1`.`carousel_large_url`, `Gallery1`.`created`, `Gallery1`.`alt`, `Gallery1`.`people`, `Gallery1`.`tags`, `Gallery1`.`sort`, `Gallery1`.`status`, `Gallery1`.`publish_at`, `Gallery1`.`unpublish_at`, `Gallery1`.`carousel_fw_url`, `Gallery1`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery1` WHERE `object_type` = 'gallery1' AND `Gallery1`.`object_id` = (6477) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 20 | 20 | 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 (62642, 62643, 62644, 62645, 62646, 62647, 62648, 62649, 62650, 62651, 62652, 62653, 62654, 62655, 62656, 62667, 62668, 62669, 62670, 62672) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 6 | maybe slow |
SELECT `Gallery2`.`id`, `Gallery2`.`name`, `Gallery2`.`filesize`, `Gallery2`.`type`, `Gallery2`.`caption`, `Gallery2`.`object_type`, `Gallery2`.`object_id`, `Gallery2`.`source`, `Gallery2`.`square_url`, `Gallery2`.`square300_url`, `Gallery2`.`square120_url`, `Gallery2`.`thumb_url`, `Gallery2`.`banner_url`, `Gallery2`.`large_url`, `Gallery2`.`popup_url`, `Gallery2`.`h195_url`, `Gallery2`.`carousel_large_url`, `Gallery2`.`created`, `Gallery2`.`alt`, `Gallery2`.`people`, `Gallery2`.`tags`, `Gallery2`.`sort`, `Gallery2`.`status`, `Gallery2`.`publish_at`, `Gallery2`.`unpublish_at`, `Gallery2`.`carousel_fw_url`, `Gallery2`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery2` WHERE `object_type` = 'gallery2' AND `Gallery2`.`object_id` = (6477) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC | 9 | 9 | 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 (62657, 62658, 62659, 62660, 62661, 62662, 62663, 62664, 62665) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 4 | maybe slow |
SELECT `Gallery3`.`id`, `Gallery3`.`name`, `Gallery3`.`filesize`, `Gallery3`.`type`, `Gallery3`.`caption`, `Gallery3`.`object_type`, `Gallery3`.`object_id`, `Gallery3`.`source`, `Gallery3`.`square_url`, `Gallery3`.`square300_url`, `Gallery3`.`square120_url`, `Gallery3`.`thumb_url`, `Gallery3`.`banner_url`, `Gallery3`.`large_url`, `Gallery3`.`popup_url`, `Gallery3`.`h195_url`, `Gallery3`.`carousel_large_url`, `Gallery3`.`created`, `Gallery3`.`alt`, `Gallery3`.`people`, `Gallery3`.`tags`, `Gallery3`.`sort`, `Gallery3`.`status`, `Gallery3`.`publish_at`, `Gallery3`.`unpublish_at`, `Gallery3`.`carousel_fw_url`, `Gallery3`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery3` WHERE `object_type` = 'gallery3' AND `Gallery3`.`object_id` = (6477) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC | 1 | 1 | 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` = 62666 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 4 | maybe slow |
SELECT `Gallery4`.`id`, `Gallery4`.`name`, `Gallery4`.`filesize`, `Gallery4`.`type`, `Gallery4`.`caption`, `Gallery4`.`object_type`, `Gallery4`.`object_id`, `Gallery4`.`source`, `Gallery4`.`square_url`, `Gallery4`.`square300_url`, `Gallery4`.`square120_url`, `Gallery4`.`thumb_url`, `Gallery4`.`banner_url`, `Gallery4`.`large_url`, `Gallery4`.`popup_url`, `Gallery4`.`h195_url`, `Gallery4`.`carousel_large_url`, `Gallery4`.`created`, `Gallery4`.`alt`, `Gallery4`.`people`, `Gallery4`.`tags`, `Gallery4`.`sort`, `Gallery4`.`status`, `Gallery4`.`publish_at`, `Gallery4`.`unpublish_at`, `Gallery4`.`carousel_fw_url`, `Gallery4`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery4` WHERE `object_type` = 'gallery4' AND `Gallery4`.`object_id` = (6477) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC | 0 | 0 | 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` = 'story' AND `Video`.`object_id` = (6477) 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` = 6477 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story' | 0 | 0 | 6 | maybe slow |
SELECT COUNT(*) AS `count` FROM `at_cn`.`stories` AS `Story` WHERE `Story`.`id` = 6477 | 1 | 1 | 3 | maybe slow |
SELECT `Story`.`id`, `Story`.`created`, `Story`.`modified`, `Story`.`status`, `Story`.`publish_at`, `Story`.`unpublish_at`, `Story`.`type`, `Story`.`luxury_news`, `Story`.`advertorial`, `Story`.`people_story`, `Story`.`top_list`, `Story`.`title`, `Story`.`deck`, `Story`.`author`, `Story`.`content`, `Story`.`video_link`, `Story`.`tags`, `Story`.`stick_to_top_panel`, `Story`.`stick_to_top_panel_until`, `Story`.`stick_to_landing_top`, `Story`.`stick_to_landing_top_until`, `Story`.`seo_meta_keywords`, `Story`.`seo_meta_description`, `Story`.`slug`, `Story`.`category`, `Story`.`columnist_id`, `Story`.`nid`, `Story`.`pview`, `Story`.`display_type`, `Story`.`source`, `Story`.`region`, `Story`.`region_id`, `Story`.`user_id`, `Story`.`region_modified`, `Story`.`full_advertorial`, `Story`.`to_tatler_tv`, `Story`.`tatlerball2015`, `Story`.`tatlerball2016`, `Story`.`author_id`, `Story`.`copyright`, `Columnist`.`id`, `Columnist`.`created`, `Columnist`.`modified`, `Columnist`.`type`, `Columnist`.`category`, `Columnist`.`status`, `Columnist`.`publish_at`, `Columnist`.`unpublish_at`, `Columnist`.`name`, `Columnist`.`bio`, `Columnist`.`seo_meta_keywords`, `Columnist`.`seo_meta_description`, `Columnist`.`slug`, `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`.`stories` AS `Story` LEFT JOIN `at_cn`.`columnists` AS `Columnist` ON (`Story`.`columnist_id` = `Columnist`.`id`) LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Story`.`author_id` = `Author`.`id`) WHERE `Story`.`columnist_id` IS NULL AND `Story`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND NOT (`Story`.`id` = 6477) ORDER BY `Story`.`publish_at` DESC LIMIT 5 | 5 | 5 | 62 | 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` = 'story' AND `Image`.`object_id` IN (6556, 6555, 6553, 6554, 6552) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 5 | 5 | 3 | maybe slow |
SELECT `Gallery1`.`id`, `Gallery1`.`name`, `Gallery1`.`filesize`, `Gallery1`.`type`, `Gallery1`.`caption`, `Gallery1`.`object_type`, `Gallery1`.`object_id`, `Gallery1`.`source`, `Gallery1`.`square_url`, `Gallery1`.`square300_url`, `Gallery1`.`square120_url`, `Gallery1`.`thumb_url`, `Gallery1`.`banner_url`, `Gallery1`.`large_url`, `Gallery1`.`popup_url`, `Gallery1`.`h195_url`, `Gallery1`.`carousel_large_url`, `Gallery1`.`created`, `Gallery1`.`alt`, `Gallery1`.`people`, `Gallery1`.`tags`, `Gallery1`.`sort`, `Gallery1`.`status`, `Gallery1`.`publish_at`, `Gallery1`.`unpublish_at`, `Gallery1`.`carousel_fw_url`, `Gallery1`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery1` WHERE `object_type` = 'gallery1' AND `Gallery1`.`object_id` IN (6556, 6555, 6553, 6554, 6552) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 17 | 17 | 3 | maybe slow |
SELECT `Gallery2`.`id`, `Gallery2`.`name`, `Gallery2`.`filesize`, `Gallery2`.`type`, `Gallery2`.`caption`, `Gallery2`.`object_type`, `Gallery2`.`object_id`, `Gallery2`.`source`, `Gallery2`.`square_url`, `Gallery2`.`square300_url`, `Gallery2`.`square120_url`, `Gallery2`.`thumb_url`, `Gallery2`.`banner_url`, `Gallery2`.`large_url`, `Gallery2`.`popup_url`, `Gallery2`.`h195_url`, `Gallery2`.`carousel_large_url`, `Gallery2`.`created`, `Gallery2`.`alt`, `Gallery2`.`people`, `Gallery2`.`tags`, `Gallery2`.`sort`, `Gallery2`.`status`, `Gallery2`.`publish_at`, `Gallery2`.`unpublish_at`, `Gallery2`.`carousel_fw_url`, `Gallery2`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery2` WHERE `object_type` = 'gallery2' AND `Gallery2`.`object_id` IN (6556, 6555, 6553, 6554, 6552) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery3`.`id`, `Gallery3`.`name`, `Gallery3`.`filesize`, `Gallery3`.`type`, `Gallery3`.`caption`, `Gallery3`.`object_type`, `Gallery3`.`object_id`, `Gallery3`.`source`, `Gallery3`.`square_url`, `Gallery3`.`square300_url`, `Gallery3`.`square120_url`, `Gallery3`.`thumb_url`, `Gallery3`.`banner_url`, `Gallery3`.`large_url`, `Gallery3`.`popup_url`, `Gallery3`.`h195_url`, `Gallery3`.`carousel_large_url`, `Gallery3`.`created`, `Gallery3`.`alt`, `Gallery3`.`people`, `Gallery3`.`tags`, `Gallery3`.`sort`, `Gallery3`.`status`, `Gallery3`.`publish_at`, `Gallery3`.`unpublish_at`, `Gallery3`.`carousel_fw_url`, `Gallery3`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery3` WHERE `object_type` = 'gallery3' AND `Gallery3`.`object_id` IN (6556, 6555, 6553, 6554, 6552) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery4`.`id`, `Gallery4`.`name`, `Gallery4`.`filesize`, `Gallery4`.`type`, `Gallery4`.`caption`, `Gallery4`.`object_type`, `Gallery4`.`object_id`, `Gallery4`.`source`, `Gallery4`.`square_url`, `Gallery4`.`square300_url`, `Gallery4`.`square120_url`, `Gallery4`.`thumb_url`, `Gallery4`.`banner_url`, `Gallery4`.`large_url`, `Gallery4`.`popup_url`, `Gallery4`.`h195_url`, `Gallery4`.`carousel_large_url`, `Gallery4`.`created`, `Gallery4`.`alt`, `Gallery4`.`people`, `Gallery4`.`tags`, `Gallery4`.`sort`, `Gallery4`.`status`, `Gallery4`.`publish_at`, `Gallery4`.`unpublish_at`, `Gallery4`.`carousel_fw_url`, `Gallery4`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery4` WHERE `object_type` = 'gallery4' AND `Gallery4`.`object_id` IN (6556, 6555, 6553, 6554, 6552) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC | 0 | 0 | 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` = 'story' AND `Video`.`object_id` IN (6556, 6555, 6553, 6554, 6552) 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 (6556, 6555, 6553, 6554, 6552) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story' | 0 | 0 | 6 | maybe slow |
SELECT `Story`.`id`, `Story`.`created`, `Story`.`modified`, `Story`.`status`, `Story`.`publish_at`, `Story`.`unpublish_at`, `Story`.`type`, `Story`.`luxury_news`, `Story`.`advertorial`, `Story`.`people_story`, `Story`.`top_list`, `Story`.`title`, `Story`.`deck`, `Story`.`author`, `Story`.`content`, `Story`.`video_link`, `Story`.`tags`, `Story`.`stick_to_top_panel`, `Story`.`stick_to_top_panel_until`, `Story`.`stick_to_landing_top`, `Story`.`stick_to_landing_top_until`, `Story`.`seo_meta_keywords`, `Story`.`seo_meta_description`, `Story`.`slug`, `Story`.`category`, `Story`.`columnist_id`, `Story`.`nid`, `Story`.`pview`, `Story`.`display_type`, `Story`.`source`, `Story`.`region`, `Story`.`region_id`, `Story`.`user_id`, `Story`.`region_modified`, `Story`.`full_advertorial`, `Story`.`to_tatler_tv`, `Story`.`tatlerball2015`, `Story`.`tatlerball2016`, `Story`.`author_id`, `Story`.`copyright`, `Columnist`.`id`, `Columnist`.`created`, `Columnist`.`modified`, `Columnist`.`type`, `Columnist`.`category`, `Columnist`.`status`, `Columnist`.`publish_at`, `Columnist`.`unpublish_at`, `Columnist`.`name`, `Columnist`.`bio`, `Columnist`.`seo_meta_keywords`, `Columnist`.`seo_meta_description`, `Columnist`.`slug`, `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`.`stories` AS `Story` LEFT JOIN `at_cn`.`columnists` AS `Columnist` ON (`Story`.`columnist_id` = `Columnist`.`id`) LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Story`.`author_id` = `Author`.`id`) WHERE `Story`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND NOT (`Story`.`id` = 6477) AND `Story`.`type` = 'culture' AND `Story`.`publish_at` BETWEEN NOW() - INTERVAL 30 DAY AND NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) ORDER BY `Story`.`pview` DESC LIMIT 5 | 1 | 1 | 4 | 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` = 'story' AND `Image`.`object_id` = (6552) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 1 | 1 | 3 | maybe slow |
SELECT `Gallery1`.`id`, `Gallery1`.`name`, `Gallery1`.`filesize`, `Gallery1`.`type`, `Gallery1`.`caption`, `Gallery1`.`object_type`, `Gallery1`.`object_id`, `Gallery1`.`source`, `Gallery1`.`square_url`, `Gallery1`.`square300_url`, `Gallery1`.`square120_url`, `Gallery1`.`thumb_url`, `Gallery1`.`banner_url`, `Gallery1`.`large_url`, `Gallery1`.`popup_url`, `Gallery1`.`h195_url`, `Gallery1`.`carousel_large_url`, `Gallery1`.`created`, `Gallery1`.`alt`, `Gallery1`.`people`, `Gallery1`.`tags`, `Gallery1`.`sort`, `Gallery1`.`status`, `Gallery1`.`publish_at`, `Gallery1`.`unpublish_at`, `Gallery1`.`carousel_fw_url`, `Gallery1`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery1` WHERE `object_type` = 'gallery1' AND `Gallery1`.`object_id` = (6552) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 3 | 3 | 3 | |
SELECT `Gallery2`.`id`, `Gallery2`.`name`, `Gallery2`.`filesize`, `Gallery2`.`type`, `Gallery2`.`caption`, `Gallery2`.`object_type`, `Gallery2`.`object_id`, `Gallery2`.`source`, `Gallery2`.`square_url`, `Gallery2`.`square300_url`, `Gallery2`.`square120_url`, `Gallery2`.`thumb_url`, `Gallery2`.`banner_url`, `Gallery2`.`large_url`, `Gallery2`.`popup_url`, `Gallery2`.`h195_url`, `Gallery2`.`carousel_large_url`, `Gallery2`.`created`, `Gallery2`.`alt`, `Gallery2`.`people`, `Gallery2`.`tags`, `Gallery2`.`sort`, `Gallery2`.`status`, `Gallery2`.`publish_at`, `Gallery2`.`unpublish_at`, `Gallery2`.`carousel_fw_url`, `Gallery2`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery2` WHERE `object_type` = 'gallery2' AND `Gallery2`.`object_id` = (6552) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery3`.`id`, `Gallery3`.`name`, `Gallery3`.`filesize`, `Gallery3`.`type`, `Gallery3`.`caption`, `Gallery3`.`object_type`, `Gallery3`.`object_id`, `Gallery3`.`source`, `Gallery3`.`square_url`, `Gallery3`.`square300_url`, `Gallery3`.`square120_url`, `Gallery3`.`thumb_url`, `Gallery3`.`banner_url`, `Gallery3`.`large_url`, `Gallery3`.`popup_url`, `Gallery3`.`h195_url`, `Gallery3`.`carousel_large_url`, `Gallery3`.`created`, `Gallery3`.`alt`, `Gallery3`.`people`, `Gallery3`.`tags`, `Gallery3`.`sort`, `Gallery3`.`status`, `Gallery3`.`publish_at`, `Gallery3`.`unpublish_at`, `Gallery3`.`carousel_fw_url`, `Gallery3`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery3` WHERE `object_type` = 'gallery3' AND `Gallery3`.`object_id` = (6552) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery4`.`id`, `Gallery4`.`name`, `Gallery4`.`filesize`, `Gallery4`.`type`, `Gallery4`.`caption`, `Gallery4`.`object_type`, `Gallery4`.`object_id`, `Gallery4`.`source`, `Gallery4`.`square_url`, `Gallery4`.`square300_url`, `Gallery4`.`square120_url`, `Gallery4`.`thumb_url`, `Gallery4`.`banner_url`, `Gallery4`.`large_url`, `Gallery4`.`popup_url`, `Gallery4`.`h195_url`, `Gallery4`.`carousel_large_url`, `Gallery4`.`created`, `Gallery4`.`alt`, `Gallery4`.`people`, `Gallery4`.`tags`, `Gallery4`.`sort`, `Gallery4`.`status`, `Gallery4`.`publish_at`, `Gallery4`.`unpublish_at`, `Gallery4`.`carousel_fw_url`, `Gallery4`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery4` WHERE `object_type` = 'gallery4' AND `Gallery4`.`object_id` = (6552) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC | 0 | 0 | 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` = 'story' AND `Video`.`object_id` = (6552) 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` = 6552 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story' | 0 | 0 | 7 | maybe slow |
SELECT `Story`.`id`, `Story`.`created`, `Story`.`modified`, `Story`.`status`, `Story`.`publish_at`, `Story`.`unpublish_at`, `Story`.`type`, `Story`.`luxury_news`, `Story`.`advertorial`, `Story`.`people_story`, `Story`.`top_list`, `Story`.`title`, `Story`.`deck`, `Story`.`author`, `Story`.`content`, `Story`.`video_link`, `Story`.`tags`, `Story`.`stick_to_top_panel`, `Story`.`stick_to_top_panel_until`, `Story`.`stick_to_landing_top`, `Story`.`stick_to_landing_top_until`, `Story`.`seo_meta_keywords`, `Story`.`seo_meta_description`, `Story`.`slug`, `Story`.`category`, `Story`.`columnist_id`, `Story`.`nid`, `Story`.`pview`, `Story`.`display_type`, `Story`.`source`, `Story`.`region`, `Story`.`region_id`, `Story`.`user_id`, `Story`.`region_modified`, `Story`.`full_advertorial`, `Story`.`to_tatler_tv`, `Story`.`tatlerball2015`, `Story`.`tatlerball2016`, `Story`.`author_id`, `Story`.`copyright`, `Columnist`.`id`, `Columnist`.`created`, `Columnist`.`modified`, `Columnist`.`type`, `Columnist`.`category`, `Columnist`.`status`, `Columnist`.`publish_at`, `Columnist`.`unpublish_at`, `Columnist`.`name`, `Columnist`.`bio`, `Columnist`.`seo_meta_keywords`, `Columnist`.`seo_meta_description`, `Columnist`.`slug`, `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`.`stories` AS `Story` LEFT JOIN `at_cn`.`columnists` AS `Columnist` ON (`Story`.`columnist_id` = `Columnist`.`id`) LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Story`.`author_id` = `Author`.`id`) WHERE `Story`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND `Story`.`type` = 'culture' AND `Story`.`id` < 6477 ORDER BY `Story`.`id` DESC LIMIT 1 | 1 | 1 | 13 | 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` = 'story' AND `Image`.`object_id` = (6473) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 1 | 1 | 3 | maybe slow |
SELECT `Gallery1`.`id`, `Gallery1`.`name`, `Gallery1`.`filesize`, `Gallery1`.`type`, `Gallery1`.`caption`, `Gallery1`.`object_type`, `Gallery1`.`object_id`, `Gallery1`.`source`, `Gallery1`.`square_url`, `Gallery1`.`square300_url`, `Gallery1`.`square120_url`, `Gallery1`.`thumb_url`, `Gallery1`.`banner_url`, `Gallery1`.`large_url`, `Gallery1`.`popup_url`, `Gallery1`.`h195_url`, `Gallery1`.`carousel_large_url`, `Gallery1`.`created`, `Gallery1`.`alt`, `Gallery1`.`people`, `Gallery1`.`tags`, `Gallery1`.`sort`, `Gallery1`.`status`, `Gallery1`.`publish_at`, `Gallery1`.`unpublish_at`, `Gallery1`.`carousel_fw_url`, `Gallery1`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery1` WHERE `object_type` = 'gallery1' AND `Gallery1`.`object_id` = (6473) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 11 | 11 | 3 | maybe slow |
SELECT `Gallery2`.`id`, `Gallery2`.`name`, `Gallery2`.`filesize`, `Gallery2`.`type`, `Gallery2`.`caption`, `Gallery2`.`object_type`, `Gallery2`.`object_id`, `Gallery2`.`source`, `Gallery2`.`square_url`, `Gallery2`.`square300_url`, `Gallery2`.`square120_url`, `Gallery2`.`thumb_url`, `Gallery2`.`banner_url`, `Gallery2`.`large_url`, `Gallery2`.`popup_url`, `Gallery2`.`h195_url`, `Gallery2`.`carousel_large_url`, `Gallery2`.`created`, `Gallery2`.`alt`, `Gallery2`.`people`, `Gallery2`.`tags`, `Gallery2`.`sort`, `Gallery2`.`status`, `Gallery2`.`publish_at`, `Gallery2`.`unpublish_at`, `Gallery2`.`carousel_fw_url`, `Gallery2`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery2` WHERE `object_type` = 'gallery2' AND `Gallery2`.`object_id` = (6473) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery3`.`id`, `Gallery3`.`name`, `Gallery3`.`filesize`, `Gallery3`.`type`, `Gallery3`.`caption`, `Gallery3`.`object_type`, `Gallery3`.`object_id`, `Gallery3`.`source`, `Gallery3`.`square_url`, `Gallery3`.`square300_url`, `Gallery3`.`square120_url`, `Gallery3`.`thumb_url`, `Gallery3`.`banner_url`, `Gallery3`.`large_url`, `Gallery3`.`popup_url`, `Gallery3`.`h195_url`, `Gallery3`.`carousel_large_url`, `Gallery3`.`created`, `Gallery3`.`alt`, `Gallery3`.`people`, `Gallery3`.`tags`, `Gallery3`.`sort`, `Gallery3`.`status`, `Gallery3`.`publish_at`, `Gallery3`.`unpublish_at`, `Gallery3`.`carousel_fw_url`, `Gallery3`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery3` WHERE `object_type` = 'gallery3' AND `Gallery3`.`object_id` = (6473) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery4`.`id`, `Gallery4`.`name`, `Gallery4`.`filesize`, `Gallery4`.`type`, `Gallery4`.`caption`, `Gallery4`.`object_type`, `Gallery4`.`object_id`, `Gallery4`.`source`, `Gallery4`.`square_url`, `Gallery4`.`square300_url`, `Gallery4`.`square120_url`, `Gallery4`.`thumb_url`, `Gallery4`.`banner_url`, `Gallery4`.`large_url`, `Gallery4`.`popup_url`, `Gallery4`.`h195_url`, `Gallery4`.`carousel_large_url`, `Gallery4`.`created`, `Gallery4`.`alt`, `Gallery4`.`people`, `Gallery4`.`tags`, `Gallery4`.`sort`, `Gallery4`.`status`, `Gallery4`.`publish_at`, `Gallery4`.`unpublish_at`, `Gallery4`.`carousel_fw_url`, `Gallery4`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery4` WHERE `object_type` = 'gallery4' AND `Gallery4`.`object_id` = (6473) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC | 0 | 0 | 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` = 'story' AND `Video`.`object_id` = (6473) 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` = 6473 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story' | 0 | 0 | 6 | maybe slow |
SELECT `Story`.`id`, `Story`.`created`, `Story`.`modified`, `Story`.`status`, `Story`.`publish_at`, `Story`.`unpublish_at`, `Story`.`type`, `Story`.`luxury_news`, `Story`.`advertorial`, `Story`.`people_story`, `Story`.`top_list`, `Story`.`title`, `Story`.`deck`, `Story`.`author`, `Story`.`content`, `Story`.`video_link`, `Story`.`tags`, `Story`.`stick_to_top_panel`, `Story`.`stick_to_top_panel_until`, `Story`.`stick_to_landing_top`, `Story`.`stick_to_landing_top_until`, `Story`.`seo_meta_keywords`, `Story`.`seo_meta_description`, `Story`.`slug`, `Story`.`category`, `Story`.`columnist_id`, `Story`.`nid`, `Story`.`pview`, `Story`.`display_type`, `Story`.`source`, `Story`.`region`, `Story`.`region_id`, `Story`.`user_id`, `Story`.`region_modified`, `Story`.`full_advertorial`, `Story`.`to_tatler_tv`, `Story`.`tatlerball2015`, `Story`.`tatlerball2016`, `Story`.`author_id`, `Story`.`copyright`, `Columnist`.`id`, `Columnist`.`created`, `Columnist`.`modified`, `Columnist`.`type`, `Columnist`.`category`, `Columnist`.`status`, `Columnist`.`publish_at`, `Columnist`.`unpublish_at`, `Columnist`.`name`, `Columnist`.`bio`, `Columnist`.`seo_meta_keywords`, `Columnist`.`seo_meta_description`, `Columnist`.`slug`, `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`.`stories` AS `Story` LEFT JOIN `at_cn`.`columnists` AS `Columnist` ON (`Story`.`columnist_id` = `Columnist`.`id`) LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Story`.`author_id` = `Author`.`id`) WHERE `Story`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND `Story`.`type` = 'culture' AND `Story`.`id` >= 6473 AND `Story`.`id` != 6477 ORDER BY `Story`.`id` ASC LIMIT 2 | 2 | 2 | 4 | 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` = 'story' AND `Image`.`object_id` IN (6473, 6479) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 2 | 2 | 3 | maybe slow |
SELECT `Gallery1`.`id`, `Gallery1`.`name`, `Gallery1`.`filesize`, `Gallery1`.`type`, `Gallery1`.`caption`, `Gallery1`.`object_type`, `Gallery1`.`object_id`, `Gallery1`.`source`, `Gallery1`.`square_url`, `Gallery1`.`square300_url`, `Gallery1`.`square120_url`, `Gallery1`.`thumb_url`, `Gallery1`.`banner_url`, `Gallery1`.`large_url`, `Gallery1`.`popup_url`, `Gallery1`.`h195_url`, `Gallery1`.`carousel_large_url`, `Gallery1`.`created`, `Gallery1`.`alt`, `Gallery1`.`people`, `Gallery1`.`tags`, `Gallery1`.`sort`, `Gallery1`.`status`, `Gallery1`.`publish_at`, `Gallery1`.`unpublish_at`, `Gallery1`.`carousel_fw_url`, `Gallery1`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery1` WHERE `object_type` = 'gallery1' AND `Gallery1`.`object_id` IN (6473, 6479) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 16 | 16 | 3 | maybe slow |
SELECT `Gallery2`.`id`, `Gallery2`.`name`, `Gallery2`.`filesize`, `Gallery2`.`type`, `Gallery2`.`caption`, `Gallery2`.`object_type`, `Gallery2`.`object_id`, `Gallery2`.`source`, `Gallery2`.`square_url`, `Gallery2`.`square300_url`, `Gallery2`.`square120_url`, `Gallery2`.`thumb_url`, `Gallery2`.`banner_url`, `Gallery2`.`large_url`, `Gallery2`.`popup_url`, `Gallery2`.`h195_url`, `Gallery2`.`carousel_large_url`, `Gallery2`.`created`, `Gallery2`.`alt`, `Gallery2`.`people`, `Gallery2`.`tags`, `Gallery2`.`sort`, `Gallery2`.`status`, `Gallery2`.`publish_at`, `Gallery2`.`unpublish_at`, `Gallery2`.`carousel_fw_url`, `Gallery2`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery2` WHERE `object_type` = 'gallery2' AND `Gallery2`.`object_id` IN (6473, 6479) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery3`.`id`, `Gallery3`.`name`, `Gallery3`.`filesize`, `Gallery3`.`type`, `Gallery3`.`caption`, `Gallery3`.`object_type`, `Gallery3`.`object_id`, `Gallery3`.`source`, `Gallery3`.`square_url`, `Gallery3`.`square300_url`, `Gallery3`.`square120_url`, `Gallery3`.`thumb_url`, `Gallery3`.`banner_url`, `Gallery3`.`large_url`, `Gallery3`.`popup_url`, `Gallery3`.`h195_url`, `Gallery3`.`carousel_large_url`, `Gallery3`.`created`, `Gallery3`.`alt`, `Gallery3`.`people`, `Gallery3`.`tags`, `Gallery3`.`sort`, `Gallery3`.`status`, `Gallery3`.`publish_at`, `Gallery3`.`unpublish_at`, `Gallery3`.`carousel_fw_url`, `Gallery3`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery3` WHERE `object_type` = 'gallery3' AND `Gallery3`.`object_id` IN (6473, 6479) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Gallery4`.`id`, `Gallery4`.`name`, `Gallery4`.`filesize`, `Gallery4`.`type`, `Gallery4`.`caption`, `Gallery4`.`object_type`, `Gallery4`.`object_id`, `Gallery4`.`source`, `Gallery4`.`square_url`, `Gallery4`.`square300_url`, `Gallery4`.`square120_url`, `Gallery4`.`thumb_url`, `Gallery4`.`banner_url`, `Gallery4`.`large_url`, `Gallery4`.`popup_url`, `Gallery4`.`h195_url`, `Gallery4`.`carousel_large_url`, `Gallery4`.`created`, `Gallery4`.`alt`, `Gallery4`.`people`, `Gallery4`.`tags`, `Gallery4`.`sort`, `Gallery4`.`status`, `Gallery4`.`publish_at`, `Gallery4`.`unpublish_at`, `Gallery4`.`carousel_fw_url`, `Gallery4`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery4` WHERE `object_type` = 'gallery4' AND `Gallery4`.`object_id` IN (6473, 6479) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC | 0 | 0 | 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` = 'story' AND `Video`.`object_id` IN (6473, 6479) 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 (6473, 6479) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story' | 0 | 0 | 6 | maybe slow |
SELECT `Story`.`id`, `Story`.`created`, `Story`.`modified`, `Story`.`status`, `Story`.`publish_at`, `Story`.`unpublish_at`, `Story`.`type`, `Story`.`luxury_news`, `Story`.`advertorial`, `Story`.`people_story`, `Story`.`top_list`, `Story`.`title`, `Story`.`deck`, `Story`.`author`, `Story`.`content`, `Story`.`video_link`, `Story`.`tags`, `Story`.`stick_to_top_panel`, `Story`.`stick_to_top_panel_until`, `Story`.`stick_to_landing_top`, `Story`.`stick_to_landing_top_until`, `Story`.`seo_meta_keywords`, `Story`.`seo_meta_description`, `Story`.`slug`, `Story`.`category`, `Story`.`columnist_id`, `Story`.`nid`, `Story`.`pview`, `Story`.`display_type`, `Story`.`source`, `Story`.`region`, `Story`.`region_id`, `Story`.`user_id`, `Story`.`region_modified`, `Story`.`full_advertorial`, `Story`.`to_tatler_tv`, `Story`.`tatlerball2015`, `Story`.`tatlerball2016`, `Story`.`author_id`, `Story`.`copyright`, `Columnist`.`id`, `Columnist`.`created`, `Columnist`.`modified`, `Columnist`.`type`, `Columnist`.`category`, `Columnist`.`status`, `Columnist`.`publish_at`, `Columnist`.`unpublish_at`, `Columnist`.`name`, `Columnist`.`bio`, `Columnist`.`seo_meta_keywords`, `Columnist`.`seo_meta_description`, `Columnist`.`slug`, `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`.`stories` AS `Story` LEFT JOIN `at_cn`.`columnists` AS `Columnist` ON (`Story`.`columnist_id` = `Columnist`.`id`) LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Story`.`author_id` = `Author`.`id`) WHERE `Story`.`status` = '1' AND `Story`.`id` != 6477 AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND `Story`.`type` = 'culture' ORDER BY `Story`.`publish_at` DESC LIMIT 5 | 5 | 5 | 15 | 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` = 'story' AND `Image`.`object_id` IN (6552, 6541, 6535, 6524, 6508) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 4 | 4 | 3 | maybe slow |
SELECT `Gallery1`.`id`, `Gallery1`.`name`, `Gallery1`.`filesize`, `Gallery1`.`type`, `Gallery1`.`caption`, `Gallery1`.`object_type`, `Gallery1`.`object_id`, `Gallery1`.`source`, `Gallery1`.`square_url`, `Gallery1`.`square300_url`, `Gallery1`.`square120_url`, `Gallery1`.`thumb_url`, `Gallery1`.`banner_url`, `Gallery1`.`large_url`, `Gallery1`.`popup_url`, `Gallery1`.`h195_url`, `Gallery1`.`carousel_large_url`, `Gallery1`.`created`, `Gallery1`.`alt`, `Gallery1`.`people`, `Gallery1`.`tags`, `Gallery1`.`sort`, `Gallery1`.`status`, `Gallery1`.`publish_at`, `Gallery1`.`unpublish_at`, `Gallery1`.`carousel_fw_url`, `Gallery1`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery1` WHERE `object_type` = 'gallery1' AND `Gallery1`.`object_id` IN (6552, 6541, 6535, 6524, 6508) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 30 | 30 | 3 | maybe slow |
SELECT `Gallery2`.`id`, `Gallery2`.`name`, `Gallery2`.`filesize`, `Gallery2`.`type`, `Gallery2`.`caption`, `Gallery2`.`object_type`, `Gallery2`.`object_id`, `Gallery2`.`source`, `Gallery2`.`square_url`, `Gallery2`.`square300_url`, `Gallery2`.`square120_url`, `Gallery2`.`thumb_url`, `Gallery2`.`banner_url`, `Gallery2`.`large_url`, `Gallery2`.`popup_url`, `Gallery2`.`h195_url`, `Gallery2`.`carousel_large_url`, `Gallery2`.`created`, `Gallery2`.`alt`, `Gallery2`.`people`, `Gallery2`.`tags`, `Gallery2`.`sort`, `Gallery2`.`status`, `Gallery2`.`publish_at`, `Gallery2`.`unpublish_at`, `Gallery2`.`carousel_fw_url`, `Gallery2`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery2` WHERE `object_type` = 'gallery2' AND `Gallery2`.`object_id` IN (6552, 6541, 6535, 6524, 6508) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC | 1 | 1 | 3 | maybe slow |
SELECT `Gallery3`.`id`, `Gallery3`.`name`, `Gallery3`.`filesize`, `Gallery3`.`type`, `Gallery3`.`caption`, `Gallery3`.`object_type`, `Gallery3`.`object_id`, `Gallery3`.`source`, `Gallery3`.`square_url`, `Gallery3`.`square300_url`, `Gallery3`.`square120_url`, `Gallery3`.`thumb_url`, `Gallery3`.`banner_url`, `Gallery3`.`large_url`, `Gallery3`.`popup_url`, `Gallery3`.`h195_url`, `Gallery3`.`carousel_large_url`, `Gallery3`.`created`, `Gallery3`.`alt`, `Gallery3`.`people`, `Gallery3`.`tags`, `Gallery3`.`sort`, `Gallery3`.`status`, `Gallery3`.`publish_at`, `Gallery3`.`unpublish_at`, `Gallery3`.`carousel_fw_url`, `Gallery3`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery3` WHERE `object_type` = 'gallery3' AND `Gallery3`.`object_id` IN (6552, 6541, 6535, 6524, 6508) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC | 1 | 1 | 3 | maybe slow |
SELECT `Gallery4`.`id`, `Gallery4`.`name`, `Gallery4`.`filesize`, `Gallery4`.`type`, `Gallery4`.`caption`, `Gallery4`.`object_type`, `Gallery4`.`object_id`, `Gallery4`.`source`, `Gallery4`.`square_url`, `Gallery4`.`square300_url`, `Gallery4`.`square120_url`, `Gallery4`.`thumb_url`, `Gallery4`.`banner_url`, `Gallery4`.`large_url`, `Gallery4`.`popup_url`, `Gallery4`.`h195_url`, `Gallery4`.`carousel_large_url`, `Gallery4`.`created`, `Gallery4`.`alt`, `Gallery4`.`people`, `Gallery4`.`tags`, `Gallery4`.`sort`, `Gallery4`.`status`, `Gallery4`.`publish_at`, `Gallery4`.`unpublish_at`, `Gallery4`.`carousel_fw_url`, `Gallery4`.`mobile_cover` FROM `at_cn`.`images` AS `Gallery4` WHERE `object_type` = 'gallery4' AND `Gallery4`.`object_id` IN (6552, 6541, 6535, 6524, 6508) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC | 0 | 0 | 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` = 'story' AND `Video`.`object_id` IN (6552, 6541, 6535, 6524, 6508) 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 (6552, 6541, 6535, 6524, 6508) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story' | 0 | 0 | 6 | maybe slow |
UPDATE `at_cn`.`stories` AS `Story` LEFT JOIN `at_cn`.`columnists` AS `Columnist` ON (`Story`.`columnist_id` = `Columnist`.`id`) LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Story`.`author_id` = `Author`.`id`) SET `Story`.`pview` = Story.pview + 1 WHERE `Story`.`id` = 6477 | 1 | 1 | 6 | maybe slow |