Sanifast

Sanifast

Sanifast is a compact easy to service grey water pump designed for commercial use. The unit is designed to receive and pump away waste water from a washing machine dishwasher, sink and is ideal for busy commercial office kitchens

  • High Pumping performance
  • Plug and Play connectivity to optional external Sanialarm Interlock for water and power isolation
  • Easy Service lid

A$0.00


Application

  • Bathtub
  • Dishwasher
  • Kitchen sink
  • Shower
  • Wash hand basin
  • Washing machine
Product sheet

Sanifast datasheet

Sanifast
Number of entries 2
Maximum flow rate 14 m³/h
Inlet pipework 50 mm
Discharge pipework 32 mm
Motor power 850W
Voltage 220-240 V
Maximum absorbed current 3.7A
Electrical class I
IP rating IP44
Max. temperature of the pumped liquid (5 min) 40°-75°
Noise level 59 - 71 db
Discharge length 100 m
Max. head (Q0) 9 m
Weight 6 kg
Water level detection Compact float
Minimum height of the shower siphon 200 mm

Related articles on blog

Complementary products

SaniAlarm Interlock

SaniAlarm Interlock

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

Sanifast

  • Bathtub
  • Dishwasher
  • Kitchen sink
  • Shower
  • Wash hand basin
  • Washing machine
Product sheet
Load Time550 ms - Unicorn powered webserver!
Querying Time141 ms
Queries654
Memory Peak Usage75.0 Mb
Included Files892 files - 13.57 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 134 ms 134 ms 23.88 Mb 24.18 Mb
__construct 0 ms 134 ms - Mb 24.18 Mb
init 63 ms 197 ms 7.27 Mb 31.37 Mb
checkAccess 0 ms 197 ms - Mb 31.37 Mb
setMedia 0 ms 197 ms 0.01 Mb 31.37 Mb
postProcess 0 ms 197 ms - Mb 31.37 Mb
initHeader 0 ms 197 ms - Mb 31.37 Mb
initContent 89 ms 286 ms 11.70 Mb 42.99 Mb
initFooter 0 ms 286 ms - Mb 42.99 Mb
display 264 ms 550 ms 31.93 Mb 74.99 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 - 654 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`)
 6.4 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` != "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`
 3.3 1308 Yes Yes /classes/Hook.php:666 
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`
 3.1 1308 Yes Yes /override/classes/Hook.php:116 
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.4 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`
 1.1 205 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:244 
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.9 20 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-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` = 233 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.8 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` = 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` = 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.8 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` = 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.8 10 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 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.8 25 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `sfa_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `sfa_hook_alias` ha
INNER JOIN `sfa_hook` h ON ha.name = h.name
 0.7 0 /classes/Hook.php:190 
SELECT SQL_NO_CACHE 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 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` = 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 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.7 5 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `sfa_pm_advancedtopmenu_columns` atmc
LEFT JOIN `sfa_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 2)
LEFT JOIN sfa_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN sfa_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 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` = 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.7 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` = 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.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` = 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.7 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` = 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.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` = 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.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` = 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.7 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` = 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` = 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.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` = 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` = 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` = 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 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` = 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` = 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 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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 
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 
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 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 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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 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.6 61 Yes /classes/Dispatcher.php:636 
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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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` = 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 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` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:872 
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` = 233)
 0.6 1 /classes/Product.php:3342 
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.5 0 /classes/tax/TaxRulesTaxManager.php:108 
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.5 2 Yes /classes/shop/Shop.php:345 
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 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` = 233
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 0.5 1 Yes Yes /classes/Product.php:3915 
SELECT SQL_NO_CACHE 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 = 233
ORDER BY f.position ASC
 0.5 22 Yes /override/classes/Product.php:37 
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 = 233 LIMIT 1
 0.4 1 /classes/Product.php:845 
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 id_classification
FROM `sfa_eg_featuretab_classification`
WHERE (`id_product` = 233) AND (`id_shop` = 1)
 0.4 23 /modules/eg_featuretab/src/Entity/Classification.php:94 
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` = 233
 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:47:29" OR `date_init` = "1970-01-01 10:00:00")
AND (`date_end` >= "2024-12-07 00:47:29" 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/inground-pump-chambers/233-swh190.html", `display_url_string`) > 0)
AND (`genders` = ""
OR `genders` IS NULL) AND (`groups` = ""
OR `groups` IS NULL  OR FIND_IN_SET(1, `groups`)) AND `display_desktop` = 1 AND (`cms` = ""
OR `cms` IS NULL) AND (`controller_exceptions` = ""
OR `controller_exceptions` IS NULL
OR FIND_IN_SET("product", `controller_exceptions`)) AND (`display_after_cart` = 1
OR (`products` = ""
OR `products` IS NULL
OR FIND_IN_SET(233, `products`))) AND (`categories` = ""
OR `categories` IS NULL  OR FIND_IN_SET(14, `categories`) OR FIND_IN_SET(73, `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 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.4 84 /classes/module/Module.php:305 
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 = 233
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-07 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.4 0 /classes/Product.php:1399 
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.4 72 Yes /classes/shop/Shop.php:704 
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`=233
 0.4 1 /classes/Tag.php:229 
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:47:28'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-07 00:47:28')
ORDER BY position ASC
 0.4 5 Yes /modules/custombanners/custombanners.php:2037 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sfa_stock_available`
WHERE (id_product = 233) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:441 
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.4 1 Yes /override/classes/Product.php:37 
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.4 0 /classes/Cart.php:1234 
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` = 233) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_guest`
FROM `sfa_connections`
WHERE `id_guest` = 9818309
AND `date_add` > '2024-12-07 00:17:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.3 400 Yes /classes/Connection.php:163 
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` = 233
 0.3 1 /classes/Product.php:6203 
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:47:29'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-07 00:47:29')
ORDER BY position ASC
 0.3 5 Yes /modules/custombanners/custombanners.php:2037 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sfa_module` m
LEFT JOIN `sfa_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 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 * 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:47:28'
AND (publish_to = '0000-00-00 00:00:00' OR publish_to >= '2024-12-07 00:47:28')
ORDER BY position ASC
 0.3 10 Yes /modules/custombanners/custombanners.php:2037 
INSERT INTO `sfa_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('9818309', '253', '308350546', '', '1', '1', '2024-12-07 00:47:29')
 0.3 1 /classes/ObjectModel.php:551 
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` = 233 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` = 233 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 `reduction`
FROM `sfa_product_group_reduction_cache`
WHERE `id_product` = 233 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:151 
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 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` = 355)
ORDER BY f.position ASC
 0.3 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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 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.3 4 Yes /classes/Product.php:3042 
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.3 4 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
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` = 355) 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 *
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.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE depends_on_stock
FROM `sfa_stock_available`
WHERE (id_product = 233) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:729 
SELECT SQL_NO_CACHE location
FROM `sfa_stock_available`
WHERE (id_product = 233) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:782 
SELECT SQL_NO_CACHE out_of_stock
FROM `sfa_stock_available`
WHERE (id_product = 233) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:754 
SELECT SQL_NO_CACHE *
FROM `sfa_category` a0
LEFT JOIN `sfa_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 85) AND (a0.`nright` > 86) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
 0.3 256 Yes /classes/PrestaShopCollection.php:373 
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.3 1 /src/Adapter/EntityMapper.php:75 
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 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.3 1 /classes/Language.php:1029 
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` = 233) AND (b.`id_shop` = 3) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sfa_product_shop`
WHERE `id_product` = 233 AND id_shop=1 LIMIT 1
 0.2 1 /classes/Product.php:5620 
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` = 233) AND (b.`id_shop` = 5) LIMIT 1
 0.2 0 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE value FROM `sfa_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.2 2 /classes/shop/Shop.php:1160 
SELECT SQL_NO_CACHE 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 *
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 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 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` = 233
ORDER BY n.`date` DESC
 0.2 3 Yes /modules/prestablog/class/news.class.php:269 
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 *
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` = 233) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 233
ORDER BY `position`
 0.2 4 Yes /classes/Product.php:3042 
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` = 208) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE tr.*
FROM `sfa_tax_rule` tr
JOIN `sfa_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.2 1 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_info%" AND cs.id_shop="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE value FROM sfa_ce_meta WHERE id = 233030201 AND name = '_elementor_edit_mode' LIMIT 1
 0.2 1 /modules/creativeelements/classes/wrappers/Post.php:206 
SELECT SQL_NO_CACHE `reduction`
FROM `sfa_group`
WHERE `id_group` = 1 LIMIT 1
 0.2 1 /classes/Group.php:151 
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` = 233 AND id_shop IN (1)
 0.2 4 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 1045)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 233
ORDER BY n.`date` DESC
 0.2 3 Yes /modules/prestablog/class/news.class.php:269 
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` = 275) 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` = 1138)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE id_tab, class_name FROM `sfa_tab`
 0.2 166 /classes/Tab.php:318 
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 *
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` = 14) AND (b.`id_shop` = 1) 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` = 356)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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 `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 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 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 id_feature
FROM `sfa_featuresdisplay123_hooks` fh
WHERE (hookname = 'displayFooterProduct')
 0.2 110 /modules/featuresdisplay123/featuresdisplay123.php:568 
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` = 3
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 "%footer_page%" AND cs.id_shop="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
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.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` = 1139)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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.2 3 Yes /classes/Language.php:820 
SELECT SQL_NO_CACHE * FROM `sfa_hook_alias`
 0.2 83 /classes/Hook.php:234 
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 *
FROM `sfa_prestablog_news_lang`
WHERE `id_prestablog_news` = 161
 0.2 2 /src/Adapter/EntityMapper.php:82 
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 *
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.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` = 359)
ORDER BY f.position ASC
 0.2 22 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` = 1058)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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` = 233
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
 0.2 0 /classes/Product.php:6176 
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` = 1058) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 233
AND image_shop.`cover` = 1 LIMIT 1
 0.2 4 /classes/Product.php:3064 
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 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` = 357)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_right%" AND cs.id_shop="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
SELECT SQL_NO_CACHE cf.id_classification_feature, f.position
FROM `sfa_eg_featuretab_classification_feature` cf
INNER JOIN `sfa_feature` `f` ON f.id_feature=cf.id_feature
WHERE (cf.`id_classification` = 358)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
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 *
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` = 1045) 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` = 1140)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE * FROM `sfa_hook_alias`
 0.2 83 /classes/Hook.php:260 
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` = 233 AND id_shop IN (1)
 0.2 4 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
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 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 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 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` = 360)
ORDER BY f.position ASC
 0.2 22 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` = 1141)
ORDER BY f.position ASC
 0.2 22 Yes /modules/eg_featuretab/src/Entity/ClassificationFeature.php:64 
SELECT SQL_NO_CACHE c.id_contact FROM sfa_ets_cfu_contact c
INNER JOIN sfa_ets_cfu_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN sfa_ets_cfu_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 AND c.hook like "%product_thumbs%" AND cs.id_shop="1";
 0.2 204 /modules/ets_cfultimate/ets_cfultimate.php:1276 
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` = 233 AND f.`active` = 1 LIMIT 1
 0.2 1 /modules/formmaker/classes/FormMakerForm.php:625 
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` = 233 AND ctg.`id_group` = 1 LIMIT 1
 0.2 2 /classes/Product.php:5502 
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.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 = 233
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 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 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 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 * FROM `sfa_attachment123_products` ap
LEFT JOIN `sfa_attachment123_shop` a ON (a.`id_attachment123` = ap.`id_attachment123`)
WHERE `id_product` = 233 AND id_shop IN (1)
 0.2 4 /modules/attachment123/classes/ProductAttachmentCustom.php:177 
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 *
FROM `sfa_prestablog_news_lang`
WHERE `id_prestablog_news` = 177
 0.2 2 /src/Adapter/EntityMapper.php:82 
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` = 446) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_page`
FROM `sfa_page`
WHERE `id_page_type` = 3 AND `id_object` = 233 LIMIT 1
 0.2 1 /classes/Page.php:80 
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 = 233
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 = "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 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 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 wtb.`id_customfields123_product_wheretobuy`
FROM `sfa_customfields123_product_wheretobuy` wtb
WHERE wtb.`id_product`=233 AND wtb.`id_shop`=1 LIMIT 1
 0.2 1 /modules/customfields123/src/Model/WhereToBuy.php:49 
SELECT SQL_NO_CACHE *
FROM `sfa_eg_featuretab_classification` a
LEFT JOIN `sfa_eg_featuretab_classification_lang` `b` ON a.`id_classification` = b.`id_classification` AND b.`id_lang` = 2
WHERE (a.`id_classification` = 356) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE id_feature
FROM `sfa_featuresdisplay123_hooks` fh
WHERE (hookname = 'displayProductAdditionalInfo')
 0.2 2 /modules/featuresdisplay123/featuresdisplay123.php:568 
SELECT SQL_NO_CACHE id_feature
FROM `sfa_featuresdisplay123_hooks` fh
WHERE (hookname = 'displayProductAdditionalInfo')
 0.2 2 /modules/featuresdisplay123/featuresdisplay123.php:568 
SELECT SQL_NO_CACHE * FROM `sfa_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.2 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM sfa_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.2 1 /classes/shop/ShopUrl.php:173 
SELECT SQL_NO_CACHE *
FROM `sfa_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sfa_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 14 LIMIT 1
 0.2 1 /classes/Category.php:1322 
SELECT SQL_NO_CACHE id_taxonomy
FROM `sfa_eg_featuretaxonomy_taxonomy_feature`
WHERE (`id_feature` = 77) LIMIT 1
 0.2 1 /modules/eg_featuretaxonomy/src/Entity/Taxonomy.php:72 
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` = 1139) LIMIT 1
 0.2 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` = 1138) LIMIT 1
 0.2 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` = 1140) LIMIT 1
 0.2 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` = 357) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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 * FROM `sfa_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.2 4 /classes/module/Module.php:2188 
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 = 233
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-07 00:00:00",
INTERVAL 100 DAY
)
) > 0
 0.1 0 /classes/Product.php:1399 
SELECT SQL_NO_CACHE id_page_type
FROM sfa_page_type
WHERE name = 'product' LIMIT 1
 0.1 1 /classes/Page.php:100