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

EV Charging Components

We can't find products matching the selection.
Time
[Total Time: 0.21028876304626 secs]
SQL [Total: 168 queries]Query Params
12.78msconnect[]
0.13msSET NAMES utf8[]
1.51msSHOW TABLE STATUS LIKE 'store_website'[]
0.22msSELECT `store_website`.* FROM `store_website`[]
1.33msSHOW TABLE STATUS LIKE 'store_group'[]
0.20msSELECT `store_group`.* FROM `store_group`[]
1.27msSHOW TABLE STATUS LIKE 'store'[]
0.20msSELECT `store`.* FROM `store`[]
0.31msSELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')[]
0.39msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.31msSELECT `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.29msSELECT `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)[]
0.70msSELECT `mana_url_key`.* FROM `mana_url_key` WHERE (`store_id` = '1') AND (url_key IN ('outdoor', 'outdoor-electrics', 'outdoor-electrics/electric', 'outdoor-electrics/electric-vehicle', 'outdoor-electrics/electric-vehicle-charging', 'outdoor-electrics/electric-vehicle-charging/ev', 'outdoor-electrics/electric-vehicle-charging/ev-charging', 'outdoor-electrics/electric-vehicle-charging/ev-charging-components', 'electrics', 'electrics/electric', 'electrics/electric-vehicle', 'electrics/electric-vehicle-charging', 'electrics/electric-vehicle-charging/ev', 'electrics/electric-vehicle-charging/ev-charging', 'electrics/electric-vehicle-charging/ev-charging-components', 'electric', 'electric-vehicle', 'electric-vehicle-charging', 'electric-vehicle-charging/ev', 'electric-vehicle-charging/ev-charging', 'electric-vehicle-charging/ev-charging-components', 'vehicle', 'vehicle-charging', 'vehicle-charging/ev', 'vehicle-charging/ev-charging', 'vehicle-charging/ev-charging-components', 'charging', 'charging/ev', 'charging/ev-charging', 'charging/ev-charging-components', 'ev', 'ev-charging', 'ev-charging-components', 'charging-components', 'components')) AND (status IN ('active', 'redirected'))[]
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.21msSELECT `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.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.22msSELECT `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.41msSELECT `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.32msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('outdoor-electrics/electric-vehicle-charging/ev-charging-components', 'outdoor-electrics/electric-vehicle-charging/ev-charging-components/')) AND (`store_id` IN ('1'))[]
0.30msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/806', 'catalog/category/view/id/806/')) AND (`store_id` IN ('1'))[]
0.30msSELECT `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/806', 'catalog/category/view/id/806/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)[]
8.14msSELECT `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/outdoor-electrics/electric-vehicle-charging/ev-charging-components' OR url_from = 'outdoor-electrics/electric-vehicle-charging/ev-charging-components' OR url_from = '/outdoor-electrics/electric-vehicle-charging/ev-charging-components' OR 'outdoor-electrics/electric-vehicle-charging/ev-charging-components' LIKE CONCAT(REPLACE(url_from, '*', '%')) OR '/outdoor-electrics/electric-vehicle-charging/ev-charging-components' LIKE CONCAT(REPLACE(url_from, '*', '%')) OR 'https://stage.electrical-showroom.co.uk/outdoor-electrics/electric-vehicle-charging/ev-charging-components' LIKE CONCAT(REPLACE(url_from, '*', '%')) OR 'outdoor-electrics/electric-vehicle-charging/ev-charging-components' LIKE CONCAT(REPLACE(url_from, '[redirect_chain]', '%')) OR '/outdoor-electrics/electric-vehicle-charging/ev-charging-components' LIKE CONCAT(REPLACE(url_from, '[redirect_chain]', '%')) OR 'https://stage.electrical-showroom.co.uk/outdoor-electrics/electric-vehicle-charging/ev-charging-components' LIKE CONCAT(REPLACE(url_from, '[redirect_chain]', '%'))) ORDER BY LENGTH(url_from) DESC []
0.24msSELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =806)[]
0.35msSELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 806)[]
5.31msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '806') 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 = '806') 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 = '806') 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 = '806') 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 = '806') AND (attribute_id IN ('70')) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC []
0.94msSELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '806') LIMIT 1[]
2.07msSELECT `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"}
3.59msSELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id){":entity_type_id":"3"}
0.31msSELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id){":attribute_id":"649"}
0.63msSELECT `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('806', '747', '152', '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.27msSELECT `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 (806, 747, 152, 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 (806, 747, 152, 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 (806, 747, 152, 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 (806, 747, 152, 2)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
3.34msSELECT 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\/152\/747\/806\/%"}
0.35msSELECT 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\/152\/747\/806\/%"}
0.91msSELECT `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 []
7.94msSELECT `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.56msSELECT `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('152', '747', '806')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')[]
0.46msSELECT `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 (152, 747, 806)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.35msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('152')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))[]
0.60msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('747')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))[]
1.13msSELECT `main_table`.* FROM `mana_filter` AS `main_table` WHERE (`main_table`.`store_id` = '1') AND (`is_enabled_in_categories` = '1') ORDER BY `position` ASC []
3.62msSELECT `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.35msSELECT `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.24msSELECT `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.32msSELECT `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.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.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')[]
3.05msCREATE TEMPORARY TABLE `temp_8906ad5f266645aba727d938f4f98d349997cb83` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity_id' , UNIQUE `TEMP_8906AD5F266645ABA727D938F4F98D349997CB83_ENTITY_ID` (`entity_id`) ) COMMENT='temp_8906ad5f266645aba727d938f4f98d349997cb83' ENGINE=innodb charset=utf8 COLLATE=utf8_general_ci[]
0.38msINSERT IGNORE INTO `temp_8906ad5f266645aba727d938f4f98d349997cb83` 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=806 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.47msSELECT `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\/152\/747\/806\/%",":c_level":5}
0.28msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='1')[]
3.40msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.26msSELECT `c`.`class_id` FROM `tax_class` AS `c` WHERE (`c`.`class_type` = 'PRODUCT')[]
2.41msSELECT `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 []
7.18msSELECT `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.48msSELECT `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.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 ('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.41msSELECT `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.24msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)[]
0.20msSELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')[]
0.19msSELECT `c`.`class_id` FROM `tax_class` AS `c` WHERE (`c`.`class_type` = 'PRODUCT')[]
0.42msSELECT `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.39msSELECT `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.40msSELECT `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.41msSELECT `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 []
3.89msSELECT `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.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.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.21msSELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0')[]
0.29msSELECT 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_8906ad5f266645aba727d938f4f98d349997cb83` 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.33msSELECT 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_8906ad5f266645aba727d938f4f98d349997cb83` 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[]
3.72msCREATE TEMPORARY TABLE `temp_40534d536a2e702deaef9903d8758e9734c2694b` ( `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_40534D536A2E702DEAEF9903D8758E9734C2694B_VALUE` (`value`), INDEX `TEMP_40534D536A2E702DEAEF9903D8758E9734C2694B_ATTRIBUTE_ID` (`attribute_id`) ) COMMENT='temp_40534d536a2e702deaef9903d8758e9734c2694b' ENGINE=innodb charset=utf8 COLLATE=utf8_general_ci[]
0.76msINSERT IGNORE INTO `temp_40534d536a2e702deaef9903d8758e9734c2694b` (`count`, `attribute_id`, `value`) SELECT COUNT(DISTINCT `eav`.`entity_id`) AS `count`, `eav`.`attribute_id` AS `attribute_id`, `eav`.`value` AS `value` FROM `temp_8906ad5f266645aba727d938f4f98d349997cb83` 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.44msSELECT `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_40534d536a2e702deaef9903d8758e9734c2694b` 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[]
5.92msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
2.62msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.23msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.32msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id){":entity_type_id":"4"}
1.43msSELECT 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=806 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_8906ad5f266645aba727d938f4f98d349997cb83` 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.59msSELECT `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=806 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_8906ad5f266645aba727d938f4f98d349997cb83` 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.43msSELECT `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 (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)[]
0.39msSELECT `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` = '806')[]
7.22msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.38msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.21msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.28msSELECT `directory_country`.* FROM `directory_country` WHERE (`directory_country`.`iso2_code`='GB')[]
0.24msSELECT `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.30msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.59msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/aam_settings')[]
0.51msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.97msSELECT `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 (152, 747, 806)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.61msSELECT `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.30msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '131')[]
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":131}
0.53msSELECT `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.24msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '125')[]
0.28msSELECT `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}
0.69msSELECT `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.40msSELECT `main_table`.* FROM `quote_address` AS `main_table` WHERE (`quote_id` IS NULL)[]
0.39msSELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`parent_id` = '-1')[]
0.57msSELECT `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.25msSELECT `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.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.26msSELECT `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.30msSELECT `captcha_log`.`count` FROM `captcha_log` WHERE (type = 1) AND (value = '44.192.254.246')[]
0.27msSELECT `captcha_log`.`count` FROM `captcha_log` WHERE (type = 1) AND (value = '44.192.254.246')[]
0.38msSELECT `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.27msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '10')[]
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":10}
7.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 (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))[]
1.79msSELECT `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 []
5.98msSELECT `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.72msSELECT `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.64msSELECT `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.28msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '5')[]
0.30msSELECT `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.62msSELECT `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 []
0.61msSELECT `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.30msSELECT `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.20msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '16')[]
0.22msSELECT `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.57msSELECT `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.23msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '126')[]
0.31msSELECT `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.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`='footer-block2') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1[]
0.27msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '127')[]
0.29msSELECT `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}
0.55msSELECT `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.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":128}
0.52msSELECT `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.24msSELECT `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.50msSELECT `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.26msSELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '130')[]
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":130}
0.31msSELECT `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.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":1}
0.28msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.24msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbaccess/token')[]
0.31msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.32msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/aam_settings')[]
0.23msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.26msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.22msSELECT `facebook_business_extension_config`.* FROM `facebook_business_extension_config` WHERE (`facebook_business_extension_config`.`config_key`='fbpixel/id')[]
0.36msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.35msSELECT `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.46msSELECT `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.72msSELECT `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.01msSELECT `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.39msSELECT `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.25msSELECT `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))[]
5.96msSELECT `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.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))[]
0.40msSELECT `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.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.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')[]
test
Code Profiler (Memory usage: real - 2097152, emalloc - 52403168)
Timer Id Time Avg Cnt Emalloc RealMem
cache_frontend_create 0.003208 0.001604 2 396,792 0
cache_load 0.000955 0.000318 3 1,900,056 0
magento 3.101073 3.101073 1 45,729,280 0
·  cache_frontend_create 0.000280 0.000140 2 12,008 0
·  cache_load 0.001384 0.000138 10 1,692,608 0
·  store.resolve 0.024680 0.024680 1 837,608 0
·  session_start 0.000530 0.000530 1 13,584 0
·  EVENT:model_load_before 0.001719 0.000573 3 473,336 0
·  ·  cache_load 0.000167 0.000084 2 81,496 0
·  routers_match 0.673680 0.673680 1 28,031,768 0
·  ·  cache_load 0.000907 0.000101 9 328,960 0
·  ·  EVENT:customer_session_init 0.008820 0.008820 1 446,152 0
·  ·  ·  OBSERVER:amasty_gdpr 0.008712 0.008712 1 437,520 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::_initEntityTypes 0.000308 0.000308 1 31,824 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000190 0.000190 1 83,936 0
·  ·  load_area:frontend.translate 0.000572 0.000572 1 25,088 0
·  ·  EVENT:controller_action_predispatch 0.016390 0.016390 1 807,072 0
·  ·  ·  OBSERVER:customer_visitor 0.000736 0.000736 1 146,160 0
·  ·  ·  OBSERVER:newrelicreporting_observer_report_concurrent_users 0.000224 0.000224 1 43,688 0
·  ·  ·  OBSERVER:persistent_synchronize 0.001348 0.001348 1 167,312 0
·  ·  ·  OBSERVER:persistent 0.000324 0.000324 1 29,400 0
·  ·  ·  OBSERVER:taxswitch 0.000637 0.000637 1 33,296 0
·  ·  ·  OBSERVER:mageworx_geolock_observer_locker 0.001294 0.001294 1 120,672 0
·  ·  ·  OBSERVER:m_seo_observer 0.010870 0.010870 1 232,496 0
·  ·  ·  ·  Mirasvit\Seo\Observer\CheckUrlObserver::redirectFromRedirectManagerUrlList 0.009068 0.009068 1 46,912 0
·  ·  CONTROLLER_ACTION:catalog_category_view 0.485780 0.485780 1 18,652,744 0
·  ·  ·  action_body 0.485765 0.485765 1 18,651,872 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000258 0.000007 36 2,856 0
·  ·  ·  ·  cache_load 0.000280 0.000093 3 53,280 0
·  ·  ·  ·  EVENT:magento_catalog_api_data_categoryinterface_load_after 0.002350 0.002350 1 99,128 0
·  ·  ·  ·  ·  OBSERVER:legacy_category_load_after 0.002324 0.002324 1 97,496 0
·  ·  ·  ·  ·  ·  after_load 0.002132 0.002132 1 93,928 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.007413 0.000674 11 18,928 0
·  ·  ·  ·  ·  load_by_code 0.007032 0.007032 1 10,600 0
·  ·  ·  ·  EAV:load_collection 0.004845 0.004845 1 29,840 0
·  ·  ·  ·  ·  load_entities 0.001947 0.001947 1 16,360 0
·  ·  ·  ·  ·  load_attributes 0.002690 0.002690 1 5,640 0
·  ·  ·  ·  LAYOUT 0.426330 0.142110 3 16,582,800 0
·  ·  ·  ·  ·  EVENT:layout_load_before 0.000629 0.000629 1 27,384 0
·  ·  ·  ·  ·  ·  OBSERVER:mstCoreAddPreprocessedStyles 0.000252 0.000252 1 10,240 0
·  ·  ·  ·  ·  layout_load 0.100351 0.100351 1 168,008 0
·  ·  ·  ·  ·  ·  layout_package_update:default 0.053555 0.053555 1 126,096 0
·  ·  ·  ·  ·  ·  ·  cache_load 0.000309 0.000309 1 655,408 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:default_head_blocks 0.001159 0.001159 1 3,168 0
·  ·  ·  ·  ·  ·  ·  layout_db_update: default_head_blocks 0.001516 0.001516 1 9,992 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:checkout_cart_sidebar_item_renderers 0.002303 0.002303 1 3,232 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:checkout_cart_sidebar_item_price_renderers 0.001003 0.001003 1 3,360 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:checkout_cart_sidebar_total_renderers 0.001303 0.001303 1 6,048 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:amgdpr_popup 0.008315 0.008315 1 1,376 0
·  ·  ·  ·  ·  ·  layout_package_update:catalog_category_view 0.012467 0.012467 1 16,560 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:msrp_popup 0.009139 0.009139 1 1,568 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:category_seo_description 0.001001 0.001001 1 1,000 0
·  ·  ·  ·  ·  ·  layout_package_update:catalog_category_view_type_layered 0.003051 0.003051 1 12,480 0
·  ·  ·  ·  ·  ·  ·  layout_package_update:mana_layered_navigation 0.001730 0.001730 1 8,640 0
·  ·  ·  ·  ·  ·  layout_package_update:catalog_category_view_type_layered_without_children 0.001039 0.001039 1 1,224 0
·  ·  ·  ·  ·  ·  layout_package_update:catalog_category_view_id_806 0.006691 0.006691 1 968 0
·  ·  ·  ·  ·  ·  cache_save 0.001157 0.001157 1 136 0
·  ·  ·  ·  ·  layout_generate_xml 0.124577 0.124577 1 781,096 0
·  ·  ·  ·  ·  ·  cache_load 0.000147 0.000147 1 225,320 0
·  ·  ·  ·  ·  layout_generate_blocks 0.140642 0.140642 1 10,994,320 0
·  ·  ·  ·  ·  ·  Magento\Framework\View\Layout::Magento\Framework\View\Layout::generateElements 0.140431 0.140431 1 11,616,864 0
·  ·  ·  ·  ·  ·  ·  build_structure 0.022573 0.022573 1 685,768 0
·  ·  ·  ·  ·  ·  ·  generate_elements 0.115973 0.115973 1 10,925,016 0
·  ·  ·  ·  ·  ·  ·  ·  cache_load 0.000547 0.000091 6 17,944 0
·  ·  ·  ·  ·  ·  ·  ·  EVENT:core_layout_block_create_after 0.000933 0.000006 158 -48,200 0
·  ·  ·  ·  ·  ·  ·  ·  Magento\Framework\View\Layout::Magento\Framework\View\Layout::generateElements 0.000920 0.000920 1 223,720 0
·  ·  ·  ·  ·  ·  ·  ·  ·  cache_load 0.000081 0.000081 1 12,584 0
·  ·  ·  ·  ·  ·  ·  ·  ·  generate_elements 0.000505 0.000505 1 135,112 0
·  ·  ·  ·  ·  ·  ·  ·  EAV:load_collection 0.002721 0.002721 1 19,848 0
·  ·  ·  ·  ·  ·  ·  ·  ·  load_entities 0.001668 0.001668 1 11,816 0
·  ·  ·  ·  ·  ·  ·  ·  REWRITE: Magento\Catalog\Model\Category::getUrl 0.002370 0.001185 2 11,800 0
·  ·  ·  ·  ·  EVENT:layout_generate_blocks_after 0.059978 0.059978 1 4,611,240 0
·  ·  ·  ·  ·  ·  OBSERVER:remove_related_block 0.000346 0.000346 1 20,064 0
·  ·  ·  ·  ·  ·  OBSERVER:executeAfterLayoutLoadedCallbacks 0.058003 0.058003 1 4,554,216 0
·  ·  ·  ·  ·  ·  ·  cache_load 0.000439 0.000110 4 275,800 0
·  ·  ·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.003698 0.000013 292 1,328 0
·  ·  ·  ·  ·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.001244 0.000004 292 14,712 0
·  ·  ·  ·  ·  ·  OBSERVER:temando_replace_shipment_info_template 0.000601 0.000601 1 18,800 0
·  ·  ·  ·  postdispatch 0.004776 0.004776 1 422,512 0
·  ·  ·  ·  ·  EVENT:controller_action_postdispatch 0.004671 0.004671 1 420,064 0
·  ·  ·  ·  ·  ·  OBSERVER:m_seo_observer_canonical 0.003130 0.003130 1 269,144 0
·  ·  ·  ·  ·  ·  OBSERVER:m_seo_observer_alternate 0.001222 0.001222 1 141,824 0
·  LAYOUT 1.968641 1.968641 1 12,113,960 0
·  ·  layout_render 1.968625 1.968625 1 12,113,544 0
·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000580 0.000008 73 -20,720 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-theme/view/frontend/templates/page/js/require_js.phtml 0.001479 0.001479 1 108,144 0
·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000618 0.000008 73 -20,736 0
·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.000321 0.000007 44 1,024 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getEntityType 0.000057 0.000005 12 1,112 0
·  ·  ·  EAV:load_collection 0.339807 0.042476 8 8,390,304 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.001027 0.000068 15 5,064 0
·  ·  ·  ·  load_entities 0.262953 0.032869 8 8,255,856 0
·  ·  ·  ·  ·  cache_load 0.000930 0.000133 7 783,800 0
·  ·  ·  ·  load_attributes 0.061556 0.007694 8 128,872 0
·  ·  ·  ·  set_orig_data 0.004930 0.000616 8 472 0
·  ·  ·  ·  after_load 0.007444 0.000930 8 1,584 0
·  ·  ·  EVENT:tax_rate_data_fetch 0.000107 0.000011 10 -2,328 0
·  ·  ·  EVENT:catalog_block_product_list_collection 0.000431 0.000431 1 18,504 0
·  ·  ·  ·  OBSERVER:review 0.000405 0.000405 1 16,968 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-theme/view/frontend/templates/html/container.phtml 0.421000 0.421000 1 6,170,360 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000175 0.000009 20 -5,288 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000183 0.000009 20 -5,608 0
·  ·  ·  ·  EVENT:core_layout_render_element 0.013447 0.000672 20 264,592 0
·  ·  ·  ·  ·  OBSERVER:pagecache 0.008041 0.000402 20 6,056 0
·  ·  ·  ·  ·  OBSERVER:amasty_gdprcookie_layout_render 0.002843 0.000142 20 232,744 0
·  ·  ·  ·  ·  OBSERVER:litemage_layout_render 0.000565 0.000028 20 13,920 0
·  ·  ·  ·  ·  OBSERVER:weltpixel_googletagmanager 0.000636 0.000032 20 4,224 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Facebook/BusinessExtension/view/frontend/templates/pixel/add_to_cart.phtml 0.117604 0.117604 1 5,628,616 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Magmodules/RichSnippets/view/frontend/templates/json.phtml 0.002248 0.000749 3 109,968 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Facebook/BusinessExtension/view/frontend/templates/pixel/head.phtml 0.004672 0.004672 1 16,376 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Anowave/Ec/view/frontend/templates/purchase.phtml 0.014310 0.014310 1 46,568 0
·  ·  ·  ·  ·  EVENT:core_layout_render_element 0.002547 0.000509 5 7,024 0
·  ·  ·  ·  ·  ·  OBSERVER:pagecache 0.001610 0.000322 5 1,000 0
·  ·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Anowave/Ec/view/frontend/templates/impression.phtml 0.004681 0.004681 1 24,192 0
·  ·  ·  ·  ·  ·  EAV:load_collection 0.002160 0.002160 1 21,536 0
·  ·  ·  ·  ·  ·  ·  load_entities 0.000638 0.000638 1 11,328 0
·  ·  ·  ·  ·  ·  ·  load_attributes 0.001358 0.001358 1 3,992 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/mailchimp/mc-magento2/view/frontend/templates/mailchimpjs.phtml 0.253206 0.253206 1 26,144 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Magento_Theme/templates/html/config.phtml 0.001361 0.001361 1 18,848 0
·  ·  ·  EVENT:core_layout_render_element 0.045952 0.000451 102 66,968 0
·  ·  ·  ·  OBSERVER:pagecache 0.036467 0.000358 102 5,384 0
·  ·  ·  ·  OBSERVER:amasty_gdprcookie_layout_render 0.000811 0.000008 102 8,696 0
·  ·  ·  ·  OBSERVER:litemage_layout_render 0.001877 0.000018 102 6,216 0
·  ·  ·  ·  OBSERVER:weltpixel_googletagmanager 0.002419 0.000024 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.005878 0.005878 1 20,496 0
·  ·  ·  ·  EVENT:core_layout_render_element 0.002224 0.000318 7 7,680 0
·  ·  ·  ·  ·  OBSERVER:pagecache 0.001633 0.000233 7 968 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-theme/view/frontend/templates/js/cookie.phtml 0.008456 0.008456 1 4,152 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-theme/view/frontend/templates/html/notices.phtml 0.000191 0.000191 1 91,472 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/dotmailer/dotmailer-magento2-extension/view/frontend/templates/email/tracking_code.phtml 0.079995 0.079995 1 669,808 0
·  ·  ·  ·  cache_load 0.000124 0.000124 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.716435 0.716435 1 2,238,448 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_before 0.000188 0.000010 18 -4,696 0
·  ·  ·  ·  cache_load 0.000493 0.000082 6 19,720 0
·  ·  ·  ·  EVENT:view_block_abstract_to_html_after 0.000186 0.000010 18 -4,984 0
·  ·  ·  ·  EAV:load_collection 0.220667 0.073556 3 2,796,016 0
·  ·  ·  ·  ·  load_entities 0.192768 0.064256 3 2,752,248 0
·  ·  ·  ·  ·  ·  cache_load 0.000328 0.000164 2 261,880 0
·  ·  ·  ·  ·  load_attributes 0.025246 0.008415 3 44,456 0
·  ·  ·  ·  ·  set_orig_data 0.001975 0.000658 3 696 0
·  ·  ·  ·  EVENT:core_layout_render_element 0.006218 0.000444 14 12,104 0
·  ·  ·  ·  ·  OBSERVER:pagecache 0.004751 0.000339 14 1,304 0
·  ·  ·  ·  ·  OBSERVER:amasty_gdprcookie_layout_render 0.000135 0.000010 14 1,816 0
·  ·  ·  ·  ·  OBSERVER:litemage_layout_render 0.000298 0.000021 14 2,312 0
·  ·  ·  ·  ·  OBSERVER:weltpixel_googletagmanager 0.000370 0.000026 14 1,592 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Anowave/TaxSwitch/view/frontend/templates/switcher.phtml 0.004829 0.004829 1 10,088 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Checkout/templates/cart/minicart.phtml 0.007402 0.007402 1 174,872 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Search/templates/form.mini.phtml 0.002805 0.002805 1 24,680 0
·  ·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Theme/templates/html/nav-mobile.phtml 0.382598 0.382598 1 -473,936 0
·  ·  ·  ·  ·  EAV:load_collection 0.129441 0.129441 1 329,480 0
·  ·  ·  ·  ·  ·  load_entities 0.116522 0.116522 1 302,312 0
·  ·  ·  ·  ·  ·  ·  cache_load 0.000129 0.000129 1 131,400 0
·  ·  ·  ·  ·  ·  load_attributes 0.011757 0.011757 1 23,688 0
·  ·  ·  ·  ·  REWRITE: Magento\Catalog\Model\Category::getUrl 0.158980 0.000371 429 339,192 0
·  ·  ·  ·  ·  EVENT:page_block_html_topmenu_gethtml_before 0.003600 0.003600 1 59,920 0
·  ·  ·  ·  ·  ·  OBSERVER:magefan_blog_topmenu_observer 0.003570 0.003570 1 58,048 0
·  ·  ·  ·  EAV: Magento\Eav\Model\Config::getAttribute 0.000103 0.000009 12 1,328 0
·  ·  ·  ·  cache_remove 0.002163 0.002163 1 2,672 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Theme/templates/html/title.phtml 0.001389 0.001389 1 8,272 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-customer/view/frontend/templates/account/authentication-popup.phtml 0.001407 0.001407 1 101,816 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/magento/module-catalog/view/frontend/templates/category/products.phtml 0.002847 0.002847 1 25,000 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/code/Manadev/LayeredNavigationPositions/view/frontend/templates/horizontal/menu.phtml 0.003257 0.003257 1 9,288 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Manadev_LayeredNavigationMobile/templates/mobile.phtml 0.001034 0.001034 1 1,040 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Manadev_LayeredNavigation/templates/navigation.phtml 0.004108 0.004108 1 1,040 0
·  ·  ·  cache_save 0.001273 0.000318 4 -920 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Astan/electricalshowroom/Magento_Theme/templates/html/footer.phtml 0.018704 0.018704 1 39,416 0
·  ·  ·  cache_remove 0.003757 0.001878 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.118732 0.118732 1 426,584 0
·  ·  ·  ·  EVENT:facebook_businessextension_ssapi_view_category 0.116044 0.116044 1 421,440 0
·  ·  ·  ·  ·  OBSERVER:facebook_businessextension_ssapi_view_category_after 0.116017 0.116017 1 419,824 0
·  ·  ·  ·  ·  ·  EVENT:model_load_before 0.000036 0.000012 3 16,160 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/app/design/frontend/Sm/market/Sm_CartQuickPro/templates/default.phtml 0.002015 0.002015 1 7,568 0
·  ·  ·  TEMPLATE:/var/www/electrical-showroom.co.uk/www/public_html/vendor/amasty/gdpr-cookie/view/frontend/templates/cookiebar.phtml 0.004649 0.004649 1 83,176 0