Kits Cylindre / Piston

Il y a 3 produits.

Affichage 1-3 de 3 article(s)
Load Time 414 ms
Querying Time 143 ms
Queries 332
Memory Peak Usage 43.2 Mb
Included Files 978 files - 10.18 Mb
PrestaShop Cache - Mb
Global vars 0.51 Mb
PrestaShop Version 1.7.8.0
PHP Version 7.4.33
MySQL Version 10.6.20-MariaDB
Memory Limit 512M
Max Execution Time 360s
Smarty Cache disabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 23 ms 23 ms 16.94 Mb 18.1 Mb
__construct 0 ms 23 ms - Mb 18.1 Mb
init 97 ms 120 ms 8.75 Mb 26.8 Mb
checkAccess 0 ms 120 ms - Mb 26.8 Mb
setMedia 8 ms 128 ms 0.84 Mb 26.8 Mb
postProcess 0 ms 128 ms - Mb 26.8 Mb
initHeader 0 ms 128 ms - Mb 26.8 Mb
initContent 123 ms 250 ms 9.55 Mb 36.1 Mb
initFooter 0 ms 250 ms - Mb 36.1 Mb
display 164 ms 414 ms 6.92 Mb 43.2 Mb
Hook Time Memory Usage
DisplayTop 100 ms 2.74 Mb
Header 12 ms 0.95 Mb
displayFooter 12 ms 0.75 Mb
displayFooterBefore 7 ms 0.49 Mb
DisplayBeforeBodyClosingTag 7 ms 0.48 Mb
DisplayNavFullWidth 2 ms 0.09 Mb
displayNav2 2 ms 0.15 Mb
DisplayHeader 2 ms 0.04 Mb
ActionFrontControllerSetMedia 1 ms 0.14 Mb
displayNav1 1 ms 0.07 Mb
DisplayGDPRConsent 1 ms 0.04 Mb
DisplayMyAccountBlock 0 ms 0.01 Mb
ActionDispatcherBefore 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
ModuleRoutes 0 ms - Mb
Footer 0 ms - Mb
ActionDispatcher 0 ms - Mb
19 hook(s) 148 ms 5.97 Mb
Module Time Memory Usage
colissimo 19 ms 2.09 Mb
spareparts 5 ms 0.37 Mb
ps_mbo 14 ms 2.40 Mb
magiczoomplus 8 ms 1.10 Mb
ps_emailsubscription 9 ms 0.77 Mb
blockreassurance 1 ms 0.09 Mb
ps_emailalerts 3 ms 0.33 Mb
ps_socialfollow 2 ms 0.15 Mb
ps_imageslider 2 ms 0.21 Mb
pm_advancedtopmenu 113 ms 4.12 Mb
ps_searchbar 1 ms 0.08 Mb
paypal 21 ms 2.66 Mb
ps_shoppingcart 1 ms 0.09 Mb
ps_contactinfo 3 ms 0.17 Mb
ps_customersignin 1 ms 0.08 Mb
psgdpr 4 ms 0.30 Mb
ps_linklist 10 ms 0.69 Mb
ps_customeraccountlinks 3 ms 0.14 Mb
statsdata 8 ms 0.53 Mb
19 module(s) 229 ms 16.36 Mb

Stopwatch SQL - 332 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`
3344 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`)
3236 ms 854 /classes/Configuration.php:160
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`
1942 ms 7 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:320
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
1831 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`
1785 ms 16 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
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
1676 ms 364 /classes/Hook.php:494
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`
1603 ms 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 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`
1520 ms 7 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 2
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1494 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`
1484 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` = 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`
1477 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` = 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`
1457 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 3
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1418 ms 3 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` = 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`
1354 ms 3 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 10
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1322 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` = 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`
1304 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` = 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`
1293 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` = 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`
1283 ms 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 7
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
1280 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` = 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`
1260 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` = 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`
1236 ms 15 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, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-01-15 00:00:00",
INTERVAL 200 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps3i_category_product` cp
LEFT JOIN `ps3i_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps3i_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps3i_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps3i_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps3i_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps3i_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps3i_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps3i_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps3i_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 541 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,40
1216 ms 3 /classes/Category.php:1057
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`
1213 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` = 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`
1212 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` = 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`
1211 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` = 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`
1197 ms 10 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 50
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1191 ms 10 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 51
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1171 ms 9 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 43
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1167 ms 5 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` = 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`
1163 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` = 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`
1162 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`
1157 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` = 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`
1146 ms 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 42
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1137 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 30
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
1136 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
1114 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` = 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`
1112 ms 4 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
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` = 541
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1089 ms 6 Yes Yes /classes/Category.php:919
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`
1084 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` = 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`
1072 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` = 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`
1014 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` = 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`
1013 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`
1005 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 9
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
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`
968 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`
965 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`
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` = 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`
954 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`
951 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`
947 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 7
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
945 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
941 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`
937 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 12
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0 AND ate.`id_cms_category` = 0)
OR c.id_cms IS NOT NULL OR cc.id_cms_category IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
936 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
936 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
935 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`
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` = 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`
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` = 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`
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` = 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`
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` = 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`
921 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`
921 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`
921 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`
921 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`
920 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
920 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
918 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
916 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
914 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps3i_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_cms_category cc ON (cc.id_cms_category = ate.`id_cms_category`)
LEFT JOIN ps3i_cms_category_shop cms_category_shop
ON (cms_category_shop.id_cms_category = cc.id_cms_category AND cms_category_shop.id_shop = 1)
LEFT JOIN ps3i_cms_category_lang ccl ON (cc.id_cms_category = ccl.id_cms_category AND ccl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 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`
912 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`
912 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`
908 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` = 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`
895 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:205
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps3i_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps3i_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 1)
LEFT JOIN ps3i_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps3i_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN ps3i_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
LEFT JOIN ps3i_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps3i_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps3i_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 1 )
LEFT JOIN `ps3i_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps3i_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `ps3i_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps3i_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 12
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
892 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps3i_hook`
881 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` = 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`
881 ms 1 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:271
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-15 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps3i_product p
LEFT JOIN ps3i_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps3i_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps3i_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1173
LIMIT 1
646 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps3i_category` c
LEFT JOIN `ps3i_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 366 AND c.`nright` >= 379 AND c.`nleft` >= 2 AND c.`nright` <= 3257 ORDER BY `nleft` DESC
633 ms 184 /classes/Category.php:1586
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-15 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps3i_product p
LEFT JOIN ps3i_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps3i_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps3i_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1174
LIMIT 1
603 ms 1 /classes/ProductAssembler.php:95
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
591 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
554 ms 27 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps3i_module` m
LEFT JOIN `ps3i_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
552 ms 68 /classes/module/Module.php:340
(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
537 ms 1 /classes/CartRule.php:383
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
530 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
516 ms 68 /classes/module/Module.php:340
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-15 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps3i_product p
LEFT JOIN ps3i_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps3i_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps3i_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1175
LIMIT 1
508 ms 1 /classes/ProductAssembler.php:95
(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
493 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps3i_product_attribute` pa
INNER JOIN ps3i_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps3i_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1175) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
489 ms 1 Yes Yes /classes/Product.php:4479
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
472 ms 1 Yes /classes/shop/Shop.php:711
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` = 1175 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` = 1175 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
451 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps3i_shop_url su
LEFT JOIN ps3i_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.itech-equipement.fr' OR su.domain_ssl = 'www.itech-equipement.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
430 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE `name`, `value`, `block` FROM `ps3i_magiczoomplus_settings` WHERE `enabled`=1
414 ms 595 /modules/magiczoomplus/magiczoomplus.php:539
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` = 1173 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` = 1173 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
409 ms 0 /classes/Cart.php:1426
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` = 1174 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` = 1174 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
409 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps3i_product_attribute` pa
INNER JOIN ps3i_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps3i_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1174) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
408 ms 1 Yes Yes /classes/Product.php:4479
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 = 1175
ORDER BY f.position ASC
404 ms 4 Yes /classes/Product.php:5897
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`
403 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
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
398 ms 1 /classes/Language.php:1198
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps3i_product_attribute` pa
INNER JOIN ps3i_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps3i_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps3i_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps3i_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps3i_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1173) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
393 ms 1 Yes Yes /classes/Product.php:4479
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`
383 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`
380 ms 3 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
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` = 1175) AND (b.`id_shop` = 1) LIMIT 1
377 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_product` a
LEFT JOIN `ps3i_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps3i_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1174) AND (b.`id_shop` = 1) LIMIT 1
366 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`
350 ms 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps3i_image` i
INNER JOIN ps3i_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps3i_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1175
ORDER BY `position`
349 ms 1 Yes /classes/Product.php:3508
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` = 1173
ORDER BY `position`
349 ms 1 Yes /classes/Product.php:3508
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` = 1173) AND (b.`id_shop` = 1) LIMIT 1
343 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
342 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a
LEFT JOIN `ps3i_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps3i_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 542) AND (b.`id_shop` = 1) LIMIT 1
339 ms 1 /src/Adapter/EntityMapper.php:76
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
338 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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
331 ms 1 /classes/Cart.php:4215
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a0
LEFT JOIN `ps3i_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 366) AND (a0.`nright` > 379) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
324 ms 184 /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE *
FROM ps3i_meta m
LEFT JOIN ps3i_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
317 ms 2 /classes/Meta.php:190
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 = 1174
ORDER BY f.position ASC
308 ms 4 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps3i_category` c
LEFT JOIN `ps3i_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
306 ms 1 /classes/Category.php:2233
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 = 1173
ORDER BY f.position ASC
305 ms 4 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a
LEFT JOIN `ps3i_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps3i_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 541) AND (b.`id_shop` = 1) LIMIT 1
298 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` = 9
ORDER BY atmcw.`position`
291 ms 1 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` = 5
ORDER BY atmcw.`position`
288 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:133
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps3i_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
285 ms 1 /classes/shop/ShopUrl.php:182
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` = 547) AND (b.`id_shop` = 1) LIMIT 1
283 ms 1 /src/Adapter/EntityMapper.php:76
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` = 1174
ORDER BY `position`
281 ms 1 Yes /classes/Product.php:3508
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` = 543) AND (b.`id_shop` = 1) LIMIT 1
281 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_country` a
LEFT JOIN `ps3i_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps3i_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
281 ms 1 /src/Adapter/EntityMapper.php:76
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` = 544) AND (b.`id_shop` = 1) LIMIT 1
279 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps3i_link_block lb
INNER JOIN ps3i_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 41 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
278 ms 4 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
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` = 545) AND (b.`id_shop` = 1) LIMIT 1
277 ms 1 /src/Adapter/EntityMapper.php:76
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` = 546) AND (b.`id_shop` = 1) LIMIT 1
274 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
FROM `ps3i_product` p
INNER JOIN ps3i_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps3i_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 541 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
268 ms 3 /classes/Category.php:986
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
267 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_guest`
FROM `ps3i_connections`
WHERE `id_guest` = 62114
AND `date_add` > '2025-01-15 02:35:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
262 ms 1 Yes /classes/Connection.php:154
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
257 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE name, alias FROM `ps3i_hook_alias`
257 ms 88 /classes/Hook.php:343
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` = 1174)
255 ms 1 /classes/Product.php:3820
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)
255 ms 1 /classes/Language.php:1049
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
253 ms 1 /classes/shop/Shop.php:205
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
250 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `ps3i_currency` c ORDER BY `iso_code` ASC
247 ms 1 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE * FROM `ps3i_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
246 ms 9 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps3i_hook_alias`
245 ms 88 /classes/Hook.php:291
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` = 1173)
244 ms 1 /classes/Product.php:3820
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')
244 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE *
FROM `ps3i_lang` a
LEFT JOIN `ps3i_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
243 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 = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
239 ms 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps3i_product` p
INNER JOIN `ps3i_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps3i_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1175)
237 ms 1 /classes/Product.php:3820
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
235 ms 1 Yes /classes/Language.php:974
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
234 ms 2 /classes/Meta.php:190
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
233 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_category` a
LEFT JOIN `ps3i_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps3i_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
233 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
228 ms 7 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE `id_country`
FROM `ps3i_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
220 ms 1 /classes/Country.php:193
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` = 1175
AND image_shop.`cover` = 1 LIMIT 1
215 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
211 ms 1 /classes/Hook.php:1270
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` = 1174
AND image_shop.`cover` = 1 LIMIT 1
208 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE 1 FROM `ps3i_specific_price` WHERE id_product = 0 LIMIT 1
206 ms 1 /classes/SpecificPrice.php:411
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerInitAfter") LIMIT 1
205 ms 1 /classes/Hook.php:1270
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
205 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
205 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE `name`
FROM `ps3i_hook`
WHERE `id_hook` = 699 LIMIT 1
204 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
203 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterBefore") LIMIT 1
202 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_elements_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
202 ms 152 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
201 ms 1 /src/Adapter/EntityMapper.php:84
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
200 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 = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
200 ms 1 /classes/Meta.php:190
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
198 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `iso_code`
FROM `ps3i_country`
WHERE `id_country` = 8 LIMIT 1
197 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayContentWrapperTop") LIMIT 1
197 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
195 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
192 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `ps3i_group_lang`
WHERE `id_group` = 1
191 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayMyAccountBlock") LIMIT 1
190 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE format
FROM `ps3i_address_format`
WHERE `id_country` = 8 LIMIT 1
190 ms 1 /classes/AddressFormat.php:672
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
189 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE psgdpr.active FROM `ps3i_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 22 LIMIT 1
188 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
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` = 1173
AND image_shop.`cover` = 1 LIMIT 1
188 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_module` FROM `ps3i_module` WHERE `name` = "ps_linklist" LIMIT 1
187 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayNewsletterRegistration") LIMIT 1
187 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
186 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "productSearchProvider") LIMIT 1
185 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
184 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps3i_product_shop`
WHERE `id_product` = 1175 AND id_shop=1 LIMIT 1
184 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterCategory") LIMIT 1
184 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionBuildFrontEndObject") LIMIT 1
183 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps3i_required_field
179 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE `id_order`
FROM `ps3i_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
179 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
179 ms 0 /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
178 ms 1 /classes/Currency.php:1126
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps3i_product_attribute`
WHERE `id_product` = 1173
177 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE *
FROM `ps3i_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
176 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionDispatcherBefore") LIMIT 1
175 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE value FROM `ps3i_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
174 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE `id_page`
FROM `ps3i_page`
WHERE `id_page_type` = 4 AND `id_object` = 541 LIMIT 1
174 ms 1 /classes/Page.php:83
SELECT SQL_NO_CACHE `reduction`
FROM `ps3i_product_group_reduction_cache`
WHERE `id_product` = 1175 AND `id_group` = 1 LIMIT 1
174 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `ps3i_cms_lang`
WHERE `id_cms` = 2 AND `id_shop` = 1
173 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionFrontControllerSetMedia") LIMIT 1
171 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentCart") LIMIT 1
168 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
167 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
167 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 ('62114', '430', '308350554', '', '1', '1', '2025-01-15 03:05:14')
167 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
166 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
165 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "moduleRoutes") LIMIT 1
164 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
164 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps3i_category_group ctg
WHERE ctg.`id_category` = 541 AND ctg.`id_group` = 1 LIMIT 1
162 ms 1 /classes/Category.php:1730
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
162 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayFooter") LIMIT 1
161 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
160 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps3i_product_attribute`
WHERE `id_product` = 1175
160 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayHeaderCategory") LIMIT 1
160 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
159 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block` a
LEFT JOIN `ps3i_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 2) LIMIT 1
158 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps3i_currency_lang`
WHERE `id_currency` = 1
158 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "filterProductSearch") LIMIT 1
156 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `image_type`
FROM `ps3i_pm_advancedtopmenu_columns_lang`
WHERE `image_type` NOT IN ("jpg", "png", "gif")
AND `id_lang` = 1
155 ms 51 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php:5799
SELECT SQL_NO_CACHE *
FROM `ps3i_link_block_lang`
WHERE `id_link_block` = 1
155 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps3i_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
154 ms 1