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

Notice: Undefined offset: 1 in /home/fullcar/domains/superparts.pl/public_html/controllers/front/ProductController.php on line 277
OLEJ 5W-30 TOTAL 9000 FUT NFC 4L VW50000505005050145W30 - TOTAL 5W30 9000 FUT NFC 4-K / superparts.pl
Opinie o sklepie superparts.pl Opinie o sklepie superparts.pl

TOTAL 5W30 9000 FUT NFC 4-K, VW50000505005050145W30 - OLEJ 5W-30 TOTAL 9000 FUT NFC 4L

OLEJ 5W-30 TOTAL 9000 FUT NFC 4L


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 5W-30 TOTAL 9000 FUT NFC 4L Zobacz powiększenie

Promocja -5%7 DNI, 00:06:34

80,67 zł
Cena netto: 66,12 zł

84,92 zł

- +

Porównaj

Dlaczego warto kupować w superparts.pl
Promocja
TOTAL
5W30 9000 FUT NFC 4-K
VW50000505005050145W30

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

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

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

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
 
Kategorie: Strona główna, Oleje i płyny, Oleje, Olej syntetyczny
Pojemność [litr] : 4
Opakowanie zbiorcze
Specyfikacja : ACEA
Specyfikacja : API
Specyfikacja : Ford WSS-M2C913-B
Specyfikacja : Ford WSS-M2C913-C
Specyfikacja : Ford WSS-M2C913-D

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

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

 

ELF5W30 EX DID 5-K
ELF5W30 LSX 5-K
ELF5W30 EX DID 5
ELF5W30 LSX 5
FORD5W40 FORD 5
LIQUI MOLY3756
MOBIL5W30 SSV 4-K
MOBIL5W30 SSV 5
MOBIL5W30 SSV 5-K
MOBIL5W30 SSV 4
TOTAL5W30 INEO 504/507 208
TOTAL5W30 INEO 504/507 60
TOTAL5W30 INEO MC3 5
ELFELF EXCELLIUM DID 5W30 5
ELFELF SOLARIS LSX 5W30 5
LIQUI MOLY3756P
MOBILMOBIL SYNT S SPECIAL V 5W30 5L
SHELL550040395
SHELL550040384
ELF5W30 EVO 900 DID 5
ELF5W30 EVO 900 DID 5-K
SHELL5W30 HX7 AV 1
SHELL5W30 HX7 AV 4
Specol5W30 C3 4
Specol5W30 GOLD 4
TOTAL5W30 INEO 504/507 5
TOTAL5W30 INEO 504/507 5-K
TOTAL5W30 INEO ECS 208
TOTAL5W30 INEO ECS 5
TOTAL5W30 INEO ECS 60
TOTAL5W30 INEO MC3 208
TOTAL5W30 INEO MC3 5-K

OPINIE (0)

 
Dodaj swoją opinie:

Klienci którzy zakupili ten produkt kupili również:

Zawartość koszyka

Brak produktów

0,00 zł SUMA

Realizuj zamówienie

Szukaj

Menu

Load Time777 ms - Unicorn powered webserver!
Querying Time243 ms
Queries605
Memory Peak Usage36.5 Mb
Included Files470 files - 8.26 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 26 ms 26 ms 6.53 Mb 6.68 Mb
__construct 0 ms 26 ms - Mb 6.68 Mb
init 111 ms 137 ms 4.99 Mb 12.23 Mb
checkAccess 0 ms 137 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 338 ms 476 ms 19.35 Mb 31.23 Mb
initFooter 20 ms 496 ms 1.12 Mb 33.28 Mb
display 281 ms 777 ms 2.79 Mb 36.49 Mb
Hook Time Memory Usage
__construct 70 ms 19.00 Mb
hookproductfooter 44 ms 0.75 Mb
hookdisplayAnywhere 26 ms - Mb
hookdisplayHeader 23 ms - Mb
hookheader 11 ms 0.25 Mb
hookextraleft 5 ms 0.25 Mb
hookdisplaySideBar 5 ms - Mb
hookdisplayFooterProduct 4 ms - Mb
hookextraright 4 ms - Mb
hookfooter 3 ms - Mb
hookdisplayFooter 3 ms 0.25 Mb
hookdisplayNav 3 ms - Mb
hooktop 3 ms - Mb
hookdisplayFooterTopNews 3 ms - Mb
hookproducttabcontent 3 ms - Mb
hookdisplayTopSecondary 2 ms - Mb
hookdisplayTopColumn 2 ms - Mb
hookdisplayBanner 2 ms - Mb
hookdisplayMobileBar 2 ms - Mb
hookdisplayBottomColumn 2 ms - Mb
hookproducttab 2 ms 0.25 Mb
hookdisplayLeftColumnProduct 2 ms - Mb
hookdisplayTop 2 ms - Mb
hookdisplayFooterInfo 1 ms - Mb
hookdisplayHomeVeryBottom 1 ms 0.25 Mb
hookdisplayFooterBottomLeft 1 ms - Mb
hookdisplayRightColumnProduct 1 ms - Mb
hookdisplayFooterBottomRight 1 ms 0.25 Mb
hookdisplayMyNewHookMobile 1 ms - Mb
hookactionDispatcher 1 ms - Mb
hookdisplayMyNewHook 1 ms - Mb
hookproductactions 1 ms - Mb
hookactionProductOutOfStock 1 ms - Mb
hookdisplayMatchedCars 1 ms - Mb
hookdisplayMobileMenu 1 ms - Mb
hookdisplayProductButtons 1 ms - Mb
hookmoduleRoutes - ms - Mb
hookdisplayFullWidthTop - ms - Mb
hookdisplayFullWidthTop2 - ms - Mb
39 hooks 239 ms 21.25 Mb
Module Time Memory Usage
crossselling 39 ms 0.75 Mb
stproductlinknav 24 ms 0.25 Mb
steasycontent 12 ms 1.50 Mb
stadvancedbanner 8 ms 1.00 Mb
stthemeeditor 7 ms 1.75 Mb
stiosslider 7 ms 1.00 Mb
paypal 7 ms 0.50 Mb
stmultilink 6 ms 1.00 Mb
productcomments 6 ms 0.25 Mb
blockcart_mod 5 ms - Mb
stadvancedmenu 5 ms 0.25 Mb
blocknewsletter 5 ms 1.00 Mb
blocksearch_mod 4 ms 0.25 Mb
producttooltip 4 ms - Mb
loyalty 4 ms - Mb
statsdata 4 ms - Mb
sendtoashop 4 ms - Mb
belvg_samplemodule 4 ms - Mb
oneallsociallogin 4 ms - Mb
staddthisbutton 3 ms - Mb
stparallax 3 ms 1.25 Mb
stproductcategoriesslider 3 ms 0.25 Mb
xtremecache 3 ms 1.50 Mb
uecookie 3 ms 0.75 Mb
rellink 3 ms - Mb
stsocial 3 ms 0.25 Mb
stcompare 3 ms - Mb
seigiarenapl 3 ms 1.00 Mb
stblog 3 ms 0.25 Mb
blockuserinfo_mod 3 ms 0.25 Mb
stcameraslideshow 2 ms 0.50 Mb
opinie 2 ms - Mb
stblogfeaturedarticles 2 ms 0.50 Mb
sendtoafriend 2 ms 0.25 Mb
stbrandsslider 2 ms 0.25 Mb
dotpay 2 ms 0.75 Mb
stblogrecentarticles 2 ms 0.25 Mb
strightbarcart 2 ms 0.50 Mb
sthomenew 2 ms 0.25 Mb
pinterestverification 2 ms 0.25 Mb
mailalerts 2 ms 0.25 Mb
pakomato 2 ms 0.75 Mb
mauticprestashop 2 ms - Mb
epchangeselect 1 ms - Mb
sthoverimage 1 ms - Mb
smartsupp 1 ms 0.50 Mb
socialnetworklinks 1 ms - Mb
stblogsearch 1 ms 0.25 Mb
categorylist 1 ms 0.25 Mb
pscleaner 1 ms - Mb
tecdoc 1 ms 0.25 Mb
gapi 1 ms - Mb
fbtrackingpixel 1 ms 0.25 Mb
epemailthemes 1 ms - Mb
blockcategories 1 ms - Mb
stblogblockcategory 1 ms - Mb
taxon 1 ms - Mb
paragonfaktura 1 ms - Mb
ganalytics 1 ms - Mb
blockviewed 1 ms - Mb
deleteordersfree 1 ms - Mb
removeiso 1 ms - Mb
vatnumber 0 ms - Mb
ceneoxml 0 ms 0.25 Mb
64 modules 239 ms 21.25 Mb

Stopwatch SQL - 605 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.8 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` = 255959
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog") 
AND cp.`position` <8077866
GROUP BY product_shop.id_product
ORDER BY cp.`position` DESC LIMIT 1
16.7 1341 Yes /modules/stproductlinknav/stproductlinknav.php:115
SELECT SQL_NO_CACHE DISTINCT od.product_id, pl.name, pl.description_short, pl.link_rewrite, p.reference, i.id_image, product_shop.show_price,
cl.link_rewrite category, p.ean13, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
FROM am_order_detail od
LEFT JOIN am_product p ON (p.id_product = od.product_id)
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` pa
ON (p.`id_product` = pa.`id_product`)
LEFT 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 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN am_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN am_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN am_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN am_image i ON (i.id_product = od.product_id)
LEFT JOIN `am_category_product` cp ON (cp.`id_category` = product_shop.id_category_default
AND cp.id_product = product_shop.id_product)
LEFT JOIN `am_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (1014)
AND pl.id_lang = 1
AND cl.id_lang = 1
AND od.product_id NOT IN (767710)
AND i.cover = 1
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 4
5.3 6 Yes /modules/crossselling/crossselling.php:179
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 "VW50000505005050145W30" AND p.`id_product` != 767710  AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
ORDER BY quantity DESC
3 33 Yes /classes/Product.php:3734
SELECT SQL_NO_CACHE cp.date_add
FROM am_cart_product cp
WHERE cp.id_product = 767710 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
2 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 * FROM `am_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.7 802 /classes/module/Module.php:2141
UPDATE `am_smarty_lazy_cache`
SET filepath='crossselling/productfooter/767710/1/1/1/1/14/7a/6e/ce/7a6ece7eb55ad880abce812dd746f66c007437ce.crossselling.tpl.php'
WHERE `template_hash`='264a7c52255fdc080e8f6815f19aa482' AND cache_id="crossselling|productfooter|767710|1|1|1|1|14" AND compile_id=""
0.7 1 /classes/SmartyCustom.php:183
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, 481520) 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 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` = 767710
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
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='a896b106e50e0be11dd08a7566fd9486' AND cache_id LIKE "stadvancedbanner|1|1|1|1|14_21_location%"
0.6 1 /classes/SmartyCustom.php:295
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` = 255959
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog") 
AND cp.`position` >8077866
GROUP BY product_shop.id_product
ORDER BY cp.`position` ASC LIMIT 1
0.6 1 Yes /modules/stproductlinknav/stproductlinknav.php:115
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, 127531) 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 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 `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 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, 719201) 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 * FROM `am_state` ORDER BY `name` ASC
0.6 312 Yes /classes/Country.php:137
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, 767710) 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, 218883) 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, 477799) 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 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` = 767710
ORDER BY `position`
0.6 1 Yes /classes/Product.php:2854
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, 229831) 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, 98225) 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, 229071) 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, 724434) 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, 719205) 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, 291610) 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, 724441) 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, 635730) 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, 230929) 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, 603167) 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, 231316) 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 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 <= 27
AND c.nright >= 28
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.5 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, 137751) 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, 490048) 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, 490059) 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, 724442) 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, 724435) 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, 724438) 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, 291243) 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, 724437) 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, 724439) 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, 291245) 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, 603168) 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, 635731) 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 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` = 255959
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.5 1 Yes Yes /classes/Category.php:658
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 (767710)
0.5 2 /modules/crossselling/crossselling.php:133
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, 767710) 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.5 2 Yes /classes/SpecificPrice.php:421
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.4 41 Yes /classes/Dispatcher.php:452
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.4 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` = 672769) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='73f17e45c091e5f28ed9d0f67243843f' AND cache_id LIKE "stiosslider|1|1|1|1|14_21_location%"
0.4 1 /classes/SmartyCustom.php:295
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='6c3b44364ec9b6ed7d9b943e2312fbdf' AND cache_id LIKE "steasycontent|1|1|1|1|14_120_location%"
0.3 1 /classes/SmartyCustom.php:295
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` = 767710)
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 = 767710)
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.3 1 Yes /modules/productcomments/ProductCommentCriterion.php:184
SELECT SQL_NO_CACHE `id_page`
FROM `am_page`
WHERE `id_page_type` = 2 AND `id_object` = 767710 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` = 767718) 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 *
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` = 218883) 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` = 767710
AND cl.`id_lang` = 1
0.3 4 /classes/Product.php:2774
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` = 767710) AND (b.`id_shop` = 1) LIMIT 1
0.3 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.3 1 Yes /modules/stparallax/StParallaxGroup.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` = 603167) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 767710 AND o.date_add >= '2017-12-18'
ORDER BY o.date_add DESC LIMIT 1
0.3 2 Yes /modules/producttooltip/producttooltip.php:132
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` = 767710
ORDER BY pc.`date_add` DESC
0.3 1 Yes /modules/productcomments/ProductComment.php:114
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` = 291610) 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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
0.3 12 /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` = 490059) 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` = 229071) 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` = 635730) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `am_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('264a7c52255fdc080e8f6815f19aa482',"crossselling|productfooter|767710|1|1|1|1|14","", FROM_UNIXTIME(1516263993))
0.3 1 /classes/SmartyCustom.php:263
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` = 137751) 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` = 231316) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='edc1bde1592e10517dfb3508b0f79ad3' AND cache_id LIKE "stmultilink|1|1|1|1|14_23_location%"
0.3 1 /classes/SmartyCustom.php:295
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 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
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` = 477799) 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 *
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` = 229831) 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` = 98225) 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` = 719201) 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` = 719205) 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 <= 18.819 AND t.price_max > 18.819)
WHERE (p.`id_product` = 218883)
0.3 9 /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` = 724437) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 = 767710
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2018-01-18 00:00:00",
INTERVAL 45 DAY
)
) > 0
0.3 0 /classes/Product.php:1289
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` = 767710
0.3 1 /classes/Product.php:5832
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` = 127531) 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 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` = 767710
AND image_shop.`cover` = 1 LIMIT 1
0.3 1 /classes/Product.php:2874
Describe `am_st_easy_content` `id_category`
0.3 1 /modules/steasycontent/StEasyContentClass.php:161
Describe `am_st_easy_content` `id_category`
0.2 1 /modules/steasycontent/StEasyContentClass.php:161
SELECT SQL_NO_CACHE id_tab, class_name FROM `am_tab`
0.2 168 /classes/Tab.php:296
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` = 767710)
INNER JOIN `am_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
0.2 1 /modules/belvg_samplemodule/belvg_samplemodule.php:155
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` = 767710) 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_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 767710) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE position
FROM `am_category_product`
WHERE id_category = 255959
AND id_product = 767710
0.2 1 /modules/stproductlinknav/stproductlinknav.php:150
SELECT SQL_NO_CACHE id_product FROM `am_category_product` WHERE `id_product` = 767710 AND `id_category` IN (255959) LIMIT 1
0.2 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` = 1
LEFT JOIN `am_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 724435) 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 (18) 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 (33) AND sec.`active`=1 
ORDER BY sec.`position`,sec.`location`
0.2 8 Yes /modules/steasycontent/StEasyContentClass.php:184
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` = 767710
ORDER BY product_attribute_shop.`price` DESC LIMIT 1
0.2 1 Yes /classes/Product.php:3335
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` = 230929) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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 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` = 767710
AND cl.`id_lang` = 1
0.2 4 /classes/Product.php:2774
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` = 490048) 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 <= 148.28 AND t.price_max > 148.28)
WHERE (p.`id_product` = 137751)
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` = 481520) 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 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 <= 56.13 AND t.price_max > 56.13)
WHERE (p.`id_product` = 767710)
0.2 11 /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` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='d28b95db49788b1d1b8263494df7a4e0' AND cache_id LIKE "steasycontent|1|1|1|1|14_18_location%"
0.2 1 /classes/SmartyCustom.php:295
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` = 603168) 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` = 724439) 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 (5001) 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` = 719201)
0.2 1 /override/classes/Product.php:273
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 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` = 767710 AND ctg.`id_group` = 1 LIMIT 1
0.2 4 /classes/Product.php:5052
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 = 127531
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` = 724438) 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 <= 137.268 AND t.price_max > 137.268)
WHERE (p.`id_product` = 98225)
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 <= 182.3844 AND t.price_max > 182.3844)
WHERE (p.`id_product` = 137751)
0.2 14 /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` = 724441) 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` = 291245) 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` = 719205)
0.2 1 /override/classes/Product.php:273
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.2 1 /classes/Currency.php:472
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` = 724442) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='0016ab6058befa741bf9bc3316ba7810' AND cache_id LIKE "steasycontent|1|1|1|1|14_5001_location%"
0.2 1 /classes/SmartyCustom.php:295
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 <= 148.28 AND t.price_max > 148.28)
WHERE (p.`id_product` = 137751)
0.2 13 /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 (19,20)
ORDER BY smsg.`position`
0.2 1 Yes /modules/stcameraslideshow/StCameraSlideshowGroup.php:233
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` = 291243) 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` = 230929)
0.2 1 /override/classes/Product.php:273
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` = 635731) 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 <= 87.21 AND t.price_max > 87.21)
WHERE (p.`id_product` = 291610)
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 <= 107.2806 AND t.price_max > 107.2806)
WHERE (p.`id_product` = 229831)
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 <= 86.9118 AND t.price_max > 86.9118)
WHERE (p.`id_product` = 229071)
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 <= 174.414 AND t.price_max > 174.414)
WHERE (p.`id_product` = 477799)
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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
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 <= 87.22 AND t.price_max > 87.22)
WHERE (p.`id_product` = 229831)
0.2 12 /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 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 = 724439
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
Describe `am_st_easy_content` `id_category`
0.2 1 /modules/steasycontent/StEasyContentClass.php:161
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 = 127531 LIMIT 1
0.2 1 /classes/Product.php:762
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 <= 10.5903 AND t.price_max > 10.5903)
WHERE (p.`id_product` = 490048)
0.2 7 /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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
0.2 12 /override/classes/Product.php:348
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` = 218883)
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` = 98225)
0.2 1 /override/classes/Product.php:273
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='737de67756ed8ed3cfc26e9120791af8' AND cache_id LIKE "stproductcategoriesslider|1|1|1|1|14%"
0.2 1 /classes/SmartyCustom.php:295
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
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 <= 82.41 AND t.price_max > 82.41)
WHERE (p.`id_product` = 635731)
0.2 12 /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` = 724434) 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` = 137751)
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` = 490048)
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 = 98225
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
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 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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
0.2 12 /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 = 477799
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
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 = 767710
AND product_shop.active = 1 LIMIT 1
0.2 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 <= 56.13 AND t.price_max > 56.13)
WHERE (p.`id_product` = 767710)
0.2 11 /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 <= 56.13 AND t.price_max > 56.13)
WHERE (p.`id_product` = 767710)
0.2 11 /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 <= 3327.91 AND t.price_max > 3327.91)
WHERE (p.`id_product` = 724441)
0.2 23 /override/classes/Product.php:348
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='a896b106e50e0be11dd08a7566fd9486' AND cache_id LIKE "stadvancedbanner|1|1|1|1|14_18_location%"
0.2 1 /classes/SmartyCustom.php:295
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 <= 111.6 AND t.price_max > 111.6)
WHERE (p.`id_product` = 98225)
0.2 13 /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 (31) 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` = 490059)
0.2 1 /override/classes/Product.php:273
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
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='73f17e45c091e5f28ed9d0f67243843f' AND cache_id LIKE "stiosslider|1|1|1|1|14_20_location%"
0.2 1 /classes/SmartyCustom.php:295
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` = 127531)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `am_product_comment` pc
WHERE pc.`id_product` = 767710
AND pc.`deleted` = 0 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:197
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.2 1 /modules/stadvancedbanner/StAdvancedBannerFontClass.php:63
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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
0.2 12 /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` = 767710)
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` = 477799)
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` = 291243)
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 = 137751
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
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.2 1 /classes/SmartyCustom.php:215
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` = 229071)
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 = 603167
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` = 724437)
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 <= 3132.25 AND t.price_max > 3132.25)
WHERE (p.`id_product` = 291243)
0.2 23 /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` = 635730)
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 = 603167 LIMIT 1
0.2 1 /classes/Product.php:762
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` = 291610)
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 = 229071
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` = 229831)
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` = 724441)
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 <= 70.66 AND t.price_max > 70.66)
WHERE (p.`id_product` = 229071)
0.2 12 /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 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 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` = 481520)
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 = 603168
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='73f17e45c091e5f28ed9d0f67243843f' AND cache_id LIKE "stiosslider|1|1|1|1|14_18_location%"
0.2 1 /classes/SmartyCustom.php:295
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 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 <= 137.268 AND t.price_max > 137.268)
WHERE (p.`id_product` = 98225)
0.2 13 /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` = 231316)
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 <= 141.8 AND t.price_max > 141.8)
WHERE (p.`id_product` = 477799)
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 <= 83.06 AND t.price_max > 83.06)
WHERE (p.`id_product` = 230929)
0.2 12 /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 = 719205
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 <= 141.8 AND t.price_max > 141.8)
WHERE (p.`id_product` = 477799)
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 <= 111.6 AND t.price_max > 111.6)
WHERE (p.`id_product` = 98225)
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 = 231316
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.611 AND t.price_max > 31.611)
WHERE (p.`id_product` = 481520)
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 <= 107.2683 AND t.price_max > 107.2683)
WHERE (p.`id_product` = 291610)
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 = 724441
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 = 230929
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 <= 102.1638 AND t.price_max > 102.1638)
WHERE (p.`id_product` = 230929)
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 = 291245
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 <= 107.2683 AND t.price_max > 107.2683)
WHERE (p.`id_product` = 291610)
0.2 13 /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` = 603167)
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 <= 89.16 AND t.price_max > 89.16)
WHERE (p.`id_product` = 603167)
0.2 12 /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 = 229831
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 <= 41.73 AND t.price_max > 41.73)
WHERE (p.`id_product` = 719201)
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 <= 107.2806 AND t.price_max > 107.2806)
WHERE (p.`id_product` = 229831)
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 <= 73.25 AND t.price_max > 73.25)
WHERE (p.`id_product` = 231316)
0.2 12 /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 = 635731
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 <= 3852.6675 AND t.price_max > 3852.6675)
WHERE (p.`id_product` = 291243)
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 <= 87.22 AND t.price_max > 87.22)
WHERE (p.`id_product` = 229831)
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 <= 4093.3293 AND t.price_max > 4093.3293)
WHERE (p.`id_product` = 724441)
0.2 4 /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 (21)
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 <= 1263.4314 AND t.price_max > 1263.4314)
WHERE (p.`id_product` = 724439)
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 <= 37.58 AND t.price_max > 37.58)
WHERE (p.`id_product` = 719205)
0.2 10 /override/classes/Product.php:348
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 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 <= 114.8205 AND t.price_max > 114.8205)
WHERE (p.`id_product` = 127531)
0.2 13 /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` = 724439)
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 <= 109.6668 AND t.price_max > 109.6668)
WHERE (p.`id_product` = 603167)
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 <= 1263.4314 AND t.price_max > 1263.4314)
WHERE (p.`id_product` = 724439)
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 <= 82.41 AND t.price_max > 82.41)
WHERE (p.`id_product` = 635731)
0.2 12 /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` = 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 <= 3852.6675 AND t.price_max > 3852.6675)
WHERE (p.`id_product` = 291243)
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 <= 1027.18 AND t.price_max > 1027.18)
WHERE (p.`id_product` = 724439)
0.2 19 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_country_lang`
WHERE `id_country` = 14
0.2 2 /Adapter/Adapter_EntityMapper.php:68
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.2 1 /modules/stparallax/StParallaxFontClass.php:73
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` = 255959) 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 <= 114.8205 AND t.price_max > 114.8205)
WHERE (p.`id_product` = 127531)
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 <= 109.6668 AND t.price_max > 109.6668)
WHERE (p.`id_product` = 603167)
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 <= 1027.18 AND t.price_max > 1027.18)
WHERE (p.`id_product` = 724439)
0.2 19 /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 <= 4093.3293 AND t.price_max > 4093.3293)
WHERE (p.`id_product` = 724441)
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 <= 3327.91 AND t.price_max > 3327.91)
WHERE (p.`id_product` = 724441)
0.2 23 /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 <= 102.1638 AND t.price_max > 102.1638)
WHERE (p.`id_product` = 230929)
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 <= 174.414 AND t.price_max > 174.414)
WHERE (p.`id_product` = 477799)
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 <= 10.5903 AND t.price_max > 10.5903)
WHERE (p.`id_product` = 490059)
0.2 7 /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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
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 <= 93.35 AND t.price_max > 93.35)
WHERE (p.`id_product` = 127531)
0.2 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 = 767710 LIMIT 1
0.2 1 /classes/Product.php:762
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 <= 86.9118 AND t.price_max > 86.9118)
WHERE (p.`id_product` = 229071)
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 <= 93.35 AND t.price_max > 93.35)
WHERE (p.`id_product` = 127531)
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`='6f14e48b7e04581079e7854bd2efc7af' AND cache_id="stblogfeaturedarticles|1|1|1|1|14" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='a896b106e50e0be11dd08a7566fd9486' AND cache_id LIKE "stadvancedbanner|1|1|1|1|14_22_location%"
0.2 1 /classes/SmartyCustom.php:295
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.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.0975 AND t.price_max > 90.0975)
WHERE (p.`id_product` = 231316)
0.2 13 /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 <= 101.3643 AND t.price_max > 101.3643)
WHERE (p.`id_product` = 635731)
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 <= 46.2234 AND t.price_max > 46.2234)
WHERE (p.`id_product` = 719205)
0.2 11 /override/classes/Product.php:348
SELECT SQL_NO_CACHE COUNT(*) FROM `am_pack` WHERE id_product_pack = 767710 LIMIT 1
0.2 1 /classes/Pack.php:50
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 <= 87.21 AND t.price_max > 87.21)
WHERE (p.`id_product` = 291610)
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 <= 1232.9889 AND t.price_max > 1232.9889)
WHERE (p.`id_product` = 291245)
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 <= 84.92 AND t.price_max > 84.92)
WHERE (p.`id_product` = 603168)
0.2 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`='04d564bffbaabc0fffdcbedad2b11081' AND cache_id="stparallax|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 <= 101.3643 AND t.price_max > 101.3643)
WHERE (p.`id_product` = 635731)
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 <= 83.06 AND t.price_max > 83.06)
WHERE (p.`id_product` = 230929)
0.2 12 /override/classes/Product.php:348
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 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.25 AND t.price_max > 73.25)
WHERE (p.`id_product` = 231316)
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 <= 70.66 AND t.price_max > 70.66)
WHERE (p.`id_product` = 229071)
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 <= 37.58 AND t.price_max > 37.58)
WHERE (p.`id_product` = 719205)
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 <= 89.16 AND t.price_max > 89.16)
WHERE (p.`id_product` = 603167)
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 <= 41.73 AND t.price_max > 41.73)
WHERE (p.`id_product` = 719201)
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 <= 46.2234 AND t.price_max > 46.2234)
WHERE (p.`id_product` = 719205)
0.2 11 /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 (23) AND smlgl.`id_lang` = 1
ORDER BY smlg.`position`
0.2 5 Yes /modules/stmultilink/StMultiLinkGroup.php:141
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 = 291610
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE * FROM `am_image_type`
0.2 15 /classes/ImageType.php:143
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 = 229071 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 `width`, `height`
FROM am_image_type
WHERE `name` = 'home_default' LIMIT 1
0.2 1 /classes/Image.php:470
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 767710) 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 <= 182.3844 AND t.price_max > 182.3844)
WHERE (p.`id_product` = 137751)
0.2 14 /override/classes/Product.php:348
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 `id_country`
FROM `am_country`
WHERE `iso_code` = 'PL' LIMIT 1
0.2 1 /classes/Country.php:174
INSERT INTO `am_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('14485197', '730027', '911429940', '', '1', '1', '2018-01-18 09:26:33')
0.2 1 /classes/ObjectModel.php:487
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|767710|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 <= 1002.43 AND t.price_max > 1002.43)
WHERE (p.`id_product` = 291245)
0.2 19 /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 = 291610 LIMIT 1
0.2 1 /classes/Product.php:762
SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `am_product_comment` pc
WHERE `id_product` = 767710 LIMIT 1
0.2 1 /modules/productcomments/ProductComment.php:240
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 = 231316 LIMIT 1
0.2 1 /classes/Product.php:762
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` = 724434)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE *
FROM `am_product_lang`
WHERE `id_product` = 767710 AND `id_shop` = 1
0.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `am_smarty_last_flush` WHERE type='compile' LIMIT 1
0.2 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE `id_guest`
FROM `am_connections`
WHERE `id_guest` = 14485197
AND `date_add` > '2018-01-18 08:56: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 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 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 <= 56.13 AND t.price_max > 56.13)
WHERE (p.`id_product` = 767710)
0.2 11 /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 0 /classes/SmartyCustom.php:215
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.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM am_category
WHERE id_category = 2 LIMIT 1
0.2 1 /classes/Category.php:1589
SELECT SQL_NO_CACHE id_shop
FROM `am_category_shop`
WHERE `id_category` = 255959
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1451
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 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` = 724442)
0.2 1 /override/classes/Product.php:273
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.2 2 /modules/rellink/classes/HrefLangMapCollection.php:193
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` = 724435)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "paypal" LIMIT 1
0.2 1 /classes/module/Module.php:2568
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` = 724438)
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 (18)
ORDER BY smsg.`position`
0.2 6 Yes /modules/stadvancedbanner/StAdvancedBannerGroup.php:239
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.2 0 /classes/SmartyCustom.php:215
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 `id_product_download`
FROM `am_product_download`
WHERE `id_product` = 767710
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1
0.2 0 /classes/ProductDownload.php:184
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 = 724442
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 <= 86.51 AND t.price_max > 86.51)
WHERE (p.`id_product` = 724434)
0.2 12 /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 = 724434
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `am_smarty_last_flush` WHERE type='template' LIMIT 1
0.2 1 /classes/SmartyCustom.php:142
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 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE version FROM `am_module` WHERE name = 'paypal' LIMIT 1
0.2 1 /modules/paypal/paypal.php:282
DELETE FROM `am_smarty_lazy_cache`
WHERE template_hash='edc1bde1592e10517dfb3508b0f79ad3' AND cache_id LIKE "stmultilink|1|1|1|1|14_22_location%"
0.2 1 /classes/SmartyCustom.php:295
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 <= 86.02 AND t.price_max > 86.02)
WHERE (p.`id_product` = 724435)
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 <= 88.53 AND t.price_max > 88.53)
WHERE (p.`id_product` = 724438)
0.2 12 /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 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 = 635730 LIMIT 1
0.2 1 /classes/Product.php:762
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 <= 104.4516 AND t.price_max > 104.4516)
WHERE (p.`id_product` = 603168)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'big_default' LIMIT 1
0.2 1 /classes/Image.php:470
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 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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
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 <= 106.4073 AND t.price_max > 106.4073)
WHERE (p.`id_product` = 724434)
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 <= 83.12 AND t.price_max > 83.12)
WHERE (p.`id_product` = 724442)
0.2 12 /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 = 218883 LIMIT 1
0.2 1 /classes/Product.php:762
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` = 603168)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 229831) 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 <= 56.13 AND t.price_max > 56.13)
WHERE (p.`id_product` = 767710)
0.2 11 /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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
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 <= 90.0975 AND t.price_max > 90.0975)
WHERE (p.`id_product` = 231316)
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 <= 84.92 AND t.price_max > 84.92)
WHERE (p.`id_product` = 603168)
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 <= 102.2376 AND t.price_max > 102.2376)
WHERE (p.`id_product` = 724442)
0.2 13 /override/classes/Product.php:348
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 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 <= 106.4073 AND t.price_max > 106.4073)
WHERE (p.`id_product` = 724434)
0.2 13 /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` = 635731)
0.2 1 /override/classes/Product.php:273
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 477799) 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 SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 724441) 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 SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 719205) 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 SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 230929) 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` = 490048 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
INSERT IGNORE INTO `am_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('264a7c52255fdc080e8f6815f19aa482',"crossselling|productfooter|767710|1|1|1|1|14","", FROM_UNIXTIME(1516263993))
0.2 1 /classes/SmartyCustom.php:263
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` = 10956) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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 = 719201 LIMIT 1
0.2 1 /classes/Product.php:762
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` = 767710
AND pccl.`id_lang` = 1
0.2 1 /modules/productcomments/ProductComment.php:168
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 <= 86.51 AND t.price_max > 86.51)
WHERE (p.`id_product` = 724434)
0.2 12 /override/classes/Product.php:348
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` = 255959 LIMIT 1
0.2 1 /classes/Category.php:1166
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 = 603168 LIMIT 1
0.2 1 /classes/Product.php:762
SELECT SQL_NO_CACHE out_of_stock
FROM `am_stock_available`
WHERE (id_product = 767710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 635731) 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 <= 102.2376 AND t.price_max > 102.2376)
WHERE (p.`id_product` = 724442)
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`='1dfc803e4db6bc8225fe845b49a09d13' AND cache_id="stsocial|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 <= 1232.9889 AND t.price_max > 1232.9889)
WHERE (p.`id_product` = 291245)
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 <= 69.0399 AND t.price_max > 69.0399)
WHERE (p.`id_product` = 767710)
0.2 12 /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 (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 <= 3589.97 AND t.price_max > 3589.97)
WHERE (p.`id_product` = 724437)
0.2 4 /override/classes/Product.php:348
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.2 1 /modules/stiosslider/StIosSliderFontClass.php:73
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'small_default' LIMIT 1
0.2 1 /classes/Image.php:470
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 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` = 291245)
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 <= 51.3279 AND t.price_max > 51.3279)
WHERE (p.`id_product` = 719201)
0.2 11 /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`='ed6c6c031658489ac193715c2708d46b' AND cache_id="stblogrecentarticles|1|1|1|1|14" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 10002
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 <= 21.68 AND t.price_max > 21.68)
WHERE (p.`id_product` = 635730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 724439) 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, 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 = 724437
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE depends_on_stock
FROM `am_stock_available`
WHERE (id_product = 767710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:646
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 = 635730
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
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 <= 83.12 AND t.price_max > 83.12)
WHERE (p.`id_product` = 724442)
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 <= 1002.43 AND t.price_max > 1002.43)
WHERE (p.`id_product` = 291245)
0.2 19 /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 = 719201
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 = 724435
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 <= 3132.25 AND t.price_max > 3132.25)
WHERE (p.`id_product` = 291243)
0.2 23 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `id_module` FROM `am_module` WHERE `name` = "blockwishlist" LIMIT 1
0.2 1 /classes/module/Module.php:2568
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 = 291243
ORDER BY f.position ASC
0.2 1 Yes /override/classes/Product.php:140
SELECT SQL_NO_CACHE *
FROM `am_product_comment` pc
WHERE pc.`id_product` = 767710
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
0.2 1 Yes /modules/productcomments/ProductComment.php:137
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 230929 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE *
FROM `am_image_lang`
WHERE `id_image` = 488108
0.2 2 /Adapter/Adapter_EntityMapper.php:68
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 <= 4415.6631 AND t.price_max > 4415.6631)
WHERE (p.`id_product` = 724437)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 767710
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:201
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 `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 218883
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /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 <= 4415.6631 AND t.price_max > 4415.6631)
WHERE (p.`id_product` = 724437)
0.2 4 /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` = 49241 LIMIT 1
0.2 1 /classes/Category.php:1166
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 = 635731 LIMIT 1
0.2 1 /classes/Product.php:762
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.6664 AND t.price_max > 26.6664)
WHERE (p.`id_product` = 635730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 488
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 <= 104.4516 AND t.price_max > 104.4516)
WHERE (p.`id_product` = 603168)
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 <= 105.8046 AND t.price_max > 105.8046)
WHERE (p.`id_product` = 724435)
0.2 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 724441
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /classes/SpecificPrice.php:201
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` = 488108) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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` = 255959 LIMIT 1
0.2 1 /classes/Category.php:1166
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 477799 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`='beb94bf7f33cc387907bccba48174ec1' AND cache_id="stbrandsslider|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 <= 26.6664 AND t.price_max > 26.6664)
WHERE (p.`id_product` = 635730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 98225) 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 <= 3589.97 AND t.price_max > 3589.97)
WHERE (p.`id_product` = 724437)
0.2 4 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 719205 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
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 `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 291243 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 724441 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 <= 51.3279 AND t.price_max > 51.3279)
WHERE (p.`id_product` = 719201)
0.2 11 /override/classes/Product.php:348
SELECT SQL_NO_CACHE *
FROM `am_tax_lang`
WHERE `id_tax` = 1
0.2 2 /Adapter/Adapter_EntityMapper.php:68
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`=767710
0.2 1 /classes/Tag.php:205
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 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.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 229831 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 481520 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 <= 21.68 AND t.price_max > 21.68)
WHERE (p.`id_product` = 635730)
0.2 10 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 719201 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`='a778d25874f7f684f2d05e4224a1225b' AND cache_id="stcameraslideshow|1|1|1|1|14_11_location" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `am_group_lang`
WHERE `id_group` = 1
0.2 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`='0016ab6058befa741bf9bc3316ba7810' AND cache_id="steasycontent|1|1|1|1|14_5001_location" AND compile_id="" LIMIT 1
0.2 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 724437 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` = 90 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 11414
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 = 724434 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`='d28b95db49788b1d1b8263494df7a4e0' AND cache_id="steasycontent|1|1|1|1|14_18_location" AND compile_id="" LIMIT 1
0.1 0 /classes/SmartyCustom.php:215
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 = 724438
ORDER BY f.position ASC
0.1 1 Yes /override/classes/Product.php:140
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 `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 291243
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` = 719205
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 = 127531) 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 = 481520 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE value FROM `am_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.1 1 /classes/shop/Shop.php:1067
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 <= 86.02 AND t.price_max > 86.02)
WHERE (p.`id_product` = 724435)
0.1 12 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 230929
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /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 <= 88.53 AND t.price_max > 88.53)
WHERE (p.`id_product` = 724438)
0.1 12 /override/classes/Product.php:348
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`='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`='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 `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 `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 10956
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` = 477799
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 = 137751) 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 = 490059 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 230929 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE s.id_searchterm, s.term,s.url,s.title,s.description 
FROM am_searchterm s
0.1 3 /override/classes/Dispatcher.php:16
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` = 18689 LIMIT 1
0.1 1 /classes/Category.php:1166
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 481520
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` = 719201
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
SELECT SQL_NO_CACHE * FROM `am_hook_alias`
0.1 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 229071) 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 nleft, nright, level_depth
FROM am_category
WHERE id_category = 255959 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 = 724438 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 603167) 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 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 <= 108.8919 AND t.price_max > 108.8919)
WHERE (p.`id_product` = 724438)
0.1 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 719201) 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_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 = 603168) 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 = 291610) 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` = 719205 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` = 724441 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` = 229831 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`='737de67756ed8ed3cfc26e9120791af8' AND cache_id="stproductcategoriesslider|1|1|1|1|14" AND compile_id="" LIMIT 1
0.1 0 /classes/SmartyCustom.php:215
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` = 49239 LIMIT 1
0.1 1 /classes/Category.php:1166
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 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 0 /classes/SmartyCustom.php:215
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 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 <= 105.8046 AND t.price_max > 105.8046)
WHERE (p.`id_product` = 724435)
0.1 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 <= 108.8919 AND t.price_max > 108.8919)
WHERE (p.`id_product` = 724438)
0.1 13 /override/classes/Product.php:348
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 137751 AND id_shop=1 LIMIT 1
0.1 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`='eb4ae2d964fa3435aa0d365f1140ef73' AND cache_id="stthemeeditor|1|1|1|1|14_crossselling" 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` = 98225 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
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 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 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 position
FROM `am_category_product`
WHERE id_category = 255959
AND id_product = 767710
0.1 1 /modules/stproductlinknav/stproductlinknav.php:150
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 490059 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
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 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 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.1 1 /classes/Language.php:894
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 4
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 218883 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`='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` = 231316 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` = 490048
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:201
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 `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 490048 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` = 481520 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` = 291243 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` = 477799 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` = 635731 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` = 'cart_default' LIMIT 1
0.1 1 /classes/Image.php:470
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 98225 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` = 137751
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 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 = 477799 LIMIT 1
0.1 1 /classes/Product.php:762
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 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.1 1 /classes/SmartyCustom.php:215
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` = 255959 LIMIT 1
0.1 0 /classes/Category.php:1166
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 229071 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 137751 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
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 `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 127531 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 11018
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` = 603167 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 = 137751 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`='a896b106e50e0be11dd08a7566fd9486' AND cache_id="stadvancedbanner|1|1|1|1|14_18_location" AND compile_id="" LIMIT 1
0.1 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 11469
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 = 490048 LIMIT 1
0.1 1 /classes/Product.php:762
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 `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 291610 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `name`
FROM `am_manufacturer`
WHERE `id_manufacturer` = 10340
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` = 229831
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` = 291610
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_21_location" AND compile_id="" LIMIT 1
0.1 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `width`, `height`
FROM am_image_type
WHERE `name` = 'large_default' LIMIT 1
0.1 1 /classes/Image.php:470
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 `priority`, `id_specific_price_priority`
FROM `am_specific_price_priority`
WHERE `id_product` = 229071
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 = 724435 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 127531 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` = 603167
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` = 635730
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 = 231316) 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 = 724434) 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 = 291245) 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_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 724439 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 291610 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` = 231316 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` = 229071 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` = 603167 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
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 = 724442) 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` = 719201 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_18_location" AND compile_id="" LIMIT 1
0.1 0 /classes/SmartyCustom.php:215
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` = 254182 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`='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 SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 291243) 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` = 724434
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`='edc1bde1592e10517dfb3508b0f79ad3' AND cache_id="stmultilink|1|1|1|1|14_22_location" AND compile_id="" LIMIT 1
0.1 0 /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_22_location" AND compile_id="" LIMIT 1
0.1 0 /classes/SmartyCustom.php:215
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 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 = 719205 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 = 229831 LIMIT 1
0.1 1 /classes/Product.php:762
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 `id_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 218883 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` = 490059 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 = 724437 LIMIT 1
0.1 1 /classes/Product.php:762
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 SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 635730) 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 GROUP_CONCAT(a.`id_product_pack`)
FROM `am_pack` a
WHERE a.`id_product_item` = 767710 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 = 230929 LIMIT 1
0.1 1 /classes/Product.php:762
SELECT SQL_NO_CACHE `reduction`
FROM `am_product_group_reduction_cache`
WHERE `id_product` = 724439 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
FROM `am_product_comment` pc
WHERE `id_product` = 767710
AND `grade` > 0 LIMIT 1
0.1 1 /modules/productcomments/ProductComment.php:261
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 724435) 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_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 635730 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` = 724434 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` = 724439
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` = 11884
AND `active` = 1 LIMIT 1
0.1 1 /classes/Manufacturer.php:248
SELECT SQL_NO_CACHE SUM(quantity)
FROM `am_stock_available`
WHERE (id_product = 724437) 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_tax_rules_group`
FROM `am_product_shop`
WHERE `id_product` = 724442 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` = 767710 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5172