https://menzzo2anis.trydev.ovh/bureau.html?menzzo2anis_products_3_category_383%5Bpage%5D=5

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

Database Queries

Nom Valeur
Executed 66 queries in 0.027 s
Total Queries 66
Insert queries 0
Update queries 0
Read queries 64
Delete queries 0
Transactions 0

Top 5 - Slowest Queries

Query Time (ms) 
              SET NAMES utf8
8.512E-5 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '207') LIMIT 1
0.00015807 
              SELECT `mz_store`.* FROM `mz_store`
0.00015903 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.0001719 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '496')
0.000175

All Queries

Query Time (ms) 
              connect
0.00078201 
              SET NAMES utf8
8.512E-5 
              SELECT `mz_store_website`.* FROM `mz_store_website`
0.00018001 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.0001719 
              SELECT `mz_store`.* FROM `mz_store`
0.00015903 
              SELECT `mz_flag`.* FROM `mz_flag` WHERE (`mz_flag`.`flag_code`='config_hash')
0.00032592 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('bureau.html', 'bureau.html/')) AND (`store_id` IN ('3'))
0.00040507 
              SELECT `main_table`.* FROM `mz_mageworx_seoredirects_redirect_custom` AS `main_table` WHERE (`status` = '1') AND ((request_entity_type = 3 AND request_entity_identifier = 207) OR (request_entity_type = 1 AND request_entity_identifier = 'bureau.html')) AND ('2024-12-11 23:57:02' 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.00034499 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('bureau.html', 'bureau.html/')) AND (`store_id` IN ('3'))
0.00027394 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_product_flat')
0.00032878 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/207', 'catalog/category/view/id/207/')) AND (`store_id` IN ('3'))
0.00039887 
              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/category/view/id/207', 'catalog/category/view/id/207/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00031281 
              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/category/view/id/207')) AND ('2024-12-11 23:57:02' 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.00028706 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/207', 'catalog/category/view/id/207/')) AND (`store_id` IN ('3'))
0.00023794 
              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/category/view/id/207', 'catalog/category/view/id/207/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00026679 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_category_flat')
0.00038481 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id =207)
0.00034404 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = 207)
0.00037003 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '207') 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 = '207') 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 = '207') 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 = '207') 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 = '207') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00125718 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '207') LIMIT 1
0.00034285 
              SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `mz_catalog_category_entity` AS `e`
 LEFT JOIN `mz_catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '935') AND `at_custom_use_parent_settings_default`.`store_id` = 0
 LEFT JOIN `mz_catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '935') AND (`at_custom_use_parent_settings`.`store_id` = 3) WHERE (`e`.`entity_id` IN('207', '199', '3', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC
0.0006001 
              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 (199, 207, 3)) AND (t_d.attribute_id IN (563, 514, 1190)) 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_datetime` 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_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 3 WHERE (e.entity_id IN (199, 207, 3)) AND (t_d.attribute_id IN (565, 566)) 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_text` 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_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 3 WHERE (e.entity_id IN (199, 207, 3)) AND (t_d.attribute_id IN (530)) 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 (199, 207, 3)) AND (t_d.attribute_id IN (936)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00113988 
              SELECT COUNT(m.entity_id) FROM `mz_catalog_category_entity` AS `m`
 LEFT JOIN `mz_catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `mz_catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)
0.00053382 
              SELECT COUNT(m.entity_id) FROM `mz_catalog_category_entity` AS `m`
 LEFT JOIN `mz_catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `mz_catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)
0.00042915 
              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `mz_catalog_category_entity` AS `e`
 LEFT JOIN `mz_catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '119') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `mz_catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '119') AND (`at_is_active`.`store_id` = 3) WHERE (`e`.`entity_id` IN('199', '207')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
0.00051808 
              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 (199, 207)) AND (t_d.attribute_id IN (111, 479)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00043201 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('199')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00023103 
              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 ('199')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (3)) AND (relation.category_id IS NULL)
0.00028205 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('207')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00027204 
              SELECT `main_table`.* FROM `mz_mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'category') AND (`source_entity_id` = '207') AND (`source_store_id` IN(0, '3')) ORDER BY source_store_id DESC
0.0003252 
              SELECT `mz_eav_attribute`.* FROM `mz_eav_attribute` WHERE (`mz_eav_attribute`.`attribute_code`='id') AND (entity_type_id = :entity_type_id)
0.00023603 
              SELECT `mz_eav_attribute`.* FROM `mz_eav_attribute` WHERE (`mz_eav_attribute`.`attribute_code`='menzzo2anis_products_3_category_383') AND (entity_type_id = :entity_type_id)
0.0002141 
              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('207', store_category_ids)) AND (from_date is null OR from_date <= '2024-12-11') AND (to_date is null OR to_date >= '2024-12-11') ORDER BY priority DESC
 LIMIT 1
0.00073719 
              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('207', store_category_ids)) AND (from_date is null OR from_date <= '2024-12-11') AND (to_date is null OR to_date >= '2024-12-11') ORDER BY priority DESC
 LIMIT 1
0.00048018 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='207')
0.00032902 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '207')
0.00020194 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '207') 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 = '207') 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 = '207') 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 = '207') 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 = '207') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00157595 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '207') LIMIT 1
0.00020003 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('soldes', 'disponibilite_menzzo', 'colorfamily', 'matiere_structure', 'rangement_type', 'rangement_ouverture', 'rangement_equipement', 'approximate_width', 'approximate_height', 'extensible', 'espace_rangement', 'largeur', 'hauteur', 'approximate_length', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00064898 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='207')
0.00030494 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '207')
0.00019598 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '207') 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 = '207') 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 = '207') 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 = '207') 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 = '207') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00113511 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '207') LIMIT 1
0.00020099 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('soldes', 'disponibilite_menzzo', 'colorfamily', 'matiere_structure', 'rangement_type', 'rangement_ouverture', 'rangement_equipement', 'approximate_width', 'approximate_height', 'extensible', 'espace_rangement', 'largeur', 'hauteur', 'approximate_length', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00042796 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='207')
0.00030994 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '207')
0.00021291 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '207') 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 = '207') 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 = '207') 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 = '207') 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 = '207') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00113916 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '207') LIMIT 1
0.00020409 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('soldes', 'disponibilite_menzzo', 'colorfamily', 'matiere_structure', 'rangement_type', 'rangement_ouverture', 'rangement_equipement', 'approximate_width', 'approximate_height', 'extensible', 'espace_rangement', 'largeur', 'hauteur', 'approximate_length', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00046802 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='207')
0.00020003 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '207')
0.00020194 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '207') 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 = '207') 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 = '207') 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 = '207') 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 = '207') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00117016 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '207') LIMIT 1
0.00015807 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('207')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00026393 
              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`='seo_bureau_bottom') AND (is_active = 1) AND (cbs.store_id in (3, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00050807 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '66')
0.00024295 
              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.0002389 
              SELECT `main_table`.*, `cat`.* FROM `mz_mageplaza_blog_post` AS `main_table`
 INNER JOIN `mz_mageplaza_blog_post_ccategory` AS `cat` ON cat.post_id=main_table.post_id AND cat.category_id=207 WHERE (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('3', `store_ids`)))) AND (`publish_date` <= '2024-12-11 23:57:03') AND (`enabled` = '1') ORDER BY publish_date DESC
 LIMIT 3
0.00047588 
              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('207', store_category_ids)) AND (from_date is null OR from_date <= '2024-12-11') AND (to_date is null OR to_date >= '2024-12-11') ORDER BY priority DESC
 LIMIT 1
0.00044394 
              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.00039792 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '493')
0.00023603 
              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.00022912 
              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.000283 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '496')
0.000175 
              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.00022316 
              SELECT `main_table`.* FROM `mz_whatsappcontact` AS `main_table` WHERE (`active` = '1')
0.00025821

Nous contactez

Developer
2.4.6-p5
1.14 s
52.00 MB
66 q / 0.027 s
Return to Site