Home

Filtri attivi

  • Categorie: Meo
  • Categorie: AXAS
  • Categorie: Quad
  • Categorie: MonoBlock
  • Categorie: Android TV box
  • Categorie: RADIO
  • Categorie: Ricondizionati

TESLA XT 850

Chiarezza 4K e suono Dolby – l’armonia perfetta tra immagine e audio

Tesla XT850 è un box Android TV™ certificato da Google, progettato per offrire un’esperienza di streaming fluida e di livello professionale. Grazie alle tecnologie Dolby Vision e Dolby Digital / Dolby Atmos, garantisce una qualità di immagine e suono immersiva, conforme agli standard più elevati del settore.

Accedi a Netflix in 4K e a numerose altre piattaforme come Disney+, HBO MAX, Prime Video, SkyShowtime, Starmax e molte altre.
La  XT850 è inoltre compatibile con le principali app IPTV: Skylink Live TV, Telly, Vodafone TV, T-Mobile TV GO, SledovaniTV, ecc. – molti di questi servizi sono preinstallati e pronti all’uso.

85,00 CHF Prezzo

Tesla XG500

Tesla XG500 – Tutto lo streaming e IPTV in un solo dispositivo

Il Tesla XG500 è un TV box Android TV™ certificato da Google, progettato per offrire un’esperienza di streaming fluida e di livello professionale. Grazie a Dolby Vision e Dolby Digital / Dolby Atmos, garantisce immagini e suoni immersivi, rispettando i più alti standard del settore.

Goditi Netflix in 4K e molte altre piattaforme come Disney+, HBO MAX, Prime Video, SkyShowtime, Starmax e altre ancora.
Il dispositivo è compatibile con le principali app IPTV: Skylink Live TV, Telly, Vodafone TV, T-Mobile TV GO, SledovaniTV, ecc. – diversi servizi sono già preinstallati per l’utilizzo immediato.

.

78,00 CHF Prezzo

X96Q 4K Andoid box

Android 10.0 TV Box - 4K HD X96Q Mini - 2GB RAM - 16GB ROM Box Android TV WiFi 2.4G H313 CPU Cortex A53 - Lettore multimediale per trasmettere il telefono sulla TV.

39,00 CHF Prezzo

X98H PRO 2GB+16GB

X98H Pro Smart TV box, Android 12, Quad Core, 4K, 2 GB + 16 GB, set-top box, lettore multimediale con WIFI 2.4/5 ghz, Bluetooth 5.0, profilo VP9

47,00 CHF Prezzo

Android X98H PRO 4K

- Prestazioni del superprocessore Allwinner H618
- Potente processore grafico Android 12.0
- Wi-Fi Dual Band
- Riproduzione HD 4K
- riproduzione H.265 HEVC e HDR10+
- supporta il Bluetooth 5.0+

57,00 CHF Prezzo

X96 Max

  • CPU: Amlogic S905X3 64-bit quad core ARM® Cortex™ A55 CPU
  • GPU: G31™ MP2 GPU processor
  • RAM : 2G
  • ROM: 16G
  • Android 9.0 
  • Lan: Ethernet Interface;Support 10/100M/1000M
49,00 CHF Prezzo

H96 MINI

49,00 CHF Prezzo

TECHNISAT DIGITRADIO 600 -...

Tipo di prodotto:
    Radio digitale
Tipo di operazione:
    Sul settore
Tipi di ricezione:
    DAB+, FM, radio Internet
Trasferimento di musica:
    Bluetooth
WLAN:
    Sì
Bluetooth:
    Sì
RDS (Radio Data System):
    Sì

329,00 CHF Prezzo

HAMA DIR3115MS - Radio...


Tipo di prodotto:
    Radio digitale
Tipo di operazione:
    Alimentazione di rete / a batteria
Tipi di ricezione:
    DAB+, FM, radio Internet
WLAN:
    Sì
Potenza massima:
    10 W
Stazioni memorabili:
    30x UKW, 30x DAB+.
Antenna:
    Antenna telescopica

220,00 CHF Prezzo
Load Time1164 ms - OK... for a shared hosting
Querying Time826 ms
Queries416
Memory Peak Usage40.7 Mb
Included Files722 files - 8.92 Mb
PrestaShop Cache- Mb
Global vars0.66 Mb
PrestaShop Version1.7.3.2
PHP Version7.1.33 (OK)
MySQL Version5.7.30-log (OK)
Memory Limit1280M
Max Execution Time300s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 81 ms 81 ms 11.85 Mb 12.04 Mb
__construct 0 ms 81 ms - Mb 12.04 Mb
init 71 ms 152 ms 6.16 Mb 18.06 Mb
checkAccess 0 ms 152 ms - Mb 18.06 Mb
setMedia 0 ms 152 ms 0.01 Mb 18.06 Mb
postProcess 0 ms 152 ms - Mb 18.06 Mb
initHeader 0 ms 152 ms - Mb 18.06 Mb
initContent 900 ms 1053 ms 18.41 Mb 36.64 Mb
initFooter 0 ms 1053 ms - Mb 36.64 Mb
display 111 ms 1164 ms 3.81 Mb 40.72 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 - 416 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE DISTINCT p.`id_product`, product_shop.`condition` 
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 >= 2
AND c.nright <= 103
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_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58)
 54.9 64184742336 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE DISTINCT p.`id_product`, product_shop.`condition` 
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 >= 2
AND c.nright <= 103
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_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
 51.2 1337182132 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name 
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 >= 2
AND c.nright <= 103
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_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58) 
GROUP BY p.id_manufacturer ORDER BY m.name
 49.9 886005120 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 1 AND lpa.`id_shop` = 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58) 
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 49.6 417688128 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE DISTINCT p.`id_product`, sa.`quantity`, sa.`out_of_stock` 
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 >= 2
AND c.nright <= 103
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
LEFT JOIN `ps_stock_available` sa
ON (sa.id_product = p.id_product AND sa.id_product_attribute=0  AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
 48.9 153205052 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE DISTINCT p.`id_product`, sa.`quantity`, sa.`out_of_stock` 
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 >= 2
AND c.nright <= 103
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
LEFT JOIN `ps_stock_available` sa
ON (sa.id_product = p.id_product AND sa.id_product_attribute=0  AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58)
 48 7353842496 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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 >= 2
AND c.nright <= 103
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)LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58)
 45.5 7353842496 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name 
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 >= 2
AND c.nright <= 103
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_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
GROUP BY p.id_manufacturer ORDER BY m.name
 45.5 18458440 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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 >= 2
AND c.nright <= 103
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)LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
 45.2 153205052 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE p.`id_product`, p.`weight` 
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 >= 2
AND c.nright <= 103
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
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58)
 44.9 7353842496 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 1 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 44.6 8701836 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE p.`id_product`, p.`weight` 
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 >= 2
AND c.nright <= 103
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
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
 43.4 153205052 /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 3 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 14.3 2900612 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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`)
 7.5 3864 /classes/Configuration.php:157 
SELECT SQL_NO_CACHE 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("2026-05-11 00:00:00", INTERVAL 200 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_product cp
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 cp.`id_category` IN (32,35,39,41,45,51,58)  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT id_product FROM ps_category_product cp WHERE cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58)
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 = 3)
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` = 3)
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")
ORDER BY p.date_add desc , cp.id_product LIMIT 0,12
 6.4 192 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1562 
SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
FROM ps_category_product cp
LEFT JOIN ps_product p ON (p.id_product = cp.id_product)  INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 3) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 2
AND c.nright < 103
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
 4.8 550 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
FROM ps_category_product cp
LEFT JOIN ps_product p ON (p.id_product = cp.id_product)  INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 3) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 2
AND c.nright < 103
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
 4 550 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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
 3.9 362 /classes/Hook.php:374 
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`
 3.2 1470 Yes Yes /classes/Hook.php:629 
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` = 3)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
 2.9 244 Yes /classes/Country.php:146 
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` = 3  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 2
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 2.5 52 Yes Yes /classes/Category.php:821 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 4 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 2.3 2900612 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
SELECT SQL_NO_CACHE COUNT(*) FROM  (SELECT cp.id_product, MIN(cp.position) position FROM ps_category_product cp
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 cp.`id_category` IN (32,35,39,41,45,51,58)  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT id_product FROM ps_category_product cp WHERE cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58)
GROUP BY cp.id_product) ps LIMIT 1
 2.1 96 /modules/ps_facetedsearch/ps_facetedsearch.php:1527 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 693
ORDER BY f.position ASC
 1.8 1 Yes /classes/Product.php:4860 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 3 AND lpa.`id_shop` = 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58) 
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 1.8 139229376 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 2 AND lpa.`id_shop` = 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58) 
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 1.5 139229376 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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` = 693 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` = 693 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.5 0 /classes/Cart.php:1197 
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
 1.4 0 /classes/Hook.php:186 
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` = 577 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` = 577 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.3 0 /classes/Cart.php:1197 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 4 AND lpa.`id_shop` = 1 AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = 32 OR cp.`id_category` = 35 OR cp.`id_category` = 39 OR cp.`id_category` = 41 OR cp.`id_category` = 45 OR cp.`id_category` = 51 OR cp.`id_category` = 58) 
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 1.3 139229376 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2026-05-11 00:00:00" AND date_to <= "2026-05-11 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2026-05-11 00:00:00" AND date_from <= "2026-05-11 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 1.2 1 /classes/CartRule.php:326 
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
 1.1 324 Yes /classes/Country.php:153 
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 = 3
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 >= 2
AND c.nright <= 103
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 = 3
LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)
LEFT JOIN ps_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 2 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
 1.1 2900612 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1909 
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` = 445 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` = 445 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.1 0 /classes/Cart.php:1197 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 577) AND (b.`id_shop` = 1) LIMIT 1
 1.1 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(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 692
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 1 1 /classes/ProductAssembler.php:91 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 693) AND (b.`id_shop` = 1) LIMIT 1
 1 1 /src/Adapter/EntityMapper.php:67 
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
 1 204 Yes /classes/Dispatcher.php:530 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 445
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 1 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 693
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.9 1 /classes/ProductAssembler.php:91 
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.9 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (391) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.9 1 Yes Yes /classes/Product.php:3788 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 445) AND (b.`id_shop` = 1) LIMIT 1
 0.9 1 /src/Adapter/EntityMapper.php:67 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 472
ORDER BY f.position ASC
 0.8 1 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (469) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.8 1 Yes 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.8 99 /classes/module/Module.php:301 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 473
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.8 1 /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` = 363 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` = 363 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.8 0 /classes/Cart.php:1197 
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` = 3)
WHERE i.`id_product` = 469
ORDER BY `position`
 0.8 4 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (577) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.8 1 Yes Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 34
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.8 1 Yes Yes /classes/Category.php:1046 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 693
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.8 0 /classes/Product.php:6020 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 65
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.8 1 Yes Yes /classes/Category.php:1046 
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` = 469 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` = 469 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.8 0 /classes/Cart.php:1197 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 363
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.8 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE * FROM ps_wb_staticblock AS psb 
LEFT JOIN ps_wb_staticblock_lang AS psl ON psb.id_wbstaticblock = psl.id_wbstaticblock
LEFT JOIN ps_wb_staticblock_shop AS pss ON psb.id_wbstaticblock = pss.id_wbstaticblock
WHERE id_shop =1 
AND id_lang =3
AND `hook_position` = "displayNav1" 
AND `showhook` = 1 ORDER BY `wborder` ASC
 0.8 4 Yes /modules/wbstaticblocks/models/Staticblock.php:113 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (472) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.8 1 Yes Yes /classes/Product.php:3788 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 391
ORDER BY f.position ASC
 0.8 1 Yes /classes/Product.php:4860 
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` = 391 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` = 391 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.8 0 /classes/Cart.php:1197 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 364
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.8 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 64
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 692) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:67 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 364) AND (b.`id_shop` = 1) LIMIT 1
 0.7 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.7 1 Yes /classes/shop/Shop.php:692 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 66
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 578
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.7 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (693) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.7 1 Yes Yes /classes/Product.php:3788 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 472) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 27
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 391
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.7 1 /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` = 579 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` = 579 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.7 0 /classes/Cart.php:1197 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 19
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
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` = 693)
 0.7 1 /classes/Product.php:3280 
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` = 364 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` = 364 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.7 0 /classes/Cart.php:1197 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 37
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
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` = 65) AND (b.`id_shop` = 1) LIMIT 1
 0.7 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(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 469
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.7 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 472
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.7 1 /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` = 472 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` = 472 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.7 0 /classes/Cart.php:1197 
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` = 578 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` = 578 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.7 0 /classes/Cart.php:1197 
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.7 99 /classes/module/Module.php:301 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 577
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.7 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 30
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 6
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 5 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-05-11 00:00:00',
INTERVAL 200 DAY
)
) > 0) as new
FROM ps_product p
INNER JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
AND p.id_product = 579
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.7 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 41
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 473) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 8
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 14
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 52 Yes Yes /classes/Category.php:1046 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 363) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:67 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 579) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 62
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 49
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.7 1 Yes Yes /classes/Category.php:1046 
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` = 692 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` = 692 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.6 0 /classes/Cart.php:1197 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (363) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 61
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 39
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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` = 30) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 1
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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.6 1 /src/Adapter/EntityMapper.php:67 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 578) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 44
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 692 LIMIT 1
 0.6 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 32
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 32825380
AND `date_add` > '2026-05-11 16:10:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.6 1 Yes /classes/Connection.php:162 
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` = 692)
 0.6 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (364) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 51
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 469
ORDER BY f.position ASC
 0.6 1 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 43
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 3
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 52 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 4
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 52 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 52
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 577
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.6 0 /classes/Product.php:6020 
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` = 19) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 469) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 7
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 578
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.6 0 /classes/Product.php:6020 
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` = 473 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` = 473 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.6 0 /classes/Cart.php:1197 
SELECT SQL_NO_CACHE * FROM ps_wb_staticblock AS psb 
LEFT JOIN ps_wb_staticblock_lang AS psl ON psb.id_wbstaticblock = psl.id_wbstaticblock
LEFT JOIN ps_wb_staticblock_shop AS pss ON psb.id_wbstaticblock = pss.id_wbstaticblock
WHERE id_shop =1 
AND id_lang =3
AND `hook_position` = "displayFooterDown" 
AND `showhook` = 1 ORDER BY `wborder` ASC
 0.6 4 Yes /modules/wbstaticblocks/models/Staticblock.php:113 
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` = 3)
WHERE i.`id_product` = 578
ORDER BY `position`
 0.6 6 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 47) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 29
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (692) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3788 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 391) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
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` = 3)
WHERE i.`id_product` = 579
ORDER BY `position`
 0.6 6 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (445) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3788 
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` = 6) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
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.6 99 /classes/module/Module.php:301 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 45
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (579) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3788 
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` = 32) AND (b.`id_shop` = 1) LIMIT 1
 0.6 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 35) AND (b.`id_shop` = 1) LIMIT 1
 0.6 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` = 19
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('1020' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '1020')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.6 0 /classes/tax/TaxRulesTaxManager.php:110 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (578) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3788 
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` = 10) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (473) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.6 1 Yes Yes /classes/Product.php:3788 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 42
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 4 Yes Yes /classes/Category.php:1046 
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` = 49) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 9
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 473
AND pc.`deleted` = 0 LIMIT 1
 0.6 1 /modules/wbfeature/classes/ProductReview.php:205 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 50
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 472
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.6 0 /classes/Product.php:6020 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 579
ORDER BY f.position ASC
 0.6 1 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` = 3)
WHERE i.`id_product` = 693
ORDER BY `position`
 0.6 8 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 33
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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` = 3)
WHERE i.`id_product` = 577
ORDER BY `position`
 0.6 7 Yes /classes/Product.php:2984 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 363
ORDER BY f.position ASC
 0.6 1 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` = 3)
WHERE i.`id_product` = 445
ORDER BY `position`
 0.6 1 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 36
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 46
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
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` = 19) LIMIT 1
 0.6 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` = 3)
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` = 3)
WHERE pa.`id_product` = 363
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.6 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` = 3
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.6 1 /src/Adapter/EntityMapper.php:67 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 445
ORDER BY f.position ASC
 0.6 1 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 2
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.6 10 Yes Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1650 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 578
ORDER BY f.position ASC
 0.6 1 Yes /classes/Product.php:4860 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 35
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 15
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 2) AND (a0.`nright` > 103) AND (a1.`id_lang` = 3)
ORDER BY a0.`nleft` asc
 0.6 4 /classes/PrestaShopCollection.php:357 
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` = 33) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM ps_wb_staticblock AS psb 
LEFT JOIN ps_wb_staticblock_lang AS psl ON psb.id_wbstaticblock = psl.id_wbstaticblock
LEFT JOIN ps_wb_staticblock_shop AS pss ON psb.id_wbstaticblock = pss.id_wbstaticblock
WHERE id_shop =1 
AND id_lang =3
AND `hook_position` = "displayTop" 
AND `showhook` = 1 ORDER BY `wborder` ASC
 0.5 4 Yes /modules/wbstaticblocks/models/Staticblock.php:113 
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` = 14) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM `ps_image_type`
 0.5 7 /classes/ImageType.php:144 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 469
 0.5 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 40
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.5 83 /classes/Hook.php:226 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 25
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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` = 26) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 577)
 0.5 1 /classes/Product.php:3280 
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` = 15) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 34) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 692
ORDER BY f.position ASC
 0.5 1 Yes /classes/Product.php:4860 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 577
ORDER BY f.position ASC
 0.5 1 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 37) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
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 = 'groupemedia.ch' OR su.domain_ssl = 'groupemedia.ch')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.5 1 Yes /classes/shop/Shop.php:344 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 16
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 12
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 473
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.5 0 /classes/Product.php:6020 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 18
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 364
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
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` = 3)
WHERE i.`id_product` = 391
ORDER BY `position`
 0.5 4 Yes /classes/Product.php:2984 
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` = 2) LIMIT 1
 0.5 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` = 3
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.5 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` = 391)
 0.5 1 /classes/Product.php:3280 
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` = 48) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 445) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.5 1 /classes/stock/StockAvailable.php:383 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 469
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.5 0 /classes/Product.php:6020 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 60
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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.5 4 /classes/Language.php:881 
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` = 52) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 692
 0.5 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE * FROM ps_wb_staticblock AS psb 
LEFT JOIN ps_wb_staticblock_lang AS psl ON psb.id_wbstaticblock = psl.id_wbstaticblock
LEFT JOIN ps_wb_staticblock_shop AS pss ON psb.id_wbstaticblock = pss.id_wbstaticblock
WHERE id_shop =1 
AND id_lang =3
AND `hook_position` = "displayNavFullWidth" 
AND `showhook` = 1 ORDER BY `wborder` ASC
 0.5 4 Yes /modules/wbstaticblocks/models/Staticblock.php:113 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 5
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 364
ORDER BY f.position ASC
 0.5 1 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 46) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
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` = 3)
WHERE i.`id_product` = 364
ORDER BY `position`
 0.5 4 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.5 1 /classes/shop/ShopUrl.php:169 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 445
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.5 0 /classes/Product.php:6020 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 48
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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` = 28) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 19
AND tr.`id_tax_rules_group` = 0
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.5 0 /classes/tax/TaxRulesTaxManager.php:110 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2026-05-11 00:00:00" AND date_to <= "2026-05-11 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2026-05-11 00:00:00" AND date_from <= "2026-05-11 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.5 1 /classes/CartRule.php:326 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 391
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.5 0 /classes/Product.php:6020 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 47
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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` = 9) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.5 1 /classes/module/Module.php:2066 
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` = 45) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 27) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 445)
 0.5 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.5 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.5 5 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 28
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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` = 29) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 364)
 0.5 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 693 LIMIT 1
 0.5 1 /classes/SpecificPrice.php:405 
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 = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
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 = 473
ORDER BY f.position ASC
 0.5 1 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` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 58
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
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` = 19) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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.5 4 Yes /classes/Currency.php:262 
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` = 3)
WHERE i.`id_product` = 473
ORDER BY `position`
 0.5 1 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
 0.5 5 /src/Adapter/EntityMapper.php:74 
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` = 39) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 51) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
 0.5 1 /classes/SpecificPrice.php:396 
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` = 3)
WHERE i.`id_product` = 472
ORDER BY `position`
 0.5 6 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 50) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 7) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 66) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 67) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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.5 4 /classes/Currency.php:603 
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` = 58) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
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.5 4 /classes/Language.php:1028 
SELECT SQL_NO_CACHE * FROM ps_wb_staticblock AS psb 
LEFT JOIN ps_wb_staticblock_lang AS psl ON psb.id_wbstaticblock = psl.id_wbstaticblock
LEFT JOIN ps_wb_staticblock_shop AS pss ON psb.id_wbstaticblock = pss.id_wbstaticblock
WHERE id_shop =1 
AND id_lang =3
AND `hook_position` = "displayFooterBefore" 
AND `showhook` = 1 ORDER BY `wborder` ASC
 0.5 4 Yes /modules/wbstaticblocks/models/Staticblock.php:113 
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` = 36) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
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` = 3)
WHERE i.`id_product` = 363
ORDER BY `position`
 0.5 4 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` = 3)
WHERE i.`id_product` = 692
ORDER BY `position`
 0.5 6 Yes /classes/Product.php:2984 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 2
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.5 10 Yes Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1650 
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` = 3)
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` = 3)
WHERE pa.`id_product` = 579
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.5 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 44) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.5 1 /classes/shop/Shop.php:1127 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 2 AND ctg.`id_group` = 1 LIMIT 1
 0.5 1 /classes/Category.php:1587 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 693) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.5 1 /classes/stock/StockAvailable.php:383 
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` = 40) AND (b.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 577 LIMIT 1
 0.5 1 /classes/SpecificPrice.php:405 
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` = 473)
 0.5 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 10
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 693 AND `id_group` = 1 LIMIT 1
 0.4 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 26
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 1 Yes Yes /classes/Category.php:1046 
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` = 5
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 38) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 42) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 445
 0.4 1 /classes/Product.php:2416 
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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 578)
 0.4 1 /classes/Product.php:3280 
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` = 31) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 2) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.4 83 /classes/Hook.php:249 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 38
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 1 Yes Yes /classes/Category.php:1046 
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` = 3) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 3)
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` = 3)
WHERE pa.`id_product` = 692
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 3
 0.4 0 /classes/Product.php:6020 
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` = 579)
 0.4 1 /classes/Product.php:3280 
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` = 64) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 41) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 472)
 0.4 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 31
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 1 Yes Yes /classes/Category.php:1046 
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` = 62) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 19 LIMIT 1
 0.4 1 /classes/AddressFormat.php:616 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.4 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:67 
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.4 1 /classes/shop/Shop.php:203 
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` = 61) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 3
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.4 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` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 60) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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` = 363)
 0.4 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.4 7 Yes /classes/ImageType.php:108 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 445 LIMIT 1
 0.4 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 67
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 1 Yes Yes /classes/Category.php:1046 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 473 LIMIT 1
 0.4 1 /classes/SpecificPrice.php:405 
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` = 469)
 0.4 1 /classes/Product.php:3280 
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description`
FROM `ps_category_lang` cl
WHERE cl.`id_lang` = 3
AND cl.`id_category` = 2 AND cl.id_shop = 1 LIMIT 1
 0.4 1 /classes/Meta.php:387 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.4 1 /classes/ObjectModel.php:1416 
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` = 43) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.4 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` = 3
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.4 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2040301 AND name = '_wp_page_template' LIMIT 1
 0.4 1 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 579 LIMIT 1
 0.4 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 391) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 391 AND id_shop=1 LIMIT 1
 0.4 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 469 LIMIT 1
 0.4 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2040301 AND name = '_wp_page_template' LIMIT 1
 0.4 1 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 473 AND id_shop=1 LIMIT 1
 0.4 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 364 AND `id_group` = 1 LIMIT 1
 0.4 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "spsearchpro" LIMIT 1
 0.4 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2040301 AND name = '_elementor_edit_mode' LIMIT 1
 0.4 1 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE COUNT(`id_product_review`) AS "nbr"
FROM `ps_wbfeature_product_review` pc
WHERE `id_product` = 473 LIMIT 1
 0.4 1 /modules/wbfeature/classes/ProductReview.php:252 
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` = 3) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 469
AND pc.`deleted` = 0 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:193 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 391 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 473
AND pc.`deleted` = 0 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:193 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 472 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 2040301 AND name = '_elementor_page_settings' LIMIT 1
 0.3 1 /modules/creativeelements/classes/wrappers/Post.php:266 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 469) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 693
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 469
AND pc.`deleted` = 0 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:205 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/ObjectModel.php:1548 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 577) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 364 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 445 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "saferpaycw" LIMIT 1
 0.3 1 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 19
 0.3 5 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 3
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/ObjectModel.php:1548 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 445 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 579
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 99 AND `id_shop` = 1 LIMIT 1
 0.3 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/ObjectModel.php:1548 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 363) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 472) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 578) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 364 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 472 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 693 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 469 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 472
AND pc.`deleted` = 0 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:193 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "jmsajaxsearch" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.3 1 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 473
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 364) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 363 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 363
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 391
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 577
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 19 LIMIT 1
 0.3 1 /classes/Country.php:271 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 578 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:405 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
 0.3 1 /classes/Category.php:1269 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 473 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE COUNT(`id_product_review`) AS "nbr"
FROM `ps_wbfeature_product_review` pc
WHERE `id_product` = 472 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:252 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmsearch" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 579) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 472
AND pc.`deleted` = 0 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:205 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 577 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 692) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 391 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 391
AND pc.`deleted` = 0 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:205 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 472
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
 0.3 1 /classes/Group.php:150 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "labblocksearch" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 473) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:383 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 578 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_wbfeature_product_review` pc
WHERE pc.`id_product` = 391
AND pc.`deleted` = 0 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:193 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocksearch_mod" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stsearchbar" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 577 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leoproductsearch" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 364
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 578
 0.3 1 /classes/Product.php:2416 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 2 LIMIT 1
 0.3 1 /classes/Product.php:4634 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 472 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 692 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.3 1 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1
 0.3 1 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tvcmssearch" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ttblocksearch" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 0.3 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 579 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 692 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE COUNT(`id_product_review`) AS "nbr"
FROM `ps_wbfeature_product_review` pc
WHERE `id_product` = 391 LIMIT 1
 0.3 1 /modules/wbfeature/classes/ProductReview.php:252 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 363 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Product.php:5515 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tdsearchblock" LIMIT 1
 0.3 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'it' LIMIT 1
 0.3 4 /classes/Language.php:721 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.2 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.2 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bonsearch" LIMIT 1
 0.2 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE COUNT(`id_product_review`) AS "nbr"
FROM `ps_wbfeature_product_review` pc
WHERE `id_product` = 469 LIMIT 1
 0.2 1 /modules/wbfeature/classes/ProductReview.php:252 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.2 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 469 AND `id_group` = 1 LIMIT 1
 0.2 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.2 0 /classes/module/Module.php:2151 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 579 AND `id_group` = 1 LIMIT 1
 0.2 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 578 AND `id_group` = 1 LIMIT 1
 0.2 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "labsearch" LIMIT 1
 0.2 0 /classes/module/Module.php:2599 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 363 AND `id_group` = 1 LIMIT 1
 0.2 0 /classes/GroupReduction.php:149

Doubles

55
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
52
SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
			FROM `ps_category` c
			LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX )
			 INNER JOIN ps_category_shop category_shop
        ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX)
			WHERE `id_lang` = XX
			AND c.`id_parent` = XX
			AND `active` = XX
			GROUP BY c.`id_category`
			ORDER BY category_shop.`position` ASC
14
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
13
SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
12
			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`
12
							SELECT `id_tax_rules_group`
							FROM `ps_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
12
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
12
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
12
SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
12
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
12
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
12
				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
12
			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
12
SELECT `id_product_attribute`
			FROM `ps_product_attribute`
			WHERE `id_product` = XX
12
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
                INNER JOIN ps_product_lang pl
                    ON pl.id_product = p.id_product
                    AND pl.id_shop = XX
                    AND pl.id_lang = XX
                    AND p.id_product = XX
                LEFT JOIN ps_stock_available sa
			        ON sa.id_product = p.id_product 
			        AND sa.id_shop = XX
12
			SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, 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)
			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`
			
			ORDER BY a.`position` ASC;
12
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)
12
			SELECT `minimal_quantity`
			FROM `ps_product_attribute_shop` pas
			WHERE `id_shop` = XX
			AND `id_product_attribute` = XX LIMIT XX
4
                        SELECT 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 = XX
                        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 = 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 = XX
                        LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
                        ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_attribute_lang_value lial
                        ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = XX) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = XX AND lpa.`id_shop` = XX

                        GROUP BY lpa.id_attribute
                        ORDER BY ag.`position` ASC, a.`position` ASC
4
SELECT COUNT(`id_product_review`) AS "nbr"
                FROM `ps_wbfeature_product_review` pc
                WHERE `id_product` = XX LIMIT XX
4
SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
                MIN(pc.`grade`) AS min,
                MAX(pc.`grade`) AS max
            FROM `ps_wbfeature_product_review` pc
            WHERE pc.`id_product` = XX
            AND pc.`deleted` = XX LIMIT XX
4
SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
            FROM `ps_wbfeature_product_review` pc
            WHERE pc.`id_product` = XX
            AND pc.`deleted` = XX LIMIT XX
4
                        SELECT 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 = XX
                        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 = 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 = XX
                        LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl
                        ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_attribute_lang_value lial
                        ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = XX) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = XX AND lpa.`id_shop` = XX AND EXISTS (SELECT * FROM ps_category_product cp WHERE id_product = p.id_product AND cp.`id_category` = XX OR cp.`id_category` = XX OR cp.`id_category` = XX OR cp.`id_category` = XX OR cp.`id_category` = XX OR cp.`id_category` = XX OR cp.`id_category` = XX) 

                        GROUP BY lpa.id_attribute
                        ORDER BY ag.`position` ASC, a.`position` ASC
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
2
SELECT * FROM `ps_hook_alias`
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) LIMIT XX
2
SELECT value FROM ps_ce_meta WHERE id = XX AND name = '_wp_page_template' LIMIT XX
2
SELECT *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX
WHERE (a.`id_currency` = 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 c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 

                        FROM ps_category_product cp
                        LEFT JOIN ps_product p ON (p.id_product = cp.id_product)  INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 

                        WHERE cp.id_category = c.id_category
                        AND product_shop.active = XX AND product_shop.`visibility` IN ("both", "catalog")
) count_products
                        FROM ps_category c
                        LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = XX and cl.id_lang = XX) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (XX)) WHERE c.nleft > XX
                        AND c.nright < XX
                        
                        AND c.active = XX
                        GROUP BY c.id_category ORDER BY c.nleft, c.position
2
				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

Tables stress

130 category
126 category_lang
109 category_shop
71 product
61 product_shop
49 product_attribute_shop
36 product_attribute
33 category_product
32 attribute_lang
32 attribute
27 stock_available
25 product_lang
24 product_attribute_combination
24 cart_product
21 manufacturer
20 attribute_group
20 attribute_group_lang
20 module
19 module_shop
13 specific_price
13 image_shop
13 image_lang
12 feature_shop
12 wbfeature_product_review
12 feature
12 feature_value_lang
12 pack
12 feature_lang
12 product_group_reduction_cache
12 feature_product
12 image
8 layered_product_attribute
8 layered_indexable_attribute_lang_value
8 layered_indexable_attribute_group_lang_value
5 currency_shop
5 wb_staticblock
5 wb_staticblock_lang
5 wb_staticblock_shop
4 ce_meta
4 shop_url
4 country
4 lang_shop
4 hook
4 cart_rule
4 category_group
4 lang
4 shop
4 currency
3 country_lang
3 country_shop
3 hook_alias
2 hook_module
2 layered_price_index
2 group
2 tax_rule
2 group_shop
2 configuration
2 shop_group
2 image_type
2 layered_category
2 tax_rules_group
1 configuration_lang
1 zone
1 state
1 meta
1 module_group
1 meta_lang
1 group_lang
1 hook_module_exceptions
1 address_format
1 required_field
1 connections

ObjectModel instances

NameInstancesSource
Category 93 /controllers/front/listing/CategoryController.php [70]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/controllers/front/listing/CategoryController.php [161]
/classes/PrestaShopCollection.php [359]
/modules/ps_facetedsearch/ps_facetedsearch.php [1644]
/modules/ps_facetedsearch/ps_facetedsearch.php [1312]
/modules/ps_facetedsearch/ps_facetedsearch.php [1644]
/modules/creativeelements/classes/wrappers/Post.php [100]
/modules/creativeelements/classes/wrappers/Post.php [100]
/modules/creativeelements/classes/wrappers/Post.php [100]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/modules/wbblocksearch/wbblocksearch.php [225]
/classes/Link.php [372]
/classes/Link.php [372]
/classes/Link.php [372]
/classes/Link.php [372]
/classes/Link.php [372]
/classes/Link.php [372]
Product 48 /classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
/classes/Link.php [99]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [99]
/classes/Link.php [99]
Combination 12 /classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
/classes/Product.php [4791]
Country 5 /config/config.inc.php [143]
/classes/AddressFormat.php [353]
/classes/controller/FrontController.php [1683]
/classes/AddressFormat.php [353]
/modules/ps_contactinfo/ps_contactinfo.php [99]
Address 4 /classes/shop/Shop.php [465]
/classes/Product.php [3123]
/classes/Product.php [3223]
/classes/Product.php [4812]
Currency 3 /classes/Tools.php [597]
/modules/ps_currencyselector/ps_currencyselector.php [100]
/modules/ps_googleanalytics/ps_googleanalytics.php [460]
Cart 3 /classes/controller/FrontController.php [414]
/classes/controller/FrontController.php [719]
/classes/controller/FrontController.php [719]
AddressFormat 2 /classes/controller/FrontController.php [1677]
/modules/ps_contactinfo/ps_contactinfo.php [93]
Language 2 /config/config.inc.php [196]
/classes/Tools.php [485]
State 2 /classes/controller/FrontController.php [1682]
/modules/ps_contactinfo/ps_contactinfo.php [98]
Shop 1 /config/config.inc.php [117]
Staticblock 1 /modules/wbstaticblocks/wbstaticblocks.php [69]
Gender 1 /classes/controller/FrontController.php [1644]
Risk 1 /classes/controller/FrontController.php [1647]
Group 1 /classes/Cart.php [225]
Customer 1 /config/config.inc.php [222]
ShopGroup 1 /classes/shop/Shop.php [547]
PrivateSale 1 /modules/privatesales/privatesales.php [390]

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/app/cache/dev/class_index.php
8/app/autoload.php
9/vendor/autoload.php
10/vendor/composer/autoload_real.php
11/vendor/composer/ClassLoader.php
12/vendor/composer/include_paths.php
13/vendor/composer/autoload_static.php
14/vendor/react/promise/src/functions_include.php
15/vendor/react/promise/src/functions.php
16/vendor/swiftmailer/swiftmailer/lib/swift_required.php
17/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
18/vendor/paragonie/random_compat/lib/random.php
19/vendor/icanboogie/common/bootstrap.php
20/vendor/icanboogie/common/lib/helpers.php
21/vendor/ircmaxell/password-compat/lib/password.php
22/vendor/symfony/polyfill-php70/bootstrap.php
23/vendor/symfony/polyfill-php56/bootstrap.php
24/vendor/symfony/polyfill-php55/bootstrap.php
25/vendor/symfony/polyfill-php54/bootstrap.php
26/vendor/symfony/polyfill-mbstring/bootstrap.php
27/vendor/symfony/polyfill-intl-icu/bootstrap.php
28/vendor/symfony/polyfill-apcu/bootstrap.php
29/vendor/jakeasmith/http_build_url/src/http_build_url.php
30/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php
31/config/bootstrap.php
32/src/Core/ContainerBuilder.php
33/src/Core/Foundation/IoC/Container.php
34/src/Adapter/ServiceLocator.php
35/vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
36/app/cache/dev/appParameters.php
37/classes/controller/Controller.php
38/classes/ObjectModel.php
39/src/Core/Foundation/Database/EntityInterface.php
40/classes/db/Db.php
41/classes/Tools.php
42/classes/Context.php
43/classes/shop/Shop.php
44/classes/db/DbPDO.php
45/classes/Configuration.php
46/classes/Validate.php
47/classes/cache/Cache.php
48/src/Adapter/EntityMapper.php
49/classes/db/DbQuery.php
50/src/Core/Addon/Theme/ThemeManagerBuilder.php
51/src/Adapter/Configuration.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/vendor/defuse/php-encryption/src/Crypto.php
70/vendor/defuse/php-encryption/src/KeyOrPassword.php
71/vendor/defuse/php-encryption/src/RuntimeTests.php
72/vendor/defuse/php-encryption/src/DerivedKeys.php
73/vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
74/vendor/defuse/php-encryption/src/Exception/CryptoException.php
75/config/smarty.config.inc.php
76/classes/Smarty/SmartyDev.php
77/vendor/prestashop/smarty/Smarty.class.php
78/vendor/prestashop/smarty/sysplugins/smarty_internal_data.php
79/vendor/prestashop/smarty/sysplugins/smarty_internal_templatebase.php
80/vendor/prestashop/smarty/sysplugins/smarty_internal_template.php
81/vendor/prestashop/smarty/sysplugins/smarty_resource.php
82/vendor/prestashop/smarty/sysplugins/smarty_internal_resource_file.php
83/vendor/prestashop/smarty/sysplugins/smarty_cacheresource.php
84/vendor/prestashop/smarty/sysplugins/smarty_internal_cacheresource_file.php
85/config/smartyfront.config.inc.php
86/classes/Smarty/SmartyResourceModule.php
87/vendor/prestashop/smarty/sysplugins/smarty_resource_custom.php
88/classes/Smarty/SmartyResourceParent.php
89/classes/Smarty/SmartyLazyRegister.php
90/vendor/prestashop/smarty/plugins/modifier.truncate.php
91/classes/Customer.php
92/classes/Group.php
93/classes/Link.php
94/classes/shop/ShopUrl.php
95/classes/Dispatcher.php
96/classes/Hook.php
97/src/Adapter/SymfonyContainer.php
98/vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
99/config/db_slave_server.inc.php
100/classes/module/Module.php
101/src/Core/Module/ModuleInterface.php
102/modules/wbblog/wbblog.php
103/modules/wbblog/config/define.inc.php
104/modules/wbblog/classes/wbimagetypeclass.php
105/modules/wbblog/classes/wbcategorypostclass.php
106/modules/wbblog/classes/wbcommentclass.php
107/modules/wbblog/classes/wbcategoryclass.php
108/modules/wbblog/classes/wbpostsclass.php
109/modules/wbblog/classes/wbpostmetaclass.php
110/modules/wbblog/controllers/front/main.php
111/classes/controller/ModuleFrontController.php
112/classes/controller/FrontController.php
113/src/Core/Module/WidgetInterface.php
114/classes/Translate.php
115/modules/wbblog/translations/it.php
116/src/PrestaShopBundle/Translation/TranslatorComponent.php
117/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
118/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
119/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
120/src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
121/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageSelector.php
122/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
123/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
124/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
125/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
126/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
127/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceChecker.php
128/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerInterface.php
129/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/BCResourceInterfaceChecker.php
130/app/cache/dev/translations/catalogue.it-IT.8739602554c7f3241958e3cc9b57fdecb474d508.php
131/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
132/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
133/vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
134/modules/privatesales/privatesales.php
135/modules/privatesales/models/PrivateSaleModel.php
136/modules/privatesales/translations/it.php
137/controllers/front/listing/CategoryController.php
138/classes/controller/ProductListingFrontController.php
139/classes/controller/ProductPresentingFrontController.php
140/src/Adapter/ObjectPresenter.php
141/src/Core/Foundation/Templating/PresenterInterface.php
142/src/Adapter/Cart/CartPresenter.php
143/src/Adapter/Product/PriceFormatter.php
144/src/Adapter/Image/ImageRetriever.php
145/classes/tax/TaxConfiguration.php
146/classes/Smarty/TemplateFinder.php
147/classes/assets/StylesheetManager.php
148/classes/assets/AbstractAssetManager.php
149/src/Adapter/Assets/AssetUrlGeneratorTrait.php
150/classes/assets/JavascriptManager.php
151/classes/assets/CccReducer.php
152/classes/Category.php
153/override/classes/Category.php
154/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerBuilder.php
155/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
156/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/IntrospectableContainerInterface.php
157/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
158/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
159/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/TaggedContainerInterface.php
160/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php
161/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBagInterface.php
162/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ResourceInterface.php
163/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/YamlFileLoader.php
164/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/FileLoader.php
165/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/FileLoader.php
166/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/Loader.php
167/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/LoaderInterface.php
168/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocator.php
169/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocatorInterface.php
170/vendor/symfony/symfony/src/Symfony/Component/Yaml/Parser.php
171/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php
172/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/FileResource.php
173/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceInterface.php
174/vendor/symfony/symfony/src/Symfony/Component/Yaml/Unescaper.php
175/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Definition.php
176/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Reference.php
177/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/Compiler.php
178/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/PassConfig.php
179/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/MergeExtensionConfigurationPass.php
180/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CompilerPassInterface.php
181/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ExtensionCompilerPass.php
182/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveDefinitionTemplatesPass.php
183/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/DecoratorServicePass.php
184/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveParameterPlaceHoldersPass.php
185/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckDefinitionValidityPass.php
186/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveReferencesToAliasesPass.php
187/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveInvalidReferencesPass.php
188/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AutowirePass.php
189/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AnalyzeServiceReferencesPass.php
190/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatablePassInterface.php
191/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckCircularReferencesPass.php
192/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckReferenceValidityPass.php
193/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemovePrivateAliasesPass.php
194/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ReplaceAliasByActualDefinitionPass.php
195/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveAbstractDefinitionsPass.php
196/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatedPass.php
197/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/InlineServiceDefinitionsPass.php
198/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveUnusedDefinitionsPass.php
199/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php
200/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraph.php
201/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/LoggingFormatter.php
202/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraphNode.php
203/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraphEdge.php
204/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/FrozenParameterBag.php
205/vendor/symfony/symfony/src/Symfony/Component/Debug/Debug.php
206/vendor/symfony/symfony/src/Symfony/Component/Debug/ExceptionHandler.php
207/vendor/symfony/symfony/src/Symfony/Component/Debug/ErrorHandler.php
208/vendor/psr/log/Psr/Log/LogLevel.php
209/vendor/symfony/symfony/src/Symfony/Component/Debug/BufferingLogger.php
210/vendor/psr/log/Psr/Log/AbstractLogger.php
211/vendor/psr/log/Psr/Log/LoggerInterface.php
212/vendor/symfony/symfony/src/Symfony/Component/Debug/DebugClassLoader.php
213/classes/Currency.php
214/src/Core/Cldr/Repository.php
215/vendor/icanboogie/cldr/lib/RunTimeProvider.php
216/vendor/icanboogie/cldr/lib/ProviderChainTrait.php
217/vendor/icanboogie/cldr/lib/ProviderInterface.php
218/vendor/icanboogie/cldr/lib/CacheInterface.php
219/vendor/icanboogie/cldr/lib/FileProvider.php
220/vendor/icanboogie/cldr/lib/WebProvider.php
221/vendor/icanboogie/cldr/lib/Repository.php
222/vendor/icanboogie/cldr/lib/AccessorTrait.php
223/vendor/icanboogie/cldr/lib/LocaleCollection.php
224/vendor/icanboogie/cldr/lib/RepositoryPropertyTrait.php
225/vendor/icanboogie/cldr/lib/CollectionTrait.php
226/vendor/icanboogie/cldr/lib/Locale.php
227/vendor/icanboogie/cldr/lib/CodePropertyTrait.php
228/vendor/icanboogie/cldr/lib/Supplemental.php
229/vendor/icanboogie/cldr/lib/Currency.php
230/vendor/icanboogie/cldr/lib/LocalizedCurrency.php
231/vendor/icanboogie/cldr/lib/LocalizedObjectWithFormatter.php
232/vendor/icanboogie/cldr/lib/LocalizedObject.php
233/vendor/icanboogie/cldr/lib/LocalePropertyTrait.php
234/classes/Cart.php
235/src/Adapter/AddressFactory.php
236/classes/CartRule.php
237/classes/Product.php
238/classes/Pack.php
239/classes/webservice/WebserviceRequest.php
240/modules/creativeelements/creativeelements.php
241/modules/creativeelements/classes/CESmarty.php
242/modules/creativeelements/includes/plugin.php
243/modules/creativeelements/classes/wrappers/Helper.php
244/modules/creativeelements/classes/wrappers/UId.php
245/modules/creativeelements/classes/wrappers/Post.php
246/modules/creativeelements/classes/wrappers/Error.php
247/modules/creativeelements/translations/it.php
248/modules/creativeelements/classes/CETheme.php
249/modules/creativeelements/classes/CEContent.php
250/src/Adapter/Product/PriceCalculator.php
251/vendor/icanboogie/cldr/lib/Numbers.php
252/vendor/icanboogie/cldr/lib/CurrencyFormatter.php
253/vendor/icanboogie/cldr/lib/NumberFormatter.php
254/vendor/icanboogie/cldr/lib/NumberPattern.php
255/classes/ProductDownload.php
256/classes/Gender.php
257/classes/Risk.php
258/classes/Meta.php
259/classes/Address.php
260/classes/AddressFormat.php
261/classes/State.php
262/classes/Media.php
263/src/Core/Filter/CollectionFilter.php
264/src/Core/Filter/FilterInterface.php
265/src/Core/Filter/FrontEndObject/ProductFilter.php
266/src/Core/Filter/HashMapWhitelistFilter.php
267/src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php
268/src/Core/Filter/FrontEndObject/CartFilter.php
269/src/Core/Filter/FrontEndObject/CustomerFilter.php
270/src/Core/Filter/FrontEndObject/ShopFilter.php
271/src/Core/Filter/FrontEndObject/ConfigurationFilter.php
272/src/Core/Filter/FrontEndObject/MainFilter.php
273/modules/creativeelements/includes/autoloader.php
274/modules/creativeelements/includes/managers/controls.php
275/modules/creativeelements/core/settings/manager.php
276/modules/creativeelements/core/settings/page/manager.php
277/modules/creativeelements/core/settings/base/manager.php
278/modules/creativeelements/core/settings/general/manager.php
279/modules/creativeelements/includes/db.php
280/modules/creativeelements/core/documents-manager.php
281/modules/creativeelements/includes/managers/schemes.php
282/modules/creativeelements/includes/schemes/color.php
283/modules/creativeelements/includes/schemes/base.php
284/modules/creativeelements/includes/interfaces/scheme.php
285/modules/creativeelements/includes/schemes/typography.php
286/modules/creativeelements/includes/schemes/color-picker.php
287/modules/creativeelements/includes/managers/elements.php
288/modules/creativeelements/includes/base/element-base.php
289/modules/creativeelements/includes/base/controls-stack.php
290/modules/creativeelements/core/base/base-object.php
291/modules/creativeelements/includes/elements/column.php
292/modules/creativeelements/includes/elements/section.php
293/modules/creativeelements/includes/elements/repeater.php
294/modules/creativeelements/includes/managers/widgets.php
295/modules/creativeelements/includes/base/widget-base.php
296/modules/creativeelements/includes/base/widget-product-base.php
297/modules/creativeelements/includes/base/widget-category-base.php
298/modules/creativeelements/includes/traits/carousel.php
299/modules/creativeelements/includes/traits/nav.php
300/modules/creativeelements/includes/managers/skins.php
301/modules/creativeelements/includes/base/skin-base.php
302/modules/creativeelements/core/files/manager.php
303/modules/creativeelements/includes/editor.php
304/modules/creativeelements/includes/preview.php
305/modules/creativeelements/includes/frontend.php
306/modules/creativeelements/core/base/app.php
307/modules/creativeelements/core/base/module.php
308/modules/creativeelements/includes/template-library/manager.php
309/modules/creativeelements/includes/template-library/sources/local.php
310/modules/creativeelements/includes/template-library/sources/base.php
311/modules/creativeelements/includes/template-library/sources/remote.php
312/modules/creativeelements/core/dynamic-tags/manager.php
313/modules/creativeelements/core/modules-manager.php
314/modules/creativeelements/modules/history/module.php
315/modules/creativeelements/modules/library/module.php
316/modules/creativeelements/modules/library/documents/not-supported.php
317/modules/creativeelements/modules/library/documents/library-document.php
318/modules/creativeelements/core/base/document.php
319/modules/creativeelements/modules/library/documents/page.php
320/modules/creativeelements/modules/library/documents/section.php
321/modules/creativeelements/modules/dynamic-tags/module.php
322/modules/creativeelements/modules/page-templates/module.php
323/modules/creativeelements/modules/catalog/module.php
324/modules/creativeelements/includes/utils.php
325/modules/creativeelements/modules/creative/module.php
326/modules/creativeelements/modules/fonts-manager/module.php
327/modules/creativeelements/modules/custom-css/module.php
328/modules/creativeelements/modules/motion-effects/module.php
329/modules/creativeelements/modules/visibility/module.php
330/modules/creativeelements/modules/history/revisions-manager.php
331/modules/creativeelements/includes/user.php
332/modules/creativeelements/includes/api.php
333/modules/creativeelements/classes/assets/CEAssetManager.php
334/modules/creativeelements/classes/assets/CEStylesheetManager5.php
335/modules/creativeelements/classes/assets/CEJavascriptManager5.php
336/modules/creativeelements/classes/assets/CECccReducer.php
337/modules/creativeelements/core/responsive/responsive.php
338/modules/creativeelements/core/document-types/post.php
339/modules/creativeelements/core/document-types/content.php
340/modules/creativeelements/core/document-types/header.php
341/modules/creativeelements/core/base/header-footer-base.php
342/modules/creativeelements/core/base/theme-document.php
343/modules/creativeelements/core/document-types/footer.php
344/modules/creativeelements/core/document-types/product.php
345/modules/creativeelements/core/base/theme-page-document.php
346/modules/creativeelements/core/document-types/product-quick-view.php
347/modules/creativeelements/core/document-types/product-miniature.php
348/modules/creativeelements/core/document-types/page-index.php
349/modules/creativeelements/core/document-types/page-contact.php
350/modules/creativeelements/core/document-types/page-not-found.php
351/modules/ps_searchbar/ps_searchbar.php
352/modules/ps_shoppingcart/ps_shoppingcart.php
353/override/modules/ps_shoppingcart/ps_shoppingcart.php
354/modules/wbblocksearch/wbblocksearch.php
355/modules/wbimgleft/wbimgleft.php
356/modules/wbimgleft/WbHomeLeft.php
357/modules/wbtopbanner/wbtopbanner.php
358/modules/wbtopbanner/WbBanners.php
359/modules/wbimageslider/wbimageslider.php
360/modules/wbimageslider/WbSlide.php
361/modules/wbcenterbanner/wbcenterbanner.php
362/modules/wbcenterbanner/WbBanner.php
363/modules/wbimgoffer/wbimgoffer.php
364/modules/wbimgoffer/WbHomeOffer.php
365/modules/wbimgbanner/wbimgbanner.php
366/modules/wbimgbanner/WbHomeBanner.php
367/modules/wblogoslider/wblogoslider.php
368/modules/wblogoslider/WbHomeSlide.php
369/modules/wbfeature/wbfeature.php
370/modules/wbfeature/classes/ProductReviewCriterion.php
371/modules/wbfeature/classes/ProductReview.php
372/modules/wbfeature/classes/CompareProduct.php
373/modules/wbfeature/classes/WishList.php
374/modules/wbfeature/translations/it.php
375/modules/wbthemeconfigurator/wbthemeconfigurator.php
376/modules/wbthemeconfigurator/_variables.php
377/modules/wbthemeconfigurator/translations/it.php
378/modules/wbstaticblocks/wbstaticblocks.php
379/modules/wbstaticblocks/models/Staticblock.php
380/modules/wbstaticblocks/translations/it.php
381/modules/saferpaycw/saferpaycw.php
382/modules/saferpaycw/lib/loader.php
383/modules/saferpaycw/lib/Customweb/Core/Util/Class.php
384/modules/saferpaycw/lib/Customweb/Core/Exception/ClassNotFoundException.php
385/modules/saferpaycw/lib/Customweb/Core/Exception/ResourceNotFoundException.php
386/modules/saferpaycw/lib/Customweb/Core/Exception/FileNotFoundException.php
387/modules/saferpaycw/lib/Customweb/Core/Util/Error.php
388/modules/saferpaycw/lib/SaferpayCw/TranslationResolver.php
389/modules/saferpaycw/lib/Customweb/I18n/Translation.php
390/modules/saferpaycw/lib/Customweb/I18n/LocalizableString.php
391/modules/saferpaycw/lib/Customweb/Core/String.php
392/modules/saferpaycw/lib/Customweb/Core/Exception/CastException.php
393/modules/saferpaycw/lib/Customweb/Core/Charset.php
394/modules/saferpaycw/lib/Customweb/Core/Exception/InvalidPatternException.php
395/modules/saferpaycw/lib/Customweb/Core/Exception/CharsetNotFoundException.php
396/modules/saferpaycw/lib/Customweb/Core/Charset/UTF8.php
397/modules/saferpaycw/lib/Customweb/Core/Exception/BadMethodCallException.php
398/modules/saferpaycw/lib/Customweb/Core/Exception/BadFunctionCallException.php
399/modules/saferpaycw/lib/Customweb/Core/Exception/LogicException.php
400/modules/saferpaycw/lib/Customweb/I18n/ILocalizableString.php
401/modules/saferpaycw/lib/Customweb/I18n/ITranslationResolver.php
402/modules/saferpaycw/translations/it.php
403/modules/saferpaycw_postfinancecard/saferpaycw_postfinancecard.php
404/modules/saferpaycw/lib/SaferpayCw/IPaymentMethod.php
405/modules/saferpaycw/lib/Customweb/Payment/Authorization/IPaymentMethod.php
406/classes/PaymentModule.php
407/modules/saferpaycw/lib/SaferpayCw/ConfigurationApi.php
408/modules/saferpaycw/lib/Customweb/Core/Stream/Input/File.php
409/modules/saferpaycw/lib/Customweb/Core/Stream/IInput.php
410/modules/saferpaycw/lib/Customweb/Core/MimeType.php
411/modules/saferpaycw/lib/SaferpayCw/Util.php
412/modules/saferpaycw/lib/Customweb/Database/Driver/MySQL/Driver.php
413/modules/saferpaycw/lib/Customweb/Database/Driver/MySQL/Statement.php
414/modules/saferpaycw/lib/Customweb/Database/Driver/AbstractStatement.php
415/modules/saferpaycw/lib/Customweb/Database/IStatement.php
416/modules/saferpaycw/lib/Customweb/Database/Driver/AbstractDriver.php
417/modules/saferpaycw/lib/Customweb/Database/Util.php
418/modules/saferpaycw/lib/Customweb/Database/IDriver.php
419/modules/saferpaycw/lib/Customweb/Core/Assert.php
420/modules/saferpaycw/lib/Customweb/Payment/Authorization/DefaultInvoiceItem.php
421/modules/saferpaycw/lib/Customweb/Payment/Authorization/IInvoiceItem.php
422/modules/saferpaycw/lib/Customweb/DependencyInjection/Container/Default.php
423/modules/saferpaycw/lib/Customweb/DependencyInjection/Container/Abstract.php
424/modules/saferpaycw/lib/Customweb/DependencyInjection/Exception/BeanNotFoundException.php
425/modules/saferpaycw/lib/Customweb/DependencyInjection/IContainer.php
426/modules/saferpaycw/lib/Customweb/Asset/Resolver/Composite.php
427/modules/saferpaycw/lib/Customweb/Asset/IResolver.php
428/modules/saferpaycw/lib/Customweb/Asset/Exception/UnresolvableAssetException.php
429/modules/saferpaycw/lib/Customweb/Mvc/Template/Smarty/ContainerBean.php
430/modules/saferpaycw/lib/Customweb/Util/Invoice.php
431/modules/saferpaycw/lib/Customweb/Util/Currency.php
432/modules/saferpaycw/lib/Customweb/Core/Http/ContextRequest.php
433/modules/saferpaycw/lib/Customweb/Core/Http/IRequest.php
434/modules/saferpaycw/lib/Customweb/Core/Http/IMessage.php
435/modules/saferpaycw/lib/Customweb/Payment/Endpoint/Dispatcher.php
436/modules/saferpaycw/lib/Customweb/Annotation/ReflectionAnnotatedClass.php
437/modules/saferpaycw/lib/Customweb/Core/Reflection/Class.php
438/modules/saferpaycw/lib/Customweb/Annotation/IAnnotationReflector.php
439/modules/saferpaycw/lib/Customweb/Annotation/AnnotationsBuilder.php
440/modules/saferpaycw/lib/Customweb/Annotation/AnnotationsCollection.php
441/modules/saferpaycw/lib/Customweb/Annotation/Util.php
442/modules/saferpaycw/lib/Customweb/Annotation/DocComment.php
443/modules/saferpaycw/lib/Customweb/Annotation/ReflectionAnnotatedMethod.php
444/modules/saferpaycw/lib/Customweb/Annotation/ReflectionAnnotatedProperty.php
445/modules/saferpaycw/lib/Customweb/Annotation/Cache/Reader.php
446/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationsMatcher.php
447/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationMatcher.php
448/modules/saferpaycw/lib/Customweb/Annotation/Parser/RegexMatcher.php
449/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationParametersMatcher.php
450/modules/saferpaycw/lib/Customweb/Annotation/Parser/ConstantMatcher.php
451/modules/saferpaycw/lib/Customweb/Annotation/Parser/SimpleSerialMatcher.php
452/modules/saferpaycw/lib/Customweb/Annotation/Parser/SerialMatcher.php
453/modules/saferpaycw/lib/Customweb/Annotation/Parser/CompositeMatcher.php
454/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationValuesMatcher.php
455/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationHashMatcher.php
456/modules/saferpaycw/lib/Customweb/Annotation/Parser/ParallelMatcher.php
457/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationMorePairsMatcher.php
458/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationPairMatcher.php
459/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationValueMatcher.php
460/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationKeyMatcher.php
461/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationIntegerMatcher.php
462/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationStringMatcher.php
463/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationSingleQuotedStringMatcher.php
464/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationDoubleQuotedStringMatcher.php
465/modules/saferpaycw/lib/Customweb/Annotation/Parser/AnnotationTopValueMatcher.php
466/modules/saferpaycw/lib/Customweb/Annotation/Cache/Annotation.php
467/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Object.php
468/modules/saferpaycw/lib/Customweb/DependencyInjection/IBean.php
469/modules/saferpaycw/lib/Customweb/Payment/Endpoint/Annotation/ExtractionMethod.php
470/modules/saferpaycw/lib/Customweb/IAnnotation.php
471/modules/saferpaycw/lib/Customweb/Mvc/Controller/Dispatcher.php
472/modules/saferpaycw/lib/Customweb/Core/Http/IResponse.php
473/modules/saferpaycw/lib/Customweb/Mvc/Controller/Annotation/Controller.php
474/modules/saferpaycw/lib/Customweb/DependencyInjection/Container/Extendable.php
475/modules/saferpaycw/lib/Customweb/Mvc/Controller/IDispatcher.php
476/modules/saferpaycw/lib/Customweb/Core/Http/Response.php
477/modules/saferpaycw/lib/Customweb/Core/Http/ICookie.php
478/modules/saferpaycw/lib/Customweb/Core/Http/AbstractMessage.php
479/modules/saferpaycw/lib/Customweb/Core/Url.php
480/modules/saferpaycw/lib/Customweb/Core/Http/Cookie.php
481/modules/saferpaycw/lib/Customweb/Mvc/Controller/Exception/ActionNotFoundException.php
482/modules/saferpaycw/lib/Customweb/Annotation/Scanner.php
483/modules/saferpaycw/lib/Customweb/Mvc/Controller/Annotation/Action.php
484/modules/saferpaycw/lib/Customweb/Mvc/Controller/Exception/ActionArgumentScalarException.php
485/modules/saferpaycw/lib/Customweb/Mvc/Controller/Exception/ActionArgumentNotResolvableException.php
486/modules/saferpaycw/lib/Customweb/Mvc/Controller/Exception/ControllerNotFoundException.php
487/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Provider/Annotation/Util.php
488/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Generic/DefaultDependency.php
489/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Generic/IDependency.php
490/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Generic.php
491/modules/saferpaycw/lib/Customweb/Core/Logger/Factory.php
492/modules/saferpaycw/lib/Customweb/Core/Logger/DefaultLogger.php
493/modules/saferpaycw/lib/Customweb/Core/ILogger.php
494/modules/saferpaycw/lib/Customweb/Cache/Backend/Memory.php
495/modules/saferpaycw/lib/Customweb/Cache/IBackend.php
496/modules/saferpaycw/lib/Customweb/Asset/Resolver/Simple.php
497/modules/saferpaycw/lib/Customweb/Asset/Exception/NonPublicAssetException.php
498/modules/saferpaycw/lib/Customweb/Database/Driver/PDO/Driver.php
499/modules/saferpaycw/lib/Customweb/Database/Driver/PDO/Statement.php
500/modules/saferpaycw/lib/Customweb/Payment/Authorization/DefaultPaymentCustomerContext.php
501/modules/saferpaycw/lib/Customweb/Payment/Authorization/IPaymentCustomerContext.php
502/modules/saferpaycw/lib/Customweb/Core/Util/Html.php
503/modules/saferpaycw/lib/Customweb/Database/Driver/MySQLi/Driver.php
504/modules/saferpaycw/lib/Customweb/Database/Driver/MySQLi/Statement.php
505/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Provider/Annotation.php
506/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/IProvider.php
507/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Provider/Editable.php
508/modules/saferpaycw/lib/Customweb/DependencyInjection/Bean/Simple.php
509/modules/saferpaycw/lib/Customweb/Storage/Backend/Database.php
510/modules/saferpaycw/lib/Customweb/Storage/IBackend.php
511/modules/saferpaycw/lib/Customweb/Payment/Authorization/IAdapterFactory.php
512/modules/saferpaycw/lib/SaferpayCw/EntityManager.php
513/modules/saferpaycw/lib/Customweb/Database/Entity/Manager.php
514/modules/saferpaycw/lib/Customweb/Database/Entity/SchemaGenerator.php
515/modules/saferpaycw/lib/Customweb/Database/Entity/IManager.php
516/modules/saferpaycw/lib/Customweb/Database/Entity/ManagedEntity.php
517/modules/saferpaycw/lib/Customweb/Database/Entity/Exception/EntityNotFoundException.php
518/modules/saferpaycw/lib/Customweb/Database/Entity/Exception/OptimisticLockingException.php
519/modules/saferpaycw/lib/Customweb/Database/Entity/Util.php
520/modules/saferpaycw/lib/Customweb/Core/Util/String.php
521/modules/saferpaycw/lib/Customweb/Database/Entity/Scanner.php
522/modules/saferpaycw/lib/Customweb/Database/Entity/Annotation/IProcessable.php
523/modules/saferpaycw/lib/Customweb/Database/Entity/Meta/Entity.php
524/modules/saferpaycw/lib/Customweb/Database/Entity/Meta/IEntity.php
525/modules/saferpaycw/lib/Customweb/Database/Entity/Annotation/Entity.php
526/modules/saferpaycw/lib/SaferpayCw/DatabaseLinkAccessor.php
527/modules/saferpaycw/lib/SaferpayCw/Adapter/IAdapter.php
528/modules/saferpaycw/lib/SaferpayCw/Entity/PaymentCustomerContext.php
529/modules/saferpaycw/lib/Customweb/Payment/Entity/AbstractPaymentCustomerContext.php
530/modules/saferpaycw/lib/Customweb/Cron/Annotation/Cron.php
531/modules/saferpaycw_vpay/saferpaycw_vpay.php
532/modules/saferpaycw_creditcard/saferpaycw_creditcard.php
533/modules/saferpaycw_postfinanceefinance/saferpaycw_postfinanceefinance.php
534/modules/saferpaycw_twint/saferpaycw_twint.php
535/modules/ps_googleanalytics/ps_googleanalytics.php
536/modules/gadwordstracking/gadwordstracking.php
537/modules/gadwordstracking/conf/common.conf.php
538/modules/gadwordstracking/lib/module-tools_class.php
539/modules/gadwordstracking/translations/it.php
540/modules/gadwordstracking/conf/hook.conf.php
541/modules/gadwordstracking/lib/hook/hook-ctrl_class.php
542/modules/gadwordstracking/lib/hook/hook-base_class.php
543/modules/gadwordstracking/lib/hook/hook-display_class.php
544/modules/gadwordstracking/lib/module-dao_class.php
545/classes/Smarty/SmartyDevTemplate.php
546/app/cache/dev/smarty/compile/e5/c2/c6/e5c2c60193044447d25bb8af086e5253053814e0.file.header.tpl.php
547/vendor/prestashop/smarty/sysplugins/smarty_internal_filter_handler.php
548/modules/paypalwithfee/paypalwithfee.php
549/modules/paypalwithfee/classes/PaypalOrder.php
550/modules/paypalwithfee/classes/PaypalRefund.php
551/modules/paypalwithfee/translations/it.php
552/modules/saferpaycw_maestro/saferpaycw_maestro.php
553/modules/senderautomatedemails/senderautomatedemails.php
554/modules/senderautomatedemails/lib/Sender/SenderApiClient.php
555/modules/senderautomatedemails/lib/Sender/CustomersExport.php
556/modules/senderautomatedemails/translations/it.php
557/modules/ets_advancedcaptcha/ets_advancedcaptcha.php
558/modules/ets_advancedcaptcha/classes/ets_pa_defines.php
559/modules/ets_advancedcaptcha/translations/it.php
560/modules/ambjolisearch/ambjolisearch.php
561/modules/ambjolisearch/classes/AmbJolisearchModule.php
562/modules/ambjolisearch/classes/AmbIndexation.php
563/modules/ambjolisearch/classes/AmbSearch.php
564/modules/ambjolisearch/classes/definitions.php
565/modules/ambjolisearch/classes/JoliLink.php
566/modules/ambjolisearch/classes/JoliLink-1.7.php
567/modules/ambjolisearch/classes/AmbJolisearchModuleProxy.php
568/modules/ambjolisearch/translations/it.php
569/classes/ImageType.php
570/modules/quantitylimit/quantitylimit.php
571/modules/quantitylimit/models/Limit.php
572/modules/quantitylimit/translations/it.php
573/app/cache/dev/smarty/compile/f9/8f/ef/f98fef12a10678b89d8ee9f40c8d19e49f9ebc65.file.header.tpl.php
574/vendor/prestashop/smarty/plugins/modifier.escape.php
575/src/Core/Product/Search/ProductSearchContext.php
576/src/Core/Product/Search/ProductSearchQuery.php
577/src/Core/Product/Search/SortOrder.php
578/modules/ambjolisearch/src/Amb_ProductSearchProvider.php
579/src/Core/Product/Search/ProductSearchProviderInterface.php
580/modules/ps_facetedsearch/ps_facetedsearch.php
581/modules/ps_facetedsearch/src/Ps_FacetedsearchProductSearchProvider.php
582/modules/ps_facetedsearch/src/Ps_FacetedsearchFiltersConverter.php
583/modules/ps_facetedsearch/src/Ps_FacetedsearchFacetsURLSerializer.php
584/modules/ps_facetedsearch/src/Ps_FacetedsearchRangeAggregator.php
585/src/Core/Product/Search/ProductSearchResult.php
586/classes/stock/StockAvailable.php
587/src/Core/Product/Search/Facet.php
588/src/Core/Product/Search/Filter.php
589/src/Core/Product/Search/URLFragmentSerializer.php
590/src/Core/Product/Search/FacetCollection.php
591/classes/Combination.php
592/classes/ProductAssembler.php
593/classes/tax/Tax.php
594/classes/SpecificPrice.php
595/classes/tax/TaxManagerFactory.php
596/classes/tax/TaxRulesTaxManager.php
597/classes/tax/TaxManagerInterface.php
598/classes/tax/TaxCalculator.php
599/classes/GroupReduction.php
600/classes/Feature.php
601/classes/ProductPresenterFactory.php
602/src/Core/Product/ProductListingPresenter.php
603/src/Core/Product/ProductPresenter.php
604/src/Adapter/Product/ProductColorsRetriever.php
605/src/Core/Product/ProductPresentationSettings.php
606/classes/Image.php
607/src/Core/Addon/Module/ModuleManagerBuilder.php
608/app/config/config.php
609/src/PrestaShopBundle/Service/DataProvider/Marketplace/ApiClient.php
610/vendor/guzzlehttp/guzzle/src/Client.php
611/vendor/guzzlehttp/guzzle/src/Event/HasEmitterTrait.php
612/vendor/guzzlehttp/guzzle/src/ClientInterface.php
613/vendor/guzzlehttp/guzzle/src/Event/HasEmitterInterface.php
614/vendor/guzzlehttp/guzzle/src/Url.php
615/vendor/guzzlehttp/guzzle/src/Utils.php
616/vendor/guzzlehttp/guzzle/src/Message/MessageFactory.php
617/vendor/guzzlehttp/guzzle/src/Event/ListenerAttacherTrait.php
618/vendor/guzzlehttp/guzzle/src/Message/MessageFactoryInterface.php
619/vendor/guzzlehttp/guzzle/src/Subscriber/HttpError.php
620/vendor/guzzlehttp/guzzle/src/Event/SubscriberInterface.php
621/vendor/guzzlehttp/guzzle/src/Subscriber/Redirect.php
622/vendor/guzzlehttp/ringphp/src/Client/CurlHandler.php
623/vendor/guzzlehttp/ringphp/src/Client/CurlFactory.php
624/vendor/guzzlehttp/ringphp/src/Client/CurlMultiHandler.php
625/vendor/guzzlehttp/ringphp/src/Client/Middleware.php
626/vendor/guzzlehttp/ringphp/src/Client/StreamHandler.php
627/vendor/guzzlehttp/guzzle/src/RequestFsm.php
628/src/Adapter/Tools.php
629/app/config/parameters.php
630/src/Adapter/Module/ModuleZipManager.php
631/src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php
632/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcherInterface.php
633/src/Adapter/Addons/AddonsDataProvider.php
634/src/PrestaShopBundle/Service/DataProvider/Admin/AddonsInterface.php
635/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
636/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
637/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
638/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
639/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
640/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
641/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
642/src/Adapter/LegacyLogger.php
643/src/PrestaShopBundle/Service/DataProvider/Admin/CategoriesProvider.php
644/src/Adapter/LegacyContext.php
645/src/Adapter/Module/ModuleDataProvider.php
646/src/Adapter/Module/AdminModuleDataProvider.php
647/src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php
648/vendor/symfony/symfony/src/Symfony/Component/Routing/Loader/YamlFileLoader.php
649/vendor/symfony/symfony/src/Symfony/Component/Routing/Router.php
650/vendor/symfony/symfony/src/Symfony/Component/Routing/RouterInterface.php
651/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/UrlMatcherInterface.php
652/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContextAwareInterface.php
653/vendor/symfony/symfony/src/Symfony/Component/Routing/Generator/UrlGeneratorInterface.php
654/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/RequestMatcherInterface.php
655/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContext.php
656/src/Adapter/Module/ModuleDataUpdater.php
657/src/Core/Addon/Module/ModuleManager.php
658/src/Core/Addon/AddonManagerInterface.php
659/src/Core/Addon/Module/ModuleRepository.php
660/src/Core/Addon/Module/ModuleRepositoryInterface.php
661/vendor/symfony/symfony/src/Symfony/Component/Finder/Finder.php
662/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ArrayCache.php
663/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
664/classes/ImageManager.php
665/app/cache/dev/smarty/compile/64/bf/8d/64bf8d734322d1745da1e11081fd0fbf53612a83.file.facets.tpl.php
666/app/cache/dev/smarty/compile/9b/c4/97/9bc49779746f2940b8a8dc0f93257b35eb259e50.file.active_filters.tpl.php
667/src/Core/Product/Search/Pagination.php
668/app/cache/dev/smarty/compile/layouts_layout_left_column_tpl/18/37/eb/1837eb5db405cc75e58a54140bfa016550e5c9ed.file.category.tpl.php
669/app/cache/dev/smarty/compile/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880.module.ps_shoppingcart.tpl.php
670/app/cache/dev/smarty/cache/wbblocksearch/1/1/1/3/1/19/b8/de/0f/b8de0f71efbe158c813f6cf11de131ef8ab551fc.wbblocksearch-top.tpl.php
671/modules/ps_languageselector/ps_languageselector.php
672/app/cache/dev/smarty/compile/1c/00/f7/1c00f78dace25d509ec3a1f54176b7ae2000accf.module.ps_languageselector.tpl.php
673/modules/ps_currencyselector/ps_currencyselector.php
674/app/cache/dev/smarty/compile/b9/77/56/b97756c07f8c7dd53da6530f78f67ddd242f77c9.module.ps_currencyselector.tpl.php
675/modules/ps_customersignin/ps_customersignin.php
676/app/cache/dev/smarty/compile/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c.module.ps_customersignin.tpl.php
677/app/cache/dev/smarty/compile/29/65/5d/29655d54adc6f81cb48e792e2ac2d8c4ff23dff8.file.hook.tpl.php
678/modules/ps_mainmenu/ps_mainmenu.php
679/modules/ps_mainmenu/ps_menutoplinks.class.php
680/app/cache/dev/smarty/compile/41/df/19/41df1985130dffd7d3fe4cb369091546a0b40be7.module.ps_mainmenu.tpl.php
681/app/cache/dev/smarty/compile/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5.module.ps_facetedsearch.tpl.php
682/vendor/prestashop/smarty/plugins/function.fetch.php
683/app/cache/dev/smarty/cache/693/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
684/classes/Attribute.php
685/app/cache/dev/smarty/compile/8b/7b/75/8b7b752f20a5e7e06b0e4815a32843f0ad3c7131.file.wb_cart_button.tpl.php
686/app/cache/dev/smarty/cache/692/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
687/app/cache/dev/smarty/cache/579/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
688/app/cache/dev/smarty/cache/578/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
689/app/cache/dev/smarty/cache/577/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
690/app/cache/dev/smarty/compile/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.file.wb_list_product_review.tpl.cache.php
691/vendor/prestashop/smarty/sysplugins/smarty_internal_write_file.php
692/app/cache/dev/smarty/cache/445/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
693/app/cache/dev/smarty/cache/364/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
694/app/cache/dev/smarty/cache/363/1/1/1/3/1/19/0e/ca/5f/0eca5fdcba9bcfae9d69aeff281365c60ec02aa3.wb_list_product_review.tpl.php
695/app/cache/dev/smarty/cache/wblogoslider/1/1/1/3/1/19/37/70/5e/37705ede3a2dfe1821713da65b2891d368a6b9b6.slider.tpl.php
696/vendor/prestashop/smarty/plugins/modifier.date_format.php
697/modules/ps_contactinfo/ps_contactinfo.php
698/app/cache/dev/smarty/compile/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d.module.ps_contactinfo.tpl.php
699/modules/ps_linklist/ps_linklist.php
700/modules/ps_linklist/src/LinkBlockRepository.php
701/modules/ps_linklist/src/LinkBlock.php
702/modules/ps_linklist/src/LinkBlockPresenter.php
703/app/cache/dev/smarty/cache/ps_linklist/displayFooter/1/1/1/3/1/19/90/65/48/906548e89c8c6025457ddaeffb1980a0c743b872.linkblock.tpl.php
704/modules/ps_emailsubscription/ps_emailsubscription.php
705/override/modules/ps_emailsubscription/ps_emailsubscription.php
706/src/Core/Foundation/Database/EntityManager.php
707/src/Core/Foundation/Database/DatabaseInterface.php
708/src/Adapter/Database.php
709/app/cache/dev/smarty/compile/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef.module.ps_emailsubscription.tpl.php
710/modules/tawkto/tawkto.php
711/modules/tawkto/translations/it.php
712/app/cache/dev/smarty/compile/aa/37/d3/aa37d32f19578f3f173b5d532567ca5a7081db03.file.widget.tpl.php
713/vendor/prestashop/smarty/plugins/shared.make_timestamp.php
714/modules/statsdata/statsdata.php
715/classes/Connection.php
716/classes/ConnectionsSource.php
717/app/cache/dev/smarty/compile/9f/c2/d6/9fc2d6a209dd8d08bf5b31bc42c542801e92f00a.file.assets.tpl.php
718/config/settings.inc.php