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 `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`, `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`, `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridals` AS `Bridal` LEFT JOIN `yamashiro`.`bridal_brands` AS `BridalBrand` ON (`Bridal`.`bridal_brand_id` = `BridalBrand`.`id`) LEFT JOIN `yamashiro`.`bridal_models` AS `BridalModel` ON (`Bridal`.`bridal_model_id` = `BridalModel`.`id`) WHERE `Bridal`.`slug` = 'pilot-bridal-tomorrow-marriage-ring' AND `Bridal`.`enabled` = '1' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`name`, `BridalsStore`.`id`, `BridalsStore`.`bridal_id`, `BridalsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`bridals_stores` AS `BridalsStore` ON (`BridalsStore`.`bridal_id` = 911 AND `BridalsStore`.`store_id` = `Store`.`id`) | 1 | 1 | 1 | |
SELECT `BridalDesign`.`id`, `BridalDesign`.`name`, `BridalsBridalDesign`.`id`, `BridalsBridalDesign`.`bridal_id`, `BridalsBridalDesign`.`bridal_design_id` FROM `yamashiro`.`bridal_designs` AS `BridalDesign` JOIN `yamashiro`.`bridals_bridal_designs` AS `BridalsBridalDesign` ON (`BridalsBridalDesign`.`bridal_id` = 911 AND `BridalsBridalDesign`.`bridal_design_id` = `BridalDesign`.`id`) | 1 | 1 | 0 | |
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`, `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`, `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridals` AS `Bridal` LEFT JOIN `yamashiro`.`bridal_brands` AS `BridalBrand` ON (`Bridal`.`bridal_brand_id` = `BridalBrand`.`id`) LEFT JOIN `yamashiro`.`bridal_models` AS `BridalModel` ON (`Bridal`.`bridal_model_id` = `BridalModel`.`id`) WHERE `Bridal`.`enabled` = '1' AND `Bridal`.`id` < 911 ORDER BY `Bridal`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `BridalsStore`.`id`, `BridalsStore`.`bridal_id`, `BridalsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`bridals_stores` AS `BridalsStore` ON (`BridalsStore`.`bridal_id` = 910 AND `BridalsStore`.`store_id` = `Store`.`id`) | 1 | 1 | 1 | |
SELECT `BridalDesign`.`id`, `BridalDesign`.`name`, `BridalsBridalDesign`.`id`, `BridalsBridalDesign`.`bridal_id`, `BridalsBridalDesign`.`bridal_design_id` FROM `yamashiro`.`bridal_designs` AS `BridalDesign` JOIN `yamashiro`.`bridals_bridal_designs` AS `BridalsBridalDesign` ON (`BridalsBridalDesign`.`bridal_id` = 910 AND `BridalsBridalDesign`.`bridal_design_id` = `BridalDesign`.`id`) | 1 | 1 | 0 | |
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`, `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`, `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridals` AS `Bridal` LEFT JOIN `yamashiro`.`bridal_brands` AS `BridalBrand` ON (`Bridal`.`bridal_brand_id` = `BridalBrand`.`id`) LEFT JOIN `yamashiro`.`bridal_models` AS `BridalModel` ON (`Bridal`.`bridal_model_id` = `BridalModel`.`id`) WHERE `Bridal`.`enabled` = '1' AND `Bridal`.`id` >= 910 AND `Bridal`.`id` != 911 ORDER BY `Bridal`.`id` ASC LIMIT 2 | 2 | 2 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `BridalsStore`.`id`, `BridalsStore`.`bridal_id`, `BridalsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`bridals_stores` AS `BridalsStore` ON (`BridalsStore`.`bridal_id` IN (910, 913) AND `BridalsStore`.`store_id` = `Store`.`id`) | 3 | 3 | 1 | maybe slow |
SELECT `BridalDesign`.`id`, `BridalDesign`.`name`, `BridalsBridalDesign`.`id`, `BridalsBridalDesign`.`bridal_id`, `BridalsBridalDesign`.`bridal_design_id` FROM `yamashiro`.`bridal_designs` AS `BridalDesign` JOIN `yamashiro`.`bridals_bridal_designs` AS `BridalsBridalDesign` ON (`BridalsBridalDesign`.`bridal_id` IN (910, 913) AND `BridalsBridalDesign`.`bridal_design_id` = `BridalDesign`.`id`) | 2 | 2 | 0 | |
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`, `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`, `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridals` AS `Bridal` LEFT JOIN `yamashiro`.`bridal_brands` AS `BridalBrand` ON (`Bridal`.`bridal_brand_id` = `BridalBrand`.`id`) LEFT JOIN `yamashiro`.`bridal_models` AS `BridalModel` ON (`Bridal`.`bridal_model_id` = `BridalModel`.`id`) WHERE `Bridal`.`recommend` = '1' AND `Bridal`.`enabled` = '1' ORDER BY rand() ASC LIMIT 4 | 4 | 4 | 2 | maybe slow |
SELECT `Store`.`id`, `Store`.`name`, `BridalsStore`.`id`, `BridalsStore`.`bridal_id`, `BridalsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`bridals_stores` AS `BridalsStore` ON (`BridalsStore`.`bridal_id` IN (697, 68, 731, 1) AND `BridalsStore`.`store_id` = `Store`.`id`) | 6 | 6 | 1 | maybe slow |
SELECT `BridalDesign`.`id`, `BridalDesign`.`name`, `BridalsBridalDesign`.`id`, `BridalsBridalDesign`.`bridal_id`, `BridalsBridalDesign`.`bridal_design_id` FROM `yamashiro`.`bridal_designs` AS `BridalDesign` JOIN `yamashiro`.`bridals_bridal_designs` AS `BridalsBridalDesign` ON (`BridalsBridalDesign`.`bridal_id` IN (697, 68, 731, 1) AND `BridalsBridalDesign`.`bridal_design_id` = `BridalDesign`.`id`) | 7 | 7 | 0 | |