Magento Profiler

connect

SET NAMES utf8

SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN (:path0, :path1)) AND (store_id IN(0, 1))

SELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = :store_id) AND (date_from <= :required_date or date_from IS NULL) AND (date_to >= :required_date or date_to IS NULL)

SELECT `index_process`.* FROM `index_process` WHERE (`index_process`.`indexer_code`='catalog_category_flat')

SELECT IS_USED_LOCK(?);

SELECT `catalog_category_flat_store_1`.`entity_id` FROM `catalog_category_flat_store_1` LIMIT 1

SELECT `catalog_category_flat_store_1`.* FROM `catalog_category_flat_store_1` WHERE (`catalog_category_flat_store_1`.`entity_id`=22)

SELECT `main_table`.* FROM `catalog_category_flat_store_1` AS `main_table` WHERE (entity_id IN ('22', '619', '2', '1')) AND (custom_use_parent_settings = 0) AND (`level` != 0) ORDER BY `level` DESC

SELECT COUNT(catalog_category_flat_store_1.entity_id) FROM `catalog_category_flat_store_1` WHERE (catalog_category_flat_store_1.path LIKE '1/2/619/22/%') AND (catalog_category_flat_store_1.is_active = 1)

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `main_table`.`entity_id`, `main_table`.`name`, `url_rewrite`.`request_path` FROM `catalog_category_flat_store_1` AS `main_table`
 LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'category/%' WHERE (main_table.entity_id IN ('619', '22')) AND (main_table.is_active = '1') ORDER BY `main_table`.`path` ASC

SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/22') AND (store_id = 1) ORDER BY `is_system` DESC LIMIT 1

SELECT `index_process`.* FROM `index_process` WHERE (`index_process`.`indexer_code`='catalog_product_flat')

SELECT IS_USED_LOCK(?);

SELECT `core_flag`.* FROM `core_flag` WHERE (`core_flag`.`flag_code`='catalog_product_flat')

SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product')

SELECT `main_table`.*, `additional_table`.*, IF(al.value IS NOT NULL, al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_in_product_listing = 1)

SELECT DISTINCT `e`.`attribute_set_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 (e.status = 1)

SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.`attribute_id`, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
 INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN(4)) AND (`additional_table`.`is_filterable` > 0) GROUP BY `entity_attribute`.`attribute_id` ORDER BY position ASC

begin

INSERT INTO `sheep_debug_request_info` (`token`, `http_method`, `store_id`, `request_path`, `ip`, `session_id`, `date`, `query_time`, `query_count`, `info`) VALUES (?, ?, ?, ?, ?, ?, '2026-02-02 14:51:37', ?, ?, ?)

commit

SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category')

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='description') AND (entity_type_id = :entity_type_id)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='name') AND (entity_type_id = :entity_type_id)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 22 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')

SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = 31) AND `at_name_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = 31) AND (`at_name`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (IF(at_name.value_id > 0, at_name.value, at_name_default.value) = 'Marques')

SELECT `catalog_category_flat_store_1`.* FROM `catalog_category_flat_store_1` WHERE (`catalog_category_flat_store_1`.`entity_id`=22)

SELECT `main_table`.`entity_id`, main_table.`name`, main_table.`path`, `main_table`.`is_active`, `main_table`.`is_anchor`, `url_rewrite`.`request_path` FROM `catalog_category_flat_store_1` AS `main_table`
 LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'category/%' WHERE (main_table.include_in_menu = '1') AND (main_table.is_active = '1') AND (main_table.path like '1/2/619/22/%') AND (`level` <= 4) ORDER BY `main_table`.`position` ASC

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '66') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `Manufacturer_idx`.*, `Manufacturer_idx`.`value`, COUNT(Manufacturer_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `Manufacturer_idx` ON Manufacturer_idx.entity_id = e.entity_id AND Manufacturer_idx.attribute_id = 66 AND Manufacturer_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `Manufacturer_idx`.`value`

SELECT `price_view_idx`.*, `price_view_idx`.`value`, COUNT(price_view_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `price_view_idx` ON price_view_idx.entity_id = e.entity_id AND price_view_idx.attribute_id = 449 AND price_view_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `price_view_idx`.`value`

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '619') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `nuance_idx`.*, `nuance_idx`.`value`, COUNT(nuance_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `nuance_idx` ON nuance_idx.entity_id = e.entity_id AND nuance_idx.attribute_id = 619 AND nuance_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `nuance_idx`.`value`

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '626') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `outdoor_indoor_les_2_idx`.*, `outdoor_indoor_les_2_idx`.`value`, COUNT(outdoor_indoor_les_2_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `outdoor_indoor_les_2_idx` ON outdoor_indoor_les_2_idx.entity_id = e.entity_id AND outdoor_indoor_les_2_idx.attribute_id = 626 AND outdoor_indoor_les_2_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `outdoor_indoor_les_2_idx`.`value`

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '627') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `forme_idx`.*, `forme_idx`.`value`, COUNT(forme_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `forme_idx` ON forme_idx.entity_id = e.entity_id AND forme_idx.attribute_id = 627 AND forme_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `forme_idx`.`value`

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '635') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `temperature_idx`.*, `temperature_idx`.`value`, COUNT(temperature_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `temperature_idx` ON temperature_idx.entity_id = e.entity_id AND temperature_idx.attribute_id = 635 AND temperature_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `temperature_idx`.`value`

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '637') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `energie_radiateur_idx`.*, `energie_radiateur_idx`.`value`, COUNT(energie_radiateur_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `energie_radiateur_idx` ON energie_radiateur_idx.entity_id = e.entity_id AND energie_radiateur_idx.attribute_id = 637 AND energie_radiateur_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `energie_radiateur_idx`.`value`

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '647') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `availability_status_idx`.*, `availability_status_idx`.`value`, COUNT(availability_status_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `availability_status_idx` ON availability_status_idx.entity_id = e.entity_id AND availability_status_idx.attribute_id = 647 AND availability_status_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `availability_status_idx`.`value`

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '651') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `nbr_places_idx`.*, `nbr_places_idx`.`value`, COUNT(nbr_places_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 `catalog_product_index_eav` AS `nbr_places_idx` ON nbr_places_idx.entity_id = e.entity_id AND nbr_places_idx.attribute_id = 651 AND nbr_places_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `nbr_places_idx`.`value`

SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=1)

SELECT `main_table`.* FROM `tax_class` AS `main_table` WHERE (`class_type` = 'PRODUCT')

(SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (5)) AND (rate.tax_country_id = 'FR') AND (rate.tax_region_id IN(0, 257)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '75001', '75001*', '7500*', '750*', '75*', '7*'))) UNION (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (5)) AND (rate.tax_country_id = 'FR') AND (rate.tax_region_id IN(0, 257)) AND (rate.zip_is_range IS NOT NULL) AND ('75001' BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC

SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)

SELECT `main_table`.* FROM `tax_class` AS `main_table` WHERE (`class_type` = 'PRODUCT')

SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (5)) AND (rate.tax_country_id = 'FR') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC

SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(price_index.min_price -(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)+((price_index.min_price-(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)) * 1, 2) AS `max`, ROUND(MIN(price_index.min_price -(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)+((price_index.min_price-(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((price_index.min_price -(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)+((price_index.min_price-(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)) * 1, 2)) AS `std` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 (e.status = 1) AND (price_index.min_price IS NOT NULL)

SELECT FLOOR((ROUND(((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `catalog_product_index_price` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE ( e.website_id = 1 ) AND ( e.customer_group_id = 0) AND ((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)) IS NOT NULL) GROUP BY FLOOR((ROUND(((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))) * 1, 2)) / 1000) + 1 ORDER BY FLOOR((ROUND(((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))*CASE e.tax_class_id WHEN 5 THEN       0.2000  ELSE 0 END))) * 1, 2)) / 1000) + 1 ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=66)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 66) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '66') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('597', '603', '2380', '2371', '386', '3256', '748', '398', '3877', '1696')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=449)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 449) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '449') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN(NULL)) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=619)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 619) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '619') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('34681', '35211', '35209', '35208', '34680', '34671', '35212', '35219', '35217')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=626)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 626) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '626') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('34711')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=627)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 627) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '627') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '34684')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=635)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 635) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '635') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=637)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 637) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '637') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=647)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 647) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '647') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('35615', '35379', '35378')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=651)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 651) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '651') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=493)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 493) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '493') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '3883')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=560)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 560) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '560') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('1603', '23987', '1595', '32667', '2310')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=554)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 554) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '554') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '34942', '2804', '33027', '28139', '34925', '35285', '35858', '33025', '32658')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=76)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 76) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '76') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '61', '118', '124', '278', '69', '67')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=491)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 491) AND (entity_id IN (7128, 9419, 13155, 27407, 33947, 33969, 36608, 36609, 37297, 40912, 52840, 52872, 60243, 60427, 70806, 75879, 78124, 80829, 82788, 82940, 84391, 84757, 84907, 85262))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '491') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('3408', '184', '165', '', '167')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 22 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')

SELECT `main_table`.*, IF(al.value IS NULL, main_table.frontend_label, al.value) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_for_sort_by = 1)

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` 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 = 22 AND cat_index.is_parent=1
 INNER JOIN `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 (e.status = 1) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC

SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = 1) AND (is_system = 1) AND (category_id = 22 OR category_id IS NULL) AND (product_id IN(60243, 85262, 84907, 84757, 84391, 82940, 82788, 80829, 78124, 75879, 70806, 60427, 7128, 52872, 52840, 40912, 37297, 36609, 36608, 33969, 33947, 27407, 13155, 9419)) ORDER BY `category_id` DESC

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(60243, 85262, 84907, 84757, 84391, 82940, 82788, 80829, 78124, 75879, 70806, 60427, 7128, 52872, 52840, 40912, 37297, 36609, 36608, 33969, 33947, 27407, 13155, 9419)) AND (stock_id=1) AND (website_id=1)

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=60243)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70024, 72303, 72304, 72305, 81994, 84905, 84906)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=85262)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (76405, 85264, 85265)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=84907)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (84908, 84909, 84910, 84911, 84912, 84913)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=84757)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (84737, 84747, 84748)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (84391)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (82940)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=82788)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (82790, 82791, 82792)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (80829)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=78124)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (78125, 78126, 78127)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75879)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70806)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70810, 76505, 76506, 76507)) AND (qty>'0')

SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
 INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` = '4') ORDER BY entity_attribute.sort_order ASC

SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `attribute_group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
 LEFT JOIN `eav_attribute_group` AS `attribute_group` ON entity.attribute_group_id = attribute_group.attribute_group_id WHERE (entity.attribute_id IN (508, 509, 56, 59, 612, 592, 58, 60, 70, 654, 66, 86, 67, 525, 511, 445, 620, 632, 637, 80, 597, 593, 57, 573, 71, 492, 626, 87, 68, 77, 512, 624, 641, 640, 82, 550, 497, 61, 72, 651, 553, 88, 69, 78, 625, 633, 496, 601, 647, 62, 73, 76, 491, 89, 623, 636, 65, 648, 594, 63, 79, 619, 627, 91, 644, 634, 502, 649, 595, 64, 493, 554, 504, 621, 635, 74, 495, 618, 599, 81, 628, 560, 622, 631, 586, 600, 617, 655, 558, 630, 84, 503, 608, 614, 656, 629, 85, 645, 642, 75, 639, 643, 449, 638, 555, 570, 83, 650, 569, 571, 598, 572, 92, 93, 446, 447, 448, 450, 451, 452, 453, 470, 471, 472, 524, 657, 658, 659, 660, 661)) AND (entity.attribute_set_id = :attribute_set_id)

SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (`product_id` = '70806') ORDER BY position  ASC

SELECT `e`.*, `link_table`.`parent_id`, `at_color`.`value` AS `color` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id
 INNER JOIN `catalog_product_entity_int` AS `at_color` ON (`at_color`.`entity_id` = `e`.`entity_id`) AND (`at_color`.`attribute_id` = 76) AND (`at_color`.`store_id` = 0) WHERE (link_table.parent_id = 70806) AND (at_color.value IS NOT NULL)

SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
 LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (70810, 76505, 76506, 76507)) AND (t_d.attribute_id IN (70, 71, 451, 452)) AND (t_d.store_id = 0)

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(70810, 76505, 76506, 76507))

SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def`
 LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 1 WHERE (def.product_super_attribute_id IN (8148)) AND (def.store_id = 0)

SELECT `price`.* FROM `catalog_product_super_attribute_pricing` AS `price` WHERE (price.product_super_attribute_id IN (8148)) AND (price.website_id = 0)

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '76') AND (`main_table`.`option_id` IN(2928, 32221, 26594, 10045)) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =70806)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70806) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70806) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70806) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70806) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70806) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=70806) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (70806)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=70806) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70810, 76505, 76506, 76507)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=60427)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (60426, 60428)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=7128)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (6527, 6528, 6529, 6540, 8230, 8231, 8232, 81397)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=52872)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (52896, 52899, 52900, 86146)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =52872)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52872) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52872) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52872) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52872) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52872) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=52872) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (52872)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=52872) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (52896, 52899, 52900, 86146)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (52840)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=40912)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (40913, 40914, 40915, 64198, 64199)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (37297)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =37297)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 37297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 37297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 37297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 37297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 37297) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=37297) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (37297)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=37297) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (37297)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (36609)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (36608)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=33969)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (33973, 70025, 72297, 72298, 81274, 83879, 83880)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =33969)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 33969) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 33969) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 33969) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 33969) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 33969) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=33969) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (33969)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=33969) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (33973, 70025, 72297, 72298, 81274, 83879, 83880)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=33947)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70026, 72300, 72301, 80829, 80830, 80831)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=27407)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (27408, 27409, 27410, 27411, 27412, 27413, 27414, 27415, 27416, 27417, 27418, 27419, 27420, 27421, 27422, 27423, 27424, 27425, 27426, 27427, 27428, 27429, 27430, 27431, 27432, 27433)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (13155)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (9419)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =9419)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 9419) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 9419) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 9419) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 9419) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 9419) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=9419) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (9419)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=9419) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (9419)) AND (qty>'0')

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 22 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')