Voopoo

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7441|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7442|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5368|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5126|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5369|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4959|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6352|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4215|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5983|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5984|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6481|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5359|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5501|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5738|1|1%"

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6732|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4217|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6731|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|2905|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7041|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5434|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5309|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5596|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|3855|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4960|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|2869|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|2301|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5220|1|1%"

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,
pl.*,  image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-12-04 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 359 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`date_add` DESC
LIMIT 0,80

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|3944|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4132|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|3979|1|1%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|3980|1|1%"

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,
pl.*,  image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-12-04 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 359 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`date_add` DESC
LIMIT 0,80

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 `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 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 (7464,7463,7462,7461,7460,7459,7458,7457,7456,7455,7442,7441,7440,7155,7078,7041,7027,6735,6732,6731,6481,6352,5984,5983,5980,5738,5596,5501,5434,5383,5368,5369,5362,5359,5309,5224,5220,5212,5126,4960,4958,4959,4293,4217,4215,4132,3980,3979,3944,3855,2905,2869,2702,2301) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;

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 (7464,7463,7462,7461,7460,7459,7458,7457,7456,7455,7442,7441,7440,7155,7078,7041,7027,6735,6732,6731,6481,6352,5984,5983,5980,5738,5596,5501,5434,5383,5368,5369,5362,5359,5309,5224,5220,5212,5126,4960,4958,4959,4293,4217,4215,4132,3980,3979,3944,3855,2905,2869,2702,2301) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, hm.`id_hook_behavior`, 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`

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, hm.id_hook_behavior, 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

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5126 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE ffve.id_feature_value,
ffvel.description
FROM
ps_fs_feature_values_extend AS ffve
INNER JOIN
ps_fs_feature_values_extend_lang AS ffvel ON (ffve.id_fs_feature_values_extend = ffvel.id_fs_feature_values_extend)
WHERE
ffvel.id_shop = "1" AND
ffvel.id_lang = "1"

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.nleft >= 337
AND c.nright <= 338
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")

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7461 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

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

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 4960 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7463 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7464 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 6481 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7455 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7078 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5980 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7462 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 6731 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7457 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7459 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5212 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5383 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7456 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7155 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7442 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5596 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7458|1|1","", FROM_UNIXTIME(1733338449))

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6481) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 25859) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 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

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 4132 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5434 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5983 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 4960 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5984 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 6735 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5984 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7155 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5362 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7441 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 6732 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7458 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5501 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 4958 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 6352 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 5369 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7027 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_av_products_average WHERE ref_product = 7440 and iso_lang in ("fr") and id_shop IN(0,1) LIMIT 1