Free Delivery
FREE DELIVERY
Free delivery on all
orders over £40
14 Day Returns
14 DAY RETURNS
Don’t like it?
Send it back!
Latest Technology
LATEST TECHNOLOGY
High quality, smart
home products
Platinum Feefo Trusted Service Award

Free delivery on all orders over £40

Shopping basket Basket
0800 0852252

Tado

Refine your search
Price  
Type  
Characteristics  
Brand  
Shopping Options
Price

5 Items

Set Descending Direction
  1. Tado Smart Thermostat Starter Kit - V3+

    £219.99
    • Characteristics: Controls Heating Remotely, Set Schedules, Programmable
    • Compatibility: iOS & Android, Amazon Alexa, Google Home, Apple HomeKit, IFTTT
    • Feature: Smart Hub Required
    • Finish: White
    • Interconnection: Wi-Fi Enabled
    • Power: Battery Powered
    More information
  2. Tado Smart Radiator Thermostat Starter Kit - V3+H

    £56.99
    • Characteristics: Controls Radiator Temperature, Set Schedules, Programmable
    • Compatibility: iOS & Android, Amazon Alexa, Google Home, Apple HomeKit, IFTTT
    • Feature: Smart Schedule allows automatic heating schedules
    • Finish: White
    • Function: Suitable for Standard Radiators with TRV's
    • Interconnection: Wi-Fi Enabled
    • Power: Battery Powered
    More information
  3. Tado Smart Radiator Thermostat Starter Kit - V3+V

    £56.99
    • Characteristics: Controls Radiator Temperature, Set Schedules, Programmable
    • Compatibility: iOS & Android, Amazon Alexa, Google Home, Apple HomeKit, IFTTT
    • Feature: Tado Internet Bridge Supplied
    • Finish: White
    • Function: Suitable for Standard Radiators with TRV's
    • Interconnection: Wi-Fi Enabled
    • Power: Battery Powered
    More information
  4. Tado Smart AC control

    £146.99
    • Characteristics: Set Schedules
    • Compatibility: iOS & Android, Amazon Alexa, Google Home, Apple HomeKit, IFTTT
    • Finish: White
    • Interconnection: Wi-Fi Enabled
    • Power: Mains Powered
    More information
  5. Tado Smart Radiator Thermostat Kit - Vertical

    £167.99
    • Characteristics: Controls Radiator Temperature, Set Schedules, Programmable
    • Compatibility: iOS & Android, Amazon Alexa, Google Home, Apple HomeKit, IFTTT
    • Feature: Smart Hub Required
    • Finish: White
    • Function: Suitable for Standard Radiators with TRV's
    • Interconnection: Wi-Fi Enabled
    • Power: Battery Powered
    More information

5 Items

Set Descending Direction
Time
[Total Time: 0.74043154716492 secs]
SQL [Total: 617 queries]Query Params
2.96msconnect[]
0.18msSET NAMES utf8[]
1.46msSHOW TABLE STATUS LIKE 'store_website'[]
0.30msSELECT `store_website`.* FROM `store_website`[]
1.21msSHOW TABLE STATUS LIKE 'store_group'[]
0.25msSELECT `store_group`.* FROM `store_group`[]
1.61msSHOW TABLE STATUS LIKE 'store'[]
0.23msSELECT `store`.* FROM `store`[]
0.37msSELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')[]
0.39msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.37msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.35msSELECT `p`.`mana_add_layered_navigation_and_products` FROM `cms_page` AS `p` INNER JOIN `cms_page_store` AS `s` ON `s`.`page_id` = `p`.`page_id` AND `s`.`store_id` IN (0, '1') WHERE (`p`.`identifier` = 'home') AND (`p`.`is_active` = 1)[]
1.01msSELECT `mana_url_key`.* FROM `mana_url_key` WHERE (`store_id` = '1') AND (url_key IN ('smart', 'smart-technology', 'smart-technology/search', 'smart-technology/search-by', 'smart-technology/search-by-brand', 'smart-technology/search-by-brand/smart', 'smart-technology/search-by-brand/smart-technology', 'smart-technology/search-by-brand/smart-technology-search', 'smart-technology/search-by-brand/smart-technology-search-by', 'smart-technology/search-by-brand/smart-technology-search-by-brand', 'smart-technology/search-by-brand/smart-technology-search-by-brand-tado', 'technology', 'technology/search', 'technology/search-by', 'technology/search-by-brand', 'technology/search-by-brand/smart', 'technology/search-by-brand/smart-technology', 'technology/search-by-brand/smart-technology-search', 'technology/search-by-brand/smart-technology-search-by', 'technology/search-by-brand/smart-technology-search-by-brand', 'technology/search-by-brand/smart-technology-search-by-brand-tado', 'search', 'search-by', 'search-by-brand', 'search-by-brand/smart', 'search-by-brand/smart-technology', 'search-by-brand/smart-technology-search', 'search-by-brand/smart-technology-search-by', 'search-by-brand/smart-technology-search-by-brand', 'search-by-brand/smart-technology-search-by-brand-tado', 'by', 'by-brand', 'by-brand/smart', 'by-brand/smart-technology', 'by-brand/smart-technology-search', 'by-brand/smart-technology-search-by', 'by-brand/smart-technology-search-by-brand', 'by-brand/smart-technology-search-by-brand-tado', 'brand', 'brand/smart', 'brand/smart-technology', 'brand/smart-technology-search', 'brand/smart-technology-search-by', 'brand/smart-technology-search-by-brand', 'brand/smart-technology-search-by-brand-tado', 'smart-technology-search', 'smart-technology-search-by', 'smart-technology-search-by-brand', 'smart-technology-search-by-brand-tado', 'technology-search', 'technology-search-by', 'technology-search-by-brand', 'technology-search-by-brand-tado', 'search-by-brand-tado', 'by-brand-tado', 'brand-tado', 'tado')) AND (status IN ('active', 'redirected'))[]
0.28msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.39msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.30msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.23msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.23msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.25msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.24msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
0.23msSELECT `ch`.`path`, `ch`.`value` FROM `mana_config_history` AS `ch` WHERE (`ch`.`scope` = 'stores' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'websites' AND `ch`.`scope_id` = 1 OR `ch`.`scope` = 'default')[]
31.02msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('smart-technology/search-by-brand/smart-technology-search-by-brand-tado', 'smart-technology/search-by-brand/smart-technology-search-by-brand-tado/')) AND (`store_id` IN ('1'))[]
0.44msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/835', 'catalog/category/view/id/835/')) AND (`store_id` IN ('1'))[]
0.54msSELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite` LEFT JOIN `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/835', 'catalog/category/view/id/835/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)[]
15.02msSELECT `main_table`.* FROM `mst_seo_redirect` AS `main_table` LEFT JOIN `mst_seo_redirect_store` AS `store_table` ON main_table.redirect_id = store_table.redirect_id WHERE (`is_active` = '1') AND (store_table.store_id in (0, '1')) AND (url_from = 'https://stage.electrical-showroom.co.uk/smart-technology/search-by-brand/smart-technology-search-by-brand-tado' OR url_from = 'smart-technology/search-by-brand/smart-technology-search-by-brand-tado' OR url_from = '/smart-technology/search-by-brand/smart-technology-search-by-brand-tado' OR 'smart-technology/search-by-brand/smart-technology-search-by-brand-tado' LIKE CONCAT(REPLACE(url_from, '*', '%')) OR '/smart-technology/search-by-brand/smart-technology-search-by-brand-tado' LIKE CONCAT(REPLACE(url_from, '*', '%')) OR 'https://stage.electrical-showroom.co.uk/smart-technology/search-by-brand/smart-technology-search-by-brand-tado' LIKE CONCAT(REPLACE(url_from, '*', '%')) OR 'smart-technology/search-by-brand/smart-technology-search-by-brand-tado' LIKE CONCAT(REPLACE(url_from, '[redirect_chain]', '%')) OR '/smart-technology/search-by-brand/smart-technology-search-by-brand-tado' LIKE CONCAT(REPLACE(url_from, '[redirect_chain]', '%')) OR 'https://stage.electrical-showroom.co.uk/smart-technology/search-by-brand/smart-technology-search-by-brand-tado' LIKE CONCAT(REPLACE(url_from, '[redirect_chain]', '%'))) ORDER BY LENGTH(url_from) DESC []
0.30msSELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =835)[]
0.30msSELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 835)[]
1.29msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '835') AND (attribute_id IN ('41', '132', '43', '45', '46', '49', '58', '57', '61', '66')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '835') AND (attribute_id IN ('322', '1168', '42', '68', '69', '67', '144', '336', '50', '51')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '835') AND (attribute_id IN ('334', '323', '44', '47', '48', '54', '55', '56', '65', '62')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '835') AND (attribute_id IN ('59', '60')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '835') AND (attribute_id IN ('70')) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC []
0.30msSELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '835') LIMIT 1[]
0.42msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='custom_layout_update_file') AND (entity_type_id = :entity_type_id){":entity_type_id":"3"}
0.23msSELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id){":entity_type_id":"3"}
0.28msSELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id){":attribute_id":"649"}
0.69msSELECT `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 `catalog_category_entity` AS `e` LEFT JOIN `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` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0 LEFT JOIN `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` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_id` IN('835', '735', '734', '2', '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 []
1.31msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (835, 735, 734, 2)) AND (t_d.attribute_id IN ('58', '61', '649')) 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 `catalog_category_entity_datetime` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (835, 735, 734, 2)) AND (t_d.attribute_id IN ('59', '60')) 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 `catalog_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (835, 735, 734, 2)) AND (t_d.attribute_id IN ('62')) 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 `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (835, 735, 734, 2)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.40msSELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `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 `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){":attribute_id":42,":store_id":"1",":active_flag":true,":c_path":"1\/2\/734\/735\/835\/%"}
0.33msSELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `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 `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){":attribute_id":42,":store_id":"1",":active_flag":true,":c_path":"1\/2\/734\/735\/835\/%"}
0.44msSELECT `layout_update`.`xml`, `layout_update`.`handle` FROM `layout_update` INNER JOIN `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 {":theme_id":"7",":store_id":"1"}
0.48msSELECT `main_table`.* FROM `sm_megamenu_items` AS `main_table` WHERE (main_table.depth = 2) AND (main_table.group_id = 1) AND (main_table.status = 1) GROUP BY `main_table`.`items_id` ORDER BY `main_table`.`priorities` ASC []
1.83msSELECT `main_table`.* FROM `sm_megamenu_items` AS `main_table` CROSS JOIN `sm_megamenu_items` AS `parent` WHERE (main_table.depth = 2) AND (main_table.group_id = 1) AND (parent.group_id = 1) AND (main_table.status = 1) GROUP BY `main_table`.`items_id` ORDER BY `main_table`.`priorities` ASC []
0.59msSELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` LEFT JOIN `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` = '42') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_id` IN('734', '735', '835')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')[]
0.54msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (734, 735, 835)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.44msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('734')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))[]
0.36msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('735')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))[]
1.06msSELECT `main_table`.* FROM `mana_filter` AS `main_table` WHERE (`main_table`.`store_id` = '1') AND (`is_enabled_in_categories` = '1') ORDER BY `position` ASC []
2.83msSELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0) ORDER BY position ASC []
0.44msSELECT `main_table`.* FROM `mst_seo_content_template` AS `main_table` WHERE (`is_active` = '1') AND (`rule_type` = '3') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.31msSELECT `main_table`.* FROM `mst_seo_content_rewrite` AS `main_table` WHERE (`is_active` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.31msSELECT `main_table`.* FROM `mst_seo_content_template` AS `main_table` WHERE (`is_active` = '1') AND (`rule_type` = '3') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.25msSELECT `main_table`.* FROM `mst_seo_content_rewrite` AS `main_table` WHERE (`is_active` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.52msSELECT `main_table`.`name`, `link`.`group_id`, COALESCE(groups.name, "None") AS `group` FROM `amasty_gdprcookie_cookie` AS `main_table` LEFT JOIN `amasty_gdprcookie_cookie_group_link` AS `link` ON main_table.id = link.cookie_id LEFT JOIN `amasty_gdprcookie_group_cookie` AS `groups` ON link.group_id = groups.id WHERE (`groups`.`is_essential` = '1')[]
75.22msCREATE TEMPORARY TABLE `temp_ba621c131efd0a82111dd1fb7b31549b5c155568` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity_id' , UNIQUE `TEMP_BA621C131EFD0A82111DD1FB7B31549B5C155568_ENTITY_ID` (`entity_id`) ) COMMENT='temp_ba621c131efd0a82111dd1fb7b31549b5c155568' ENGINE=innodb charset=utf8 COLLATE=utf8_general_ci[]
0.61msINSERT IGNORE INTO `temp_ba621c131efd0a82111dd1fb7b31549b5c155568` SELECT DISTINCT `e`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=835 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0[]
0.44msSELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m` LEFT JOIN `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 `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 (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level){":attribute_id":42,":store_id":1,":scope":1,":c_path":"1\/2\/734\/735\/835\/%",":c_level":5}
0.27msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='1')[]
0.24msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT `c`.`class_id` FROM `tax_class` AS `c` WHERE (`c`.`class_type` = 'PRODUCT')[]
0.54msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'SO19 2PB', 'SO19 2PB*', 'SO19 2P*', 'SO19 2*', 'SO19 *', 'SO19*', 'SO1*', 'SO*', 'S*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.44msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('4')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'SO19 2PB', 'SO19 2PB*', 'SO19 2P*', 'SO19 2*', 'SO19 *', 'SO19*', 'SO1*', 'SO*', 'S*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.46msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('5')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'SO19 2PB', 'SO19 2PB*', 'SO19 2P*', 'SO19 2*', 'SO19 *', 'SO19*', 'SO1*', 'SO*', 'S*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.52msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('6')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'SO19 2PB', 'SO19 2PB*', 'SO19 2P*', 'SO19 2*', 'SO19 *', 'SO19*', 'SO1*', 'SO*', 'S*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.53msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('7')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'SO19 2PB', 'SO19 2PB*', 'SO19 2P*', 'SO19 2*', 'SO19 *', 'SO19*', 'SO1*', 'SO*', 'S*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)[]
0.25msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.32msSELECT `c`.`class_id` FROM `tax_class` AS `c` WHERE (`c`.`class_type` = 'PRODUCT')[]
0.54msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '', '*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.53msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('4')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '', '*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.57msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('5')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '', '*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.53msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('6')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '', '*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.52msSELECT `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 `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('7')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '', '*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC []
0.41msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.28msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.31msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.67msSELECT ROUND(`price_index`.`min_price`-(`price_index`.`min_price`/(1+(CASE `price_index`.`tax_class_id` WHEN 2 THEN 0.2000 WHEN 4 THEN 0.0000 WHEN 5 THEN 0.0000 WHEN 6 THEN 0.2000 WHEN 7 THEN 0.0000 ELSE 0 END))*CASE `price_index`.`tax_class_id` WHEN 2 THEN 0.2000 WHEN 4 THEN 0.0000 WHEN 5 THEN 0.0000 WHEN 6 THEN 0.2000 WHEN 7 THEN 0.0000 ELSE 0 END), 2) AS `available_values` FROM `temp_ba621c131efd0a82111dd1fb7b31549b5c155568` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON `price_index`.`entity_id` = `e`.`entity_id` AND `price_index`.`website_id` = '1' AND `price_index`.`customer_group_id` = 0[]
0.48msSELECT FLOOR(MIN(ROUND(`price_index`.`min_price`-(`price_index`.`min_price`/(1+(CASE `price_index`.`tax_class_id` WHEN 2 THEN 0.2000 WHEN 4 THEN 0.0000 WHEN 5 THEN 0.0000 WHEN 6 THEN 0.2000 WHEN 7 THEN 0.0000 ELSE 0 END))*CASE `price_index`.`tax_class_id` WHEN 2 THEN 0.2000 WHEN 4 THEN 0.0000 WHEN 5 THEN 0.0000 WHEN 6 THEN 0.2000 WHEN 7 THEN 0.0000 ELSE 0 END), 2)) * 1) / 1 AS `min`, CEIL(MAX(ROUND(`price_index`.`min_price`-(`price_index`.`min_price`/(1+(CASE `price_index`.`tax_class_id` WHEN 2 THEN 0.2000 WHEN 4 THEN 0.0000 WHEN 5 THEN 0.0000 WHEN 6 THEN 0.2000 WHEN 7 THEN 0.0000 ELSE 0 END))*CASE `price_index`.`tax_class_id` WHEN 2 THEN 0.2000 WHEN 4 THEN 0.0000 WHEN 5 THEN 0.0000 WHEN 6 THEN 0.2000 WHEN 7 THEN 0.0000 ELSE 0 END), 2)) * 1) / 1 AS `max`, COUNT(*) AS `count` FROM `temp_ba621c131efd0a82111dd1fb7b31549b5c155568` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON `price_index`.`entity_id` = `e`.`entity_id` AND `price_index`.`website_id` = '1' AND `price_index`.`customer_group_id` = 0[]
72.05msCREATE TEMPORARY TABLE `temp_96282dc3f7bdd87c41af8b6006d2b06a721a8ec6` ( `value` int UNSIGNED NOT NULL COMMENT 'Value' , `count` int UNSIGNED NOT NULL COMMENT 'Count' , `attribute_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute_id' , UNIQUE `TEMP_96282DC3F7BDD87C41AF8B6006D2B06A721A8EC6_VALUE` (`value`), INDEX `TEMP_96282DC3F7BDD87C41AF8B6006D2B06A721A8EC6_ATTRIBUTE_ID` (`attribute_id`) ) COMMENT='temp_96282dc3f7bdd87c41af8b6006d2b06a721a8ec6' ENGINE=innodb charset=utf8 COLLATE=utf8_general_ci[]
1.29msINSERT IGNORE INTO `temp_96282dc3f7bdd87c41af8b6006d2b06a721a8ec6` (`count`, `attribute_id`, `value`) SELECT COUNT(DISTINCT `eav`.`entity_id`) AS `count`, `eav`.`attribute_id` AS `attribute_id`, `eav`.`value` AS `value` FROM `temp_ba621c131efd0a82111dd1fb7b31549b5c155568` AS `e` INNER JOIN `catalog_product_index_eav` AS `eav` ON `eav`.`entity_id` = `e`.`entity_id` AND `eav`.`attribute_id` IN ('636', '594', '560', '595', '584', '535', '614', '597', '593', '621', '620', '310', '160', '622', '592', '164', '576', '320', '339', '605', '577', '202', '545', '603', '304', '153', '311', '319', '459', '536', '623', '541', '321', '316', '318', '194', '253', '312', '269', '273', '315', '234', '150', '314', '624', '188', '258', '245', '214', '317', '290', '313', '243', '221', '456', '277', '458', '460', '534', '461', '539', '544', '538', '585', '543', '540', '537', '546', '542') AND `eav`.`store_id` = '1' INNER JOIN `cataloginventory_stock_status` AS `eav__stock` ON `eav`.`source_id` = `eav__stock`.`product_id` AND `eav__stock`.`website_id` = 0 AND `eav__stock`.`stock_id` = 1 AND `eav__stock`.`stock_status` = 1 GROUP BY `eav`.`attribute_id`, `eav`.`value`[]
0.61msSELECT `eav`.`count`, `eav`.`attribute_id` AS `attribute_id`, `o`.`sort_order` AS `sort_order`, `eav`.`value` AS `value`, COALESCE(`vs`.`value`, `vg`.`value`) AS `label`, 1 <> 1 AS `is_selected`, `url_key`.`url_key` AS `url_key`, `url_key`.`position` AS `url_position` FROM `temp_96282dc3f7bdd87c41af8b6006d2b06a721a8ec6` AS `eav` INNER JOIN `eav_attribute_option` AS `o` ON `o`.`option_id` = `eav`.`value` INNER JOIN `eav_attribute_option_value` AS `vg` ON `vg`.`option_id` = `eav`.`value` AND `vg`.`store_id` = 0 LEFT JOIN `eav_attribute_option_value` AS `vs` ON `vs`.`option_id` = `eav`.`value` AND `vs`.`store_id` = '1' LEFT JOIN `mana_url_key` AS `url_key` ON `url_key`.`option_id` = `eav`.`value` AND `url_key`.`sub_type` = 'filter_option' AND `url_key`.`status` = 'active' AND `url_key`.`store_id` = '1' LIMIT 1000[]
0.30msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.33msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.26msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.30msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id){":entity_type_id":"4"}
0.54msSELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=835 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `temp_ba621c131efd0a82111dd1fb7b31549b5c155568` AS `product_id_filter` ON `e`.`entity_id` = `product_id_filter`.`entity_id` INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1)[]
0.72msSELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=835 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `temp_ba621c131efd0a82111dd1fb7b31549b5c155568` AS `product_id_filter` ON `e`.`entity_id` = `product_id_filter`.`entity_id` LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` asc, `cat_index`.`position` asc, `e`.`entity_id` DESC, `e`.`entity_id` ASC LIMIT 10[]
6.02msSELECT `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 `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_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 = 1 WHERE (e.entity_id IN (5713, 4054, 1953, 1951, 1944)) AND (t_d.attribute_id IN ('71', '86', '87', '97', '112', '113', '114', '119', '133', '152', '154', '155', '161', '163', '166', '169', '173', '175', '178', '182', '189', '195', '201', '207', '212', '213', '216', '227', '229', '233', '240', '248', '256', '257', '262', '267', '270', '272', '278', '280', '298', '299', '327', '462', '463', '464', '465', '532', '533', '547', '548', '549', '550', '551', '552', '553', '554', '555', '556', '557', '558', '559', '564', '567', '575', '586', '589', '596', '598', '599', '606', '609', '610', '611', '613', '617', '626', '627', '640', '653', '1121')) 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 `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_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 = 1 WHERE (e.entity_id IN (5713, 4054, 1953, 1951, 1944)) AND (t_d.attribute_id IN ('73', '1125', '1126', '1127', '1128', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167')) 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 `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` 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 = 1 WHERE (e.entity_id IN (5713, 4054, 1953, 1951, 1944)) AND (t_d.attribute_id IN ('76', '120')) 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 `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_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 = 1 WHERE (e.entity_id IN (5713, 4054, 1953, 1951, 1944)) AND (t_d.attribute_id IN ('77', '78', '93', '94')) 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 `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_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 = 1 WHERE (e.entity_id IN (5713, 4054, 1953, 1951, 1944)) AND (t_d.attribute_id IN ('96', '121', '123', '125', '126', '127', '128', '131', '150', '300', '587', '650', '1123')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
1.01msSELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('5713', '4054', '1953', '1951', '1944')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)[]
0.38msSELECT `mana_url_key`.`url_key` FROM `mana_url_key` WHERE (`store_id` = '1') AND (`type` = 'page') AND (`status` = 'active') AND (`sub_type` = 'category_page') AND (`category_id` = '835')[]
0.33msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.39msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.23msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.36msSELECT `directory_country`.* FROM `directory_country` WHERE (`directory_country`.`iso2_code`='GB')[]
0.34msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.25msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.46msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.28msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/aam_settings')[]
0.26msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.59msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (734, 735, 835)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.50msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.39msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '5713') ORDER BY `qty` ASC []
0.30msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('5713'))[]
0.31msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.25msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.22msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.26msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.25msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('5713'))[]
0.87msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('5713'))[]
0.48msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.42msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '4054') ORDER BY `qty` ASC []
0.24msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('4054'))[]
0.30msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.26msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.21msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.26msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.22msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('4054'))[]
0.37msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('4054'))[]
0.40msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.28msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1953') ORDER BY `qty` ASC []
0.24msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1953'))[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.25msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.38msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.27msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.31msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.25msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1953'))[]
0.37msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1953'))[]
0.39msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.29msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1951') ORDER BY `qty` ASC []
0.25msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1951'))[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.25msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.27msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1951'))[]
0.33msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1951'))[]
0.36msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.27msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1944') ORDER BY `qty` ASC []
0.22msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1944'))[]
0.26msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.17msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.21msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.19msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.24msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.22msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.18msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.23msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.19msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.21msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.19msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-09-26') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1944'))[]
0.36msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1944'))[]
0.75msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='right-side-icons') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.29msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '131')[]
0.42msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":131}
0.56msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='header_free_delivery_info') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.23msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '125')[]
0.43msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":125}
51.35msSELECT `main_table`.`consent_id`, `main_table`.`name`, `main_table`.`consent_code`, IFNULL(amasty_gdpr_consents_scope.`is_enabled`, amasty_gdpr_consents_scope_default.`is_enabled`) AS `is_enabled`, IFNULL(amasty_gdpr_consents_scope.`is_required`, amasty_gdpr_consents_scope_default.`is_required`) AS `is_required`, IFNULL(amasty_gdpr_consents_scope.`log_the_consent`, amasty_gdpr_consents_scope_default.`log_the_consent`) AS `log_the_consent`, IFNULL(amasty_gdpr_consents_scope.`hide_the_consent_after_user_left_the_consent`, amasty_gdpr_consents_scope_default.`hide_the_consent_after_user_left_the_consent`) AS `hide_the_consent_after_user_left_the_consent`, IFNULL(amasty_gdpr_consents_scope.`consent_location`, amasty_gdpr_consents_scope_default.`consent_location`) AS `consent_location`, IFNULL(amasty_gdpr_consents_scope.`link_type`, amasty_gdpr_consents_scope_default.`link_type`) AS `link_type`, IFNULL(amasty_gdpr_consents_scope.`cms_page_id`, amasty_gdpr_consents_scope_default.`cms_page_id`) AS `cms_page_id`, IFNULL(amasty_gdpr_consents_scope.`consent_text`, amasty_gdpr_consents_scope_default.`consent_text`) AS `consent_text`, IFNULL(amasty_gdpr_consents_scope.`countries`, amasty_gdpr_consents_scope_default.`countries`) AS `countries`, IFNULL(amasty_gdpr_consents_scope.`visibility`, amasty_gdpr_consents_scope_default.`visibility`) AS `visibility`, IFNULL(amasty_gdpr_consents_scope.`sort_order`, amasty_gdpr_consents_scope_default.`sort_order`) AS `sort_order` FROM `amasty_gdpr_consents` AS `main_table` LEFT JOIN `amasty_gdpr_consents_scope` ON (main_table.consent_id = amasty_gdpr_consents_scope.consent_entity_id AND amasty_gdpr_consents_scope.store_id = 1) INNER JOIN `amasty_gdpr_consents_scope` AS `amasty_gdpr_consents_scope_default` ON main_table.consent_id = amasty_gdpr_consents_scope_default.consent_entity_id WHERE (`amasty_gdpr_consents_scope_default`.`store_id` = '0') AND (IFNULL(amasty_gdpr_consents_scope.`is_enabled`, amasty_gdpr_consents_scope_default.`is_enabled`) = '1') AND (IFNULL(amasty_gdpr_consents_scope.`hide_the_consent_after_user_left_the_consent`, amasty_gdpr_consents_scope_default.`hide_the_consent_after_user_left_the_consent`) = '1') ORDER BY IFNULL(amasty_gdpr_consents_scope.`sort_order`, amasty_gdpr_consents_scope_default.`sort_order`) ASC []
0.48msSELECT `main_table`.* FROM `quote_address` AS `main_table` WHERE (`quote_id` IS NULL)[]
0.43msSELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`parent_id` = '-1')[]
0.67msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='header-customer-service') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.25msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '132')[]
0.26msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":132}
0.35msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.39msSELECT `captcha_log`.`count` FROM `captcha_log` WHERE (type = 1) AND (value = '44.192.254.246')[]
0.22msSELECT `captcha_log`.`count` FROM `captcha_log` WHERE (type = 1) AND (value = '44.192.254.246')[]
0.35msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='phone-header-v5') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.25msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '10')[]
0.26msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":10}
6.48msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
20.19msSELECT `main_table`.* FROM `magefan_blog_category` AS `main_table` INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`is_active` = '1') AND (`include_in_menu` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC []
9.30msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
9.33msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.49msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='megamenu-horizontal') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.26msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '5')[]
0.26msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":5}
0.45msSELECT `main_table`.* FROM `sm_megamenu_items` AS `main_table` WHERE (main_table.depth = 2) AND (main_table.group_id = 2) AND (main_table.status = 1) GROUP BY `main_table`.`items_id` ORDER BY `main_table`.`priorities` ASC []
18.16msSELECT `main_table`.* FROM `sm_megamenu_items` AS `main_table` CROSS JOIN `sm_megamenu_items` AS `parent` WHERE (main_table.depth = 2) AND (main_table.group_id = 2) AND (parent.group_id = 2) AND (main_table.status = 1) GROUP BY `main_table`.`items_id` ORDER BY `main_table`.`priorities` ASC []
0.62msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='link-right-header') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.30msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '16')[]
0.24msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":16}
0.46msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 5713)[]
0.52msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.38msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.25msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.25msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.24msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.38msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.22msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.36msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.25msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.31msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.28msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.24msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.41msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.62msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '300') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.44msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 4054)[]
0.51msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.38msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.29msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.27msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.26msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.31msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.23msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.30msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.31msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.29msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.29msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.32msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.24msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.28msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.24msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.31msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.23msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.27msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.49msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.32msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.28msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.26msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.36msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '300') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.39msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1953)[]
0.58msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.32msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.26msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.26msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.25msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.42msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.26msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.33msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.26msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.26msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.23msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.32msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.37msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '300') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.43msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1951)[]
0.59msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.35msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.26msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.29msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.23msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.26msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.35msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.29msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.38msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.24msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.32msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.43msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.34msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.25msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.31msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.33msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.25msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.28msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.32msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.25msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.29msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.36msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.51msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '300') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.37msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1944)[]
0.52msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.36msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.23msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.24msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.39msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.24msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.24msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.54msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.26msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.28msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.28msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.24msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.52msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '300') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.86msSELECT `mana_url_key`.`url_key`, `mana_url_key`.`sub_type`, `mana_url_key`.`param_name`, `mana_url_key`.`url_part`, `mana_url_key`.`requires_param_name`, `mana_url_key`.`position`, `mana_url_key`.`id` FROM `mana_url_key` WHERE (`store_id` = '1') AND (`type` = 'parameter') AND (`status` = 'active')[]
0.46msSELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='5713')[]
0.33msSELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '5713')[]
3.92msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '5713') AND (attribute_id IN ('71', '82', '85', '122', '152', '151', '331', '103', '86', '321', '154', '156', '332', '638', '84', '87', '107', '155', '158', '333', '326', '640', '109', '548', '159', '335', '88', '161', '162', '133', '119', '95', '163', '165', '320', '166', '168', '169', '601', '173', '171', '598', '170', '1124', '98', '175', '172', '97', '178', '628', '606', '174', '182', '629', '117', '189', '177', '112', '195', '180', '113', '201', '630', '114', '207', '181', '212', '183', '653', '213', '184', '1121', '185', '329', '216', '186', '298', '187', '465', '190', '626', '191', '227', '203', '129', '229', '205', '130', '233', '206', '299', '208', '240', '209', '327', '210', '211', '612', '215', '248', '217', '256', '218', '257', '309', '262', '219', '267', '223', '270', '224', '272', '225', '278', '226', '280', '230', '599', '232', '627', '235', '228', '236', '237', '238', '239', '231', '615', '242', '625', '241', '617', '246', '247', '250', '252', '254', '255', '260', '261', '302', '264', '265', '266', '268', '271', '275', '613', '303', '276', '281', '200', '196', '197', '198', '199', '222')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '5713') AND (attribute_id IN ('76', '75', '79', '91', '120', '99', '80', '337')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '5713') AND (attribute_id IN ('100', '310', '127', '153', '160', '622', '89', '164', '121', '585', '126', '314', '587', '188', '96', '202', '194', '102', '605', '214', '319', '150', '603', '328', '312', '330', '221', '340', '1122', '234', '285', '311', '315', '317', '338', '243', '123', '608', '128', '124', '614', '125', '316', '650', '318', '131', '637', '313', '1123', '245', '290', '304', '300', '253', '258', '273', '269', '277', '623')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '5713') AND (attribute_id IN ('104', '77', '105', '78', '93', '94')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '5713') AND (attribute_id IN ('1125', '83', '101', '1126', '72', '1127', '106', '1128', '73', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '284')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC []
0.80msSELECT `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 `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `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 `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '5713') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC []
5.12msSELECT `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 `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `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 `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 `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 = '88') AND (main.disabled = 0) AND (entity.entity_id = '5713') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC []
0.33msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 5713)[]
0.25msSELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 5713)[]
0.33msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '5713') ORDER BY `qty` ASC []
0.40msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-ST01EK01IB01-TC-UK-00'))[]
0.28msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.25msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.26msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.29msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`type_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-ST01EK01IB01-TC-UK-00'))[]
0.43msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (product_id='5713') AND (stock_id=1) LIMIT 1[]
0.46msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.27msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.29msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.29msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.35msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.24msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.31msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.24msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.41msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.28msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.29msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.26msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.33msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.23msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.48msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.24msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.61msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.36msSELECT `main_table`.* FROM `mst_seo_content_template` AS `main_table` WHERE (`is_active` = '1') AND (`rule_type` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.29msSELECT `main_table`.* FROM `mst_seo_content_rewrite` AS `main_table` WHERE (`is_active` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.48msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (`store_id` = '1') AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='5713') ORDER BY main_table.created_at DESC []
0.63msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='5713') ORDER BY main_table.created_at DESC []
0.30msSELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='4054')[]
0.30msSELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '4054')[]
5.65msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '4054') AND (attribute_id IN ('71', '82', '85', '122', '152', '151', '331', '103', '86', '321', '154', '156', '332', '638', '84', '87', '107', '155', '158', '333', '326', '640', '109', '548', '159', '335', '88', '161', '162', '133', '119', '95', '163', '165', '320', '166', '168', '169', '601', '173', '171', '598', '170', '1124', '98', '175', '172', '97', '178', '628', '606', '174', '182', '629', '117', '189', '177', '112', '195', '180', '113', '201', '630', '114', '207', '181', '212', '183', '653', '213', '184', '1121', '185', '329', '216', '186', '298', '187', '465', '190', '626', '191', '227', '203', '129', '229', '205', '130', '233', '206', '299', '208', '240', '209', '327', '210', '211', '612', '215', '248', '217', '256', '218', '257', '309', '262', '219', '267', '223', '270', '224', '272', '225', '278', '226', '280', '230', '599', '232', '627', '235', '228', '236', '237', '238', '239', '231', '615', '242', '625', '241', '617', '246', '247', '250', '252', '254', '255', '260', '261', '302', '264', '265', '266', '268', '271', '275', '613', '303', '276', '281', '200', '196', '197', '198', '199', '222')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '4054') AND (attribute_id IN ('76', '75', '79', '91', '120', '99', '80', '337')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '4054') AND (attribute_id IN ('100', '310', '127', '153', '160', '622', '89', '164', '121', '585', '126', '314', '587', '188', '96', '202', '194', '102', '605', '214', '319', '150', '603', '328', '312', '330', '221', '340', '1122', '234', '285', '311', '315', '317', '338', '243', '123', '608', '128', '124', '614', '125', '316', '650', '318', '131', '637', '313', '1123', '245', '290', '304', '300', '253', '258', '273', '269', '277', '623')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '4054') AND (attribute_id IN ('104', '77', '105', '78', '93', '94')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '4054') AND (attribute_id IN ('1125', '83', '101', '1126', '72', '1127', '106', '1128', '73', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '284')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC []
0.70msSELECT `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 `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `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 `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '4054') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC []
0.99msSELECT `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 `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `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 `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 `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 = '88') AND (main.disabled = 0) AND (entity.entity_id = '4054') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC []
0.28msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 4054)[]
0.26msSELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 4054)[]
0.36msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '4054') ORDER BY `qty` ASC []
0.31msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-SRT01HIB01-TC-ML'))[]
0.26msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.25msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.25msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.27msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`type_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-SRT01HIB01-TC-ML'))[]
0.38msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (product_id='4054') AND (stock_id=1) LIMIT 1[]
0.76msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
1.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.60msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.37msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.67msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.28msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
1.31msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.54msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.27msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.55msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.41msSELECT `main_table`.* FROM `mst_seo_content_template` AS `main_table` WHERE (`is_active` = '1') AND (`rule_type` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.26msSELECT `main_table`.* FROM `mst_seo_content_rewrite` AS `main_table` WHERE (`is_active` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.35msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (`store_id` = '1') AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='4054') ORDER BY main_table.created_at DESC []
0.50msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='4054') ORDER BY main_table.created_at DESC []
4.33msSELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='1953')[]
0.36msSELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '1953')[]
4.09msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1953') AND (attribute_id IN ('71', '82', '85', '122', '152', '151', '331', '103', '86', '321', '154', '156', '332', '638', '84', '87', '107', '155', '158', '333', '326', '640', '109', '548', '159', '335', '88', '161', '162', '133', '119', '95', '163', '165', '320', '166', '168', '169', '601', '173', '171', '598', '170', '1124', '98', '175', '172', '97', '178', '628', '606', '174', '182', '629', '117', '189', '177', '112', '195', '180', '113', '201', '630', '114', '207', '181', '212', '183', '653', '213', '184', '1121', '185', '329', '216', '186', '298', '187', '465', '190', '626', '191', '227', '203', '129', '229', '205', '130', '233', '206', '299', '208', '240', '209', '327', '210', '211', '612', '215', '248', '217', '256', '218', '257', '309', '262', '219', '267', '223', '270', '224', '272', '225', '278', '226', '280', '230', '599', '232', '627', '235', '228', '236', '237', '238', '239', '231', '615', '242', '625', '241', '617', '246', '247', '250', '252', '254', '255', '260', '261', '302', '264', '265', '266', '268', '271', '275', '613', '303', '276', '281', '200', '196', '197', '198', '199', '222')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1953') AND (attribute_id IN ('76', '75', '79', '91', '120', '99', '80', '337')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1953') AND (attribute_id IN ('100', '310', '127', '153', '160', '622', '89', '164', '121', '585', '126', '314', '587', '188', '96', '202', '194', '102', '605', '214', '319', '150', '603', '328', '312', '330', '221', '340', '1122', '234', '285', '311', '315', '317', '338', '243', '123', '608', '128', '124', '614', '125', '316', '650', '318', '131', '637', '313', '1123', '245', '290', '304', '300', '253', '258', '273', '269', '277', '623')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1953') AND (attribute_id IN ('104', '77', '105', '78', '93', '94')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1953') AND (attribute_id IN ('1125', '83', '101', '1126', '72', '1127', '106', '1128', '73', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '284')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC []
7.84msSELECT `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 `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `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 `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1953') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC []
0.97msSELECT `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 `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `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 `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 `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 = '88') AND (main.disabled = 0) AND (entity.entity_id = '1953') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC []
0.24msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1953)[]
0.22msSELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1953)[]
0.33msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1953') ORDER BY `qty` ASC []
3.76msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-SRT01VIB01-TC-ML'))[]
1.17msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.41msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
6.94msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.31msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`type_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-SRT01VIB01-TC-ML'))[]
0.85msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (product_id='1953') AND (stock_id=1) LIMIT 1[]
0.28msSELECT `main_table`.* FROM `inventory_source_stock_link` AS `main_table` WHERE ((`stock_id` = 1)) ORDER BY priority ASC []
0.21msSELECT COUNT(*) FROM `inventory_source_stock_link` AS `main_table` WHERE ((`stock_id` = 1))[]
4.14msSELECT `inventory_source`.* FROM `inventory_source` WHERE (`inventory_source`.`source_code`='default')[]
0.84msSELECT `main_table`.* FROM `inventory_source_carrier_link` AS `main_table` WHERE ((`source_code` = 'default'))[]
0.32msSELECT `main_table`.* FROM `inventory_source_item` AS `main_table` WHERE ((`sku` = 'V3P-SK-SRT01VIB01-TC-ML')) AND ((`source_code` IN('default'))) AND ((`status` = 1))[]
6.55msSELECT COUNT(*) FROM `inventory_source_item` AS `main_table` WHERE ((`sku` = 'V3P-SK-SRT01VIB01-TC-ML')) AND ((`source_code` IN('default'))) AND ((`status` = 1))[]
0.81msSELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = '1953')[]
0.27msSELECT SUM(quantity) AS `quantity` FROM `inventory_reservation` WHERE (sku = 'V3P-SK-SRT01VIB01-TC-ML') AND (stock_id = 1) LIMIT 1[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.23msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.38msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
3.03msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.73msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.25msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.21msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
3.70msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
2.34msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.26msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.29msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
7.21msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.41msSELECT `main_table`.* FROM `mst_seo_content_template` AS `main_table` WHERE (`is_active` = '1') AND (`rule_type` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.29msSELECT `main_table`.* FROM `mst_seo_content_rewrite` AS `main_table` WHERE (`is_active` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
2.74msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (`store_id` = '1') AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='1953') ORDER BY main_table.created_at DESC []
0.70msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='1953') ORDER BY main_table.created_at DESC []
0.26msSELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='1951')[]
0.34msSELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '1951')[]
9.92msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1951') AND (attribute_id IN ('71', '82', '85', '122', '152', '151', '331', '103', '86', '321', '154', '156', '332', '638', '84', '87', '107', '155', '158', '333', '326', '640', '109', '548', '159', '335', '88', '161', '162', '133', '119', '95', '163', '165', '320', '166', '168', '169', '601', '173', '171', '598', '170', '1124', '98', '175', '172', '97', '178', '628', '606', '174', '182', '629', '117', '189', '177', '112', '195', '180', '113', '201', '630', '114', '207', '181', '212', '183', '653', '213', '184', '1121', '185', '329', '216', '186', '298', '187', '465', '190', '626', '191', '227', '203', '129', '229', '205', '130', '233', '206', '299', '208', '240', '209', '327', '210', '211', '612', '215', '248', '217', '256', '218', '257', '309', '262', '219', '267', '223', '270', '224', '272', '225', '278', '226', '280', '230', '599', '232', '627', '235', '228', '236', '237', '238', '239', '231', '615', '242', '625', '241', '617', '246', '247', '250', '252', '254', '255', '260', '261', '302', '264', '265', '266', '268', '271', '275', '613', '303', '276', '281', '200', '196', '197', '198', '199', '222')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1951') AND (attribute_id IN ('76', '75', '79', '91', '120', '99', '80', '337')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1951') AND (attribute_id IN ('100', '310', '127', '153', '160', '622', '89', '164', '121', '585', '126', '314', '587', '188', '96', '202', '194', '102', '605', '214', '319', '150', '603', '328', '312', '330', '221', '340', '1122', '234', '285', '311', '315', '317', '338', '243', '123', '608', '128', '124', '614', '125', '316', '650', '318', '131', '637', '313', '1123', '245', '290', '304', '300', '253', '258', '273', '269', '277', '623')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1951') AND (attribute_id IN ('104', '77', '105', '78', '93', '94')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1951') AND (attribute_id IN ('1125', '83', '101', '1126', '72', '1127', '106', '1128', '73', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '284')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC []
0.66msSELECT `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 `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `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 `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1951') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC []
1.38msSELECT `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 `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `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 `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 `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 = '88') AND (main.disabled = 0) AND (entity.entity_id = '1951') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC []
0.30msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1951)[]
0.26msSELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1951)[]
0.33msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1951') ORDER BY `qty` ASC []
6.02msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('AC01-TC-EN-02'))[]
0.30msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.23msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.25msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.26msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`type_id` FROM `catalog_product_entity` WHERE (sku IN ('AC01-TC-EN-02'))[]
0.38msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (product_id='1951') AND (stock_id=1) LIMIT 1[]
5.73msSELECT `main_table`.* FROM `inventory_source_item` AS `main_table` WHERE ((`sku` = 'AC01-TC-EN-02')) AND ((`source_code` IN('default'))) AND ((`status` = 1))[]
0.28msSELECT COUNT(*) FROM `inventory_source_item` AS `main_table` WHERE ((`sku` = 'AC01-TC-EN-02')) AND ((`source_code` IN('default'))) AND ((`status` = 1))[]
0.27msSELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = '1951')[]
0.26msSELECT SUM(quantity) AS `quantity` FROM `inventory_reservation` WHERE (sku = 'AC01-TC-EN-02') AND (stock_id = 1) LIMIT 1[]
0.33msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.23msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.24msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
7.87msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.27msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.27msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.24msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.27msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.25msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.27msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.22msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.25msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.23msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
6.79msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.37msSELECT `main_table`.* FROM `mst_seo_content_template` AS `main_table` WHERE (`is_active` = '1') AND (`rule_type` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.25msSELECT `main_table`.* FROM `mst_seo_content_rewrite` AS `main_table` WHERE (`is_active` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
7.29msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (`store_id` = '1') AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='1951') ORDER BY main_table.created_at DESC []
0.60msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='1951') ORDER BY main_table.created_at DESC []
0.25msSELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='1944')[]
6.11msSELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '1944')[]
3.89msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1944') AND (attribute_id IN ('71', '82', '85', '122', '152', '151', '331', '103', '86', '321', '154', '156', '332', '638', '84', '87', '107', '155', '158', '333', '326', '640', '109', '548', '159', '335', '88', '161', '162', '133', '119', '95', '163', '165', '320', '166', '168', '169', '601', '173', '171', '598', '170', '1124', '98', '175', '172', '97', '178', '628', '606', '174', '182', '629', '117', '189', '177', '112', '195', '180', '113', '201', '630', '114', '207', '181', '212', '183', '653', '213', '184', '1121', '185', '329', '216', '186', '298', '187', '465', '190', '626', '191', '227', '203', '129', '229', '205', '130', '233', '206', '299', '208', '240', '209', '327', '210', '211', '612', '215', '248', '217', '256', '218', '257', '309', '262', '219', '267', '223', '270', '224', '272', '225', '278', '226', '280', '230', '599', '232', '627', '235', '228', '236', '237', '238', '239', '231', '615', '242', '625', '241', '617', '246', '247', '250', '252', '254', '255', '260', '261', '302', '264', '265', '266', '268', '271', '275', '613', '303', '276', '281', '200', '196', '197', '198', '199', '222')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1944') AND (attribute_id IN ('76', '75', '79', '91', '120', '99', '80', '337')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1944') AND (attribute_id IN ('100', '310', '127', '153', '160', '622', '89', '164', '121', '585', '126', '314', '587', '188', '96', '202', '194', '102', '605', '214', '319', '150', '603', '328', '312', '330', '221', '340', '1122', '234', '285', '311', '315', '317', '338', '243', '123', '608', '128', '124', '614', '125', '316', '650', '318', '131', '637', '313', '1123', '245', '290', '304', '300', '253', '258', '273', '269', '277', '623')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1944') AND (attribute_id IN ('104', '77', '105', '78', '93', '94')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1944') AND (attribute_id IN ('1125', '83', '101', '1126', '72', '1127', '106', '1128', '73', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '284')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC []
0.55msSELECT `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 `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `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 `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1944') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC []
0.86msSELECT `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 `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `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 `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 `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 = '88') AND (main.disabled = 0) AND (entity.entity_id = '1944') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC []
5.47msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1944)[]
0.32msSELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1944)[]
0.33msSELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1944') ORDER BY `qty` ASC []
8.28msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-SRT01VIB01-APL-ML-00'))[]
0.28msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.21msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.22msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.24msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`type_id` FROM `catalog_product_entity` WHERE (sku IN ('V3P-SK-SRT01VIB01-APL-ML-00'))[]
0.33msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (product_id='1944') AND (stock_id=1) LIMIT 1[]
0.30msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.90msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.26msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
1.89msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.27msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.22msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
1.36msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.21msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
6.57msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.21msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.22msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.44msSELECT `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 `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '150') AND (`main_table`.`option_id` IN('751')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.71msSELECT `main_table`.* FROM `mst_seo_content_template` AS `main_table` WHERE (`is_active` = '1') AND (`rule_type` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
7.51msSELECT `main_table`.* FROM `mst_seo_content_rewrite` AS `main_table` WHERE (`is_active` = '1') AND (FIND_IN_SET(1, store_ids) OR store_ids = 0) ORDER BY sort_order DESC []
0.37msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (`store_id` = '1') AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='1944') ORDER BY main_table.created_at DESC []
0.51msSELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='1944') ORDER BY main_table.created_at DESC []
3.41msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer-block1') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.63msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '126')[]
0.32msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":126}
0.32msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer-block2') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.23msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '127')[]
0.24msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":127}
2.82msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer-block3') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.24msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '128')[]
0.27msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":128}
0.51msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer-block4') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.23msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '129')[]
0.23msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":129}
0.48msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer-block5') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.21msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '130')[]
1.97msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":130}
0.32msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='payment-footer') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.23msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '1')[]
0.23msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id){":block_id":1}
3.93msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
6.31msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbaccess/token')[]
0.36msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.24msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/aam_settings')[]
0.61msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
6.28msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.27msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.33msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.51msSELECT `main_table`.*, `store_settings`.`name` AS `group_store_name`, `store_settings`.`description` AS `group_store_description` FROM `amasty_gdprcookie_group_cookie` AS `main_table` LEFT JOIN `amasty_gdprcookie_cookie_group_description` AS `store_settings` ON main_table.id = store_settings.group_id AND store_settings.store_id = 1[]
0.49msSELECT `main_table`.*, `link`.`group_id`, COALESCE(groups.name, "None") AS `group`, `store_settings`.`description` AS `cookie_store_description` FROM `amasty_gdprcookie_cookie` AS `main_table` LEFT JOIN `amasty_gdprcookie_cookie_group_link` AS `link` ON main_table.id = link.cookie_id LEFT JOIN `amasty_gdprcookie_group_cookie` AS `groups` ON link.group_id = groups.id LEFT JOIN `amasty_gdprcookie_cookie_description` AS `store_settings` ON main_table.id = store_settings.cookie_id AND store_settings.store_id = 1[]
6.42msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
7.10msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
8.36msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.59msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('5713'))[]
0.37msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"5713"}
0.29msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('4054'))[]
0.29msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"4054"}
0.26msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('1953'))[]
0.29msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"1953"}
0.25msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('1951'))[]
0.28msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"1951"}
0.27msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('1944'))[]
0.30msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"1944"}
8.70msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
7.03msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
6.32msSELECT `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 `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `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 = 1 WHERE (e.entity_id IN (696, 282, 3, 9, 95, 152, 294, 734, 903, 976, 1043, 745, 22, 85, 747, 283, 697, 736, 758, 746, 25, 87, 290, 738, 866, 10, 48, 26, 90, 139, 748, 739, 909, 78, 30, 92, 230, 740, 911, 188, 33, 146, 742, 741, 115, 218, 36, 737, 41, 735, 128, 225, 895, 743, 744, 1028, 14, 304, 23, 58, 310, 27, 31, 37, 42, 79, 86, 262, 91, 93, 97, 103, 116, 140, 147, 172, 177, 189, 219, 226, 229, 233, 264, 284, 318, 702, 823, 838, 843, 850, 855, 841, 863, 749, 753, 761, 782, 787, 798, 818, 904, 867, 896, 910, 912, 1029, 11, 105, 24, 59, 28, 32, 38, 43, 52, 80, 138, 88, 194, 94, 98, 104, 143, 151, 155, 173, 267, 190, 220, 252, 265, 319, 732, 824, 839, 844, 851, 856, 842, 864, 750, 754, 764, 783, 788, 799, 819, 905, 868, 897, 917, 913, 1030, 106, 54, 60, 29, 145, 65, 39, 44, 53, 81, 270, 89, 195, 170, 731, 182, 646, 156, 174, 269, 274, 808, 266, 312, 825, 840, 845, 852, 857, 751, 755, 763, 784, 789, 800, 820, 906, 869, 918, 914, 107, 55, 61, 62, 163, 45, 75, 82, 221, 196, 99, 183, 313, 186, 175, 767, 600, 809, 321, 826, 846, 853, 858, 752, 756, 762, 785, 790, 801, 821, 907, 870, 919, 915, 108, 56, 63, 164, 66, 71, 83, 222, 198, 100, 184, 187, 224, 768, 810, 623, 815, 314, 827, 847, 854, 859, 865, 765, 786, 791, 802, 822, 908, 871, 920, 916, 109, 57, 150, 64, 165, 67, 72, 84, 223, 302, 101, 197, 134, 250, 249, 769, 811, 648, 816, 315, 828, 848, 860, 757, 766, 898, 803, 921, 110, 141, 158, 144, 192, 68, 73, 206, 191, 238, 247, 236, 135, 251, 261, 770, 812, 813, 817, 316, 829, 849, 861, 759, 804, 922, 180, 201, 159, 214, 69, 74, 234, 199, 271, 733, 272, 902, 814, 317, 830, 862, 760, 805, 923, 112, 208, 211, 160, 239, 70, 148, 301, 275, 248, 450, 831, 872, 806, 771, 185, 209, 254, 242, 136, 167, 306, 297, 792, 451, 832, 807, 775, 205, 210, 257, 278, 142, 168, 601, 793, 452, 833, 772, 300, 307, 273, 193, 298, 149, 216, 656, 776, 794, 598, 834, 773, 604, 200, 602, 166, 217, 777, 795, 599, 835, 774, 212, 207, 245, 778, 796, 655, 836, 213, 215, 246, 779, 797, 837, 243, 256, 780, 876, 240, 244, 260, 886, 877, 241, 255, 281, 258, 259, 605, 276, 279, 277, 280, 309, 308, 603)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.38msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('5713'))[]
0.28msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"5713"}
0.29msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('4054'))[]
0.27msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"4054"}
0.24msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('1953'))[]
0.41msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"1953"}
0.26msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('1951'))[]
0.25msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"1951"}
0.30msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('1944'))[]
0.26msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"1944"}
0.36msSELECT `main_table`.`name`, `link`.`group_id`, COALESCE(groups.name, "None") AS `group` FROM `amasty_gdprcookie_cookie` AS `main_table` LEFT JOIN `amasty_gdprcookie_cookie_group_link` AS `link` ON main_table.id = link.cookie_id LEFT JOIN `amasty_gdprcookie_group_cookie` AS `groups` ON link.group_id = groups.id WHERE (`groups`.`is_essential` = '1')[]
0.37msSELECT `main_table`.*, `tax_class_table`.* FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN')) ORDER BY main_table.customer_group_id ASC []
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.22msSELECT COUNT(*) FROM `customer_group` AS `main_table` LEFT JOIN `tax_class` AS `tax_class_table` ON main_table.tax_class_id = tax_class_table.class_id WHERE ((`customer_group_code` = 'NOT LOGGED IN'))[]
0.20msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
test
Code Profiler (Memory usage: real - 79691776, emalloc - 74577056)
Timer Id Time Avg Cnt Emalloc RealMem
cache_frontend_create 0.039729 0.019864 2 670,328 0
cache_load 0.001105 0.000368 3 1,900,056 2,097,152
magento 5.289723 5.289723 1 66,824,560 65,011,712
·  cache_frontend_create 0.000366 0.000183 2 12,136 0
·  cache_load 0.001298 0.000144 9 1,692,856 2,097,152
·  store.resolve 0.067952 0.067952 1 1,217,784 0
·  session_start 0.000401 0.000401 1 13,744 0
·  EVENT:model_load_before 0.001134 0.000378 3 473,336 0
·  ·  cache_load 0.000118 0.000059 2 81,496 0
·  routers_match 1.481230 1.481230 1 35,858,504 33,554,432
·  ·  cache_load 0.000708 0.000079 9 328,960 0
·  ·  EVENT:customer_session_init 0.031536 0.031536 1 653,112 0
·  ·  ·  OBSERVER:amasty_gdpr 0.030842 0.030842 1 578,544 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::_initEntityTypes 0.000316 0.000316 1 31,952 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000884 0.000884 1 18,688 0
·  ·  load_area:frontend.translate 0.001545 0.001545 1 26,144 0
·  ·  EVENT:controller_action_predispatch 0.059985 0.059985 1 1,015,760 2,097,152
·  ·  ·  OBSERVER:customer_visitor 0.002938 0.002938 1 81,808 0
·  ·  ·  OBSERVER:newrelicreporting_observer_report_concurrent_users 0.000557 0.000557 1 109,544 0
·  ·  ·  OBSERVER:persistent_synchronize 0.006768 0.006768 1 169,904 0
·  ·  ·  OBSERVER:persistent 0.001484 0.001484 1 95,384 0
·  ·  ·  OBSERVER:taxswitch 0.001894 0.001894 1 33,968 0
·  ·  ·  OBSERVER:mageworx_geolock_observer_locker 0.007716 0.007716 1 122,144 2,097,152
·  ·  ·  OBSERVER:m_seo_observer 0.036069 0.036069 1 367,808 0
·  ·  ·  ·  Mirasvit\Seo\Observer\CheckUrlObserver::redirectFromRedirectManagerUrlList 0.016683 0.016683 1 47,392 0
·  ·  CONTROLLER_ACTION:catalog_category_view 0.903606 0.903606 1 23,449,928 23,068,672
·  ·  ·  action_body 0.903593 0.903593 1 23,449,056 23,068,672
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000239 0.000007 36 2,856 0
·  ·  ·  ·  cache_load 0.000231 0.000077 3 53,280 0
·  ·  ·  ·  EVENT:magento_catalog_api_data_categoryinterface_load_after 0.003779 0.003779 1 34,776 0
·  ·  ·  ·  ·  OBSERVER:legacy_category_load_after 0.003758 0.003758 1 33,144 0
·  ·  ·  ·  ·  ·  after_load 0.003466 0.003466 1 29,416 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.001917 0.000174 11 18,928 0
·  ·  ·  ·  ·  load_by_code 0.001648 0.001648 1 10,600 0
·  ·  ·  ·  EAV:load_collection 0.004098 0.004098 1 29,840 0
·  ·  ·  ·  ·  load_entities 0.001693 0.001693 1 16,360 0
·  ·  ·  ·  ·  load_attributes 0.002251 0.002251 1 5,640 0
·  ·  ·  ·  LAYOUT 0.788360 0.262787 3 20,887,536 20,971,520
·  ·  ·  ·  ·  EVENT:layout_load_before 0.002308 0.002308 1 28,440 0
·  ·  ·  ·  ·  ·  OBSERVER:mstCoreAddPreprocessedStyles 0.001572 0.001572 1 10,848 0
·  ·  ·  ·  ·  layout_load 0.040276 0.040276 1 168,424 0
·  ·  ·  ·  ·  ·  layout_package_update:default 0.025959 0.025959 1 126,512 0
·  ·  ·  ·  ·  ·  ·  cache_load 0.000363 0.000363 1 655,408 0
·  ·  ·  ·  ·  ·  ·  layout_db_update: default_head_blocks 0.001453 0.001453 1 10,152 0
·  ·  ·  ·  ·  ·  layout_package_update:catalog_category_view 0.002626 0.002626 1 16,560 0
·  ·  ·  ·  ·  ·  layout_package_update:catalog_category_view_type_layered 0.001734 0.001734 1 12,480 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:mana_layered_navigation 0.001010 0.001010 1 8,640 0
·  ·  ·  ·  ·  ·  cache_save 0.001047 0.001047 1 136 0
·  ·  ·  ·  ·  layout_generate_xml 0.084619 0.084619 1 781,832 0
·  ·  ·  ·  ·  ·  cache_load 0.000110 0.000110 1 225,320 0
·  ·  ·  ·  ·  layout_generate_blocks 0.539129 0.539129 1 14,715,504 14,680,064
·  ·  ·  ·  ·  ·  Magento\Framework\View\Layout::Magento\Framework\View\Layout::generateElements 0.538965 0.538965 1 15,338,048 14,680,064
·  ·  ·  ·  ·  ·  ·  build_structure 0.016130 0.016130 1 686,248 0
·  ·  ·  ·  ·  ·  ·  generate_elements 0.521118 0.521118 1 14,645,560 14,680,064
·  ·  ·  ·  ·  ·  ·  ·  cache_load 0.000408 0.000068 6 17,944 0
·  ·  ·  ·  ·  ·  ·  ·  EVENT:core_layout_block_create_after 0.000644 0.000004 158 -48,200 0
·  ·  ·  ·  ·  ·  ·  ·  Magento\Framework\View\Layout::Magento\Framework\View\Layout::generateElements 0.003448 0.003448 1 224,040 0
·  ·  ·  ·  ·  ·  ·  ·  ·  cache_load 0.000062 0.000062 1 12,584 0
·  ·  ·  ·  ·  ·  ·  ·  ·  generate_elements 0.003139 0.003139 1 135,432 0
·  ·  ·  ·  ·  ·  ·  ·  EAV:load_collection 0.002471 0.002471 1 19,816 0
·  ·  ·  ·  ·  ·  ·  ·  ·  load_entities 0.001478 0.001478 1 11,816 0
·  ·  ·  ·  ·  ·  ·  ·  REWRITE: Magento\Catalog\Model\Category::getUrl 0.003455 0.001728 2 102,296 0
·  ·  ·  ·  ·  EVENT:layout_generate_blocks_after 0.121905 0.121905 1 5,192,584 6,291,456
·  ·  ·  ·  ·  ·  OBSERVER:remove_related_block 0.001282 0.001282 1 20,512 2,097,152
·  ·  ·  ·  ·  ·  OBSERVER:executeAfterLayoutLoadedCallbacks 0.116173 0.116173 1 5,042,408 4,194,304
·  ·  ·  ·  ·  ·  ·  cache_load 0.000383 0.000096 4 275,800 0
·  ·  ·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.002719 0.000009 292 1,328 0
·  ·  ·  ·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000890 0.000003 292 14,712 0
·  ·  ·  ·  ·  ·  OBSERVER:temando_replace_order_info_template 0.001003 0.001003 1 8,760 0
·  ·  ·  ·  ·  ·  OBSERVER:temando_replace_shipment_info_template 0.002360 0.002360 1 110,512 0
·  ·  ·  ·  postdispatch 0.023332 0.023332 1 431,264 0
·  ·  ·  ·  ·  EVENT:controller_action_postdispatch 0.023256 0.023256 1 428,816 0
·  ·  ·  ·  ·  ·  OBSERVER:m_seo_observer_canonical 0.016005 0.016005 1 364,616 0
·  ·  ·  ·  ·  ·  OBSERVER:m_seo_observer_alternate 0.006374 0.006374 1 54,784 0
·  LAYOUT 3.442232 3.442232 1 24,270,976 27,262,976
·  ·  layout_render 3.442218 3.442218 1 24,270,560 27,262,976
·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000548 0.000007 78 -22,200 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-theme/view/frontend/templates/page/js/require_js.phtml 0.003277 0.003277 1 110,256 0
·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000617 0.000008 78 -22,216 0
·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000140 0.000010 14 1,160 0
·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.000378 0.000008 45 1,024 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000070 0.000005 13 1,160 0
·  ·  ·  EAV:load_collection 0.434014 0.054252 8 8,253,048 2,097,152
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.000881 0.000059 15 5,064 0
·  ·  ·  ·  load_entities 0.338685 0.042336 8 8,084,928 0
·  ·  ·  ·  ·  cache_load 0.000982 0.000140 7 783,800 0
·  ·  ·  ·  load_attributes 0.083746 0.010468 8 147,600 2,097,152
·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.001350 0.000009 151 1,104 0
·  ·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000443 0.000003 151 7,816 0
·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000445 0.000003 144 7,448 0
·  ·  ·  ·  set_orig_data 0.005591 0.000699 8 472 0
·  ·  ·  ·  after_load 0.002849 0.000356 8 16,208 0
·  ·  ·  cache_load 0.001035 0.000065 16 336,144 0
·  ·  ·  EVENT:tax_rate_data_fetch 0.000073 0.000007 10 -2,328 0
·  ·  ·  EVENT:core_collection_abstract_load_before 0.000321 0.000010 31 -8,688 0
·  ·  ·  EVENT:core_collection_abstract_load_after 0.000342 0.000011 31 -8,688 0
·  ·  ·  EVENT:catalog_block_product_list_collection 0.001307 0.001307 1 18,984 0
·  ·  ·  ·  OBSERVER:review 0.001287 0.001287 1 17,448 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-theme/view/frontend/templates/html/container.phtml 0.695067 0.695067 1 8,166,832 8,388,608
·  ·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000125 0.000006 20 -5,288 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000147 0.000007 20 2,584 0
·  ·  ·  ·  EVENT:core_layout_render_element 0.027265 0.001363 20 442,832 0
·  ·  ·  ·  ·  OBSERVER:pagecache 0.005778 0.000289 20 6,376 0
·  ·  ·  ·  ·  OBSERVER:amasty_gdprcookie_layout_render 0.019452 0.000973 20 418,536 0
·  ·  ·  ·  ·  OBSERVER:litemage_layout_render 0.000683 0.000034 20 5,888 0
·  ·  ·  ·  ·  OBSERVER:weltpixel_googletagmanager 0.000603 0.000030 20 4,384 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Facebook/BusinessExtension/view/frontend/templates/pixel/add_to_cart.phtml 0.137232 0.137232 1 6,101,496 6,291,456
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Magmodules/RichSnippets/view/frontend/templates/json.phtml 0.003374 0.001125 3 20,624 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Facebook/BusinessExtension/view/frontend/templates/pixel/head.phtml 0.004458 0.004458 1 16,728 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Anowave/Ec/view/frontend/templates/purchase.phtml 0.103625 0.103625 1 1,378,768 2,097,152
·  ·  ·  ·  ·  EVENT:core_layout_render_element 0.001502 0.000300 5 7,024 0
·  ·  ·  ·  ·  ·  OBSERVER:pagecache 0.001100 0.000220 5 1,000 0
·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Anowave/Ec/view/frontend/templates/impression.phtml 0.097714 0.097714 1 1,351,496 0
·  ·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.001376 0.000072 19 211,288 0
·  ·  ·  ·  ·  ·  ·  cache_load 0.000100 0.000100 1 61,880 0
·  ·  ·  ·  ·  ·  EAV:load_collection 0.001615 0.001615 1 21,504 0
·  ·  ·  ·  ·  ·  ·  load_entities 0.000478 0.000478 1 11,328 0
·  ·  ·  ·  ·  ·  ·  load_attributes 0.001017 0.001017 1 3,960 0
·  ·  ·  ·  ·  ·  EVENT:core_collection_abstract_load_before 0.000178 0.000009 20 -5,032 0
·  ·  ·  ·  ·  ·  EVENT:core_collection_abstract_load_after 0.000214 0.000011 20 -5,032 0
·  ·  ·  ·  ·  ·  EVENT:model_load_before 0.000207 0.000007 30 -8,952 0
·  ·  ·  ·  ·  ·  EVENT:core_abstract_load_before 0.000078 0.000005 15 -3,912 0
·  ·  ·  ·  ·  ·  EVENT:model_load_after 0.000238 0.000008 30 -8,952 0
·  ·  ·  ·  ·  ·  EVENT:core_abstract_load_after 0.000077 0.000005 15 -3,912 0
·  ·  ·  ·  ·  ·  EVENT:customer_group_load_before 0.000079 0.000005 15 -3,792 0
·  ·  ·  ·  ·  ·  EVENT:customer_group_load_after 0.000075 0.000005 15 -3,912 0
·  ·  ·  ·  ·  ·  EVENT:catalog_product_get_final_price 0.003710 0.000742 5 13,328 0
·  ·  ·  ·  ·  ·  ·  OBSERVER:catalogrule 0.003610 0.000722 5 9,072 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/mailchimp/mc-magento2/view/frontend/templates/mailchimpjs.phtml 0.406230 0.406230 1 117,568 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Magento_Theme/templates/html/config.phtml 0.001816 0.001816 1 19,168 0
·  ·  ·  EVENT:core_layout_render_element 0.045288 0.000444 102 157,080 0
·  ·  ·  ·  OBSERVER:pagecache 0.034965 0.000343 102 95,496 0
·  ·  ·  ·  OBSERVER:amasty_gdprcookie_layout_render 0.000742 0.000007 102 8,696 0
·  ·  ·  ·  OBSERVER:litemage_layout_render 0.001603 0.000016 102 6,216 0
·  ·  ·  ·  OBSERVER:weltpixel_googletagmanager 0.004265 0.000042 102 7,032 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-catalog/view/base/templates/js/components.phtml 0.004968 0.004968 1 21,776 0
·  ·  ·  ·  EVENT:core_layout_render_element 0.001687 0.000241 7 7,680 0
·  ·  ·  ·  ·  OBSERVER:pagecache 0.001255 0.000179 7 968 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/dotmailer/dotmailer-magento2-extension/view/frontend/templates/email/tracking_code.phtml 0.077461 0.077461 1 670,000 0
·  ·  ·  ·  cache_load 0.000166 0.000166 1 225,360 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Magento_Theme/templates/html/header.phtml 0.492978 0.492978 1 3,069,648 6,291,456
·  ·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000130 0.000007 18 -4,696 0
·  ·  ·  ·  cache_load 0.000432 0.000072 6 19,720 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000129 0.000007 18 -4,984 0
·  ·  ·  ·  EAV:load_collection 0.093740 0.031247 3 2,796,016 0
·  ·  ·  ·  ·  load_entities 0.067036 0.022345 3 2,752,248 0
·  ·  ·  ·  ·  ·  cache_load 0.000316 0.000158 2 261,880 2,097,152
·  ·  ·  ·  ·  load_attributes 0.024978 0.008326 3 44,456 0
·  ·  ·  ·  ·  set_orig_data 0.001237 0.000412 3 696 0
·  ·  ·  ·  EVENT:core_layout_render_element 0.004231 0.000302 14 12,104 0
·  ·  ·  ·  ·  OBSERVER:pagecache 0.003238 0.000231 14 1,304 0
·  ·  ·  ·  ·  OBSERVER:amasty_gdprcookie_layout_render 0.000087 0.000006 14 1,816 0
·  ·  ·  ·  ·  OBSERVER:litemage_layout_render 0.000192 0.000014 14 2,312 0
·  ·  ·  ·  ·  OBSERVER:weltpixel_googletagmanager 0.000261 0.000019 14 1,592 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Anowave/TaxSwitch/view/frontend/templates/switcher.phtml 0.003430 0.003430 1 10,408 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Checkout/templates/cart/minicart.phtml 0.011455 0.011455 1 177,144 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Search/templates/form.mini.phtml 0.002724 0.002724 1 25,320 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Theme/templates/html/nav-mobile.phtml 0.157922 0.157922 1 692,712 0
·  ·  ·  ·  ·  EAV:load_collection 0.043683 0.043683 1 1,404,056 0
·  ·  ·  ·  ·  ·  load_entities 0.033355 0.033355 1 1,376,888 0
·  ·  ·  ·  ·  ·  ·  cache_load 0.000132 0.000132 1 131,400 0
·  ·  ·  ·  ·  ·  load_attributes 0.009538 0.009538 1 23,688 0
·  ·  ·  ·  ·  REWRITE: Magento\Catalog\Model\Category::getUrl 0.053768 0.000125 429 339,568 0
·  ·  ·  ·  ·  EVENT:page_block_html_topmenu_gethtml_before 0.026553 0.026553 1 61,184 0
·  ·  ·  ·  ·  ·  OBSERVER:magefan_blog_topmenu_observer 0.026529 0.026529 1 59,312 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.000063 0.000005 12 1,328 0
·  ·  ·  ·  cache_remove 0.002571 0.002571 1 2,832 2,097,152
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Theme/templates/html/title.phtml 0.001178 0.001178 1 8,624 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-customer/view/frontend/templates/account/authentication-popup.phtml 0.003397 0.003397 1 102,552 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-catalog/view/frontend/templates/category/products.phtml 0.341716 0.341716 1 3,322,672 2,097,152
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Catalog/templates/product/list.phtml 0.332731 0.332731 1 3,178,144 2,097,152
·  ·  ·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000366 0.000008 48 -13,384 0
·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Magento_Catalog/templates/product/list/toolbar.phtml 0.003005 0.003005 1 14,400 0
·  ·  ·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000306 0.000006 48 -14,152 0
·  ·  ·  ·  ·  EVENT:core_layout_render_element 0.001181 0.000295 4 6,840 0
·  ·  ·  ·  ·  Mirasvit\Seo\Plugin\Frontend\Catalog\Model\Product\FriendlyImageUrlPlugin::afterGetData 0.091416 0.018283 5 1,442,448 0
·  ·  ·  ·  ·  ·  Mirasvit\Seo\Service\FriendlyImageUrlService::getFriendlyImageAlt 0.091304 0.018261 5 1,441,224 0
·  ·  ·  ·  ·  ·  ·  cache_load 0.000263 0.000131 2 336,136 0
·  ·  ·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000698 0.000004 160 8,696 0
·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/WeltPixel/GoogleTagManager/view/frontend/templates/product_click.phtml 0.001409 0.000094 15 16,192 0
·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Magento_Catalog/templates/product/image_with_borders.phtml 0.001836 0.000367 5 13,672 0
·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.000128 0.000013 10 1,648 0
·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-catalog/view/base/templates/product/price/final_price.phtml 0.128452 0.025690 5 695,336 0
·  ·  ·  ·  ·  ·  EVENT:core_collection_abstract_load_before 0.000261 0.000009 30 -7,864 0
·  ·  ·  ·  ·  ·  EVENT:core_collection_abstract_load_after 0.000246 0.000008 30 -7,864 0
·  ·  ·  ·  ·  ·  EVENT:model_load_before 0.000502 0.000008 60 -18,664 0
·  ·  ·  ·  ·  ·  EVENT:core_abstract_load_before 0.000155 0.000005 30 -8,584 0
·  ·  ·  ·  ·  ·  EVENT:model_load_after 0.000497 0.000008 60 -11,112 0
·  ·  ·  ·  ·  ·  EVENT:core_abstract_load_after 0.000159 0.000005 30 -8,584 0
·  ·  ·  ·  ·  ·  EVENT:customer_group_load_before 0.000164 0.000005 30 -8,344 0
·  ·  ·  ·  ·  ·  EVENT:customer_group_load_after 0.000156 0.000005 30 -8,584 0
·  ·  ·  ·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000064 0.000006 10 -1,944 0
·  ·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-tax/view/base/templates/pricing/adjustment.phtml 0.012525 0.002505 5 16,736 0
·  ·  ·  ·  ·  ·  ·  EVENT:model_load_before 0.000072 0.000007 10 -2,136 0
·  ·  ·  ·  ·  ·  ·  EVENT:model_load_after 0.000084 0.000008 10 -2,136 0
·  ·  ·  ·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000075 0.000008 10 -2,104 0
·  ·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Catalog/templates/product/price/amount/default.phtml 0.025328 0.005066 5 253,248 0
·  ·  ·  ·  ·  ·  ·  locale/currency 0.016221 0.003244 5 246,064 0
·  ·  ·  ·  ·  ·  ·  ·  EVENT:currency_display_options_forming 0.003892 0.003892 1 137,432 0
·  ·  ·  ·  ·  ·  ·  ·  ·  OBSERVER:magento_currencysymbol_currency_display_options 0.003865 0.003865 1 135,256 0
·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Astan/Template/view/frontend/templates/attributes.phtml 0.025651 0.005130 5 30,568 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Manadev/LayeredNavigationPositions/view/frontend/templates/horizontal/menu.phtml 0.011635 0.011635 1 104,776 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Manadev/LayeredNavigationSliders/view/frontend/templates/filter/slider.phtml 0.003481 0.003481 1 71,184 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Manadev/LayeredNavigationCheckboxes/view/frontend/templates/filter/checkboxes.phtml 0.005037 0.001679 3 14,032 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Manadev_LayeredNavigationMobile/templates/mobile.phtml 0.006890 0.006890 1 95,400 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Manadev/LayeredNavigationCheckboxes/view/frontend/templates/filter/checkboxes.phtml 0.003302 0.001101 3 7,088 0
·  ·  ·  Mirasvit\Seo\Plugin\Frontend\Catalog\Model\Product\FriendlyImageUrlPlugin::beforeSetData#updateGallery 0.000217 0.000043 5 20,648 0
·  ·  ·  ·  Mirasvit\Seo\Plugin\Frontend\Catalog\Model\Product\FriendlyImageUrlPlugin::updateGallery#getFriendlyImageAlt 0.000113 0.000010 11 19,552 0
·  ·  ·  EVENT:magento_catalog_api_data_productinterface_load_after 0.129757 0.025951 5 777,976 0
·  ·  ·  ·  OBSERVER:legacy_model_load 0.129569 0.025914 5 773,976 0
·  ·  ·  ·  ·  after_load 0.029080 0.005816 5 26,168 0
·  ·  ·  ·  ·  EVENT:catalog_product_load_after 0.099852 0.019970 5 763,864 0
·  ·  ·  ·  ·  ·  OBSERVER:inventory 0.099727 0.019945 5 759,928 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-catalog/view/base/templates/product/price/final_price.phtml 0.107066 0.021413 5 90,304 0
·  ·  ·  ·  EVENT:core_collection_abstract_load_before 0.000164 0.000011 15 -3,808 0
·  ·  ·  ·  EVENT:core_collection_abstract_load_after 0.000167 0.000011 15 -3,808 0
·  ·  ·  ·  EVENT:model_load_before 0.000273 0.000009 30 -9,240 0
·  ·  ·  ·  EVENT:core_abstract_load_before 0.000101 0.000007 15 -4,168 0
·  ·  ·  ·  EVENT:model_load_after 0.000317 0.000011 30 -9,240 0
·  ·  ·  ·  EVENT:core_abstract_load_after 0.000102 0.000007 15 -4,168 0
·  ·  ·  ·  EVENT:customer_group_load_before 0.000108 0.000007 15 -4,048 0
·  ·  ·  ·  EVENT:customer_group_load_after 0.000107 0.000007 15 -4,168 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000088 0.000009 10 -2,328 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-tax/view/base/templates/pricing/adjustment.phtml 0.023662 0.004732 5 12,720 0
·  ·  ·  ·  ·  EVENT:model_load_before 0.000115 0.000012 10 -2,520 0
·  ·  ·  ·  ·  EVENT:model_load_after 0.000106 0.000011 10 -2,520 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000090 0.000009 10 -2,488 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Catalog/templates/product/price/amount/default.phtml 0.004475 0.000895 5 1,704 0
·  ·  ·  EVENT:review_review_collection_load_before 0.000103 0.000010 10 -2,072 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Manadev_LayeredNavigation/templates/navigation.phtml 0.017404 0.017404 1 19,304 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Manadev/LayeredNavigationSliders/view/frontend/templates/filter/slider.phtml 0.001180 0.001180 1 5,168 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Manadev/LayeredNavigationCheckboxes/view/frontend/templates/filter/checkboxes.phtml 0.005110 0.001703 3 7,088 0
·  ·  ·  cache_save 0.001266 0.000317 4 -1,080 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Theme/templates/html/footer.phtml 0.031861 0.031861 1 36,936 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Theme/templates/html/social.phtml 0.002350 0.002350 1 2,256 0
·  ·  ·  cache_remove 0.008791 0.004395 2 -696 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Facebook/BusinessExtension/view/frontend/templates/pixel/view_category.phtml 0.225874 0.225874 1 509,024 0
·  ·  ·  ·  EVENT:facebook_businessextension_ssapi_view_category 0.212686 0.212686 1 503,528 0
·  ·  ·  ·  ·  OBSERVER:facebook_businessextension_ssapi_view_category_after 0.212656 0.212656 1 501,912 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-catalog/view/frontend/templates/frontend_storage_manager.phtml 0.001164 0.001164 1 3,736 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Anowave/TaxSwitch/view/frontend/templates/footer.phtml 0.008348 0.008348 1 1,104 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Sm_CartQuickPro/templates/quickview.phtml 0.002947 0.002947 1 1,432 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Sm_CartQuickPro/templates/default.phtml 0.003099 0.003099 1 7,728 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/amasty/gdpr-cookie/view/frontend/templates/cookiebar.phtml 0.007071 0.007071 1 80,328 0