Query | Affected | Num. rows | Took (ms) | Actions |
---|
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`.`status` = '1' AND `Product`.`publish_at` <= NOW() AND (`Product`.`unpublish_at` IS NULL OR `Product`.`unpublish_at` > NOW()) AND `Product`.`slug` = 'hamilton-ventura-xxl-elvis-anniversary-watch' ORDER BY `Product`.`publish_at` DESC LIMIT 1 | 1 | 1 | 4 | maybe slow |
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`.`id` = 213 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`.`status` = '1' AND `Product`.`publish_at` <= NOW() AND (`Product`.`unpublish_at` IS NULL OR `Product`.`unpublish_at` > NOW()) AND `Product`.`id` < 2583 ORDER BY `Product`.`id` DESC LIMIT 1 | 1 | 1 | 4 | 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`.`status` = '1' AND `Product`.`publish_at` <= NOW() AND (`Product`.`unpublish_at` IS NULL OR `Product`.`unpublish_at` > NOW()) AND `Product`.`id` >= 2582 AND `Product`.`id` != 2583 ORDER BY `Product`.`id` ASC LIMIT 2 | 2 | 2 | 4 | 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 2 | 2 | 2 | 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` IN (86, 85) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'ShoppingTheme' | 4 | 4 | 4 | |
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`.`status` = '1' AND `Product`.`publish_at` <= NOW() AND (`Product`.`unpublish_at` IS NULL OR `Product`.`unpublish_at` > NOW()) AND NOT (`Product`.`id` = 2583) AND `Product`.`brand_id` = 213 ORDER BY `Product`.`publish_at` DESC LIMIT 4 | 2 | 2 | 4 | 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`.`status` = '1' AND `Product`.`publish_at` <= NOW() AND (`Product`.`unpublish_at` IS NULL OR `Product`.`unpublish_at` > NOW()) AND NOT (`Product`.`id` = 2583) AND `Product`.`category` = 'watch' ORDER BY `Product`.`publish_at` DESC LIMIT 4 | 4 | 4 | 4 | |