SELECT `housing_color_new_idx`.`value`, COUNT(housing_color_new_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `mgop_catalog_product_index_eav` AS `housing_color_new_idx` ON housing_color_new_idx.entity_id = e.entity_id AND housing_color_new_idx.attribute_id = '184' AND housing_color_new_idx.store_id = '1' GROUP BY `housing_color_new_idx`.`value`
SELECT `lens_color_new_idx`.`value`, COUNT(lens_color_new_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `mgop_catalog_product_index_eav` AS `lens_color_new_idx` ON lens_color_new_idx.entity_id = e.entity_id AND lens_color_new_idx.attribute_id = '185' AND lens_color_new_idx.store_id = '1' GROUP BY `lens_color_new_idx`.`value`
SELECT `manufacturer_idx`.`value`, COUNT(manufacturer_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `mgop_catalog_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '81' AND manufacturer_idx.store_id = '1' GROUP BY `manufacturer_idx`.`value`
SELECT `mgop_magebees_finder`.* FROM `mgop_magebees_finder` WHERE (`mgop_magebees_finder`.`finder_id`='1')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='3055')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='3045')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1268')
SELECT `main_table`.* FROM `mgop_magebees_finder_dropdowns` AS `main_table` WHERE (`finder_id` = '1')
SELECT `mgop_magebees_finder_map_value`.* FROM `mgop_magebees_finder_map_value` WHERE (`mgop_magebees_finder_map_value`.`ymm_value_id`='3055')
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `stock_status_index`.`stock_status` AS `is_salable` FROM `mgop_catalog_product_flat_1` AS `e`
LEFT JOIN `mgop_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (e.sku IN('211029', '211163', '211031'))
SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '995') ORDER BY `qty` ASC
SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('995'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '995')
SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '997') ORDER BY `qty` ASC
SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('997'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '997')
SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '996') ORDER BY `qty` ASC
SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('996'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '996')
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 995)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 997)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 996)
SELECT `main_table`.* FROM `mgop_cataloginventory_stock` AS `main_table`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e36d46936_82362855` (
`entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
`score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' ,
PRIMARY KEY (`entity_id`)
) COMMENT='mgop_search_tmp_669a4e36d46936_82362855' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
INSERT INTO `mgop_search_tmp_669a4e36d46936_82362855` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `mgop_catalog_product_index_eav` AS `search_index`
INNER JOIN `mgop_cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1
INNER JOIN `mgop_catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1'
INNER JOIN `mgop_catalog_product_entity` AS `sku_filter` ON search_index.entity_id = `sku_filter`.`entity_id` WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 102 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id in ('2')) AND (`sku_filter`.`sku` IN ('211029', '211163', '211031'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
LIMIT 10000
SELECT `mgop_search_tmp_669a4e36d46936_82362855`.`entity_id`, `mgop_search_tmp_669a4e36d46936_82362855`.`score` FROM `mgop_search_tmp_669a4e36d46936_82362855`
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='2')
SELECT `e`.`attribute_set_id` FROM `mgop_catalog_product_flat_1` AS `e` WHERE (entity_id IN (997, 996, 995)) GROUP BY `attribute_set_id`
SELECT `main_table`.`attribute_code` FROM `mgop_eav_attribute` AS `main_table`
INNER JOIN `mgop_catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
INNER JOIN `mgop_eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN('4')) GROUP BY `main_table`.`attribute_id`
SELECT count(main_table.entity_id) AS `count`, MAX(min_price) AS `max`, MIN(min_price) AS `min`, STDDEV_SAMP(min_price) AS `std` FROM `mgop_catalog_product_index_price` AS `main_table` WHERE (main_table.entity_id in (select entity_id from mgop_search_tmp_669a4e36d46936_82362855)) AND (customer_group_id = 0) AND (main_table.website_id = '1')
SELECT IFNULL(FLOOR(min_price / 10 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC
SELECT IFNULL(FLOOR(min_price / 10 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC
SELECT `main_table`.*, count(main_table.value) AS `count` FROM (SELECT `main_table`.`category_id` AS `value` FROM `mgop_catalog_category_product_index_store1` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.product_id = entities.entity_id
INNER JOIN `mgop_catalog_category_entity` AS `category` ON main_table.category_id = category.entity_id WHERE (main_table.store_id = '1') AND (`category`.`path` LIKE '1/2%') AND (`category`.`level` > '1')) AS `main_table` GROUP BY `value`
SELECT `mgop_eav_attribute`.* FROM `mgop_eav_attribute` WHERE (`mgop_eav_attribute`.`attribute_code`='color') AND (entity_type_id = :entity_type_id)
SELECT `mgop_eav_entity_type`.`additional_attribute_table` FROM `mgop_eav_entity_type` WHERE (entity_type_id = :entity_type_id)
SELECT `mgop_catalog_eav_attribute`.* FROM `mgop_catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 92) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 183) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 184) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 185) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `mgop_eav_attribute`.* FROM `mgop_eav_attribute` WHERE (`mgop_eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)
SELECT `mgop_catalog_eav_attribute`.* FROM `mgop_catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e36d46936_82362855` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 81) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT COUNT(*) FROM (SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `mgop_catalog_product_index_eav` AS `search_index`
INNER JOIN `mgop_cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1
INNER JOIN `mgop_catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1'
INNER JOIN `mgop_catalog_product_entity` AS `sku_filter` ON search_index.entity_id = `sku_filter`.`entity_id` WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 102 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id in ('2')) AND (`sku_filter`.`sku` IN ('211029', '211163', '211031'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
) AS `core_select`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e36dca916_42035816` (
`entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
`score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' ,
PRIMARY KEY (`entity_id`)
) COMMENT='mgop_search_tmp_669a4e36dca916_42035816' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
INSERT INTO `mgop_search_tmp_669a4e36dca916_42035816` (`entity_id`,`score`) VALUES (?, ?), (?, ?), (?, ?)
SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(price_index.min_price ) * 1, 2) AS `max`, ROUND(MIN(price_index.min_price ) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((price_index.min_price ) * 1, 2)) AS `std` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (price_index.min_price IS NOT NULL)
SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `mgop_catalog_product_index_price` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ORDER BY (FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1) ASC
SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `mgop_catalog_product_index_price` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ORDER BY (FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1) ASC