Корзина

Меню

Подобрать товар ⬇

Категория

Сброс

Коллекция

Страна производства

Фаска

Цена

2280 Р - 9150 Р

Рисунок

Порода дерева

Тип укладки

Бесплатная доставка при покупке от 20000 руб.
Гарантия качества от производителя.
Выгодная цена при покупке на сайте.
Большой выбор товаров в наличии и на заказ.

Напольное покрытие в Самаре

Показано 1 - 36 из 250 товаров
Показано 1 - 36 из 250 товаров
Load Time13933 ms - You'd better run your shop on a toaster
Querying Time7134 ms
Queries869
Memory Peak Usage21.8 Mb
Included Files316 files - 6.36 Mb
PrestaShop Cache- Mb
Global vars0.85 Mb
PrestaShop Version1.6.1.18
PHP Version7.1.33-2+ubuntu18.04.1+deb.sury.org+1 (OK)
MySQL Version5.7.30-0ubuntu0.18.04.1 (OK)
Memory Limit1024M
Max Execution Time0s
Smarty Cacheenabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 183 ms 183 ms 4.03 Mb 5.01 Mb
__construct 0 ms 183 ms - Mb 5.01 Mb
init 121 ms 304 ms 0.68 Mb 5.01 Mb
checkAccess 0 ms 304 ms - Mb 5.01 Mb
setMedia 3 ms 307 ms 0.03 Mb 5.01 Mb
postProcess 0 ms 307 ms - Mb 5.01 Mb
initHeader 0 ms 307 ms - Mb 5.01 Mb
initContent 8865 ms 9173 ms 12.53 Mb 17.29 Mb
initFooter 705 ms 9878 ms 0.77 Mb 18.94 Mb
display 4055 ms 13933 ms 2.79 Mb 21.78 Mb
Hook Time Memory Usage
hookdisplayLeftColumn 4719 ms - Mb
hookactionProductListOverride 898 ms 2.00 Mb
hookdisplayProductListReviews 649 ms - Mb
hookfooter 415 ms 2.00 Mb
hookleftcolumn 237 ms - Mb
hookdisplayTop 173 ms - Mb
hooktop 156 ms - Mb
hookdisplayHeader 144 ms - Mb
hookdisplayProductListFunctionalButtons 87 ms - Mb
hookHeader 77 ms - Mb
__construct 60 ms - Mb
hookdisplayNav 35 ms - Mb
hookdisplayGform 23 ms - Mb
hookdisplayFooter 5 ms - Mb
hookmoduleRoutes 1 ms - Mb
hookdisplayTopColumn 0 ms - Mb
16 hooks 7680 ms 4.00 Mb
Module Time Memory Usage
pm_advancedsearch4 5616 ms 2.00 Mb
productcomments 650 ms - Mb
blockshopreviews 327 ms - Mb
advanceblog 187 ms - Mb
blocktopmenu 172 ms - Mb
blockcart 147 ms - Mb
blocknewsletter 141 ms 2.00 Mb
blockwishlist 93 ms - Mb
fsopengraph 64 ms - Mb
freecall 56 ms - Mb
infinitescroll 49 ms - Mb
blockuserinfo 34 ms - Mb
responsivemenu 31 ms - Mb
gformbuilderpro 26 ms - Mb
themeconfigurator 26 ms - Mb
seosageo 15 ms - Mb
gmseofields 7 ms - Mb
blocksearch 6 ms - Mb
blockcategories 4 ms - Mb
blocksocial 4 ms - Mb
blockcms 4 ms - Mb
blockcontactinfos 3 ms - Mb
magiczoomplus 3 ms - Mb
blockcontact 3 ms - Mb
yandexmodule 3 ms - Mb
seoexpert 3 ms - Mb
howmanybox 2 ms - Mb
callforprice 1 ms - Mb
mailalerts 1 ms - Mb
homeslider 1 ms - Mb
blockviewed 1 ms - Mb
productscategory 0 ms - Mb
blockmyaccount 0 ms - Mb
crossselling 0 ms - Mb
34 modules 7680 ms 4.00 Mb

Stopwatch SQL - 869 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-06-05 00:00:00",
INTERVAL 0 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`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_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  )
LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category`
AND c.nleft >= 10 AND c.nright <= 11)
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 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` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE c.id_category > 0
AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY `orderprice` ASC
LIMIT 0,36
469.2 3060 Yes Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 23
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
275.2 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/15/c8023eb0b648ef693f2a5cfe26eca918350df0a1/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|15|c8023eb0b648ef693f2a5cfe26eca918350df0a1|1|1|1|1|0" AND compile_id=""
225.9 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/39/4022971bc2a47c36e1fd358bdc458901ba730068/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|39|4022971bc2a47c36e1fd358bdc458901ba730068|1|1|1|1|0" AND compile_id=""
223.1 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
LEFT JOIN `ps_category_group` cg ON ( cg.`id_category` = aclink.`id_criterion_linked`) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND cg.`id_group` = 1
AND ac.`id_criterion_group` = 4
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
180.1 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 5
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
155.5 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|7|c8a272a8269c2448c678a9568f92c253c521be79|1|1|1|1|0","", FROM_UNIXTIME(1591346719))
146.2 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5120|1|1%"
145.4 1 /classes/SmartyCustom.php:295
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/10/14d9fc1dd2335a55d2e7f94fb0425d474a7dc30e/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|10|14d9fc1dd2335a55d2e7f94fb0425d474a7dc30e|1|1|1|1|0" AND compile_id=""
140.5 1 /classes/SmartyCustom.php:183
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5118|1|1%"
136 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|21|8290463a11970947fa3d685238ff2e5a10678863|1|1|1|1|0","", FROM_UNIXTIME(1591346721))
135.6 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4056|1|1%"
132.5 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 7
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
132.5 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|41|39586f93c9a825b68be813b6b11bb324f3e15aa2|1|1|1|1|0","", FROM_UNIXTIME(1591346722))
129.8 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/24/7e9def26d2e580631a220837350076e14076e136/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|24|7e9def26d2e580631a220837350076e14076e136|1|1|1|1|0" AND compile_id=""
129.7 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|15|c8023eb0b648ef693f2a5cfe26eca918350df0a1|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
128.3 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/9/3080ed67fd04b39e6276ef69609a691387bb1e92/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|9|3080ed67fd04b39e6276ef69609a691387bb1e92|1|1|1|1|0" AND compile_id=""
122.3 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/35/78585796571924ff97ffce41c19b81e64ebbd188/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|35|78585796571924ff97ffce41c19b81e64ebbd188|1|1|1|1|0" AND compile_id=""
113.1 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 30
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
112.5 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/38/998ee713062d1476067b635f0dc630736e8c0bf8/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|38|998ee713062d1476067b635f0dc630736e8c0bf8|1|1|1|1|0" AND compile_id=""
104.9 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 36
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
102.3 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5911|1|1%"
99.9 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|36|d09dcb6cc77e96a8793e751299e49e7967fd330d|1|1|1|1|0","", FROM_UNIXTIME(1591346721))
98 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5910|1|1%"
96.3 1 /classes/SmartyCustom.php:295
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/7/c8a272a8269c2448c678a9568f92c253c521be79/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|7|c8a272a8269c2448c678a9568f92c253c521be79|1|1|1|1|0" AND compile_id=""
91 1 /classes/SmartyCustom.php:183
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4156|1|1%"
90.3 1 /classes/SmartyCustom.php:295
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/34/85c8ac63f90fce3483234f8834e2f8a1b9d40c1d/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|34|85c8ac63f90fce3483234f8834e2f8a1b9d40c1d|1|1|1|1|0" AND compile_id=""
83.6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 35
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
83.5 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1586|1|1%"
77.4 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4720|1|1%"
75.8 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 38
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
71.3 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE DISTINCT t.*, tl.*, t2.`img_path`, COUNT(DISTINCT c.comments_id) AS countofcomment, pc.`id_blogcategory`,
pcl.`category_title`, pcl.`link_rewrite_cat`, pcl.`id_lang`, pcl.`id_blogcategory`, fmcg.`id_group`,fbauth.`name` as `author_name`,fbauth.`id_author`
FROM `ps_fme_blog_posts` t
LEFT JOIN `ps_fme_blog_post_cat` pc
ON (t.id_post = pc.id_post)
LEFT JOIN `ps_fme_blog_categories_lang` pcl
ON (pc.id_blogcategory = pcl.id_blogcategory AND pcl.id_lang = 1)
LEFT JOIN `ps_fme_blog_posts_lang` tl ON (
t.`id_post` = tl.`id_post`
AND tl.`id_lang` = 1
)
LEFT JOIN `ps_fme_blog_categories_group` fmcg
ON (pc.id_blogcategory = fmcg.id_blogcategory AND fmcg.id_group = 1)
LEFT JOIN `ps_fme_blog_post_auth` fba
ON (t.id_post = fba.id_post)
LEFT JOIN `ps_fme_blog_authors` fbauth
ON (fbauth.id_author = fba.id_auth)
LEFT JOIN `ps_fme_blog_posts_shop` sh
ON (sh.id_post = t.id_post)
LEFT JOIN `ps_fme_blog_posts_comments` c
ON (t.id_post = c.id_post AND c.active = 1)
LEFT JOIN `ps_fme_blog_images` t2 ON (t.id_post = t2.id_post AND t2.featured = 1)
WHERE t.`active` = 1
AND t.`publication_time` < now()
AND sh.id_shop = 1
AND fmcg.id_group IS NOT NULL
GROUP BY t.id_post
ORDER BY t.`publication_time` desc  Limit 0,3
69.5 48313920 Yes /modules/advanceblog/models/BlogPosts.php:368
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1585|1|1%"
69.2 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4155|1|1%"
66.8 1 /classes/SmartyCustom.php:295
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/13/7f92639ba5ca672288c0cb4da61f81278aded63f/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|13|7f92639ba5ca672288c0cb4da61f81278aded63f|1|1|1|1|0" AND compile_id=""
66.4 1 /classes/SmartyCustom.php:183
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|3775|1|1%"
65.7 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 9
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
62.4 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|3776|1|1%"
58 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5119|1|1%"
57.7 1 /classes/SmartyCustom.php:295
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/36/d09dcb6cc77e96a8793e751299e49e7967fd330d/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|36|d09dcb6cc77e96a8793e751299e49e7967fd330d|1|1|1|1|0" AND compile_id=""
55.8 1 /classes/SmartyCustom.php:183
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5107|1|1%"
51.8 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 40
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
49.4 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 24
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
49.2 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 34
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
47.8 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 13
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
46.4 64 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|3771|1|1%"
46.2 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5121|1|1%"
45.6 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1579|1|1%"
45 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5915|1|1%"
44.7 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5122|1|1%"
40.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4150|1|1%"
39.5 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 39
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
39.5 8 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 21
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
37.5 24 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
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`)
35.8 4086 /classes/Configuration.php:148
SELECT SQL_NO_CACHE acp.id_product, (IF(app.`valid_id_specific_price`=1 AND app.`is_specific`=1, 1, 0) + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`), 1, 0) +  IF (app.`id_country` IN (0, 0), 4, 0) +  IF (app.`id_currency` IN (0, 1), 8, 0) +  IF (app.`id_shop` IN (0, 1), 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_1` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672))
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 0 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 0)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` -
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
* IF(grc.`reduction` > 0, 1 - grc.`reduction`, 1) ASC LIMIT 1
35 1 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:50
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 10
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
34 16 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1584|1|1%"
33.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1588|1|1%"
33.1 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4050|1|1%"
32.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4149|1|1%"
30.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5916|1|1%"
30.3 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|3772|1|1%"
30 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1583|1|1%"
29.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|3774|1|1%"
29.4 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|7|c8a272a8269c2448c678a9568f92c253c521be79|1|1|1|1|0","", FROM_UNIXTIME(1591346719))
28.4 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5912|1|1" AND compile_id="" LIMIT 1
26.5 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 6
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
26.3 12 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 37
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
26.1 8 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5912|1|1%"
25.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5917|1|1%"
24.6 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|5123|1|1%"
23 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 41
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
21.1 16 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1589|1|1%"
20.1 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|1587|1|1%"
19.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4048|1|1%"
18.5 1 /classes/SmartyCustom.php:295
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5123
ORDER BY f.position ASC
18.4 10 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|1587|1|1" AND compile_id="" LIMIT 1
18 0 /classes/SmartyCustom.php:215
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|4157|1|1%"
17.8 1 /classes/SmartyCustom.php:295
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/30/6c22781a6fbdd5043c0e4e53323959a0a3cd3fc6/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|30|6c22781a6fbdd5043c0e4e53323959a0a3cd3fc6|1|1|1|1|0" AND compile_id=""
15.6 1 /classes/SmartyCustom.php:183
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id LIKE "productlist_colors|3773|1|1%"
15.5 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|10|14d9fc1dd2335a55d2e7f94fb0425d474a7dc30e|1|1|1|1|0","", FROM_UNIXTIME(1591346719))
15.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE acp.id_product, (IF(app.`valid_id_specific_price`=1 AND app.`is_specific`=1, 1, 0) + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`), 1, 0) +  IF (app.`id_country` IN (0, 0), 4, 0) +  IF (app.`id_currency` IN (0, 1), 8, 0) +  IF (app.`id_shop` IN (0, 1), 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_1` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672))
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 0 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 0)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` -
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
* IF(grc.`reduction` > 0, 1 - grc.`reduction`, 1) DESC LIMIT 1
14.8 1 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:50
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 12
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
14.5 8 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4050) AND (b.`id_shop` = 1) LIMIT 1
14.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|37|138f32c902c22dd0b3548061d5eb0b85f4718a8e|1|1|1|1|0","", FROM_UNIXTIME(1591346722))
14 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|39|4022971bc2a47c36e1fd358bdc458901ba730068|1|1|1|1|0","", FROM_UNIXTIME(1591346718))
13.4 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|4150|1|1" AND compile_id="" LIMIT 1
13 0 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|12|52489e108891e70f701caaac0895f911b548055f|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
12.9 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|40|d98d2429ba7e48184a5df4c2451fcb47dbd12417|1|1|1|1|0","", FROM_UNIXTIME(1591346722))
12.3 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/6/a2501d7ac47847678d3051e395027b9060927ad5/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|a2501d7ac47847678d3051e395027b9060927ad5|1|1|1|1|0" AND compile_id=""
11.7 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|3775" AND compile_id="" LIMIT 1
11.6 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|1589|1|1" AND compile_id="" LIMIT 1
11.5 0 /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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4149
ORDER BY f.position ASC
11.2 6 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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
11.1 1 Yes /classes/SpecificPrice.php:362
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 (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
11 5325 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3772 AND id_shop=1 LIMIT 1
10.9 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5910|1|1" AND compile_id="" LIMIT 1
10.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|12|52489e108891e70f701caaac0895f911b548055f|1|1|1|1|0" AND compile_id="" LIMIT 1
9.4 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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|3776" AND compile_id="" LIMIT 1
9.2 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/4/026d7ea40e00eda085e971f06b9e44c5119e8cb7/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|4|026d7ea40e00eda085e971f06b9e44c5119e8cb7|1|1|1|1|0" AND compile_id=""
9.1 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|4149|1|1" AND compile_id="" LIMIT 1
9 0 /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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5910
ORDER BY f.position ASC
9 12 Yes /classes/Product.php:4456
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|41|39586f93c9a825b68be813b6b11bb324f3e15aa2|1|1|1|1|0","", FROM_UNIXTIME(1591346722))
8.5 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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5123" AND compile_id="" LIMIT 1
8.2 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getPriceRangeForSearchBloc/18/43ac38a91d6d036fb6026122442bc94e5b633e49/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getPriceRangeForSearchBloc|18|43ac38a91d6d036fb6026122442bc94e5b633e49|1|1|1|1|0" AND compile_id=""
7.8 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4050 AND id_shop=1 LIMIT 1
7.6 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3773 AND id_shop=1 LIMIT 1
7.4 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|9|3080ed67fd04b39e6276ef69609a691387bb1e92|1|1|1|1|0" AND compile_id="" LIMIT 1
6.6 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 66 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
6.5 11 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
6.2 1 Yes Yes /classes/Supplier.php:127
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` = 3772)
6.2 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'left' AND active = 1
ORDER BY item_order ASC
6.1 234 Yes /modules/themeconfigurator/themeconfigurator.php:375
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/23/a8b9c5bf541cba6958be36902e899ca04c049f32/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|23|a8b9c5bf541cba6958be36902e899ca04c049f32|1|1|1|1|0" AND compile_id=""
6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3774 AND `id_group` = 1 LIMIT 1
6 0 /classes/GroupReduction.php:149
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/21/8290463a11970947fa3d685238ff2e5a10678863/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|21|8290463a11970947fa3d685238ff2e5a10678863|1|1|1|1|0" AND compile_id=""
6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|a2501d7ac47847678d3051e395027b9060927ad5|1|1|1|1|0" AND compile_id="" LIMIT 1
5.6 1 /classes/SmartyCustom.php:215
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` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5123,5121,5122,5119,5120,4056,5118,4050,4048,4149,4157,1588,1589,1587,4150,1583,1586,3775,3776,3772,3774,3773,3771,4155,5107,4156,1579,1584,1585,5910,5911,5912,5915,5916,5917,4720) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
5.5 504 Yes /classes/Product.php:3468
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` = 4050)
5.4 1 /classes/Product.php:3002
UPDATE `ps_smarty_lazy_cache`
SET filepath='blocktopmenu/1/1/1/1/0/category/36/20/22/61/202261737f7471ff70a95274dd663f2dc7c8ef47.blocktopmenu.tpl.php'
WHERE `template_hash`='9b076b330c3b383e100e4c23e6c16d43' AND cache_id="blocktopmenu|1|1|1|1|0|category|36" AND compile_id=""
5.4 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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
5 1 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 = 5123 LIMIT 1
4.9 1 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|9|3080ed67fd04b39e6276ef69609a691387bb1e92|1|1|1|1|0","", FROM_UNIXTIME(1591346719))
4.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 36 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
4.7 319 /classes/Category.php:712
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|4720" AND compile_id="" LIMIT 1
4.7 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/5/d0c63005821b79fa5630ca99fdc774de3962bf5c/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|5|d0c63005821b79fa5630ca99fdc774de3962bf5c|1|1|1|1|0" AND compile_id=""
4.6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5911|1|1" AND compile_id="" LIMIT 1
4.5 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 15
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
4.3 8 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|a2501d7ac47847678d3051e395027b9060927ad5|1|1|1|1|0","", FROM_UNIXTIME(1591346719))
4.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE geo.*, geo.`id_city` as `id`, s.domain  FROM ps_dgeolocation_city_state geo LEFT JOIN ps_shop_url s ON(geo.id_shop = s.id_shop)
WHERE geo.`active` = 1 AND geo.id_shop > 0
3.9 990 /modules/seosageo/classes/DGeolocationCityState.php:53
SELECT SQL_NO_CACHE * FROM `ps_image_type`
3.8 9 /classes/ImageType.php:143
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|1588" AND compile_id="" LIMIT 1
3.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 36
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
3.6 1 Yes Yes /classes/Category.php:656
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4149
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.5 1 /classes/SpecificPrice.php:196
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
3.5 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE t.*, tl.comment_content, c.avatar, p.link_rewrite, p.post_title
FROM `ps_fme_blog_posts_comments` t
LEFT JOIN `ps_fme_blog_posts_comments_lang` tl ON (
t.`comments_id` = tl.`comments_id`
AND tl.`id_lang` = 1
)
LEFT JOIN `ps_fme_blog_posts_lang` p ON (
t.`id_post` = p.`id_post`
AND p.`id_lang` = 1
)
LEFT JOIN `ps_fme_blog_posts_shop` sh
ON (sh.id_post = t.id_post)
LEFT JOIN `ps_customer` c
ON (t.`id_customer` = c.`id_customer`)
WHERE t.`active` = 1
AND sh.id_shop = 1
ORDER BY t.`comments_id` DESC
LIMIT 0, 5
3.4 5 /modules/advanceblog/models/BlogPosts.php:1103
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|38|998ee713062d1476067b635f0dc630736e8c0bf8|1|1|1|1|0","", FROM_UNIXTIME(1591346722))
3.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE app.price_wt as max_price, app.`reduction_amount`, app.`reduction_type`, app.`reduction_tax`, acp.id_product, app.id_currency, app.id_country, (IF(app.`valid_id_specific_price`=1 AND app.`is_specific`=1, 1, 0) + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`), 1, 0) +  IF (app.`id_group` = 1, 2, 0) +  IF (app.`id_country` = 0, 4, 0) +  IF (app.`id_currency` = 1, 8, 0) +  IF (app.`id_shop` = 1, 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_1` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672))
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 0 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE acp.`id_product` = 4712 AND  ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 0)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` -
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
* IF(grc.`reduction` > 0, 1 - grc.`reduction`, 1) DESC LIMIT 1
3.3 0 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:50
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5915
ORDER BY f.position ASC
3.1 12 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5122|1|1" AND compile_id="" LIMIT 1
3.1 0 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/41/39586f93c9a825b68be813b6b11bb324f3e15aa2/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|41|39586f93c9a825b68be813b6b11bb324f3e15aa2|1|1|1|1|0" AND compile_id=""
3.1 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|40|d98d2429ba7e48184a5df4c2451fcb47dbd12417|1|1|1|1|0","", FROM_UNIXTIME(1591346722))
3.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 19 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
3 10 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE s.`seo_key`, s.`id_seo`, sl.`seo_url`
FROM `ps_pm_advancedsearch_seo` s
JOIN `ps_pm_advancedsearch_seo_lang` sl ON (s.`id_seo`=sl.`id_seo` AND sl.`id_lang`=1)
WHERE s.`seo_key` IN ("b7a55873d1bd685ec915a4d2ed41a6c6","72348e3a2a12c35a0c0e3a981b688a99")
AND s.`deleted`=0
3 2 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5910
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3 1 /classes/SpecificPrice.php:196
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/12/52489e108891e70f701caaac0895f911b548055f/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|12|52489e108891e70f701caaac0895f911b548055f|1|1|1|1|0" AND compile_id=""
3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|1585" AND compile_id="" LIMIT 1
3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 17 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.9 56 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 18 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.9 56 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE COUNT(DISTINCT cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category`
AND c.nleft >= 10 AND c.nright <= 11)
WHERE c.id_category > 0  AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
2.8 612 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:52
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/32/9fecf8e0bbb0047179e4fd9e9075d368e43c7b83/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|32|9fecf8e0bbb0047179e4fd9e9075d368e43c7b83|1|1|1|1|0" AND compile_id=""
2.8 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|4|026d7ea40e00eda085e971f06b9e44c5119e8cb7|1|1|1|1|0","", FROM_UNIXTIME(1591346718))
2.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|5|d0c63005821b79fa5630ca99fdc774de3962bf5c|1|1|1|1|0","", FROM_UNIXTIME(1591346718))
2.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE * FROM `ps_dgeolocation_city_state` WHERE `id_shop` =1 LIMIT 1
2.6 990 /modules/seosageo/seosageo.php:238
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|3776|1|1" AND compile_id="" LIMIT 1
2.5 0 /classes/SmartyCustom.php:215
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
2.5 213 /classes/Hook.php:235
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|13|7f92639ba5ca672288c0cb4da61f81278aded63f|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
2.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE app.price_wt as min_price, app.`reduction_amount`, app.`reduction_type`, app.`reduction_tax`, app.id_currency, acp.id_product, app.id_country, (IF(app.`valid_id_specific_price`=1 AND app.`is_specific`=1, 1, 0) + app.`has_no_specific` +  IF ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`), 1, 0) +  IF (app.`id_group` = 1, 2, 0) +  IF (app.`id_country` = 0, 4, 0) +  IF (app.`id_currency` = 1, 8, 0) +  IF (app.`id_shop` = 1, 16, 0)) AS `score`
FROM `ps_pm_advancedsearch_product_price_1` app
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (app.`id_cache_product` = acp.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672))
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 0 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`) WHERE acp.`id_product` = 5123 AND  ((app.`from` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' >= app.`from`) AND (app.`to` = '0000-00-00 00:00:00' OR '2020-06-05 11:45:21' <= app.`to`)) AND  ((app.`valid_id_specific_price`=1 AND app.`is_specific`=1 AND app.`id_currency` IN (0, 1)) OR app.`has_no_specific`=1) AND ps.`active` = 1
AND ps.`visibility` IN ("both", "search") AND app.`id_country` IN (0, 0)  AND app.`id_group` IN (0, 1)  AND app.`id_shop` IN (0, 1)  ORDER BY score DESC, 
(
app.`price_wt` -
IF(
app.`reduction_type`='amount',
app.`reduction_amount` * IF(app.`reduction_tax`=1, 1, IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1))  / IF(t.`rate` > 0, ((t.`rate`/100) + 1), 1),
app.`reduction_amount`
)
)
* IF(grc.`reduction` > 0, 1 - grc.`reduction`, 1) ASC LIMIT 1
2.4 0 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:50
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4720
ORDER BY f.position ASC
2.4 10 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "gformbuilderpro" LIMIT 1
2.4 1 /classes/module/Module.php:2568
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/40/d98d2429ba7e48184a5df4c2451fcb47dbd12417/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|40|d98d2429ba7e48184a5df4c2451fcb47dbd12417|1|1|1|1|0" AND compile_id=""
2.4 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 51) LIMIT 1
2.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9b076b330c3b383e100e4c23e6c16d43',"blocktopmenu|1|1|1|1|0|category|36","", FROM_UNIXTIME(1591346718))
2.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(`id_post`) AS counter, DATE_FORMAT(date_add, "%m-%Y") AS time_stamp,
DATE_FORMAT(date_add, "%M %Y") AS time_view, DATE_FORMAT(date_add, "%Y%m") AS time_sort
FROM ps_fme_blog_posts
WHERE active = 1
GROUP BY MONTH(date_add), YEAR(date_add)
ORDER BY time_sort DESC
2.3 37 Yes /modules/advanceblog/models/BlogPosts.php:997
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|34|85c8ac63f90fce3483234f8834e2f8a1b9d40c1d|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
2.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|32|9fecf8e0bbb0047179e4fd9e9075d368e43c7b83|1|1|1|1|0","", FROM_UNIXTIME(1591346721))
2.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`='dfd47bacacbb45d7173526c60076e7e3' AND cache_id="blocksocial|1|1|1|1|0" AND compile_id="" LIMIT 1
2.1 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/37/138f32c902c22dd0b3548061d5eb0b85f4718a8e/1/1/1/1/0/53/be/57/53be570a7ec1df3908c3777720083e9fb950af56.cache.tpl.php'
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|37|138f32c902c22dd0b3548061d5eb0b85f4718a8e|1|1|1|1|0" AND compile_id=""
2.1 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|23|a8b9c5bf541cba6958be36902e899ca04c049f32|1|1|1|1|0","", FROM_UNIXTIME(1591346721))
2.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 39 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.1 56 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "fsopengraph" LIMIT 1
2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE a.*,b.label
FROM ps_gformbuilderprofields as a,
ps_gformbuilderprofields_lang as b,
ps_gformbuilderprofields_shop as c
WHERE a.id_gformbuilderprofields = b.id_gformbuilderprofields
AND a.id_gformbuilderprofields = c.id_gformbuilderprofields
AND c.id_shop = 1
AND b.id_lang = 1
AND a.id_gformbuilderprofields IN(94,95,96)
2 3 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:176
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|1584|1|1" AND compile_id="" LIMIT 1
2 0 /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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5912) AND (b.`id_shop` = 1) LIMIT 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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5916" AND compile_id="" LIMIT 1
2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 21 AND `id_shop` = 1
1.9 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) LIMIT 1
1.9 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|35|78585796571924ff97ffce41c19b81e64ebbd188|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
1.9 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|30|6c22781a6fbdd5043c0e4e53323959a0a3cd3fc6|1|1|1|1|0","", FROM_UNIXTIME(1591346718))
1.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_gformbuilderpro` a
LEFT JOIN `ps_gformbuilderpro_lang` `b` ON a.`id_gformbuilderpro` = b.`id_gformbuilderpro` AND b.`id_lang` = 1
LEFT JOIN `ps_gformbuilderpro_shop` `c` ON a.`id_gformbuilderpro` = c.`id_gformbuilderpro` AND c.`id_shop` = 1
WHERE (a.`id_gformbuilderpro` = 24) LIMIT 1
1.9 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5917|1|1" AND compile_id="" LIMIT 1
1.8 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d22b953fa4736374feaaf4b2ee38dd9a' AND cache_id="blockcms|2|1|1|1|1|0" AND compile_id="" LIMIT 1
1.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product` + acpc4.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (671))
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc4 ON ( acp.`id_cache_product` = acpc4.`id_cache_product` AND acpc4.`id_criterion` IN (672)) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "search")
AND ac.`id_criterion_group` = 32
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
1.8 8 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5119|1|1" AND compile_id="" LIMIT 1
1.8 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4f296089919889fb5b29e0c5220afb8a' AND cache_id="blockcontactinfos|1|1|1|1|0" AND compile_id="" LIMIT 1
1.8 1 /classes/SmartyCustom.php:215
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 = 'evropol-rus.ru' OR su.domain_ssl = 'evropol-rus.ru')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
1.8 2 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) LIMIT 1
1.8 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3775
ORDER BY f.position ASC
1.8 13 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 13 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.8 1 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 12 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.7 2 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
1.7 1 /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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5910" AND compile_id="" LIMIT 1
1.7 1 /classes/SmartyCustom.php:215
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
1.7 44 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 51 AND `id_shop` = 1
1.7 1 /Adapter/Adapter_EntityMapper.php:68
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getPriceRangeForSearchBloc|18|43ac38a91d6d036fb6026122442bc94e5b633e49|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
1.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 38 AND `id_shop` = 1
1.6 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 14 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 6 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE *
FROM `ps_pm_advancedsearch` a
LEFT JOIN `ps_pm_advancedsearch_shop` `c` ON a.`id_search` = c.`id_search` AND c.`id_shop` = 1
WHERE (a.`id_search` = 1) LIMIT 1
1.6 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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|1583" AND compile_id="" LIMIT 1
1.6 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 10
AND c.nright >= 11
AND c.nleft >= 2
AND c.nright <= 111
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
1.6 28 Yes /classes/Tools.php:1308
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) LIMIT 1
1.6 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|4155|1|1" AND compile_id="" LIMIT 1
1.5 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
1.5 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.5 31 Yes /classes/Country.php:137
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4056
ORDER BY f.position ASC
1.5 11 Yes /classes/Product.php:4456
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|24|7e9def26d2e580631a220837350076e14076e136|1|1|1|1|0","", FROM_UNIXTIME(1591346721))
1.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 59 AND `id_shop` = 1
1.5 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
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` = 1583)
1.5 1 /classes/Product.php:3002
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|15|c8023eb0b648ef693f2a5cfe26eca918350df0a1|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
1.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5911
ORDER BY f.position ASC
1.4 12 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|1586|1|1" AND compile_id="" LIMIT 1
1.4 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 49) LIMIT 1
1.4 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1588
ORDER BY f.position ASC
1.4 7 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 15 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 3 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 18 AND `id_shop` = 1
1.4 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 54) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
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
1.4 1 /classes/Currency.php:470
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5915) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:380
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 =1 AND m.page = "category" LIMIT 1
1.4 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5107|1|1" AND compile_id="" LIMIT 1
1.4 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 65 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 7 Yes Yes /classes/Category.php:584
SELECT SQL_NO_CACHE *
FROM ps_freecall as f
INNER JOIN ps_freecall_lang as fl
ON f.id_freecall = fl.id_freecall
WHERE fl.id_lang = 1
AND fl.id_shop = 1
1.4 1 /modules/freecall/classes/FreeCallClass.php:190
SELECT SQL_NO_CACHE pc.*
FROM `ps_blockshopreviews` pc
WHERE pc.active = 1 AND pc.`is_deleted` = 0 AND  
id_lang = 1 AND id_shop = 1
ORDER BY pc.`date_add` DESC LIMIT 0 ,2
1.4 8 Yes /modules/blockshopreviews/classes/shopreviews.class.php:295
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|4156|1|1" AND compile_id="" LIMIT 1
1.4 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 61) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 39 AND `id_shop` = 1
1.3 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE acg.*, acgl.*
FROM `ps_pm_advancedsearch_criterion_group_1` acg
LEFT JOIN `ps_pm_advancedsearch_criterion_group_1_lang` acgl ON (acg.`id_criterion_group` = acgl.`id_criterion_group` AND acgl.`id_lang` = 1 )
WHERE acg.`id_search` = 1
ORDER BY `position`
1.3 27 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3776
ORDER BY f.position ASC
1.3 13 Yes /classes/Product.php:4456
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` = 3775)
1.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 65 AND `id_shop` = 1
1.3 1 /Adapter/Adapter_EntityMapper.php:68
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5912
ORDER BY f.position ASC
1.3 12 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 26) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 77 AND `id_shop` = 1
1.3 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5915" AND compile_id="" LIMIT 1
1.3 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5121
ORDER BY f.position ASC
1.3 10 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5917
ORDER BY f.position ASC
1.3 12 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3773
ORDER BY f.position ASC
1.3 12 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4050
ORDER BY f.position ASC
1.3 11 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*
FROM `ps_feature` f
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1)
ORDER BY f.`position` ASC
1.3 36 Yes /classes/Feature.php:85
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3771
ORDER BY f.position ASC
1.2 13 Yes /classes/Product.php:4456
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1583) 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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|1589" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
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
1.2 26 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 54 AND `id_shop` = 1
1.2 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE ac.`id_criterion`, ac.`id_criterion_group`, acg.`visible`,aclink.`id_criterion_linked`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
LEFT JOIN `ps_pm_advancedsearch_criterion_group_1` acg ON (acg.`id_criterion_group` = ac.`id_criterion_group`)
WHERE acg.`criterion_group_type` = "category"
AND aclink.`id_criterion_linked`  = 36
1.2 5 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|4050|1|1" AND compile_id="" LIMIT 1
1.2 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE s.`seo_key`, s.`id_seo`, sl.`seo_url`
FROM `ps_pm_advancedsearch_seo` s
JOIN `ps_pm_advancedsearch_seo_lang` sl ON (s.`id_seo`=sl.`id_seo` AND sl.`id_lang`=1)
WHERE s.`seo_key` IN ("bbbcea29a2d5b5e1c344a72295eea522","b9fa00e930e70ce39186a384dc51567b","9eee38bf0dfde568ecbd2fd58a407904","d6d54ae20e48fce45ae6d72164ccca8f","f2da9d3631bc198408425937670673da","788eb16404a3f11e81ae68011ab2b45c","94f078ac55f3fe42d32b27902c05ea22")
AND s.`deleted`=0
1.2 7 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|4720|1|1" AND compile_id="" LIMIT 1
1.2 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(1)
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = "db_presta"
AND TABLE_NAME = "ps_tab"
AND COLUMN_NAME = "hide_host_mode" LIMIT 1
1.2 0 /modules/seoexpert/seoexpert.php:372
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5911" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 38) LIMIT 1
1.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1589
ORDER BY f.position ASC
1.1 7 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4048
ORDER BY f.position ASC
1.1 11 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1586
ORDER BY f.position ASC
1.1 7 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facetedsearch" LIMIT 1
1.1 1 /classes/module/Module.php:2568
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5916
ORDER BY f.position ASC
1.1 12 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1579
ORDER BY f.position ASC
1.1 8 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5107
ORDER BY f.position ASC
1.1 11 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 63) LIMIT 1
1.1 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1583
ORDER BY f.position ASC
1.1 7 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2132324ad7612ed7cb91de8444f03dae' AND cache_id="blocksearch-top|1|1|1|1|0" AND compile_id="" LIMIT 1
1.1 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3774
ORDER BY f.position ASC
1.1 13 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4157
ORDER BY f.position ASC
1.1 6 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1587
ORDER BY f.position ASC
1.1 7 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5118
ORDER BY f.position ASC
1.1 10 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|1587" AND compile_id="" LIMIT 1
1.1 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5119
ORDER BY f.position ASC
1.1 10 Yes /classes/Product.php:4456
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1585
ORDER BY f.position ASC
1.1 7 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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.1 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
1.1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1.1 1 Yes /classes/Country.php:130
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5122
ORDER BY f.position ASC
1.1 10 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 39) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 52) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 23 AND `id_shop` = 1
1.1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|3771" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4056) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
1.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1
1.1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1
1.1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description`
FROM `ps_category_lang` cl
WHERE cl.`id_lang` = 1
AND cl.`id_category` = 36 AND cl.id_shop = 1 LIMIT 1
1 1 /classes/Meta.php:291
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 3776
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 77) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1584
ORDER BY f.position ASC
1 7 Yes /classes/Product.php:4456
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5911) AND (b.`id_shop` = 1) LIMIT 1
1 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5120
ORDER BY f.position ASC
1 10 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE `name`, `value`, `block` FROM `ps_magiczoomplus_settings` WHERE `enabled`=1
1 595 /modules/magiczoomplus/magiczoomplus.php:536
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|10|14d9fc1dd2335a55d2e7f94fb0425d474a7dc30e|1|1|1|1|0","", FROM_UNIXTIME(1591346719))
1 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4150
ORDER BY f.position ASC
1 6 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|3771|1|1" AND compile_id="" LIMIT 1
1 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5123|1|1" AND compile_id="" LIMIT 1
1 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|4150" AND compile_id="" LIMIT 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|3774|1|1" AND compile_id="" LIMIT 1
1 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 59) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='35cd305a7376d26fe34a5dbc3549c31d' AND cache_id="blockcontact|1|1|1|1|0" AND compile_id="" LIMIT 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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5122" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 63 AND `id_shop` = 1
1 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1
1 1 /Adapter/Adapter_EntityMapper.php:68
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5121) AND (b.`id_shop` = 1) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "fbtwgpack" LIMIT 1
1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 23) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5915|1|1" AND compile_id="" LIMIT 1
0.9 0 /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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4155) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
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.9 44 /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.9 44 /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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4155
ORDER BY f.position ASC
0.9 6 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|3773" AND compile_id="" LIMIT 1
0.9 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1588) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
0.9 1 /Adapter/Adapter_EntityMapper.php:68
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4156
ORDER BY f.position ASC
0.9 6 Yes /classes/Product.php:4456
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4157) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_module_currency`
WHERE `id_module` = 137
AND `id_shop` = 1
0.9 1 /classes/Currency.php:295
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 50 AND `id_shop` = 1
0.9 1 /Adapter/Adapter_EntityMapper.php:68
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.9 46 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='bfe7a83fb1ce61839575db203c6a12a1' AND cache_id="blockcategories|1|1|1|1|0|36|1" AND compile_id="" LIMIT 1
0.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 37 AND `id_shop` = 1
0.9 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5917" 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3772
ORDER BY f.position ASC
0.9 13 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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.9 1 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`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|36|d09dcb6cc77e96a8793e751299e49e7967fd330d|1|1|1|1|0" AND compile_id="" LIMIT 1
0.9 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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.9 1 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4048) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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.9 1 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1589) AND (b.`id_shop` = 1) LIMIT 1
0.9 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1587) AND (b.`id_shop` = 1) LIMIT 1
0.9 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4720) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 36 LIMIT 1
0.9 1 /classes/Category.php:1477
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|4056" AND compile_id="" LIMIT 1
0.9 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`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|4149" AND compile_id="" LIMIT 1
0.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE s.*
FROM `ps_scene_category` sc
LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene)
INNER JOIN ps_scene_shop scene_shop
ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1)
LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene)
WHERE sc.id_category = 36
AND sl.id_lang = 1 AND s.active = 1
ORDER BY sl.name ASC
0.9 1 Yes /classes/Scene.php:226
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4149) AND (b.`id_shop` = 1) LIMIT 1
0.9 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3775) AND (b.`id_shop` = 1) LIMIT 1
0.9 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1586) AND (b.`id_shop` = 1) LIMIT 1
0.9 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5915) AND (b.`id_shop` = 1) LIMIT 1
0.9 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5916) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) LIMIT 1
0.8 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`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|32|9fecf8e0bbb0047179e4fd9e9075d368e43c7b83|1|1|1|1|0" AND compile_id="" LIMIT 1
0.8 0 /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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4150) AND (b.`id_shop` = 1) LIMIT 1
0.8 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5122) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pc.*
FROM `ps_blockshopreviews` pc
WHERE pc.active = 1 AND pc.`is_deleted` = 0 AND  
id_lang = 1 AND id_shop = 1
ORDER BY pc.`date_add` DESC LIMIT 0 ,2
0.8 8 Yes /modules/blockshopreviews/classes/shopreviews.class.php:295
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.8 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|5121" AND compile_id="" LIMIT 1
0.8 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3776) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE b.*, bl.`id_lang`, bl.`banner_link`, bl.`banner_img`, bl.`banner_description`
FROM `ps_fme_blog_posts_banners` b
LEFT JOIN `ps_fme_blog_posts_banners_lang` bl ON(b.id_banner = bl.id_banner)
WHERE  b.`active` = 1
AND b.location = "blog_left"
AND bl.id_lang = 1
AND bl.id_shop = 1 AND bl.id_shop_group = 1
ORDER BY b.position ASC, b.id_banner ASC
0.8 1 Yes /modules/advanceblog/models/BlogBanners.php:163
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 36) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.8 234 Yes /modules/themeconfigurator/themeconfigurator.php:375
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
0.8 1 /Adapter/Adapter_EntityMapper.php:68
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5917) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.8 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5910) AND (b.`id_shop` = 1) LIMIT 1
0.8 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1585) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
0.8 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
0.8 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 55 AND `id_shop` = 1
0.8 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 58) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 50) LIMIT 1
0.7 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4056) AND (b.`id_shop` = 1) LIMIT 1
0.7 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`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|29|482a2db32f11a24a02a404e8ca8a135cfb4210f8|1|1|1|1|0" AND compile_id="" LIMIT 1
0.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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5107) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5119) AND (b.`id_shop` = 1) LIMIT 1
0.7 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|1585|1|1" AND compile_id="" LIMIT 1
0.7 0 /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 = 3776 LIMIT 1
0.7 1 /classes/Product.php:752
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1579) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 65) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1584) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3771) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4156) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
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 = 3774 LIMIT 1
0.7 1 /classes/Product.php:752
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 56 AND `id_shop` = 1
0.7 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_pm_advancedsearch_lang`
WHERE `id_search` = 1
0.7 1 /Adapter/Adapter_EntityMapper.php:68
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.7 44 /classes/module/Module.php:277
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5120) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5118) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.7 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|13|7f92639ba5ca672288c0cb4da61f81278aded63f|1|1|1|1|0" AND compile_id="" LIMIT 1
0.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|5|d0c63005821b79fa5630ca99fdc774de3962bf5c|1|1|1|1|0","", FROM_UNIXTIME(1591346718))
0.7 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|4157|1|1" AND compile_id="" LIMIT 1
0.7 0 /classes/SmartyCustom.php:215
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.7 44 /classes/module/Module.php:277
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 14 LIMIT 1
0.7 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 58 AND `id_shop` = 1
0.7 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
0.7 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
0.7 26 /classes/Category.php:1672
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e9e48d1abbe4b93b2f9d33c43c3af719' AND cache_id="productcomments|1|1|1|1|0|1579" AND compile_id="" LIMIT 1
0.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE pc.*
FROM `ps_blockshopreviews` pc
WHERE pc.active = 1 AND pc.`is_deleted` = 0 AND  
id_lang = 1 AND id_shop = 1
ORDER BY pc.`date_add` DESC LIMIT 0 ,2
0.7 8 Yes /modules/blockshopreviews/classes/shopreviews.class.php:295
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|10|14d9fc1dd2335a55d2e7f94fb0425d474a7dc30e|1|1|1|1|0" 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` = 3774)
0.7 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|a2501d7ac47847678d3051e395027b9060927ad5|1|1|1|1|0","", FROM_UNIXTIME(1591346719))
0.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('dcb08f121b8743cbe38005dcc9fe981e',"pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|12|52489e108891e70f701caaac0895f911b548055f|1|1|1|1|0","", FROM_UNIXTIME(1591346720))
0.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 62 AND `id_shop` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE aclist.`id_criterion_parent`, aclist.`id_criterion`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`is_custom`=1
0.6 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|1588|1|1" AND compile_id="" LIMIT 1
0.6 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.6 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5917) 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` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3773) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5118|1|1" AND compile_id="" LIMIT 1
0.6 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4720) 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_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 36) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search`
FROM `ps_pm_advancedsearch` ads
JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1)  WHERE 1  AND ads.`active`=1  ORDER BY ads.`position`
0.6 26 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3772) 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` = 1586)
0.6 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
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.6 1 /classes/shop/Shop.php:202
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|5916|1|1" AND compile_id="" LIMIT 1
0.6 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
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` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 247) LIMIT 1
0.6 0 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.6 196 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) WHERE c.`id_category` = 36 AND cs.`id_shop` = 1 AND c.`id_parent` != 0 LIMIT 1
0.6 1 /classes/Category.php:1219
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 20 AND `id_shop` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.6 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE s.`seo_key`, s.`id_seo`, sl.`seo_url`
FROM `ps_pm_advancedsearch_seo` s
JOIN `ps_pm_advancedsearch_seo_lang` sl ON (s.`id_seo`=sl.`id_seo` AND sl.`id_lang`=1)
WHERE s.`seo_key` IN ("763740db5109184888327fa8fee21584","0a635119204188a737863a9c66cd7968","561185c8939beb3dda2735de82fe7444","9b12460b2503ea4bad9436b230a447c8","5f73ad41fe3595b36427278b6593417c","b6536cad74c0639c2926d2c906bbdfa5")
AND s.`deleted`=0
0.6 6 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|30|6c22781a6fbdd5043c0e4e53323959a0a3cd3fc6|1|1|1|1|0" AND compile_id="" LIMIT 1
0.6 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
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` = 4155)
0.6 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 60 AND `id_shop` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 62) LIMIT 1
0.6 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3774) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
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.6 44 /classes/module/Module.php:277
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 75) LIMIT 1
0.6 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`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|40|d98d2429ba7e48184a5df4c2451fcb47dbd12417|1|1|1|1|0" AND compile_id="" LIMIT 1
0.6 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 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, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 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 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1583 AND `id_group` = 1 LIMIT 1
0.6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 71) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.`seo_key`, s.`id_seo`, sl.`seo_url`
FROM `ps_pm_advancedsearch_seo` s
JOIN `ps_pm_advancedsearch_seo_lang` sl ON (s.`id_seo`=sl.`id_seo` AND sl.`id_lang`=1)
WHERE s.`seo_key` IN ("afee6a2ed737d51f124531d9cebd2722")
AND s.`deleted`=0
0.6 0 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dcb08f121b8743cbe38005dcc9fe981e' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|21|8290463a11970947fa3d685238ff2e5a10678863|1|1|1|1|0" AND compile_id="" LIMIT 1
0.6 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5123) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.`seo_key`, s.`id_seo`, sl.`seo_url`
FROM `ps_pm_advancedsearch_seo` s
JOIN `ps_pm_advancedsearch_seo_lang` sl ON (s.`id_seo`=sl.`id_seo` AND sl.`id_lang`=1)
WHERE s.`seo_key` IN ("8d21aecd07ef4e5b64911a129dbf4ddc","7cb858d20bafce66fe830b6207ecff98","62225df4609a9e083c76f25ddd2cbb9f","ad4e79382cc4822831e8e03ab9e91532")
AND s.`deleted`=0
0.6 4 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
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` = 5910)
0.6 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 73) LIMIT 1
0.6 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`='614e4802f9dfd7bc3afb863d07cd8835' AND cache_id="productlist_colors|3772|1|1" AND compile_id="" LIMIT 1
0.6 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE max(date_upd) FROM ps_category LIMIT 1
0.6 56 /modules/responsivemenu/responsivemenu.php:2608
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgseoredirect" LIMIT 1
0.6 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1585) 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_category_lang`
WHERE `id_category` = 69 AND `id_shop` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68
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` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 247) LIMIT 1
0.5 0 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 60) LIMIT 1
0.5 1