Echappement

Echappement quad-SSV-moto off road

 

Personnalisez votre quad en optant pour un nouvel échappement. Cette rubrique regorge de bons plans pour trouver des accessoires off road pas cher pour votre engin. Sur cette page, vous trouverez aussi bien des échappements complets, que des protections, des systèmes pare-chaleurs, des silent-blocs ou des protections. Modifier l'échappement de votre machine ne permet pas seulement de faire plus de bruit. En passant de pare-feu, un échappement modifié permet au quad de mieux respirer et donc d'offrir des performances légèrement supérieures. D'ailleurs, certaines silencieux constituent un bon compromis entre un son amélioré mais pas trop fort et un meilleur confort d'utilisation. Le remplacement de cette pièce est assez simple puisqu'il s'agit avant tout de démontage et de remontage, les fixations correspondant à celles d'origine. En cas de doute, n'hésitez pas à faire appel à un professionnel pour le montage de vos accessoires off road.

Un échappement plus démonstratif permet aussi d'améliorer le look. Sur ce point, il est vrai qu'un beau silencieux a toujours son petit effet. Nous accordons un soin tout particulier dans le choix des équipements que nous mettons à votre disposition. Un quad cross, on s'y attache rapidement et on ne veut que le meilleur. C'est en partant d'un constat de ce type que nous enrichissons régulièrement les pages de notre boutique. Faîtes-vous plaisir parmi notre sélection et n'hésitez pas à nous contacter si vous avez des requêtes particulières. Allier style et performances n'a jamais été aussi simple qu'en remplaçant la ligne d'échappement de votre quad adoré !

Sous-catégories

  • Cross


    Échappement Cross

    Le motocross est un sport extrême exigeant, en loisir ou en compétition il est essentiel de posséder le meilleur équipement non seulement pour votre plaisir, mais également pour votre sécurité. Votre moto doit être correctement préparée afin de résister aux multiples chocs et s'adapter aux terrains les plus exigeants. 

    Notre boutique en ligne est spécialisée depuis 2005 dans la vente d'accessoires, d'équipements et de pièces détachées pour quads, SSV, moto, cross et enduro. Des produits de marque et de qualité afin d’embellir votre engin pour vos virées les plus sportives.

    Pour tirer le meilleur parti de votre véhicule, la sélection du bon échappement est essentielle en particulier lorsqu'il s'agit d’off-road. Améliorez les performances de votre motocross avec nos accessoires off-road.


    Pourquoi changer votre pot d’échappement ? 

    - Un moteur plus vif 

    - Une plus grande durée de vie pour votre moteur

    - Une esthétique travaillée

    - Une meilleure réponse de votre moto


     Nos modèles chez Access-K

    Nous vous proposons ici plusieurs modèles dédiés au cross ainsi qu'une gamme d'équipements essentiels pour l'entretien de votre pièce. Vous trouverez des bandes thermiques, des silencieux, des protections et des plaques pare-chaleur adhésive (résiste à des températures de 500°). Faites votre choix parmi notre large gamme d’accessoires. Sans oublier notre kit de pièces qui comprend le nécessaire pour entretenir et réparer votre système.

    Bénéficiez maintenant des conditions de vente exceptionnelles de notre site et profitez de notre expérience.



  • Enduro

     

    Échappement Enduro

     

    Les silencieux et pots d’échappement sont très importants pour équiper les motos d’enduro. Que ce soit des 2 temps ou 4 temps, chaque pot est nécessaire pour la performance du moteur de la moto. Voici une sélection de silencieux et d’échappements pour moto de très grande qualité et de marques reconnues sur le marché.

     

    Pourquoi choisir nos silencieux et échappements ? 

    Grâce aux silencieux et échappements de grandes marques que nous proposons comme ceux de chez FMF, Akrapovic, Factory et autres, votre motocross sera doté de meilleures performances que vous ayez un 2 ou un 4 temps.

     

    Les bénéfices obtenus par les silencieux et échappements pour enduro 

    Changer d’échappement ou de silencieux sur une moto permet d’augmenter la vitesse de l’engin à tous les régimes, de sentir une meilleure réponse à la poignée d’accélération et d’avoir un moteur plus vif.

      

    Les avantages de nos silencieux

    Ces silencieux sont conçus pour un grand nombre de marques. Sélectionnez le modèle correspondant à votre moto et à vos besoins. Tenez compte de la marque, du prix et de la capacité du silencieux ou de l’échappement. Plus il sera à votre moto et plus vous réaliserez des performances. Chaque modèle de silencieux est léger, possède une courbe de couple bien répartie, offre un bruit minimal dans sa catégorie et offre une bonne longévité.Nous sommes à votre disposition pour vous donner un maximum de renseignements sur tous les silencieux et échappements en 2 ou 4 temps pour votre enduro.

     

Il y a 3 produits.

Affichage 1-3 de 3 article(s)
Load Time 466 ms
Querying Time 136 ms
Queries 345
Memory Peak Usage 43.6 Mb
Included Files 979 files - 10.18 Mb
PrestaShop Cache - Mb
Global vars 0.51 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.94 Mb 18.1 Mb
__construct 0 ms 22 ms - Mb 18.1 Mb
init 95 ms 117 ms 8.72 Mb 26.8 Mb
checkAccess 0 ms 117 ms - Mb 26.8 Mb
setMedia 8 ms 125 ms 0.84 Mb 26.8 Mb
postProcess 0 ms 125 ms - Mb 26.8 Mb
initHeader 0 ms 125 ms - Mb 26.8 Mb
initContent 200 ms 325 ms 9.64 Mb 36.2 Mb
initFooter 0 ms 325 ms - Mb 36.2 Mb
display 141 ms 466 ms 7.17 Mb 43.6 Mb
Hook Time Memory Usage
DisplayTop 87 ms 2.74 Mb
displayFooter 9 ms 0.75 Mb
Header 9 ms 0.96 Mb
DisplayBeforeBodyClosingTag 5 ms 0.48 Mb
displayFooterBefore 5 ms 0.50 Mb
displayNav2 2 ms 0.15 Mb
DisplayHeader 2 ms 0.04 Mb
DisplayNavFullWidth 2 ms 0.09 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
displayNav1 1 ms 0.07 Mb
DisplayGDPRConsent 0 ms 0.04 Mb
DisplayMyAccountBlock 0 ms 0.01 Mb
ActionDispatcherBefore 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
ModuleRoutes 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
ActionDispatcher 0 ms - Mb
Footer 0 ms - Mb
19 hook(s) 124 ms 5.97 Mb
Module Time Memory Usage
colissimo 19 ms 2.09 Mb
spareparts 4 ms 0.37 Mb
ps_mbo 13 ms 2.40 Mb
magiczoomplus 8 ms 1.10 Mb
ps_emailsubscription 7 ms 0.77 Mb
blockreassurance 1 ms 0.09 Mb
ps_emailalerts 3 ms 0.33 Mb
ps_socialfollow 2 ms 0.15 Mb
ps_imageslider 2 ms 0.21 Mb
pm_advancedtopmenu 100 ms 4.12 Mb
ps_searchbar 1 ms 0.08 Mb
paypal 16 ms 2.66 Mb
ps_shoppingcart 1 ms 0.10 Mb
ps_contactinfo 3 ms 0.17 Mb
ps_customersignin 1 ms 0.08 Mb
psgdpr 3 ms 0.30 Mb
ps_linklist 8 ms 0.68 Mb
ps_customeraccountlinks 2 ms 0.14 Mb
statsdata 6 ms 0.53 Mb
19 module(s) 198 ms 16.37 Mb

Stopwatch SQL - 345 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, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-01-15 00:00:00",
INTERVAL 200 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps3i_category_product` cp
LEFT JOIN `ps3i_product` p
ON p.`id_product` = cp.`id_product`
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_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  )
LEFT JOIN `ps3i_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.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`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 356 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,40
7898 ms 30 /classes/Category.php:1057
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`
2105 ms 122 Yes Yes /classes/Hook.php:1173
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`)
1858 ms 854 /classes/Configuration.php:160
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
1672 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
1564 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`
1448 ms 16 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` = 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`
1308 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` = 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`
1303 ms 9 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`
1300 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` = 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`
1297 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` = 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`
1193 ms 15 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` = 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`
1180 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` = 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`
1178 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` = 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`
1166 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`
1164 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` = 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`
1148 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` = 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`
1146 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` = 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`
1129 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`
1128 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` = 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`
1125 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` = 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`
1124 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` = 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`
1119 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` = 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`
1113 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` = 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`
1090 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` = 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`
1074 ms 3 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`
1074 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` = 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`
1052 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` = 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`
1046 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`
1013 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` = 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`
1005 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`
1000 ms 7 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` = 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`
995 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`
995 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`
980 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` = 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`
972 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` = 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`
971 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` = 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`
967 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` = 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`
952 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`
942 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` = 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`
940 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` = 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`
936 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` = 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`
935 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` = 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`
934 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` = 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`
933 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`
932 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`
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` = 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`
929 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`
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` = 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`
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` = 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`
920 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`
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` = 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`
915 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`
914 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`
914 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`
911 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`
909 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`
909 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`
908 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`
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` = 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`
906 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`
906 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` = 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`
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` = 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`
905 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` = 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`
894 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` = 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`
892 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`
891 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`
891 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`
887 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`
885 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`
875 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`
855 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` = 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`
855 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`
851 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps3i_category` c
INNER JOIN ps3i_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps3i_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 356
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
799 ms 2 Yes Yes /classes/Category.php:919
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`
754 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
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 = 7697
LIMIT 1
598 ms 8 /classes/ProductAssembler.php:95
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 = 8007
LIMIT 1
598 ms 1 /classes/ProductAssembler.php:95
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 (7697) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
540 ms 7 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps3i_hook`
526 ms 764 /classes/Hook.php:1233
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a0
LEFT JOIN `ps3i_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 87) AND (a0.`nright` > 92) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
502 ms 45 /classes/PrestaShopCollection.php:381
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 = 8119
LIMIT 1
468 ms 1 /classes/ProductAssembler.php:95
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` = 7697 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` = 7697 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
466 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
438 ms 68 /classes/module/Module.php:340
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
434 ms 27 Yes /classes/Dispatcher.php:643
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` = 7697
ORDER BY `position`
427 ms 8 Yes /classes/Product.php:3508
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
416 ms 1 Yes /classes/shop/Shop.php:711
(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
407 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps3i_attribute` a
LEFT JOIN `ps3i_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 7697
AND pac.`id_product_attribute` = 10739
AND agl.`id_lang` = 1
407 ms 1 /classes/Product.php:7398
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps3i_attribute` a
LEFT JOIN `ps3i_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 7697
AND pac.`id_product_attribute` = 10742
AND agl.`id_lang` = 1
407 ms 1 /classes/Product.php:7398
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` = 10736
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7697 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` = 10736
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 7697 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
402 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps3i_attribute` a
LEFT JOIN `ps3i_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 7697
AND pac.`id_product_attribute` = 10740
AND agl.`id_lang` = 1
401 ms 1 /classes/Product.php:7398
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` = 8119 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` = 8119 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
394 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps3i_attribute` a
LEFT JOIN `ps3i_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 7697
AND pac.`id_product_attribute` = 10741
AND agl.`id_lang` = 1
392 ms 1 /classes/Product.php:7398
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
386 ms 68 /classes/module/Module.php:340
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` = 8007 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` = 8007 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
382 ms 0 /classes/Cart.php:1426
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 (8007) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
379 ms 1 Yes Yes /classes/Product.php:4479
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
378 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
372 ms 68 /classes/module/Module.php:340
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 `name`, `value`, `block` FROM `ps3i_magiczoomplus_settings` WHERE `enabled`=1
361 ms 595 /modules/magiczoomplus/magiczoomplus.php:539
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps3i_attribute` a
LEFT JOIN `ps3i_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 7697
AND pac.`id_product_attribute` = 10736
AND agl.`id_lang` = 1
357 ms 1 /classes/Product.php:7398
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 (8119) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
353 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps3i_category` c
LEFT JOIN `ps3i_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 87 AND c.`nright` >= 92 AND c.`nleft` >= 2 AND c.`nright` <= 3257 ORDER BY `nleft` DESC
352 ms 45 /classes/Category.php:1586
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` = 7697) AND (b.`id_shop` = 1) LIMIT 1
348 ms 1 /src/Adapter/EntityMapper.php:76
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` = 8007) AND (b.`id_shop` = 1) LIMIT 1
341 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 356 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
339 ms 30 /classes/Category.php:986
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
334 ms 1 Yes /classes/shop/Shop.php:1350
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
329 ms 1 /classes/Language.php:1198
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 = 7697
ORDER BY f.position ASC
326 ms 4 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps3i_product_attribute_image` pai
LEFT JOIN `ps3i_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps3i_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (10736, 10737, 10738, 10739, 10740, 10741, 10742) AND il.`id_lang` = 1 ORDER by i.`position`
315 ms 10 Yes /classes/Product.php:2894
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps3i_category` c
LEFT JOIN `ps3i_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
311 ms 1 /classes/Category.php:2233
(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
310 ms 1 /classes/CartRule.php:383
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` = 8119) AND (b.`id_shop` = 1) LIMIT 1
309 ms 1 /src/Adapter/EntityMapper.php:76
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
308 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps3i_attribute` a
LEFT JOIN `ps3i_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 7697
AND pac.`id_product_attribute` = 10738
AND agl.`id_lang` = 1
306 ms 1 /classes/Product.php:7398
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a
LEFT JOIN `ps3i_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps3i_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 356) AND (b.`id_shop` = 1) LIMIT 1
305 ms 1 /src/Adapter/EntityMapper.php:76
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 = 8007
ORDER BY f.position ASC
302 ms 4 Yes /classes/Product.php:5897
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
302 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps3i_attribute` a
LEFT JOIN `ps3i_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 7697
AND pac.`id_product_attribute` = 10737
AND agl.`id_lang` = 1
302 ms 1 /classes/Product.php:7398
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 = 8119
ORDER BY f.position ASC
295 ms 4 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a
LEFT JOIN `ps3i_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps3i_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 525) AND (b.`id_shop` = 1) LIMIT 1
295 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` = 1
ORDER BY atmcw.`position`
293 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
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` = 8007
ORDER BY `position`
288 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_guest`
FROM `ps3i_connections`
WHERE `id_guest` = 62069
AND `date_add` > '2025-01-15 02:21:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
283 ms 1 Yes /classes/Connection.php:154
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` = 7697)
268 ms 7 /classes/Product.php:3820
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
260 ms 1 /src/Adapter/EntityMapper.php:76
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
256 ms 1 /classes/Cart.php:4215
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`
249 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
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` = 8119
ORDER BY `position`
246 ms 1 Yes /classes/Product.php:3508
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`
245 ms 3 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
240 ms 9 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerInitAfter") LIMIT 1
239 ms 1 /classes/Hook.php:1270
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')
238 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps3i_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
237 ms 1 /classes/shop/ShopUrl.php:182
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)
237 ms 1 /classes/Language.php:1049
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
235 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` = 4
ORDER BY atmcw.`position`
235 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE name, alias FROM `ps3i_hook_alias`
228 ms 88 /classes/Hook.php:343
SELECT SQL_NO_CACHE * FROM `ps3i_currency` c ORDER BY `iso_code` ASC
227 ms 1 Yes /classes/Currency.php:709
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` = 8119)
223 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps3i_product` p LEFT JOIN `ps3i_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps3i_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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) WHERE p.`id_product` = 7697 AND pa.`id_product` = 7697 AND pa.`id_product_attribute` = 10736 LIMIT 1
217 ms 1 /classes/Product.php:1135
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
217 ms 7 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
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` = 8007)
215 ms 1 /classes/Product.php:3820
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
214 ms 1 /src/Adapter/EntityMapper.php:76
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`
213 ms 4 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
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
213 ms 1 /src/Adapter/EntityMapper.php:76
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` = 7697
AND image_shop.`cover` = 1 LIMIT 1
212 ms 8 /classes/Product.php:3533
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
210 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps3i_hook_alias`
210 ms 88 /classes/Hook.php:291
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
208 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a
LEFT JOIN `ps3i_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps3i_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
207 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_page_type
FROM ps3i_page_type
WHERE name = 'category' LIMIT 1
207 ms 1 /classes/Page.php:104
SELECT SQL_NO_CACHE 1 FROM `ps3i_specific_price` WHERE id_product = 0 LIMIT 1
206 ms 1 /classes/SpecificPrice.php:411
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`
205 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
205 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
204 ms 1 /classes/Hook.php:1270
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
203 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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)
WHERE pa.`id_product_attribute` = 10736 LIMIT 1
201 ms 1 /classes/Combination.php:543
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`
200 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
198 ms 1 /classes/Hook.php:1270
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
197 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
197 ms 1 /src/Adapter/EntityMapper.php:76
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
196 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE `id_order`
FROM `ps3i_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
194 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
194 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
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` = 8007
AND image_shop.`cover` = 1 LIMIT 1
193 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE *
FROM `ps3i_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
192 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerSetVariables") LIMIT 1
192 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
191 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a
LEFT JOIN `ps3i_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps3i_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 526) AND (b.`id_shop` = 1) LIMIT 1
190 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`
FROM `ps3i_hook`
WHERE `id_hook` = 699 LIMIT 1
188 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps3i_required_field
187 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterTitleTag") LIMIT 1
186 ms 1 /classes/Hook.php:1270
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
186 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcherBefore") LIMIT 1
181 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerSetMedia") LIMIT 1
181 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
181 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
180 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
179 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_product_attribute` a
LEFT JOIN `ps3i_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 10736) LIMIT 1
177 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionOutputHTMLBefore") LIMIT 1
176 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_country_lang`
WHERE `id_country` = 8
176 ms 1 /src/Adapter/EntityMapper.php:84
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
176 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayContentWrapperTop") LIMIT 1
175 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_customersignin" LIMIT 1
175 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
174 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterBodyOpeningTag") LIMIT 1
174 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
173 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
173 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_contactinfo" LIMIT 1
173 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
172 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
172 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
171 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterProductSearch") LIMIT 1
171 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayMyAccountBlock") LIMIT 1
171 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
171 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayTop") LIMIT 1
170 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
170 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayBanner") LIMIT 1
170 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
170 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
170 ms 1 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
170 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
169 ms 1 /classes/Country.php:401