Sanicompact

Sanicompact

Sanicompact is the first all-in-one macerating toilet suite. Adding a toilet is now as easy as one product. The compact design enables a toilet to be added anywhere, making Sanicompact ideal for a powder room or laundry addition , where plumbing is not immediately available.

  • Ability to add a basin
  • 240v plug connection
  • Low water usage

--------------

--------------

NZ$0.00


Application

  • Toilet
  • Wash hand basin
Product sheet

The Sanicompact is a compact toilet suite with built-in macerator and an additional inlet so you can install a hand basin for a complete toilet even in the smallest space. The Sanicompact requires 1.7 bar dynamic incoming water pressure (i.e. measured whilst the water is flowing into the Sanicompact and not static pressure). The Sanicompact...

See more

Sanicompact 43 datasheet

Dimensions l x w x h (mm)
390 x 430 x 445

Sanicompact
Number of entries 1
Maximum flow rate 105 L/min
Inlet pipework 40 mm
Discharge pipework 32 mm
Motor power 550 W
Voltage 220-240 V
Frequency 50 Hz
Electrical class I
Noise level 51 dB(A)
Discharge length 30 m
Max. head (Q0) 3 m
Options Optional Sink
Sanicompact

Sanicompact

  • Toilet
  • Wash hand basin
Product sheet
Load Time511 ms - Unicorn powered webserver!
Querying Time120 ms
Queries441
Memory Peak Usage69.0 Mb
Included Files886 files - 13.54 Mb
PrestaShop Cache- Mb
Global vars0.47 Mb
PrestaShop Version1.7.5.2
PHP Version7.2.34 (OK)
MySQL Version10.5.17-MariaDB (OK)
Memory Limit256M
Max Execution Time30s
Smarty Cachedisabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 131 ms 131 ms 24.09 Mb 24.39 Mb
__construct 0 ms 131 ms - Mb 24.39 Mb
init 55 ms 186 ms 6.99 Mb 31.31 Mb
checkAccess 0 ms 186 ms - Mb 31.31 Mb
setMedia 0 ms 186 ms 0.01 Mb 31.31 Mb
postProcess 0 ms 186 ms - Mb 31.31 Mb
initHeader 0 ms 186 ms - Mb 31.31 Mb
initContent 93 ms 279 ms 11.57 Mb 42.78 Mb
initFooter 0 ms 279 ms - Mb 42.78 Mb
display 232 ms 511 ms 26.18 Mb 69.02 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 441 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE `id_guest`
FROM `sfa_connections`
WHERE `id_guest` = 9850601
AND `date_add` > '2024-12-10 22:03:00'
AND id_shop IN (3) 
ORDER BY `date_add` DESC LIMIT 1
 10.6 32589 Yes /classes/Connection.php:163 
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 `sfa_configuration` c
LEFT JOIN `sfa_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 5.2 2980 /classes/Configuration.php:160 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `sfa_module` m
INNER JOIN sfa_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 3 AND module_shop.enable_device & 1)
INNER JOIN `sfa_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `sfa_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `sfa_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `sfa_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 3) AND (mg.`id_shop` = 3 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 2.9 1308 Yes Yes /override/classes/Hook.php:116 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `sfa_module` m
INNER JOIN sfa_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 3 AND module_shop.enable_device & 1)
INNER JOIN `sfa_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `sfa_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `sfa_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `sfa_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 3) AND (mg.id_shop = 3 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 2.7 1308 Yes Yes /classes/Hook.php:666 
SELECT SQL_NO_CACHE *
FROM `sfa_prestablog_news_lang`
WHERE `id_prestablog_news` = 31
 1.7 3 /src/Adapter/EntityMapper.php:82 
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, active
FROM `sfa_hook_module` hm
STRAIGHT_JOIN `sfa_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 3)
STRAIGHT_JOIN `sfa_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 1.1 345 /classes/Hook.php:403 
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
FROM `sfa_pm_advancedtopmenu` atp
INNER JOIN `sfa_pm_advancedtopmenu_shop` atp_shop
ON atp_shop.id_menu = atp.id_menu
AND atp_shop.id_shop IN (3) 
LEFT JOIN `sfa_pm_advancedtopmenu_lang` atpl ON (atp.`id_menu` = atpl.`id_menu` AND atpl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atp.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3 AND 1)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atp.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atp.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3 AND 1)
LEFT JOIN `sfa_supplier` s ON (atp.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3 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)
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 (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`
 1 205 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:244 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 463)
ORDER BY f.position ASC
 0.9 14 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 52
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`
 0.8 20 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 467)
ORDER BY f.position ASC
 0.8 14 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 53
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`
 0.7 20 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 300
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.7 15 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE *
FROM `sfa_customfields123_product` a
LEFT JOIN `sfa_customfields123_product_lang` `b` ON a.`id_customfields123_product` = b.`id_customfields123_product` AND b.`id_lang` = 2
LEFT JOIN `sfa_customfields123_product_shop` `c` ON a.`id_customfields123_product` = c.`id_customfields123_product` AND c.`id_shop` = 3
WHERE (a.`id_customfields123_product` = 69) AND (b.`id_shop` = 3) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 47
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`
 0.7 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 48
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`
 0.7 25 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 1022)
ORDER BY f.position ASC
 0.7 14 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 150
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`
 0.7 25 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `sfa_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `sfa_hook_alias` ha
INNER JOIN `sfa_hook` h ON ha.name = h.name
 0.7 0 /classes/Hook.php:190 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 112
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.7 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 57
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`
 0.7 20 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-10 00:00:00",
INTERVAL 100 DAY
)
) > 0 AS new
FROM `sfa_accessory`
LEFT JOIN `sfa_product` p ON p.`id_product` = `id_product_2`
INNER JOIN sfa_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `sfa_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=3)
LEFT JOIN `sfa_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 3 
)
LEFT JOIN `sfa_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 3 
)
LEFT JOIN `sfa_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=3)
LEFT JOIN `sfa_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `sfa_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN sfa_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
WHERE `id_product_1` = 74 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.6 1 Yes /classes/Product.php:4003 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 151
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`
 0.6 15 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 64
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`
 0.6 10 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 146
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`
 0.6 15 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 56
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`
 0.6 20 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 155
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 59
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 227
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 60
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`
 0.6 20 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 51
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 63
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 152
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 285
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 55
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 61
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`
 0.6 15 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 66
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 148
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 58
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 83
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 62
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 149
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 349
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 316
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 293
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 287
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 149
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 99
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 105
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 220
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 109
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 104
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 115
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 96
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 315
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 301
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 298
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 110
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 256
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 295
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 317
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification_feature` a
WHERE (a.`id_classification_feature` = 25801) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 95
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 248
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 320
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 244
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 230
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 319
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 101
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 286
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 294
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 340
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 347
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 290
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_elements` ate
LEFT JOIN `sfa_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 111
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`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 (cms_shop.`id_shop` = 3 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 3 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 3 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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 `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 3)
LEFT JOIN sfa_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
LEFT JOIN sfa_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN sfa_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 2 AND cal.id_shop = 3 )
LEFT JOIN `sfa_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN sfa_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 3)
LEFT JOIN `sfa_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN sfa_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 3)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 65
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`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification_feature` a
WHERE (a.`id_classification_feature` = 19561) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
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 `sfa_category` c
INNER JOIN sfa_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 3)
LEFT JOIN `sfa_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 3 )
LEFT JOIN `sfa_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 12
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:872 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification_feature` a
WHERE (a.`id_classification_feature` = 13531) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `sfa_product_attribute` pa
INNER JOIN sfa_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 3)
LEFT JOIN sfa_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `sfa_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `sfa_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `sfa_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `sfa_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `sfa_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN sfa_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 3)
WHERE pa.`id_product` = 74
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 0.5 1 Yes Yes /classes/Product.php:3915 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `sfa_meta` m
LEFT JOIN `sfa_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 3 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.5 61 Yes /classes/Dispatcher.php:636 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `sfa_meta` m
LEFT JOIN `sfa_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.5 61 Yes /classes/Dispatcher.php:636 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `sfa_meta` m
LEFT JOIN `sfa_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 5 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.4 61 Yes /classes/Dispatcher.php:636 
SELECT SQL_NO_CACHE *
FROM `sfa_advancedpopup`
INNER JOIN `sfa_advancedpopup_lang` ON `sfa_advancedpopup`.`id_advancedpopup` = `sfa_advancedpopup_lang`.`id_advancedpopup`
WHERE `id_shop` = 3 AND `id_lang` = 2 AND `active` = 1
AND (`date_init` <= "2024-12-10 22:33:01" OR `date_init` = "1970-01-01 10:00:00")
AND (`date_end` >= "2024-12-10 22:33:01" OR `date_end` = "1970-01-01 10:00:00")
AND (`customers` = ""
OR `customers` IS NULL
OR FIND_IN_SET("0", `customers`))
AND (`languages` = ""
OR `languages` IS NULL
OR FIND_IN_SET("2", `languages`))
AND (`display_ip_string` = ""
OR `display_ip_string` IS NULL
OR FIND_IN_SET("18.97.14.82", `display_ip_string`))
AND (`display_url_string` = ""
OR `display_url_string` IS NULL
OR INSTR("www.saniflo.co.nz/installing-a-toilet/74-sanicompact-43.html", `display_url_string`) > 0)
AND (`genders` = ""
OR `genders` IS NULL) AND (`groups` = ""
OR `groups` IS NULL  OR FIND_IN_SET(1, `groups`)) AND `display_desktop` = 1 AND (`cms` = ""
OR `cms` IS NULL) AND (`controller_exceptions` = ""
OR `controller_exceptions` IS NULL
OR FIND_IN_SET("product", `controller_exceptions`)) AND (`display_after_cart` = 1
OR (`products` = ""
OR `products` IS NULL
OR FIND_IN_SET(74, `products`))) AND (`categories` = ""
OR `categories` IS NULL  OR FIND_IN_SET(2, `categories`) OR FIND_IN_SET(12, `categories`) OR FIND_IN_SET(13, `categories`) OR FIND_IN_SET(72, `categories`)) AND (`display_after_cart` = 1
OR (`manufacturers` = ""
OR `manufacturers` IS NULL
OR FIND_IN_SET("0", `manufacturers`))) AND (`display_after_cart` = 1
OR (`suppliers` = ""
OR `suppliers` IS NULL
OR FIND_IN_SET("0", `suppliers`))) ORDER BY `priority` ASC;
 0.4 2 Yes /modules/advancedpopupcreator/classes/AdvancedPopup.php:421 
SELECT SQL_NO_CACHE name, value, pf.id_feature , fvl.id_feature_value as id_feature_value
FROM sfa_feature_product pf
LEFT JOIN sfa_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN sfa_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN sfa_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN sfa_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 74
ORDER BY f.position ASC
 0.4 14 Yes /override/classes/Product.php:37 
INSERT INTO `sfa_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')
 0.4 1 /classes/ObjectModel.php:551 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sfa_attribute` a
LEFT JOIN `sfa_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `sfa_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `sfa_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `sfa_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN sfa_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 3)
INNER JOIN sfa_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 3)
WHERE pa.`id_product` = 74
 0.4 1 /classes/Product.php:6203 
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 `sfa_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 74 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sfa_cart_product` cp JOIN `sfa_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sfa_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` = 74 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sfa_attribute` a
LEFT JOIN `sfa_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `sfa_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `sfa_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `sfa_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN sfa_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 3)
INNER JOIN sfa_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 3)
WHERE pa.`id_product` = 74
 0.4 1 /classes/Product.php:6203 
INSERT INTO `sfa_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('9850601', '38', '308350546', '', '3', '2', '2024-12-10 22:33:01')
 0.4 1 /classes/ObjectModel.php:551 
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 sfa_shop_group gs
LEFT JOIN sfa_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN sfa_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
 0.3 72 Yes /classes/shop/Shop.php:704 
SELECT SQL_NO_CACHE *
FROM `sfa_product` a
LEFT JOIN `sfa_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `sfa_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 74) AND (b.`id_shop` = 3) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM sfa_custombanners
WHERE hook_name = 'displayFooter'
AND id_shop = 3
AND id_lang = 2
AND active = 1
AND publish_from <= '2024-12-10 22:33:01'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-10 22:33:01')
ORDER BY position ASC
 0.3 5 Yes /modules/custombanners/custombanners.php:2037 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE * FROM sfa_custombanners
WHERE hook_name = 'displayNav1'
AND id_shop = 3
AND id_lang = 2
AND active = 1
AND publish_from <= '2024-12-10 22:33:00'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-10 22:33:00')
ORDER BY position ASC
 0.3 5 Yes /modules/custombanners/custombanners.php:2037 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE * FROM sfa_custombanners
WHERE hook_name = 'displayTop'
AND id_shop = 3
AND id_lang = 2
AND active = 1
AND publish_from <= '2024-12-10 22:33:00'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-10 22:33:00')
ORDER BY position ASC
 0.3 10 Yes /modules/custombanners/custombanners.php:2037 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `sfa_category` c
LEFT JOIN `sfa_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 3 )
INNER JOIN sfa_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 3)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.3 16 Yes Yes /classes/Category.php:1098 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE *
FROM `sfa_product` a
LEFT JOIN `sfa_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `sfa_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 74) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM sfa_shop_url su
LEFT JOIN sfa_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.saniflo.co.nz' OR su.domain_ssl = 'www.saniflo.co.nz')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.3 2 Yes /classes/shop/Shop.php:345 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sfa_image` i
INNER JOIN sfa_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 3)
LEFT JOIN `sfa_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 74
ORDER BY `position`
 0.3 17 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE *
FROM `sfa_product` a
LEFT JOIN `sfa_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `sfa_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 5
WHERE (a.`id_product` = 74) AND (b.`id_shop` = 5) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 3
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE a.id_ce_content as id FROM sfa_ce_content a
LEFT JOIN sfa_ce_content_lang AS b ON a.id_ce_content = b.id_ce_content
LEFT JOIN sfa_ce_content_shop sa ON sa.id_ce_content = a.id_ce_content AND sa.id_shop = b.id_shop
WHERE b.id_lang = 2 AND sa.id_shop = 3 AND a.hook LIKE 'displayAfterProductThumbs' AND a.active = 1 ORDER BY a.id_product, a.id_category DESC
 0.3 44 Yes /modules/creativeelements/classes/CEContent.php:153 
SELECT SQL_NO_CACHE a.id_ce_content as id FROM sfa_ce_content a
LEFT JOIN sfa_ce_content_lang AS b ON a.id_ce_content = b.id_ce_content
LEFT JOIN sfa_ce_content_shop sa ON sa.id_ce_content = a.id_ce_content AND sa.id_shop = b.id_shop
WHERE b.id_lang = 2 AND sa.id_shop = 3 AND a.hook LIKE 'displayRightColumnProduct' AND a.active = 1 ORDER BY a.id_product, a.id_category DESC
 0.2 44 Yes /modules/creativeelements/classes/CEContent.php:153 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `sfa_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `sfa_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 2)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 14
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
SELECT SQL_NO_CACHE id_classification
FROM `sfa_eg_featuretab_classification`
WHERE (`id_product` = 74) AND (`id_shop` = 3)
 0.2 25 /modules/eg_featuretab/src/Entity/Classification.php:94 
SELECT SQL_NO_CACHE *
FROM `sfa_product` a
LEFT JOIN `sfa_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 74) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_category` a0
LEFT JOIN `sfa_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 81) AND (a0.`nright` > 82) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
 0.2 256 Yes /classes/PrestaShopCollection.php:373 
SELECT SQL_NO_CACHE tr.*
FROM `sfa_tax_rule` tr
JOIN `sfa_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
 0.2 1 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_info%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sfa_attribute` a
LEFT JOIN `sfa_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `sfa_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sfa_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sfa_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 3)
LEFT JOIN `sfa_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 74
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.2 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%footer_page%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 463) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%header%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE *
FROM `sfa_cms` a
LEFT JOIN `sfa_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `sfa_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 3
WHERE (a.`id_cms` = 17) AND (b.`id_shop` = 3) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `sfa_lang` l
JOIN sfa_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 3)
WHERE l.`active` = 1 LIMIT 1
 0.2 1 /classes/Language.php:1029 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%nav_top%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE `id_page`
FROM `sfa_page`
WHERE `id_page_type` = 3 AND `id_object` = 74 LIMIT 1
 0.2 1 /classes/Page.php:80 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `sfa_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `sfa_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 2)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 15
ORDER BY atmcw.`position`
 0.2 5 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search`
FROM `sfa_pm_advancedsearch` ads
JOIN `sfa_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=3)  WHERE 1  AND ads.`active`=1  ORDER BY ads.`position`
 0.2 12 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:45 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%displayTop%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE wtl.name, wt.id_wfu123_type
FROM sfa_wfu123_type wt
LEFT JOIN sfa_wfu123_type_lang wtl 
ON (wtl.id_wfu123_type = wt.id_wfu123_type) 
LEFT JOIN sfa_wfu123_type_shop wts 
ON (wts.id_wfu123_type = wt.id_wfu123_type) 
WHERE 
wtl.id_lang = 2 
AND wts.id_shop = 3
AND wt.id_wfu123_type = 5
 0.2 0 /modules/customfields123/src/Model/WhereToBuy.php:90 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `sfa_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `sfa_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 2)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 18
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM sfa_shop s
LEFT JOIN sfa_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 5
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.2 1 /classes/shop/Shop.php:201 
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
FROM `sfa_product` p
INNER JOIN `sfa_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `sfa_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 74)
 0.2 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE id_tab, class_name FROM `sfa_tab`
 0.2 166 /classes/Tab.php:318 
SELECT SQL_NO_CACHE *
FROM `sfa_country` a
LEFT JOIN `sfa_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `sfa_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 3
WHERE (a.`id_country` = 27) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE np.`id_prestablog_news`
FROM `sfa_prestablog_news_product` np
LEFT JOIN `sfa_prestablog_news` n
ON (np.`id_prestablog_news` = n.`id_prestablog_news`)
WHERE np.`id_product` = 74
ORDER BY n.`date` DESC
 0.2 2 Yes /modules/prestablog/class/news.class.php:269 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM sfa_shop_url
WHERE main = 1
AND id_shop = 3 LIMIT 1
 0.2 1 /classes/shop/ShopUrl.php:173 
SELECT SQL_NO_CACHE id_feature
FROM `sfa_featuresdisplay123_hooks` fh
WHERE (hookname = 'displayFooterProduct')
 0.2 110 /modules/featuresdisplay123/featuresdisplay123.php:568 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sfa_image` i
INNER JOIN sfa_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 3)
WHERE i.`id_product` = 74
AND image_shop.`cover` = 1 LIMIT 1
 0.2 17 /classes/Product.php:3064 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `sfa_lang` l
JOIN sfa_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.2 1 /classes/Language.php:1029 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_info%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `sfa_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `sfa_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 2)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 17
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
SELECT SQL_NO_CACHE * FROM `sfa_attachment123_products` ap
LEFT JOIN `sfa_attachment123_shop` a ON (a.`id_attachment123` = ap.`id_attachment123`)
WHERE `id_product` = 74 AND id_shop IN (3)
 0.2 5 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_right%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 466)
ORDER BY f.position ASC
 0.2 14 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE count(*)
FROM `sfa_advancedpopup`
INNER JOIN `sfa_advancedpopup_lang` ON `sfa_advancedpopup`.`id_advancedpopup` = `sfa_advancedpopup_lang`.`id_advancedpopup`
WHERE `id_shop` = 3 AND `id_lang` = 2 AND `active` = 1
AND `display_on_exit` = 1 LIMIT 1
 0.2 2 /modules/advancedpopupcreator/classes/AdvancedPopup.php:856 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `sfa_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `sfa_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 2)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 16
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `sfa_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `sfa_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 2)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 44
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 464)
ORDER BY f.position ASC
 0.2 14 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_thumbs%" AND cs.id_shop="3";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE * FROM `sfa_attachment123_products` ap
LEFT JOIN `sfa_attachment123_shop` a ON (a.`id_attachment123` = ap.`id_attachment123`)
WHERE `id_product` = 74 AND id_shop IN (3)
 0.2 5 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 465)
ORDER BY f.position ASC
 0.2 14 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `sfa_lang` l
JOIN sfa_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 5)
WHERE l.`active` = 1 LIMIT 1
 0.2 1 /classes/Language.php:1029 
SELECT SQL_NO_CACHE value FROM sfa_ce_meta WHERE id = 74030203 AND name = '_elementor_edit_mode' LIMIT 1
 0.2 1 /modules/creativeelements/classes/wrappers/Post.php:206 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `sfa_lang` l
LEFT JOIN `sfa_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.2 3 /classes/Language.php:882 
SELECT SQL_NO_CACHE *
FROM sfa_meta m
LEFT JOIN sfa_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 2
AND ml.id_shop = 3 LIMIT 1
 0.2 1 /classes/Meta.php:189 
SELECT SQL_NO_CACHE type+0 AS type FROM `sfa_lgcanonicalurls` WHERE `id_object` = 74   AND `type_object` = 1 LIMIT 1
 0.2 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1545 
SELECT SQL_NO_CACHE *
FROM `sfa_category` a
LEFT JOIN `sfa_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `sfa_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 3) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 1 FROM sfa_cart_product cp INNER JOIN sfa_product p
ON (p.id_product = cp.id_product) INNER JOIN sfa_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.2 1 /classes/Cart.php:4013 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 468)
ORDER BY f.position ASC
 0.2 14 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE f.`id_fm_form`
FROM
`sfa_fm_form_products` fp
LEFT JOIN `sfa_fm_form` f ON (f.`id_fm_form` = fp.`id_fm_form`)
LEFT JOIN `sfa_fm_form_shop` fs ON (f.`id_fm_form` = fs.`id_fm_form`)
WHERE fp.`id_product` = 74 AND f.`active` = 1 LIMIT 1
 0.2 1 /modules/formmaker/classes/FormMakerForm.php:625 
SELECT SQL_NO_CACHE p.id_product
FROM `sfa_product` p
INNER JOIN sfa_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 3)
WHERE p.id_product = 74
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-10 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.2 0 /classes/Product.php:1399 
SELECT SQL_NO_CACHE *
FROM sfa_meta m
LEFT JOIN sfa_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 2
AND ml.id_shop = 3 LIMIT 1
 0.2 1 /classes/Meta.php:189 
SELECT SQL_NO_CACHE p.id_product
FROM `sfa_product` p
INNER JOIN sfa_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 3)
WHERE p.id_product = 74
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-10 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.2 0 /classes/Product.php:1399 
SELECT SQL_NO_CACHE *
FROM `sfa_attachment123` a
LEFT JOIN `sfa_attachment123_lang` `b` ON a.`id_attachment123` = b.`id_attachment123` AND b.`id_lang` = 2
LEFT JOIN `sfa_attachment123_shop` `c` ON a.`id_attachment123` = c.`id_attachment123` AND c.`id_shop` = 3
WHERE (a.`id_attachment123` = 257) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `sfa_currency` c
LEFT JOIN sfa_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 3)
WHERE c.`active` = 1 LIMIT 1
 0.2 5 /classes/Currency.php:661 
SELECT SQL_NO_CACHE p.id_product
FROM `sfa_product` p
INNER JOIN sfa_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 3)
WHERE p.id_product = 74
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-10 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.2 0 /classes/Product.php:1399 
SELECT SQL_NO_CACHE tr.*
FROM `sfa_tax_rule` tr
JOIN `sfa_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
 0.2 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 1022) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE value FROM `sfa_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.2 2 /classes/shop/Shop.php:1160 
SELECT SQL_NO_CACHE *
FROM sfa_meta m
LEFT JOIN sfa_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 2
AND ml.id_shop = 3 LIMIT 1
 0.2 1 /classes/Meta.php:189 
SELECT SQL_NO_CACHE wtb.`id_customfields123_product_wheretobuy`
FROM `sfa_customfields123_product_wheretobuy` wtb
WHERE wtb.`id_product`=74 AND wtb.`id_shop`=3 LIMIT 1
 0.2 1 /modules/customfields123/src/Model/WhereToBuy.php:49 
SELECT SQL_NO_CACHE *
FROM `sfa_country` a
LEFT JOIN `sfa_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 3
WHERE (a.`id_country` = 27) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_country` a
LEFT JOIN `sfa_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `sfa_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 3
WHERE (a.`id_country` = 21) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `sfa_hook_alias`
 0.2 83 /classes/Hook.php:260 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 466) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_category` FROM `sfa_category_product`
WHERE `id_product` = 74
 0.2 4 /classes/Product.php:2933 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 465) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `sfa_hook_alias`
 0.2 83 /classes/Hook.php:234 
SELECT SQL_NO_CACHE * FROM `sfa_attachment123_products` ap
LEFT JOIN `sfa_attachment123_shop` a ON (a.`id_attachment123` = ap.`id_attachment123`)
WHERE `id_product` = 74 AND id_shop IN (3)
 0.2 5 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
SELECT SQL_NO_CACHE *
FROM `sfa_attachment123` a
LEFT JOIN `sfa_attachment123_lang` `b` ON a.`id_attachment123` = b.`id_attachment123` AND b.`id_lang` = 2
LEFT JOIN `sfa_attachment123_shop` `c` ON a.`id_attachment123` = c.`id_attachment123` AND c.`id_shop` = 3
WHERE (a.`id_attachment123` = 211) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sfa_product_attribute pa
INNER JOIN sfa_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 3)
WHERE pa.id_product = 74 LIMIT 1
 0.2 1 /classes/Product.php:845 
SELECT SQL_NO_CACHE wtl.name, wt.id_wfu123_type
FROM sfa_wfu123_type wt
LEFT JOIN sfa_wfu123_type_lang wtl 
ON (wtl.id_wfu123_type = wt.id_wfu123_type) 
LEFT JOIN sfa_wfu123_type_shop wts 
ON (wts.id_wfu123_type = wt.id_wfu123_type) 
WHERE 
wtl.id_lang = 2 
AND wts.id_shop = 3
AND wt.id_wfu123_type = 5
 0.2 0 /modules/customfields123/src/Model/WhereToBuy.php:90 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM sfa_shop s
LEFT JOIN sfa_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 3
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.2 1 /classes/shop/Shop.php:201 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sfa_category_product` cp
INNER JOIN `sfa_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 74 AND ctg.`id_group` = 1 LIMIT 1
 0.2 4 /classes/Product.php:5502 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM sfa_shop s
LEFT JOIN sfa_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
 0.2 1 /classes/shop/Shop.php:201 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sfa_tag t
LEFT JOIN sfa_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=74
 0.2 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE p.id_product
FROM `sfa_product` p
INNER JOIN sfa_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 3)
WHERE p.id_product = 74
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-10 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.1 0 /classes/Product.php:1399 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sfa_stock_available`
WHERE (id_product = 74) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:441 
SELECT SQL_NO_CACHE *
FROM `sfa_product_lang`
WHERE `id_product` = 74 AND `id_shop` = 3
 0.1 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE `id_country`
FROM `sfa_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.1 1 /classes/Country.php:192 
SELECT SQL_NO_CACHE *
FROM `sfa_lang` a
LEFT JOIN `sfa_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 3
WHERE (a.`id_lang` = 2) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE id_page_type
FROM sfa_page_type
WHERE name = 'product' LIMIT 1
 0.1 1 /classes/Page.php:100 
SELECT SQL_NO_CACHE *
FROM `sfa_category` a
LEFT JOIN `sfa_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 12) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_group` a
LEFT JOIN `sfa_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 3
WHERE (a.`id_group` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 468) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (3) LIMIT 1
 0.1 1 /src/Adapter/Module/ModuleDataProvider.php:174 
SELECT SQL_NO_CACHE * FROM `sfa_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.1 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `sfa_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
 0.1 3 Yes /classes/Language.php:820 
SELECT SQL_NO_CACHE id_feature
FROM `sfa_featuresdisplay123_hooks` fh
WHERE (hookname = 'displayProductAdditionalInfo')
 0.1 2 /modules/featuresdisplay123/featuresdisplay123.php:568 
SELECT SQL_NO_CACHE wtb.`id_customfields123_product_wheretobuy`
FROM `sfa_customfields123_product_wheretobuy` wtb
WHERE wtb.`id_product`=74 AND wtb.`id_shop`=3 LIMIT 1
 0.1 1 /modules/customfields123/src/Model/WhereToBuy.php:49 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 464) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_country`
FROM `sfa_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.1 1 /classes/Country.php:192 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification_feature` a
WHERE (a.`id_classification_feature` = 25813) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_currency` a
LEFT JOIN `sfa_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 3
WHERE (a.`id_currency` = 4) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_advancedpopup`
FROM `sfa_advancedpopup`
WHERE `id_shop` = 3 AND `session` = 1
 0.1 2 /modules/advancedpopupcreator/classes/AdvancedPopup.php:268 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 467) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_feature` f
LEFT JOIN `sfa_feature_lang` fl
ON ( f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 2)
WHERE f.`id_feature` = 19 LIMIT 1
 0.1 1 /classes/Feature.php:73 
SELECT SQL_NO_CACHE `text_header`
FROM `sfa_code_lang` 
WHERE `id_lang` = 2 
AND  `id_shop` = 3 LIMIT 1
 0.1 18 /modules/customcode123/customcode123.php:398 
SELECT SQL_NO_CACHE *
FROM `sfa_shop` a
WHERE (a.`id_shop` = 5) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sfa_tag t
LEFT JOIN sfa_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=74
 0.1 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE id_feature
FROM `sfa_featuresdisplay123_hooks` fh
WHERE (hookname = 'displayProductAdditionalInfo')
 0.1 2 /modules/featuresdisplay123/featuresdisplay123.php:568 
SELECT SQL_NO_CACHE id_feature
FROM `sfa_featuresdisplay123_hooks` fh
WHERE (hookname = 'displayProductAddTocart')
 0.1 1 /modules/featuresdisplay123/featuresdisplay123.php:568 
SELECT SQL_NO_CACHE *
FROM `sfa_feature_value` a
LEFT JOIN `sfa_feature_value_lang` `b` ON a.`id_feature_value` = b.`id_feature_value` AND b.`id_lang` = 2
WHERE (a.`id_feature_value` = 615) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `sfa_code_lang` 
WHERE `id_lang` = 2 AND  `id_shop` = 3 LIMIT 1
 0.1 18 /modules/customcode123/customcode123.php:322 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification_feature` a
WHERE (a.`id_classification_feature` = 13567) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_shop` a0
WHERE (a0.`active` = 1)
 0.1 4 /classes/PrestaShopCollection.php:373 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sfa_tag t
LEFT JOIN sfa_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=74
 0.1 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE * FROM sfa_cb_hook_settings
WHERE hook_name = 'displayNav1' LIMIT 1
 0.1 1 /modules/custombanners/custombanners.php:2018 
SELECT SQL_NO_CACHE *
FROM `sfa_feature` a
LEFT JOIN `sfa_feature_shop` `c` ON a.`id_feature` = c.`id_feature` AND c.`id_shop` = 3
WHERE (a.`id_feature` = 7) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sfa_feature_value` a
LEFT JOIN `sfa_feature_value_lang` `b` ON a.`id_feature_value` = b.`id_feature_value` AND b.`id_lang` = 2
WHERE (a.`id_feature_value` = 41) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75