Sanimulti

Sanimulti

Sanimulti is a versatile macerator with two possible configurations for connection to a toilet.The pump is designed for installation on the same level and in the same room as the fixtures that it is servicing. The Sanimulti is suited to domestic or commercial applications.

  • Wall hung or standard P-Trap toilet
  • Plug & play Sanialarm Interlock option
  • Possible additional connections to a basin and/or shower

A$0.00


Application

  • Bidet
  • Shower
  • Toilet
  • Wall hung toilet
  • Wash hand basin
Product Sheet

The Sanimulti is a very versatile macerator for commercial projects due to it's 8 metre vertical lift capability. In addition, when there is a need to conceal the pump, the side pan connection allows for possible installation from view . The adjustable pan connection allows a greater selection of compatible toilets to suit. The pump is...

See more

Sanimulti Data sheet

Sanimulti
Number of entries 4
Inlet pipework 100/40 mm
Discharge pipework 22 - 32 mm
Motor power 560 W
Voltage 220-240V/50Hz
Electrical class I
IP rating IP44
Discharge length 70 m
Max. head (Q0) 8 m
Shower tray height 17 cm

Complementary products

SaniAlarm Interlock

SaniAlarm Interlock

The Sanialarm Interlock has 3 functions , whereby it sets off an audible alarm in...
Sanimulti

Sanimulti

  • Bidet
  • Shower
  • Toilet
  • Wall hung toilet
  • Wash hand basin
Product Sheet
Load Time468 ms - Unicorn powered webserver!
Querying Time108 ms
Queries455
Memory Peak Usage69.4 Mb
Included Files891 files - 13.56 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 123 ms 123 ms 23.89 Mb 24.18 Mb
__construct 0 ms 123 ms - Mb 24.18 Mb
init 51 ms 174 ms 7.27 Mb 31.38 Mb
checkAccess 0 ms 174 ms - Mb 31.38 Mb
setMedia 0 ms 175 ms 0.01 Mb 31.38 Mb
postProcess 0 ms 175 ms - Mb 31.38 Mb
initHeader 0 ms 175 ms - Mb 31.38 Mb
initContent 90 ms 264 ms 11.78 Mb 43.07 Mb
initFooter 0 ms 264 ms - Mb 43.07 Mb
display 204 ms 468 ms 26.21 Mb 69.36 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 - 455 queries

Query Time (ms) Rows Filesort Group By Location 
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.7 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 = 1 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` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 2.7 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 = 1 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` = 1) AND (mg.id_shop = 1 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 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 = 1)
STRAIGHT_JOIN `sfa_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 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 (1) 
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 = 1 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 = 1 )
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 = 1 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 = 1 AND 1)
WHERE atp.`active` = 1 AND (atp.`active_desktop` = 1 || atp.`active_mobile` = 1)
AND ((atp.`id_manufacturer` = 0 AND atp.`id_supplier` = 0 AND atp.`id_category` = 0 AND atp.`id_cms` = 0)
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`
 0.9 205 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:244 
SELECT SQL_NO_CACHE `id_advancedpopup`
FROM `sfa_advancedpopup`
WHERE `id_shop` = 1 AND `session` = 1
 0.8 2 /modules/advancedpopupcreator/classes/AdvancedPopup.php:268 
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 4
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 0.8 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 3
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 0.8 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 132
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 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 131
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 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 323
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.7 15 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 142
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 10 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-07 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 = 1)
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=1)
LEFT JOIN `sfa_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `sfa_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
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=1)
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 = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 246 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.7 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 15
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 0.7 25 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 147
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 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 14
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 19
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 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 11
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 13
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 16
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 12
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 141
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 154
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 21
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 18
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 258
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 143
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 10
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 1
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 133
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 157
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 18
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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.6 0 /classes/Hook.php:190 
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 17
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 20
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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 304
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 19
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 351
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 222
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 225
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 324
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 238
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 281
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 346
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 21
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 259
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 29
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 30
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 28
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 17
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 335
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 5
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 6
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 25
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 221
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 31
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 302
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 261
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 282
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 260
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 27
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 328
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 1
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 24
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 326
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 7
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 311
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 312
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 246
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 226
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 3
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 224
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 262
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 9
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 264
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 26
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 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 = 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 = 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 = 1 )
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 = 1)
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 = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 8
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` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 0.6 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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.6 1 /classes/ObjectModel.php:551 
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 = 3 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.5 61 Yes /classes/Dispatcher.php:636 
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 = 1)
LEFT JOIN `sfa_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
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 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 = 1)
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 = 1  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 = 1)
WHERE pa.`id_product` = 246
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.4 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 = 5 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.4 61 Yes /classes/Dispatcher.php:636 
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 = 1)
INNER JOIN sfa_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 246
 0.4 1 /classes/Product.php:6203 
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` = 1 AND `id_lang` = 2 AND `active` = 1
AND (`date_init` <= "2024-12-07 00:23:51" OR `date_init` = "1970-01-01 10:00:00")
AND (`date_end` >= "2024-12-07 00:23:51" 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.com.au/install-toilets/246-sanimulti.html?utm_campaign=saniflo_au_2023&utm_content=2023165&utm_medium=product_listings&utm_source=architecture_and_design&utm_term=dec", `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(246, `products`))) AND (`categories` = ""
OR `categories` IS NULL  OR FIND_IN_SET(12, `categories`) OR FIND_IN_SET(13, `categories`) OR FIND_IN_SET(71, `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 = 1)
WHERE pf.id_product = 246
ORDER BY f.position ASC
 0.4 15 Yes /override/classes/Product.php:37 
SELECT SQL_NO_CACHE * FROM sfa_custombanners
WHERE hook_name = 'displayNav1'
AND id_shop = 1
AND id_lang = 2
AND active = 1
AND publish_from <= '2024-12-07 00:23:51'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-07 00:23:51')
ORDER BY position ASC
 0.3 5 Yes /modules/custombanners/custombanners.php:2037 
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 = 1)
INNER JOIN sfa_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 246
 0.3 1 /classes/Product.php:6203 
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 
INSERT INTO `sfa_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('9818257', '273', '308350546', '', '1', '1', '2024-12-07 00:23:51')
 0.3 1 /classes/ObjectModel.php:551 
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` = 246) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
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` = 246 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` = 246 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
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` = 232 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` = 232 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE * FROM sfa_custombanners
WHERE hook_name = 'displayTop'
AND id_shop = 1
AND id_lang = 2
AND active = 1
AND publish_from <= '2024-12-07 00:23:51'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-07 00:23:51')
ORDER BY position ASC
 0.3 10 Yes /modules/custombanners/custombanners.php:2037 
SELECT SQL_NO_CACHE * FROM sfa_custombanners
WHERE hook_name = 'displayFooter'
AND id_shop = 1
AND id_lang = 2
AND active = 1
AND publish_from <= '2024-12-07 00:23:51'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-07 00:23:51')
ORDER BY position ASC
 0.3 5 Yes /modules/custombanners/custombanners.php:2037 
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` = 246) AND (b.`id_shop` = 3) 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` = 1
 0.3 84 /classes/module/Module.php:305 
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 = 1 )
INNER JOIN sfa_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
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` = 1
 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.com.au' OR su.domain_ssl = 'www.saniflo.com.au')
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 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 = 1)
WHERE pf.id_product = 232
ORDER BY f.position ASC
 0.3 1 Yes /override/classes/Product.php:37 
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` = 1
 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` = 1
 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` = 1
 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` = 1
 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` = 1
 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` = 1
 0.3 84 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE `id_guest`
FROM `sfa_connections`
WHERE `id_guest` = 9818257
AND `date_add` > '2024-12-06 23:53:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.3 347 Yes /classes/Connection.php:163 
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 = 1 AND a.hook LIKE 'displayAfterProductThumbs' AND a.active = 1 ORDER BY a.id_product, a.id_category DESC
 0.3 45 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 = 1 AND a.hook LIKE 'displayRightColumnProduct' AND a.active = 1 ORDER BY a.id_product, a.id_category DESC
 0.3 45 Yes /modules/creativeelements/classes/CEContent.php:153 
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` = 246) AND (b.`id_shop` = 5) LIMIT 1
 0.3 0 /src/Adapter/EntityMapper.php:75 
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` = 232) AND (b.`id_shop` = 1) 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 *
FROM `sfa_product` a
LEFT JOIN `sfa_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 246) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 39
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
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 = 1)
LEFT JOIN `sfa_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 246
ORDER BY `position`
 0.2 14 Yes /classes/Product.php:3042 
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 *
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` = 799) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 246 AND f.`active` = 1 LIMIT 1
 0.2 1 /modules/formmaker/classes/FormMakerForm.php:625 
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 = 1)
LEFT JOIN `sfa_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 232
ORDER BY `position`
 0.2 4 Yes /classes/Product.php:3042 
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` = 799)
ORDER BY f.position ASC
 0.2 15 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 1
WHERE (a.`id_customfields123_product` = 214) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE id_classification
FROM `sfa_eg_featuretab_classification`
WHERE (`id_product` = 246) AND (`id_shop` = 1)
 0.2 13 /modules/eg_featuretab/src/Entity/Classification.php:94 
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`=1)  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 *
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` = 1
WHERE (a.`id_cms` = 17) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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 = 1)
LEFT JOIN `sfa_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 246)
 0.2 1 /classes/Product.php:3342 
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` = 246
ORDER BY n.`date` DESC
 0.2 1 Yes /modules/prestablog/class/news.class.php:269 
SELECT SQL_NO_CACHE id_tab, class_name FROM `sfa_tab`
 0.2 166 /classes/Tab.php:318 
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="1";
 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` = 4
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
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="1";
 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 = 1)
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` = 232
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.2 0 /classes/Product.php:6176 
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` = 3
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` = 1
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
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="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
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 "%header%" AND cs.id_shop="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
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="1";
 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` = 246 AND id_shop IN (1)
 0.2 3 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
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 = 1)
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` = 246
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.2 0 /classes/Product.php:6176 
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` = 1040)
ORDER BY f.position ASC
 0.2 15 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 246 AND ctg.`id_group` = 1 LIMIT 1
 0.2 3 /classes/Product.php:5502 
SELECT SQL_NO_CACHE value FROM sfa_ce_meta WHERE id = 246030201 AND name = '_elementor_edit_mode' LIMIT 1
 0.2 1 /modules/creativeelements/classes/wrappers/Post.php:206 
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` = 1 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 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 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` = 42
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
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 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` = 5
ORDER BY atmcw.`position`
 0.2 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
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` = 1
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 1) 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 "%product_thumbs%" AND cs.id_shop="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
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 = 1)
WHERE i.`id_product` = 246
AND image_shop.`cover` = 1 LIMIT 1
 0.2 14 /classes/Product.php:3064 
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 `id_country`
FROM `sfa_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.2 1 /classes/Country.php:192 
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="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
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="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
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 = 1)
WHERE c.`active` = 1 LIMIT 1
 0.2 5 /classes/Currency.php:661 
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` = 1
WHERE (a.`id_country` = 24) 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 = 1)
WHERE l.`active` = 1 LIMIT 1
 0.2 1 /classes/Language.php:1029 
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` = 1040) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 802)
ORDER BY f.position ASC
 0.2 15 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 800)
ORDER BY f.position ASC
 0.2 15 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 801)
ORDER BY f.position ASC
 0.2 15 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 246 AND id_shop IN (1)
 0.2 3 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
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 = 1)
WHERE p.id_product = 246
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-07 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 = 1 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 = 1)
WHERE p.id_product = 246
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-07 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` = 1
WHERE (a.`id_attachment123` = 321) 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 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 = 1)
LEFT JOIN `sfa_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 232)
 0.2 1 /classes/Product.php:3342 
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` = 803)
ORDER BY f.position ASC
 0.2 15 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 804)
ORDER BY f.position ASC
 0.2 15 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 246 AND id_shop IN (1)
 0.2 3 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
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`=246
 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 = 1)
WHERE p.id_product = 246
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-07 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.2 0 /classes/Product.php:1399 
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 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_product_lang`
WHERE `id_product` = 246 AND `id_shop` = 1
 0.2 3 /src/Adapter/EntityMapper.php:82 
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` = 232 AND ctg.`id_group` = 1 LIMIT 1
 0.2 1 /classes/Product.php:5502 
SELECT SQL_NO_CACHE wtb.`id_customfields123_product_wheretobuy`
FROM `sfa_customfields123_product_wheretobuy` wtb
WHERE wtb.`id_product`=246 AND wtb.`id_shop`=1 LIMIT 1
 0.2 1 /modules/customfields123/src/Model/WhereToBuy.php:49 
SELECT SQL_NO_CACHE `id_page`
FROM `sfa_page`
WHERE `id_page_type` = 3 AND `id_object` = 246 LIMIT 1
 0.2 1 /classes/Page.php:80 
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` = 1
WHERE (a.`id_attachment123` = 376) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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 = 1 LIMIT 1
 0.2 1 /classes/Meta.php:189 
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 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 = 1)
WHERE pa.id_product = 246 LIMIT 1
 0.2 1 /classes/Product.php:845 
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` = 1
WHERE (a.`id_country` = 21) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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 = 1)
WHERE p.id_product = 246
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-07 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.2 0 /classes/Product.php:1399 
SELECT SQL_NO_CACHE type+0 AS type FROM `sfa_lgcanonicalurls` WHERE `id_object` = 246   AND `type_object` = 1 LIMIT 1
 0.1 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1545 
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` = 1
WHERE (a.`id_currency` = 3) 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` = 450) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE value FROM `sfa_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.1 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 = 1 LIMIT 1
 0.1 1 /classes/Meta.php:189 
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` = 804) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
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.1 1 /classes/shop/Shop.php:201 
SELECT SQL_NO_CACHE * FROM `sfa_hook_alias`
 0.1 83 /classes/Hook.php:234 
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` = 1
WHERE (a.`id_country` = 24) 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` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
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 * FROM `sfa_hook_alias`
 0.1 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` = 801) 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` = 802) 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` = 800) 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 *
FROM `sfa_lang` a
LEFT JOIN `sfa_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) 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` = 803) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
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 *
FROM `sfa_category` a
LEFT JOIN `sfa_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) 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 (1) LIMIT 1
 0.1 1 /src/Adapter/Module/ModuleDataProvider.php:174 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM sfa_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/shop/ShopUrl.php:173 
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 SUM(quantity)
FROM `sfa_stock_available`
WHERE (id_product = 246) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:441 
SELECT SQL_NO_CACHE id_taxonomy
FROM `sfa_eg_featuretaxonomy_taxonomy_feature`
WHERE (`id_feature` = 77) LIMIT 1
 0.1 1 /modules/eg_featuretaxonomy/src/Entity/Taxonomy.php:72 
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_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 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`=246
 0.1 1 /classes/Tag.php:229 
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`=246
 0.1 1 /classes/Tag.php:229