ALUM. RIM CAP

11,33 €
Microfiche : GOES 520
Quantité

  Paiement sécurisé

Grâce à notre Certificat SSL

 

Expédition sous 48h

  Service clients

Appelez-nous : 03 21 24 90 25

9050-040036

Références spécifiques

UPC
15
Load Time 418 ms
Querying Time 138 ms
Queries 317
Memory Peak Usage 43.1 Mb
Included Files 987 files - 10.34 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 38 ms 38 ms 17.03 Mb 18.1 Mb
__construct 0 ms 38 ms - Mb 18.1 Mb
init 157 ms 196 ms 11.61 Mb 28.7 Mb
checkAccess 0 ms 196 ms - Mb 28.7 Mb
setMedia 8 ms 204 ms 0.84 Mb 29.7 Mb
postProcess 0 ms 204 ms - Mb 29.7 Mb
initHeader 0 ms 204 ms - Mb 29.7 Mb
initContent 72 ms 276 ms 6.45 Mb 36.9 Mb
initFooter 0 ms 276 ms - Mb 36.9 Mb
display 142 ms 418 ms 6.89 Mb 43.1 Mb
Hook Time Memory Usage
DisplayTop 88 ms 2.49 Mb
displayFooter 9 ms 0.70 Mb
Header 8 ms 0.85 Mb
DisplayBeforeBodyClosingTag 5 ms 0.38 Mb
displayFooterBefore 5 ms 0.46 Mb
DisplayProductActions 3 ms 0.16 Mb
DisplayHeader 2 ms 0.03 Mb
displayNav2 2 ms 0.14 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
DisplayReassurance 1 ms 0.08 Mb
displayNav1 1 ms 0.07 Mb
productActions 1 ms 0.09 Mb
displayFooterProduct 1 ms 0.09 Mb
displayProductAdditionalInfo 1 ms 0.06 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
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
DisplayAfterProductThumbs 0 ms - Mb
ActionDispatcher 0 ms - Mb
Footer 0 ms - Mb
28 hook(s) 130 ms 5.80 Mb
Module Time Memory Usage
colissimo 31 ms 2.09 Mb
spareparts 6 ms 0.42 Mb
ps_mbo 22 ms 2.40 Mb
magiczoomplus 11 ms 1.03 Mb
ps_emailsubscription 8 ms 0.77 Mb
blockreassurance 2 ms 0.17 Mb
ps_emailalerts 3 ms 0.33 Mb
ps_socialfollow 2 ms 0.12 Mb
ps_imageslider 2 ms 0.21 Mb
pm_advancedtopmenu 104 ms 5.11 Mb
ps_searchbar 1 ms 0.07 Mb
paypal 17 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 7 ms 0.65 Mb
ps_customeraccountlinks 2 ms 0.20 Mb
statsdata 6 ms 0.43 Mb
21 module(s) 234 ms 16.37 Mb

Stopwatch SQL - 317 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`
3546 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`)
3377 ms 854 /classes/Configuration.php:160
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
2744 ms 364 /classes/Hook.php:494
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
2605 ms 0 /classes/Hook.php:1233
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`
1480 ms 16 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atp.*, atpl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name,
ccl.name as cms_category_name
FROM `ps3i_pm_advancedtopmenu` atp
LEFT JOIN `ps3i_pm_advancedtopmenu_lang` atpl ON (atp.`id_menu` = atpl.`id_menu` AND atpl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atp.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1 AND 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = atp.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1 AND 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atp.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atp.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1 AND 1)
LEFT JOIN `ps3i_supplier` s ON (atp.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1 AND 1)
WHERE atp.`active` = 1 AND (atp.`active_desktop` = 1 || atp.`active_mobile` = 1)
AND ((atp.`id_manufacturer` = 0 AND atp.`id_supplier` = 0 AND atp.`id_category` = 0 AND atp.`id_cms` = 0 AND atp.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND IF (atp.`id_category` IS NULL OR atp.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atp.`id_menu`
ORDER BY atp.`position`
1402 ms 7 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:320
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 2
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1381 ms 11 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
1331 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`
1323 ms 9 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` = 4796
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
1284 ms 1 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` = 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`
1265 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` = 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`
1237 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` = 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`
1211 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 71
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1205 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 30
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1203 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` = 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`
1195 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`
1177 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`
1173 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` = 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`
1160 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` = 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`
1158 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 37
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1155 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` = 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`
1152 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`
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`
1140 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` = 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`
1121 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 29
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1108 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` = 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`
1080 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` = 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`
1070 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`
1059 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` = 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`
1058 ms 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps3i_hook`
1041 ms 764 /classes/Hook.php:1233
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`
1034 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 5
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1033 ms 6 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 39
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1033 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` = 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`
1033 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`
1011 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 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`
1008 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` = 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`
1001 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 33
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
984 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`
978 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`
974 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`
971 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 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`
964 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` = 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`
964 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`
963 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`
962 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`
956 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`
956 ms 3 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 68
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
952 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
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` = 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`
946 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
946 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
944 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`
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` = 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`
942 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 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`
942 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
940 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
938 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`
938 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`
932 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
930 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`
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` = 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`
925 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`
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` = 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`
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` = 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`
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` = 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`
917 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`
912 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
905 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
901 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` = 4796 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
898 ms 1 Yes /classes/Product.php:4631
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`
891 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 13
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
891 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`
888 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`
884 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`
841 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps3i_category` c
INNER JOIN ps3i_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps3i_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 406
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
779 ms 1 Yes Yes /classes/Category.php:919
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` = 4796
760 ms 1 /classes/Product.php:7427
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
635 ms 19 Yes Yes /classes/Category.php:1146
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` = 4796
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 9216 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
618 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` = 4796
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 9216 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
607 ms 1 Yes Yes /classes/Product.php:4541
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
581 ms 68 /classes/module/Module.php:340
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` = 4796
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 9216 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
575 ms 1 Yes Yes /classes/Product.php:4541
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
545 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
537 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
526 ms 68 /classes/module/Module.php:340
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps3i_meta` m
LEFT JOIN `ps3i_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
512 ms 27 Yes /classes/Dispatcher.php:643
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` = 4796
502 ms 1 /classes/Product.php:7427
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
486 ms 1 Yes /classes/shop/Shop.php:711
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` = 4796
AND pac.`id_product_attribute` = 9216
AND agl.`id_lang` = 1
486 ms 1 /classes/Product.php:7398
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
466 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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` = 4796 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` = 4796 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
457 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
431 ms 1 /classes/CartRule.php:383
(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
417 ms 1 /classes/CartRule.php:383
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
414 ms 1 Yes /classes/shop/Shop.php:1350
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` = 9216
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4796 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` = 9216
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4796 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
410 ms 0 /classes/Cart.php:1426
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
408 ms 1 /classes/Language.php:1198
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` = 4796
ORDER BY `position`
384 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `name`, `value`, `block` FROM `ps3i_magiczoomplus_settings` WHERE `enabled`=1
381 ms 595 /modules/magiczoomplus/magiczoomplus.php:539
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a0
LEFT JOIN `ps3i_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 504) AND (a0.`nright` > 505) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
375 ms 253 /classes/PrestaShopCollection.php:381
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` = 4796)
368 ms 1 /classes/Product.php:3820
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
367 ms 1 Yes /classes/SpecificPrice.php:624
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` = 4796) AND (b.`id_shop` = 1) LIMIT 1
355 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps3i_feature_product pf
LEFT JOIN ps3i_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps3i_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps3i_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps3i_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4796
ORDER BY f.position ASC
345 ms 4 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps3i_tab`
342 ms 169 /classes/Tab.php:359
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` = 406) AND (b.`id_shop` = 1) LIMIT 1
324 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
322 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
317 ms 2 /classes/Meta.php:190
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 = 4796 LIMIT 1
316 ms 1 /classes/Product.php:1037
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
315 ms 81 /classes/SpecificPrice.php:287
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 = 4796
AND DATEDIFF("2025-01-15 00:00:00", product_shop.`date_add`) < 200 LIMIT 1
308 ms 0 /classes/Product.php:1647
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`
307 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
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
306 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`
FROM `ps3i_hook`
WHERE `id_hook` = 699 LIMIT 1
298 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE *
FROM `ps3i_manufacturer` a
LEFT JOIN `ps3i_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps3i_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 5) LIMIT 1
298 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 (9216) AND il.`id_lang` = 1 ORDER by i.`position`
296 ms 1 Yes /classes/Product.php:2894
SELECT SQL_NO_CACHE name, alias FROM `ps3i_hook_alias`
290 ms 88 /classes/Hook.php:343
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
287 ms 1 /src/Adapter/EntityMapper.php:76
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
286 ms 1 /src/Adapter/EntityMapper.php:76
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` = 4796 AND ctg.`id_group` = 1 LIMIT 1
280 ms 1 /classes/Product.php:6615
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` = 9216) LIMIT 1
280 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps3i_hook_alias`
280 ms 88 /classes/Hook.php:291
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
279 ms 9 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
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
273 ms 4 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE `id_guest`
FROM `ps3i_connections`
WHERE `id_guest` = 62282
AND `date_add` > '2025-01-15 03:33:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
272 ms 1 Yes /classes/Connection.php:154
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
270 ms 1 /classes/shop/Shop.php:205
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`
269 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
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)
269 ms 1 /classes/Language.php:1049
SELECT SQL_NO_CACHE *
FROM `ps3i_currency` a
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 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 = 4796 LIMIT 1
267 ms 1 /classes/Product.php:1051
SELECT SQL_NO_CACHE * FROM `ps3i_currency` c ORDER BY `iso_code` ASC
266 ms 1 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps3i_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
265 ms 1 /classes/shop/ShopUrl.php:182
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
262 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE a.* 
FROM `ps3i_spareparts_category_product` a
WHERE a.`id_product`=4796
GROUP BY a.`id_category` 
ORDER BY a.`number` ASC
LIMIT 10
261 ms 1 Yes Yes /modules/spareparts/classes/SparePartsClass.php:208
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')
261 ms 1 /classes/ObjectModel.php:578
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
258 ms 0 /classes/tax/TaxRulesTaxManager.php:109
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
255 ms 2 /classes/Meta.php:190
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
251 ms 1 /classes/Cart.php:4215
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
248 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 4
ORDER BY atmcw.`position`
246 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 3
ORDER BY atmcw.`position`
245 ms 3 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE `id_order`
FROM `ps3i_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
240 ms 1 /classes/order/Order.php:1203
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
238 ms 1 Yes /classes/Language.php:974
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`=4796
236 ms 1 /classes/Tag.php:229
SELECT SQL_NO_CACHE `id_country`
FROM `ps3i_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
226 ms 1 /classes/Country.php:193
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 (4796)
ORDER BY o.id_order DESC
LIMIT 400
219 ms 1 Yes /modules/ps_crossselling/ps_crossselling.php:257
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps3i_stock_available`
WHERE (id_product = 4796) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
219 ms 1 /classes/stock/StockAvailable.php:453
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`
217 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
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`
216 ms 4 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
SELECT SQL_NO_CACHE *
FROM `ps3i_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
215 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
214 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps3i_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 1)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 9
ORDER BY atmcw.`position`
214 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
214 ms 7 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
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
213 ms 0 /src/Adapter/Module/ModuleDataProvider.php:174
SELECT SQL_NO_CACHE value FROM `ps3i_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
211 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE 1 FROM `ps3i_specific_price` WHERE id_product = 0 LIMIT 1
209 ms 1 /classes/SpecificPrice.php:411
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
206 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerInitBefore") LIMIT 1
205 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_currency_lang`
WHERE `id_currency` = 1
202 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `ps3i_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
202 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerInitAfter") LIMIT 1
202 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_lang` FROM `ps3i_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
200 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
199 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps3i_specific_price` WHERE `id_product` != 0
199 ms 9 /classes/SpecificPrice.php:295
SELECT SQL_NO_CACHE *
FROM `ps3i_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
199 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
198 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
198 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps3i_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 406 LIMIT 1
198 ms 1 /classes/Category.php:1371
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` = 4796 AND pa.`id_product` = 4796 AND pa.`id_product_attribute` = 9216 LIMIT 1
197 ms 1 /classes/Product.php:1135
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcherBefore") LIMIT 1
195 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_country_lang`
WHERE `id_country` = 8
194 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE c.id_currency
FROM `ps3i_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
191 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE * FROM `ps3i_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
190 ms 9 Yes /classes/ImageType.php:109
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` = 4796
AND image_shop.`cover` = 1 LIMIT 1
189 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps3i_product_attribute`
WHERE `id_product` = 4796
189 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE *
FROM `ps3i_tax_lang`
WHERE `id_tax` = 1
189 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProduct") LIMIT 1
187 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps3i_stock_available`
WHERE (id_product = 4796) AND (id_product_attribute = 9216) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
187 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE id_page_type
FROM ps3i_page_type
WHERE name = 'product' LIMIT 1
186 ms 1 /classes/Page.php:104
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
186 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps3i_category` c
WHERE (c.`id_category` = 2) LIMIT 1
186 ms 1 /classes/Category.php:1957
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
186 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_categorytree" LIMIT 1
185 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
185 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_group_lang`
WHERE `id_group` = 1
184 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE 1 FROM `ps3i_specific_price` WHERE id_product = 4796 LIMIT 1
183 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE `iso_code`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
183 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
183 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionBuildFrontEndObject") LIMIT 1
182 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 1 FROM `ps3i_specific_price` WHERE `from` BETWEEN '2025-01-15 00:00:00' AND '2025-01-15 23:59:59' LIMIT 1
182 ms 1 /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_lang` FROM `ps3i_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
180 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE id_shop
FROM `ps3i_product_shop`
WHERE `id_product` = 4796
AND id_shop = 1 LIMIT 1
180 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE id_shop
FROM `ps3i_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
179 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
178 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE out_of_stock
FROM `ps3i_stock_available`
WHERE (id_product = 4796) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
178 ms 1 /classes/stock/StockAvailable.php:769
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 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
177 ms 1 /classes/Currency.php:1126
SELECT SQL_NO_CACHE * FROM `ps3i_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
177 ms 9 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayContentWrapperTop") LIMIT 1
176 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "moduleRoutes") LIMIT 1
175 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
175 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `name` FROM `ps3i_supplier` WHERE `id_supplier` = 0 LIMIT 1
174 ms 0 /classes/Supplier.php:244
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerSetMedia") LIMIT 1
174 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_sharebuttons" LIMIT 1
173 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `ps3i_product_group_reduction_cache`
WHERE `id_product` = 4796 AND `id_group` = 1 LIMIT 1
171 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_crossselling" LIMIT 1
170 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
169 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `name`
FROM `ps3i_hook`
WHERE `id_hook` = 820 LIMIT 1
167 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionProductOutOfStock") LIMIT 1
167 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_shop
FROM `ps3i_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
165 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE id_shop
FROM `ps3i_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
165 ms 1 /classes/ObjectModel.php:1647
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
165 ms 1 /classes/Meta.php:190
SELECT SQL_NO_CACHE `id_page`
FROM `ps3i_page`
WHERE `id_page_type` = 12 AND `id_object` = 4796 LIMIT 1
165 ms 1 /classes/Page.php:83
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterBodyOpeningTag") LIMIT 1
164 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block_lang`
WHERE `id_link_block` = 2
164 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerSetVariables") LIMIT 1
164 ms 1 /classes/Hook.php:1270
INSERT INTO `ps3i_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('62282', '1775', '308350554', '', '1', '1', '2025-01-15 04:03:53')
162 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayContentWrapperBottom") LIMIT 1
162 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps3i_product_shop`
WHERE `id_product` = 4796 AND id_shop=1 LIMIT 1
159 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_columns_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
158 ms 51 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE * FROM `ps3i_hook_module_exceptions`
WHERE `id_shop` IN (1)
155 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterTitleTag") LIMIT 1
155 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `name`
FROM `ps3i_manufacturer`
WHERE `id_manufacturer` = 5
AND `active` = 1 LIMIT 1
154 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps3i_stock_available`
WHERE (id_product = 4796) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
153 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE id_shop
FROM `ps3i_category_shop`
WHERE `id_category` = 406
AND id_shop = 1 LIMIT 1
152 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE location
FROM `ps3i_stock_available`
WHERE (id_product = 4796) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
152 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterProductContent") LIMIT 1
152 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentCart") LIMIT 1
150 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
149 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductAdditionalInfo") LIMIT 1
149 ms 1 /classes/Hook.php:1270
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
148 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionOutputHTMLBefore") LIMIT 1
146 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE location
FROM `ps3i_stock_available`
WHERE (id_product = 4796) AND (id_product_attribute = 9216) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
146 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
145 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE psgdpr.active FROM `ps3i_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 22 LIMIT 1
143 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
143 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayMyAccountBlock") LIMIT 1
140 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
140 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayAfterProductThumbs") LIMIT 1
139 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
139 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayTop") LIMIT 1
138 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionControllerInitBefore") LIMIT 1
138 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_order`
FROM `ps3i_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
138 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
138 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 2 AND `id_shop` = 1
137 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
137 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
137 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooter") LIMIT 1
137 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductActions") LIMIT 1
133 ms 1 /classes/Hook.php:1270