https://menzzo2anis.trydev.ovh/fauteuil-scandinave-klarys-velours-rose.html

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

Database Queries

Nom Valeur
Executed 268 queries in 0.154 s
Total Queries 268
Insert queries 2
Update queries 0
Read queries 261
Delete queries 0
Transactions 2

Top 5 - Slowest Queries

Query Time (ms) 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.00010419 
              SELECT `mz_store`.* FROM `mz_store`
0.00010705 
              begin
0.00011706 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00012398 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00013709

All Queries

Query Time (ms) 
              connect
0.00090504 
              SET NAMES utf8
0.00015187 
              SELECT `mz_store_website`.* FROM `mz_store_website`
0.00020099 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.00010419 
              SELECT `mz_store`.* FROM `mz_store`
0.00010705 
              SELECT `mz_flag`.* FROM `mz_flag` WHERE (`mz_flag`.`flag_code`='config_hash')
0.00036597 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('fauteuil-scandinave-klarys-velours-rose.html', 'fauteuil-scandinave-klarys-velours-rose.html/')) AND (`store_id` IN ('3'))
0.0007031 
              SELECT `main_table`.* FROM `mz_mageworx_seoredirects_redirect_custom` AS `main_table` WHERE (`status` = '1') AND ((request_entity_type = 2 AND request_entity_identifier = 4181) OR (request_entity_type = 1 AND request_entity_identifier = 'fauteuil-scandinave-klarys-velours-rose.html')) AND ('2024-12-18 01:59:01' 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.00047612 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('fauteuil-scandinave-klarys-velours-rose.html', 'fauteuil-scandinave-klarys-velours-rose.html/')) AND (`store_id` IN ('3'))
0.00031686 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_product_flat')
0.00035787 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/product/view/id/4181', 'catalog/product/view/id/4181/')) AND (`store_id` IN ('3'))
0.0004282 
              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/4181', 'catalog/product/view/id/4181/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00029707 
              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/4181')) AND ('2024-12-18 01:59:01' 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.00026798 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/product/view/id/4181', 'catalog/product/view/id/4181/')) AND (`store_id` IN ('3'))
0.00025296 
              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/4181', 'catalog/product/view/id/4181/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00026512 
              SELECT `mz_catalog_product_entity`.* FROM `mz_catalog_product_entity` WHERE (entity_id =4181)
0.00076008 
              SELECT `t`.* FROM `mz_catalog_product_entity` AS `t` WHERE (entity_id = 4181)
0.00033092 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_int` AS `t` WHERE (entity_id = '4181') AND (attribute_id IN (273, 2319, 2320, 863, 1116, 988, 1033, 2249, 1034, 1035, 860, 2246, 1036, 1110, 1037, 110, 859, 1038, 274, 1039, 1187, 1031, 1040, 1041, 861, 526, 965, 862, 992, 2192, 1047, 2193, 1049, 1173, 102, 2194, 1051, 1020, 2195, 1052, 2188, 1055, 272, 2190, 1058, 1003, 2189, 1062, 949, 2191, 1063, 1018, 1135, 1065, 1129, 1068, 1126, 1070, 1071, 1178, 1078, 1079, 2248, 1083, 1029, 1030, 1032, 1042, 1050, 1053, 1048, 1054, 1056, 1057, 1059, 1060, 1061, 1066, 1067, 1069, 1073, 1074, 1075, 1077, 1081, 1082, 1084, 1085, 1086, 1087, 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 = '4181') AND (attribute_id IN (979, 106, 1146, 929, 562, 96, 109, 1115, 481, 836, 2247, 493, 1114, 103, 571, 1192, 1117, 1001, 1188, 1160, 1118, 105, 1112, 703, 1119, 1216, 507, 985, 1179, 271, 1127, 1123, 1134, 2187, 987, 1043, 570, 1165, 1019, 1002, 1132, 1044, 1045, 951, 1008, 1046, 952, 879, 880, 1128, 881, 2204, 2205, 1007, 1064, 1089, 1090, 1091, 1169, 1092, 1093, 1076, 2202, 1094, 2203, 1095, 1096, 1080, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 2168, 2174, 1072, 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 = '4181') AND (attribute_id IN (1028, 1000, 567, 1107, 99, 1108, 1109, 503, 100, 101, 986, 270, 1131, 953, 993, 2196)) 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 = '4181') 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 = '4181') AND (attribute_id IN (506, 976, 97, 977, 531, 104, 2186, 1017, 1125, 494, 1150, 2325, 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, 2285, 2321)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.01354003 
              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` = '4181') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC
0.00174403 
              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('8124', '8123')) ORDER BY sort_order ASC, title ASC
0.00043082 
              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 = '4181') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
0.0012989 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 4181)
0.00071788 
              SELECT `mz_catalog_product_website`.`website_id` FROM `mz_catalog_product_website` WHERE (product_id = 4181)
0.00032401 
              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('4181'))
0.00072217 
              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 = '4181') ORDER BY `qty` ASC
0.00023699 
              SELECT `mz_directory_currency_rate`.`rate` FROM `mz_directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to = :currency_to)
0.00030684 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 4181)
0.00042105 
              SELECT `mz_catalog_product_entity`.`sku`, `mz_catalog_product_entity`.`entity_id` FROM `mz_catalog_product_entity` WHERE (sku IN ('8801vrose'))
0.00036621 
              SELECT `mz_inventory_stock_sales_channel`.`stock_id` FROM `mz_inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')
0.00024581 
              SELECT `mz_inventory_stock`.* FROM `mz_inventory_stock` WHERE (`mz_inventory_stock`.`stock_id`=1)
0.00019217 
              SELECT `mz_inventory_stock_sales_channel`.* FROM `mz_inventory_stock_sales_channel` WHERE (stock_id = 1)
0.00019217 
              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 = 4181)
0.00044179 
              SELECT `mz_catalog_product_entity`.* FROM `mz_catalog_product_entity` WHERE (entity_id =4181)
0.00035691 
              SELECT `t`.* FROM `mz_catalog_product_entity` AS `t` WHERE (entity_id = 4181)
0.00018001 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_product_entity_int` AS `t` WHERE (entity_id = '4181') AND (attribute_id IN (273, 2319, 2320, 863, 1116, 988, 1033, 2249, 1034, 1035, 860, 2246, 1036, 1110, 1037, 110, 859, 1038, 274, 1039, 1187, 1031, 1040, 1041, 861, 526, 965, 862, 992, 2192, 1047, 2193, 1049, 1173, 102, 2194, 1051, 1020, 2195, 1052, 2188, 1055, 272, 2190, 1058, 1003, 2189, 1062, 949, 2191, 1063, 1018, 1135, 1065, 1129, 1068, 1126, 1070, 1071, 1178, 1078, 1079, 2248, 1083, 1029, 1030, 1032, 1042, 1050, 1053, 1048, 1054, 1056, 1057, 1059, 1060, 1061, 1066, 1067, 1069, 1073, 1074, 1075, 1077, 1081, 1082, 1084, 1085, 1086, 1087, 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 = '4181') AND (attribute_id IN (979, 106, 1146, 929, 562, 96, 109, 1115, 481, 836, 2247, 493, 1114, 103, 571, 1192, 1117, 1001, 1188, 1160, 1118, 105, 1112, 703, 1119, 1216, 507, 985, 1179, 271, 1127, 1123, 1134, 2187, 987, 1043, 570, 1165, 1019, 1002, 1132, 1044, 1045, 951, 1008, 1046, 952, 879, 880, 1128, 881, 2204, 2205, 1007, 1064, 1089, 1090, 1091, 1169, 1092, 1093, 1076, 2202, 1094, 2203, 1095, 1096, 1080, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 2168, 2174, 1072, 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 = '4181') AND (attribute_id IN (1028, 1000, 567, 1107, 99, 1108, 1109, 503, 100, 101, 986, 270, 1131, 953, 993, 2196)) 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 = '4181') 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 = '4181') AND (attribute_id IN (506, 976, 97, 977, 531, 104, 2186, 1017, 1125, 494, 1150, 2325, 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, 2285, 2321)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00695086 
              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` = '4181') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC
0.00056291 
              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('8124', '8123')) ORDER BY sort_order ASC, title ASC
0.00036287 
              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 = '4181') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
0.00056911 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 4181)
0.00021982 
              SELECT `mz_catalog_product_website`.`website_id` FROM `mz_catalog_product_website` WHERE (product_id = 4181)
0.00019908 
              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 = '4181') ORDER BY `qty` ASC
0.00021815 
              SELECT `mz_catalog_category_product`.`category_id`, `mz_catalog_category_product`.`position` FROM `mz_catalog_category_product` WHERE (product_id = 4181)
0.00019193 
              SELECT `mz_catalog_category_product_index_store3`.`product_id` FROM `mz_catalog_category_product_index_store3` WHERE (product_id = 4181) AND (category_id = 0)
0.00018001 
              SELECT `mz_catalog_product_website`.`website_id` FROM `mz_catalog_product_website` WHERE (product_id = 4181)
0.00028396 
              SELECT `mz_catalog_category_product_index_store3`.`product_id` FROM `mz_catalog_category_product_index_store3` WHERE (product_id = 4181) AND (category_id = 0)
0.00021005 
              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 = '4181') AND (ft.store_id = 3)
0.00103211 
              SELECT `mz_catalogrule_product_price`.`product_id`, `mz_catalogrule_product_price`.`rule_price` FROM `mz_catalogrule_product_price` WHERE (rule_date = '2024-12-18') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(4181))
0.00030899 
              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.00133395 
              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.0004921 
              begin
0.00011706 
              INSERT INTO `mz_report_event` (`logged_at`, `event_type_id`, `object_id`, `subtype`, `store_id`) VALUES ('2024-12-18 01:59:01', ?, ?, ?, ?)
0.00031686 
              commit
0.00054479 
              SELECT `mz_catalog_category_product_index_store3`.`product_id` FROM `mz_catalog_category_product_index_store3` WHERE (product_id = 4181) AND (category_id = 0)
0.00030494 
              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.00042605 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_category_flat')
0.00034189 
              SELECT `main_table`.* FROM `mz_mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'product') AND (`source_entity_id` = '4181') AND (`source_store_id` IN(0, 3)) ORDER BY source_store_id DESC
0.000422 
              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 ('4181')) 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.00090909 
              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.00742698 
              SELECT `mz_store`.`website_id`, `mz_store`.`store_id` FROM `mz_store` WHERE (store_id != 0)
0.00025606 
              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('4181')) 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 (4181)  AND `url_rewrite`.`store_id` IN (3,2,14,23,25,26,28,29) AND `url_rewrite`.`metadata` IS NULL)
0.0039649 
              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 ('4181')) 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.00041699 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00040913 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00035191 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00197697 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00029993 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00034213 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00023317 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00165391 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00019097 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='152')
0.00015497 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '152')
0.00021791 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '152') 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 = '152') 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 = '152') 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 = '152') 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 = '152') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00170517 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '152') LIMIT 1
0.000247 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00020504 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00017595 
              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.00145006 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00024581 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00019097 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00021005 
              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.00138307 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00025702 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.000175 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00016093 
              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.00149512 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00033784 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='128')
0.00017405 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '128')
0.00016713 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '128') 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 = '128') 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 = '128') 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 = '128') 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 = '128') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00145102 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '128') LIMIT 1
0.00023699 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00016809 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00020695 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00171685 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00025511 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00017691 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00016308 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00155187 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00024581 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='152')
0.00022888 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '152')
0.00018477 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '152') 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 = '152') 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 = '152') 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 = '152') 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 = '152') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00143909 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '152') LIMIT 1
0.000283 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00020981 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00022602 
              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.00155902 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.0002799 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00023198 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00026393 
              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.00138402 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00023293 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00019097 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00020099 
              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.00140309 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00020099 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='128')
0.00016594 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '128')
0.00016594 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '128') 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 = '128') 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 = '128') 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 = '128') 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 = '128') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00104403 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '128') LIMIT 1
0.00025105 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00024295 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00022006 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00121307 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00021982 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00021195 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.000175 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00167394 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00021601 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='152')
0.00018311 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '152')
0.00019217 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '152') 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 = '152') 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 = '152') 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 = '152') 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 = '152') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00171304 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '152') LIMIT 1
0.00023389 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00019097 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00015879 
              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.00144601 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00019813 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00016093 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00014997 
              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.00134087 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00023603 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00025702 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
0.00021005 
              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.00147295 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00024509 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='128')
0.00019312 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '128')
0.00015402 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '128') 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 = '128') 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 = '128') 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 = '128') 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 = '128') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0015099 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '128') LIMIT 1
0.00026894 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00017715 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00015497 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00170112 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00024104 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00015283 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
0.00013709 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') LIMIT 1
0.00019884 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='152')
0.00024414 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '152')
0.00017309 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '152') 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 = '152') 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 = '152') 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 = '152') 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 = '152') 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 = '152') LIMIT 1
0.00018311 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00017595 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
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 = '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.00091696 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.000211 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00022101 
              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.00094414 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00018692 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00015616 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
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 = '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.00094986 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00017381 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='128')
0.00017118 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '128')
0.00017214 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '128') 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 = '128') 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 = '128') 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 = '128') 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 = '128') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00118613 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '128') LIMIT 1
0.00021195 
              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 = '4181')
0.00046301 
              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 (149, 152, 227, 383, 199, 128)) 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 (149, 152, 227, 383, 199, 128)) AND (t_d.attribute_id IN (119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00106716 
              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.00029898 
              SELECT `mz_catalogrule_product_price`.`product_id`, `mz_catalogrule_product_price`.`rule_price` FROM `mz_catalogrule_product_price` WHERE (rule_date = '2024-12-18') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(4181))
0.00040007 
              SELECT `mz_customer_group`.* FROM `mz_customer_group` WHERE (`mz_customer_group`.`customer_group_id`='1')
0.00035286 
              SELECT `mz_tax_class`.* FROM `mz_tax_class` WHERE (`mz_tax_class`.`class_id`='5')
0.00026894 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00026202 
              SELECT `mz_customer_group`.* FROM `mz_customer_group` WHERE (`mz_customer_group`.`customer_group_id`=0)
0.00019598 
              SELECT `mz_tax_class`.* FROM `mz_tax_class` WHERE (`mz_tax_class`.`class_id`='5')
0.00018406 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00019312 
              (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.00124502 
              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.00039601 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00023699 
              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 ('4181')) 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.00051689 
              SELECT `main_table`.* FROM `mz_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('4181')) AND (entity_type = 1) AND (store_id = 3)
0.00025201 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('3')) ORDER BY main_table.name ASC
0.00036502 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('4')) ORDER BY main_table.name ASC
0.00022316 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('5')) ORDER BY main_table.name ASC
0.0002079 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('6')) ORDER BY main_table.name ASC
0.00019097 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('7')) ORDER BY main_table.name ASC
0.00019312 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('8')) ORDER BY main_table.name ASC
0.00019288 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('9')) ORDER BY main_table.name ASC
0.00026393 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('10')) ORDER BY main_table.name ASC
0.00022292 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('11')) ORDER BY main_table.name ASC
0.00018811 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('12')) ORDER BY main_table.name ASC
0.00019288 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('13')) ORDER BY main_table.name ASC
0.00018406 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('14')) ORDER BY main_table.name ASC
0.0002501 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('15')) ORDER BY main_table.name ASC
0.00019193 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('16')) ORDER BY main_table.name ASC
0.00020003 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('17')) ORDER BY main_table.name ASC
0.00017905 
              SELECT `main_table`.* FROM `mz_store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('18')) ORDER BY main_table.name ASC
0.00019097 
              SELECT GET_LOCK(?, ?);
0.00024199 
              SELECT RELEASE_LOCK(?);
0.0001719 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00032496 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00016594 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00028491 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
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 = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00152707 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.0002141 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='149')
0.00029707 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '149')
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 = '149') 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 = '149') 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 = '149') 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 = '149') 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 = '149') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.001194 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '149') LIMIT 1
0.00016189 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='152')
0.00015688 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '152')
0.00015497 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '152') 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 = '152') 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 = '152') 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 = '152') 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 = '152') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00106001 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '152') LIMIT 1
0.00018883 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='227')
0.00015211 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '227')
0.00013995 
              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.00129414 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '227') LIMIT 1
0.00023198 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='383')
0.00014114 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '383')
0.00015712 
              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.00100994 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '383') LIMIT 1
0.00020814 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='199')
0.00015998 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '199')
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 = '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.00145507 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '199') LIMIT 1
0.00023508 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='128')
0.00022006 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '128')
0.0001719 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '128') 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 = '128') 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 = '128') 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 = '128') 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 = '128') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00113201 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '128') LIMIT 1
0.00021505 
              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('57')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00112295 
              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` = '2320') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00032091 
              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('203')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.0008769 
              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.00032496 
              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.00022006 
              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('1127')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
0.00117302 
              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.00030613 
              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.00025702 
              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.00028396 
              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.00401115 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00030899 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00017595 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.00027108 
              SELECT `mz_customer_group_excluded_website`.`website_id` FROM `mz_customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
0.000139 
              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 ('4181')) 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.00062394 
              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 = '4181') AND (entity_code = 'product')
0.00038981 
              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 ('4181')) 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.00039601 
              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 ('4181')) 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.00034809 
              SELECT * FROM mz_axelites_trustpilot_reviews WHERE store_id = 3 ORDER BY created_at DESC LIMIT 5 OFFSET 0;
0.00113893 
              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.00056481 
              SELECT `t`.* FROM `mz_cms_page` AS `t` WHERE (page_id = '1')
0.00028014 
              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.00023079 
              SELECT `mz_cms_page`.`title` FROM `mz_cms_page` WHERE (page_id = :page_id)
0.00022697 
              SELECT `mz_cms_page`.`title` FROM `mz_cms_page` WHERE (page_id = :page_id)
0.00021696 
              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-18') AND (to_date is null OR to_date >= '2024-12-18') ORDER BY priority DESC
 LIMIT 1
0.00055814 
              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.00054693 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '493')
0.0002141 
              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.0002358 
              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.00044703 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '496')
0.00016379 
              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.00018406 
              SELECT `main_table`.* FROM `mz_whatsappcontact` AS `main_table` WHERE (`active` = '1')
0.0002811

Nous contactez

Developer
2.4.6-p5
1.60 s
68.00 MB
268 q / 0.154 s
Return to Site