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 `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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`slug` = 'mariage-ent' AND `BridalBrand`.`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` FROM `yamashiro`.`bridals` AS `Bridal` WHERE `Bridal`.`enabled` = '1' AND `Bridal`.`bridal_brand_id` = (4) ORDER BY `Bridal`.`order` DESC | 37 | 37 | 1 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 59 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 59 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 59 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 59 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 59 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 14 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 13 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 47 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 1 | 1 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`id` = 19 | 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` IN (519, 520, 521, 522, 523, 93, 861, 94, 862, 96, 97, 98, 99, 100, 102, 116, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 442, 443, 444, 445) AND `BridalsStore`.`store_id` = `Store`.`id`) | 37 | 37 | 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` IN (519, 520, 521, 522, 523, 93, 861, 94, 862, 96, 97, 98, 99, 100, 102, 116, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 442, 443, 444, 445) AND `BridalsBridalDesign`.`bridal_design_id` = `BridalDesign`.`id`) | 59 | 59 | 0 | |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`bridal_brand_id` = (4) ORDER BY `BridalModel`.`order` DESC | 4 | 4 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 4 | 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` FROM `yamashiro`.`bridals` AS `Bridal` WHERE `Bridal`.`enabled` = '1' AND `Bridal`.`bridal_model_id` IN (59, 13, 47, 19) ORDER BY `Bridal`.`order` DESC | 36 | 36 | 1 | |
SELECT `Store`.`id`, `Store`.`name`, `BridalBrandsStore`.`id`, `BridalBrandsStore`.`bridal_brand_id`, `BridalBrandsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`bridal_brands_stores` AS `BridalBrandsStore` ON (`BridalBrandsStore`.`bridal_brand_id` = 4 AND `BridalBrandsStore`.`store_id` = `Store`.`id`) | 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`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro`.`watches` AS `Watch` JOIN `yamashiro`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`store_id` = 4 AND `WatchesStore`.`watch_id` = `Watch`.`id`) | 505 | 505 | 5 | |
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` = 4 AND `BridalsStore`.`bridal_id` = `Bridal`.`id`) | 431 | 431 | 4 | |
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` = 4 AND `JewelryStore`.`jewelry_id` = `Jewelry`.`id`) | 381 | 381 | 4 | |
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`, `WatchBrandsStore`.`id`, `WatchBrandsStore`.`watch_brand_id`, `WatchBrandsStore`.`store_id` FROM `yamashiro`.`watch_brands` AS `WatchBrand` JOIN `yamashiro`.`watch_brands_stores` AS `WatchBrandsStore` ON (`WatchBrandsStore`.`store_id` = 4 AND `WatchBrandsStore`.`watch_brand_id` = `WatchBrand`.`id`) | 20 | 20 | 0 | |
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` = 4 AND `JewelryBrandsStore`.`jewelry_brand_id` = `JewelryBrand`.`id`) | 4 | 4 | 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`.`bridal_brand_id` = 4 AND `is_brand_pickupable` = '1' ORDER BY `Bridal`.`order_brand_pickup` desc, `Bridal`.`order` desc | 0 | 0 | 1 | maybe slow |
72 duplicate queries run.