Casque Jet S769 TROOPER - Blanc Noir -
search
  • Casque Jet S769 TROOPER - Blanc Noir -

Casque Jet S769 TROOPER - Blanc Noir -

89,00 €
Taille : XS
Quantité

  Paiement sécurisé

Grâce à notre Certificat SSL

 

Expédition sous 48h

  Service clients

Appelez-nous : 03 21 24 90 25

Le casque S769 TROOPER est essentiellement orienté sur la pratique du trial, du quad et SSV.

Vous pratiquez le quad, le trial ou encore le SSV ? Le S769 TROOPER est fait pour vous ! 

Sa conception moderne offre un grand champ de vision ainsi qu’une visière détachable et réglable en hauteur. Son faible poids sera votre allié lors de vos journées de roulage. L’intérieur entièrement démontable et lavable facilitera grandement l’entretien du casque après vos sorties. L’aspect pratique n’est pas négligé pour autant, un écran fumé vous protègera du soleil et des éventuelles projections, vous pourrez déclipser cet écran facilement et le remplacer par un incolore si nécessaire. Enfin, sa boucle micrométrique vous offrira une grande facilité d’usage.  

Casque livré avec 2 écrans : 1 fumé + incolore

- Coque en ABS
- Écran fumé interchangeable 
- Larges ventilations frontales, extraction arrière
- Intérieur en tissu aéré, démontable et lavable
- Boucle d’attache rapide micrométrique
- Livré avec housse de casque
- Poids : 950g (± 50 g)

Modèle: S769 TROOPER

Couleur: BLANC NOIR

Taille: XS à XL

Homologué: ECE R22-05

Système d'attache: MICROMETRIQUE

Matière: ABS

Couleur Visière: FUMEE

Lunette Solaire: OUI

Visière Démontable: NON


S769
Load Time 350 ms
Querying Time 128 ms
Queries 318
Memory Peak Usage 43.2 Mb
Included Files 988 files - 10.37 Mb
PrestaShop Cache - Mb
Global vars 0.52 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 23 ms 23 ms 17.03 Mb 18.1 Mb
__construct 0 ms 23 ms - Mb 18.1 Mb
init 111 ms 134 ms 11.61 Mb 28.7 Mb
checkAccess 0 ms 134 ms - Mb 28.7 Mb
setMedia 8 ms 142 ms 0.84 Mb 29.7 Mb
postProcess 0 ms 142 ms - Mb 29.7 Mb
initHeader 0 ms 142 ms - Mb 29.7 Mb
initContent 67 ms 209 ms 6.59 Mb 37.1 Mb
initFooter 0 ms 209 ms - Mb 37.1 Mb
display 141 ms 350 ms 6.89 Mb 43.2 Mb
Hook Time Memory Usage
DisplayTop 86 ms 2.52 Mb
displayFooter 10 ms 0.76 Mb
Header 8 ms 0.85 Mb
DisplayBeforeBodyClosingTag 6 ms 0.38 Mb
displayFooterBefore 5 ms 0.46 Mb
DisplayProductActions 3 ms 0.16 Mb
displayNav2 2 ms 0.14 Mb
DisplayHeader 2 ms 0.03 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
DisplayReassurance 1 ms 0.14 Mb
productActions 1 ms 0.09 Mb
displayFooterProduct 1 ms 0.09 Mb
displayNav1 1 ms 0.07 Mb
displayProductAdditionalInfo 1 ms 0.07 Mb
DisplayGDPRConsent 0 ms 0.04 Mb
DisplayMyAccountBlock 0 ms 0.01 Mb
ActionDispatcherBefore 0 ms - Mb
DisplayProductAdditionalInfo 0 ms - Mb
DisplayNavFullWidth 0 ms - Mb
Productfooter 0 ms - Mb
ModuleRoutes 0 ms - Mb
DisplayFooterProduct 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayAfterProductThumbs 0 ms - Mb
Footer 0 ms - Mb
ActionDispatcher 0 ms - Mb
28 hook(s) 129 ms 5.96 Mb
Module Time Memory Usage
colissimo 19 ms 2.09 Mb
spareparts 5 ms 0.42 Mb
ps_mbo 13 ms 2.40 Mb
magiczoomplus 8 ms 1.03 Mb
ps_emailsubscription 7 ms 0.77 Mb
blockreassurance 2 ms 0.24 Mb
ps_emailalerts 3 ms 0.33 Mb
ps_socialfollow 2 ms 0.12 Mb
ps_imageslider 2 ms 0.21 Mb
pm_advancedtopmenu 100 ms 5.14 Mb
ps_searchbar 1 ms 0.07 Mb
paypal 15 ms 1.48 Mb
ps_shoppingcart 1 ms 0.09 Mb
ps_contactinfo 3 ms 0.16 Mb
ps_customersignin 1 ms 0.07 Mb
ps_sharebuttons 1 ms 0.11 Mb
ps_crossselling 2 ms 0.14 Mb
psgdpr 3 ms 0.29 Mb
ps_linklist 8 ms 0.72 Mb
ps_customeraccountlinks 2 ms 0.14 Mb
statsdata 6 ms 0.43 Mb
21 module(s) 203 ms 16.46 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 318 queries

Query Time (ms) Rows Filesort Group By Location 
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`
 2182 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`)
 1883 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
 1785 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
 1594 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`
 1437 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` = 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`
 1294 ms 11 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`
 1287 ms 7 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:320 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 6
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 1286 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`
 1255 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` = 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`
 1204 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` = 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`
 1192 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` = 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`
 1187 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` = 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`
 1185 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` = 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`
 1167 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` = 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`
 1152 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` = 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`
 1142 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` = 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`
 1140 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`
 1136 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` = 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`
 1134 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`
 1112 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`
 1112 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` = 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`
 1100 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 42
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 1087 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`
 1064 ms 2 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`
 1061 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`
 1060 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 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`
 1041 ms 7 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
 1039 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` = 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`
 1036 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` = 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`
 1023 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 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`
 1014 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`
 1006 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` = 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`
 1006 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 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`
 1005 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`
 982 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`
 977 ms 4 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` = 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`
 958 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`
 949 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 44
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 948 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`
 945 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`
 943 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`
 943 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 31
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 937 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`
 937 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`
 936 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
 936 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-15 00:00:00",
INTERVAL 200 DAY
)
) > 0 AS new
FROM `ps3i_accessory`
LEFT JOIN `ps3i_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps3i_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps3i_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps3i_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps3i_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_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 (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps3i_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 8039 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 933 ms 1 Yes /classes/Product.php:4631 
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`
 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` = 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`
 928 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`
 927 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` = 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`
 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` = 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`
 926 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`
 924 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 23
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 923 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
 922 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`
 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` = 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`
 920 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps3i_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps3i_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps3i_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps3i_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8039
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 919 ms 5 Yes Yes /classes/Product.php:4541 
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`
 918 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
 914 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`
 912 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` = 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`
 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`
 904 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`
 903 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
 902 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`
 898 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`
 898 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`
 893 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 13
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 891 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` = 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`
 887 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 11
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 878 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`
 867 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`
 862 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` = 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`
 843 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 15
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 774 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps3i_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps3i_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps3i_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps3i_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8039
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 10938 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 654 ms 1 Yes Yes /classes/Product.php:4541 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps3i_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps3i_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps3i_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps3i_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8039
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 10938 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 649 ms 1 Yes Yes /classes/Product.php:4541 
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` = 60
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 627 ms 1 Yes Yes /classes/Category.php:919 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps3i_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps3i_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps3i_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps3i_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8039
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 10938 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 623 ms 1 Yes Yes /classes/Product.php:4541 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, 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 (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`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)
INNER JOIN ps3i_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8039
 569 ms 5 /classes/Product.php:7427 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps3i_hook`
 546 ms 764 /classes/Hook.php:1233 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, 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 (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps3i_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps3i_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps3i_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`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)
INNER JOIN ps3i_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8039
 543 ms 5 /classes/Product.php:7427 
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
 525 ms 27 Yes /classes/Dispatcher.php:643 
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
 518 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` = 8039 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` = 8039 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 469 ms 0 /classes/Cart.php:1426 
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
 458 ms 1 Yes /classes/shop/Shop.php:711 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps3i_category` c
LEFT JOIN `ps3i_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps3i_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 455 ms 19 Yes Yes /classes/Category.php:1146 
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
 434 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
 429 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` = 10938
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8039 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` = 10938
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8039 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 412 ms 0 /classes/Cart.php:1426 
(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
 410 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` = 8039
AND pac.`id_product_attribute` = 10938
AND agl.`id_lang` = 1
 391 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 = 8039
ORDER BY f.position ASC
 387 ms 4 Yes /classes/Product.php:5897 
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
 384 ms 1 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE `name`, `value`, `block` FROM `ps3i_magiczoomplus_settings` WHERE `enabled`=1
 382 ms 595 /modules/magiczoomplus/magiczoomplus.php:539 
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
 381 ms 68 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps3i_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-15 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-15 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 380 ms 1 Yes /classes/SpecificPrice.php:624 
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
 379 ms 1 /classes/Language.php:1198 
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` = 8039) AND (b.`id_shop` = 1) LIMIT 1
 372 ms 1 /src/Adapter/EntityMapper.php:76 
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
 367 ms 1 Yes /classes/shop/Shop.php:1350 
SELECT SQL_NO_CACHE * FROM `ps3i_psreassurance` pr
LEFT JOIN ps3i_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "1"
AND pr.status = 1
ORDER BY pr.position
 333 ms 9 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159 
(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
 331 ms 1 /classes/CartRule.php:383 
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
 301 ms 0 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps3i_image` i
INNER JOIN ps3i_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps3i_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 8039
ORDER BY `position`
 301 ms 1 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
 298 ms 2 /classes/Meta.php:190 
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` = 8039)
 297 ms 5 /classes/Product.php:3820 
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`
 295 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps3i_connections`
WHERE `id_guest` = 62402
AND `date_add` > '2025-01-15 04:07:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 294 ms 1 Yes /classes/Connection.php:154 
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a0
LEFT JOIN `ps3i_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 264) AND (a0.`nright` > 265) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 290 ms 133 /classes/PrestaShopCollection.php:381 
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
 282 ms 2 /classes/Meta.php:190 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps3i_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 279 ms 1 /classes/shop/ShopUrl.php:182 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps3i_tab`
 278 ms 169 /classes/Tab.php:359 
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
 271 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps3i_currency` a
LEFT JOIN `ps3i_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps3i_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 268 ms 1 /src/Adapter/EntityMapper.php:76 
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 (10938, 10939, 10940, 10941, 10942) AND il.`id_lang` = 1 ORDER by i.`position`
 267 ms 5 Yes /classes/Product.php:2894 
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`
 265 ms 4 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87 
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 (10938, 10939, 10940, 10941, 10942) AND il.`id_lang` = 1 ORDER by i.`position`
 263 ms 5 Yes /classes/Product.php:2894 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 = 8039 LIMIT 1
 263 ms 5 /classes/Product.php:1037 
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
 260 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`
 259 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133 
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
 259 ms 2 /classes/Meta.php:190 
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
 253 ms 2 /classes/Meta.php:190 
SELECT SQL_NO_CACHE * FROM `ps3i_currency` c ORDER BY `iso_code` ASC
 252 ms 1 Yes /classes/Currency.php:709 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 3
ORDER BY atmcw.`position`
 251 ms 3 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133 
SELECT SQL_NO_CACHE o.id_order
FROM ps3i_orders o
LEFT JOIN ps3i_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (8039)
ORDER BY o.id_order DESC
LIMIT 400
 250 ms 1 Yes /modules/ps_crossselling/ps_crossselling.php:257 
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `ps3i_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
 242 ms 81 /classes/SpecificPrice.php:287 
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`
 239 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps3i_tag t
LEFT JOIN ps3i_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=8039
 231 ms 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps3i_hook_alias`
 231 ms 88 /classes/Hook.php:291 
SELECT SQL_NO_CACHE `id_order`
FROM `ps3i_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 230 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps3i_module` m
LEFT JOIN `ps3i_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
 228 ms 0 /src/Adapter/Module/ModuleDataProvider.php:174 
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
 227 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE * FROM `ps3i_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 227 ms 9 Yes /classes/ImageType.php:109 
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')
 227 ms 1 /classes/ObjectModel.php:578 
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
 225 ms 1 /src/Adapter/EntityMapper.php:76 
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` = 8039 AND pa.`id_product` = 8039 AND pa.`id_product_attribute` = 10938 LIMIT 1
 223 ms 1 /classes/Product.php:1135 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
 223 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE a.* 
FROM `ps3i_spareparts_category_product` a
WHERE a.`id_product`=8039
GROUP BY a.`id_category` 
ORDER BY a.`number` ASC
LIMIT 10
 222 ms 1 Yes Yes /modules/spareparts/classes/SparePartsClass.php:208 
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
 221 ms 1 /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` = 60) AND (b.`id_shop` = 1) LIMIT 1
 220 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_customersignin" LIMIT 1
 220 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
 216 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE 1 FROM `ps3i_specific_price` WHERE id_product = 0 LIMIT 1
 216 ms 1 /classes/SpecificPrice.php:411 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerInitAfter") LIMIT 1
 216 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
 211 ms 1 /src/Adapter/EntityMapper.php:84 
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`
 209 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps3i_stock_available`
WHERE (id_product = 8039) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 209 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps3i_category_product` cp
INNER JOIN `ps3i_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 8039 AND ctg.`id_group` = 1 LIMIT 1
 208 ms 2 /classes/Product.php:6615 
SELECT SQL_NO_CACHE name, alias FROM `ps3i_hook_alias`
 206 ms 88 /classes/Hook.php:343 
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 2 AND `id_shop` = 1
 206 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE * FROM `ps3i_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 204 ms 9 Yes /classes/ImageType.php:109 
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)
 203 ms 1 /classes/Language.php:1049 
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` = 10938) LIMIT 1
 203 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` = 5
ORDER BY atmcw.`position`
 202 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps3i_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 60 LIMIT 1
 200 ms 1 /classes/Category.php:1371 
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
 199 ms 7 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps3i_currency` c
LEFT JOIN ps3i_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 198 ms 1 /classes/Currency.php:1126 
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` = 8039
AND image_shop.`cover` = 1 LIMIT 1
 198 ms 1 /classes/Product.php:3533 
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
 197 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799 
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
 197 ms 1 /classes/shop/Shop.php:205 
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_categorytree" LIMIT 1
 197 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198 
SELECT SQL_NO_CACHE *
FROM `ps3i_cms` a
LEFT JOIN `ps3i_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) LIMIT 1
 196 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps3i_product` p
INNER JOIN ps3i_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 8039
AND DATEDIFF("2025-01-15 00:00:00", product_shop.`date_add`) < 200 LIMIT 1
 195 ms 0 /classes/Product.php:1647 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterTitleTag") LIMIT 1
 195 ms 1 /classes/Hook.php:1270 
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
 193 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_page`
FROM `ps3i_page`
WHERE `id_page_type` = 12 AND `id_object` = 8039 LIMIT 1
 191 ms 1 /classes/Page.php:83 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayBanner") LIMIT 1
 189 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
 189 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps3i_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 187 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionBuildFrontEndObject") LIMIT 1
 187 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNav2") LIMIT 1
 187 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
 185 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProduct") LIMIT 1
 184 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayTop") LIMIT 1
 183 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE *
FROM `ps3i_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 182 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
 182 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE `name`
FROM `ps3i_hook`
WHERE `id_hook` = 699 LIMIT 1
 181 ms 1 /classes/Hook.php:229 
SELECT SQL_NO_CACHE `name`
FROM `ps3i_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
 181 ms 0 /classes/Manufacturer.php:312 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 product_attribute_shop.default_on = 1  AND pa.id_product = 8039 LIMIT 1
 180 ms 5 /classes/Product.php:1051 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
 177 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE *
FROM `ps3i_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 176 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcherBefore") LIMIT 1
 176 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
 176 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799 
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product_attribute` FROM `ps3i_specific_price` WHERE `id_product_attribute` != 0 GROUP BY id_product ) AS counted LIMIT 1
 176 ms 4 /classes/SpecificPrice.php:287 
SELECT SQL_NO_CACHE *
FROM `ps3i_cms` a
LEFT JOIN `ps3i_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
 176 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
 176 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block` a
LEFT JOIN `ps3i_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 2) LIMIT 1
 175 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps3i_cms` a
LEFT JOIN `ps3i_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) LIMIT 1
 175 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
 174 ms 1 /classes/Country.php:274 
SELECT SQL_NO_CACHE id_page_type
FROM ps3i_page_type
WHERE name = 'product' LIMIT 1
 174 ms 1 /classes/Page.php:104 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
 174 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
 174 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
 174 ms 1 Yes /classes/Language.php:974 
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_contactinfo" LIMIT 1
 173 ms 1 /classes/module/Module.php:2840 
INSERT INTO `ps3i_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('62402', '842', '308350554', '', '1', '1', '2025-01-15 04:37:58')
 172 ms 1 /classes/ObjectModel.php:578 
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 168 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayReassurance") LIMIT 1
 167 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block_lang`
WHERE `id_link_block` = 1
 166 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionObjectAddAfter") LIMIT 1
 166 ms 0 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE `reduction`
FROM `ps3i_product_group_reduction_cache`
WHERE `id_product` = 8039 AND `id_group` = 1 LIMIT 1
 166 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
 164 ms 0 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE `id_country`
FROM `ps3i_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 164 ms 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE `name` FROM `ps3i_supplier` WHERE `id_supplier` = 0 LIMIT 1
 162 ms 0 /classes/Supplier.php:244 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionProductOutOfStock") LIMIT 1
 160 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterBefore") LIMIT 1
 159 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_columns_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
 157 ms 51 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
 157 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayContentWrapperBottom") LIMIT 1
 156 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayMyAccountBlock") LIMIT 1
 156 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterProductThumbs") LIMIT 1
 156 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductAdditionalInfo") LIMIT 1
 155 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductActions") LIMIT 1
 155 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionOutputHTMLBefore") LIMIT 1
 155 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block_lang`
WHERE `id_link_block` = 2
 154 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
 154 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooter") LIMIT 1
 153 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterBodyOpeningTag") LIMIT 1
 153 ms 1 /classes/Hook.php:1270 
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
 152 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayContentWrapperTop") LIMIT 1
 152 ms 1 /classes/Hook.php:1270 
SELECT SQL_NO_CACHE psgdpr.active FROM `ps3i_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 22 LIMIT 1
 152 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132 
SELECT SQL_NO_CACHE value FROM `ps3i_configuration` WHERE `name` = "PS_MUL