Strict Standards: Declaration of Dispatcher::loadRoutes() should be compatible with DispatcherCore::loadRoutes($id_shop = NULL) in /home/fullcar/domains/superparts.pl/public_html/override/classes/Dispatcher.php on line 1150

Notice: Trying to get property of non-object in /home/fullcar/domains/superparts.pl/public_html/classes/Tools.php on line 1222

Notice: Trying to get property of non-object in /home/fullcar/domains/superparts.pl/public_html/classes/Tools.php on line 1222

Notice: Trying to get property of non-object in /home/fullcar/domains/superparts.pl/public_html/classes/Tools.php on line 1222

Notice: Undefined offset: 1 in /home/fullcar/domains/superparts.pl/public_html/controllers/front/ProductController.php on line 277
OLEJ PRZEKŁADNIOWY ZF LIFEGUARDFLUID 5 20L G052162A2 - ZF Parts 8704 003 / superparts.pl
Opinie o sklepie superparts.pl Opinie o sklepie superparts.pl

ZF Parts 8704 003, G052162A2 - OLEJ PRZEKŁADNIOWY ZF LIFEGUARDFLUID 5 20L

OLEJ PRZEKŁADNIOWY ZF LIFEGUARDFLUID 5 20L


Notice: Undefined index: show_brand_logo in /home/fullcar/domains/superparts.pl/public_html/cache/smarty/compile/41/7c/d4/417cd494f15f3db5f0750aeb6d614b5ba67501bf.file.product.tpl.php on line 232

Notice: Trying to get property of non-object in /home/fullcar/domains/superparts.pl/public_html/cache/smarty/compile/41/7c/d4/417cd494f15f3db5f0750aeb6d614b5ba67501bf.file.product.tpl.php on line 232
OLEJ PRZEKŁADNIOWY ZF LIFEGUARDFLUID 5 20L Zobacz powiększenie

Promocja -5%7 DNI, 00:01:30

655,48 zł
Cena netto: 542,02 zł

689,98 zł

+ Darmowa dostawa!

- +

Porównaj

Dlaczego warto kupować w superparts.pl
Promocja
ZF Parts
8704 003
G052162A2

Notice: Undefined index: id_feature in /home/fullcar/domains/superparts.pl/public_html/cache/smarty/compile/41/7c/d4/417cd494f15f3db5f0750aeb6d614b5ba67501bf.file.product.tpl.php on line 1382

Notice: Undefined index: id_feature in /home/fullcar/domains/superparts.pl/public_html/cache/smarty/compile/41/7c/d4/417cd494f15f3db5f0750aeb6d614b5ba67501bf.file.product.tpl.php on line 1382

Notice: Undefined index: id_feature in /home/fullcar/domains/superparts.pl/public_html/cache/smarty/compile/41/7c/d4/417cd494f15f3db5f0750aeb6d614b5ba67501bf.file.product.tpl.php on line 1382

Notice: Undefined index: id_feature in /home/fullcar/domains/superparts.pl/public_html/cache/smarty/compile/41/7c/d4/417cd494f15f3db5f0750aeb6d614b5ba67501bf.file.product.tpl.php on line 1382
4047592073902
Ostatnie egzemplarze!
 
Kategorie: Oleje i płyny, Oleje, Olej przekładniowy
kanister
Pojemność [litr] : 20

ZASTOSOWANIE W POJAZDACH

 

Notice: Undefined index: id_product in /home/fullcar/domains/superparts.pl/public_html/modules/belvg_samplemodule/belvg_samplemodule.php on line 140

Notice: Undefined offset: -1 in /home/fullcar/domains/superparts.pl/public_html/cache/smarty/compile/19/6c/b3/196cb34d28458940f966a0f8d47292c59265a082.file.product.tpl.php on line 144

ZAMIENNIKI

 

KOSZTY WYSYŁKI

 

Paczkomaty

Paczkomaty

Przedpłata: 10.50 zł

Pobranie: 15.50 zł

 Kurier

Kurier

Przedpłata: 15.00 zł

Pobranie: 21.00 zł

 Kurier za granicę

Kurier za granicę

Przedpłata: 85.00 zł

Niemcy, Wielka Brytania, Czechy, Słowacja, Belgia, Holandia, Irlandia, Włochy, Francja, Austria

KODY OE

 

CASTROL70W80 TRANSMAX-Z 1
FUCHS OILATF 5005 SL 1
FEBI BILSTEIN29738
FEBI BILSTEIN14738
RAVENOLATF 5/4 HP FLUID 1L
RAVENOLATF 5/4 HP FLUID 208L
RAVENOLATF 5/4 HP FLUID 20L
RAVENOLATF 5/4 HP FLUID 4L
RAVENOLATF 5/4 HP FLUID 60L
ZF Parts8704000
CASTROLC0310PL
FUCHS OILTITAN ATF 5005 1L
RAVENOL1212104-010-01-999
RAVENOL1212104-001-01-999
RAVENOL1212104-208-01-999
RAVENOL1212104-020-01-999
RAVENOL1212104-004-01-999
RAVENOL1212104-060-01-999
ZF Parts8704 000
CASTROLTRANSMAX Z 1L
CASTROLTRANSMAX Z 20
CASTROLTRANSMAX Z 208
FEBI BILSTEIN14738K
RAVENOLATF 5/4 HP FLUID 10L
MANNOLMAN-133
MANNOL133/4
MANNOLATF AG52
MANNOL133/1
VAICO60-0101
VAICO60-0132
ZF PartsS671.090.170

OPINIE (0)

 
Dodaj swoją opinie:

Zawartość koszyka

Brak produktów

0,00 zł SUMA

Realizuj zamówienie

Szukaj

Menu

Load Time746 ms - Unicorn powered webserver!
Querying Time216 ms
Queries526
Memory Peak Usage36.2 Mb
Included Files469 files - 8.24 Mb
PrestaShop Cache0.01 Mb
Global vars1.88 Mb
PrestaShop Version1.6.1.6
PHP Version5.6.30 (OK)
MySQL Version10.2.6-MariaDB (OK)
Memory Limit1024M
Max Execution Time-1s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 27 ms 27 ms 6.54 Mb 6.68 Mb
__construct 0 ms 27 ms - Mb 6.68 Mb
init 111 ms 138 ms 4.99 Mb 12.23 Mb
checkAccess 0 ms 138 ms - Mb 12.23 Mb
setMedia 1 ms 139 ms 0.07 Mb 12.23 Mb
postProcess 0 ms 139 ms - Mb 12.23 Mb
initHeader 0 ms 139 ms - Mb 12.23 Mb
initContent 273 ms 412 ms 18.60 Mb 30.46 Mb
initFooter 16 ms 428 ms 1.11 Mb 32.50 Mb
display 318 ms 746 ms 3.07 Mb 36.17 Mb
Hook Time Memory Usage
__construct 67 ms 20.00 Mb
hookdisplayMatchedCars 29 ms - Mb
hookdisplayAnywhere 21 ms - Mb
hookdisplayHeader 21 ms - Mb
hookheader 11 ms 0.25 Mb
hookproductfooter 8 ms - Mb
hookdisplaySideBar 5 ms - Mb
hookextraleft 5 ms - Mb
hookdisplayFooterProduct 4 ms - Mb
hookfooter 4 ms - Mb
hookextraright 3 ms - Mb
hookdisplayNav 3 ms - Mb
hookdisplayFooter 3 ms - Mb
hooktop 3 ms - Mb
hookproducttabcontent 2 ms - Mb
hookdisplayMobileBar 2 ms - Mb
hookdisplayTopSecondary 2 ms - Mb
hookdisplayFooterTopNews 2 ms - Mb
hookdisplayLeftColumnProduct 2 ms 0.25 Mb
hookdisplayBottomColumn 2 ms - Mb
hookdisplayTopColumn 2 ms - Mb
hookdisplayBanner 2 ms - Mb
hookdisplayTop 2 ms - Mb
hookproducttab 1 ms 0.25 Mb
hookdisplayFooterInfo 1 ms - Mb
hookdisplayMyNewHookMobile 1 ms - Mb
hookdisplayHomeVeryBottom 1 ms - Mb
hookdisplayFooterBottomLeft 1 ms - Mb
hookdisplayMyNewHook 1 ms - Mb
hookdisplayRightColumnProduct 1 ms - Mb
hookactionDispatcher 1 ms - Mb
hookproductactions 1 ms - Mb
hookdisplayFooterBottomRight 1 ms - Mb
hookactionProductOutOfStock 1 ms - Mb
hookdisplayProductButtons 1 ms - Mb
hookdisplayMobileMenu 0 ms - Mb
hookdisplayFullWidthTop 0 ms - Mb
hookmoduleRoutes - ms - Mb
hookdisplayFullWidthTop2 - ms - Mb
39 hooks 217 ms 20.75 Mb
Module Time Memory Usage
belvg_samplemodule 32 ms - Mb
stproductlinknav 20 ms 0.25 Mb
steasycontent 11 ms 1.50 Mb
paypal 6 ms 0.50 Mb
stadvancedbanner 6 ms 1.00 Mb
stthemeeditor 6 ms 1.75 Mb
stiosslider 6 ms 0.75 Mb
blockcart_mod 6 ms - Mb
stmultilink 5 ms 1.25 Mb
stadvancedmenu 5 ms 0.25 Mb
productcomments 5 ms 0.50 Mb
blocksearch_mod 4 ms 0.25 Mb
blocknewsletter 4 ms 1.00 Mb
producttooltip 4 ms - Mb
statsdata 4 ms - Mb
sendtoashop 4 ms - Mb
loyalty 4 ms - Mb
crossselling 4 ms - Mb
staddthisbutton 4 ms - Mb
oneallsociallogin 3 ms - Mb
xtremecache 3 ms 1.50 Mb
uecookie 3 ms 0.75 Mb
stparallax 3 ms 1.25 Mb
stcompare 3 ms - Mb
rellink 3 ms - Mb
stblog 3 ms 0.25 Mb
stsocial 3 ms 0.25 Mb
stproductcategoriesslider 3 ms 0.25 Mb
seigiarenapl 2 ms 1.00 Mb
blockuserinfo_mod 2 ms 0.50 Mb
stcameraslideshow 2 ms 0.50 Mb
opinie 2 ms - Mb
strightbarcart 2 ms - Mb
stblogfeaturedarticles 2 ms 0.50 Mb
stblogrecentarticles 2 ms - Mb
dotpay 2 ms 0.75 Mb
sendtoafriend 2 ms 0.25 Mb
stbrandsslider 2 ms 0.25 Mb
sthomenew 2 ms 0.25 Mb
pinterestverification 2 ms 0.25 Mb
mailalerts 2 ms 0.25 Mb
pakomato 2 ms 0.50 Mb
epchangeselect 1 ms - Mb
sthoverimage 1 ms 0.50 Mb
mauticprestashop 1 ms - Mb
smartsupp 1 ms 0.50 Mb
pscleaner 1 ms 0.50 Mb
tecdoc 1 ms 0.25 Mb
socialnetworklinks 1 ms - Mb
stblogsearch 1 ms 0.25 Mb
gapi 1 ms - Mb
categorylist 1 ms 0.25 Mb
blockcategories 1 ms - Mb
stblogblockcategory 1 ms - Mb
fbtrackingpixel 1 ms 0.25 Mb
blockviewed 1 ms - Mb
epemailthemes 1 ms - Mb
paragonfaktura 1 ms - Mb
ganalytics 1 ms - Mb
taxon 1 ms - Mb
deleteordersfree 1 ms - Mb
removeiso 0 ms - Mb
ceneoxml 0 ms - Mb
vatnumber 0 ms - Mb
64 modules 217 ms 20.75 Mb

Stopwatch SQL - 526 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `am_specific_price` WHERE `id_product` != 0 LIMIT 1
86.2 25966 /classes/SpecificPrice.php:233
SELECT SQL_NO_CACHE p.`id_product`,p.`ean13`,
pl.`link_rewrite`,pl.`name`,
product_shop.`id_category_default`, 
MAX(image_shop.`id_image`) id_image
FROM `am_category_product` cp
LEFT JOIN `am_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN am_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `am_image` i
ON (i.`id_product` = p.`id_product`) LEFT JOIN am_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `am_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 255957
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog") 
AND cp.`position` <8112998
GROUP BY product_shop.id_product
ORDER BY cp.`position` DESC LIMIT 1
13.7 1084 Yes /modules/stproductlinknav/stproductlinknav.php:115
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 `am_configuration` c
LEFT JOIN `am_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
3.2 2161 /classes/Configuration.php:148
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(
"2018-01-18 00:00:00",
INTERVAL 45 DAY
)
) > 0 AS new
FROM `am_product` p 
INNER JOIN am_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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 `am_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `am_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `am_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 `am_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `am_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN am_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.`nr_oryginalu` LIKE "G052162A2" AND p.`id_product` != 765828  AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
ORDER BY quantity DESC
3.2 31 Yes /classes/Product.php:3734
SELECT SQL_NO_CACHE cp.date_add
FROM am_cart_product cp
WHERE cp.id_product = 765828 LIMIT 1
2.2 11562 /modules/producttooltip/producttooltip.php:144
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `am_hook_module` hm
STRAIGHT_JOIN `am_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `am_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.9 789 /classes/Hook.php:236
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `am_module` m
INNER JOIN am_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 `am_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `am_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `am_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `am_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") 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`
1.7 198 Yes Yes /override/classes/Hook.php:70
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `am_country` c  INNER JOIN am_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `am_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `am_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1.5 243 Yes /classes/Country.php:131
SELECT SQL_NO_CACHE e.* FROM `am_pojazd` e
INNER JOIN `am_pojazd_produkt` pp ON (pp.`id_pojazd` = e.`id_pojazd`)
INNER JOIN `am_product` p ON (pp.`id_produkt` = p.`id_product` AND  pp.`id_produkt` = 765828)
INNER JOIN `am_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
1.4 217 /modules/belvg_samplemodule/belvg_samplemodule.php:155
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 653184) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE * FROM `am_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.8 802 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 270734) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE p.`id_product`,p.`ean13`,
pl.`link_rewrite`,pl.`name`,
product_shop.`id_category_default`, 
MAX(image_shop.`id_image`) id_image
FROM `am_category_product` cp
LEFT JOIN `am_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN am_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `am_image` i
ON (i.`id_product` = p.`id_product`) LEFT JOIN am_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `am_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 255957
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog") 
AND cp.`position` >8112998
GROUP BY product_shop.id_product
ORDER BY cp.`position` ASC LIMIT 1
0.7 2 Yes /modules/stproductlinknav/stproductlinknav.php:115
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `am_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `am_module` m
0.7 181 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 765828) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 651314) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 748823) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 748797) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `am_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `am_module` m
0.6 181 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `am_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `am_module` m
0.6 181 /classes/module/Module.php:277
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 `am_product_attribute` pa
INNER JOIN am_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 am_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `am_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `am_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `am_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `am_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `am_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN am_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 765828
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.6 1 Yes Yes /classes/Product.php:3647
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `am_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `am_hook_alias` ha
INNER JOIN `am_hook` h ON ha.name = h.name
0.6 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `am_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `am_module` m
0.6 181 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 569175) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 652869) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 270732) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 108753) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 609454) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 632948) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 547004) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 121052) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 569174) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 765829) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 121279) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 270733) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE * FROM `am_state` ORDER BY `name` ASC
0.5 312 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 600041) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 654494) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 270730) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 74806) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 270731) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:364
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `am_image` i
INNER JOIN am_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `am_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 765828
ORDER BY `position`
0.5 1 Yes /classes/Product.php:2854
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM am_category c
LEFT JOIN am_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN am_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 23
AND c.nright >= 24
AND c.nleft >= 2
AND c.nright <= 1131
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.4 176 Yes /classes/Tools.php:1301
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 14, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `am_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 14) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 765828) AND `id_customer` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2018-01-18 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.4 2 Yes /classes/SpecificPrice.php:421
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 `am_category` c
INNER JOIN am_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `am_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `am_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 255957
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:658
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `am_meta` m
LEFT JOIN `am_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.3 41 Yes /classes/Dispatcher.php:452
Describe `am_st_easy_content` `id_category`
0.3 1 /modules/steasycontent/StEasyContentClass.php:161
Describe `am_st_easy_content` `id_category`
0.3 1 /modules/steasycontent/StEasyContentClass.php:161
SELECT SQL_NO_CACHE `id_page`
FROM `am_page`
WHERE `id_page_type` = 2 AND `id_object` = 765828 LIMIT 1
0.3 1 /classes/Page.php:77
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 651314) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `am_category` c
LEFT JOIN `am_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN am_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 22 Yes Yes /classes/Category.php:971
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 765830) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
Describe `am_st_easy_content` `id_category`
0.3 1 /modules/steasycontent/StEasyContentClass.php:161
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 765828)
0.3 1 /override/classes/Product.php:273
Describe `am_st_easy_content` `id_category`
0.3 1 /modules/steasycontent/StEasyContentClass.php:161
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 270731) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cp.`id_category`, cl.`description`, cl.`name`, cl.`link_rewrite` FROM `am_category_product` cp
LEFT JOIN `am_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `am_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN am_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 765828
AND cl.`id_lang` = 1
0.3 3 /classes/Product.php:2774
SELECT SQL_NO_CACHE tr.*
FROM `am_tax_rule` tr
JOIN `am_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 14
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.3 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.3 18 /override/classes/Product.php:348
Describe `am_st_easy_content` `id_category`
0.3 1 /modules/steasycontent/StEasyContentClass.php:161
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 6441.7191 AND t.price_max > 6441.7191)
WHERE (p.`id_product` = 600041)
0.3 4 /override/classes/Product.php:348
Describe `am_st_easy_content` `id_category`
0.3 1 /modules/steasycontent/StEasyContentClass.php:161
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 765828) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 748823) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_product FROM `am_category_product` WHERE `id_product` = 765828 AND `id_category` IN (255957) LIMIT 1
0.3 1 /classes/Product.php:5021
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 765828) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 765828) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cp.`id_category`, cl.`description`, cl.`name`, cl.`link_rewrite` FROM `am_category_product` cp
LEFT JOIN `am_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `am_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN am_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 765828
AND cl.`id_lang` = 1
0.3 3 /classes/Product.php:2774
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM am_shop_url su
LEFT JOIN am_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'superparts.pl' OR su.domain_ssl = 'superparts.pl')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.3 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 121052) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 270733) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 609454) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 547004) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 479.45 AND t.price_max > 479.45)
WHERE (p.`id_product` = 765828)
0.3 16 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 765829) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE position
FROM `am_category_product`
WHERE id_category = 255957
AND id_product = 765828
0.3 1 /modules/stproductlinknav/stproductlinknav.php:150
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `am_product` p
LEFT JOIN `am_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN am_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 1
AND pl.id_product = 765828
AND product_shop.active = 1 LIMIT 1
0.3 1 /classes/Meta.php:259
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.3 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (5001) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.3 8 Yes /modules/steasycontent/StEasyContentClass.php:184
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `am_image` i
INNER JOIN am_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 765828
AND image_shop.`cover` = 1 LIMIT 1
0.3 1 /classes/Product.php:2874
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `am_attribute` a
LEFT JOIN `am_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `am_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `am_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `am_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN am_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 am_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 765828
0.3 1 /classes/Product.php:5832
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 35.31 AND t.price_max > 35.31)
WHERE (p.`id_product` = 108753)
0.3 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE o.date_add
FROM am_order_detail od
LEFT JOIN am_orders o ON (od.id_order = o.id_order)
WHERE od.product_id = 765828 AND o.date_add >= '2017-12-18'
ORDER BY o.date_add DESC LIMIT 1
0.3 1 Yes /modules/producttooltip/producttooltip.php:132
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 28.59 AND t.price_max > 28.59)
WHERE (p.`id_product` = 569174)
0.3 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 30.23 AND t.price_max > 30.23)
WHERE (p.`id_product` = 547004)
0.3 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 569175) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 479.45 AND t.price_max > 479.45)
WHERE (p.`id_product` = 765828)
0.2 16 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 35.1657 AND t.price_max > 35.1657)
WHERE (p.`id_product` = 569174)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 23.755605 AND t.price_max > 23.755605)
WHERE (p.`id_product` = 651314)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 270732) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 270734
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 270730) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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 am_shop_group gs
LEFT JOIN am_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN am_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.2 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 748797) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (34) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (120,480,490,500,510,910,920,930,940,520,570) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 569174) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE spg.*, spgl.`title`
FROM `am_st_parallax_group` spg
INNER JOIN am_st_parallax_group_shop st_parallax_group_shop
ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1)
LEFT JOIN `am_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`)
WHERE spgl.`id_lang` = 1
ORDER BY spg.`location`, spg.`position`
0.2 1 Yes /modules/stparallax/StParallaxGroup.php:140
SELECT SQL_NO_CACHE id_tab, class_name FROM `am_tab`
0.2 168 /classes/Tab.php:296
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 108753) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 632948) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 121279) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 124.63 AND t.price_max > 124.63)
WHERE (p.`id_product` = 121052)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 270734) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(*) as count, AVG(stars) as avg FROM am_opinie WHERE active = 1 ORDER BY date ASC LIMIT 1
0.2 225 /modules/opinie/opinie.php:94
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 74806) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 600041) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 652869) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 632948)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name`
FROM `am_product_comment_criterion` pcc
LEFT JOIN `am_product_comment_criterion_lang` pccl
ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion)
LEFT JOIN `am_product_comment_criterion_product` pccp
ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 765828)
LEFT JOIN `am_product_comment_criterion_category` pccc
ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`)
LEFT JOIN `am_product_shop` ps
ON (ps.id_category_default = pccc.id_category AND ps.id_product = 765828)
WHERE pccl.`id_lang` = 1
AND (
pccp.id_product IS NOT NULL
OR ps.id_product IS NOT NULL
OR pcc.id_product_comment_criterion_type = 1
)
AND pcc.active = 1
GROUP BY pcc.id_product_comment_criterion
0.2 1 Yes /modules/productcomments/ProductCommentCriterion.php:184
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (24) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
Describe `am_st_easy_content` `id_category`
0.2 1 /modules/steasycontent/StEasyContentClass.php:161
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 654494) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 223.87 AND t.price_max > 223.87)
WHERE (p.`id_product` = 632948)
0.2 14 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 569175)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 108753 LIMIT 1
0.2 1 /classes/Product.php:762
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 108753
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 5237.17 AND t.price_max > 5237.17)
WHERE (p.`id_product` = 600041)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 121052
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 479.45 AND t.price_max > 479.45)
WHERE (p.`id_product` = 765828)
0.2 16 /override/classes/Product.php:348
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (18) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 19.3135 AND t.price_max > 19.3135)
WHERE (p.`id_product` = 651314)
0.2 9 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 765828
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
UPDATE `am_smarty_lazy_cache`
SET filepath='crossselling/productfooter/765828/1/1/1/1/14/7a/6e/ce/7a6ece7eb55ad880abce812dd746f66c007437ce.crossselling.tpl.php'
WHERE `template_hash`='264a7c52255fdc080e8f6815f19aa482' AND cache_id="crossselling|productfooter|765828|1|1|1|1|14" AND compile_id=""
0.2 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE *
FROM `am_currency` c
INNER JOIN am_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.2 1 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 169.942 AND t.price_max > 169.942)
WHERE (p.`id_product` = 748823)
0.2 14 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 479.45 AND t.price_max > 479.45)
WHERE (p.`id_product` = 765828)
0.2 16 /override/classes/Product.php:348
Describe `am_st_easy_content` `id_category`
0.2 1 /modules/steasycontent/StEasyContentClass.php:161
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_advanced_banner_group` smsg
INNER JOIN am_st_advanced_banner_group_shop st_advanced_banner_group_shop
ON (st_advanced_banner_group_shop.id_st_advanced_banner_group = smsg.id_st_advanced_banner_group AND st_advanced_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1 AND smsg.`id_parent`=0  AND smsg.`location` IN (21)
ORDER BY smsg.`position`
0.2 6 Yes /modules/stadvancedbanner/StAdvancedBannerGroup.php:239
INSERT INTO `am_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('14485323', '499181', '911429940', '', '1', '1', '2018-01-18 09:31:37')
0.2 1 /classes/ObjectModel.php:487
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 651314
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 741.69 AND t.price_max > 741.69)
WHERE (p.`id_product` = 569175)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 388.03 AND t.price_max > 388.03)
WHERE (p.`id_product` = 270732)
0.2 16 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 653184) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_advanced_banner_group` smsg
INNER JOIN am_st_advanced_banner_group_shop st_advanced_banner_group_shop
ON (st_advanced_banner_group_shop.id_st_advanced_banner_group = smsg.id_st_advanced_banner_group AND st_advanced_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1 AND smsg.`id_parent`=0  AND smsg.`location` IN (18)
ORDER BY smsg.`position`
0.2 6 Yes /modules/stadvancedbanner/StAdvancedBannerGroup.php:239
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `am_category_product` cp
INNER JOIN `am_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 765828 AND ctg.`id_group` = 1 LIMIT 1
0.2 3 /classes/Product.php:5052
SELECT SQL_NO_CACHE tr.*
FROM `am_tax_rule` tr
JOIN `am_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 14
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.2 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_iosslider_group` smsg
INNER JOIN am_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (18)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 43.4313 AND t.price_max > 43.4313)
WHERE (p.`id_product` = 108753)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_advanced_banner_group` smsg
INNER JOIN am_st_advanced_banner_group_shop st_advanced_banner_group_shop
ON (st_advanced_banner_group_shop.id_st_advanced_banner_group = smsg.id_st_advanced_banner_group AND st_advanced_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1 AND smsg.`id_parent`=0  AND smsg.`location` IN (22)
ORDER BY smsg.`position`
0.2 6 Yes /modules/stadvancedbanner/StAdvancedBannerGroup.php:239
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 43.4313 AND t.price_max > 43.4313)
WHERE (p.`id_product` = 108753)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 600041
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 153.2949 AND t.price_max > 153.2949)
WHERE (p.`id_product` = 121052)
0.2 14 /override/classes/Product.php:348
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_iosslider_group` smsg
INNER JOIN am_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
0.2 1 /modules/stiosslider/StIosSliderGroup.php:156
SELECT SQL_NO_CACHE *
FROM `am_manufacturer` a
LEFT JOIN `am_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `am_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 895) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 23.755605 AND t.price_max > 23.755605)
WHERE (p.`id_product` = 651314)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 25.54 AND t.price_max > 25.54)
WHERE (p.`id_product` = 121279)
0.2 10 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 121052)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 653184
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_camera_slideshow_group` smsg
INNER JOIN am_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (19,20)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 121279)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 121279
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 653184)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 25.02 AND t.price_max > 25.02)
WHERE (p.`id_product` = 609454)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 25.54 AND t.price_max > 25.54)
WHERE (p.`id_product` = 121279)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_category` a
LEFT JOIN `am_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `am_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 255957) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 569174)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 765828) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 32.5581 AND t.price_max > 32.5581)
WHERE (p.`id_product` = 270730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 748797
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 547004)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 603 AND t.price_max > 603)
WHERE (p.`id_product` = 569175)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 153.2949 AND t.price_max > 153.2949)
WHERE (p.`id_product` = 121052)
0.2 14 /override/classes/Product.php:348
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (33) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 275.3601 AND t.price_max > 275.3601)
WHERE (p.`id_product` = 632948)
0.2 15 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 35.1657 AND t.price_max > 35.1657)
WHERE (p.`id_product` = 569174)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 31.4142 AND t.price_max > 31.4142)
WHERE (p.`id_product` = 121279)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 30.7746 AND t.price_max > 30.7746)
WHERE (p.`id_product` = 609454)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 124.63 AND t.price_max > 124.63)
WHERE (p.`id_product` = 121052)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 19.3135 AND t.price_max > 19.3135)
WHERE (p.`id_product` = 653184)
0.2 9 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 34.8688 AND t.price_max > 34.8688)
WHERE (p.`id_product` = 748797)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 270730
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 19.3135 AND t.price_max > 19.3135)
WHERE (p.`id_product` = 651314)
0.2 9 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 609454)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_advanced_banner_group` smsg
INNER JOIN am_st_advanced_banner_group_shop st_advanced_banner_group_shop
ON (st_advanced_banner_group_shop.id_st_advanced_banner_group = smsg.id_st_advanced_banner_group AND st_advanced_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1 AND smsg.`id_parent`=0  AND smsg.`location` IN (16)
ORDER BY smsg.`position`
0.2 6 Yes /modules/stadvancedbanner/StAdvancedBannerGroup.php:239
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 30.7746 AND t.price_max > 30.7746)
WHERE (p.`id_product` = 609454)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 35.31 AND t.price_max > 35.31)
WHERE (p.`id_product` = 108753)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 74806
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (31) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 25.02 AND t.price_max > 25.02)
WHERE (p.`id_product` = 609454)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM am_theme t
LEFT JOIN am_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN am_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =5 AND m.page = "product" LIMIT 1
0.2 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 569174
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 31.4142 AND t.price_max > 31.4142)
WHERE (p.`id_product` = 121279)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_category` a
LEFT JOIN `am_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `am_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 255936) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 28.59 AND t.price_max > 28.59)
WHERE (p.`id_product` = 569174)
0.2 10 /override/classes/Product.php:348
INSERT INTO `am_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', '', '0')
0.2 1 /classes/ObjectModel.php:487
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 26.47 AND t.price_max > 26.47)
WHERE (p.`id_product` = 270730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 32.5581 AND t.price_max > 32.5581)
WHERE (p.`id_product` = 270730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 42.888624 AND t.price_max > 42.888624)
WHERE (p.`id_product` = 748797)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 569175
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 479.45 AND t.price_max > 479.45)
WHERE (p.`id_product` = 765828)
0.2 16 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 651314)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE pc.`id_product_comment`,
(SELECT count(*) FROM `am_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `am_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, 
IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `am_product_comment` pc
LEFT JOIN `am_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 765828
ORDER BY pc.`date_add` DESC
0.2 1 Yes /modules/productcomments/ProductComment.php:114
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 1414.6845 AND t.price_max > 1414.6845)
WHERE (p.`id_product` = 270734)
0.2 20 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 169.942 AND t.price_max > 169.942)
WHERE (p.`id_product` = 748823)
0.2 14 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 31.28 AND t.price_max > 31.28)
WHERE (p.`id_product` = 74806)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 1150.15 AND t.price_max > 1150.15)
WHERE (p.`id_product` = 270734)
0.2 20 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 34.8688 AND t.price_max > 34.8688)
WHERE (p.`id_product` = 748797)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_iosslider_group` smsg
INNER JOIN am_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (20)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='0016ab6058befa741bf9bc3316ba7810' AND cache_id="steasycontent|1|1|1|1|14_5001_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `am_product_lang`
WHERE `id_product` = 765828 AND `id_shop` = 1
0.2 2 /Adapter/Adapter_EntityMapper.php:68
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 748797)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 589.7235 AND t.price_max > 589.7235)
WHERE (p.`id_product` = 765828)
0.2 18 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 108753)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 31.28 AND t.price_max > 31.28)
WHERE (p.`id_product` = 74806)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE o.id_order
FROM am_orders o
LEFT JOIN am_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1 AND od.product_id IN (765828)
0.2 1 /modules/crossselling/crossselling.php:133
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='6c3b44364ec9b6ed7d9b943e2312fbdf' AND cache_id="steasycontent|1|1|1|1|14_120_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 1414.6845 AND t.price_max > 1414.6845)
WHERE (p.`id_product` = 270734)
0.2 20 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 23.755605 AND t.price_max > 23.755605)
WHERE (p.`id_product` = 653184)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_iosslider_group` smsg
INNER JOIN am_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (21)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM am_tag t
LEFT JOIN am_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=765828
0.2 1 /classes/Tag.php:205
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 17.3061 AND t.price_max > 17.3061)
WHERE (p.`id_product` = 654494)
0.2 9 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 748823)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 765828 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `am_st_multi_link_group` smlg
INNER JOIN am_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `am_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (23) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.2 5 Yes /modules/stmultilink/StMultiLinkGroup.php:141
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 209.02866 AND t.price_max > 209.02866)
WHERE (p.`id_product` = 748823)
0.2 14 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 1150.15 AND t.price_max > 1150.15)
WHERE (p.`id_product` = 270734)
0.2 20 /override/classes/Product.php:348
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_iosslider_group` smsg
INNER JOIN am_st_iosslider_group_shop st_iosslider_group_shop
ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (11)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stiosslider/StIosSliderGroup.php:255
SELECT SQL_NO_CACHE value FROM am_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
0.2 1 /classes/cache/CacheFs.php:36
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 19.3135 AND t.price_max > 19.3135)
WHERE (p.`id_product` = 653184)
0.2 9 /override/classes/Product.php:348
SELECT SQL_NO_CACHE smsg.*
FROM `am_st_camera_slideshow_group` smsg
INNER JOIN am_st_camera_slideshow_group_shop st_camera_slideshow_group_shop
ON (st_camera_slideshow_group_shop.id_st_camera_slideshow_group = smsg.id_st_camera_slideshow_group AND st_camera_slideshow_group_shop.id_shop = 1)
WHERE smsg.`active`=1  AND smsg.`location` IN (11)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 603 AND t.price_max > 603)
WHERE (p.`id_product` = 569175)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 26.47 AND t.price_max > 26.47)
WHERE (p.`id_product` = 270730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `id_guest`
FROM `am_connections`
WHERE `id_guest` = 14485323
AND `date_add` > '2018-01-18 09:01:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.2 1 Yes /classes/Connection.php:138
SELECT SQL_NO_CACHE p.id_product
FROM `am_product` p
INNER JOIN am_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 765828
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2018-01-18 00:00:00",
INTERVAL 45 DAY
)
) > 0
0.2 0 /classes/Product.php:1289
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 741.69 AND t.price_max > 741.69)
WHERE (p.`id_product` = 569175)
0.2 18 /override/classes/Product.php:348
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='053be851af97e4a8529bd68fe96ffca2' AND cache_id="stadvancedmenu|1|1|1|1|14" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 209.02866 AND t.price_max > 209.02866)
WHERE (p.`id_product` = 748823)
0.2 14 /override/classes/Product.php:348
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `am_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 255957 LIMIT 1
0.2 1 /classes/Category.php:1166
SELECT SQL_NO_CACHE 1 FROM `am_specific_price` WHERE `to` BETWEEN '2018-01-18 00:00:00' AND '2018-01-18 23:59:59' LIMIT 1
0.2 1 /classes/SpecificPrice.php:308
SELECT SQL_NO_CACHE spcs.*
FROM `am_st_product_categories_slider` spcs
WHERE 1  AND spcs.id_shop = 1  AND spcs.`active`=1  AND spcs.`display_on`&16384
ORDER BY spcs.`position`
0.2 2 Yes /modules/stproductcategoriesslider/StProductCategoriesSliderClass.php:143
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='a896b106e50e0be11dd08a7566fd9486' AND cache_id="stadvancedbanner|1|1|1|1|14_16_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 477.2769 AND t.price_max > 477.2769)
WHERE (p.`id_product` = 270732)
0.2 16 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 270730)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `am_lang` l
JOIN am_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.2 1 /classes/Language.php:894
SELECT SQL_NO_CACHE * FROM `am_image_type`
0.2 15 /classes/ImageType.php:143
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 748823
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 477.2769 AND t.price_max > 477.2769)
WHERE (p.`id_product` = 270732)
0.2 16 /override/classes/Product.php:348
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='20151b0a6f677b3bbfd32d21fe4e8916' AND cache_id="stproductcategoriesslider|1|1|1|1|14" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `am_category` a
LEFT JOIN `am_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `am_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 255954) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 101.9 AND t.price_max > 101.9)
WHERE (p.`id_product` = 270733)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 270732
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 609454
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 270733)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 569174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 895
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 42.888624 AND t.price_max > 42.888624)
WHERE (p.`id_product` = 748797)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE position
FROM `am_category_product`
WHERE id_category = 255957
AND id_product = 765828
0.2 1 /modules/stproductlinknav/stproductlinknav.php:150
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 74806) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 765828 LIMIT 1
0.2 1 /classes/Product.php:762
SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
FROM `am_st_easy_content` sec
INNER JOIN am_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`location` IN (32) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 270734)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 6441.7191 AND t.price_max > 6441.7191)
WHERE (p.`id_product` = 600041)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_group` a
LEFT JOIN `am_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 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 14.07 AND t.price_max > 14.07)
WHERE (p.`id_product` = 654494)
0.2 8 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 270732)
0.2 1 /override/classes/Product.php:273
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 600041)
0.2 1 /override/classes/Product.php:273
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 765829)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 125.337 AND t.price_max > 125.337)
WHERE (p.`id_product` = 270733)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='a896b106e50e0be11dd08a7566fd9486' AND cache_id="stadvancedbanner|1|1|1|1|14_21_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 125.337 AND t.price_max > 125.337)
WHERE (p.`id_product` = 270733)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 270733
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE f.*
FROM `am_st_easy_content_font` f
LEFT JOIN `am_st_easy_content` ec ON (f.`id_st_easy_content` = ec.`id_st_easy_content`)
WHERE ec.`active`=1
0.2 1 /modules/steasycontent/StEasyContentFontClass.php:63
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 632948
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 30.23 AND t.price_max > 30.23)
WHERE (p.`id_product` = 765829)
0.2 10 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 654494)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 275.3601 AND t.price_max > 275.3601)
WHERE (p.`id_product` = 632948)
0.2 15 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 38.4744 AND t.price_max > 38.4744)
WHERE (p.`id_product` = 74806)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 37.1829 AND t.price_max > 37.1829)
WHERE (p.`id_product` = 547004)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_image` a
LEFT JOIN `am_image_shop` `c` ON a.`id_image` = c.`id_image` AND c.`id_shop` = 1
WHERE (a.`id_image` = 512725) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `am_country` a
LEFT JOIN `am_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 14) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 74806)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE 1 FROM `am_specific_price` WHERE `from` BETWEEN '2018-01-18 00:00:00' AND '2018-01-18 23:59:59' LIMIT 1
0.2 1 /classes/SpecificPrice.php:304
SELECT SQL_NO_CACHE *
FROM `am_image_lang`
WHERE `id_image` = 512725
0.2 2 /Adapter/Adapter_EntityMapper.php:68
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 652869)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 654494
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 5237.17 AND t.price_max > 5237.17)
WHERE (p.`id_product` = 600041)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 101.9 AND t.price_max > 101.9)
WHERE (p.`id_product` = 270733)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url`
FROM `am_st_multi_link_group` smlg
INNER JOIN am_st_multi_link_group_shop st_multi_link_group_shop
ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1)
LEFT JOIN `am_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`)
WHERE smlg.`active`=1  AND smlg.`location` IN (22) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.2 5 Yes /modules/stmultilink/StMultiLinkGroup.php:141
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 3950 AND t.price_max > 3950)
WHERE (p.`id_product` = 270731)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 37.1829 AND t.price_max > 37.1829)
WHERE (p.`id_product` = 547004)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 37.1829 AND t.price_max > 37.1829)
WHERE (p.`id_product` = 765829)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 547004
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 765829
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE * FROM `am_hook_alias`
0.2 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 388.03 AND t.price_max > 388.03)
WHERE (p.`id_product` = 270732)
0.2 16 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 38.4744 AND t.price_max > 38.4744)
WHERE (p.`id_product` = 74806)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='622fb4e1788c57111d693fd67202cb85' AND cache_id="stadvancedmenu|1|1|1|1|14" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 14.07 AND t.price_max > 14.07)
WHERE (p.`id_product` = 654494)
0.2 8 /override/classes/Product.php:348
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 121052 LIMIT 1
0.2 1 /classes/Product.php:762
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='e15f3256bd353e80c73803bebfc159d4' AND cache_id="steasycontent|1|1|1|1|14" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 121279 LIMIT 1
0.2 1 /classes/Product.php:762
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 270731
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 17.3061 AND t.price_max > 17.3061)
WHERE (p.`id_product` = 654494)
0.2 9 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 4858.5 AND t.price_max > 4858.5)
WHERE (p.`id_product` = 270731)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 73.378 AND t.price_max > 73.378)
WHERE (p.`id_product` = 652869)
0.2 12 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 223.87 AND t.price_max > 223.87)
WHERE (p.`id_product` = 632948)
0.2 14 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 37.1829 AND t.price_max > 37.1829)
WHERE (p.`id_product` = 765829)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 30.23 AND t.price_max > 30.23)
WHERE (p.`id_product` = 765829)
0.2 10 /override/classes/Product.php:348
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,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `am_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` = 270731)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='737de67756ed8ed3cfc26e9120791af8' AND cache_id="stproductcategoriesslider|1|1|1|1|14" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='6b6db30114a719b5528701ff58721ce4' AND cache_id="staddthisbutton|1|1|1|1|14_1" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 30.23 AND t.price_max > 30.23)
WHERE (p.`id_product` = 547004)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 4858.5 AND t.price_max > 4858.5)
WHERE (p.`id_product` = 270731)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 600041) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 632948 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='73f17e45c091e5f28ed9d0f67243843f' AND cache_id="stiosslider|1|1|1|1|14_18_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 90.25494 AND t.price_max > 90.25494)
WHERE (p.`id_product` = 652869)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 108753 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 3950 AND t.price_max > 3950)
WHERE (p.`id_product` = 270731)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_currency` a
LEFT JOIN `am_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 23.755605 AND t.price_max > 23.755605)
WHERE (p.`id_product` = 653184)
0.2 10 /override/classes/Product.php:348
INSERT IGNORE INTO `am_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('264a7c52255fdc080e8f6815f19aa482',"crossselling|productfooter|765828|1|1|1|1|14","", FROM_UNIXTIME(1516264297))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'large_default' LIMIT 1
0.2 1 /classes/Image.php:470
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 547004 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `reduction`
FROM `am_group`
WHERE `id_group` = 1 LIMIT 1
0.2 1 /classes/Group.php:133
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='a896b106e50e0be11dd08a7566fd9486' AND cache_id="stadvancedbanner|1|1|1|1|14_22_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE s.id_searchterm, s.term,s.url,s.title,s.description 
FROM am_searchterm s
0.2 3 /override/classes/Dispatcher.php:16
SELECT SQL_NO_CACHE value FROM `am_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.2 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 609454 LIMIT 1
0.2 1 /classes/Product.php:762
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 108753) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_module` FROM `am_module_shop` WHERE `id_module` = 270 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 73.378 AND t.price_max > 73.378)
WHERE (p.`id_product` = 652869)
0.1 12 /override/classes/Product.php:348
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='d28b95db49788b1d1b8263494df7a4e0' AND cache_id="steasycontent|1|1|1|1|14_24_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `am_currency` c
LEFT JOIN am_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.1 1 /classes/Currency.php:472
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 547004
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='6f14e48b7e04581079e7854bd2efc7af' AND cache_id="stblogfeaturedarticles|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 270730 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM am_feature_product pf
LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
WHERE pf.id_product = 652869
ORDER BY f.position ASC
0.1 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "stblog" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `am_lang` a
LEFT JOIN `am_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='a2559c043acd795325e4866e0749d06c' AND cache_id="sthomenew|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "blockwishlist" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='107d6d127ce406c5bf5c17e7eec10bf1' AND cache_id="stmultilink|1|1|1|1|14_1_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 121279) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE id_shop
FROM `am_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 609454) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='73f17e45c091e5f28ed9d0f67243843f' AND cache_id="stiosslider|1|1|1|1|14_20_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 270730) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "blockcart" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= 90.25494 AND t.price_max > 90.25494)
WHERE (p.`id_product` = 652869)
0.1 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 270733 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 121052) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='53caaef872ac40aba31947655eb7a882' AND cache_id="stmultilink|1|1|1|1|14_3_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='a896b106e50e0be11dd08a7566fd9486' AND cache_id="stadvancedbanner|1|1|1|1|14_18_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 108753 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='73f17e45c091e5f28ed9d0f67243843f' AND cache_id="stiosslider|1|1|1|1|14_21_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='a778d25874f7f684f2d05e4224a1225b' AND cache_id="stcameraslideshow|1|1|1|1|14_11_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 569175) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_hreflangmap`, `iso_language_code`, `iso_country_code`, `id_lang` FROM `am_rellink`WHERE `id_shop` is NULL AND `id_shop_group` is NULL
0.1 2 /modules/rellink/classes/HrefLangMapCollection.php:193
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 270734) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
FROM `am_product_comment` pc
WHERE `id_product` = 765828
AND `grade` > 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:261
SELECT SQL_NO_CACHE domain, domain_ssl
FROM am_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE *
FROM `am_country_lang`
WHERE `id_country` = 14
0.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='a66f1eeb4de47a0eef8673047bf6aa65' AND cache_id="stadvancedmenu|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion`
FROM `am_product_comment` pc
LEFT JOIN `am_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`)
LEFT JOIN `am_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
LEFT JOIN `am_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
WHERE pc.`id_product` = 765828
AND pccl.`id_lang` = 1
0.1 1 /modules/productcomments/ProductComment.php:168
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM am_shop s
LEFT JOIN am_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN am_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.1 1 /classes/shop/Shop.php:203
SELECT SQL_NO_CACHE pa.`id_product_attribute`
FROM `am_product_attribute` pa
INNER JOIN am_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` = 765828
ORDER BY product_attribute_shop.`price` DESC LIMIT 1
0.1 1 Yes /classes/Product.php:3335
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 748797) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 632948 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='95c96299e93c0f875b73c4890affa4f3' AND cache_id="stsocial|1|1|1|1|14_stsocial" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 569174 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 765828 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE f.*
FROM `am_st_advanced_banner_font` f
LEFT JOIN `am_st_advanced_banner` ios ON (f.`id_st_advanced_banner` = ios.`id_st_advanced_banner`)
WHERE 1  AND ios.`active`=1
0.1 1 /modules/stadvancedbanner/StAdvancedBannerFontClass.php:63
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 651314) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 547004 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 488
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 121279 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 609454
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 569174 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE *
FROM `am_group_lang`
WHERE `id_group` = 1
0.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `id_country`
FROM `am_country`
WHERE `iso_code` = 'PL' LIMIT 1
0.1 1 /classes/Country.php:174
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='c36c1588a08908875cfd046c738ba388' AND cache_id="steasycontent|1|1|1|1|14_3_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 121052 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 609454 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE *
FROM `am_tax_lang`
WHERE `id_tax` = 1
0.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'home_default' LIMIT 1
0.1 1 /classes/Image.php:470
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 270733
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE *
FROM `am_country` a
LEFT JOIN `am_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `am_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 14) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 121052
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='73f17e45c091e5f28ed9d0f67243843f' AND cache_id="stiosslider|1|1|1|1|14_11_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 569174
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='50cb8fe75b300257227c8f30f3fb5fb5' AND cache_id="pinterestverification|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='284fb6d21e56bbaa0338e0d6194959f7' AND cache_id="blocksearch_mod|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 748823) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='d28b95db49788b1d1b8263494df7a4e0' AND cache_id="steasycontent|1|1|1|1|14_18_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 632948
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `am_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 255957 LIMIT 1
0.1 1 /classes/Category.php:1166
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='04d564bffbaabc0fffdcbedad2b11081' AND cache_id="stparallax|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='edc1bde1592e10517dfb3508b0f79ad3' AND cache_id="stmultilink|1|1|1|1|14_23_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 569175
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 121052 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 609454 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.1 1 /classes/Image.php:470
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `am_product_comment` pc
WHERE pc.`id_product` = 765828
AND pc.`deleted` = 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:197
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 270730 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "paypal" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 569174 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE *
FROM `am_product_comment` pc
WHERE pc.`id_product` = 765828
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
0.1 1 Yes /modules/productcomments/ProductComment.php:137
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 121279 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `am_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='beb94bf7f33cc387907bccba48174ec1' AND cache_id="stbrandsslider|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'small_default' LIMIT 1
0.1 1 /classes/Image.php:470
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'cart_default' LIMIT 1
0.1 1 /classes/Image.php:470
SELECT SQL_NO_CACHE out_of_stock
FROM `am_stock_available`
WHERE (id_product = 765828) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "blocklayered" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE f.*
FROM `am_st_iosslider_font` f
LEFT JOIN `am_st_iosslider` ios ON (f.`id_st_iosslider` = ios.`id_st_iosslider`)
WHERE ios.`id_st_iosslider_group` IN (1) 
AND ios.`active`=1
0.1 1 /modules/stiosslider/StIosSliderFontClass.php:73
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 547004 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='edc1bde1592e10517dfb3508b0f79ad3' AND cache_id="stmultilink|1|1|1|1|14_22_location" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 270732) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'big_default' LIMIT 1
0.1 1 /classes/Image.php:470
SELECT SQL_NO_CACHE id_page_type
FROM am_page_type
WHERE name = 'product' LIMIT 1
0.1 1 /classes/Page.php:97
SELECT SQL_NO_CACHE `id_module` FROM `am_module_shop` WHERE `id_module` = 280 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE id_shop
FROM `am_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `am_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 255957 LIMIT 1
0.1 0 /classes/Category.php:1166
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `am_lang` l
LEFT JOIN `am_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.1 1 /classes/Language.php:777
SELECT SQL_NO_CACHE f.*
FROM `am_st_parallax_font` f
LEFT JOIN `am_st_parallax` ios ON (f.`id_st_parallax` = ios.`id_st_parallax`)
WHERE ios.`id_st_parallax_group` IN (1) 
AND ios.`active`=1
0.1 1 /modules/stparallax/StParallaxFontClass.php:73
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM am_required_field
0.1 1 /classes/ObjectModel.php:1368
SELECT SQL_NO_CACHE version FROM `am_module` WHERE name = 'paypal' LIMIT 1
0.1 1 /modules/paypal/paypal.php:282
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 600041 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 765829) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 270733) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 748823
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 270731) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='1dfc803e4db6bc8225fe845b49a09d13' AND cache_id="stsocial|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 748797 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='04073373e27294ca99fb1d0f6f452112' AND cache_id="stadvancedbanner|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='264a7c52255fdc080e8f6815f19aa482' AND cache_id="crossselling|productfooter|765828|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 765829 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 748797 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 547004) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 652869
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 632948 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 632948) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 654494 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 270734 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 654494) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE id_shop
FROM `am_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE `name` FROM `am_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.1 0 /classes/Supplier.php:192
SELECT SQL_NO_CACHE id_shop
FROM `am_category_shop`
WHERE `id_category` = 255957
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 748823 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 652869) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `am_smarty_last_flush` WHERE type='compile' LIMIT 1
0.1 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 569175 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 270731
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 748823 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 653184) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 569175 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 748797 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE depends_on_stock
FROM `am_stock_available`
WHERE (id_product = 765828) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE `id_product_download`
FROM `am_product_download`
WHERE `id_product` = 765828
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1
0.1 0 /classes/ProductDownload.php:184
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 651314 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 652869 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 653184 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 653184 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `am_pack` a
WHERE a.`id_product_item` = 765828 LIMIT 1
0.1 1 /classes/Pack.php:251
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 270732 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "blockviewed" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 270734 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 651314
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM am_category
WHERE id_category = 2 LIMIT 1
0.1 1 /classes/Category.php:1589
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 748823 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 270734 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 270733 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `id_module` FROM `am_module_shop` WHERE `id_module` = 100 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 199
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 270731 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 748797
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "blockcategories" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
WHERE `template_hash`='ed6c6c031658489ac193715c2708d46b' AND cache_id="stblogrecentarticles|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 979
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 270730 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `am_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 50874 LIMIT 1
0.1 1 /classes/Category.php:1166
SELECT SQL_NO_CACHE id_shop
FROM `am_product_shop`
WHERE `id_product` = 765828
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 10831
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `am_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 255954 LIMIT 1
0.1 1 /classes/Category.php:1166
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 651314 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE COUNT(*) FROM `am_pack` WHERE id_product_pack = 765828 LIMIT 1
0.1 1 /classes/Pack.php:50
SELECT SQL_NO_CACHE `id_module` FROM `am_module_shop` WHERE `id_module` = 296 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 74806 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM am_product_attribute pa
INNER JOIN am_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 = 74806 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 270732
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `id_module` FROM `am_module_shop` WHERE `id_module` = 90 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 569175 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `am_product_comment` pc
WHERE `id_product` = 765828 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:240
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 600041 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 654494 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 270732 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 765829 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 653184
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 270730
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `am_smarty_last_flush` WHERE type='template' LIMIT 1
0.1 1 /classes/SmartyCustom.php:142
INSERT IGNORE INTO `am_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('264a7c52255fdc080e8f6815f19aa482',"crossselling|productfooter|765828|1|1|1|1|14","", FROM_UNIXTIME(1516264297))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 121279
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE *
FROM `am_lang` a
LEFT JOIN `am_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 651314 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 765829
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 11808
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 600041
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 74806
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 652869 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 270734
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 270731 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 654494
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM am_category
WHERE id_category = 255957 LIMIT 1
0.1 1 /classes/Category.php:1589
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 270733 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `am_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 10507
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 108753
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE *
FROM `am_theme` a
WHERE (a.`id_theme` = 5) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 600041 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 74806 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 765829 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 654494 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 653184 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `am_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 270732 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 652869 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 270731 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149

Doubles

99
SELECT IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= XX.XX AND t.price_max > XX.XX)
WHERE (p.`id_product` = XX)
25
SELECT *
FROM `am_product` a
LEFT JOIN `am_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
23
				SELECT `priority`, `id_specific_price_priority`
				FROM `am_specific_price_priority`
				WHERE `id_product` = XX
				ORDER BY `id_specific_price_priority` DESC LIMIT XX
23
SELECT product_attribute_shop.id_product_attribute
				FROM am_product_attribute pa
				 INNER JOIN am_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
				WHERE pa.id_product = XX LIMIT XX
23
			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `am_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
23
							SELECT `id_tax_rules_group`
							FROM `am_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
23
			SELECT `reduction`
			FROM `am_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
23
SELECT SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
23
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on,
p.`forcePrice`
FROM `am_product` p
INNER JOIN `am_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `am_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
22
                                SELECT name, value, pf.id_feature
                                FROM am_feature_product pf
                                LEFT JOIN am_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX)
                                LEFT JOIN am_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
                                LEFT JOIN am_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
                                WHERE pf.id_product = XX
                                ORDER BY f.position ASC
8
Describe `am_st_easy_content` `id_category`
7
			SELECT sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop`
			FROM `am_st_easy_content` sec
			 INNER JOIN am_st_easy_content_shop st_easy_content_shop
		ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = XX)
			LEFT JOIN `am_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
			WHERE secl.`id_lang` = XX AND sec.`location` IN (XX) AND sec.`active`=XX 
            ORDER BY sec.`position`,sec.`location`
7
				SELECT `name`
				FROM `am_manufacturer`
				WHERE `id_manufacturer` = XX
				AND `active` = XX LIMIT XX
5
SELECT `id_module` FROM `am_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
5
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="steasycontent|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX
5
			SELECT cl.`link_rewrite`
			FROM `am_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
4
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="stmultilink|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX
4
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="stiosslider|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX
4
SELECT IF(tp.value,tp.value,t.value) as value,p.`id_product`,p.`on_sale`
FROM `am_product` p
LEFT JOIN `am_taxon_prefiks` `tp` ON (p.supplier_reference = tp.supplier_reference)
INNER JOIN `am_taxon` t ON (t.price_min <= XX AND t.price_max > XX)
WHERE (p.`id_product` = XX)
4
			SELECT smsg.*
			FROM `am_st_iosslider_group` smsg
			 INNER JOIN am_st_iosslider_group_shop st_iosslider_group_shop
		ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = XX)
			WHERE smsg.`active`=XX  AND smsg.`location` IN (XX)
            ORDER BY smsg.`position`
4
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="stadvancedbanner|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX
4
			SELECT smsg.*
			FROM `am_st_advanced_banner_group` smsg
			 INNER JOIN am_st_advanced_banner_group_shop st_advanced_banner_group_shop
		ON (st_advanced_banner_group_shop.id_st_advanced_banner_group = smsg.id_st_advanced_banner_group AND st_advanced_banner_group_shop.id_shop = XX)
			WHERE smsg.`active`=XX AND smsg.`id_parent`=XX  AND smsg.`location` IN (XX)
            ORDER BY smsg.`position`
4
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `am_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `am_module` m
3
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `am_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="stadvancedmenu|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX
3
SELECT *
FROM `am_category` a
LEFT JOIN `am_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `am_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
2
SELECT position
			FROM `am_category_product`
			WHERE id_category = XX
			AND id_product