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`=707)

SELECT `main_table`.* FROM `catalog_category_flat_store_1` AS `main_table` WHERE (entity_id IN ('707', '464', '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/464/707/%') 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 ('464', '707')) 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/707') 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 = 707 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:48:53', ?, ?, ?)

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 = 707 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`=707)

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/464/707/%') 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('600')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('35230', '34671', '35211', '34681', '34672', '35212', '35213')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('35681', '')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('11371', '1217', '1907', '6319', '1908')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('66', '', '1686', '10', '1497', '19384', '24222', '1496', '1447', '3161')) 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 = 707 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 (56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730))

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('', '174')) 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 = 707 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 = 707 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 = 707 OR category_id IS NULL) AND (product_id IN(56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730)) ORDER BY `category_id` DESC

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(56437, 63585, 72803, 73858, 73860, 73863, 73867, 73868, 73872, 73877, 76899, 77319, 78372, 81243, 90730)) AND (stock_id=1) AND (website_id=1)

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

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

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

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

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

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

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

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

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (73867, 73869, 73870, 96311)) AND (qty>'0')

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

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

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

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

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

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

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (90730)) 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 = 707 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')