Accesorios de baño Formato 105//140//50 mm 140//55//135 MM 265//145//90 MM 60//65//45 mm

Filtros activos

  • Formato: 60/65/45 mm
  • Formato: 105/140/50 mm
  • Formato: 140/55/135 MM
  • Formato: 265/145/90 MM
Volver arriba

Nueva cuenta de cliente

¿Ya eres cliente?
Accede a tu cuenta ó restablece tu contraseña
Load Time219 ms - Unicorn powered webserver!
Querying Time145 ms
Queries279
Memory Peak Usage16.9 Mb
Included Files660 files - 9.95 Mb
PrestaShop Cache- Mb
Global vars1.29 Mb
PrestaShop Version1.7.4.4
PHP Version7.1.33 (OK)
MySQL Version10.5.23-MariaDB-0+deb11u1 (OK)
Memory Limit4096M
Max Execution Time999s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 18 ms 18 ms 3.89 Mb 3.90 Mb
__construct 1 ms 18 ms 0.02 Mb 3.91 Mb
init 15 ms 33 ms 1.81 Mb 5.77 Mb
checkAccess 0 ms 33 ms - Mb 5.77 Mb
setMedia 1 ms 34 ms 0.23 Mb 6.00 Mb
postProcess 0 ms 34 ms - Mb 6.00 Mb
initHeader 0 ms 34 ms - Mb 6.00 Mb
initContent 156 ms 190 ms 6.76 Mb 13.15 Mb
initFooter 0 ms 190 ms - Mb 13.15 Mb
display 30 ms 219 ms 3.44 Mb 16.86 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 - 279 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE (   
SELECT GROUP_CONCAT(cp.id_category) 
FROM ps_category_product cp 
LEFT JOIN ps_category c 
ON cp.id_category = c.id_category 
WHERE   c.id_parent=24 AND 
cp.id_product = p.id_product 
GROUP BY id_parent
) as cats_hijas_de_catactual_separadas_por_comas,
p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-05-14 00:00:00", INTERVAL 0 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM  ((SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category = 24
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY cp.id_product) UNION ALL (SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category != 24
AND c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE NOT EXISTS(SELECT * FROM ps_category_product cpe 
WHERE cp.id_product=cpe.id_product AND cpe.id_category = 24)
AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY cp.id_product)) cp
LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 1)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
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 product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY case when (SELECT count(*) from ps_category where id_parent = 24) > 0 
then p.id_category_default
else p.id_product
end
ORDER BY cp.position asc , cp.id_product LIMIT 0,10000
 40.4 51675744000 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1666 
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 1
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 1
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
WHERE lpa.id_attribute_group = 2 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 3.2 4698800 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 25 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY fv.id_feature_value
 2.7 99504000 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 25
GROUP BY fv.id_feature_value
 2.7 24876000 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 22 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY fv.id_feature_value
 2.7 30558784 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 15 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY fv.id_feature_value
 2.5 47761920 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
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`)
 2.4 1531 /classes/Configuration.php:157 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 16 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY fv.id_feature_value
 2.4 30558784 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 17 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY fv.id_feature_value
 2.3 30558784 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 23
GROUP BY fv.id_feature_value
 2.3 7639696 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 23
GROUP BY fv.id_feature_value
 2.3 7639696 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 22
GROUP BY fv.id_feature_value
 2.3 7639696 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 15
GROUP BY fv.id_feature_value
 2.1 11940480 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE *
FROM `ps_pap_product`
WHERE (id_product = 5034) AND (id_shop = 1) LIMIT 1
 2.1 5167 /modules/productareapacks/models/PAPProductModel.php:100 
SELECT SQL_NO_CACHE *
FROM `ps_pap_product`
WHERE (id_product = 5112) AND (id_shop = 1) LIMIT 1
 2.1 5167 /modules/productareapacks/models/PAPProductModel.php:100 
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653)
 2.1 30558784 /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 24 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY fv.id_feature_value
 2 30558784 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE *
FROM `ps_pap_product`
WHERE (id_product = 5005) AND (id_shop = 1) LIMIT 1
 2 5167 /modules/productareapacks/models/PAPProductModel.php:100 
SELECT SQL_NO_CACHE *
FROM `ps_pap_product`
WHERE (id_product = 5089) AND (id_shop = 1) LIMIT 1
 2 5167 /modules/productareapacks/models/PAPProductModel.php:100 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 27 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY fv.id_feature_value
 2 30558784 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 16
GROUP BY fv.id_feature_value
 2 7639696 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 17
GROUP BY fv.id_feature_value
 1.9 7639696 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM ps_layered_product_attribute lpa
INNER JOIN ps_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN ps_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 1
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = lpa.id_product
INNER JOIN ps_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN ps_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 1
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
WHERE lpa.id_attribute_group = 2 AND lpa.`id_shop` = 1 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 1.8 18795200 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE COUNT(*) FROM  ((SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category = 24
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY cp.id_product) UNION ALL (SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category != 24
AND c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE NOT EXISTS(SELECT * FROM ps_category_product cpe 
WHERE cp.id_product=cpe.id_product AND cpe.id_category = 24)
AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 867 OR fp.`id_feature_value` = 842 OR fp.`id_feature_value` = 619 OR fp.`id_feature_value` = 653) 
GROUP BY cp.id_product)) ps LIMIT 1
 1.7 366838080 /modules/ps_facetedsearch/ps_facetedsearch.php:1607 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 24
GROUP BY fv.id_feature_value
 1.7 7639696 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
WHERE fp.id_feature = 27
GROUP BY fv.id_feature_value
 1.6 7639696 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 4509
AND c.nright <= 4548
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1
 1.6 7639696 /modules/ps_facetedsearch/ps_facetedsearch.php:2014 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 4509) AND (a0.`nright` > 4548) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 1.3 2766 Yes /classes/PrestaShopCollection.php:357 
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`
 1.1 138 Yes Yes /override/classes/Hook.php:185 
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
 1.1 444 /classes/Hook.php:374 
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.9 0 /classes/Hook.php:186 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 24
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.6 19 Yes Yes /classes/Category.php:873 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 0.6 1 /classes/CartRule.php:393 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 0.6 1 /classes/CartRule.php:393 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 0.6 1 /classes/CartRule.php:393 
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
 0.5 403 Yes /classes/Country.php:153 
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.5 50 Yes /classes/Dispatcher.php:530 
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
 0.5 244 Yes /classes/Country.php:146 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 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) 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  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5005) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.4 6 Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 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) 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  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5112) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.4 4 Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'mundoceramicas'
AND TABLE_NAME='ps_btmegamenu_lang'
 0.4 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1415 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'mundoceramicas'
AND TABLE_NAME='ps_btmegamenu_lang'
 0.4 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1415 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 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) 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  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5034) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.4 1 Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'mundoceramicas'
AND TABLE_NAME='ps_btmegamenu_lang'
AND COLUMN_NAME ='url'
 0.4 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1380 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'mundoceramicas'
AND TABLE_NAME='ps_btmegamenu_lang'
AND COLUMN_NAME ='url'
 0.3 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1380 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5089) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-05-14 00:00:00',
INTERVAL 0 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 = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 5034
 0.3 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE id_category FROM ps_category WHERE id_parent=2
 0.3 501 /modules/ets_crosssell/ets_crosssell.php:785 
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` = 1262
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5112 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` = 1262
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5112 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1233 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-05-14 00:00:00',
INTERVAL 0 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 = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 5005
 0.3 7 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.mundoceramicas.com' OR su.domain_ssl = 'www.mundoceramicas.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.3 1 Yes /classes/shop/Shop.php:344 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 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) 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  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5089) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.3 1 Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.3 86 /classes/module/Module.php:301 
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` = 5034 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` = 5034 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1233 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-05-14 00:00:00',
INTERVAL 0 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 = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 5089
 0.3 1 /classes/ProductAssembler.php:91 
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
 0.3 1 /classes/ObjectModel.php:529 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.3 86 /classes/module/Module.php:301 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.3 86 /classes/module/Module.php:301 
SELECT SQL_NO_CACHE p.*, pl.params, pl.id_lang
FROM ps_appagebuilder p
LEFT JOIN ps_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=1)
LEFT JOIN ps_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder)
WHERE
pl.id_lang=1
AND ps.id_shop=1
AND p.id_appagebuilder_positions IN (12,13,14,15)
ORDER BY p.id_appagebuilder
 0.3 85 /modules/appagebuilder/classes/ApPageBuilderModel.php:302 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5034) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 7
AND tr.`id_state` IN (0, 339)
AND ('12004' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '12004')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.3 2 /classes/tax/TaxRulesTaxManager.php:110 
SELECT SQL_NO_CACHE t.*, tl.text, tl.id_lang
FROM `ps_pap_translation` t
LEFT JOIN `ps_pap_translation_lang` `tl` ON t.id_translation = tl.id_translation AND tl.id_lang = 1
WHERE (id_shop = 1)
 0.3 300 /modules/productareapacks/models/PAPTranslationModel.php:64 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-05-14 00:00:00',
INTERVAL 0 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 = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 5112
 0.3 5 /classes/ProductAssembler.php:91 
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` = 5089 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` = 5089 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1233 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('25894528', '5479', '316843511', '', '1', '1', '2024-05-14 18:26:46')
 0.3 1 /classes/ObjectModel.php:529 
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` = 1153
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5005 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` = 1153
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5005 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1233 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 24
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.2 10 Yes Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1755 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5005) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE p.*, pl.* from `ps_appagebuilder_profiles` p  INNER JOIN `ps_appagebuilder_profiles_lang` pl ON (pl.id_appagebuilder_profiles = p.id_appagebuilder_profiles) AND id_lang=1 INNER JOIN `ps_appagebuilder_profiles_shop` ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles) WHERE ps.id_shop=1 AND ps.active=1 LIMIT 1
 0.2 16 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:227 
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` = 5005 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` = 5005 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.2 0 /classes/Cart.php:1233 
SELECT SQL_NO_CACHE product_id, COUNT(product_id) AS sales FROM `ps_order_detail` WHERE product_id IN (SELECT id_product FROM `ps_category_product` LEFT JOIN ps_product USING (id_product) WHERE id_category = 24 AND active = 1) GROUP BY product_id ORDER BY sales DESC LIMIT 5
 0.2 1 Yes /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:1641 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2219) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.2 1 Yes /classes/shop/Shop.php:692 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.is_virtual = 0 AND p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.2 9 /classes/Cart.php:3946 
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` = 5112 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` = 5112 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.2 0 /classes/Cart.php:1233 
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=1
 0.2 16 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5112
ORDER BY f.position ASC
 0.2 5 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5112
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5034
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=1
 0.2 16 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115 
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 (1263, 1264, 1265, 1262) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 4 Yes /classes/Product.php:2434 
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` = 1)
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` = 1)
WHERE pa.`id_product` = 5112
AND pac.`id_product_attribute` = 1262
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6020 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5005
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2213) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
 0.2 189 /classes/Tab.php:314 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 25894528
AND `date_add` > '2024-05-14 17:56:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.2 1 Yes /classes/Connection.php:162 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1684) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
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` = 5005)
 0.2 6 /classes/Product.php:3280 
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=1
 0.2 16 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.2 83 /classes/Hook.php:226 
SELECT SQL_NO_CACHE t.*, tl.text, tl.id_lang
FROM `ps_pap_translation` t
LEFT JOIN `ps_pap_translation_lang` `tl` ON t.id_translation = tl.id_translation AND tl.id_lang = 1
WHERE (id_shop = 1)
 0.2 300 /modules/productareapacks/models/PAPTranslationModel.php:64 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5034
ORDER BY f.position ASC
 0.2 6 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.2 9 /classes/Cart.php:3929 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1681) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
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` = 1)
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` = 1)
WHERE pa.`id_product` = 5034
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
 0.2 0 /classes/Product.php:6020 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=1
 0.2 16 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5089
ORDER BY f.position ASC
 0.2 5 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1682) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
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` = 1)
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` = 1)
WHERE pa.`id_product` = 5005
AND pac.`id_product_attribute` = 1153
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6020 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2216) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE t.*, tl.text, tl.id_lang
FROM `ps_pap_translation` t
LEFT JOIN `ps_pap_translation_lang` `tl` ON t.id_translation = tl.id_translation AND tl.id_lang = 1
WHERE (id_shop = 1)
 0.2 300 /modules/productareapacks/models/PAPTranslationModel.php:64 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.2 9 /classes/Language.php:1028 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5005
ORDER BY f.position ASC
 0.2 5 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE p.`id_appagebuilder_profiles` FROM `ps_appagebuilder_profiles` p INNER JOIN `ps_appagebuilder_profiles_lang` pl ON(pl.id_appagebuilder_profiles = p.id_appagebuilder_profiles AND pl.friendly_url='45+' AND id_lang=1 )  INNER JOIN `ps_appagebuilder_profiles_shop` ps ON(ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles AND ps.id_shop =1) LIMIT 1
 0.2 4 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:389 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2215) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
 0.2 1 Yes /classes/Currency.php:300 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 8) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2218) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
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` = 5089)
 0.2 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
 0.2 0 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
 0.2 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77 
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=1
 0.2 16 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 24
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.2 10 Yes Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1755 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5112) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 1 AND uuid = "1931df73a1a8968c2a7a28fd08c82c79") LIMIT 1
 0.2 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1680) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1679) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2217) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
 0.2 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
 0.2 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.2 1 /classes/shop/Shop.php:203 
SELECT SQL_NO_CACHE * FROM ps_manufacturer m,ps_manufacturer_shop ms WHERE m.id_manufacturer= ms.id_manufacturer AND ms.id_shop="1" AND m.active=1 LIMIT 1
 0.2 10 /modules/ets_crosssell/ets_crosssell.php:724 
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
 0.2 1 /classes/Image.php:496 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.2 83 /classes/Hook.php:249 
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=1
 0.2 16 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2220) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1683) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 3) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2222) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE page from `ps_appagebuilder_page` where id_category = '24' AND id_shop = '1' LIMIT 1
 0.2 13 /modules/appagebuilder/appagebuilder.php:3071 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2212) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2221) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 339)
AND ('12004' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '12004')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.2 0 /classes/tax/TaxRulesTaxManager.php:110 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5034 AND id_shop=1 LIMIT 1
 0.2 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
 0.2 1 Yes /classes/Currency.php:300 
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` = 5034)
 0.2 1 /classes/Product.php:3280 
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 (371, 372, 373, 1153, 1154, 1155) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 6 Yes /classes/Product.php:2434 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_products p
INNER JOIN ps_appagebuilder_products_shop ps on(p.id_appagebuilder_products = ps.id_appagebuilder_products) WHERE  ps.active=1 and ps.id_shop=1 LIMIT 1
 0.2 7 /modules/appagebuilder/classes/ApPageBuilderProductsModel.php:116 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
 0.2 1 /classes/Image.php:496 
SELECT SQL_NO_CACHE * FROM `ps_image_type`
 0.2 8 /classes/ImageType.php:144 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 7
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.2 1 /classes/tax/TaxRulesTaxManager.php:110 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.2 8 Yes /classes/ImageType.php:108 
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1262) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE id_category FROM ps_category WHERE is_root_category=1 LIMIT 1
 0.2 2766 /modules/ets_crosssell/ets_crosssell.php:783 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 5) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 1 AND uuid = "1931df73a1a8968c2a7a28fd08c82c79") LIMIT 1
 0.2 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "facebookproductsfeed" LIMIT 1
 0.2 0 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.2 1 /classes/shop/ShopUrl.php:169 
SELECT SQL_NO_CACHE `id_product`, `id_product_attribute`, id_shop
FROM `ps_cart_product`
WHERE `id_cart` = 0
ORDER BY `date_add` DESC LIMIT 1
 0.2 9 /classes/Cart.php:607 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 58 AND `id_shop` = 1 LIMIT 1
 0.2 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 1 AND uuid = "1931df73a1a8968c2a7a28fd08c82c79") LIMIT 1
 0.2 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 1678 LIMIT 1
 0.2 1 /classes/Category.php:1321 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 1681 LIMIT 1
 0.2 1 /classes/Category.php:1321 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 1681 LIMIT 1
 0.2 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE id_btmegamenu_group FROM `ps_btmegamenu_group`  WHERE randkey IN ('cdf12604c03e0de855bdca69c9a0725a') AND id_shop = 1
 0.2 2 /modules/appagebuilder/classes/shortcodes/ApMegamenu.php:121 
SELECT SQL_NO_CACHE *
FROM `ps_btmegamenu_group` a
WHERE (a.`id_btmegamenu_group` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 7) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.1 4 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5034) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.1 8 Yes /classes/ImageType.php:108 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5089
ORDER BY `position`
 0.1 1 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1153 LIMIT 1
 0.1 1 /classes/Combination.php:444 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
 0.1 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77 
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 5112 AND pa.`id_product` = 5112 AND pa.`id_product_attribute` = 1262 LIMIT 1
 0.1 1 /classes/Product.php:920 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 1678 LIMIT 1
 0.1 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 57 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 8) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "shiptopay" LIMIT 1
 0.1 0 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'es' LIMIT 1
 0.1 3 /classes/Language.php:721 
SELECT SQL_NO_CACHE *
FROM `ps_btmegamenu_group_lang`
WHERE `id_btmegamenu_group` = 1
 0.1 3 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "advancedloyalty" LIMIT 1
 0.1 0 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE * FROM `ps_appagebuilder_positions` WHERE id_appagebuilder_positions IN(12,13,14,15)
 0.1 4 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:318 
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 5005 AND pa.`id_product` = 5005 AND pa.`id_product_attribute` = 1153 LIMIT 1
 0.1 1 /classes/Product.php:920 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 24 AND ctg.`id_group` = 1 LIMIT 1
 0.1 1 /classes/Category.php:1652 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2214) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 0.1 1 /classes/Currency.php:657 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
 0.1 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.1 3 /classes/Language.php:881 
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` = 1)
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` = 1)
WHERE pa.`id_product` = 5089
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
 0.1 0 /classes/Product.php:6020 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
 0.1 3 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
 0.1 1 /classes/Page.php:100 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1548 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1678) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1548 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ets_productcomments" LIMIT 1
 0.1 0 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1153) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.1 1 /classes/shop/Shop.php:1127 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE ar.id_ets_abancart_reminder FROM `ps_ets_abancart_reminder` ar
LEFT JOIN `ps_ets_abancart_campaign` ac ON (ac.id_ets_abancart_campaign = ar.id_ets_abancart_campaign)
WHERE ac.id_ets_abancart_campaign is NOT NULL AND ac.campaign_type = 'browser' LIMIT 1
 0.1 4 /modules/ets_abandonedcart/classes/EtsAbancartReminder.php:204 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1685) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
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` = 5112)
 0.1 4 /classes/Product.php:3280 
SELECT SQL_NO_CACHE required FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:282 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 6 LIMIT 1
 0.1 1 /classes/Country.php:271 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leobootstrapmenu" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1548 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 4) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.1 2 /classes/ObjectModel.php:1416 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5112
 0.1 4 /classes/Product.php:2416 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2213 LIMIT 1
 0.1 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5034
 0.1 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5005
 0.1 6 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "appagebuilder" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE t.*, tl.text, tl.id_lang
FROM `ps_pap_translation` t
LEFT JOIN `ps_pap_translation_lang` `tl` ON t.id_translation = tl.id_translation AND tl.id_lang = 1
WHERE (id_shop = 1)
 0.1 300 /modules/productareapacks/models/PAPTranslationModel.php:64 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 14) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
 0.1 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77 
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 24 LIMIT 1
 0.1 1 /classes/Page.php:80 
SELECT SQL_NO_CACHE *
FROM `ps_state` a
WHERE (a.`id_state` = 339) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
 0.1 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 2213 LIMIT 1
 0.1 1 /classes/Category.php:1321 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
 0.1 1 /classes/Group.php:150 
SELECT SQL_NO_CACHE * FROM ps_facebookpixels WHERE pixel_type = 1 AND pixel_active = 1
 0.1 1 /modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php:1663 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5089 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 163 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE additional FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:282 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 10) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
 0.1 4 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 55 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.1 1 /classes/module/Module.php:2066 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 2216 LIMIT 1
 0.1 1 /classes/Category.php:1321 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockgrouptop" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:282 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 6 LIMIT 1
 0.1 1 /classes/AddressFormat.php:616 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5005) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:282 
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '1',`title` = 'main menu',`title_fo` = 'Categorías',`id_lang` = '2' WHERE id_btmegamenu_group = 1 AND id_lang = 2
 0.1 1 /classes/ObjectModel.php:762 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5005 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 6
 0.1 4 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2216 LIMIT 1
 0.1 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5005 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 142 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:282 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-05-14 00:00:00" AND date_to <= "2024-05-14 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-05-14 00:00:00" AND date_from <= "2024-05-14 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-05-14 00:00:00" AND date_to > "2024-05-14 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.1 1 /classes/CartRule.php:335 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 1 AND id_lang = 3 LIMIT 1
 0.1 1 /classes/ObjectModel.php:761 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5089 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 61 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5034 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5089) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
UPDATE `ps_btmegamenu_group` SET `id_btmegamenu_group` = '1',`active` = '1',`hook` = '',`position` = '0',`id_shop` = '1',`params` = 'eyJncm91cF90eXBlIjoiaG9yaXpvbnRhbCIsInNob3dfY2F2YXMiOiIxIiwidHlwZV9zdWIiOiJhdXRvIiwiZ3JvdXBfY2xhc3MiOiIifQ==',`active_ap` = '1',`randkey` = 'cdf12604c03e0de855bdca69c9a0725a',`form_id` = '2185617446' WHERE `id_btmegamenu_group` = 1
 0.1 1 /classes/ObjectModel.php:694 
SELECT SQL_NO_CACHE `id_product`, `id_product_attribute`, id_shop
FROM `ps_cart_product`
WHERE `id_cart` = 0
ORDER BY `date_add` DESC LIMIT 1
 0.1 9 /classes/Cart.php:607 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1262 LIMIT 1
 0.1 1 /classes/Combination.php:444 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5089
 0.1 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ProductSamples" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5112) AND (id_product_attribute = 1262) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ets_homecategories" LIMIT 1
 0.1 0 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5112) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5005) AND (id_product_attribute = 1153) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 1 AND id_lang = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:761 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-05-14 00:00:00" AND date_to <= "2024-05-14 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-05-14 00:00:00" AND date_from <= "2024-05-14 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-05-14 00:00:00" AND date_to > "2024-05-14 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.1 1 /classes/CartRule.php:335 
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw;
 0.1 1 /override/classes/Hook.php:72 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5112 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customersignin" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5112 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 1 AND id_lang = 2 LIMIT 1
 0.1 1 /classes/ObjectModel.php:761 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.1 1 /classes/module/Module.php:2603 
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '1',`title` = 'main menu',`title_fo` = 'Categorías',`id_lang` = '1' WHERE id_btmegamenu_group = 1 AND id_lang = 1
 0.1 1 /classes/ObjectModel.php:762 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151 
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '1',`title` = 'main menu',`title_fo` = 'Categorías',`id_lang` = '3' WHERE id_btmegamenu_group = 1 AND id_lang = 3
 0.1 1 /classes/ObjectModel.php:762 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 14 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2151

Doubles

28
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
10
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
9
SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
                        COUNT(DISTINCT p.id_product) nbr,
                        lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 

                        FROM ps_feature_product fp
                        INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
                                             STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
                                             c.nleft >= XX
                                             AND c.nright <= XX
                                             AND c.active = XX)
                                             STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
                                             AND product_shop.id_shop = XX)
                                             STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
                                             WHERE product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog")) p
                        ON p.id_product = fp.id_product
                        LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = XX)
                        INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = XX))
                        LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_lang_value lifl
                        ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
                        ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = XX) 

WHERE fp.id_feature = XX
GROUP BY fv.id_feature_value
7
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX
WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
7
SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
                        COUNT(DISTINCT p.id_product) nbr,
                        lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 

                        FROM ps_feature_product fp
                        INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
                                             STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
                                             c.nleft >= XX
                                             AND c.nright <= XX
                                             AND c.active = XX)
                                             STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
                                             AND product_shop.id_shop = XX)
                                             STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
                                             WHERE product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog")) p
                        ON p.id_product = fp.id_product
                        LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = XX)
                        INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = XX))
                        LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_lang_value lifl
                        ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
                        ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = XX) 

WHERE fp.id_feature = XX AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX) 
GROUP BY fv.id_feature_value
7
SELECT * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =XX LIMIT XX
6
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
            COALESCE(SUM(first_level_quantity), XX) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity
          FROM `ps_cart_product` cp
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX 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` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
            pr.`pack_stock_type` = XX
            AND XX = XX
        ))) as q LIMIT XX
6
SELECT p.*, ps.*,pl.friendly_url
                        FROM ps_appagebuilder_profiles p
                        INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
                        INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
                        WHERE id_shop=XX AND id_lang=XX
6
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4
SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
4
SELECT t.*, tl.text, tl.id_lang
FROM `ps_pap_translation` t
LEFT JOIN `ps_pap_translation_lang` `tl` ON t.id_translation = tl.id_translation AND tl.id_lang = XX
WHERE (id_shop = XX)
4
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
4
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) 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 = XX)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
4
			SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) 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 = XX) LEFT JOIN ps_stock_available stock
			ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX  AND stock.id_shop_group = XX  )
			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` = XX)
			JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
			WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
			GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
			HAVING qty > XX
			ORDER BY a.`position` ASC;
4
							SELECT `id_tax_rules_group`
							FROM `ps_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
4
SELECT `id_product_attribute`
			FROM `ps_product_attribute`
			WHERE `id_product` = XX
4
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
4
			SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
			FROM `ps_image` i
			 INNER JOIN ps_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
			LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
			WHERE i.`id_product` = XX
			ORDER BY `position`
4
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
4
SELECT
                    p.*,
                    pl.*,
                    sa.out_of_stock,
                    IFNULL(sa.quantity, XX) as quantity,
                    (DATEDIFF(
				p.`date_add`,
				DATE_SUB(
					'XX-XX-XX XX:XX:XX',
					INTERVAL XX DAY
				)
			) > XX) as new
                FROM ps_product p
                LEFT JOIN ps_product_lang pl
                    ON pl.id_product = p.id_product
                    AND pl.id_shop = XX
                    AND pl.id_lang = XX
                LEFT JOIN ps_stock_available sa
			        ON sa.id_product = p.id_product 
			        AND sa.id_shop = XX
			    WHERE p.id_product = XX
4
SELECT *
FROM `ps_pap_product`
WHERE (id_product = XX) AND (id_shop = XX) LIMIT XX
4
				SELECT name, value, pf.id_feature
				FROM ps_feature_product pf
				LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX)
				LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
				LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
				 INNER JOIN ps_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX)
				WHERE pf.id_product = XX
				ORDER BY f.position ASC
4
			SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, 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` = XX)
			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 = XX)
			LEFT JOIN `ps_attribute_group_lang` agl
				ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
			WHERE pa.`id_product` = XX
				AND pac.`id_product_attribute` = XX
				AND agl.`id_lang` = XX
3
SELECT COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = XX AND id_lang = XX LIMIT XX
3
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = 'XX',`title` = 'main menu',`title_fo` = 'Categorías',`id_lang` = 'XX' WHERE id_btmegamenu_group = XX AND id_lang = XX
3
SELECT *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = XX AND id_lang = XX AND uuid = XX) LIMIT XX
3
                SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
                FROM `ps_module` m
                LEFT JOIN `ps_module_shop` ms
                ON m.`id_module` = ms.`id_module`
                AND ms.`id_shop` = XX
3
				SELECT tr.*
				FROM `ps_tax_rule` tr
				JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
                        SELECT * FROM INFORMATION_SCHEMA.COLUMNS
                        WHERE TABLE_SCHEMA = 'mundoceramicas'
                        AND TABLE_NAME='ps_btmegamenu_lang'
2
		SELECT *
		FROM `ps_currency` c
		 INNER JOIN ps_currency_shop currency_shop
        ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX ORDER BY `iso_code` ASC
2
SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) 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 = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
2
                        SELECT * FROM INFORMATION_SCHEMA.COLUMNS
                            WHERE TABLE_SCHEMA = 'mundoceramicas'
                                AND TABLE_NAME='ps_btmegamenu_lang'
                                AND COLUMN_NAME ='url'
2
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
				LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`id_customer` = XX  AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
				LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`group_restriction` = XX  AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%")
2
			SELECT product_attribute_shop.`price`
			FROM `ps_product_attribute` pa
			 INNER JOIN ps_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
			WHERE pa.`id_product_attribute` = XX LIMIT XX
2
SELECT type, id_value, filter_show_limit, filter_type FROM ps_layered_category
			WHERE id_category = XX
				AND id_shop = XX
			GROUP BY `type`, id_value ORDER BY position ASC
2
(SELECT XX FROM `ps_cart_rule` WHERE date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `ps_cart_rule` WHERE date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `ps_cart_rule` WHERE date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX) LIMIT XX
2
SELECT *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX
WHERE (a.`id_product_attribute` = XX) LIMIT XX
2
SELECT * FROM `ps_hook_alias`
2
            SELECT `id_product`, `id_product_attribute`, id_shop
            FROM `ps_cart_product`
            WHERE `id_cart` = XX
            ORDER BY `date_add` DESC LIMIT XX
2
SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX

Tables stress

59 category
48 product
41 product_shop
39 category_lang
33 feature_product
30 category_shop
28 category_product
20 feature_value_lang
20 module
20 feature_lang
19 product_attribute_shop
18 product_attribute
16 cart_product
16 layered_indexable_feature_value_lang_value
16 layered_indexable_feature_lang_value
16 feature_value
15 stock_available
15 appagebuilder_profiles_shop
15 module_shop
12 cart_rule
10 attribute
10 attribute_lang
9 product_lang
8 product_attribute_combination
8 appagebuilder_profiles_lang
8 appagebuilder_profiles
7 cms_shop
7 cms_lang
7 cms
7 image_lang
6 cart_rule_lang
6 image
6 pack
6 attribute_group_lang
6 attribute_group
5 image_shop
5 image_type
5 currency_shop
5 lgcookieslaw_lang
4 shop
4 shop_url
4 product_group_reduction_cache
4 feature
4 currency
4 pap_translation
4 pap_translation_lang
4 hook
4 pap_product
4 btmegamenu_group_lang
4 country
4 lang_shop
4 lang
4 feature_shop
3 tax_rule
3 tax_rules_group
3 trustedshopsintegration
3 country_lang
3 country_shop
3 hook_alias
2 layered_product_attribute
2 state
2 shop_group
2 configuration
2 btmegamenu_group
2 product_attribute_image
2 hook_module
2 group
2 layered_category
2 category_group
2 group_shop
2 layered_indexable_attribute_group_lang_value
2 layered_price_index
2 layered_indexable_attribute_lang_value
2 manufacturer
1 required_field
1 appagebuilder_positions
1 page_type
1 connections
1 facebookpixels
1 order_detail
1 ets_abancart_campaign
1 ets_abancart_reminder
1 configuration_lang
1 zone
1 tab
1 lgcookieslaw
1 appagebuilder_lang
1 address_format
1 appagebuilder_shop
1 module_group
1 appagebuilder
1 meta
1 meta_lang
1 appagebuilder_products_shop
1 group_lang
1 appagebuilder_products
1 tax_lang
1 tax
1 hook_module_exceptions
1 appagebuilder_page
1 page

ObjectModel instances

NameInstancesSource
Category 47 /controllers/front/listing/CategoryController.php [70]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/controllers/front/listing/CategoryController.php [178]
/classes/Meta.php [377]
/classes/Link.php [373]
/classes/Link.php [373]
/classes/PrestaShopCollection.php [359]
/classes/PrestaShopCollection.php [359]
/modules/ps_facetedsearch/ps_facetedsearch.php [1749]
/modules/ps_facetedsearch/ps_facetedsearch.php [1390]
/modules/ps_facetedsearch/ps_facetedsearch.php [1749]
/classes/controller/ProductListingFrontController.php [386]
/classes/Link.php [373]
/classes/controller/ProductListingFrontController.php [386]
/classes/Link.php [373]
/classes/controller/ProductListingFrontController.php [386]
/classes/Link.php [373]
/classes/controller/ProductListingFrontController.php [386]
/classes/Link.php [373]
/classes/Link.php [373]
/classes/Link.php [373]
/classes/Link.php [373]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [399]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [399]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [399]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [399]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [399]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [399]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [399]
/modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php [1748]
PAPTranslationModel 40 /modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
/modules/productareapacks/productareapacks.php [293]
Product 16 /classes/Link.php [100]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [100]
/classes/Link.php [100]
/classes/Link.php [100]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [100]
/classes/Link.php [100]
/classes/Link.php [100]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [100]
/classes/Link.php [100]
/classes/Link.php [100]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [100]
/classes/Link.php [100]
ApPageBuilderModel 10 /modules/appagebuilder/appagebuilder.php [1619]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
/modules/appagebuilder/appagebuilder.php [1984]
CMS 8 /classes/Link.php [524]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [432]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [432]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [432]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [432]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [432]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [432]
/modules/appagebuilder/classes/shortcodes/ApBlockLink.php [432]
ApPageBuilderProfilesModel 7 /modules/appagebuilder/appagebuilder.php [2659]
/modules/appagebuilder/appagebuilder.php [1473]
/modules/appagebuilder/appagebuilder.php [2447]
/modules/appagebuilder/classes/ApPageBuilderHookModel.php [31]
/modules/appagebuilder/classes/ApPageBuilderHookModel.php [31]
/modules/appagebuilder/classes/ApPageBuilderHookModel.php [31]
/modules/appagebuilder/classes/ApPageBuilderHookModel.php [31]
Country 4 /config/config.inc.php [145]
/classes/controller/FrontController.php [346]
/classes/AddressFormat.php [353]
/classes/controller/FrontController.php [1619]
Address 4 /classes/shop/Shop.php [465]
/classes/Product.php [3123]
/classes/Product.php [3223]
/classes/Product.php [4812]
Combination 4 /classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
PAPProductModel 4 /modules/productareapacks/productareapacks.php [205]
/modules/productareapacks/productareapacks.php [205]
/modules/productareapacks/productareapacks.php [205]
/modules/productareapacks/productareapacks.php [205]
LeoWidget 2 /modules/leobootstrapmenu/leobootstrapmenu.php [100]
/modules/leobootstrapmenu/leobootstrapmenu.php [100]
Tax 2 /classes/tax/TaxRulesTaxManager.php [117]
/classes/tax/TaxRulesTaxManager.php [117]
Language 2 /config/config.inc.php [198]
/classes/Tools.php [537]
State 2 /classes/AddressFormat.php [353]
/classes/controller/FrontController.php [1618]
BtmegamenuGroup 1 /modules/leobootstrapmenu/leobootstrapmenu.php [1674]
Guest 1 /modules/statsdata/statsdata.php [83]
Shop 1 /config/config.inc.php [119]
AddressFormat 1 /classes/controller/FrontController.php [1613]
Configuration 1 /modules/appagebuilder/appagebuilder.php [1836]
Risk 1 /classes/controller/FrontController.php [1583]
Gender 1 /classes/controller/FrontController.php [1580]
Group 1 /classes/Cart.php [245]
Cart 1 /classes/controller/FrontController.php [415]
Currency 1 /classes/Tools.php [652]
Customer 1 /config/config.inc.php [224]
ShopGroup 1 /classes/shop/Shop.php [547]
Connection 1 /modules/statsdata/statsdata.php [117]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/autoload.php
5/config/alias.php
6/classes/PrestaShopAutoload.php
7/var/cache/prod/class_index.php
8/vendor/autoload.php
9/vendor/composer/autoload_real.php
10/vendor/composer/ClassLoader.php
11/vendor/composer/include_paths.php
12/vendor/composer/autoload_static.php
13/vendor/react/promise/src/functions_include.php
14/vendor/react/promise/src/functions.php
15/vendor/swiftmailer/swiftmailer/lib/swift_required.php
16/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
17/vendor/paragonie/random_compat/lib/random.php
18/vendor/icanboogie/common/bootstrap.php
19/vendor/icanboogie/common/lib/helpers.php
20/vendor/symfony/polyfill-php70/bootstrap.php
21/vendor/symfony/polyfill-php56/bootstrap.php
22/vendor/symfony/polyfill-mbstring/bootstrap.php
23/vendor/symfony/polyfill-intl-icu/bootstrap.php
24/vendor/symfony/polyfill-ctype/bootstrap.php
25/vendor/symfony/polyfill-apcu/bootstrap.php
26/vendor/smarty/smarty/libs/bootstrap.php
27/vendor/smarty/smarty/libs/Autoloader.php
28/vendor/ircmaxell/password-compat/lib/password.php
29/vendor/jakeasmith/http_build_url/src/http_build_url.php
30/config/bootstrap.php
31/src/Core/ContainerBuilder.php
32/src/Core/Foundation/IoC/Container.php
33/src/Adapter/ServiceLocator.php
34/vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
35/var/cache/prod/appParameters.php
36/classes/controller/Controller.php
37/classes/ObjectModel.php
38/src/Core/Foundation/Database/EntityInterface.php
39/classes/db/Db.php
40/classes/Tools.php
41/classes/Context.php
42/classes/shop/Shop.php
43/classes/db/DbPDO.php
44/classes/Configuration.php
45/classes/Validate.php
46/classes/cache/Cache.php
47/src/Adapter/EntityMapper.php
48/classes/db/DbQuery.php
49/src/Core/Addon/Theme/ThemeManagerBuilder.php
50/src/Adapter/Configuration.php
51/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
52/src/Core/ConfigurationInterface.php
53/src/Core/Addon/Theme/ThemeRepository.php
54/src/Core/Addon/AddonRepositoryInterface.php
55/src/Core/Addon/Theme/Theme.php
56/src/Core/Addon/AddonInterface.php
57/vendor/shudrum/array-finder/ArrayFinder.php
58/config/defines_uri.inc.php
59/classes/Language.php
60/classes/Country.php
61/classes/PrestaShopCollection.php
62/classes/shop/ShopGroup.php
63/classes/Cookie.php
64/classes/PhpEncryption.php
65/vendor/defuse/php-encryption/src/Core.php
66/classes/PhpEncryptionEngine.php
67/vendor/defuse/php-encryption/src/Key.php
68/vendor/defuse/php-encryption/src/Encoding.php
69/config/smarty.config.inc.php
70/vendor/smarty/smarty/libs/Smarty.class.php
71/vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php
72/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php
73/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
74/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
75/vendor/smarty/smarty/libs/sysplugins/smarty_resource.php
76/vendor/smarty/smarty/libs/sysplugins/smarty_variable.php
77/vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php
78/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
79/vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php
80/config/smartyfront.config.inc.php
81/classes/Smarty/SmartyResourceModule.php
82/vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php
83/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php
84/classes/Smarty/SmartyResourceParent.php
85/classes/Smarty/SmartyLazyRegister.php
86/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php
87/vendor/smarty/smarty/libs/plugins/modifier.truncate.php
88/classes/Customer.php
89/classes/Group.php
90/classes/Link.php
91/classes/shop/ShopUrl.php
92/classes/Dispatcher.php
93/classes/Hook.php
94/override/classes/Hook.php
95/src/Adapter/SymfonyContainer.php
96/classes/module/Module.php
97/src/Core/Module/ModuleInterface.php
98/vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
99/config/db_slave_server.inc.php
100/modules/appagebuilder/appagebuilder.php
101/modules/appagebuilder/libs/Helper.php
102/modules/appagebuilder/libs/LeoFrameworkHelper.php
103/modules/appagebuilder/classes/ApPageSetting.php
104/modules/appagebuilder/classes/ApPageBuilderModel.php
105/modules/appagebuilder/classes/shortcodes.php
106/modules/appagebuilder/controllers/admin/AdminApPageBuilderShortcodes.php
107/modules/appagebuilder/controllers/admin/AdminApPageBuilderPositions.php
108/modules/appagebuilder/classes/ApPageBuilderPositionsModel.php
109/classes/controller/ModuleAdminController.php
110/classes/controller/AdminController.php
111/modules/appagebuilder/classes/ApShortCodesBuilder.php
112/modules/appagebuilder/classes/ApPageBuilderProfilesModel.php
113/modules/appagebuilder/classes/ApPageBuilderProductsModel.php
114/modules/appagebuilder/classes/ApPageBuilderShortcodeModel.php
115/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php
116/vendor/smarty/smarty/libs/sysplugins/smarty_data.php
117/classes/Translate.php
118/modules/appagebuilder/translations/es.php
119/modules/leoblog/leoblog.php
120/modules/leoblog/loader.php
121/modules/leoblog/classes/config.php
122/modules/leoblog/libs/Helper.php
123/modules/leoblog/classes/leoblogcat.php
124/modules/leoblog/classes/blog.php
125/modules/leoblog/classes/link.php
126/modules/leoblog/classes/comment.php
127/modules/leoblog/classes/LeoblogOwlCarousel.php
128/modules/leoblog/translations/es.php
129/controllers/front/listing/CategoryController.php
130/classes/controller/ProductListingFrontController.php
131/classes/controller/ProductPresentingFrontController.php
132/classes/controller/FrontController.php
133/override/controllers/front/listing/CategoryController.php
134/src/PrestaShopBundle/Translation/TranslatorComponent.php
135/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
136/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
137/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
138/src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
139/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatter.php
140/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatterInterface.php
141/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/ChoiceMessageFormatterInterface.php
142/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageSelector.php
143/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
144/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
145/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
146/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
147/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
148/var/cache/prod/translations/catalogue.es-ES.NXhscRe.php
149/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
150/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
151/vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
152/src/Adapter/ObjectPresenter.php
153/src/Core/Foundation/Templating/PresenterInterface.php
154/src/Adapter/Cart/CartPresenter.php
155/src/Adapter/Product/PriceFormatter.php
156/src/Adapter/Image/ImageRetriever.php
157/classes/tax/TaxConfiguration.php
158/classes/Smarty/TemplateFinder.php
159/classes/assets/StylesheetManager.php
160/classes/assets/AbstractAssetManager.php
161/src/Adapter/Assets/AssetUrlGeneratorTrait.php
162/classes/assets/JavascriptManager.php
163/classes/assets/CccReducer.php
164/classes/Category.php
165/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerBuilder.php
166/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
167/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
168/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
169/vendor/psr/container/src/ContainerInterface.php
170/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/TaggedContainerInterface.php
171/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/EnvPlaceholderParameterBag.php
172/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php
173/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBagInterface.php
174/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ResourceInterface.php
175/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Definition.php
176/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Alias.php
177/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/YamlFileLoader.php
178/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/FileLoader.php
179/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/FileLoader.php
180/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/Loader.php
181/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/LoaderInterface.php
182/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocator.php
183/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocatorInterface.php
184/vendor/symfony/symfony/src/Symfony/Component/Yaml/Parser.php
185/vendor/symfony/symfony/src/Symfony/Component/Yaml/Yaml.php
186/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php
187/vendor/symfony/symfony/src/Symfony/Component/Yaml/Unescaper.php
188/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ComposerResource.php
189/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceInterface.php
190/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/FileResource.php
191/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Reference.php
192/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/Compiler.php
193/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/PassConfig.php
194/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/MergeExtensionConfigurationPass.php
195/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CompilerPassInterface.php
196/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveClassPass.php
197/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveInstanceofConditionalsPass.php
198/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RegisterEnvVarProcessorsPass.php
199/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ExtensionCompilerPass.php
200/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveChildDefinitionsPass.php
201/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AbstractRecursivePass.php
202/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceLocatorTagPass.php
203/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/DecoratorServicePass.php
204/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveParameterPlaceHoldersPass.php
205/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveFactoryClassPass.php
206/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/FactoryReturnTypePass.php
207/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckDefinitionValidityPass.php
208/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RegisterServiceSubscribersPass.php
209/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveNamedArgumentsPass.php
210/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AutowireRequiredMethodsPass.php
211/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveBindingsPass.php
212/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AutowirePass.php
213/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveTaggedIteratorArgumentPass.php
214/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/PriorityTaggedServiceTrait.php
215/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveServiceSubscribersPass.php
216/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveReferencesToAliasesPass.php
217/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveInvalidReferencesPass.php
218/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AnalyzeServiceReferencesPass.php
219/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatablePassInterface.php
220/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckCircularReferencesPass.php
221/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckReferenceValidityPass.php
222/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckArgumentsValidityPass.php
223/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolvePrivatesPass.php
224/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemovePrivateAliasesPass.php
225/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ReplaceAliasByActualDefinitionPass.php
226/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveAbstractDefinitionsPass.php
227/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatedPass.php
228/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/InlineServiceDefinitionsPass.php
229/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveUnusedDefinitionsPass.php
230/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/DefinitionErrorExceptionPass.php
231/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php
232/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveHotPathPass.php
233/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraph.php
234/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/EnvVarProcessor.php
235/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/EnvVarProcessorInterface.php
236/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Exception/RuntimeException.php
237/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Exception/ExceptionInterface.php
238/vendor/psr/container/src/ContainerExceptionInterface.php
239/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraphNode.php
240/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraphEdge.php
241/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/FrozenParameterBag.php
242/classes/Currency.php
243/src/Core/Cldr/Repository.php
244/vendor/icanboogie/cldr/lib/RunTimeProvider.php
245/vendor/icanboogie/cldr/lib/ProviderChainTrait.php
246/vendor/icanboogie/cldr/lib/ProviderInterface.php
247/vendor/icanboogie/cldr/lib/CacheInterface.php
248/vendor/icanboogie/cldr/lib/FileProvider.php
249/vendor/icanboogie/cldr/lib/WebProvider.php
250/vendor/icanboogie/cldr/lib/Repository.php
251/vendor/icanboogie/cldr/lib/AccessorTrait.php
252/vendor/icanboogie/cldr/lib/LocaleCollection.php
253/vendor/icanboogie/cldr/lib/RepositoryPropertyTrait.php
254/vendor/icanboogie/cldr/lib/CollectionTrait.php
255/vendor/icanboogie/cldr/lib/Locale.php
256/vendor/icanboogie/cldr/lib/CodePropertyTrait.php
257/vendor/icanboogie/cldr/lib/Supplemental.php
258/vendor/icanboogie/cldr/lib/Currency.php
259/vendor/icanboogie/cldr/lib/LocalizedCurrency.php
260/vendor/icanboogie/cldr/lib/LocalizedObjectWithFormatter.php
261/vendor/icanboogie/cldr/lib/LocalizedObject.php
262/vendor/icanboogie/cldr/lib/LocalePropertyTrait.php
263/classes/Cart.php
264/override/classes/Cart.php
265/src/Adapter/AddressFactory.php
266/classes/CartRule.php
267/override/classes/CartRule.php
268/classes/Product.php
269/override/classes/Product.php
270/classes/Pack.php
271/classes/webservice/WebserviceRequest.php
272/classes/ImageType.php
273/modules/productareapacks/productareapacks.php
274/modules/productareapacks/lib/bootstrap.php
275/modules/productareapacks/lib/classes/PAPControllerCore.php
276/modules/productareapacks/models/PAPInstall.php
277/modules/productareapacks/models/PAPDimensionModel.php
278/modules/productareapacks/models/PAPTranslationModel.php
279/modules/productareapacks/models/PAPTranslationProductModel.php
280/modules/productareapacks/models/PAPProductModel.php
281/modules/productareapacks/models/PAPProductFieldModel.php
282/modules/productareapacks/models/PAPProductAttributeModel.php
283/modules/productareapacks/controllers/admin/config/PAPAdminConfigMainController.php
284/modules/productareapacks/controllers/admin/config/PAPAdminConfigDimensionsController.php
285/modules/productareapacks/controllers/admin/config/PAPAdminConfigOptionsController.php
286/modules/productareapacks/controllers/admin/config/PAPAdminConfigTranslationsController.php
287/modules/productareapacks/controllers/admin/producttab/PAPAdminProductTabController.php
288/modules/productareapacks/controllers/admin/producttab/PAPAdminProductTabGeneralController.php
289/modules/productareapacks/controllers/admin/producttab/PAPAdminProductTabCombinationsController.php
290/modules/productareapacks/controllers/admin/producttab/PAPAdminProductTabTranslationsController.php
291/modules/productareapacks/controllers/front/PAPFrontCartController.php
292/modules/productareapacks/controllers/front/PAPFrontProductController.php
293/modules/productareapacks/helpers/PAPTranslationHelper.php
294/modules/productareapacks/translations/es.php
295/classes/ProductDownload.php
296/classes/tax/Tax.php
297/src/Core/Cart/Calculator.php
298/src/Core/Cart/CartRowCollection.php
299/src/Core/Cart/Fees.php
300/src/Core/Cart/CartRuleCollection.php
301/src/Adapter/Product/PriceCalculator.php
302/classes/order/Order.php
303/src/Core/Cart/CartRow.php
304/src/Core/Cart/AmountImmutable.php
305/src/Core/Cart/CartRuleCalculator.php
306/vendor/icanboogie/cldr/lib/Numbers.php
307/vendor/icanboogie/cldr/lib/CurrencyFormatter.php
308/vendor/icanboogie/cldr/lib/NumberFormatter.php
309/vendor/icanboogie/cldr/lib/NumberPattern.php
310/classes/Gender.php
311/classes/Risk.php
312/classes/Meta.php
313/classes/Address.php
314/classes/AddressFormat.php
315/classes/State.php
316/src/Core/Addon/Module/ModuleManagerBuilder.php
317/app/config/config.php
318/src/PrestaShopBundle/Service/DataProvider/Marketplace/ApiClient.php
319/vendor/guzzlehttp/guzzle/src/Client.php
320/vendor/guzzlehttp/guzzle/src/Event/HasEmitterTrait.php
321/vendor/guzzlehttp/guzzle/src/ClientInterface.php
322/vendor/guzzlehttp/guzzle/src/Event/HasEmitterInterface.php
323/vendor/guzzlehttp/guzzle/src/Url.php
324/vendor/guzzlehttp/guzzle/src/Utils.php
325/vendor/guzzlehttp/guzzle/src/Message/MessageFactory.php
326/vendor/guzzlehttp/guzzle/src/Event/ListenerAttacherTrait.php
327/vendor/guzzlehttp/guzzle/src/Message/MessageFactoryInterface.php
328/vendor/guzzlehttp/guzzle/src/Subscriber/HttpError.php
329/vendor/guzzlehttp/guzzle/src/Event/SubscriberInterface.php
330/vendor/guzzlehttp/guzzle/src/Subscriber/Redirect.php
331/vendor/guzzlehttp/ringphp/src/Client/CurlHandler.php
332/vendor/guzzlehttp/ringphp/src/Client/CurlFactory.php
333/vendor/guzzlehttp/ringphp/src/Client/CurlMultiHandler.php
334/vendor/guzzlehttp/ringphp/src/Client/Middleware.php
335/vendor/guzzlehttp/ringphp/src/Client/StreamHandler.php
336/vendor/guzzlehttp/guzzle/src/RequestFsm.php
337/src/Adapter/Tools.php
338/app/config/parameters.php
339/src/Adapter/Module/ModuleZipManager.php
340/src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php
341/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcherInterface.php
342/src/Adapter/Addons/AddonsDataProvider.php
343/src/PrestaShopBundle/Service/DataProvider/Admin/AddonsInterface.php
344/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
345/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
346/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
347/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
348/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
349/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
350/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
351/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
352/src/Adapter/LegacyLogger.php
353/vendor/psr/log/Psr/Log/LoggerInterface.php
354/src/PrestaShopBundle/Service/DataProvider/Admin/CategoriesProvider.php
355/src/Adapter/LegacyContext.php
356/src/Adapter/Module/ModuleDataProvider.php
357/src/Adapter/Module/AdminModuleDataProvider.php
358/src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php
359/vendor/symfony/symfony/src/Symfony/Component/Routing/Loader/YamlFileLoader.php
360/vendor/symfony/symfony/src/Symfony/Component/Routing/Router.php
361/vendor/symfony/symfony/src/Symfony/Component/Routing/RouterInterface.php
362/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/UrlMatcherInterface.php
363/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContextAwareInterface.php
364/vendor/symfony/symfony/src/Symfony/Component/Routing/Generator/UrlGeneratorInterface.php
365/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/RequestMatcherInterface.php
366/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContext.php
367/src/Adapter/Module/ModuleDataUpdater.php
368/src/Core/Addon/Module/ModuleManager.php
369/src/Core/Addon/AddonManagerInterface.php
370/src/Core/Addon/Module/ModuleRepository.php
371/src/Core/Addon/Module/ModuleRepositoryInterface.php
372/vendor/symfony/symfony/src/Symfony/Component/Finder/Finder.php
373/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ArrayCache.php
374/classes/Media.php
375/src/Core/Filter/CollectionFilter.php
376/src/Core/Filter/FilterInterface.php
377/src/Core/Filter/FrontEndObject/ProductFilter.php
378/src/Core/Filter/HashMapWhitelistFilter.php
379/src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php
380/src/Core/Filter/FrontEndObject/CartFilter.php
381/src/Core/Filter/FrontEndObject/CustomerFilter.php
382/src/Core/Filter/FrontEndObject/ShopFilter.php
383/src/Core/Filter/FrontEndObject/ConfigurationFilter.php
384/src/Core/Filter/FrontEndObject/MainFilter.php
385/modules/ps_searchbar/ps_searchbar.php
386/src/Core/Module/WidgetInterface.php
387/modules/ps_shoppingcart/ps_shoppingcart.php
388/modules/appagebuilder/classes/shortcodes/ApAccordions.php
389/modules/appagebuilder/classes/shortcodes/ApAlert.php
390/modules/appagebuilder/classes/shortcodes/ApBlockCarousel.php
391/modules/appagebuilder/classes/shortcodes/ApBlockLink.php
392/modules/appagebuilder/classes/shortcodes/ApBlog.php
393/modules/appagebuilder/classes/shortcodes/ApButton.php
394/modules/appagebuilder/classes/shortcodes/ApCategoryImage.php
395/modules/appagebuilder/classes/shortcodes/ApColumn.php
396/modules/appagebuilder/classes/shortcodes/ApCountdown.php
397/modules/appagebuilder/classes/shortcodes/ApFacebook.php
398/modules/appagebuilder/classes/shortcodes/ApFontAwesome.php
399/modules/appagebuilder/classes/shortcodes/ApFullSlider.php
400/modules/appagebuilder/classes/shortcodes/ApGenCode.php
401/modules/appagebuilder/classes/shortcodes/ApGmap.php
402/modules/appagebuilder/classes/shortcodes/ApHtml.php
403/modules/appagebuilder/classes/shortcodes/ApImage.php
404/modules/appagebuilder/classes/shortcodes/ApImage360.php
405/modules/appagebuilder/classes/shortcodes/ApImageGallery.php
406/modules/appagebuilder/classes/shortcodes/ApImageGalleryProduct.php
407/modules/appagebuilder/classes/shortcodes/ApImageHotspot.php
408/modules/appagebuilder/classes/shortcodes/ApInstagram.php
409/modules/appagebuilder/classes/shortcodes/ApManuFacturersCarousel.php
410/modules/appagebuilder/classes/shortcodes/ApMegamenu.php
411/modules/appagebuilder/classes/shortcodes/ApModule.php
412/modules/appagebuilder/classes/shortcodes/ApProductCarousel.php
413/modules/appagebuilder/classes/shortcodes/ApProductList.php
414/modules/appagebuilder/classes/shortcodes/ApProductTag.php
415/modules/appagebuilder/classes/shortcodes/ApQuicklogin.php
416/modules/appagebuilder/classes/shortcodes/ApRawHtml.php
417/modules/appagebuilder/classes/shortcodes/ApRow.php
418/modules/appagebuilder/classes/ApPageBuilderHookModel.php
419/modules/appagebuilder/classes/shortcodes/ApSlideShow.php
420/modules/appagebuilder/classes/shortcodes/ApSliderLayer.php
421/modules/appagebuilder/classes/shortcodes/ApTabs.php
422/modules/appagebuilder/classes/shortcodes/ApTwitter.php
423/modules/appagebuilder/classes/shortcodes/ApVideo.php
424/vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php
425/vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php
426/vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php
427/classes/Image.php
428/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php
429/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
430/var/cache/prod/smarty/compile/c4/93/d7/c493d71a9ce86d2a80a0ec1cce2a3755638192d5_2.file.header.tpl.php
431/vendor/smarty/smarty/libs/plugins/modifier.escape.php
432/modules/leobootstrapmenu/leobootstrapmenu.php
433/modules/leobootstrapmenu/classes/Btmegamenu.php
434/modules/leobootstrapmenu/classes/BtmegamenuGroup.php
435/modules/leobootstrapmenu/libs/Helper.php
436/modules/leobootstrapmenu/classes/widgetbase.php
437/modules/leobootstrapmenu/classes/widget.php
438/modules/leobootstrapmenu/translations/es.php
439/classes/Tab.php
440/var/cache/prod/smarty/compile/fc/45/ff/fc45ffe98c6378ea87b96648b5e8b04baca9655d_2.file.javascript_parameter.tpl.php
441/modules/ps_legalcompliance/ps_legalcompliance.php
442/modules/ps_legalcompliance/entities/AeucCMSRoleEmailEntity.php
443/modules/ps_legalcompliance/entities/AeucEmailEntity.php
444/src/Core/Foundation/Database/EntityManager.php
445/src/Core/Foundation/Database/DatabaseInterface.php
446/src/Adapter/Database.php
447/src/Core/Foundation/Filesystem/FileSystem.php
448/src/Core/Email/EmailLister.php
449/modules/leoslideshow/leoslideshow.php
450/modules/leoslideshow/classes/LeoSlideshowConfig.php
451/modules/leoslideshow/classes/LeoSlideshowGroup.php
452/modules/leoslideshow/classes/LeoSlideshowSlide.php
453/modules/leoslideshow/classes/LeoSlideshowStatus.php
454/modules/leoslideshow/libs/Helper.php
455/modules/leoslideshow/translations/es.php
456/modules/leofeature/leofeature.php
457/modules/leofeature/classes/ProductReviewCriterion.php
458/modules/leofeature/classes/ProductReview.php
459/modules/leofeature/classes/CompareProduct.php
460/modules/leofeature/classes/WishList.php
461/modules/leofeature/translations/es.php
462/modules/blockgrouptop/blockgrouptop.php
463/modules/blockgrouptop/translations/es.php
464/modules/leoquicklogin/leoquicklogin.php
465/modules/leoquicklogin/translations/es.php
466/modules/productsamples/productsamples.php
467/modules/productsamples/lib/bootstrap.php
468/modules/productsamples/lib/classes/PSControllerCore.php
469/modules/productsamples/models/PSInstall.php
470/modules/productsamples/models/PSProductSampleModel.php
471/modules/productsamples/models/PSCartSampleModel.php
472/modules/productsamples/helpers/PSHelper.php
473/modules/productsamples/helpers/PSAjaxResponse.php
474/modules/productsamples/controllers/admin/config/PSAdminConfigMainController.php
475/modules/productsamples/controllers/admin/producttab/PSAdminProductTabController.php
476/modules/productsamples/controllers/admin/producttab/PSAdminProductTabGeneralController.php
477/modules/productsamples/controllers/admin/producttab/PSAdminProductTabShippingController.php
478/modules/productsamples/controllers/front/PSProductFrontController.php
479/modules/productsamples/controllers/front/PSCartFrontController.php
480/modules/productsamples/translations/es.php
481/modules/angalimporter/angalimporter.php
482/modules/angalimporter/translations/es.php
483/modules/ps_emailalerts/ps_emailalerts.php
484/modules/ps_emailalerts/vendor/autoload.php
485/modules/ps_emailalerts/vendor/composer/autoload_real.php
486/modules/ps_emailalerts/vendor/composer/autoload_static.php
487/modules/ps_emailalerts/MailAlert.php
488/modules/ceca/ceca.php
489/modules/ceca/classes/CecaTpv.php
490/classes/PaymentModule.php
491/modules/ceca/translations/es.php
492/modules/stpreloader/stpreloader.php
493/modules/stpreloader/translations/es.php
494/var/cache/prod/smarty/cache/stpreloader/1/1/1/1/6/d8/ef/9b/d8ef9b9536cce263df8a05ed8788202c8a8aaaa0.stpreloaderviewstemplates.php
495/modules/paypalwithfee/paypalwithfee.php
496/modules/paypalwithfee/classes/PaypalOrder.php
497/modules/paypalwithfee/classes/PaypalRefund.php
498/modules/paypalwithfee/translations/es.php
499/modules/eicaptcha/eicaptcha.php
500/modules/eicaptcha/translations/es.php
501/modules/lgcookieslaw/lgcookieslaw.php
502/modules/lgcookieslaw/translations/es.php
503/modules/ets_abandonedcart/ets_abandonedcart.php
504/modules/ets_abandonedcart/classes/EtsAbancartMail.php
505/classes/Mail.php
506/modules/ets_abandonedcart/classes/EtsAbancartCampaign.php
507/modules/ets_abandonedcart/classes/EtsAbancartReminder.php
508/modules/ets_abandonedcart/classes/EtsAbancartEmailTemplate.php
509/modules/ets_abandonedcart/classes/EtsAbancartTracking.php
510/modules/ets_abandonedcart/classes/EtsAbancartIndex.php
511/modules/ets_abandonedcart/classes/EtsAbancartIndexCustomer.php
512/modules/ets_abandonedcart/classes/EtsAbancartCart.php
513/modules/ets_abandonedcart/classes/EtsAbancartShoppingCart.php
514/modules/ets_abandonedcart/classes/EtsAbancartUnsubscribers.php
515/modules/ets_abandonedcart/classes/EtsAbancartDefines.php
516/modules/ets_abandonedcart/translations/es.php
517/modules/ets_crosssell/ets_crosssell.php
518/modules/ets_crosssell/translations/es.php
519/vendor/defuse/php-encryption/src/Crypto.php
520/vendor/defuse/php-encryption/src/KeyOrPassword.php
521/vendor/defuse/php-encryption/src/RuntimeTests.php
522/vendor/defuse/php-encryption/src/DerivedKeys.php
523/vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
524/vendor/defuse/php-encryption/src/Exception/CryptoException.php
525/var/cache/prod/smarty/compile/08/9b/d9/089bd96b260d0fcc7d8bdf6767856923b86b4a98_2.file.header.tpl.php
526/modules/advansedcoupons/advansedcoupons.php
527/modules/advansedcoupons/classes/WsCoupons.php
528/modules/advansedcoupons/translations/es.php
529/modules/facebookconversiontrackingplus/facebookconversiontrackingplus.php
530/modules/facebookconversiontrackingplus/translations/es.php
531/modules/trustedshopsintegration/trustedshopsintegration.php
532/modules/trustedshopsintegration/config_prod.php
533/modules/trustedshopsintegration/parameters.php
534/modules/trustedshopsintegration/classes/tsid.php
535/modules/trustedshopsintegration/classes/TSMember.php
536/modules/trustedshopsintegration/classes/Api/TSApiClient.php
537/modules/trustedshopsintegration/classes/Api/TSApiResponse.php
538/modules/trustedshopsintegration/vendor/lib/totwebpack.php
539/modules/trustedshopsintegration/views/assets-manifest.php
540/modules/trustedshopsintegration/translations/es.php
541/modules/ganalytics/ganalytics.php
542/modules/ganalytics/es.php
543/src/Core/Product/Search/ProductSearchContext.php
544/src/Core/Product/Search/ProductSearchQuery.php
545/src/Core/Product/Search/SortOrder.php
546/modules/ps_facetedsearch/ps_facetedsearch.php
547/modules/ps_facetedsearch/src/Ps_FacetedsearchProductSearchProvider.php
548/modules/ps_facetedsearch/src/Ps_FacetedsearchFiltersConverter.php
549/modules/ps_facetedsearch/src/Ps_FacetedsearchFacetsURLSerializer.php
550/src/Core/Product/Search/ProductSearchProviderInterface.php
551/modules/ps_facetedsearch/src/Ps_FacetedsearchRangeAggregator.php
552/src/Core/Product/Search/ProductSearchResult.php
553/src/Core/Product/Search/Facet.php
554/src/Core/Product/Search/Filter.php
555/src/Core/Product/Search/URLFragmentSerializer.php
556/src/Core/Product/Search/FacetCollection.php
557/classes/Combination.php
558/classes/stock/StockAvailable.php
559/classes/ProductAssembler.php
560/classes/SpecificPrice.php
561/classes/tax/TaxManagerFactory.php
562/classes/tax/TaxRulesTaxManager.php
563/classes/tax/TaxManagerInterface.php
564/classes/tax/TaxCalculator.php
565/classes/GroupReduction.php
566/classes/Feature.php
567/classes/ProductPresenterFactory.php
568/src/Core/Product/ProductListingPresenter.php
569/src/Core/Product/ProductPresenter.php
570/src/Adapter/Product/ProductColorsRetriever.php
571/src/Core/Product/ProductPresentationSettings.php
572/var/cache/prod/smarty/compile/fa/cc/cb/facccb0b7bc281d226588ae550dd60f9e26f0558_2.file.facets.tpl.php
573/vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php
574/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
575/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php
576/var/cache/prod/smarty/compile/ef/af/9c/efaf9c75f3dacfbb4ab606860f29e2f22ff3b3af_2.file.active_filters.tpl.php
577/src/Core/Product/Search/Pagination.php
578/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/c2/17/33/c217333abf1faa467bf296f7c753872593f7010f_2.file.category.tpl.php
579/vendor/smarty/smarty/libs/plugins/modifier.replace.php
580/vendor/smarty/smarty/libs/plugins/shared.mb_str_replace.php
581/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/f9/ab/77/f9ab773a6baa08f52da65860991646841d004b47_2.file.product-list.tpl.php
582/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/f7/9c/64/f79c64c1e34715c77287c5b83e7aa1a92ad97cf5_2.file.layout-left-column.tpl.php
583/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/15/26/65/1526652e936147d7c1aab2b330c8de8b2576c95d_2.file.layout-both-columns.tpl.php
584/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/6a/40/e5/6a40e501c5f796506099f6471e8bcb1de4dd510f_2.file.head.tpl.php
585/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/0c/05/63/0c05633e4b55c1c46078ddf0709b79c0376f10f7_2.file.setting.tpl.php
586/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_updatescope.php
587/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ce/41/f0/ce41f096a5d830fd23a3f7ca6b7e239988bf9e6e_2.file.stylesheets.tpl.php
588/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/d3/44/a5/d344a5993d8b05d6161a4881108c64faef450c30_2.file.javascript.tpl.php
589/var/cache/prod/smarty/cache/stpreloader/1/1/1/1/6_/07/c6/ea/07c6ea404316e7bffcc3a0981eef69d81ad0e2ce.stpreloaderviewstemplates.php
590/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/03/4c/6b/034c6b0a6d5f9bd3376c63785054994d25c4cb0a_2.file.product-activation.tpl.php
591/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/8e/a1/60/8ea160f2b44e93aee170f839a76bb6573e5545e8_2.file.header.tpl.php
592/var/cache/prod/smarty/cache/appagebuilder/displayBanner/SSL_1/c_group_1/la_1/ctry_6/aa/52/ab/aa52aba68fc4e127a9284fc2faba882342b40462.appagebuilder.tpl.php
593/var/cache/prod/smarty/compile/70/0d/d9/700dd9784c1efcd379101d491cf3db21459498f3_2.file.ApGeneral.tpl.php
594/var/cache/prod/smarty/compile/69/6a/91/696a918c632730e83462f81478e27fbdd7d5a03b_2.file.ApColumn.tpl.php
595/var/cache/prod/smarty/compile/ed/e3/b3/ede3b385ae9550ec06530c2cafea3230829d7440_2.file.ApRow.tpl.php
596/var/cache/prod/smarty/compile/ee/9c/61/ee9c61822db488445a774f53a154c2b62eeaaae9_2.file.appagebuilder.tpl.php
597/var/cache/prod/smarty/compile/55/a3/87/55a387c98b791449536350c9c80b927d7879b489_2.file.ApGenCode.tpl.php
598/vendor/smarty/smarty/libs/sysplugins/smarty_internal_smartytemplatecompiler.php
599/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatecompilerbase.php
600/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_codeframe.php
601/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templateparser.php
602/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatelexer.php
603/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_literals.php
604/vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree_template.php
605/vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree.php
606/vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree_text.php
607/vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_private_print_expression.php
608/vendor/smarty/smarty/libs/sysplugins/smarty_internal_compilebase.php
609/vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree_tag.php
610/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_writefile.php
611/var/cache/prod/smarty/compile/5a/72/d8/5a72d86d285e5e4e09082743e4a418f8b0027b36_2.file.id_gencode_5a3a246a9eafc_1513759850.tpl.php
612/var/cache/prod/smarty/cache/1_2185617446_leobootstrapmenu/20240514/1/1/1/1/1/6/1/6f/63/2d/6f632dfc2fff5db001eb3fe61e3d39667510756d.leobootstrapmenuviewstemp.php
613/var/cache/prod/smarty/compile/18/9b/83/189b8342cbacdfcdff99052b4ec97d17966af144_2.file.ApMegamenu.tpl.php
614/var/cache/prod/smarty/compile/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.pssearchbarpssearchbar.tp.php
615/var/cache/prod/smarty/compile/9d/bb/41/9dbb4170bcba146f5fa0a29b6a89dcc4c4c462a2_2.file.ApModule.tpl.php
616/modules/ps_customersignin/ps_customersignin.php
617/var/cache/prod/smarty/compile/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.pscustomersigninpscustome.php
618/var/cache/prod/smarty/compile/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.psshoppingcartpsshoppingc.php
619/var/cache/prod/smarty/compile/34/7b/7b/347b7b2dbb0c5eb05f4041a2bbe49610278770b6_2.module.blockgrouptopviewstemplat.php
620/classes/CMS.php
621/var/cache/prod/smarty/compile/cf/3d/44/cf3d44c693054fb435a30f21b44a418701fc4b8a_2.file.cookieslaw.tpl.php
622/var/cache/prod/smarty/cache/appagebuilder/displayNavFullWidth/SSL_1/c_group_1/la_1/ctry_6/aa/52/ab/aa52aba68fc4e127a9284fc2faba882342b40462.appagebuilder.tpl.php
623/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/87/44/7e/87447e5b08b06a0d610ae51bdd9e0437ebd55bd1_2.file.notifications.tpl.php
624/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/3c/2c/35/3c2c35d91164551f7efb729ce55b8e8149101d9c_2.file.breadcrumb.tpl.php
625/var/cache/prod/smarty/cache/appagebuilder/displayLeftColumn/SSL_1/c_group_1/la_1/ctry_6/aa/52/ab/aa52aba68fc4e127a9284fc2faba882342b40462.appagebuilder.tpl.php
626/var/cache/prod/smarty/compile/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.psfacetedsearchpsfaceteds.php
627/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/69/ed/f5/69edf51bf8e2f059e2481592c16341b493109504_2.file.categories.tpl.php
628/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/6b/4d/50/6b4d50f0bc1c5c9152c0a8a7481aa2a827310558_2.file.leo_col_products.tpl.php
629/vendor/smarty/smarty/libs/plugins/function.math.php
630/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/bc/c7/62/bcc762f69f8ce049a9192364aefebd257f495169_2.file.pagination.tpl.php
631/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/5e/85/cf/5e85cf229fa4e76f80efd0dacb19db24cf0d5e20_2.file.products-bottom.tpl.php
632/var/cache/prod/smarty/compile/38/4a/2e/384a2e8888256bd499115a31e56f0fd0b907962a_2.file.layout_tab.tpl.php
633/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/d4/c0/b4/d4c0b4617675117872b7ea93301375f6e32116e0_2.file.footer.tpl.php
634/var/cache/prod/smarty/cache/appagebuilder/displayFooterBefore/SSL_1/c_group_1/la_1/ctry_6/aa/52/ab/aa52aba68fc4e127a9284fc2faba882342b40462.appagebuilder.tpl.php
635/var/cache/prod/smarty/compile/d3/4d/bc/d34dbcdf46b8fa7c62ec345f53e2975c725cc084_2.file.ApHtml.tpl.php
636/var/cache/prod/smarty/compile/98/a5/8c/98a58c059b760f3df2c8aaaf7331a264d2d11618_2.file.ApBlockLink.tpl.php
637/var/cache/prod/smarty/cache/appagebuilder/displayFooter/SSL_1/c_group_1/la_1/ctry_6/aa/52/ab/aa52aba68fc4e127a9284fc2faba882342b40462.appagebuilder.tpl.php
638/var/cache/prod/smarty/compile/9a/b6/36/9ab6366ec7137eb1725eca2e8c326ef3b47c0301_2.file.fo-head.tpl.php
639/var/cache/prod/smarty/compile/d9/6b/1d/d96b1d77eee6b6dfdc9653d5893fdaaabed03622_2.file.pixelheader.tpl.php
640/var/cache/prod/smarty/compile/f4/8e/ac/f48eac36ad6176f1688ca1b703934329d036b42f_2.file.addtocart.tpl.php
641/var/cache/prod/smarty/compile/0a/b5/66/0ab56646a2652658a793654a65f5ca80b889e46a_2.file.wishlist.tpl.php
642/var/cache/prod/smarty/compile/d6/30/06/d630067a3b961d2f50642a9367e32bc4eed5f6c9_2.file.category.tpl.php
643/var/cache/prod/smarty/compile/df/4e/ed/df4eedf060926e3fd119fc7b3c129ae355ca0158_2.file.trustbadge_js.tpl.php
644/vendor/smarty/smarty/libs/sysplugins/smarty_undefined_variable.php
645/var/cache/prod/smarty/compile/a6/23/09/a62309a87bfb97ceeafc2ca6515e5c5d004a86fd_2.file.ApImage.tpl.php
646/var/cache/prod/smarty/cache/appagebuilder/displayFooterAfter/SSL_1/c_group_1/la_1/ctry_6/aa/52/ab/aa52aba68fc4e127a9284fc2faba882342b40462.appagebuilder.tpl.php
647/modules/statsdata/statsdata.php
648/classes/Guest.php
649/classes/Connection.php
650/classes/Page.php
651/classes/ConnectionsSource.php
652/var/cache/prod/smarty/compile/af/e9/74/afe974643c400d6544c0608f1c7aec4ec20d70e3_2.module.leoquickloginviewstemplat.php
653/var/cache/prod/smarty/compile/01/53/db/0153dba508ba33b8497625ce148519b6db90fcee_2.module.leoquickloginviewstemplat.php
654/var/cache/prod/smarty/compile/bb/60/7d/bb607db04dfe36af201713ac4e202ee1dd4c7317_2.module.leoquickloginviewstemplat.php
655/var/cache/prod/smarty/compile/80/5c/e2/805ce2d86f1187d802d55b829fd8b831e391ad7c_2.module.leofeatureviewstemplatesf.php
656/var/cache/prod/smarty/compile/fd/e4/7e/fde47e68fca37f3f6dcb2391d9ed97c4e24edca6_2.module.leofeatureviewstemplatesf.php