Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT DISTINCT `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` FROM `at_cn`.`tagged` AS `Tagged` LEFT JOIN `at_cn`.`tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) INNER JOIN `at_cn`.`stories` AS `Story` ON (`Tagged`.`foreign_key` = `Story`.`id` AND `Tagged`.`model` = 'Story') WHERE `Story`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND `Tag`.`keyname` IN ('crazyrouge', 'crazy-rouge', 'Crazy Rouge') ORDER BY `Story`.`publish_at` DESC | 12 | 12 | 51 | 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 `object_id` = 5595 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 53633 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 5 | 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 `object_id` = 5592 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 53601 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 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 `object_id` = 5593 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 53616 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 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 `object_id` = 5560 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 53149 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 1 | 1 | 5 | 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 `object_id` = 5196 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 49879 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 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 `object_id` = 5193 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 49773 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 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 `object_id` = 5142 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 49154 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 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 `object_id` = 5090 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 48338 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 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 `object_id` = 5035 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 47854 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 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 `object_id` = 4558 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 43361 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 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 `object_id` = 4404 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 40739 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 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 `object_id` = 4237 AND `object_type` = 'story' ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 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` = 39304 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Image' | 0 | 0 | 4 | maybe slow |