Hardcover Book - Square
Please login to order this product.

Hardcover Book - Square

This template lets you impose your style and express your creativity with freedom, as you can customize the full design of the cover, spine and back cover. Characterized by the all-in-one cover, it has a high quality finish and durability to suit every occasion, showcasing the versatility of your presentation.

Product Details

You should attach the photo to the cover according to the model available in the cover templates downloads area, taking into account the size and number of sheets. In order to speed up production, Hardcover Book printing can be done in Silk or Lustre when you select the Indifferent Paper Type.

  • 250 char. max
  • 250 char. max

Format

  •
  • 250 char. max
  • 250 char. max
No. Spreads
Paper Type
Size

Terá de ter acessórios

Atributos Books Capa Rígida - Quadrado
Atributos Books Capa Rígida - Quadrado
€0.00

Complete your order

Bestbox Wood

Bestbox Wood

Personalize
Silver 26 Green Water 602 620 Silver 06 Black 7705 Navy Blue 941 Beige 02 Natural 402 Black D01 White Black 02 Black Green 603 Aqua 03 White 619 Beige 07 Grey 7703 Blue 408 Brown 05 Brown 624 Dark Grey 09 Brown Dark Grey 5950 Brown 04 Grey 470 Camel 08 Grey 625 Light Grey ST27 Golden Grey 4810 Grey Purple 700 Olive Golden 08 Pearl White 7704 Black 802 Petal 16 Caramel Bronze 09 Baby Blue 421 Green 10 Blue 250 White D03 Silver Navy Blue 4690 Beige 03 Grey 804 Fossil 22 Green Water 156 Pink 261 Dark Brown D03 Blue 5840 Green 405 Green 247 Brown ST09 Baby Blue 5701 White 01 Blue Beige 902 Cookie 28 Pink Burgundy ST17 Brown 5250 Navy Blue 14 Light Grey 16 Brown 705 Red 05 Red 5430 Yellow ST14 Orange 4100 Dark Grey 17 Beige 071 Beige 18 Yellow 4090 Black 18 Green 16 Baby Pink 5390 Salmon 409 Navy Blue ST26 Dark Green 4170 Yellow 126 Old Blue ST 21 Green 4150 Light Lilac 422 Turquoise 17 Green Water 5220 Old Pink ST 08
Bestbox White

Bestbox White

Personalize
Black 02 620 Green Water 602 Beige 02 Silver 06 Black 7705 Navy Blue 941 Black Black D01 Silver 26 White Natural 402 Brown Brown 624 Aqua 03 Brown 04 White 619 Dark Grey 5950 Green 603 Brown 05 Beige 07 Grey 7703 Blue 408 Dark Grey 09 Grey 470 Grey 4810 Grey Light Grey ST27 Golden Grey 625 Olive Purple 700 Camel 08 Golden 08 Pearl White 7704 Caramel Black 802 Green 10 Bronze 09 Baby Blue 421 Navy Blue 4690 White D03 Silver Blue 250 Petal 16 Pink 261 Fossil 22 Grey 804 Beige 03 Green Water 156 Blue 5840 Dark Brown D03 White 01 Green 405 Baby Blue 5701 Brown ST09 Blue Green 247 Cookie 28 Beige 902 Brown 5250 Burgundy ST17 Navy Blue 14 Pink Brown 705 Red 5430 Red 05 Light Grey 16 Orange 4100 Yellow ST14 Dark Grey 17 Beige 071 Yellow 4090 Beige 18 Black 18 Baby Pink 5390 Green 16 Salmon 409 Dark Green 4170 Navy Blue ST26 Yellow 126 Green 4150 Old Blue ST 21 Light Lilac 422 Green Water 5220 Turquoise 17 Old Pink ST 08
cached
Load Time212 ms - Unicorn powered webserver!
Querying Time119 ms
Queries637
Memory Peak Usage25.8 Mb
Included Files538 files - 7.91 Mb
PrestaShop Cache- Mb
Global vars0.45 Mb
PrestaShop Version1.7.5.1
PHP Version7.0.33 (Consider upgrading)
MySQL Version10.6.19-MariaDB (OK)
Memory Limit4096M
Max Execution Time16384s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 20 ms 20 ms 4.05 Mb 4.07 Mb
__construct 0 ms 20 ms - Mb 4.07 Mb
init 19 ms 39 ms 2.71 Mb 6.83 Mb
checkAccess 0 ms 39 ms - Mb 6.83 Mb
setMedia 2 ms 41 ms 0.08 Mb 7.35 Mb
postProcess 0 ms 41 ms - Mb 7.35 Mb
initHeader 0 ms 41 ms - Mb 7.35 Mb
initContent 35 ms 76 ms 2.97 Mb 9.96 Mb
initFooter 0 ms 76 ms - Mb 9.96 Mb
display 137 ms 212 ms 15.46 Mb 25.80 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 637 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
 6.8 15889 /classes/SpecificPrice.php:283 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-06 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 533
 5.3 150 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-06 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 531
 5.2 148 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-06 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 498
 3.9 28 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (533) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.2 594 Yes Yes /override/classes/Product.php:3942 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (531) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.2 594 Yes Yes /override/classes/Product.php:3942 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (533) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.2 594 Yes Yes /override/classes/Product.php:3942 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (531) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.2 594 Yes Yes /override/classes/Product.php:3942 
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`)
 1.6 2833 /classes/Configuration.php:160 
SELECT SQL_NO_CACHE pa.`id_product_attribute`,
pa.`id_product`,
stock.`quantity` AS `stock_available`,
stock.`out_of_stock`,
GROUP_CONCAT( DISTINCT CONCAT(ag.`id_attribute_group`, ":" , a.`id_attribute`) SEPARATOR "-") AS `id_attributes`, GROUP_CONCAT( DISTINCT CONCAT( al.`name`) ORDER BY agl.`public_name`, al.`name` SEPARATOR " - ") AS `name` 
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN
`ps_product_attribute_shop` pas
ON
pas.`id_product_attribute` = pa.`id_product_attribute`
AND pas.`id_shop` = 1
LEFT JOIN
`ps_product_attribute_combination` pac
ON
pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN
`ps_attribute` a
ON
a.`id_attribute` = pac.`id_attribute`
LEFT JOIN
`ps_attribute_group` ag
ON
ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN
`ps_attribute_lang` al
ON
a.`id_attribute` = al.`id_attribute`
AND al.`id_lang` = 4
LEFT JOIN
`ps_attribute_group_lang` agl
ON
ag.`id_attribute_group` = agl.`id_attribute_group`
AND agl.`id_lang` = 4
INNER JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE
pa.`id_product` IN (248)
AND stock.`id_product_attribute` = pa.`id_product_attribute`
GROUP BY
pa.`id_product`, pa.`id_product_attribute`
ORDER BY  `name` ASC
 1.4 100 Yes /modules/hsmultiaccessoriespro/abstract/classes/HsMaProduct.php:175 
SELECT SQL_NO_CACHE DISTINCT apg.`id_accessory_group`,
apg.`id_accessory`,
apg.`default_quantity`,
apg.`min_quantity`,
apg.`required`,
apg.`position`,
pl.`link_rewrite`,
pl.`description_short`,
pl.`available_later`,
p.`id_product` AS `id_product`,
p.`is_virtual`,
stock.`quantity` AS `stock_available`,
stock.`out_of_stock`,
apg.`id_accessory_group_product`,		
apg.`id_product_attribute`,
i.`id_image`,
IF(`is`.`id_image`, `is`.`id_image`, i.`id_image`) `id_image`                    
FROM
`ps_accessory_group_product` apg INNER JOIN `ps_product` p ON (p.`id_product` = apg.`id_accessory` AND p.active =1)LEFT JOIN
`ps_product_lang` pl ON (pl.`id_product` = apg.`id_accessory` AND pl.`id_shop` = 1 AND pl.`id_lang` = 4)
LEFT JOIN
`ps_accessory_group_product_lang` agpl ON (agpl.`id_accessory_group_product` = apg.`id_accessory_group_product`  AND agpl.`id_lang` = 4)
LEFT JOIN
`ps_image` i ON (i.`id_product` = apg.`id_accessory` AND `i`.`cover` = 1)
LEFT JOIN
`ps_image_shop` `is` ON ( `is`.`id_image` = i.`id_image` AND `is`.id_shop = 1 AND `is`.`cover` = 1)
LEFT JOIN
`ps_image_lang` il ON (il.`id_image` = i.`id_image`  AND il.`id_lang` = 4)
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  )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)    
WHERE
apg.`id_accessory_group` IN (3,4,1,2) AND apg.`id_product` IN(245) AND p.`id_product` NOT IN (245) AND p.`visibility` != 'none'
GROUP BY
apg.`id_accessory_group`,
apg.`id_accessory`
ORDER BY apg.`position` ASC
 0.7 337 Yes Yes /modules/hsmultiaccessoriespro/abstract/classes/HsAccessoriesGroupAbstract.php:587 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_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` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 0.6 152 Yes Yes /classes/Hook.php:666 
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 4)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
 0.6 244 Yes /classes/Country.php:147 
SELECT SQL_NO_CACHE DISTINCT prp.`id_product`, p.`reference`, pl.`name`, p.`active`
FROM `ps_product_related_pro` prp
LEFT JOIN `ps_product` p ON (prp.`id_product` = p.`id_product`)
LEFT JOIN
`ps_product_lang` pl
ON (
pl.id_product = p.id_product AND pl.`id_lang` = 4
AND pl.`id_shop` = 1
)
WHERE p.`active` = 1 AND prp.`id_shop` = 1
AND prp.`id_related` = 245
AND prp.`id_product` NOT IN (
SELECT
`id_related`
FROM
`ps_product_related_pro`
WHERE `id_product` = 245
)
ORDER BY prp.`position` ASC
 0.6 2452 Yes /modules/relatedproductpro/classes/RelatedProductProModel.php:118 
UPDATE ps_sfkseoschema SET sfk_product_viewcount = '10843' WHERE sfk_product='245'
 0.6 1 /modules/sfkseoschema/sfkseoschema.php:411 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 0.5 448 /classes/SpecificPrice.php:283 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-10-06 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 4)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 245 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.5 1 Yes /override/classes/Product.php:4085 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, 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
 0.5 353 /classes/Hook.php:403 
SELECT SQL_NO_CACHE pa.`id_product_attribute`,
stock.`quantity` AS `stock_available`,
stock.`out_of_stock`,
GROUP_CONCAT( DISTINCT CONCAT(ag.`id_attribute_group`, ":" , a.`id_attribute`) SEPARATOR "-") AS `id_attributes`, GROUP_CONCAT( DISTINCT CONCAT( al.`name`) ORDER BY agl.`public_name`, al.`name` SEPARATOR " - ") AS `name` 
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN
`ps_product_attribute_shop` pas
ON
pas.`id_product_attribute` = pa.`id_product_attribute`
AND pas.`id_shop` = 1
LEFT JOIN
`ps_product_attribute_combination` pac
ON
pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN
`ps_attribute` a
ON
a.`id_attribute` = pac.`id_attribute`
LEFT JOIN
`ps_attribute_group` ag
ON
ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN
`ps_attribute_lang` al
ON
a.`id_attribute` = al.`id_attribute`
AND al.`id_lang` = 4
LEFT JOIN
`ps_attribute_group_lang` agl
ON
ag.`id_attribute_group` = agl.`id_attribute_group`
AND agl.`id_lang` = 4
INNER JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE
pa.`id_product` = 245
AND stock.`id_product_attribute` = pa.`id_product_attribute`
GROUP BY
pa.`id_product`, pa.`id_product_attribute`
ORDER BY  `name` ASC
 0.4 2 Yes /modules/hsmultiaccessoriespro/abstract/classes/HsMaProduct.php:101 
SHOW TABLES LIKE '%psblog_blog%'
 0.4 1 /modules/psblog/psblog.php:44 
SELECT SQL_NO_CACHE * FROM ps_sfkseoschema WHERE sfk_status = 1 AND FIND_IN_SET('4', `sfk_language`) AND FIND_IN_SET('1', `sfk_shop`) AND sfk_product = 245 LIMIT 0,1
 0.4 531 /modules/sfkseoschema/sfkseoschema.php:360 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (84943, 84944, 84945, 84946, 84947, 84948, 84949, 84950, 84951, 84952, 84953, 84954, 84955, 84956, 84957, 84958, 84959, 84960, 84961, 84962, 84963, 84964, 84965, 84966, 84967, 84968, 84969, 84970, 84971, 84972, 84973, 84974, 84975, 84976, 84977, 84978, 84979, 84980, 84981, 84982, 84983, 84984, 84985, 84986, 84987, 84988, 84989, 84990, 84991, 84992, 84993, 84994, 84995, 84996, 84997, 84998, 84999, 85000, 85001, 85002, 85003, 85004, 85005, 85006, 85007, 85008, 85009, 85010, 85011, 85012, 85013, 85014, 85015, 85016, 85017, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85034, 85035, 85036, 85037, 85038, 85039, 85040, 85041, 85042, 85045, 85046, 85047, 85048, 85049, 85050, 85051, 85052, 85053, 85054, 85055, 85056, 85057, 85058, 85059, 85060, 85061, 85062, 85063, 85064, 85065, 85066, 85067, 85068, 85069, 85070, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85091, 85092, 85093, 85094, 85095, 85096, 85104, 85105, 85108, 85110, 85111, 85112, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85120, 85121, 85122, 85123, 85124, 85125, 85126, 85127, 85128, 85129, 85130, 85131, 85132, 85133, 85134, 85135, 85136, 85137, 85138, 85139, 85140, 85141, 85142, 85143, 85144, 85148, 85149, 85150, 85151, 85152, 85153, 85154, 85155, 85156, 85157, 85158, 85159, 85160, 85161, 85162, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85171, 85172, 85173, 85174, 85175, 85176, 85177, 85178, 85179, 85180, 85181, 85182, 85183, 85184, 85185, 85186, 85187, 85188, 85189, 85190, 85191, 85192, 85193, 85194, 85195, 85196, 85197, 85198, 85199, 85200, 85201, 85202, 85203, 85204, 85205, 85206, 85207, 85208, 85225, 85226, 85227, 85228, 85229, 85230, 85231, 85232, 85233, 85234, 85235, 85236, 85237, 85238, 85239, 85240, 85241, 85242, 85243, 85244, 85245, 85246, 85247, 85248, 85249, 85250, 85251, 85252, 85253, 85254, 85255, 85256, 85257, 85258, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85267, 85268, 85269, 85270) AND il.`id_lang` = 4 ORDER by i.`position`
 0.4 297 Yes /override/classes/Product.php:2488 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=245
 0.4 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
 0.3 448 /classes/SpecificPrice.php:291 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (84572, 84573, 84574, 84575, 84576, 84577, 84578, 84579, 84580, 84581, 84582, 84583, 84584, 84585, 84586, 84587, 84588, 84589, 84590, 84591, 84592, 84593, 84594, 84595, 84596, 84597, 84598, 84599, 84600, 84601, 84602, 84603, 84604, 84605, 84606, 84607, 84608, 84609, 84610, 84611, 84612, 84613, 84614, 84615, 84616, 84617, 84618, 84619, 84620, 84621, 84622, 84623, 84624, 84625, 84626, 84627, 84628, 84629, 84630, 84631, 84632, 84633, 84634, 84635, 84636, 84637, 84638, 84639, 84640, 84641, 84642, 84643, 84644, 84645, 84646, 84647, 84648, 84649, 84650, 84651, 84652, 84653, 84654, 84655, 84656, 84657, 84658, 84659, 84660, 84661, 84662, 84663, 84671, 84672, 84675, 84677, 84678, 84679, 84680, 84681, 84682, 84683, 84684, 84685, 84686, 84687, 84688, 84689, 84690, 84691, 84692, 84693, 84694, 84695, 84696, 84697, 84698, 84699, 84700, 84701, 84702, 84703, 84704, 84705, 84706, 84707, 84708, 84709, 84710, 84711, 84712, 84713, 84714, 84715, 84716, 84717, 84718, 84719, 84720, 84721, 84722, 84723, 84724, 84725, 84726, 84727, 84728, 84736, 84737, 84738, 84739, 84740, 84748, 84749, 84752, 84759, 84760, 84761, 84762, 84763, 84764, 84771, 84772, 84773, 84774, 84775, 84776, 84777, 84778, 84779, 84780, 84781, 84782, 84783, 84784, 84785, 84786, 84787, 84788, 84789, 84790, 84791, 84795, 84796, 84797, 84798, 84799, 84800, 84801, 84802, 84803, 84804, 84805, 84806, 84807, 84808, 84809, 84810, 84811, 84812, 84813, 84814, 84815, 84816, 84817, 84818, 84819, 84820, 84821, 84822, 84823, 84824, 84825, 84826, 84827, 84828, 84829, 84830, 84831, 84832, 84833, 84834, 84835, 84836, 84837, 84838, 84839, 84840, 84841, 84842, 84843, 84844, 84845, 84846, 84847, 84848, 84849, 84850, 84851, 84852, 84853, 84854, 84855, 84856, 84857, 84858, 84859, 84860, 84861, 84862, 84863, 84864, 84865, 84866, 84867, 84868, 84869, 84870, 84871, 84872, 84873, 84874, 84875, 84876, 84877, 84878, 84879, 84880, 84881, 84882, 84883, 84896, 84897, 84898, 84899, 84900, 84901, 84902, 84903, 84904, 84905, 84906, 84907, 84908, 84909, 84910, 84911, 84912, 84913, 85271, 85272, 85273, 85274, 85275, 85276, 85277, 85278) AND il.`id_lang` = 4 ORDER by i.`position`
 0.3 297 Yes /override/classes/Product.php:2488 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (498) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 112 Yes Yes /override/classes/Product.php:3942 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 245
 0.3 2 /override/classes/Product.php:6285 
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
 0.3 0 /classes/Hook.php:190 
SELECT SQL_NO_CACHE cu.id_customization, cd.index, cd.value, cd.type, cu.in_cart, cu.quantity
FROM `ps_customization` cu
LEFT JOIN `ps_customized_data` cd ON (cu.`id_customization` = cd.`id_customization`)
WHERE cu.id_cart = 0
AND cu.id_product = 245 AND type = 0 AND in_cart = 0
 0.3 1 /override/classes/Cart.php:4256 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 245
AND al.`id_lang` = 4
AND agl.`id_lang` = 4
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 0.3 2 Yes Yes /override/classes/Product.php:3997 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-10-06 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 4)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 245 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.3 1 Yes /override/classes/Product.php:4085 
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` = 531)
 0.3 297 /override/classes/Product.php:3347 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76208) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.3 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE DISTINCT prp.`id_related` as `id_product`, p.`reference`, pl.`name`, p.`active`
FROM `ps_product_related_pro` prp
LEFT JOIN `ps_product` p ON (prp.id_related = p.id_product)
LEFT JOIN `ps_product_lang` pl
ON (
pl.id_product = p.id_product AND pl.`id_lang` = 4
AND pl.`id_shop` = 1
)
WHERE p.`active` = 1 AND prp.`id_shop` = 1
AND prp.`id_product` = 245
ORDER BY prp.`position` ASC
 0.3 4 Yes /modules/relatedproductpro/classes/RelatedProductProModel.php:97 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76206) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.3 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 245
AND al.`id_lang` = 4
AND agl.`id_lang` = 4
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 0.3 2 Yes Yes /override/classes/Product.php:3997 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76207) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.3 71 Yes /classes/SpecificPrice.php:549 
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` = 533)
 0.3 297 /override/classes/Product.php:3347 
SELECT SQL_NO_CACHE *
FROM `ps_attribute_group` a
LEFT JOIN `ps_attribute_group_shop` `c` ON a.`id_attribute_group` = c.`id_attribute_group` AND c.`id_shop` = 1
WHERE (a.`id_attribute_group` = 35) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76207) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.3 71 Yes /classes/SpecificPrice.php:612 
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` = 4  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 117
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.3 1 Yes Yes /override/classes/Category.php:872 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  ) WHERE product_attribute_shop.default_on = 1  AND IFNULL(stock.quantity, 0) >= 1 AND pa.id_product = 248 LIMIT 1
 0.3 50 /override/classes/Product.php:864 
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` = 4  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 117
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.3 1 Yes Yes /override/classes/Category.php:872 
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.* , m.`name` AS manufacturer_name, s.`name` AS supplier_name
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product`  AND pl.id_shop = 1 )
LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `ps_supplier` s ON (s.`id_supplier` = p.`id_supplier`)LEFT JOIN `ps_category_product` c ON (c.`id_product` = p.`id_product`)
WHERE pl.`id_lang` = 4 AND c.`id_category` = 117 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1
ORDER BY p.`id_product` asc
 0.3 3 Yes /override/classes/Product.php:1356 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.3 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.3 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76256) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.3 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.3 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.3 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.3 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76245) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.3 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE "thumb" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "gb0femkwe66k9p_digibooklab.com" AND TABLE_NAME = "ps_psblog_blog" AND COLUMN_NAME = "thumb"
 0.3 0 /modules/psblog/psblog.php:44 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76257) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76244) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 1 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76256) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76245) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 498 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 58109) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76206) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.2 102 Yes /classes/Dispatcher.php:636 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE cf.`id_customization_field`, cf.`type`, cf.`required`, cfl.`name`, cfl.`id_lang`
FROM `ps_customization_field` cf
NATURAL JOIN `ps_customization_field_lang` cfl
WHERE cf.`id_product` = 245 AND cfl.`id_lang` = 4 AND !cf.`is_module`
AND cf.`is_deleted` = 0
ORDER BY cf.`id_customization_field`
 0.2 2 /override/classes/Product.php:5413 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76244) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76208) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE `id_cart_rule` FROM `ps_accessory_product_cart_rule` WHERE `id_main_product`=245 AND `id_accessory`=248 LIMIT 1
 0.2 1 /modules/hsmultiaccessoriespro/abstract/classes/HsMaCartRule.php:203 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76253) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.* , m.`name` AS manufacturer_name, s.`name` AS supplier_name
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product`  AND pl.id_shop = 1 )
LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `ps_supplier` s ON (s.`id_supplier` = p.`id_supplier`)LEFT JOIN `ps_category_product` c ON (c.`id_product` = p.`id_product`)
WHERE pl.`id_lang` = 4 AND c.`id_category` = 117 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1
ORDER BY p.`id_product` asc
 0.2 3 Yes /override/classes/Product.php:1356 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (474) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.2 8 Yes Yes /override/classes/Product.php:3942 
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
 0.2 324 Yes /classes/Country.php:154 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *
FROM `ps_gdpr_custom_script` c
INNER JOIN `ps_gdpr_custom_script_lang` `l` ON c.id_gdpr_custom_script = l.id_gdpr_custom_script
WHERE (active = 1)
ORDER BY position ASC
 0.2 1 Yes /modules/gdprpro/src/GdprCustomScript.php:223 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76236) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76252) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76255) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76237) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76209) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76213) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76210) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76254) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76214) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76226) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76225) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76212) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76227) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76270) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76212) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76257) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76272) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76223) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76268) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76255) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76274) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76221) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76215) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 474 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 474 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.2 0 /override/classes/Cart.php:1245 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76240) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76251) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76271) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76237) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76211) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 248 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 248 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.2 0 /override/classes/Cart.php:1245 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76258) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76266) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76243) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76260) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76239) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76230) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76267) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76236) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76209) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76224) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76241) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76242) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76259) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76210) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76238) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76241) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76222) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76224) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76266) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76271) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76275) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76229) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76239) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76243) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76269) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-06 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 474
 0.2 5 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76259) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76211) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76230) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
 0.2 178 /classes/Tab.php:318 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76252) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76221) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'teste.digibooklab.com' OR su.domain_ssl = 'teste.digibooklab.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.2 1 Yes /classes/shop/Shop.php:345 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76273) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76274) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76215) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76268) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76260) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76254) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76214) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76275) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76213) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76228) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 71 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76228) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76270) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76227) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76258) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76269) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76253) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76242) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76267) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76272) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76240) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76251) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76223) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76222) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76238) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76226) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76225) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76273) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 248 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 76229) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 71 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (474) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.2 8 Yes Yes /override/classes/Product.php:3942 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  ) WHERE pa.id_product = 248 AND IFNULL(stock.quantity, 0) >= 1 LIMIT 1
 0.2 50 /override/classes/Product.php:874 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 245
ORDER BY f.position ASC
 0.2 6 Yes /override/classes/Product.php:5034 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 4)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
WHERE pa.`id_product` = 533
AND pac.`id_product_attribute` = 84578
AND agl.`id_lang` = 4
 0.2 4 /override/classes/Product.php:6258 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.2 1 Yes /classes/SpecificPrice.php:612 
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 15, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 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, 15) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-10-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC