Radium Engineering 

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 2056 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 1895 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 72373 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 664 GROUP BY product_shop.id_product

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

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

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

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 128 AND c.nright >= 129)
ORDER BY c.nleft

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 76787 GROUP BY product_shop.id_product

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

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 250922 GROUP BY product_shop.id_product

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 <= 5200
AND c.nright >= 5217
AND c.nleft >= 2
AND c.nright <= 8461
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 252179 GROUP BY product_shop.id_product

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

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 6976 AND c.nright >= 6977)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 6801 AND c.nright >= 6802)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 6801 AND c.nright >= 6802)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 6923 AND c.nright >= 6924)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 6923 AND c.nright >= 6924)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 1996 AND c.nright >= 1997)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 1610 AND c.nright >= 1611)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 1994 AND c.nright >= 1995)
ORDER BY c.nleft

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 1599 AND c.nright >= 1600)
ORDER BY c.nleft

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 7020 AND c.nright >= 7023)
ORDER BY c.nleft

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246042 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246560 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 248797 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 7558 AND c.nright >= 7559)
ORDER BY c.nleft

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 116951 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 76093 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 248253 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 75917 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 245299 GROUP BY product_shop.id_product

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

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 245860 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 21121 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 20128 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 56903 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246177 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 1663 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 262726 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 18979 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 1664 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 263584 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246428 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 21521 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 39700 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 69030 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 8537 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 248270 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 245824 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 264768 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 264769 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 18932 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 248972 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 62285 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 19657 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 264974 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246121 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246178 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 7686 AND c.nright >= 7687)
ORDER BY c.nleft

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246179 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 26126 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 7696 AND c.nright >= 7697)
ORDER BY c.nleft

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 69029 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 263535 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 246122 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 527 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 262940 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 1482 GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.description, pl.description_short, pl.available_now,
pl.available_later, pl.link_rewrite, pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name, MAX(image_shop.id_image) id_image,
il.legend, m.name AS manufacturer_name, cl.name AS category_default,
DATEDIFF(product_shop.date_add, DATE_SUB(NOW(),
INTERVAL 20
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM ps_category_product cp
LEFT JOIN ps_product p
ON p.id_product = cp.id_product
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_product_attribute pa
ON (p.id_product = pa.id_product)
LEFT 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 AND product_attribute_shop.default_on = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN ps_category_lang cl
ON (product_shop.id_category_default = cl.id_category
AND cl.id_lang = 1 AND cl.id_shop = 1 )
LEFT JOIN ps_product_lang pl
ON (p.id_product = pl.id_product
AND pl.id_lang = 1 AND pl.id_shop = 1 )
LEFT JOIN ps_image i
ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN ps_image_lang il
ON (image_shop.id_image = il.id_image
AND il.id_lang = 1)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE product_shop.id_shop = 1
AND p.id_product = 17627 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 *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 7772 AND c.nright >= 7773)
ORDER BY c.nleft

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 4181 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,24

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

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC

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

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 92 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,0

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 180 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,0

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 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, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 72373) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 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, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 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, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 56903) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 128 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,0

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` = 2056
ORDER BY `position`

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 180 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,0

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 2207 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,0

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 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, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 21121) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 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, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 140 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,0

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-03-11 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 127 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,0

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 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, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 262940) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 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, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 245299) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-03-11 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1