Query | Affected | Num. rows | Took (ms) | Actions |
---|
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 "%300list%" AND `Celebrity`.`slug` = 'Mao Danqing' 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` = 192 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `at_cn`.`celebrities` AS `Celebrity` WHERE `Celebrity`.`id` = 192 | 1 | 1 | 3 | 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 "%300list%" AND ((`Celebrity`.`last_name` < "Mao") OR (((`Celebrity`.`last_name` = 'Mao') AND (`Celebrity`.`name` < "毛丹青")))) ORDER BY `Celebrity`.`last_name` DESC, `Celebrity`.`name` DESC 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` = 745 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 3 | 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 "%300list%" AND ((`Celebrity`.`last_name` > "Mao") OR (((`Celebrity`.`last_name` = 'Mao') 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` = 193 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 3 | 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 "%300list%" ORDER BY RAND() ASC LIMIT 4 | 4 | 4 | 10 | 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 (805, 17, 828, 219) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Celebrity' | 0 | 0 | 3 | maybe slow |