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 `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product')

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

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 `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 = 83642) 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 = 83642) 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 = 83642) 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 = 83642) 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 = 83642) 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=83642) 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 (83642)) 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=83642) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83642) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83642)) AND (stock_id=1) AND (website_id=1)

SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table`
 INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
 LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1
 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`product_id` = '83642') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC

SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 83642)

SELECT `catalog_category_product_index`.`product_id` FROM `catalog_category_product_index` WHERE (product_id = 83642) AND (category_id = 642)

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

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

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 `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 ('613', '642')) 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`='product/83642') AND (store_id = 1) ORDER BY `is_system` DESC LIMIT 1

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 16:36:49', ?, ?, ?)

commit

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

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) ORDER BY main_table.sort_order ASC, value ASC

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') 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 `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 `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-02-02') AND (website_id = 1) AND (customer_group_id = 0) AND (product_id IN(83642))

SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (`product_id` = '83642') ORDER BY position  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, 66)) AND (entity.attribute_set_id = :attribute_set_id)

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_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
 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 = 83642) 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 (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) 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(75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144))

DESCRIBE `catalog_product_entity`

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 (8697)) AND (def.store_id = 0)

SELECT `price`.* FROM `catalog_product_super_attribute_pricing` AS `price` WHERE (price.product_super_attribute_id IN (8697)) 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(1808, 279, 278, 2558, 4070, 61, 26594, 2928, 10045, 32413, 31769, 31770, 32147, 67, 285, 32221, 427, 128, 32587, 32728, 32727, 32726, 35740, 36264, 36265)) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

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

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) ORDER BY main_table.sort_order ASC, value ASC

SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (`product_id` = '83642') 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_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
 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 = 83642) 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 (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) 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(75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144))

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 (8697)) AND (def.store_id = 0)

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

SELECT `main_table`.* FROM `catalogsearch_query` AS `main_table` WHERE (num_results >= 2 AND popularity >= 50 AND query_text != "__empty__") AND (store_id = 1) ORDER BY popularity DESC, num_results DESC, updated_at ASC LIMIT 12

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

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/%') AND (`level` <= 2) ORDER BY `main_table`.`position` ASC

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

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/315/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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`='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 `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/1116') AND (store_id = 1) ORDER BY `is_system` DESC LIMIT 1

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

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

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

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

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

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

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

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

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

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

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/516/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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/612/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/613/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/614/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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/615/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/616/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/618/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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 `catalog_category_flat_store_1`.* FROM `catalog_category_flat_store_1` WHERE (`catalog_category_flat_store_1`.`entity_id`=231)

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

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

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

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

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

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

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

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

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

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

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

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

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

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/620/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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/621/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/622/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/624/%') AND (`level` <= 3) ORDER BY `main_table`.`position` ASC

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

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

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

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

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

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

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

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

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

SELECT `catalog_category_product`.`category_id` FROM `catalog_category_product` WHERE (product_id = 83642)

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

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

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

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

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

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

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

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

(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`.`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 `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =75220)

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 = 75220) 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 = 75220) 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 = 75220) 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 = 75220) 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 = 75220) 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=75220) 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 (75220)) 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=75220) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=75220) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(75220)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 80888) 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 = 80888) 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 = 80888) 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 = 80888) 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 = 80888) 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=80888) 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 (80888)) 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=80888) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=80888) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(80888)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 81268) 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 = 81268) 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 = 81268) 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 = 81268) 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 = 81268) 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=81268) 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 (81268)) 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=81268) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=81268) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(81268)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 81810) 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 = 81810) 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 = 81810) 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 = 81810) 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 = 81810) 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=81810) 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 (81810)) 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=81810) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=81810) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(81810)) AND (stock_id=1) AND (website_id=1)

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

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (81810)) AND (qty>'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` = '592') 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 =82554)

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 = 82554) 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 = 82554) 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 = 82554) 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 = 82554) 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 = 82554) 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=82554) 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 (82554)) 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=82554) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=82554) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(82554)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83643) 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 = 83643) 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 = 83643) 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 = 83643) 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 = 83643) 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=83643) 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 (83643)) 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=83643) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83643) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83643)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83644) 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 = 83644) 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 = 83644) 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 = 83644) 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 = 83644) 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=83644) 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 (83644)) 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=83644) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83644) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83644)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83645) 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 = 83645) 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 = 83645) 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 = 83645) 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 = 83645) 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=83645) 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 (83645)) 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=83645) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83645) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83645)) AND (stock_id=1) AND (website_id=1)

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

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

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

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 = 83647) 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 = 83647) 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 = 83647) 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 = 83647) 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 = 83647) 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=83647) 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 (83647)) 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=83647) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83647) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83647)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83648) 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 = 83648) 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 = 83648) 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 = 83648) 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 = 83648) 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=83648) 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 (83648)) 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=83648) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83648) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83648)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83649) 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 = 83649) 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 = 83649) 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 = 83649) 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 = 83649) 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=83649) 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 (83649)) 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=83649) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83649) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83649)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83651) 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 = 83651) 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 = 83651) 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 = 83651) 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 = 83651) 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=83651) 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 (83651)) 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=83651) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83651) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83651)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83652) 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 = 83652) 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 = 83652) 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 = 83652) 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 = 83652) 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=83652) 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 (83652)) 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=83652) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83652) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83652)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83653) 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 = 83653) 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 = 83653) 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 = 83653) 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 = 83653) 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=83653) 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 (83653)) 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=83653) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83653) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83653)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83654) 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 = 83654) 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 = 83654) 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 = 83654) 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 = 83654) 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=83654) 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 (83654)) 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=83654) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83654) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83654)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83655) 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 = 83655) 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 = 83655) 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 = 83655) 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 = 83655) 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=83655) 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 (83655)) 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=83655) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83655) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83655)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83656) 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 = 83656) 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 = 83656) 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 = 83656) 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 = 83656) 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=83656) 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 (83656)) 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=83656) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83656) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83656)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83657) 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 = 83657) 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 = 83657) 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 = 83657) 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 = 83657) 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=83657) 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 (83657)) 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=83657) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83657) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83657)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 83659) 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 = 83659) 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 = 83659) 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 = 83659) 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 = 83659) 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=83659) 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 (83659)) 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=83659) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=83659) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83659)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 86459) 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 = 86459) 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 = 86459) 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 = 86459) 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 = 86459) 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=86459) 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 (86459)) 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=86459) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=86459) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(86459)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 86460) 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 = 86460) 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 = 86460) 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 = 86460) 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 = 86460) 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=86460) 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 (86460)) 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=86460) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=86460) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(86460)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 86461) 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 = 86461) 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 = 86461) 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 = 86461) 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 = 86461) 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=86461) 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 (86461)) 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=86461) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=86461) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(86461)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 103001) 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 = 103001) 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 = 103001) 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 = 103001) 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 = 103001) 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=103001) 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 (103001)) 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=103001) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=103001) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(103001)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 104143) 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 = 104143) 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 = 104143) 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 = 104143) 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 = 104143) 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=104143) 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 (104143)) 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=104143) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=104143) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(104143)) AND (stock_id=1) AND (website_id=1)

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

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

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 = 104144) 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 = 104144) 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 = 104144) 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 = 104144) 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 = 104144) 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=104144) 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 (104144)) 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=104144) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
 INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`=104144) AND (stock_id = :stock_id)

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(104144)) AND (stock_id=1) AND (website_id=1)

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

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) AND (qty>'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` = '586') 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 =83642)

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 = 83642) 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 = 83642) 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 = 83642) 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 = 83642) 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 = 83642) 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=83642) 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 (83642)) 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=83642) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(83642)) AND (stock_id=1) AND (website_id=1)

SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table`
 INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
 LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1
 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`product_id` = '83642') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC

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`.* FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4)

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`.*, `link_table`.`parent_id`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` 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_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = 80) AND `at_status_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = 80) AND (`at_status`.`store_id` = 1) WHERE (link_table.parent_id = 83642) AND (((`e`.`required_options` != '1') OR (`e`.`required_options` IS NULL))) AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1')

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 (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) AND (t_d.attribute_id IN (56, 612, 70, 654, 86, 67, 445, 620, 597, 71, 624, 640, 82, 550, 497, 72, 69, 625, 633, 496, 601, 73, 623, 648, 79, 91, 644, 634, 649, 504, 621, 618, 599, 622, 617, 630, 503, 614, 645, 642, 643, 638, 570, 83, 650, 569, 571, 451, 452, 453, 471, 472, 658, 659, 660, 661)) AND (t_d.store_id = 0) UNION ALL 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_int` AS `t_d`
 LEFT JOIN `catalog_product_entity_int` 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 (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) AND (t_d.attribute_id IN (592, 66, 525, 511, 632, 637, 593, 492, 626, 641, 651, 553, 647, 76, 491, 636, 594, 619, 627, 595, 493, 554, 635, 74, 495, 81, 628, 560, 631, 586, 655, 558, 608, 656, 629, 85, 449, 555, 598, 446, 447, 448, 450, 470, 524, 657, 66)) AND (t_d.store_id = 0) UNION ALL 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_text` AS `t_d`
 LEFT JOIN `catalog_product_entity_text` 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 (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) AND (t_d.attribute_id IN (58, 57, 68, 512, 89, 502, 600, 652)) AND (t_d.store_id = 0) UNION ALL 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_decimal` AS `t_d`
 LEFT JOIN `catalog_product_entity_decimal` 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 (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) AND (t_d.attribute_id IN (60, 573, 61, 65, 64, 84, 75, 639, 572)) AND (t_d.store_id = 0) UNION ALL 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_datetime` AS `t_d`
 LEFT JOIN `catalog_product_entity_datetime` 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 (75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144)) AND (t_d.attribute_id IN (87, 77, 88, 78, 62, 63)) 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(75220, 80888, 81268, 81810, 82554, 83643, 83644, 83645, 83647, 83648, 83649, 83651, 83652, 83653, 83654, 83655, 83656, 83657, 83659, 86459, 86460, 86461, 103001, 104143, 104144))

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

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

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 sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75220)) AND (qty>'0')

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

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

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

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

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

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=81810) AND (website_id = 0)

SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-02-02') AND (website_id = 1) AND (customer_group_id = 0) AND (product_id IN(81810))

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

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

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

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

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

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

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=83645) AND (website_id = 0)

SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-02-02') AND (website_id = 1) AND (customer_group_id = 0) AND (product_id IN(83645))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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