Be part of the in-crowd and receive exclusive party invitations and fabulous offers.
SIGN UP WITH TATLER
© 2024 Edipresse Media Asia Limited. All rights reserved. All material on this site is © asiatatler.com. Edipresse Media Asia Limited.
沪ICP备10210439号-2
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `Brand`.`id`, `Brand`.`created`, `Brand`.`modified`, `Brand`.`status`, `Brand`.`publish_at`, `Brand`.`unpublish_at`, `Brand`.`name`, `Brand`.`description`, `Brand`.`seo_meta_keywords`, `Brand`.`seo_meta_description`, `Brand`.`slug`, `Brand`.`tid` FROM `at_cn`.`brands` AS `Brand` WHERE `Brand`.`slug` = 'opi' LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `Product`.`id`, `Product`.`created`, `Product`.`modified`, `Product`.`status`, `Product`.`publish_at`, `Product`.`unpublish_at`, `Product`.`brand_id`, `Product`.`category`, `Product`.`website`, `Product`.`price`, `Product`.`pick_of_the_day`, `Product`.`title`, `Product`.`deck`, `Product`.`description`, `Product`.`seo_meta_keywords`, `Product`.`seo_meta_description`, `Product`.`slug`, `Product`.`theme_id`, `Product`.`nid`, `Product`.`pview`, `ShoppingTheme`.`id`, `ShoppingTheme`.`created`, `ShoppingTheme`.`modified`, `ShoppingTheme`.`status`, `ShoppingTheme`.`publish_at`, `ShoppingTheme`.`unpublish_at`, `ShoppingTheme`.`title`, `ShoppingTheme`.`description`, `ShoppingTheme`.`tags`, `ShoppingTheme`.`stick_to_top_panel`, `ShoppingTheme`.`stick_to_top_panel_until`, `ShoppingTheme`.`stick_to_landing_top`, `ShoppingTheme`.`stick_to_landing_top_until`, `ShoppingTheme`.`seo_meta_keywords`, `ShoppingTheme`.`seo_meta_description`, `ShoppingTheme`.`slug`, `ShoppingTheme`.`author`, `ShoppingTheme`.`nid`, `ShoppingTheme`.`pview`, `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`.`products` AS `Product` LEFT JOIN `at_cn`.`shopping_themes` AS `ShoppingTheme` ON (`Product`.`theme_id` = `ShoppingTheme`.`id`) LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Product`.`id` AND `Image`.`object_type` = 'product') WHERE `Product`.`brand_id` = 358 AND `Product`.`status` = '1' AND `Product`.`publish_at` <= NOW() AND (`Product`.`unpublish_at` IS NULL OR `Product`.`unpublish_at` > NOW()) ORDER BY `Product`.`publish_at` DESC LIMIT 10 | 2 | 2 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `at_cn`.`products` AS `Product` LEFT JOIN `at_cn`.`shopping_themes` AS `ShoppingTheme` ON (`Product`.`theme_id` = `ShoppingTheme`.`id`) LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Product`.`id` AND `Image`.`object_type` = 'product') WHERE `Product`.`brand_id` = 358 AND `Product`.`status` = '1' AND `Product`.`publish_at` <= NOW() AND (`Product`.`unpublish_at` IS NULL OR `Product`.`unpublish_at` > NOW()) | 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`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND (`Story`.`unpublish_at` IS NULL OR `Story`.`unpublish_at` > NOW()) AND `Story`.`stick_to_top_panel` = '0' ORDER BY `Story`.`publish_at` DESC LIMIT 15 | 15 | 15 | 61 | 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, 6551, 6550, 6549, 6546, 6547, 6545, 6543, 6544, 6542, 6541, 6540, 6548, 6539, 6538) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 15 | 15 | 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, 6551, 6550, 6549, 6546, 6547, 6545, 6543, 6544, 6542, 6541, 6540, 6548, 6539, 6538) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 104 | 104 | 9 | 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, 6551, 6550, 6549, 6546, 6547, 6545, 6543, 6544, 6542, 6541, 6540, 6548, 6539, 6538) ORDER BY `Gallery2`.`sort` ASC, `Gallery2`.`created` ASC | 11 | 11 | 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, 6551, 6550, 6549, 6546, 6547, 6545, 6543, 6544, 6542, 6541, 6540, 6548, 6539, 6538) ORDER BY `Gallery3`.`sort` ASC, `Gallery3`.`created` ASC | 5 | 5 | 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, 6551, 6550, 6549, 6546, 6547, 6545, 6543, 6544, 6542, 6541, 6540, 6548, 6539, 6538) 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, 6551, 6550, 6549, 6546, 6547, 6545, 6543, 6544, 6542, 6541, 6540, 6548, 6539, 6538) 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, 6551, 6550, 6549, 6546, 6547, 6545, 6543, 6544, 6542, 6541, 6540, 6548, 6539, 6538) 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`.`stick_to_top_panel` = '1' AND (`Story`.`stick_to_top_panel_until` IS NULL OR `Story`.`stick_to_top_panel_until` > NOW()) ORDER BY `Story`.`publish_at` DESC LIMIT 15 | 15 | 15 | 32 | 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 (4591, 4592, 4583, 4558, 4555, 4552, 4534, 4536, 4527, 4528, 4522, 4523, 4521, 4526, 4508) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 149 | 149 | 13 | 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 (4591, 4592, 4583, 4558, 4555, 4552, 4534, 4536, 4527, 4528, 4522, 4523, 4521, 4526, 4508) ORDER BY `Gallery1`.`sort` ASC, `Gallery1`.`created` ASC | 0 | 0 | 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 (4591, 4592, 4583, 4558, 4555, 4552, 4534, 4536, 4527, 4528, 4522, 4523, 4521, 4526, 4508) 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 (4591, 4592, 4583, 4558, 4555, 4552, 4534, 4536, 4527, 4528, 4522, 4523, 4521, 4526, 4508) 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 (4591, 4592, 4583, 4558, 4555, 4552, 4534, 4536, 4527, 4528, 4522, 4523, 4521, 4526, 4508) 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 (4591, 4592, 4583, 4558, 4555, 4552, 4534, 4536, 4527, 4528, 4522, 4523, 4521, 4526, 4508) 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 (4591, 4592, 4583, 4558, 4555, 4552, 4534, 4536, 4527, 4528, 4522, 4523, 4521, 4526, 4508) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Story' | 52 | 52 | 7 | maybe slow |
| SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`status`, `Event`.`publish_at`, `Event`.`unpublish_at`, `Event`.`title`, `Event`.`venue`, `Event`.`event_date`, `Event`.`description`, `Event`.`tags`, `Event`.`author`, `Event`.`stick_to_top_panel`, `Event`.`stick_to_top_panel_until`, `Event`.`stick_to_landing_top`, `Event`.`stick_to_landing_top_until`, `Event`.`seo_meta_keywords`, `Event`.`seo_meta_description`, `Event`.`slug`, `Event`.`nid`, `Event`.`display_type`, `Event`.`tatlerball2015`, `Event`.`tatlerball2016`, `Event`.`author_id`, `Event`.`copyright`, `Event`.`source`, `Author`.`id`, `Author`.`created`, `Author`.`modified`, `Author`.`type`, `Author`.`category`, `Author`.`status`, `Author`.`publish_at`, `Author`.`unpublish_at`, `Author`.`name`, `Author`.`bio`, `Author`.`seo_meta_keywords`, `Author`.`seo_meta_description`, `Author`.`slug` FROM `at_cn`.`events` AS `Event` LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Event`.`author_id` = `Author`.`id`) WHERE `Event`.`status` = '1' AND `Event`.`publish_at` <= NOW() AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) ORDER BY `Event`.`publish_at` DESC LIMIT 15 | 15 | 15 | 6 | maybe slow |
| SELECT `Image`.`id`, `Image`.`name`, `Image`.`filesize`, `Image`.`type`, `Image`.`caption`, `Image`.`object_type`, `Image`.`object_id`, `Image`.`source`, `Image`.`square_url`, `Image`.`square300_url`, `Image`.`square120_url`, `Image`.`thumb_url`, `Image`.`banner_url`, `Image`.`large_url`, `Image`.`popup_url`, `Image`.`h195_url`, `Image`.`carousel_large_url`, `Image`.`created`, `Image`.`alt`, `Image`.`people`, `Image`.`tags`, `Image`.`sort`, `Image`.`status`, `Image`.`publish_at`, `Image`.`unpublish_at`, `Image`.`carousel_fw_url`, `Image`.`mobile_cover` FROM `at_cn`.`images` AS `Image` WHERE `Image`.`object_type` = 'event' AND `Image`.`object_id` IN (1045, 1044, 1042, 1043, 1041, 1040, 1039, 1038, 1037, 1036, 1035, 1033, 1034, 1032, 1031) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 253 | 253 | 13 | maybe slow |
| SELECT `Video`.`id`, `Video`.`title`, `Video`.`description`, `Video`.`source`, `Video`.`object_type`, `Video`.`object_id`, `Video`.`ext`, `Video`.`type`, `Video`.`size`, `Video`.`group`, `Video`.`width`, `Video`.`height`, `Video`.`filesize`, `Video`.`created`, `Video`.`status`, `Video`.`publish_at`, `Video`.`unpublish_at`, `Video`.`tags`, `Video`.`slug`, `Video`.`event`, `Video`.`behindscene`, `Video`.`old_source`, `Video`.`youtube` FROM `at_cn`.`videos` AS `Video` WHERE `Video`.`object_type` = 'event' AND `Video`.`object_id` IN (1045, 1044, 1042, 1043, 1041, 1040, 1039, 1038, 1037, 1036, 1035, 1033, 1034, 1032, 1031) ORDER BY `Video`.`created` DESC | 0 | 0 | 3 | maybe slow |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `at_cn`.`tags` AS `Tag` JOIN `at_cn`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (1045, 1044, 1042, 1043, 1041, 1040, 1039, 1038, 1037, 1036, 1035, 1033, 1034, 1032, 1031) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Event' | 62 | 62 | 7 | maybe slow |
| SELECT `ShoppingTheme`.`id`, `ShoppingTheme`.`created`, `ShoppingTheme`.`modified`, `ShoppingTheme`.`status`, `ShoppingTheme`.`publish_at`, `ShoppingTheme`.`unpublish_at`, `ShoppingTheme`.`title`, `ShoppingTheme`.`description`, `ShoppingTheme`.`tags`, `ShoppingTheme`.`stick_to_top_panel`, `ShoppingTheme`.`stick_to_top_panel_until`, `ShoppingTheme`.`stick_to_landing_top`, `ShoppingTheme`.`stick_to_landing_top_until`, `ShoppingTheme`.`seo_meta_keywords`, `ShoppingTheme`.`seo_meta_description`, `ShoppingTheme`.`slug`, `ShoppingTheme`.`author`, `ShoppingTheme`.`nid`, `ShoppingTheme`.`pview`, `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`.`shopping_themes` AS `ShoppingTheme` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `ShoppingTheme`.`id` AND `Image`.`object_type` = 'shopping_theme') WHERE `ShoppingTheme`.`status` = '1' AND `ShoppingTheme`.`publish_at` <= NOW() AND (`ShoppingTheme`.`unpublish_at` IS NULL OR `ShoppingTheme`.`unpublish_at` > NOW()) ORDER BY `ShoppingTheme`.`publish_at` DESC LIMIT 15 | 15 | 15 | 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 (86, 85, 84, 3, 4, 5, 6, 7, 9, 10, 15, 16, 18, 12, 13) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'ShoppingTheme' | 4 | 4 | 3 | maybe slow |
Peak Memory Use 21.97 MB
| Message | Memory use |
|---|---|
| Component initialization | 1.81 MB |
| Controller action start | 2.70 MB |
| Controller render start | 5.57 MB |
| View render complete | 6.36 MB |
Total Request Time: 814 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 8.76 | |
| Event: Controller.initialize | 13.65 | |
| Event: Controller.startup | 1.37 | |
| Controller action | 630.49 | |
| Event: Controller.beforeRender | 71.96 | |
| » Processing toolbar data | 71.81 | |
| Rendering View | 8.28 | |
| » Rendering APP/View/Themed/Tatler/Products/brand_view.ctp | 1.53 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_elements_pop_enews_session.ctp | 0.09 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_stylesheets.ctp | 0.36 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_content_guide_brandview.ctp | 0.70 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_breadcrumb.ctp | 0.15 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_subscribe_letter.ctp | 0.11 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_breadcrumb.ctp #2 | 0.12 | |
| » Rendering APP/View/Themed/Tatler/Layouts/site.ctp | 6.18 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_meta.ctp | 0.17 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_fbmeta.ctp | 0.06 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_stylesheets.ctp #2 | 0.29 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts.ctp | 0.49 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_facebook.ctp | 0.07 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_twitter.ctp | 0.06 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_openx.ctp | 0.07 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_javascript_after.ctp | 0.42 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_ga.ctp | 0.09 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_ads.ctp | 0.07 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_ads.ctp #2 | 0.05 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_ads.ctp #3 | 0.05 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_header.ctp | 2.29 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_header_holder.ctp | 0.52 | |
| » » » » Rendering APP/View/Themed/Tatler/Elements/site_tatler_countries.ctp | 0.11 | |
| » » » » Rendering APP/View/Themed/Tatler/Elements/site_social_icons.ctp | 0.07 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_sticky_menu.ctp | 1.56 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_main.ctp | 0.08 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_footer.ctp | 0.74 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_social_icons.ctp #2 | 0.07 | |
| » » » Rendering APP/View/Themed/Tatler/Elements/site_tatler_countries.ctp #2 | 0.07 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_openx.ctp #2 | 0.07 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_ads.ctp #4 | 0.08 | |
| » » Rendering APP/View/Themed/Tatler/Elements/site_subscribe_letter.ctp #2 | 0.12 |
| Constant | Value |
|---|---|
| APP | /var/www/html/tatler-cn-test/app/ |
| APP_DIR | app |
| APPLIBS | /var/www/html/tatler-cn-test/app/Lib/ |
| CACHE | /var/www/html/tatler-cn-test/app/tmp/cache/ |
| CAKE | /var/www/html/tatler-cn-test/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /var/www/html/tatler-cn-test/lib |
| CORE_PATH | /var/www/html/tatler-cn-test/lib/ |
| CAKE_VERSION | 2.1.2 |
| CSS | /var/www/html/tatler-cn-test/app/webroot/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | http://shangliutatler.com:8081 |
| IMAGES | /var/www/html/tatler-cn-test/app/webroot/img/ |
| IMAGES_URL | img/ |
| JS | /var/www/html/tatler-cn-test/app/webroot/js/ |
| JS_URL | js/ |
| LOGS | /var/www/html/tatler-cn-test/app/tmp/logs/ |
| ROOT | /var/www/html/tatler-cn-test |
| TESTS | /var/www/html/tatler-cn-test/app/Test/ |
| TMP | /var/www/html/tatler-cn-test/app/tmp/ |
| VENDORS | /var/www/html/tatler-cn-test/vendors/ |
| WEBROOT_DIR | webroot |
| WWW_ROOT | /var/www/html/tatler-cn-test/app/webroot/ |
| Environment Variable | Value |
|---|---|
| Php Version | 5.5.9-1ubuntu4.14 |
| Redirect Redirect Cake Site | asiatatler |
| Redirect Redirect Cake Region | CN |
| Redirect Redirect Cake Lang | zh-CN |
| Redirect Redirect Cake Env | debug |
| Redirect Redirect Status | 200 |
| Redirect Cake Site | asiatatler |
| Redirect Cake Region | CN |
| Redirect Cake Lang | zh-CN |
| Redirect Cake Env | debug |
| Redirect Status | 200 |
| Cake Site | asiatatler |
| Cake Region | CN |
| Cake Lang | zh-CN |
| Cake Env | debug |
| Http Accept | */* |
| Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Http Accept Encoding | gzip, br, zstd, deflate |
| Http Host | shangliutatler.com:8081 |
| Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin |
| Server Signature | Apache/2.4.7 (Ubuntu) Server at shangliutatler.com Port 8081 |
| Server Software | Apache/2.4.7 (Ubuntu) |
| Server Name | shangliutatler.com |
| Server Addr | 10.46.22.148 |
| Server Port | 8081 |
| Remote Addr | 18.191.26.4 |
| Document Root | /var/www/html/tatler-cn-test |
| Request Scheme | http |
| Context Prefix | |
| Context Document Root | /var/www/html/tatler-cn-test |
| Server Admin | [no address given] |
| Script Filename | /var/www/html/tatler-cn-test/app/webroot/index.php |
| Remote Port | 44931 |
| Redirect Url | /app/webroot/tatler-picks/brands/opi |
| Gateway Interface | CGI/1.1 |
| Server Protocol | HTTP/1.1 |
| Request Method | GET |
| Query String | |
| Request Uri | /tatler-picks/brands/opi |
| Script Name | /app/webroot/index.php |
| Php Self | /app/webroot/index.php |
| Request Time Float | 1731220076.457 |
| Request Time | 1731220076 |
