Liste des produits de la marque WARM

Il y a 1 produit.

Affichage 1-1 de 1 article(s)
Load Time 327 ms
Querying Time 120 ms
Queries 267
Memory Peak Usage 42.1 Mb
Included Files 972 files - 10.17 Mb
PrestaShop Cache - Mb
Global vars 0.50 Mb
PrestaShop Version 1.7.8.0
PHP Version 7.4.33
MySQL Version 10.6.20-MariaDB
Memory Limit 512M
Max Execution Time 360s
Smarty Cache disabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 22 ms 22 ms 16.93 Mb 18.1 Mb
__construct 0 ms 22 ms - Mb 18.1 Mb
init 74 ms 96 ms 8.44 Mb 26.5 Mb
checkAccess 0 ms 96 ms - Mb 26.5 Mb
setMedia 8 ms 104 ms 0.78 Mb 26.5 Mb
postProcess 0 ms 104 ms - Mb 26.5 Mb
initHeader 0 ms 104 ms - Mb 26.5 Mb
initContent 88 ms 192 ms 9.44 Mb 35.6 Mb
initFooter 0 ms 192 ms - Mb 35.6 Mb
display 135 ms 327 ms 6.33 Mb 42.1 Mb
Hook Time Memory Usage
DisplayTop 91 ms 2.68 Mb
displayFooter 10 ms 0.75 Mb
Header 7 ms 0.85 Mb
DisplayBeforeBodyClosingTag 6 ms 0.48 Mb
displayFooterBefore 5 ms 0.56 Mb
displayNav2 2 ms 0.15 Mb
DisplayHeader 2 ms 0.03 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
displayNav1 1 ms 0.07 Mb
DisplayGDPRConsent 0 ms 0.05 Mb
DisplayMyAccountBlock 0 ms 0.01 Mb
ActionDispatcherBefore 0 ms - Mb
DisplayNavFullWidth 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
Footer 0 ms - Mb
ActionDispatcher 0 ms - Mb
19 hook(s) 126 ms 5.79 Mb
Module Time Memory Usage
colissimo 18 ms 2.09 Mb
spareparts 3 ms 0.32 Mb
ps_mbo 13 ms 2.40 Mb
magiczoomplus 8 ms 1.04 Mb
ps_emailsubscription 7 ms 0.84 Mb
blockreassurance 1 ms 0.09 Mb
ps_emailalerts 3 ms 0.26 Mb
ps_socialfollow 2 ms 0.15 Mb
ps_imageslider 2 ms 0.27 Mb
pm_advancedtopmenu 104 ms 4.05 Mb
ps_searchbar 1 ms 0.08 Mb
paypal 14 ms 2.57 Mb
ps_shoppingcart 1 ms 0.09 Mb
ps_contactinfo 3 ms 0.17 Mb
ps_customersignin 1 ms 0.14 Mb
psgdpr 3 ms 0.36 Mb
ps_linklist 8 ms 0.68 Mb
ps_customeraccountlinks 2 ms 0.14 Mb
statsdata 6 ms 0.53 Mb
19 module(s) 199 ms 16.31 Mb

Stopwatch SQL - 267 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`,
pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-01-15 00:00:00",
INTERVAL 200 DAY
)
) > 0 AS new FROM `ps3i_product` p
INNER JOIN ps3i_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `ps3i_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps3i_product_lang` pl
ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps3i_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps3i_image_lang` il
ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps3i_manufacturer` m
ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN ps3i_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )JOIN `ps3i_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps3i_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` =1)JOIN `ps3i_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_manufacturer` = 20
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY pl.`name` asc
LIMIT 0,40
2189 ms 12 Yes Yes /classes/Manufacturer.php:495
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps3i_module` m
INNER JOIN ps3i_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps3i_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps3i_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps3i_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps3i_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2084 ms 122 Yes Yes /classes/Hook.php:1173
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 49
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1942 ms 10 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 51
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1892 ms 9 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 48
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1880 ms 15 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps3i_configuration` c
LEFT JOIN `ps3i_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1832 ms 854 /classes/Configuration.php:160
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 50
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1821 ms 10 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps3i_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps3i_hook_alias` ha
INNER JOIN `ps3i_hook` h ON ha.name = h.name
1674 ms 0 /classes/Hook.php:1233
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps3i_hook_module` hm
STRAIGHT_JOIN `ps3i_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps3i_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1531 ms 364 /classes/Hook.php:494
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 3
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1417 ms 16 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atp.*, atpl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name,
ccl.name as cms_category_name
FROM `ps3i_pm_advancedtopmenu` atp
LEFT JOIN `ps3i_pm_advancedtopmenu_lang` atpl ON (atp.`id_menu` = atpl.`id_menu` AND atpl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atp.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1 AND 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = atp.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1 AND 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atp.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atp.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1 AND 1)
LEFT JOIN `ps3i_supplier` s ON (atp.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1 AND 1)
WHERE atp.`active` = 1 AND (atp.`active_desktop` = 1 || atp.`active_mobile` = 1)
AND ((atp.`id_manufacturer` = 0 AND atp.`id_supplier` = 0 AND atp.`id_category` = 0 AND atp.`id_cms` = 0 AND atp.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND IF (atp.`id_category` IS NULL OR atp.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atp.`id_menu`
ORDER BY atp.`position`
1357 ms 7 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:320
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 6
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1311 ms 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 46
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1300 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 2
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1279 ms 11 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 47
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1278 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 41
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1240 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 1
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1218 ms 9 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 28
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1211 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 27
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1194 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 10
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1168 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 71
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1155 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 37
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1148 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 4
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1136 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 43
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1132 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 40
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1124 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 30
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1102 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 42
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1079 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 8
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1065 ms 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 10
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1063 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 29
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1047 ms 3 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 2
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1038 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 39
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1037 ms 2 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 4
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1033 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 5
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1028 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 24
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1019 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 9
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1005 ms 7 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 5
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
997 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 1
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
997 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 3
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
973 ms 3 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 11
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
961 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 9
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
952 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 25
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
950 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 45
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
946 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 31
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
942 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 6
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
939 ms 3 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 68
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
936 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 38
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
936 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 69
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
931 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 12
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
927 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 15
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
924 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 23
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
924 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 26
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
923 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 14
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
918 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 33
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
918 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 17
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
916 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 20
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
916 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 52
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
913 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 22
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
912 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 36
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
911 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 7
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
910 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 32
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
907 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 35
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
907 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 7
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
905 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 44
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
903 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 19
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
901 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 18
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
900 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 16
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
897 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 21
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
896 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 13
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
894 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 12
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
881 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 14
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
879 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 11
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
876 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 13
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
874 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 15
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
820 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps3i_product_attribute` pa
INNER JOIN ps3i_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps3i_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (790) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
637 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps3i_hook`
542 ms 764 /classes/Hook.php:1233
SELECT SQL_NO_CACHE p.`id_product`
FROM `ps3i_product` p
INNER JOIN ps3i_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_manufacturer = 20 AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND EXISTS (
SELECT 1
FROM `ps3i_category_group` cg
LEFT JOIN `ps3i_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `ps3i_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` =1
)
521 ms 12 /classes/Manufacturer.php:426
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-15 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps3i_product p
LEFT JOIN ps3i_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps3i_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps3i_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 790
LIMIT 1
493 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps3i_meta` m
LEFT JOIN `ps3i_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
476 ms 27 Yes /classes/Dispatcher.php:643
(SELECT 1 FROM `ps3i_cart_rule` WHERE date_to >= "2025-01-15 00:00:00" AND date_to <= "2025-01-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps3i_cart_rule` WHERE date_from >= "2025-01-15 00:00:00" AND date_from <= "2025-01-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps3i_cart_rule` WHERE date_from < "2025-01-15 00:00:00" AND date_to > "2025-01-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
456 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps3i_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 790 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps3i_cart_product` cp JOIN `ps3i_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps3i_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 790 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
435 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps3i_module` m
LEFT JOIN `ps3i_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
435 ms 68 /classes/module/Module.php:340
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps3i_shop_url su
LEFT JOIN ps3i_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.itech-equipement.fr' OR su.domain_ssl = 'www.itech-equipement.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
430 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps3i_module` m
LEFT JOIN `ps3i_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
423 ms 68 /classes/module/Module.php:340
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps3i_module` m
LEFT JOIN `ps3i_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
404 ms 68 /classes/module/Module.php:340
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps3i_shop_group gs
LEFT JOIN ps3i_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps3i_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
400 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps3i_module` m
LEFT JOIN `ps3i_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
377 ms 68 /classes/module/Module.php:340
SELECT SQL_NO_CACHE `name`, `value`, `block` FROM `ps3i_magiczoomplus_settings` WHERE `enabled`=1
377 ms 595 /modules/magiczoomplus/magiczoomplus.php:539
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
367 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE tr.*
FROM `ps3i_tax_rule` tr
JOIN `ps3i_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
363 ms 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps3i_image` i
INNER JOIN ps3i_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps3i_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 790
ORDER BY `position`
354 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
345 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 1
ORDER BY atmcw.`position`
332 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps3i_feature_product pf
LEFT JOIN ps3i_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps3i_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps3i_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps3i_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 790
ORDER BY f.position ASC
330 ms 4 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ps3i_product` a
LEFT JOIN `ps3i_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps3i_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 790) AND (b.`id_shop` = 1) LIMIT 1
329 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps3i_lang` l
JOIN ps3i_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
323 ms 1 /classes/Language.php:1198
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps3i_link_block lb
INNER JOIN ps3i_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 41 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
321 ms 4 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
(SELECT 1 FROM `ps3i_cart_rule` WHERE date_to >= "2025-01-15 00:00:00" AND date_to <= "2025-01-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps3i_cart_rule` WHERE date_from >= "2025-01-15 00:00:00" AND date_from <= "2025-01-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps3i_cart_rule` WHERE date_from < "2025-01-15 00:00:00" AND date_to > "2025-01-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
320 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
317 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
310 ms 2 /classes/Meta.php:190
INSERT INTO `ps3i_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
293 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE 1 FROM ps3i_cart_product cp INNER JOIN ps3i_product p
ON (p.id_product = cp.id_product) INNER JOIN ps3i_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
290 ms 1 /classes/Cart.php:4215
SELECT SQL_NO_CACHE `id_guest`
FROM `ps3i_connections`
WHERE `id_guest` = 62301
AND `date_add` > '2025-01-15 03:40:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
289 ms 1 Yes /classes/Connection.php:154
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps3i_lang` l
LEFT JOIN `ps3i_lang_shop` ls ON (l.id_lang = ls.id_lang)
281 ms 1 /classes/Language.php:1049
SELECT SQL_NO_CACHE *
FROM `ps3i_manufacturer` a
LEFT JOIN `ps3i_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps3i_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 20) LIMIT 1
273 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_country` a
LEFT JOIN `ps3i_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps3i_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
266 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_currency` a
LEFT JOIN `ps3i_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps3i_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
265 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 2
ORDER BY atmcw.`position`
256 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE * FROM `ps3i_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
251 ms 9 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE * FROM `ps3i_currency` c ORDER BY `iso_code` ASC
246 ms 1 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 3
ORDER BY atmcw.`position`
243 ms 3 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 4
ORDER BY atmcw.`position`
240 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps3i_product` p
INNER JOIN `ps3i_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps3i_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 790)
235 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
232 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps3i_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
231 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
230 ms 1 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
229 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE name, alias FROM `ps3i_hook_alias`
225 ms 88 /classes/Hook.php:343
SELECT SQL_NO_CACHE *
FROM `ps3i_group` a
LEFT JOIN `ps3i_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
222 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_lang` a
LEFT JOIN `ps3i_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
220 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps3i_hook_alias`
216 ms 88 /classes/Hook.php:291
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
216 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 5
ORDER BY atmcw.`position`
214 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
213 ms 7 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 9
ORDER BY atmcw.`position`
211 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps3i_image` i
INNER JOIN ps3i_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 790
AND image_shop.`cover` = 1 LIMIT 1
203 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE *
FROM `ps3i_cms` a
LEFT JOIN `ps3i_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) LIMIT 1
203 ms 1 /src/Adapter/EntityMapper.php:76
INSERT INTO `ps3i_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('62301', '177', '308350554', '', '1', '1', '2025-01-15 04:10:39')
202 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE `id_page`
FROM `ps3i_page`
WHERE `id_page_type` = 14 AND `id_object` = 20 LIMIT 1
201 ms 1 /classes/Page.php:83
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps3i_shop s
LEFT JOIN ps3i_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
200 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 2 AND `id_shop` = 1
199 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block` a
LEFT JOIN `ps3i_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 1) LIMIT 1
198 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_page_type
FROM ps3i_page_type
WHERE name = 'manufacturer' LIMIT 1
197 ms 1 /classes/Page.php:104
SELECT SQL_NO_CACHE *
FROM `ps3i_cms` a
LEFT JOIN `ps3i_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) LIMIT 1
196 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block` a
LEFT JOIN `ps3i_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 2) LIMIT 1
196 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
196 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
195 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE *
FROM `ps3i_cms` a
LEFT JOIN `ps3i_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
195 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
194 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionProductSearchProviderRunQueryBefore") LIMIT 1
193 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerInitAfter") LIMIT 1
192 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps3i_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
190 ms 1 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE *
FROM `ps3i_country` a
LEFT JOIN `ps3i_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps3i_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
190 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_shop
FROM `ps3i_manufacturer_shop`
WHERE `id_manufacturer` = 20
AND id_shop = 1 LIMIT 1
190 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps3i_currency` c
LEFT JOIN ps3i_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
188 ms 1 /classes/Currency.php:1126
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNav2") LIMIT 1
187 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
186 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterBodyOpeningTag") LIMIT 1
186 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
185 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps3i_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 9 LIMIT 1
185 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcherBefore") LIMIT 1
185 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
184 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
183 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
183 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerSetMedia") LIMIT 1
180 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "productSearchProvider") LIMIT 1
179 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterTitleTag") LIMIT 1
178 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayBanner") LIMIT 1
178 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
177 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block_lang`
WHERE `id_link_block` = 1
176 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterProductSearch") LIMIT 1
176 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayTop") LIMIT 1
175 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE tr.*
FROM `ps3i_tax_rule` tr
JOIN `ps3i_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
174 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE format
FROM `ps3i_address_format`
WHERE `id_country` = 8 LIMIT 1
174 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
174 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE `name`
FROM `ps3i_hook`
WHERE `id_hook` = 699 LIMIT 1
173 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE 1 FROM `ps3i_specific_price` WHERE id_product = 0 LIMIT 1
172 ms 1 /classes/SpecificPrice.php:411
SELECT SQL_NO_CACHE `iso_code`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
171 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE *
FROM `ps3i_country` a
LEFT JOIN `ps3i_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
171 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_contactinfo" LIMIT 1
171 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterCategory") LIMIT 1
170 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_country`
FROM `ps3i_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
164 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayContentWrapperTop") LIMIT 1
163 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
163 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
162 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps3i_required_field
161 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayMyAccountBlock") LIMIT 1
161 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
160 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooter") LIMIT 1
159 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
158 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block_lang`
WHERE `id_link_block` = 2
157 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
157 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE psgdpr.active FROM `ps3i_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 22 LIMIT 1
157 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_columns_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
156 ms 51 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE `id_order`
FROM `ps3i_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
156 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionBuildFrontEndObject") LIMIT 1
156 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
155 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_linklist" LIMIT 1
155 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayBeforeBodyClosingTag") LIMIT 1
153 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_currency_lang`
WHERE `id_currency` = 1
151 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
151 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module_shop` WHERE `id_module` = 33 AND `id_shop` = 1 LIMIT 1
150 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
150 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
149 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
149 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNewsletterRegistration") LIMIT 1
149 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1