| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`name`, `WatchBrand`.`id` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `enabled` = '1' ORDER BY `order` DESC LIMIT 14 | 14 | 14 | 0 | |
| SELECT `BridalBrand`.`slug`, `BridalBrand`.`thumbnail`, `BridalBrand`.`name`, `BridalBrand`.`id` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `enabled` = '1' ORDER BY `order` DESC LIMIT 14 | 14 | 14 | 0 | |
| SELECT `JewelryBrand`.`slug`, `JewelryBrand`.`thumbnail`, `JewelryBrand`.`name`, `JewelryBrand`.`id` FROM `yamashiro`.`jewelry_brands` AS `JewelryBrand` WHERE `enabled` = '1' ORDER BY `order` DESC LIMIT 14 | 9 | 9 | 0 | |
| SELECT `Content`.`id`, `Content`.`name`, `Content`.`content`, `Content`.`type`, `Content`.`enabled` FROM `yamashiro`.`contents` AS `Content` WHERE `Content`.`type` = 'HeadNews' AND `Content`.`enabled` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`slug` = 'seiko-presage' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Watch`.`id`, `Watch`.`slug`, `Watch`.`name`, `Watch`.`image01`, `Watch`.`image02`, `Watch`.`image03`, `Watch`.`image04`, `Watch`.`image05`, `Watch`.`image06`, `Watch`.`image07`, `Watch`.`image08`, `Watch`.`price`, `Watch`.`credit_flg`, `Watch`.`sold_out`, `Watch`.`credit_number`, `Watch`.`credit_amount`, `Watch`.`description`, `Watch`.`new`, `Watch`.`recommend`, `Watch`.`order`, `Watch`.`order_all`, `Watch`.`order_top_pickup`, `Watch`.`order_brand_pickup`, `Watch`.`tag_title`, `Watch`.`tag_description`, `Watch`.`tag_keyword`, `Watch`.`blog_slug_1`, `Watch`.`blog_slug_2`, `Watch`.`blog_slug_3`, `Watch`.`blog_slug_4`, `Watch`.`is_pickupable`, `Watch`.`is_brand_pickupable`, `Watch`.`enabled`, `Watch`.`modified`, `Watch`.`created`, `Watch`.`watch_brand_id`, `Watch`.`watch_model_id` FROM `yamashiro`.`watches` AS `Watch` WHERE `Watch`.`enabled` = '1' AND `Watch`.`watch_brand_id` = (32) ORDER BY `Watch`.`order` DESC | 31 | 31 | 2 | maybe slow |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 335 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 335 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 335 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 113 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 113 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 372 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 372 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 372 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 372 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 372 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 335 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 335 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 363 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 113 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 199 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 113 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 113 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 363 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 363 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 113 | 1 | 1 | 0 | |
| SELECT `Store`.`id`, `Store`.`name`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`watch_id` IN (3746, 3747, 3749, 3750, 3355, 3357, 3358, 3360, 3361, 2871, 3899, 2144, 2145, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3952, 2427, 3486, 3487, 3488, 935, 936, 3753, 4046, 2283) AND `WatchesStore`.`store_id` = `Store`.`id`) | 46 | 46 | 1 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`watch_brand_id` = (32) ORDER BY `WatchModel`.`order` DESC | 6 | 6 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 32 | 1 | 1 | 0 | |
| SELECT `Watch`.`id`, `Watch`.`slug`, `Watch`.`name`, `Watch`.`image01`, `Watch`.`image02`, `Watch`.`image03`, `Watch`.`image04`, `Watch`.`image05`, `Watch`.`image06`, `Watch`.`image07`, `Watch`.`image08`, `Watch`.`price`, `Watch`.`credit_flg`, `Watch`.`sold_out`, `Watch`.`credit_number`, `Watch`.`credit_amount`, `Watch`.`description`, `Watch`.`new`, `Watch`.`recommend`, `Watch`.`order`, `Watch`.`order_all`, `Watch`.`order_top_pickup`, `Watch`.`order_brand_pickup`, `Watch`.`tag_title`, `Watch`.`tag_description`, `Watch`.`tag_keyword`, `Watch`.`blog_slug_1`, `Watch`.`blog_slug_2`, `Watch`.`blog_slug_3`, `Watch`.`blog_slug_4`, `Watch`.`is_pickupable`, `Watch`.`is_brand_pickupable`, `Watch`.`enabled`, `Watch`.`modified`, `Watch`.`created`, `Watch`.`watch_brand_id`, `Watch`.`watch_model_id` FROM `yamashiro`.`watches` AS `Watch` WHERE `Watch`.`enabled` = '1' AND `Watch`.`watch_model_id` IN (199, 112, 113, 335, 363, 372) ORDER BY `Watch`.`order` DESC | 31 | 31 | 2 | maybe slow |
| SELECT `Store`.`id`, `Store`.`name`, `WatchBrandsStore`.`id`, `WatchBrandsStore`.`watch_brand_id`, `WatchBrandsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`watch_brands_stores` AS `WatchBrandsStore` ON (`WatchBrandsStore`.`watch_brand_id` = 32 AND `WatchBrandsStore`.`store_id` = `Store`.`id`) | 4 | 4 | 0 | |
| SELECT `Watch`.`id`, `Watch`.`slug`, `Watch`.`name`, `Watch`.`image01`, `Watch`.`image02`, `Watch`.`image03`, `Watch`.`image04`, `Watch`.`image05`, `Watch`.`image06`, `Watch`.`image07`, `Watch`.`image08`, `Watch`.`price`, `Watch`.`credit_flg`, `Watch`.`sold_out`, `Watch`.`credit_number`, `Watch`.`credit_amount`, `Watch`.`description`, `Watch`.`new`, `Watch`.`recommend`, `Watch`.`order`, `Watch`.`order_all`, `Watch`.`order_top_pickup`, `Watch`.`order_brand_pickup`, `Watch`.`tag_title`, `Watch`.`tag_description`, `Watch`.`tag_keyword`, `Watch`.`blog_slug_1`, `Watch`.`blog_slug_2`, `Watch`.`blog_slug_3`, `Watch`.`blog_slug_4`, `Watch`.`is_pickupable`, `Watch`.`is_brand_pickupable`, `Watch`.`enabled`, `Watch`.`modified`, `Watch`.`created`, `Watch`.`watch_brand_id`, `Watch`.`watch_model_id`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro`.`watches` AS `Watch` JOIN `yamashiro`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`store_id` IN (1, 3, 4, 5) AND `WatchesStore`.`watch_id` = `Watch`.`id`) | 2835 | 2835 | 23 | |
| SELECT `Bridal`.`id`, `Bridal`.`name`, `Bridal`.`slug`, `Bridal`.`image01`, `Bridal`.`image02`, `Bridal`.`image03`, `Bridal`.`image04`, `Bridal`.`image05`, `Bridal`.`image06`, `Bridal`.`image07`, `Bridal`.`image08`, `Bridal`.`price`, `Bridal`.`credit_flg`, `Bridal`.`sold_out`, `Bridal`.`credit_number`, `Bridal`.`credit_amount`, `Bridal`.`description`, `Bridal`.`new`, `Bridal`.`recommend`, `Bridal`.`order`, `Bridal`.`order_all`, `Bridal`.`order_top_pickup`, `Bridal`.`order_brand_pickup`, `Bridal`.`tag_title`, `Bridal`.`tag_description`, `Bridal`.`tag_keyword`, `Bridal`.`blog_slug_1`, `Bridal`.`blog_slug_2`, `Bridal`.`blog_slug_3`, `Bridal`.`blog_slug_4`, `Bridal`.`is_pickupable`, `Bridal`.`is_brand_pickupable`, `Bridal`.`is_marriage`, `Bridal`.`is_engagement`, `Bridal`.`enabled`, `Bridal`.`modified`, `Bridal`.`created`, `Bridal`.`bridal_brand_id`, `Bridal`.`bridal_model_id`, `BridalsStore`.`id`, `BridalsStore`.`bridal_id`, `BridalsStore`.`store_id` FROM `yamashiro`.`bridals` AS `Bridal` JOIN `yamashiro`.`bridals_stores` AS `BridalsStore` ON (`BridalsStore`.`store_id` IN (1, 3, 4, 5) AND `BridalsStore`.`bridal_id` = `Bridal`.`id`) | 1730 | 1730 | 12 | |
| SELECT `Jewelry`.`id`, `Jewelry`.`slug`, `Jewelry`.`name`, `Jewelry`.`image01`, `Jewelry`.`image02`, `Jewelry`.`image03`, `Jewelry`.`image04`, `Jewelry`.`image05`, `Jewelry`.`image06`, `Jewelry`.`image07`, `Jewelry`.`image08`, `Jewelry`.`price`, `Jewelry`.`credit_flg`, `Jewelry`.`sold_out`, `Jewelry`.`credit_number`, `Jewelry`.`credit_amount`, `Jewelry`.`description`, `Jewelry`.`new`, `Jewelry`.`recommend`, `Jewelry`.`order`, `Jewelry`.`order_all`, `Jewelry`.`order_top_pickup`, `Jewelry`.`order_brand_pickup`, `Jewelry`.`tag_title`, `Jewelry`.`tag_description`, `Jewelry`.`tag_keyword`, `Jewelry`.`blog_slug_1`, `Jewelry`.`blog_slug_2`, `Jewelry`.`blog_slug_3`, `Jewelry`.`blog_slug_4`, `Jewelry`.`is_pickupable`, `Jewelry`.`is_brand_pickupable`, `Jewelry`.`enabled`, `Jewelry`.`modified`, `Jewelry`.`created`, `Jewelry`.`jewelry_brand_id`, `Jewelry`.`jewelry_model_id`, `JewelryStore`.`id`, `JewelryStore`.`jewelry_id`, `JewelryStore`.`store_id` FROM `yamashiro`.`jewelries` AS `Jewelry` JOIN `yamashiro`.`jewelry_stores` AS `JewelryStore` ON (`JewelryStore`.`store_id` IN (1, 3, 4, 5) AND `JewelryStore`.`jewelry_id` = `Jewelry`.`id`) | 1413 | 1413 | 12 | |
| SELECT `BridalBrand`.`id`, `BridalBrand`.`name`, `BridalBrand`.`slug`, `BridalBrand`.`thumbnail`, `BridalBrand`.`cover_images`, `BridalBrand`.`banner`, `BridalBrand`.`banner_text`, `BridalBrand`.`campaign_text`, `BridalBrand`.`order`, `BridalBrand`.`tag_title`, `BridalBrand`.`tag_description`, `BridalBrand`.`tag_keyword`, `BridalBrand`.`enabled`, `BridalBrandsStore`.`id`, `BridalBrandsStore`.`bridal_brand_id`, `BridalBrandsStore`.`store_id` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` JOIN `yamashiro`.`bridal_brands_stores` AS `BridalBrandsStore` ON (`BridalBrandsStore`.`store_id` IN (1, 3, 4, 5) AND `BridalBrandsStore`.`bridal_brand_id` = `BridalBrand`.`id`) | 49 | 49 | 1 | |
| SELECT `JewelryBrand`.`id`, `JewelryBrand`.`name`, `JewelryBrand`.`slug`, `JewelryBrand`.`thumbnail`, `JewelryBrand`.`cover_images`, `JewelryBrand`.`banner`, `JewelryBrand`.`banner_text`, `JewelryBrand`.`campaign_text`, `JewelryBrand`.`order`, `JewelryBrand`.`tag_title`, `JewelryBrand`.`tag_description`, `JewelryBrand`.`tag_keyword`, `JewelryBrand`.`enabled`, `JewelryBrandsStore`.`id`, `JewelryBrandsStore`.`jewelry_brand_id`, `JewelryBrandsStore`.`store_id` FROM `yamashiro`.`jewelry_brands` AS `JewelryBrand` JOIN `yamashiro`.`jewelry_brands_stores` AS `JewelryBrandsStore` ON (`JewelryBrandsStore`.`store_id` IN (1, 3, 4, 5) AND `JewelryBrandsStore`.`jewelry_brand_id` = `JewelryBrand`.`id`) | 18 | 18 | 0 | |
| SELECT `Watch`.`id`, `Watch`.`slug`, `Watch`.`name`, `Watch`.`image01`, `Watch`.`image02`, `Watch`.`image03`, `Watch`.`image04`, `Watch`.`image05`, `Watch`.`image06`, `Watch`.`image07`, `Watch`.`image08`, `Watch`.`price`, `Watch`.`credit_flg`, `Watch`.`sold_out`, `Watch`.`credit_number`, `Watch`.`credit_amount`, `Watch`.`description`, `Watch`.`new`, `Watch`.`recommend`, `Watch`.`order`, `Watch`.`order_all`, `Watch`.`order_top_pickup`, `Watch`.`order_brand_pickup`, `Watch`.`tag_title`, `Watch`.`tag_description`, `Watch`.`tag_keyword`, `Watch`.`blog_slug_1`, `Watch`.`blog_slug_2`, `Watch`.`blog_slug_3`, `Watch`.`blog_slug_4`, `Watch`.`is_pickupable`, `Watch`.`is_brand_pickupable`, `Watch`.`enabled`, `Watch`.`modified`, `Watch`.`created`, `Watch`.`watch_brand_id`, `Watch`.`watch_model_id`, `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled`, `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watches` AS `Watch` LEFT JOIN `yamashiro`.`watch_brands` AS `WatchBrand` ON (`Watch`.`watch_brand_id` = `WatchBrand`.`id`) LEFT JOIN `yamashiro`.`watch_models` AS `WatchModel` ON (`Watch`.`watch_model_id` = `WatchModel`.`id`) WHERE `Watch`.`watch_brand_id` = 32 AND `Watch`.`is_brand_pickupable` = '1' ORDER BY `Watch`.`order_brand_pickup` desc, `Watch`.`order` desc | 2 | 2 | 2 | |
| SELECT `Store`.`id`, `Store`.`name`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`watch_id` IN (3747, 3749) AND `WatchesStore`.`store_id` = `Store`.`id`) | 0 | 0 | 1 | maybe slow |
62 duplicate queries run.
