https://menzzo2anis.trydev.ovh/meuble-de-chambre/bout-de-lit.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.029 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.702E-5 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.0001111 
              SELECT `mz_store`.* FROM `mz_store`
0.00013399 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '259') LIMIT 1
0.00018597 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '259')
0.00019217

All Queries

Query Time (ms) 
              connect
0.00093508 
              SET NAMES utf8
8.702E-5 
              SELECT `mz_store_website`.* FROM `mz_store_website`
0.00022507 
              SELECT `mz_store_group`.* FROM `mz_store_group`
0.0001111 
              SELECT `mz_store`.* FROM `mz_store`
0.00013399 
              SELECT `mz_flag`.* FROM `mz_flag` WHERE (`mz_flag`.`flag_code`='config_hash')
0.00035214 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('meuble-de-chambre/bout-de-lit.html', 'meuble-de-chambre/bout-de-lit.html/')) AND (`store_id` IN ('3'))
0.00043106 
              SELECT `main_table`.* FROM `mz_mageworx_seoredirects_redirect_custom` AS `main_table` WHERE (`status` = '1') AND ((request_entity_type = 3 AND request_entity_identifier = 259) OR (request_entity_type = 1 AND request_entity_identifier = 'meuble-de-chambre/bout-de-lit.html')) AND ('2024-12-11 23:48:03' 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.000319 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('meuble-de-chambre/bout-de-lit.html', 'meuble-de-chambre/bout-de-lit.html/')) AND (`store_id` IN ('3'))
0.000247 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_product_flat')
0.00040293 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/259', 'catalog/category/view/id/259/')) AND (`store_id` IN ('3'))
0.00041604 
              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/259', 'catalog/category/view/id/259/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00039196 
              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/259')) AND ('2024-12-11 23:48:03' 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.00035596 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/259', 'catalog/category/view/id/259/')) AND (`store_id` IN ('3'))
0.00029397 
              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/259', 'catalog/category/view/id/259/')) AND (url_rewrite.store_id IN ('3')) AND (relation.category_id IS NULL)
0.00029588 
              SELECT `mz_indexer_state`.* FROM `mz_indexer_state` WHERE (`mz_indexer_state`.`indexer_id`='catalog_category_flat')
0.00032902 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id =259)
0.00090003 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = 259)
0.00035715 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '259') 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 = '259') 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 = '259') 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 = '259') 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 = '259') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00184894 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '259') LIMIT 1
0.00037193 
              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('259', '256', '246', '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.0008409 
              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 (259, 256, 199, 246, 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 (259, 256, 199, 246, 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 (259, 256, 199, 246, 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 (259, 256, 199, 246, 3)) AND (t_d.attribute_id IN (936)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00190496 
              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.00034904 
              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.00030112 
              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', '246', '256', '259')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
0.0006249 
              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, 246, 256, 259)) AND (t_d.attribute_id IN (111, 479)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.00055408 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('199')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00025797 
              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.00028801 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('246')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00025511 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('256')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00025702 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('259')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.00026178 
              SELECT `main_table`.* FROM `mz_mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'category') AND (`source_entity_id` = '259') AND (`source_store_id` IN(0, '3')) ORDER BY source_store_id DESC
0.00054193 
              SELECT `mz_eav_attribute`.* FROM `mz_eav_attribute` WHERE (`mz_eav_attribute`.`attribute_code`='id') AND (entity_type_id = :entity_type_id)
0.00028205 
              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.00021219 
              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('259', 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.00061011 
              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('259', 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.00033712 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='259')
0.00028777 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '259')
0.00021696 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '259') 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 = '259') 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 = '259') 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 = '259') 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 = '259') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00109792 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '259') LIMIT 1
0.00019693 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('color', 'taille', 'forme', 'extensible', 'hauteur_ajustable', 'espace_rangement', 'matiere_structure', 'fournie', 'rangement_type', 'rangement_ouverture', 'rangement_equipement', 'armchair_type', 'bed_type', 'is_electrical', 'mattress_type', 'power_watts', 'removable', 'sofa_type', 'largeur', 'hauteur', 'colorfamily', 'disponibilite_menzzo', 'soldes', 'bipolart_type', 'lighting', 'type_attachment', 'type_rideau', 'motif_rideau', 'product_universes', 'size', 'bed_size', 'angle', 'diameter', 'nb_products', 'nb_persons', 'nb_places', 'nb_cutlery', 'capacity', 'piece', 'entretien', 'approximate_width', 'approximate_length', 'gigogne', 'assise_matelassee', 'dossier_matelasse', 'forme_canape', 'dimension_sommier', 'bed_elements', 'for_bed', 'for_angle', 'type_douille', 'nb_pieces', 'sold_with', 'destination', 'coussin_type', 'luminous', 'theme', 'fonctions', 'emplacement', 'specificity', 'type_of_product', 'bed_rangement_type', 'facade_type', 'approximate_height', 'photo_dimensions', 'cutlery_type', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00057292 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='259')
0.00032091 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '259')
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 = '259') 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 = '259') 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 = '259') 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 = '259') 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 = '259') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00102997 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '259') LIMIT 1
0.00020719 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('color', 'taille', 'forme', 'extensible', 'hauteur_ajustable', 'espace_rangement', 'matiere_structure', 'fournie', 'rangement_type', 'rangement_ouverture', 'rangement_equipement', 'armchair_type', 'bed_type', 'is_electrical', 'mattress_type', 'power_watts', 'removable', 'sofa_type', 'largeur', 'hauteur', 'colorfamily', 'disponibilite_menzzo', 'soldes', 'bipolart_type', 'lighting', 'type_attachment', 'type_rideau', 'motif_rideau', 'product_universes', 'size', 'bed_size', 'angle', 'diameter', 'nb_products', 'nb_persons', 'nb_places', 'nb_cutlery', 'capacity', 'piece', 'entretien', 'approximate_width', 'approximate_length', 'gigogne', 'assise_matelassee', 'dossier_matelasse', 'forme_canape', 'dimension_sommier', 'bed_elements', 'for_bed', 'for_angle', 'type_douille', 'nb_pieces', 'sold_with', 'destination', 'coussin_type', 'luminous', 'theme', 'fonctions', 'emplacement', 'specificity', 'type_of_product', 'bed_rangement_type', 'facade_type', 'approximate_height', 'photo_dimensions', 'cutlery_type', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00055909 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='259')
0.00030184 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '259')
0.00024295 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `mz_catalog_category_entity_int` AS `t` WHERE (entity_id = '259') 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 = '259') 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 = '259') 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 = '259') 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 = '259') AND (attribute_id IN (937, 2200)) AND (`store_id` IN ('3', 0))) ) AS `u` ORDER BY `store_id` ASC
0.00097609 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '259') LIMIT 1
0.00019693 
              SELECT `mz_eav_attribute`.`attribute_code`, `mz_eav_attribute`.`backend_type` FROM `mz_eav_attribute` WHERE (attribute_code IN ('color', 'taille', 'forme', 'extensible', 'hauteur_ajustable', 'espace_rangement', 'matiere_structure', 'fournie', 'rangement_type', 'rangement_ouverture', 'rangement_equipement', 'armchair_type', 'bed_type', 'is_electrical', 'mattress_type', 'power_watts', 'removable', 'sofa_type', 'largeur', 'hauteur', 'colorfamily', 'disponibilite_menzzo', 'soldes', 'bipolart_type', 'lighting', 'type_attachment', 'type_rideau', 'motif_rideau', 'product_universes', 'size', 'bed_size', 'angle', 'diameter', 'nb_products', 'nb_persons', 'nb_places', 'nb_cutlery', 'capacity', 'piece', 'entretien', 'approximate_width', 'approximate_length', 'gigogne', 'assise_matelassee', 'dossier_matelasse', 'forme_canape', 'dimension_sommier', 'bed_elements', 'for_bed', 'for_angle', 'type_douille', 'nb_pieces', 'sold_with', 'destination', 'coussin_type', 'luminous', 'theme', 'fonctions', 'emplacement', 'specificity', 'type_of_product', 'bed_rangement_type', 'facade_type', 'approximate_height', 'photo_dimensions', 'cutlery_type', 'final_price', 'categories', 'categories.lvl0', 'categories.lvl1', 'categories.lvl2'))
0.00054216 
              SELECT `mz_catalog_category_entity`.* FROM `mz_catalog_category_entity` WHERE (entity_id ='259')
0.00021911 
              SELECT `t`.* FROM `mz_catalog_category_entity` AS `t` WHERE (entity_id = '259')
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 = '259') 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 = '259') 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 = '259') 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 = '259') 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 = '259') AND (attribute_id IN (937, 2200)) AND (`store_id` IN (3, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00094604 
              SELECT `mz_catalog_category_entity`.`entity_id` FROM `mz_catalog_category_entity` WHERE (entity_id = '259') LIMIT 1
0.00018597 
              SELECT `mz_url_rewrite`.* FROM `mz_url_rewrite` WHERE (`entity_id` IN ('259')) AND (`entity_type` IN ('category')) AND (`store_id` IN (3))
0.0002501 
              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_bout-de-lit_bottom') AND (is_active = 1) AND (cbs.store_id in (3, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00041223 
              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=259 WHERE (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('3', `store_ids`)))) AND (`publish_date` <= '2024-12-11 23:48:04') AND (`enabled` = '1') ORDER BY publish_date DESC
 LIMIT 3
0.00054288 
              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('259', 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.00036907 
              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.00036192 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '493')
0.0002389 
              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.00022292 
              SELECT `mz_cms_block`.`block_id` FROM `mz_cms_block`
 INNER JOIN `mz_cms_block_store` AS `cbs` ON mz_cms_block.block_id = cbs.block_id WHERE (`mz_cms_block`.`identifier`='footer_newsletter') AND (is_active = 1) AND (cbs.store_id in (3, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00032806 
              SELECT `t`.* FROM `mz_cms_block` AS `t` WHERE (block_id = '496')
0.00019479 
              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.00022292 
              SELECT `main_table`.* FROM `mz_whatsappcontact` AS `main_table` WHERE (`active` = '1')
0.00028515

Nous contactez

Developer
2.4.6-p5
1.23 s
52.00 MB
66 q / 0.029 s
Return to Site