TABLE ÉLECTRIQUE 3 PLANS, 3 MOTEURS, DOSSIER PROCLIVE / DÉCLIVE, PORTE-ROULEAUX, BOUCHON FACIAL ET ROULETTES RÉTRACTABLES

SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 485
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` 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 DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
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` = 485

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 485
AND a.`id_attribute` NOT IN(38, 228, 227, 226, 225, 224, 223, 222, 221, 220, 219, 218, 217, 216, 215, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199, 198, 197, 196, 195, 194, 193, 27, 37, 92, 32, 90, 25, 192, 191, 190, 189, 188, 187, 186, 185, 184, 183, 182, 88, 28, 26, 29, 89, 35, 33, 91, 31, 36, 84, 34, 181, 229)

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (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 product_attribute_shop.default_on = 1  AND pa.id_product = 485 LIMIT 1

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-24 00:00:00",
INTERVAL 90 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 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 (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
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_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 (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 485 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product

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

SELECT SQL_NO_CACHE pa.`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` = 485
AND product_attribute_shop.default_on = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 485

SELECT SQL_NO_CACHE pa.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` = 485

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` = 13
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (233749, 233748, 233747, 233746, 233745, 233744, 233743, 233742, 233741, 233740, 233739, 233738, 233737, 233736, 233735, 233734, 233733, 233732, 233731, 233730, 233729, 233728, 233727, 233726, 233725, 233724, 233723, 233722, 233721, 233720, 233719, 233718, 233717, 233716, 233715, 233714, 233625, 233624, 233623, 233622, 233621, 233713, 233712, 233711, 233710, 233709, 233708, 233707, 233706, 233705, 233704, 233703, 233702, 233701, 233700, 233699, 233698, 233697, 233696, 233695, 233694, 233693, 233692, 233691, 233690, 233689, 233688, 233687, 233686, 233685, 233684, 233683, 233682, 233681, 233680, 233679, 233678, 233677, 233676, 233675, 233674, 233673, 233672, 233671, 233670, 233669, 233668, 233667, 233666, 233665, 233664, 233663, 233662, 233661, 233660, 233659, 233658, 233657, 233656, 233655, 233654, 233653, 233652, 233651, 233650, 233649, 233648, 233647, 233646, 233645, 233644, 233643, 233642, 233641, 233640, 233639, 233638, 233637, 233636, 233635, 233634, 233633, 233632, 233631, 233630, 233629, 233628, 233627, 233626, 233620, 233750, 233751) AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233750)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 485
ORDER BY `position`

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233697)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC 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
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` = 17)

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233705)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233722)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233695)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233701)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233743)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233745)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233724)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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 = 485
ORDER BY f.position ASC

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233685)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233687)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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` = 0 AND `id_customer` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-24 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233686)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233742)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233741)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233717)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233725)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233734)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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 = 27
ORDER BY f.position ASC

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233703)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233732)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233693)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233718)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233735)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233728)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233679)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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 = 17
ORDER BY f.position ASC

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 = 17 LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233689)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233704)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233721)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233691)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC 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` = 17) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233730)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233694)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233737)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233746)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233700)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233729)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233731)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233696)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC 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` = 27) AND (b.`id_shop` = 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 = 485 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)
WHERE p.id_product = 485
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-01-24 00:00:00",
INTERVAL 90 DAY
)
) > 0

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

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233702)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233684)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`)
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 )
WHERE p.`id_product` = 485
AND l.`active` = 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233733)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233740)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233723)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 485
AND image_shop.`cover` = 1 LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233699)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

INSERT INTO `ps_blockips_pages`(ip, id_shop, page, user_agent) VALUES('18.97.9.174', '1', 'https://www.latabledexamen.com/tables-d-examen-de-massage/485-table-electrique-3-plans-3-moteurs-dossier-proclive-declive-porte-rouleaux-bouchon-facial-et-roulettes-retractables-3663647107609.html?srsltid=AfmBOopt0hoYmaa6-AIRsXXlrT8IIXgqLawq5VkpICHUPRrHJJpOw5hW', 'CCBot/2.0 (https://commoncrawl.org/faq/)')

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233744)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233698)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC 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
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` = 27)

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233736)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233632)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233726)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233629)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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 <= 3
AND c.nright >= 34
AND c.nleft >= 2
AND c.nright <= 275
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC

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

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233720)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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)
WHERE pa.id_product = 485

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233683)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233682)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233681)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233680)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233628)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233727)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233633)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233738)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233631)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233688)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233716)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233692)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233630)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233627)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233622)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233712)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC 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 product_attribute_shop.default_on = 1  AND pa.id_product = 17 LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='blocktopmenu/1/1/1/21/product/485/59/ca/9b/59ca9b071831744ee6cdc2463b005e188e07f580.blocktopmenu.tpl.php'
WHERE `template_hash`='6255e1a65eec35b85b477c3adec3a25b' AND cache_id="blocktopmenu|1|1|1|21|product|485" AND compile_id=""

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233709)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233707)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_steavisgarantis_average_rating WHERE product_id='485' and id_lang='1' LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233714)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_blockips` WHERE ip = '18.97.9.174' AND id_shop = '1' LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='14e2cab5736b3cb510ab77f2d2151600' AND cache_id="displayFooterProduct2025-01-24 18|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233751)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "category"
AND pspco.`id_object` IN (2,13,22,37,97,102,113)
AND pspco.`id_product_attribute` IN (0, 0)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233624)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC 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`=485

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233659)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1

UPDATE `ps_blockips` SET last_date = '2025-01-24 18:56:03', nbr_pages = nbr_pages+1, id_customer = '', id_guest = '' WHERE ip = '18.97.9.174' AND id_shop = '1'

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233749)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233640)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 1
AND pl.id_product = 485
AND product_shop.active = 1 LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 485) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233647)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233620)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233739)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233690)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 485
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233626)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233650)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='52a017a5d1c3aeb2561790ab927e3c9e' AND cache_id="blockcategories|1|1|1|21|13|1" AND compile_id="" LIMIT 1

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)
WHERE pa.id_product = 17

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233638)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233637)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233634)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233677)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233747)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233643)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='68098216fdb7248b7f27f630a67611eb' AND cache_id="blockbanner|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 485 AND ctg.`id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233645)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233669)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='6598b4b77b80ac12ec33455508725188' AND cache_id="blockmyaccountfooter|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233636)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233674)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233635)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233639)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 20363
AND `date_add` > '2025-01-24 18:26:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233664)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233623)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233672)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233621)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233649)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233656)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233719)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ae4ad706089da68e971763e786de0de3' AND cache_id="blockcms|2|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='db9b2f097ed1c5352fe05002ea63a524' AND cache_id="blockcontactinfos|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233675)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233625)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233660)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233646)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233642)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233648)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233663)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('20363', '464', '308349358', '', '1', '1', '2025-01-24 18:56:09')

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233708)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233644)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233665)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233715)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233641)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233673)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233654)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233748)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='socialsharing_header/485/1/1/1/21/f9/f5/f3/f9f5f31f0afdedf3ad216a69b51a629112620808.socialsharing_header.tpl.php'
WHERE `template_hash`='b820a1d3e68c1f250a88cf400bc0c526' AND cache_id="socialsharing_header|485|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233651)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233667)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233678)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233653)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233666)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233670)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233711)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233713)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233671)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233661)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 17) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233662)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('b820a1d3e68c1f250a88cf400bc0c526',"socialsharing_header|485|1|1|1|21","", FROM_UNIXTIME(1737741362))

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233706)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2e5750c059aeb0cc92764aa125b2289b' AND cache_id="productpaymentlogos|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 485

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233676)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233668)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4f8e36729a62f7aa69131aae65957efa' AND cache_id="socialsharing|485|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233655)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='655c99e0b6adbbe521a70b0c20475a1b' AND cache_id="blocksearch-top|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233657)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233710)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233658)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 27) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1

SELECT SQL_NO_CACHE np.`id_prestablog_news`
FROM `ps_prestablog_news_product` np
LEFT JOIN `ps_prestablog_news` n ON (np.`id_prestablog_news` = n.`id_prestablog_news`)
WHERE np.`id_product` = 485
ORDER BY n.`date` DESC

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

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 17
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 485 AND `id_shop` = 1

SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (485)
AND pspco.`id_product_attribute` IN (0, 233652)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1

SELECT SQL_NO_CACHE rate FROM ps_steavisgarantis_average_rating WHERE product_id='485' and id_lang='1' LIMIT 1

SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 485) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE id_address_delivery
FROM `ps_cart`
WHERE (id_cart="0") LIMIT 1

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='6255e1a65eec35b85b477c3adec3a25b' AND cache_id="blocktopmenu|1|1|1|21|product|485" AND compile_id="" 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 = 27 LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('4f8e36729a62f7aa69131aae65957efa',"socialsharing|485|1|1|1|21","", FROM_UNIXTIME(1737741365))

SELECT SQL_NO_CACHE count(*) FROM ps_steavisgarantis_reviews WHERE product_id='485' and id_lang='1' LIMIT 1

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

UPDATE `ps_smarty_lazy_cache`
SET filepath='socialsharing/485/1/1/1/21/29/b9/3d/29b93db67fc6d6ed7932d7582d5df5cc64369419.socialsharing.tpl.php'
WHERE `template_hash`='4f8e36729a62f7aa69131aae65957efa' AND cache_id="socialsharing|485|1|1|1|21" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('b820a1d3e68c1f250a88cf400bc0c526',"socialsharing_header|485|1|1|1|21","", FROM_UNIXTIME(1737741362))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b820a1d3e68c1f250a88cf400bc0c526' AND cache_id="socialsharing_header|485|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 2 AND `id_object` = 485 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` = 13 LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 13
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 17) AND (id_product_attribute = 215825) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('6255e1a65eec35b85b477c3adec3a25b',"blocktopmenu|1|1|1|21|product|485","", FROM_UNIXTIME(1737741364))

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

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 27
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE `id_product_download`
FROM `ps_product_download`
WHERE `id_product` = 485
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1

SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 13 LIMIT 1

SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 485) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('4f8e36729a62f7aa69131aae65957efa',"socialsharing|485|1|1|1|21","", FROM_UNIXTIME(1737741365))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('6255e1a65eec35b85b477c3adec3a25b',"blocktopmenu|1|1|1|21|product|485","", FROM_UNIXTIME(1737741364))

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