https://menzzo2anis.trydev.ovh/deco-textiles/objet-deco.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 65 queries in 0.026 s
Total Queries 65
Insert queries 0
Update queries 0
Read queries 63
Delete queries 0
Transactions 0

Top 5 - Slowest Queries

Query Time (ms) 
              SET NAMES utf8
0.0001018 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00011897 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00012207 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '346')
0.00012493 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00012493

All Queries

Query Time (ms) 
              connect
0.00092697 
              SET NAMES utf8
0.0001018 
              SELECT `mz_store_website`.* FROM `mz_store_website`
0.00020003 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.00015521 
              SELECT `mz_store`.* FROM `mz_store`
0.00013304 
              SELECT `mz_flag`.* FROM `mz_flag` WHERE (`mz_flag`.`flag_code`='config_hash')
0.00039387 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('deco-textiles/objet-deco.html', 'deco-textiles/objet-deco.html/')) AND (`store_id` IN ('3'))
0.00049996 
              SELECT `main_table`.* FROM `mz_mageworx_seoredirects_redirect_custom` AS `main_table` WHERE (`status` = '1') AND ((request_entity_type = 3 AND request_entity_identifier = 346) OR (request_entity_type = 1 AND request_entity_identifier = 'deco-textiles/objet-deco.html')) AND ('2024-12-11 23:34:25' 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.00036311 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('deco-textiles/objet-deco.html', 'deco-textiles/objet-deco.html/')) AND (`store_id` IN ('3'))
0.00027084 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_product_flat')
0.00037289 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/346', 'catalog/category/view/id/346/')) AND (`store_id` IN ('3'))
0.00038004 
              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/346', 'catalog/category/view/id/346/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00040698 
              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/346')) AND ('2024-12-11 23:34:25' 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.00028396 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/346', 'catalog/category/view/id/346/')) AND (`store_id` IN ('3'))
0.00028682 
              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/346', 'catalog/category/view/id/346/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.0002718 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_category_flat')
0.00027299 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id =346)
0.00022507 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = 346)
0.00023198 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '346') 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 = '346') 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 = '346') 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 = '346') 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 = '346') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00127316 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00030184 
              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('346', '334', '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.00129104 
              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 (346, 199, 334, 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 (346, 199, 334, 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 (346, 199, 334, 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 (346, 199, 334, 3)) AND (t_d.attribute_id IN (936)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00187016 
              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.00040603 
              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.00030684 
              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', '334', '346')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
0.00056481 
              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, 334, 346)) AND (t_d.attribute_id IN (111, 479)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.000494 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('199')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00026202 
              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.00033808 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('334')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00025797 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('346')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00025296 
              SELECT `main_table`.* FROM `mz_mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'category') AND (`source_entity_id` = '346') AND (`source_store_id` IN(0, '3')) ORDER BY source_store_id DESC
0.00034499 
              SELECT `mz_eav_attribute`.* FROM `mz_eav_attribute` WHERE (`mz_eav_attribute`.`attribute_code`='id') AND (entity_type_id = :entity_type_id)
0.00019407 
              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.00020099 
              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('346', 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.00051093 
              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('346', 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.00038505 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='346')
0.00025296 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '346')
0.00015807 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '346') 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 = '346') 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 = '346') 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 = '346') 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 = '346') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00102711 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00018787 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('angle', 'armchair_type', 'assise_matelassee', 'bed_elements', 'bed_size', 'bed_type', 'bipolart_type', 'color', 'coussin_type', 'diameter', 'dimension_sommier', 'dossier_matelasse', 'entretien', 'espace_rangement', 'extensible', 'for_angle', 'for_bed', 'forme', 'forme_canape', 'fournie', 'gigogne', 'hauteur_ajustable', 'is_electrical', 'lighting', 'luminous', 'mattress_type', 'motif_rideau', 'nb_cutlery', 'nb_persons', 'nb_pieces', 'nb_places', 'nb_products', 'power_watts', 'rangement_ouverture', 'rangement_type', 'removable', 'size', 'sofa_type', 'taille', 'type_attachment', 'type_douille', 'type_rideau', 'approximate_height', 'approximate_length', 'approximate_width', 'bed_rangement_type', 'capacity', 'colorfamily', 'cutlery_type', 'destination', 'disponibilite_menzzo', 'emplacement', 'facade_type', 'fonctions', 'matiere_structure', 'photo_dimensions', 'piece', 'product_universes', 'rangement_equipement', 'sold_with', 'soldes', 'specificity', 'theme', 'type_of_product', 'hauteur', 'largeur', 'power_watts', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00066495 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='346')
0.00024009 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '346')
0.00013494 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '346') 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 = '346') 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 = '346') 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 = '346') 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 = '346') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00093699 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00011897 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('angle', 'armchair_type', 'assise_matelassee', 'bed_elements', 'bed_size', 'bed_type', 'bipolart_type', 'color', 'coussin_type', 'diameter', 'dimension_sommier', 'dossier_matelasse', 'entretien', 'espace_rangement', 'extensible', 'for_angle', 'for_bed', 'forme', 'forme_canape', 'fournie', 'gigogne', 'hauteur_ajustable', 'is_electrical', 'lighting', 'luminous', 'mattress_type', 'motif_rideau', 'nb_cutlery', 'nb_persons', 'nb_pieces', 'nb_places', 'nb_products', 'power_watts', 'rangement_ouverture', 'rangement_type', 'removable', 'size', 'sofa_type', 'taille', 'type_attachment', 'type_douille', 'type_rideau', 'approximate_height', 'approximate_length', 'approximate_width', 'bed_rangement_type', 'capacity', 'colorfamily', 'cutlery_type', 'destination', 'disponibilite_menzzo', 'emplacement', 'facade_type', 'fonctions', 'matiere_structure', 'photo_dimensions', 'piece', 'product_universes', 'rangement_equipement', 'sold_with', 'soldes', 'specificity', 'theme', 'type_of_product', 'hauteur', 'largeur', 'power_watts', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00047684 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='346')
0.00024509 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '346')
0.00013304 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '346') 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 = '346') 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 = '346') 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 = '346') 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 = '346') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00105715 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00012207 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('angle', 'armchair_type', 'assise_matelassee', 'bed_elements', 'bed_size', 'bed_type', 'bipolart_type', 'color', 'coussin_type', 'diameter', 'dimension_sommier', 'dossier_matelasse', 'entretien', 'espace_rangement', 'extensible', 'for_angle', 'for_bed', 'forme', 'forme_canape', 'fournie', 'gigogne', 'hauteur_ajustable', 'is_electrical', 'lighting', 'luminous', 'mattress_type', 'motif_rideau', 'nb_cutlery', 'nb_persons', 'nb_pieces', 'nb_places', 'nb_products', 'power_watts', 'rangement_ouverture', 'rangement_type', 'removable', 'size', 'sofa_type', 'taille', 'type_attachment', 'type_douille', 'type_rideau', 'approximate_height', 'approximate_length', 'approximate_width', 'bed_rangement_type', 'capacity', 'colorfamily', 'cutlery_type', 'destination', 'disponibilite_menzzo', 'emplacement', 'facade_type', 'fonctions', 'matiere_structure', 'photo_dimensions', 'piece', 'product_universes', 'rangement_equipement', 'sold_with', 'soldes', 'specificity', 'theme', 'type_of_product', 'hauteur', 'largeur', 'power_watts', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00047803 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='346')
0.00013089 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '346')
0.00012493 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '346') 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 = '346') 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 = '346') 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 = '346') 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 = '346') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00086999 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '346') LIMIT 1
0.00012493 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('346')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00019288 
              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_objet-deco_bottom') AND (is_active = 1) AND (cbs.store_id in (3, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.000386 
              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=346 WHERE (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('3', `store_ids`)))) AND (`publish_date` <= '2024-12-11 23:34:26') AND (`enabled` = '1') ORDER BY publish_date DESC
 LIMIT 3
0.00054908 
              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('346', 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.00038791 
              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.00037384 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '493')
0.00024986 
              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.00021791 
              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.00027919 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '496')
0.00018692 
              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.00021195 
              SELECT `main_table`.* FROM `mz_whatsappcontact` AS `main_table` WHERE (`active` = '1')
0.0002799

Nous contactez

Developer
2.4.6-p5
1.07 s
52.00 MB
65 q / 0.026 s
Return to Site