Actieve filters

  • Thema locatie: nederland

Duurzaamheid | SDG 5 | Gendergelijkheid

Boeken die bijdragen tot het streven naar een gelijke participatie van kansengroepen aan alle aspecten van het maatschappelijk leven.

Actieve filters

  • Thema locatie: nederland
Load Time 156 ms
Querying Time 82 ms
Queries 230
Memory Peak Usage 11.9 Mb
Included Files 935 files - 10.70 Mb
PrestaShop Cache - Mb
Global vars 0.51 Mb
PrestaShop Version 1.7.8.8
PHP Version 7.4.33
MySQL Version 10.6.16-MariaDB-0ubuntu0.22.04.1-log
Memory Limit 512M
Max Execution Time 300s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0 ms 0 ms 3.39 Mb 4.2 Mb
__construct 0 ms 0 ms - Mb 4.2 Mb
init 8 ms 8 ms 1.19 Mb 4.7 Mb
checkAccess 0 ms 8 ms - Mb 4.7 Mb
setMedia 1 ms 9 ms 0.16 Mb 4.8 Mb
postProcess 0 ms 9 ms - Mb 4.8 Mb
initHeader 0 ms 9 ms - Mb 4.8 Mb
initContent 106 ms 116 ms 4.73 Mb 9.5 Mb
initFooter 0 ms 116 ms - Mb 9.5 Mb
display 40 ms 156 ms 2.28 Mb 11.9 Mb
Hook Time Memory Usage
DisplayHeader 11 ms 0.43 Mb
DisplayBeforeBodyClosingTag 8 ms 0.23 Mb
displayNav2 7 ms 0.42 Mb
DisplayNavFullWidth 5 ms 0.26 Mb
ActionObjectCartAddAfter 4 ms 0.11 Mb
ActionSearch 3 ms - Mb
displayLeftColumn 2 ms 0.15 Mb
displayFooter 2 ms 0.21 Mb
displayNav1 1 ms 0.07 Mb
Header 1 ms 0.10 Mb
displayFooterAfter 0 ms 0.05 Mb
displayTop 0 ms 0.04 Mb
displayBeforeBodyClosingTag 0 ms 0.04 Mb
ActionFrontControllerSetMedia 0 ms 0.01 Mb
DisplayFooter 0 ms 0.01 Mb
ProductSearchProvider 0 ms - Mb
ActionDispatcherBefore 0 ms - Mb
17 hook(s) 45 ms 2.09 Mb
Module Time Memory Usage
ps_mbo 1 ms 0.13 Mb
blockreassurance 1 ms 0.10 Mb
ps_emailalerts 0 ms 0.04 Mb
ps_socialfollow 1 ms 0.07 Mb
ps_searchbar 1 ms 0.06 Mb
evxtopbar 1 ms 0.12 Mb
freega4 0 ms 0.03 Mb
ps_imageslider 0 ms 0.03 Mb
mediocheckout 0 ms 0.05 Mb
bpostshm 0 ms 0.16 Mb
pm_advancedtopmenu 5 ms 0.38 Mb
catalogblocks 0 ms 0.14 Mb
lgcookieslaw 1 ms 0.08 Mb
shoppinglist 8 ms 0.19 Mb
gamification 4 ms 0.18 Mb
productsurveysadv 0 ms 0.16 Mb
fscustomhtml 3 ms 0.44 Mb
ogone 0 ms 0.46 Mb
ps_shoppingcart 7 ms 0.35 Mb
ps_facetedsearch 1 ms 0.06 Mb
statssearch 3 ms 0.04 Mb
ps_contactinfo 1 ms 0.08 Mb
ps_currencyselector 0 ms 0.06 Mb
ps_customersignin 0 ms 0.06 Mb
ps_categorytree 2 ms 0.13 Mb
ps_linklist 1 ms 0.09 Mb
ps_customeraccountlinks 0 ms 0.07 Mb
statsdata 8 ms 0.24 Mb
28 module(s) 49 ms 4.01 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 230 queries

Query Time (ms) Rows Filesort Group By Location 
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`)
 5995 ms 2868 /classes/Configuration.php:160 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('18496265', '257928', '0', '', '8', '2', '2024-04-28 07:25:31')
 3934 ms 1 /classes/ObjectModel.php:578 
INSERT INTO `ps_cart` (`id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES ('2', '8', '0', '0', '0', '1', '0', '0', '4', '0', '0', '', '0', '', '', '0', '2024-04-28 07:25:31', '2024-04-28 07:25:31')
 3259 ms 1 /classes/ObjectModel.php:578 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 8)
WHERE pf.id_product = 9859748
ORDER BY f.position ASC
 2802 ms 27 Yes /override/classes/Product.php:6008 
INSERT INTO `ps_statssearch` (`id_shop`, `id_shop_group`, `keywords`, `results`, `date_add`)
VALUES (8, 2, '', 2, NOW())
 2788 ms 1 /modules/statssearch/statssearch.php:96 
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 = 8 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` = 8) AND (mg.id_shop = 8 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 2661 ms 1304 Yes Yes /classes/Hook.php:1183 
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')
 2578 ms 1 /classes/ObjectModel.php:578 
SELECT SQL_NO_CACHE distinct p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, 
pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`,
image_shop.`id_image` as id_image, NULL as legend, NULL as manufacturer_name , NULL as id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 30 DAY
)
) > 0 new
FROM ps_product p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 8)
INNER JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.id_shop = 8 
) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 8 AND image_shop.cover=1)
WHERE p.active = 1 and p.`id_product`  IN (-1, 9859748, 4690400)
ORDER BY FIELD (p.`id_product`,-1, 9859748, 4690400)  LIMIT 50
 2194 ms 2 Yes /classes/Search.php:386 
SELECT SQL_NO_CACHE c.`id_condition`
FROM `ps_condition` c
LEFT JOIN `ps_condition_advice` ca ON ca.`id_condition` = c.`id_condition`
WHERE (c.`calculation_type` = 'hook') AND (c.`calculation_detail` = 'ActionObjectCartAddAfter') AND (c.`validated` = 0) AND (ca.`id_advice` IN (1,2,3,4,6,10,11,12,21,22,23,24,26,30,31,32,41,42,43,44,46,50,51,52,61,62,63,64,66,70,71,72,81,82,83,84,86,90,91,92,101,102,103,104,106,110,111,112,121,122,123,124,126,130,131,132,141,142,143,144,146,150,151,152,161,162,163,164,166,170,171,172,181,182,183,184,186,190,191,192,201,202,203,204,206,210,211,212,221,222,223,224,226,230,231,232,241,242,243,244,246,250,251,252,261,263,268,269,272,279,280,281,282,284,286,287,288,289,290,291,294,296,303,304,305,306,308,310,311,312,314,315,318,320,327,328,329,330,332,334,335,336,337,338,339,342,344,351,352,353,354,356,358,359,360,361,362,363,366,368,375,376,377,378,380,382,383,384,385,386,387,390,392,399,400,401,402,404,406,407,408,409,410,411,414,416,423,424,425,426,428,430,431,432,433,434,435,438,440,447,448,449,450,452,454,455,456,458,459,460,461,463,467,468,469,471,478,479,480,481,482,483,484,485,487,491,492,493,495,502,503,504,505,506,507,508,509,511,515,516,517,519,526,527,528,529,530,531,532,533,535,539,540,541,543,550,551,552,553,554,555,556,557,559,563,564,565,567,574,575,576,577,578,579,580,581,583,587,588,589,598,599,602,611,613,618,628,629,630,631,632,633,634,637,638,639,641,648,650,653,656,658,663,673,675,680,690,692,697,700,707,708,709,710,711,712,713,714,715,716,718,723,733,735,740,750,752,757,767,768,769,770,771,774,775,776,778,785,787,790,793,795,800,810,812,817,820,827,828,829,830,831,832,833,834,835,836,838,843,853,855,860,870,872,877,887,889,894,904,906,911,921,923,928,938,940,945,955,957,962,972,974,979,989,990,991,992,993,996,997,998,1000,1007,1009,1012,1014,1015,1016,1017,1018,1019,1022,1023,1024,1026,1033,1035,1038,1041,1043,1048,1058,1060,1065,1075,1077,1082,1092,1094,1099,1109,1110,1111,1112,1113,1114,1117,1118,1119,1121,1128,1130,1132,1135,1136,1137,1138,1139,1140,1143,1144,1145,1147,1154,1156,1158,1161,1162,1163,1164,1165,1166,1169,1170,1171,1173,1180,1182,1184,1187,1189,1193,1196,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,3253,3257,3258,3260,3261,3262,3263,3265,3442,3481,3654,3742,4028,4031,4721,4723,4725,4726,4766,4794,4795,4810,4820,4836,4837,4855,4874,4875,4896,4897,4924,4976,4977,4978,4979,4980,4981,4982,4984,4985,4986,4987,4988,4989,4990,4992,4993,4994,4995,4996,4997,4998,5026,5027,5028,5029,5030,5031,5032,5033,5063,5064,5065,5066,5067,5068,5069,5070,5071,5076,5077,5078,5079,5080,5081,5082,5083,5084,5085,5086,5106,5107,5108,5109,5110,5111,5112,5114,5115,5116,5117,5118,5120,5121,5122,5123,5124,5125,5126,5127,5128,5129,5130,5131,5133,5134,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5186))
GROUP BY c.`id_condition`
 2164 ms 4956 Yes /modules/gamification/classes/Condition.php:143 
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 = 8)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 4)
WHERE i.`id_product` = 9859748
ORDER BY `position`
 1817 ms 1 Yes /override/classes/Product.php:3543 
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
 1612 ms 0 /classes/Hook.php:1243 
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, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 8)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 1510 ms 326 /classes/Hook.php:504 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 4 AND cl.id_shop = 8 
WHERE (c.nleft <= 1390 AND c.nright >= 1391)
ORDER BY c.nleft
 994 ms 1304 Yes /override/classes/Product.php:7950 
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, cp.remark,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
cu.`id_customization`, cu.`quantity` AS customization_quantity,
p.`reference` AS reference, p.`ean13`, p.`isbn`,
p.`upc` AS upc, p.`mpn` AS mpn, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `ps_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 18702399
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=8
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 4
WHERE (cp.`id_cart` = 18702399) AND (p.`id_product` IS NOT NULL)
GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization`
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
 936 ms 1 Yes Yes /classes/Cart.php:775 
SELECT SQL_NO_CACHE atp.*, atpl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps_pm_advancedtopmenu` atp
INNER JOIN `ps_pm_advancedtopmenu_shop` atp_shop
ON atp_shop.id_menu = atp.id_menu
AND atp_shop.id_shop IN (8) 
LEFT JOIN `ps_pm_advancedtopmenu_lang` atpl ON (atp.`id_menu` = atpl.`id_menu` AND atpl.`id_lang` = 4)
LEFT JOIN ps_cms c ON (c.id_cms = atp.`id_cms`)
LEFT JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 8 AND 1)
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 4)
LEFT JOIN ps_category ca ON (ca.id_category = atp.`id_category`)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 4 AND cal.id_shop = 8 )
LEFT JOIN `ps_manufacturer` m ON (atp.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 8 AND 1)
LEFT JOIN `ps_supplier` s ON (atp.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 8 AND 1)
WHERE atp.`active` = 1 AND (atp.`active_desktop` = 1 || atp.`active_mobile` = 1)
AND ((atp.`id_manufacturer` = 0 AND atp.`id_supplier` = 0 AND atp.`id_category` = 0 AND atp.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND IF (atp.`id_category` IS NULL OR atp.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atp.`id_menu`
ORDER BY atp.`position`
 908 ms 2201 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:244 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 980) AND (a0.`nright` > 981) AND (a1.`id_lang` = 4)
ORDER BY a0.`nleft` asc
 891 ms 36512 Yes /classes/PrestaShopCollection.php:381 
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, cp.remark,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
cu.`id_customization`, cu.`quantity` AS customization_quantity,
p.`reference` AS reference, p.`ean13`, p.`isbn`,
p.`upc` AS upc, p.`mpn` AS mpn, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `ps_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 18702399
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=8
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 4
WHERE (cp.`id_cart` = 18702399) AND (p.`id_product` IS NOT NULL)
GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization`
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
 774 ms 1 Yes Yes /classes/Cart.php:775 
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, cp.remark,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
cu.`id_customization`, cu.`quantity` AS customization_quantity,
p.`reference` AS reference, p.`ean13`, p.`isbn`,
p.`upc` AS upc, p.`mpn` AS mpn, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `ps_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 18702399
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=8
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 4
WHERE (cp.`id_cart` = 18702399) AND (p.`id_product` IS NOT NULL)
GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization`
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
 764 ms 1 Yes Yes /classes/Cart.php:775 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 4 AND cl.id_shop = 8 
WHERE (c.nleft <= 1390 AND c.nright >= 1391)
ORDER BY c.nleft
 683 ms 1304 Yes /override/classes/Product.php:7950 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 4 AND cl.id_shop = 8 
WHERE (c.nleft <= 1776 AND c.nright >= 1777)
ORDER BY c.nleft
 681 ms 1304 Yes /override/classes/Product.php:7950 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 4)
LEFT JOIN ps_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 8)
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 4)
LEFT JOIN ps_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 4 AND cal.id_shop = 8 )
LEFT JOIN `ps_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 8)
LEFT JOIN `ps_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 8)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 121
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 674 ms 217 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 4 AND cl.id_shop = 8 
WHERE (c.nleft <= 1776 AND c.nright >= 1777)
ORDER BY c.nleft
 669 ms 1304 Yes /override/classes/Product.php:7950 
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps_pm_advancedtopmenu_columns` atmc
LEFT JOIN `ps_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 4)
LEFT JOIN ps_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 8)
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 4)
LEFT JOIN ps_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 4 AND cal.id_shop = 8 )
LEFT JOIN `ps_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 8)
LEFT JOIN `ps_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 8)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 122
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
 644 ms 93 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 4)
LEFT JOIN ps_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 8)
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 4)
LEFT JOIN ps_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 4 AND cal.id_shop = 8 )
LEFT JOIN `ps_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 8)
LEFT JOIN `ps_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 8)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 359
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 8 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 8 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 8 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 605 ms 31 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
SELECT SQL_NO_CACHE c.`id_condition`
FROM `ps_condition` c
LEFT JOIN `ps_condition_badge` cb ON cb.`id_condition` = c.`id_condition`
WHERE (c.`calculation_type` = 'hook') AND (c.`calculation_detail` = 'ActionObjectCartAddAfter') AND (c.`validated` = 0) AND (cb.`id_badge` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,144,150,152,162,174,186,199,204,205,213,214,215,216,217,218,225,226,227,228,229,230,231,232,233,234))
GROUP BY c.`id_condition`
 601 ms 236 Yes /modules/gamification/classes/Condition.php:114 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 600 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 592 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `ps_pm_advancedtopmenu_elements` ate
LEFT JOIN `ps_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 4)
LEFT JOIN ps_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 8)
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 4)
LEFT JOIN ps_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 4 AND cal.id_shop = 8 )
LEFT JOIN `ps_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 8)
LEFT JOIN `ps_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 8)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 360
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 8 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 8 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 8 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
 576 ms 31 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183 
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` = 4 AND cl.id_shop = 8 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 8)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND nleft >= 973 AND nright <= 1008
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
 562 ms 40 Yes /modules/ps_categorytree/ps_categorytree.php:117 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 8)
WHERE pf.id_product = 4690400
ORDER BY f.position ASC
 547 ms 30 Yes /override/classes/Product.php:6008 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
 510 ms 743 /classes/Hook.php:1283 
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 = 8)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 4  AND cl.id_shop = 8 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 1187
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 480 ms 1 Yes Yes /classes/Category.php:919 
SELECT SQL_NO_CACHE name
FROM `ps_feature_lang` fl
LEFT JOIN  `ps_layered_indexable_feature` lif
ON lif.id_feature = fl.id_feature
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 4
 460 ms 299 /modules/ps_facetedsearch/ps_facetedsearch.php:2481 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
 444 ms 743 /classes/Hook.php:1243 
SELECT SQL_NO_CACHE cr.*
FROM ps_cart_rule cr
LEFT JOIN ps_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN ps_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
LEFT JOIN ps_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN ps_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
OR crs.id_shop = 8
)
AND (
cr.`group_restriction` = 0
OR crg.`id_group` = 1
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `ps_cart_product`
WHERE `ps_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 18702399
)
)
AND NOT EXISTS (SELECT 1 FROM ps_cart_cart_rule WHERE cr.id_cart_rule = ps_cart_cart_rule.id_cart_rule
AND id_cart = 18702399)
ORDER BY priority
 438 ms 110 Yes /classes/CartRule.php:1721 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 431 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 427 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE cr.*
FROM ps_cart_rule cr
LEFT JOIN ps_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN ps_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
LEFT JOIN ps_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN ps_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
OR crs.id_shop = 8
)
AND (
cr.`group_restriction` = 0
OR crg.`id_group` = 1
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `ps_cart_product`
WHERE `ps_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 18702399
)
)
AND NOT EXISTS (SELECT 1 FROM ps_cart_cart_rule WHERE cr.id_cart_rule = ps_cart_cart_rule.id_cart_rule
AND id_cart = 18702399)
ORDER BY priority
 413 ms 110 Yes /classes/CartRule.php:1721 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 412 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 410 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 407 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-28 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 8
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 2 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 8
WHERE p.id_product = 9859748
LIMIT 1
 405 ms 1 /classes/ProductAssembler.php:106 
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 = 8)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1187  AND cl.id_shop = 8 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 1187
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 404 ms 1 Yes Yes /classes/Category.php:919 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 402 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 402 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `ps_cart_cart_rule` cd
LEFT JOIN `ps_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `ps_cart_rule_lang` crl ON (
cd.`id_cart_rule` = crl.`id_cart_rule`
AND crl.id_lang = 4
)
WHERE `id_cart` = 18702399
ORDER by cr.priority ASC, cr.gift_product DESC
 399 ms 1 Yes /classes/Cart.php:511 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 398 ms 16 Yes /classes/SpecificPrice.php:588 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 398 ms 16 Yes /classes/SpecificPrice.php:588 
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` = 8
 396 ms 87 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 8, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 8) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-28 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 396 ms 16 Yes /classes/SpecificPrice.php:588 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-04-28 00:00:00" AND date_to <= "2024-04-28 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-04-28 00:00:00" AND date_from <= "2024-04-28 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-04-28 00:00:00" AND date_to > "2024-04-28 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 390 ms 1 /classes/CartRule.php:383 
SELECT SQL_NO_CACHE COUNT(*) FROM  ((SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category = 1187
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 8)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 0) 
GROUP BY cp.id_product)) ps LIMIT 1
 390 ms 2 /modules/ps_facetedsearch/ps_facetedsearch.php:1621 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-28 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 8
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 2 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 8
WHERE p.id_product = 4690400
LIMIT 1
 377 ms 1 /classes/ProductAssembler.php:106 
(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` = 4)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 370 ms 1 /classes/CartRule.php:444 
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` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 8
WHERE (a.`id_product` = 9859748) AND (b.`id_shop` = 8) LIMIT 1
 347 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 18702399 AND cp.`id_product` = 9859748 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 18702399 AND p.`id_product_item` = 9859748 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 328 ms 0 /classes/Cart.php:1444 
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 = 8)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (9859748) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 317 ms 1 Yes Yes /override/classes/Product.php:4521 
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` = 8
 312 ms 87 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 18702399 AND cp.`id_product` = 4690400 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 18702399 AND p.`id_product_item` = 4690400 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 311 ms 0 /classes/Cart.php:1444 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
 309 ms 1 /classes/module/Module.php:2840 
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
 300 ms 22 Yes /classes/shop/Shop.php:711 
(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` = 4)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 293 ms 1 /classes/CartRule.php:444 
SELECT SQL_NO_CACHE id_advice
FROM `ps_advice` a
 292 ms 590 /modules/gamification/classes/Condition.php:124 
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 = 8)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4690400) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 285 ms 1 Yes Yes /override/classes/Product.php:4521 
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 = 8 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 280 ms 86 Yes /classes/Dispatcher.php:650 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-04-28 00:00:00" AND date_to <= "2024-04-28 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-04-28 00:00:00" AND date_from <= "2024-04-28 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-04-28 00:00:00" AND date_to > "2024-04-28 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 269 ms 1 /classes/CartRule.php:383 
(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` = 4)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 263 ms 1 /classes/CartRule.php:444 
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` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 8
WHERE (a.`id_product` = 4690400) AND (b.`id_shop` = 8) LIMIT 1
 259 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.medioeurope.com' OR su.domain_ssl = 'www.medioeurope.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 258 ms 10 Yes /classes/shop/Shop.php:1350 
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` = 3
AND tr.`id_tax_rules_group` = 5
AND tr.`id_state` IN (0, 0)
AND ('3190' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '3190')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 248 ms 1 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 243 ms 1 /classes/Cart.php:4233 
SELECT SQL_NO_CACHE * FROM `ps_fsch_block` c LEFT JOIN `ps_fsch_block_lang` l ON (c.`id_fsch_block` = l.`id_fsch_block`) INNER JOIN `ps_fsch_block_shop` s ON (s.`id_fsch_block` = c.`id_fsch_block` AND s.`id_shop` = 8) WHERE l.`id_lang` = '4' AND c.`hook` = 'displayNotificationError' AND c.`active` = '1' ORDER BY c.`hook`, c.`position` ASC
 240 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php:277 
(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` = 4)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 236 ms 1 /classes/CartRule.php:444 
SELECT SQL_NO_CACHE * FROM `ps_fsch_block` c LEFT JOIN `ps_fsch_block_lang` l ON (c.`id_fsch_block` = l.`id_fsch_block`) INNER JOIN `ps_fsch_block_shop` s ON (s.`id_fsch_block` = c.`id_fsch_block` AND s.`id_shop` = 8) WHERE l.`id_lang` = '4' AND c.`hook` = 'displayFooter' AND c.`active` = '1' ORDER BY c.`hook`, c.`position` ASC
 236 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php:277 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 9859748 and id_category in (160, 618, 842, 846) LIMIT 1
 229 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 8)
WHERE i.`id_product` = 9859748
AND image_shop.`cover` = 1 LIMIT 1
 229 ms 1 /override/classes/Product.php:3568 
SELECT SQL_NO_CACHE public_name
FROM `ps_attribute_group_lang` agl
LEFT JOIN `ps_layered_indexable_attribute_group` liag
ON liag.id_attribute_group = agl.id_attribute_group
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 4
 227 ms 16 /modules/ps_facetedsearch/ps_facetedsearch.php:2471 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 9859748 and id_category in (160, 618, 842, 846) LIMIT 1
 218 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE * FROM `ps_fsch_block` c LEFT JOIN `ps_fsch_block_lang` l ON (c.`id_fsch_block` = l.`id_fsch_block`) INNER JOIN `ps_fsch_block_shop` s ON (s.`id_fsch_block` = c.`id_fsch_block` AND s.`id_shop` = 8) WHERE l.`id_lang` = '4' AND c.`hook` = 'displayBeforeBodyClosingTag' AND c.`active` = '1' ORDER BY c.`hook`, c.`position` ASC
 216 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php:277 
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 = 8)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 4)
WHERE i.`id_product` = 4690400
ORDER BY `position`
 215 ms 1 Yes /override/classes/Product.php:3543 
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` = 3
AND tr.`id_tax_rules_group` = 5
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
 213 ms 1 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 4690400 and id_category in (160, 618, 842, 846) LIMIT 1
 212 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE * FROM `ps_fsch_block` c LEFT JOIN `ps_fsch_block_lang` l ON (c.`id_fsch_block` = l.`id_fsch_block`) INNER JOIN `ps_fsch_block_shop` s ON (s.`id_fsch_block` = c.`id_fsch_block` AND s.`id_shop` = 8) WHERE l.`id_lang` = '4' AND c.`hook` = 'displayNotificationInfo' AND c.`active` = '1' ORDER BY c.`hook`, c.`position` ASC
 207 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php:277 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 4)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 97
ORDER BY atmcw.`position`
 204 ms 2 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
 200 ms 4 /classes/SpecificPrice.php:287 
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 8
WHERE (a.`id_category` = 1187) AND (b.`id_shop` = 8) LIMIT 1
 197 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE * FROM `ps_fsch_block` c LEFT JOIN `ps_fsch_block_lang` l ON (c.`id_fsch_block` = l.`id_fsch_block`) INNER JOIN `ps_fsch_block_shop` s ON (s.`id_fsch_block` = c.`id_fsch_block` AND s.`id_shop` = 8) WHERE l.`id_lang` = '4' AND c.`hook` = 'displayNotificationWarning' AND c.`active` = '1' ORDER BY c.`hook`, c.`position` ASC
 196 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php:277 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 8)
WHERE i.`id_product` = 4690400
AND image_shop.`cover` = 1 LIMIT 1
 194 ms 1 /override/classes/Product.php:3568 
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` = 3
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('3190' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '3190')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 194 ms 0 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE * FROM `ps_fsch_block` c LEFT JOIN `ps_fsch_block_lang` l ON (c.`id_fsch_block` = l.`id_fsch_block`) INNER JOIN `ps_fsch_block_shop` s ON (s.`id_fsch_block` = c.`id_fsch_block` AND s.`id_shop` = 8) WHERE l.`id_lang` = '4' AND c.`hook` = 'displayNotificationSuccess' AND c.`active` = '1' ORDER BY c.`hook`, c.`position` ASC
 193 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php:277 
SELECT SQL_NO_CACHE * FROM `ps_fsch_block` c LEFT JOIN `ps_fsch_block_lang` l ON (c.`id_fsch_block` = l.`id_fsch_block`) INNER JOIN `ps_fsch_block_shop` s ON (s.`id_fsch_block` = c.`id_fsch_block` AND s.`id_shop` = 8) WHERE l.`id_lang` = '4' AND c.`hook` = 'displayHeader' AND c.`active` = '1' ORDER BY c.`hook`, c.`position` ASC
 193 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php:277 
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `ps_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `ps_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 4)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 68
ORDER BY atmcw.`position`
 190 ms 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129 
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)
 190 ms 25 /classes/Language.php:1049 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 8
WHERE (a.`id_category` = 1187) AND (b.`id_shop` = 8) LIMIT 1
 181 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 8
WHERE (a.`id_cms` = 41) AND (b.`id_shop` = 8) LIMIT 1
 180 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE distinct id_category from ps_category_lang where id_lang = 4 and name = 'Boeken'
 179 ms 55 /bootstrap.php:50 
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 = 8)
WHERE l.`active` = 1 LIMIT 1
 178 ms 4 /classes/Language.php:1198 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 18496265
AND `date_add` > '2024-04-28 06:55:00'
AND id_shop_group = 2 
ORDER BY `date_add` DESC LIMIT 1
 173 ms 1 Yes /classes/Connection.php:154 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 9859748 and id_category in (160, 618, 842, 846) LIMIT 1
 172 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE id_badge
FROM `ps_badge` b
WHERE (b.`validated` = 0)
 169 ms 234 /modules/gamification/classes/Condition.php:96 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=18702399 LIMIT 1
 168 ms 1 /classes/Cart.php:4233 
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 8
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 8) LIMIT 1
 167 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
 167 ms 1316 /classes/SpecificPrice.php:411 
SELECT SQL_NO_CACHE distinct id_category from ps_category_lang where id_lang = 4 and name = 'Boeken'
 165 ms 55 /override/classes/Product.php:6024 
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 8
WHERE (a.`id_category` = 1466) AND (b.`id_shop` = 8) LIMIT 1
 165 ms 1 /src/Adapter/EntityMapper.php:76 
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 = 8)
WHERE c.`active` = 1 LIMIT 1
 164 ms 1 /classes/Currency.php:1126 
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` = 4
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 8
WHERE (a.`id_country` = 3) LIMIT 1
 164 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 8)
WHERE (p.`id_product` = 9859748)
 164 ms 1 /override/classes/Product.php:3859 
SELECT SQL_NO_CACHE * FROM ps_layered_category
WHERE id_shop = 8
GROUP BY `type`, id_value ORDER BY position ASC
 164 ms 9 Yes Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1783 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 4
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 8
WHERE (a.`id_currency` = 1) LIMIT 1
 164 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE distinct id_category from ps_category_lang where id_lang = 4 and name = 'Boeken'
 163 ms 55 /solr.php:106 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 345) LIMIT 1
 160 ms 1 /classes/Category.php:1957 
SELECT SQL_NO_CACHE * FROM `ps_fsch_filter` WHERE `id_content` = 34 AND `content_type` = 'fsch_block' ORDER BY id_filter_group, id_filter ASC
 157 ms 1 Yes /modules/fscustomhtml/classes/FsCustomHtmlFilterModel.php:168 
SELECT SQL_NO_CACHE domain
FROM `ps_shop_url`
WHERE (main = 1) AND (active = 1)
AND id_shop IN (8, 12, 9, 10, 13, 11, 5, 17, 6, 7)
 155 ms 10 /classes/shop/Shop.php:801 
SELECT SQL_NO_CACHE distinct id_category from ps_category_lang where id_lang = 4 and name = 'Boeken'
 155 ms 55 /override/classes/Product.php:6024 
SELECT SQL_NO_CACHE distinct id_category from ps_category_lang where id_lang = 4 and name = 'Boeken'
 155 ms 55 /solr.php:106 
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` = 8
WHERE (a.`id_category` = 1187) LIMIT 1
 155 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 4690400 and id_category in (160, 618, 842, 846) LIMIT 1
 152 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 9859748 and id_category in (160, 618, 842, 846) LIMIT 1
 152 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 4 AND `id_object` = 1187 LIMIT 1
 149 ms 1 /classes/Page.php:83 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 148 ms 2 /classes/shop/Shop.php:1171 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 9859748 and id_category in (160, 618, 842, 846) LIMIT 1
 148 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 9859748 and id_category in (160, 618, 842, 846) LIMIT 1
 147 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-04-28 00:00:00' AND '2024-04-28 23:59:59' LIMIT 1
 147 ms 1 /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 4690400 and id_category in (160, 618, 842, 846) LIMIT 1
 146 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 146 ms 7 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 4690400 and id_category in (160, 618, 842, 846) LIMIT 1
 146 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 4690400 and id_category in (160, 618, 842, 846) LIMIT 1
 145 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE id_category from ps_category_product where id_product = 4690400 and id_category in (160, 618, 842, 846) LIMIT 1
 145 ms 4 /classes/SpecificPrice.php:534 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 145 ms 1 /classes/Link.php:181 
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 = 8
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 144 ms 1 /classes/shop/Shop.php:205 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 141 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
 141 ms 88 /classes/Hook.php:353 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 8 
AND cl.`id_category` = 345 LIMIT 1
 140 ms 1 /classes/Category.php:1371 
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` = 8
WHERE (a.`id_lang` = 4) LIMIT 1
 140 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 3
 139 ms 5 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 138 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE `id_order` 
FROM `ps_orders`
WHERE `id_cart` = 18702399 AND id_shop IN (8) LIMIT 1
 136 ms 1 /override/classes/order/Order.php:1385 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 1187 AND `id_shop` = 8
 136 ms 5 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
 135 ms 1 Yes /classes/Currency.php:709 
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` = 8
WHERE (a.`id_currency` = 1) LIMIT 1
 135 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 135 ms 1 /classes/Link.php:181 
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` = 8
WHERE (a.`id_group` = 1) LIMIT 1
 135 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
 134 ms 88 /classes/Hook.php:301 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 1187 AND ctg.`id_group` = 1 LIMIT 1
 134 ms 1 /classes/Category.php:1730 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2024-04-28 00:00:00' AND '2024-04-28 23:59:59' LIMIT 1
 132 ms 1 /classes/SpecificPrice.php:366 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 8 LIMIT 1
 132 ms 1 /classes/shop/ShopUrl.php:182 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 9859748 AND id_shop=8 LIMIT 1
 132 ms 1 /override/classes/Product.php:6941 
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` = 8
WHERE (a.`id_country` = 3) LIMIT 1
 129 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 4 LIMIT 1
 129 ms 1 /modules/lgcookieslaw/lgcookieslaw.php:229 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 8)
WHERE (p.`id_product` = 4690400)
 126 ms 1 /override/classes/Product.php:3859 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 8 AND id_lang = 4 AND id_category = 345 LIMIT 1
 124 ms 1 /override/classes/Product.php:5659 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 3 LIMIT 1
 123 ms 1 /classes/AddressFormat.php:672 
SELECT SQL_NO_CACHE `id_order` 
FROM `ps_orders`
WHERE `id_cart` = 18702399 AND id_shop IN (8) LIMIT 1
 122 ms 1 /override/classes/order/Order.php:1385 
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
 121 ms 1 /classes/Page.php:104 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 120 ms 1 /classes/Link.php:181 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9859748) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
 119 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 9859748
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 118 ms 0 /classes/SpecificPrice.php:250 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
 118 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 14 LIMIT 1
 117 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 116 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 116 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4690400) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
 116 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
 115 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 4690400 LIMIT 1
 114 ms 1 /classes/Pack.php:89 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 2) LIMIT 1
 113 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 8) LIMIT 1
 113 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 113 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 9859748 LIMIT 1
 113 ms 1 /classes/Pack.php:89 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 112 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 112 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 112 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facetedsearch" LIMIT 1
 112 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
 112 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 112 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
 112 ms 3 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_socialfollow" LIMIT 1
 111 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 3 LIMIT 1
 110 ms 1 /classes/Country.php:274 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 109 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 109 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 109 ms 1 /classes/Link.php:181 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'nl-nl'
OR `language_code` = 'nl-nl' LIMIT 1
 108 ms 5 /classes/Language.php:853 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 3
 108 ms 4 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 9859748 LIMIT 1
 108 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
 108 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 108 ms 5 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `name` FROM `ps_hook_alias` WHERE `alias` = 'ActionObjectCartAddAfter' LIMIT 1
 107 ms 0 /modules/gamification/gamification.php:189 
SELECT SQL_NO_CACHE id_shop from ps_product_shop where id_product = 4690400 LIMIT 1
 107 ms 1 /override/classes/Product.php:3710 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "fscustomhtml" LIMIT 1
 106 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 8 
AND cl.`id_category` = 298 LIMIT 1
 106 ms 1 /classes/Category.php:1371 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'nl-nl'
OR `language_code` = 'nl-nl' LIMIT 1
 105 ms 5 /classes/Language.php:853 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 8 
AND cl.`id_category` = 386 LIMIT 1
 104 ms 1 /classes/Category.php:1371 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 3) LIMIT 1
 104 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 104 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 104 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE * FROM ps_cart_cart_rule WHERE id_cart = 18702399
 103 ms 1 /classes/Cart.php:3040 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 386) LIMIT 1
 103 ms 1 /classes/Category.php:1957 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 9859748 AND `id_group` = 1 LIMIT 1
 101 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (8)
 101 ms 14 /classes/module/Module.php:2237 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 100 ms 1 /classes/ObjectModel.php:1510 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 12 AND `id_shop` = 8 LIMIT 1
 99 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customersignin" LIMIT 1
 99 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 8 LIMIT 1
 98 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'nl' LIMIT 1
 97 ms 5 /classes/Language.php:824 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 4
AND id_shop = 8 LIMIT 1
 95 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4690400 AND id_shop=8 LIMIT 1
 95 ms 1 /override/classes/Product.php:6941 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 101 AND `id_shop` = 8 LIMIT 1
 94 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 8 LIMIT 1
 93 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 8 AND id_lang = 4 AND id_category = 386 LIMIT 1
 93 ms 1 /override/classes/Product.php:5659 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 10 AND `id_shop` = 8 LIMIT 1
 92 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE count(*) from px_hidden h join ps_product p on p.id_product = h.id_product join ps_customer c on c.id_customer = h.id_customer where h.id_customer =  and h.id_product = 9859748 LIMIT 1
 92 ms 1 /override/classes/Product.php:5686 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 24 AND `id_shop` = 8 LIMIT 1
 91 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 18 AND `id_shop` = 8 LIMIT 1
 91 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 3 LIMIT 1
 91 ms 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 13 AND `id_shop` = 8 LIMIT 1
 90 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1
 90 ms 11 /classes/shop/Shop.php:1172 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 27 AND `id_shop` = 8 LIMIT 1
 90 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 84 AND `id_shop` = 8 LIMIT 1
 90 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 14 AND `id_shop` = 8 LIMIT 1
 90 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
 90 ms 1 /classes/Currency.php:893 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4690400
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 89 ms 0 /classes/SpecificPrice.php:250 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 15 AND `id_shop` = 8 LIMIT 1
 89 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 26 AND `id_shop` = 8 LIMIT 1
 89 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 8 LIMIT 1
 86 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
 85 ms 1 /classes/Group.php:154 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 3 LIMIT 1
 84 ms 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 4 LIMIT 1
 84 ms 1 /modules/lgcookieslaw/lgcookieslaw.php:229 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4690400 AND `id_group` = 1 LIMIT 1
 84 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 4 LIMIT 1
 80 ms 1 /modules/lgcookieslaw/lgcookieslaw.php:229 
SELECT SQL_NO_CACHE count(*) from px_hidden h join ps_product p on p.id_product = h.id_product join ps_customer c on c.id_customer = h.id_customer where h.id_customer =  and h.id_product = 4690400 LIMIT 1
 65 ms 1 /override/classes/Product.php:5686

Doubles

16 queries 
select id_shop from ps_product_shop where id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
12 queries 
select id_category from ps_category_product where id_product = <span style="color:blue">XX</span> and id_category in (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
12 queries 
			SELECT *, ( IF (`id_group` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) +  IF (`id_country` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) +  IF (`id_currency` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) +  IF (`id_shop` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) +  IF (`id_customer` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>)) AS `score`
				FROM `ps_specific_price`
				WHERE
                
                `id_shop` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND
                `id_currency` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND
                `id_country` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND
                `id_group` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_product` = <span style="color:blue">XX</span> AND `id_customer` = <span style="color:blue">XX</span> AND `id_product_attribute` = <span style="color:blue">XX</span> AND `id_cart` = <span style="color:blue">XX</span>  AND (`from` = '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' OR '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' >= `from`) AND (`to` = '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' OR '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' <= `to`)
				AND IF(`from_quantity` > <span style="color:blue">XX</span>, `from_quantity`, <span style="color:blue">XX</span>) <= <span style="color:blue">XX</span> ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT <span style="color:blue">XX</span>
12 queries 
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
5 queries 
select distinct id_category from ps_category_lang where id_lang = <span style="color:blue">XX</span> and name = 'Boeken'
4 queries 
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = <span style="color:blue">XX</span>
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = <span style="color:blue">XX</span>
WHERE (a.`id_category` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
4 queries 
SELECT *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = <span style="color:blue">XX</span> AND cl.id_shop = <span style="color:blue">XX</span> 
WHERE (c.nleft <= <span style="color:blue">XX</span> AND c.nright >= <span style="color:blue">XX</span>)
ORDER BY c.nleft
3 queries 
				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` = <span style="color:blue">XX</span>
				AND tr.`id_country` = <span style="color:blue">XX</span>
				AND tr.`id_tax_rules_group` = <span style="color:blue">XX</span>
				AND tr.`id_state` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>)
				AND ('<span style="color:blue">XX</span>' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = <span style="color:blue">XX</span> AND tr.`zipcode_from` IN(<span style="color:blue">XX</span>, '<span style="color:blue">XX</span>')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries 
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = <span style="color:blue">XX</span>
			 AND cl.id_shop = <span style="color:blue">XX</span> 
			AND cl.`id_category` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, cp.remark,
                        pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
                        p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
                        product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
                        stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
                        p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, <span style="color:blue">XX</span>) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
                        CONCAT(LPAD(cp.`id_product`, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>), LPAD(IFNULL(cp.`id_product_attribute`, <span style="color:blue">XX</span>), <span style="color:blue">XX</span>, <span style="color:blue">XX</span>), IFNULL(cp.`id_address_delivery`, <span style="color:blue">XX</span>), IFNULL(cp.`id_customization`, <span style="color:blue">XX</span>)) AS unique_id, cp.id_address_delivery,
                        product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
cu.`id_customization`, cu.`quantity` AS customization_quantity,
p.`reference` AS reference, p.`ean<span style="color:blue">XX</span>`, p.`isbn`,
                p.`upc` AS upc, p.`mpn` AS mpn, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product`
            AND pl.`id_lang` = <span style="color:blue">XX</span> AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category`
            AND cl.`id_lang` = <span style="color:blue">XX</span> AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
 LEFT JOIN ps_stock_available stock
            ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = <span style="color:blue">XX</span> AND stock.id_shop_group = <span style="color:blue">XX</span>  AND stock.id_shop = <span style="color:blue">XX</span>  )
LEFT JOIN `ps_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = <span style="color:blue">XX</span>
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=<span style="color:blue">XX</span> AND image_shop.id_shop=<span style="color:blue">XX</span>
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = <span style="color:blue">XX</span>
WHERE (cp.`id_cart` = <span style="color:blue">XX</span>) AND (p.`id_product` IS NOT NULL)
GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization`
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
2 queries 
SELECT `id_order` 
            FROM `ps_orders`
            WHERE `id_cart` = <span style="color:blue">XX</span> AND id_shop IN (<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
(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` = <span style="color:blue">XX</span>)
            WHERE (cr.`id_customer` = <span style="color:blue">XX</span>
            OR (cr.`id_customer` = <span style="color:blue">XX</span> AND (cr.`highlight` = <span style="color:blue">XX</span> OR cr.`code` = "")))
             AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = <span style="color:blue">XX</span>
				 AND free_shipping = <span style="color:blue">XX</span> AND carrier_restriction = <span style="color:blue">XX</span>)
2 queries 
(SELECT <span style="color:blue">XX</span> FROM `ps_cart_rule` WHERE date_to >= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND date_to <= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND `id_customer` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>)UNION ALL (SELECT <span style="color:blue">XX</span> FROM `ps_cart_rule` WHERE date_from >= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND date_from <= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND `id_customer` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>)UNION ALL (SELECT <span style="color:blue">XX</span> FROM `ps_cart_rule` WHERE date_from < "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND date_to > "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND `id_customer` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
(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` = <span style="color:blue">XX</span>)
            WHERE (cr.`id_customer` = <span style="color:blue">XX</span>
            OR (cr.`id_customer` = <span style="color:blue">XX</span> AND (cr.`highlight` = <span style="color:blue">XX</span> OR cr.`code` = "")))
             AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = <span style="color:blue">XX</span>
				AND cr.`quantity` > <span style="color:blue">XX</span> AND highlight = <span style="color:blue">XX</span> AND code NOT LIKE "BO_ORDER_%")
2 queries 
                SELECT name, value, pf.id_feature, f.position
                FROM ps_feature_product pf
                LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>)
                LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = <span style="color:blue">XX</span>)
                LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>)
                 INNER JOIN ps_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = <span style="color:blue">XX</span>)
                WHERE pf.id_product = <span style="color:blue">XX</span>
                ORDER BY f.position ASC
2 queries 
SELECT <span style="color:blue">XX</span> FROM ps_cart_product cp INNER JOIN ps_product p
                ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
                ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=<span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT image_shop.`id_image`
                    FROM `ps_image` i
                     INNER JOIN ps_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = <span style="color:blue">XX</span>)
                    WHERE i.`id_product` = <span style="color:blue">XX</span>
                    AND image_shop.`cover` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), <span style="color:blue">XX</span>) as deep_quantity,
            COALESCE(SUM(first_level_quantity), <span style="color:blue">XX</span>) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, <span style="color:blue">XX</span> as pack_quantity
          FROM `ps_cart_product` cp
            WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND cp.`id_product` = <span style="color:blue">XX</span> UNION SELECT <span style="color:blue">XX</span> as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
          FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
            WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND p.`id_product_item` = <span style="color:blue">XX</span> AND (pr.`pack_stock_type` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) OR (
            pr.`pack_stock_type` = <span style="color:blue">XX</span>
            AND <span style="color:blue">XX</span> = <span style="color:blue">XX</span>
        ))) as q LIMIT <span style="color:blue">XX</span>
2 queries 
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = <span style="color:blue">XX</span> AND `id_group` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = <span style="color:blue">XX</span>) AND (id_product_attribute = <span style="color:blue">XX</span>) AND (id_shop_group = <span style="color:blue">XX</span>) AND (id_shop = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
			SELECT `need_identification_number`
			FROM `ps_country`
			WHERE `id_country` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
            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 = <span style="color:blue">XX</span>)
            LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = <span style="color:blue">XX</span>)
            WHERE i.`id_product` = <span style="color:blue">XX</span>
            ORDER BY `position`
2 queries 
SELECT button<span style="color:blue">XX</span> FROM ps_lgcookieslaw_lang WHERE id_lang = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
                            SELECT `id_tax_rules_group`
                            FROM `ps_product_shop`
                            WHERE `id_product` = <span style="color:blue">XX</span> AND id_shop=<span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT product_shop.`price`, product_shop.`ecotax`,
<span style="color:blue">XX</span> as id_product_attribute
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = <span style="color:blue">XX</span>)
WHERE (p.`id_product` = <span style="color:blue">XX</span>)
2 queries 
				SELECT `priority`, `id_specific_price_priority`
				FROM `ps_specific_price_priority`
				WHERE `id_product` = <span style="color:blue">XX</span>
				ORDER BY `id_specific_price_priority` DESC LIMIT <span style="color:blue">XX</span>
2 queries 
select count(*) from px_hidden h join ps_product p on p.id_product = h.id_product join ps_customer c on c.id_customer = h.id_customer where h.id_customer =  and h.id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = <span style="color:blue">XX</span>
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = <span style="color:blue">XX</span>
WHERE (a.`id_product` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT name FROM ps_category_lang WHERE id_shop = <span style="color:blue">XX</span> AND id_lang = <span style="color:blue">XX</span> AND id_category = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT
                    p.*,
                    ps.*,
                    pl.*,
                    sa.out_of_stock,
                    IFNULL(sa.quantity, <span style="color:blue">XX</span>) as quantity,
                    (DATEDIFF(
                        p.`date_add`,
                        DATE_SUB(
                            '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>',
                            INTERVAL <span style="color:blue">XX</span> DAY
                        )
                    ) > <span style="color:blue">XX</span>) as new
                FROM ps_product p
                LEFT JOIN ps_product_lang pl
                    ON pl.id_product = p.id_product
                    AND pl.id_shop = <span style="color:blue">XX</span>
                    AND pl.id_lang = <span style="color:blue">XX</span>
                LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
			        AND sa.id_shop = <span style="color:blue">XX</span>
			        AND sa.id_shop_group = <span style="color:blue">XX</span> LEFT JOIN ps_product_shop ps
			        ON ps.id_product = p.id_product
			        AND ps.id_shop = <span style="color:blue">XX</span>
			    WHERE p.id_product = <span style="color:blue">XX</span>
			    LIMIT <span style="color:blue">XX</span>
2 queries 
		SELECT 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 = <span style="color:blue">XX</span>)
		LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = <span style="color:blue">XX</span>  AND cl.id_shop = <span style="color:blue">XX</span> )
		LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
		WHERE `id_parent` = <span style="color:blue">XX</span>
		AND `active` = <span style="color:blue">XX</span>
		AND cg.`id_group` =<span style="color:blue">XX</span>
		GROUP BY c.`id_category`
		ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 queries 
SELECT `id_lang` FROM `ps_lang`
                    WHERE `locale` = 'nl-nl'
                    OR `language_code` = 'nl-nl' LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT ate.*, atel.*,
        cl.link_rewrite, cl.meta_title,
        cal.link_rewrite as category_link_rewrite, cal.name as category_name,
        m.name as manufacturer_name,
        s.name as supplier_name
        FROM `ps_pm_advancedtopmenu_elements` ate
                LEFT JOIN `ps_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = <span style="color:blue">XX</span>)
                LEFT JOIN ps_cms c ON (c.id_cms = ate.`id_cms`)
                 LEFT JOIN ps_cms_shop cms_shop
        ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = <span style="color:blue">XX</span>)
                LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = <span style="color:blue">XX</span>)
                LEFT JOIN ps_category ca ON (ca.id_category = ate.`id_category`)
                LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)
                LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = <span style="color:blue">XX</span> AND cal.id_shop = <span style="color:blue">XX</span> )
                LEFT JOIN `ps_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
                 LEFT JOIN ps_manufacturer_shop manufacturer_shop
        ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = <span style="color:blue">XX</span>)
                LEFT JOIN `ps_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
                 LEFT JOIN ps_supplier_shop supplier_shop
        ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = <span style="color:blue">XX</span>)
                WHERE  ate.`active` = <span style="color:blue">XX</span> AND (ate.`active_desktop` = <span style="color:blue">XX</span> || ate.`active_mobile` = <span style="color:blue">XX</span>) AND ate.`id_column` = <span style="color:blue">XX</span>
                AND ((ate.`id_manufacturer` = <span style="color:blue">XX</span> AND ate.`id_supplier` = <span style="color:blue">XX</span> AND ate.`id_category` = <span style="color:blue">XX</span> AND ate.`id_cms` = <span style="color:blue">XX</span>)
                OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
                AND (cms_shop.`id_shop` = <span style="color:blue">XX</span> OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = <span style="color:blue">XX</span> OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = <span style="color:blue">XX</span> OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, cg.`id_group` IN (<span style="color:blue">XX</span>))
                GROUP BY ate.`id_element`
                ORDER BY ate.`position`
2 queries 
		SELECT SQL_NO_CACHE cr.*
		FROM ps_cart_rule cr
		LEFT JOIN ps_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
		 LEFT JOIN ps_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
		LEFT JOIN ps_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
		
		LEFT JOIN ps_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
		WHERE cr.active = <span style="color:blue">XX</span>
		AND cr.code = ""
		AND cr.quantity > <span style="color:blue">XX</span>
		AND NOW() BETWEEN cr.date_from AND cr.date_to
		AND (
			cr.id_customer = <span style="color:blue">XX</span>
			
		)
		AND (
			cr.`carrier_restriction` = <span style="color:blue">XX</span>
			
		)
		AND (
			cr.`shop_restriction` = <span style="color:blue">XX</span>
			OR crs.id_shop = <span style="color:blue">XX</span>
		)
		AND (
			cr.`group_restriction` = <span style="color:blue">XX</span>
			OR crg.`id_group` = <span style="color:blue">XX</span>
		)
		AND (
			cr.`reduction_product` <= <span style="color:blue">XX</span>
			OR EXISTS (
				SELECT <span style="color:blue">XX</span>
				FROM `ps_cart_product`
				WHERE `ps_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = <span style="color:blue">XX</span>
			)
		)
		AND NOT EXISTS (SELECT <span style="color:blue">XX</span> FROM ps_cart_cart_rule WHERE cr.id_cart_rule = ps_cart_cart_rule.id_cart_rule
																			AND id_cart = <span style="color:blue">XX</span>)
		ORDER BY priority
2 queries 
                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` = <span style="color:blue">XX</span>
2 queries 
            SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, <span style="color:blue">XX</span> 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 = <span style="color:blue">XX</span>)
            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` = <span style="color:blue">XX</span>)
            JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (<span style="color:blue">XX</span>) AND ag.`is_color_group` = <span style="color:blue">XX</span>
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
2 queries 
SELECT atmcw.*, atmcwl.*
                FROM `ps_pm_advancedtopmenu_columns_wrap` atmcw
                LEFT JOIN `ps_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = <span style="color:blue">XX</span>)
                WHERE  atmcw.`active` = <span style="color:blue">XX</span> AND (atmcw.`active_desktop` = <span style="color:blue">XX</span> || atmcw.`active_mobile` = <span style="color:blue">XX</span>) AND atmcw.`id_menu` = <span style="color:blue">XX</span>
                ORDER BY atmcw.`position`
2 queries 
SELECT atmc.*, atmcl.*,
                cl.link_rewrite, cl.meta_title,
                cal.link_rewrite as category_link_rewrite, cal.name as category_name,
                m.name as manufacturer_name,
                s.name as supplier_name
                FROM `ps_pm_advancedtopmenu_columns` atmc
                LEFT JOIN `ps_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = <span style="color:blue">XX</span>)
                LEFT JOIN ps_cms c ON (c.id_cms = atmc.`id_cms`)
                 LEFT JOIN ps_cms_shop cms_shop
        ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = <span style="color:blue">XX</span>)
                LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = <span style="color:blue">XX</span>)
                LEFT JOIN ps_category ca ON (ca.id_category = atmc.`id_category`)
                LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)
                LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = <span style="color:blue">XX</span> AND cal.id_shop = <span style="color:blue">XX</span> )
                LEFT JOIN `ps_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
                 LEFT JOIN ps_manufacturer_shop manufacturer_shop
        ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = <span style="color:blue">XX</span>)
                LEFT JOIN `ps_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
                 LEFT JOIN ps_supplier_shop supplier_shop
        ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = <span style="color:blue">XX</span>)
                WHERE  atmc.`active` = <span style="color:blue">XX</span> AND (atmc.`active_desktop` = <span style="color:blue">XX</span> || atmc.`active_mobile` = <span style="color:blue">XX</span>) AND  atmc.`id_wrap` = <span style="color:blue">XX</span>
                AND ((atmc.`id_manufacturer` = <span style="color:blue">XX</span> AND atmc.`id_supplier` = <span style="color:blue">XX</span> AND atmc.`id_category` = <span style="color:blue">XX</span> AND atmc.`id_cms` = <span style="color:blue">XX</span>)
                OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, cg.`id_group` IN (<span style="color:blue">XX</span>))
                GROUP BY atmc.`id_column`
                ORDER BY atmc.`position`

Tables stress

31 category_lang
31 product_shop
21 category
17 product
16 specific_price
16 module
16 module_shop
13 category_product
13 cart_rule
11 cart_product
9 category_group
8 stock_available
8 category_shop
8 manufacturer
8 image_shop
8 product_lang
7 hook
7 fsch_block
7 fsch_block_shop
7 fsch_block_lang
6 cms
6 cms_lang
6 lang
6 cms_shop
5 cart_rule_lang
5 shop
5 shop_url
5 image
5 country
5 supplier_shop
5 supplier
5 manufacturer_shop
5 currency
5 image_lang
4 hook_alias
4 currency_shop
4 cart_cart_rule
4 lang_shop
4 pack
3 product_supplier
3 feature_product
3 tax_rules_group
3 tax_rule
3 customization
3 feature_lang
3 lgcookieslaw_lang
2 shop_group
2 product_group_reduction_cache
2 pm_advancedtopmenu_columns_wrap_lang
2 orders
2 feature_value_lang
2 feature
2 feature_shop
2 pm_advancedtopmenu_columns_wrap
2 configuration
2 pm_advancedtopmenu_columns_lang
2 hook_module
2 country_shop
2 country_lang
2 cart_rule_shop
2 cart_rule_group
2 cart_rule_carrier
2 cart_rule_country
2 pm_advancedtopmenu_columns
2 pm_advancedtopmenu_elements
2 product_attribute_combination
2 condition
2 specific_price_priority
2 group
2 customer
2 group_shop
2 pm_advancedtopmenu_elements_lang
2 product_attribute
2 product_attribute_shop
2 currency_lang
2 attribute
2 attribute_lang
2 attribute_group
1 page_type
1 configuration_lang
1 connections
1 fsch_filter
1 condition_advice
1 module_group
1 pm_advancedtopmenu_lang
1 address_format
1 condition_badge
1 layered_category
1 attribute_group_lang
1 layered_indexable_attribute_group
1 badge
1 layered_indexable_feature
1 required_field
1 image_type
1 pm_advancedtopmenu_shop
1 group_lang
1 hook_module_exceptions
1 tax
1 tax_lang
1 meta_lang
1 meta
1 advice
1 pm_advancedtopmenu
1 page

ObjectModel instances

Name Instances Source
Language 16 /config/config.inc.php [222]
/classes/Tools.php [658]
/classes/Tools.php [581]
/classes/Cart.php [704]
/classes/Cart.php [711]
/classes/Cart.php [767]
/classes/Cart.php [800]
/classes/Cart.php [505]
/classes/Cart.php [704]
/classes/Cart.php [711]
/classes/Cart.php [767]
/classes/Cart.php [800]
/classes/Cart.php [704]
/classes/Cart.php [711]
/classes/Cart.php [767]
/classes/Cart.php [800]
Category 14 /controllers/front/listing/CategoryController.php [89]
/classes/Meta.php [380]
/classes/Link.php [421]
/classes/Link.php [421]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/modules/ps_facetedsearch/ps_facetedsearch.php [1769]
/modules/ps_facetedsearch/ps_facetedsearch.php [1401]
/modules/ps_categorytree/ps_categorytree.php [288]
/modules/ps_categorytree/ps_categorytree.php [291]
/modules/ps_categorytree/ps_categorytree.php [295]
FsCustomHtmlBlockFilterModel 7 /modules/fscustomhtml/fscustomhtml.php [1368]
/modules/fscustomhtml/fscustomhtml.php [1368]
/modules/fscustomhtml/fscustomhtml.php [1368]
/modules/fscustomhtml/fscustomhtml.php [1368]
/modules/fscustomhtml/fscustomhtml.php [1368]
/modules/fscustomhtml/fscustomhtml.php [1368]
/modules/fscustomhtml/fscustomhtml.php [1368]
Product 6 /classes/Link.php [114]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [67]
/src/Adapter/Image/ImageRetriever.php [67]
/classes/Link.php [114]
/classes/Link.php [114]
Shop 5 /config/config.inc.php [128]
/classes/Link.php [1468]
/classes/Link.php [1468]
/classes/Link.php [1468]
/classes/Link.php [1468]
Country 5 /config/config.inc.php [157]
/classes/AddressFormat.php [404]
/classes/controller/FrontController.php [1677]
/classes/AddressFormat.php [404]
/modules/ps_contactinfo/ps_contactinfo.php [99]
Address 4 /classes/shop/Shop.php [469]
/override/classes/Product.php [3689]
/override/classes/Product.php [3803]
/override/classes/Product.php [5952]
Combination 2 /override/classes/Product.php [5914]
/override/classes/Product.php [5914]
Currency 2 /src/Adapter/Currency/CurrencyDataProvider.php [101]
/classes/Tools.php [704]
Tax 2 /classes/tax/TaxRulesTaxManager.php [116]
/classes/tax/TaxRulesTaxManager.php [116]
AddressFormat 2 /classes/controller/FrontController.php [1671]
/modules/ps_contactinfo/ps_contactinfo.php [93]
CMS 1 /classes/Link.php [623]
Guest 1 /modules/statsdata/statsdata.php [83]
Risk 1 /classes/controller/FrontController.php [1609]
State 1 /classes/controller/FrontController.php [1676]
Gender 1 /classes/controller/FrontController.php [1606]
Group 1 /classes/Cart.php [250]
Cart 1 /classes/controller/FrontController.php [443]
Customer 1 /config/config.inc.php [271]
ShopGroup 1 /classes/shop/Shop.php [557]
Connection 1 /modules/statsdata/statsdata.php [117]

Included Files

# Filename
0 /index.php
1 /config/config.inc.php
2 /config/defines.inc.php
3 /config/autoload.php
4 /vendor/autoload.php
5 /vendor/composer/autoload_real.php
6 /vendor/composer/platform_check.php
7 /vendor/composer/ClassLoader.php
8 /vendor/composer/include_paths.php
9 /vendor/composer/autoload_static.php
10 /vendor/react/promise/src/functions_include.php
11 /vendor/react/promise/src/functions.php
12 /vendor/symfony/polyfill-intl-normalizer/bootstrap.php
13 /vendor/symfony/polyfill-php72/bootstrap.php
14 /vendor/symfony/polyfill-intl-idn/bootstrap.php
15 /vendor/symfony/polyfill-ctype/bootstrap.php
16 /vendor/symfony/polyfill-mbstring/bootstrap.php
17 /vendor/symfony/polyfill-php73/bootstrap.php
18 /vendor/symfony/polyfill-iconv/bootstrap.php
19 /vendor/jakeasmith/http_build_url/src/http_build_url.php
20 /vendor/markbaker/complex/classes/src/functions/abs.php
21 /vendor/markbaker/complex/classes/src/functions/acos.php
22 /vendor/markbaker/complex/classes/src/functions/acosh.php
23 /vendor/markbaker/complex/classes/src/functions/acot.php
24 /vendor/markbaker/complex/classes/src/functions/acoth.php
25 /vendor/markbaker/complex/classes/src/functions/acsc.php
26 /vendor/markbaker/complex/classes/src/functions/acsch.php
27 /vendor/markbaker/complex/classes/src/functions/argument.php
28 /vendor/markbaker/complex/classes/src/functions/asec.php
29 /vendor/markbaker/complex/classes/src/functions/asech.php
30 /vendor/markbaker/complex/classes/src/functions/asin.php
31 /vendor/markbaker/complex/classes/src/functions/asinh.php
32 /vendor/markbaker/complex/classes/src/functions/atan.php
33 /vendor/markbaker/complex/classes/src/functions/atanh.php
34 /vendor/markbaker/complex/classes/src/functions/conjugate.php
35 /vendor/markbaker/complex/classes/src/functions/cos.php
36 /vendor/markbaker/complex/classes/src/functions/cosh.php
37 /vendor/markbaker/complex/classes/src/functions/cot.php
38 /vendor/markbaker/complex/classes/src/functions/coth.php
39 /vendor/markbaker/complex/classes/src/functions/csc.php
40 /vendor/markbaker/complex/classes/src/functions/csch.php
41 /vendor/markbaker/complex/classes/src/functions/exp.php
42 /vendor/markbaker/complex/classes/src/functions/inverse.php
43 /vendor/markbaker/complex/classes/src/functions/ln.php
44 /vendor/markbaker/complex/classes/src/functions/log2.php
45 /vendor/markbaker/complex/classes/src/functions/log10.php
46 /vendor/markbaker/complex/classes/src/functions/negative.php
47 /vendor/markbaker/complex/classes/src/functions/pow.php
48 /vendor/markbaker/complex/classes/src/functions/rho.php
49 /vendor/markbaker/complex/classes/src/functions/sec.php
50 /vendor/markbaker/complex/classes/src/functions/sech.php
51 /vendor/markbaker/complex/classes/src/functions/sin.php
52 /vendor/markbaker/complex/classes/src/functions/sinh.php
53 /vendor/markbaker/complex/classes/src/functions/sqrt.php
54 /vendor/markbaker/complex/classes/src/functions/tan.php
55 /vendor/markbaker/complex/classes/src/functions/tanh.php
56 /vendor/markbaker/complex/classes/src/functions/theta.php
57 /vendor/markbaker/complex/classes/src/operations/add.php
58 /vendor/markbaker/complex/classes/src/operations/subtract.php
59 /vendor/markbaker/complex/classes/src/operations/multiply.php
60 /vendor/markbaker/complex/classes/src/operations/divideby.php
61 /vendor/markbaker/complex/classes/src/operations/divideinto.php
62 /vendor/markbaker/matrix/classes/src/Functions/adjoint.php
63 /vendor/markbaker/matrix/classes/src/Functions/antidiagonal.php
64 /vendor/markbaker/matrix/classes/src/Functions/cofactors.php
65 /vendor/markbaker/matrix/classes/src/Functions/determinant.php
66 /vendor/markbaker/matrix/classes/src/Functions/diagonal.php
67 /vendor/markbaker/matrix/classes/src/Functions/identity.php
68 /vendor/markbaker/matrix/classes/src/Functions/inverse.php
69 /vendor/markbaker/matrix/classes/src/Functions/minors.php
70 /vendor/markbaker/matrix/classes/src/Functions/trace.php
71 /vendor/markbaker/matrix/classes/src/Functions/transpose.php
72 /vendor/markbaker/matrix/classes/src/Operations/add.php
73 /vendor/markbaker/matrix/classes/src/Operations/directsum.php
74 /vendor/markbaker/matrix/classes/src/Operations/subtract.php
75 /vendor/markbaker/matrix/classes/src/Operations/multiply.php
76 /vendor/markbaker/matrix/classes/src/Operations/divideby.php
77 /vendor/markbaker/matrix/classes/src/Operations/divideinto.php
78 /vendor/paragonie/random_compat/lib/random.php
79 /vendor/swiftmailer/swiftmailer/lib/swift_required.php
80 /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
81 /vendor/symfony/polyfill-apcu/bootstrap.php
82 /vendor/symfony/polyfill-intl-icu/bootstrap.php
83 /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
84 /vendor/ircmaxell/password-compat/lib/password.php
85 /vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
86 /app/AppKernel.php
87 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php
88 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/KernelInterface.php
89 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernelInterface.php
90 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/RebootableInterface.php
91 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/TerminableInterface.php
92 /config/alias.php
93 /classes/PrestaShopAutoload.php
94 /var/cache/prod/class_index.php
95 /config/bootstrap.php
96 /src/Core/ContainerBuilder.php
97 /src/Core/Foundation/IoC/Container.php
98 /src/Adapter/ServiceLocator.php
99 /vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
100 /var/cache/prod/appParameters.php
103 /classes/controller/Controller.php
105 /classes/ObjectModel.php
106 /src/Core/Foundation/Database/EntityInterface.php
108 /classes/db/Db.php
110 /classes/Hook.php
112 /classes/module/Module.php
113 /src/Core/Module/ModuleInterface.php
115 /classes/Tools.php
116 /classes/Context.php
117 /classes/shop/Shop.php
118 /classes/db/DbPDO.php
119 /classes/AddressFormat.php
120 /classes/Configuration.php
121 /classes/Validate.php
122 /classes/cache/Cache.php
123 /src/Adapter/EntityMapper.php
124 /classes/db/DbQuery.php
125 /src/Core/Addon/Theme/ThemeManagerBuilder.php
126 /src/Adapter/Configuration.php
127 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
128 /src/Core/Domain/Configuration/ShopConfigurationInterface.php
129 /src/Core/ConfigurationInterface.php
130 /src/Core/Addon/Theme/ThemeRepository.php
131 /src/Core/Addon/AddonRepositoryInterface.php
132 /src/Core/Domain/Shop/ValueObject/ShopConstraint.php
133 /src/Core/Addon/Theme/Theme.php
134 /src/Core/Addon/AddonInterface.php
135 /vendor/shudrum/array-finder/ArrayFinder.php
136 /config/defines_uri.inc.php
137 /classes/Language.php
138 /src/Core/Language/LanguageInterface.php
139 /classes/Country.php
140 /classes/PrestaShopCollection.php
141 /classes/shop/ShopGroup.php
142 /classes/Cookie.php
143 /classes/PhpEncryption.php
144 /vendor/defuse/php-encryption/src/Core.php
145 /classes/PhpEncryptionEngine.php
146 /vendor/defuse/php-encryption/src/Key.php
147 /vendor/defuse/php-encryption/src/Encoding.php
148 /src/Core/Session/SessionHandler.php
149 /src/Core/Session/SessionHandlerInterface.php
150 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Session.php
151 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionInterface.php
152 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/PhpBridgeSessionStorage.php
153 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/NativeSessionStorage.php
154 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/SessionStorageInterface.php
155 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/MetadataBag.php
156 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionBagInterface.php
157 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Proxy/SessionHandlerProxy.php
158 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Proxy/AbstractProxy.php
159 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/StrictSessionHandler.php
160 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/AbstractSessionHandler.php
161 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Attribute/AttributeBag.php
162 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Attribute/AttributeBagInterface.php
163 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionBagProxy.php
164 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Flash/FlashBag.php
165 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Flash/FlashBagInterface.php
166 /config/smarty.config.inc.php
167 /vendor/smarty/smarty/libs/Smarty.class.php
168 /vendor/smarty/smarty/libs/Autoloader.php
169 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php
170 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php
171 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
172 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
173 /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php
174 /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php
175 /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php
176 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
177 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php
178 /config/smartyfront.config.inc.php
179 /classes/Smarty/SmartyResourceModule.php
180 /vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php
181 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php
182 /classes/Smarty/SmartyResourceParent.php
183 /classes/Smarty/SmartyLazyRegister.php
184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php
185 /vendor/smarty/smarty/libs/plugins/modifier.truncate.php
186 /classes/Customer.php
187 /classes/Group.php
188 /classes/Link.php
189 /classes/shop/ShopUrl.php
190 /classes/Dispatcher.php
191 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Request.php
192 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/FileBag.php
193 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ServerBag.php
194 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/HeaderBag.php
195 /src/Adapter/SymfonyContainer.php
196 /vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
197 /config/db_slave_server.inc.php
198 /modules/ps_mbo/ps_mbo.php
199 /modules/ps_mbo/vendor/autoload.php
200 /modules/ps_mbo/vendor/composer/autoload_real.php
201 /modules/ps_mbo/vendor/composer/platform_check.php
202 /modules/ps_mbo/vendor/composer/autoload_static.php
203 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php
204 /vendor/smarty/smarty/libs/sysplugins/smarty_data.php
205 /classes/Translate.php
206 /modules/ps_mbo/translations/nl.php
207 /src/PrestaShopBundle/Translation/TranslatorComponent.php
208 /vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
209 /vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
210 /vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
211 /src/PrestaShopBundle/Translation/TranslatorInterface.php
212 /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
213 /src/PrestaShopBundle/Translation/TranslatorLanguageTrait.php
214 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatter.php
215 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatterInterface.php
216 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/ChoiceMessageFormatterInterface.php
217 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageSelector.php
218 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
219 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
220 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
221 /vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
222 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
223 /var/cache/prod/translations/catalogue.nl-NL.NXhscRe.php
224 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
225 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
226 /vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
227 /controllers/front/listing/CategoryController.php
228 /classes/controller/ProductListingFrontController.php
229 /classes/controller/ProductPresentingFrontController.php
230 /classes/controller/FrontController.php
231 /src/Adapter/Presenter/Object/ObjectPresenter.php
232 /src/Adapter/Presenter/PresenterInterface.php
233 /src/Adapter/Presenter/Cart/CartPresenter.php
234 /src/Adapter/Product/PriceFormatter.php
235 /src/Adapter/Image/ImageRetriever.php
236 /classes/tax/TaxConfiguration.php
237 /classes/Smarty/TemplateFinder.php
238 /classes/assets/StylesheetManager.php
239 /classes/assets/AbstractAssetManager.php
240 /src/Adapter/Assets/AssetUrlGeneratorTrait.php
241 /classes/assets/JavascriptManager.php
242 /classes/assets/CccReducer.php
243 /classes/Category.php
244 /classes/webservice/WebserviceRequest.php
245 /src/Adapter/ContainerBuilder.php
246 /src/Adapter/Environment.php
247 /src/Core/EnvironmentInterface.php
248 /vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Setup.php
249 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ArrayCache.php
250 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
251 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
252 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
253 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
254 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiOperationCache.php
255 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
256 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiDeleteCache.php
257 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
258 /vendor/doctrine/orm/lib/Doctrine/ORM/Configuration.php
259 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Configuration.php
260 /vendor/doctrine/persistence/lib/Doctrine/Persistence/Mapping/Driver/MappingDriver.php
261 /vendor/doctrine/persistence/lib/Doctrine/Common/Persistence/Mapping/Driver/MappingDriver.php
262 /vendor/doctrine/persistence/lib/Doctrine/Persistence/Mapping/ClassMetadata.php
263 /vendor/doctrine/persistence/lib/Doctrine/Common/Persistence/Mapping/ClassMetadata.php
264 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php
265 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php
266 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Annotation.php
267 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Entity.php
268 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embeddable.php
269 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embedded.php
270 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/MappedSuperclass.php
271 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/InheritanceType.php
272 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorColumn.php
273 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorMap.php
274 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Id.php
275 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/GeneratedValue.php
276 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Version.php
277 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumn.php
278 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumns.php
279 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Column.php
280 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToOne.php
281 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToMany.php
282 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToOne.php
283 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToMany.php
284 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Table.php
285 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UniqueConstraint.php
286 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Index.php
287 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinTable.php
288 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SequenceGenerator.php
289 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/CustomIdGenerator.php
290 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ChangeTrackingPolicy.php
291 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OrderBy.php
292 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQueries.php
293 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQuery.php
294 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/HasLifecycleCallbacks.php
295 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PrePersist.php
296 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostPersist.php
297 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreUpdate.php
298 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostUpdate.php
299 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreRemove.php
300 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostRemove.php
301 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostLoad.php
302 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreFlush.php
303 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/FieldResult.php
304 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ColumnResult.php
305 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityResult.php
306 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQuery.php
307 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQueries.php
308 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMapping.php
309 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMappings.php
310 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverride.php
311 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverrides.php
312 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverride.php
313 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverrides.php
314 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityListeners.php
315 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Cache.php
316 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php
317 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php
318 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php
319 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php
320 /vendor/doctrine/lexer/lib/Doctrine/Common/Lexer/AbstractLexer.php
321 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php
322 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/CachedReader.php
323 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/AnnotationDriver.php
324 /vendor/doctrine/persistence/lib/Doctrine/Persistence/Mapping/Driver/AnnotationDriver.php
325 /vendor/doctrine/persistence/lib/Doctrine/Common/Persistence/Mapping/Driver/AnnotationDriver.php
326 /var/cache/prod/FrontContainer.php
327 /src/Adapter/Container/LegacyContainer.php
328 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
329 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
330 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
331 /vendor/psr/container/src/ContainerInterface.php
332 /src/Adapter/Container/LegacyContainerInterface.php
333 /modules/contactform/vendor/autoload.php
334 /modules/contactform/vendor/composer/autoload_real.php
335 /modules/contactform/vendor/composer/autoload_static.php
336 /modules/dashactivity/vendor/autoload.php
337 /modules/dashactivity/vendor/composer/autoload_real.php
338 /modules/dashactivity/vendor/composer/autoload_static.php
339 /modules/dashtrends/vendor/autoload.php
340 /modules/dashtrends/vendor/composer/autoload_real.php
341 /modules/dashtrends/vendor/composer/autoload_static.php
342 /modules/dashgoals/vendor/autoload.php
343 /modules/dashgoals/vendor/composer/autoload_real.php
344 /modules/dashgoals/vendor/composer/autoload_static.php
345 /modules/dashproducts/vendor/autoload.php
346 /modules/dashproducts/vendor/composer/autoload_real.php
347 /modules/dashproducts/vendor/composer/autoload_static.php
348 /modules/graphnvd3/vendor/autoload.php
349 /modules/graphnvd3/vendor/composer/autoload_real.php
350 /modules/graphnvd3/vendor/composer/autoload_static.php
351 /modules/gridhtml/vendor/autoload.php
352 /modules/gridhtml/vendor/composer/autoload_real.php
353 /modules/gridhtml/vendor/composer/autoload_static.php
354 /modules/gsitemap/vendor/autoload.php
355 /modules/gsitemap/vendor/composer/autoload_real.php
356 /modules/gsitemap/vendor/composer/autoload_static.php
357 /modules/ps_banner/vendor/autoload.php
358 /modules/ps_banner/vendor/composer/autoload_real.php
359 /modules/ps_banner/vendor/composer/autoload_static.php
360 /modules/ps_categorytree/vendor/autoload.php
361 /modules/ps_categorytree/vendor/composer/autoload_real.php
362 /modules/ps_categorytree/vendor/composer/autoload_static.php
363 /modules/ps_contactinfo/vendor/autoload.php
364 /modules/ps_contactinfo/vendor/composer/autoload_real.php
365 /modules/ps_contactinfo/vendor/composer/autoload_static.php
366 /modules/ps_currencyselector/vendor/autoload.php
367 /modules/ps_currencyselector/vendor/composer/autoload_real.php
368 /modules/ps_currencyselector/vendor/composer/autoload_static.php
369 /modules/ps_customeraccountlinks/vendor/autoload.php
370 /modules/ps_customeraccountlinks/vendor/composer/autoload_real.php
371 /modules/ps_customeraccountlinks/vendor/composer/autoload_static.php
372 /modules/ps_customersignin/vendor/autoload.php
373 /modules/ps_customersignin/vendor/composer/autoload_real.php
374 /modules/ps_customersignin/vendor/composer/autoload_static.php
375 /modules/ps_customtext/vendor/autoload.php
376 /modules/ps_customtext/vendor/composer/autoload_real.php
377 /modules/ps_customtext/vendor/composer/autoload_static.php
378 /modules/ps_emailsubscription/vendor/autoload.php
379 /modules/ps_emailsubscription/vendor/composer/autoload_real.php
380 /modules/ps_emailsubscription/vendor/composer/autoload_static.php
381 /modules/ps_facetedsearch/vendor/autoload.php
382 /modules/ps_facetedsearch/vendor/composer/autoload_real.php
383 /modules/ps_facetedsearch/vendor/composer/autoload_static.php
384 /modules/ps_featuredproducts/vendor/autoload.php
385 /modules/ps_featuredproducts/vendor/composer/autoload_real.php
386 /modules/ps_featuredproducts/vendor/composer/autoload_static.php
387 /modules/ps_imageslider/vendor/autoload.php
388 /modules/ps_imageslider/vendor/composer/autoload_real.php
389 /modules/ps_imageslider/vendor/composer/autoload_static.php
390 /modules/ps_mainmenu/vendor/autoload.php
391 /modules/ps_mainmenu/vendor/composer/autoload_real.php
392 /modules/ps_mainmenu/vendor/composer/autoload_static.php
393 /modules/ps_searchbar/vendor/autoload.php
394 /modules/ps_searchbar/vendor/composer/autoload_real.php
395 /modules/ps_searchbar/vendor/composer/autoload_static.php
396 /modules/ps_sharebuttons/vendor/autoload.php
397 /modules/ps_sharebuttons/vendor/composer/autoload_real.php
398 /modules/ps_sharebuttons/vendor/composer/autoload_static.php
399 /modules/ps_shoppingcart/vendor/autoload.php
400 /modules/ps_shoppingcart/vendor/composer/autoload_real.php
401 /modules/ps_shoppingcart/vendor/composer/autoload_static.php
402 /modules/ps_socialfollow/vendor/autoload.php
403 /modules/ps_socialfollow/vendor/composer/autoload_real.php
404 /modules/ps_socialfollow/vendor/composer/autoload_static.php
405 /modules/ps_themecusto/vendor/autoload.php
406 /modules/ps_themecusto/vendor/composer/autoload_real.php
407 /modules/ps_themecusto/vendor/composer/autoload_static.php
408 /modules/pagesnotfound/vendor/autoload.php
409 /modules/pagesnotfound/vendor/composer/autoload_real.php
410 /modules/pagesnotfound/vendor/composer/autoload_static.php
411 /modules/statsbestcategories/vendor/autoload.php
412 /modules/statsbestcategories/vendor/composer/autoload_real.php
413 /modules/statsbestcategories/vendor/composer/autoload_static.php
414 /modules/statsbestcustomers/vendor/autoload.php
415 /modules/statsbestcustomers/vendor/composer/autoload_real.php
416 /modules/statsbestcustomers/vendor/composer/autoload_static.php
417 /modules/statsbestproducts/vendor/autoload.php
418 /modules/statsbestproducts/vendor/composer/autoload_real.php
419 /modules/statsbestproducts/vendor/composer/autoload_static.php
420 /modules/statsbestsuppliers/vendor/autoload.php
421 /modules/statsbestsuppliers/vendor/composer/autoload_real.php
422 /modules/statsbestsuppliers/vendor/composer/autoload_static.php
423 /modules/statsbestvouchers/vendor/autoload.php
424 /modules/statsbestvouchers/vendor/composer/autoload_real.php
425 /modules/statsbestvouchers/vendor/composer/autoload_static.php
426 /modules/statscarrier/vendor/autoload.php
427 /modules/statscarrier/vendor/composer/autoload_real.php
428 /modules/statscarrier/vendor/composer/autoload_static.php
429 /modules/statscatalog/vendor/autoload.php
430 /modules/statscatalog/vendor/composer/autoload_real.php
431 /modules/statscatalog/vendor/composer/autoload_static.php
432 /modules/statscheckup/vendor/autoload.php
433 /modules/statscheckup/vendor/composer/autoload_real.php
434 /modules/statscheckup/vendor/composer/autoload_static.php
435 /modules/statsdata/vendor/autoload.php
436 /modules/statsdata/vendor/composer/autoload_real.php
437 /modules/statsdata/vendor/composer/autoload_static.php
438 /modules/statsforecast/vendor/autoload.php
439 /modules/statsforecast/vendor/composer/autoload_real.php
440 /modules/statsforecast/vendor/composer/autoload_static.php
441 /modules/statslive/vendor/autoload.php
442 /modules/statslive/vendor/composer/autoload_real.php
443 /modules/statslive/vendor/composer/autoload_static.php
444 /modules/statsnewsletter/vendor/autoload.php
445 /modules/statsnewsletter/vendor/composer/autoload_real.php
446 /modules/statsnewsletter/vendor/composer/autoload_static.php
447 /modules/statspersonalinfos/vendor/autoload.php
448 /modules/statspersonalinfos/vendor/composer/autoload_real.php
449 /modules/statspersonalinfos/vendor/composer/autoload_static.php
450 /modules/statsproduct/vendor/autoload.php
451 /modules/statsproduct/vendor/composer/autoload_real.php
452 /modules/statsproduct/vendor/composer/autoload_static.php
453 /modules/statsregistrations/vendor/autoload.php
454 /modules/statsregistrations/vendor/composer/autoload_real.php
455 /modules/statsregistrations/vendor/composer/autoload_static.php
456 /modules/statssales/vendor/autoload.php
457 /modules/statssales/vendor/composer/autoload_real.php
458 /modules/statssales/vendor/composer/autoload_static.php
459 /modules/statssearch/vendor/autoload.php
460 /modules/statssearch/vendor/composer/autoload_real.php
461 /modules/statssearch/vendor/composer/autoload_static.php
462 /modules/statsstock/vendor/autoload.php
463 /modules/statsstock/vendor/composer/autoload_real.php
464 /modules/statsstock/vendor/composer/autoload_static.php
465 /modules/welcome/vendor/autoload.php
466 /modules/welcome/vendor/composer/autoload_real.php
467 /modules/welcome/vendor/composer/autoload_static.php
468 /modules/gamification/vendor/autoload.php
469 /modules/gamification/vendor/composer/autoload_real.php
470 /modules/gamification/vendor/composer/autoload_static.php
471 /modules/cronjobs/vendor/autoload.php
472 /modules/cronjobs/vendor/composer/autoload_real.php
473 /modules/cronjobs/vendor/composer/autoload_static.php
474 /modules/psaddonsconnect/vendor/autoload.php
475 /modules/psaddonsconnect/vendor/composer/autoload_real.php
476 /modules/psaddonsconnect/vendor/composer/autoload_static.php
477 /modules/ps_buybuttonlite/vendor/autoload.php
478 /modules/ps_buybuttonlite/vendor/composer/autoload_real.php
479 /modules/ps_buybuttonlite/vendor/composer/autoload_static.php
480 /modules/blockreassurance/vendor/autoload.php
481 /modules/blockreassurance/vendor/composer/autoload_real.php
482 /modules/blockreassurance/vendor/composer/autoload_static.php
483 /modules/ps_newproducts/vendor/autoload.php
484 /modules/ps_newproducts/vendor/composer/autoload_real.php
485 /modules/ps_newproducts/vendor/composer/autoload_static.php
486 /modules/ps_specials/vendor/autoload.php
487 /modules/ps_specials/vendor/composer/autoload_real.php
488 /modules/ps_specials/vendor/composer/autoload_static.php
489 /modules/psgdpr/vendor/autoload.php
490 /modules/psgdpr/vendor/composer/autoload_real.php
491 /modules/psgdpr/vendor/composer/autoload_static.php
492 /modules/ps_googleanalytics/vendor/autoload.php
493 /modules/ps_googleanalytics/vendor/composer/autoload_real.php
494 /modules/ps_googleanalytics/vendor/composer/autoload_static.php
495 /modules/ps_emailalerts/vendor/autoload.php
496 /modules/ps_emailalerts/vendor/composer/autoload_real.php
497 /modules/ps_emailalerts/vendor/composer/autoload_static.php
498 /modules/ps_checkpayment/vendor/autoload.php
499 /modules/ps_checkpayment/vendor/composer/autoload_real.php
500 /modules/ps_checkpayment/vendor/composer/autoload_static.php
501 /modules/ps_wirepayment/vendor/autoload.php
502 /modules/ps_wirepayment/vendor/composer/autoload_real.php
503 /modules/ps_wirepayment/vendor/composer/autoload_static.php
504 /modules/ps_bestsellers/vendor/autoload.php
505 /modules/ps_bestsellers/vendor/composer/autoload_real.php
506 /modules/ps_bestsellers/vendor/composer/autoload_static.php
507 /modules/ps_faviconnotificationbo/vendor/autoload.php
508 /modules/ps_faviconnotificationbo/vendor/composer/autoload_real.php
509 /modules/ps_faviconnotificationbo/vendor/composer/autoload_static.php
510 /modules/autoupgrade/vendor/autoload.php
511 /modules/autoupgrade/vendor/composer/autoload_real.php
512 /modules/autoupgrade/vendor/composer/autoload_static.php
513 /modules/ps_languageselector/vendor/autoload.php
514 /modules/ps_languageselector/vendor/composer/autoload_real.php
515 /modules/ps_languageselector/vendor/composer/autoload_static.php
516 /modules/ps_linklist/vendor/autoload.php
517 /modules/ps_linklist/vendor/composer/autoload_real.php
518 /modules/ps_linklist/vendor/composer/autoload_static.php
519 /src/Core/Localization/Locale/Repository.php
520 /src/Core/Localization/Locale/RepositoryInterface.php
521 /src/Core/Localization/CLDR/LocaleRepository.php
522 /src/Core/Localization/CLDR/LocaleDataSource.php
523 /src/Core/Localization/CLDR/DataLayer/LocaleCache.php
524 /src/Core/Data/Layer/AbstractDataLayer.php
525 /src/Core/Localization/CLDR/LocaleDataLayerInterface.php
526 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/FilesystemAdapter.php
527 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AbstractAdapter.php
528 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AdapterInterface.php
529 /vendor/psr/cache/src/CacheItemPoolInterface.php
530 /vendor/psr/log/Psr/Log/LoggerAwareInterface.php
531 /vendor/symfony/symfony/src/Symfony/Component/Cache/ResettableInterface.php
532 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/AbstractTrait.php
533 /vendor/psr/log/Psr/Log/LoggerAwareTrait.php
534 /vendor/symfony/symfony/src/Symfony/Component/Cache/PruneableInterface.php
535 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemTrait.php
536 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemCommonTrait.php
537 /vendor/symfony/symfony/src/Symfony/Component/Cache/CacheItem.php
538 /vendor/psr/cache/src/CacheItemInterface.php
539 /src/Core/Localization/CLDR/DataLayer/LocaleReference.php
540 /src/Core/Localization/CLDR/Reader.php
541 /src/Core/Localization/CLDR/ReaderInterface.php
542 /src/Core/Localization/Currency/Repository.php
543 /src/Core/Localization/Currency/RepositoryInterface.php
544 /src/Core/Localization/Currency/CurrencyDataSource.php
545 /src/Core/Localization/Currency/DataSourceInterface.php
546 /src/Core/Localization/Currency/DataLayer/CurrencyCache.php
547 /src/Core/Localization/Currency/CurrencyDataLayerInterface.php
548 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/ArrayAdapter.php
549 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/ArrayTrait.php
550 /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php
551 /src/Adapter/Currency/CurrencyDataProvider.php
552 /src/Core/Currency/CurrencyDataProviderInterface.php
553 /src/Adapter/LegacyContext.php
554 /src/Adapter/Tools.php
555 /src/Core/Localization/Currency/DataLayer/CurrencyReference.php
556 /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php
557 /vendor/prestashop/decimal/src/Operation/Rounding.php
558 /src/Core/Localization/Locale.php
559 /src/Core/Localization/LocaleInterface.php
560 /src/Core/Localization/Specification/Price.php
561 /src/Core/Localization/Specification/Number.php
562 /src/Core/Localization/Specification/NumberInterface.php
563 /src/Core/Localization/Specification/Factory.php
564 /src/Core/Localization/CLDR/LocaleData.php
565 /src/Core/Localization/CLDR/NumberSymbolsData.php
566 /src/Core/Localization/CLDR/CurrencyData.php
567 /src/Core/Localization/CLDR/Locale.php
568 /src/Core/Localization/CLDR/LocaleInterface.php
569 /src/Core/Localization/Specification/NumberSymbolList.php
570 /classes/Currency.php
571 /src/Core/Localization/Currency/LocalizedCurrencyId.php
572 /src/Core/Localization/Currency/CurrencyData.php
573 /src/Core/Localization/Currency/CurrencyCollection.php
574 /src/Core/Localization/Currency.php
575 /src/Core/Localization/CurrencyInterface.php
576 /src/Core/Localization/Specification/NumberCollection.php
577 /src/Core/Localization/Number/Formatter.php
578 /classes/Cart.php
579 /src/Adapter/AddressFactory.php
580 /classes/CartRule.php
581 /override/classes/Product.php
582 /bootstrap.php
583 /solr.php
584 /src/Core/Domain/Product/ValueObject/RedirectType.php
585 /src/Core/Util/DateTime/DateTime.php
586 /src/Core/Domain/Product/Stock/ValueObject/OutOfStockType.php
587 /classes/Pack.php
588 /src/Core/Domain/Product/Pack/ValueObject/PackStockType.php
589 /src/Core/Domain/Product/ValueObject/ProductType.php
590 /src/Core/Domain/Product/ValueObject/Reference.php
591 /src/Core/Domain/Product/ValueObject/Ean13.php
592 /src/Core/Domain/Product/ValueObject/Isbn.php
593 /src/Core/Domain/Product/ValueObject/Upc.php
594 /src/Core/Domain/Product/ProductSettings.php
595 /src/Core/Domain/Shop/ValueObject/ShopId.php
596 /modules/blockreassurance/blockreassurance.php
597 /src/Core/Module/WidgetInterface.php
598 /src/PrestaShopBundle/Translation/DomainNormalizer.php
599 /classes/Media.php
600 /modules/ps_emailalerts/ps_emailalerts.php
601 /modules/ps_emailalerts/MailAlert.php
602 /modules/ps_socialfollow/ps_socialfollow.php
603 /classes/ProductDownload.php
604 /classes/tax/Tax.php
605 /src/Core/Localization/CLDR/ComputingPrecision.php
606 /src/Core/Localization/CLDR/ComputingPrecisionInterface.php
607 /src/Core/Cart/Calculator.php
608 /src/Core/Cart/CartRowCollection.php
609 /src/Core/Cart/Fees.php
610 /src/Core/Cart/AmountImmutable.php
611 /src/Core/Cart/CartRuleCollection.php
612 /src/Core/Cart/CartRuleCalculator.php
613 /src/Adapter/Product/PriceCalculator.php
614 /override/classes/order/Order.php
615 /src/Core/Cart/CartRow.php
616 /vendor/prestashop/decimal/src/DecimalNumber.php
617 /vendor/prestashop/decimal/src/Builder.php
618 /classes/Gender.php
619 /classes/Risk.php
620 /classes/Meta.php
621 /classes/Address.php
622 /src/Adapter/ContainerFinder.php
623 /src/Core/String/CharacterCleaner.php
624 /classes/ImageType.php
625 /src/Core/Addon/Module/ModuleManagerBuilder.php
626 /src/Core/Util/File/YamlParser.php
627 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceChecker.php
628 /vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerInterface.php
629 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/FileResource.php
630 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceInterface.php
631 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ResourceInterface.php
632 /var/cache/prod/yaml/e1d0bef1e957accbdc65a202b994c12b.php
633 /var/cache/prod/yaml/3d96146d7a518f544cf3653e9a372368.php
634 /src/PrestaShopBundle/Service/DataProvider/Marketplace/ApiClient.php
635 /vendor/guzzlehttp/guzzle/src/Client.php
636 /vendor/guzzlehttp/guzzle/src/ClientInterface.php
637 /vendor/guzzlehttp/guzzle/src/Event/HasEmitterInterface.php
638 /vendor/guzzlehttp/guzzle/src/Event/HasEmitterTrait.php
639 /vendor/guzzlehttp/guzzle/src/Url.php
640 /vendor/guzzlehttp/guzzle/src/Utils.php
641 /vendor/guzzlehttp/guzzle/src/Message/MessageFactory.php
642 /vendor/guzzlehttp/guzzle/src/Message/MessageFactoryInterface.php
643 /vendor/guzzlehttp/guzzle/src/Event/ListenerAttacherTrait.php
644 /vendor/guzzlehttp/guzzle/src/Subscriber/HttpError.php
645 /vendor/guzzlehttp/guzzle/src/Event/SubscriberInterface.php
646 /vendor/guzzlehttp/guzzle/src/Subscriber/Redirect.php
647 /vendor/guzzlehttp/ringphp/src/Client/CurlHandler.php
648 /vendor/guzzlehttp/ringphp/src/Client/CurlFactory.php
649 /vendor/guzzlehttp/ringphp/src/Client/CurlMultiHandler.php
650 /vendor/guzzlehttp/ringphp/src/Client/Middleware.php
651 /vendor/guzzlehttp/ringphp/src/Client/StreamHandler.php
652 /vendor/guzzlehttp/guzzle/src/RequestFsm.php
653 /app/config/parameters.php
654 /src/Adapter/Module/ModuleZipManager.php
655 /src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php
656 /vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcherInterface.php
657 /src/Core/Hook/HookDispatcherInterface.php
658 /src/Adapter/Addons/AddonsDataProvider.php
659 /src/PrestaShopBundle/Service/DataProvider/Admin/AddonsInterface.php
660 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
661 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
662 /src/Adapter/LegacyLogger.php
663 /vendor/psr/log/Psr/Log/LoggerInterface.php
664 /src/PrestaShopBundle/Service/DataProvider/Admin/CategoriesProvider.php
665 /src/Adapter/Module/ModuleDataProvider.php
666 /src/Adapter/Module/AdminModuleDataProvider.php
667 /src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php
668 /vendor/symfony/symfony/src/Symfony/Component/Config/FileLocator.php
669 /vendor/symfony/symfony/src/Symfony/Component/Config/FileLocatorInterface.php
670 /vendor/symfony/symfony/src/Symfony/Component/Routing/Loader/YamlFileLoader.php
671 /vendor/symfony/symfony/src/Symfony/Component/Config/Loader/FileLoader.php
672 /vendor/symfony/symfony/src/Symfony/Component/Config/Loader/Loader.php
673 /vendor/symfony/symfony/src/Symfony/Component/Config/Loader/LoaderInterface.php
674 /vendor/symfony/symfony/src/Symfony/Component/Routing/Router.php
675 /vendor/symfony/symfony/src/Symfony/Component/Routing/RouterInterface.php
676 /vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/UrlMatcherInterface.php
677 /vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContextAwareInterface.php
678 /vendor/symfony/symfony/src/Symfony/Component/Routing/Generator/UrlGeneratorInterface.php
679 /vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/RequestMatcherInterface.php
680 /vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContext.php
681 /src/Adapter/Module/ModuleDataUpdater.php
682 /src/Core/Addon/Module/ModuleManager.php
683 /src/Core/Addon/AddonManagerInterface.php
684 /src/Core/Addon/Module/ModuleRepository.php
685 /src/Core/Addon/Module/ModuleRepositoryInterface.php
686 /vendor/symfony/symfony/src/Symfony/Component/Finder/Finder.php
687 /src/Adapter/Cache/Clearer/SymfonyCacheClearer.php
688 /src/Core/Cache/Clearer/CacheClearerInterface.php
689 /classes/State.php
690 /src/Core/Filter/FrontEndObject/MainFilter.php
691 /src/Core/Filter/FilterInterface.php
692 /src/Core/Filter/FrontEndObject/CartFilter.php
693 /src/Core/Filter/HashMapWhitelistFilter.php
694 /src/Core/Filter/CollectionFilter.php
695 /src/Core/Filter/FrontEndObject/ProductFilter.php
696 /src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php
697 /src/Core/Filter/FrontEndObject/CustomerFilter.php
698 /src/Core/Filter/FrontEndObject/ShopFilter.php
699 /src/Core/Filter/FrontEndObject/ConfigurationFilter.php
700 /modules/ps_searchbar/ps_searchbar.php
701 /modules/evxtopbar/evxtopbar.php
702 /modules/evxtopbar/translations/nl.php
703 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
704 /var/cache/prod/smarty/compile/medio/5c/e0/1e/5ce01ee9d32741abd70a38ce69fd6ab18ab99da5_2.file.topbar.tpl.php
705 /vendor/smarty/smarty/libs/plugins/modifier.escape.php
706 /modules/freega4/freega4.php
707 /var/cache/prod/smarty/compile/medio/50/93/56/5093568b60e62711b6fceb55ac60fcfda7bd0593_2.file.gtag.tpl.php
708 /modules/ps_imageslider/ps_imageslider.php
709 /modules/ps_imageslider/Ps_HomeSlide.php
710 /modules/mediocheckout/mediocheckout.php
711 /override/classes/PaymentModule.php
712 /modules/mediocheckout/translations/nl.php
713 /modules/bpostshm/bpostshm.php
714 /modules/bpostshm/classes/Service.php
715 /classes/module/CarrierModule.php
716 /modules/bpostshm/translations/nl.php
717 /modules/pm_advancedtopmenu/pm_advancedtopmenu.php
718 /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php
719 /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php
720 /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php
721 /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php
722 /modules/pm_advancedtopmenu/AdvancedTopMenuProductColumnClass.php
723 /modules/pm_advancedtopmenu/AdvancedTopMenuWidgetProxy.php
724 /var/cache/prod/smarty/compile/medio/4c/f1/15/4cf115cba6641f09f36f53e0c15cbbcc99d55255_2.file.pm_advancedtopmenu_header.tpl.php
725 /modules/catalogblocks/catalogblocks.php
726 /modules/catalogblocks/models/catalog-block.php
727 /modules/catalogblocks/translations/nl.php
728 /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php
729 /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php
730 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php
731 /var/cache/prod/smarty/cache/catalogblocks_header/1/8/1/1/4/3/medio/0d/22/1f/0d221fc65964a93476d1d3b7edc14bde509536fa.header.tpl.php
732 /modules/lgcookieslaw/lgcookieslaw.php
733 /modules/lgcookieslaw/translations/nl.php
734 /classes/CMS.php
735 /var/cache/prod/smarty/compile/medio/ba/6e/db/ba6edbd32301ed727bd7db272f87b32c2638012e_2.file.cookieslaw_header_1_7.tpl.php
736 /var/cache/prod/smarty/compile/medio/99/3f/4e/993f4e07d8608a04350abd3597bb44b2b569d085_2.file.cookieslaw_header_code.tpl.php
737 /modules/shoppinglist/shoppinglist.php
738 /modules/shoppinglist/classes/ShoppingListObject.php
739 /modules/shoppinglist/translations/nl.php
740 /modules/gamification/gamification.php
741 /modules/gamification/classes/Badge.php
742 /modules/gamification/classes/Advice.php
743 /modules/gamification/classes/Condition.php
744 /modules/gamification/classes/GamificationTools.php
745 /modules/gamification/translations/nl.php
746 /vendor/defuse/php-encryption/src/Crypto.php
747 /vendor/defuse/php-encryption/src/KeyOrPassword.php
748 /vendor/defuse/php-encryption/src/RuntimeTests.php
749 /vendor/defuse/php-encryption/src/DerivedKeys.php
750 /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
751 /vendor/defuse/php-encryption/src/Exception/CryptoException.php
752 /modules/productsurveysadv/productsurveysadv.php
753 /src/Adapter/Localization/LegacyTranslator.php
754 /modules/productsurveysadv/productsurveysadv.config.php
755 /modules/productsurveysadv/classes/SurveysAdvInstaller.php
756 /modules/productsurveysadv/classes/SurveyAdv.php
757 /modules/productsurveysadv/classes/QuestionAdv.php
758 /modules/productsurveysadv/classes/AnswerAdv.php
759 /modules/productsurveysadv/classes/RespondentAdv.php
760 /modules/productsurveysadv/classes/Comet.php
761 /modules/productsurveysadv/classes/SurveyAdvPosition.php
762 /modules/productsurveysadv/classes/SurveyAdvMail.php
763 /modules/productsurveysadv/classes/SurveyAdvRemoteAddress.php
764 /modules/fscustomhtml/fscustomhtml.php
765 /modules/fscustomhtml/classloader.php
766 /modules/fscustomhtml/classes/FsCustomHtmlHelper.php
767 /modules/fscustomhtml/classes/FsCustomHtmlHelperFormAbstract.php
768 /classes/helper/HelperForm.php
769 /classes/helper/Helper.php
770 /modules/fscustomhtml/classes/FsCustomHtmlHelperConfig.php
771 /modules/fscustomhtml/classes/FsCustomHtmlHelperForm.php
772 /modules/fscustomhtml/classes/FsCustomHtmlHelperFormFilter.php
773 /modules/fscustomhtml/classes/FsCustomHtmlHelperList.php
774 /classes/helper/HelperList.php
775 /modules/fscustomhtml/classes/FsCustomHtmlFilterModel.php
776 /modules/fscustomhtml/classes/FsCustomHtmlBlockFilterModel.php
777 /modules/fscustomhtml/classes/FsCustomHtmlBlockModel.php
778 /modules/fscustomhtml/classes/FsCustomHtmlHookModel.php
779 /modules/fscustomhtml/classes/FsCustomHtmlTemplateModel.php
780 /modules/fscustomhtml/classes/FsCustomHtmlValidate.php
781 /modules/ogone/ogone.php
782 /modules/ogone/inc/DirectLink.php
783 /modules/ogone/inc/CurrencyCacheCleaner.php
784 /modules/ogone/inc/ProductCacheCleaner.php
785 /modules/ogone/inc/SpecificPriceCacheCleaner.php
786 /classes/SpecificPrice.php
787 /modules/ogone/inc/OgoneTransactionLog.php
788 /modules/ogone/inc/OgoneAlias.php
789 /modules/ogone/inc/OgonePM.php
790 /modules/ogone/inc/OgoneProductSubscription.php
791 /modules/ogone/inc/OgoneSubscription.php
792 /modules/ogone/inc/OgoneOrderSubscription.php
793 /modules/ogone/translations/nl.php
794 /modules/ogone/nl.php
795 /modules/ps_shoppingcart/ps_shoppingcart.php
796 /src/Core/Product/Search/ProductSearchContext.php
797 /src/Core/Product/Search/ProductSearchQuery.php
798 /src/Core/Product/Search/SortOrder.php
799 /modules/ps_facetedsearch/ps_facetedsearch.php
800 /modules/ps_facetedsearch/src/Ps_FacetedsearchProductSearchProvider.php
801 /modules/ps_facetedsearch/src/Ps_FacetedsearchFiltersConverter.php
802 /modules/ps_facetedsearch/src/Ps_FacetedsearchFacetsURLSerializer.php
803 /src/Core/Product/Search/ProductSearchProviderInterface.php
804 /modules/ps_facetedsearch/src/Ps_FacetedsearchRangeAggregator.php
805 /src/Core/Product/Search/SortOrderFactory.php
806 /src/Core/Product/Search/ProductSearchResult.php
807 /src/Core/Product/Search/Facet.php
808 /src/Core/Product/Search/Filter.php
809 /src/Core/Product/Search/URLFragmentSerializer.php
810 /src/Core/Product/Search/FacetCollection.php
811 /classes/Search.php
812 /classes/Combination.php
813 /classes/stock/StockAvailable.php
814 /classes/tax/TaxManagerFactory.php
815 /classes/tax/TaxRulesTaxManager.php
816 /classes/tax/TaxManagerInterface.php
817 /classes/tax/TaxCalculator.php
818 /classes/GroupReduction.php
819 /classes/Feature.php
820 /modules/statssearch/statssearch.php
821 /classes/module/ModuleGraph.php
822 /classes/ProductAssembler.php
823 /classes/ProductPresenterFactory.php
824 /src/Adapter/Presenter/Product/ProductListingPresenter.php
825 /src/Adapter/Presenter/Product/ProductPresenter.php
826 /src/Adapter/Product/ProductColorsRetriever.php
827 /src/Adapter/HookManager.php
828 /src/Core/Product/ProductPresentationSettings.php
829 /src/Adapter/Presenter/Product/ProductListingLazyArray.php
830 /src/Adapter/Presenter/Product/ProductLazyArray.php
831 /src/Adapter/Presenter/AbstractLazyArray.php
832 /classes/Image.php
833 /vendor/doctrine/common/lib/Doctrine/Common/Util/Inflector.php
834 /vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php
835 /vendor/doctrine/inflector/lib/Doctrine/Inflector/InflectorFactory.php
836 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Language.php
837 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/InflectorFactory.php
838 /vendor/doctrine/inflector/lib/Doctrine/Inflector/GenericLanguageInflectorFactory.php
839 /vendor/doctrine/inflector/lib/Doctrine/Inflector/LanguageInflectorFactory.php
840 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Rules.php
841 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Ruleset.php
842 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformations.php
843 /vendor/doctrine/inflector/lib/Doctrine/Inflector/WordInflector.php
844 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Inflectible.php
845 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformation.php
846 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Pattern.php
847 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Patterns.php
848 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Uninflected.php
849 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitutions.php
850 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitution.php
851 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Word.php
852 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Inflector.php
853 /vendor/doctrine/inflector/lib/Doctrine/Inflector/CachedWordInflector.php
854 /vendor/doctrine/inflector/lib/Doctrine/Inflector/RulesetInflector.php
855 /var/cache/prod/smarty/compile/fb/17/cb/fb17cb44ca77ccd1c621d0a98042075e6f493ac0_2.file.facets.tpl.php
856 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php
857 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
858 /var/cache/prod/smarty/compile/8b/be/7b/8bbe7bdb06c267902dc00b81d11e54b8f7657dd8_2.file.active_filters.tpl.php
859 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php
860 /src/Core/Product/Search/Pagination.php
861 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_smartytemplatecompiler.php
862 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatecompilerbase.php
863 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_codeframe.php
864 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templateparser.php
865 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatelexer.php
866 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_literals.php
867 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree_template.php
868 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree.php
869 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_extends.php
870 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_shared_inheritance.php
871 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_compilebase.php
872 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree_tag.php
873 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_parsetree_text.php
874 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_block.php
875 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php
876 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_include.php
877 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_writefile.php
878 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/2b/02/77/2b0277e415fe63e68532507258cd7a3101d951d3_2.file.category.tpl.php
879 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/7c/6b/2b/7c6b2bd287d8e6fde3ba6eb59911a53417094b8a_2.file.product-list.tpl.php
880 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/c7/a7/66/c7a766c2bd99db15dff0d8bdb21c47ead32b2b19_2.file.layout-left-column.tpl.php
881 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/60/29/95/6029952689365bb28df91034aae93e47146dbed8_2.file.layout-both-columns.tpl.php
882 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/a0/b0/ea/a0b0eaf4dbd37c3f837eca5065a6a1e235d0bded_2.file.head.tpl.php
883 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/0c/47/a8/0c47a8fe586fa5ad803206ceb5217501948ce80a_2.file.head-jsonld.tpl.php
884 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/86/04/65/86046541ef76d4bb78238ec93a1db6a19ad16b7e_2.file.pagination-seo.tpl.php
885 /vendor/smarty/smarty/libs/plugins/modifier.replace.php
886 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/6f/d8/1b/6fd81bc0dd7d1dcf6f4160469fe640caafb7369e_2.file.stylesheets.tpl.php
887 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/24/53/c7/2453c7c4eeb0501859840667ae5137063d992f69_2.file.javascript.tpl.php
888 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/21/00/22/210022c0b319bf853ba706e81ddf51c344977b4e_2.file.product-activation.tpl.php
889 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/0c/a4/b4/0ca4b4431c82aef05e0a3b6ba2a30213df9de4d9_2.file.header.tpl.php
890 /modules/ps_contactinfo/ps_contactinfo.php
891 /var/cache/prod/smarty/compile/medio/0e/b2/11/0eb2119957cbc13b240126b3ccd8fac8f109f1e2_2.module.pscontactinfonav.tpl.php
892 /modules/ps_currencyselector/ps_currencyselector.php
893 /modules/ps_customersignin/ps_customersignin.php
894 /var/cache/prod/smarty/compile/medio/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.pscustomersigninpscustome.php
895 /src/Adapter/Cart/CartPresenter.php
896 /classes/Customization.php
897 /var/cache/prod/smarty/compile/medio/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.psshoppingcartpsshoppingc.php
898 /var/cache/prod/smarty/compile/medio/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.pssearchbarpssearchbar.tp.php
899 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_updatecache.php
900 /var/cache/prod/smarty/compile/medio/d2/80/02/d28002f30b2710b75577318a1b77566c072f9a29_2.module.pmadvancedtopmenuviewstem.cache.php
901 /var/cache/prod/smarty/cache/ADTM/2ac0d14bae30086da95d9f5223b25c2dd0a49312/4/1/8/1/medio/d0/bb/5c/d0bb5c109ae1dcda6f8b0856beb83ed24354f0f0.pmadvancedtopmenuviewstem.php
902 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/a3/db/ef/a3dbefa2b11e71b126538f264977c56790aa23ad_2.file.notifications.tpl.php
903 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/d3/f6/30/d3f630570b9bebd37a83054d4c352edf262184c8_2.file.breadcrumb.tpl.php
904 /modules/ps_categorytree/ps_categorytree.php
905 /var/cache/prod/smarty/compile/medio/89/21/00/8921007f54626fc7fe42cbff53f1d70828d3393d_2.module.pscategorytreeviewstempla.php
906 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_tplfunction.php
907 /var/cache/prod/smarty/compile/medio/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.psfacetedsearchpsfaceteds.php
908 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_if.php
909 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_private_print_expression.php
910 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/9d/ac/2e/9dac2e517e68010ce745587b91c8d073138301a6_2.file.category-header.tpl.php
911 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/2d/c3/2a/2dc32a877ca1fb4971c40a75095ad218a25df872_2.file.products-top.tpl.php
912 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/d5/b0/ff/d5b0ff955a4a87e0735454b215e7467fd1650730_2.file.sort-orders.tpl.php
913 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/91/4e/07/914e07eaa223857b0133c4dc200d37d214d5e7c6_2.file.products.tpl.php
914 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/be/13/5f/be135fc09fdb27257a0837af53fd2ccdaa1c60cc_2.file.product.tpl.php
915 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/a5/4a/02/a54a024ce5abc8eb6a38e6466cc73b783e7eb484_2.file.pagination.tpl.php
916 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/ed/b9/45/edb94544573c69613f1d519a19fb4093d778ac1e_2.file.products-bottom.tpl.php
917 /var/cache/prod/smarty/compile/mediolayouts_layout_left_column_tpl/c3/ce/1d/c3ce1d3293b183e5d322374170d5325c91460f7d_2.file.footer.tpl.php
918 /modules/ps_linklist/ps_linklist.php
919 /var/cache/prod/translations/catalogue.de-DE.NXhscRe.php
920 /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php
921 /modules/ps_linklist/src/Filter/LinkFilter.php
922 /modules/ps_linklist/src/Filter/BestSalesRouteFilter.php
923 /modules/ps_linklist/src/Filter/RouteFilterInterface.php
924 /modules/ps_linklist/src/LegacyLinkBlockRepository.php
925 /var/cache/prod/smarty/cache/ps_linklist/displayFooter/1/8/1/1/4/3/medio/80/3f/2d/803f2df27dadbc9b5743bf48005924ac89bdd0b6.pslinklistviewstemplatesh.php
926 /modules/ps_customeraccountlinks/ps_customeraccountlinks.php
927 /var/cache/prod/smarty/cache/ps_customeraccountlinks/1/8/1/1/4/3/medio/02/3b/d7/023bd7b2cbf691baf0eb5d0bbc3a420865303a26.pscustomeraccountlinkspsc.php
928 /var/cache/prod/smarty/compile/medio/ef/ec/e0/efece032b35ee93ce02ce4e78cfe3b68bae75fe4_2.file.ga4_jscart.tpl.php
929 /var/cache/prod/smarty/cache/ps_socialfollow/1/8/1/1/4/3/medio/a4/55/b5/a455b5ca3500f960f14c5291e640e871c96925b6.pssocialfollowpssocialfol.php
930 /modules/statsdata/statsdata.php
931 /classes/Guest.php
932 /classes/Connection.php
933 /classes/Page.php
934 /classes/ConnectionsSource.php