Informations

Autres peintures industrielles

Outre des peintures de retouche RALSOPPEC COLORS met à votre disposition un ensemble de peintures industrielles, indispensables pour les industries en tout genre.

 

Vous trouverez ainsi dans notre gamme de peintures industrielles :

  • des primaires d'accroche de qualité et à séchage rapide, idéals pour préparer vos supports en métal avant l'...

Outre des peintures de retouche RALSOPPEC COLORS met à votre disposition un ensemble de peintures industrielles, indispensables pour les industries en tout genre.

 

Vous trouverez ainsi dans notre gamme de peintures industrielles :

  • des primaires d'accroche de qualité et à séchage rapide, idéals pour préparer vos supports en métal avant l'application de la peinture
  • un convertisseur de rouille deux en un (stabilisateur + apprêt), indispensable pour restaurer les zones rouillées
  • des peintures de galvanisation : galva alu brillant, galva zinc alu séchage rapide, galva zinc mat 97%, galva zinc mat séchage rapide
  • des peintures thermorésistantes pour des surfaces exposées à de très hautes températures

  

Soyez en sûr, nos peintures industrielles sont de qualité, résistantes, et offres un couvrant et une durée sans précédent. 

 

La gamme SOPPEC COLORS propose également un ensemble de peintures spéciales adaptées à la préparation des supports.

 

Pour faciliter l'application de vos peintures de retouche, SOPPEC COLORS propose également des accessoires pour aérosol.

Détails

Autres peintures industrielles Il y a 8 produits.

Résultats 1 - 8 sur 8.
  • Peinture de galvanisation

    Galva zinc alu brillante à froid pour surfaces métalliques en fer et acier. Idéal pour des retouches ou réparer des parties endommagées du zinc altéré dans les pièces acier, carrosseries, clôtures, constructions métalliques de l’industrie lourde. Offre une protection brillante et résistante contre la corrosion et redonne aux surfaces traitées l’apparence...

    102,60 €
  • Peinture de galvanisation

    Peinture de galvanisation à froid à séchage rapide utilisable pour des petites réparations. Redonne l’apparence d’un métal brillant neuf.

    102,60 €
  • Peinture de galvanisation

    Peinture très chargée en Zinc pour prévenir la corrosion sur les surfaces métalliques acier nu et galvanisé. Formation d’une coucheauto-protectrice qui peut servir d’apprêt pour toutes les peintures. Traitement des tuyauteries, canalisations, pipe-line. Très bonne conductivité utilisable pour la soudure à point.

    102,60 €
  • Peinture de galvanisation

    Peinture de galvanisation à froid à séchage rapide utilisable pour offrir une de protection contre la corrosion de métaux acier et fer pour des travaux de maintenance rapide en construction ou production industrielle.

    102,60 €
  • Primaire universel à séchage rapide

    Primaire de haute qualité, universel, à séchage rapide à haut pouvoir couvrant, Il permet de préparer les supports (métal, bois, plastique et de nombreux autres supports) avant de les pulvériser à la peinture. Utilisable sur l’acier nu et les surfaces légèrement rouillées Également adapté au plastique et au bois, disponible en 500ml.

    102,60 €
  • Stabilisateur de rouille / couche d'apprêt

    Convertisseur de rouille «deux en un», faisant office de stabilisateur de rouille et de couche d’apprêt. Idéal pour restaurer les zones rouillées sur des machines / véhicules ou autres équipements métalliques: clôtures, chassis... Le produit pénètre la rouille et forme une pellicule protectrice de qualité. C'est un traitement à la fois efficace et facile...

    102,60 €
  • Peinture thermorésistante

    Peinture haute température ou thermorésistante utilisable sur des surfaces exposées à de très hautes températures telles que : conduites de vapeur, moteurs, canalisations d’échappement, radiateurs, etc. Les revêtements peuvent être en acier neuf, nu, grenaillé ou rouillé ou peints à condition d’être correctement préparés avant utilisation des peintures...

    114,00 €
  • Poignée Pistolet Universelle

    La Poignée pour Aérosol SOPPEC est un outil idéal pour appliquer facilement vos peintures de retouche. Elle apporte facilité et confort d’application à son utilisateur. Elle facilite l’application de la peinture et évite à l’utilisateur de se tâcher les mains ou les doigts. Aussi, elle permet d’amoindrir la fatigue des membres précédemment cités.

    3,75 €
Résultats 1 - 8 sur 8.
Load Time2705 ms - You'd better run your shop on a toaster
Querying Time873 ms
Queries582
Memory Peak Usage39.6 Mb
Included Files393 files - 7.23 Mb
PrestaShop Cache- Mb
Global vars2.15 Mb
PrestaShop Version1.6.1.19
PHP Version5.6.40 (OK)
MySQL Version5.7.29-log (OK)
Memory Limit512M
Max Execution Time300s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 176 ms 176 ms 9.45 Mb 9.53 Mb
__construct 0 ms 176 ms - Mb 9.53 Mb
init 53 ms 229 ms 3.34 Mb 12.85 Mb
checkAccess 0 ms 229 ms - Mb 12.85 Mb
setMedia 11 ms 240 ms 0.24 Mb 13.08 Mb
postProcess 0 ms 240 ms - Mb 13.08 Mb
initHeader 0 ms 240 ms - Mb 13.09 Mb
initContent 1732 ms 1972 ms 19.04 Mb 32.18 Mb
initFooter 356 ms 2328 ms 3.08 Mb 37.25 Mb
display 377 ms 2705 ms 3.52 Mb 39.62 Mb
Hook Time Memory Usage
__construct 444 ms 22.75 Mb
hookfooter 257 ms 2.00 Mb
hookproductlistassign 219 ms 2.25 Mb
hookdisplayTop 208 ms - Mb
hookleftcolumn 177 ms 1.00 Mb
hookHeader 142 ms - Mb
hookdisplayProductListReviews 112 ms 1.75 Mb
hooktop 48 ms - Mb
hookdisplayFooter 46 ms - Mb
hookdisplayNav 38 ms - Mb
hookdisplayLeftColumn 36 ms 0.25 Mb
hookdisplayBanner 34 ms - Mb
hookdisplayHeader 27 ms - Mb
hookdisplayAfterBody 3 ms - Mb
hookpluscomHeader 2 ms - Mb
hookmoduleRoutes 2 ms - Mb
hookdisplayGDPRConsent 1 ms - Mb
hookdisplayTopColumn - ms - Mb
hookDisplayOverrideTemplate - ms - Mb
19 hooks 1796 ms 30.00 Mb
Module Time Memory Usage
blocklayered 368 ms 3.50 Mb
blocktopmenu 209 ms 0.50 Mb
blockcategories 203 ms 0.50 Mb
lgcomments 133 ms 3.00 Mb
prestablog 80 ms 3.25 Mb
blockcms 67 ms 0.50 Mb
blockstore 57 ms - Mb
rcpganalytics 54 ms 0.50 Mb
blocksocial 47 ms - Mb
blockbanner 47 ms - Mb
blocksearch 38 ms - Mb
blocknewsletter 34 ms 2.50 Mb
blockcontactinfos 33 ms - Mb
paypal 29 ms 1.00 Mb
homeslider 27 ms 0.25 Mb
blockcontact 26 ms - Mb
k_cookies 24 ms - Mb
statsdata 21 ms 1.00 Mb
blockcart 19 ms 0.25 Mb
blockmyaccountfooter 19 ms 0.25 Mb
mercanet 19 ms 1.50 Mb
blockviewed 18 ms 0.25 Mb
contactform 17 ms 1.75 Mb
blockspecials 16 ms 0.50 Mb
lgcanonicalurls 15 ms 0.50 Mb
themeconfigurator 14 ms 0.25 Mb
pm_multiplefeatures 14 ms 0.25 Mb
lgtagmanager 13 ms 0.75 Mb
ordersexport 12 ms 1.25 Mb
blocknewproducts 12 ms - Mb
psgdpr 11 ms 2.00 Mb
lgseoredirect 11 ms 0.50 Mb
blocklanguages 9 ms - Mb
kbfreedelivery 7 ms 0.75 Mb
feeder 7 ms - Mb
dpdfrance 6 ms 0.50 Mb
sekeywords 6 ms 0.25 Mb
blockuserinfo 6 ms - Mb
medpriceqty 6 ms 0.25 Mb
pga 5 ms 0.50 Mb
pagesnotfound 5 ms - Mb
socialsharing 5 ms 0.50 Mb
homefeatured 5 ms - Mb
editorial 4 ms 0.25 Mb
blocktags 4 ms - Mb
blockmyaccount 3 ms - Mb
blockbestsellers 3 ms - Mb
blocksupplier 3 ms 0.25 Mb
blockcurrencies 3 ms - Mb
blockfacebook 3 ms 0.25 Mb
50 modules 1796 ms 30.00 Mb

Stopwatch SQL - 582 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_store s INNER JOIN ps_store_shop store_shop
ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LIMIT 1
19.8 2924 /modules/blockstore/blockstore.php:94
SELECT SQL_NO_CACHE DISTINCT(nl.`id_prestablog_news`), n.*, nl.*,
LEFT(nl.`title`, 80) as title,
(
SELECT count(cn.`id_prestablog_commentnews`)
FROM `ps_prestablog_commentnews` cn
WHERE cn.`news` = n.`id_prestablog_news`
AND cn.`actif` = 1
) as count_comments,
n.`id_prestablog_news` as `id`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 1
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) <= '2020/06/05 12:42:45'
ORDER BY n.`date` desc
LIMIT 0, 5
16.1 101520 Yes /modules/prestablog/class/news.class.php:535
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
10.5 1000 /classes/Configuration.php:148
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
9.4 2896 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND `level_depth` <= 4
AND cg.`id_group` IN (1)
ORDER BY `level_depth` ASC, category_shop.`position` ASC
9 38 Yes /modules/blockcategories/blockcategories.php:304
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 12 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
6.6 38 Yes Yes /classes/Category.php:585
SELECT SQL_NO_CACHE p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-06-05 00:00:00", INTERVAL 0 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM ps_cat_filter_restriction cp
LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 1)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
ORDER BY cp.position asc , cp.id_product LIMIT 0,12
6.2 32 Yes /modules/blocklayered/blocklayered.php:2054
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
4.6 364 /classes/Hook.php:236
CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
SELECT cp.id_product, MIN(cp.position) position FROM ps_category_product cp
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE cp.`id_category` IN (28)  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT id_product FROM ps_category_product cp WHERE cp.`id_category` = 28)
GROUP BY cp.id_product ORDER BY position, id_product
4.6 1 /modules/blocklayered/blocklayered.php:1958
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
4.5 253 Yes /classes/Country.php:131
CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY
SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category = 28
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
4.3 1 /modules/blocklayered/blocklayered.php:2142
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 80
AND pac.id_product_attribute = 264
AND a.`id_attribute` NOT IN(111)
3.7 2 /classes/Product.php:5573
UPDATE `ps_smarty_lazy_cache`
SET filepath='blocktopmenu/1/1/1/1/1/21/category/28/e8/5a/6f/e85a6ffe8b529291af20807de3766779f5ab85bc.blocktopmenu.tpl.php'
WHERE `template_hash`='935b0c878d4d54beb2aa91f49723ed12' AND cache_id="blocktopmenu|1|1|1|1|1|21|category|28" AND compile_id=""
3.6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 7
AND nleft >= 44 AND nright <= 53
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
3.6 38 Yes /modules/blockcategories/blockcategories.php:231
UPDATE `ps_smarty_lazy_cache`
SET filepath='blocksocial/1/1/1/1/1/21/73/cf/46/73cf46a9a222c8b700bfac26b47934bcf84dfe8c.blocksocial.tpl.php'
WHERE `template_hash`='62d457827e25666809506e9efcdf0da6' AND cache_id="blocksocial|1|1|1|1|1|21" AND compile_id=""
3.6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 1
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 1
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
WHERE lpa.id_attribute_group = 6 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
3.6 154 Yes /modules/blocklayered/blocklayered.php:2382
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcms/2/1/1/1/1/1/21/41/d3/b7/41d3b7e586b066d54d543ab283fdf0d9bce36535.blockcms.tpl.php'
WHERE `template_hash`='14e3bfccf492f8cf3beea5e88f03f5b4' AND cache_id="blockcms|2|1|1|1|1|1|21" AND compile_id=""
3.5 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcontact/1/1/1/1/1/21/e3/4c/f4/e34cf40121f82f8ee2dcb33af270342e207c926a.nav.tpl.php'
WHERE `template_hash`='e16851078a37a79b6391739a99a96feb' AND cache_id="blockcontact|1|1|1|1|1|21" AND compile_id=""
3.5 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcms/0/1/1/1/1/1/21/41/d3/b7/41d3b7e586b066d54d543ab283fdf0d9bce36535.blockcms.tpl.php'
WHERE `template_hash`='14e3bfccf492f8cf3beea5e88f03f5b4' AND cache_id="blockcms|0|1|1|1|1|1|21" AND compile_id=""
3.5 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/1/1/1/1/21/28/1/55/f2/45/55f245f1556b8b756ea12cb1b588740ffc73187f.blockcategories_footer.tpl.php'
WHERE `template_hash`='edd03d3149d8e884bc9603ec33536464' AND cache_id="blockcategories|1|1|1|1|1|21|28|1" AND compile_id=""
3.4 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockmyaccountfooter/1/1/1/1/1/21/f5/e5/db/f5e5dbea52957d25c824b96d3aae4d5e590244e6.blockmyaccountfooter.tpl.php'
WHERE `template_hash`='382b318ec0a84a7ae5d224b8ad3a1306' AND cache_id="blockmyaccountfooter|1|1|1|1|1|21" AND compile_id=""
3.4 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='prestablog/1/1/1/1/1/21/9c/3f/16/9c3f1633af848eecff2ab32c1d825033a0912ffd.grid-for-1-6_nav-top.tpl.php'
WHERE `template_hash`='af6c569406478407664fca22e2660ed2' AND cache_id="prestablog|1|1|1|1|1|21" AND compile_id=""
3.3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 28
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
3.3 9 Yes Yes /modules/blocklayered/blocklayered.php:2128
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/1/1/1/1/21/26/28/1/78/34/34/783434a2b84a754d010ccf36c81f5c887b5ca69a.blockcategories.tpl.php'
WHERE `template_hash`='d88e0a3e97847328f54a5a25e258a2fa' AND cache_id="blockcategories|1|1|1|1|1|21|26|28|1" AND compile_id=""
3.3 1 /classes/SmartyCustom.php:183
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 = 'soppec.pluscom.fr' OR su.domain_ssl = 'soppec.pluscom.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
3.3 1 Yes /classes/shop/Shop.php:334
UPDATE `ps_smarty_lazy_cache`
SET filepath='blocksearch_top/1/1/1/1/1/21/4c/f8/73/4cf873adb57b29f565854726236c523e21e4824b.blocksearch-top.tpl.php'
WHERE `template_hash`='1f38e48ad1ff9883c592df453c194c54' AND cache_id="blocksearch-top|1|1|1|1|1|21" AND compile_id=""
3.2 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockstore/1/1/1/1/1/21/04/24/d9/0424d9e86d5e8738590695490940cb9d69339902.blockstore.tpl.php'
WHERE `template_hash`='99f1463fc2299dea575907571c1861cb' AND cache_id="blockstore|1|1|1|1|1|21" AND compile_id=""
3.2 1 /classes/SmartyCustom.php:183
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
3.1 1 /classes/ObjectModel.php:487
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcontactinfos/1/1/1/1/1/21/43/91/ab/4391ab93da815fcdfc78f00a02953c0d12d8fac3.blockcontactinfos.tpl.php'
WHERE `template_hash`='1e435d7f7224c1cf0014cbe1b9cf03bf' AND cache_id="blockcontactinfos|1|1|1|1|1|21" AND compile_id=""
3.1 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 78
AND pac.id_product_attribute = 549
AND a.`id_attribute` NOT IN(111, 120)
3.1 3 /classes/Product.php:5573
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|76|1|1","", FROM_UNIXTIME(1591353765))
3.1 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockbanner/1/1/1/1/1/21/44/fc/6f/44fc6ff0e058e9b2c03991fb0eafdad13fe03c61.blockbanner.tpl.php'
WHERE `template_hash`='9de052fb2cca70d20596a33b17ba550f' AND cache_id="blockbanner|1|1|1|1|1|21" AND compile_id=""
3.1 1 /classes/SmartyCustom.php:183
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
3.1 1 Yes /classes/shop/Shop.php:663
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('14', '34', '583844181', '', '1', '1', '2020-06-05 12:42:46')
3.1 1 /classes/ObjectModel.php:487
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` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 13) AND (b.`id_shop` = 1) LIMIT 1
3.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('af6c569406478407664fca22e2660ed2',"prestablog|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
3 0 /classes/Hook.php:131
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 8
GROUP BY fv.id_feature_value
3 8 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 28  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 28
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2.9 1 Yes Yes /classes/Category.php:658
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 74
AND pac.id_product_attribute = 261
AND a.`id_attribute` NOT IN(111)
2.9 2 /classes/Product.php:5573
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (76,77,78,79,74,75,80,138) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2.9 66 Yes Yes /classes/Product.php:3466
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d88e0a3e97847328f54a5a25e258a2fa',"blockcategories|1|1|1|1|1|21|26|28|1","", FROM_UNIXTIME(1591353765))
2.9 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e16851078a37a79b6391739a99a96feb',"blockcontact|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 77
AND pac.id_product_attribute = 548
AND a.`id_attribute` NOT IN(111, 120)
2.8 3 /classes/Product.php:5573
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('935b0c878d4d54beb2aa91f49723ed12',"blocktopmenu|1|1|1|1|1|21|category|28","", FROM_UNIXTIME(1591353764))
2.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|80|1|1","", FROM_UNIXTIME(1591353765))
2.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_product`, `id_product_attribute`
FROM `ps_specific_price`
WHERE	`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND
`from_quantity` = 1 AND
`reduction` > 0
AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
2.8 252 /classes/SpecificPrice.php:479
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 28
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2.8 1 Yes Yes /classes/Category.php:658
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|75|1|1","", FROM_UNIXTIME(1591353765))
2.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 76
ORDER BY f.position ASC
2.8 6 Yes /classes/Product.php:4454
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9de052fb2cca70d20596a33b17ba550f',"blockbanner|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 76
AND pac.`id_product_attribute` = 547
2.7 2 /classes/Product.php:5532
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"138|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 80
AND pac.id_product_attribute = 265
AND a.`id_attribute` NOT IN(111)
2.7 2 /classes/Product.php:5573
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 79
AND pac.id_product_attribute = 550
AND a.`id_attribute` NOT IN(111, 120)
2.7 3 /classes/Product.php:5573
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
2.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
2.7 92 /classes/module/Module.php:277
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|138|1|1","", FROM_UNIXTIME(1591353765))
2.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 74
AND pac.id_product_attribute = 263
AND a.`id_attribute` NOT IN(111)
2.6 2 /classes/Product.php:5573
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 80
AND pac.`id_product_attribute` = 265
2.6 2 /classes/Product.php:5532
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 79
AND pac.`id_product_attribute` = 550
2.6 2 /classes/Product.php:5532
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 76
AND pac.id_product_attribute = 547
AND a.`id_attribute` NOT IN(111, 120)
2.6 3 /classes/Product.php:5573
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
2.6 72 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 77
AND pac.`id_product_attribute` = 548
2.6 2 /classes/Product.php:5532
SELECT SQL_NO_CACHE bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name
FROM `ps_cms_block` bc
LEFT JOIN `ps_cms_block_shop` bcs
ON (bcs.id_cms_block = bc.id_cms_block)
INNER JOIN `ps_cms_category_lang` ccl
ON (bc.`id_cms_category` = ccl.`id_cms_category`)
INNER JOIN `ps_cms_block_lang` bcl
ON (bc.`id_cms_block` = bcl.`id_cms_block`)
WHERE bc.`location` = 0
AND ccl.`id_lang` = 1
AND bcl.`id_lang` = 1
AND bcs.id_shop = 1 AND ccl.`id_shop` = 1
ORDER BY `position`
2.6 1 Yes /modules/blockcms/BlockCMSModel.php:360
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 78
AND pac.`id_product_attribute` = 549
2.5 2 /classes/Product.php:5532
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
WHERE pa.`id_product` = 74
AND pac.id_product_attribute = 262
AND a.`id_attribute` NOT IN(111)
2.5 2 /classes/Product.php:5573
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('14e3bfccf492f8cf3beea5e88f03f5b4',"blockcms|0|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
2.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|79|1|1","", FROM_UNIXTIME(1591353765))
2.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('1e435d7f7224c1cf0014cbe1b9cf03bf',"blockcontactinfos|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('1f38e48ad1ff9883c592df453c194c54',"blocksearch-top|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
2.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 28) AND (b.`id_shop` = 1) LIMIT 1
2.5 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e7b89dfa5bffe62c3e5457128c16cb83',"blocknewproducts|20200605|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
2.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"76|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 74
AND pac.`id_product_attribute` = 263
2.4 2 /classes/Product.php:5532
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` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('62d457827e25666809506e9efcdf0da6',"blocksocial|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
2.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 74
AND pac.`id_product_attribute` = 262
2.4 2 /classes/Product.php:5532
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('eda55eff9654326e44c750eefd96a2d8',"blockspecials|20200605|8|20200605|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
2.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"80|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"75|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_cms_category` a
LEFT JOIN `ps_cms_category_lang` `b` ON a.`id_cms_category` = b.`id_cms_category` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_category_shop` `c` ON a.`id_cms_category` = c.`id_cms_category` AND c.`id_shop` = 1
WHERE (a.`id_cms_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 74
AND pac.`id_product_attribute` = 261
2.3 2 /classes/Product.php:5532
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `name`
FROM `ps_attribute` a
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 = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 80
AND pac.`id_product_attribute` = 264
2.3 2 /classes/Product.php:5532
SELECT SQL_NO_CACHE s.*
FROM `ps_scene_category` sc
LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene)
INNER JOIN ps_scene_shop scene_shop
ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1)
LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene)
WHERE sc.id_category = 28
AND sl.id_lang = 1 AND s.active = 1
ORDER BY sl.name ASC
2.3 1 Yes /classes/Scene.php:226
SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
2.3 1 Yes Yes /classes/Supplier.php:127
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"77|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|74|1|1","", FROM_UNIXTIME(1591353765))
2.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|78|1|1","", FROM_UNIXTIME(1591353765))
2.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
2.2 367 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
2.2 92 /classes/module/Module.php:277
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('edd03d3149d8e884bc9603ec33536464',"blockcategories|1|1|1|1|1|21|28|1","", FROM_UNIXTIME(1591353765))
2.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
WHERE pa.id_product = 76 AND (aml.id_langs LIKE '%,1,%' OR aml.id_langs IS NULL);
2.2 2 /override/classes/Product.php:98
SELECT SQL_NO_CACHE cl.`id_cms`, cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_block_page` bcp
INNER JOIN `ps_cms_lang` cl
ON (bcp.`id_cms` = cl.`id_cms`)
INNER JOIN `ps_cms` c
ON (bcp.`id_cms` = c.`id_cms`)
INNER JOIN `ps_cms_shop` cs
ON (c.`id_cms` = cs.`id_cms`)
WHERE bcp.`id_cms_block` = 1
AND cs.`id_shop` = 1
AND cl.`id_lang` = 1 AND cl.`id_shop` = 1
AND bcp.`is_category` = 0
AND c.`active` = 1
ORDER BY `position`
2.2 3 Yes /modules/blockcms/BlockCMSModel.php:411
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|77|1|1","", FROM_UNIXTIME(1591353765))
2.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"79|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_feature FROM ps_layered_indexable_feature WHERE indexable = 0
2.1 2 /modules/blocklayered/blocklayered.php:741
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"78|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 261 LIMIT 1
2.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 76) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.1 3 Yes /classes/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"74|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
2.1 92 /classes/module/Module.php:277
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
2.1 103 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 77) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.1 3 Yes /classes/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('382b318ec0a84a7ae5d224b8ad3a1306',"blockmyaccountfooter|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
2.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "category" LIMIT 1
2.1 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 76) AND (b.`id_shop` = 1) LIMIT 1
2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
2 1 /classes/module/Module.php:2568
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` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 26) AND (b.`id_shop` = 1) LIMIT 1
2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 77) AND (b.`id_shop` = 1) LIMIT 1
2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 77
ORDER BY f.position ASC
2 6 Yes /classes/Product.php:4454
SELECT SQL_NO_CACHE c.`id_cms`, cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms` c
INNER JOIN `ps_cms_shop` cs
ON (c.`id_cms` = cs.`id_cms`)
INNER JOIN `ps_cms_lang` cl
ON (c.`id_cms` = cl.`id_cms`)
WHERE c.`id_cms_category` = 2
AND cs.`id_shop` = 1
AND cl.`id_lang` = 1 AND cl.`id_shop` = 1
AND c.`active` = 1
ORDER BY `position`
2 41 Yes /modules/blocktopmenu/blocktopmenu.php:820
SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
FROM ps_linksmenutop l
LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 1 AND ll.id_shop=1)
LEFT JOIN ps_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_linksmenutop = "3"
AND l.id_shop IN (0, 1)
2 1 /modules/blocktopmenu/menutoplinks.class.php:38
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 17
GROUP BY fv.id_feature_value
2 8 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM ps_cat_restriction p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1
1.9 8 /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 47
AND c.nright >= 48
AND c.nleft >= 2
AND c.nright <= 75
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
1.9 38 Yes /classes/Tools.php:1306
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1.9 1 /override/classes/Cart.php:228
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)
1.9 2 /classes/Language.php:777
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 75
ORDER BY f.position ASC
1.8 7 Yes /classes/Product.php:4454
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
1.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
1.8 3 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
1.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 80
ORDER BY f.position ASC
1.8 6 Yes /classes/Product.php:4454
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 76)
1.8 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 1
INNER JOIN ps_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 1
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
WHERE lpa.id_attribute_group = 8 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
1.7 139 Yes /modules/blocklayered/blocklayered.php:2382
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
1.7 1 /classes/shop/Shop.php:203
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
1.7 1 Yes /classes/tax/TaxRulesTaxManager.php:109
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` = 1
WHERE (a.`id_product` = 76) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:61
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` = 1
WHERE (a.`id_product` = 77) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 138) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.7 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
1.7 2 /classes/Language.php:894
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 78
ORDER BY f.position ASC
1.7 6 Yes /classes/Product.php:4454
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 138
ORDER BY f.position ASC
1.7 1 Yes /classes/Product.php:4454
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 78) AND (b.`id_shop` = 1) LIMIT 1
1.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 77)
1.7 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 52
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`
1.6 10575 Yes /modules/prestablog/class/correspondancescategories.class.php:60
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` = 1
WHERE (a.`id_country` = 8) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 80) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.6 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='935b0c878d4d54beb2aa91f49723ed12' AND cache_id="blocktopmenu|1|1|1|1|1|21|category|28" AND compile_id="" LIMIT 1
1.6 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE bcp.`id_cms_category`, bcp.`id_parent`, bcp.`level_depth`, bcp.`active`, bcp.`position`, cl.`name`, cl.`link_rewrite`
FROM `ps_cms_category` bcp INNER JOIN `ps_cms_category_shop` cs
ON (bcp.`id_cms_category` = cs.`id_cms_category`)
INNER JOIN `ps_cms_category_lang` cl
ON (bcp.`id_cms_category` = cl.`id_cms_category`)
WHERE cl.`id_lang` = 1
AND bcp.`id_parent` = 2 AND cs.`id_shop` = 1 AND cl.`id_shop` = 1
1.6 1 /modules/blocktopmenu/blocktopmenu.php:773
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
1.6 103 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE id_attribute_group FROM ps_layered_indexable_attribute_group WHERE indexable = 0
1.6 8 /modules/blocklayered/blocklayered.php:739
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "order"
OR m.page = "order"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
1.6 1 /classes/Meta.php:149
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 79
ORDER BY f.position ASC
1.6 6 Yes /classes/Product.php:4454
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 75) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.6 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE type+0 AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = 28   AND `type_object` = 2 LIMIT 1
1.6 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1549
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
1.6 3 /classes/Currency.php:472
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
WHERE pa.id_product = 77 AND (aml.id_langs LIKE '%,1,%' OR aml.id_langs IS NULL);
1.6 2 /override/classes/Product.php:98
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 76 AND active = 1 AND id_lang = 1 LIMIT 1
1.6 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:61
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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 28) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 78) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.6 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 74
ORDER BY f.position ASC
1.6 6 Yes /classes/Product.php:4454
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` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 27) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 74) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.5 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 2
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
1.5 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pga" LIMIT 1
1.5 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (29) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
1.5 2 Yes /classes/CMS.php:104
SELECT SQL_NO_CACHE l.`id_lang`, c.`link_rewrite`
FROM `ps_category_lang` AS c
LEFT JOIN  `ps_lang` AS l ON c.`id_lang` = l.`id_lang`
WHERE c.`id_category` = 28
AND l.`active` = 1
1.5 4 /classes/Category.php:1460
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 79) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-06-05 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.5 3 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2020-06-05 00:00:00' AND '2020-06-05 23:59:59' LIMIT 1
1.5 1 /classes/SpecificPrice.php:302
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 138) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 10
GROUP BY fv.id_feature_value
1.5 8 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 26) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_image_type`
1.5 9 /classes/ImageType.php:143
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.5 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 547 LIMIT 1
1.5 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('14e3bfccf492f8cf3beea5e88f03f5b4',"blockcms|2|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
1.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE c.`id_cookie`, c.`name`, c.`config`, c.`active`
FROM ps_k_cookies c
WHERE 1 = 1  AND c.`active` = 1
1.5 77 /modules/k_cookies/classes/CookieClass.php:56
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1.5 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 14
AND `date_add` > '2020-06-05 12:12:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
1.4 1 Yes /classes/Connection.php:138
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
WHERE pa.id_product = 80 AND (aml.id_langs LIKE '%,1,%' OR aml.id_langs IS NULL);
1.4 2 /override/classes/Product.php:98
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 45 AND `id_shop` = 1
1.4 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1.4 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
1.4 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcomments" LIMIT 1
1.4 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 27) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 46) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1
1.4 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 76 AND `id_shop` = 1
1.4 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 9
GROUP BY fv.id_feature_value
1.4 8 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
1.4 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
1.4 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 78)
1.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
1.4 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 138)
1.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'left' AND active = 1
ORDER BY item_order ASC
1.4 48 Yes /modules/themeconfigurator/themeconfigurator.php:376
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
1.4 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 75) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 9) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_lgseoredirect WHERE (CONCAT("", url_old) = "/fr/28-autres-peintures-industrielles" OR CONCAT("", url_old) LIKE "/fr/28-autres-peintures-industrielles#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1
1.4 1 /modules/lgseoredirect/lgseoredirect.php:858
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('99f1463fc2299dea575907571c1861cb',"blockstore|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
1.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 21 AND `id_shop` = 1
1.4 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (26) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
1.4 2 Yes /classes/CMS.php:104
SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
FROM ps_linksmenutop l
LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 1 AND ll.id_shop=1)
LEFT JOIN ps_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_linksmenutop = "2"
AND l.id_shop IN (0, 1)
1.4 1 /modules/blocktopmenu/menutoplinks.class.php:38
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` = 1
WHERE (a.`id_product` = 78) LIMIT 1
1.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
1.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
1.3 2 /classes/Country.php:174
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 79) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 12
GROUP BY fv.id_feature_value
1.3 8 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 51
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`
1.3 10575 Yes /modules/prestablog/class/correspondancescategories.class.php:60
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 18 AND `id_shop` = 1
1.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 78 AND active = 1 AND id_lang = 1 LIMIT 1
1.3 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 80) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (9) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
1.3 2 Yes /classes/CMS.php:104
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
1.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 74) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1.3 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 45) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 45) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.3 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`name` as `group`
FROM `ps_attribute_group_lang` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`name` IS NOT NULL
1.3 1 /classes/Product.php:5555
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 80)
1.3 2 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 47) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="76|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 48 AND `id_shop` = 1
1.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
WHERE pa.id_product = 78 AND (aml.id_langs LIKE '%,1,%' OR aml.id_langs IS NULL);
1.3 2 /override/classes/Product.php:98
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
1.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
FROM ps_linksmenutop l
LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 1 AND ll.id_shop=1)
LEFT JOIN ps_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_linksmenutop = "4"
AND l.id_shop IN (0, 1)
1.3 1 /modules/blocktopmenu/menutoplinks.class.php:38
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 6 AND `id_object` = 28 LIMIT 1
1.3 1 /classes/Page.php:77
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1.3 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 30) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT 1
1.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
1.3 48 Yes /modules/themeconfigurator/themeconfigurator.php:376
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|76|1|1" AND compile_id="" LIMIT 1
1.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
WHERE pa.id_product = 75 AND (aml.id_langs LIKE '%,1,%' OR aml.id_langs IS NULL);
1.3 2 /override/classes/Product.php:98
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
1.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 548 LIMIT 1
1.3 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
1.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 79)
1.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE canonical_url FROM `ps_lgcanonicalurls_lang` WHERE `id_object` = 28   AND `type_object` = 2   AND `id_lang` = 1;
1.3 0 /modules/lgcanonicalurls/lgcanonicalurls.php:1593
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 51) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 49 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 76
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.2 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_layered_category
WHERE id_category = 28
AND id_shop = 1 LIMIT 1
1.2 9 /modules/blocklayered/blocklayered.php:637
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (27) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
1.2 2 Yes /classes/CMS.php:104
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1.2 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 75)
1.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 44 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
WHERE pa.id_product = 79 AND (aml.id_langs LIKE '%,1,%' OR aml.id_langs IS NULL);
1.2 2 /override/classes/Product.php:98
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|75|1|1" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 29) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|77|1|1" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`name` as `group`
FROM `ps_attribute_group_lang` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`name` IS NOT NULL
1.2 1 /classes/Product.php:5555
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN ps_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 15
GROUP BY fv.id_feature_value
1.2 8 Yes /modules/blocklayered/blocklayered.php:2382
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description`
FROM `ps_category_lang` cl
WHERE cl.`id_lang` = 1
AND cl.`id_category` = 28 AND cl.id_shop = 1 LIMIT 1
1.2 1 /classes/Meta.php:291
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 50
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`
1.2 10575 Yes /modules/prestablog/class/correspondancescategories.class.php:60
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_storecomments WHERE active = 1 AND id_lang = 1 LIMIT 1
1.2 5 /modules/lgcomments/lgcomments.php:936
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 38) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 50 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 48) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 31 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`name` as `group`
FROM `ps_attribute_group_lang` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`name` IS NOT NULL
1.2 1 /classes/Product.php:5555
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 549 LIMIT 1
1.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 28 LIMIT 1
1.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE comment FROM ps_lgcomments_storecomments WHERE active = 1 AND stars > 6 AND id_lang = 1 ORDER BY RAND()
1.2 5 Yes /modules/lgcomments/lgcomments.php:982
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 20 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 36) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.2 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 36 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
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` = 1
WHERE (a.`id_product` = 74) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 23 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
1.2 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 77 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 43 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 74)
1.2 3 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="138|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="78|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 37 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|79|1|1" AND compile_id="" LIMIT 1
1.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 20 LIMIT 1
1.2 1 /modules/psgdpr/classes/GDPRConsent.php:112
ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product),
ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE,
ADD KEY `condition` (`condition`,`id_product`) USING BTREE,
ADD KEY `weight` (`weight`,`id_product`) USING BTREE
1.2 1 /modules/blocklayered/blocklayered.php:2148
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 76 AND `id_group` = 1 LIMIT 1
1.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
1.2 2 /Adapter/Adapter_EntityMapper.php:68
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` = 1
WHERE (a.`id_product` = 75) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 138 AND active = 1 AND id_lang = 1 LIMIT 1
1.2 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`name` as `group`
FROM `ps_attribute_group_lang` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`name` IS NOT NULL
1.2 1 /classes/Product.php:5555
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 546 LIMIT 1
1.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 0 LIMIT 1
1.1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 38 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
WHERE pa.id_product = 74 AND (aml.id_langs LIKE '%,1,%' OR aml.id_langs IS NULL);
1.1 2 /override/classes/Product.php:98
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1.1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 30 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE bcp.`id_cms`, cl.`name`, cl.`link_rewrite`
FROM `ps_cms_block_page` bcp
INNER JOIN `ps_cms_category_lang` cl
ON (bcp.`id_cms` = cl.`id_cms_category`)
WHERE bcp.`id_cms_block` = 1
AND cl.`id_lang` = 1
AND bcp.`is_category` = 1
1.1 6 /modules/blockcms/BlockCMSModel.php:424
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 44) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
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` = 1
WHERE (a.`id_product` = 79) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 36) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
1.1 1 /classes/Page.php:97
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.1 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.1 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1.1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 78 AND id_lang = 1 LIMIT 1
1.1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 50) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.1 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 74 AND id_lang = 1 LIMIT 1
1.1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 49
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`
1.1 10575 Yes /modules/prestablog/class/correspondancescategories.class.php:60
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
1.1 18 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 75 AND id_lang = 1 LIMIT 1
1.1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
1.1 1 /classes/ObjectModel.php:1376
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 74 AND active = 1 AND id_lang = 1 LIMIT 1
1.1 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 37) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
1.1 1 /classes/Image.php:472
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 46 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.1 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE * FROM `ps_pga` WHERE id_product = 0 AND id_shop=1
1.1 60 /modules/pga/pga.php:733
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 39) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.1 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 78 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
1.1 1 /modules/blocklayered/blocklayered.php:1960
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 75 AND active = 1 AND id_lang = 1 LIMIT 1
1.1 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 23) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 49) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 138 AND id_lang = 1 LIMIT 1
1.1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 51 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 42) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 47 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 46) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|78|1|1" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
1.1 1 /classes/Product.php:5546
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 79 AND active = 1 AND id_lang = 1 LIMIT 1
1.1 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 27) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
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` = 1
WHERE (a.`id_product` = 80) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='eda55eff9654326e44c750eefd96a2d8' AND cache_id="blockspecials|20200605|8|20200605|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 77 AND id_lang = 1 LIMIT 1
1.1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 31) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 42) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 28 LIMIT 1
1.1 1 /classes/Category.php:1477
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 29 AND `id_shop` = 1
1.1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 30) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
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` = 1
WHERE (a.`id_product` = 138) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"74|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
1.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|74|1|1" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 79 AND id_lang = 1 LIMIT 1
1.1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 76 AND id_lang = 1 LIMIT 1
1.1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 41) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 31) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 51) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 38) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="80|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 48
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`
1.1 10575 Yes /modules/prestablog/class/correspondancescategories.class.php:60
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) LIMIT 1
1.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 76) AND (id_product_attribute = 547) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 80 AND active = 1 AND id_lang = 1 LIMIT 1
1 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE type+0 AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = 28   AND `type_object` = 2 LIMIT 1
1 1 /modules/lgcanonicalurls/lgcanonicalurls.php:1549
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 0 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 29) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 41) AND (b.`id_shop` = 1) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) AND (b.`id_shop` = 1) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 42 AND `id_shop` = 1
1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 39 AND `id_shop` = 1
1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
1 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
1 1 /classes/Category.php:1477
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
1 4 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) AND (b.`id_shop` = 1) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 74 AND id_lang = 1 LIMIT 1
1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 50) AND (b.`id_shop` = 1) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='62d457827e25666809506e9efcdf0da6' AND cache_id="blocksocial|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8
1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 28 AND ctg.`id_group` = 1 LIMIT 1
1 1 /classes/Category.php:1309
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 80 AND id_lang = 1 LIMIT 1
1 1 /modules/lgcomments/lgcomments.php:902
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 80 AND `id_shop` = 1
1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 38
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
1 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckout" LIMIT 1
1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="74|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 77) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 77 AND active = 1 AND id_lang = 1 LIMIT 1
1 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='14e3bfccf492f8cf3beea5e88f03f5b4' AND cache_id="blockcms|0|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|138|1|1" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="77|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 77
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 43) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d88e0a3e97847328f54a5a25e258a2fa' AND cache_id="blockcategories|1|1|1|1|1|21|26|28|1" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 47) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_contactform` WHERE position=1
1 2 /modules/contactform/classes/class.tools.php:2823
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="75|1|1|1|1|1|21" AND compile_id="" LIMIT 1
1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'category_default' LIMIT 1
1 1 /classes/Image.php:472
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 74 AND `id_shop` = 1
1 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 28 LIMIT 1
1 0 /classes/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) AND (b.`id_shop` = 1) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 26) LIMIT 1
1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE public_name
FROM `ps_attribute_group_lang` agl
LEFT JOIN `ps_layered_indexable_attribute_group` liag
ON liag.id_attribute_group = agl.id_attribute_group
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
1 96 /modules/blocklayered/blocklayered.php:2721
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 74 AND active = 1 AND id_lang = 1 LIMIT 1
1 6 /modules/lgcomments/lgcomments.php:857
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
1 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr' LIMIT 1
1 1 /classes/Language.php:680
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 39) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.9 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pagesnotfound" LIMIT 1
0.9 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.9 1 /classes/ObjectModel.php:1459
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.9 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 48) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('935b0c878d4d54beb2aa91f49723ed12',"blocktopmenu|1|1|1|1|1|21|category|28","", FROM_UNIXTIME(1591353764))
0.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 76) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.9 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 550 LIMIT 1
0.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.9 1 /classes/ObjectModel.php:1459
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='70433347072c3750390efb5cc6a80e02' AND cache_id="79|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.9 1 /classes/Image.php:472
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.9 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 264 LIMIT 1
0.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 37) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9de052fb2cca70d20596a33b17ba550f',"blockbanner|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 74) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.9 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE name
FROM `ps_feature_lang` fl
LEFT JOIN  `ps_layered_indexable_feature` lif
ON lif.id_feature = fl.id_feature
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
0.9 24 /modules/blocklayered/blocklayered.php:2731
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 28
AND id_shop = 1 LIMIT 1
0.9 1 /classes/ObjectModel.php:1459
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='af6c569406478407664fca22e2660ed2' AND cache_id="prestablog|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.9 0 /classes/module/Module.php:2218
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"138|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 75 AND `id_shop` = 1
0.9 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 138 AND `id_shop` = 1
0.9 2 /Adapter/Adapter_EntityMapper.php:68
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|76|1|1","", FROM_UNIXTIME(1591353765))
0.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 28) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.9 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3dce0547ada74ab6309102c67ded04ce' AND cache_id="productlist_colors|80|1|1" AND compile_id="" LIMIT 1
0.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 44) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|77|1|1","", FROM_UNIXTIME(1591353765))
0.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 78
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.9 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
0.9 4 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 36
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.9 1 /modules/blockcms/BlockCMSModel.php:333
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('1f38e48ad1ff9883c592df453c194c54',"blocksearch-top|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
0.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 76 AND id_shop=1 LIMIT 1
0.9 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.9 1 /classes/Group.php:133
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"79|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d88e0a3e97847328f54a5a25e258a2fa',"blockcategories|1|1|1|1|1|21|26|28|1","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('14e3bfccf492f8cf3beea5e88f03f5b4',"blockcms|0|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='edd03d3149d8e884bc9603ec33536464' AND cache_id="blockcategories|1|1|1|1|1|21|28|1" AND compile_id="" LIMIT 1
0.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 138) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 9
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.8 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 79 AND `id_shop` = 1
0.8 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e16851078a37a79b6391739a99a96feb' AND cache_id="blockcontact|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='382b318ec0a84a7ae5d224b8ad3a1306' AND cache_id="blockmyaccountfooter|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e7b89dfa5bffe62c3e5457128c16cb83' AND cache_id="blocknewproducts|20200605|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.8 1 /classes/ObjectModel.php:1459
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e16851078a37a79b6391739a99a96feb',"blockcontact|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.8 0 /classes/Product.php:5546
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('1e435d7f7224c1cf0014cbe1b9cf03bf',"blockcontactinfos|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 77 AND `id_group` = 1 LIMIT 1
0.8 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9de052fb2cca70d20596a33b17ba550f' AND cache_id="blockbanner|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.8 0 /classes/Product.php:5546
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.8 0 /classes/Product.php:5546
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 78) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 79) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 3
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.8 1 /modules/blockcms/BlockCMSModel.php:333
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|74|1|1","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.8 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 75) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 75 AND `id_group` = 1 LIMIT 1
0.8 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 75
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.8 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.8 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 74 AND id_lang = 1 AND active = 1 LIMIT 1
0.8 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkout_klarna" LIMIT 1
0.8 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.8 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 79 AND `id_group` = 1 LIMIT 1
0.8 0 /classes/GroupReduction.php:149
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('edd03d3149d8e884bc9603ec33536464',"blockcategories|1|1|1|1|1|21|28|1","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('eda55eff9654326e44c750eefd96a2d8',"blockspecials|20200605|8|20200605|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 51 LIMIT 1
0.8 1 /classes/Category.php:1054
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('62d457827e25666809506e9efcdf0da6',"blocksocial|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|78|1|1","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"80|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarnauk" LIMIT 1
0.8 1 /classes/module/Module.php:2568
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|80|1|1","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2020-06-05 00:00:00' AND '2020-06-05 23:59:59' LIMIT 1
0.8 1 /classes/SpecificPrice.php:306
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('99f1463fc2299dea575907571c1861cb',"blockstore|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
0.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 75 AND id_lang = 1 AND active = 1 LIMIT 1
0.8 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 80
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE COUNT(id_lgcomments_storecomments) AS total FROM ps_lgcomments_storecomments WHERE active = 1 AND id_lang = 1 LIMIT 1
0.7 5 /modules/lgcomments/lgcomments.php:957
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 49) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1
0.7 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 77) AND (id_product_attribute = 548) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"77|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 78 AND `id_group` = 1 LIMIT 1
0.7 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 79
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='1e435d7f7224c1cf0014cbe1b9cf03bf' AND cache_id="blockcontactinfos|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 78 AND id_lang = 1 AND active = 1 LIMIT 1
0.7 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 120
AND g.`id_lang` = 1
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.7 0 /classes/Product.php:5546
SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 29
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
0.7 1 /modules/blockcms/BlockCMSModel.php:333
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 80 AND id_lang = 1 AND active = 1 LIMIT 1
0.7 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 138
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='1f38e48ad1ff9883c592df453c194c54' AND cache_id="blocksearch-top|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.7 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 74 AND id_lang = 1 AND active = 1 LIMIT 1
0.7 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.7 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='14e3bfccf492f8cf3beea5e88f03f5b4' AND cache_id="blockcms|2|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 51 LIMIT 1
0.7 0 /classes/Category.php:1054
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'm_scene_default' LIMIT 1
0.7 1 /classes/Image.php:472
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 80 AND `id_group` = 1 LIMIT 1
0.7 0 /classes/GroupReduction.php:149
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('14e3bfccf492f8cf3beea5e88f03f5b4',"blockcms|2|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.7 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 0 LIMIT 1
0.7 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 0 LIMIT 1
0.7 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='99f1463fc2299dea575907571c1861cb' AND cache_id="blockstore|1|1|1|1|1|21" AND compile_id="" LIMIT 1
0.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 74) AND (id_product_attribute = 261) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 40 AND `id_shop` = 1 LIMIT 1
0.7 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1
0.7 1 /modules/paypal/paypal.php:276
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 138 AND `id_group` = 1 LIMIT 1
0.7 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 79 AND id_lang = 1 AND active = 1 LIMIT 1
0.7 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 74
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 1 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3dce0547ada74ab6309102c67ded04ce',"productlist_colors|79|1|1","", FROM_UNIXTIME(1591353765))
0.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE canonical_url FROM `ps_lgcanonicalurls_lang` WHERE `id_object` = 28   AND `type_object` = 2   AND `id_lang` = 2;
0.7 0 /modules/lgcanonicalurls/lgcanonicalurls.php:1593
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarna" LIMIT 1
0.7 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1
0.7 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 138 AND id_lang = 1 AND active = 1 LIMIT 1
0.7 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 77 AND id_shop=1 LIMIT 1
0.7 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.7 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 77 AND id_lang = 1 AND active = 1 LIMIT 1
0.7 6 /modules/lgcomments/lgcomments.php:880
DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction
0.7 1 /modules/blocklayered/blocklayered.php:2132
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.7 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 75 AND id_shop=1 LIMIT 1
0.6 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "klarnaofficial" LIMIT 1
0.6 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.6 1 /override/classes/Cart.php:228
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"76|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.6 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 80) AND (id_product_attribute = 264) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = 76 AND id_lang = 1 AND active = 1 LIMIT 1
0.6 6 /modules/lgcomments/lgcomments.php:880
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.6 1 /override/classes/Cart.php:228
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"74|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 78 AND id_shop=1 LIMIT 1
0.6 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1
0.6 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "supercheckout" LIMIT 1
0.6 1 /classes/module/Module.php:2568
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"78|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(p.`quantity`)
FROM `ps_cart_product` as p
LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
WHERE p.`id_cart` = 0
AND ps.`id_manufacturer` = 7 LIMIT 1
0.6 1 /override/classes/Cart.php:228
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 75) AND (id_product_attribute = 546) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:380
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e7b89dfa5bffe62c3e5457128c16cb83',"blocknewproducts|20200605|1|1|1|1|1|21","", FROM_UNIXTIME(1591353765))
0.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('382b318ec0a84a7ae5d224b8ad3a1306',"blockmyaccountfooter|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 80 AND id_shop=1 LIMIT 1
0.6 1 /classes/Product.php:5033
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('70433347072c3750390efb5cc6a80e02',"75|1|1|1|1|1|21","", FROM_UNIXTIME(1591353766))
0.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 74 AND `id_group` = 1 LIMIT 1
0.6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE COUNT(*) FROM ps_cat_filter_restriction LIMIT 1
0.6 0 /modules/blocklayered/blocklayered.php:2009
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 138 AND id_shop=1 LIMIT 1
0.6 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.6 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.6 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.6 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.6 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.6 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.5 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 74 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 79 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:5033
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 79) AND (id_product_attribute = 550) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 78) AND (id_product_attribute = 549) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.5 0 /classes/module/Module.php:2218
DROP TEMPORARY TABLE IF EXISTS ps_cat_filter_restriction
0.4 1 /modules/blocklayered/blocklayered.php:1934

Doubles

37
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
36
SELECT *
							FROM `ps_category_lang`
							WHERE `id_category` = XX AND `id_shop` = XX
36
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) LIMIT XX
32
			SELECT SUM(p.`quantity`)
			FROM `ps_cart_product` as p
			LEFT JOIN `ps_product` as ps on p.`id_product` = ps.`id_product`
			WHERE p.`id_cart` = XX
			    AND ps.`id_manufacturer` = XX LIMIT XX
17
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"XX|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
15
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
14
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"productlist_colors|XX|XX|XX","", FROM_UNIXTIME(XX))
13
					SELECT a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`
					FROM `ps_layered_indexable_attribute_group_lang_value` g
					LEFT JOIN `ps_attribute` a
						ON (a.`id_attribute_group` = g.`id_attribute_group`)
					WHERE a.`id_attribute` = XX
					AND g.`id_lang` = XX
					AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
10
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
9
SELECT SUM(stars) AS totalcomentarios FROM ps_lgcomments_productcomments WHERE id_product = XX AND id_lang = XX AND active = XX LIMIT XX
9
SELECT COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = XX AND active = XX AND id_lang = XX LIMIT XX
9
			SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name`
			FROM `ps_attribute` a
			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 = XX)
			LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
				ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = XX)
			WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
			AND pa.`id_product` = XX
			AND pac.`id_product_attribute` = XX
9
SELECT link_rewrite FROM ps_product_lang WHERE id_product = XX AND id_lang = XX LIMIT XX
8
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="productlist_colors|XX|XX|XX" AND compile_id="" LIMIT XX
8
				SELECT `priority`, `id_specific_price_priority`
				FROM `ps_specific_price_priority`
				WHERE `id_product` = XX
				ORDER BY `id_specific_price_priority` DESC LIMIT XX
8
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
8
			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `ps_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
8
				SELECT 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 = XX)
				LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
				LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
				 INNER JOIN ps_feature_shop feature_shop
		ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX)
				WHERE pf.id_product = XX
				ORDER BY f.position ASC
8
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
8
							SELECT `id_tax_rules_group`
							FROM `ps_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
8
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) LIMIT XX
8
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="XX|XX|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX
8
SELECT *
							FROM `ps_product_lang`
							WHERE `id_product` = XX AND `id_shop` = XX
8
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
7
		SELECT *
		FROM ps_product_attachment pa
		LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
		LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX)
                LEFT JOIN ps_addev_amp_languages aml ON aml.id_attachment = pa.id_attachment
		WHERE pa.id_product = XX AND (aml.id_langs LIKE '%,XX,%' OR aml.id_langs IS NULL);
7
			SELECT product_attribute_shop.`price`
			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 = XX)
			WHERE pa.`id_product_attribute` = XX LIMIT XX
6
SELECT cl.`meta_title`, cl.`link_rewrite`
			FROM `ps_cms_lang` cl
			INNER JOIN `ps_cms` c
			ON (cl.`id_cms` = c.`id_cms`)
			WHERE cl.`id_cms` = XX
			AND (c.`active` = XX OR c.`id_cms` = XX) AND cl.`id_shop` = XX
			AND cl.`id_lang` = XX LIMIT XX
6
SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
					COUNT(DISTINCT p.id_product) nbr,
					lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 

					FROM ps_feature_product fp
					INNER JOIN ps_cat_restriction p
					ON p.id_product = fp.id_product
					LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = XX)
					INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = XX))
					LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = XX)
					LEFT JOIN ps_layered_indexable_feature_lang_value lifl
					ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = XX)
					LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
					ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = XX) 

WHERE fp.id_feature = XX
GROUP BY fv.id_feature_value 
5
		SELECT	cl.`title`, cl.`link_rewrite`, cc.`categorie`
		FROM `ps_prestablog_correspondancecategorie` as cc
		LEFT JOIN `ps_prestablog_categorie` as c
			ON (cc.`categorie` = c.`id_prestablog_categorie`)
		LEFT JOIN `ps_prestablog_categorie_lang` as cl
			ON (cc.`categorie` = cl.`id_prestablog_categorie`)
		WHERE cc.`news` = XX
			AND cl.`id_lang` = XX
			AND c.`actif` = XX
			AND cc.`categorie` IN (
						SELECT id_prestablog_categorie
						FROM ps_prestablog_categorie_group
						WHERE id_group IN (XX)
					)
		ORDER BY cl.`title`
5
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX
WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
5
				SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = XX)
				LEFT JOIN `ps_attribute_group_lang` agl
					ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
				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 = XX)
				WHERE pa.`id_product` = XX
				AND pac.id_product_attribute = XX
				AND a.`id_attribute` NOT IN(XX)
4
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
4
				SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, 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` = XX)
				LEFT JOIN `ps_attribute_group_lang` agl
					ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
				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 = XX)
				WHERE pa.`id_product` = XX
				AND pac.id_product_attribute = XX
				AND a.`id_attribute` NOT IN(XX, XX)
4
		SELECT c.id_cms, cl.link_rewrite, cl.meta_title
		FROM ps_cms c
		LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = XX)
		 INNER JOIN ps_cms_shop cms_shop
		ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = XX)
		WHERE XX
		 AND c.id_cms IN (XX) AND c.`active` = XX GROUP BY c.id_cms
		ORDER BY c.`position`
4
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockcms|XX|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
4
						SELECT g.`id_attribute_group`, g.`name` as `group`
						FROM `ps_attribute_group_lang` g
						LEFT JOIN `ps_attribute` a
							ON (a.`id_attribute_group` = g.`id_attribute_group`)
						WHERE a.`id_attribute` = XX
						AND g.`id_lang` = XX
						AND g.`name` IS NOT NULL
3
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `ps_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `ps_module` m
3
SELECT l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
				FROM ps_linksmenutop l
				LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = XX AND ll.id_shop=XX)
				LEFT JOIN ps_shop s ON l.id_shop = s.id_shop
				WHERE XX  AND l.id_linksmenutop = "XX"
				AND l.id_shop IN (XX, XX)
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blocktopmenu|XX|XX|XX|XX|XX|XX|category|XX","", FROM_UNIXTIME(XX))
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockcontact|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blocksearch-top|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
SELECT canonical_url FROM `ps_lgcanonicalurls_lang` WHERE `id_object` = XX   AND `type_object` = XX   AND `id_lang` = XX;
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blocksocial|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
SELECT type+XX AS type FROM `ps_lgcanonicalurls` WHERE `id_object` = XX   AND `type_object` = XX LIMIT XX
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockcategories|XX|XX|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
		SELECT 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 = XX)
		LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX  AND cl.id_shop = XX )
		LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
		WHERE `id_parent` = XX
		AND `active` = XX
		AND cg.`id_group` =XX
		GROUP BY c.`id_category`
		ORDER BY `level_depth` ASC, category_shop.`position` ASC
2
					SELECT COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
					a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
					liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title

					FROM ps_layered_product_attribute lpa
					INNER JOIN ps_attribute a
					ON a.id_attribute = lpa.id_attribute
					INNER JOIN ps_attribute_lang al
					ON al.id_attribute = a.id_attribute
					AND al.id_lang = XX
					INNER JOIN ps_cat_restriction p
					ON p.id_product = lpa.id_product
					INNER JOIN ps_attribute_group ag
					ON ag.id_attribute_group = lpa.id_attribute_group
					INNER JOIN ps_attribute_group_lang agl
					ON agl.id_attribute_group = lpa.id_attribute_group
					AND agl.id_lang = XX
					LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
					ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = XX)
					LEFT JOIN ps_layered_indexable_attribute_lang_value lial
					ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = XX) 

WHERE lpa.id_attribute_group = XX AND lpa.`id_shop` = XX

					GROUP BY lpa.id_attribute
					ORDER BY ag.`position` ASC, a.`position` ASC
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockmyaccountfooter|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
			SELECT nleft, nright, level_depth
			FROM ps_category
			WHERE id_category = XX LIMIT XX
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockbanner|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blocknewproducts|XX|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
			SELECT domain, domain_ssl
			FROM ps_shop_url
			WHERE main = XX
			AND id_shop = XX LIMIT XX
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockspecials|XX|XX|XX|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockstore|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockcategories|XX|XX|XX|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
UPDATE `ps_smarty_lazy_cache`
							SET filepath='blockcms/XX/XX/XX/XX/XX/XX/XX/XX/dXX/bXX/XXdXXbXXeXXbXXdXXdXXabXXfdfXXdXXbceXX.blockcms.tpl.php'
							WHERE `template_hash`=XX AND cache_id="blockcms|XX|XX|XX|XX|XX|XX|XX" AND compile_id=""
2
INSERT IGNORE INTO `ps_smarty_lazy_cache`
							(`template_hash`, `cache_id`, `compile_id`, `last_update`)
							VALUES (XX,"blockcontactinfos|XX|XX|XX|XX|XX|XX","", FROM_UNIXTIME(XX))
2
SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
							WHERE `template_hash`=XX AND cache_id="blockcms|XX|XX|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX
2
				SELECT 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` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX
WHERE (a.`id_country` = XX) LIMIT XX

Tables stress

85 category_lang
83 category
80 category_shop
59 product
38 attribute
35 product_attribute_shop
35 product_shop
32 cart_product
31 smarty_lazy_cache
26 product_attribute
26 product_lang
19 product_attribute_combination
19 module
18 lgcomments_productcomments
17 cms_lang
17 cms
16 stock_available
16 attribute_group_lang
15 feature_lang
15 specific_price
15 layered_indexable_attribute_group_lang_value
15 module_shop
14 feature_value_lang
14 feature_product
12 attribute_lang
11 layered_indexable_attribute_lang_value
11 cms_shop
9 cat_restriction
8 feature_shop
8 specific_price_priority
8 product_group_reduction_cache
8 feature
7 attachment
7 shop
7 product_attachment
7 attachment_lang
7 addev_amp_languages
6 prestablog_correspondancecategorie
6 layered_indexable_feature_lang_value
6 layered_indexable_feature_value_lang_value
6 category_group
6 prestablog_categorie_group
6 feature_value
5 country
5 shop_url
5 lang
5 image_type
5 prestablog_categorie
5 prestablog_categorie_lang
4 currency_shop
4 cms_category_lang
4 country_shop
4 country_lang
4 lang_shop
4 hook
3 currency
3 meta
3 category_product
3 theme
3 attribute_group
3 linksmenutop
3 lgcomments_storecomments
3 linksmenutop_lang
2 group
2 meta_lang
2 configuration
2 shop_group
2 cat_filter_restriction
2 tax_rule
2 tax_rules_group
2 cms_block_page
2 themeconfigurator
2 lgcanonicalurls
2 hook_module
2 cms_category_shop
2 layered_category
2 layered_product_attribute
2 hook_alias
2 layered_indexable_feature
2 layered_indexable_attribute_group
2 group_shop
2 lgcanonicalurls_lang
2 cms_category
2 smarty_last_flush
1 page
1 page_type
1 manufacturer
1 supplier
1 required_field
1 psgdpr_consent
1 supplier_shop
1 supplier_lang
1 connections
1 pga
1 scene
1 scene_category
1 scene_shop
1 scene_lang
1 layered_price_index
1 group_lang
1 hook_module_exceptions
1 configuration_lang
1 module_group
1 lgseoredirect
1 theme_meta
1 zone
1 state
1 prestablog_news_lang
1 prestablog_commentnews
1 prestablog_news
1 contactform
1 image_shop
1 cms_block_lang
1 cms_block_shop
1 k_cookies
1 store
1 store_shop
1 cms_block
1 image_lang

ObjectModel instances

NameInstancesSource
Category 90 /controllers/front/CategoryController.php [99]
/classes/Link.php [177]
/modules/blocklayered/blocklayered.php [2120]
/modules/blocklayered/blocklayered.php [696]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/modules/blocktopmenu/blocktopmenu.php [599]
/classes/Link.php [177]
/classes/Link.php [177]
/modules/blockcategories/blockcategories.php [193]
/modules/blockcategories/blockcategories.php [197]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/modules/blockcategories/blockcategories.php [243]
/modules/blocklayered/blocklayered.php [1806]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
Product 58 /classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/modules/blocklayered/blocklayered.php [3202]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
Customer 8 /config/config.inc.php [221]
/modules/prestablog/prestablog.php [9850]
/modules/prestablog/prestablog.php [9850]
/modules/prestablog/prestablog.php [9850]
/modules/prestablog/prestablog.php [9850]
/modules/prestablog/prestablog.php [9850]
/modules/prestablog/prestablog.php [9850]
/modules/prestablog/prestablog.php [9850]
CMS 5 /classes/Link.php [265]
/modules/blocktopmenu/blocktopmenu.php [669]
/modules/blocktopmenu/blocktopmenu.php [669]
/modules/blocktopmenu/blocktopmenu.php [669]
/classes/Link.php [265]
Country 3 /config/config.inc.php [142]
/classes/controller/FrontController.php [279]
/modules/paypal/paypal.php [112]
Language 2 /config/config.inc.php [195]
/classes/Tools.php [498]
Address 2 /classes/Product.php [2937]
/classes/Product.php [4404]
Shop 2 /config/config.inc.php [114]
/modules/lgcanonicalurls/lgcanonicalurls.php [1632]
Guest 1 /modules/statsdata/statsdata.php [104]
Connection 1 /modules/statsdata/statsdata.php [142]
CMSCategory 1 /modules/blocktopmenu/blocktopmenu.php [500]
Currency 1 /classes/controller/FrontController.php [283]
Theme 1 /config/config.inc.php [115]
ShopGroup 1 /classes/shop/Shop.php [518]
Cart 1 /classes/controller/FrontController.php [348]
Group 1 /classes/Cart.php [184]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/settings.inc.php
5/config/autoload.php
6/config/alias.php
7/classes/PrestaShopAutoload.php
8/cache/class_index.php
9/config/bootstrap.php
10/Core/Business/Core_Business_ContainerBuilder.php
11/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
12/Adapter/Adapter_ServiceLocator.php
13/classes/controller/Controller.php
14/classes/ObjectModel.php
15/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
16/classes/db/Db.php
17/classes/Tools.php
18/classes/Context.php
19/classes/shop/Shop.php
20/override/classes/shop/Shop.php
21/classes/db/DbPDO.php
22/classes/Configuration.php
23/classes/Validate.php
24/override/classes/Validate.php
25/classes/cache/Cache.php
26/Adapter/Adapter_EntityMapper.php
27/classes/db/DbQuery.php
28/classes/Theme.php
29/config/defines_uri.inc.php
30/classes/Language.php
31/classes/Country.php
32/classes/PrestaShopCollection.php
33/classes/shop/ShopGroup.php
34/classes/Cookie.php
35/classes/Rijndael.php
36/config/smarty.config.inc.php
37/tools/smarty/Smarty.class.php
38/tools/smarty/sysplugins/smarty_internal_data.php
39/tools/smarty/sysplugins/smarty_internal_templatebase.php
40/tools/smarty/sysplugins/smarty_internal_template.php
41/tools/smarty/sysplugins/smarty_resource.php
42/tools/smarty/sysplugins/smarty_internal_resource_file.php
43/tools/smarty/sysplugins/smarty_cacheresource.php
44/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
45/classes/SmartyCustom.php
46/config/smartyfront.config.inc.php
47/classes/Customer.php
48/override/classes/Customer.php
49/classes/Group.php
50/classes/Link.php
51/override/classes/Link.php
52/classes/shop/ShopUrl.php
53/classes/Dispatcher.php
54/override/classes/Dispatcher.php
55/classes/Hook.php
56/tools/mobile_Detect/Mobile_Detect.php
57/classes/module/Module.php
58/config/db_slave_server.inc.php
59/modules/prestablog/prestablog.php
60/modules/prestablog/class/news.class.php
61/modules/prestablog/class/categories.class.php
62/modules/prestablog/class/correspondancescategories.class.php
63/modules/prestablog/class/commentnews.class.php
64/modules/prestablog/class/antispam.class.php
65/modules/prestablog/class/subblocks.class.php
66/classes/Translate.php
67/themes/soppec/modules/prestablog/translations/fr.php
68/modules/prestablog/translations/fr.php
69/modules/lgseoredirect/lgseoredirect.php
70/modules/lgseoredirect/classes/LGJsonApi.php
71/modules/lgseoredirect/classes/LGSeoRedirectPubli.php
72/themes/soppec/modules/lgseoredirect/translations/fr.php
73/modules/lgseoredirect/translations/fr.php
74/controllers/front/CategoryController.php
75/classes/controller/FrontController.php
76/classes/Category.php
77/override/classes/Category.php
78/themes/soppec/lang/fr.php
79/classes/Currency.php
80/classes/Cart.php
81/override/classes/Cart.php
82/modules/kbfreedelivery/classes/KbFreeShippingRule.php
83/classes/CartRule.php
84/classes/Meta.php
85/classes/Product.php
86/override/classes/Product.php
87/classes/webservice/WebserviceRequest.php
88/classes/Media.php
89/classes/Scene.php
90/modules/socialsharing/socialsharing.php
91/themes/soppec/modules/socialsharing/translations/fr.php
92/modules/socialsharing/translations/fr.php
93/modules/blockbanner/blockbanner.php
94/themes/soppec/modules/blockbanner/translations/fr.php
95/modules/blockbanner/translations/fr.php
96/modules/blockbestsellers/blockbestsellers.php
97/themes/soppec/modules/blockbestsellers/translations/fr.php
98/modules/blockbestsellers/translations/fr.php
99/modules/blockcart/blockcart.php
100/themes/soppec/modules/blockcart/translations/fr.php
101/modules/blockcart/translations/fr.php
102/modules/blocksocial/blocksocial.php
103/override/modules/blocksocial/blocksocial.php
104/themes/soppec/modules/blocksocial/translations/fr.php
105/modules/blocksocial/translations/fr.php
106/modules/blockcategories/blockcategories.php
107/themes/soppec/modules/blockcategories/translations/fr.php
108/modules/blockcategories/translations/fr.php
109/modules/blockcurrencies/blockcurrencies.php
110/themes/soppec/modules/blockcurrencies/translations/fr.php
111/modules/blockcurrencies/translations/fr.php
112/modules/blockfacebook/blockfacebook.php
113/themes/soppec/modules/blockfacebook/translations/fr.php
114/modules/blockfacebook/translations/fr.php
115/modules/blocklanguages/blocklanguages.php
116/override/modules/blocklanguages/blocklanguages.php
117/themes/soppec/modules/blocklanguages/translations/fr.php
118/modules/blocklanguages/translations/fr.php
119/modules/blocklayered/blocklayered.php
120/themes/soppec/modules/blocklayered/translations/fr.php
121/modules/blocklayered/translations/fr.php
122/modules/blockcms/blockcms.php
123/modules/blockcms/BlockCMSModel.php
124/themes/soppec/modules/blockcms/translations/fr.php
125/modules/blockcms/translations/fr.php
126/modules/blockcontact/blockcontact.php
127/themes/soppec/modules/blockcontact/translations/fr.php
128/modules/blockcontact/translations/fr.php
129/modules/blockcontactinfos/blockcontactinfos.php
130/themes/soppec/modules/blockcontactinfos/translations/fr.php
131/modules/blockcontactinfos/translations/fr.php
132/modules/blockmyaccount/blockmyaccount.php
133/themes/soppec/modules/blockmyaccount/translations/fr.php
134/modules/blockmyaccount/translations/fr.php
135/modules/blockmyaccountfooter/blockmyaccountfooter.php
136/themes/soppec/modules/blockmyaccountfooter/translations/fr.php
137/modules/blockmyaccountfooter/translations/fr.php
138/modules/blocknewproducts/blocknewproducts.php
139/themes/soppec/modules/blocknewproducts/translations/fr.php
140/modules/blocknewproducts/translations/fr.php
141/modules/blocknewsletter/blocknewsletter.php
142/themes/soppec/modules/blocknewsletter/translations/fr.php
143/modules/blocknewsletter/translations/fr.php
144/modules/blocksearch/blocksearch.php
145/themes/soppec/modules/blocksearch/translations/fr.php
146/modules/blocksearch/translations/fr.php
147/modules/blockspecials/blockspecials.php
148/themes/soppec/modules/blockspecials/translations/fr.php
149/modules/blockspecials/translations/fr.php
150/modules/blockstore/blockstore.php
151/themes/soppec/modules/blockstore/translations/fr.php
152/modules/blockstore/translations/fr.php
153/modules/blocksupplier/blocksupplier.php
154/themes/soppec/modules/blocksupplier/translations/fr.php
155/modules/blocksupplier/translations/fr.php
156/modules/blocktags/blocktags.php
157/themes/soppec/modules/blocktags/translations/fr.php
158/modules/blocktags/translations/fr.php
159/modules/blockuserinfo/blockuserinfo.php
160/override/modules/blockuserinfo/blockuserinfo.php
161/themes/soppec/modules/blockuserinfo/translations/fr.php
162/modules/blockuserinfo/translations/fr.php
163/modules/blockviewed/blockviewed.php
164/themes/soppec/modules/blockviewed/translations/fr.php
165/modules/blockviewed/translations/fr.php
166/modules/homeslider/homeslider.php
167/modules/homeslider/HomeSlide.php
168/themes/soppec/modules/homeslider/translations/fr.php
169/modules/homeslider/translations/fr.php
170/modules/homefeatured/homefeatured.php
171/themes/soppec/modules/homefeatured/translations/fr.php
172/modules/homefeatured/translations/fr.php
173/modules/themeconfigurator/themeconfigurator.php
174/themes/soppec/modules/themeconfigurator/translations/fr.php
175/modules/themeconfigurator/translations/fr.php
176/cache/smarty/compile/12/b2/36/12b236a6319b252eaecb3fa1d249d917ee94822b.file.hook.tpl.php
177/tools/smarty/sysplugins/smarty_internal_filter_handler.php
178/modules/editorial/editorial.php
179/override/modules/editorial/editorial.php
180/themes/soppec/modules/editorial/translations/fr.php
181/modules/editorial/translations/fr.php
182/modules/editorial/EditorialClass.php
183/modules/blocktopmenu/blocktopmenu.php
184/modules/blocktopmenu/menutoplinks.class.php
185/themes/soppec/modules/blocktopmenu/translations/fr.php
186/modules/blocktopmenu/translations/fr.php
187/modules/contactform/contactform.php
188/modules/contactform/classes/class.tools.php
189/modules/contactform/classes/class.toolbar.php
190/modules/contactform/classes/class.utils.php
191/modules/contactform/library/recaptcha/recaptchalib.php
192/modules/contactform/classes/class.dataexport.php
193/modules/contactform/classes/class.front.php
194/themes/soppec/modules/contactform/translations/fr.php
195/modules/contactform/fr.php
196/modules/dpdfrance/dpdfrance.php
197/classes/module/CarrierModule.php
198/themes/soppec/modules/dpdfrance/translations/fr.php
199/modules/dpdfrance/fr.php
200/modules/pga/pga.php
201/themes/soppec/modules/pga/translations/fr.php
202/modules/pga/key.php
203/modules/paypal/paypal.php
204/modules/paypal/api/paypal_lib.php
205/modules/paypal/api/paypal_connect.php
206/modules/paypal/api/CallApiPaypalPlus.php
207/modules/paypal/api/ApiPaypalPlus.php
208/modules/paypal/paypal_logos.php
209/module