| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Magazine`.`id`, `Magazine`.`created`, `Magazine`.`modified`, `Magazine`.`status`, `Magazine`.`publish_at`, `Magazine`.`unpublish_at`, `Magazine`.`month_issue`, `Magazine`.`year_issue`, `Magazine`.`title`, `Magazine`.`deck`, `Magazine`.`description`, `Magazine`.`contents`, `Magazine`.`extended`, `Magazine`.`tags`, `Magazine`.`seo_meta_keywords`, `Magazine`.`seo_meta_description`, `Magazine`.`slug`, `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`.`magazines` AS `Magazine` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Magazine`.`id` AND `Image`.`object_type` = 'magazine') WHERE `Magazine`.`status` = '1' AND `Magazine`.`publish_at` <= NOW() AND (`Magazine`.`unpublish_at` IS NULL OR `Magazine`.`unpublish_at` > NOW()) ORDER BY `Magazine`.`publish_at` DESC | 1 | 1 | 4 | maybe slow |
| SELECT `Celebrity`.`id`, `Celebrity`.`created`, `Celebrity`.`modified`, `Celebrity`.`status`, `Celebrity`.`publish_at`, `Celebrity`.`unpublish_at`, `Celebrity`.`name`, `Celebrity`.`last_name`, `Celebrity`.`description`, `Celebrity`.`ref_id`, `Celebrity`.`new_entry_2013`, `Celebrity`.`seo_meta_keywords`, `Celebrity`.`seo_meta_description`, `Celebrity`.`slug`, `Celebrity`.`tags`, `Celebrity`.`region`, `Celebrity`.`category`, `Celebrity`.`type`, `Celebrity`.`related`, `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`.`celebrities` AS `Celebrity` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Celebrity`.`id` AND `Image`.`object_type` = 'celebrity') WHERE `Celebrity`.`status` = '1' AND `Celebrity`.`publish_at` <= NOW() AND (`Celebrity`.`unpublish_at` IS NULL OR `Celebrity`.`unpublish_at` > NOW()) AND `Celebrity`.`type` LIKE "%generation-t%" AND `Celebrity`.`slug` = 'Zhou-yuan' LIMIT 1 | 1 | 1 | 4 | 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` = 696 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 4 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `at_cn`.`celebrities` AS `Celebrity` WHERE `Celebrity`.`id` = 696 | 1 | 1 | 4 | maybe slow |
| SELECT `Celebrity`.`id`, `Celebrity`.`created`, `Celebrity`.`modified`, `Celebrity`.`status`, `Celebrity`.`publish_at`, `Celebrity`.`unpublish_at`, `Celebrity`.`name`, `Celebrity`.`last_name`, `Celebrity`.`description`, `Celebrity`.`ref_id`, `Celebrity`.`new_entry_2013`, `Celebrity`.`seo_meta_keywords`, `Celebrity`.`seo_meta_description`, `Celebrity`.`slug`, `Celebrity`.`tags`, `Celebrity`.`region`, `Celebrity`.`category`, `Celebrity`.`type`, `Celebrity`.`related`, `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`.`celebrities` AS `Celebrity` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Celebrity`.`id` AND `Image`.`object_type` = 'celebrity') WHERE `Celebrity`.`status` = '1' AND `Celebrity`.`publish_at` <= NOW() AND (`Celebrity`.`unpublish_at` IS NULL OR `Celebrity`.`unpublish_at` > NOW()) AND `Celebrity`.`type` LIKE "%generation-t%" AND ((`Celebrity`.`last_name` < "Zhou") OR (((`Celebrity`.`last_name` = 'Zhou') AND (`Celebrity`.`name` < "周圆")))) ORDER BY `Celebrity`.`last_name` DESC, `Celebrity`.`name` DESC LIMIT 1 | 1 | 1 | 5 | 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` = 694 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 4 | maybe slow |
| SELECT `Celebrity`.`id`, `Celebrity`.`created`, `Celebrity`.`modified`, `Celebrity`.`status`, `Celebrity`.`publish_at`, `Celebrity`.`unpublish_at`, `Celebrity`.`name`, `Celebrity`.`last_name`, `Celebrity`.`description`, `Celebrity`.`ref_id`, `Celebrity`.`new_entry_2013`, `Celebrity`.`seo_meta_keywords`, `Celebrity`.`seo_meta_description`, `Celebrity`.`slug`, `Celebrity`.`tags`, `Celebrity`.`region`, `Celebrity`.`category`, `Celebrity`.`type`, `Celebrity`.`related`, `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`.`celebrities` AS `Celebrity` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Celebrity`.`id` AND `Image`.`object_type` = 'celebrity') WHERE `Celebrity`.`status` = '1' AND `Celebrity`.`publish_at` <= NOW() AND (`Celebrity`.`unpublish_at` IS NULL OR `Celebrity`.`unpublish_at` > NOW()) AND `Celebrity`.`type` LIKE "%generation-t%" AND ((`Celebrity`.`last_name` > "Zhou") OR (((`Celebrity`.`last_name` = 'Zhou') AND (`Celebrity`.`name` > "周圆")))) ORDER BY `Celebrity`.`last_name` ASC, `Celebrity`.`name` ASC LIMIT 1 | 1 | 1 | 4 | 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` = 693 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 4 | maybe slow |
| SELECT `Celebrity`.`id`, `Celebrity`.`created`, `Celebrity`.`modified`, `Celebrity`.`status`, `Celebrity`.`publish_at`, `Celebrity`.`unpublish_at`, `Celebrity`.`name`, `Celebrity`.`last_name`, `Celebrity`.`description`, `Celebrity`.`ref_id`, `Celebrity`.`new_entry_2013`, `Celebrity`.`seo_meta_keywords`, `Celebrity`.`seo_meta_description`, `Celebrity`.`slug`, `Celebrity`.`tags`, `Celebrity`.`region`, `Celebrity`.`category`, `Celebrity`.`type`, `Celebrity`.`related`, `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`.`celebrities` AS `Celebrity` LEFT JOIN `at_cn`.`images` AS `Image` ON (`Image`.`object_id` = `Celebrity`.`id` AND `Image`.`object_type` = 'celebrity') WHERE `Celebrity`.`status` = '1' AND `Celebrity`.`publish_at` <= NOW() AND (`Celebrity`.`unpublish_at` IS NULL OR `Celebrity`.`unpublish_at` > NOW()) AND `Celebrity`.`type` LIKE "%generation-t%" ORDER BY RAND() ASC LIMIT 4 | 4 | 4 | 9 | 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 (1027, 919, 599, 665) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 4 | maybe slow |
