sulje
Cart

https://meccofi.mydevfactory.com/catalog/category/view/id/12/

  • Controller Module: Magento_Catalog
  • Controller Class: Magento\Catalog\Controller\Category\View
  • Controller Action Name: execute

Database Queries

Nimi Arvo
Executed 444 queries in 0.189 s
Total Queries 444
Insert queries 0
Update queries 1
Read queries 438
Delete queries 0
Tapahtumat 2

Top 5 - Slowest Queries

Query Time (ms) 
              SET NAMES utf8
0.00014091 
              SELECT GET_LOCK(?, ?);
0.00016999 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1155)
0.00018716 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1218)
0.00020695 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1223)
0.000211

All Queries

Query Time (ms) 
              connect
0.00091195 
              SET NAMES utf8
0.00014091 
              SELECT `store_website`.* FROM `store_website`
0.00034499 
              SELECT `store_group`.* FROM `store_group`
0.0002861 
              SELECT `store`.* FROM `store`
0.00030899 
              SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')
0.00050211 
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/12', 'catalog/category/view/id/12/')) AND (`store_id` IN ('1'))
0.00053215 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite`
 LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/category/view/id/12', 'catalog/category/view/id/12/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)
0.00050998 
              SELECT `translation`.`string`, `translation`.`translate`, `translation`.`store_id`, `translation`.`locale` FROM `translation` ORDER BY `store_id` ASC
0.00043702 
              SELECT `translation`.`string`, `translation`.`translate` FROM `translation` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC
0.00043702 
              SELECT `stripe_account`.* FROM `stripe_account` WHERE (`stripe_account`.`secret_key`='5019875dbc8498db66c046f9ca36113fe18f39ba5c4852a0ac1243ae95ad0c71')
0.00046396 
              begin
0.00025296 
              UPDATE `stripe_account` SET `is_valid` = ? WHERE (id=3)
0.00050998 
              commit
0.00021911 
              SELECT COUNT(*) FROM `stripe_customers` AS `main_table` WHERE (`session_id` = 've7lnkuhfohp6l3s080kj1af0o') AND ((`pk` = 'pk_live_51SQ4XoEQhpkV25H3GqHUxNYPTPnrp66C8wr6gGvy7fW1OA1hSJdK794pNmEiRY2cgD1FaebjJ6lTihnYeQ1gcNhn00Vx66HU8g') OR (`pk` IS NULL))
0.00071311 
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =12)
0.00073409 
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 12)
0.00061584 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (59, 60)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (70)) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00214505 
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '12') LIMIT 1
0.00060701 
              SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e`
 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_id` IN('12', '33', '3', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC
0.00106597 
              SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_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 (e.entity_id IN (12, 33, 3, 2)) AND (t_d.attribute_id IN (58, 61, 313)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_datetime` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 33, 3, 2)) AND (t_d.attribute_id IN (59, 60)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_text` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 33, 3, 2)) AND (t_d.attribute_id IN (62)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_int` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 33, 3, 2)) AND (t_d.attribute_id IN (69)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.001755 
              SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)
0.00081801 
              SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)
0.00071502 
              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e`
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_id` IN('3', '33', '12')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
0.00100517 
              SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_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 (e.entity_id IN (3, 12, 33)) AND (t_d.attribute_id IN (41, 43)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00094986 
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('3')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
0.00064301 
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('33')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
0.00060606 
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('12')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
0.00060916 
              SELECT `main_table`.* FROM `checkout_agreement` AS `main_table`
 INNER JOIN `checkout_agreement_store` AS `store_table_1` ON main_table.agreement_id = store_table_1.agreement_id WHERE (store_table_1.store_id IN ('1', 0)) AND ((`is_active` = 1)) GROUP BY `main_table`.`agreement_id`
0.00075412 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='page_menu') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00089478 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='before-category-products') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00089478 
              SELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')
0.00056195 
              SELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=2)
0.00050712 
              SELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 2)
0.00041604 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='position') AND (entity_type_id = :entity_type_id)
0.00055599 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)
0.00068784 
              SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
0.000458 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00047612 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='color') AND (entity_type_id = :entity_type_id)
0.00048804 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00037599 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='material') AND (entity_type_id = :entity_type_id)
0.00049782 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00030112 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='choose_colors') AND (entity_type_id = :entity_type_id)
0.00035095 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00032306 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='hems_model') AND (entity_type_id = :entity_type_id)
0.00047898 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00034809 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='one_or_two_piece') AND (entity_type_id = :entity_type_id)
0.00037694 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00028086 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='length') AND (entity_type_id = :entity_type_id)
0.00046396 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00037599 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='choose_dress') AND (entity_type_id = :entity_type_id)
0.00046992 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.0003469 
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='fastening') AND (entity_type_id = :entity_type_id)
0.00039506 
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
0.00033307 
              SELECT `e`.`entity_id`, `stockItem`.`is_salable`, `cat_index`.`position` FROM `catalog_product_entity` AS `e`
 INNER JOIN `inventory_stock_2` AS `stockItem` ON stockItem.sku = e.sku
 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id = e.entity_id AND cat_index.category_id = 12 AND cat_index.store_id = 1 ORDER BY is_salable DESC, position ASC, entity_id DESC
 LIMIT 12
0.00126696 
              SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
 LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (1225, 1224, 1223, 1222, 1221, 1220, 1219, 1218, 1216, 1213, 1212, 1211)) ORDER BY FIELD(e.entity_id,1225,1224,1223,1222,1221,1220,1219,1218,1216,1213,1212,1211)
0.00125194 
              SELECT `t_d`.`attribute_id`, `e`.`entity_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`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 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 (e.entity_id IN (1225, 1224, 1223, 1222, 1221, 1220, 1219, 1218, 1216, 1213, 1212, 1211)) AND (t_d.attribute_id IN (71, 85, 86, 87, 97, 112, 113, 114, 119, 314, 315, 363)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1225, 1224, 1223, 1222, 1221, 1220, 1219, 1218, 1216, 1213, 1212, 1211)) AND (t_d.attribute_id IN (73, 152, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 362)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1225, 1224, 1223, 1222, 1221, 1220, 1219, 1218, 1216, 1213, 1212, 1211)) AND (t_d.attribute_id IN (76, 120)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1225, 1224, 1223, 1222, 1221, 1220, 1219, 1218, 1216, 1213, 1212, 1211)) AND (t_d.attribute_id IN (77, 78, 93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1225, 1224, 1223, 1222, 1221, 1220, 1219, 1218, 1216, 1213, 1212, 1211)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 133, 151, 374)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00723505 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite`
 LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('1225', '1224', '1223', '1222', '1221', '1220', '1219', '1218', '1216', '1213', '1212', '1211')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id = '12')
0.00105 
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='12')
0.00067592 
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '12')
0.00053406 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '12') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00216985 
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '12') LIMIT 1
0.00063491 
              SELECT `main_table`.* FROM `cataloginventory_stock` AS `main_table`
0.00044107 
              SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=12 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
 LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku
0.00137401 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('VT10201'))
0.00074792 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 552)
0.0006299 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('VT10271'))
0.00050998 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 618)
0.00041318 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('VT10383'))
0.00043702 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 918)
0.00044107 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC100'))
0.00040197 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 966)
0.00037217 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC101'))
0.000314 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 967)
0.00030398 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC102'))
0.00031281 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 968)
0.00032187 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC103'))
0.00034094 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 969)
0.00031805 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC104'))
0.00032592 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 971)
0.00037718 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC105'))
0.00032496 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 972)
0.00040007 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC106'))
0.00043011 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 973)
0.00039601 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC107'))
0.00032306 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 974)
0.00033021 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC108'))
0.00029278 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 975)
0.00030994 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC109'))
0.00028682 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 976)
0.00035095 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC110'))
0.00031304 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 977)
0.00038791 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC111'))
0.00039196 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 978)
0.00047112 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC112'))
0.00042415 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 979)
0.00044203 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC113'))
0.00040197 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 980)
0.00052595 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC114'))
0.00041008 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 981)
0.00043797 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC115'))
0.0003891 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 982)
0.00042701 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC116'))
0.00038791 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 983)
0.00039196 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC117'))
0.00042796 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 984)
0.00035 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC118'))
0.00028801 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 985)
0.00040507 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC119'))
0.00036192 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 986)
0.00040197 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC120'))
0.00032496 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 987)
0.00031996 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC121'))
0.00033498 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 988)
0.00036693 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC122'))
0.00035906 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 989)
0.00038195 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC123'))
0.00034499 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 990)
0.00037694 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC124'))
0.00046992 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 991)
0.00034094 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC125'))
0.00033784 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 992)
0.00037694 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC126'))
0.00035715 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 993)
0.00031996 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC127'))
0.00032496 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 994)
0.00030589 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC128'))
0.00034094 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 995)
0.00036287 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC129'))
0.00029993 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 996)
0.00038099 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC130'))
0.00032783 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 997)
0.00023293 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC131'))
0.00032282 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 998)
0.00045609 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC132'))
0.00040603 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 999)
0.00032687 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC133'))
0.00029612 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1000)
0.00032902 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC135'))
0.00037193 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1002)
0.00036812 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC136'))
0.00033188 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1003)
0.00038505 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC137'))
0.0003891 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1004)
0.00040603 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC138'))
0.00034809 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1005)
0.00043893 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC139'))
0.00032306 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1006)
0.00032592 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC140'))
0.00029397 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1007)
0.00032592 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC021'))
0.0002749 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1008)
0.0003159 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC003'))
0.00031996 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1013)
0.00029588 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC009'))
0.00026608 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1019)
0.00027609 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC010'))
0.0002811 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1020)
0.00029802 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC011'))
0.00029707 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1021)
0.00028896 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC012'))
0.00028896 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1022)
0.00030184 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC016'))
0.00031805 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1026)
0.00038505 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC024'))
0.00031304 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1029)
0.00033808 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC065'))
0.0003171 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1036)
0.00033379 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC066'))
0.00029492 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1037)
0.00032878 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC177'))
0.00032187 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1078)
0.000314 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC178'))
0.00031686 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1079)
0.00043392 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC179'))
0.00035715 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1080)
0.00031805 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC180'))
0.00031495 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1081)
0.00040603 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC181'))
0.00035906 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1082)
0.00034094 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC182'))
0.00033212 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1083)
0.00037909 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC183'))
0.00032115 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1084)
0.00042796 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC184'))
0.00038695 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1085)
0.00038695 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC185'))
0.0003469 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1086)
0.00036407 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC186'))
0.00034094 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1087)
0.00032711 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC187'))
0.00030208 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1088)
0.00032783 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC188'))
0.00037003 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1089)
0.00030518 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC189'))
0.0002799 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1090)
0.0003109 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC192'))
0.00023508 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1093)
0.00025201 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC165'))
0.00033498 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1094)
0.00029707 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC170'))
0.00027394 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1099)
0.00032997 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC171'))
0.00033903 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1100)
0.00033903 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC176'))
0.00026989 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1105)
0.00031495 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC200'))
0.00030994 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1115)
0.0003159 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC023'))
0.00031304 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1116)
0.00030303 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC233'))
0.00029397 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1122)
0.00032187 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC236'))
0.00027299 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1123)
0.00032997 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC239'))
0.00046015 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1124)
0.00034904 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC240'))
0.000314 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1125)
0.00035214 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC235'))
0.00031304 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1126)
0.00040579 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC214'))
0.00038314 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1127)
0.00037193 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC061'))
0.000314 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1128)
0.0003252 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC212'))
0.00037003 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1129)
0.00037003 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC225'))
0.00029612 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1133)
0.00036502 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC229'))
0.00030208 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1135)
0.00030208 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC213'))
0.00027394 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1137)
0.00034094 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC220'))
0.00032306 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1138)
0.00030279 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC223'))
0.00025201 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1139)
0.00036907 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC230'))
0.00035882 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1140)
0.00032592 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC237'))
0.00029397 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1141)
0.00030899 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC218'))
0.000314 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1143)
0.00035405 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC211'))
0.00030398 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1144)
0.00044703 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC209'))
0.00032115 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1145)
0.00031209 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC219'))
0.00030088 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1147)
0.00031281 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC206'))
0.00030804 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1148)
0.00028396 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC224'))
0.00026178 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1151)
0.00030804 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC222'))
0.00026822 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1152)
0.00025105 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC210'))
0.00023508 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1153)
0.00025702 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC241'))
0.00041199 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1154)
0.00022101 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC242'))
0.00022316 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1155)
0.00018716 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC215'))
0.00029683 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1156)
0.00030589 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC243'))
0.00030112 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1157)
0.00035691 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC207'))
0.00028896 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1158)
0.00030303 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC208'))
0.00026393 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1160)
0.00023699 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT1'))
0.00024414 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1203)
0.0002439 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT2'))
0.00025296 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1204)
0.00034595 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT3'))
0.00027013 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1205)
0.00026202 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT4'))
0.0002811 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1206)
0.00033116 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT5'))
0.00030899 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1207)
0.00032187 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT6'))
0.00025821 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1208)
0.00025105 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT7'))
0.00038409 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1209)
0.00026989 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT8'))
0.0002811 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1210)
0.00032806 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT9'))
0.00028801 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1211)
0.0003159 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT10'))
0.00026393 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1212)
0.00027394 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT11'))
0.00031304 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1213)
0.00030899 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT12'))
0.00025201 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1216)
0.00025201 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT13'))
0.00021219 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1218)
0.00020695 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT14'))
0.00026298 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1219)
0.00026703 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT15'))
0.0002799 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1220)
0.00025797 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT16'))
0.00024295 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1221)
0.00023985 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT17'))
0.00024199 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1222)
0.00024199 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT18'))
0.00024199 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1223)
0.000211 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT19'))
0.000283 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1224)
0.00024915 
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT20'))
0.00021911 
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1225)
0.00028801 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1225))
0.00049615 
              SELECT GET_LOCK(?, ?);
0.0003171 
              SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)
0.00051785 
              SELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')
0.00041199 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00038505 
              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 ('2')) AND (rate.tax_country_id = 'FI') 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
0.00074387 
              SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='1')
0.00036001 
              SELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')
0.00041413 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00033784 
              (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 ('2')) AND (rate.tax_country_id = 'FI') AND (rate.tax_region_id IN(0, 336)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '00100', '00100*', '0010*', '001*', '00*', '0*'))) UNION (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'FI') AND (rate.tax_region_id IN(0, 336)) AND (rate.zip_is_range IS NOT NULL) AND ('00100' BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC
0.00102806 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00058317 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1225') ORDER BY `qty` ASC
0.000494 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1225))
0.00030804 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00031209 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00027299 
              SELECT RELEASE_LOCK(?);
0.00032187 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1224))
0.00058699 
              SELECT GET_LOCK(?, ?);
0.00029016 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00052595 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.000458 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1224') ORDER BY `qty` ASC
0.00055885 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1224))
0.00073719 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00032401 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00038505 
              SELECT RELEASE_LOCK(?);
0.000319 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1223))
0.00045204 
              SELECT GET_LOCK(?, ?);
0.00024986 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00042319 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00044107 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1223') ORDER BY `qty` ASC
0.00061297 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1223))
0.00036001 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00037313 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00034189 
              SELECT RELEASE_LOCK(?);
0.00026202 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1222))
0.00051594 
              SELECT GET_LOCK(?, ?);
0.000319 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00043488 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00043416 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1222') ORDER BY `qty` ASC
0.00057697 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1222))
0.000422 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00030518 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00035095 
              SELECT RELEASE_LOCK(?);
0.00048709 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1221))
0.00041509 
              SELECT GET_LOCK(?, ?);
0.00027418 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00037408 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00030184 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1221') ORDER BY `qty` ASC
0.00052595 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1221))
0.00033808 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00034499 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.0002718 
              SELECT RELEASE_LOCK(?);
0.00023699 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1220))
0.00051212 
              SELECT GET_LOCK(?, ?);
0.00025988 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00047088 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00037789 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1220') ORDER BY `qty` ASC
0.00039506 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1220))
0.00047898 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00029707 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00037503 
              SELECT RELEASE_LOCK(?);
0.00032806 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1219))
0.00040913 
              SELECT GET_LOCK(?, ?);
0.00029516 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00036192 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00043082 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1219') ORDER BY `qty` ASC
0.00049019 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1219))
0.0003531 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00032306 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00031281 
              SELECT RELEASE_LOCK(?);
0.00033712 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1218))
0.00040913 
              SELECT GET_LOCK(?, ?);
0.00016999 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00036383 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00040412 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1218') ORDER BY `qty` ASC
0.00046015 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1218))
0.00048304 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00035381 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00040388 
              SELECT RELEASE_LOCK(?);
0.00029516 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1216))
0.00041103 
              SELECT GET_LOCK(?, ?);
0.00023794 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00043797 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00033092 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1216') ORDER BY `qty` ASC
0.00042796 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1216))
0.00035596 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00031209 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00032997 
              SELECT RELEASE_LOCK(?);
0.0003581 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1213))
0.00046015 
              SELECT GET_LOCK(?, ?);
0.00025296 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00040007 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00044012 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1213') ORDER BY `qty` ASC
0.00051904 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1213))
0.00043797 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00037313 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00042796 
              SELECT RELEASE_LOCK(?);
0.00028491 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1212))
0.00045609 
              SELECT GET_LOCK(?, ?);
0.00027108 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00047183 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00056314 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1212') ORDER BY `qty` ASC
0.00050092 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1212))
0.00039506 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00036407 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00030899 
              SELECT RELEASE_LOCK(?);
0.00025201 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1211))
0.00042915 
              SELECT GET_LOCK(?, ?);
0.00035286 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00039387 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.0004158 
              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`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1211') ORDER BY `qty` ASC
0.00058293 
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-05') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1211))
0.00039005 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00041103 
              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00034785 
              SELECT RELEASE_LOCK(?);
0.00050116 
              SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level)
0.00069213 
              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
 LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('')) ORDER BY `e`.`position` ASC
0.00073004 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='sidebar-additional-custom') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00069213 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='block_footer_top') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00067711 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='block_footer_bottom') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00060916 
              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '51')
0.00034189 
              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
0.00037718 
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =33)
0.00064683 
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 33)
0.00033998 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0010941 
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '33') LIMIT 1
0.0003581 
              SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level)
0.00070691 
              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
 LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('10', '11', '12', '19', '20', '22', '4', '5')) ORDER BY `e`.`position` ASC
0.00109911 
              SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_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 (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (43, 41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_text` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_int` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (51)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00135899 
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =21)
0.00044703 
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 21)
0.00039506 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00153804 
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '21') LIMIT 1
0.00037789 
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('21')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
0.00042391 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer_links') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00054193 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='payment') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00047994
Developer
2.4.5
1.58 s
20.00 MB
444 q / 0.189 s
Return to Site