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 `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`, `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`, `JewelryModel`.`id`, `JewelryModel`.`name`, `JewelryModel`.`jewelry_brand_id`, `JewelryModel`.`order` FROM `yamashiro`.`jewelries` AS `Jewelry` LEFT JOIN `yamashiro`.`jewelry_brands` AS `JewelryBrand` ON (`Jewelry`.`jewelry_brand_id` = `JewelryBrand`.`id`) LEFT JOIN `yamashiro`.`jewelry_models` AS `JewelryModel` ON (`Jewelry`.`jewelry_model_id` = `JewelryModel`.`id`) WHERE `Jewelry`.`slug` = 'jewelry-k18-shisaring-diamond' AND `Jewelry`.`enabled` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Store`.`id`, `Store`.`name`, `JewelryStore`.`id`, `JewelryStore`.`jewelry_id`, `JewelryStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`jewelry_stores` AS `JewelryStore` ON (`JewelryStore`.`jewelry_id` = 517 AND `JewelryStore`.`store_id` = `Store`.`id`) | 2 | 2 | 0 | |
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`, `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`, `JewelryModel`.`id`, `JewelryModel`.`name`, `JewelryModel`.`jewelry_brand_id`, `JewelryModel`.`order` FROM `yamashiro`.`jewelries` AS `Jewelry` LEFT JOIN `yamashiro`.`jewelry_brands` AS `JewelryBrand` ON (`Jewelry`.`jewelry_brand_id` = `JewelryBrand`.`id`) LEFT JOIN `yamashiro`.`jewelry_models` AS `JewelryModel` ON (`Jewelry`.`jewelry_model_id` = `JewelryModel`.`id`) WHERE `Jewelry`.`enabled` = '1' AND `Jewelry`.`id` < 517 ORDER BY `Jewelry`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `JewelryStore`.`id`, `JewelryStore`.`jewelry_id`, `JewelryStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`jewelry_stores` AS `JewelryStore` ON (`JewelryStore`.`jewelry_id` = 516 AND `JewelryStore`.`store_id` = `Store`.`id`) | 2 | 2 | 0 | |
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`, `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`, `JewelryModel`.`id`, `JewelryModel`.`name`, `JewelryModel`.`jewelry_brand_id`, `JewelryModel`.`order` FROM `yamashiro`.`jewelries` AS `Jewelry` LEFT JOIN `yamashiro`.`jewelry_brands` AS `JewelryBrand` ON (`Jewelry`.`jewelry_brand_id` = `JewelryBrand`.`id`) LEFT JOIN `yamashiro`.`jewelry_models` AS `JewelryModel` ON (`Jewelry`.`jewelry_model_id` = `JewelryModel`.`id`) WHERE `Jewelry`.`enabled` = '1' AND `Jewelry`.`id` >= 516 AND `Jewelry`.`id` != 517 ORDER BY `Jewelry`.`id` ASC LIMIT 2 | 2 | 2 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `JewelryStore`.`id`, `JewelryStore`.`jewelry_id`, `JewelryStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`jewelry_stores` AS `JewelryStore` ON (`JewelryStore`.`jewelry_id` IN (516, 519) AND `JewelryStore`.`store_id` = `Store`.`id`) | 3 | 3 | 0 | |
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`, `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`, `JewelryModel`.`id`, `JewelryModel`.`name`, `JewelryModel`.`jewelry_brand_id`, `JewelryModel`.`order` FROM `yamashiro`.`jewelries` AS `Jewelry` LEFT JOIN `yamashiro`.`jewelry_brands` AS `JewelryBrand` ON (`Jewelry`.`jewelry_brand_id` = `JewelryBrand`.`id`) LEFT JOIN `yamashiro`.`jewelry_models` AS `JewelryModel` ON (`Jewelry`.`jewelry_model_id` = `JewelryModel`.`id`) WHERE `Jewelry`.`recommend` = '1' AND `Jewelry`.`enabled` = '1' ORDER BY rand() ASC LIMIT 4 | 0 | 0 | 2 | maybe slow |