摩登之所 这是一套位于上海最繁华地段的二层公寓,从推门进入的那一刻起,就被拥有巨大存在感的楼梯所吸引,设计上别具一格地采用了亮面烟灰色作为楼梯外观色,抽象感十足。仅从这一处,便可知公寓整体以纽约现代风格为主,简约流畅的线条搭配精心处理的细节,Jerry骄傲地将它形容为“007”也会住的地方。公寓的整体设计由来自加拿大的建筑及室内设计师James Saywell完成,帮助Jerry完成多处公寓设计的他对Jerry的品位了如指掌,设计起来自然也更得心应手。公寓整体采用了现代风格的暖灰、柔白以及酷黑色系,显得简洁高级。家具则多以俏皮亮丽的颜色为主,力求突出色彩与现代感,一方面与公寓的整体色调产生碰撞,另一方面也与Jerry幽默开朗的个性呼应。观赏一处住宅,当然可以从整体风格了解主人的个性,亦如同寻宝一般,可从细节之处发现主人的爱好兴趣。Jerry家中,随处可见极具现代风格的艺术品,有些价值不菲,如Andy Warhol和 Roy Litchenstein的作品大胆先锋又极富趣味,令原本略显冷感的空间随即“热闹”了起来。客厅中的巨幅蜘蛛人画作就是特别定制而来,蜘蛛人喷射出最后的标志性“HITS”就是这座公寓House in The Sky的简称。一楼影视厅中的巨幅画作挑选了Lichtenstein的标志性创作元素条纹与波点,通过科技合成客厅全景而来,如果你足够细心,会发现画的色彩与旁边墙上皮板的颜色是一样的。当然,Jerry家中也不乏朋友们的神来之作,二楼洗手间的那幅好莱坞女星Angelina Jolie的黑白摄影作品就因被Jerry好友加上了禁烟标志而变得更加耐人寻味。事实上,公寓中几乎每一幅艺术品背后都有一个有趣的故事,正是这些多元化的作品令Jerry的家显得丰富生动。
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` = 'wine-life-apartment-elegance-2016-Aug' LIMIT 1
1
1
1
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` = (4265) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC
10
10
1
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 (39598, 39597, 39599, 39600, 39601, 39602, 39603, 39604, 39605, 39606) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image'
0
0
2
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` = (4265) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC
0
0
0
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` = (4265) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC
0
0
0
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` = (4265) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC
0
0
0
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` = (4265) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC
0
0
0
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` = (4265) ORDER BY `Video`.`created` DESC
0
0
0
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` = 4265 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story'
1
1
4
maybe slow
SELECT `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `at_cn`.`tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('57a2ec03-3bc4-489a-ada7-60948bc4bf0c')
1
1
7
maybe slow
SELECT COUNT(*) AS `count` FROM `at_cn`.`stories` AS `Story` WHERE `Story`.`id` = 4265
1
1
0
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` = 4265) ORDER BY `Story`.`publish_at` DESC LIMIT 5
5
5
59
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 (6673, 6674, 6672, 6671, 6675) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC
1
1
1
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 (6673, 6674, 6672, 6671, 6675) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC
14
14
1
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 (6673, 6674, 6672, 6671, 6675) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC
12
12
1
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 (6673, 6674, 6672, 6671, 6675) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC
0
0
0
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 (6673, 6674, 6672, 6671, 6675) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC
0
0
0
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 (6673, 6674, 6672, 6671, 6675) ORDER BY `Video`.`created` DESC
0
0
0
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 (6673, 6674, 6672, 6671, 6675) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story'
0
0
4
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` = 4265) AND `Story`.`type` = 'life' 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
5
5
2
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 (6659, 6660, 6666, 6663, 6661) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC
3
3
0
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 (6659, 6660, 6666, 6663, 6661) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC
38
38
1
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 (6659, 6660, 6666, 6663, 6661) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC
3
3
0
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 (6659, 6660, 6666, 6663, 6661) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC
0
0
0
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 (6659, 6660, 6666, 6663, 6661) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC
0
0
0
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 (6659, 6660, 6666, 6663, 6661) ORDER BY `Video`.`created` DESC
0
0
0
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 (6659, 6660, 6666, 6663, 6661) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story'
0
0
4
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` = 'life' AND `Story`.`id` < 4265 ORDER BY `Story`.`id` DESC LIMIT 1
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` = (4264) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC
6
6
1
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` = (4264) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC
0
0
0
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` = (4264) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC
0
0
0
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` = (4264) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC
0
0
0
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` = (4264) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC
0
0
0
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` = (4264) ORDER BY `Video`.`created` DESC
0
0
0
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` = 4264 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story'
1
1
4
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` = 'life' AND `Story`.`id` >= 4264 AND `Story`.`id` != 4265 ORDER BY `Story`.`id` ASC LIMIT 2
2
2
21
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 (4264, 4266) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC
24
24
1
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 (4264, 4266) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC
0
0
0
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 (4264, 4266) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC
0
0
0
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 (4264, 4266) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC
0
0
0
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 (4264, 4266) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC
0
0
0
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 (4264, 4266) ORDER BY `Video`.`created` DESC
0
0
0
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 (4264, 4266) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story'
2
2
4
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` != 4265 AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND `Story`.`type` = 'life' ORDER BY `Story`.`publish_at` DESC LIMIT 5
5
5
23
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 (6673, 6674, 6675, 6669, 6668) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC
0
0
1
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 (6673, 6674, 6675, 6669, 6668) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC
20
20
1
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 (6673, 6674, 6675, 6669, 6668) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC
5
5
0
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 (6673, 6674, 6675, 6669, 6668) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC
0
0
0
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 (6673, 6674, 6675, 6669, 6668) ORDER BY `Gallery4`.`sort` ASC, `Gallery4`.`created` ASC
0
0
0
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 (6673, 6674, 6675, 6669, 6668) ORDER BY `Video`.`created` DESC
0
0
0
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 (6673, 6674, 6675, 6669, 6668) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story'
0
0
4
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` = 4265
1
1
2
maybe slow
Query Explain:
Click an "Explain" link above, to see the query explanation.