Utilizziamo cookies per migliorare l'esperienza dell'utente. Se non viene indicato nulla, si presume l'accettazione.
Tula lámpara de techo gris claro Tula lámpara de techo gris claro Tula lámpara de techo gris claro Tula lámpara de techo gris claro
    Tula lámpara de techo gris claro
    Tula lámpara de techo gris claro
    Tula lámpara de techo gris claro
    Tula lámpara de techo gris claro

Tula lámpara de techo gris claro

89,00 €

Estas preciosas lámparas completan la colección de ratán Kenay Home.

Muchos modelos disponibles, no vas a saber con cual o cuales quedarte. De muchas medidas y colores. 

Quedarán perfectas en cualquier rincón de tu casa.

Recíbelo en: 10 giorni
PVP válido para territorio español y todas nuestras tiendas.
01Maggiori informazioni
02Consegna e montaggio
03Detalles
Tula lámpara de techo gris claro
89,00 €

Load time3447 ms - You'd better run your shop on a toaster
Querying time250 ms
Queries580
Memory peak usage57.0 Mb
Included files413 files - 6.39 Mb
thirty bees cache3.21 Mb
Global vars2.48 Mb
thirty bees version1.1.0
PrestaShop (emulated) version1.6.1.999
PHP version5.6.40 (Consider upgrading)
MySQL version10.3.22-MariaDB (OK)
Memory limit256M
Max execution time3600s
Smarty cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 113 ms 113 ms 13.66 Mb 13.83 Mb
__construct 0 ms 113 ms - Mb 13.83 Mb
init 68 ms 182 ms 11.65 Mb 25.55 Mb
checkAccess 0 ms 182 ms - Mb 25.55 Mb
setMedia 3 ms 185 ms 0.26 Mb 25.79 Mb
postProcess 0 ms 185 ms - Mb 25.79 Mb
initHeader 0 ms 185 ms 0.01 Mb 25.79 Mb
initContent 230 ms 415 ms 17.35 Mb 43.17 Mb
initFooter 211 ms 626 ms 0.81 Mb 44.95 Mb
display 2820 ms 3447 ms 12.57 Mb 56.99 Mb
Hook Time Memory Usage
hookdisplayMenuItems 2096 ms 9.75 Mb
hookdisplayFooter 202 ms 0.75 Mb
__construct 118 ms 21.00 Mb
hookdisplayProductList 18 ms - Mb
hooktop 11 ms 0.50 Mb
hookHeader 8 ms - Mb
hookdisplayHeader 5 ms - Mb
hookproductListActions 4 ms - Mb
hookdisplayNav 3 ms - Mb
hookdisplayAfterTitle 3 ms - Mb
hookdisplaySlimBanner 2 ms - Mb
hookactionProductOutOfStock 2 ms - Mb
hookdisplayTopMenu 2 ms - Mb
hookproductactions 2 ms 0.25 Mb
hookdisplayProductTags 2 ms - Mb
hookdisplayPopUpNewsletter 1 ms - Mb
hookdisplayExtraSearch 1 ms - Mb
hookdisplayTopColumn 1 ms - Mb
hookdisplayProductBanner 1 ms - Mb
hookdisplayAfterBodyOpeningTag 1 ms - Mb
hookmoduleRoutes 1 ms - Mb
hookdisplaySimpleNewsletterForm 1 ms 0.25 Mb
hookdisplayCategoryBanner 0 ms - Mb
hookdisplayBeforeBodyClosingTag 0 ms - Mb
hookactionModuleRegisterHookAfter - ms - Mb
hookdisplayProductButtons - ms - Mb
hookdisplayProductSimulator - ms - Mb
hookdisplayRightColumnProduct - ms - Mb
hookfooter - ms - Mb
hookactionFrontControllerSetMedia - ms - Mb
hookactionDispatcher - ms - Mb
31 hooks 2485 ms 32.50 Mb
Module Time Memory Usage
horizontalcategories 2101 ms 10.25 Mb
mailchimppro 195 ms 0.25 Mb
okisamproducttemplate 21 ms 0.50 Mb
amzpayments 20 ms 3.75 Mb
blockwishlistpro 12 ms 1.50 Mb
blockcart 10 ms 0.75 Mb
paypal 10 ms 1.75 Mb
footerlinks 9 ms 0.75 Mb
cdc_googletagmanager 8 ms 0.75 Mb
headerbanner 8 ms 0.75 Mb
doofinder 6 ms 0.50 Mb
blocklayered 5 ms 1.25 Mb
mailalerts 5 ms 0.25 Mb
lookbook 4 ms 0.50 Mb
blocksearch 4 ms 0.25 Mb
okisamnewsletter 4 ms 0.50 Mb
okisamslimbanner 4 ms - Mb
instantcredit 3 ms 0.50 Mb
okisamfinder 3 ms 0.25 Mb
cronjobs 3 ms 0.50 Mb
okisamtags 3 ms - Mb
blockviewed 3 ms - Mb
customjscodes 3 ms 0.25 Mb
themeconfigurator 3 ms 0.75 Mb
okisamhomeslider 3 ms 0.50 Mb
blockuserinfo 2 ms 0.25 Mb
cofidis 2 ms 0.25 Mb
okisamshops 2 ms 0.25 Mb
criteoonetag 2 ms 0.75 Mb
blockcms 2 ms 0.25 Mb
chrls_cookies_lopd 2 ms - Mb
generaldataprotectionregulation 2 ms 0.25 Mb
okisamhomesliderdos 2 ms 0.25 Mb
blocknewsletter 2 ms 0.50 Mb
infinitescroll 2 ms 0.25 Mb
okisamflashsales 1 ms - Mb
sliderfeatured 1 ms - Mb
footerbanner 1 ms 0.25 Mb
popuppromotions 1 ms 0.25 Mb
okisamcategoriesrecommended 1 ms 0.50 Mb
blockcategories 1 ms - Mb
okisampresales 1 ms - Mb
blockstore 1 ms - Mb
blocksupplier 1 ms 0.25 Mb
homefeatured 1 ms 0.25 Mb
blockbestsellers 1 ms 0.25 Mb
productpaymentlogos 1 ms - Mb
blocksocial 1 ms 0.25 Mb
blockspecials 1 ms - Mb
blockpaymentlogo 1 ms - Mb
blocktags 1 ms - Mb
blocknewproducts 1 ms - Mb
blockmanufacturer 1 ms - Mb
blockcontactinfos 1 ms 0.25 Mb
blockmyaccountfooter 0 ms - Mb
okisamshopthelook 0 ms - Mb
blockmyaccount 0 ms 0.25 Mb
okisamvideohome 0 ms - Mb
58 modules 2485 ms 32.50 Mb

Stopwatch SQL - 580 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`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`
7.9 1387 /classes/Configuration.php:425
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (8) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
6.8 832 /override/classes/Category.php:189
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 = 2 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` = 2) AND (mg.`id_shop` = 2 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
6.6 264 Yes Yes /classes/Hook.php:583
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
5.6 2597 /classes/SpecificPrice.php:373
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 878 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
4.8 72 Yes Yes /override/classes/Category.php:164
SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 2)
STRAIGHT_JOIN `ps_module` AS m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.8 421 /classes/Hook.php:209
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (9) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
3.4 577 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (76) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
3.1 331 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (65) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
3.1 542 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (858) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
2.8 1004 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 8 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.7 66 Yes Yes /override/classes/Category.php:164
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (52) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
2.5 372 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (890) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
2.3 238 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 76 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.3 112 Yes Yes /override/classes/Category.php:164
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 86 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.2 109 Yes Yes /override/classes/Category.php:164
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
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` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.1 103 Yes Yes /override/classes/Category.php:164
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 = 2 
ORDER BY LENGTH(ml.`url_rewrite`) DESC
2.1 119 Yes /classes/Dispatcher.php:596
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 32 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2 33 Yes Yes /override/classes/Category.php:164
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (32) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.6 389 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 9 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 45 Yes Yes /override/classes/Category.php:164
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 52 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 13 Yes Yes /override/classes/Category.php:164
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` AS name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.6 0 /classes/Hook.php:724
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
1.5 119 Yes /classes/Dispatcher.php:596
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE `id_product` IN (0, 9943)
AND `id_product_attribute` IN (0, 0)
AND `id_shop` IN (0, 2)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 8)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2020-03-30 10:28:53' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2020-03-30 10:28:53' <= `to`)
)
AND id_cart IN (0, 0)
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, `id_specific_price` ASC LIMIT 1
1.5 3 Yes /override/classes/SpecificPrice.php:45
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 = 2)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 6  AND cl.id_shop = 2 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 113
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.4 1 Yes Yes /override/classes/Category.php:100
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (119) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.3 295 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 553) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (894) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.2 152 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 766) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (891) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.1 56 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 858 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.1 139 Yes Yes /override/classes/Category.php:164
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (77) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.1 74 /override/classes/Category.php:189
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 2
1 116 /classes/module/Module.php:215
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (325) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1 76 /override/classes/Category.php:189
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 2
1 116 /classes/module/Module.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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 1112 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 103 Yes Yes /override/classes/Category.php:164
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 2
0.9 116 /classes/module/Module.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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 1002 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 103 Yes Yes /override/classes/Category.php:164
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2020-03-30 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
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=2)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 6 AND pl.id_shop = 2 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 6 AND cl.id_shop = 2 
)
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=2)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 6)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 9943 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.9 4 Yes /classes/Product.php:6201
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 2
0.9 116 /classes/module/Module.php:215
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (109) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.8 187 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (117) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.8 96 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.8 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (102) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.8 166 /override/classes/Category.php:189
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` = 6
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 9943) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (855) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.7 38 /override/classes/Category.php:189
SELECT SQL_NO_CACHE gs.*, s.*, gs.`name` AS `group_name`, s.`name` AS `shop_name`, s.`active`,
su.`domain`, su.`domain_ssl`, su.`physical_uri`, su.`virtual_uri`
FROM `ps_shop_group` gs
LEFT JOIN `ps_shop` `s` ON s.`id_shop_group` = gs.`id_shop_group`
LEFT JOIN `ps_shop_url` `su` ON s.`id_shop` = su.`id_shop` AND su.`main` = 1
WHERE (s.`deleted` = 0) AND (gs.`deleted` = 0)
ORDER BY gs.`name`, s.`name`
0.7 4 Yes /classes/shop/Shop.php:746
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='f501eff740a70a98590d8078f5a11947' AND cache_id="horizontalcategories2|1|2|1|1|8" AND compile_id="" LIMIT 1
0.7 1 /classes/SmartyCustom.php:308
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 13) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.7 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 2)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 8)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 9943) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-03-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-03-30 00:00:00' <= `to`))
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.7 3 Yes /classes/SpecificPrice.php:577
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (553) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.7 22 /override/classes/Category.php:189
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 13
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.7 1 /classes/tax/TaxRulesTaxManager.php:132
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 6
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 2
WHERE (a.`id_cms` = 13) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `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 = 2)
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  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 2)
WHERE pa.`id_product` = 9943
AND al.`id_lang` = 6
AND agl.`id_lang` = 6
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 1 Yes Yes /classes/Product.php:6151
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 = 2 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2)
WHERE c.nleft <= 679
AND c.nright >= 680
AND c.nleft >= 4
AND c.nright <= 821
AND cl.id_lang = 6
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.7 42 Yes /classes/Tools.php:1882
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 2 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2)
WHERE `id_lang` = 6
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.6 31 Yes Yes /classes/Category.php:546
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` = 2
WHERE (a.`id_category` = 855) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
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 = 'kenayhome.com' OR su.domain_ssl = 'kenayhome.com') AND (s.`active` = 1) AND (s.`deleted` = 0)
ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC
0.6 4 Yes /classes/shop/Shop.php:347
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 9943) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.6 1 /classes/shop/Shop.php:1274
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 6
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 2
WHERE (a.`id_cms` = 8) AND (b.`id_shop` = 2) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_hook_module_exceptions`
WHERE (`id_shop` IN (2))
0.6 358 /classes/module/Module.php:2985
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 55) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.6 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (881) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.6 78 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (104) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.6 125 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (559) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.6 122 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 860) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.6 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 855) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.6 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 856) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.6 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9943) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 13) AND (`id_shop` = 2)
0.6 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 553) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.6 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 879 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.6 15 Yes Yes /override/classes/Category.php:164
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9943) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 325) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.6 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE `id_product` IN (0, 9941)
AND `id_product_attribute` IN (0, 0)
AND `id_shop` IN (0, 2)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 8)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2020-03-30 10:28:53' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2020-03-30 10:28:53' <= `to`)
)
AND id_cart IN (0, 0)
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, `id_specific_price` ASC LIMIT 1
0.6 3 Yes /override/classes/SpecificPrice.php:45
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (116) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.6 93 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (893) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 45 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 13) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (892) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 39 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 866) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (879) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 110 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (558) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 101 /override/classes/Category.php:189
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `ps_product_lang` `pl` ON pl.`id_product` = p.`id_product`  AND pl.id_shop = 2 
WHERE (pl.`id_lang` = 6) AND (pl.`id_product` = 9943) AND (product_shop.`active` = 1) LIMIT 1
0.5 1 /classes/Meta.php:313
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 2)
WHERE (`deleted` = 0) AND (c.`active` = 1)
ORDER BY `name` ASC
0.5 1 Yes /classes/Currency.php:350
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE `id_product` IN (0, 9945)
AND `id_product_attribute` IN (0, 0)
AND `id_shop` IN (0, 2)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 8)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2020-03-30 10:28:53' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2020-03-30 10:28:53' <= `to`)
)
AND id_cart IN (0, 0)
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, `id_specific_price` ASC LIMIT 1
0.5 3 Yes /override/classes/SpecificPrice.php:45
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` = 2
WHERE (a.`id_category` = 55) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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` = 2
WHERE (a.`id_category` = 856) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 55) AND (`id_shop` = 2)
0.5 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (895) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 35 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (55) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 50 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (57) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 59 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (874) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 1 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*
FROM `ps_module_currency` mc
LEFT JOIN `ps_currency` `c` ON c.`id_currency` = mc.`id_currency`
WHERE (c.`deleted` = 0) AND (mc.`id_module` = 154) AND (c.`active` = 1) AND (mc.`id_shop` = 2)
ORDER BY c.`name` ASC
0.5 1 Yes /classes/Currency.php:205
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 6)
WHERE i.`id_product` = 9943
ORDER BY `position`
0.5 4 Yes /classes/Product.php:5898
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 766) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 866) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 1 /classes/Category.php:2207
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 109) AND (b.`id_shop` = 2) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 553) AND (`id_shop` = 2)
0.5 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 818) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 1 /classes/Category.php:2207
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` = 6)
WHERE `level_depth` = 1
0.5 6 /classes/Category.php:430
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 9941) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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` = 6
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 2
WHERE (a.`id_country` = 8) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 34) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.5 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 9945) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (340) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 45 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (33) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 77 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (882) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 53 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 46) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 9943)
0.4 1 /classes/Product.php:845
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 10) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (898) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 9 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 325) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 11) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (866) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 17 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 117) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 9) AND (b.`id_shop` = 2) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (46) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 25 /override/classes/Category.php:189
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` `ls` ON l.`id_lang` = ls.`id_lang`
0.4 3 /classes/Language.php:167
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 2)
WHERE (`deleted` = 0)
ORDER BY `name` ASC
0.4 1 Yes /classes/Currency.php:350
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` = 2) AND (s.`active` = 1) AND (s.`deleted` = 0) AND (su.`main` = 1) LIMIT 1
0.4 1 /classes/shop/Shop.php:173
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (897) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 57 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 824) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 109) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (861) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 87 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (34) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 50 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (113) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 77 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 9) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 771) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 861) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 340) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 862) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (114) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 48 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 559) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE ott.`id_okisamtags_tag` as id_tag, ott.`position`, ott.`color`, ott.`text_color`, ott.`id_category`, ott.`active`, ott.`title`, ott.`description`,
ottl.`text`, ottl.`image`
FROM ps_okisamtags_tag ott
LEFT JOIN ps_okisamtags_tag_lang ottl ON (ott.id_okisamtags_tag = ottl.id_okisamtags_tag)
WHERE ottl.id_lang = 6 AND ott.`active` = 1
ORDER BY ott.position ASC
0.4 1 Yes /modules/okisamtags/okisamtags.php:438
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (11) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 67 /override/classes/Category.php:189
SELECT SQL_NO_CACHE ott.`id_okisamtags_tag` as id_tag, ott.`position`, ott.`color`, ott.`text_color`, ott.`id_category`, ott.`active`, ott.`title`, ott.`description`,
ottl.`text`, ottl.`image`
FROM ps_okisamtags_tag ott
LEFT JOIN ps_okisamtags_tag_lang ottl ON (ott.id_okisamtags_tag = ottl.id_okisamtags_tag)
WHERE ottl.id_lang = 6 AND ott.`active` = 1
ORDER BY ott.position ASC
0.4 1 Yes /modules/okisamtags/okisamtags.php:438
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 855) AND (`id_shop` = 2)
0.4 4 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (40) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 53 /override/classes/Category.php:189
SELECT SQL_NO_CACHE url_rewrite
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta=ml.id_meta
WHERE id_lang=6 AND page="module-lookbook-default" LIMIT 1
0.4 8 /modules/lookbook/lookbook.php:575
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 766) AND (`id_shop` = 2)
0.4 4 /Adapter/Adapter_EntityMapper.php:88
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 2) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 857) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
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 = 2)
WHERE pa.id_product = 9943 LIMIT 1
0.4 1 /classes/Product.php:1055
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (923) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 12 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE (`id_product` = 9943) AND (`id_shop` = 2)
0.4 4 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (10) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 69 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE `domain`, `domain_ssl`
FROM `ps_shop_url`
WHERE (`main` = 1) AND (`id_shop` = 2) LIMIT 1
0.4 1 /classes/shop/ShopUrl.php:247
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (112) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 71 /override/classes/Category.php:189
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 = 6)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 6)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 6)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 9941
ORDER BY f.position ASC
0.4 5 Yes /classes/Product.php:1982
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 111) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 77) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 325) AND (`id_shop` = 2)
0.4 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 856) AND (`id_shop` = 2)
0.4 4 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (745) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 67 /override/classes/Category.php:189
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
WHERE p.id_product = 9941
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-03-30 00:00:00",
INTERVAL 20 DAY
)
) > 0
0.4 0 /classes/Product.php:545
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 119) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 112) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 2) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 866) AND (`id_shop` = 2)
0.4 4 /Adapter/Adapter_EntityMapper.php:88
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.4 1 /classes/shop/Shop.php:173
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`)
FROM `ps_lang` l
INNER JOIN `ps_lang_shop` ls ON ls.`id_lang` = l.`id_lang`
WHERE (ls.`id_shop` = 1) AND (l.`active` = 1) LIMIT 1
0.4 6 /classes/Language.php:383
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 863) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.4 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 113) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 6
AND cl.id_shop = 2 
AND cl.`id_category` = 113 LIMIT 1
0.3 1 /classes/Category.php:752
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 865) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (770) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 61 /override/classes/Category.php:189
SELECT SQL_NO_CACHE DISTINCT pl.name as name
FROM `ps_product_lang` pl
WHERE (pl.id_product = 9943) AND (pl.id_lang = 6 AND pl.id_shop = 2 ) LIMIT 1
0.3 1 /classes/Product.php:3695
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` = 2
WHERE (a.`id_category` = 76) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 340) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 988) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (911) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 9 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 870) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (766) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 24 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (13) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 52 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (922) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 24 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (901) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 28 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 34) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (53) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 17 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 558) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 864) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 867) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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` = 2
WHERE (a.`id_category` = 34) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 118) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`)
FROM `ps_lang` l
INNER JOIN `ps_lang_shop` ls ON ls.`id_lang` = l.`id_lang`
WHERE (ls.`id_shop` = 2) AND (l.`active` = 1) LIMIT 1
0.3 1 /classes/Language.php:383
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 113) AND (b.`id_shop` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `id_module`
FROM `ps_module`
WHERE (`name` = 'deluxecorners') LIMIT 1
0.3 1 /classes/module/Module.php:1726
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (930) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 1 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (862) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 57 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (687) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 45 /override/classes/Category.php:189
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 9945
AND image_shop.`cover` = 1 LIMIT 1
0.3 4 /classes/Product.php:7411
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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` = 2
WHERE (a.`id_category` = 46) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name
FROM `ps_manufacturer`
WHERE (`id_manufacturer` = 0) AND (`active` = 1) LIMIT 1
0.3 0 /classes/Manufacturer.php:257
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (907) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 1 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (918) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 3 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (910) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 5 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 860) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
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` = 2
WHERE (a.`id_category` = 860) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 9941
AND image_shop.`cover` = 1 LIMIT 1
0.3 4 /classes/Product.php:7411
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (926) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 11 /override/classes/Category.php:189
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
WHERE p.id_product = 9943
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-03-30 00:00:00",
INTERVAL 20 DAY
)
) > 0
0.3 0 /classes/Product.php:545
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (824) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 37 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 76) AND (`id_shop` = 2)
0.3 8 /Adapter/Adapter_EntityMapper.php:88
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` = 2
WHERE (a.`id_category` = 861) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (919) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 1 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 818) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 109) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (884) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 12 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (927) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 32 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (1131) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 15 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (908) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 22 /override/classes/Category.php:189
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` = 2) AND (m.`page` = 'product') LIMIT 1
0.3 1 /classes/Theme.php:396
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` = 6
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 9941) AND (b.`id_shop` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 117) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 824) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 2
WHERE (a.`id_country` = 8) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 = 6)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 6)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 6)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 9943
ORDER BY f.position ASC
0.3 5 Yes /classes/Product.php:1982
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (946) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 1 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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` = 2
WHERE (a.`id_category` = 113) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 86 /classes/Hook.php:677
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` = 2
WHERE (a.`id_category` = 10) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (935) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 30 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 116) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (863) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 42 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (856) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 28 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (915) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 21 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 10) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 46) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 695) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (883) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 13 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 11) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 104) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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` = 2
WHERE (a.`id_category` = 77) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 861) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (768) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 42 /override/classes/Category.php:189
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 9943 AND ctg.`id_group` = 1 LIMIT 1
0.3 15 /classes/Product.php:6751
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 77) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 2
WHERE (a.`id_currency` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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` = 2
WHERE (a.`id_category` = 117) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 771) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (111) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 38 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 824) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 9943)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:467
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (118) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 13 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 340) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (906) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 1 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (936) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 26 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (771) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 31 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE (`id_product` = 9945) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
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` = 2
WHERE (a.`id_category` = 988) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 988) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 818) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_module_currency`
WHERE (`id_module` = 182) AND (`id_shop` = 2)
0.3 1 /classes/Currency.php:235
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (103) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 23 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 119) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (860) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 35 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 109) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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` = 2
WHERE (a.`id_category` = 11) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 102) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (857) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 26 /override/classes/Category.php:189
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` AS `attribute`, agl.`name` AS `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 6)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 6)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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 = 2)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 2)
WHERE pa.`id_product` = 9943
0.3 1 /classes/Product.php:3623
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (925) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 18 /override/classes/Category.php:189
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` = 6
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 9945) AND (b.`id_shop` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 113) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 67) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 992) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE COUNT(*)
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 = 2)
WHERE (pa.`id_product` = 9945) LIMIT 1
0.3 1 /classes/Product.php:5808
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (695) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 19 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (903) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 17 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 103) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 114) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE url_rewrite
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta=ml.id_meta
WHERE id_lang=6 AND page="module-lookbook-default" LIMIT 1
0.3 8 /modules/lookbook/lookbook.php:575
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 862) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE (`id_product` = 9941) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 111) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (896) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 22 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (864) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 18 /override/classes/Category.php:189
SELECT SQL_NO_CACHE hm.`id_module`
FROM `ps_hook_module` hm, `ps_hook` h
WHERE hm.`id_module` = 71 AND h.`id_hook` = 210
AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1
0.3 1 /classes/module/Module.php:2690
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 76) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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` = 2
WHERE (a.`id_category` = 857) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (994) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 11 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (692) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 31 /override/classes/Category.php:189
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` = 2
WHERE (a.`id_category` = 771) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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`
WHERE (cs.`id_shop` = 2) AND (c.`active` = 1) LIMIT 1
0.3 1 /classes/Currency.php:478
SELECT SQL_NO_CACHE COUNT(*)
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 = 2)
WHERE (pa.`id_product` = 9941) LIMIT 1
0.3 1 /classes/Product.php:5808
SELECT SQL_NO_CACHE ott.`id_okisamtags_tag` as id_tag, ott.`position`, ott.`color`, ott.`text_color`, ott.`id_category`, ott.`active`, ott.`title`, ott.`description`,
ottl.`text`, ottl.`image`
FROM ps_okisamtags_tag ott
LEFT JOIN ps_okisamtags_tag_lang ottl ON (ott.id_okisamtags_tag = ottl.id_okisamtags_tag)
WHERE ottl.id_lang = 6 AND ott.`active` = 1
ORDER BY ott.position ASC
0.3 1 Yes /modules/okisamtags/okisamtags.php:438
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` = 2
WHERE (a.`id_category` = 112) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 559) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 809) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_module_currency`
WHERE (`id_module` = 154) AND (`id_shop` = 2)
0.3 1 /classes/Currency.php:235
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` = 2
WHERE (a.`id_category` = 862) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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` = 2
WHERE (a.`id_category` = 111) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (107) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 17 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 770) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 857) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 745) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 768) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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` = 2
WHERE (a.`id_category` = 559) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='aeca42b047143629cfb36b59117cdd67' AND cache_id="horizontalcategories_hamb|1|2|1|1|8" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:308
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (921) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 8 /override/classes/Category.php:189
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `ps_tag` t
LEFT JOIN `ps_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 9943)
0.3 1 /classes/Tag.php:327
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 118) AND (`id_shop` = 2)
0.3 6 /Adapter/Adapter_EntityMapper.php:88
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 = 6)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 6)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 6)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 9945
ORDER BY f.position ASC
0.3 5 Yes /classes/Product.php:1982
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (909) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 12 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 992) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 865) AND (`id_shop` = 2)
0.3 4 /Adapter/Adapter_EntityMapper.php:88
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` = 2
WHERE (a.`id_category` = 119) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 32) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.3 1 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (867) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 14 /override/classes/Category.php:189
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 2
WHERE (a.`id_group` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE (LEFT(`language_code`, 2) = 'en')
ORDER BY `found` ASC LIMIT 1
0.2 3 Yes /classes/Language.php:248
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 112) AND (`id_shop` = 2)
0.2 6 /Adapter/Adapter_EntityMapper.php:88
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` = 2
WHERE (a.`id_category` = 863) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:80
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (942) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.2 10 /override/classes/Category.php:189
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (914) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.2 21 /override/classes/Category.php:189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.2 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE (`id_category` = 558) AND (`id_shop` = 2)
0.2 4 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.2 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.2 0 /classes/Category.php:2207
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
LEFT JOIN `ps_category_shop` `cs` ON c.`id_category` = cs.`id_category` AND cs.`id_shop` = 2
WHERE (`id_lang` = 6 AND cl.id_shop = 2 ) AND (c.`id_category` = 1) AND (cs.`id_shop` = 2) AND (c.`id_parent` != 0) LIMIT 1
0.2 0 /classes/Category.php:2207
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 = 2)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (941) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.2 6 /override/classes/Category.php:189