https://menzzo2anis.trydev.ovh/pouf-rond-daisy-tissu-beige-pied-or.html

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

Database Queries

Nom Valeur
Executed 296 queries in 0.146 s
Total Queries 296
Insert queries 2
Update queries 0
Read queries 289
Delete queries 0
Transactions 2

Top 5 - Slowest Queries

Query Time (ms) 
              SET NAMES utf8
0.00011587 
              SELECT `mz_tax_class`.* FROM `mz_tax_class` WHERE (`mz_tax_class`.`class_id`='5')
0.00011706 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.00012207 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00012207 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '156')
0.00012279

All Queries

Query Time (ms) 
              connect
0.00083518 
              SET NAMES utf8
0.00011587 
              SELECT `mz_store_website`.* FROM `mz_store_website`
0.00013399 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.00012207 
              SELECT `mz_store`.* FROM `mz_store`
0.00013685 
              SELECT `mz_flag`.* FROM `mz_flag` WHERE (`mz_flag`.`flag_code`='config_hash')
0.00022292 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('pouf-rond-daisy-tissu-beige-pied-or.html', 'pouf-rond-daisy-tissu-beige-pied-or.html/')) AND (`store_id` IN ('3'))
0.00068593 
              SELECT `main_table`.* FROM `mz_mageworx_seoredirects_redirect_custom` AS `main_table` WHERE (`status` = '1') AND ((request_entity_type = 2 AND request_entity_identifier = 6287) OR (request_entity_type = 1 AND request_entity_identifier = 'pouf-rond-daisy-tissu-beige-pied-or.html')) AND ('2024-12-11 21:07:48' BETWEEN IFNULL(`main_table`.`start_at`, NOW() - INTERVAL 1 DAY) AND IFNULL(`main_table`.`finish_at`, NOW() + INTERVAL 1 DAY)) AND (store_id IN('3', 0)) ORDER BY request_entity_type ASC
0.00036621 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('pouf-rond-daisy-tissu-beige-pied-or.html', 'pouf-rond-daisy-tissu-beige-pied-or.html/')) AND (`store_id` IN ('3'))
0.000283 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_product_flat')
0.00025821 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/product/view/id/6287', 'catalog/product/view/id/6287/')) AND (`store_id` IN ('3'))
0.00032496 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/product/view/id/6287', 'catalog/product/view/id/6287/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00028801 
              SELECT `main_table`.* FROM `mz_mageworx_seoredirects_redirect_custom` AS `main_table` WHERE (`status` = '1') AND ((request_entity_type = 1 AND request_entity_identifier = 'catalog/product/view/id/6287')) AND ('2024-12-11 21:07:48' BETWEEN IFNULL(`main_table`.`start_at`, NOW() - INTERVAL 1 DAY) AND IFNULL(`main_table`.`finish_at`, NOW() + INTERVAL 1 DAY)) AND (store_id IN('3', 0))
0.0003221 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/product/view/id/6287', 'catalog/product/view/id/6287/')) AND (`store_id` IN ('3'))
0.00024104 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/product/view/id/6287', 'catalog/product/view/id/6287/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00024986 
              SELECT `mz_catalog_product_entity`.* FROM `mz_catalog_product_entity` WHERE (entity_id =6287)
0.00037313 
              SELECT `t`.* FROM `mz_catalog_product_entity` AS `t` WHERE (entity_id = 6287)
0.00024009 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_int` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (273, 2319, 1033, 1116, 863, 988, 2249, 1164, 860, 2246, 1110, 1055, 110, 859, 1058, 274, 958, 1063, 1187, 965, 1071, 861, 1079, 1083, 862, 526, 1048, 992, 2192, 1078, 2193, 1173, 272, 2194, 2195, 2188, 2190, 102, 2189, 1020, 2191, 1003, 949, 1018, 1135, 1129, 1126, 1178, 2248, 999, 1170, 2322, 2324, 904, 947, 1191, 2169, 2170)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_varchar` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (978, 2187, 106, 1146, 929, 562, 96, 979, 109, 481, 1043, 1115, 836, 2247, 493, 103, 1045, 1114, 571, 1002, 1192, 1046, 1117, 1001, 1188, 703, 105, 1118, 1112, 271, 1216, 1119, 507, 985, 1160, 1127, 1123, 1064, 1134, 990, 1076, 570, 1165, 987, 1132, 1019, 998, 1008, 879, 880, 1128, 951, 881, 2204, 952, 2205, 1007, 1089, 1090, 1091, 1092, 1093, 1169, 1094, 1095, 2202, 1096, 2203, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 962, 2168, 2174, 2286, 2290, 2294, 2298, 2302, 2306, 2310, 2314, 2287, 2291, 2295, 2299, 2303, 2307, 2311, 2315, 2288, 2292, 2296, 2300, 2304, 2308, 2312, 2316, 2289, 2293, 2297, 2301, 2305, 2309, 2313, 2317, 905, 906)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_decimal` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (1028, 1000, 567, 99, 503, 100, 101, 986, 270, 1107, 1131, 1108, 1109, 993, 2196, 953)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_datetime` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (572, 573, 568, 569, 704, 705, 2206)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_text` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (2186, 506, 531, 97, 104, 976, 977, 494, 1017, 1125, 2325, 1150, 2184, 2254, 2258, 2262, 2266, 2270, 2274, 2278, 2282, 2255, 2259, 2263, 2267, 2271, 2275, 2279, 2283, 2256, 2260, 2264, 2268, 2272, 2276, 2280, 2284, 2257, 2261, 2265, 2269, 2273, 2277, 2281, 2321, 2285)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.01172304 
              SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `mz_catalog_product_option` AS `main_table`
 INNER JOIN `mz_catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id
 INNER JOIN `mz_catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
 LEFT JOIN `mz_catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 3
 LEFT JOIN `mz_catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
 LEFT JOIN `mz_catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 3 WHERE (`cpe`.`entity_id` = '6287') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC
0.00154305 
              SELECT `main_table`.*, `default_value_title`.`title` AS `default_title`, `store_value_title`.`title` AS `store_title`, IF(store_value_title.title IS NULL, default_value_title.title, store_value_title.title) AS `title`, `default_value_price`.`price` AS `default_price`, `default_value_price`.`price_type` AS `default_price_type`, `store_value_price`.`price` AS `store_price`, `store_value_price`.`price_type` AS `store_price_type`, IF(store_value_price.price IS NULL, default_value_price.price, store_value_price.price) AS `price`, IF(store_value_price.price_type IS NULL, default_value_price.price_type, store_value_price.price_type) AS `price_type` FROM `mz_catalog_product_option_type_value` AS `main_table`
 INNER JOIN `mz_catalog_product_option_type_title` AS `default_value_title` ON default_value_title.option_type_id = main_table.option_type_id
 LEFT JOIN `mz_catalog_product_option_type_title` AS `store_value_title` ON store_value_title.option_type_id = main_table.option_type_id AND store_value_title.store_id = 3
 LEFT JOIN `mz_catalog_product_option_type_price` AS `default_value_price` ON default_value_price.option_type_id = main_table.option_type_id AND default_value_price.store_id = 0
 LEFT JOIN `mz_catalog_product_option_type_price` AS `store_value_price` ON store_value_price.option_type_id = main_table.option_type_id AND store_value_price.store_id = 3 WHERE (default_value_title.store_id = 0) AND (`option_id` IN('11269', '11270')) ORDER BY sort_order ASC, title ASC
0.00037694 
              SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `mz_catalog_product_entity_media_gallery` AS `main`
 INNER JOIN `mz_catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 3 AND value.entity_id = entity.entity_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '703') AND (main.disabled = 0) AND (entity.entity_id = '6287') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
0.0010798 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 6287)
0.00047493 
              SELECT `mz_catalog_product_website`.`website_id` FROM `mz_catalog_product_website` WHERE (product_id = 6287)
0.00034118 
              SELECT `main_table`.*, `cp_table`.`type_id` FROM `mz_cataloginventory_stock_item` AS `main_table`
 INNER JOIN `mz_catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('6287'))
0.00051713 
              SELECT `mz_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mz_catalog_product_entity_tier_price`.`website_id`, `mz_catalog_product_entity_tier_price`.`all_groups`, `mz_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mz_catalog_product_entity_tier_price`.`value` AS `price`, `mz_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mz_catalog_product_entity_tier_price`.`percentage_value`, `mz_catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `mz_catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '6287') ORDER BY `qty` ASC
0.0002799 
              SELECT `mz_directory_currency_rate`.`rate` FROM `mz_directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to = :currency_to)
0.00026894 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 6287)
0.00026798 
              SELECT `mz_catalog_product_entity`.`sku`, `mz_catalog_product_entity`.`entity_id` FROM `mz_catalog_product_entity` WHERE (sku IN ('lsr19123beigefabric'))
0.00021791 
              SELECT `mz_inventory_stock_sales_channel`.`stock_id` FROM `mz_inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')
0.00019217 
              SELECT `mz_inventory_stock`.* FROM `mz_inventory_stock` WHERE (`mz_inventory_stock`.`stock_id`=1)
0.00017691 
              SELECT `mz_inventory_stock_sales_channel`.* FROM `mz_inventory_stock_sales_channel` WHERE (stock_id = 1)
0.00016284 
              SELECT `mz_cataloginventory_stock_status`.`qty` AS `quantity`, `mz_cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `mz_cataloginventory_stock_status` WHERE (product_id = 6287)
0.00053287 
              SELECT `mz_catalog_product_entity`.* FROM `mz_catalog_product_entity` WHERE (entity_id =6287)
0.00023484 
              SELECT `t`.* FROM `mz_catalog_product_entity` AS `t` WHERE (entity_id = 6287)
0.00023484 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_int` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (273, 2319, 1033, 1116, 863, 988, 2249, 1164, 860, 2246, 1110, 1055, 110, 859, 1058, 274, 958, 1063, 1187, 965, 1071, 861, 1079, 1083, 862, 526, 1048, 992, 2192, 1078, 2193, 1173, 272, 2194, 2195, 2188, 2190, 102, 2189, 1020, 2191, 1003, 949, 1018, 1135, 1129, 1126, 1178, 2248, 999, 1170, 2322, 2324, 904, 947, 1191, 2169, 2170)) AND (`store_id` IN ('3', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_varchar` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (978, 2187, 106, 1146, 929, 562, 96, 979, 109, 481, 1043, 1115, 836, 2247, 493, 103, 1045, 1114, 571, 1002, 1192, 1046, 1117, 1001, 1188, 703, 105, 1118, 1112, 271, 1216, 1119, 507, 985, 1160, 1127, 1123, 1064, 1134, 990, 1076, 570, 1165, 987, 1132, 1019, 998, 1008, 879, 880, 1128, 951, 881, 2204, 952, 2205, 1007, 1089, 1090, 1091, 1092, 1093, 1169, 1094, 1095, 2202, 1096, 2203, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 962, 2168, 2174, 2286, 2290, 2294, 2298, 2302, 2306, 2310, 2314, 2287, 2291, 2295, 2299, 2303, 2307, 2311, 2315, 2288, 2292, 2296, 2300, 2304, 2308, 2312, 2316, 2289, 2293, 2297, 2301, 2305, 2309, 2313, 2317, 905, 906)) AND (`store_id` IN ('3', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_decimal` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (1028, 1000, 567, 99, 503, 100, 101, 986, 270, 1107, 1131, 1108, 1109, 993, 2196, 953)) AND (`store_id` IN ('3', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_datetime` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (572, 573, 568, 569, 704, 705, 2206)) AND (`store_id` IN ('3', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_text` AS `t` WHERE (entity_id = '6287') AND (attribute_id IN (2186, 506, 531, 97, 104, 976, 977, 494, 1017, 1125, 2325, 1150, 2184, 2254, 2258, 2262, 2266, 2270, 2274, 2278, 2282, 2255, 2259, 2263, 2267, 2271, 2275, 2279, 2283, 2256, 2260, 2264, 2268, 2272, 2276, 2280, 2284, 2257, 2261, 2265, 2269, 2273, 2277, 2281, 2321, 2285)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00634623 
              SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `mz_catalog_product_option` AS `main_table`
 INNER JOIN `mz_catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id
 INNER JOIN `mz_catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
 LEFT JOIN `mz_catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 3
 LEFT JOIN `mz_catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
 LEFT JOIN `mz_catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 3 WHERE (`cpe`.`entity_id` = '6287') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC
0.00051498 
              SELECT `main_table`.*, `default_value_title`.`title` AS `default_title`, `store_value_title`.`title` AS `store_title`, IF(store_value_title.title IS NULL, default_value_title.title, store_value_title.title) AS `title`, `default_value_price`.`price` AS `default_price`, `default_value_price`.`price_type` AS `default_price_type`, `store_value_price`.`price` AS `store_price`, `store_value_price`.`price_type` AS `store_price_type`, IF(store_value_price.price IS NULL, default_value_price.price, store_value_price.price) AS `price`, IF(store_value_price.price_type IS NULL, default_value_price.price_type, store_value_price.price_type) AS `price_type` FROM `mz_catalog_product_option_type_value` AS `main_table`
 INNER JOIN `mz_catalog_product_option_type_title` AS `default_value_title` ON default_value_title.option_type_id = main_table.option_type_id
 LEFT JOIN `mz_catalog_product_option_type_title` AS `store_value_title` ON store_value_title.option_type_id = main_table.option_type_id AND store_value_title.store_id = 3
 LEFT JOIN `mz_catalog_product_option_type_price` AS `default_value_price` ON default_value_price.option_type_id = main_table.option_type_id AND default_value_price.store_id = 0
 LEFT JOIN `mz_catalog_product_option_type_price` AS `store_value_price` ON store_value_price.option_type_id = main_table.option_type_id AND store_value_price.store_id = 3 WHERE (default_value_title.store_id = 0) AND (`option_id` IN('11269', '11270')) ORDER BY sort_order ASC, title ASC
0.00037813 
              SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `mz_catalog_product_entity_media_gallery` AS `main`
 INNER JOIN `mz_catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 3 AND value.entity_id = entity.entity_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id
 LEFT JOIN `mz_catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '703') AND (main.disabled = 0) AND (entity.entity_id = '6287') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
0.0005939 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 6287)
0.00022793 
              SELECT `mz_catalog_product_website`.`website_id` FROM `mz_catalog_product_website` WHERE (product_id = 6287)
0.00021219 
              SELECT `mz_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mz_catalog_product_entity_tier_price`.`website_id`, `mz_catalog_product_entity_tier_price`.`all_groups`, `mz_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mz_catalog_product_entity_tier_price`.`value` AS `price`, `mz_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mz_catalog_product_entity_tier_price`.`percentage_value`, `mz_catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `mz_catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '6287') ORDER BY `qty` ASC
0.00027895 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 6287)
0.00024319 
              SELECT `mz_catalog_category_product_index_store3`.`product_id` FROM `mz_catalog_category_product_index_store3` WHERE (product_id = 6287) AND (category_id = 0)
0.00043297 
              SELECT `mz_catalog_product_website`.`website_id` FROM `mz_catalog_product_website` WHERE (product_id = 6287)
0.00024486 
              SELECT `mz_catalog_category_product_index_store3`.`product_id` FROM `mz_catalog_category_product_index_store3` WHERE (product_id = 6287) AND (category_id = 0)
0.00019789 
              SELECT `ft`.`related_products` AS `ax_related_products`, `ft`.`crosssell_products` AS `ax_crosssell_products`, `ft`.`ax_model_products` FROM `mz_axelites_cached_product_static` AS `ft` WHERE (ft.product_id = '6287') AND (ft.store_id = 3)
0.00065994 
              SELECT `mz_catalogrule_product_price`.`product_id`, `mz_catalogrule_product_price`.`rule_price` FROM `mz_catalogrule_product_price` WHERE (rule_date = '2024-12-11') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(6287))
0.00030303 
              INSERT  INTO `mz_report_viewed_product_index` (`visitor_id`,`product_id`,`store_id`) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE `visitor_id` = VALUES(`visitor_id`), `product_id` = VALUES(`product_id`), `store_id` = VALUES(`store_id`)
0.00129199 
              SELECT COUNT(DISTINCT e.entity_id) FROM `mz_catalog_product_flat_3` AS `e`
 INNER JOIN `mz_report_viewed_product_index` AS `idx_table` ON (idx_table.product_id=e.entity_id) AND (idx_table.visitor_id = '')
 INNER JOIN `mz_catalog_category_product_index_store3` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=3 AND cat_index.category_id=3 WHERE (cat_index.visibility IN(3, 2, 4, 5, 6))
0.00044608 
              begin
0.00013304 
              INSERT INTO `mz_report_event` (`logged_at`, `event_type_id`, `object_id`, `subtype`, `store_id`) VALUES ('2024-12-11 21:07:48', ?, ?, ?, ?)
0.00043201 
              commit
0.0002501 
              SELECT `mz_catalog_category_product_index_store3`.`product_id` FROM `mz_catalog_category_product_index_store3` WHERE (product_id = 6287) AND (category_id = 0)
0.00023603 
              SELECT `layout_update`.`xml`, `layout_update`.`handle` FROM `mz_layout_update` AS `layout_update`
 INNER JOIN `mz_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.theme_id = :theme_id) AND (link.is_temporary = 0) ORDER BY `layout_update`.`sort_order` ASC
0.000319 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_category_flat')
0.00029612 
              SELECT `main_table`.* FROM `mz_mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'product') AND (`source_entity_id` = '6287') AND (`source_store_id` IN(0, 3)) ORDER BY source_store_id DESC
0.00028801 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('6287')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (3)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL)
0.00079799 
              SELECT `mz_core_config_data`.`scope`, `mz_core_config_data`.`scope_id`, `mz_core_config_data`.`path`, `mz_core_config_data`.`value` FROM `mz_core_config_data` WHERE (path IN ('general/locale/code', 'general/country/default', 'mageworx_seo/base/canonical/product_canonical_url_type', 'mageworx_seo/base/canonical/trailing_slash_home_page', 'mageworx_seo/base/canonical/trailing_slash', 'catalog/seo/product_use_categories', 'web/secure/base_url', 'web/secure/use_in_frontend', 'web/secure/base_link_url', 'web/unsecure/base_url', 'web/unsecure/base_link_url', 'web/url/use_store')) AND (scope IN ('stores', 'websites'))
0.00672293 
              SELECT `mz_store`.`website_id`, `mz_store`.`store_id` FROM `mz_store` WHERE (store_id != 0)
0.00022912 
              SELECT `e`.`entity_id`, `url_rewrite`.`store_id`, `url_rewrite`.`request_path` FROM `mz_catalog_product_entity` AS `e`
 INNER JOIN `mz_catalog_product_website` AS `w` ON e.entity_id = w.product_id
 INNER JOIN `mz_store` AS `store` ON w.website_id = store.website_id AND store.is_active = 1
 LEFT JOIN `mz_catalog_product_entity_int` AS `status_tab` ON status_tab.attribute_id = '273' AND e.entity_id = status_tab.entity_id AND store.store_id = status_tab.store_id
 LEFT JOIN `mz_catalog_product_entity_int` AS `status_tab_2` ON status_tab_2.attribute_id = '273' AND e.entity_id = status_tab_2.entity_id AND status_tab_2.store_id = 0
 INNER JOIN `mz_url_rewrite` AS `url_rewrite` ON e.entity_id = url_rewrite.entity_id AND url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id IN(3, 2, 14, 23, 25, 26, 28, 29) AND url_rewrite.entity_type = 'product' AND store.store_id = url_rewrite.store_id
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `catalog_url_rewrite` ON url_rewrite.url_rewrite_id = catalog_url_rewrite.url_rewrite_id WHERE (e.entity_id IN('6287')) AND (CASE WHEN status_tab.value IS NULL THEN status_tab_2.value = 1 ELSE status_tab.value = 1 END) AND (`url_rewrite`.`entity_id` IN (6287)  AND `url_rewrite`.`store_id` IN (3,2,14,23,25,26,28,29) AND `url_rewrite`.`metadata` IS NULL)
0.00316811 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('6287')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (3)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL)
0.00027394 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00025511 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00023603 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00159812 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00022602 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00022507 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00019813 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00104499 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00019097 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='156')
0.00019288 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '156')
0.00013304 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00153589 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '156') LIMIT 1
0.00021195 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00021386 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00018215 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00107384 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00022507 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00021601 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00023007 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00146294 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00024509 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='245')
0.00019789 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '245')
0.00016904 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00131488 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '245') LIMIT 1
0.00013423 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00012493 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00018311 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00114799 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00017381 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='61')
0.00012708 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '61')
0.00014186 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00118899 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '61') LIMIT 1
0.000144 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00013089 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00012517 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00093412 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00012302 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00014591 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00015998 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00138903 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00012803 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='156')
0.00012302 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '156')
0.00013304 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00124717 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '156') LIMIT 1
0.00013208 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00012612 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00013113 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00118685 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00012398 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00015903 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00012422 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00116301 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00012493 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='245')
0.00012398 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '245')
0.00012398 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00096607 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '245') LIMIT 1
0.00015497 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00012517 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00013208 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00106597 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00012207 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='61')
0.00012517 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '61')
0.00012708 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00140285 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '61') LIMIT 1
0.00015306 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00019097 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00014806 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00142908 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00013494 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00012589 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00012493 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0013361 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00012517 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='156')
0.00012398 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '156')
0.00012398 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0014379 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '156') LIMIT 1
0.00017095 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.0001471 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00012803 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00097799 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00012684 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00012398 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00013208 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00117803 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00013208 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='245')
0.00017405 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '245')
0.00013304 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00118089 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '245') LIMIT 1
0.00012398 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00013208 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00012898 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00105691 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00012493 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='61')
0.00012493 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '61')
0.00012398 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0011909 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '61') LIMIT 1
0.00013185 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00015306 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00012493 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00144982 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00013113 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.00012898 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00014496 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0010922 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00012589 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='156')
0.00012493 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '156')
0.00012279 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00093699 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '156') LIMIT 1
0.000139 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00013089 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00012898 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00115085 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00012517 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00012898 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00013399 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00120401 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00012398 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='245')
0.00012493 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '245')
0.00012803 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00120997 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '245') LIMIT 1
0.00015593 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00016594 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00015211 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00114489 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.0001471 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='61')
0.00013185 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '61')
0.0001452 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00141215 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '61') LIMIT 1
0.00012493 
              SELECT `e`.*, `at_product_id`.`product_id` FROM `mz_catalog_category_entity` AS `e`
 INNER JOIN `mz_catalog_category_product` AS `at_product_id` ON (at_product_id.`category_id`=e.entity_id) WHERE (at_product_id.product_id = '6287')
0.00032306 
              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 `mz_catalog_category_entity_varchar` AS `t_d`
 INNER JOIN `mz_catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `mz_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 = 3 WHERE (e.entity_id IN (155, 156, 199, 227, 245, 383, 61)) AND (t_d.attribute_id IN (111, 479)) 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 `mz_catalog_category_entity_int` AS `t_d`
 INNER JOIN `mz_catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `mz_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 = 3 WHERE (e.entity_id IN (155, 156, 199, 227, 245, 383, 61)) AND (t_d.attribute_id IN (119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00131011 
              SELECT IF(store_value.attribute_id IS NULL, default_value.attribute_id, store_value.attribute_id) AS `attribute_id`, IF(store_value.value IS NULL, default_value.value, store_value.value) AS `attr_value` FROM `mz_catalog_category_entity` AS `e`
 LEFT JOIN `mz_catalog_category_entity_varchar` AS `default_value` ON default_value.attribute_id IN (111) AND default_value.entity_id = e.entity_id AND default_value.store_id = 0
 LEFT JOIN `mz_catalog_category_entity_varchar` AS `store_value` ON store_value.attribute_id IN (111) AND store_value.entity_id = e.entity_id AND store_value.store_id = :store_id WHERE (e.entity_id = :entity_id)
0.00021696 
              SELECT `mz_catalogrule_product_price`.`product_id`, `mz_catalogrule_product_price`.`rule_price` FROM `mz_catalogrule_product_price` WHERE (rule_date = '2024-12-11') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(6287))
0.00024295 
              SELECT `mz_customer_group`.* FROM `mz_customer_group` WHERE (`mz_customer_group`.`customer_group_id`='1')
0.00018096 
              SELECT `mz_tax_class`.* FROM `mz_tax_class` WHERE (`mz_tax_class`.`class_id`='5')
0.00016594 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00018001 
              SELECT `mz_customer_group`.* FROM `mz_customer_group` WHERE (`mz_customer_group`.`customer_group_id`=0)
0.00014496 
              SELECT `mz_tax_class`.* FROM `mz_tax_class` WHERE (`mz_tax_class`.`class_id`='5')
0.00011706 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00013304 
              (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 `mz_tax_calculation` AS `main_table`
 INNER JOIN `mz_tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `mz_tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `mz_tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '3' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'FR') AND (rate.tax_region_id IN(0, 276)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '94149', '94149*', '9414*', '941*', '94*', '9*'))) 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 `mz_tax_calculation` AS `main_table`
 INNER JOIN `mz_tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `mz_tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `mz_tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '3' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'FR') AND (rate.tax_region_id IN(0, 276)) AND (rate.zip_is_range IS NOT NULL) AND ('94149' 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.00098586 
              SELECT `mz_klarna_kco_quote`.`kco_quote_id` FROM `mz_klarna_kco_quote` WHERE (is_active = 1) AND (quote_id = :quote_id) ORDER BY `kco_quote_id` desc
0.00021791 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00020599 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('6287')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (3)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL)
0.00036693 
              SELECT `main_table`.* FROM `mz_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('6287')) AND (entity_type = 1) AND (store_id = 3)
0.00033593 
              SELECT GET_LOCK(?, ?);
0.00017905 
              SELECT RELEASE_LOCK(?);
0.00014806 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00023985 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00021505 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.000247 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00018001 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00141907 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00015402 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='156')
0.00012589 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '156')
0.00013304 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00151706 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '156') LIMIT 1
0.00012612 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00012493 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00013518 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00090003 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00019312 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00016809 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00018096 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00098991 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00015402 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='245')
0.00015593 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '245')
0.00018501 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00096989 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '245') LIMIT 1
0.00018501 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.0001421 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00016785 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00088501 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00024891 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='61')
0.00022316 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '61')
0.00021601 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00118899 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '61') LIMIT 1
0.00021219 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='155')
0.0002501 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '155')
0.00021195 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '155') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00116801 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '155') LIMIT 1
0.00022101 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='156')
0.00020814 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '156')
0.00019908 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '156') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0010879 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '156') LIMIT 1
0.000211 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00016809 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00020814 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '199') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00110102 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00021601 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00019598 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00020123 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '227') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00101995 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00022507 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='245')
0.0002079 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '245')
0.00019908 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '245') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00094914 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '245') LIMIT 1
0.00020099 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00020885 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00017381 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '383') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00092506 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00022411 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='61')
0.00021291 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '61')
0.00015807 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (2326, 119, 935, 936, 1214, 1207, 932, 1219, 117, 120, 1205, 2178, 2161, 2175, 2167, 2177, 1204)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_varchar` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (111, 479, 948, 113, 114, 1217, 2197, 1209, 118, 563, 533, 1163, 1176, 928, 514, 1190, 2198, 2199, 2209)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_text` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (112, 115, 116, 1212, 1215, 121, 122, 123, 1177, 927, 530, 2185, 2318, 2165, 2176)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_datetime` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (565, 566)) AND (`store_id` IN (3, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_decimal` AS `t` WHERE (entity_id = '61') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00113392 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '61') LIMIT 1
0.00019813 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '272') AND (`main_table`.`option_id` IN('143')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00091982 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '977') AND (`main_table`.`option_id` IN('204')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00086713 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '2192') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.0002718 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '2193') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00024009 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '2194') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00022888 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '2195') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00019908 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '2190') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00026393 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '2189') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00027108 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '1170') AND (`main_table`.`option_id` IN('703')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00061584 
              SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mz_eav_attribute_option` AS `main_table`
 INNER JOIN `mz_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `mz_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '3' WHERE (`main_table`.`attribute_id` = '977') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00353694 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.0002501 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00014305 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00017881 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00014091 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('6287')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (3)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL)
0.00043607 
              SELECT `main_table`.*, `review_entity`.`entity_code` FROM `mz_review_entity_summary` AS `main_table`
 LEFT JOIN `mz_review_entity` AS `review_entity` ON main_table.entity_type = review_entity.entity_id WHERE (store_id = 3) AND (entity_pk_value = '6287') AND (entity_code = 'product')
0.00026488 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('6287')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (3)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL)
0.00034094 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mz_url_rewrite` AS `url_rewrite`
 LEFT JOIN `mz_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('6287')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (3)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL)
0.00030398 
              SELECT * FROM mz_axelites_trustpilot_reviews WHERE store_id = 3 ORDER BY created_at DESC LIMIT 5 OFFSET 0;
0.00103211 
              SELECT `mz_cms_page`.`page_id` FROM `mz_cms_page`
 INNER JOIN `mz_cms_page_store` AS `cms_page_store` ON mz_cms_page.page_id = cms_page_store.page_id WHERE (`mz_cms_page`.`page_id`='1') AND (is_active = 1) AND (cms_page_store.store_id IN (0, 3)) ORDER BY `cms_page_store`.`store_id` DESC
 LIMIT 1
0.00032687 
              SELECT `t`.* FROM `mz_cms_page` AS `t` WHERE (page_id = '1')
0.00021887 
              SELECT `cps`.`store_id` FROM `mz_cms_page_store` AS `cps`
 INNER JOIN `mz_cms_page` AS `cp` ON cps.page_id = cp.page_id WHERE (cp.page_id = :page_id)
0.00025105 
              SELECT `mz_cms_page`.`title` FROM `mz_cms_page` WHERE (page_id = :page_id)
0.00016809 
              SELECT `mz_cms_page`.`title` FROM `mz_cms_page` WHERE (page_id = :page_id)
0.00020599 
              SELECT `main_table`.* FROM `mz_mageplaza_bannerslider_slider` AS `main_table` WHERE (FIND_IN_SET(0, `customer_group_ids`)) AND (`status` = '1') AND (FIND_IN_SET(0, store_ids) OR FIND_IN_SET('3', store_ids)) AND (FIND_IN_SET(3, store_category_ids) OR FIND_IN_SET(0, store_category_ids)) AND (from_date is null OR from_date <= '2024-12-11') AND (to_date is null OR to_date >= '2024-12-11') ORDER BY priority DESC
 LIMIT 1
0.00042796 
              SELECT `mz_cms_block`.`block_id` FROM `mz_cms_block`
 INNER JOIN `mz_cms_block_store` AS `cbs` ON mz_cms_block.block_id = cbs.block_id WHERE (`mz_cms_block`.`identifier`='footer_block_content') AND (is_active = 1) AND (cbs.store_id in (3, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00037193 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '493')
0.00021696 
              SELECT `cbs`.`store_id` FROM `mz_cms_block_store` AS `cbs`
 INNER JOIN `mz_cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
0.00020504 
              SELECT `mz_cms_block`.`block_id` FROM `mz_cms_block`
 INNER JOIN `mz_cms_block_store` AS `cbs` ON mz_cms_block.block_id = cbs.block_id WHERE (`mz_cms_block`.`identifier`='footer_newsletter') AND (is_active = 1) AND (cbs.store_id in (3, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00032806 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '496')
0.00017619 
              SELECT `cbs`.`store_id` FROM `mz_cms_block_store` AS `cbs`
 INNER JOIN `mz_cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
0.00019884 
              SELECT `main_table`.* FROM `mz_whatsappcontact` AS `main_table` WHERE (`active` = '1')
0.00023818

Nous contactez

Developer
2.4.6-p5
1.08 s
66.00 MB
296 q / 0.146 s
Return to Site