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`='1588')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1573')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1572')
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`='1588')
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('858001', '858002', '861061 -Edited on 2013-04-02', '861062 -Edited on 2013-04-02', '531048 -Edited on 2013-04-02', '531049 -Edited on 2013-04-02', '531051 -Edited on 2013-04-02', '531054', '531058 -Edited on 2013-04-02', '531059 -Edited on 2013-01-16', '531060', '531061', '531005 -Edited on 2013-01-16', '531045 -Edited on 2013-01-16', '531006 -Edited on 2013-01-16', '851009', '851010', '531044 -Edited on 2013-01-11', '111074 ', '851011', '851012', '851017', '851018', '851019', '851021', '851022', '851023 -Edited on 2013-01-16', '851024 -Edited on 2013-01-25', '821001', '821003', '821004', '821005', '821006', '861071 ', '861072 ', '821002', '861093', '861095', '861096 -Edited on 2013-04-24', '861099', '861110 -Edited on 2013-02-21', '861111', '861112 -Edited on 2013-01-16', '861113 -Edited on 2013-01-16', '881001 -Edited on 2013-03-21', '881002 -Edited on 2013-03-21', '881003', '881004', '881005', '881012', '881013', '881014', '881018 ', '881019 ', '881025 -Edited on 2013-01-16', '881026 -Edited on 2013-01-16', '881028 -Edited on 2013-04-19', '881029 -Edited on 2013-01-16', '881030 -Edited on 2013-01-16', '881031 -Edited on 2013-04-02', '211037', '211039', '221180 -Edited on 2013-02-26', '221180'))
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 = '1010') 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('1010'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '1010')
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 = '1011') 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('1011'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '1011')
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 = '889') 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('889'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '889')
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 = '52') 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('52'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '52')
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 = '878') 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('878'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '878')
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 = '881') 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('881'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '881')
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 = '882') 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('882'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '882')
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 = '901') 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('901'))
SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '901')
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 1010)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 1011)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 889)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 52)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 878)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 881)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 882)
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 901)
SELECT `main_table`.* FROM `mgop_cataloginventory_stock` AS `main_table`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e497cb6e8_64554082` (
`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_669a4e497cb6e8_64554082' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
INSERT INTO `mgop_search_tmp_669a4e497cb6e8_64554082` 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 ('858001', '858002', '861061 -Edited on 2013-04-02', '861062 -Edited on 2013-04-02', '531048 -Edited on 2013-04-02', '531049 -Edited on 2013-04-02', '531051 -Edited on 2013-04-02', '531054', '531058 -Edited on 2013-04-02', '531059 -Edited on 2013-01-16', '531060', '531061', '531005 -Edited on 2013-01-16', '531045 -Edited on 2013-01-16', '531006 -Edited on 2013-01-16', '851009', '851010', '531044 -Edited on 2013-01-11', '111074', '851011', '851012', '851017', '851018', '851019', '851021', '851022', '851023 -Edited on 2013-01-16', '851024 -Edited on 2013-01-25', '821001', '821003', '821004', '821005', '821006', '861071', '861072', '821002', '861093', '861095', '861096 -Edited on 2013-04-24', '861099', '861110 -Edited on 2013-02-21', '861111', '861112 -Edited on 2013-01-16', '861113 -Edited on 2013-01-16', '881001 -Edited on 2013-03-21', '881002 -Edited on 2013-03-21', '881003', '881004', '881005', '881012', '881013', '881014', '881018', '881019', '881025 -Edited on 2013-01-16', '881026 -Edited on 2013-01-16', '881028 -Edited on 2013-04-19', '881029 -Edited on 2013-01-16', '881030 -Edited on 2013-01-16', '881031 -Edited on 2013-04-02', '211037', '211039', '221180 -Edited on 2013-02-26', '221180'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
LIMIT 10000
SELECT `mgop_search_tmp_669a4e497cb6e8_64554082`.`entity_id`, `mgop_search_tmp_669a4e497cb6e8_64554082`.`score` FROM `mgop_search_tmp_669a4e497cb6e8_64554082`
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 (1011, 1010, 901, 889, 882, 881, 878, 52)) 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_669a4e497cb6e8_64554082)) AND (customer_group_id = 0) AND (main_table.website_id = '1')
SELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e497cb6e8_64554082` 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 / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table`
INNER JOIN `mgop_search_tmp_669a4e497cb6e8_64554082` 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_669a4e497cb6e8_64554082` 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_669a4e497cb6e8_64554082` 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_669a4e497cb6e8_64554082` 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_669a4e497cb6e8_64554082` 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_669a4e497cb6e8_64554082` 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_669a4e497cb6e8_64554082` 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 ('858001', '858002', '861061 -Edited on 2013-04-02', '861062 -Edited on 2013-04-02', '531048 -Edited on 2013-04-02', '531049 -Edited on 2013-04-02', '531051 -Edited on 2013-04-02', '531054', '531058 -Edited on 2013-04-02', '531059 -Edited on 2013-01-16', '531060', '531061', '531005 -Edited on 2013-01-16', '531045 -Edited on 2013-01-16', '531006 -Edited on 2013-01-16', '851009', '851010', '531044 -Edited on 2013-01-11', '111074', '851011', '851012', '851017', '851018', '851019', '851021', '851022', '851023 -Edited on 2013-01-16', '851024 -Edited on 2013-01-25', '821001', '821003', '821004', '821005', '821006', '861071', '861072', '821002', '861093', '861095', '861096 -Edited on 2013-04-24', '861099', '861110 -Edited on 2013-02-21', '861111', '861112 -Edited on 2013-01-16', '861113 -Edited on 2013-01-16', '881001 -Edited on 2013-03-21', '881002 -Edited on 2013-03-21', '881003', '881004', '881005', '881012', '881013', '881014', '881018', '881019', '881025 -Edited on 2013-01-16', '881026 -Edited on 2013-01-16', '881028 -Edited on 2013-04-19', '881029 -Edited on 2013-01-16', '881030 -Edited on 2013-01-16', '881031 -Edited on 2013-04-02', '211037', '211039', '221180 -Edited on 2013-02-26', '221180'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
) AS `core_select`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e4981ffb0_89742211` (
`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_669a4e4981ffb0_89742211' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
INSERT INTO `mgop_search_tmp_669a4e4981ffb0_89742211` (`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