SELECT SQL_NO_CACHE p.id_product as id, m.name as manufacturer_name, p.price
FROM ps_product as p
JOIN ps_manufacturer m USING (id_manufacturer)
WHERE EXISTS(SELECT 1 FROM product_marque_modele_type pmmt WHERE pmmt.id_product = p.id_product AND  pmmt.type_id=1977)
AND p.active = 0
AND p.id_category_default = 1247
AND p.price > 0
AND p.price <= 5000
AND m.active = 1 order by manufacturer_name,price

SELECT SQL_NO_CACHE pfvl.id_feature_value,pfvl.value,pfp.id_feature
FROM ps_feature as pfl
JOIN ps_feature_product AS pfp using (id_feature)
join ps_feature_value_lang AS pfvl using(id_feature_value)
join ps_product p using(id_product)
WHERE id_category_default = 1247
AND p.active=1 AND pfvl.id_lang=1
AND p.price<6000
AND (EXISTS(SELECT 1 FROM product_marque_modele_type pmmt WHERE  pmmt.type_id=1977 and pmmt.id_product = p.id_product) OR p.is_universal)
group by id_feature_value

SELECT SQL_NO_CACHE * FROM (
SELECT p1.id_product as id, m.name as manufacturer_name, m.id_manufacturer, p1.id_category_default,p1.price, p1.price - IF(reduction is null,0,reduction) as priceRemise,
if(stock_dispo>0,1,0) as dispo
FROM ps_product p1
LEFT JOIN ps_manufacturer m USING (id_manufacturer)
LEFT JOIN ps_stock_dispo_gs using (id_product)
LEFT JOIN ps_specific_price sp USING (id_product)
LEFT JOIN product_marque_modele_type as pmmt ON (p1.id_product = pmmt.id_product) 
JOIN mod_vehicules_types mvt ON pmmt.type_id = mvt.type_id
WHERE id_category_default =1247
AND mvt.ext_type IN (2,999,4,5)
AND (p1.id_manufacturer not in (3,25,46,79,91,180,520,47,109,576,553,589,119,561,595,596,607,703,261,543,36,598,599,161,508,137,436,88,232,346,378,887,152,608,517,1024,259) OR stock_dispo>0)
AND p1.active= 1
AND  pmmt.type_id=1977 
AND p1.price>0 AND p1.price<5000 
GROUP BY p1.id_product) as R23 ORDER BY dispo desc,manufacturer_name

SELECT SQL_NO_CACHE force_display,
gs.stock_dispo,
gs.id_next_supplier,
pl.name,
group_concat(oem.id_ptt_reference) as refConstructeur,
image,
p1.id_product                                  as id,
m.name                                         as manufacturer_name,
m.id_manufacturer,
p1.id_category_default,
p1.price,
p1.price - IF(reduction is null, 0, reduction) as priceRemise,
0 as dispo,pl.description
FROM ps_product p1
JOIN ps_product_lang pl using (id_product)
LEFT JOIN ps_stock_dispo_gs gs using (id_product)
LEFT JOIN ps_specific_price sp USING (id_product)
JOIN ps_manufacturer m USING (id_manufacturer)
LEFT JOIN ps_ptt_product_refconstructeur oem using (id_product)
LEFT JOIN (SELECT 1 as image, id_product FROM ps_image group by id_product) R1 using (id_product)
WHERE p1.active = 1 and gs.stock_dispo is null
AND id_category_default=1247
AND p1.id_manufacturer in (3,25,46,79,91,180,520,47,109,576,553,589,119,561,595,596,607,703,261,543,36,598,599,161,508,137,436,88,232,346,378,887,152,608,517,1024,259)
AND EXISTS (SELECT 1 FROM mod_vehicules_types mvt
JOIN product_marque_modele_type as pmmt using (type_id) where mvt.ext_type IN (2,999,4,5) AND  pmmt.type_id=1977 AND p1.id_product=pmmt.id_product)
AND pl.id_lang = 1 
AND pl.id_shop = 1 
group by id
order by force_display desc,stock_dispo desc,image desc,p1.price asc

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`)

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

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

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
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_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` != "paymentOptions") 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`

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.id_category<>1049 AND c.nleft <= 1428
AND c.nright >= 1429
AND c.nleft >= 2
AND c.nright <= 5847
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC

SELECT SQL_NO_CACHE id_category from ps_category where is_universal = 1

SELECT SQL_NO_CACHE id_product,manufacturer_name,nbVentes,score FROM (SELECT id_product,manufacturer_name,nbVentes,score,rn FROM(SELECT id_product,
m.name as manufacturer_name,
nbVentes,
2 as score,
dense_rank() OVER (PARTITION BY id_category ORDER BY nbVentes DESC) AS rn
FROM pop_product_vehicle
JOIN ps_product pp using (id_product)
INNER JOIN ps_manufacturer m USING (id_manufacturer) 
WHERE id_vehicle=5096 
and id_product != 0 
and pp.active
and id_category != 0 ) as r2
UNION ALL(
SELECT DISTINCT p.id_product, m.name as manufacturer_name,nbVentes,0 as rn,1 as score
FROM pop_product p
INNER JOIN ps_manufacturer m USING (id_manufacturer)
WHERE p.is_universal = 1
AND p.active = 1
AND p.price<6000
AND p.id_product !=0
order by nbVentes desc limit 10) ) as r1 WHERE rn=1 ORDER BY score DESC,nbVentes DESC LIMIT 10

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 AND c.active = 1
ORDER BY cl.name ASC

SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)

SELECT SQL_NO_CACHE p.id_product as id, m.name as manufacturer_name, m.id_manufacturer, p.id_category_default,p.price,
p.price - IF(reduction is null,0,reduction) as priceRemise,nbVentes
FROM ps_product p
LEFT JOIN ps_manufacturer m using (id_manufacturer)
LEFT JOIN pop_product pop using (id_product)
LEFT JOIN ps_specific_price sp USING (id_product)
join ps_category c on(p.id_category_default=c.id_category)
WHERE id_parent=1247 and p.active= 1 and (ext_type in(2,999,4,5) or p.is_universal)
GROUP BY p.id_product,nbVentes
order by nbVentes desc,priceRemise

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 3 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*
FROM `ps_feature` f
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1)
ORDER BY f.`position` ASC

SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 1 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE DISTINCT m.name, m.id_manufacturer , p.price - IF(reduction is null,0,reduction) as price_remise
FROM  ps_product p
LEFT JOIN ps_specific_price sp USING (id_product)
JOIN ps_manufacturer m ON (p.id_manufacturer = m.id_manufacturer) 
JOIN ps_category c ON(p.id_category_default=c.id_category)
WHERE id_parent=1247 AND p.active = 1 AND p.price<6000
ORDER BY price_remise

SELECT SQL_NO_CACHE *
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON m.`id_meta` = ml.`id_meta`
WHERE ml.`id_lang` = 1 AND ml.id_shop = 1 ORDER BY page ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 6 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 18 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

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` = 4950) AND (b.`id_shop` = 1) LIMIT 1

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` = 5517903) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE DISTINCT pfvl.id_feature_value,pfvl.value,pfp.id_feature
FROM ps_feature_lang as pfl,ps_feature_value_lang AS pfvl
JOIN ps_feature_product AS pfp ON (pfp.id_feature_value = pfvl.id_feature_value)
JOIN ps_product p ON(p.id_product= pfp.id_product)
LEFT JOIN product_marque_modele_type AS pmmt ON (p.id_product = pmmt.id_product)
JOIN ps_category c on(p.id_category_default=c.id_category)
WHERE 1247 = id_parent
AND (pfl.id_feature=pfp.id_feature)
AND  p.active=1 AND p.price<6000 and pfvl.id_lang=1

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

SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-10-09 00:00:00" AND date_to <= "2025-10-09 23:59:59") OR (date_from >= "2025-10-09 00:00:00" AND date_from <= "2025-10-09 23:59:59") OR (date_from < "2025-10-09 00:00:00" AND date_to > "2025-10-09 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 2 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

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` = 6595362) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` )
LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `ps_supplier` s ON (s.`id_supplier` = p.`id_supplier`) 
WHERE pl.`id_lang` = 1
AND p.reference="alma-insurance" LIMIT 1

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` = 3194) AND (b.`id_shop` = 1) LIMIT 1

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` = 2959380) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 4 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

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` = 4432832) AND (b.`id_shop` = 1) LIMIT 1

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

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1

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` = 4518831) AND (b.`id_shop` = 1) LIMIT 1

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` = 6598606) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1

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` = 6594917) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.*, b.`name`, b.`description`
FROM `ps_lgcookieslaw_purpose` a
LEFT JOIN `ps_lgcookieslaw_purpose_lang` `b` ON (b.`id_lgcookieslaw_purpose` = a.`id_lgcookieslaw_purpose` AND b.`id_lang` = 1)
WHERE (a.`id_shop` = 1) AND (a.`active` = 1)

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 20 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1

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

SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1

SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 53
AND tr.`id_state` IN (0, 0)
AND ('63800' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '63800')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 21 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 7 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 9 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 8 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 14 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE id_category FROM ps_category WHERE id_parent=1960 and id_category=1247
UNION ALL select id_category from ps_category where id_parent in(SELECT id_category FROM ps_category WHERE id_parent=1960) and id_category=1247
UNION ALL select id_category from ps_category where id_parent in(select id_category from ps_category where id_parent in(SELECT id_category FROM ps_category WHERE id_parent=1960)) and id_category=1247

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 10 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1

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 = 'www.carmino.fr' OR su.domain_ssl = 'www.carmino.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

SELECT SQL_NO_CACHE ic.*
FROM `ps_insuroption_cart` ic
WHERE (ic.`id_cart` = 0) AND (ic.`id_shop` = 1)

SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1

SELECT SQL_NO_CACHE id_category FROM ps_category WHERE id_parent=1960 and id_category=1247
UNION ALL select id_category from ps_category where id_parent in(SELECT id_category FROM ps_category WHERE id_parent=1960) and id_category=1247
UNION ALL select id_category from ps_category where id_parent in(select id_category from ps_category where id_parent in(SELECT id_category FROM ps_category WHERE id_parent=1960)) and id_category=1247

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 16 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE '' as licence_plate,mvt.type_id, mvt.type_name, 
mvm.marque_id, mvm.marque_name, 
mvmo.modele_id, mvmo.modele_name,
mvgmo.groupe_modele_id, mvgmo.groupe_modele_name,mvgmo.utilitaire,
CONCAT(mvmo.mois_debut_prod, '/', mvmo.annee_debut_prod) as start_date,
CONCAT(mvmo.mois_fin_prod, '/', mvmo.annee_fin_prod) as end_date, mvt.ext_type
from mod_vehicules_types mvt 
join mod_vehicules_marques mvm using (marque_id)
join mod_vehicules_groupes_modeles mvgmo using (groupe_modele_id)
LEFT JOIN mod_vehicules_modeles mvmo ON (mvt.modele_id = mvmo.modele_id)
where type_id=1977

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 5 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 17 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 22 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE mvt.type_id, mvt.type_name, mvt.type_id as id,
mvm.marque_id, mvm.marque_name, 
mvmo.modele_id, mvmo.modele_name,
mvgmo.groupe_modele_id, mvgmo.groupe_modele_name,mvgmo.utilitaire,
CONCAT(mvmo.mois_debut_prod, '/', mvmo.annee_debut_prod) as start_date,
CONCAT(mvmo.mois_fin_prod, '/', mvmo.annee_fin_prod) as end_date, mvt.ext_type
FROM mod_vehicules_types mvt
LEFT JOIN mod_vehicules_marques mvm ON (mvt.marque_id = mvm.marque_id)
LEFT JOIN mod_vehicules_modeles mvmo ON (mvt.modele_id = mvmo.modele_id)
LEFT JOIN mod_vehicules_groupes_modeles mvgmo ON (mvmo.groupe_modele_id = mvgmo.groupe_modele_id)
WHERE type_id = 1977 AND mvt.ext_type in (2,999,4,5) LIMIT 1

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 19 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 26 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 25 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 13 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

SELECT SQL_NO_CACHE v.*,vl.*,f.bExlusive
FROM ps_feature_value v
join ps_feature f using(id_feature)
LEFT JOIN ps_feature_value_lang vl using(id_feature_value)
WHERE v.id_feature = 24 AND vl.id_lang = 1
AND (v.custom IS NULL OR v.custom = 0)
ORDER BY vl.value ASC

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 6598606)

SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8

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

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 3194)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 5517903)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 4518831)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 4950)

SELECT SQL_NO_CACHE distinct o.id_order FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1 AND od.product_id in(0)
order by o.id_order desc

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 2959380)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 6595362)

SELECT SQL_NO_CACHE * FROM ps_catdata WHERE licence_plate = ''

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "homeslider" LIMIT 1

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 4432832)

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, product_attribute_shop.`ecotax` AS attribute_ecotax
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` = 6594917)

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

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 1247 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_insuroption_cart`
WHERE (id_cart = 0)

SELECT SQL_NO_CACHE *
FROM `ps_insuroption_cart`
WHERE (id_cart = 0)

SELECT SQL_NO_CACHE * FROM ps_catdata WHERE licence_plate = ''

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 AND c.`deleted` = 0 LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_catdata WHERE licence_plate = ''

SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
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

SELECT SQL_NO_CACHE id_manufacturer,name, nbVentes,concat('/e/equipementier-auto?idManufacturer=',id_manufacturer) as url FROM pop_manufacturer
ORDER BY nbVentes DESC
LIMIT 43

SELECT SQL_NO_CACHE * FROM ps_catdata WHERE licence_plate = ''

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

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(1,4,17,18) AND `id_shop` = 1

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` = 1239) LIMIT 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 5517903
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

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` = 1247) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 1239 AND `id_shop` = 1

SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "categoryType"
OR m.page = "categorytype"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 3194
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

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` = 1238) LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4518831 LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 3194 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 1238 AND `id_shop` = 1

SELECT SQL_NO_CACHE id_supplier as id, 
name, 
si.delivery_delay, 
si.min_amount_franco as minAmountFranco, 
si.express_price,
si.min_amount_order as minAmountOrder, 
si.delay_max_order as delayMaxOrder,
si.cut_offs, si.cut_off_friday_subtract, 
IF(cut_off_alert_delay is null,0,cut_off_alert_delay ) as cut_off_alert_delay
FROM ps_supplier s
LEFT JOIN ps_supplier_info si ON (s.id_supplier = si.supplier_id)
WHERE s.id_supplier = 40

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4950 LIMIT 1

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)

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 4950
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 4518831
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

SELECT SQL_NO_CACHE id_supplier as id, 
name, 
si.delivery_delay, 
si.min_amount_franco as minAmountFranco, 
si.express_price,
si.min_amount_order as minAmountOrder, 
si.delay_max_order as delayMaxOrder,
si.cut_offs, si.cut_off_friday_subtract, 
IF(cut_off_alert_delay is null,0,cut_off_alert_delay ) as cut_off_alert_delay
FROM ps_supplier s
LEFT JOIN ps_supplier_info si ON (s.id_supplier = si.supplier_id)
WHERE s.id_supplier = 40

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(81,82,83,84) AND `id_shop` = 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 5517903 LIMIT 1

SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 6595362 LIMIT 1

SELECT SQL_NO_CACHE id_supplier as id, 
name, 
si.delivery_delay, 
si.min_amount_franco as minAmountFranco, 
si.express_price,
si.min_amount_order as minAmountOrder, 
si.delay_max_order as delayMaxOrder,
si.cut_offs, si.cut_off_friday_subtract, 
IF(cut_off_alert_delay is null,0,cut_off_alert_delay ) as cut_off_alert_delay
FROM ps_supplier s
LEFT JOIN ps_supplier_info si ON (s.id_supplier = si.supplier_id)
WHERE s.id_supplier = 40

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(7,8,19,20) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(3,6,21,22) AND `id_shop` = 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 6598606
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 6594917
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

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

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4432832 LIMIT 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 2959380
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_banner" LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 2959380 LIMIT 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 4432832
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

SELECT SQL_NO_CACHE psgdprl.message FROM `ps_psgdpr_consent` psgdpr
LEFT JOIN ps_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 95 AND psgdprl.id_lang =1 LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 6598606 LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 6594917 LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(205,206,207,208) AND `id_shop` = 1

SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 6595362
AND DATEDIFF("2025-10-09 00:00:00", product_shop.`date_add`) < 20 LIMIT 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(113,114,115,116) AND `id_shop` = 1

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

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(33,34,35,36) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(2,5,23,24) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(13,14,29,30) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(53,54,55,56) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(57,58,59,60) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(45,46,47,48) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(173,174,175,176) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(209,210,211,212) AND `id_shop` = 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=5517903

SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC

SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(9,10,25,26) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(15,16,31,32) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(69,70,71,72) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(85,86,87,88) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(89,90,91,92) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(117,118,119,120) AND `id_shop` = 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=6594917

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(61,62,63,64) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(11,12,27,28) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(65,66,67,68) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(73,74,75,76) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(93,94,95,96) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(41,42,43,44) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(201,202,203,204) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(189,190,191,192) AND `id_shop` = 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=4950

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

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(49,50,51,52) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(77,78,79,80) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(141,142,143,144) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(105,106,107,108) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(169,170,171,172) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(177,178,179,180) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(37,38,39,40) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(97,98,99,100) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(101,102,103,104) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(109,110,111,112) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(129,130,131,132) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(133,134,135,136) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(137,138,139,140) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(161,162,163,164) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(185,186,187,188) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(197,198,199,200) AND `id_shop` = 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=3194

SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(121,122,123,124) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(125,126,127,128) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(145,146,147,148) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(149,150,151,152) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(153,154,155,156) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(157,158,159,160) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(165,166,167,168) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(181,182,183,184) AND `id_shop` = 1

SELECT SQL_NO_CACHE img, type FROM `ps_fbloginblock_img`
WHERE `type` IN(193,194,195,196) AND `id_shop` = 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=4432832

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=4518831

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

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=6598606

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=2959380

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=6595362

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)

SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 3194 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 4950 LIMIT 1

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` = 1154 LIMIT 1

SELECT SQL_NO_CACHE `active`
FROM `ps_module`
WHERE `name` = "ps_mbo" LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 4518831 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1

SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 1247) LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3194 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ets_extraoptions" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockbanner" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 53) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 53

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 4432832 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2959380 LIMIT 1

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` = 2174 LIMIT 1

SELECT SQL_NO_CACHE ext_id FROM mod_vehicules_types WHERE type_id = '1977' LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 6595362 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 6598606 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4950 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1

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` = 1411 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 3194

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 3194

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4518831 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `active`
FROM `ps_module`
WHERE `name` = "ps_mbo" LIMIT 1

SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "psgdpr" LIMIT 1

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` = 1390 LIMIT 1

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` = 1352 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2959380 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1

SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1

SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field

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` = 1103 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 6595362 LIMIT 1

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` = 1701 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 6598606 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 6594917 LIMIT 1

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` = 1576 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4432832 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 940 LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5517903 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo,id_next_supplier FROM ps_stock_dispo_gs
WHERE 4950 = id_product

SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ybc_blog" LIMIT 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 6594917 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 2 LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5517903 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 4950

SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 705 LIMIT 1

SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 532 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 4950

SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1

SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 626 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 4432832

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 4518831

SELECT SQL_NO_CACHE stock_dispo,id_next_supplier FROM ps_stock_dispo_gs
WHERE 3194 = id_product

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 2959380

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 4 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 6594917

SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 95 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 5517903

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 6595362

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 6598606

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 14 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_imageslider" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4950 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3194 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo,id_next_supplier FROM ps_stock_dispo_gs
WHERE 3194 = id_product

SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 40 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2959380 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 570 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5517903 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4432832 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4518831 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo,id_next_supplier FROM ps_stock_dispo_gs
WHERE 4950 = id_product

SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 6598606 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 6594917 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 537 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 6595362 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 6594917

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 2959380

SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 4518831

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 5517903

SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 394 LIMIT 1

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 4432832

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 6595362

SELECT SQL_NO_CACHE stock_dispo, stock_verrouille FROM ps_stock_dispo_gs WHERE id_product = 6598606