array_rand - [internal], line ??
EventsController::view() - APP/Controller/EventsController.php, line 556
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 485
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 103
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85
[main] - APP/webroot/index.php, line 92
Notice (8): Undefined index: [APP/Controller/EventsController.php, line 557]
EventsController::view() - APP/Controller/EventsController.php, line 557
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 485
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 103
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85
[main] - APP/webroot/index.php, line 92
Notice (8): Undefined index: [APP/Controller/EventsController.php, line 557]
EventsController::view() - APP/Controller/EventsController.php, line 557
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 485
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 103
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85
[main] - APP/webroot/index.php, line 92
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/html/tatler-cn-test/lib/Cake/Utility/Debugger.php:761) [CORE/Cake/Network/CakeResponse.php, line 395]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 395
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 372
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 119
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85
[main] - APP/webroot/index.php, line 92
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/html/tatler-cn-test/lib/Cake/Utility/Debugger.php:761) [CORE/Cake/Network/CakeResponse.php, line 395]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 395
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 372
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 119
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85
[main] - APP/webroot/index.php, line 92
SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`status`, `Event`.`publish_at`, `Event`.`unpublish_at`, `Event`.`title`, `Event`.`venue`, `Event`.`event_date`, `Event`.`description`, `Event`.`tags`, `Event`.`author`, `Event`.`stick_to_top_panel`, `Event`.`stick_to_top_panel_until`, `Event`.`stick_to_landing_top`, `Event`.`stick_to_landing_top_until`, `Event`.`seo_meta_keywords`, `Event`.`seo_meta_description`, `Event`.`slug`, `Event`.`nid`, `Event`.`display_type`, `Event`.`tatlerball2015`, `Event`.`tatlerball2016`, `Event`.`author_id`, `Event`.`copyright`, `Event`.`source`, `Author`.`id`, `Author`.`created`, `Author`.`modified`, `Author`.`type`, `Author`.`category`, `Author`.`status`, `Author`.`publish_at`, `Author`.`unpublish_at`, `Author`.`name`, `Author`.`bio`, `Author`.`seo_meta_keywords`, `Author`.`seo_meta_description`, `Author`.`slug` FROM `at_cn`.`events` AS `Event` LEFT JOIN `at_cn`.`authors` AS `Author` ON (`Event`.`author_id` = `Author`.`id`) WHERE `Event`.`status` = '1' AND `Event`.`publish_at` <= NOW() AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) AND `Event`.`slug` = 'Toplife-05-2018' ORDER BY `Event`.`event_date` DESC 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` = 'event' AND `Image`.`object_id` = (1045) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC
10
10
3
maybe slow
SELECT `Video`.`id`, `Video`.`title`, `Video`.`description`, `Video`.`source`, `Video`.`object_type`, `Video`.`object_id`, `Video`.`ext`, `Video`.`type`, `Video`.`size`, `Video`.`group`, `Video`.`width`, `Video`.`height`, `Video`.`filesize`, `Video`.`created`, `Video`.`status`, `Video`.`publish_at`, `Video`.`unpublish_at`, `Video`.`tags`, `Video`.`slug`, `Video`.`event`, `Video`.`behindscene`, `Video`.`old_source`, `Video`.`youtube` FROM `at_cn`.`videos` AS `Video` WHERE `Video`.`object_type` = 'event' AND `Video`.`object_id` = (1045) 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` = 1045 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Event'
3
3
7
maybe slow
SELECT COUNT(*) AS `count` FROM `at_cn`.`events` AS `Event` WHERE `Event`.`id` = 1045
1
1
3
maybe slow
SELECT DISTINCT `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` FROM `at_cn`.`tagged` AS `Tagged` LEFT JOIN `at_cn`.`tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) INNER JOIN `at_cn`.`events` AS `Event` ON (`Tagged`.`foreign_key` = `Event`.`id` AND `Tagged`.`model` = 'Event') WHERE `Event`.`status` = '1' AND `Event`.`publish_at` <= NOW() AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) AND `Event`.`id` != 1045 AND `Tag`.`keyname` IN ('Toplife', '京东', 'LVMH') ORDER BY `Event`.`event_date` DESC LIMIT 3
0
0
10
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`.`event_date` BETWEEN NOW() - INTERVAL 40 DAY AND NOW() AND (`Event`.`unpublish_at` IS NULL OR `Event`.`unpublish_at` > NOW()) AND NOT (`Event`.`id` = 1045) ORDER BY `Event`.`event_date` DESC, `Event`.`id` DESC
0
0
4
maybe slow
Query Explain:
Click an "Explain" link above, to see the query explanation.