Load Time 618 ms
Querying Time 183 ms
Queries 285
Memory Peak Usage 42.7 Mb
Included Files 859 files - 9.50 Mb
PrestaShop Cache - Mb
Global vars 0.22 Mb
PrestaShop Version 1.7.8.5
PHP Version 7.4.30
MySQL Version 10.3.36-MariaDB
Memory Limit 256M
Max Execution Time 0s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0 ms 0 ms 11.76 Mb 12.1 Mb
__construct 14 ms 14 ms 1.74 Mb 15.0 Mb
init 93 ms 106 ms 8.00 Mb 22.6 Mb
checkAccess 0 ms 106 ms - Mb 22.6 Mb
setMedia 24 ms 130 ms 1.51 Mb 23.0 Mb
postProcess 0 ms 130 ms - Mb 23.0 Mb
initHeader 0 ms 130 ms - Mb 23.0 Mb
initContent 374 ms 504 ms 11.47 Mb 34.5 Mb
initFooter 0 ms 504 ms - Mb 34.5 Mb
display 114 ms 618 ms 7.80 Mb 42.7 Mb
Hook Time Memory Usage
displayProductListReviews 32 ms 1.47 Mb
DisplayHeader 23 ms 1.90 Mb
displayFooterBefore 8 ms 1.77 Mb
DisplayBeforeBodyClosingTag 7 ms 0.24 Mb
displayNav2 6 ms 0.55 Mb
displayLeftColumn 5 ms 0.11 Mb
ActionFrontControllerSetMedia 4 ms 0.45 Mb
ProductSearchProvider 4 ms 0.60 Mb
displayFooter 3 ms 0.19 Mb
DisplayGDPRConsent 3 ms 1.30 Mb
displayNav1 2 ms 0.07 Mb
displayTop 2 ms 0.07 Mb
displayNavFullWidth 1 ms 0.06 Mb
DisplayLeftColumn 1 ms - Mb
DisplayNavFullWidth 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
18 hook(s) 99 ms 8.80 Mb
Module Time Memory Usage
blockwishlist 9 ms 0.57 Mb
ps_emailsubscription 17 ms 2.00 Mb
ps_facebook 19 ms 1.23 Mb
blockreassurance 2 ms 0.21 Mb
productcomments 35 ms 1.80 Mb
ps_imageslider 4 ms 0.37 Mb
ps_searchbar 3 ms 0.40 Mb
ps_shoppingcart 4 ms 0.47 Mb
psxmarketingwithgoogle 3 ms 0.17 Mb
migrationpro 11 ms 1.02 Mb
ps_facetedsearch 8 ms 0.99 Mb
ps_contactinfo 4 ms 0.17 Mb
ps_languageselector 1 ms 0.07 Mb
ps_currencyselector 1 ms 0.09 Mb
ps_customersignin 1 ms 0.08 Mb
ps_mainmenu 6 ms 0.34 Mb
ps_categorytree 6 ms 0.17 Mb
psgdpr 5 ms 1.53 Mb
ps_socialfollow 3 ms 0.24 Mb
ps_linklist 2 ms 0.16 Mb
ps_customeraccountlinks 1 ms 0.10 Mb
statsdata 7 ms 0.29 Mb
22 module(s) 151 ms 12.46 Mb

Stopwatch SQL - 285 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 180, 12
18637 ms 365797152 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 AND ps.id_shop='1' GROUP BY p.id_product) p
10868 ms 182898576 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 43808
LIMIT 1
4246 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2925 ms 64 Yes Yes /classes/Hook.php:1183
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
2851 ms 0 /classes/Hook.php:1243
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2750 ms 241 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42512
LIMIT 1
2497 ms 1 /classes/ProductAssembler.php:95
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`)
2262 ms 444 /classes/Configuration.php:160
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42419
LIMIT 1
2178 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42412
LIMIT 1
2107 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42649
ORDER BY `position`
1773 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 9
AND nleft >= 12 AND nright <= 13
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
1767 ms 22 Yes /modules/ps_categorytree/ps_categorytree.php:149
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 = 1)
WHERE i.`id_product` = 42512
AND image_shop.`cover` = 1 LIMIT 1
1753 ms 4 /classes/Product.php:3533
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1725 ms 352 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="d6278028d1807d41a4e8f3338161c175" LIMIT 1
1722 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:168
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42572
ORDER BY `position`
1684 ms 6 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42412
ORDER BY `position`
1650 ms 6 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42788
LIMIT 1
1627 ms 1 /classes/ProductAssembler.php:95
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 = 1)
WHERE i.`id_product` = 42572
AND image_shop.`cover` = 1 LIMIT 1
1501 ms 6 /classes/Product.php:3533
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42572
LIMIT 1
1477 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 280
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1352 ms 1 Yes Yes /classes/Category.php:919
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 = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1336 ms 230 /classes/Hook.php:504
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 43808
ORDER BY `position`
1322 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1290 ms 763 /classes/Hook.php:1283
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42700
LIMIT 1
1269 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42413
LIMIT 1
1260 ms 1 /classes/ProductAssembler.php:95
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', 'en', '0')
1181 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42766
LIMIT 1
1174 ms 1 /classes/ProductAssembler.php:95
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('160843', '10', '585940996', '', '1', '1', '2022-08-17 06:04:13')
1110 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42649
LIMIT 1
1102 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 43814
LIMIT 1
1054 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42512
ORDER BY `position`
1044 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-08-17 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 42701
LIMIT 1
1018 ms 1 /classes/ProductAssembler.php:95
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 = 1)
WHERE i.`id_product` = 42412
AND image_shop.`cover` = 1 LIMIT 1
996 ms 6 /classes/Product.php:3533
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42419
ORDER BY `position`
950 ms 6 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
944 ms 763 /classes/Hook.php:1243
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42512 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42512 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
887 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42412 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42412 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
851 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42649 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42649 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
848 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42412) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
815 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 280
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
791 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Converter.php:247
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42788) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
781 ms 1 Yes Yes /classes/Product.php:4479
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
778 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42572) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
768 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42572 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42572 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
768 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 12) AND (a0.`nright` > 13) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
760 ms 199 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42412)
749 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42512) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
742 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 43808 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 43808 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
741 ms 0 /classes/Cart.php:1429
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
732 ms 1 /classes/Cart.php:4218
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2022-08-17 00:00:00" AND date_to <= "2022-08-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2022-08-17 00:00:00" AND date_from <= "2022-08-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2022-08-17 00:00:00" AND date_to > "2022-08-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
727 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (43808) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
724 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (43814) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
714 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42412) AND (b.`id_shop` = 1) LIMIT 1
709 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` = 0 AND cp.`id_product` = 42419 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42419 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
695 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42700
ORDER BY `position`
676 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42419) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
667 ms 1 Yes Yes /classes/Product.php:4479
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 = 1)
WHERE i.`id_product` = 42649
AND image_shop.`cover` = 1 LIMIT 1
665 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42788
ORDER BY `position`
661 ms 7 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42512) AND (b.`id_shop` = 1) LIMIT 1
658 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 = 'dapicart.pt' OR su.domain_ssl = 'dapicart.pt')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
654 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42413) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
647 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42766 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42766 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
643 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42766
ORDER BY `position`
638 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42572) AND (b.`id_shop` = 1) LIMIT 1
629 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
622 ms 26 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
621 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42413 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42413 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
611 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42766) AND (b.`id_shop` = 1) LIMIT 1
609 ms 1 /src/Adapter/EntityMapper.php:76
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42649
ORDER BY f.position ASC
601 ms 1 Yes /classes/Product.php:5897
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42701
ORDER BY f.position ASC
599 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42700 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42700 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
598 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42788 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42788 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
593 ms 0 /classes/Cart.php:1429
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 = 1)
WHERE i.`id_product` = 42700
AND image_shop.`cover` = 1 LIMIT 1
589 ms 4 /classes/Product.php:3533
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42512
ORDER BY f.position ASC
586 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 43814
ORDER BY `position`
579 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42700) AND (b.`id_shop` = 1) LIMIT 1
579 ms 1 /src/Adapter/EntityMapper.php:76
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42412
ORDER BY f.position ASC
577 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 280 AND ctg.`id_group` = 1 LIMIT 1
576 ms 1 /classes/Category.php:1730
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 = 1)
WHERE i.`id_product` = 43808
AND image_shop.`cover` = 1 LIMIT 1
572 ms 4 /classes/Product.php:3533
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 15 LIMIT 1
572 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42649) AND (b.`id_shop` = 1) LIMIT 1
567 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` = 0 AND cp.`id_product` = 42701 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42701 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
566 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42700) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
566 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42412) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
563 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 43808) AND (b.`id_shop` = 1) LIMIT 1
554 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42766)
553 ms 1 /classes/Product.php:3820
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42572
ORDER BY f.position ASC
553 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
552 ms 1 Yes /classes/Currency.php:709
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` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
551 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42701
ORDER BY `position`
545 ms 5 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42413) AND (b.`id_shop` = 1) LIMIT 1
545 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42413
ORDER BY `position`
544 ms 6 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 43814 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 43814 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
538 ms 0 /classes/Cart.php:1429
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2022-08-17 00:00:00" AND date_to <= "2022-08-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2022-08-17 00:00:00" AND date_from <= "2022-08-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2022-08-17 00:00:00" AND date_to > "2022-08-17 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
538 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
529 ms 1 /src/Adapter/EntityMapper.php:76
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 43814
ORDER BY f.position ASC
524 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
522 ms 64 /classes/module/Module.php:340
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
521 ms 1 /classes/Language.php:1198
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 15 LIMIT 1
519 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42766) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
516 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42512)
515 ms 1 /classes/Product.php:3820
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 43808
ORDER BY f.position ASC
514 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 764 LIMIT 1
512 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42701) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
509 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42649) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
498 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 43814) AND (b.`id_shop` = 1) LIMIT 1
492 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
481 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42572)
481 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facebook" LIMIT 1
480 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 15) LIMIT 1
479 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42700)
477 ms 1 /classes/Product.php:3820
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)
476 ms 1 /classes/Language.php:1049
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 43808)
475 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42419) AND (b.`id_shop` = 1) LIMIT 1
472 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42649 LIMIT 1
458 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42701) AND (b.`id_shop` = 1) LIMIT 1
457 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
454 ms 1 /src/Adapter/EntityMapper.php:76
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42419
ORDER BY f.position ASC
454 ms 1 Yes /classes/Product.php:5897
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` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
453 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
453 ms 7 Yes /classes/ImageType.php:109
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42766
ORDER BY f.position ASC
450 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 280) AND (b.`id_shop` = 1) LIMIT 1
445 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
434 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 280) LIMIT 1
433 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
433 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_mainmenu" LIMIT 1
432 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42788) AND (b.`id_shop` = 1) LIMIT 1
422 ms 1 /src/Adapter/EntityMapper.php:76
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42413
ORDER BY f.position ASC
417 ms 1 Yes /classes/Product.php:5897
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42788
ORDER BY f.position ASC
415 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 160843
AND `date_add` > '2022-08-17 05:34:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
414 ms 1 Yes /classes/Connection.php:154
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42649)
407 ms 1 /classes/Product.php:3820
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 = 1)
WHERE i.`id_product` = 42413
AND image_shop.`cover` = 1 LIMIT 1
400 ms 6 /classes/Product.php:3533
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 = 1)
WHERE i.`id_product` = 42788
AND image_shop.`cover` = 1 LIMIT 1
400 ms 7 /classes/Product.php:3533
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42700
ORDER BY f.position ASC
392 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42788)
391 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42413)
391 ms 1 /classes/Product.php:3820
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 = 1)
WHERE i.`id_product` = 42419
AND image_shop.`cover` = 1 LIMIT 1
390 ms 6 /classes/Product.php:3533
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
388 ms 1 /src/Adapter/EntityMapper.php:76
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 = 1)
WHERE i.`id_product` = 42766
AND image_shop.`cover` = 1 LIMIT 1
387 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42649
385 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
383 ms 88 /classes/Hook.php:301
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
377 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 43814)
372 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
368 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
367 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
365 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42701)
358 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
356 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
355 ms 1 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42419)
352 ms 1 /classes/Product.php:3820
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 = 1)
WHERE i.`id_product` = 43814
AND image_shop.`cover` = 1 LIMIT 1
344 ms 4 /classes/Product.php:3533
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 280 AND `id_shop` = 1
342 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 4 AND `id_object` = 280 LIMIT 1
337 ms 1 /classes/Page.php:83
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
334 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 15
333 ms 1 /src/Adapter/EntityMapper.php:84
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 = 1)
WHERE i.`id_product` = 42701
AND image_shop.`cover` = 1 LIMIT 1
328 ms 5 /classes/Product.php:3533
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
327 ms 88 /classes/Hook.php:353
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42512 LIMIT 1
325 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42412
325 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
322 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42512) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
322 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42412 LIMIT 1
317 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42572
316 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
315 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42572 LIMIT 1
314 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
312 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42766 LIMIT 1
312 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
311 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42412 AND id_shop=1 LIMIT 1
310 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
310 ms 1 /classes/Currency.php:1126
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 22 LIMIT 1
307 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42512
305 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
305 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42572) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
305 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42419 LIMIT 1
302 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
302 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 15) LIMIT 1
301 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
300 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
300 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
297 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 43808
296 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42649) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
296 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42512 AND id_shop=1 LIMIT 1
293 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
291 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
291 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42512 AND `id_group` = 1 LIMIT 1
290 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'pt-pt'
OR `language_code` = 'pt-pt' LIMIT 1
290 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
288 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
287 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 43814
286 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
284 ms 1 /classes/Page.php:104
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42788 AND id_shop=1 LIMIT 1
283 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
283 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
283 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
280 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'pt-pt'
OR `language_code` = 'pt-pt' LIMIT 1
280 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
279 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42419) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
278 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42419 AND id_shop=1 LIMIT 1
278 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43808) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
276 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42412 AND `id_group` = 1 LIMIT 1
275 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 280 LIMIT 1
275 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
273 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
272 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
271 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
271 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
270 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42419
269 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42766) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
269 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 32 AND `id_shop` = 1 LIMIT 1
268 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42701
264 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42788) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
260 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 13 AND `id_shop` = 1 LIMIT 1
257 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42766
254 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 15 LIMIT 1
254 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
252 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
252 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
252 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42649 AND id_shop=1 LIMIT 1
251 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
251 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_currencyselector" LIMIT 1
249 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
247 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
246 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_socialfollow" LIMIT 1
245 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42700
242 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
242 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42649 AND `id_group` = 1 LIMIT 1
241 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 60 AND `id_shop` = 1 LIMIT 1
240 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
240 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 128 LIMIT 1
239 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 15 AND `id_shop` = 1 LIMIT 1
239 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 17 AND `id_shop` = 1 LIMIT 1
237 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
236 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42413
236 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
233 ms 1 /classes/Group.php:154
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42701 AND id_shop=1 LIMIT 1
232 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
231 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42413) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
229 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
229 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42766 AND id_shop=1 LIMIT 1
228 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42413 AND id_shop=1 LIMIT 1
225 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42701) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
225 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42413 AND `id_group` = 1 LIMIT 1
225 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
225 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42788 LIMIT 1
224 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42572 AND id_shop=1 LIMIT 1
223 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42788 AND `id_group` = 1 LIMIT 1
223 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
222 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 33 AND `id_shop` = 1 LIMIT 1
222 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 128 LIMIT 1
220 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42413 LIMIT 1
220 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42700 LIMIT 1
219 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
219 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 15 LIMIT 1
218 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42700 AND `id_group` = 1 LIMIT 1
215 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
213 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43814) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
212 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 42701 LIMIT 1
211 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 42700 AND id_shop=1 LIMIT 1
210 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
210 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 43814 LIMIT 1
208 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42700) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
208 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 128 LIMIT 1
206 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 27 AND `id_shop` = 1 LIMIT 1
206 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 30 AND `id_shop` = 1 LIMIT 1
205 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 42788
204 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
203 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
203 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 15 LIMIT 1
202 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 43808 LIMIT 1
201 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 43814 AND id_shop=1 LIMIT 1
198 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 43808 AND id_shop=1 LIMIT 1
194 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
189 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customersignin" LIMIT 1
186 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42766 AND `id_group` = 1 LIMIT 1
185 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42572 AND `id_group` = 1 LIMIT 1
185 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42701 AND `id_group` = 1 LIMIT 1
182 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 280 LIMIT 1
178 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 18 AND `id_shop` = 1 LIMIT 1
176 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 42419 AND `id_group` = 1 LIMIT 1
174 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 43814 AND `id_group` = 1 LIMIT 1
174 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
165 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 28 AND `id_shop` = 1 LIMIT 1
163 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 43808 AND `id_group` = 1 LIMIT 1
163 ms 0 /classes/GroupReduction.php:156

Doubles

15 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>
12 queries
SELECT `id_product_attribute`
            FROM `ps_product_attribute`
            WHERE `id_product` = <span style="color:blue">XX</span>
12 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`
12 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>
12 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 = <span style="color:blue">XX</span>) AND (id_shop_group = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
12 queries
SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
12 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>
12 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>
12 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>
12 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;
12 queries
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,<span style="color:blue">XX</span>) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
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>)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>)
WHERE (p.`id_product` = <span style="color:blue">XX</span>)
12 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>
12 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>
12 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>
                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>
12 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>
12 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
3 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 <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 *
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>
2 queries
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = <span style="color:blue">XX</span>
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = <span style="color:blue">XX</span>
WHERE (a.`id_country` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 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>
2 queries
SELECT `id_lang` FROM `ps_lang`
                    WHERE `locale` = 'pt-pt'
                    OR `language_code` = 'pt-pt' LIMIT <span style="color:blue">XX</span>

Tables stress

51 product_shop
51 product
26 product_attribute
26 stock_available
25 cart_product
24 pack
24 product_lang
24 image
24 image_shop
24 product_attribute_shop
20 category_lang
18 module
18 module_shop
14 product_attribute_combination
12 attribute_lang
12 product_group_reduction_cache
12 attribute_group
12 feature_product
12 feature_lang
12 feature_value_lang
12 feature
12 feature_shop
12 image_lang
12 attribute
12 orders
9 country
8 category
7 hook
6 cart_rule
6 lang
5 category_shop
5 currency
5 category_group
4 shop_url
4 shop
4 country_shop
4 currency_shop
4 country_lang
4 lang_shop
3 hook_alias
3 category_product
2 product_sale
2 configuration
2 shop_group
2 group_shop
2 group
2 hook_module
2 currency_lang
1 configuration_lang
1 psgdpr_consent
1 connections
1 page_type
1 module_group
1 tax_rules_group
1 meta
1 meta_lang
1 image_type
1 tax_rule
1 group_lang
1 layered_filter_block
1 hook_module_exceptions
1 zone
1 state
1 layered_category
1 required_field
1 address_format
1 page

ObjectModel instances

Name Instances Source
Product 36 /classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
Combination 12 /classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
Category 10 /controllers/front/listing/CategoryController.php [89]
/classes/Meta.php [380]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/modules/ps_facetedsearch/src/Product/Search.php [103]
/modules/ps_categorytree/ps_categorytree.php [320]
/modules/ps_categorytree/ps_categorytree.php [323]
Country 8 /config/config.inc.php [157]
/classes/controller/FrontController.php [407]
/classes/AddressFormat.php [404]
/classes/controller/FrontController.php [1710]
/classes/AddressFormat.php [404]
/modules/ps_contactinfo/ps_contactinfo.php [102]
/classes/AddressFormat.php [404]
/modules/ps_contactinfo/ps_contactinfo.php [102]
Address 4 /classes/shop/Shop.php [469]
/classes/Product.php [3654]
/classes/Product.php [3764]
/classes/Product.php [5840]
State 3 /classes/controller/FrontController.php [1709]
/modules/ps_contactinfo/ps_contactinfo.php [91]
/modules/ps_contactinfo/ps_contactinfo.php [91]
AddressFormat 3 /classes/controller/FrontController.php [1704]
/modules/ps_contactinfo/ps_contactinfo.php [96]
/modules/ps_contactinfo/ps_contactinfo.php [96]
Language 2 /config/config.inc.php [222]
/classes/Tools.php [581]
Currency 2 /src/Adapter/Currency/CurrencyDataProvider.php [101]
/classes/controller/FrontController.php [411]
Shop 1 /config/config.inc.php [128]
Guest 1 /modules/statsdata/statsdata.php [77]
Gender 1 /classes/controller/FrontController.php [1639]
Risk 1 /classes/controller/FrontController.php [1642]
Group 1 /classes/Cart.php [248]
Cart 1 /classes/controller/FrontController.php [476]
Customer 1 /config/config.inc.php [249]
ShopGroup 1 /classes/shop/Shop.php [557]
Connection 1 /modules/statsdata/statsdata.php [111]

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/paragonie/random_compat/lib/random.php
11 /vendor/symfony/polyfill-php70/bootstrap.php
12 /vendor/symfony/polyfill-php72/bootstrap.php
13 /vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14 /vendor/symfony/polyfill-intl-idn/bootstrap.php
15 /vendor/react/promise/src/functions_include.php
16 /vendor/react/promise/src/functions.php
17 /vendor/symfony/polyfill-ctype/bootstrap.php
18 /vendor/symfony/polyfill-mbstring/bootstrap.php
19 /vendor/symfony/polyfill-iconv/bootstrap.php
20 /vendor/swiftmailer/swiftmailer/lib/swift_required.php
21 /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
22 /vendor/symfony/polyfill-php73/bootstrap.php
23 /vendor/symfony/polyfill-php56/bootstrap.php
24 /vendor/symfony/polyfill-intl-icu/bootstrap.php
25 /vendor/symfony/polyfill-apcu/bootstrap.php
26 /vendor/markbaker/matrix/classes/src/functions/adjoint.php
27 /vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
28 /vendor/markbaker/matrix/classes/src/functions/cofactors.php
29 /vendor/markbaker/matrix/classes/src/functions/determinant.php
30 /vendor/markbaker/matrix/classes/src/functions/diagonal.php
31 /vendor/markbaker/matrix/classes/src/functions/identity.php
32 /vendor/markbaker/matrix/classes/src/functions/inverse.php
33 /vendor/markbaker/matrix/classes/src/functions/minors.php
34 /vendor/markbaker/matrix/classes/src/functions/trace.php
35 /vendor/markbaker/matrix/classes/src/functions/transpose.php
36 /vendor/markbaker/matrix/classes/src/operations/add.php
37 /vendor/markbaker/matrix/classes/src/operations/directsum.php
38 /vendor/markbaker/matrix/classes/src/operations/subtract.php
39 /vendor/markbaker/matrix/classes/src/operations/multiply.php
40 /vendor/markbaker/matrix/classes/src/operations/divideby.php
41 /vendor/markbaker/matrix/classes/src/operations/divideinto.php
42 /vendor/markbaker/complex/classes/src/functions/abs.php
43 /vendor/markbaker/complex/classes/src/functions/acos.php
44 /vendor/markbaker/complex/classes/src/functions/acosh.php
45 /vendor/markbaker/complex/classes/src/functions/acot.php
46 /vendor/markbaker/complex/classes/src/functions/acoth.php
47 /vendor/markbaker/complex/classes/src/functions/acsc.php
48 /vendor/markbaker/complex/classes/src/functions/acsch.php
49 /vendor/markbaker/complex/classes/src/functions/argument.php
50 /vendor/markbaker/complex/classes/src/functions/asec.php
51 /vendor/markbaker/complex/classes/src/functions/asech.php
52 /vendor/markbaker/complex/classes/src/functions/asin.php
53 /vendor/markbaker/complex/classes/src/functions/asinh.php
54 /vendor/markbaker/complex/classes/src/functions/atan.php
55 /vendor/markbaker/complex/classes/src/functions/atanh.php
56 /vendor/markbaker/complex/classes/src/functions/conjugate.php
57 /vendor/markbaker/complex/classes/src/functions/cos.php
58 /vendor/markbaker/complex/classes/src/functions/cosh.php
59 /vendor/markbaker/complex/classes/src/functions/cot.php
60 /vendor/markbaker/complex/classes/src/functions/coth.php
61 /vendor/markbaker/complex/classes/src/functions/csc.php
62 /vendor/markbaker/complex/classes/src/functions/csch.php
63 /vendor/markbaker/complex/classes/src/functions/exp.php
64 /vendor/markbaker/complex/classes/src/functions/inverse.php
65 /vendor/markbaker/complex/classes/src/functions/ln.php
66 /vendor/markbaker/complex/classes/src/functions/log2.php
67 /vendor/markbaker/complex/classes/src/functions/log10.php
68 /vendor/markbaker/complex/classes/src/functions/negative.php
69 /vendor/markbaker/complex/classes/src/functions/pow.php
70 /vendor/markbaker/complex/classes/src/functions/rho.php
71 /vendor/markbaker/complex/classes/src/functions/sec.php
72 /vendor/markbaker/complex/classes/src/functions/sech.php
73 /vendor/markbaker/complex/classes/src/functions/sin.php
74 /vendor/markbaker/complex/classes/src/functions/sinh.php
75 /vendor/markbaker/complex/classes/src/functions/sqrt.php
76 /vendor/markbaker/complex/classes/src/functions/tan.php
77 /vendor/markbaker/complex/classes/src/functions/tanh.php
78 /vendor/markbaker/complex/classes/src/functions/theta.php
79 /vendor/markbaker/complex/classes/src/operations/add.php
80 /vendor/markbaker/complex/classes/src/operations/subtract.php
81 /vendor/markbaker/complex/classes/src/operations/multiply.php
82 /vendor/markbaker/complex/classes/src/operations/divideby.php
83 /vendor/markbaker/complex/classes/src/operations/divideinto.php
84 /vendor/jakeasmith/http_build_url/src/http_build_url.php
85 /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
86 /vendor/ircmaxell/password-compat/lib/password.php
87 /vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
88 /app/AppKernel.php
89 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php
90 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/KernelInterface.php
91 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernelInterface.php
92 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/RebootableInterface.php
93 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/TerminableInterface.php
94 /config/alias.php
95 /classes/PrestaShopAutoload.php
96 /var/cache/dev/class_index.php
97 /config/bootstrap.php
98 /src/Core/ContainerBuilder.php
99 /src/Core/Foundation/IoC/Container.php
100 /src/Adapter/ServiceLocator.php
101 /vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
102 /var/cache/dev/appParameters.php
105 /classes/controller/Controller.php
107 /classes/ObjectModel.php
108 /src/Core/Foundation/Database/EntityInterface.php
110 /classes/db/Db.php
112 /classes/Hook.php
114 /classes/module/Module.php
115 /src/Core/Module/ModuleInterface.php
117 /classes/Tools.php
118 /classes/Context.php
119 /classes/shop/Shop.php
120 /classes/db/DbPDO.php
121 /classes/AddressFormat.php
122 /classes/Configuration.php
123 /classes/Validate.php
124 /classes/cache/Cache.php
125 /src/Adapter/EntityMapper.php
126 /classes/db/DbQuery.php
127 /src/Core/Addon/Theme/ThemeManagerBuilder.php
128 /src/Adapter/Configuration.php
129 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
130 /src/Core/Domain/Configuration/ShopConfigurationInterface.php
131 /src/Core/ConfigurationInterface.php
132 /src/Core/Addon/Theme/ThemeRepository.php
133 /src/Core/Addon/AddonRepositoryInterface.php
134 /src/Core/Domain/Shop/ValueObject/ShopConstraint.php
135 /src/Core/Addon/Theme/Theme.php
136 /src/Core/Addon/AddonInterface.php
137 /vendor/shudrum/array-finder/ArrayFinder.php
138 /config/defines_uri.inc.php
139 /classes/Language.php
140 /src/Core/Language/LanguageInterface.php
141 /classes/Country.php
142 /classes/PrestaShopCollection.php
143 /classes/shop/ShopGroup.php
144 /classes/Cookie.php
145 /classes/PhpEncryption.php
146 /vendor/defuse/php-encryption/src/Core.php
147 /classes/PhpEncryptionEngine.php
148 /vendor/defuse/php-encryption/src/Key.php
149 /vendor/defuse/php-encryption/src/Encoding.php
150 /src/Core/Session/SessionHandler.php
151 /src/Core/Session/SessionHandlerInterface.php
152 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Session.php
153 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionInterface.php
154 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/PhpBridgeSessionStorage.php
155 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/NativeSessionStorage.php
156 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/SessionStorageInterface.php
157 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/MetadataBag.php
158 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionBagInterface.php
159 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Proxy/SessionHandlerProxy.php
160 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Proxy/AbstractProxy.php
161 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/StrictSessionHandler.php
162 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/AbstractSessionHandler.php
163 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Attribute/AttributeBag.php
164 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Attribute/AttributeBagInterface.php
165 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionBagProxy.php
166 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Flash/FlashBag.php
167 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Flash/FlashBagInterface.php
168 /config/smarty.config.inc.php
169 /classes/Smarty/SmartyDev.php
170 /vendor/smarty/smarty/libs/Smarty.class.php
171 /vendor/smarty/smarty/libs/Autoloader.php
172 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php
173 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php
174 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
175 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
176 /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php
177 /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php
178 /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php
179 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
180 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php
181 /config/smartyfront.config.inc.php
182 /classes/Smarty/SmartyResourceModule.php
183 /vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php
184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php
185 /classes/Smarty/SmartyResourceParent.php
186 /classes/Smarty/SmartyLazyRegister.php
187 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php
188 /vendor/smarty/smarty/libs/plugins/modifier.truncate.php
189 /classes/Customer.php
190 /classes/Group.php
191 /classes/Link.php
192 /override/classes/Link.php
193 /classes/shop/ShopUrl.php
194 /classes/Dispatcher.php
195 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Request.php
196 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/FileBag.php
197 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ServerBag.php
198 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/HeaderBag.php
199 /src/Adapter/SymfonyContainer.php
200 /vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
201 /config/db_slave_server.inc.php
202 /controllers/front/listing/CategoryController.php
203 /classes/controller/ProductListingFrontController.php
204 /classes/controller/ProductPresentingFrontController.php
205 /classes/controller/FrontController.php
206 /src/PrestaShopBundle/Translation/TranslatorComponent.php
207 /vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
208 /vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
209 /vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
210 /src/PrestaShopBundle/Translation/TranslatorInterface.php
211 /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
212 /src/PrestaShopBundle/Translation/TranslatorLanguageTrait.php
213 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatter.php
214 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatterInterface.php
215 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/ChoiceMessageFormatterInterface.php
216 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageSelector.php
217 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
218 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
219 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
220 /vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
221 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
222 /var/cache/dev/translations/catalogue.pt-PT.NXhscRe.php
223 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
224 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
225 /vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
226 /src/Adapter/Presenter/Object/ObjectPresenter.php
227 /src/Adapter/Presenter/PresenterInterface.php
228 /src/Adapter/Presenter/Cart/CartPresenter.php
229 /src/Adapter/Product/PriceFormatter.php
230 /src/Adapter/Image/ImageRetriever.php
231 /classes/tax/TaxConfiguration.php
232 /classes/Smarty/TemplateFinder.php
233 /classes/assets/StylesheetManager.php
234 /classes/assets/AbstractAssetManager.php
235 /src/Adapter/Assets/AssetUrlGeneratorTrait.php
236 /classes/assets/JavascriptManager.php
237 /classes/assets/CccReducer.php
238 /classes/Category.php
239 /classes/webservice/WebserviceRequest.php
240 /src/Adapter/ContainerBuilder.php
241 /src/Adapter/Environment.php
242 /src/Core/EnvironmentInterface.php
243 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceChecker.php
244 /vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerInterface.php
245 /vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Setup.php
246 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ArrayCache.php
247 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
248 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
249 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
250 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
251 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiOperationCache.php
252 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
253 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiDeleteCache.php
254 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
255 /vendor/doctrine/orm/lib/Doctrine/ORM/Configuration.php
256 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Configuration.php
257 /vendor/doctrine/persistence/lib/Doctrine/Persistence/Mapping/Driver/MappingDriver.php
258 /vendor/doctrine/persistence/lib/Doctrine/Common/Persistence/Mapping/Driver/MappingDriver.php
259 /vendor/doctrine/persistence/lib/Doctrine/Persistence/Mapping/ClassMetadata.php
260 /vendor/doctrine/persistence/lib/Doctrine/Common/Persistence/Mapping/ClassMetadata.php
261 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php
262 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php
263 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Annotation.php
264 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Entity.php
265 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embeddable.php
266 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embedded.php
267 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/MappedSuperclass.php
268 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/InheritanceType.php
269 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorColumn.php
270 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorMap.php
271 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Id.php
272 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/GeneratedValue.php
273 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Version.php
274 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumn.php
275 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumns.php
276 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Column.php
277 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToOne.php
278 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToMany.php
279 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToOne.php
280 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToMany.php
281 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Table.php
282 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UniqueConstraint.php
283 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Index.php
284 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinTable.php
285 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SequenceGenerator.php
286 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/CustomIdGenerator.php
287 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ChangeTrackingPolicy.php
288 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OrderBy.php
289 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQueries.php
290 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQuery.php
291 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/HasLifecycleCallbacks.php
292 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PrePersist.php
293 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostPersist.php
294 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreUpdate.php
295 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostUpdate.php
296 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreRemove.php
297 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostRemove.php
298 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostLoad.php
299 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreFlush.php
300 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/FieldResult.php
301 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ColumnResult.php
302 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityResult.php
303 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQuery.php
304 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQueries.php
305 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMapping.php
306 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMappings.php
307 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverride.php
308 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverrides.php
309 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverride.php
310 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverrides.php
311 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityListeners.php
312 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Cache.php
313 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php
314 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php
315 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php
316 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php
317 /vendor/doctrine/lexer/lib/Doctrine/Common/Lexer/AbstractLexer.php
318 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php
319 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/CachedReader.php
320 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/AnnotationDriver.php
321 /vendor/doctrine/persistence/lib/Doctrine/Persistence/Mapping/Driver/AnnotationDriver.php
322 /vendor/doctrine/persistence/lib/Doctrine/Common/Persistence/Mapping/Driver/AnnotationDriver.php
323 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/FileResource.php
324 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceInterface.php
325 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ResourceInterface.php
326 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ComposerResource.php
327 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/DirectoryResource.php
328 /vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ReflectionClassResource.php
329 /var/cache/dev/FrontContainer.php
330 /src/Adapter/Container/LegacyContainer.php
331 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
332 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
333 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
334 /vendor/psr/container/src/ContainerInterface.php
335 /src/Adapter/Container/LegacyContainerInterface.php
336 /modules/ps_imageslider/vendor/autoload.php
337 /modules/ps_imageslider/vendor/composer/autoload_real.php
338 /modules/ps_imageslider/vendor/composer/autoload_static.php
339 /modules/ps_searchbar/vendor/autoload.php
340 /modules/ps_searchbar/vendor/composer/autoload_real.php
341 /modules/ps_searchbar/vendor/composer/autoload_static.php
342 /modules/ps_wirepayment/vendor/autoload.php
343 /modules/ps_wirepayment/vendor/composer/autoload_real.php
344 /modules/ps_wirepayment/vendor/composer/autoload_static.php
345 /modules/statssales/vendor/autoload.php
346 /modules/statssales/vendor/composer/autoload_real.php
347 /modules/statssales/vendor/composer/autoload_static.php
348 /modules/gamification/vendor/autoload.php
349 /modules/gamification/vendor/composer/autoload_real.php
350 /modules/gamification/vendor/composer/autoload_static.php
351 /modules/psaddonsconnect/vendor/autoload.php
352 /modules/psaddonsconnect/vendor/composer/autoload_real.php
353 /modules/psaddonsconnect/vendor/composer/autoload_static.php
354 /modules/psgdpr/vendor/autoload.php
355 /modules/psgdpr/vendor/composer/autoload_real.php
356 /modules/psgdpr/vendor/composer/autoload_static.php
357 /modules/ps_mbo/vendor/autoload.php
358 /modules/ps_mbo/vendor/composer/autoload_real.php
359 /modules/ps_mbo/vendor/composer/autoload_static.php
360 /modules/ps_buybuttonlite/vendor/autoload.php
361 /modules/ps_buybuttonlite/vendor/composer/autoload_real.php
362 /modules/ps_buybuttonlite/vendor/composer/autoload_static.php
363 /modules/ps_metrics/vendor/autoload.php
364 /modules/ps_metrics/vendor/composer/autoload_real.php
365 /modules/ps_metrics/vendor/composer/autoload_static.php
366 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment.php
367 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/Client.php
368 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/Consumer.php
369 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/QueueConsumer.php
370 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/Consumer/File.php
371 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/Consumer/ForkCurl.php
372 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/Consumer/LibCurl.php
373 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/Consumer/Socket.php
374 /modules/ps_metrics/vendor/segmentio/analytics-php/lib/Segment/Version.php
375 /modules/ps_facebook/vendor/autoload.php
376 /modules/ps_facebook/vendor/composer/autoload_real.php
377 /modules/ps_facebook/vendor/composer/platform_check.php
378 /modules/ps_facebook/vendor/composer/autoload_static.php
379 /modules/ps_facebook/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php
380 /modules/ps_facebook/vendor/lcobucci/jwt/compat/class-aliases.php
381 /modules/ps_facebook/vendor/lcobucci/jwt/src/Token.php
382 /modules/ps_facebook/vendor/lcobucci/jwt/src/Signature.php
383 /modules/ps_facebook/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
384 /modules/ps_facebook/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
385 /modules/ps_facebook/vendor/facebook/graph-sdk/src/Facebook/polyfills.php
386 /modules/psxmarketingwithgoogle/vendor/autoload.php
387 /modules/psxmarketingwithgoogle/vendor/composer/autoload_real.php
388 /modules/psxmarketingwithgoogle/vendor/composer/autoload_static.php
389 /modules/psxmarketingwithgoogle/vendor/symfony/polyfill-php80/bootstrap.php
390 /modules/blockreassurance/vendor/autoload.php
391 /modules/blockreassurance/vendor/composer/autoload_real.php
392 /modules/blockreassurance/vendor/composer/autoload_static.php
393 /modules/ps_facetedsearch/vendor/autoload.php
394 /modules/ps_facetedsearch/vendor/composer/autoload_real.php
395 /modules/ps_facetedsearch/vendor/composer/autoload_static.php
396 /src/Core/Localization/Locale/Repository.php
397 /src/Core/Localization/Locale/RepositoryInterface.php
398 /src/Core/Localization/CLDR/LocaleRepository.php
399 /src/Core/Localization/CLDR/LocaleDataSource.php
400 /src/Core/Localization/CLDR/DataLayer/LocaleCache.php
401 /src/Core/Data/Layer/AbstractDataLayer.php
402 /src/Core/Localization/CLDR/LocaleDataLayerInterface.php
403 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/FilesystemAdapter.php
404 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AbstractAdapter.php
405 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AdapterInterface.php
406 /vendor/psr/cache/src/CacheItemPoolInterface.php
407 /vendor/psr/log/Psr/Log/LoggerAwareInterface.php
408 /vendor/symfony/symfony/src/Symfony/Component/Cache/ResettableInterface.php
409 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/AbstractTrait.php
410 /vendor/psr/log/Psr/Log/LoggerAwareTrait.php
411 /vendor/symfony/symfony/src/Symfony/Component/Cache/PruneableInterface.php
412 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemTrait.php
413 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemCommonTrait.php
414 /vendor/symfony/symfony/src/Symfony/Component/Cache/CacheItem.php
415 /vendor/psr/cache/src/CacheItemInterface.php
416 /src/Core/Localization/CLDR/DataLayer/LocaleReference.php
417 /src/Core/Localization/CLDR/Reader.php
418 /src/Core/Localization/CLDR/ReaderInterface.php
419 /src/Core/Localization/Currency/Repository.php
420 /src/Core/Localization/Currency/RepositoryInterface.php
421 /src/Core/Localization/Currency/CurrencyDataSource.php
422 /src/Core/Localization/Currency/DataSourceInterface.php
423 /src/Core/Localization/Currency/DataLayer/CurrencyCache.php
424 /src/Core/Localization/Currency/CurrencyDataLayerInterface.php
425 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/ArrayAdapter.php
426 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/ArrayTrait.php
427 /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php
428 /src/Adapter/Currency/CurrencyDataProvider.php
429 /src/Core/Currency/CurrencyDataProviderInterface.php
430 /src/Adapter/LegacyContext.php
431 /src/Adapter/Tools.php
432 /src/Core/Localization/Currency/DataLayer/CurrencyReference.php
433 /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php
434 /vendor/prestashop/decimal/src/Operation/Rounding.php
435 /src/Core/Localization/Locale.php
436 /src/Core/Localization/LocaleInterface.php
437 /src/Core/Localization/Specification/Price.php
438 /src/Core/Localization/Specification/Number.php
439 /src/Core/Localization/Specification/NumberInterface.php
440 /src/Core/Localization/Specification/Factory.php
441 /src/Core/Localization/CLDR/LocaleData.php
442 /src/Core/Localization/CLDR/NumberSymbolsData.php
443 /src/Core/Localization/CLDR/CurrencyData.php
444 /src/Core/Localization/CLDR/Locale.php
445 /src/Core/Localization/CLDR/LocaleInterface.php
446 /src/Core/Localization/Specification/NumberSymbolList.php
447 /classes/Currency.php
448 /src/Core/Localization/Currency/LocalizedCurrencyId.php
449 /src/Core/Localization/Currency/CurrencyData.php
450 /src/Core/Localization/Currency/CurrencyCollection.php
451 /src/Core/Localization/Currency.php
452 /src/Core/Localization/CurrencyInterface.php
453 /src/Core/Localization/Specification/NumberCollection.php
454 /src/Core/Localization/Number/Formatter.php
455 /vendor/symfony/symfony/src/Symfony/Component/Debug/Debug.php
456 /vendor/symfony/symfony/src/Symfony/Component/Debug/ExceptionHandler.php
457 /vendor/symfony/symfony/src/Symfony/Component/Debug/ErrorHandler.php
458 /vendor/psr/log/Psr/Log/LogLevel.php
459 /vendor/symfony/symfony/src/Symfony/Component/Debug/BufferingLogger.php
460 /vendor/psr/log/Psr/Log/AbstractLogger.php
461 /vendor/psr/log/Psr/Log/LoggerInterface.php
462 /vendor/symfony/symfony/src/Symfony/Component/Debug/DebugClassLoader.php
463 /classes/Cart.php
464 /src/Adapter/AddressFactory.php
465 /classes/CartRule.php
466 /classes/Product.php
467 /src/Core/Domain/Product/ValueObject/RedirectType.php
468 /src/Core/Util/DateTime/DateTime.php
469 /src/Core/Domain/Product/Stock/ValueObject/OutOfStockType.php
470 /classes/Pack.php
471 /src/Core/Domain/Product/Pack/ValueObject/PackStockType.php
472 /src/Core/Domain/Product/ValueObject/ProductType.php
473 /src/Core/Domain/Product/ValueObject/Reference.php
474 /src/Core/Domain/Product/ValueObject/Ean13.php
475 /src/Core/Domain/Product/ValueObject/Isbn.php
476 /src/Core/Domain/Product/ValueObject/Upc.php
477 /src/Core/Domain/Product/ProductSettings.php
478 /src/Core/Domain/Shop/ValueObject/ShopId.php
479 /modules/blockwishlist/blockwishlist.php
480 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php
481 /vendor/smarty/smarty/libs/sysplugins/smarty_data.php
482 /src/PrestaShopBundle/Translation/DomainNormalizer.php
483 /classes/Media.php
484 /modules/ps_emailsubscription/ps_emailsubscription.php
485 /src/Core/Module/WidgetInterface.php
486 /src/Adapter/Localization/LegacyTranslator.php
487 /classes/Translate.php
488 /modules/ps_facebook/ps_facebook.php
489 /modules/ps_facebook/classes/Config/Config.php
490 /modules/ps_facebook/translations/pt.php
491 /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php
492 /modules/ps_facebook/vendor/prestashop/module-lib-cache-directory-provider/src/Cache/CacheDirectoryProvider.php
493 /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ContainerProvider.php
494 /var/cache/dev/Ps_facebookFrontContainer.php
495 /modules/ps_facebook/classes/Buffer/TemplateBuffer.php
496 /modules/blockreassurance/blockreassurance.php
497 /classes/ProductDownload.php
498 /classes/tax/Tax.php
499 /src/Core/Localization/CLDR/ComputingPrecision.php
500 /src/Core/Localization/CLDR/ComputingPrecisionInterface.php
501 /src/Core/Cart/Calculator.php
502 /src/Core/Cart/CartRowCollection.php
503 /src/Core/Cart/Fees.php
504 /src/Core/Cart/AmountImmutable.php
505 /src/Core/Cart/CartRuleCollection.php
506 /src/Core/Cart/CartRuleCalculator.php
507 /src/Adapter/Product/PriceCalculator.php
508 /classes/order/Order.php
509 /src/Core/Cart/CartRow.php
510 /vendor/prestashop/decimal/src/DecimalNumber.php
511 /vendor/prestashop/decimal/src/Builder.php
512 /classes/Gender.php
513 /classes/Risk.php
514 /classes/Meta.php
515 /classes/Address.php
516 /classes/ImageType.php
517 /src/Core/Addon/Module/ModuleManagerBuilder.php
518 /src/Core/Util/File/YamlParser.php
519 /var/cache/dev/yaml/2334cec7f0e3ba843965027b63280f42.php
520 /var/cache/dev/yaml/edf73473a46c60c8fb779e6dd2e45245.php
521 /src/PrestaShopBundle/Service/DataProvider/Marketplace/ApiClient.php
522 /vendor/guzzlehttp/guzzle/src/Client.php
523 /vendor/guzzlehttp/guzzle/src/ClientInterface.php
524 /vendor/guzzlehttp/guzzle/src/Event/HasEmitterInterface.php
525 /vendor/guzzlehttp/guzzle/src/Event/HasEmitterTrait.php
526 /vendor/guzzlehttp/guzzle/src/Url.php
527 /vendor/guzzlehttp/guzzle/src/Utils.php
528 /vendor/guzzlehttp/guzzle/src/Message/MessageFactory.php
529 /vendor/guzzlehttp/guzzle/src/Message/MessageFactoryInterface.php
530 /vendor/guzzlehttp/guzzle/src/Event/ListenerAttacherTrait.php
531 /vendor/guzzlehttp/guzzle/src/Subscriber/HttpError.php
532 /vendor/guzzlehttp/guzzle/src/Event/SubscriberInterface.php
533 /vendor/guzzlehttp/guzzle/src/Subscriber/Redirect.php
534 /vendor/guzzlehttp/ringphp/src/Client/CurlHandler.php
535 /vendor/guzzlehttp/ringphp/src/Client/CurlFactory.php
536 /vendor/guzzlehttp/ringphp/src/Client/CurlMultiHandler.php
537 /vendor/guzzlehttp/ringphp/src/Client/Middleware.php
538 /vendor/guzzlehttp/ringphp/src/Client/StreamHandler.php
539 /vendor/guzzlehttp/guzzle/src/RequestFsm.php
540 /app/config/parameters.php
541 /src/Adapter/Module/ModuleZipManager.php
542 /src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php
543 /vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcherInterface.php
544 /src/Core/Hook/HookDispatcherInterface.php
545 /src/Adapter/Addons/AddonsDataProvider.php
546 /src/PrestaShopBundle/Service/DataProvider/Admin/AddonsInterface.php
547 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
548 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
549 /src/Adapter/LegacyLogger.php
550 /src/PrestaShopBundle/Service/DataProvider/Admin/CategoriesProvider.php
551 /src/Adapter/Module/ModuleDataProvider.php
552 /src/Adapter/Module/AdminModuleDataProvider.php
553 /src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php
554 /vendor/symfony/symfony/src/Symfony/Component/Config/FileLocator.php
555 /vendor/symfony/symfony/src/Symfony/Component/Config/FileLocatorInterface.php
556 /vendor/symfony/symfony/src/Symfony/Component/Routing/Loader/YamlFileLoader.php
557 /vendor/symfony/symfony/src/Symfony/Component/Config/Loader/FileLoader.php
558 /vendor/symfony/symfony/src/Symfony/Component/Config/Loader/Loader.php
559 /vendor/symfony/symfony/src/Symfony/Component/Config/Loader/LoaderInterface.php
560 /vendor/symfony/symfony/src/Symfony/Component/Routing/Router.php
561 /vendor/symfony/symfony/src/Symfony/Component/Routing/RouterInterface.php
562 /vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/UrlMatcherInterface.php
563 /vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContextAwareInterface.php
564 /vendor/symfony/symfony/src/Symfony/Component/Routing/Generator/UrlGeneratorInterface.php
565 /vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/RequestMatcherInterface.php
566 /vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContext.php
567 /src/Adapter/Module/ModuleDataUpdater.php
568 /src/Core/Addon/Module/ModuleManager.php
569 /src/Core/Addon/AddonManagerInterface.php
570 /src/Core/Addon/Module/ModuleRepository.php
571 /src/Core/Addon/Module/ModuleRepositoryInterface.php
572 /vendor/symfony/symfony/src/Symfony/Component/Finder/Finder.php
573 /src/Adapter/Cache/Clearer/SymfonyCacheClearer.php
574 /src/Core/Cache/Clearer/CacheClearerInterface.php
575 /classes/State.php
576 /src/Core/Filter/FrontEndObject/MainFilter.php
577 /src/Core/Filter/FilterInterface.php
578 /src/Core/Filter/FrontEndObject/CartFilter.php
579 /src/Core/Filter/HashMapWhitelistFilter.php
580 /src/Core/Filter/CollectionFilter.php
581 /src/Core/Filter/FrontEndObject/ProductFilter.php
582 /src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php
583 /src/Core/Filter/FrontEndObject/CustomerFilter.php
584 /src/Core/Filter/FrontEndObject/ShopFilter.php
585 /src/Core/Filter/FrontEndObject/ConfigurationFilter.php
586 /classes/Smarty/SmartyDevTemplate.php
587 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
588 /var/cache/dev/smarty/compile/classic/53/1f/f5/531ff5fadbab34ae9adf28c596f08da4ca8fffe0_2.module.blockwishlistviewstemplat.php
589 /var/cache/dev/smarty/compile/classic/b3/9f/fe/b39ffe0e9a6e5e655319605fb4fac018757bed47_2.module.blockwishlistviewstemplat.php
590 /var/cache/dev/smarty/compile/classic/d8/d0/86/d8d086f3098974d41bc92b06c33cf9e584313501_2.module.blockwishlistviewstemplat.php
591 /var/cache/dev/smarty/compile/classic/f9/93/73/f9937302c902c18a7e92f61a7bb91ac32c58d2fe_2.module.blockwishlistviewstemplat.php
592 /var/cache/dev/smarty/compile/classic/99/ff/6f/99ff6f99ecd074931a71deddfe65081482db8401_2.module.blockwishlistviewstemplat.php
593 /var/cache/dev/smarty/compile/classic/a6/cf/26/a6cf26c62a3d814aa3a70f19a62034bfdce54c8a_2.module.blockwishlistviewstemplat.php
594 /modules/productcomments/productcomments.php
595 /modules/ps_imageslider/ps_imageslider.php
596 /modules/ps_imageslider/Ps_HomeSlide.php
597 /modules/ps_searchbar/ps_searchbar.php
598 /modules/ps_shoppingcart/ps_shoppingcart.php
599 /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php
600 /modules/ps_facebook/classes/Config/Env.php
601 /modules/ps_facebook/classes/Handler/ErrorHandler/ModuleFilteredRavenClient.php
602 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Client.php
603 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Util.php
604 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Compat.php
605 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor/SanitizeDataProcessor.php
606 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor.php
607 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Context.php
608 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs.php
609 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Serializer.php
610 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ReprSerializer.php
611 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/TransactionStack.php
612 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs/ErrorHandler.php
613 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Stacktrace.php
614 /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ErrorHandler.php
615 /modules/ps_facebook/classes/Dispatcher/EventDispatcher.php
616 /modules/ps_facebook/classes/Handler/ApiConversionHandler.php
617 /modules/ps_facebook/classes/Adapter/ConfigurationAdapter.php
618 /modules/ps_facebook/classes/Factory/ContextFactory.php
619 /modules/ps_facebook/classes/API/FacebookClient.php
620 /modules/ps_facebook/classes/Factory/FacebookEssentialsApiClientFactory.php
621 /modules/ps_facebook/classes/Factory/ApiClientFactoryInterface.php
622 /modules/ps_facebook/classes/Provider/AccessTokenProvider.php
623 /modules/ps_facebook/classes/Factory/PsApiClientFactory.php
624 /modules/ps_metrics/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php
625 /modules/ps_metrics/vendor/prestashop/prestashop-accounts-installer/src/Installer/Installer.php
626 /modules/ps_facebook/classes/API/EventSubscriber/AccountSuspendedSubscriber.php
627 /modules/ps_facebook/classes/Handler/ConfigurationHandler.php
628 /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Api.php
629 /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Session.php
630 /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/SessionInterface.php
631 /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/ApiConfig.php
632 /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Http/Client.php
633 /modules/ps_facebook/classes/Handler/PixelHandler.php
634 /modules/ps_facebook/classes/Provider/EventDataProvider.php
635 /modules/ps_facebook/classes/Adapter/ToolsAdapter.php
636 /modules/ps_facebook/classes/Repository/ProductRepository.php
637 /modules/ps_facebook/classes/Provider/ProductAvailabilityProvider.php
638 /modules/ps_facebook/classes/Provider/ProductAvailabilityProviderInterface.php
639 /modules/ps_facebook/classes/Repository/GoogleCategoryRepository.php
640 /modules/ps_facebook/classes/Provider/GoogleCategoryProvider.php
641 /modules/ps_facebook/classes/Provider/GoogleCategoryProviderInterface.php
642 /modules/psxmarketingwithgoogle/psxmarketingwithgoogle.php
643 /modules/psxmarketingwithgoogle/translations/pt.php
644 /var/cache/dev/PsxmarketingwithgoogleFrontContainer.php
645 /modules/psxmarketingwithgoogle/classes/Adapter/ConfigurationAdapter.php
646 /modules/psxmarketingwithgoogle/classes/Factory/ContextFactory.php
647 /modules/psxmarketingwithgoogle/classes/config/Config.php
648 /modules/psxmarketingwithgoogle/classes/Handler/RemarketingHookHandler.php
649 /modules/psxmarketingwithgoogle/classes/Buffer/TemplateBuffer.php
650 /modules/migrationpro/migrationpro.php
651 /modules/migrationpro/classes/MigrationProMapping.php
652 /modules/migrationpro/classes/MigrationProProcess.php
653 /modules/migrationpro/classes/MigrationProData.php
654 /modules/migrationpro/classes/MigrationProMigratedData.php
655 /modules/migrationpro/classes/EDClient.php
656 /modules/migrationpro/classes/EDQuery.php
657 /modules/migrationpro/classes/EDImport.php
658 /src/Core/Product/Search/ProductSearchContext.php
659 /src/Core/Product/Search/ProductSearchQuery.php
660 /src/Core/Product/Search/SortOrder.php
661 /modules/ps_facetedsearch/ps_facetedsearch.php
662 /modules/ps_facetedsearch/src/HookDispatcher.php
663 /modules/ps_facetedsearch/src/Hook/Attribute.php
664 /modules/ps_facetedsearch/src/Hook/AbstractHook.php
665 /modules/ps_facetedsearch/src/Hook/AttributeGroup.php
666 /modules/ps_facetedsearch/src/Hook/Category.php
667 /modules/ps_facetedsearch/src/Hook/Configuration.php
668 /modules/ps_facetedsearch/src/Hook/Design.php
669 /modules/ps_facetedsearch/src/Hook/Feature.php
670 /modules/ps_facetedsearch/src/Form/Feature/FormModifier.php
671 /modules/ps_facetedsearch/src/Form/Feature/FormDataProvider.php
672 /modules/ps_facetedsearch/src/Hook/FeatureValue.php
673 /modules/ps_facetedsearch/src/Hook/Product.php
674 /modules/ps_facetedsearch/src/Hook/ProductSearch.php
675 /modules/ps_facetedsearch/src/Hook/SpecificPrice.php
676 /modules/ps_facetedsearch/src/URLSerializer.php
677 /modules/ps_facetedsearch/src/Filters/DataAccessor.php
678 /modules/ps_facetedsearch/src/Product/SearchProvider.php
679 /src/Core/Product/Search/FacetsRendererInterface.php
680 /src/Core/Product/Search/ProductSearchProviderInterface.php
681 /modules/ps_facetedsearch/src/Filters/Converter.php
682 /modules/ps_facetedsearch/src/Product/SearchFactory.php
683 /src/Core/Product/Search/ProductSearchResult.php
684 /modules/ps_facetedsearch/src/Product/Search.php
685 /modules/ps_facetedsearch/src/Adapter/MySQL.php
686 /modules/ps_facetedsearch/src/Adapter/AbstractAdapter.php
687 /modules/ps_facetedsearch/src/Adapter/InterfaceAdapter.php
688 /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ArrayCollection.php
689 /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Collection.php
690 /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Selectable.php
691 /modules/ps_facetedsearch/src/Filters/Products.php
692 /classes/stock/StockAvailable.php
693 /modules/ps_facetedsearch/src/Filters/Block.php
694 /src/Core/Product/Search/FacetCollection.php
695 /classes/ProductAssembler.php
696 /classes/Combination.php
697 /classes/SpecificPrice.php
698 /classes/tax/TaxManagerFactory.php
699 /classes/tax/TaxRulesTaxManager.php
700 /classes/tax/TaxManagerInterface.php
701 /classes/tax/TaxCalculator.php
702 /classes/GroupReduction.php
703 /classes/Feature.php
704 /classes/ProductPresenterFactory.php
705 /src/Adapter/Presenter/Product/ProductListingPresenter.php
706 /src/Adapter/Presenter/Product/ProductPresenter.php
707 /src/Adapter/Product/ProductColorsRetriever.php
708 /src/Adapter/HookManager.php
709 /src/Core/Product/ProductPresentationSettings.php
710 /src/Adapter/Presenter/Product/ProductListingLazyArray.php
711 /src/Adapter/Presenter/Product/ProductLazyArray.php
712 /src/Adapter/Presenter/AbstractLazyArray.php
713 /classes/Image.php
714 /vendor/doctrine/common/lib/Doctrine/Common/Util/Inflector.php
715 /vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php
716 /var/cache/dev/smarty/compile/classic/2e/80/73/2e807335546cfa2360c36327ac89dd2fcb054379_2.module.psfacetedsearchviewstempl.php
717 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php
718 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
719 /src/Core/Product/Search/Pagination.php
720 /vendor/defuse/php-encryption/src/Crypto.php
721 /vendor/defuse/php-encryption/src/KeyOrPassword.php
722 /vendor/defuse/php-encryption/src/RuntimeTests.php
723 /vendor/defuse/php-encryption/src/DerivedKeys.php
724 /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
725 /vendor/defuse/php-encryption/src/Exception/CryptoException.php
726 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/72/19/8b/72198bb2a6143df32c9ccee2dcd6987f5f60f633_2.file.category.tpl.php
727 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/51/05/0d/51050d2d10152bdc78293cb1ffbfd162487b5fb5_2.file.product-list.tpl.php
728 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/01/88/1a/01881afa91793eb1fb77a2cba54c2d58b2e96b2a_2.file.layout-left-column.tpl.php
729 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a4/88/c5/a488c52a31e468058acaf98fafc1c4be23a469c8_2.file.layout-both-columns.tpl.php
730 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ec/c0/50/ecc050404d70a91d1e48f4f8e1999c45bccc2859_2.file.helpers.tpl.php
731 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_tplfunction.php
732 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/93/7d/df/937ddf7c80a6e0655d6a25681f37675ef4345484_2.file.head.tpl.php
733 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php
734 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/35/c2/86/35c2861ab48705ecb54aa8b87bbde79228ff3e9c_2.file.head-jsonld.tpl.php
735 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/23/16/b6/2316b6ce5a2ae4908174f748f57d56b364687561_2.file.product-list-jsonld.tpl.php
736 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/1e/d2/15/1ed21501a44c3a29acd7c463fac4779bea3eb8cd_2.file.pagination-seo.tpl.php
737 /vendor/smarty/smarty/libs/plugins/modifier.replace.php
738 /vendor/smarty/smarty/libs/plugins/shared.mb_str_replace.php
739 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/93/f0/56/93f056613f1f67ea057a32d318835bfdb7f76053_2.file.stylesheets.tpl.php
740 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f0/51/f4/f051f4cd1391b02f65da6388a8e7544cbe7b37a5_2.file.javascript.tpl.php
741 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/cd/33/f0/cd33f02b1df0486b53004c26c5c88b6d4bc4f65f_2.file.product-activation.tpl.php
742 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/41/9b/33/419b331361c22b61e3ba52e347bdb6d5ddbeba93_2.file.header.tpl.php
743 /modules/ps_contactinfo/ps_contactinfo.php
744 /var/cache/dev/smarty/compile/classic/0e/b2/11/0eb2119957cbc13b240126b3ccd8fac8f109f1e2_2.module.pscontactinfonav.tpl.php
745 /modules/ps_languageselector/ps_languageselector.php
746 /modules/ps_currencyselector/ps_currencyselector.php
747 /modules/ps_customersignin/ps_customersignin.php
748 /var/cache/dev/smarty/compile/classic/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.pscustomersigninpscustome.php
749 /src/Adapter/Cart/CartPresenter.php
750 /var/cache/dev/smarty/compile/classic/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.psshoppingcartpsshoppingc.php
751 /modules/ps_mainmenu/ps_mainmenu.php
752 /modules/ps_mainmenu/ps_menutoplinks.class.php
753 /var/cache/dev/smarty/compile/classic/41/df/19/41df1985130dffd7d3fe4cb369091546a0b40be7_2.module.psmainmenupsmainmenu.tpl.php
754 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php
755 /var/cache/dev/smarty/compile/classic/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.pssearchbarpssearchbar.tp.php
756 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ed/7d/33/ed7d33cd2bd0dbb243e13ad0f4e964a1f1f5cabc_2.file.notifications.tpl.php
757 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/1c/7a/0d/1c7a0dcbb86c7392a53369f3dd3b530ae82f57ab_2.file.breadcrumb.tpl.php
758 /modules/ps_categorytree/ps_categorytree.php
759 /var/cache/dev/smarty/compile/classic/89/21/00/8921007f54626fc7fe42cbff53f1d70828d3393d_2.module.pscategorytreeviewstempla.php
760 /var/cache/dev/smarty/compile/classic/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.psfacetedsearchpsfaceteds.php
761 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/12/e7/00/12e7009e38fdc5b32751f71b3886c794919c4188_2.file.category-header.tpl.php
762 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ac/e9/fe/ace9fe1de613c1f48d3698e5baaf511b8a1e0a46_2.file.products-top.tpl.php
763 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/d7/a6/a3/d7a6a306e1379a2bd3678cc39198a058c5eb6db6_2.file.sort-orders.tpl.php
764 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6d/b5/16/6db5161efd984f60ec8263ed7e7766be9ddde68c_2.file.products.tpl.php
765 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e5/7d/45/e57d45c9898495c5e3af0a763f8e9d6370bc508a_2.file.productlist.tpl.php
766 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_capture.php
767 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/76/2b/2c/762b2c4d8029642ec76b72fbab04b0500158eb6e_2.file.product.tpl.php
768 /modules/productcomments/src/Repository/ProductCommentRepository.php
769 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Logging/LoggerChain.php
770 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Logging/SQLLogger.php
771 /vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/Logger/DbalLogger.php
772 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Logging/DebugStack.php
773 /vendor/doctrine/doctrine-bundle/ConnectionFactory.php
774 /vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/ContainerAwareEventManager.php
775 /vendor/doctrine/event-manager/lib/Doctrine/Common/EventManager.php
776 /vendor/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php
777 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php
778 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
779 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver.php
780 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/ExceptionConverterDriver.php
781 /vendor/doctrine/dbal/lib/Doctrine/DBAL/VersionAwarePlatformDriver.php
782 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php
783 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Connection.php
784 /vendor/doctrine/dbal/lib/Doctrine/DBAL/TransactionIsolationLevel.php
785 /vendor/doctrine/dbal/lib/Doctrine/DBAL/ParameterType.php
786 /vendor/doctrine/dbal/lib/Doctrine/DBAL/FetchMode.php
787 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/Expression/ExpressionBuilder.php
788 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php
789 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/ServerInfoAwareConnection.php
790 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
791 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Statement.php
792 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/ResultStatement.php
793 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Events.php
794 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/MariaDb1027Platform.php
795 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/MySqlPlatform.php
796 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php
797 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/DateIntervalUnit.php
798 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/TrimMode.php
799 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/Type.php
800 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php
801 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/SimpleArrayType.php
802 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/JsonArrayType.php
803 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/JsonType.php
804 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ObjectType.php
805 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/BooleanType.php
806 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/IntegerType.php
807 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/PhpIntegerMappingType.php
808 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/SmallIntType.php
809 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/BigIntType.php
810 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/StringType.php
811 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/TextType.php
812 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateTimeType.php
813 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/PhpDateTimeMappingType.php
814 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateTimeImmutableType.php
815 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateTimeTzType.php
816 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateTimeTzImmutableType.php
817 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateType.php
818 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateImmutableType.php
819 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/TimeType.php
820 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/TimeImmutableType.php
821 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DecimalType.php
822 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/FloatType.php
823 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/BinaryType.php
824 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/BlobType.php
825 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/GuidType.php
826 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateIntervalType.php
827 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php
828 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/Expression/CompositeExpression.php
829 /vendor/doctrine/dbal/lib/Doctrine/DBAL/SQLParserUtils.php
830 /var/cache/dev/smarty/compile/classic/e9/e4/d0/e9e4d0b935584380ea8beb3f467908e1cd2486f5_2.module.productcommentsviewstempl.php
831 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/b7/ff/d4/b7ffd4dbcaa6ce9a279e15a0eb2a19a32b24cba8_2.file.product-flags.tpl.php
832 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/63/69/67/6369678df9ee88e18599ca21a640a41f8a00fa70_2.file.pagination.tpl.php
833 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a2/90/4e/a2904eb9b8644bbf001fdf9e37b86cd3d982c9e3_2.file.products-bottom.tpl.php
834 /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/9a/19/0e/9a190eb15037a6135ab0852299c20ca5992ef5b7_2.file.footer.tpl.php
835 /var/cache/dev/smarty/compile/classic/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef_2.module.psemailsubscriptionviewst.php
836 /modules/psgdpr/psgdpr.php
837 /modules/psgdpr/translations/pt.php
838 /modules/psgdpr/classes/GDPRConsent.php
839 /modules/ps_socialfollow/ps_socialfollow.php
840 /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php
841 /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php
842 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php
843 /var/cache/dev/smarty/cache/ps_socialfollow/1/1/1/21/classic/8c/7e/1a/8c7e1a9348af6adb49463906671973d7bb5aad03.pssocialfollowpssocialfol.php
844 /modules/ps_linklist/ps_linklist.php
845 /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php
846 /modules/ps_linklist/src/LegacyLinkBlockRepository.php
847 /var/cache/dev/smarty/cache/ps_linklist/displayFooter/1/1/1/21/classic/76/4f/f2/764ff242631cc7eb33f2fde9de9b1ee58b93e229.pslinklistviewstemplatesh.php
848 /modules/ps_customeraccountlinks/ps_customeraccountlinks.php
849 /var/cache/dev/smarty/cache/ps_customeraccountlinks/1/1/1/21/classic/13/34/be/1334be4e0926a8aff9d4606e2be93a5d1075bac8.pscustomeraccountlinkspsc.php
850 /var/cache/dev/smarty/compile/classic/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d_2.module.pscontactinfopscontactinf.php
851 /vendor/smarty/smarty/libs/plugins/function.mailto.php
852 /modules/statsdata/statsdata.php
853 /classes/Guest.php
854 /src/Adapter/ContainerFinder.php
855 /src/Core/String/CharacterCleaner.php
856 /classes/Connection.php
857 /classes/Page.php
858 /classes/ConnectionsSource.php