Actieve filters

  • Standaardmaten: M
  • Standaardmaten: 46

Actieve filters

  • Standaardmaten: M
  • Standaardmaten: 46
Load Time326 ms - Unicorn powered webserver!
Querying Time95 ms
Queries338
Memory Peak Usage39.8 Mb
Included Files941 files - 8.80 Mb
PrestaShop Cache- Mb
Global vars0.47 Mb
PrestaShop Version1.7.6.1
PHP Version7.2.34 (OK)
MySQL Version10.5.26-MariaDB (OK)
Memory Limit256M
Max Execution Time30s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 35 ms 35 ms 9.90 Mb 10.15 Mb
__construct 6 ms 41 ms 1.77 Mb 12.43 Mb
init 48 ms 89 ms 6.73 Mb 19.29 Mb
checkAccess 0 ms 89 ms - Mb 19.29 Mb
setMedia 46 ms 135 ms 4.78 Mb 23.27 Mb
postProcess 0 ms 135 ms - Mb 23.27 Mb
initHeader 0 ms 135 ms - Mb 23.27 Mb
initContent 150 ms 285 ms 13.11 Mb 36.35 Mb
initFooter 0 ms 285 ms - Mb 36.35 Mb
display 41 ms 326 ms 3.15 Mb 39.83 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 338 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, p.date_add FROM sws_product p LEFT JOIN sws_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sws_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sws_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 ) INNER JOIN sws_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sws_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN sws_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE ((pac.id_attribute IN (2, 104))) AND p.visibility IN ('both', 'catalog') AND c.nleft>=2 AND c.nright<=151 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN sws_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sws_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (2, 104)))
 15.3 1680 /modules/ps_facetedsearch/src/Adapter/MySQL.php:90 
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, p.date_add FROM sws_product p LEFT JOIN sws_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sws_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sws_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 ) INNER JOIN sws_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sws_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN sws_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE ((pac.id_attribute IN (2, 104))) AND p.visibility IN ('both', 'catalog') AND c.nleft>=2 AND c.nright<=151 AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_add DESC LIMIT 360, 12
 5.4 175980 Yes Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:90 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `sws_module` m
INNER JOIN sws_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 `sws_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `sws_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `sws_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `sws_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 1.5 316 Yes Yes /classes/Hook.php:670 
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 `sws_configuration` c
LEFT JOIN `sws_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 1.1 713 /classes/Configuration.php:160 
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `sws_country` c  INNER JOIN sws_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `sws_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `sws_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
 1.1 245 Yes /classes/Country.php:147 
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `sws_category` c
INNER JOIN `sws_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `sws_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 151
AND c.id_category IN (
SELECT id_category
FROM `sws_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
 1.1 76 Yes /modules/ps_categorytree/ps_categorytree.php:117 
INSERT INTO `sws_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
 1 1 /classes/ObjectModel.php:561 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active
FROM `sws_hook_module` hm
STRAIGHT_JOIN `sws_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `sws_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 0.9 316 /classes/Hook.php:407 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `sws_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `sws_hook_alias` ha
INNER JOIN `sws_hook` h ON ha.name = h.name
 0.8 0 /classes/Hook.php:194 
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 `sws_category` c
INNER JOIN sws_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `sws_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `sws_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 2
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.7 9 Yes Yes /classes/Category.php:909 
(SELECT SQL_NO_CACHE * FROM `sws_cart_rule` cr
LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `sws_cart_rule` cr
LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 0.7 1 /classes/CartRule.php:401 
(SELECT SQL_NO_CACHE * FROM `sws_cart_rule` cr
LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `sws_cart_rule` cr
LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 0.7 1 /classes/CartRule.php:401 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 344
 0.6 37 /classes/ProductAssembler.php:90 
INSERT INTO `sws_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('28712434', '126', '314419846', '', '1', '1', '2024-10-08 04:45:23')
 0.6 1 /classes/ObjectModel.php:561 
(SELECT SQL_NO_CACHE * FROM `sws_cart_rule` cr
LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `sws_cart_rule` cr
LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 0.6 1 /classes/CartRule.php:401 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 227
 0.5 31 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 226
 0.5 25 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE * FROM `sws_state` ORDER BY `name` ASC
 0.5 324 Yes /classes/Country.php:154 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 230
 0.5 29 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE *
FROM `sws_lang` a
LEFT JOIN `sws_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 212
 0.5 17 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 347
 0.4 19 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 4115
 0.4 16 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM sws_shop_url su
LEFT JOIN sws_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.silverado.nl' OR su.domain_ssl = 'www.silverado.nl')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.4 1 Yes /override/classes/shop/Shop.php:345 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (344) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 12 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 216
 0.4 16 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE *
FROM `sws_attribute` a
INNER JOIN sws_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
WHERE a.`id_attribute_group` = 1
ORDER BY `position` ASC
 0.4 288 Yes /classes/AttributeGroup.php:238 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 126
 0.4 16 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 219
 0.4 16 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 211
 0.4 13 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-10-08 00:00:00',
INTERVAL 90 DAY
)
) > 0) as new
FROM sws_product p
LEFT JOIN sws_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sws_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 103
 0.4 16 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.4 17 Yes /classes/AttributeGroup.php:261 
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 sws_shop_group gs
LEFT JOIN sws_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN sws_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.4 1 Yes /override/classes/shop/Shop.php:705 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (226) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 10 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (219) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 5 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (230) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 10 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (347) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 6 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (227) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 10 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4115) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 5 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (211) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 6 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (212) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 6 Yes Yes /classes/Product.php:3887 
(SELECT 1 FROM `sws_cart_rule` WHERE date_to >= "2024-10-08 00:00:00" AND date_to <= "2024-10-08 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sws_cart_rule` WHERE date_from >= "2024-10-08 00:00:00" AND date_from <= "2024-10-08 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sws_cart_rule` WHERE date_from < "2024-10-08 00:00:00" AND date_to > "2024-10-08 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.4 1 /classes/CartRule.php:342 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 344 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 344 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1238 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (103) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 5 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (126) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 5 Yes Yes /classes/Product.php:3887 
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 `sws_product_attribute` pa
INNER JOIN sws_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 `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (216) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 5 Yes Yes /classes/Product.php:3887 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 216 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 216 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 212 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 212 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 103 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 103 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 347 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 347 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1726
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 347 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1726
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 347 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 225
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 227 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 225
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 227 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 47
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 344 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 47
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 344 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 211 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 211 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 219 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 219 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE version
FROM `sws_module`
WHERE (`name` = "mollie") LIMIT 1
 0.3 1 /modules/mollie/src/Repository/ModuleRepository.php:27 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4115 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 4115 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 344
AND pac.`id_product_attribute` = 47
AND agl.`id_lang` = 1
 0.3 1 /classes/Product.php:6258 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 227 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 227 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 230 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 230 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 226 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 226 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `sws_meta` m
LEFT JOIN `sws_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.3 44 Yes /classes/Dispatcher.php:640 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1711
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 126 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1711
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 126 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 344
ORDER BY `position`
 0.3 5 Yes /classes/Product.php:3059 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 126 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_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` = 126 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1710
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 103 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1710
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 103 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1722
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 216 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1722
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 216 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1914
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4115 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1914
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4115 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 226
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 230 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 226
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 230 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1724
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 219 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1724
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 219 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1720
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 211 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1720
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 211 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 443
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 226 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 443
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 226 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
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 `sws_cart_product` cp
WHERE cp.`id_product_attribute` = 1721
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 212 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1721
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 212 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM sws_layered_category
WHERE id_category = 2
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.3 11 Yes Yes /modules/ps_facetedsearch/src/Filters/Converter.php:224 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sws_module` m
LEFT JOIN `sws_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.3 88 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE tr.*
FROM `sws_tax_rule` tr
JOIN `sws_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` = 11
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.3 1 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 347) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.3 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 344) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 347
AND pac.`id_product_attribute` = 1726
AND agl.`id_lang` = 1
 0.3 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 216
AND pac.`id_product_attribute` = 1722
AND agl.`id_lang` = 1
 0.3 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE 1 FROM sws_cart_product cp INNER JOIN sws_product p
ON (p.id_product = cp.id_product) INNER JOIN sws_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.3 1 /classes/Cart.php:4054 
(SELECT 1 FROM `sws_cart_rule` WHERE date_to >= "2024-10-08 00:00:00" AND date_to <= "2024-10-08 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sws_cart_rule` WHERE date_from >= "2024-10-08 00:00:00" AND date_from <= "2024-10-08 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sws_cart_rule` WHERE date_from < "2024-10-08 00:00:00" AND date_to > "2024-10-08 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.3 1 /classes/CartRule.php:342 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 226 AND pa.`id_product` = 226 AND pa.`id_product_attribute` = 443 LIMIT 1
 0.3 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 219
AND pac.`id_product_attribute` = 1724
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 211
AND pac.`id_product_attribute` = 1720
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 219) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 103
AND pac.`id_product_attribute` = 1710
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 227) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 4115
AND pac.`id_product_attribute` = 1914
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 347
ORDER BY `position`
 0.2 4 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 226
AND pac.`id_product_attribute` = 443
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 212) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 126) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 216) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 227
AND pac.`id_product_attribute` = 225
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 212
AND pac.`id_product_attribute` = 1721
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 226) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 103) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 230
AND pac.`id_product_attribute` = 226
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4115) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 211) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (47, 53, 70, 86, 102, 115, 130, 334, 525, 746, 846, 940) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `sws_attribute` a
LEFT JOIN `sws_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sws_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sws_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 126
AND pac.`id_product_attribute` = 1711
AND agl.`id_lang` = 1
 0.2 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `sws_currency` c
LEFT JOIN sws_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 0.2 1 /classes/Currency.php:768 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.2 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 219)
 0.2 5 /classes/Product.php:3364 
SELECT SQL_NO_CACHE *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 230) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.2 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 344)
 0.2 12 /classes/Product.php:3364 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `sws_lang` l
JOIN sws_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.2 1 /classes/Language.php:1057 
SELECT SQL_NO_CACHE `id_guest`
FROM `sws_connections`
WHERE `id_guest` = 28712434
AND `date_add` > '2024-10-08 04:15:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.2 1 Yes /classes/Connection.php:163 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 216)
 0.2 5 /classes/Product.php:3364 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 216
ORDER BY `position`
 0.2 2 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 211
ORDER BY `position`
 0.2 4 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.2 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 226
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.2 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.2 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 4115
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 219
ORDER BY `position`
 0.2 4 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 230
ORDER BY `position`
 0.2 2 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE *
FROM `sws_country` a
LEFT JOIN `sws_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `sws_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 13) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.2 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 227
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE *
FROM `sws_category` a0
LEFT JOIN `sws_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 2) AND (a0.`nright` > 151) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 0.2 1 Yes /classes/PrestaShopCollection.php:381 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 103
ORDER BY `position`
 0.2 2 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 126
ORDER BY `position`
 0.2 2 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sws_image` i
INNER JOIN sws_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 212
ORDER BY `position`
 0.2 3 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE DISTINCT agl.`name`, ag.*, agl.*
FROM `sws_attribute_group` ag
INNER JOIN sws_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
LEFT JOIN `sws_attribute_group_lang` agl
ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = 1)
ORDER BY `name` ASC
 0.2 17 Yes /classes/AttributeGroup.php:261 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 226)
 0.2 10 /classes/Product.php:3364 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 103)
 0.2 5 /classes/Product.php:3364 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 230)
 0.2 10 /classes/Product.php:3364 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1720, 1938, 2201, 2464, 2723, 2893) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 347)
 0.2 6 /classes/Product.php:3364 
SELECT SQL_NO_CACHE *
FROM `sws_group` a
LEFT JOIN `sws_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 227)
 0.2 10 /classes/Product.php:3364 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 126)
 0.2 5 /classes/Product.php:3364 
SELECT SQL_NO_CACHE data FROM sws_layered_filter_block WHERE hash="973c0eab08b6394ba24f9b6868655f93" LIMIT 1
 0.2 1 /modules/ps_facetedsearch/src/Filters/Block.php:172 
SELECT SQL_NO_CACHE `id_page`
FROM `sws_page`
WHERE `id_page_type` = 5 AND `id_object` = 2 LIMIT 1
 0.2 1 /classes/Page.php:83 
SELECT SQL_NO_CACHE id_page_type
FROM sws_page_type
WHERE name = 'category' LIMIT 1
 0.2 1 /classes/Page.php:104 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1710, 1928, 2191, 2454, 2713) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 4115)
 0.2 5 /classes/Product.php:3364 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (443, 522, 843, 7018, 7019, 7565, 9696, 9697, 9698, 9699) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 212)
 0.2 6 /classes/Product.php:3364 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sws_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` = 211)
 0.2 6 /classes/Product.php:3364 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1722, 1940, 2203, 2466, 2725) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1726, 1943, 2207, 2470, 2729, 2894) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE *
FROM `sws_currency` c
WHERE `deleted` = 0 ORDER BY `iso_code` ASC
 0.2 1 Yes /classes/Currency.php:419 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 230 AND pa.`id_product` = 230 AND pa.`id_product_attribute` = 226 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 47) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `sws_lang` l
LEFT JOIN `sws_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.2 1 /classes/Language.php:910 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1914, 2167, 2433, 2704, 8772) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 344 AND pa.`id_product` = 344 AND pa.`id_product_attribute` = 47 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 51) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 227 AND pa.`id_product` = 227 AND pa.`id_product_attribute` = 225 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1721, 1939, 2202, 2465, 2724, 10427) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (225, 333, 444, 523, 623, 744, 809, 844, 899, 938) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 90) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (226, 445, 524, 624, 745, 810, 845, 900, 939, 7017) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1722) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1720) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1724, 1942, 2205, 2468, 2727) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sws_product_attribute_image` pai
LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1711, 1929, 2192, 2455, 2714) AND il.`id_lang` = 1 ORDER by i.`position`
 0.2 1 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE * FROM `sws_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.2 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE * FROM `sws_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.2 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE *
FROM `sws_currency` a
LEFT JOIN `sws_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `sws_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_module` FROM `sws_module` WHERE `name` = "mollie" LIMIT 1
 0.2 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 347 AND pa.`id_product` = 347 AND pa.`id_product_attribute` = 1726 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1724) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1914) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE value FROM `sws_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.2 1 /override/classes/shop/Shop.php:1164 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1710) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 443) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 103 AND pa.`id_product` = 103 AND pa.`id_product_attribute` = 1710 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 225) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM sws_shop s
LEFT JOIN sws_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.2 1 /override/classes/shop/Shop.php:201 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM sws_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.2 1 /classes/shop/ShopUrl.php:182 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 212 AND pa.`id_product` = 212 AND pa.`id_product_attribute` = 1721 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 211 AND pa.`id_product` = 211 AND pa.`id_product_attribute` = 1720 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sws_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 60 LIMIT 1
 0.2 1 /classes/Category.php:1360 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 216 AND pa.`id_product` = 216 AND pa.`id_product_attribute` = 1722 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE `id_country`
FROM `sws_country`
WHERE `iso_code` = 'US' LIMIT 1
 0.2 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 126 AND pa.`id_product` = 126 AND pa.`id_product_attribute` = 1711 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 219 AND pa.`id_product` = 219 AND pa.`id_product_attribute` = 1724 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 4115 AND pa.`id_product` = 4115 AND pa.`id_product_attribute` = 1914 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE * FROM `sws_fbpsc_connector_position`
 0.2 7 /modules/facebookpsconnect/lib/module-dao_class.php:366 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1711) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 226) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 443 LIMIT 1
 0.2 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1721) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE tr.*
FROM `sws_tax_rule` tr
JOIN `sws_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
 0.2 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1726) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 0 LIMIT 1
 0.2 1 /classes/SpecificPrice.php:407 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM sws_category_group ctg
WHERE ctg.`id_category` = 2 AND ctg.`id_group` = 1 LIMIT 1
 0.2 1 /classes/Category.php:1691 
SELECT SQL_NO_CACHE * FROM `sws_hook_alias`
 0.2 83 /classes/Hook.php:238 
SELECT SQL_NO_CACHE `id_module` FROM `sws_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.2 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE *
FROM `sws_currency` a
LEFT JOIN `sws_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `sws_hook_alias`
 0.1 83 /classes/Hook.php:264 
SELECT SQL_NO_CACHE c.id_currency
FROM `sws_currency` c
WHERE (deleted = 0) AND (iso_code = 'EUR') LIMIT 1
 0.1 1 /classes/Currency.php:587 
SELECT SQL_NO_CACHE `id_lang` FROM `sws_lang` WHERE `locale` = 'nl-nl' LIMIT 1
 0.1 1 /classes/Language.php:743 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1721 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sws_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 14 LIMIT 1
 0.1 1 /classes/Category.php:1360 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 47 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE * FROM `sws_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.1 1 /classes/module/Module.php:2221 
SELECT SQL_NO_CACHE *
FROM `sws_country` a
LEFT JOIN `sws_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sws_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 106 LIMIT 1
 0.1 1 /classes/Category.php:1360 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 225 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE *
FROM `sws_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 226 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 92) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `sws_country`
WHERE `id_country` = 13 LIMIT 1
 0.1 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `sws_country`
WHERE `id_country` = 13 LIMIT 1
 0.1 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1726 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1914 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 227) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sws_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 31 LIMIT 1
 0.1 1 /classes/Category.php:1360 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 211 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1724 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 226) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1710 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1722 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 42) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1711 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sws_product_attribute` pa
INNER JOIN sws_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 1720 LIMIT 1
 0.1 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 344) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 230) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sws_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 107 LIMIT 1
 0.1 1 /classes/Category.php:1360 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 4115) AND (id_product_attribute = 1914) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE *
FROM `sws_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 123) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 106 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 68) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 4115 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 344
 0.1 12 /classes/Product.php:2473 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 344) AND (id_product_attribute = 47) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 344 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 60 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 126) AND (id_product_attribute = 1711) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 106 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 60 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 344 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 347) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 103) AND (id_product_attribute = 1710) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 216) AND (id_product_attribute = 1722) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `iso_code`
FROM `sws_country`
WHERE `id_country` = 13 LIMIT 1
 0.1 1 /classes/Country.php:274 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 212
 0.1 6 /classes/Product.php:2473 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 31 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE id_shop FROM sws_shop
 0.1 1 /override/classes/shop/Shop.php:741 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 106 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 230) AND (id_product_attribute = 226) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE *
FROM `sws_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
 0.1 1 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 106 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 212) AND (id_product_attribute = 1721) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 216) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 230
 0.1 10 /classes/Product.php:2473 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 226) AND (id_product_attribute = 443) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 211) AND (id_product_attribute = 1720) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 219) AND (id_product_attribute = 1724) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 347) AND (id_product_attribute = 1726) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) AND (b.`id_shop` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 227) AND (id_product_attribute = 225) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 103) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 4115
 0.1 5 /classes/Product.php:2473 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 212) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 347
 0.1 6 /classes/Product.php:2473 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 211) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE *
FROM `sws_country` a
LEFT JOIN `sws_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 13) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 4115) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 226
 0.1 10 /classes/Product.php:2473 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 227
 0.1 10 /classes/Product.php:2473 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 347 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 216
 0.1 5 /classes/Product.php:2473 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 219) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = 126) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 211
 0.1 6 /classes/Product.php:2473 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 212 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE `id_country`
FROM `sws_country`
WHERE `iso_code` = 'US' LIMIT 1
 0.1 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE `id_lang` FROM `sws_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.1 1 /classes/Language.php:721 
SELECT SQL_NO_CACHE *
FROM `sws_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 0.1 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 126
 0.1 5 /classes/Product.php:2473 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 219
 0.1 5 /classes/Product.php:2473 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sws_product_attribute`
WHERE `id_product` = 103
 0.1 5 /classes/Product.php:2473 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 219 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 216 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 230 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 226 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE *
FROM `sws_group_lang`
WHERE `id_group` = 1
 0.1 1 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 227 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE id_shop
FROM `sws_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1611 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 126 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 103 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE *
FROM `sws_country_lang`
WHERE `id_country` = 21
 0.1 1 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE 1 FROM `sws_specific_price` WHERE id_product = 344 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM sws_required_field
 0.1 2 /classes/ObjectModel.php:1474 
SELECT SQL_NO_CACHE *
FROM `sws_tax_lang`
WHERE `id_tax` = 1
 0.1 1 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE *
FROM `sws_currency_lang`
WHERE `id_currency` = 1
 0.1 1 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE `id_module` FROM `sws_module_shop` WHERE `id_module` = 121 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 212 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE format
FROM `sws_address_format`
WHERE `id_country` = 13 LIMIT 1
 0.1 1 /classes/AddressFormat.php:629 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 14 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 226 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 230 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 219 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 126 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 227 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 347 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE *
FROM `sws_country_lang`
WHERE `id_country` = 13
 0.1 1 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 216 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 211 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 103 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sws_product_shop`
WHERE `id_product` = 4115 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_group`
WHERE `id_group` = 1 LIMIT 1
 0.1 1 /classes/Group.php:151 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 347 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE id_shop
FROM `sws_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1611 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 106 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 31 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 60 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE name FROM sws_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 107 LIMIT 1
 0.1 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 216 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 103 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE id_shop
FROM `sws_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1611 
SELECT SQL_NO_CACHE `id_module` FROM `sws_module_shop` WHERE `id_module` = 124 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 219 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 211 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 230 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 227 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 126 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 226 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 4115 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `reduction`
FROM `sws_product_group_reduction_cache`
WHERE `id_product` = 212 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `sws_country`
WHERE `id_country` = 13 LIMIT 1
 0.1 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE `id_lang` FROM `sws_lang` WHERE `iso_code` = 'fr' LIMIT 1
 0.1 1 /classes/Language.php:721 
SELECT SQL_NO_CACHE `id_lang` FROM `sws_lang` WHERE `iso_code` = 'it' LIMIT 1
 0.1 1 /classes/Language.php:721 
SELECT SQL_NO_CACHE `id_lang` FROM `sws_lang` WHERE `iso_code` = 'es' LIMIT 1
 0.1 1 /classes/Language.php:721

Doubles

24
SELECT SUM(quantity)
FROM `sws_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
24
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
            COALESCE(SUM(first_level_quantity), XX) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity
          FROM `sws_cart_product` cp
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
          FROM `sws_cart_product` cp JOIN `sws_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sws_product` pr ON p.`id_product_pack` = pr.`id_product`
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
            pr.`pack_stock_type` = XX
            AND XX = XX
        ))) as q LIMIT XX
13
SELECT XX FROM `sws_specific_price` WHERE id_product = XX LIMIT XX
12
SELECT
                    p.*,
                    pl.*,
                    sa.out_of_stock,
                    IFNULL(sa.quantity, XX) as quantity,
                    (DATEDIFF(
				p.`date_add`,
				DATE_SUB(
					'XX-XX-XX XX:XX:XX',
					INTERVAL XX DAY
				)
			) > XX) as new
                FROM sws_product p
                LEFT JOIN sws_product_lang pl
                    ON pl.id_product = p.id_product
                    AND pl.id_shop = XX
                    AND pl.id_lang = XX
                LEFT JOIN sws_stock_available sa
			        ON sa.id_product = p.id_product 
			        AND sa.id_shop = XX
			    WHERE p.id_product = XX
12
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `sws_product` p
INNER JOIN `sws_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `sws_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
12
                            SELECT `id_tax_rules_group`
                            FROM `sws_product_shop`
                            WHERE `id_product` = XX AND id_shop=XX LIMIT XX
12
SELECT name FROM sws_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
12
			SELECT `reduction`
			FROM `sws_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
12
SELECT pa.`available_date` FROM `sws_product` p LEFT JOIN `sws_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sws_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN sws_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
12
            SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`,pa.`upc`
            FROM `sws_attribute` a
            LEFT JOIN `sws_attribute_lang` al
                ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
            LEFT JOIN `sws_product_attribute_combination` pac
                ON (pac.`id_attribute` = a.`id_attribute`)
            LEFT JOIN `sws_product_attribute` pa
                ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
             INNER JOIN sws_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
            LEFT JOIN `sws_attribute_group_lang` agl
                ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
            WHERE pa.`id_product` = XX
                AND pac.`id_product_attribute` = XX
                AND agl.`id_lang` = XX
12
SELECT *
FROM `sws_product_attribute` a
LEFT JOIN `sws_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX
WHERE (a.`id_product_attribute` = XX) LIMIT XX
12
SELECT *
FROM `sws_product` a
LEFT JOIN `sws_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `sws_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
12
SELECT `id_product_attribute`
            FROM `sws_product_attribute`
            WHERE `id_product` = XX
12
            SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
            FROM `sws_image` i
             INNER JOIN sws_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
            LEFT JOIN `sws_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
            WHERE i.`id_product` = XX
            ORDER BY `position`
12
            SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
            FROM `sws_product_attribute` pa
             INNER JOIN sws_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
            JOIN `sws_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
            JOIN `sws_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
            JOIN `sws_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
            JOIN `sws_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
12
			SELECT product_attribute_shop.`price`
			FROM `sws_product_attribute` pa
			 INNER JOIN sws_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
			WHERE pa.`id_product_attribute` = XX LIMIT XX
9
SELECT *
FROM `sws_category` a
LEFT JOIN `sws_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `sws_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
9
			SELECT DISTINCT agl.`name`, ag.*, agl.*
			FROM `sws_attribute_group` ag
			 INNER JOIN sws_attribute_group_shop attribute_group_shop
        ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX)
			LEFT JOIN `sws_attribute_group_lang` agl
				ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = XX)
			ORDER BY `name` ASC
5
			SELECT cl.`link_rewrite`
			FROM `sws_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
5
            SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
            FROM `sws_product_attribute_image` pai
            LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
            LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
            WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
3
            SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
            FROM `sws_product_attribute_image` pai
            LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
            LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
            WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
3
			SELECT `need_identification_number`
			FROM `sws_country`
			WHERE `id_country` = XX LIMIT XX
3
            SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
            FROM `sws_product_attribute_image` pai
            LEFT JOIN `sws_image_lang` il ON (il.`id_image` = pai.`id_image`)
            LEFT JOIN `sws_image` i ON (i.`id_image` = pai.`id_image`)
            WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2
SELECT `id_module` FROM `sws_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
2
				SELECT tr.*
				FROM `sws_tax_rule` tr
				JOIN `sws_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
(SELECT XX FROM `sws_cart_rule` WHERE date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `sws_cart_rule` WHERE date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `sws_cart_rule` WHERE date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX) LIMIT XX
2
SELECT * FROM `sws_hook_alias`
2
(SELECT SQL_NO_CACHE * FROM `sws_cart_rule` cr
				LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`id_customer` = XX  AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `sws_cart_rule` cr
				LEFT JOIN `sws_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`group_restriction` = XX  AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%")
2
SELECT *
							FROM `sws_country_lang`
							WHERE `id_country` = XX
2
SELECT *
FROM `sws_country` a
LEFT JOIN `sws_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX
WHERE (a.`id_country` = XX) LIMIT XX
2
			SELECT `id_country`
			FROM `sws_country`
			WHERE `iso_code` = 'US' LIMIT XX

Tables stress

75 product_attribute
75 product
72 product_attribute_shop
51 product_shop
49 cart_product
38 stock_available
30 category_lang
27 product_attribute_combination
25 attribute
25 attribute_lang
24 image
24 pack
24 product_lang
24 image_lang
21 attribute_group
21 attribute_group_lang
15 category
13 specific_price
12 image_shop
12 category_shop
12 product_group_reduction_cache
12 cart_rule
12 product_attribute_image
10 country
9 attribute_group_shop
8 lang
6 module
6 cart_rule_lang
5 currency
5 module_shop
5 shop
4 shop_url
4 lang_shop
4 hook
4 country_lang
4 currency_shop
4 country_shop
3 category_group
3 hook_alias
2 tax_rules_group
2 tax_rule
2 hook_module
2 image_type
2 category_product
2 configuration
2 currency_lang
2 group
2 group_shop
2 shop_group
1 configuration_lang
1 zone
1 state
1 connections
1 page_type
1 hook_module_exceptions
1 module_group
1 tax_lang
1 tax
1 layered_filter_block
1 meta
1 meta_lang
1 attribute_shop
1 group_lang
1 layered_category
1 fbpsc_connector_position
1 required_field
1 address_format
1 page

ObjectModel instances

NameInstancesSource
Product 36 /classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
Category 15 /controllers/front/listing/CategoryController.php [85]
/controllers/front/listing/CategoryController.php [200]
/controllers/front/listing/CategoryController.php [200]
/controllers/front/listing/CategoryController.php [200]
/controllers/front/listing/CategoryController.php [200]
/controllers/front/listing/CategoryController.php [200]
/controllers/front/listing/CategoryController.php [200]
/controllers/front/listing/CategoryController.php [200]
/controllers/front/listing/CategoryController.php [200]
/classes/Meta.php [379]
/classes/Link.php [386]
/classes/PrestaShopCollection.php [383]
/modules/ps_facetedsearch/src/Product/Search.php [107]
/modules/ps_categorytree/ps_categorytree.php [288]
/modules/ps_categorytree/ps_categorytree.php [291]
Combination 12 /classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
Country 8 /config/config.inc.php [141]
/classes/controller/FrontController.php [872]
/classes/AddressFormat.php [357]
/classes/controller/FrontController.php [1623]
/classes/AddressFormat.php [357]
/modules/ps_contactinfo/ps_contactinfo.php [99]
/classes/AddressFormat.php [357]
/modules/ps_contactinfo/ps_contactinfo.php [99]
Customer 4 /config/config.inc.php [220]
/classes/AddressFormat.php [357]
/classes/AddressFormat.php [357]
/classes/AddressFormat.php [357]
Address 4 /override/classes/shop/Shop.php [467]
/classes/Product.php [3201]
/classes/Product.php [3310]
/classes/Product.php [4970]
AddressFormat 3 /classes/controller/FrontController.php [1617]
/modules/ps_contactinfo/ps_contactinfo.php [93]
/modules/ps_contactinfo/ps_contactinfo.php [93]
State 3 /classes/controller/FrontController.php [1622]
/modules/ps_contactinfo/ps_contactinfo.php [98]
/modules/ps_contactinfo/ps_contactinfo.php [98]
Language 2 /config/config.inc.php [194]
/classes/Tools.php [579]
Currency 2 /src/Adapter/Currency/CurrencyDataProvider.php [101]
/classes/Tools.php [700]
Shop 1 /config/config.inc.php [119]
Connection 1 /modules/statsdata/statsdata.php [117]
Guest 1 /modules/statsdata/statsdata.php [83]
Tax 1 /classes/tax/TaxRulesTaxManager.php [115]
Risk 1 /classes/controller/FrontController.php [1587]
Gender 1 /classes/controller/FrontController.php [1584]
Group 1 /classes/Cart.php [245]
Cart 1 /classes/controller/FrontController.php [410]
ShopGroup 1 /override/classes/shop/Shop.php [551]
ConnectionsSource 1 /modules/statsdata/statsdata.php [118]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/autoload.php
5/vendor/autoload.php
6/vendor/composer/autoload_real.php
7/vendor/composer/ClassLoader.php
8/vendor/composer/include_paths.php
9/vendor/composer/autoload_static.php
10/vendor/symfony/polyfill-ctype/bootstrap.php
11/vendor/react/promise/src/functions_include.php
12/vendor/react/promise/src/functions.php
13/vendor/swiftmailer/swiftmailer/lib/swift_required.php
14/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
15/vendor/paragonie/random_compat/lib/random.php
16/vendor/symfony/polyfill-php70/bootstrap.php
17/vendor/symfony/polyfill-php56/bootstrap.php
18/vendor/symfony/polyfill-mbstring/bootstrap.php
19/vendor/symfony/polyfill-intl-icu/bootstrap.php
20/vendor/symfony/polyfill-apcu/bootstrap.php
21/vendor/markbaker/matrix/classes/src/functions/adjoint.php
22/vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
23/vendor/markbaker/matrix/classes/src/functions/cofactors.php
24/vendor/markbaker/matrix/classes/src/functions/determinant.php
25/vendor/markbaker/matrix/classes/src/functions/diagonal.php
26/vendor/markbaker/matrix/classes/src/functions/identity.php
27/vendor/markbaker/matrix/classes/src/functions/inverse.php
28/vendor/markbaker/matrix/classes/src/functions/minors.php
29/vendor/markbaker/matrix/classes/src/functions/trace.php
30/vendor/markbaker/matrix/classes/src/functions/transpose.php
31/vendor/markbaker/matrix/classes/src/operations/add.php
32/vendor/markbaker/matrix/classes/src/operations/directsum.php
33/vendor/markbaker/matrix/classes/src/operations/subtract.php
34/vendor/markbaker/matrix/classes/src/operations/multiply.php
35/vendor/markbaker/matrix/classes/src/operations/divideby.php
36/vendor/markbaker/matrix/classes/src/operations/divideinto.php
37/vendor/markbaker/complex/classes/src/functions/abs.php
38/vendor/markbaker/complex/classes/src/functions/acos.php
39/vendor/markbaker/complex/classes/src/functions/acosh.php
40/vendor/markbaker/complex/classes/src/functions/acot.php
41/vendor/markbaker/complex/classes/src/functions/acoth.php
42/vendor/markbaker/complex/classes/src/functions/acsc.php
43/vendor/markbaker/complex/classes/src/functions/acsch.php
44/vendor/markbaker/complex/classes/src/functions/argument.php
45/vendor/markbaker/complex/classes/src/functions/asec.php
46/vendor/markbaker/complex/classes/src/functions/asech.php
47/vendor/markbaker/complex/classes/src/functions/asin.php
48/vendor/markbaker/complex/classes/src/functions/asinh.php
49/vendor/markbaker/complex/classes/src/functions/atan.php
50/vendor/markbaker/complex/classes/src/functions/atanh.php
51/vendor/markbaker/complex/classes/src/functions/conjugate.php
52/vendor/markbaker/complex/classes/src/functions/cos.php
53/vendor/markbaker/complex/classes/src/functions/cosh.php
54/vendor/markbaker/complex/classes/src/functions/cot.php
55/vendor/markbaker/complex/classes/src/functions/coth.php
56/vendor/markbaker/complex/classes/src/functions/csc.php
57/vendor/markbaker/complex/classes/src/functions/csch.php
58/vendor/markbaker/complex/classes/src/functions/exp.php
59/vendor/markbaker/complex/classes/src/functions/inverse.php
60/vendor/markbaker/complex/classes/src/functions/ln.php
61/vendor/markbaker/complex/classes/src/functions/log2.php
62/vendor/markbaker/complex/classes/src/functions/log10.php
63/vendor/markbaker/complex/classes/src/functions/negative.php
64/vendor/markbaker/complex/classes/src/functions/pow.php
65/vendor/markbaker/complex/classes/src/functions/rho.php
66/vendor/markbaker/complex/classes/src/functions/sec.php
67/vendor/markbaker/complex/classes/src/functions/sech.php
68/vendor/markbaker/complex/classes/src/functions/sin.php
69/vendor/markbaker/complex/classes/src/functions/sinh.php
70/vendor/markbaker/complex/classes/src/functions/sqrt.php
71/vendor/markbaker/complex/classes/src/functions/tan.php
72/vendor/markbaker/complex/classes/src/functions/tanh.php
73/vendor/markbaker/complex/classes/src/functions/theta.php
74/vendor/markbaker/complex/classes/src/operations/add.php
75/vendor/markbaker/complex/classes/src/operations/subtract.php
76/vendor/markbaker/complex/classes/src/operations/multiply.php
77/vendor/markbaker/complex/classes/src/operations/divideby.php
78/vendor/markbaker/complex/classes/src/operations/divideinto.php
79/vendor/smarty/smarty/libs/bootstrap.php
80/vendor/smarty/smarty/libs/Autoloader.php
81/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
82/vendor/ircmaxell/password-compat/lib/password.php
83/vendor/jakeasmith/http_build_url/src/http_build_url.php
84/vendor/symfony/polyfill-php73/bootstrap.php
85/vendor/symfony/polyfill-php73/Php73.php
86/app/AppKernel.php
87/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php
88/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/KernelInterface.php
89/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernelInterface.php
90/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/RebootableInterface.php
91/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/TerminableInterface.php
92/config/alias.php
93/classes/PrestaShopAutoload.php
94/var/cache/prod/class_index.php
95/config/bootstrap.php
96/src/Core/ContainerBuilder.php
97/src/Core/Foundation/IoC/Container.php
98/src/Adapter/ServiceLocator.php
99/vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
100/var/cache/prod/appParameters.php
101/classes/controller/Controller.php
102/classes/ObjectModel.php
103/src/Core/Foundation/Database/EntityInterface.php
104/classes/db/Db.php
105/classes/Tools.php
106/classes/Context.php
107/override/classes/shop/Shop.php
108/classes/db/DbPDO.php
109/classes/AddressFormat.php
110/classes/Configuration.php
111/classes/Validate.php
112/override/classes/Validate.php
113/classes/cache/Cache.php
114/src/Adapter/EntityMapper.php
115/classes/db/DbQuery.php
116/src/Core/Addon/Theme/ThemeManagerBuilder.php
117/src/Adapter/Configuration.php
118/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
119/src/Core/ConfigurationInterface.php
120/src/Core/Addon/Theme/ThemeRepository.php
121/src/Core/Addon/AddonRepositoryInterface.php
122/src/Core/Addon/Theme/Theme.php
123/src/Core/Addon/AddonInterface.php
124/vendor/shudrum/array-finder/ArrayFinder.php
125/config/defines_uri.inc.php
126/classes/Language.php
127/classes/Country.php
128/classes/PrestaShopCollection.php
129/classes/shop/ShopGroup.php
130/classes/Cookie.php
131/classes/PhpEncryption.php
132/vendor/defuse/php-encryption/src/Core.php
133/classes/PhpEncryptionEngine.php
134/vendor/defuse/php-encryption/src/Key.php
135/vendor/defuse/php-encryption/src/Encoding.php
136/config/smarty.config.inc.php
137/vendor/smarty/smarty/libs/Smarty.class.php
138/vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php
139/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php
140/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
141/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
142/vendor/smarty/smarty/libs/sysplugins/smarty_resource.php
143/vendor/smarty/smarty/libs/sysplugins/smarty_variable.php
144/vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php
145/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
146/vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php
147/config/smartyfront.config.inc.php
148/classes/Smarty/SmartyResourceModule.php
149/vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php
150/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php
151/classes/Smarty/SmartyResourceParent.php
152/classes/Smarty/SmartyLazyRegister.php
153/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php
154/vendor/smarty/smarty/libs/plugins/modifier.truncate.php
155/classes/Customer.php
156/classes/Group.php
157/classes/Link.php
158/classes/shop/ShopUrl.php
159/classes/Dispatcher.php
160/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Request.php
161/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/FileBag.php
162/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ServerBag.php
163/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/HeaderBag.php
164/classes/Hook.php
165/src/Adapter/SymfonyContainer.php
166/vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
167/config/db_slave_server.inc.php
168/controllers/front/listing/CategoryController.php
169/classes/controller/ProductListingFrontController.php
170/classes/controller/ProductPresentingFrontController.php
171/classes/controller/FrontController.php
172/src/PrestaShopBundle/Translation/TranslatorComponent.php
173/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
174/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
175/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
176/src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
177/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatter.php
178/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatterInterface.php
179/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/ChoiceMessageFormatterInterface.php
180/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageSelector.php
181/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
182/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
183/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
184/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
185/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
186/var/cache/prod/translations/catalogue.nl-NL.NXhscRe.php
187/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
188/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
189/vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
190/src/Adapter/Presenter/Object/ObjectPresenter.php
191/src/Adapter/Presenter/PresenterInterface.php
192/src/Adapter/Presenter/Cart/CartPresenter.php
193/src/Adapter/Product/PriceFormatter.php
194/src/Adapter/Image/ImageRetriever.php
195/classes/tax/TaxConfiguration.php
196/classes/Smarty/TemplateFinder.php
197/classes/assets/StylesheetManager.php
198/classes/assets/AbstractAssetManager.php
199/src/Adapter/Assets/AssetUrlGeneratorTrait.php
200/classes/assets/JavascriptManager.php
201/classes/assets/CccReducer.php
202/classes/Category.php
203/src/Adapter/ContainerBuilder.php
204/src/Adapter/Environment.php
205/src/Core/EnvironmentInterface.php
206/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Setup.php
207/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ArrayCache.php
208/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
209/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
210/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
211/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
212/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
213/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
214/vendor/doctrine/orm/lib/Doctrine/ORM/Configuration.php
215/vendor/doctrine/dbal/lib/Doctrine/DBAL/Configuration.php
216/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php
217/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php
218/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Annotation.php
219/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Entity.php
220/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embeddable.php
221/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embedded.php
222/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/MappedSuperclass.php
223/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/InheritanceType.php
224/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorColumn.php
225/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorMap.php
226/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Id.php
227/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/GeneratedValue.php
228/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Version.php
229/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumn.php
230/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumns.php
231/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Column.php
232/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToOne.php
233/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToMany.php
234/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToOne.php
235/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToMany.php
236/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Table.php
237/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UniqueConstraint.php
238/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Index.php
239/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinTable.php
240/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SequenceGenerator.php
241/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/CustomIdGenerator.php
242/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ChangeTrackingPolicy.php
243/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OrderBy.php
244/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQueries.php
245/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQuery.php
246/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/HasLifecycleCallbacks.php
247/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PrePersist.php
248/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostPersist.php
249/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreUpdate.php
250/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostUpdate.php
251/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreRemove.php
252/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostRemove.php
253/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostLoad.php
254/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreFlush.php
255/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/FieldResult.php
256/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ColumnResult.php
257/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityResult.php
258/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQuery.php
259/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQueries.php
260/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMapping.php
261/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMappings.php
262/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverride.php
263/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverrides.php
264/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverride.php
265/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverrides.php
266/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityListeners.php
267/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Cache.php
268/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php
269/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php
270/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php
271/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php
272/vendor/doctrine/lexer/lib/Doctrine/Common/Lexer/AbstractLexer.php
273/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php
274/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/CachedReader.php
275/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/AnnotationDriver.php
276/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/Driver/AnnotationDriver.php
277/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/Driver/MappingDriver.php
278/var/cache/prod/FrontContainer.php
279/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
280/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
281/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
282/vendor/psr/container/src/ContainerInterface.php
283/modules/dashproducts/vendor/autoload.php
284/modules/dashproducts/vendor/composer/autoload_real.php
285/modules/dashproducts/vendor/composer/autoload_static.php
286/modules/ps_banner/vendor/autoload.php
287/modules/ps_banner/vendor/composer/autoload_real.php
288/modules/ps_banner/vendor/composer/autoload_static.php
289/modules/ps_contactinfo/vendor/autoload.php
290/modules/ps_contactinfo/vendor/composer/autoload_real.php
291/modules/ps_contactinfo/vendor/composer/autoload_static.php
292/modules/ps_currencyselector/vendor/autoload.php
293/modules/ps_currencyselector/vendor/composer/autoload_real.php
294/modules/ps_currencyselector/vendor/composer/autoload_static.php
295/modules/ps_customtext/vendor/autoload.php
296/modules/ps_customtext/vendor/composer/autoload_real.php
297/modules/ps_customtext/vendor/composer/autoload_static.php
298/modules/ps_emailsubscription/vendor/autoload.php
299/modules/ps_emailsubscription/vendor/composer/autoload_real.php
300/modules/ps_emailsubscription/vendor/composer/autoload_static.php
301/modules/ps_faviconnotificationbo/vendor/autoload.php
302/modules/ps_faviconnotificationbo/vendor/composer/autoload_real.php
303/modules/ps_faviconnotificationbo/vendor/composer/autoload_static.php
304/modules/ps_featuredproducts/vendor/autoload.php
305/modules/ps_featuredproducts/vendor/composer/autoload_real.php
306/modules/ps_featuredproducts/vendor/composer/autoload_static.php
307/modules/ps_imageslider/vendor/autoload.php
308/modules/ps_imageslider/vendor/composer/autoload_real.php
309/modules/ps_imageslider/vendor/composer/autoload_static.php
310/modules/ps_shoppingcart/vendor/autoload.php
311/modules/ps_shoppingcart/vendor/composer/autoload_real.php
312/modules/ps_shoppingcart/vendor/composer/autoload_static.php
313/modules/ps_themecusto/vendor/autoload.php
314/modules/ps_themecusto/vendor/composer/autoload_real.php
315/modules/ps_themecusto/vendor/composer/autoload_static.php
316/modules/statsbestcategories/vendor/autoload.php
317/modules/statsbestcategories/vendor/composer/autoload_real.php
318/modules/statsbestcategories/vendor/composer/autoload_static.php
319/modules/statsbestcustomers/vendor/autoload.php
320/modules/statsbestcustomers/vendor/composer/autoload_real.php
321/modules/statsbestcustomers/vendor/composer/autoload_static.php
322/modules/statsproduct/vendor/autoload.php
323/modules/statsproduct/vendor/composer/autoload_real.php
324/modules/statsproduct/vendor/composer/autoload_static.php
325/modules/welcome/vendor/autoload.php
326/modules/welcome/vendor/composer/autoload_real.php
327/modules/welcome/vendor/composer/autoload_namespaces.php
328/modules/welcome/vendor/composer/autoload_psr4.php
329/modules/welcome/vendor/composer/autoload_classmap.php
330/modules/gamification/vendor/autoload.php
331/modules/gamification/vendor/composer/autoload_real.php
332/modules/gamification/vendor/composer/autoload_static.php
333/modules/psaddonsconnect/vendor/autoload.php
334/modules/psaddonsconnect/vendor/composer/autoload_real.php
335/modules/psaddonsconnect/vendor/composer/autoload_static.php
336/modules/ps_mbo/vendor/autoload.php
337/modules/ps_mbo/vendor/composer/autoload_real.php
338/modules/ps_mbo/vendor/composer/autoload_static.php
339/modules/ps_buybuttonlite/vendor/autoload.php
340/modules/ps_buybuttonlite/vendor/composer/autoload_real.php
341/modules/ps_buybuttonlite/vendor/composer/autoload_static.php
342/modules/blockreassurance/vendor/autoload.php
343/modules/blockreassurance/vendor/composer/autoload_real.php
344/modules/blockreassurance/vendor/composer/autoload_static.php
345/modules/ps_newproducts/vendor/autoload.php
346/modules/ps_newproducts/vendor/composer/autoload_real.php
347/modules/ps_newproducts/vendor/composer/autoload_static.php
348/modules/ps_linklist/vendor/autoload.php
349/modules/ps_linklist/vendor/composer/autoload_real.php
350/modules/ps_linklist/vendor/composer/autoload_static.php
351/modules/ps_facetedsearch/vendor/autoload.php
352/modules/ps_facetedsearch/vendor/composer/autoload_real.php
353/modules/ps_facetedsearch/vendor/composer/autoload_static.php
354/modules/ps_emailalerts/vendor/autoload.php
355/modules/ps_emailalerts/vendor/composer/autoload_real.php
356/modules/ps_emailalerts/vendor/composer/autoload_static.php
357/modules/ps_emailalerts/vendor/symfony/polyfill-php72/bootstrap.php
358/modules/pscleaner/vendor/autoload.php
359/modules/pscleaner/vendor/composer/autoload_real.php
360/modules/pscleaner/vendor/composer/autoload_static.php
361/modules/mollie/vendor/autoload.php
362/modules/mollie/vendor/composer/autoload_real.php
363/modules/mollie/vendor/composer/autoload_static.php
364/modules/mollie/vendor/segmentio/analytics-php/lib/Segment.php
365/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/Client.php
366/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/Consumer.php
367/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/QueueConsumer.php
368/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/Consumer/File.php
369/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/Consumer/ForkCurl.php
370/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/Consumer/LibCurl.php
371/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/Consumer/Socket.php
372/modules/mollie/vendor/segmentio/analytics-php/lib/Segment/Version.php
373/modules/sendcloudv2/vendor/autoload.php
374/modules/sendcloudv2/vendor/composer/autoload_real.php
375/modules/sendcloudv2/vendor/composer/platform_check.php
376/modules/sendcloudv2/vendor/composer/autoload_static.php
377/src/Core/Localization/Locale/Repository.php
378/src/Core/Localization/Locale/RepositoryInterface.php
379/src/Core/Localization/CLDR/LocaleRepository.php
380/src/Core/Localization/CLDR/LocaleDataSource.php
381/src/Core/Localization/CLDR/DataLayer/LocaleCache.php
382/src/Core/Data/Layer/AbstractDataLayer.php
383/src/Core/Localization/CLDR/LocaleDataLayerInterface.php
384/vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/FilesystemAdapter.php
385/vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AbstractAdapter.php
386/vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/AbstractTrait.php
387/vendor/psr/log/Psr/Log/LoggerAwareTrait.php
388/vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AdapterInterface.php
389/vendor/psr/cache/src/CacheItemPoolInterface.php
390/vendor/psr/log/Psr/Log/LoggerAwareInterface.php
391/vendor/symfony/symfony/src/Symfony/Component/Cache/ResettableInterface.php
392/vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemTrait.php
393/vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemCommonTrait.php
394/vendor/symfony/symfony/src/Symfony/Component/Cache/PruneableInterface.php
395/vendor/symfony/symfony/src/Symfony/Component/Cache/CacheItem.php
396/vendor/psr/cache/src/CacheItemInterface.php
397/src/Core/Localization/CLDR/DataLayer/LocaleReference.php
398/src/Core/Localization/CLDR/Reader.php
399/src/Core/Localization/CLDR/ReaderInterface.php
400/src/Core/Localization/Currency/Repository.php
401/src/Core/Localization/Currency/RepositoryInterface.php
402/src/Core/Localization/Currency/CurrencyDataSource.php
403/src/Core/Localization/Currency/DataSourceInterface.php
404/src/Core/Localization/Currency/DataLayer/CurrencyCache.php
405/src/Core/Localization/Currency/CurrencyDataLayerInterface.php
406/vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/ArrayAdapter.php
407/vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/ArrayTrait.php
408/src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php
409/src/Adapter/Currency/CurrencyDataProvider.php
410/src/Core/Currency/CurrencyDataProviderInterface.php
411/src/Adapter/LegacyContext.php
412/src/Adapter/Tools.php
413/src/Core/Localization/Currency/DataLayer/CurrencyReference.php
414/src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php
415/vendor/prestashop/decimal/src/Operation/Rounding.php
416/src/Core/Localization/Locale.php
417/src/Core/Localization/LocaleInterface.php
418/src/Core/Localization/Specification/Price.php
419/src/Core/Localization/Specification/Number.php
420/src/Core/Localization/Specification/NumberInterface.php
421/src/Core/Localization/Specification/Factory.php
422/src/Core/Localization/CLDR/LocaleData.php
423/src/Core/Localization/CLDR/NumberSymbolsData.php
424/src/Core/Localization/CLDR/CurrencyData.php
425/src/Core/Localization/CLDR/Locale.php
426/src/Core/Localization/CLDR/LocaleInterface.php
427/src/Core/Localization/Specification/NumberSymbolList.php
428/src/Core/Localization/Currency/CurrencyCollection.php
429/classes/Currency.php
430/src/Core/Localization/Currency/LocalizedCurrencyId.php
431/src/Core/Localization/Currency/CurrencyData.php
432/src/Core/Localization/Currency.php
433/src/Core/Localization/CurrencyInterface.php
434/src/Core/Localization/Specification/NumberCollection.php
435/src/Core/Localization/Number/Formatter.php
436/vendor/geoip2/geoip2/src/Database/Reader.php
437/vendor/geoip2/geoip2/src/ProviderInterface.php
438/vendor/maxmind-db/reader/src/MaxMind/Db/Reader.php
439/vendor/maxmind-db/reader/src/MaxMind/Db/Reader/Decoder.php
440/vendor/maxmind-db/reader/src/MaxMind/Db/Reader/Util.php
441/vendor/maxmind-db/reader/src/MaxMind/Db/Reader/Metadata.php
442/vendor/geoip2/geoip2/src/Model/City.php
443/vendor/geoip2/geoip2/src/Model/Country.php
444/vendor/geoip2/geoip2/src/Model/AbstractModel.php
445/vendor/geoip2/geoip2/src/Compat/JsonSerializable.php
446/vendor/geoip2/geoip2/src/Record/Continent.php
447/vendor/geoip2/geoip2/src/Record/AbstractPlaceRecord.php
448/vendor/geoip2/geoip2/src/Record/AbstractRecord.php
449/vendor/geoip2/geoip2/src/Record/Country.php
450/vendor/geoip2/geoip2/src/Record/MaxMind.php
451/vendor/geoip2/geoip2/src/Record/RepresentedCountry.php
452/vendor/geoip2/geoip2/src/Record/Traits.php
453/vendor/geoip2/geoip2/src/Record/City.php
454/vendor/geoip2/geoip2/src/Record/Location.php
455/vendor/geoip2/geoip2/src/Record/Postal.php
456/vendor/geoip2/geoip2/src/Record/Subdivision.php
457/classes/Cart.php
458/src/Adapter/AddressFactory.php
459/classes/CartRule.php
460/classes/Product.php
461/override/classes/Product.php
462/classes/Pack.php
463/classes/webservice/WebserviceRequest.php
464/classes/ImageType.php
465/classes/ImageManager.php
466/classes/module/Module.php
467/src/Core/Module/ModuleInterface.php
468/modules/blockreassurance/blockreassurance.php
469/src/Core/Module/WidgetInterface.php
470/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php
471/vendor/smarty/smarty/libs/sysplugins/smarty_data.php
472/src/PrestaShopBundle/Translation/DomainNormalizer.php
473/src/Adapter/Localization/LegacyTranslator.php
474/classes/Translate.php
475/modules/blockreassurance/translations/nl.php
476/classes/Media.php
477/modules/mollie/mollie.php
478/classes/PaymentModule.php
479/modules/mollie/translations/nl.php
480/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerBuilder.php
481/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/TaggedContainerInterface.php
482/modules/mollie/vendor/vlucas/phpdotenv/src/Dotenv.php
483/modules/mollie/src/Repository/ModuleRepository.php
484/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/EnvPlaceholderParameterBag.php
485/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php
486/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBagInterface.php
487/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ResourceInterface.php
488/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Definition.php
489/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Alias.php
490/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocator.php
491/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocatorInterface.php
492/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/YamlFileLoader.php
493/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Loader/FileLoader.php
494/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/FileLoader.php
495/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/Loader.php
496/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/LoaderInterface.php
497/vendor/symfony/symfony/src/Symfony/Component/Yaml/Parser.php
498/vendor/symfony/symfony/src/Symfony/Component/Yaml/Yaml.php
499/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php
500/vendor/symfony/symfony/src/Symfony/Component/Yaml/Unescaper.php
501/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/ComposerResource.php
502/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceInterface.php
503/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/FileResource.php
504/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Reference.php
505/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Expression.php
506/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/Compiler.php
507/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/PassConfig.php
508/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/MergeExtensionConfigurationPass.php
509/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CompilerPassInterface.php
510/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveClassPass.php
511/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveInstanceofConditionalsPass.php
512/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RegisterEnvVarProcessorsPass.php
513/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ExtensionCompilerPass.php
514/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveChildDefinitionsPass.php
515/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AbstractRecursivePass.php
516/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceLocatorTagPass.php
517/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RegisterServiceSubscribersPass.php
518/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/DecoratorServicePass.php
519/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveParameterPlaceHoldersPass.php
520/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveFactoryClassPass.php
521/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/FactoryReturnTypePass.php
522/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckDefinitionValidityPass.php
523/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveNamedArgumentsPass.php
524/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AutowireRequiredMethodsPass.php
525/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveBindingsPass.php
526/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AutowirePass.php
527/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveTaggedIteratorArgumentPass.php
528/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/PriorityTaggedServiceTrait.php
529/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveServiceSubscribersPass.php
530/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveReferencesToAliasesPass.php
531/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveInvalidReferencesPass.php
532/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/AnalyzeServiceReferencesPass.php
533/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatablePassInterface.php
534/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckCircularReferencesPass.php
535/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckReferenceValidityPass.php
536/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckArgumentsValidityPass.php
537/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolvePrivatesPass.php
538/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemovePrivateAliasesPass.php
539/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ReplaceAliasByActualDefinitionPass.php
540/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveAbstractDefinitionsPass.php
541/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RepeatedPass.php
542/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/InlineServiceDefinitionsPass.php
543/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/RemoveUnusedDefinitionsPass.php
544/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/DefinitionErrorExceptionPass.php
545/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php
546/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ResolveHotPathPass.php
547/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraph.php
548/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/EnvVarProcessor.php
549/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/EnvVarProcessorInterface.php
550/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Exception/RuntimeException.php
551/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Exception/ExceptionInterface.php
552/vendor/psr/container/src/ContainerExceptionInterface.php
553/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraphNode.php
554/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/ServiceReferenceGraphEdge.php
555/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ExpressionLanguage.php
556/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/ExpressionLanguage.php
557/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ExpressionLanguageProvider.php
558/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/ExpressionFunctionProviderInterface.php
559/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/ExpressionFunction.php
560/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Compiler.php
561/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Parser.php
562/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Lexer.php
563/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Token.php
564/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/TokenStream.php
565/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Node/FunctionNode.php
566/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Node/Node.php
567/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Node/ConstantNode.php
568/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Node/ArgumentsNode.php
569/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Node/ArrayNode.php
570/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/Node/GetAttrNode.php
571/vendor/symfony/symfony/src/Symfony/Component/ExpressionLanguage/ParsedExpression.php
572/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/FrozenParameterBag.php
573/modules/mollie/vendor/vlucas/phpdotenv/src/Loader.php
574/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/DotenvFactory.php
575/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/FactoryInterface.php
576/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/Adapter/ApacheAdapter.php
577/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/Adapter/AdapterInterface.php
578/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/Adapter/EnvConstAdapter.php
579/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/Adapter/ServerConstAdapter.php
580/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/Adapter/PutenvAdapter.php
581/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/DotenvVariables.php
582/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/AbstractVariables.php
583/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/VariablesInterface.php
584/modules/mollie/vendor/vlucas/phpdotenv/src/Environment/Adapter/ArrayAdapter.php
585/modules/mollie/vendor/phpoption/phpoption/src/PhpOption/Option.php
586/modules/mollie/vendor/phpoption/phpoption/src/PhpOption/Some.php
587/modules/mollie/vendor/vlucas/phpdotenv/src/Lines.php
588/modules/mollie/vendor/vlucas/phpdotenv/src/Parser.php
589/modules/mollie/vendor/phpoption/phpoption/src/PhpOption/None.php
590/modules/mollie/src/Service/ApiKeyService.php
591/modules/mollie/src/Config/Config.php
592/modules/mollie/vendor/mollie/mollie-api-php/src/MollieApiClient.php
593/modules/mollie/vendor/mollie/mollie-api-php/src/HttpAdapter/MollieHttpAdapterPicker.php
594/modules/mollie/vendor/mollie/mollie-api-php/src/HttpAdapter/MollieHttpAdapterPickerInterface.php
595/vendor/guzzlehttp/guzzle/src/ClientInterface.php
596/vendor/guzzlehttp/guzzle/src/Event/HasEmitterInterface.php
597/modules/mollie/vendor/mollie/mollie-api-php/src/HttpAdapter/CurlMollieHttpAdapter.php
598/modules/mollie/vendor/mollie/mollie-api-php/src/HttpAdapter/MollieHttpAdapterInterface.php
599/modules/mollie/vendor/mollie/mollie-api-php/src/CompatibilityChecker.php
600/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/PaymentEndpoint.php
601/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/CollectionEndpointAbstract.php
602/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/EndpointAbstract.php
603/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/MethodEndpoint.php
604/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/ProfileMethodEndpoint.php
605/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/CustomerEndpoint.php
606/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/SettlementsEndpoint.php
607/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/SettlementPaymentEndpoint.php
608/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/SubscriptionEndpoint.php
609/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/CustomerPaymentsEndpoint.php
610/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/MandateEndpoint.php
611/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/InvoiceEndpoint.php
612/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/PermissionEndpoint.php
613/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/ProfileEndpoint.php
614/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/OnboardingEndpoint.php
615/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/OrganizationEndpoint.php
616/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/OrderEndpoint.php
617/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/OrderLineEndpoint.php
618/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/OrderPaymentEndpoint.php
619/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/OrderRefundEndpoint.php
620/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/ShipmentEndpoint.php
621/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/RefundEndpoint.php
622/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/PaymentRefundEndpoint.php
623/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/PaymentCaptureEndpoint.php
624/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/ChargebackEndpoint.php
625/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/PaymentChargebackEndpoint.php
626/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/WalletEndpoint.php
627/modules/mollie/vendor/mollie/mollie-api-php/src/Endpoints/PaymentLinkEndpoint.php
628/modules/mollie/src/Handler/ErrorHandler/ErrorHandler.php
629/modules/mollie/src/Config/Env.php
630/modules/mollie/src/Handler/ErrorHandler/ModuleFilteredRavenClient.php
631/modules/mollie/vendor/sentry/sentry/lib/Raven/Client.php
632/modules/mollie/vendor/sentry/sentry/lib/Raven/Util.php
633/modules/mollie/vendor/sentry/sentry/lib/Raven/Compat.php
634/modules/mollie/vendor/sentry/sentry/lib/Raven/Processor/SanitizeDataProcessor.php
635/modules/mollie/vendor/sentry/sentry/lib/Raven/Processor.php
636/modules/mollie/vendor/sentry/sentry/lib/Raven/Context.php
637/modules/mollie/vendor/sentry/sentry/lib/Raven/Breadcrumbs.php
638/modules/mollie/vendor/sentry/sentry/lib/Raven/Serializer.php
639/modules/mollie/vendor/sentry/sentry/lib/Raven/ReprSerializer.php
640/modules/mollie/vendor/sentry/sentry/lib/Raven/TransactionStack.php
641/modules/mollie/vendor/sentry/sentry/lib/Raven/Breadcrumbs/ErrorHandler.php
642/modules/mollie/vendor/sentry/sentry/lib/Raven/Stacktrace.php
643/modules/mollie/vendor/sentry/sentry/lib/Raven/ErrorHandler.php
644/modules/mollie/src/Service/ErrorDisplayService.php
645/modules/mollie/src/Utility/EnvironmentUtility.php
646/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
647/var/cache/prod/smarty/compile/71/6f/93/716f930d047477e41f7c9983d17f3b6330acc82b_2.file.custom_css.tpl.php
648/vendor/smarty/smarty/libs/plugins/modifier.escape.php
649/classes/ProductDownload.php
650/classes/tax/Tax.php
651/src/Core/Cart/Calculator.php
652/src/Core/Cart/CartRowCollection.php
653/src/Core/Cart/Fees.php
654/src/Core/Cart/CartRuleCollection.php
655/src/Core/Cart/CartRuleCalculator.php
656/src/Adapter/Product/PriceCalculator.php
657/classes/order/Order.php
658/src/Core/Cart/CartRow.php
659/src/Core/Cart/AmountImmutable.php
660/vendor/prestashop/decimal/src/Number.php
661/vendor/prestashop/decimal/src/Builder.php
662/classes/Gender.php
663/classes/Risk.php
664/classes/Meta.php
665/classes/Address.php
666/classes/State.php
667/src/Core/Addon/Module/ModuleManagerBuilder.php
668/src/Core/Util/File/YamlParser.php
669/vendor/symfony/symfony/src/Symfony/Component/Config/Resource/SelfCheckingResourceChecker.php
670/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerInterface.php
671/var/cache/prod/yaml/2ef406ecf5734ee8caf074fb1d3f5b50.php
672/var/cache/prod/yaml/f3e68da10a3b5718bcaf3f572d08f1d1.php
673/src/PrestaShopBundle/Service/DataProvider/Marketplace/ApiClient.php
674/vendor/guzzlehttp/guzzle/src/Client.php
675/vendor/guzzlehttp/guzzle/src/Event/HasEmitterTrait.php
676/vendor/guzzlehttp/guzzle/src/Url.php
677/vendor/guzzlehttp/guzzle/src/Utils.php
678/vendor/guzzlehttp/guzzle/src/Message/MessageFactory.php
679/vendor/guzzlehttp/guzzle/src/Event/ListenerAttacherTrait.php
680/vendor/guzzlehttp/guzzle/src/Message/MessageFactoryInterface.php
681/vendor/guzzlehttp/guzzle/src/Subscriber/HttpError.php
682/vendor/guzzlehttp/guzzle/src/Event/SubscriberInterface.php
683/vendor/guzzlehttp/guzzle/src/Subscriber/Redirect.php
684/vendor/guzzlehttp/ringphp/src/Client/CurlHandler.php
685/vendor/guzzlehttp/ringphp/src/Client/CurlFactory.php
686/vendor/guzzlehttp/ringphp/src/Client/CurlMultiHandler.php
687/vendor/guzzlehttp/ringphp/src/Client/Middleware.php
688/vendor/guzzlehttp/ringphp/src/Client/StreamHandler.php
689/vendor/guzzlehttp/guzzle/src/RequestFsm.php
690/app/config/parameters.php
691/src/Adapter/Module/ModuleZipManager.php
692/src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php
693/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcherInterface.php
694/src/Core/Hook/HookDispatcherInterface.php
695/src/Adapter/Addons/AddonsDataProvider.php
696/src/PrestaShopBundle/Service/DataProvider/Admin/AddonsInterface.php
697/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
698/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
699/src/Adapter/LegacyLogger.php
700/vendor/psr/log/Psr/Log/LoggerInterface.php
701/src/PrestaShopBundle/Service/DataProvider/Admin/CategoriesProvider.php
702/src/Adapter/Module/ModuleDataProvider.php
703/src/Adapter/Module/AdminModuleDataProvider.php
704/src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php
705/vendor/symfony/symfony/src/Symfony/Component/Routing/Loader/YamlFileLoader.php
706/vendor/symfony/symfony/src/Symfony/Component/Routing/Router.php
707/vendor/symfony/symfony/src/Symfony/Component/Routing/RouterInterface.php
708/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/UrlMatcherInterface.php
709/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContextAwareInterface.php
710/vendor/symfony/symfony/src/Symfony/Component/Routing/Generator/UrlGeneratorInterface.php
711/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/RequestMatcherInterface.php
712/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContext.php
713/src/Adapter/Module/ModuleDataUpdater.php
714/src/Core/Addon/Module/ModuleManager.php
715/src/Core/Addon/AddonManagerInterface.php
716/src/Core/Addon/Module/ModuleRepository.php
717/src/Core/Addon/Module/ModuleRepositoryInterface.php
718/vendor/symfony/symfony/src/Symfony/Component/Finder/Finder.php
719/src/Adapter/Cache/Clearer/SymfonyCacheClearer.php
720/src/Core/Cache/Clearer/CacheClearerInterface.php
721/src/Core/Filter/FrontEndObject/MainFilter.php
722/src/Core/Filter/FilterInterface.php
723/src/Core/Filter/FrontEndObject/CartFilter.php
724/src/Core/Filter/HashMapWhitelistFilter.php
725/src/Core/Filter/CollectionFilter.php
726/src/Core/Filter/FrontEndObject/ProductFilter.php
727/src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php
728/src/Core/Filter/FrontEndObject/CustomerFilter.php
729/src/Core/Filter/FrontEndObject/ShopFilter.php
730/src/Core/Filter/FrontEndObject/ConfigurationFilter.php
731/modules/ps_imageslider/ps_imageslider.php
732/modules/ps_imageslider/Ps_HomeSlide.php
733/modules/ps_shoppingcart/ps_shoppingcart.php
734/modules/uecookie/uecookie.php
735/themes/silverado/modules/uecookie/translations/nl.php
736/modules/uecookie/translations/nl.php
737/modules/uecookie/key.php
738/modules/ps_searchbar/ps_searchbar.php
739/modules/blockreinsurancecustom/blockreinsurancecustom.php
740/modules/blockreinsurancecustom/reinsurancecustomClass.php
741/modules/blockreinsurancecustom/translations/nl.php
742/modules/storeggmap/storeggmap.php
743/modules/storeggmap/translations/nl.php
744/modules/scrolltop/scrolltop.php
745/modules/scrolltop/translations/nl.php
746/modules/tinymcepro/tinymcepro.php
747/modules/tinymcepro/translations/nl.php
748/modules/tinymcepro/key.php
749/var/cache/prod/smarty/compile/54/75/90/547590745e15d594d950d6107f9b95ca00c8668c_2.file.header.tpl.php
750/modules/ps_emailalerts/ps_emailalerts.php
751/modules/ps_emailalerts/MailAlert.php
752/modules/productcomments/productcomments.php
753/modules/productcomments/ProductComment.php
754/modules/productcomments/ProductCommentCriterion.php
755/modules/productcomments/translations/nl.php
756/modules/prodquestions/prodquestions.php
757/modules/prodquestions/translations/nl.php
758/classes/controller/AdminController.php
759/modules/prodquestions/classes/ps17helpprodquestions.class.php
760/vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php
761/vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php
762/vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php
763/var/cache/prod/smarty/cache/prodquestions/head_tpl/1/1/1/21/a4/91/d4/a491d4310545f4ef7cd2adaf706fce6f82feddf6.head.tpl.php
764/modules/reviewsreply/reviewsreply.php
765/modules/reviewsreply/models/rreply.php
766/modules/reviewsreply/translations/nl.php
767/modules/reviewsreply/key.php
768/modules/facebookpsconnect/facebookpsconnect.php
769/modules/facebookpsconnect/conf/common.conf.php
770/modules/facebookpsconnect/lib/warning_class.php
771/modules/facebookpsconnect/lib/module-tools_class.php
772/modules/facebookpsconnect/nl.php
773/modules/facebookpsconnect/conf/hook.conf.php
774/modules/facebookpsconnect/lib/hook/hook-ctrl_class.php
775/modules/facebookpsconnect/lib/hook/i-hook_class.php
776/modules/facebookpsconnect/lib/hook/hook-display_class.php
777/modules/facebookpsconnect/lib/module-dao_class.php
778/modules/facebookpsconnect/lib/render/facade-render-connectors_class.php
779/modules/facebookpsconnect/lib/render/render-connectors_class.php
780/var/cache/prod/smarty/compile/ee/cb/16/eecb160c1136e8d97673e11774da392d45bd79c6_2.file.header.tpl.php
781/modules/everpscaptcha/everpscaptcha.php
782/modules/everpscaptcha/translations/nl.php
783/var/cache/prod/smarty/compile/1a/2f/85/1a2f854269372491cb1a77179c8ffdb880e148be_2.file.ever-ps-captcha.tpl.php
784/modules/sendcloudv2/sendcloudv2.php
785/classes/module/CarrierModule.php
786/modules/sendcloudv2/translations/nl.php
787/modules/sendcloudv2/classes/Bootstrap/Bootstrap.php
788/modules/sendcloudv2/classes/Bootstrap/ServiceRegister.php
789/modules/sendcloudv2/vendor/sendcloud/integration-core/src/Infrastructure/ServiceRegister.php
790/src/Core/Product/Search/ProductSearchContext.php
791/src/Core/Product/Search/ProductSearchQuery.php
792/src/Core/Product/Search/SortOrder.php
793/modules/ps_facetedsearch/ps_facetedsearch.php
794/modules/ps_facetedsearch/src/HookDispatcher.php
795/modules/ps_facetedsearch/src/Hook/Attribute.php
796/modules/ps_facetedsearch/src/Hook/AbstractHook.php
797/modules/ps_facetedsearch/src/Hook/AttributeGroup.php
798/modules/ps_facetedsearch/src/Hook/Category.php
799/modules/ps_facetedsearch/src/Hook/Design.php
800/modules/ps_facetedsearch/src/Hook/Feature.php
801/modules/ps_facetedsearch/src/Form/Feature/FormModifier.php
802/modules/ps_facetedsearch/src/Form/Feature/FormDataProvider.php
803/modules/ps_facetedsearch/src/Hook/FeatureValue.php
804/modules/ps_facetedsearch/src/Hook/Product.php
805/modules/ps_facetedsearch/src/Hook/ProductSearch.php
806/modules/ps_facetedsearch/src/Hook/SpecificPrice.php
807/modules/ps_facetedsearch/src/Product/SearchProvider.php
808/src/Core/Product/Search/FacetsRendererInterface.php
809/src/Core/Product/Search/ProductSearchProviderInterface.php
810/modules/ps_facetedsearch/src/Filters/Converter.php
811/modules/ps_facetedsearch/src/URLSerializer.php
812/src/Core/Product/Search/ProductSearchResult.php
813/src/Core/Product/Search/URLFragmentSerializer.php
814/classes/AttributeGroup.php
815/classes/Combination.php
816/modules/ps_facetedsearch/src/Product/Search.php
817/modules/ps_facetedsearch/src/Adapter/MySQL.php
818/modules/ps_facetedsearch/src/Adapter/AbstractAdapter.php
819/modules/ps_facetedsearch/src/Adapter/InterfaceAdapter.php
820/vendor/doctrine/collections/lib/Doctrine/Common/Collections/ArrayCollection.php
821/vendor/doctrine/collections/lib/Doctrine/Common/Collections/Collection.php
822/vendor/doctrine/collections/lib/Doctrine/Common/Collections/Selectable.php
823/modules/ps_facetedsearch/src/Filters/Products.php
824/classes/stock/StockAvailable.php
825/modules/ps_facetedsearch/src/Filters/Block.php
826/src/Core/Product/Search/Facet.php
827/src/Core/Product/Search/Filter.php
828/src/Core/Product/Search/FacetCollection.php
829/classes/ProductAssembler.php
830/classes/SpecificPrice.php
831/classes/tax/TaxManagerFactory.php
832/classes/tax/TaxRulesTaxManager.php
833/classes/tax/TaxManagerInterface.php
834/classes/tax/TaxCalculator.php
835/classes/GroupReduction.php
836/classes/Feature.php
837/classes/ProductPresenterFactory.php
838/src/Adapter/Presenter/Product/ProductListingPresenter.php
839/src/Adapter/Presenter/Product/ProductPresenter.php
840/src/Adapter/Product/ProductColorsRetriever.php
841/src/Core/Product/ProductPresentationSettings.php
842/src/Adapter/Presenter/Product/ProductListingLazyArray.php
843/src/Adapter/Presenter/Product/ProductLazyArray.php
844/src/Adapter/Presenter/AbstractLazyArray.php
845/classes/Image.php
846/vendor/doctrine/common/lib/Doctrine/Common/Util/Inflector.php
847/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php
848/var/cache/prod/smarty/compile/d4/1d/65/d41d65d76b9471b5d365fe06cf1737c89a53af9f_2.module.psfacetedsearchviewstempl.php
849/vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php
850/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
851/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php
852/var/cache/prod/smarty/compile/2e/80/73/2e807335546cfa2360c36327ac89dd2fcb054379_2.module.psfacetedsearchviewstempl.php
853/src/Core/Product/Search/Pagination.php
854/vendor/defuse/php-encryption/src/Crypto.php
855/vendor/defuse/php-encryption/src/KeyOrPassword.php
856/vendor/defuse/php-encryption/src/RuntimeTests.php
857/vendor/defuse/php-encryption/src/DerivedKeys.php
858/vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
859/vendor/defuse/php-encryption/src/Exception/CryptoException.php
860/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/24/46/f2/2446f27a12bb4a43c2c176ba9b1af9c59563c982_2.file.category.tpl.php
861/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/85/d9/6b/85d96b85432263005d856c042794b83df6e4b94a_2.file.product-list.tpl.php
862/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/99/59/56/9959568d11d20225442bd1816bd943c8c0a977f4_2.file.layout-left-column.tpl.php
863/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/27/29/bf/2729bf948f8a30716bf96c7eea079ec65eb15b00_2.file.layout-both-columns.tpl.php
864/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/0a/6a/5c/0a6a5cbc29d819bc0759765872d98ec4808fb55a_2.file.head.tpl.php
865/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/3b/db/c7/3bdbc7684379985feb32921541e5ad3021b41512_2.file.stylesheets.tpl.php
866/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/34/a0/52/34a0525097813aa0ce8971bfd43b85596856215f_2.file.javascript.tpl.php
867/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/38/05/17/380517b2fcf761b50f425872f73f9e0abe57362f_2.file.product-activation.tpl.php
868/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/74/fe/9b/74fe9bbea32d82bfb33adc3804b264711b573360_2.file.header.tpl.php
869/modules/ps_contactinfo/ps_contactinfo.php
870/var/cache/prod/smarty/compile/0e/b2/11/0eb2119957cbc13b240126b3ccd8fac8f109f1e2_2.module.pscontactinfonav.tpl.php
871/modules/ps_languageselector/ps_languageselector.php
872/modules/ps_customersignin/ps_customersignin.php
873/var/cache/prod/smarty/compile/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.pscustomersigninpscustome.php
874/src/Adapter/Cart/CartPresenter.php
875/var/cache/prod/smarty/compile/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.psshoppingcartpsshoppingc.php
876/modules/ps_mainmenu/ps_mainmenu.php
877/modules/ps_mainmenu/ps_menutoplinks.class.php
878/var/cache/prod/smarty/compile/41/df/19/41df1985130dffd7d3fe4cb369091546a0b40be7_2.module.psmainmenupsmainmenu.tpl.php
879/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_tplfunction.php
880/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php
881/var/cache/prod/smarty/compile/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.pssearchbarpssearchbar.tp.php
882/modules/facebookpsconnect/lib/render/iterator-render-connectors_class.php
883/var/cache/prod/smarty/compile/0e/60/64/0e6064a1c6c9d0d7b4a8a949ea6354e9accaf6fa_2.file.connector-buttons-js.tpl.php
884/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/29/89/ab/2989abdff1bd2b41e7490c2bf0f4aecd05b328c4_2.file.notifications.tpl.php
885/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/5d/ac/70/5dac70e08f91ec018d345c1a1f1bebcae3bbd46d_2.file.breadcrumb.tpl.php
886/modules/ps_categorytree/ps_categorytree.php
887/var/cache/prod/smarty/compile/89/21/00/8921007f54626fc7fe42cbff53f1d70828d3393d_2.module.pscategorytreeviewstempla.php
888/var/cache/prod/smarty/compile/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.psfacetedsearchpsfaceteds.php
889/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/83/16/45/8316451abe35bee391564ca99956b6f394afd997_2.file.category-header.tpl.php
890/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/a6/e1/05/a6e105de00890a208c4d0bdf684caf74a1f666e1_2.file.products-top.tpl.php
891/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/f2/22/48/f222483674d612b429c4f23241fbbe14a0be09b6_2.file.sort-orders.tpl.php
892/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/00/f8/b800f8d2da8a05dec2eb086fd9da4785dacc192d_2.file.toppagination.tpl.php
893/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ba/52/b2/ba52b2ecdec4382eeaffc909aa013748de403a53_2.file.products.tpl.php
894/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/09/35/8d/09358d18bf4fc6784513e750096f15ce74f95351_2.file.product.tpl.php
895/var/cache/prod/smarty/cache/productcomments/1/1/1/21/344/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
896/vendor/smarty/smarty/libs/plugins/modifier.date_format.php
897/var/cache/prod/smarty/cache/productcomments/1/1/1/21/347/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
898/var/cache/prod/smarty/cache/productcomments/1/1/1/21/216/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
899/var/cache/prod/smarty/cache/productcomments/1/1/1/21/219/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
900/var/cache/prod/smarty/cache/productcomments/1/1/1/21/226/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
901/var/cache/prod/smarty/cache/productcomments/1/1/1/21/227/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
902/var/cache/prod/smarty/cache/productcomments/1/1/1/21/230/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
903/var/cache/prod/smarty/cache/productcomments/1/1/1/21/211/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
904/var/cache/prod/smarty/cache/productcomments/1/1/1/21/212/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
905/var/cache/prod/smarty/cache/productcomments/1/1/1/21/4115/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
906/var/cache/prod/smarty/cache/productcomments/1/1/1/21/103/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
907/var/cache/prod/smarty/cache/productcomments/1/1/1/21/126/c1/f2/a7/c1f2a7f03de24146630ba70eddd8d7aed3b07c25.productcommentsproductcom.php
908/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/29/a8/4d/29a84dc7b1e5607d1b561554ce47ecb10255c72e_2.file.pagination.tpl.php
909/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/87/81/59/87815921b4f48cdd68627a5eeed1c2dfc7725c69_2.file.products-bottom.tpl.php
910/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/64/c6/8e/64c68ec6a5c044b0fe1298eee71b843923ad764d_2.file.footer.tpl.php
911/modules/ps_emailsubscription/ps_emailsubscription.php
912/src/Core/Foundation/Database/EntityManager.php
913/src/Core/Foundation/Database/DatabaseInterface.php
914/src/Adapter/Database.php
915/var/cache/prod/smarty/compile/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef_2.module.psemailsubscriptionviewst.php
916/modules/ps_socialfollow/ps_socialfollow.php
917/var/cache/prod/smarty/cache/ps_socialfollow/1/1/1/21/ab/25/a0/ab25a0c56a57ecd9a1b7147526c76dbb0afddcb4.pssocialfollowpssocialfol.php
918/modules/ps_linklist/ps_linklist.php
919/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php
920/modules/ps_linklist/src/LegacyLinkBlockRepository.php
921/var/cache/prod/smarty/cache/ps_linklist/displayFooter/1/1/1/21/0f/8b/be/0f8bbe329b47ef7372e2ecba26ae0424d94c1cd3.pslinklistviewstemplatesh.php
922/modules/ps_customeraccountlinks/ps_customeraccountlinks.php
923/var/cache/prod/smarty/cache/ps_customeraccountlinks/1/1/1/21/b5/3f/27/b53f27fbb06c432be772edf0ac8fc207553147c1.pscustomeraccountlinkspsc.php
924/var/cache/prod/smarty/compile/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d_2.module.pscontactinfopscontactinf.php
925/var/cache/prod/smarty/compile/04/c5/4a/04c54ac25350ef2d9286c59a137b44196bd2c29b_2.file.top.tpl.php
926/modules/medgtranslate/medgtranslate.php
927/modules/medgtranslate/class/mediacom87.php
928/modules/medgtranslate/translations/nl.php
929/var/cache/prod/smarty/compile/4d/2c/ae/4d2caece99a5d9e563a887ec09fabbb4c6f7ec39_2.file.footer.tpl.php
930/var/cache/prod/smarty/compile/65/a8/5a/65a85a368d75a6e15a23ff7964477074384766f1_2.file.footer.tpl.php
931/modules/statsdata/statsdata.php
932/classes/Guest.php
933/modules/sendcloudv2/classes/Services/ServicePoints/ServicePointService.php
934/modules/sendcloudv2/classes/Interfaces/ModuleInterface.php
935/classes/Connection.php
936/classes/Page.php
937/classes/ConnectionsSource.php