Verres à bière

Verres à bière Belgique33clLupulusVan Den Bossche

Filtres actifs

  • Pays d'origine: Belgique
  • Contenance: 33cl
  • Marque: Lupulus
  • Marque: Van Den Bossche
Top
Load Time1221 ms - OK... for a shared hosting
Querying Time695 ms
Queries178
Memory Peak Usage22.5 Mb
Included Files650 files - 9.75 Mb
PrestaShop Cache- Mb
Global vars1.10 Mb
PrestaShop Version1.7.2.4
PHP Version7.1.33 (OK)
MySQL Version5.5.68-MariaDB (Consider upgrading)
Memory Limit512M
Max Execution Time3600s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 105 ms 105 ms 3.58 Mb 3.61 Mb
__construct 0 ms 105 ms - Mb 3.61 Mb
init 698 ms 802 ms 4.57 Mb 14.03 Mb
checkAccess 0 ms 802 ms - Mb 14.03 Mb
setMedia 73 ms 875 ms 0.97 Mb 14.03 Mb
postProcess 0 ms 875 ms - Mb 14.03 Mb
initHeader 0 ms 875 ms - Mb 14.03 Mb
initContent 17 ms 892 ms 1.77 Mb 14.03 Mb
initFooter 0 ms 892 ms - Mb 14.03 Mb
display 329 ms 1221 ms 11.35 Mb 22.52 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 - 178 queries

Query Time (ms) Rows Filesort Group By Location 
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
 67.5 1 /classes/shop/Shop.php:203 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 65.9 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
 62.1 527 Yes /classes/Manufacturer.php:206 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 58.5 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=26)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 57 96577920 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=29)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 54.7 86605200 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 4864812
AND `date_add` > '2024-06-14 12:09:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 51.9 1 Yes /classes/Connection.php:162 
SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY p.id_manufacturer
 13.3 609071400 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 8 ORDER BY vl.`value` ASC
 12.4 62 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:181 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 12 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 11.9 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 11.4 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 10.9 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 10 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
 8.1 527 Yes /classes/Manufacturer.php:206 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "statsdata" LIMIT 1
 7.9 1 /classes/module/Module.php:2597 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 7.5 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
 7.3 244 Yes /classes/Country.php:146 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=23)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 7.1 87130080 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
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` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2298) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 6.6 1 Yes Yes /classes/Product.php:3517 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=17)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 5.9 57299400 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=19)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 5.7 57299400 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=27)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 5.5 154839600 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=18)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 5.2 115998480 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 4.7 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890)))
 4.6 57299400 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 4.1 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
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`)
 3.8 1236 /classes/Configuration.php:157 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=33)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 3.7 102089160 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=32)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 3.5 89754480 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 3.5 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
 3.2 0 /classes/Attribute.php:288 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=25)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 3 175309920 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=37)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 2.9 51438240 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 599
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
 2.9 181 Yes /modules/ps_categorytree/ps_categorytree.php:117 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=30)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 2.8 40415760 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=24)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 2.6 98152560 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=28)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 2.5 82668600 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=31)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 2.3 37528920 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 36
 2.2 17006112 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 2.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=35)) AND ((fp_1.id_feature_value IN (145, 93889))) AND ((fp_2.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 2.1 16271280 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
 1.9 1 /classes/ObjectModel.php:518 
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("76b6d8312c49297e29f3601b740942bc", "a:1:{s:7:\"filters\";a:4:{i:0;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"37\";s:6:\"values\";a:1:{i:14830;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Calice\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:5:\"Forme\";s:8:\"url_name\";s:5:\"forme\";s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"8\";s:6:\"values\";a:1:{i:145;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:8:\"Belgique\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:14:\"Pays d\'origine\";s:8:\"url_name\";s:12:\"paysdorigine\";s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"9\";s:6:\"values\";a:3:{i:160;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"25cl\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:159;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:4:\"33cl\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:161;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"50cl\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Contenance\";s:8:\"url_name\";s:10:\"contenance\";s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:40:{i:2;a:2:{s:4:\"name\";s:15:\"Palm (De Hoorn)\";s:3:\"nbr\";s:1:\"1\";}i:4;a:2:{s:4:\"name\";s:17:\"Brasserie Du Bocq\";s:3:\"nbr\";s:1:\"4\";}i:5;a:2:{s:4:\"name\";s:26:\"Koningshoeven (La Trappe) \";s:3:\"nbr\";s:1:\"2\";}i:7;a:2:{s:4:\"name\";s:5:\"Silly\";s:3:\"nbr\";s:1:\"1\";}i:8;a:2:{s:4:\"name\";s:15:\"Abbaye des rocs\";s:3:\"nbr\";s:1:\"1\";}i:10;a:2:{s:4:\"name\";s:5:\"Roman\";s:3:\"nbr\";s:1:\"2\";}i:13;a:2:{s:4:\"name\";s:6:\"Huyghe\";s:3:\"nbr\";s:1:\"5\";}i:14;a:2:{s:4:\"name\";s:16:\"Van Honsenbrouke\";s:3:\"nbr\";s:1:\"3\";}i:15;a:2:{s:4:\"name\";s:14:\"Van Steenberge\";s:3:\"nbr\";s:1:\"4\";}i:16;a:2:{s:4:\"name\";s:8:\"Lefebvre\";s:3:\"nbr\";s:1:\"4\";}i:19;a:2:{s:4:\"name\";s:10:\"Corsendonk\";s:3:\"nbr\";s:1:\"1\";}i:21;a:2:{s:4:\"name\";s:8:\"De Proef\";s:3:\"nbr\";s:1:\"1\";}i:22;a:2:{s:4:\"name\";s:7:\"Caulier\";s:3:\"nbr\";s:1:\"2\";}i:24;a:2:{s:4:\"name\";s:13:\"De Halve Maan\";s:3:\"nbr\";s:1:\"2\";}i:26;a:2:{s:4:\"name\";s:8:\"La Senne\";s:3:\"nbr\";s:1:\"1\";}i:27;a:2:{s:4:\"name\";s:9:\"Dubuisson\";s:3:\"nbr\";s:1:\"3\";}i:28;a:2:{s:4:\"name\";s:9:\"Het Anker\";s:3:\"nbr\";s:1:\"1\";}i:30;a:2:{s:4:\"name\";s:6:\"Haacht\";s:3:\"nbr\";s:1:\"2\";}i:31;a:2:{s:4:\"name\";s:8:\"Achouffe\";s:3:\"nbr\";s:1:\"1\";}i:32;a:2:{s:4:\"name\";s:6:\"Chimay\";s:3:\"nbr\";s:1:\"1\";}i:34;a:2:{s:4:\"name\";s:11:\"Alken-Maes \";s:3:\"nbr\";s:1:\"2\";}i:36;a:2:{s:4:\"name\";s:9:\"AB In Bev\";s:3:\"nbr\";s:1:\"2\";}i:37;a:2:{s:4:\"name\";s:14:\"Duvel Moortgat\";s:3:\"nbr\";s:1:\"2\";}i:44;a:2:{s:4:\"name\";s:8:\"Bosteels\";s:3:\"nbr\";s:1:\"2\";}i:48;a:2:{s:4:\"name\";s:23:\"Brasserie des Légendes\";s:3:\"nbr\";s:1:\"3\";}i:49;a:2:{s:4:\"name\";s:8:\"Martin\'s\";s:3:\"nbr\";s:1:\"1\";}i:50;a:2:{s:4:\"name\";s:15:\"Saint-Feuillien\";s:3:\"nbr\";s:1:\"3\";}i:55;a:2:{s:4:\"name\";s:9:\"Lindemans\";s:3:\"nbr\";s:1:\"1\";}i:57;a:3:{s:4:\"name\";s:7:\"Lupulus\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:58;a:2:{s:4:\"name\";s:13:\"De Landtsheer\";s:3:\"nbr\";s:1:\"1\";}i:60;a:3:{s:4:\"name\";s:15:\"Van Den Bossche\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:62;a:2:{s:4:\"name\";s:13:\"De Brabandere\";s:3:\"nbr\";s:1:\"2\";}i:64;a:2:{s:4:\"name\";s:8:\"Vanuxeem\";s:3:\"nbr\";s:1:\"1\";}i:65;a:2:{s:4:\"name\";s:19:\"Abbaye de Rochefort\";s:3:\"nbr\";s:1:\"1\";}i:67;a:2:{s:4:\"name\";s:8:\"De Block\";s:3:\"nbr\";s:1:\"1\";}i:70;a:2:{s:4:\"name\";s:6:\"Urthel\";s:3:\"nbr\";s:1:\"1\";}i:72;a:2:{s:4:\"name\";s:9:\"Van Viven\";s:3:\"nbr\";s:1:\"1\";}i:74;a:2:{s:4:\"name\";s:19:\"Abbaye de Westmalle\";s:3:\"nbr\";s:1:\"1\";}i:256;a:2:{s:4:\"name\";s:11:\"Brasserie C\";s:3:\"nbr\";s:1:\"1\";}i:507;a:2:{s:4:\"name\";s:14:\"Abbaye d\'Orval\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")
 1.8 1 /modules/ps_facetedsearch/src/Filters/Block.php:193 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=8)) AND ((fp_1.id_feature_value IN (159, 51000, 56666, 58378, 88587, 64809, 88608, 70784, 93890))) GROUP BY fp.id_feature_value
 1.6 2834352 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 1.6 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 1.6 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 1.5 156 Yes Yes /classes/Hook.php:629 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 1.3 388 /classes/Hook.php:373 
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` = 8
AND tr.`id_tax_rules_group` = 6
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
 1.3 1 Yes /classes/tax/TaxRulesTaxManager.php:110 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 1.3 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (145, 93889))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (57, 60) AND c.nleft>=517 AND c.nright<=590 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=9)) AND ((fp_1.id_feature_value IN (145, 93889))) GROUP BY fp.id_feature_value
 1.2 2834352 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 1.2 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 1.2 1 /classes/CartRule.php:348 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 1.2 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
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` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1262) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1.1 1 Yes Yes /classes/Product.php:3517 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 1.1 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 1.1 8 Yes /classes/ImageType.php:108 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-06-14 00:00:00',
INTERVAL 20 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 = 1
AND p.id_product = 1262
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 1.1 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 8 ORDER BY vl.`value` ASC
 1 62 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:181 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 1 1 /classes/CartRule.php:348 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 1 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.9 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.9 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.9 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 22 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
 0.9 19 Yes Yes /modules/ps_facetedsearch/src/Filters/Block.php:108 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.8 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE r.id_reward
FROM `ps_rewards` r
WHERE r.id_reward_state = 2
AND date_end < NOW() AND date_end != '0000-00-00 00:00:00'
 0.8 1587 /modules/allinone_rewards/models/RewardsModel.php:515 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.8 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.8 1 /classes/shop/Shop.php:1119 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.8 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 0.8 1 /classes/CartRule.php:348 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.8 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.8 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.8 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
 0.7 0 /classes/Hook.php:185 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.7 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.7 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 9 ORDER BY vl.`value` ASC
 0.7 32 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:181 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.7 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.7 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 37 ORDER BY vl.`value` ASC
 0.7 15 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:181 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.7 83 /classes/Hook.php:225 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.7 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
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 = 'drinkshop.fr' OR su.domain_ssl = 'drinkshop.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.6 1 Yes /classes/shop/Shop.php:344 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND cr.date_from < "2024-06-14 12:39:51"
AND cr.date_to > "2024-06-14 12:39:51"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 0.6 1 /classes/CartRule.php:348 
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
 0.6 324 Yes /classes/Country.php:153 
SELECT SQL_NO_CACHE "thumb" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "drinkshop_v1724" AND TABLE_NAME = "ps_psblog_blog" AND COLUMN_NAME = "thumb"
 0.6 0 /modules/psblog/psblog.php:44 
SELECT SQL_NO_CACHE *
FROM `ps_rewards_state` a
WHERE (a.`id_reward_state` = 2) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SHOW TABLES LIKE '%psblog_blog%'
 0.6 1 /modules/psblog/psblog.php:44 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
 0.6 1 /classes/SpecificPrice.php:397 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 2298
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
 0.6 0 /classes/Product.php:5725 
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` = 22) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.5 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2298
ORDER BY f.position ASC
 0.5 3 Yes /classes/Product.php:4586 
SELECT SQL_NO_CACHE fp.id_feature, vl.value, fl.name
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` v ON (fp.`id_feature_value` = v.`id_feature_value`)
LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1)
LEFT JOIN `ps_feature` f ON (f.`id_feature` = v.`id_feature`)
LEFT JOIN `ps_feature_lang` fl ON (fl.`id_feature` = f.`id_feature` AND fl.`id_lang` = 1)
WHERE fp.`id_product` = 2298 ORDER BY f.`position` ASC, fp.`position` ASC
 0.5 3 Yes /modules/pm_multiplefeatures/pm_multiplefeatures.php:201 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.5 1 /classes/module/Module.php:2064 
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.5 1 Yes /classes/shop/Shop.php:692 
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.5 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 22
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.5 19 Yes Yes /modules/ps_facetedsearch/src/Filters/Converter.php:247 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 22
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.5 3 Yes Yes /classes/Category.php:821 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.5 67 Yes /classes/Dispatcher.php:469 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.5 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
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 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` = 8
AND tr.`id_tax_rules_group` = 6
AND tr.`id_state` IN (0, 0)
AND ('66240' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '66240')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.5 1 Yes /classes/tax/TaxRulesTaxManager.php:110 
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.5 87 /classes/module/Module.php:296 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-06-14 00:00:00',
INTERVAL 20 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 = 1
AND p.id_product = 2298
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
 0.5 1 /classes/ProductAssembler.php:91 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.5 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1
 0.5 1 /src/Adapter/EntityMapper.php:74 
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 1 /classes/Language.php:810 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.4 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="76b6d8312c49297e29f3601b740942bc" LIMIT 1
 0.4 1 /modules/ps_facetedsearch/src/Filters/Block.php:168 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 22 LIMIT 1
 0.4 1 /classes/Category.php:1269 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 22 AND ctg.`id_group` = 1 LIMIT 1
 0.4 1 /classes/Category.php:1587 
SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 9 ORDER BY vl.`value` ASC
 0.4 32 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:181 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.4 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1262
ORDER BY f.position ASC
 0.3 3 Yes /classes/Product.php:4586 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.3 87 /classes/module/Module.php:296 
SELECT SQL_NO_CACHE r.id_reward
FROM `ps_rewards` r
JOIN `ps_orders` o USING (id_order)
WHERE (id_reward_state=1 AND o.current_state IN (4,5,2,14,15))
OR (r.id_reward_state = 6
AND o.current_state IN (4,5,2,14,15))
 0.3 8 /modules/allinone_rewards/models/RewardsModel.php:500 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1262) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
 0.3 1 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1262 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE fp.id_feature, vl.value, fl.name
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` v ON (fp.`id_feature_value` = v.`id_feature_value`)
LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1)
LEFT JOIN `ps_feature` f ON (f.`id_feature` = v.`id_feature`)
LEFT JOIN `ps_feature_lang` fl ON (fl.`id_feature` = f.`id_feature` AND fl.`id_lang` = 1)
WHERE fp.`id_product` = 1262 ORDER BY f.`position` ASC, fp.`position` ASC
 0.3 3 Yes /modules/pm_multiplefeatures/pm_multiplefeatures.php:201 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2298) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 517) AND (a0.`nright` > 590) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 0.3 6 Yes /classes/PrestaShopCollection.php:358 
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` = 201) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1262
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
 0.2 0 /classes/Product.php:5725 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 2298
ORDER BY `position`
 0.2 2 Yes /classes/Product.php:2779 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1262
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:2779 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ultimateimagetool" LIMIT 1
 0.2 1 /classes/module/Module.php:2597 
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` = 1262)
 0.2 1 /classes/Product.php:3041 
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.2 1 /classes/Currency.php:603 
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` = 8
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('66240' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '66240')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.2 0 /classes/tax/TaxRulesTaxManager.php:110 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.2 1 /classes/ObjectModel.php:1406 
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` = 199) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE b.id_pagebuilderprofile
FROM `ps_pagebuilderprofile` b
WHERE (`key`= '1478580409') LIMIT 1
 0.2 26 /modules/pspagebuilder/classes/profile.php:157 
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
 0.2 1 /classes/Page.php:100 
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` = 2298)
 0.2 1 /classes/Product.php:3041 
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` = 8) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
 0.2 171 /classes/Tab.php:314 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.2 1 /classes/ObjectModel.php:1509 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.2 1 /classes/ObjectModel.php:1509 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.2 1 /classes/Language.php:957 
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 22 LIMIT 1
 0.2 1 /classes/Page.php:80 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1262 LIMIT 1
 0.2 1 /classes/SpecificPrice.php:406 
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` = 8) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description`
FROM `ps_category_lang` cl
WHERE cl.`id_lang` = 1
AND cl.`id_category` = 22 AND cl.id_shop = 1 LIMIT 1
 0.2 1 /classes/Meta.php:387 
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` = 200) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE *
FROM ps_pssliderlayer_groups gr
WHERE gr.id_shop = 1
AND gr.hook = "header" AND gr.`active` = 1
ORDER BY gr.id_pssliderlayer_groups LIMIT 1
 0.2 1 /modules/pssliderlayer/pssliderlayer.php:973 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('4864812', '29', '51837274', '', '1', '1', '2024-06-14 12:39:51')
 0.2 1 /classes/ObjectModel.php:518 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.2 83 /classes/Hook.php:248 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.2 1 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2298) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.2 1 /classes/stock/StockAvailable.php:380 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1262) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.2 1 /classes/stock/StockAvailable.php:380 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1262
 0.2 1 /classes/Product.php:2219 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2298 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:406 
SELECT SQL_NO_CACHE *
FROM `ps_rewards_state_lang`
WHERE `id_reward_state` = 2
 0.1 1 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 22 LIMIT 1
 0.1 1 /classes/Product.php:4363 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ptsthemepanel" LIMIT 1
 0.1 1 /classes/module/Module.php:2597 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8
 0.1 1 /src/Adapter/EntityMapper.php:74 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 22 LIMIT 1
 0.1 1 /classes/Product.php:4363 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1262 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5220 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2298
 0.1 1 /classes/Product.php:2219 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:67 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 81 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2149 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
 0.1 1 /classes/Country.php:271 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.1 0 /classes/module/Module.php:2597 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1
 0.1 1 /classes/AddressFormat.php:616 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2149 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1509 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2298 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2298 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5220 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
 0.1 1 /classes/Group.php:150

Doubles

36
SELECT DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = XX) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = XX) ORDER BY f.`position` ASC
16
SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX  AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (XX, XX) AND c.nleft>=XX AND c.nright<=XX AND ps.id_shop='XX' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
5
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
5
SELECT v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
3
				SELECT tr.*
				FROM `ps_tax_rule` tr
				JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
				LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`id_customer` = XX  AND cr.date_from < "XX-XX-XX XX:XX:XX"
				AND cr.date_to > "XX-XX-XX XX:XX:XX"
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
				LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`group_restriction` = XX  AND cr.date_from < "XX-XX-XX XX:XX:XX"
				AND cr.date_to > "XX-XX-XX XX:XX:XX"
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%")
3
SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
2
		SELECT m.*, ml.`description`, ml.`short_description`
		FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop
        ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2
			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;
2
SELECT `id_product_attribute`
			FROM `ps_product_attribute`
			WHERE `id_product` = XX
2
		SELECT fp.id_feature, vl.value, fl.name
		FROM `ps_feature_product` fp
		LEFT JOIN `ps_feature_value` v ON (fp.`id_feature_value` = v.`id_feature_value`)
		LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX)
		LEFT JOIN `ps_feature` f ON (f.`id_feature` = v.`id_feature`)
		
		LEFT JOIN `ps_feature_lang` fl ON (fl.`id_feature` = f.`id_feature` AND fl.`id_lang` = XX)
		WHERE fp.`id_product` = XX ORDER BY f.`position` ASC, fp.`position` ASC
2
			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`
2
			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
2
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
2
				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
2
SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
2
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
2
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)
2
							SELECT `id_tax_rules_group`
							FROM `ps_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
2
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
2
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
2
SELECT * FROM `ps_hook_alias`
2
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
2
                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 `minimal_quantity`
			FROM `ps_product_attribute_shop` pas
			WHERE `id_shop` = XX
			AND `id_product_attribute` = XX LIMIT XX

Tables stress

100 feature_product
40 feature_lang
40 feature
38 feature_shop
36 layered_indexable_feature
36 layered_indexable_feature_lang_value
30 category
27 product_attribute
27 product
27 product_shop
25 product_attribute_combination
25 stock_available
22 category_product
21 product_sale
13 category_lang
9 feature_value_lang
8 product_attribute_shop
8 module
8 category_shop
8 cart_rule
8 cart_rule_lang
7 feature_value
6 module_shop
5 layered_indexable_feature_value_lang_value
4 product_lang
4 shop
4 attribute_lang
4 attribute
4 shop_url
4 country
4 hook
4 lang_shop
3 country_lang
3 country_shop
3 specific_price
3 hook_alias
3 tax_rule
3 tax_rules_group
3 lang
3 currency_shop
3 category_group
2 product_group_reduction_cache
2 attribute_group_lang
2 image
2 image_shop
2 image_lang
2 attribute_group
2 layered_category
2 configuration
2 shop_group
2 group_shop
2 rewards
2 manufacturer_lang
2 manufacturer_shop
2 hook_module
2 manufacturer
2 currency
2 group
1 address_format
1 required_field
1 page_type
1 pagebuilderprofile
1 pssliderlayer_groups
1 tab
1 rewards_state
1 connections
1 orders
1 rewards_state_lang
1 tax_lang
1 state
1 zone
1 image_type
1 configuration_lang
1 hook_module_exceptions
1 tax
1 layered_filter_block
1 module_group
1 meta
1 meta_lang
1 group_lang
1 page

ObjectModel instances

NameInstancesSource
Category 8 /controllers/front/listing/CategoryController.php [67]
/controllers/front/listing/CategoryController.php [144]
/controllers/front/listing/CategoryController.php [144]
/controllers/front/listing/CategoryController.php [144]
/modules/ps_facetedsearch/src/Product/Search.php [101]
/classes/PrestaShopCollection.php [360]
/classes/PrestaShopCollection.php [360]
/modules/ps_categorytree/ps_categorytree.php [288]
Product 8 /classes/Link.php [98]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [98]
/classes/Link.php [98]
/classes/Link.php [98]
/src/Adapter/Image/ImageRetriever.php [52]
/classes/Link.php [98]
/classes/Link.php [98]
Address 4 /classes/Product.php [2903]
/classes/Product.php [2984]
/classes/Product.php [4538]
/classes/shop/Shop.php [465]
Country 3 /config/config.inc.php [146]
/classes/AddressFormat.php [353]
/classes/controller/FrontController.php [1601]
Tax 2 /classes/tax/TaxRulesTaxManager.php [117]
/classes/tax/TaxRulesTaxManager.php [117]
Language 2 /config/config.inc.php [199]
/classes/Tools.php [464]
Combination 2 /classes/Product.php [4517]
/classes/Product.php [4517]
AddressFormat 1 /classes/controller/FrontController.php [1595]
Guest 1 /modules/statsdata/statsdata.php [83]
RewardsStateModel 1 /modules/allinone_rewards/models/RewardsModel.php [472]
PsVerticalMenuWidget 1 /modules/psverticalmenu/psverticalmenu.php [48]
PsMegamenuWidget 1 /modules/psmegamenu/psmegamenu.php [47]
State 1 /classes/controller/FrontController.php [1600]
Shop 1 /config/config.inc.php [120]
Risk 1 /classes/controller/FrontController.php [1565]
Gender 1 /classes/controller/FrontController.php [1562]
Group 1 /classes/Cart.php [214]
Cart 1 /classes/controller/FrontController.php [416]
Currency 1 /classes/Tools.php [579]
Customer 1 /config/config.inc.php [225]
ShopGroup 1 /classes/shop/Shop.php [547]
Connection 1 /modules/statsdata/statsdata.php [117]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/autoload.php
5/config/alias.php
6/classes/PrestaShopAutoload.php
7/app/cache/prod/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/settings.inc.php
32/config/bootstrap.php
33/src/Core/ContainerBuilder.php
34/src/Core/Foundation/IoC/Container.php
35/src/Adapter/ServiceLocator.php
36/vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
37/app/cache/prod/appParameters.php
38/classes/controller/Controller.php
39/classes/ObjectModel.php
40/src/Core/Foundation/Database/EntityInterface.php
41/classes/db/Db.php
42/classes/Tools.php
43/classes/Context.php
44/classes/shop/Shop.php
45/classes/db/DbPDO.php
46/classes/Configuration.php
47/classes/Validate.php
48/classes/cache/Cache.php
49/src/Adapter/EntityMapper.php
50/classes/db/DbQuery.php
51/src/Core/Addon/Theme/ThemeManagerBuilder.php
52/src/Adapter/Configuration.php
53/src/Core/ConfigurationInterface.php
54/src/Core/Addon/Theme/ThemeRepository.php
55/src/Core/Addon/AddonRepositoryInterface.php
56/vendor/symfony/symfony/src/Symfony/Component/Yaml/Parser.php
57/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php
58/vendor/symfony/symfony/src/Symfony/Component/Yaml/Unescaper.php
59/src/Core/Addon/Theme/Theme.php
60/src/Core/Addon/AddonInterface.php
61/vendor/shudrum/array-finder/ArrayFinder.php
62/config/defines_uri.inc.php
63/tools/htmlpurifier/HTMLPurifier.standalone.php
64/classes/Language.php
65/classes/Country.php
66/classes/PrestaShopCollection.php
67/classes/shop/ShopGroup.php
68/classes/Cookie.php
69/classes/PhpEncryption.php
70/vendor/defuse/php-encryption/src/Core.php
71/classes/PhpEncryptionEngine.php
72/vendor/defuse/php-encryption/src/Key.php
73/vendor/defuse/php-encryption/src/Encoding.php
74/config/smarty.config.inc.php
75/vendor/prestashop/smarty/Smarty.class.php
76/vendor/prestashop/smarty/sysplugins/smarty_internal_data.php
77/vendor/prestashop/smarty/sysplugins/smarty_internal_templatebase.php
78/vendor/prestashop/smarty/sysplugins/smarty_internal_template.php
79/vendor/prestashop/smarty/sysplugins/smarty_resource.php
80/vendor/prestashop/smarty/sysplugins/smarty_internal_resource_file.php
81/vendor/prestashop/smarty/sysplugins/smarty_cacheresource.php
82/vendor/prestashop/smarty/sysplugins/smarty_internal_cacheresource_file.php
83/config/smartyfront.config.inc.php
84/classes/Smarty/SmartyResourceModule.php
85/vendor/prestashop/smarty/sysplugins/smarty_resource_custom.php
86/classes/Smarty/SmartyResourceParent.php
87/classes/Smarty/SmartyLazyRegister.php
88/vendor/prestashop/smarty/plugins/modifier.truncate.php
89/classes/Customer.php
90/classes/Group.php
91/classes/Link.php
92/override/classes/Link.php
93/classes/shop/ShopUrl.php
94/classes/module/Module.php
95/classes/Dispatcher.php
96/classes/Hook.php
97/vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
98/config/db_slave_server.inc.php
99/modules/psblog/psblog.php
100/modules/psblog/loader.php
101/modules/psblog/classes/config.php
102/modules/psblog/libs/Helper.php
103/modules/psblog/classes/psblogcat.php
104/modules/psblog/classes/blog.php
105/modules/psblog/classes/link.php
106/modules/psblog/classes/comment.php
107/modules/psblog/classes/PsblogOwlCarousel.php
108/src/PrestaShopBundle/Translation/TranslatorComponent.php
109/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
110/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
111/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
112/src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
113/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageSelector.php
114/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
115/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
116/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
117/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
118/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
119/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceChecker.php
120/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerInterface.php
121/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/BCResourceInterfaceChecker.php
122/app/cache/prod/translations/catalogue.fr-FR.8739602554c7f3241958e3cc9b57fdecb474d508.php
123/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
124/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
125/vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
126/classes/Translate.php
127/modules/psblog/translations/fr.php
128/controllers/front/listing/CategoryController.php
129/classes/controller/ProductListingFrontController.php
130/classes/controller/ProductPresentingFrontController.php
131/classes/controller/FrontController.php
132/src/Adapter/ObjectPresenter.php
133/src/Core/Foundation/Templating/PresenterInterface.php
134/src/Adapter/Cart/CartPresenter.php
135/src/Adapter/Product/PriceFormatter.php
136/src/Adapter/Image/ImageRetriever.php
137/classes/tax/TaxConfiguration.php
138/classes/Smarty/TemplateFinder.php
139/classes/assets/StylesheetManager.php
140/classes/assets/AbstractAssetManager.php
141/src/Adapter/Assets/AssetUrlGeneratorTrait.php
142/classes/assets/JavascriptManager.php
143/classes/assets/CccReducer.php
144/classes/Category.php
145/override/classes/Category.php
146/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerBuilder.php
147/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
148/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/IntrospectableContainerInterface.php
149/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
150/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
151/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/TaggedContainerInterface.php
152/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php
153/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBagInterface.php
154/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ResourceInterface.php
155/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/YamlFileLoader.php
156/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/FileLoader.php
157/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/FileLoader.php
158/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/Loader.php
159/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/LoaderInterface.php
160/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocator.php
161/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocatorInterface.php
162/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/FileResource.php
163/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceInterface.php
164/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Definition.php
165/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/Compiler.php
166/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/PassConfig.php
167/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/MergeExtensionConfigurationPass.php
168/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CompilerPassInterface.php
169/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ExtensionCompilerPass.php
170/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveDefinitionTemplatesPass.php
171/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/DecoratorServicePass.php
172/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveParameterPlaceHoldersPass.php
173/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckDefinitionValidityPass.php
174/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveReferencesToAliasesPass.php
175/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveInvalidReferencesPass.php
176/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AutowirePass.php
177/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AnalyzeServiceReferencesPass.php
178/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatablePassInterface.php
179/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckCircularReferencesPass.php
180/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckReferenceValidityPass.php
181/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemovePrivateAliasesPass.php
182/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ReplaceAliasByActualDefinitionPass.php
183/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveAbstractDefinitionsPass.php
184/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatedPass.php
185/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/InlineServiceDefinitionsPass.php
186/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveUnusedDefinitionsPass.php
187/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php
188/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraph.php
189/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/LoggingFormatter.php
190/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/FrozenParameterBag.php
191/classes/Currency.php
192/src/Core/Cldr/Repository.php
193/vendor/icanboogie/cldr/lib/RunTimeProvider.php
194/vendor/icanboogie/cldr/lib/ProviderChainTrait.php
195/vendor/icanboogie/cldr/lib/ProviderInterface.php
196/vendor/icanboogie/cldr/lib/CacheInterface.php
197/vendor/icanboogie/cldr/lib/FileProvider.php
198/vendor/icanboogie/cldr/lib/WebProvider.php
199/vendor/icanboogie/cldr/lib/Repository.php
200/vendor/icanboogie/cldr/lib/AccessorTrait.php
201/vendor/icanboogie/cldr/lib/LocaleCollection.php
202/vendor/icanboogie/cldr/lib/RepositoryPropertyTrait.php
203/vendor/icanboogie/cldr/lib/CollectionTrait.php
204/vendor/icanboogie/cldr/lib/Locale.php
205/vendor/icanboogie/cldr/lib/CodePropertyTrait.php
206/vendor/icanboogie/cldr/lib/Supplemental.php
207/vendor/icanboogie/cldr/lib/Currency.php
208/vendor/icanboogie/cldr/lib/LocalizedCurrency.php
209/vendor/icanboogie/cldr/lib/LocalizedObjectWithFormatter.php
210/vendor/icanboogie/cldr/lib/LocalizedObject.php
211/vendor/icanboogie/cldr/lib/LocalePropertyTrait.php
212/classes/Cart.php
213/src/Adapter/AddressFactory.php
214/classes/CartRule.php
215/classes/Product.php
216/classes/webservice/WebserviceRequest.php
217/src/Core/Product/Search/ProductSearchContext.php
218/src/Core/Product/Search/ProductSearchQuery.php
219/src/Core/Product/Search/SortOrder.php
220/modules/ps_facetedsearch/ps_facetedsearch.php
221/modules/ps_facetedsearch/vendor/autoload.php
222/modules/ps_facetedsearch/vendor/composer/autoload_real.php
223/modules/ps_facetedsearch/vendor/composer/autoload_static.php
224/src/Core/Module/WidgetInterface.php
225/modules/ps_facetedsearch/src/HookDispatcher.php
226/modules/ps_facetedsearch/src/Hook/Attribute.php
227/modules/ps_facetedsearch/src/Hook/AbstractHook.php
228/modules/ps_facetedsearch/src/Hook/AttributeGroup.php
229/modules/ps_facetedsearch/src/Hook/Category.php
230/modules/ps_facetedsearch/src/Hook/Design.php
231/modules/ps_facetedsearch/src/Hook/Feature.php
232/modules/ps_facetedsearch/src/Form/Feature/FormModifier.php
233/modules/ps_facetedsearch/src/Form/Feature/FormDataProvider.php
234/modules/ps_facetedsearch/src/Hook/FeatureValue.php
235/modules/ps_facetedsearch/src/Hook/Product.php
236/modules/ps_facetedsearch/src/Hook/ProductSearch.php
237/modules/ps_facetedsearch/src/Hook/SpecificPrice.php
238/modules/ps_facetedsearch/src/URLSerializer.php
239/modules/ps_facetedsearch/src/Filters/DataAccessor.php
240/modules/ps_facetedsearch/src/Product/SearchProvider.php
241/src/Core/Product/Search/FacetsRendererInterface.php
242/src/Core/Product/Search/ProductSearchProviderInterface.php
243/modules/ps_facetedsearch/src/Filters/Converter.php
244/modules/ps_facetedsearch/src/Product/SearchFactory.php
245/src/Core/Product/Search/ProductSearchResult.php
246/classes/Manufacturer.php
247/modules/ps_facetedsearch/src/Product/Search.php
248/modules/ps_facetedsearch/src/Adapter/MySQL.php
249/modules/ps_facetedsearch/src/Adapter/AbstractAdapter.php
250/modules/ps_facetedsearch/src/Adapter/InterfaceAdapter.php
251/vendor/doctrine/collections/lib/Doctrine/Common/Collections/ArrayCollection.php
252/vendor/doctrine/collections/lib/Doctrine/Common/Collections/Collection.php
253/vendor/doctrine/collections/lib/Doctrine/Common/Collections/Selectable.php
254/modules/ps_facetedsearch/src/Filters/Products.php
255/classes/stock/StockAvailable.php
256/modules/ps_facetedsearch/src/Filters/Block.php
257/src/Core/Product/Search/Facet.php
258/src/Core/Product/Search/Filter.php
259/src/Core/Product/Search/FacetCollection.php
260/classes/ProductAssembler.php
261/modules/pm_multiplefeatures/pm_multiplefeatures.php
262/classes/Feature.php
263/classes/Combination.php
264/classes/tax/Tax.php
265/classes/Address.php
266/classes/SpecificPrice.php
267/classes/tax/TaxManagerFactory.php
268/classes/tax/TaxRulesTaxManager.php
269/classes/tax/TaxManagerInterface.php
270/classes/tax/TaxCalculator.php
271/classes/GroupReduction.php
272/classes/ProductPresenterFactory.php
273/src/Core/Product/ProductListingPresenter.php
274/src/Core/Product/ProductPresenter.php
275/src/Adapter/Product/ProductColorsRetriever.php
276/src/Core/Product/ProductPresentationSettings.php
277/classes/Image.php
278/classes/ImageType.php
279/src/Core/Addon/Module/ModuleManagerBuilder.php
280/app/config/config.php
281/src/PrestaShopBundle/Service/DataProvider/Marketplace/ApiClient.php
282/vendor/guzzlehttp/guzzle/src/Client.php
283/vendor/guzzlehttp/guzzle/src/Event/HasEmitterTrait.php
284/vendor/guzzlehttp/guzzle/src/ClientInterface.php
285/vendor/guzzlehttp/guzzle/src/Event/HasEmitterInterface.php
286/vendor/guzzlehttp/guzzle/src/Url.php
287/vendor/guzzlehttp/guzzle/src/Utils.php
288/vendor/guzzlehttp/guzzle/src/Message/MessageFactory.php
289/vendor/guzzlehttp/guzzle/src/Event/ListenerAttacherTrait.php
290/vendor/guzzlehttp/guzzle/src/Message/MessageFactoryInterface.php
291/vendor/guzzlehttp/guzzle/src/Subscriber/HttpError.php
292/vendor/guzzlehttp/guzzle/src/Event/SubscriberInterface.php
293/vendor/guzzlehttp/guzzle/src/Subscriber/Redirect.php
294/vendor/guzzlehttp/ringphp/src/Client/CurlHandler.php
295/vendor/guzzlehttp/ringphp/src/Client/CurlFactory.php
296/vendor/guzzlehttp/ringphp/src/Client/CurlMultiHandler.php
297/vendor/guzzlehttp/ringphp/src/Client/Middleware.php
298/vendor/guzzlehttp/ringphp/src/Client/StreamHandler.php
299/vendor/guzzlehttp/guzzle/src/RequestFsm.php
300/src/Adapter/Tools.php
301/app/config/parameters.php
302/src/Adapter/Module/ModuleZipManager.php
303/src/Adapter/Addons/AddonsDataProvider.php
304/src/PrestaShopBundle/Service/DataProvider/Admin/AddonsInterface.php
305/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
306/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
307/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
308/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
309/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
310/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
311/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
312/src/PrestaShopBundle/Service/DataProvider/Admin/CategoriesProvider.php
313/src/Adapter/LegacyContext.php
314/src/Adapter/LegacyLogger.php
315/vendor/psr/log/Psr/Log/LoggerInterface.php
316/src/Adapter/Module/AdminModuleDataProvider.php
317/src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php
318/vendor/symfony/symfony/src/Symfony/Component/Routing/Loader/YamlFileLoader.php
319/vendor/symfony/symfony/src/Symfony/Component/Routing/Router.php
320/vendor/symfony/symfony/src/Symfony/Component/Routing/RouterInterface.php
321/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/UrlMatcherInterface.php
322/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContextAwareInterface.php
323/vendor/symfony/symfony/src/Symfony/Component/Routing/Generator/UrlGeneratorInterface.php
324/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/RequestMatcherInterface.php
325/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContext.php
326/src/Adapter/Module/ModuleDataUpdater.php
327/src/Adapter/Module/ModuleDataProvider.php
328/src/Core/Addon/Module/ModuleManager.php
329/src/Core/Addon/AddonManagerInterface.php
330/src/Core/Addon/Module/ModuleRepository.php
331/src/Core/Addon/Module/ModuleRepositoryInterface.php
332/vendor/symfony/symfony/src/Symfony/Component/Finder/Finder.php
333/src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php
334/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcherInterface.php
335/vendor/icanboogie/cldr/lib/Numbers.php
336/vendor/icanboogie/cldr/lib/CurrencyFormatter.php
337/vendor/icanboogie/cldr/lib/NumberFormatter.php
338/vendor/icanboogie/cldr/lib/NumberPattern.php
339/classes/ImageManager.php
340/app/cache/prod/smarty/compile/d4/1d/65/d41d65d76b9471b5d365fe06cf1737c89a53af9f.module.facets.tpl.php
341/app/cache/prod/smarty/compile/2e/80/73/2e807335546cfa2360c36327ac89dd2fcb054379.module.active-filters.tpl.php
342/src/Core/Product/Search/Pagination.php
343/modules/ptsthemepanel/ptsthemepanel.php
344/modules/ptsthemepanel/classes/helper.php
345/modules/ptsthemepanel/classes/sample.php
346/modules/ptsthemepanel/translations/fr.php
347/modules/allinone_rewards/allinone_rewards.php
348/modules/allinone_rewards/plugins/RewardsCorePlugin.php
349/modules/allinone_rewards/plugins/RewardsGenericPlugin.php
350/modules/allinone_rewards/plugins/RewardsLoyaltyPlugin.php
351/modules/allinone_rewards/plugins/RewardsSponsorshipPlugin.php
352/modules/allinone_rewards/models/RewardsModel.php
353/modules/allinone_rewards/models/RewardsAccountModel.php
354/modules/allinone_rewards/models/RewardsSponsorshipModel.php
355/modules/allinone_rewards/plugins/RewardsFacebookPlugin.php
356/modules/allinone_rewards/models/RewardsStateModel.php
357/modules/allinone_rewards/models/RewardsSponsorshipCodeModel.php
358/modules/allinone_rewards/models/RewardsPaymentModel.php
359/modules/allinone_rewards/models/RewardsFacebookModel.php
360/modules/allinone_rewards/models/RewardsTemplateModel.php
361/modules/allinone_rewards/models/RewardsProductModel.php
362/modules/allinone_rewards/models/RewardsGiftProductModel.php
363/modules/allinone_rewards/models/RewardsGiftProductAttributeModel.php
364/modules/allinone_rewards/translations/fr.php
365/modules/statsdata/statsdata.php
366/modules/ps_emailsubscription/ps_emailsubscription.php
367/classes/Media.php
368/modules/nkmgls/nkmgls.php
369/modules/nkmgls/vendor/autoload.php
370/modules/nkmgls/vendor/composer/autoload_real.php
371/modules/nkmgls/vendor/composer/platform_check.php
372/modules/nkmgls/vendor/composer/autoload_static.php
373/modules/nkmgls/vendor/nukium/gls-prestashop/lib/NkmHelper.php
374/modules/nkmgls/controllers/admin/AdminGlsOrderController.php
375/classes/controller/ModuleAdminController.php
376/classes/controller/AdminController.php
377/modules/nkmgls/controllers/admin/AdminGlsAjaxController.php
378/modules/nkmgls/controllers/admin/AdminGlsLabelController.php
379/modules/nkmgls/controllers/admin/AdminGlsPackingListController.php
380/classes/module/CarrierModule.php
381/modules/nkmgls/translations/fr.php
382/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Init/PrestashopGlsInit.php
383/modules/nkmgls/vendor/nukium/gls-common/src/Service/Init/GlsInit.php
384/modules/nkmgls/vendor/nukium/gls-common/src/Service/Init/ShipItAdapterResolutionInit.php
385/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Init/PrestashopAdapterInit.php
386/modules/nkmgls/vendor/nukium/gls-common/src/Service/Init/AdapterInitInterface.php
387/modules/nkmgls/vendor/nukium/gls-common/src/Service/Repository/Cache/CacheRepositoryFactory.php
388/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Repository/Cache/PrestashopCacheRepository.php
389/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Repository/AbstractRepository.php
390/modules/nkmgls/vendor/nukium/gls-common/src/Service/Repository/Cache/CacheRepositoryInterface.php
391/modules/nkmgls/vendor/nukium/gls-prestashop/classes/GlsCacheClass.php
392/modules/nkmgls/vendor/nukium/gls-common/src/Entity/CacheInterface.php
393/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/DTO/Adapter/Address/AddressHandlerFactory.php
394/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Handler/DTO/Adapter/Address/PrestashopAddressHandler.php
395/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/DTO/Adapter/Address/AddressHandler.php
396/modules/nkmgls/vendor/nukium/gls-common/src/Service/Container.php
397/modules/nkmgls/vendor/nukium/gls-common/src/Service/ContainerInterface.php
398/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/DTO/Adapter/Carrier/CarrierHandlerFactory.php
399/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Handler/DTO/Adapter/Carrier/PrestashopCarrierHandler.php
400/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/DTO/Adapter/Carrier/CarrierHandler.php
401/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Adapter/Config/PrestashopConfig.php
402/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Config/ConfigInterface.php
403/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/Entity/Cache/CacheHandlerFactory.php
404/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Handler/Entity/Cache/PrestashopCacheHandler.php
405/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/Entity/Cache/CacheHandler.php
406/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Config/ConfigFactory.php
407/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/EntityManager/EntityManagerFactory.php
408/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Adapter/EntityManager/PrestashopEntityManager.php
409/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/EntityManager/EntityManagerInterface.php
410/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Shop/ShopFactory.php
411/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Adapter/Shop/PrestashopShop.php
412/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Shop/ShopInterface.php
413/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Translator/TranslatorFactory.php
414/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Adapter/Translator/PrestashopTranslator.php
415/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Translator/TranslatorInterface.php
416/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Utility/UtilityFactory.php
417/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Adapter/Utility/PrestashopUtility.php
418/modules/nkmgls/vendor/nukium/gls-common/src/Service/Adapter/Utility/Component/DefaultUtility.php
419/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/ShipItAdapterResolution.php
420/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/NoShipItAdapter.php
421/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/ShipItAdapterInterface.php
422/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/LabelAdapter.php
423/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/AbstractAdapter.php
424/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/Component/AuthErrorComponent.php
425/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/ShipItComponentInterface.php
426/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/Component/DefaultErrorComponent.php
427/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/Component/LabelInternationalComponent.php
428/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Routine/ShipItErrorRoutine.php
429/modules/nkmgls/vendor/nukium/gls-common/src/Service/API/ShipmentApi.php
430/modules/nkmgls/vendor/nukium/gls-common/src/Service/HttpClient/LegacyClient.php
431/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/Legacy/GlsApiHandler.php
432/modules/nkmgls/vendor/nukium/gls-common/src/Service/HttpClient/GlsCurlClient.php
433/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/Component/LabelErrorComponent.php
434/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/Component/LabelComponent.php
435/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/RelayAdapter.php
436/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/Component/RelayComponent.php
437/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/TrackingAdapter.php
438/modules/nkmgls/vendor/nukium/gls-common/src/Service/ShipIt/Adapter/Component/TrackingComponent.php
439/modules/nkmgls/vendor/nukium/gls-common/src/Service/API/TrackingApi.php
440/modules/nkmgls/vendor/nukium/gls-common/src/Service/Helper/GlsHelper.php
441/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Helper/ModuleHelper.php
442/modules/nkmgls/vendor/nukium/gls-prestashop/src/Service/Helper/EnvHelper.php
443/modules/nkmgls/vendor/nukium/gls-common/src/Service/Routine/AllowedServicesRoutine.php
444/modules/nkmgls/vendor/nukium/gls-common/src/Service/DataLoader/AllowedServicesLoader.php
445/modules/nkmgls/vendor/nukium/gls-common/src/Service/Handler/DTO/GLS/AllowedServicesHandler.php
446/modules/nkmgls/vendor/nukium/gls-common/src/Service/API/AllowedServicesApi.php
447/modules/nkmgls/vendor/nukium/gls-common/src/Service/Routine/CacheRoutine.php
448/modules/nkmgls/vendor/nukium/gls-common/src/Service/DataLoader/CacheLoader.php
449/src/Adapter/Product/PriceCalculator.php
450/classes/ProductDownload.php
451/classes/Gender.php
452/classes/Risk.php
453/classes/Meta.php
454/classes/AddressFormat.php
455/classes/State.php
456/modules/ps_imageslider/ps_imageslider.php
457/modules/ps_imageslider/Ps_HomeSlide.php
458/modules/ps_searchbar/ps_searchbar.php
459/modules/ps_shoppingcart/ps_shoppingcart.php
460/modules/psmegamenu/psmegamenu.php
461/modules/psmegamenu/loader.php
462/modules/psmegamenu/classes/psmenurijndael.php
463/modules/psmegamenu/classes/mcrypt.php
464/modules/psmegamenu/classes/Psbtmegamenu.php
465/modules/psmegamenu/libs/Helper.php
466/modules/psmegamenu/classes/widgetbase.php
467/modules/psmegamenu/classes/widget.php
468/classes/PhpEncryptionLegacyEngine.php
469/modules/psmegamenu/translations/fr.php
470/modules/pspagebuilder/pspagebuilder.php
471/modules/pspagebuilder/loader.php
472/modules/pspagebuilder/classes/psrijndael.php
473/modules/pspagebuilder/classes/mcrypt.php
474/modules/pspagebuilder/classes/helper.php
475/modules/pspagebuilder/classes/widgetbase.php
476/modules/pspagebuilder/classes/profile.php
477/modules/pspagebuilder/translations/fr.php
478/app/cache/prod/smarty/cache/pspagebuilder/1478580409/20240614/1/1/1/1/1/8/ec/5a/58/ec5a5839a8d5de095ba7b3207fe9315be8e443d2.pspagebuilder.tpl.php
479/modules/pssliderlayer/pssliderlayer.php
480/modules/pssliderlayer/classes/grouplayer.php
481/modules/pssliderlayer/classes/sliderlayer.php
482/modules/pssliderlayer/classes/status.php
483/modules/pssliderlayer/translations/fr.php
484/classes/Tab.php
485/modules/ptsbttestimonials/ptsbttestimonials.php
486/modules/ptsbttestimonials/classes/PtsTestimonial.php
487/modules/ptsbttestimonials/translations/fr.php
488/modules/ptsmaplocator/ptsmaplocator.php
489/modules/ptsmaplocator/translations/fr.php
490/modules/psverticalmenu/psverticalmenu.php
491/modules/psverticalmenu/loader.php
492/modules/psverticalmenu/classes/psverticalrijndael.php
493/modules/psverticalmenu/classes/mcrypt.php
494/modules/psverticalmenu/classes/PsVerticalMegamenu.php
495/modules/psverticalmenu/libs/Helper.php
496/modules/psverticalmenu/classes/widgetbase.php
497/modules/psverticalmenu/classes/widget.php
498/modules/psverticalmenu/translations/fr.php
499/modules/leofeature/leofeature.php
500/modules/leofeature/classes/ProductReviewCriterion.php
501/modules/leofeature/classes/ProductReview.php
502/modules/leofeature/classes/CompareProduct.php
503/modules/leofeature/classes/WishList.php
504/modules/leofeature/translations/fr.php
505/modules/thegiftcard/thegiftcard.php
506/modules/thegiftcard/models/GiftCardModel.php
507/modules/thegiftcard/models/GiftCardUploader.php
508/modules/thegiftcard/translations/fr.php
509/modules/payplug/payplug.php
510/modules/payplug/classes/MyLogPHP.class.php
511/modules/payplug/lib/init.php
512/modules/payplug/lib/Payplug/Authentication.php
513/modules/payplug/lib/Payplug/Card.php
514/modules/payplug/lib/Payplug/Customer.php
515/modules/payplug/lib/Payplug/InstallmentPlan.php
516/modules/payplug/lib/Payplug/Notification.php
517/modules/payplug/lib/Payplug/Payment.php
518/modules/payplug/lib/Payplug/Payplug.php
519/modules/payplug/lib/Payplug/Refund.php
520/modules/payplug/lib/Payplug/Core/APIRoutes.php
521/modules/payplug/lib/Payplug/Exception/PayplugException.php
522/modules/payplug/lib/Payplug/Exception/DependencyException.php
523/modules/payplug/lib/Payplug/Core/Config.php
524/modules/payplug/lib/Payplug/Core/IHttpRequest.php
525/modules/payplug/lib/Payplug/Core/CurlRequest.php
526/modules/payplug/lib/Payplug/Core/HttpClient.php
527/modules/payplug/lib/Payplug/Exception/HttpException.php
528/modules/payplug/lib/Payplug/Exception/BadRequestException.php
529/modules/payplug/lib/Payplug/Exception/ConfigurationException.php
530/modules/payplug/lib/Payplug/Exception/ConfigurationNotSetException.php
531/modules/payplug/lib/Payplug/Exception/ConnectionException.php
532/modules/payplug/lib/Payplug/Exception/ForbiddenException.php
533/modules/payplug/lib/Payplug/Exception/InvalidPaymentException.php
534/modules/payplug/lib/Payplug/Exception/NotAllowedException.php
535/modules/payplug/lib/Payplug/Exception/NotFoundException.php
536/modules/payplug/lib/Payplug/Exception/PayplugServerException.php
537/modules/payplug/lib/Payplug/Exception/PHPVersionException.php
538/modules/payplug/lib/Payplug/Exception/UnauthorizedException.php
539/modules/payplug/lib/Payplug/Exception/UndefinedAttributeException.php
540/modules/payplug/lib/Payplug/Exception/UnexpectedAPIResponseException.php
541/modules/payplug/lib/Payplug/Exception/UnknownAPIResourceException.php
542/modules/payplug/lib/Payplug/Resource/IAPIResourceFactory.php
543/modules/payplug/lib/Payplug/Resource/APIResource.php
544/modules/payplug/lib/Payplug/Resource/Card.php
545/modules/payplug/lib/Payplug/Resource/Customer.php
546/modules/payplug/lib/Payplug/Resource/IVerifiableAPIResource.php
547/modules/payplug/lib/Payplug/Resource/InstallmentPlan.php
548/modules/payplug/lib/Payplug/Resource/InstallmentPlanSchedule.php
549/modules/payplug/lib/Payplug/Resource/Payment.php
550/modules/payplug/lib/Payplug/Resource/PaymentCard.php
551/modules/payplug/lib/Payplug/Resource/PaymentCustomer.php
552/modules/payplug/lib/Payplug/Resource/PaymentHostedPayment.php
553/modules/payplug/lib/Payplug/Resource/PaymentNotification.php
554/modules/payplug/lib/Payplug/Resource/PaymentPaymentFailure.php
555/modules/payplug/lib/Payplug/Resource/Refund.php
556/modules/payplug/lib/Payplug/Resource/PaymentAuthorization.php
557/modules/payplug/lib/Payplug/Resource/PaymentBilling.php
558/modules/payplug/lib/Payplug/Resource/PaymentShipping.php
559/modules/payplug/lib/libphonenumber/CountryCodeSource.php
560/modules/payplug/lib/libphonenumber/CountryCodeToRegionCodeMap.php
561/modules/payplug/lib/libphonenumber/MetadataLoaderInterface.php
562/modules/payplug/lib/libphonenumber/DefaultMetadataLoader.php
563/modules/payplug/lib/libphonenumber/Matcher.php
564/modules/payplug/lib/libphonenumber/MatcherAPIInterface.php
565/modules/payplug/lib/libphonenumber/MetadataSourceInterface.php
566/modules/payplug/lib/libphonenumber/MultiFileMetadataSourceImpl.php
567/modules/payplug/lib/libphonenumber/NumberFormat.php
568/modules/payplug/lib/libphonenumber/NumberParseException.php
569/modules/payplug/lib/libphonenumber/PhoneMetadata.php
570/modules/payplug/lib/libphonenumber/PhoneNumber.php
571/modules/payplug/lib/libphonenumber/PhoneNumberDesc.php
572/modules/payplug/lib/libphonenumber/PhoneNumberFormat.php
573/modules/payplug/lib/libphonenumber/PhoneNumberType.php
574/modules/payplug/lib/libphonenumber/PhoneNumberUtil.php
575/modules/payplug/lib/libphonenumber/RegexBasedMatcher.php
576/modules/payplug/lib/libphonenumber/ValidationResult.php
577/modules/payplug/classes/PPPayment.php
578/modules/payplug/classes/PPPaymentInstallment.php
579/classes/PaymentModule.php
580/modules/payplug/translations/fr.php
581/modules/paypal/paypal.php
582/modules/paypal/vendor/autoload.php
583/modules/paypal/vendor/composer/autoload_real.php
584/modules/paypal/vendor/composer/autoload_static.php
585/modules/paypal/sdk/BraintreeSiSdk.php
586/modules/paypal/classes/AbstractMethodPaypal.php
587/modules/paypal/vendor/ppbtlib/src/AbstractMethod.php
588/modules/paypal/classes/PaypalCapture.php
589/modules/paypal/classes/PaypalOrder.php
590/modules/paypal/classes/PaypalCustomer.php
591/modules/paypal/classes/PaypalVaulting.php
592/modules/paypal/classes/PaypalLog.php
593/modules/paypal/vendor/ppbtlib/src/Extensions/ProcessLogger/Classes/ProcessLoggerObjectModel.php
594/modules/paypal/vendor/ppbtlib/src/Module/PaymentModule.php
595/modules/paypal/translations/fr.php
596/modules/ps_emailalerts/ps_emailalerts.php
597/modules/ps_emailalerts/MailAlert.php
598/modules/chronopost/chronopost.php
599/modules/chronopost/fr.php
600/modules/ultimateimagetool/ultimateimagetool.php
601/modules/ultimateimagetool/translations/fr.php
602/modules/bonmarkup/bonmarkup.php
603/modules/bonmarkup/translations/fr.php
604/app/cache/prod/smarty/compile/01/7d/3d/017d3d9441533714bd41a3baa82cc413ecf4a75e.file.bonmarkup.tpl.php
605/vendor/prestashop/smarty/plugins/modifier.escape.php
606/vendor/prestashop/smarty/sysplugins/smarty_internal_filter_handler.php
607/modules/eicaptcha/eicaptcha.php
608/modules/eicaptcha/vendor/autoload.php
609/modules/eicaptcha/vendor/composer/autoload_real.php
610/modules/eicaptcha/vendor/composer/autoload_static.php
611/modules/eicaptcha/translations/fr.php
612/modules/eicaptcha/src/Debugger.php
613/vendor/defuse/php-encryption/src/Crypto.php
614/vendor/defuse/php-encryption/src/KeyOrPassword.php
615/vendor/defuse/php-encryption/src/RuntimeTests.php
616/vendor/defuse/php-encryption/src/DerivedKeys.php
617/vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
618/vendor/defuse/php-encryption/src/Exception/CryptoException.php
619/app/cache/prod/smarty/compile/layouts_layout_left_column_tpl/85/b0/04/85b004fa9a73f7000a003e04877dd7243de08509.file.category.tpl.php
620/modules/ps_customersignin/ps_customersignin.php
621/app/cache/prod/smarty/compile/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c.module.ps_customersignin.tpl.php
622/modules/ps_languageselector/ps_languageselector.php
623/modules/ps_currencyselector/ps_currencyselector.php
624/app/cache/prod/smarty/compile/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617.module.ps_searchbar.tpl.php
625/app/cache/prod/smarty/compile/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880.module.ps_shoppingcart.tpl.php
626/app/cache/prod/smarty/cache/psmegamenu/20240614/1/1/1/1/1/8/1/a2/4f/da/a24fda90fed15095e48d825ca73c9b80a61e974e.megamenu.tpl.php
627/modules/ps_categorytree/ps_categorytree.php
628/app/cache/prod/smarty/compile/89/21/00/8921007f54626fc7fe42cbff53f1d70828d3393d.module.ps_categorytree.tpl.php
629/app/cache/prod/smarty/compile/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5.module.ps_facetedsearch.tpl.php
630/modules/ps_featuredproducts/ps_featuredproducts.php
631/app/cache/prod/smarty/cache/ps_featuredproducts/1/1/1/8/fa/6c/c3/fa6cc378d2942c8857b89d6bca728048c0caeedd.ps_featuredproducts.tpl.php
632/app/cache/prod/smarty/cache/1262/20240614/1/1/1/1/1/8/56/fe/de/56fedef05e62ec3451722eff9c8cf4c09914783b.swap.tpl.php
633/app/cache/prod/smarty/cache/1262/1/1/1/8/e9/6b/4a/e96b4a5d04f7e3bc0235ab2debec9735db1aa3d8.leo_list_product_review.tpl.php
634/app/cache/prod/smarty/compile/45/53/67/455367da99bf09227cd05b0f95de4eca063ddda6.file.leo_wishlist_button.tpl.php
635/classes/Attribute.php
636/app/cache/prod/smarty/compile/1d/00/37/1d0037578075a99c62d3bb247e19bb140adcd502.file.leo_cart_button.tpl.php
637/app/cache/prod/smarty/compile/45/b1/e6/45b1e64ba3990d9e3fd7a1836a52242c9f443d4e.file.leo_compare_button.tpl.php
638/app/cache/prod/smarty/cache/2298/20240614/1/1/1/1/1/8/56/fe/de/56fedef05e62ec3451722eff9c8cf4c09914783b.swap.tpl.php
639/app/cache/prod/smarty/cache/2298/1/1/1/8/e9/6b/4a/e96b4a5d04f7e3bc0235ab2debec9735db1aa3d8.leo_list_product_review.tpl.php
640/modules/ps_socialfollow/ps_socialfollow.php
641/app/cache/prod/smarty/cache/ps_socialfollow/1/1/1/8/80/ac/9d/80ac9ddb06fe7b43ffdd2f5cd1185536480d2577.ps_socialfollow.tpl.php
642/classes/Guest.php
643/classes/Connection.php
644/classes/Page.php
645/classes/ConnectionsSource.php
646/modules/ultimateimagetool/simple_html_dom.php