Najlepiej sprzedające się

Lista produktów producenta: De Noyles

Kosmetyki De Noyles

De Noyles to hiszpańska marka kosmetyków z ponad 20-letnim doświadczeniem. Sekretem sukcesu tej firmy jest dostarczanie skórze bogactwa naturalnych składników, które pobudzają procesy fizjologiczne i dbają o odpowiednią pielęgnację. Wielkim atutem jest szeroka oferta wysokiej jakości preparatów. Kosmetyki marki De Noyles to propozycja dla salonów kosmetycznych i SPA, a także wszystkich wielbicielek kosmetyków naturalnych. Produkty przeznaczone są dla kobiet i mężczyzn, do pielęgnacji każdego typu cery, w tym też do skóry wrażliwej.

Bestsellery De Noyles!

Kosmetyki De Noyles to między innymi podstawowe produkty pielęgnacyjne (kremy, mleczka, toniki, kosmetyki do demakijażu i oczyszczania), kosmetyki do ciała (balsamy, żele wyszczuplające i antycellulitowe), specjalistyczne preparaty do skóry z problemami takimi jak trądzik czy blizny, ampułki, maski, olejki i wiele więcej. Najpopularniejsze produkty marki De Noyles to przykładowo krem Base Hydratant Oil-Free (matująco-nawilżający na dzień) oraz żel Gel Aha 9% (nawilżający żel z kwasami AHA). Jeśli chodzi o inne kosmetyki De Noyles opinie są również bardzo pozytywne. W ofercie są także profesjonalne produkty do zabiegów na ciało. Wśród nich można wyróżnić żel chłodzący - Gel Adelgazante Crio. Ogromne doświadczenie hiszpańskiego producenta pozwoliło na stworzenie kosmetyków najwyższej jakości, skutecznych i bezpiecznych.

Sięgnij po hiszpańskie kosmetyki z górnej półki dla skóry w różnym wieku i o różnych potrzebach. Preparaty z tej kategorii można ze sobą łączyć, co umożliwia opracowanie efektywnych zabiegów o indywidualnym charakterze, dopasowanym do konkretnych wymagań skóry. Zapoznaj się z produktami De Noyles i wybierz swoje ulubione.

Więcej
na stronę
Pokazuje 1 - 50 z 79 produktów
Pokazuje 1 - 50 z 79 produktów
Load Time1938 ms - You'd better run your shop on a toaster
Querying Time830 ms
Queries677
Memory Peak Usage31.4 Mb
Included Files431 files - 6.47 Mb
PrestaShop Cache- Mb
Global vars1.90 Mb
PrestaShop Version1.6.1.22
PHP Version5.6.39 (OK)
MySQL Version5.6.42 (OK)
Memory Limit2048M
Max Execution Time0s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 32 ms 32 ms 6.90 Mb 7.04 Mb
__construct 0 ms 33 ms - Mb 7.04 Mb
init 7 ms 39 ms 1.19 Mb 8.22 Mb
checkAccess 0 ms 39 ms - Mb 8.22 Mb
setMedia 2 ms 41 ms 0.07 Mb 8.26 Mb
postProcess 0 ms 41 ms - Mb 8.26 Mb
initHeader 0 ms 42 ms - Mb 8.26 Mb
initContent 1243 ms 1285 ms 20.07 Mb 28.39 Mb
initFooter 19 ms 1303 ms 0.37 Mb 30.16 Mb
display 635 ms 1938 ms 1.26 Mb 31.36 Mb
Hook Time Memory Usage
hookleftcolumn 130 ms 2.25 Mb
__construct 84 ms 13.75 Mb
hookheader 29 ms - Mb
hookdisplayHeader 17 ms - Mb
hookfooter 12 ms - Mb
hookdisplayNav 10 ms - Mb
hookdisplayx13Canonical 5 ms - Mb
hookdisplayTop 4 ms - Mb
hooktop 2 ms - Mb
hookdisplayFooter 2 ms - Mb
hookdisplayProductListReviews 1 ms - Mb
hookdisplayProductDeliveryTime 1 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookdisplayTopColumn - ms - Mb
hookdisplayBanner - ms - Mb
hookdisplayBestSellers - ms - Mb
16 hooks 297 ms 16.00 Mb
Module Time Memory Usage
blockbestsellers 126 ms 2.50 Mb
fbpixel 11 ms 0.25 Mb
tooltips 10 ms 0.25 Mb
finalmenu 9 ms - Mb
x13canonical 7 ms 0.25 Mb
x13cookies 6 ms 1.50 Mb
blockcart 6 ms 0.25 Mb
ajaxcart 5 ms 0.50 Mb
blockhtml 5 ms - Mb
x13allegro 5 ms 0.25 Mb
platformaRatalna 4 ms 0.50 Mb
blocksearch 4 ms - Mb
psproductcountdown 4 ms - Mb
elevatezoom 4 ms 0.25 Mb
faktiva_seotk 4 ms - Mb
vatnumber 4 ms 0.75 Mb
sensbitdhl 3 ms 0.50 Mb
notarobot 3 ms - Mb
advancefooter 3 ms 0.25 Mb
sensbitgls 3 ms 0.75 Mb
revws 3 ms 0.25 Mb
htmlboxpro 3 ms 0.50 Mb
seomanager 3 ms - Mb
sekeywords 3 ms 0.25 Mb
x13lazyload 3 ms 0.50 Mb
pagesnotfound 3 ms - Mb
solditems 3 ms - Mb
blockcms 3 ms 0.25 Mb
socialnetworklinks 3 ms - Mb
blockcontact 2 ms - Mb
blocknewproducts 2 ms 0.25 Mb
blockcontactinfos 2 ms - Mb
blockmyaccountfooter 2 ms - Mb
blockuserinfo 2 ms - Mb
themeszonecarousel 2 ms 0.25 Mb
smartblog 2 ms 0.75 Mb
froggyquestiononproduct 2 ms 0.25 Mb
imoje 2 ms 0.25 Mb
blockcurrencies 2 ms - Mb
themeconfigurator 2 ms - Mb
bongooglereviews 2 ms - Mb
ganalytics 2 ms - Mb
colorzoom 2 ms 0.50 Mb
advancedordernotes 2 ms - Mb
ppb 2 ms 0.50 Mb
x13linkrewrite 2 ms 0.25 Mb
codegenerator 1 ms 0.25 Mb
blockviewed 1 ms 0.25 Mb
gmbestsellers 1 ms - Mb
x13opc 1 ms - Mb
editorial 1 ms - Mb
prestaspeed 1 ms 0.50 Mb
blocklayered 1 ms 0.50 Mb
lot_reinactive 1 ms 0.25 Mb
oviccustomtags 1 ms - Mb
blockmanufacturer 1 ms 0.25 Mb
blockmyaccount 1 ms 0.25 Mb
homeslider 1 ms 0.25 Mb
pele_relatedproducts 0 ms - Mb
productscategory 0 ms - Mb
bestkit_productfeatures 0 ms - Mb
61 modules 297 ms 16.00 Mb

Stopwatch SQL - 677 queries

Query Time (ms) Rows Filesort Group By Location
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105361|1|4","", FROM_UNIXTIME(1576193569))
437.7 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105360|1|4","", FROM_UNIXTIME(1576193569))
160.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
19.5 10 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
, 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,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-12-13 00:00:00",
INTERVAL 46 DAY
)
) > 0 AS new FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `ps_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 `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 4 AND pl.id_shop = 1 )
LEFT JOIN `ps_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 `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 4)
LEFT JOIN `ps_manufacturer` m
ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )JOIN `ps_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` = 1)JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_manufacturer` = 75
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY p.`date_add` desc
LIMIT 0,50
10.8 50544 Yes Yes /classes/Manufacturer.php:386
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (105361,105360,105359,105358,105357,105356,105355,105354,105353,105352,105345,105344,105343,105341,105340,105339,105338,105337,105336,105335,105334,105317,105316,105315,105314,105313,105312,105311,105309,105308,105305,105283,105282,105281,105280,105277,105276,105275,105274,105273,105272,105270,105268,105267,105266,23841,23839,23838,23836,23835) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
10.4 100 Yes /classes/Product.php:3465
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105337|1|4","", FROM_UNIXTIME(1576193570))
6.9 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105305|1|4","", FROM_UNIXTIME(1576193570))
3.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_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 `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (2))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
3.5 872 Yes Yes /classes/Hook.php:355
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 `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.1 466 /classes/Hook.php:236
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105275|1|4","", FROM_UNIXTIME(1576193570))
3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE * FROM `ps_image_type`
2.9 21 /classes/ImageType.php:143
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105339|1|4" AND compile_id="" LIMIT 1
2.4 1 /classes/SmartyCustom.php:215
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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2.3 1727 /classes/Configuration.php:148
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105338|1|4" AND compile_id="" LIMIT 1
2.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105341|1|4" AND compile_id="" LIMIT 1
2.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105336|1|4" AND compile_id="" LIMIT 1
2.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105343|1|4" AND compile_id="" LIMIT 1
2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 105361 AND `id_group` = 1 LIMIT 1
1.8 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE p.id_product, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`link_rewrite`, pl.`name`, pl.`description_short`, product_shop.`id_category_default`,
image_shop.`id_image` id_image, il.`legend`,
ps.`quantity` AS sales, p.`ean13`, p.`upc`, cl.`link_rewrite` AS category, p.show_price, p.available_for_order, IFNULL(stock.quantity, 0) as quantity, p.customizable,
IFNULL(pa.minimal_quantity, p.minimal_quantity) as minimal_quantity, stock.out_of_stock,
product_shop.`date_add` > "2019-10-28" as new,
product_shop.`on_sale`, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM (SELECT od.`product_id` AS `id_product`, COUNT(od.`product_id`) AS `quantity`, COUNT(od.`product_id`) AS `sale_nbr`, NOW() AS `date_upd`
FROM ps_order_detail od
JOIN ps_orders o ON od.`id_order` = o.`id_order`
AND o.`id_shop` = 1
AND o.`current_state`
IN (5,2) AND o.`date_add`
BETWEEN DATE_SUB( NOW( ) , INTERVAL 90 DAY ) AND NOW( ) JOIN ps_product_shop psh ON od.`product_id` = psh.`id_product`
AND psh.`id_shop` = 1
AND psh.`active` = 1
AND psh.`available_for_order` = 1
AND psh.`price` >= 0
AND psh.`visibility` != 'none'  JOIN ps_product prd ON od.`product_id` = prd.`id_product`  AND prd.`id_manufacturer` = 75 GROUP BY od.`product_id` ) ps
LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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 `ps_product_attribute` pa ON (product_attribute_shop.id_product_attribute=pa.id_product_attribute)
LEFT JOIN `ps_product_lang` pl
ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.id_shop = 1 
LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 4)
LEFT JOIN `ps_category_lang` cl
ON cl.`id_category` = product_shop.`id_category_default`
AND cl.`id_lang` = 4 AND cl.id_shop = 1  LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE product_shop.`active` = 1
AND p.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`)
ORDER BY ps.quantity DESC
LIMIT 0, 8
1.7 33689559852 Yes /override/classes/ProductSale.php:194
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105352|1|4" AND compile_id="" LIMIT 1
1.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105344|1|4" AND compile_id="" LIMIT 1
1.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105345|1|4" AND compile_id="" LIMIT 1
1.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105353|1|4" AND compile_id="" LIMIT 1
1.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105305) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105354
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.5 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105357|1|4" AND compile_id="" LIMIT 1
1.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105356
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.4 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105359
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.3 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105359|1|4" AND compile_id="" LIMIT 1
1.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE p.`id_product`
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_manufacturer = 75 AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND EXISTS (
SELECT 1
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` = 1
)
1.3 351 /classes/Manufacturer.php:322
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105335|1|4" AND compile_id="" LIMIT 1
1.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105267) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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
1.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105360)
1.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105267) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105270|1|4" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.2 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105337|1|4" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105313|1|4" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105311|1|4" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 6774
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105358
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105280|1|4" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105283|1|4" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105354|1|4" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105308|1|4" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105356|1|4","", FROM_UNIXTIME(1576193569))
1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105360
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105355|1|4" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105266) AND (b.`id_shop` = 1) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.9 1032 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105305 AND id_shop=1 LIMIT 1
0.9 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105317|1|4" AND compile_id="" LIMIT 1
0.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 6771
ORDER BY f.position ASC
0.9 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105357) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105314|1|4","", FROM_UNIXTIME(1576193569))
0.9 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105274|1|4","", FROM_UNIXTIME(1576193570))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105266
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.8 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 6774)
0.8 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105266)
0.8 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105356 AND id_shop=1 LIMIT 1
0.7 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105266) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105281|1|4","", FROM_UNIXTIME(1576193570))
0.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105267
ORDER BY f.position ASC
0.7 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 6771 LIMIT 1
0.7 1 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6774) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 105266 LIMIT 1
0.7 1 /classes/Product.php:752
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105357) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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:362
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105358|1|4" AND compile_id="" LIMIT 1
0.7 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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105355)
0.7 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105359) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6774) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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:362
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 105305 LIMIT 1
0.6 1 /classes/Product.php:752
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105280
ORDER BY f.position ASC
0.6 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105356
ORDER BY f.position ASC
0.6 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105356) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105358) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105355) AND (b.`id_shop` = 1) LIMIT 1
0.6 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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105305)
0.5 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105343|1|4","", FROM_UNIXTIME(1576193569))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105359) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105354) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'small_default' LIMIT 1
0.5 1 /classes/Image.php:472
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105357) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105357
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`
FROM `ps_manufacturer_lang` ml
LEFT JOIN `ps_manufacturer` m ON (ml.`id_manufacturer` = m.`id_manufacturer`)
WHERE ml.id_lang = 4
AND ml.id_manufacturer = 75 LIMIT 1
0.5 1 /override/classes/Meta.php:316
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105358) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105305|1|4","", FROM_UNIXTIME(1576193570))
0.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105309|1|4","", FROM_UNIXTIME(1576193570))
0.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_x13linkrewrite FROM ps_x13linkrewrite WHERE active = 1 AND old_url = 'https://eversun.pl/75-de-noyles' LIMIT 1
0.5 600 /modules/x13linkrewrite/classes/UrlRedirect.php:33
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 4)
WHERE pa.id_product = 105267
0.5 1 /classes/Product.php:4470
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 4)
WHERE deleted = 0
ORDER BY `name` ASC
0.4 55 Yes /override/classes/order/OrderState.php:21
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105345|1|4","", FROM_UNIXTIME(1576193569))
0.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105282|1|4","", FROM_UNIXTIME(1576193570))
0.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105266) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105354) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105355) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105266
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105358
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 144 /classes/module/Module.php:277
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105353|1|4","", FROM_UNIXTIME(1576193569))
0.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105345) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.4 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105353) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.4 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105361
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105267) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105344) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.4 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 144 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 144 /classes/module/Module.php:277
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.4 1 /classes/Image.php:472
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.4 144 /classes/module/Module.php:277
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105354
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105305) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105358|1|4","", FROM_UNIXTIME(1576193569))
0.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105340|1|4","", FROM_UNIXTIME(1576193569))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 9 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.3 46 Yes /classes/Dispatcher.php:452
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105357|1|4","", FROM_UNIXTIME(1576193569))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105361) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105280) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105360) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105344) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105361) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105345) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 105358 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105355|1|4","", FROM_UNIXTIME(1576193569))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105355) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105356) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6771) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
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 ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.3 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.3 46 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105359) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105337) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105274|1|4" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105354) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105275) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105341) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105340) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105314) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105283) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105345
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105352|1|4","", FROM_UNIXTIME(1576193569))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105316) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105276) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105314|1|4" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105358) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105272) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105352) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105335) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105313) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105344|1|4","", FROM_UNIXTIME(1576193569))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105315) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105353
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105352
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105277) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105317) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105309) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105334) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105312) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105343) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105336) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105311) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 23839) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105268) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 23836) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 23841) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105273) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 4)
WHERE pa.id_product = 6774
0.3 1 /classes/Product.php:4470
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105338) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.3 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105308) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105270) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105274) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_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 7 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 23838) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105281) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 23835) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105282) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 105339) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-13 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.2 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 6774) 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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105345)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105312) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105353) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105360) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105360
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 6771) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105275) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105343) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105314) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105280) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105316) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105309) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105352) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105337) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105336) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105283) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105335) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105276) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105341) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'eversun.pl' OR su.domain_ssl = 'eversun.pl')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.2 1 /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23841) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105313) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105340) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105315) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`
FROM `ps_manufacturer_lang` ml
LEFT JOIN `ps_manufacturer` m ON (ml.`id_manufacturer` = m.`id_manufacturer`)
WHERE ml.id_lang = 4
AND ml.id_manufacturer = 75 LIMIT 1
0.2 1 /override/classes/Meta.php:316
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105273) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105274) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105277) 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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105344)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 6774
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105272) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105311) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105338) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105334) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105282) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23839) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23838) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105270) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105268) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105308) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105305
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23835) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105339) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105281) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105317) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23836) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105355
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105353)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105335
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105340
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105282
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105359
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105314
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105272
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 23841
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105268|1|4" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105337
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105275
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105353
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105273
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 23839
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105281
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 23835
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105344
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105317
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105341
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105316
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105313
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105283
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105315
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105343
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105270
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 23836
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105336
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105276
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105277
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 23838
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105312
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105339
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105308
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105274
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105309
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105338
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105334
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105268
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105311
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105280)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 4
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 105266 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105267)
0.2 1 /classes/Product.php:2998
UPDATE `ps_smarty_lazy_cache`
SET filepath='manufacturer/0/0/75/13122019/x13canonical/1/1/2/4/21/95/08/e3/9508e3422cc184bdd5d7c3ae2923613be771ca6e.x13canonical.tpl.php'
WHERE `template_hash`='96889b07532fce64981e0de3202dfc14' AND cache_id="manufacturer|0|0|75|13122019|x13canonical|1|1|2|4|21" AND compile_id=""
0.2 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `name` ASC
0.2 21 Yes /classes/ImageType.php:108
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.2 8 /classes/Currency.php:472
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105340)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 6771)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105273)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105356)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105335)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM `ps_tooltips` a LEFT JOIN `ps_tooltips_lang` l ON (l.`id_tooltips` = a.`id_tooltips` AND l.`id_lang` = 4) WHERE a.`active`=1 AND (a.`everywhere`=1)
0.2 1 /modules/tooltips/models/tooltip.php:78
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105282)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105314)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105281)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105357)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105277)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105354)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105361)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105352)
0.2 1 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105315|1|4","", FROM_UNIXTIME(1576193569))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105313)
0.2 1 /classes/Product.php:2998
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockbestsellers_col/manufacturer/7520191213/52/c3/4d/52c34d5b912fda59a8284683ec5d552f07e12bbf.blockbestsellers.tpl.php'
WHERE `template_hash`='78e59836470b916bbc2fb9d67502c338' AND cache_id="blockbestsellers-col|manufacturer|7520191213" AND compile_id=""
0.2 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 23835)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105359)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105309)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105337)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105272)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105338)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_xallegro_configuration
0.2 55 /modules/x13allegro/classes/php5/XAllegroConfiguration.php:0
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105316)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105270)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105312)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105336)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105343)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105339)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105317)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105315)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105276)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105268)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105275)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 23839)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105341)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105283)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='96889b07532fce64981e0de3202dfc14' AND cache_id="manufacturer|0|0|75|13122019|x13canonical|1|1|2|4|21" 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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105308)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105334)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105358)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 23841)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105311)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 4
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 75) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 9)
WHERE l.`active` = 1 LIMIT 1
0.2 1 /classes/Language.php:894
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 6774 LIMIT 1
0.2 1 /classes/Product.php:752
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 105274)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 4
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.1 16 Yes /modules/themeconfigurator/themeconfigurator.php:376
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105305
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_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 product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 23838)
0.1 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 23836)
0.1 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 4)
WHERE pa.id_product = 6771
0.1 1 /classes/Product.php:4470
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='78e59836470b916bbc2fb9d67502c338' AND cache_id="blockbestsellers-col|manufacturer|7520191213" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `title`, `content` FROM ps_x13cookies WHERE `id_lang`=4 AND id_shop = 1 LIMIT 1
0.1 1 /modules/x13cookies/x13cookies.php:86
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105309|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.1 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105273|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.1 86 /classes/Hook.php:187
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105276|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 4
LEFT JOIN `ps_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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105273|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =10 AND m.page = "manufacturer" LIMIT 1
0.1 1 /classes/Theme.php:275
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105275|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "x13allegro" LIMIT 1
0.1 1 /classes/module/Module.php:2568
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105311|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105312|1|4" 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 `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105275|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105308|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 4)
WHERE pa.id_product = 105280
0.1 1 /classes/Product.php:4470
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105336|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105276|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.1 1 /classes/Country.php:174
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105312|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105270|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105272|1|4" 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 `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105315|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105334|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105317|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105282|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105313|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105280|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105277|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105280) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105305|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105283|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105272|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105316|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105316|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105281|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105277|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 105280 LIMIT 1
0.1 1 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105345) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='c7785c26c1e8ace22e170ecbfc8150e7' AND cache_id="blockcms|2|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 105267 LIMIT 1
0.1 1 /classes/Product.php:752
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.1 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'PLN') LIMIT 1
0.1 8 /classes/Currency.php:319
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105361|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('96889b07532fce64981e0de3202dfc14',"manufacturer|0|0|75|13122019|x13canonical|1|1|2|4|21","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b72c564c36a8a2788ac80280c358eb47' AND cache_id="blockcontact|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 149 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 266 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4c5949ab6bf1e034ada75aa96467b7f8' AND cache_id="6|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 4)
WHERE pa.id_product = 105266
0.1 1 /classes/Product.php:4470
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105360|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105268|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 4)
WHERE pa.id_product = 105305
0.1 1 /classes/Product.php:4470
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105345
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='da2dedab9d01c805621032fa013ad5a4' AND cache_id="top_menu|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('78e59836470b916bbc2fb9d67502c338',"blockbestsellers-col|manufacturer|7520191213","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 150 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.1 1 /classes/Language.php:777
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105336|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e67ea290717444848a05188b10e74581' AND cache_id="advancefooter|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('78e59836470b916bbc2fb9d67502c338',"blockbestsellers-col|manufacturer|7520191213","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105274|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105341|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105344
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4c5949ab6bf1e034ada75aa96467b7f8' AND cache_id="3|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105283|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='7840100a95e20640bb54b0934b8fbcad' AND cache_id="blocksearch-top|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 2) LIMIT 1
0.1 0 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105345 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='89a08778e42116e086e70e3b285fea10' AND cache_id="blockcontactinfos|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 4) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2019-12-13 00:00:00' AND '2019-12-13 23:59:59' LIMIT 1
0.1 1 /classes/SpecificPrice.php:302
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "psgdpr" LIMIT 1
0.1 0 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|23841|1|4" 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 `ps_smarty_lazy_cache`
WHERE `template_hash`='1c49d7c37e3eda433b4ac1f4e64fce38' AND cache_id="side_menu|1|1|2|4|21" 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 `ps_smarty_lazy_cache`
WHERE `template_hash`='3b8b28e4a58e1d14d7551869402afe03' AND cache_id="blockmyaccountfooter|1|1|2|4|21" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105353 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105354|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105361) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105359|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|23835|1|4" 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 `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105267|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105338|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|23839|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105354 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|23838|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105267|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105335|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23835|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105339|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105340|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105358|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|23836|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105266|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23838|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23836|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23841|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105361|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23839|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105337|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 129 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105356|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105360|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105339|1|4","", FROM_UNIXTIME(1576193569))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.1 0 /classes/Language.php:719
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105316|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105268) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105266|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105360) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105305) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e171304a01713dce16ad967c4292f4ec' AND cache_id="productlist_colors|105334|1|4" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105280
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23836) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105355|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105356) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105353|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105283) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.1 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6771) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105316
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105308|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105353) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105312
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('96889b07532fce64981e0de3202dfc14',"manufacturer|0|0|75|13122019|x13canonical|1|1|2|4|21","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23835) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105354|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105357|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105313) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105340|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105281
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105345|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105317) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105267
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105359|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105343|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105337) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 147 LIMIT 1
0.1 1 /classes/Category.php:1054
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105352|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105361
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 2
0.1 1 /Adapter/Adapter_EntityMapper.php:68
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105356|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 4
0.1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23841) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105335|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105344|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105313|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23839) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105281) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 146 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105314) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105355
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 202 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105275) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105276) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105340) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105308) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105283
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105270 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105273) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 763 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105309) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105338) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 148 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105352) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105270) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105336) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105352
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105274) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105335) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 105345 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105344 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105311) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 6771
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105344) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105315) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105341|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105312) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105317|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105316) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 5 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105272) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105339) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105277) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105341) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23838) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105343) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105314|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105312|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105316 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105282) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 105334) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105315|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105311|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105276
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105338|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 23835 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105282|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 517 LIMIT 1
0.1 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105308
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105357
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105341 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105360 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105266 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105313 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105355 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105343
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105336
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105334|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 4) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 10) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23841
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105280 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105312 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105313
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE id_shop
FROM `ps_manufacturer_shop`
WHERE `id_manufacturer` = 75
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1459
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23841|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23836
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 23838 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 105353 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105314
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105340
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105341
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105317
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105315
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105277
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105277|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105311
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23835
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105272 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23839
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105335
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105281|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105273
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105309
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105281 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 105340 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105275
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105270
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105337
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23839|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|105309|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105339
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105282
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e171304a01713dce16ad967c4292f4ec',"productlist_colors|23836|1|4","", FROM_UNIXTIME(1576193570))
0.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23838
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198