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 339 queries in 0.078 s
Total Queries 339
Insert queries 0
Update queries 1
Read queries 334
Delete queries 0
Tapahtumat 2

Top 5 - Slowest Queries

Query Time (ms)
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 979)
            
9.322E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC110'))
            
9.394E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC112'))
            
9.489E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC131'))
            
9.489E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 994)
            
9.513E-5

All Queries

Query Time (ms)
              connect
            
0.00064015
              SET NAMES utf8
            
9.704E-5
              SELECT `store_website`.* FROM `store_website`
            
0.00021005
              SELECT `store_group`.* FROM `store_group`
            
0.00015903
              SELECT `store`.* FROM `store`
            
0.0001359
              SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')
            
0.00043702
              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.00061202
              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.00048113
              SELECT `stripe_account`.* FROM `stripe_account` WHERE (`stripe_account`.`secret_key`='5019875dbc8498db66c046f9ca36113fe18f39ba5c4852a0ac1243ae95ad0c71')
            
0.0004859
              begin
            
0.00020289
              UPDATE `stripe_account` SET `is_valid` = ? WHERE (id=3)
            
0.00044298
              commit
            
0.000103
              SELECT COUNT(*) FROM `stripe_customers` AS `main_table` WHERE (`session_id` = 'iofepkmj31hquaa8ceur2t5pnt') AND ((`pk` = 'pk_live_51SQ4XoEQhpkV25H3GqHUxNYPTPnrp66C8wr6gGvy7fW1OA1hSJdK794pNmEiRY2cgD1FaebjJ6lTihnYeQ1gcNhn00Vx66HU8g') OR (`pk` IS NULL))
            
0.00041699
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =12)
            
0.00035596
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 12)
            
0.00045586
              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.00128007
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '12') LIMIT 1
            
0.00026703
              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.00068402
              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.00124979
              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.00052881
              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.00043893
              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.0007298
              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.00051093
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('3')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            
0.00029612
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('33')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            
0.00027514
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('12')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            
0.0002389
              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.00062609
              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.00060606
              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.00060892
              SELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')
            
0.00048494
              SELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=2)
            
0.00033617
              SELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 2)
            
0.0002048
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='position') AND (entity_type_id = :entity_type_id)
            
0.00046992
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)
            
0.00050807
              SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
            
0.00020909
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00049806
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='color') AND (entity_type_id = :entity_type_id)
            
0.00029397
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00019121
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='material') AND (entity_type_id = :entity_type_id)
            
0.00023103
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00018597
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='choose_colors') AND (entity_type_id = :entity_type_id)
            
0.00023198
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00020599
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='hems_model') AND (entity_type_id = :entity_type_id)
            
0.00030804
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00020003
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='one_or_two_piece') AND (entity_type_id = :entity_type_id)
            
0.00023413
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00033617
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='length') AND (entity_type_id = :entity_type_id)
            
0.00023103
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00014806
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='choose_dress') AND (entity_type_id = :entity_type_id)
            
0.00015116
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.00012803
              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='fastening') AND (entity_type_id = :entity_type_id)
            
0.00014901
              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            
0.000144
              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.00101209
              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.00083995
              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.00523806
              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.00075316
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='12')
            
0.00053716
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '12')
            
0.000247
              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.00103307
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '12') LIMIT 1
            
0.00021291
              SELECT `main_table`.* FROM `cataloginventory_stock` AS `main_table`
            
0.00060081
              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.00089002
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('VT10201'))
            
0.00026298
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 552)
            
0.00051689
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('VT10271'))
            
0.00017405
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 618)
            
0.00014496
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('VT10383'))
            
0.00012493
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 918)
            
0.00012517
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC100'))
            
0.00014019
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 966)
            
0.00011301
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC101'))
            
0.00010204
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 967)
            
9.894E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC102'))
            
9.799E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 968)
            
9.918E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC103'))
            
0.00011897
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 969)
            
0.00010395
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC104'))
            
0.00013494
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 971)
            
0.00015497
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC105'))
            
0.00011396
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 972)
            
0.000103
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC106'))
            
0.0001061
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 973)
            
0.00010395
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC107'))
            
9.799E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 974)
            
0.00012589
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC108'))
            
0.00011706
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 975)
            
0.00012112
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC109'))
            
0.00010109
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 976)
            
9.584E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC110'))
            
9.394E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 977)
            
0.00012088
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC111'))
            
0.00010395
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 978)
            
9.608E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC112'))
            
9.489E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 979)
            
9.322E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC113'))
            
0.00011706
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 980)
            
0.0001111
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC114'))
            
9.704E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 981)
            
0.0001061
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC115'))
            
0.00011802
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 982)
            
0.00010204
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC116'))
            
0.00011897
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 983)
            
0.00010395
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC117'))
            
9.584E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 984)
            
9.608E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC118'))
            
0.000103
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 985)
            
0.00011182
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC119'))
            
0.000103
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 986)
            
9.894E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC120'))
            
9.799E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 987)
            
0.00011683
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC121'))
            
0.00012612
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 988)
            
0.00011396
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC122'))
            
0.00010204
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 989)
            
9.799E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC123'))
            
0.00011897
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 990)
            
0.000139
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC124'))
            
0.00010204
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 991)
            
9.823E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC125'))
            
0.000103
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 992)
            
0.00011992
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC126'))
            
0.00011206
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 993)
            
0.00010681
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC127'))
            
9.894E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 994)
            
9.513E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC128'))
            
9.68E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 995)
            
0.00010014
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC129'))
            
0.000103
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 996)
            
0.00012088
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC130'))
            
0.000103
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 997)
            
9.704E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC131'))
            
9.489E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 998)
            
9.799E-5
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC132'))
            
0.00011992
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 999)
            
0.00013399
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC133'))
            
0.0001061
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1000)
            
0.000103
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC135'))
            
9.608E-5
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1002)
            
0.00015497
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC136'))
            
0.00011396
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1003)
            
0.000139
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC137'))
            
0.00010514
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1004)
            
0.00012207
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC138'))
            
0.000144
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1005)
            
0.00016093
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC139'))
            
0.00013685
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1006)
            
0.00013494
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC140'))
            
0.00013614
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1007)
            
0.00015593
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC021'))
            
0.00014496
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1008)
            
0.00012398
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC003'))
            
0.00011802
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1013)
            
0.00011396
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC009'))
            
0.00011301
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1019)
            
0.00012803
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC010'))
            
0.00011516
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1020)
            
0.00011802
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC011'))
            
0.00011802
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1021)
            
0.00011086
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC012'))
            
0.00011992
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1022)
            
0.00011587
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC016'))
            
0.00011182
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1026)
            
0.000139
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC024'))
            
0.00014615
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1029)
            
0.00013709
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC065'))
            
0.00013781
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1036)
            
0.00012016
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC066'))
            
0.00012016
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1037)
            
0.00016594
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC177'))
            
0.00013018
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1078)
            
0.00014114
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC178'))
            
0.00012398
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1079)
            
0.00010991
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC179'))
            
0.000144
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1080)
            
0.00012398
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC180'))
            
0.0001092
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1081)
            
0.0001092
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC181'))
            
0.00010705
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1082)
            
0.00011897
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC182'))
            
0.00014091
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1083)
            
0.0001359
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC183'))
            
0.0001862
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1084)
            
0.00029612
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC184'))
            
0.00016284
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1085)
            
0.00012803
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC185'))
            
0.00011396
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1086)
            
0.00010896
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC186'))
            
0.0001049
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1087)
            
0.0001421
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC187'))
            
0.00012207
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1088)
            
0.0001092
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC188'))
            
0.00011706
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1089)
            
0.00011396
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC189'))
            
0.0001061
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1090)
            
0.0001018
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC192'))
            
0.0001061
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1093)
            
0.000108
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC165'))
            
0.00010109
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1094)
            
0.00011992
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC170'))
            
0.00012612
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1099)
            
0.00015306
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC171'))
            
0.00019383
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1100)
            
0.00027108
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC176'))
            
0.00024605
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1105)
            
0.00022507
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC200'))
            
0.00019717
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1115)
            
0.00020099
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC023'))
            
0.00018406
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1116)
            
0.00016713
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC233'))
            
0.00017381
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1122)
            
0.00021195
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC236'))
            
0.00021911
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1123)
            
0.0001781
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC239'))
            
0.00017905
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1124)
            
0.00016999
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC240'))
            
0.00018597
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1125)
            
0.00014591
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC235'))
            
0.00014615
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1126)
            
0.00018001
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC214'))
            
0.00022483
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1127)
            
0.00019884
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC061'))
            
0.00022483
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1128)
            
0.00020194
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC212'))
            
0.00017881
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1129)
            
0.0002141
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC225'))
            
0.00018096
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1133)
            
0.00016594
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC229'))
            
0.00020194
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1135)
            
0.00018096
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC213'))
            
0.00019193
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1137)
            
0.00017214
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC220'))
            
0.00018978
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1138)
            
0.00015521
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC223'))
            
0.0001328
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1139)
            
0.00026298
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC230'))
            
0.00017905
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1140)
            
0.00015688
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC237'))
            
0.00014591
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1141)
            
0.00015497
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC218'))
            
0.0001452
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1143)
            
0.00013494
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC211'))
            
0.00013804
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1144)
            
0.00013399
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC209'))
            
0.00024104
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1145)
            
0.00020504
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC219'))
            
0.00022006
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1147)
            
0.00019884
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC206'))
            
0.00021815
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1148)
            
0.00018597
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC224'))
            
0.00015116
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1151)
            
0.00017619
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC222'))
            
0.00018382
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1152)
            
0.00024104
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC210'))
            
0.00028086
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1153)
            
0.00017691
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC241'))
            
0.00013113
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1154)
            
0.00015998
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC242'))
            
0.00013781
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1155)
            
0.00012684
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC215'))
            
0.00011206
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1156)
            
0.0001061
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC243'))
            
0.00010514
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1157)
            
0.00011492
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC207'))
            
0.00011683
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1158)
            
0.00012112
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MEC208'))
            
0.00013304
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1160)
            
0.00013113
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT1'))
            
0.00016022
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1203)
            
0.00013685
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT2'))
            
0.00019407
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1204)
            
0.00014496
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT3'))
            
0.00013185
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1205)
            
0.00012779
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT4'))
            
0.00016689
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1206)
            
0.00014496
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT5'))
            
0.00012207
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1207)
            
0.00012398
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT6'))
            
0.00019503
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1208)
            
0.00015211
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT7'))
            
0.00011802
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1209)
            
0.00010705
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT8'))
            
0.000103
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1210)
            
0.00012493
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT9'))
            
0.00011492
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1211)
            
0.00011802
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT10'))
            
0.00012016
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1212)
            
0.00011182
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT11'))
            
0.00015378
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1213)
            
0.00013614
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT12'))
            
0.0001061
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1216)
            
0.00010681
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT13'))
            
0.000103
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1218)
            
0.00017095
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT14'))
            
0.00014019
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1219)
            
0.00011897
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT15'))
            
0.00011086
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1220)
            
0.00010705
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT16'))
            
0.00010109
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1221)
            
0.00011301
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT17'))
            
0.0001111
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1222)
            
0.0001061
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT18'))
            
0.00011396
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1223)
            
0.00011587
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT19'))
            
0.00012183
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1224)
            
0.00011897
              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('MECT20'))
            
0.00012016
              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 1225)
            
0.00012493
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1225))
            
0.0004611
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1224))
            
0.00053191
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1223))
            
0.00035787
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1222))
            
0.00030303
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1221))
            
0.00022197
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1220))
            
0.00026894
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1219))
            
0.00026393
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1218))
            
0.00024605
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1216))
            
0.00025702
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1213))
            
0.00024915
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1212))
            
0.00027514
              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1211))
            
0.00028014
              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.00064492
              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.00046897
              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.00043607
              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.00054216
              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.0004499
              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '51')
            
0.00025892
              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.00029588
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =33)
            
0.00026107
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 33)
            
0.00023198
              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.00086498
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '33') LIMIT 1
            
0.00017285
              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.00039196
              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.00074291
              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.00106215
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =21)
            
0.00017405
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 21)
            
0.00012898
              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.00105309
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '21') LIMIT 1
            
0.00020814
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('21')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            
0.00022793
              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.00046706
              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.00045109
Developer
2.4.5
0.95 s
22.00 MB
339 q / 0.078 s