https://jair.r202.fr/le-chaisier/tabourets-exterieurs

Queries

SQL Queries

#Time Info
0 0.31 ms
connect
1 0.08 ms
SET NAMES utf8
2 0.26 ms
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN (:path0, :path1)) AND (store_id IN(0, 1))
Parameters: :path0 = le-chaisier/tabourets-exterieurs, :path1 = le-chaisier/tabourets-exterieurs/
3 0.17 ms
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)
Parameters: :store_id = 1, :required_date = 2026-02-02 14:50:28
4 0.14 ms
SELECT `index_process`.* FROM `index_process` WHERE (`index_process`.`indexer_code`='catalog_category_flat')
5 0.12 ms
SELECT IS_USED_LOCK(?);
Parameters: 1 = jair_r202.index_process_5
6 0.16 ms
SELECT `catalog_category_flat_store_1`.`entity_id` FROM `catalog_category_flat_store_1` LIMIT 1
7 0.19 ms
SELECT `catalog_category_flat_store_1`.* FROM `catalog_category_flat_store_1` WHERE (`catalog_category_flat_store_1`.`entity_id`=722)
8 0.22 ms
SELECT `main_table`.* FROM `catalog_category_flat_store_1` AS `main_table` WHERE (entity_id IN ('722', '612', '2', '1')) AND (custom_use_parent_settings = 0) AND (`level` != 0) ORDER BY `level` DESC
9 0.19 ms
SELECT COUNT(catalog_category_flat_store_1.entity_id) FROM `catalog_category_flat_store_1` WHERE (catalog_category_flat_store_1.path LIKE '1/2/612/722/%') AND (catalog_category_flat_store_1.is_active = 1)
10 0.19 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = default
11 0.17 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = STORE_default
12 0.20 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = THEME_frontend_lecedrerougev5_stock
13 0.18 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = catalog_category_view
14 0.20 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = clean_layout_product
15 0.21 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = MAP_popup
16 0.21 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = SHORTCUT_popup
17 0.20 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = SHORTCUT_uk_popup
18 0.20 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = catalog_category_default
19 0.20 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = catalog_category_layered_nochildren
20 0.17 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = CATEGORY_722
21 0.17 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = customer_logged_out
22 0.20 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = algolia_search_handle
23 0.21 ms
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
Parameters: :store_id = 1, :area = frontend, :package = lecedrerougev5, :theme = stock, :layout_update_handle = algolia_search_handle_no_topsearch
24 206.86 ms
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 ('612', '722')) AND (main_table.is_active = '1') ORDER BY `main_table`.`path` ASC
25 0.24 ms
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
26 0.15 ms
SELECT `index_process`.* FROM `index_process` WHERE (`index_process`.`indexer_code`='catalog_product_flat')
27 0.13 ms
SELECT IS_USED_LOCK(?);
Parameters: 1 = jair_r202.index_process_4
28 0.15 ms
SELECT `core_flag`.* FROM `core_flag` WHERE (`core_flag`.`flag_code`='catalog_product_flat')
29 0.17 ms
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product')
30 0.60 ms
SELECT `main_table`.*, `additional_table`.*, IF(al.value IS NOT NULL, al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_in_product_listing = 1)
31 0.60 ms
SELECT DISTINCT `e`.`attribute_set_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0 WHERE (e.status = 1)
32 0.56 ms
SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.`attribute_id`, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
 INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN(4)) AND (`additional_table`.`is_filterable` > 0) GROUP BY `entity_attribute`.`attribute_id` ORDER BY position ASC
33 0.10 ms
begin
34 1.24 ms
INSERT INTO `sheep_debug_request_info` (`token`, `http_method`, `store_id`, `request_path`, `ip`, `session_id`, `date`, `query_time`, `query_count`, `info`) VALUES (?, ?, ?, ?, ?, ?, '2026-02-02 14:50:28', ?, ?, ?)
Parameters: 1 = 62c1a974, 2 = GET, 3 = 1, 4 = /le-chaisier/tabourets-exterieurs, 5 = 216.73.216.123, 6 = , 7 = 0.21, 8 = 34, 9 =
35 0.26 ms
commit
36 0.21 ms
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category')
37 0.16 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='description') AND (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 3
38 0.18 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 3
39 0.15 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 34
40 0.12 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='name') AND (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 3
41 0.10 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 3
42 0.11 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 31
43 1.16 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')
44 5.43 ms
SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = 31) AND `at_name_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = 31) AND (`at_name`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (IF(at_name.value_id > 0, at_name.value, at_name_default.value) = 'Marques')
45 0.18 ms
SELECT `catalog_category_flat_store_1`.* FROM `catalog_category_flat_store_1` WHERE (`catalog_category_flat_store_1`.`entity_id`=722)
46 0.28 ms
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/722/%') AND (`level` <= 4) ORDER BY `main_table`.`position` ASC
47 2.86 ms
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
48 0.84 ms
SELECT `Manufacturer_idx`.*, `Manufacturer_idx`.`value`, COUNT(Manufacturer_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0
 INNER JOIN `catalog_product_index_eav` AS `Manufacturer_idx` ON Manufacturer_idx.entity_id = e.entity_id AND Manufacturer_idx.attribute_id = 66 AND Manufacturer_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `Manufacturer_idx`.`value`
49 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = Manufacturer
50 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=66)
51 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
52 0.15 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 66
53 0.38 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
54 0.95 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 66) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
55 0.45 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '66') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('386', '968', '969', '1187', '398', '2451', '2562', '2571', '2803', '1696', '611', '603', '3163', '3705', '2426', '809', '713')) ORDER BY main_table.sort_order ASC, value ASC
56 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = price_view
57 0.11 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=449)
58 0.10 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
59 0.13 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 449
60 0.35 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
61 0.71 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 449) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
62 0.19 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '449') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN(NULL)) ORDER BY main_table.sort_order ASC, value ASC
63 0.17 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = nuance
64 0.11 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=619)
65 0.09 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
66 0.12 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 619
67 0.40 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
68 0.77 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 619) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
69 0.43 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '619') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('35211', '35210', '35215', '34671', '34681', '35208', '34680', '34678', '34676', '35213', '35212', '34831', '35209', '35216', '34670', '34677', '34672')) ORDER BY main_table.sort_order ASC, value ASC
70 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = outdoor_indoor_les_2
71 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=626)
72 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
73 0.15 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 626
74 0.32 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
75 0.82 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 626) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
76 0.28 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '626') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('34711', '', '34713')) ORDER BY main_table.sort_order ASC, value ASC
77 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = forme
78 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=627)
79 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
80 0.15 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 627
81 0.36 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
82 0.74 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 627) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
83 0.19 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '627') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC
84 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = temperature
85 0.07 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=635)
86 0.06 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
87 0.12 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 635
88 0.36 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
89 0.75 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 635) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
90 0.19 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '635') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC
91 0.17 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = energie_radiateur
92 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=637)
93 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
94 0.12 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 637
95 0.36 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
96 0.70 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 637) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
97 0.20 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '637') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC
98 0.17 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = availability_status
99 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=647)
100 0.10 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
101 0.13 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 647
102 0.32 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
103 0.81 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 647) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
104 0.28 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '647') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('35615', '', '35379', '35378')) ORDER BY main_table.sort_order ASC, value ASC
105 0.16 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = nbr_places
106 0.14 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=651)
107 0.10 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
108 0.13 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 651
109 0.31 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
110 0.80 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 651) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
111 0.20 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '651') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC
112 0.17 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = designer
113 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=493)
114 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
115 0.15 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 493
116 0.37 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
117 0.79 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 493) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
118 0.29 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '493') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '1024', '1036', '6380', '10022', '9229')) ORDER BY main_table.sort_order ASC, value ASC
119 0.16 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = type_objet
120 0.12 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=560)
121 0.15 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
122 0.15 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 560
123 0.37 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
124 0.80 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 560) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
125 0.34 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '560') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('11142', '1235', '4475', '11137', '11377', '11271', '6807')) ORDER BY main_table.sort_order ASC, value ASC
126 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = gamme_collection
127 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=554)
128 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
129 0.11 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 554
130 0.33 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
131 0.76 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 554) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
132 0.58 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '554') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('1193', '1206', '', '1270', '35601', '1204', '1203', '1269', '1275', '908', '3435', '909', '3455', '32660', '17782', '2180', '32661', '35300', '1331', '18421', '36582', '33031', '2496', '31914', '3202')) ORDER BY main_table.sort_order ASC, value ASC
133 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = color
134 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=76)
135 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
136 0.16 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 76
137 0.38 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
138 0.81 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 76) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
139 0.50 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '76') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '1339', '118', '106', '3572', '75', '40', '59', '61', '1706', '1107', '1808', '32413', '1655', '3713', '808', '10', '31769', '4070', '26594')) ORDER BY main_table.sort_order ASC, value ASC
140 0.18 ms
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)
Parameters: :entity_type_code = catalog_product, :attribute_code = matiere
141 0.15 ms
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=491)
142 0.14 ms
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Parameters: :entity_type_id = 4
143 0.15 ms
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Parameters: :attribute_id = 491
144 0.37 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1)
145 0.75 ms
SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 491) AND (entity_id IN (7984, 8272, 14035, 14333, 14667, 15612, 16295, 16608, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 24680, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582, 42583, 42586, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 106376))
146 0.30 ms
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '491') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('167', '', '174', '184', '187')) ORDER BY main_table.sort_order ASC, value ASC
147 1.17 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')
148 0.31 ms
SELECT `main_table`.*, IF(al.value IS NULL, main_table.frontend_label, al.value) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_for_sort_by = 1)
149 0.99 ms
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0 WHERE (e.status = 1) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC
150 1.54 ms
SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = 1) AND (is_system = 1) AND (category_id = 722 OR category_id IS NULL) AND (product_id IN(106376, 42586, 42583, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 24680, 8272, 14035, 14333, 14667, 15612, 16295, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 7984, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582)) ORDER BY `category_id` DESC
151 0.70 ms
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(106376, 42586, 42583, 42588, 45047, 53303, 57209, 70490, 70726, 70734, 70752, 71750, 77111, 77775, 78455, 78563, 81875, 81947, 82030, 83674, 85246, 85250, 89419, 89427, 89438, 89464, 89480, 90766, 90767, 98977, 24680, 8272, 14035, 14333, 14667, 15612, 16295, 17045, 17197, 18305, 18320, 18323, 18327, 18328, 7984, 27079, 28068, 28070, 37143, 37148, 40066, 40189, 41609, 41784, 41785, 42571, 42573, 42580, 42582)) AND (stock_id=1) AND (website_id=1)
152 0.14 ms
SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)
153 0.31 ms
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
154 0.18 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (106376)) AND (qty>'0')
155 0.17 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42586)) AND (qty>'0')
156 1.04 ms
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
157 0.73 ms
SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `attribute_group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
 LEFT JOIN `eav_attribute_group` AS `attribute_group` ON entity.attribute_group_id = attribute_group.attribute_group_id WHERE (entity.attribute_id IN (508, 509, 56, 59, 612, 592, 58, 60, 70, 654, 66, 86, 67, 525, 511, 445, 620, 632, 637, 80, 597, 593, 57, 573, 71, 492, 626, 87, 68, 77, 512, 624, 641, 640, 82, 550, 497, 61, 72, 651, 553, 88, 69, 78, 625, 633, 496, 601, 647, 62, 73, 76, 491, 89, 623, 636, 65, 648, 594, 63, 79, 619, 627, 91, 644, 634, 502, 649, 595, 64, 493, 554, 504, 621, 635, 74, 495, 618, 599, 81, 628, 560, 622, 631, 586, 600, 617, 655, 558, 630, 84, 503, 608, 614, 656, 629, 85, 645, 642, 75, 639, 643, 449, 638, 555, 570, 83, 650, 569, 571, 598, 572, 92, 93, 446, 447, 448, 450, 451, 452, 453, 470, 471, 472, 524, 657, 658, 659, 660, 661)) AND (entity.attribute_set_id = :attribute_set_id)
Parameters: :attribute_set_id = 4
158 0.15 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =42586)
159 0.87 ms
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 = 42586) 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 = 42586) 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 = 42586) 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 = 42586) 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 = 42586) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
160 0.17 ms
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=42586) AND (website_id = 0)
161 0.30 ms
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 (42586)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
162 0.18 ms
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=42586) AND (website_id = 0) ORDER BY `qty` ASC
163 0.17 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
164 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
165 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
166 0.16 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
167 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
168 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
169 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
170 0.08 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
171 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
172 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
173 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
174 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
175 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42586
176 0.14 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42586)) AND (qty>'0')
177 0.18 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42583)) AND (qty>'0')
178 0.15 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =42583)
179 0.75 ms
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 = 42583) 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 = 42583) 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 = 42583) 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 = 42583) 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 = 42583) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
180 0.16 ms
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=42583) AND (website_id = 0)
181 0.25 ms
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 (42583)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
182 0.14 ms
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=42583) AND (website_id = 0) ORDER BY `qty` ASC
183 0.16 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
184 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
185 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
186 0.09 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
187 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
188 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
189 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
190 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
191 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
192 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
193 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
194 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
195 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42583
196 0.09 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42583)) AND (qty>'0')
197 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42588)) AND (qty>'0')
198 0.10 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =42588)
199 0.72 ms
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 = 42588) 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 = 42588) 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 = 42588) 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 = 42588) 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 = 42588) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
200 0.14 ms
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=42588) AND (website_id = 0)
201 0.25 ms
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 (42588)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
202 0.17 ms
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=42588) AND (website_id = 0) ORDER BY `qty` ASC
203 0.16 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
204 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
205 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
206 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
207 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
208 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
209 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
210 0.08 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
211 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
212 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
213 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
214 0.06 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
215 0.06 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42588
216 0.09 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42588)) AND (qty>'0')
217 0.12 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=45047)
218 0.15 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (41609, 41613, 41614, 41616, 41617, 74137, 74138, 74139)) AND (qty>'0')
219 0.08 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=53303)
220 0.20 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (53305, 53306, 53307, 53308, 53309, 53310, 53311, 53312, 53313, 53314, 53315, 53316, 53317, 53318, 53319)) AND (qty>'0')
221 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (57209)) AND (qty>'0')
222 0.11 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70490)
223 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (80991, 80992, 80993, 80994, 80995, 80996)) AND (qty>'0')
224 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70726)
225 0.33 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70727, 70728, 70730, 70731, 70732, 70734, 70735, 70738, 70742, 70743, 70744, 70745, 70746, 70748, 70749, 70750, 77111, 83822, 83823, 86422, 86423, 86424, 104043, 104127, 104128)) AND (qty>'0')
226 0.10 ms
SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (`product_id` = '70726') ORDER BY position  ASC
227 0.33 ms
SELECT `e`.*, `link_table`.`parent_id`, `at_color`.`value` AS `color` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id
 INNER JOIN `catalog_product_entity_int` AS `at_color` ON (`at_color`.`entity_id` = `e`.`entity_id`) AND (`at_color`.`attribute_id` = 76) AND (`at_color`.`store_id` = 0) WHERE (link_table.parent_id = 70726) AND (at_color.value IS NOT NULL)
228 0.79 ms
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 (70727, 70728, 70730, 70731, 70732, 70734, 70735, 70738, 70742, 70743, 70744, 70745, 70746, 70748, 70749, 70750, 77111, 83822, 83823, 86422, 86423, 86424, 104043, 104127, 104128)) AND (t_d.attribute_id IN (70, 71, 451, 452)) AND (t_d.store_id = 0)
229 0.45 ms
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(70727, 70728, 70730, 70731, 70732, 70734, 70735, 70738, 70742, 70743, 70744, 70745, 70746, 70748, 70749, 70750, 77111, 83822, 83823, 86422, 86423, 86424, 104043, 104127, 104128))
230 0.15 ms
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 (8146)) AND (def.store_id = 0)
231 0.17 ms
SELECT `price`.* FROM `catalog_product_super_attribute_pricing` AS `price` WHERE (price.product_super_attribute_id IN (8146)) AND (price.website_id = 0)
232 0.60 ms
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(1658, 285, 2558, 279, 4070, 1808, 26595, 26594, 278, 2335, 427, 2928, 128, 31769, 32147, 31770, 32413, 67, 32587, 32728, 32727, 32726, 36265, 35740, 36264)) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
233 0.14 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =70726)
234 0.76 ms
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 = 70726) 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 = 70726) 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 = 70726) 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 = 70726) 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 = 70726) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
235 0.16 ms
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=70726) AND (website_id = 0)
236 0.24 ms
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 (70726)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
237 0.17 ms
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=70726) AND (website_id = 0) ORDER BY `qty` ASC
238 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
239 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
240 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
241 0.16 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
242 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
243 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
244 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
245 0.08 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
246 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
247 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
248 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70726
249 0.31 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70727, 70728, 70730, 70731, 70732, 70734, 70735, 70738, 70742, 70743, 70744, 70745, 70746, 70748, 70749, 70750, 77111, 83822, 83823, 86422, 86423, 86424, 104043, 104127, 104128)) AND (qty>'0')
250 0.17 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70734)) AND (qty>'0')
251 0.18 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70752)
252 0.36 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70753, 70754, 70756, 70757, 70758, 70760, 70761, 70764, 70768, 70769, 70770, 70771, 70772, 70774, 70775, 70776, 77109, 83491, 83492, 86425, 86426, 86427, 104124, 104125, 104126)) AND (qty>'0')
253 0.14 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =70752)
254 0.75 ms
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 = 70752) 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 = 70752) 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 = 70752) 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 = 70752) 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 = 70752) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
255 0.14 ms
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=70752) AND (website_id = 0)
256 0.28 ms
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 (70752)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
257 0.16 ms
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=70752) AND (website_id = 0) ORDER BY `qty` ASC
258 0.16 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
259 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
260 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
261 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
262 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
263 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
264 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
265 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
266 0.08 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
267 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
268 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 70752
269 0.28 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70753, 70754, 70756, 70757, 70758, 70760, 70761, 70764, 70768, 70769, 70770, 70771, 70772, 70774, 70775, 70776, 77109, 83491, 83492, 86425, 86426, 86427, 104124, 104125, 104126)) AND (qty>'0')
270 0.18 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=71750)
271 0.89 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (71751, 71753, 71754, 71759, 71760, 71761, 71764, 71765, 71766, 71768, 71769, 71770, 71771, 71773, 71774, 71775, 71777, 71778, 71783, 71784, 71785, 71788, 71789, 71790, 71792, 71793, 71794, 71795, 71796, 71797, 71798, 71799, 71801, 71802, 71807, 71808, 71809, 71812, 71813, 71814, 71816, 71817, 71818, 71819, 71820, 71821, 71822, 82899, 88194, 88195, 88196, 88197, 88198, 88199, 88200, 88201, 88202, 88203, 88204, 88205, 88206, 88207, 88208, 88209, 88210, 88211, 88212, 88213, 88214, 88215, 88217, 88218, 88219, 88220, 88222, 88223, 88224, 88225, 88226, 88227, 88228, 88229, 88230, 88232, 88233, 88234, 88235, 98774, 98775, 98776, 98777)) AND (qty>'0')
272 0.16 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (77111)) AND (qty>'0')
273 0.18 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =77111)
274 0.90 ms
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 = 77111) 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 = 77111) 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 = 77111) 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 = 77111) 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 = 77111) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
275 0.17 ms
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=77111) AND (website_id = 0)
276 0.24 ms
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 (77111)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
277 0.13 ms
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=77111) AND (website_id = 0) ORDER BY `qty` ASC
278 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
279 0.16 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
280 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
281 0.16 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
282 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
283 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
284 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
285 0.12 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
286 0.08 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
287 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
288 0.07 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
289 0.13 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
290 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 77111
291 0.13 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (77111)) AND (qty>'0')
292 0.13 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (77775)) AND (qty>'0')
293 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (78455)) AND (qty>'0')
294 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (78563)) AND (qty>'0')
295 0.13 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=81875)
296 0.43 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (80940, 81255, 81269, 81367, 81368, 81876, 81877, 81878, 81879, 81880, 81882, 81883, 81885, 81887, 81888, 81889, 81890, 81892, 81893, 86822, 86823, 86824, 98713, 105943, 105944)) AND (qty>'0')
297 0.10 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =81875)
298 1.16 ms
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 = 81875) 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 = 81875) 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 = 81875) 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 = 81875) 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 = 81875) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
299 0.12 ms
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=81875) AND (website_id = 0)
300 0.25 ms
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 (81875)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
301 0.13 ms
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=81875) AND (website_id = 0) ORDER BY `qty` ASC
302 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
303 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
304 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
305 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
306 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
307 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
308 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
309 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
310 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
311 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
312 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 81875
313 0.43 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (80940, 81255, 81269, 81367, 81368, 81876, 81877, 81878, 81879, 81880, 81882, 81883, 81885, 81887, 81888, 81889, 81890, 81892, 81893, 86822, 86823, 86824, 98713, 105943, 105944)) AND (qty>'0')
314 0.14 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (81947)) AND (qty>'0')
315 0.12 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=82030)
316 0.30 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (80517, 82031, 82032, 82033, 82034, 82035, 82036, 82037, 82038, 82039, 85109, 86774, 86775, 89002, 89127, 89128, 89129, 89130, 89131, 89132, 89133, 89134, 89135, 89136)) AND (qty>'0')
317 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =82030)
318 1.04 ms
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 = 82030) 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 = 82030) 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 = 82030) 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 = 82030) 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 = 82030) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
319 0.13 ms
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=82030) AND (website_id = 0)
320 0.30 ms
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 (82030)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
321 0.13 ms
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=82030) AND (website_id = 0) ORDER BY `qty` ASC
322 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
323 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
324 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
325 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
326 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
327 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
328 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
329 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
330 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
331 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
332 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 82030
333 0.40 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (80517, 82031, 82032, 82033, 82034, 82035, 82036, 82037, 82038, 82039, 85109, 86774, 86775, 89002, 89127, 89128, 89129, 89130, 89131, 89132, 89133, 89134, 89135, 89136)) AND (qty>'0')
334 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (83674)) AND (qty>'0')
335 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =83674)
336 1.15 ms
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 = 83674) 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 = 83674) 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 = 83674) 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 = 83674) 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 = 83674) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
337 0.12 ms
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=83674) AND (website_id = 0)
338 0.20 ms
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 (83674)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
339 0.11 ms
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=83674) AND (website_id = 0) ORDER BY `qty` ASC
340 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
341 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
342 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
343 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
344 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
345 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
346 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
347 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
348 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
349 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
350 0.14 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
351 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
352 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 83674
353 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (83674)) AND (qty>'0')
354 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=85246)
355 0.15 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (85247, 85248, 85249)) AND (qty>'0')
356 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (85250)) AND (qty>'0')
357 0.11 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=89419)
358 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (89422, 89423, 89424, 89425, 89426, 104851, 104861)) AND (qty>'0')
359 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=89427)
360 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (89428, 89429, 89430, 89431, 89432, 89433, 104852)) AND (qty>'0')
361 0.11 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=89438)
362 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (89458, 89459, 89460, 89461, 89462, 89463, 104853)) AND (qty>'0')
363 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=89464)
364 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (89465, 89466, 89467, 89468, 89469, 104854, 104862)) AND (qty>'0')
365 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=89480)
366 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (89481, 89482, 89483, 89484, 89485, 104855, 104860)) AND (qty>'0')
367 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (90766)) AND (qty>'0')
368 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (90767)) AND (qty>'0')
369 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =90767)
370 1.02 ms
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 = 90767) 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 = 90767) 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 = 90767) 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 = 90767) 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 = 90767) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
371 0.12 ms
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=90767) AND (website_id = 0)
372 0.24 ms
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 (90767)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
373 0.13 ms
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=90767) AND (website_id = 0) ORDER BY `qty` ASC
374 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
375 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
376 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
377 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
378 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
379 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
380 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
381 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
382 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
383 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
384 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
385 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
386 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 90767
387 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (90767)) AND (qty>'0')
388 0.14 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (98977)) AND (qty>'0')
389 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =98977)
390 1.07 ms
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 = 98977) 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 = 98977) 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 = 98977) 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 = 98977) 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 = 98977) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
391 0.12 ms
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=98977) AND (website_id = 0)
392 0.26 ms
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 (98977)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
393 0.13 ms
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=98977) AND (website_id = 0) ORDER BY `qty` ASC
394 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
395 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
396 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
397 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
398 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
399 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
400 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
401 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
402 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
403 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
404 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
405 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
406 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 98977
407 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (98977)) AND (qty>'0')
408 0.11 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=24680)
409 0.16 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (24681, 24682, 24684, 74390)) AND (qty>'0')
410 0.13 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=8272)
411 0.44 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8249, 8251, 8261, 8265, 8267, 8270, 16069, 27177, 29885, 35867, 44729, 58198, 58199, 69289, 69290, 69291, 82273, 82274, 76943, 86494, 86495, 86496, 104312, 104313, 104315)) AND (qty>'0')
412 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =8272)
413 1.07 ms
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 = 8272) 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 = 8272) 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 = 8272) 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 = 8272) 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 = 8272) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
414 0.12 ms
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=8272) AND (website_id = 0)
415 0.23 ms
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 (8272)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
416 0.13 ms
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=8272) AND (website_id = 0) ORDER BY `qty` ASC
417 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
418 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
419 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
420 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
421 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
422 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
423 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
424 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
425 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
426 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
427 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 8272
428 0.43 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8249, 8251, 8261, 8265, 8267, 8270, 16069, 27177, 29885, 35867, 44729, 58198, 58199, 69289, 69290, 69291, 82273, 82274, 76943, 86494, 86495, 86496, 104312, 104313, 104315)) AND (qty>'0')
429 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=14035)
430 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14036, 27079)) AND (qty>'0')
431 0.11 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=14333)
432 0.21 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14334, 14335, 14337, 18157, 106482, 106483, 106484, 106485)) AND (qty>'0')
433 0.12 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =14333)
434 1.12 ms
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 = 14333) 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 = 14333) 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 = 14333) 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 = 14333) 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 = 14333) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
435 0.11 ms
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=14333) AND (website_id = 0)
436 0.20 ms
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 (14333)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
437 0.13 ms
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=14333) AND (website_id = 0) ORDER BY `qty` ASC
438 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
439 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
440 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
441 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
442 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
443 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
444 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
445 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
446 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
447 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
448 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 14333
449 0.21 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14334, 14335, 14337, 18157, 106482, 106483, 106484, 106485)) AND (qty>'0')
450 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14667)) AND (qty>'0')
451 0.13 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=15612)
452 0.43 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (15619, 15620, 15622, 15624, 15629, 15635, 15637, 27187, 30428, 35904, 44745, 58284, 58285, 69216, 69217, 69218, 75384, 86402, 86403, 86404, 90331, 90332, 104118, 104120, 104121)) AND (qty>'0')
453 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =15612)
454 0.70 ms
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 = 15612) 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 = 15612) 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 = 15612) 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 = 15612) 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 = 15612) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
455 0.13 ms
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=15612) AND (website_id = 0)
456 0.26 ms
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 (15612)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
457 0.13 ms
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=15612) AND (website_id = 0) ORDER BY `qty` ASC
458 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
459 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
460 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
461 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
462 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
463 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
464 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
465 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
466 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
467 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
468 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 15612
469 0.42 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (15619, 15620, 15622, 15624, 15629, 15635, 15637, 27187, 30428, 35904, 44745, 58284, 58285, 69216, 69217, 69218, 75384, 86402, 86403, 86404, 90331, 90332, 104118, 104120, 104121)) AND (qty>'0')
470 0.12 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=16295)
471 0.31 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (16432, 16433, 16435, 16438, 16442, 16448, 16450, 27124, 30427, 35895, 44653, 58292, 58293, 83673, 83674, 83675, 83676, 83677, 83679, 86798, 86799, 86800, 100671, 105450, 105451)) AND (qty>'0')
472 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =16295)
473 1.06 ms
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 = 16295) 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 = 16295) 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 = 16295) 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 = 16295) 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 = 16295) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
474 0.12 ms
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=16295) AND (website_id = 0)
475 0.31 ms
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 (16295)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
476 0.12 ms
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=16295) AND (website_id = 0) ORDER BY `qty` ASC
477 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
478 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
479 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
480 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
481 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
482 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
483 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
484 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
485 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
486 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
487 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 16295
488 0.46 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (16432, 16433, 16435, 16438, 16442, 16448, 16450, 27124, 30427, 35895, 44653, 58292, 58293, 83673, 83674, 83675, 83676, 83677, 83679, 86798, 86799, 86800, 100671, 105450, 105451)) AND (qty>'0')
489 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (17045)) AND (qty>'0')
490 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (17197)) AND (qty>'0')
491 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=18305)
492 0.15 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18306, 18307, 18308, 18309)) AND (qty>'0')
493 0.09 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=18320)
494 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18322, 18323, 18324, 18326, 18328, 18329, 18327)) AND (qty>'0')
495 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =18320)
496 0.96 ms
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 = 18320) 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 = 18320) 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 = 18320) 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 = 18320) 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 = 18320) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
497 0.12 ms
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=18320) AND (website_id = 0)
498 0.24 ms
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 (18320)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
499 0.13 ms
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=18320) AND (website_id = 0) ORDER BY `qty` ASC
500 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
501 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
502 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
503 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
504 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
505 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
506 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
507 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
508 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
509 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
510 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18320
511 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18322, 18323, 18324, 18326, 18328, 18329, 18327)) AND (qty>'0')
512 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18323)) AND (qty>'0')
513 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =18323)
514 1.13 ms
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 = 18323) 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 = 18323) 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 = 18323) 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 = 18323) 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 = 18323) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
515 0.12 ms
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=18323) AND (website_id = 0)
516 0.23 ms
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 (18323)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
517 0.13 ms
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=18323) AND (website_id = 0) ORDER BY `qty` ASC
518 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
519 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
520 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
521 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
522 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
523 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
524 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
525 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
526 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
527 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
528 0.09 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
529 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
530 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18323
531 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18323)) AND (qty>'0')
532 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18327)) AND (qty>'0')
533 0.10 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =18327)
534 1.12 ms
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 = 18327) 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 = 18327) 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 = 18327) 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 = 18327) 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 = 18327) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
535 0.12 ms
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=18327) AND (website_id = 0)
536 0.24 ms
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 (18327)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
537 0.11 ms
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=18327) AND (website_id = 0) ORDER BY `qty` ASC
538 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
539 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
540 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
541 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
542 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
543 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
544 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
545 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
546 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
547 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
548 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
549 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
550 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18327
551 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18327)) AND (qty>'0')
552 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18328)) AND (qty>'0')
553 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =18328)
554 1.12 ms
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 = 18328) 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 = 18328) 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 = 18328) 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 = 18328) 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 = 18328) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
555 0.12 ms
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=18328) AND (website_id = 0)
556 0.23 ms
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 (18328)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
557 0.13 ms
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=18328) AND (website_id = 0) ORDER BY `qty` ASC
558 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
559 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
560 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
561 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
562 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
563 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
564 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
565 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
566 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
567 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
568 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
569 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
570 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 18328
571 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (18328)) AND (qty>'0')
572 0.13 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=7984)
573 0.41 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (7960, 7961, 7963, 7965, 7977, 15991, 27145, 30426, 35963, 44679, 58180, 58181, 86974, 86975, 86976, 86977, 86978, 86979, 86980, 86982, 86983, 52798, 102574)) AND (qty>'0')
574 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (27079)) AND (qty>'0')
575 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (28068)) AND (qty>'0')
576 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (28070)) AND (qty>'0')
577 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=37143)
578 0.18 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (13964, 13965, 37144, 37145, 37147, 37148)) AND (qty>'0')
579 0.10 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (37148)) AND (qty>'0')
580 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=40066)
581 0.28 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (40067, 40068, 40069, 40071, 40076, 40077, 40078, 40079, 103338, 103339, 103340, 103341, 103342, 103343)) AND (qty>'0')
582 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (40189)) AND (qty>'0')
583 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (41609)) AND (qty>'0')
584 0.10 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=41784)
585 0.14 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (41785, 41786, 41790)) AND (qty>'0')
586 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =41784)
587 0.94 ms
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 = 41784) 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 = 41784) 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 = 41784) 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 = 41784) 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 = 41784) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
588 0.13 ms
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=41784) AND (website_id = 0)
589 0.20 ms
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 (41784)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
590 0.13 ms
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=41784) AND (website_id = 0) ORDER BY `qty` ASC
591 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
592 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
593 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
594 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
595 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
596 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
597 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
598 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
599 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
600 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
601 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 41784
602 0.14 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (41785, 41786, 41790)) AND (qty>'0')
603 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (41785)) AND (qty>'0')
604 0.11 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=42571)
605 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (25898, 25899, 25900, 42572, 42573, 42574, 25897)) AND (qty>'0')
606 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =42571)
607 0.95 ms
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 = 42571) 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 = 42571) 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 = 42571) 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 = 42571) 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 = 42571) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
608 0.12 ms
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=42571) AND (website_id = 0)
609 0.26 ms
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 (42571)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
610 0.13 ms
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=42571) AND (website_id = 0) ORDER BY `qty` ASC
611 0.09 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
612 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
613 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
614 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
615 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
616 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
617 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
618 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
619 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
620 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
621 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42571
622 0.19 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (25898, 25899, 25900, 42572, 42573, 42574, 25897)) AND (qty>'0')
623 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42573)) AND (qty>'0')
624 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =42573)
625 1.02 ms
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 = 42573) 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 = 42573) 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 = 42573) 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 = 42573) 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 = 42573) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
626 0.12 ms
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=42573) AND (website_id = 0)
627 0.28 ms
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 (42573)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
628 0.13 ms
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=42573) AND (website_id = 0) ORDER BY `qty` ASC
629 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
630 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
631 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
632 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
633 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
634 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
635 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
636 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
637 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
638 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
639 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
640 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
641 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42573
642 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42573)) AND (qty>'0')
643 0.11 ms
SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=42580)
644 0.18 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42581, 42582, 42583, 42588, 42589, 42590)) AND (qty>'0')
645 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =42580)
646 0.95 ms
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 = 42580) 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 = 42580) 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 = 42580) 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 = 42580) 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 = 42580) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
647 0.12 ms
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=42580) AND (website_id = 0)
648 0.29 ms
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 (42580)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
649 0.13 ms
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=42580) AND (website_id = 0) ORDER BY `qty` ASC
650 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
651 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
652 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
653 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
654 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
655 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
656 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
657 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
658 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
659 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
660 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42580
661 0.18 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42581, 42582, 42583, 42588, 42589, 42590)) AND (qty>'0')
662 0.11 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42582)) AND (qty>'0')
663 0.09 ms
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =42582)
664 1.00 ms
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 = 42582) 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 = 42582) 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 = 42582) 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 = 42582) 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 = 42582) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
665 0.16 ms
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=42582) AND (website_id = 0)
666 0.29 ms
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 (42582)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
667 0.13 ms
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=42582) AND (website_id = 0) ORDER BY `qty` ASC
668 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
669 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
670 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
671 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
672 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
673 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
674 0.11 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
675 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
676 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
677 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
678 0.15 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
679 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
680 0.10 ms
SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)
Parameters: :entity_type_id = 4, :entity_id = 42582
681 0.12 ms
SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42582)) AND (qty>'0')
682 1.65 ms
SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 722 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')

Models

Response Headers

Resource Name Class Count
core/url_rewrite Mage_Core_Model_Url_Rewrite 2
index/process Mage_Index_Model_Process 2
catalog/category_flat Jair_Catalog_Model_Category 2
core/flag Mage_Catalog_Model_Product_Flat_Flag 1
eav/entity_type Mage_Eav_Model_Entity_Type 2
catalog/attribute Mage_Catalog_Model_Resource_Eav_Attribute 16
customer/group Mage_Customer_Model_Group 1

Collections

Loaded Collections

Collections loaded during this request.

# Type Class Count
1 flat Mage_Core_Model_Resource_Store_Collection 1
                                    
                                        SELECT `main_table`.* FROM `core_store` AS `main_table`                                    
                                
2 flat Mage_Core_Model_Resource_Website_Collection 1
                                    
                                        SELECT `main_table`.* FROM `core_website` AS `main_table`                                    
                                
3 flat Mage_Core_Model_Resource_Store_Group_Collection 1
                                    
                                        SELECT `main_table`.* FROM `core_store_group` AS `main_table`                                    
                                
4 flat Mage_Catalog_Model_Resource_Product_Attribute_Collection 1
                                    
                                        SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.`attribute_id`, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
 INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN(4)) AND (`additional_table`.`is_filterable` > 0) GROUP BY `entity_attribute`.`attribute_id`                                    
                                
5 eav Mage_Catalog_Model_Resource_Category_Collection 1
                                    
                                        SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = 31) AND `at_name_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = 31) AND (`at_name`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (IF(at_name.value_id > 0, at_name.value, at_name_default.value) = 'Marques')                                    
                                
6 flat Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection 16
                                    
                                        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)                                    
                                
7 eav Jair_Listing_Catalog_Model_Resource_Eav_Mysql4_Product_Collection 1
                                    
                                        SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 722 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0 WHERE (e.status = 1)                                    
                                
8 flat Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection 1
                                    
                                        SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (`product_id` = '70726')                                    
                                
9 eav Mage_Catalog_Model_Resource_Product_Type_Configurable_Product_Collection 1
                                    
                                        SELECT `e`.*, `link_table`.`parent_id`, `at_color`.`value` AS `color` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id
 INNER JOIN `catalog_product_entity_int` AS `at_color` ON (`at_color`.`entity_id` = `e`.`entity_id`) AND (`at_color`.`attribute_id` = 76) AND (`at_color`.`store_id` = 0) WHERE (link_table.parent_id = 70726) AND (at_color.value IS NOT NULL)                                    
                                
10 flat Mage_CatalogInventory_Model_Resource_Stock_Item_Collection 1
                                    
                                        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(70727, 70728, 70730, 70731, 70732, 70734, 70735, 70738, 70742, 70743, 70744, 70745, 70746, 70748, 70749, 70750, 77111, 83822, 83823, 86422, 86423, 86424, 104043, 104127, 104128))                                    
                                

Database Configuration

Current configurations related to database.

Key Value
global/resources/default_setup/connection/active 1
global/resources/default_setup/connection/dbname jair_r202
global/resources/default_setup/connection/host localhost
global/resources/default_setup/connection/initStatements SET NAMES utf8
global/resources/default_setup/connection/model mysql4
global/resources/default_setup/connection/password JZ7!!:KB@aoA
global/resources/default_setup/connection/persistent
global/resources/default_setup/connection/profiler 1
global/resources/default_setup/connection/type pdo_mysql
global/resources/default_setup/connection/username jair