Stationery
Notebooks, agendas, office accessories and more. Everything you need to combine the pleasant and the useful, either at work or at home.
Notebooks, agendas, office accessories and more. Everything you need to combine the pleasant and the useful, either at work or at home.
| Load Time | 744.095 ms |
| Querying Time | 70 ms |
| Queries | 228 |
| Memory Peak Usage | 12.9 Mb |
| Included Files | 1048 files - 12.55 Mb |
| PrestaShop Cache | - Mb |
| Global vars | 0.04 Mb |
| PrestaShop Version | 9.0.2 |
| PHP Version | 8.3.25 |
| MySQL Version | 10.6.19-MariaDB |
| Memory Limit | 512M |
| Max Execution Time | 300s |
| Smarty Cache | enabled |
| Smarty Compilation | never recompile |
| Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
|---|---|---|---|---|
| config | 295.281 ms | 295.281 ms | 4.04 Mb | 9.7 Mb |
| __construct | 0.025 ms | 295.306 ms | - Mb | 9.7 Mb |
| init | 62.613 ms | 357.919 ms | 0.91 Mb | 9.7 Mb |
| checkAccess | 0.001 ms | 357.920 ms | - Mb | 9.7 Mb |
| setMedia | 55.087 ms | 413.007 ms | 0.93 Mb | 9.7 Mb |
| postProcess | 0.002 ms | 413.009 ms | - Mb | 9.7 Mb |
| initHeader | 0.000 ms | 413.009 ms | - Mb | 9.7 Mb |
| initContent | 215.382 ms | 628.391 ms | 3.34 Mb | 9.7 Mb |
| initFooter | 0.002 ms | 628.393 ms | - Mb | 9.7 Mb |
| display | 115.702 ms | 744.095 ms | 3.54 Mb | 12.9 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| DisplayHeader | 51.429 ms | 0.65 Mb |
| displayProductListReviews | 43.586 ms | 0.63 Mb |
| ActionFrontControllerSetMedia | 37.872 ms | 0.67 Mb |
| DisplayBeforeBodyClosingTag | 8.021 ms | 0.34 Mb |
| displayLeftColumn | 5.465 ms | 0.25 Mb |
| displayNav2 | 4.716 ms | 0.30 Mb |
| ProductSearchProvider | 4.209 ms | 0.07 Mb |
| displayFooter | 2.291 ms | 0.19 Mb |
| DisplayFooter | 2.031 ms | 0.06 Mb |
| displayTop | 1.620 ms | 0.10 Mb |
| displayFooterBefore | 1.393 ms | 0.10 Mb |
| displayNav1 | 1.100 ms | 0.07 Mb |
| DisplayLeftColumn | 0.255 ms | 0.01 Mb |
| DisplayTop | 0.026 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.007 ms | - Mb |
| ModuleRoutes | 0.006 ms | - Mb |
| DisplayFooterBefore | 0.004 ms | - Mb |
| DisplayFooterAfter | 0.004 ms | - Mb |
| DisplayNavFullWidth | 0.004 ms | - Mb |
| 19 hook(s) | 164.039 ms | 3.44 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| ps_checkout | 76.262 ms | 0.72 Mb |
| blockreassurance | 3.017 ms | 0.13 Mb |
| blockwishlist | 2.580 ms | 0.07 Mb |
| ps_emailsubscription | 4.349 ms | 0.05 Mb |
| ps_socialfollow | 1.715 ms | 0.06 Mb |
| ps_facebook | 22.612 ms | 0.34 Mb |
| ps_accounts | 1.497 ms | 0.07 Mb |
| ps_emailalerts | 4.854 ms | 0.01 Mb |
| ps_shoppingcart | 1.895 ms | 0.08 Mb |
| ps_searchbar | 1.281 ms | 0.06 Mb |
| ps_imageslider | 4.095 ms | 0.03 Mb |
| productcomments | 46.491 ms | 0.64 Mb |
| psxmarketingwithgoogle | 3.167 ms | 0.02 Mb |
| ps_googleanalytics | 4.853 ms | 0.23 Mb |
| psshipping | 31.853 ms | 0.39 Mb |
| ps_facetedsearch | 13.713 ms | 0.16 Mb |
| ps_contactinfo | 2.750 ms | 0.10 Mb |
| ps_languageselector | 1.414 ms | 0.05 Mb |
| ps_currencyselector | 2.328 ms | 0.14 Mb |
| ps_customersignin | 1.051 ms | 0.05 Mb |
| ps_mainmenu | 6.466 ms | 0.13 Mb |
| pagesnotfound | 0.825 ms | 0.01 Mb |
| ps_categorytree | 4.616 ms | 0.20 Mb |
| ps_supplierlist | 1.073 ms | 0.05 Mb |
| ps_brandlist | 2.754 ms | 0.13 Mb |
| ps_linklist | 2.940 ms | 0.11 Mb |
| ps_customeraccountlinks | 1.080 ms | 0.07 Mb |
| statsdata | 5.019 ms | 0.21 Mb |
| 28 module(s) | 256.550 ms | 4.29 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 80 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN psj2_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute |
2.122 ms | 8 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 100 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psj2_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `psj2_hook_alias` ha INNER JOIN `psj2_hook` h ON ha.name = h.name |
1.958 ms | 0 | /classes/Hook.php:1568 | ||
| 2 | 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 `psj2_configuration` c LEFT JOIN `psj2_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
1.776 ms | 473 | /classes/Configuration.php:182 | ||
| 16 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `psj2_module` m INNER JOIN psj2_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1) INNER JOIN `psj2_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `psj2_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `psj2_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.737 ms | 150 | Yes | Yes | /classes/Hook.php:1500 |
| 101 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `psj2_hook_module` hm STRAIGHT_JOIN `psj2_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `psj2_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.638 ms | 383 | /classes/Hook.php:495 | ||
| 94 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN psj2_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute |
1.536 ms | 8 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 88 | SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p GROUP BY p.id_manufacturer |
1.267 ms | 36 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 92 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN psj2_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute |
1.251 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 85 | SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN psj2_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value |
1.245 ms | 16 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 68 | SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC |
1.187 ms | 36 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 70 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) |
1.142 ms | 36 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 75 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_specific_price sp ON (
sp.id_product = p.id_product AND
sp.id_shop IN (0, 1) AND
sp.id_currency IN (0, 2) AND
sp.id_country IN (0, 8) AND
sp.id_group IN (0, 1) AND
sp.from_quantity = 1 AND
sp.reduction > 0 AND
sp.id_customer = 0 AND
sp.id_cart = 0 AND
(sp.from = '0000-00-00 00:00:00' OR '2026-01-13 01:51:48' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-01-13 01:51:48' <= sp.to)
) WHERE ((sp.reduction>0)) |
1.050 ms | 4 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 71 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_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 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) |
0.984 ms | 36 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 72 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_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 ) WHERE ((sa.quantity>0)) |
0.968 ms | 36 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 82 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN psj2_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute |
0.961 ms | 36 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 171 | SELECT SQL_NO_CACHE c.*, cl.* FROM `psj2_category` c INNER JOIN psj2_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `psj2_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `psj2_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `psj2_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC |
0.932 ms | 9 | Yes | Yes | /classes/Category.php:815 |
| 83 | SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN psj2_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=1)) GROUP BY fp.id_feature_value |
0.910 ms | 540 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 78 | SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=4 AND c.nleft>10 AND c.nright<11 GROUP BY cp.id_category |
0.840 ms | 12 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 74 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p WHERE p.date_add>'2025-12-25 00:00:00' |
0.797 ms | 36 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 89 | SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p GROUP BY p.condition |
0.789 ms | 36 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 73 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psj2_product p LEFT JOIN psj2_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psj2_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psj2_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN psj2_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 GROUP BY p.id_product) p WHERE ((p.on_sale=1)) |
0.784 ms | 36 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 15 | SELECT SQL_NO_CACHE lower(name) as name FROM `psj2_hook` h WHERE (h.active = 1) |
0.778 ms | 1187 | /classes/Hook.php:1608 | ||
| 18 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psj2_hook` |
0.743 ms | 1187 | /classes/Hook.php:1568 | ||
| 42 | SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_description` FROM `psj2_category` c INNER JOIN psj2_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `psj2_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `psj2_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 7 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.660 ms | 1 | Yes | Yes | /classes/Category.php:946 |
| 107 | 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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `psj2_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 16 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psj2_cart_product` cp JOIN `psj2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psj2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 16 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.610 ms | 0 | /classes/Cart.php:1449 | ||
| 96 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-01-13 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM psj2_product p LEFT JOIN psj2_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN psj2_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN psj2_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (16,17,18) |
0.583 ms | 3 | /classes/ProductAssembler.php:101 | ||
| 87 | SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `psj2_manufacturer` m INNER JOIN psj2_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `psj2_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC |
0.567 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 69 | SELECT SQL_NO_CACHE data FROM psj2_layered_filter_block WHERE hash="faae1d0031e4b1b9f82639a20ac5213c" LIMIT 1 |
0.543 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:185 | ||
| 84 | SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `psj2_feature_value` v LEFT JOIN `psj2_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `psj2_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 1 ORDER BY vl.`value` ASC |
0.540 ms | 10 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 81 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `psj2_attribute_group` ag INNER JOIN `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `psj2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN psj2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN psj2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `psj2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC |
0.537 ms | 25 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 180 | 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 `psj2_product_attribute` pa INNER JOIN psj2_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 `psj2_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `psj2_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `psj2_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (16) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.514 ms | 16 | Yes | Yes | /classes/Product.php:4278 |
| 183 | SELECT SQL_NO_CACHE * FROM `psj2_product` a LEFT JOIN `psj2_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 16) LIMIT 1 |
0.512 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 21 | SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `psj2_meta` m LEFT JOIN `psj2_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.503 ms | 43 | Yes | /classes/Dispatcher.php:636 | |
| 64 | SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `psj2_attribute_group` ag INNER JOIN psj2_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 `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `psj2_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `psj2_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC |
0.497 ms | 4 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 |
| 0 | SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM psj2_shop_url su LEFT JOIN psj2_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'ps.user28.niprem.o2switch.site' OR su.domain_ssl = 'ps.user28.niprem.o2switch.site') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.495 ms | 1 | Yes | /classes/shop/Shop.php:1392 | |
| 91 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `psj2_attribute_group` ag INNER JOIN `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `psj2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN psj2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN psj2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `psj2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC |
0.474 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 79 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `psj2_attribute_group` ag INNER JOIN `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `psj2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN psj2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN psj2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `psj2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC |
0.461 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 19 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `psj2_module` m LEFT JOIN `psj2_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.448 ms | 75 | /classes/module/Module.php:342 | ||
| 223 | SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `psj2_category_product` cp LEFT JOIN `psj2_category` c ON (c.id_category = cp.id_category) LEFT JOIN `psj2_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN psj2_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (16,17,18) AND cl.`id_lang` = 1 ORDER BY c.`level_depth` DESC |
0.445 ms | 27 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 | |
| 191 | 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 `psj2_product_attribute` pa INNER JOIN psj2_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 `psj2_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `psj2_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `psj2_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (17) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.434 ms | 16 | Yes | Yes | /classes/Product.php:4278 |
| 147 | SELECT SQL_NO_CACHE 1 FROM psj2_cart_product cp INNER JOIN psj2_product p ON (p.id_product = cp.id_product) INNER JOIN psj2_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.430 ms | 1 | /classes/Cart.php:4067 | ||
| 63 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM psj2_layered_category WHERE controller = 'category' AND id_category = 7 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.429 ms | 13 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:57 |
| 76 | SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM psj2_product p INNER JOIN psj2_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 8) INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 |
0.426 ms | 1 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 93 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `psj2_attribute_group` ag INNER JOIN `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `psj2_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN psj2_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN psj2_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `psj2_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC |
0.418 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 187 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `psj2_product_attribute_combination` pac LEFT JOIN `psj2_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `psj2_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (28,29,30,31) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.415 ms | 4 | /classes/Product.php:2507 | ||
| 111 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `psj2_attribute` a LEFT JOIN `psj2_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `psj2_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `psj2_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN psj2_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 `psj2_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `psj2_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 16 AND pac.`id_product_attribute` = 28 AND agl.`id_lang` = 1 |
0.404 ms | 1 | /classes/Product.php:7185 | ||
| 199 | 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 `psj2_product_attribute` pa INNER JOIN psj2_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 `psj2_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `psj2_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `psj2_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (18) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.402 ms | 16 | Yes | Yes | /classes/Product.php:4278 |
| 1 | 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 psj2_shop_group gs LEFT JOIN psj2_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN psj2_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.398 ms | 1 | Yes | /classes/shop/Shop.php:716 | |
| 65 | SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `psj2_feature` f INNER JOIN psj2_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `psj2_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `psj2_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `psj2_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC |
0.386 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 | |
| 45 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `psj2_module` m LEFT JOIN `psj2_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.382 ms | 75 | /classes/module/Module.php:342 | ||
| 186 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `psj2_product_attribute` pa INNER JOIN psj2_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` = 16 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.377 ms | 4 | Yes | Yes | /classes/Product.php:2492 |
| 118 | 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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `psj2_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 17 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psj2_cart_product` cp JOIN `psj2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psj2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 17 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.374 ms | 0 | /classes/Cart.php:1449 | ||
| 109 | 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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `psj2_cart_product` cp WHERE cp.`id_product_attribute` = 28 AND cp.`id_cart` = 0 AND cp.`id_product` = 16 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psj2_cart_product` cp JOIN `psj2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psj2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 28 AND cp.`id_cart` = 0 AND p.`id_product_item` = 16 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.355 ms | 0 | /classes/Cart.php:1449 | ||
| 129 | 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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `psj2_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 18 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psj2_cart_product` cp JOIN `psj2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psj2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 18 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.351 ms | 0 | /classes/Cart.php:1449 | ||
| 23 | SELECT SQL_NO_CACHE * FROM `psj2_currency` c ORDER BY `iso_code` ASC |
0.347 ms | 2 | Yes | /classes/Currency.php:708 | |
| 122 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `psj2_attribute` a LEFT JOIN `psj2_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `psj2_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `psj2_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN psj2_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 `psj2_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `psj2_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 17 AND pac.`id_product_attribute` = 32 AND agl.`id_lang` = 1 |
0.344 ms | 1 | /classes/Product.php:7185 | ||
| 22 | SELECT SQL_NO_CACHE * FROM `psj2_category` a LEFT JOIN `psj2_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `psj2_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 7) AND (b.`id_shop` = 1) LIMIT 1 |
0.343 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 90 | SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM psj2_product p INNER JOIN psj2_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psj2_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psj2_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psj2_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=10 AND c.nright<=11 |
0.342 ms | 9 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 120 | 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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `psj2_cart_product` cp WHERE cp.`id_product_attribute` = 32 AND cp.`id_cart` = 0 AND cp.`id_product` = 17 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psj2_cart_product` cp JOIN `psj2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psj2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 32 AND cp.`id_cart` = 0 AND p.`id_product_item` = 17 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.338 ms | 0 | /classes/Cart.php:1449 | ||
| 131 | 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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `psj2_cart_product` cp WHERE cp.`id_product_attribute` = 36 AND cp.`id_cart` = 0 AND cp.`id_product` = 18 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `psj2_cart_product` cp JOIN `psj2_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psj2_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 36 AND cp.`id_cart` = 0 AND p.`id_product_item` = 18 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.335 ms | 0 | /classes/Cart.php:1449 | ||
| 133 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `psj2_attribute` a LEFT JOIN `psj2_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `psj2_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `psj2_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN psj2_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 `psj2_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `psj2_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 18 AND pac.`id_product_attribute` = 36 AND agl.`id_lang` = 1 |
0.330 ms | 1 | /classes/Product.php:7185 | ||
| 141 | SELECT SQL_NO_CACHE * FROM `psj2_product` a LEFT JOIN `psj2_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `psj2_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17) AND (b.`id_shop` = 1) LIMIT 1 |
0.328 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 195 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `psj2_product_attribute_combination` pac LEFT JOIN `psj2_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `psj2_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (32,33,34,35) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.322 ms | 4 | /classes/Product.php:2507 | ||
| 47 | SELECT SQL_NO_CACHE * FROM `psj2_category` a LEFT JOIN `psj2_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `psj2_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 7) AND (b.`id_shop` = 1) LIMIT 1 |
0.321 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 203 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `psj2_product_attribute_combination` pac LEFT JOIN `psj2_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `psj2_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `psj2_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `psj2_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (36,37,38,39) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.320 ms | 4 | /classes/Product.php:2507 | ||
| 86 | SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `psj2_feature_value` v LEFT JOIN `psj2_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `psj2_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 2 ORDER BY vl.`value` ASC |
0.317 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 95 | REPLACE INTO psj2_layered_filter_block (hash, data) VALUES ("faae1d0031e4b1b9f82639a20ac5213c", "a:1:{s:7:\"filters\";a:10:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:3;}i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:7:\"On sale\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:11:\"New product\";s:3:\"nbr\";i:3;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:3;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:1;s:6:\"values\";a:1:{i:5;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:18:\"Recycled cardboard\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:11:\"Composition\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:2;s:6:\"values\";a:1:{i:10;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:9:\"120 pages\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Property\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:1:{i:2;a:2:{s:4:\"name\";s:14:\"Graphic Corner\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Condition\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"New\";s:3:\"nbr\";i:3;}s:4:\"used\";a:2:{s:4:\"name\";s:4:\"Used\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Refurbished\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:8;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Weight\";s:3:\"max\";d:0.3;s:3:\"min\";d:0.3;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:3;}i:9;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:4;s:4:\"name\";s:10:\"Paper Type\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:4:{i:22;a:4:{s:4:\"name\";s:5:\"Ruled\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:23;a:4:{s:4:\"name\";s:5:\"Plain\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:24;a:4:{s:4:\"name\";s:7:\"Squared\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:4:{s:4:\"name\";s:5:\"Doted\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}") |
0.316 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:209 | ||
| 46 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.315 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 102 | SELECT SQL_NO_CACHE tr.*
FROM `psj2_tax_rule` tr
JOIN `psj2_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 9
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.314 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 20 | SELECT SQL_NO_CACHE name, alias FROM `psj2_hook_alias` |
0.309 ms | 86 | /classes/Hook.php:371 | ||
| 62 | SELECT SQL_NO_CACHE `id_category` FROM `psj2_category_shop` WHERE `id_category` = 7 AND `id_shop` = 1 LIMIT 1 |
0.306 ms | 1 | /classes/Category.php:2454 | ||
| 136 | SELECT SQL_NO_CACHE * FROM `psj2_product` a LEFT JOIN `psj2_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `psj2_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 16) AND (b.`id_shop` = 1) LIMIT 1 |
0.291 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 202 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `psj2_product_attribute` pa INNER JOIN psj2_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` = 18 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.287 ms | 4 | Yes | Yes | /classes/Product.php:2492 |
| 194 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `psj2_product_attribute` pa INNER JOIN psj2_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` = 17 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.282 ms | 4 | Yes | Yes | /classes/Product.php:2492 |
| 11 | SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psj2_lang` l JOIN psj2_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.276 ms | 4 | /classes/Language.php:1204 | ||
| 66 | SELECT SQL_NO_CACHE * FROM `psj2_category` a LEFT JOIN `psj2_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 7) LIMIT 1 |
0.274 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 99 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `psj2_product` p INNER JOIN `psj2_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `psj2_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` = 16) |
0.272 ms | 4 | /classes/Product.php:3603 | ||
| 144 | SELECT SQL_NO_CACHE * FROM `psj2_product` a LEFT JOIN `psj2_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `psj2_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 18) AND (b.`id_shop` = 1) LIMIT 1 |
0.271 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 172 | SELECT SQL_NO_CACHE DISTINCT c.* FROM `psj2_category` c LEFT JOIN `psj2_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1) WHERE `level_depth` = 1 |
0.271 ms | 1 | /classes/Category.php:2247 | ||
| 200 | SELECT SQL_NO_CACHE * FROM `psj2_product` a LEFT JOIN `psj2_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 18) LIMIT 1 |
0.266 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 77 | SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `psj2_category` c INNER JOIN psj2_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `psj2_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position |
0.262 ms | 9 | Yes | /classes/Category.php:744 | |
| 225 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `psj2_product_attribute_combination` pac LEFT JOIN `psj2_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `psj2_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `psj2_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 28 ORDER BY ag.`position` ASC, a.`position` ASC |
0.248 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 192 | SELECT SQL_NO_CACHE * FROM `psj2_product` a LEFT JOIN `psj2_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17) LIMIT 1 |
0.246 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 58 | SELECT SQL_NO_CACHE * FROM `psj2_category` a0 LEFT JOIN `psj2_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 10) AND (a0.`nright` > 11) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.242 ms | 9 | Yes | /classes/PrestaShopCollection.php:381 | |
| 138 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `psj2_image` i INNER JOIN psj2_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `psj2_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 16 ORDER BY `position` |
0.242 ms | 1 | Yes | /classes/Product.php:3285 | |
| 142 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `psj2_image` i INNER JOIN psj2_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `psj2_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 17 ORDER BY `position` |
0.240 ms | 1 | Yes | /classes/Product.php:3285 | |
| 33 | SELECT SQL_NO_CACHE * FROM `psj2_country` a LEFT JOIN `psj2_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `psj2_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1 |
0.239 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 10 | SELECT SQL_NO_CACHE domain, domain_ssl FROM psj2_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.233 ms | 1 | /classes/shop/ShopUrl.php:178 | ||
| 6 | SELECT SQL_NO_CACHE * FROM `psj2_country` a LEFT JOIN `psj2_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2 LEFT JOIN `psj2_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1 |
0.231 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 217 | SELECT SQL_NO_CACHE `id_guest` FROM `psj2_connections` WHERE `id_guest` = 34 AND `date_add` > '2026-01-13 01:21:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.230 ms | 1 | Yes | /classes/Connection.php:168 | |
| 139 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `psj2_product_attribute_image` pai LEFT JOIN `psj2_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `psj2_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 16 AND il.`id_lang` = 1 ORDER by i.`position` |
0.229 ms | 1 | Yes | /classes/Product.php:2668 | |
| 226 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `psj2_product_attribute_combination` pac LEFT JOIN `psj2_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `psj2_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `psj2_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 32 ORDER BY ag.`position` ASC, a.`position` ASC |
0.223 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 27 | SELECT SQL_NO_CACHE * FROM `psj2_currency` a LEFT JOIN `psj2_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `psj2_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.219 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 170 | SELECT SQL_NO_CACHE * FROM `psj2_category` a LEFT JOIN `psj2_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `psj2_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.216 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 216 | INSERT INTO `psj2_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') |
0.216 ms | 1 | /classes/ObjectModel.php:535 | ||
| 59 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_facebook" LIMIT 1 |
0.215 ms | 1 | /classes/module/Module.php:2778 | ||
| 115 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `psj2_product` p INNER JOIN `psj2_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `psj2_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` = 17) |
0.211 ms | 4 | /classes/Product.php:3603 | ||
| 145 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `psj2_image` i INNER JOIN psj2_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `psj2_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 18 ORDER BY `position` |
0.211 ms | 1 | Yes | /classes/Product.php:3285 | |
| 175 | SELECT SQL_NO_CACHE c.*, cl.* FROM `psj2_category` c LEFT JOIN `psj2_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 10 AND c.`nright` >= 11 AND c.`nleft` >= 2 AND c.`nright` <= 17 ORDER BY `nleft` DESC |
0.211 ms | 9 | Yes | /classes/Category.php:1617 | |
| 110 | SELECT SQL_NO_CACHE pa.`available_date` FROM `psj2_product` p LEFT JOIN `psj2_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN psj2_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN psj2_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` = 16 AND pa.`id_product` = 16 AND pa.`id_product_attribute` = 28 LIMIT 1 |
0.210 ms | 1 | /classes/Product.php:1180 | ||
| 156 | SELECT SQL_NO_CACHE * FROM `psj2_currency` c INNER JOIN psj2_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC |
0.209 ms | 2 | Yes | /classes/Currency.php:687 | |
| 37 | SELECT SQL_NO_CACHE * FROM `psj2_group` a LEFT JOIN `psj2_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.205 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 48 | SELECT SQL_NO_CACHE * FROM `psj2_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.204 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 227 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `psj2_product_attribute_combination` pac LEFT JOIN `psj2_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `psj2_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `psj2_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 36 ORDER BY ag.`position` ASC, a.`position` ASC |
0.204 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 5 | SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `psj2_lang` l LEFT JOIN `psj2_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.199 ms | 2 | /classes/Language.php:1070 | ||
| 126 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `psj2_product` p INNER JOIN `psj2_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `psj2_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` = 18) |
0.199 ms | 4 | /classes/Product.php:3603 | ||
| 97 | SELECT SQL_NO_CACHE 1 FROM `psj2_specific_price` WHERE id_product = 0 LIMIT 1 |
0.197 ms | 1 | /classes/SpecificPrice.php:423 | ||
| 146 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `psj2_product_attribute_image` pai LEFT JOIN `psj2_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `psj2_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 18 AND il.`id_lang` = 1 ORDER by i.`position` |
0.196 ms | 1 | Yes | /classes/Product.php:2668 | |
| 155 | SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `psj2_currency` c LEFT JOIN psj2_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1 |
0.196 ms | 2 | /classes/Currency.php:1120 | ||
| 112 | SELECT SQL_NO_CACHE * FROM `psj2_product_attribute` a LEFT JOIN `psj2_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 28) LIMIT 1 |
0.195 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 143 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `psj2_product_attribute_image` pai LEFT JOIN `psj2_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `psj2_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 17 AND il.`id_lang` = 1 ORDER by i.`position` |
0.192 ms | 1 | Yes | /classes/Product.php:2668 | |
| 184 | SELECT SQL_NO_CACHE * FROM `psj2_product_lang` WHERE `id_product` = 16 AND `id_shop` = 1 |
0.182 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 4 | SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM psj2_shop s LEFT JOIN psj2_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.180 ms | 1 | /classes/shop/Shop.php:215 | ||
| 8 | SELECT SQL_NO_CACHE * FROM `psj2_lang` a LEFT JOIN `psj2_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 2) LIMIT 1 |
0.179 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 121 | SELECT SQL_NO_CACHE pa.`available_date` FROM `psj2_product` p LEFT JOIN `psj2_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN psj2_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN psj2_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` = 17 AND pa.`id_product` = 17 AND pa.`id_product_attribute` = 32 LIMIT 1 |
0.177 ms | 1 | /classes/Product.php:1180 | ||
| 132 | SELECT SQL_NO_CACHE pa.`available_date` FROM `psj2_product` p LEFT JOIN `psj2_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN psj2_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN psj2_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` = 18 AND pa.`id_product` = 18 AND pa.`id_product_attribute` = 36 LIMIT 1 |
0.167 ms | 1 | /classes/Product.php:1180 | ||
| 222 | SELECT SQL_NO_CACHE data FROM `psj2_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.166 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39 | ||
| 24 | SELECT SQL_NO_CACHE `id_lang` FROM `psj2_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.160 ms | 2 | /classes/Language.php:870 | ||
| 25 | SELECT SQL_NO_CACHE value FROM `psj2_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.159 ms | 1 | /classes/shop/Shop.php:1211 | ||
| 148 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_contactinfo" LIMIT 1 |
0.157 ms | 1 | /classes/module/Module.php:2778 | ||
| 123 | SELECT SQL_NO_CACHE * FROM `psj2_product_attribute` a LEFT JOIN `psj2_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 32) LIMIT 1 |
0.154 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 140 | SELECT SQL_NO_CACHE * FROM `psj2_image_type` |
0.154 ms | 7 | /classes/ImageType.php:161 | ||
| 218 | SELECT SQL_NO_CACHE id_page_type FROM psj2_page_type WHERE name = 'category' LIMIT 1 |
0.154 ms | 1 | /classes/Page.php:100 | ||
| 134 | SELECT SQL_NO_CACHE * FROM `psj2_product_attribute` a LEFT JOIN `psj2_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 36) LIMIT 1 |
0.153 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 67 | SELECT SQL_NO_CACHE * FROM `psj2_category_lang` WHERE `id_category` = 7 AND `id_shop` = 1 |
0.153 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `psj2_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.152 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 61 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.152 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 193 | SELECT SQL_NO_CACHE * FROM `psj2_product_lang` WHERE `id_product` = 17 AND `id_shop` = 1 |
0.149 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 31 | SELECT SQL_NO_CACHE * FROM `psj2_currency` a LEFT JOIN `psj2_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `psj2_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.146 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 105 | SELECT SQL_NO_CACHE tr.*
FROM `psj2_tax_rule` tr
JOIN `psj2_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('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.146 ms | 0 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 40 | SELECT SQL_NO_CACHE `id_category` FROM `psj2_category_shop` WHERE `id_category` = 7 AND `id_shop` = 1 LIMIT 1 |
0.145 ms | 1 | /classes/Category.php:2454 | ||
| 17 | SELECT SQL_NO_CACHE `name`, `alias` FROM `psj2_hook_alias` |
0.144 ms | 86 | /classes/Hook.php:319 | ||
| 219 | SELECT SQL_NO_CACHE `id_page` FROM `psj2_page` WHERE `id_page_type` = 4 AND `id_object` = 7 LIMIT 1 |
0.144 ms | 1 | /classes/Page.php:83 | ||
| 13 | SELECT SQL_NO_CACHE * FROM `psj2_lang` a LEFT JOIN `psj2_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.143 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 188 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 16) AND (id_product_attribute = 29) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.142 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 57 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM psj2_required_field |
0.139 ms | 1 | /classes/ObjectModel.php:1437 | ||
| 166 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.139 ms | 1 | /classes/module/Module.php:2778 | ||
| 201 | SELECT SQL_NO_CACHE * FROM `psj2_product_lang` WHERE `id_product` = 18 AND `id_shop` = 1 |
0.139 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 211 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_linklist" LIMIT 1 |
0.139 ms | 1 | /classes/module/Module.php:2778 | ||
| 108 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 16) AND (id_product_attribute = 28) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.138 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 50 | SELECT SQL_NO_CACHE * FROM `psj2_image_type` WHERE 1 AND `suppliers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.136 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 34 | SELECT SQL_NO_CACHE * FROM `psj2_currency` a LEFT JOIN `psj2_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.135 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 158 | SELECT SQL_NO_CACHE * FROM `psj2_currency_lang` WHERE `id_currency` = 1 |
0.134 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 163 | SELECT SQL_NO_CACHE SUM(`quantity`) FROM `psj2_cart_product` WHERE `id_cart` = 0 LIMIT 1 |
0.133 ms | 1 | /classes/Cart.php:1320 | ||
| 55 | SELECT SQL_NO_CACHE * FROM `psj2_country` a LEFT JOIN `psj2_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1 |
0.132 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 159 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.129 ms | 1 | /classes/module/Module.php:2778 | ||
| 49 | SELECT SQL_NO_CACHE * FROM `psj2_image_type` WHERE 1 AND `manufacturers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.128 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 220 | INSERT INTO `psj2_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('34', '7', '1844093383', '', '1', '1', '2026-01-13 01:51:48') |
0.128 ms | 1 | /classes/ObjectModel.php:535 | ||
| 221 | INSERT INTO `psj2_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('33', '', 'ps.user28.niprem.o2switch.site/en/7-stationery', '', '2026-01-13 01:51:48') |
0.127 ms | 1 | /classes/ObjectModel.php:535 | ||
| 157 | SELECT SQL_NO_CACHE * FROM `psj2_currency` a LEFT JOIN `psj2_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.124 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 38 | SELECT SQL_NO_CACHE * FROM `psj2_group_lang` WHERE `id_group` = 1 |
0.121 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 114 | SELECT SQL_NO_CACHE 1 FROM `psj2_specific_price` WHERE id_product = 17 LIMIT 1 |
0.121 ms | 1 | /classes/SpecificPrice.php:432 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `psj2_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.120 ms | 1 | /src/Adapter/EntityMapper.php:73 | ||
| 52 | SELECT SQL_NO_CACHE * FROM `psj2_image_type` WHERE 1 AND `stores` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.120 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 173 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `psj2_category` c LEFT JOIN `psj2_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 7 LIMIT 1 |
0.120 ms | 1 | /classes/Category.php:1607 | ||
| 164 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_mainmenu" LIMIT 1 |
0.119 ms | 1 | /classes/module/Module.php:2778 | ||
| 196 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 17) AND (id_product_attribute = 33) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.119 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 178 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_brandlist" LIMIT 1 |
0.118 ms | 1 | /classes/module/Module.php:2778 | ||
| 204 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 18) AND (id_product_attribute = 37) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.118 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 51 | SELECT SQL_NO_CACHE * FROM `psj2_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.116 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 119 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 17) AND (id_product_attribute = 32) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.115 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 176 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_supplierlist" LIMIT 1 |
0.115 ms | 1 | /classes/module/Module.php:2778 | ||
| 56 | SELECT SQL_NO_CACHE * FROM `psj2_country_lang` WHERE `id_country` = 8 |
0.115 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 113 | SELECT SQL_NO_CACHE * FROM `psj2_product_attribute_lang` WHERE `id_product_attribute` = 28 |
0.115 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 168 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.115 ms | 1 | /classes/module/Module.php:2778 | ||
| 182 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.115 ms | 1 | /classes/module/Module.php:2267 | ||
| 35 | SELECT SQL_NO_CACHE * FROM `psj2_currency_lang` WHERE `id_currency` = 2 |
0.113 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 130 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 18) AND (id_product_attribute = 36) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.112 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 26 | SELECT SQL_NO_CACHE c.id_currency FROM `psj2_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.111 ms | 1 | /classes/Currency.php:893 | ||
| 153 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.111 ms | 1 | /classes/module/Module.php:2778 | ||
| 106 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 16) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.110 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 44 | SELECT SQL_NO_CACHE * FROM `psj2_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.109 ms | 1 | /classes/module/Module.php:2168 | ||
| 124 | SELECT SQL_NO_CACHE * FROM `psj2_product_attribute_lang` WHERE `id_product_attribute` = 32 |
0.108 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 206 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 18) AND (id_product_attribute = 39) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.108 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 98 | SELECT SQL_NO_CACHE 1 FROM `psj2_specific_price` WHERE id_product = 16 LIMIT 1 |
0.107 ms | 1 | /classes/SpecificPrice.php:432 | ||
| 135 | SELECT SQL_NO_CACHE * FROM `psj2_product_attribute_lang` WHERE `id_product_attribute` = 36 |
0.107 ms | 2 | /src/Adapter/EntityMapper.php:81 | ||
| 103 | SELECT SQL_NO_CACHE `reduction` FROM `psj2_product_group_reduction_cache` WHERE `id_product` = 16 AND `id_group` = 1 LIMIT 1 |
0.106 ms | 0 | /classes/GroupReduction.php:146 | ||
| 185 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `psj2_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 7 LIMIT 1 |
0.105 ms | 0 | /classes/Category.php:1396 | ||
| 30 | SELECT SQL_NO_CACHE c.id_currency FROM `psj2_currency` c WHERE (iso_code = 'USD') LIMIT 1 |
0.103 ms | 1 | /classes/Currency.php:893 | ||
| 137 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `psj2_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 7 LIMIT 1 |
0.103 ms | 1 | /classes/Category.php:1396 | ||
| 12 | SELECT SQL_NO_CACHE `id_lang` FROM `psj2_lang` WHERE `iso_code` = 'en' LIMIT 1 |
0.102 ms | 2 | /classes/Language.php:844 | ||
| 117 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 17) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.102 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 125 | SELECT SQL_NO_CACHE 1 FROM `psj2_specific_price` WHERE id_product = 18 LIMIT 1 |
0.102 ms | 1 | /classes/SpecificPrice.php:432 | ||
| 224 | SELECT SQL_NO_CACHE `name` FROM `psj2_manufacturer` WHERE `id_manufacturer` = 2 AND `active` = 1 LIMIT 1 |
0.101 ms | 1 | /classes/Manufacturer.php:306 | ||
| 28 | SELECT SQL_NO_CACHE `id_lang` FROM `psj2_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.101 ms | 2 | /classes/Language.php:870 | ||
| 60 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 28 AND `id_shop` = 1 LIMIT 1 |
0.100 ms | 1 | /classes/module/Module.php:2267 | ||
| 128 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 18) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.100 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 181 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "productcomments" LIMIT 1 |
0.100 ms | 1 | /classes/module/Module.php:2778 | ||
| 9 | SELECT SQL_NO_CACHE id_shop FROM `psj2_lang_shop` WHERE `id_lang` = 2 AND id_shop = 1 LIMIT 1 |
0.099 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 53 | SELECT SQL_NO_CACHE format FROM `psj2_address_format` WHERE `id_country` = 8 LIMIT 1 |
0.099 ms | 1 | /classes/AddressFormat.php:649 | ||
| 43 | SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM psj2_shop s |
0.098 ms | 1 | /classes/shop/Shop.php:922 | ||
| 150 | SELECT SQL_NO_CACHE `need_identification_number` FROM `psj2_country` WHERE `id_country` = 8 LIMIT 1 |
0.098 ms | 1 | /classes/Country.php:406 | ||
| 189 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 16) AND (id_product_attribute = 30) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.098 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 197 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 17) AND (id_product_attribute = 34) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.098 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 149 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1 |
0.096 ms | 1 | /classes/module/Module.php:2267 | ||
| 212 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1 |
0.096 ms | 1 | /classes/module/Module.php:2267 | ||
| 198 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 17) AND (id_product_attribute = 35) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.096 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 165 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1 |
0.095 ms | 1 | /classes/module/Module.php:2267 | ||
| 207 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.095 ms | 1 | /classes/module/Module.php:2778 | ||
| 39 | SELECT SQL_NO_CACHE id_shop FROM `psj2_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.094 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 151 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.094 ms | 1 | /classes/module/Module.php:2778 | ||
| 213 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1 |
0.094 ms | 1 | /classes/module/Module.php:2778 | ||
| 41 | SELECT SQL_NO_CACHE ctg.`id_group` FROM psj2_category_group ctg WHERE ctg.`id_category` = 7 AND ctg.`id_group` = 1 LIMIT 1 |
0.093 ms | 1 | /classes/Category.php:1774 | ||
| 205 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 18) AND (id_product_attribute = 38) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.093 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 177 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 36 AND `id_shop` = 1 LIMIT 1 |
0.092 ms | 1 | /classes/module/Module.php:2267 | ||
| 169 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.090 ms | 1 | /classes/module/Module.php:2267 | ||
| 167 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.090 ms | 1 | /classes/module/Module.php:2267 | ||
| 190 | SELECT SQL_NO_CACHE SUM(quantity) FROM `psj2_stock_available` WHERE (id_product = 16) AND (id_product_attribute = 31) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.090 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 215 | SELECT SQL_NO_CACHE `need_identification_number` FROM `psj2_country` WHERE `id_country` = 8 LIMIT 1 |
0.089 ms | 1 | /classes/Country.php:406 | ||
| 36 | SELECT SQL_NO_CACHE id_shop FROM `psj2_currency_shop` WHERE `id_currency` = 2 AND id_shop = 1 LIMIT 1 |
0.087 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 104 | SELECT SQL_NO_CACHE `reduction` FROM `psj2_group` WHERE `id_group` = 1 LIMIT 1 |
0.087 ms | 1 | /classes/Group.php:151 | ||
| 160 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.087 ms | 1 | /classes/module/Module.php:2267 | ||
| 209 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.087 ms | 1 | /classes/module/Module.php:2778 | ||
| 32 | SELECT SQL_NO_CACHE `id_lang` FROM `psj2_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.085 ms | 2 | /classes/Language.php:870 | ||
| 179 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 63 AND `id_shop` = 1 LIMIT 1 |
0.085 ms | 1 | /classes/module/Module.php:2267 | ||
| 14 | SELECT SQL_NO_CACHE id_shop FROM `psj2_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.084 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 116 | SELECT SQL_NO_CACHE `reduction` FROM `psj2_product_group_reduction_cache` WHERE `id_product` = 17 AND `id_group` = 1 LIMIT 1 |
0.084 ms | 0 | /classes/GroupReduction.php:146 | ||
| 54 | SELECT SQL_NO_CACHE `need_identification_number` FROM `psj2_country` WHERE `id_country` = 8 LIMIT 1 |
0.083 ms | 1 | /classes/Country.php:406 | ||
| 161 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.083 ms | 1 | /classes/module/Module.php:2778 | ||
| 29 | SELECT SQL_NO_CACHE `id_lang` FROM `psj2_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.082 ms | 2 | /classes/Language.php:870 | ||
| 208 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.082 ms | 1 | /classes/module/Module.php:2267 | ||
| 152 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.081 ms | 1 | /classes/module/Module.php:2267 | ||
| 214 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1 |
0.081 ms | 1 | /classes/module/Module.php:2267 | ||
| 127 | SELECT SQL_NO_CACHE `reduction` FROM `psj2_product_group_reduction_cache` WHERE `id_product` = 18 AND `id_group` = 1 LIMIT 1 |
0.081 ms | 0 | /classes/GroupReduction.php:146 | ||
| 154 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.080 ms | 1 | /classes/module/Module.php:2267 | ||
| 174 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `psj2_category` c WHERE c.`id_category` = 2 LIMIT 1 |
0.080 ms | 1 | /classes/Category.php:1612 | ||
| 210 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.079 ms | 1 | /classes/module/Module.php:2267 | ||
| 162 | SELECT SQL_NO_CACHE `id_module` FROM `psj2_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.078 ms | 1 | /classes/module/Module.php:2267 |
| 16 queries |
SELECT `id_module` FROM `psjXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX |
| 15 queries |
SELECT SUM(quantity) FROM `psjXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX |
| 6 queries |
SELECT
COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
COALESCE(SUM(first_level_quantity), XX) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity
FROM `psjXX_cart_product` cp
WHERE cp.`id_product_attribute` = XX
AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psjXX_cart_product` cp JOIN `psjXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psjXX_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 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
|
| 4 queries |
SELECT `id_lang` FROM `psjXX_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT XX
|
| 4 queries |
SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `psjXX_attribute_group` ag INNER JOIN `psjXX_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `psjXX_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `psjXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN psjXX_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN psjXX_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `psjXX_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
|
| 4 queries |
SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psjXX_product p LEFT JOIN psjXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psjXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psjXX_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN psjXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psjXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psjXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN psjXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN psjXX_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN psjXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psjXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN psjXX_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
|
| 4 queries |
SELECT XX FROM `psjXX_specific_price` WHERE id_product = XX LIMIT XX |
| 3 queries |
SELECT * FROM `psjXX_category` a LEFT JOIN `psjXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `psjXX_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 |
| 3 queries |
SELECT `need_identification_number` FROM `psjXX_country` WHERE `id_country` = XX LIMIT XX |
| 3 queries |
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, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `psjXX_product` p INNER JOIN `psjXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `psjXX_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) |
| 3 queries |
SELECT `reduction` FROM `psjXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
| 3 queries |
SELECT pa.`available_date` FROM `psjXX_product` p LEFT JOIN `psjXX_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN psjXX_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN psjXX_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
|
| 3 queries |
SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `psjXX_attribute` a
LEFT JOIN `psjXX_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `psjXX_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `psjXX_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN psjXX_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 `psjXX_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX)
LEFT JOIN `psjXX_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
|
| 3 queries |
SELECT * FROM `psjXX_product_attribute` a LEFT JOIN `psjXX_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 |
| 3 queries |
SELECT * FROM `psjXX_product_attribute_lang` WHERE `id_product_attribute` = XX |
| 3 queries |
SELECT * FROM `psjXX_product` a LEFT JOIN `psjXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `psjXX_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 |
| 3 queries |
SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psjXX_image` i
INNER JOIN psjXX_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
LEFT JOIN `psjXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
WHERE i.`id_product` = XX
ORDER BY `position`
|
| 3 queries |
SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `psjXX_product_attribute_image` pai
LEFT JOIN `psjXX_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `psjXX_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
|
| 3 queries |
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 `psjXX_product_attribute` pa
INNER JOIN psjXX_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 `psjXX_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psjXX_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psjXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
JOIN `psjXX_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;
|
| 3 queries |
SELECT * FROM `psjXX_product` a LEFT JOIN `psjXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX |
| 3 queries |
SELECT * FROM `psjXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX |
| 3 queries |
SELECT pa.*, product_attribute_shop.*
FROM `psjXX_product_attribute` pa
INNER JOIN psjXX_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` = XX
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
|
| 3 queries |
SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `psjXX_product_attribute_combination` pac
LEFT JOIN `psjXX_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `psjXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `psjXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `psjXX_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
WHERE pac.id_product_attribute IN (XX,XX,XX,XX)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
|
| 3 queries |
SELECT al.`name` AS attribute_name
FROM `psjXX_product_attribute_combination` pac
LEFT JOIN `psjXX_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `psjXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `psjXX_attribute_lang` al ON (
a.`id_attribute` = al.`id_attribute`
AND al.`id_lang` = XX
)
WHERE pac.`id_product_attribute` = XX
ORDER BY ag.`position` ASC, a.`position` ASC
|
| 2 queries |
SELECT * FROM `psjXX_country` a LEFT JOIN `psjXX_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `psjXX_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX |
| 2 queries |
SELECT * FROM `psjXX_lang` a LEFT JOIN `psjXX_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX |
| 2 queries |
SELECT id_shop FROM `psjXX_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX |
| 2 queries |
SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psjXX_module` m
LEFT JOIN `psjXX_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = XX
|
| 2 queries |
SELECT * FROM `psjXX_currency` a LEFT JOIN `psjXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `psjXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX |
| 2 queries |
SELECT * FROM `psjXX_currency` a LEFT JOIN `psjXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX |
| 2 queries |
SELECT * FROM `psjXX_currency_lang` WHERE `id_currency` = XX |
| 2 queries |
SELECT `id_category` FROM `psjXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX |
| 2 queries |
SELECT `id_module` FROM `psjXX_module` WHERE `name` = "ps_accounts" LIMIT XX |
| 2 queries |
SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psjXX_product p LEFT JOIN psjXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psjXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psjXX_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN psjXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psjXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psjXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN psjXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN psjXX_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN psjXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
|
| 2 queries |
SELECT v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `psjXX_feature_value` v LEFT JOIN `psjXX_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `psjXX_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC |
| 2 queries |
SELECT tr.*
FROM `psjXX_tax_rule` tr
JOIN `psjXX_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 queries |
SELECT cl.`link_rewrite` FROM `psjXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX |
| 38 product |
| 38 product_attribute |
| 36 stock_available |
| 35 product_attribute_combination |
| 33 category |
| 32 product_shop |
| 22 module |
| 22 category_group |
| 21 category_product |
| 20 attribute |
| 19 module_shop |
| 18 product_attribute_shop |
| 16 product_sale |
| 16 attribute_lang |
| 14 category_lang |
| 14 attribute_group |
| 14 cart_product |
| 11 attribute_group_lang |
| 10 category_shop |
| 9 lang |
| 9 currency |
| 7 currency_shop |
| 7 product_lang |
| 6 lang_shop |
| 6 country |
| 6 hook |
| 6 image_type |
| 6 pack |
| 6 product_attribute_lang |
| 6 image |
| 6 image_lang |
| 5 shop |
| 5 attribute_group_shop |
| 5 specific_price |
| 4 shop_url |
| 4 currency_lang |
| 4 attribute_shop |
| 4 layered_indexable_attribute_lang_value |
| 3 country_lang |
| 3 country_shop |
| 3 hook_alias |
| 3 product_group_reduction_cache |
| 3 image_shop |
| 3 product_attribute_image |
| 2 shop_group |
| 2 configuration |
| 2 hook_module |
| 2 group |
| 2 group_shop |
| 2 feature_product |
| 2 feature_value |
| 2 feature_value_lang |
| 2 layered_indexable_feature_value_lang_value |
| 2 manufacturer |
| 2 tax_rule |
| 2 tax_rules_group |
| 1 configuration_lang |
| 1 module_group |
| 1 meta |
| 1 meta_lang |
| 1 group_lang |
| 1 hook_module_exceptions |
| 1 address_format |
| 1 required_field |
| 1 layered_category |
| 1 layered_indexable_attribute_group |
| 1 layered_indexable_attribute_group_lang_value |
| 1 feature |
| 1 feature_shop |
| 1 feature_lang |
| 1 layered_indexable_feature |
| 1 layered_indexable_feature_lang_value |
| 1 layered_filter_block |
| 1 layered_price_index |
| 1 manufacturer_shop |
| 1 manufacturer_lang |
| 1 connections |
| 1 page_type |
| 1 page |
| 1 ganalytics_data |
| Name | Instances | Source |
|---|---|---|
| Category | 18 |
/controllers/front/listing/CategoryController.php:87 (__construct) [id: 7]
/classes/Meta.php:364 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 7] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /classes/Link.php:402 (__construct) [id: 7] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /src/Adapter/Presenter/Category/CategoryLazyArray.php:112 (__construct) [id: 7] |
| Product | 9 |
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 16]
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 17] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 18] /classes/Link.php:114 (__construct) [id: 16] /classes/Link.php:114 (__construct) [id: 17] /classes/Link.php:114 (__construct) [id: 18] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 16] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 17] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 18] |
| Country | 8 |
/config/config.inc.php:154 (__construct) [id: 8]
/classes/controller/FrontController.php:312 (__construct) [id: 8] /classes/AddressFormat.php:402 (__construct) [id: 8] /classes/controller/FrontController.php:1702 (__construct) [id: 8] /classes/AddressFormat.php:402 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 8] /classes/AddressFormat.php:402 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 8] |
| Currency | 4 |
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2]
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:685 (getCurrencyInstance) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1] |
| Address | 4 |
/classes/shop/Shop.php:487 (__construct) [id: ]
/classes/Product.php:3437 (initialize) [id: ] /classes/Product.php:3547 (__construct) [id: ] /classes/Product.php:5697 (__construct) [id: ] |
| AddressFormat | 3 |
/classes/controller/FrontController.php:1696 (generateAddress) [id: ]
/modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] |
| Language | 3 |
/config/config.inc.php:219 (__construct) [id: 2]
/classes/Tools.php:631 (__construct) [id: 1] /classes/Tools.php:550 (__construct) [id: 1] |
| Combination | 3 |
/classes/Product.php:5645 (__construct) [id: 28]
/classes/Product.php:5645 (__construct) [id: 32] /classes/Product.php:5645 (__construct) [id: 36] |
| State | 3 |
/classes/controller/FrontController.php:1701 (__construct) [id: 0]
/modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] |
| Shop | 1 |
/config/config.inc.php:122 (initialize) [id: 1]
|
| Connection | 1 |
/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
|
| Guest | 1 |
/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
|
| Gender | 1 |
/classes/controller/FrontController.php:1619 (__construct) [id: 0]
|
| Risk | 1 |
/classes/controller/FrontController.php:1622 (__construct) [id: ]
|
| Group | 1 |
/classes/Cart.php:272 (getCurrent) [id: 1]
|
| Cart | 1 |
/classes/controller/FrontController.php:425 (__construct) [id: ]
|
| Customer | 1 |
/config/config.inc.php:272 (__construct) [id: ]
|
| ShopGroup | 1 |
/classes/shop/Shop.php:562 (__construct) [id: 1]
|
| ConnectionsSource | 1 |
/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
|
| # | Filename |
|---|---|
| 0 | /index.php |
| 1 | /config/config.inc.php |
| 2 | /config/defines.inc.php |
| 3 | /config/autoload.php |
| 4 | /vendor/autoload.php |
| 5 | /vendor/composer/autoload_real.php |
| 6 | /vendor/composer/platform_check.php |
| 7 | /vendor/composer/ClassLoader.php |
| 8 | /vendor/composer/autoload_static.php |
| 9 | /vendor/symfony/deprecation-contracts/function.php |
| 10 | /vendor/symfony/polyfill-mbstring/bootstrap.php |
| 11 | /vendor/symfony/polyfill-mbstring/bootstrap80.php |
| 12 | /vendor/symfony/polyfill-ctype/bootstrap.php |
| 13 | /vendor/symfony/polyfill-ctype/bootstrap80.php |
| 14 | /vendor/symfony/polyfill-php83/bootstrap.php |
| 15 | /vendor/symfony/var-dumper/Resources/functions/dump.php |
| 16 | /vendor/symfony/polyfill-intl-normalizer/bootstrap.php |
| 17 | /vendor/symfony/polyfill-intl-normalizer/bootstrap80.php |
| 18 | /vendor/twig/twig/src/Resources/core.php |
| 19 | /vendor/twig/twig/src/Resources/debug.php |
| 20 | /vendor/twig/twig/src/Resources/escaper.php |
| 21 | /vendor/twig/twig/src/Resources/string_loader.php |
| 22 | /vendor/symfony/polyfill-intl-grapheme/bootstrap.php |
| 23 | /vendor/symfony/polyfill-intl-grapheme/bootstrap80.php |
| 24 | /vendor/symfony/string/Resources/functions.php |
| 25 | /vendor/symfony/polyfill-intl-idn/bootstrap.php |
| 26 | /vendor/symfony/clock/Resources/now.php |
| 27 | /vendor/symfony/polyfill-php80/bootstrap.php |
| 28 | /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php |
| 29 | /vendor/jakeasmith/http_build_url/src/http_build_url.php |
| 30 | /vendor/symfony/polyfill-intl-icu/bootstrap.php |
| 31 | /vendor/ircmaxell/password-compat/lib/password.php |
| 32 | /vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php |
| 33 | /vendor/symfony/polyfill-php73/bootstrap.php |
| 34 | /vendor/symfony/translation/Resources/functions.php |
| 35 | /src/Core/Version.php |
| 36 | /config/alias.php |
| 37 | /vendor/prestashop/autoload/src/PrestashopAutoload.php |
| 38 | /vendor/prestashop/autoload/src/LegacyClassLoader.php |
| 39 | /vendor/symfony/filesystem/Filesystem.php |
| 40 | /vendor/prestashop/autoload/src/Autoloader.php |
| 41 | /config/bootstrap.php |
| 42 | /src/Core/ContainerBuilder.php |
| 43 | /src/Core/Foundation/IoC/Container.php |
| 44 | /src/Adapter/ServiceLocator.php |
| 45 | /var/cache/dev/appParameters.php |
| 48 | /var/cache/dev/class_index.php |
| 49 | /classes/controller/Controller.php |
| 51 | /classes/ObjectModel.php |
| 52 | /src/Core/Foundation/Database/EntityInterface.php |
| 54 | /classes/db/Db.php |
| 56 | /classes/Hook.php |
| 58 | /classes/module/Module.php |
| 59 | /src/Core/Module/Legacy/ModuleInterface.php |
| 61 | /classes/Tools.php |
| 62 | /classes/Context.php |
| 63 | /classes/shop/Shop.php |
| 64 | /src/Core/Security/PasswordGenerator.php |
| 65 | /classes/db/DbPDO.php |
| 66 | /classes/AddressFormat.php |
| 67 | /classes/Configuration.php |
| 68 | /src/Core/Domain/Shop/ValueObject/ShopConstraint.php |
| 69 | /classes/Validate.php |
| 70 | /src/PrestaShopBundle/Form/Admin/Type/FormattedTextareaType.php |
| 71 | /src/PrestaShopBundle/Form/Admin/Type/TranslatorAwareType.php |
| 72 | /src/PrestaShopBundle/Form/Admin/Type/CommonAbstractType.php |
| 73 | /vendor/symfony/form/AbstractType.php |
| 74 | /vendor/symfony/form/FormTypeInterface.php |
| 75 | /classes/cache/Cache.php |
| 76 | /src/Adapter/EntityMapper.php |
| 77 | /classes/db/DbQuery.php |
| 78 | /src/Core/Addon/Theme/ThemeManagerBuilder.php |
| 79 | /vendor/psr/log/src/NullLogger.php |
| 80 | /vendor/psr/log/src/AbstractLogger.php |
| 81 | /vendor/psr/log/src/LoggerTrait.php |
| 82 | /vendor/psr/log/src/LoggerInterface.php |
| 83 | /src/Core/Context/ApiClientContext.php |
| 84 | /src/Adapter/Configuration.php |
| 85 | /vendor/symfony/http-foundation/ParameterBag.php |
| 86 | /src/Core/Domain/Configuration/ShopConfigurationInterface.php |
| 87 | /src/Core/ConfigurationInterface.php |
| 88 | /src/Core/Addon/Theme/ThemeRepository.php |
| 89 | /src/Core/Addon/AddonRepositoryInterface.php |
| 90 | /src/Core/Addon/Theme/Theme.php |
| 91 | /src/Core/Addon/AddonInterface.php |
| 92 | /src/Core/Util/ArrayFinder.php |
| 93 | /vendor/symfony/property-access/PropertyAccess.php |
| 94 | /vendor/symfony/property-access/PropertyAccessorBuilder.php |
| 95 | /vendor/symfony/property-access/PropertyAccessor.php |
| 96 | /vendor/symfony/property-access/PropertyAccessorInterface.php |
| 97 | /vendor/symfony/property-info/Extractor/ReflectionExtractor.php |
| 98 | /vendor/symfony/property-info/PropertyListExtractorInterface.php |
| 99 | /vendor/symfony/property-info/PropertyTypeExtractorInterface.php |
| 100 | /vendor/symfony/property-info/PropertyAccessExtractorInterface.php |
| 101 | /vendor/symfony/property-info/PropertyInitializableExtractorInterface.php |
| 102 | /vendor/symfony/property-info/PropertyReadInfoExtractorInterface.php |
| 103 | /vendor/symfony/property-info/PropertyWriteInfoExtractorInterface.php |
| 104 | /vendor/symfony/property-info/Extractor/ConstructorArgumentTypeExtractorInterface.php |
| 105 | /vendor/symfony/property-info/Type.php |
| 106 | /vendor/symfony/string/Inflector/EnglishInflector.php |
| 107 | /vendor/symfony/string/Inflector/InflectorInterface.php |
| 108 | /vendor/symfony/property-access/PropertyPath.php |
| 109 | /vendor/symfony/property-access/PropertyPathInterface.php |
| 110 | /vendor/symfony/property-access/PropertyPathIteratorInterface.php |
| 111 | /config/defines_uri.inc.php |
| 112 | /classes/Language.php |
| 113 | /src/Core/Language/LanguageInterface.php |
| 114 | /classes/Country.php |
| 115 | /classes/PrestaShopCollection.php |
| 116 | /classes/shop/ShopGroup.php |
| 117 | /classes/Cookie.php |
| 118 | /src/Core/Http/CookieOptions.php |
| 119 | /classes/PhpEncryption.php |
| 120 | /classes/PhpEncryptionEngine.php |
| 121 | /vendor/defuse/php-encryption/src/Key.php |
| 122 | /vendor/defuse/php-encryption/src/Encoding.php |
| 123 | /vendor/defuse/php-encryption/src/Core.php |
| 124 | /src/Core/Session/SessionHandler.php |
| 125 | /src/Core/Session/SessionHandlerInterface.php |
| 126 | /vendor/symfony/http-foundation/Session/Session.php |
| 127 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBag.php |
| 128 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBagInterface.php |
| 129 | /vendor/symfony/http-foundation/Session/SessionBagInterface.php |
| 130 | /vendor/symfony/http-foundation/Session/Flash/FlashBag.php |
| 131 | /vendor/symfony/http-foundation/Session/Flash/FlashBagInterface.php |
| 132 | /vendor/symfony/http-foundation/Session/SessionBagProxy.php |
| 133 | /vendor/symfony/http-foundation/Session/FlashBagAwareSessionInterface.php |
| 134 | /vendor/symfony/http-foundation/Session/SessionInterface.php |
| 135 | /vendor/symfony/http-foundation/Session/Storage/PhpBridgeSessionStorage.php |
| 136 | /vendor/symfony/http-foundation/Session/Storage/NativeSessionStorage.php |
| 137 | /vendor/symfony/http-foundation/Session/Storage/MetadataBag.php |
| 138 | /vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php |
| 139 | /vendor/symfony/http-foundation/Session/Storage/Handler/AbstractSessionHandler.php |
| 140 | /vendor/symfony/http-foundation/Session/Storage/Proxy/SessionHandlerProxy.php |
| 141 | /vendor/symfony/http-foundation/Session/Storage/Proxy/AbstractProxy.php |
| 142 | /vendor/symfony/http-foundation/Session/Storage/SessionStorageInterface.php |
| 143 | /config/smarty.config.inc.php |
| 144 | /classes/Smarty/SmartyDev.php |
| 145 | /vendor/smarty/smarty/libs/Smarty.class.php |
| 146 | /vendor/smarty/smarty/libs/functions.php |
| 147 | /vendor/smarty/smarty/libs/Autoloader.php |
| 148 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php |
| 149 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php |
| 150 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| 151 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php |
| 152 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php |
| 153 | /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php |
| 154 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php |
| 155 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php |
| 156 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php |
| 157 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerclass.php |
| 158 | /classes/ImageManager.php |
| 159 | /classes/Product.php |
| 160 | /classes/Profile.php |
| 161 | /classes/Tab.php |
| 162 | /config/smartyfront.config.inc.php |
| 163 | /classes/Smarty/SmartyResourceModule.php |
| 164 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php |
| 165 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php |
| 166 | /classes/Smarty/SmartyResourceParent.php |
| 167 | /classes/Smarty/SmartyLazyRegister.php |
| 168 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php |
| 169 | /vendor/smarty/smarty/libs/plugins/modifier.truncate.php |
| 170 | /classes/Customer.php |
| 171 | /classes/Group.php |
| 172 | /classes/Link.php |
| 173 | /classes/shop/ShopUrl.php |
| 174 | /app/FrontKernel.php |
| 175 | /app/AppKernel.php |
| 176 | /vendor/symfony/http-kernel/Kernel.php |
| 177 | /vendor/symfony/config/ConfigCache.php |
| 178 | /vendor/symfony/config/ResourceCheckerConfigCache.php |
| 179 | /vendor/symfony/config/ConfigCacheInterface.php |
| 180 | /vendor/symfony/http-kernel/KernelInterface.php |
| 181 | /vendor/symfony/http-kernel/HttpKernelInterface.php |
| 182 | /vendor/symfony/http-kernel/RebootableInterface.php |
| 183 | /vendor/symfony/http-kernel/TerminableInterface.php |
| 184 | /vendor/symfony/dotenv/Dotenv.php |
| 185 | /classes/Dispatcher.php |
| 186 | /vendor/symfony/http-foundation/Request.php |
| 187 | /vendor/symfony/http-foundation/AcceptHeader.php |
| 188 | /vendor/symfony/http-foundation/AcceptHeaderItem.php |
| 189 | /vendor/symfony/http-foundation/FileBag.php |
| 190 | /vendor/symfony/http-foundation/HeaderBag.php |
| 191 | /vendor/symfony/http-foundation/HeaderUtils.php |
| 192 | /vendor/symfony/http-foundation/InputBag.php |
| 193 | /vendor/symfony/http-foundation/ServerBag.php |
| 194 | /src/Adapter/SymfonyContainer.php |
| 195 | /config/db_slave_server.inc.php |
| 196 | /src/Adapter/ContainerBuilder.php |
| 197 | /src/Adapter/Environment.php |
| 198 | /src/Core/EnvironmentInterface.php |
| 199 | /vendor/symfony/config/Resource/SelfCheckingResourceChecker.php |
| 200 | /vendor/symfony/config/ResourceCheckerInterface.php |
| 201 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/DoctrineProvider.php |
| 202 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php |
| 203 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php |
| 204 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php |
| 205 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php |
| 206 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiOperationCache.php |
| 207 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php |
| 208 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiDeleteCache.php |
| 209 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php |
| 210 | /vendor/symfony/cache/Adapter/ArrayAdapter.php |
| 211 | /vendor/psr/log/src/LoggerAwareTrait.php |
| 212 | /vendor/symfony/cache/Adapter/AdapterInterface.php |
| 213 | /vendor/symfony/cache/CacheItem.php |
| 214 | /vendor/symfony/cache-contracts/ItemInterface.php |
| 215 | /vendor/psr/cache/src/CacheItemInterface.php |
| 216 | /vendor/psr/cache/src/CacheItemPoolInterface.php |
| 217 | /vendor/symfony/cache-contracts/CacheInterface.php |
| 218 | /vendor/psr/log/src/LoggerAwareInterface.php |
| 219 | /vendor/symfony/cache/ResettableInterface.php |
| 220 | /vendor/symfony/service-contracts/ResetInterface.php |
| 221 | /vendor/doctrine/orm/src/Tools/Setup.php |
| 222 | /vendor/doctrine/deprecations/src/Deprecation.php |
| 223 | /vendor/doctrine/orm/src/Configuration.php |
| 224 | /vendor/doctrine/dbal/src/Configuration.php |
| 225 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/CacheAdapter.php |
| 226 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationReader.php |
| 227 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php |
| 228 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php |
| 229 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php |
| 230 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php |
| 231 | /vendor/doctrine/lexer/src/AbstractLexer.php |
| 232 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php |
| 233 | /vendor/doctrine/orm/src/Mapping/Driver/AnnotationDriver.php |
| 234 | /vendor/doctrine/orm/src/Mapping/Driver/CompatibilityAnnotationDriver.php |
| 235 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriver.php |
| 236 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/ColocatedMappingDriver.php |
| 237 | /vendor/doctrine/orm/src/Mapping/Driver/ReflectionBasedDriver.php |
| 238 | /vendor/symfony/cache/Adapter/FilesystemAdapter.php |
| 239 | /vendor/symfony/cache/Adapter/AbstractAdapter.php |
| 240 | /vendor/symfony/cache/Traits/AbstractAdapterTrait.php |
| 241 | /vendor/symfony/cache/Traits/ContractsTrait.php |
| 242 | /vendor/symfony/cache-contracts/CacheTrait.php |
| 243 | /vendor/psr/cache/src/InvalidArgumentException.php |
| 244 | /vendor/psr/cache/src/CacheException.php |
| 245 | /vendor/symfony/cache/Traits/FilesystemTrait.php |
| 246 | /vendor/symfony/cache/Traits/FilesystemCommonTrait.php |
| 247 | /vendor/symfony/cache/PruneableInterface.php |
| 248 | /vendor/symfony/cache/Marshaller/DefaultMarshaller.php |
| 249 | /vendor/symfony/cache/Marshaller/MarshallerInterface.php |
| 250 | /src/Adapter/Module/Repository/CachedModuleRepository.php |
| 251 | /src/Adapter/Module/Repository/ModuleRepository.php |
| 252 | /src/Core/Repository/AbstractObjectModelRepository.php |
| 253 | /vendor/symfony/cache/LockRegistry.php |
| 254 | /modules/psshipping/vendor/autoload.php |
| 255 | /modules/psshipping/vendor/composer/autoload_real.php |
| 256 | /modules/psshipping/vendor/composer/autoload_static.php |
| 257 | /modules/psshipping/vendor/ralouphie/getallheaders/src/getallheaders.php |
| 258 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions_include.php |
| 259 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions.php |
| 260 | /modules/psshipping/vendor/clue/stream-filter/src/functions_include.php |
| 261 | /modules/psshipping/vendor/clue/stream-filter/src/functions.php |
| 262 | /modules/psshipping/vendor/php-http/message/src/filters.php |
| 263 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions_include.php |
| 264 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions.php |
| 265 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment.php |
| 266 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/Client.php |
| 267 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/Consumer.php |
| 268 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/QueueConsumer.php |
| 269 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/Consumer/File.php |
| 270 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/Consumer/ForkCurl.php |
| 271 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/Consumer/LibCurl.php |
| 272 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/Consumer/Socket.php |
| 273 | /modules/psshipping/vendor/segmentio/analytics-php/lib/Segment/Version.php |
| 274 | /modules/psxmarketingwithgoogle/vendor/autoload.php |
| 275 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_real.php |
| 276 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_static.php |
| 277 | /modules/ps_accounts/vendor/autoload.php |
| 278 | /modules/ps_accounts/vendor/composer/autoload_real.php |
| 279 | /modules/ps_accounts/vendor/composer/platform_check.php |
| 280 | /modules/ps_accounts/vendor/composer/autoload_static.php |
| 281 | /modules/ps_accounts/vendor/paragonie/random_compat/lib/random.php |
| 282 | /modules/ps_accounts/vendor/symfony/polyfill-ctype/bootstrap.php |
| 283 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/class-aliases.php |
| 284 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Token.php |
| 285 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Signature.php |
| 286 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/json-exception-polyfill.php |
| 287 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php |
| 288 | /modules/ps_accounts/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php |
| 289 | /modules/ps_accounts/vendor/ramsey/uuid/src/functions.php |
| 290 | /modules/ps_classic_edition/vendor/autoload.php |
| 291 | /modules/ps_classic_edition/vendor/composer/autoload_real.php |
| 292 | /modules/ps_classic_edition/vendor/composer/platform_check.php |
| 293 | /modules/ps_classic_edition/vendor/composer/autoload_static.php |
| 294 | /modules/ps_facebook/vendor/autoload.php |
| 295 | /modules/ps_facebook/vendor/composer/autoload_real.php |
| 296 | /modules/ps_facebook/vendor/composer/autoload_static.php |
| 297 | /modules/ps_checkout/vendor/autoload.php |
| 298 | /modules/ps_checkout/vendor/composer/autoload_real.php |
| 299 | /modules/ps_checkout/vendor/composer/autoload_static.php |
| 300 | /modules/ps_mbo/vendor/autoload.php |
| 301 | /modules/ps_mbo/vendor/composer/autoload_real.php |
| 302 | /modules/ps_mbo/vendor/composer/platform_check.php |
| 303 | /modules/ps_mbo/vendor/composer/autoload_static.php |
| 304 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions_include.php |
| 305 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions.php |
| 306 | /modules/ps_mbo/vendor/sentry/sentry/src/functions.php |
| 307 | /modules/ps_mbo/bootstrap.php |
| 308 | /modules/ps_mbo/src/Helpers/EnvHelper.php |
| 309 | /modules/ps_eventbus/vendor/autoload.php |
| 310 | /modules/ps_eventbus/vendor/composer/autoload_real.php |
| 311 | /modules/ps_eventbus/vendor/composer/autoload_static.php |
| 312 | /vendor/symfony/config/Resource/FileResource.php |
| 313 | /vendor/symfony/config/Resource/SelfCheckingResourceInterface.php |
| 314 | /vendor/symfony/config/Resource/ResourceInterface.php |
| 315 | /vendor/symfony/config/Resource/ReflectionClassResource.php |
| 316 | /vendor/symfony/config/Resource/DirectoryResource.php |
| 317 | /vendor/symfony/config/Resource/ClassExistenceResource.php |
| 318 | /var/cache/dev/FrontContainer.php |
| 319 | /src/Adapter/Container/LegacyContainer.php |
| 320 | /vendor/symfony/dependency-injection/Container.php |
| 321 | /vendor/symfony/dependency-injection/Argument/RewindableGenerator.php |
| 322 | /vendor/symfony/dependency-injection/Argument/ServiceLocator.php |
| 323 | /vendor/symfony/dependency-injection/ServiceLocator.php |
| 324 | /vendor/symfony/service-contracts/ServiceLocatorTrait.php |
| 325 | /vendor/psr/container/src/ContainerExceptionInterface.php |
| 326 | /vendor/psr/container/src/NotFoundExceptionInterface.php |
| 327 | /vendor/symfony/service-contracts/ServiceProviderInterface.php |
| 328 | /vendor/psr/container/src/ContainerInterface.php |
| 329 | /vendor/symfony/dependency-injection/ContainerInterface.php |
| 330 | /src/Adapter/Container/LegacyContainerInterface.php |
| 331 | /src/PrestaShopBundle/Entity/Repository/FeatureFlagRepository.php |
| 332 | /vendor/doctrine/orm/src/EntityRepository.php |
| 333 | /vendor/doctrine/persistence/src/Persistence/ObjectRepository.php |
| 334 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Selectable.php |
| 335 | /vendor/symfony/var-exporter/LazyProxyTrait.php |
| 336 | /vendor/symfony/var-exporter/Internal/LazyObjectTrait.php |
| 337 | /vendor/symfony/var-exporter/LazyObjectInterface.php |
| 338 | /vendor/symfony/var-exporter/Internal/Hydrator.php |
| 339 | /vendor/symfony/var-exporter/Internal/LazyObjectRegistry.php |
| 340 | /vendor/symfony/var-exporter/Internal/LazyObjectState.php |
| 341 | /src/PrestaShopBundle/Security/Admin/LegacyAdminTokenValidator.php |
| 342 | /vendor/symfony/var-exporter/LazyGhostTrait.php |
| 343 | /src/Core/FeatureFlag/FeatureFlagManager.php |
| 344 | /src/Core/FeatureFlag/FeatureFlagStateCheckerInterface.php |
| 345 | /src/Core/FeatureFlag/Layer/DbLayer.php |
| 346 | /src/Core/FeatureFlag/TypeLayerInterface.php |
| 347 | /src/Core/FeatureFlag/Layer/DotEnvLayer.php |
| 348 | /src/Core/FeatureFlag/Layer/EnvLayer.php |
| 349 | /src/Core/FeatureFlag/Layer/QueryLayer.php |
| 350 | /vendor/symfony/http-foundation/RequestStack.php |
| 351 | /vendor/doctrine/orm/src/EntityManager.php |
| 352 | /vendor/doctrine/orm/src/EntityManagerInterface.php |
| 353 | /vendor/doctrine/persistence/src/Persistence/ObjectManager.php |
| 354 | /src/Core/Hook/HookModuleFilter.php |
| 355 | /src/Core/Hook/HookModuleFilterInterface.php |
| 356 | /modules/ps_checkout/ps_checkout.php |
| 357 | /classes/PaymentModule.php |
| 358 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php |
| 359 | /vendor/smarty/smarty/libs/sysplugins/smarty_data.php |
| 360 | /src/PrestaShopBundle/Translation/TranslatorComponent.php |
| 361 | /vendor/symfony/translation/Translator.php |
| 362 | /vendor/symfony/translation/MessageCatalogue.php |
| 363 | /vendor/symfony/translation/MessageCatalogueInterface.php |
| 364 | /vendor/symfony/translation/MetadataAwareInterface.php |
| 365 | /vendor/symfony/translation/CatalogueMetadataAwareInterface.php |
| 366 | /vendor/symfony/translation-contracts/TranslatorInterface.php |
| 367 | /vendor/symfony/translation/TranslatorBagInterface.php |
| 368 | /vendor/symfony/translation-contracts/LocaleAwareInterface.php |
| 369 | /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php |
| 370 | /src/PrestaShopBundle/Translation/TranslatorLanguageTrait.php |
| 371 | /src/PrestaShopBundle/Translation/TranslatorInterface.php |
| 372 | /vendor/symfony/translation/Formatter/MessageFormatter.php |
| 373 | /vendor/symfony/translation/Formatter/IntlFormatter.php |
| 374 | /vendor/symfony/translation/Formatter/IntlFormatterInterface.php |
| 375 | /vendor/symfony/translation/Formatter/MessageFormatterInterface.php |
| 376 | /vendor/symfony/translation/IdentityTranslator.php |
| 377 | /vendor/symfony/translation-contracts/TranslatorTrait.php |
| 378 | /vendor/symfony/config/ConfigCacheFactory.php |
| 379 | /vendor/symfony/config/ConfigCacheFactoryInterface.php |
| 380 | /var/cache/dev/translations/catalogue.en-US.NXhscRe.php |
| 381 | /controllers/front/listing/CategoryController.php |
| 382 | /classes/controller/ProductListingFrontController.php |
| 383 | /classes/controller/ProductPresentingFrontController.php |
| 384 | /classes/controller/FrontController.php |
| 385 | /src/Adapter/Presenter/Object/ObjectPresenter.php |
| 386 | /src/Adapter/Presenter/PresenterInterface.php |
| 387 | /src/Adapter/Presenter/Cart/CartPresenter.php |
| 388 | /src/Adapter/Image/ImageRetriever.php |
| 389 | /classes/tax/TaxConfiguration.php |
| 390 | /classes/Smarty/TemplateFinder.php |
| 391 | /classes/assets/StylesheetManager.php |
| 392 | /classes/assets/AbstractAssetManager.php |
| 393 | /src/Adapter/Assets/AssetUrlGeneratorTrait.php |
| 394 | /classes/assets/JavascriptManager.php |
| 395 | /classes/assets/CccReducer.php |
| 396 | /classes/Category.php |
| 397 | /src/Core/Domain/Category/ValueObject/RedirectType.php |
| 398 | /src/Core/Domain/Category/CategorySettings.php |
| 399 | /src/Core/Domain/Category/SeoSettings.php |
| 400 | /classes/webservice/WebserviceRequest.php |
| 401 | /src/Core/Localization/Locale/Repository.php |
| 402 | /src/Core/Localization/Locale/RepositoryInterface.php |
| 403 | /src/Core/Localization/CLDR/LocaleRepository.php |
| 404 | /src/Core/Localization/CLDR/LocaleDataSource.php |
| 405 | /src/Core/Localization/CLDR/DataLayer/LocaleCache.php |
| 406 | /src/Core/Data/Layer/AbstractDataLayer.php |
| 407 | /src/Core/Localization/CLDR/LocaleDataLayerInterface.php |
| 408 | /src/Core/Localization/CLDR/DataLayer/LocaleReference.php |
| 409 | /src/Core/Localization/CLDR/Reader.php |
| 410 | /src/Core/Localization/CLDR/ReaderInterface.php |
| 411 | /src/Core/Localization/Currency/Repository.php |
| 412 | /src/Core/Localization/Currency/RepositoryInterface.php |
| 413 | /src/Core/Localization/Currency/CurrencyDataSource.php |
| 414 | /src/Core/Localization/Currency/DataSourceInterface.php |
| 415 | /src/Core/Localization/Currency/DataLayer/CurrencyCache.php |
| 416 | /src/Core/Localization/Currency/CurrencyDataLayerInterface.php |
| 417 | /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php |
| 418 | /src/Adapter/Currency/CurrencyDataProvider.php |
| 419 | /src/Core/Currency/CurrencyDataProviderInterface.php |
| 420 | /src/Adapter/LegacyContext.php |
| 421 | /src/Adapter/Tools.php |
| 422 | /src/Core/Localization/Currency/DataLayer/CurrencyReference.php |
| 423 | /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php |
| 424 | /vendor/prestashop/decimal/src/Operation/Rounding.php |
| 425 | /src/Core/Localization/Locale.php |
| 426 | /src/Core/Localization/LocaleInterface.php |
| 427 | /src/Core/Localization/Specification/Price.php |
| 428 | /src/Core/Localization/Specification/Number.php |
| 429 | /src/Core/Localization/Specification/NumberInterface.php |
| 430 | /src/Core/Localization/Specification/Factory.php |
| 431 | /src/Core/Localization/CLDR/LocaleData.php |
| 432 | /src/Core/Localization/CLDR/NumberSymbolsData.php |
| 433 | /src/Core/Localization/CLDR/CurrencyData.php |
| 434 | /src/Core/Localization/CLDR/Locale.php |
| 435 | /src/Core/Localization/CLDR/LocaleInterface.php |
| 436 | /src/Core/Localization/Specification/NumberSymbolList.php |
| 437 | /classes/Currency.php |
| 438 | /src/Core/Localization/Currency/LocalizedCurrencyId.php |
| 439 | /src/Core/Localization/Currency/CurrencyData.php |
| 440 | /src/Core/Localization/Currency/CurrencyCollection.php |
| 441 | /src/Core/Localization/Currency.php |
| 442 | /src/Core/Localization/CurrencyInterface.php |
| 443 | /src/Core/Localization/Specification/NumberCollection.php |
| 444 | /src/Core/Localization/Number/Formatter.php |
| 445 | /classes/Cart.php |
| 446 | /src/Adapter/AddressFactory.php |
| 447 | /classes/CartRule.php |
| 448 | /src/Core/Domain/Product/ValueObject/RedirectType.php |
| 449 | /src/Core/Util/DateTime/DateTime.php |
| 450 | /src/Core/Domain/Product/Stock/ValueObject/OutOfStockType.php |
| 451 | /src/Core/Domain/Product/Pack/ValueObject/PackStockType.php |
| 452 | /src/Core/Domain/Product/ValueObject/ProductType.php |
| 453 | /src/Core/Domain/Product/ValueObject/Reference.php |
| 454 | /src/Core/Domain/Product/ValueObject/Gtin.php |
| 455 | /src/Core/Domain/Product/ValueObject/Isbn.php |
| 456 | /src/Core/Domain/Product/ValueObject/Upc.php |
| 457 | /src/Core/Domain/Product/ProductSettings.php |
| 458 | /src/Adapter/Presenter/Category/CategoryPresenter.php |
| 459 | /src/Adapter/Presenter/Category/CategoryLazyArray.php |
| 460 | /src/Adapter/Presenter/AbstractLazyArray.php |
| 461 | /src/Adapter/Presenter/LazyArrayAttribute.php |
| 462 | /src/Core/Util/Inflector.php |
| 463 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/InflectorFactory.php |
| 464 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Language.php |
| 465 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/InflectorFactory.php |
| 466 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/GenericLanguageInflectorFactory.php |
| 467 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/LanguageInflectorFactory.php |
| 468 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Rules.php |
| 469 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Ruleset.php |
| 470 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformations.php |
| 471 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/WordInflector.php |
| 472 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Inflectible.php |
| 473 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformation.php |
| 474 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Pattern.php |
| 475 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Patterns.php |
| 476 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Uninflected.php |
| 477 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitutions.php |
| 478 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitution.php |
| 479 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Word.php |
| 480 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Inflector.php |
| 481 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/CachedWordInflector.php |
| 482 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/RulesetInflector.php |
| 483 | /src/Core/Domain/Shop/ValueObject/ShopId.php |
| 484 | /src/Core/Domain/Shop/ValueObject/ShopIdInterface.php |
| 485 | /vendor/symfony/property-access/Exception/UnexpectedTypeException.php |
| 486 | /vendor/symfony/property-access/Exception/RuntimeException.php |
| 487 | /vendor/symfony/property-access/Exception/ExceptionInterface.php |
| 488 | /modules/blockreassurance/blockreassurance.php |
| 489 | /src/Core/Module/WidgetInterface.php |
| 490 | /src/PrestaShopBundle/Translation/DomainNormalizer.php |
| 491 | /classes/Media.php |
| 492 | /modules/blockwishlist/blockwishlist.php |
| 493 | /modules/ps_emailsubscription/ps_emailsubscription.php |
| 494 | /modules/ps_socialfollow/ps_socialfollow.php |
| 495 | /modules/ps_facebook/ps_facebook.php |
| 496 | /classes/Translate.php |
| 497 | /modules/ps_facebook/translations/en.php |
| 498 | /modules/psshipping/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php |
| 499 | /modules/psshipping/vendor/prestashop/module-lib-cache-directory-provider/src/Cache/CacheDirectoryProvider.php |
| 500 | /modules/psshipping/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ContainerProvider.php |
| 501 | /var/cache/dev/Ps_facebookFrontContainer.php |
| 502 | /modules/ps_facebook/classes/Buffer/TemplateBuffer.php |
| 503 | /var/cache/dev/Ps_checkout9506FrontContainer.php |
| 504 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Validator/MerchantValidator.php |
| 505 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Validator/MerchantValidatorInterface.php |
| 506 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Adapter/Configuration.php |
| 507 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Adapter/ConfigurationInterface.php |
| 508 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Adapter/Context.php |
| 509 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Adapter/ContextInterface.php |
| 510 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Repository/PsAccountRepository.php |
| 511 | /modules/ps_checkout/vendor/invertus/infrastructure/src/Repository/PsAccountRepositoryInterface.php |
| 512 | /modules/psshipping/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php |
| 513 | /modules/psshipping/vendor/prestashop/prestashop-accounts-installer/src/Installer/Installer.php |
| 514 | /src/Core/Addon/Module/ModuleManagerBuilder.php |
| 515 | /src/Adapter/LegacyLogger.php |
| 516 | /src/Adapter/Module/ModuleDataProvider.php |
| 517 | /src/Adapter/Module/AdminModuleDataProvider.php |
| 518 | /src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php |
| 519 | /src/Adapter/Module/Module.php |
| 520 | /src/Core/Module/ModuleInterface.php |
| 521 | /vendor/symfony/config/FileLocator.php |
| 522 | /vendor/symfony/config/FileLocatorInterface.php |
| 523 | /vendor/symfony/routing/Loader/YamlFileLoader.php |
| 524 | /vendor/symfony/config/Loader/FileLoader.php |
| 525 | /vendor/symfony/config/Loader/Loader.php |
| 526 | /vendor/symfony/config/Loader/LoaderInterface.php |
| 527 | /vendor/symfony/routing/Loader/Configurator/Traits/HostTrait.php |
| 528 | /vendor/symfony/routing/Loader/Configurator/Traits/LocalizedRouteTrait.php |
| 529 | /vendor/symfony/routing/Loader/Configurator/Traits/PrefixTrait.php |
| 530 | /vendor/symfony/routing/Router.php |
| 531 | /vendor/symfony/routing/RouterInterface.php |
| 532 | /vendor/symfony/routing/Matcher/UrlMatcherInterface.php |
| 533 | /vendor/symfony/routing/RequestContextAwareInterface.php |
| 534 | /vendor/symfony/routing/Generator/UrlGeneratorInterface.php |
| 535 | /vendor/symfony/routing/Matcher/RequestMatcherInterface.php |
| 536 | /vendor/symfony/routing/RequestContext.php |
| 537 | /src/Core/Module/ModuleManager.php |
| 538 | /src/Core/Module/ModuleManagerInterface.php |
| 539 | /src/Core/Module/ModuleRepository.php |
| 540 | /src/Core/Module/ModuleRepositoryInterface.php |
| 541 | /src/Adapter/HookManager.php |
| 542 | /src/Core/Context/LanguageContext.php |
| 543 | /src/Core/Module/SourceHandler/SourceHandlerFactory.php |
| 544 | /src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php |
| 545 | /vendor/symfony/event-dispatcher/EventDispatcherInterface.php |
| 546 | /vendor/symfony/event-dispatcher-contracts/EventDispatcherInterface.php |
| 547 | /vendor/psr/event-dispatcher/src/EventDispatcherInterface.php |
| 548 | /src/Core/Hook/HookDispatcherInterface.php |
| 549 | /vendor/symfony/translation/Loader/XliffFileLoader.php |
| 550 | /vendor/symfony/translation/Loader/LoaderInterface.php |
| 551 | /modules/ps_accounts/ps_accounts.php |
| 552 | /modules/ps_accounts/src/Hook/HookableTrait.php |
| 553 | /modules/ps_accounts/src/Module/Install.php |
| 554 | /modules/ps_accounts/translations/en.php |
| 555 | /modules/ps_accounts/src/ServiceContainer/PsAccountsContainer.php |
| 556 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/ServiceContainer.php |
| 557 | /modules/ps_accounts/config.php |
| 558 | /modules/ps_accounts/src/Log/Logger.php |
| 559 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Logger.php |
| 560 | /modules/ps_accounts/vendor/psr/log/Psr/Log/LoggerInterface.php |
| 561 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/ResettableInterface.php |
| 562 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/RotatingFileHandler.php |
| 563 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php |
| 564 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php |
| 565 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php |
| 566 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/HandlerInterface.php |
| 567 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Utils.php |
| 568 | /modules/ps_accounts/src/ServiceProvider/ApiClientProvider.php |
| 569 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/Contract/IServiceProvider.php |
| 570 | /modules/ps_accounts/src/ServiceProvider/CommandProvider.php |
| 571 | /modules/ps_accounts/src/ServiceProvider/DefaultProvider.php |
| 572 | /modules/ps_accounts/src/ServiceProvider/OAuth2Provider.php |
| 573 | /modules/ps_accounts/src/ServiceProvider/RepositoryProvider.php |
| 574 | /modules/ps_accounts/src/ServiceProvider/SessionProvider.php |
| 575 | /modules/ps_accounts/src/Service/PsAccountsService.php |
| 576 | /modules/ps_accounts/src/Account/Session/ShopSession.php |
| 577 | /modules/ps_accounts/src/Account/Session/Session.php |
| 578 | /modules/ps_accounts/src/Account/Session/SessionInterface.php |
| 579 | /modules/ps_accounts/src/Repository/ConfigurationRepository.php |
| 580 | /modules/ps_accounts/src/Adapter/Configuration.php |
| 581 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Service.php |
| 582 | /modules/ps_accounts/src/Http/Client/ClientConfig.php |
| 583 | /modules/ps_accounts/src/Http/Client/ConfigObject.php |
| 584 | /modules/ps_accounts/src/Type/Enum.php |
| 585 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Client.php |
| 586 | /modules/ps_accounts/src/Adapter/Link.php |
| 587 | /modules/ps_accounts/src/Context/ShopContext.php |
| 588 | /modules/ps_accounts/vendor/ramsey/uuid/src/Uuid.php |
| 589 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidInterface.php |
| 590 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactory.php |
| 591 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactoryInterface.php |
| 592 | /modules/ps_accounts/vendor/ramsey/uuid/src/FeatureSet.php |
| 593 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Number/DegradedNumberConverter.php |
| 594 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/NumberConverterInterface.php |
| 595 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/DefaultUuidBuilder.php |
| 596 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/UuidBuilderInterface.php |
| 597 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/StringCodec.php |
| 598 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/CodecInterface.php |
| 599 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/FallbackNodeProvider.php |
| 600 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/NodeProviderInterface.php |
| 601 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/SystemNodeProvider.php |
| 602 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/RandomNodeProvider.php |
| 603 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorFactory.php |
| 604 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomBytesGenerator.php |
| 605 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorInterface.php |
| 606 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Time/SystemTimeProvider.php |
| 607 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/TimeProviderInterface.php |
| 608 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorFactory.php |
| 609 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Time/PhpTimeConverter.php |
| 610 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/TimeConverterInterface.php |
| 611 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/DefaultTimeGenerator.php |
| 612 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorInterface.php |
| 613 | /modules/ps_accounts/vendor/ramsey/uuid/src/BinaryUtils.php |
| 614 | /modules/ps_accounts/src/Service/OAuth2/CachedFile.php |
| 615 | /modules/ps_accounts/src/Account/LinkShop.php |
| 616 | /modules/ps_accounts/src/Cqrs/CommandBus.php |
| 617 | /modules/ps_accounts/src/Cqrs/Bus.php |
| 618 | /modules/ps_accounts/src/Account/Session/Firebase/ShopSession.php |
| 619 | /modules/ps_accounts/src/Account/Session/Firebase/FirebaseSession.php |
| 620 | /modules/ps_accounts/src/Account/Session/Firebase/OwnerSession.php |
| 621 | /modules/ps_checkout/vendor/invertus/core/src/Settings/Configuration/PayPalConfiguration.php |
| 622 | /modules/ps_emailalerts/ps_emailalerts.php |
| 623 | /modules/ps_emailalerts/MailAlert.php |
| 624 | /src/Adapter/Presenter/Cart/CartLazyArray.php |
| 625 | /src/Adapter/Product/PriceFormatter.php |
| 626 | /classes/Gender.php |
| 627 | /src/Core/Domain/Title/ValueObject/Gender.php |
| 628 | /classes/Risk.php |
| 629 | /classes/Meta.php |
| 630 | /classes/Address.php |
| 631 | /classes/ImageType.php |
| 632 | /classes/State.php |
| 633 | /src/Core/Security/PasswordPolicyConfiguration.php |
| 634 | /src/Core/Configuration/DataConfigurationInterface.php |
| 635 | /src/Core/Security/Hashing.php |
| 636 | /src/Core/Filter/FrontEndObject/MainFilter.php |
| 637 | /src/Core/Filter/FilterInterface.php |
| 638 | /src/Core/Filter/FrontEndObject/CartFilter.php |
| 639 | /src/Core/Filter/HashMapWhitelistFilter.php |
| 640 | /src/Core/Filter/CollectionFilter.php |
| 641 | /src/Core/Filter/FrontEndObject/ProductFilter.php |
| 642 | /src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php |
| 643 | /src/Core/Filter/FrontEndObject/CustomerFilter.php |
| 644 | /src/Core/Filter/FrontEndObject/ShopFilter.php |
| 645 | /src/Core/Filter/FrontEndObject/ConfigurationFilter.php |
| 646 | /classes/ProductAssembler.php |
| 647 | /src/Core/Product/Search/ProductSearchContext.php |
| 648 | /modules/ps_shoppingcart/ps_shoppingcart.php |
| 649 | /modules/ps_searchbar/ps_searchbar.php |
| 650 | /modules/ps_imageslider/ps_imageslider.php |
| 651 | /modules/ps_imageslider/Ps_HomeSlide.php |
| 652 | /modules/productcomments/productcomments.php |
| 653 | /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php |
| 654 | /modules/ps_facebook/classes/Config/Env.php |
| 655 | /modules/ps_facebook/classes/Handler/ErrorHandler/ModuleFilteredRavenClient.php |
| 656 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Client.php |
| 657 | /modules/ps_facebook/classes/Config/Config.php |
| 658 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Util.php |
| 659 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Compat.php |
| 660 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Processor/SanitizeDataProcessor.php |
| 661 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Processor.php |
| 662 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Context.php |
| 663 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Breadcrumbs.php |
| 664 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Serializer.php |
| 665 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/ReprSerializer.php |
| 666 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/TransactionStack.php |
| 667 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Breadcrumbs/ErrorHandler.php |
| 668 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/Stacktrace.php |
| 669 | /modules/ps_accounts/src/Adapter/ConfigurationKeys.php |
| 670 | /modules/psshipping/vendor/sentry/sentry/lib/Raven/ErrorHandler.php |
| 671 | /modules/ps_facebook/classes/Dispatcher/EventDispatcher.php |
| 672 | /modules/ps_facebook/classes/Handler/ApiConversionHandler.php |
| 673 | /modules/ps_facebook/classes/Adapter/ConfigurationAdapter.php |
| 674 | /modules/ps_facebook/classes/Factory/ContextFactory.php |
| 675 | /modules/ps_facebook/classes/API/Client/FacebookClient.php |
| 676 | /modules/ps_facebook/classes/Factory/FacebookEssentialsApiClientFactory.php |
| 677 | /modules/ps_facebook/classes/Factory/ApiClientFactoryInterface.php |
| 678 | /modules/ps_facebook/classes/Provider/AccessTokenProvider.php |
| 679 | /modules/ps_facebook/classes/Factory/PsApiClientFactory.php |
| 680 | /modules/ps_facebook/classes/Handler/ConfigurationHandler.php |
| 681 | /modules/ps_facebook/classes/Http/HttpClient.php |
| 682 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Api.php |
| 683 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Session.php |
| 684 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/SessionInterface.php |
| 685 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/ApiConfig.php |
| 686 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Http/Client.php |
| 687 | /modules/ps_facebook/classes/Handler/PixelHandler.php |
| 688 | /vendor/symfony/http-foundation/Session/Storage/MockFileSessionStorage.php |
| 689 | /vendor/symfony/http-foundation/Session/Storage/MockArraySessionStorage.php |
| 690 | /modules/ps_facebook/classes/Provider/EventDataProvider.php |
| 691 | /modules/ps_facebook/classes/Adapter/ToolsAdapter.php |
| 692 | /modules/ps_facebook/classes/Repository/ProductRepository.php |
| 693 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProvider.php |
| 694 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProviderInterface.php |
| 695 | /modules/ps_facebook/classes/Repository/GoogleCategoryRepository.php |
| 696 | /modules/ps_facebook/classes/Provider/GoogleCategoryProvider.php |
| 697 | /modules/ps_facebook/classes/Provider/GoogleCategoryProviderInterface.php |
| 698 | /modules/psxmarketingwithgoogle/psxmarketingwithgoogle.php |
| 699 | /var/cache/dev/PsxmarketingwithgoogleFrontContainer.php |
| 700 | /modules/psxmarketingwithgoogle/classes/Adapter/ConfigurationAdapter.php |
| 701 | /modules/psxmarketingwithgoogle/classes/Factory/ContextFactory.php |
| 702 | /modules/psxmarketingwithgoogle/classes/config/Config.php |
| 703 | /modules/psxmarketingwithgoogle/classes/Handler/RemarketingHookHandler.php |
| 704 | /modules/psxmarketingwithgoogle/classes/Buffer/TemplateBuffer.php |
| 705 | /modules/ps_googleanalytics/ps_googleanalytics.php |
| 706 | /modules/ps_googleanalytics/classes/Hook/HookDisplayHeader.php |
| 707 | /modules/ps_googleanalytics/classes/Hook/HookInterface.php |
| 708 | /modules/psshipping/psshipping.php |
| 709 | /src/Adapter/Localization/LegacyTranslator.php |
| 710 | /var/cache/dev/PsshippingFrontContainer.php |
| 711 | /modules/psshipping/src/Hooks/HookDisplayHeader.php |
| 712 | /modules/psshipping/src/Domain/GelProximity/GelProximityService.php |
| 713 | /modules/psshipping/src/Domain/Carriers/CarrierRepository.php |
| 714 | /src/Adapter/ContainerFinder.php |
| 715 | /vendor/doctrine/dbal/src/Logging/LoggerChain.php |
| 716 | /vendor/doctrine/dbal/src/Logging/SQLLogger.php |
| 717 | /vendor/symfony/doctrine-bridge/Logger/DbalLogger.php |
| 718 | /vendor/doctrine/dbal/src/Logging/DebugStack.php |
| 719 | /vendor/doctrine/doctrine-bundle/ConnectionFactory.php |
| 720 | /src/PrestaShopBundle/DependencyInjection/RuntimeConstEnvVarProcessor.php |
| 721 | /vendor/symfony/dependency-injection/EnvVarProcessorInterface.php |
| 722 | /vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php |
| 723 | /vendor/doctrine/event-manager/src/EventManager.php |
| 724 | /vendor/doctrine/dbal/src/DriverManager.php |
| 725 | /vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php |
| 726 | /vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php |
| 727 | /vendor/doctrine/dbal/src/VersionAwarePlatformDriver.php |
| 728 | /vendor/doctrine/dbal/src/Driver.php |
| 729 | /src/PrestaShopBundle/Doctrine/DatabaseConnection.php |
| 730 | /vendor/doctrine/dbal/src/Connection.php |
| 731 | /vendor/doctrine/dbal/src/ArrayParameterType.php |
| 732 | /vendor/doctrine/dbal/src/ParameterType.php |
| 733 | /vendor/doctrine/dbal/src/Query/Expression/ExpressionBuilder.php |
| 734 | /vendor/doctrine/dbal/src/Schema/LegacySchemaManagerFactory.php |
| 735 | /vendor/doctrine/dbal/src/Schema/SchemaManagerFactory.php |
| 736 | /vendor/doctrine/dbal/src/Driver/PDO/Connection.php |
| 737 | /vendor/doctrine/dbal/src/Driver/ServerInfoAwareConnection.php |
| 738 | /vendor/doctrine/dbal/src/Driver/Connection.php |
| 739 | /vendor/doctrine/dbal/src/Events.php |
| 740 | /vendor/doctrine/dbal/src/Platforms/MariaDb1060Platform.php |
| 741 | /vendor/doctrine/dbal/src/Platforms/MariaDb1052Platform.php |
| 742 | /vendor/doctrine/dbal/src/Platforms/MariaDb1043Platform.php |
| 743 | /vendor/doctrine/dbal/src/Platforms/MariaDb1027Platform.php |
| 744 | /vendor/doctrine/dbal/src/Platforms/MariaDBPlatform.php |
| 745 | /vendor/doctrine/dbal/src/Platforms/MySQLPlatform.php |
| 746 | /vendor/doctrine/dbal/src/Platforms/AbstractMySQLPlatform.php |
| 747 | /vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php |
| 748 | /vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php |
| 749 | /vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php |
| 750 | /vendor/doctrine/dbal/src/Types/Types.php |
| 751 | /vendor/doctrine/dbal/src/Types/Type.php |
| 752 | /vendor/doctrine/dbal/src/Types/ArrayType.php |
| 753 | /vendor/doctrine/dbal/src/Types/AsciiStringType.php |
| 754 | /vendor/doctrine/dbal/src/Types/StringType.php |
| 755 | /vendor/doctrine/dbal/src/Types/BigIntType.php |
| 756 | /vendor/doctrine/dbal/src/Types/PhpIntegerMappingType.php |
| 757 | /vendor/doctrine/dbal/src/Types/BinaryType.php |
| 758 | /vendor/doctrine/dbal/src/Types/BlobType.php |
| 759 | /vendor/doctrine/dbal/src/Types/BooleanType.php |
| 760 | /vendor/doctrine/dbal/src/Types/DateType.php |
| 761 | /vendor/doctrine/dbal/src/Types/DateImmutableType.php |
| 762 | /vendor/doctrine/dbal/src/Types/DateIntervalType.php |
| 763 | /vendor/doctrine/dbal/src/Types/DateTimeType.php |
| 764 | /vendor/doctrine/dbal/src/Types/PhpDateTimeMappingType.php |
| 765 | /vendor/doctrine/dbal/src/Types/DateTimeImmutableType.php |
| 766 | /vendor/doctrine/dbal/src/Types/DateTimeTzType.php |
| 767 | /vendor/doctrine/dbal/src/Types/DateTimeTzImmutableType.php |
| 768 | /vendor/doctrine/dbal/src/Types/DecimalType.php |
| 769 | /vendor/doctrine/dbal/src/Types/FloatType.php |
| 770 | /vendor/doctrine/dbal/src/Types/GuidType.php |
| 771 | /vendor/doctrine/dbal/src/Types/IntegerType.php |
| 772 | /vendor/doctrine/dbal/src/Types/JsonType.php |
| 773 | /vendor/doctrine/dbal/src/Types/ObjectType.php |
| 774 | /vendor/doctrine/dbal/src/Types/SimpleArrayType.php |
| 775 | /vendor/doctrine/dbal/src/Types/SmallIntType.php |
| 776 | /vendor/doctrine/dbal/src/Types/TextType.php |
| 777 | /vendor/doctrine/dbal/src/Types/TimeType.php |
| 778 | /vendor/doctrine/dbal/src/Types/TimeImmutableType.php |
| 779 | /vendor/doctrine/dbal/src/Types/TypeRegistry.php |
| 780 | /src/Core/Product/Search/ProductSearchQuery.php |
| 781 | /src/Core/Product/Search/SortOrder.php |
| 782 | /modules/ps_facetedsearch/ps_facetedsearch.php |
| 783 | /modules/ps_facetedsearch/src/HookDispatcher.php |
| 784 | /modules/ps_facetedsearch/src/Hook/Attribute.php |
| 785 | /modules/ps_facetedsearch/src/Hook/AbstractHook.php |
| 786 | /modules/ps_facetedsearch/src/Hook/AttributeGroup.php |
| 787 | /modules/ps_facetedsearch/src/Hook/Category.php |
| 788 | /modules/ps_facetedsearch/src/Hook/Configuration.php |
| 789 | /modules/ps_facetedsearch/src/Hook/Design.php |
| 790 | /modules/ps_facetedsearch/src/Hook/Feature.php |
| 791 | /modules/ps_facetedsearch/src/Form/Feature/FormModifier.php |
| 792 | /modules/ps_facetedsearch/src/Form/Feature/FormDataProvider.php |
| 793 | /modules/ps_facetedsearch/src/Hook/FeatureValue.php |
| 794 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormModifier.php |
| 795 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormDataProvider.php |
| 796 | /modules/ps_facetedsearch/src/Hook/Product.php |
| 797 | /modules/ps_facetedsearch/src/Hook/ProductSearch.php |
| 798 | /modules/ps_facetedsearch/src/Hook/SpecificPrice.php |
| 799 | /modules/ps_facetedsearch/src/Filters/Provider.php |
| 800 | /modules/ps_facetedsearch/src/URLSerializer.php |
| 801 | /modules/ps_facetedsearch/src/Filters/DataAccessor.php |
| 802 | /modules/ps_facetedsearch/src/Product/SearchProvider.php |
| 803 | /src/Core/Product/Search/FacetsRendererInterface.php |
| 804 | /src/Core/Product/Search/ProductSearchProviderInterface.php |
| 805 | /modules/ps_facetedsearch/src/Filters/Converter.php |
| 806 | /modules/ps_facetedsearch/src/Product/SearchFactory.php |
| 807 | /src/Core/Product/Search/ProductSearchResult.php |
| 808 | /classes/Combination.php |
| 809 | /modules/ps_facetedsearch/src/Product/Search.php |
| 810 | /modules/ps_facetedsearch/src/Adapter/MySQL.php |
| 811 | /modules/ps_facetedsearch/src/Adapter/AbstractAdapter.php |
| 812 | /modules/ps_facetedsearch/src/Adapter/InterfaceAdapter.php |
| 813 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ArrayCollection.php |
| 814 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Collection.php |
| 815 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ReadableCollection.php |
| 816 | /modules/ps_facetedsearch/src/Filters/Products.php |
| 817 | /classes/stock/StockAvailable.php |
| 818 | /modules/ps_facetedsearch/src/Filters/Block.php |
| 819 | /modules/ps_facetedsearch/src/Definition/Availability.php |
| 820 | /classes/Manufacturer.php |
| 821 | /src/Core/Util/String/StringModifier.php |
| 822 | /src/Core/Util/String/StringModifierInterface.php |
| 823 | /src/Core/Product/Search/Facet.php |
| 824 | /src/Core/Product/Search/Filter.php |
| 825 | /vendor/prestashop/decimal/src/DecimalNumber.php |
| 826 | /vendor/prestashop/decimal/src/Builder.php |
| 827 | /src/Core/Product/Search/FacetCollection.php |
| 828 | /classes/Pack.php |
| 829 | /src/Core/Localization/CLDR/ComputingPrecision.php |
| 830 | /src/Core/Localization/CLDR/ComputingPrecisionInterface.php |
| 831 | /classes/SpecificPrice.php |
| 832 | /classes/tax/TaxManagerFactory.php |
| 833 | /classes/tax/TaxRulesTaxManager.php |
| 834 | /classes/tax/TaxManagerInterface.php |
| 835 | /classes/tax/TaxCalculator.php |
| 836 | /classes/GroupReduction.php |
| 837 | /classes/order/Order.php |
| 838 | /classes/tax/Tax.php |
| 839 | /src/Core/Domain/Combination/CombinationSettings.php |
| 840 | /classes/ProductPresenterFactory.php |
| 841 | /src/Adapter/Presenter/Product/ProductListingPresenter.php |
| 842 | /src/Adapter/Presenter/Product/ProductPresenter.php |
| 843 | /src/Adapter/Product/ProductColorsRetriever.php |
| 844 | /src/Core/Product/ProductPresentationSettings.php |
| 845 | /src/Adapter/Presenter/Product/ProductListingLazyArray.php |
| 846 | /src/Adapter/Presenter/Product/ProductLazyArray.php |
| 847 | /classes/Image.php |
| 848 | /src/Core/Image/ImageFormatConfiguration.php |
| 849 | /src/Core/Image/ImageFormatConfigurationInterface.php |
| 850 | /classes/Smarty/SmartyDevTemplate.php |
| 851 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php |
| 852 | /var/cache/dev/smarty/compile/classic/d4/1d/65/d41d65d76b9471b5d365fe06cf1737c89a53af9f_2.module.ps_facetedsearchviewstemplatesfrontcatalogfacets.tpl.php |
| 853 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php |
| 854 | /vendor/smarty/smarty/libs/plugins/modifier.count.php |
| 855 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php |
| 856 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php |
| 857 | /var/cache/dev/smarty/compile/classic/2e/80/73/2e807335546cfa2360c36327ac89dd2fcb054379_2.module.ps_facetedsearchviewstemplatesfrontcatalogactivefilters.tpl.php |
| 858 | /src/Core/Product/Search/Pagination.php |
| 859 | /vendor/defuse/php-encryption/src/Crypto.php |
| 860 | /vendor/defuse/php-encryption/src/KeyOrPassword.php |
| 861 | /vendor/defuse/php-encryption/src/RuntimeTests.php |
| 862 | /vendor/defuse/php-encryption/src/DerivedKeys.php |
| 863 | /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php |
| 864 | /vendor/defuse/php-encryption/src/Exception/CryptoException.php |
| 865 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/8e/b2/cc/8eb2cc90b2c651043826b31b4477f40e611cc443_2.file.category.tpl.php |
| 866 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f1/69/67/f1696736d087a74bdf30094c27eb15cca29ef74a_2.file.product-list.tpl.php |
| 867 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/86/63/a786630fe18adda635b0597d73de5dd80576a9e2_2.file.layout-left-column.tpl.php |
| 868 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/b1/ec/27/b1ec27588d0dd6952faca8ce73463a8f4cb6154a_2.file.layout-both-columns.tpl.php |
| 869 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/77/0e/fd/770efd8572d66c8eb84f5d51dbb7ef86dbc59096_2.file.helpers.tpl.php |
| 870 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_tplfunction.php |
| 871 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/1b/d1/68/1bd168dcc2d49a8ac9914fe70d6f5cb034aa5b59_2.file.head.tpl.php |
| 872 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/76/f2/4c/76f24cd96294b1dea0750fb69dd59e416c4c9411_2.file.head-jsonld.tpl.php |
| 873 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/d5/1d/d7/d51dd715fbefa85627502a9aa93c93dbf89d40a1_2.file.product-list-jsonld.tpl.php |
| 874 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ed/c2/16/edc21651e04088260ce7b34455760e4dae138bfb_2.file.pagination-seo.tpl.php |
| 875 | /vendor/smarty/smarty/libs/plugins/modifier.replace.php |
| 876 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/61/61/74/616174a88cbcfe1e34fe302ba81d3ac168b1adeb_2.file.stylesheets.tpl.php |
| 877 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/49/01/c0/4901c05391888802a20719abe3066e65d715b3f1_2.file.javascript.tpl.php |
| 878 | /classes/ProductDownload.php |
| 879 | /src/Core/Cart/Calculator.php |
| 880 | /src/Core/Cart/CartRowCollection.php |
| 881 | /src/Core/Cart/Fees.php |
| 882 | /src/Core/Cart/AmountImmutable.php |
| 883 | /src/Core/Cart/CartRuleCollection.php |
| 884 | /src/Core/Cart/CartRuleCalculator.php |
| 885 | /src/Adapter/Product/PriceCalculator.php |
| 886 | /src/Core/Cart/CartRow.php |
| 887 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/3a/ea/fd/3aeafd5556e84761d3b077ce1f352751b3881676_2.file.product-activation.tpl.php |
| 888 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a2/d0/37/a2d037e6eecc5cac115de075e5f82abde9a781e3_2.file.header.tpl.php |
| 889 | /modules/ps_contactinfo/ps_contactinfo.php |
| 890 | /var/cache/dev/smarty/compile/classic/0e/b2/11/0eb2119957cbc13b240126b3ccd8fac8f109f1e2_2.module.ps_contactinfonav.tpl.php |
| 891 | /modules/ps_languageselector/ps_languageselector.php |
| 892 | /var/cache/dev/smarty/compile/classic/1c/00/f7/1c00f78dace25d509ec3a1f54176b7ae2000accf_2.module.ps_languageselectorps_languageselector.tpl.php |
| 893 | /modules/ps_currencyselector/ps_currencyselector.php |
| 894 | /var/cache/dev/smarty/compile/classic/b9/77/56/b97756c07f8c7dd53da6530f78f67ddd242f77c9_2.module.ps_currencyselectorps_currencyselector.tpl.php |
| 895 | /modules/ps_customersignin/ps_customersignin.php |
| 896 | /var/cache/dev/smarty/compile/classic/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.ps_customersigninps_customersignin.tpl.php |
| 897 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php |
| 898 | /var/cache/dev/smarty/compile/classic/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.ps_shoppingcartps_shoppingcart.tpl.php |
| 899 | /modules/ps_mainmenu/ps_mainmenu.php |
| 900 | /modules/ps_mainmenu/ps_menutoplinks.class.php |
| 901 | /var/cache/dev/smarty/compile/classic/41/df/19/41df1985130dffd7d3fe4cb369091546a0b40be7_2.module.ps_mainmenups_mainmenu.tpl.php |
| 902 | /var/cache/dev/smarty/compile/classic/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.ps_searchbarps_searchbar.tpl.php |
| 903 | /modules/pagesnotfound/pagesnotfound.php |
| 904 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/eb/97/dc/eb97dcc089cf98b4bf102e167b6cc4cbf8e1315b_2.file.notifications.tpl.php |
| 905 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/5c/3e/85/5c3e857c83024775d10eac19daf6cbbedd5982cd_2.file.breadcrumb.tpl.php |
| 906 | /modules/ps_categorytree/ps_categorytree.php |
| 907 | /var/cache/dev/smarty/compile/classic/89/21/00/8921007f54626fc7fe42cbff53f1d70828d3393d_2.module.ps_categorytreeviewstemplateshookps_categorytree.tpl.php |
| 908 | /modules/ps_supplierlist/ps_supplierlist.php |
| 909 | /modules/ps_brandlist/ps_brandlist.php |
| 910 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php |
| 911 | /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php |
| 912 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php |
| 913 | /var/cache/dev/smarty/cache/ps_brandlist/1/1/1/1/2/8/classic/fe/40/1f/fe401fee3c288deef9e07f1a75155804891f7730.ps_brandlistviewstemplateshookps_brandlist.tpl.php |
| 914 | /var/cache/dev/smarty/compile/classic/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.ps_facetedsearchps_facetedsearch.tpl.php |
| 915 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/d3/cd/aa/d3cdaafea9b124c5cea4ed6814f095e1d18d8475_2.file.category-header.tpl.php |
| 916 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/63/63/fd/6363fd6da903026992f42b160ddfae21f144395a_2.file.products-top.tpl.php |
| 917 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6c/81/14/6c8114c3ae697d1485f2449f2c332debc3e85b9c_2.file.sort-orders.tpl.php |
| 918 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/46/e4/c5/46e4c509e88f64324bab7d72c4a0cc749f7c1243_2.file.products.tpl.php |
| 919 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/00/39/1f/00391ff7e96203e36653e472c592eb5632729fed_2.file.productlist.tpl.php |
| 920 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_capture.php |
| 921 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4b/e3/5d/4be35dc32f421ed8ac8970ab865218c2905be26f_2.file.product.tpl.php |
| 922 | /modules/productcomments/src/Repository/ProductCommentRepository.php |
| 923 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepository.php |
| 924 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepositoryInterface.php |
| 925 | /vendor/doctrine/doctrine-bundle/Registry.php |
| 926 | /vendor/symfony/doctrine-bridge/ManagerRegistry.php |
| 927 | /vendor/doctrine/persistence/src/Persistence/AbstractManagerRegistry.php |
| 928 | /vendor/doctrine/persistence/src/Persistence/ManagerRegistry.php |
| 929 | /vendor/doctrine/persistence/src/Persistence/ConnectionRegistry.php |
| 930 | /modules/productcomments/src/Entity/ProductComment.php |
| 931 | /vendor/doctrine/orm/src/Proxy/Proxy.php |
| 932 | /vendor/doctrine/common/src/Proxy/Proxy.php |
| 933 | /vendor/doctrine/persistence/src/Persistence/Proxy.php |
| 934 | /vendor/doctrine/orm/src/Proxy/InternalProxy.php |
| 935 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriverChain.php |
| 936 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/ImplicitlyIgnoredAnnotationNames.php |
| 937 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/IgnoreAnnotation.php |
| 938 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/PhpParser.php |
| 939 | /src/PrestaShopBundle/Service/Database/DoctrineNamingStrategy.php |
| 940 | /vendor/doctrine/orm/src/Mapping/UnderscoreNamingStrategy.php |
| 941 | /vendor/doctrine/orm/src/Mapping/NamingStrategy.php |
| 942 | /vendor/doctrine/orm/src/Mapping/DefaultQuoteStrategy.php |
| 943 | /vendor/doctrine/orm/src/Internal/SQLResultCasing.php |
| 944 | /vendor/doctrine/orm/src/Mapping/QuoteStrategy.php |
| 945 | /vendor/doctrine/doctrine-bundle/Mapping/ContainerEntityListenerResolver.php |
| 946 | /vendor/doctrine/doctrine-bundle/Mapping/EntityListenerServiceResolver.php |
| 947 | /vendor/doctrine/orm/src/Mapping/EntityListenerResolver.php |
| 948 | /vendor/doctrine/doctrine-bundle/Repository/ContainerRepositoryFactory.php |
| 949 | /vendor/doctrine/orm/src/Repository/RepositoryFactory.php |
| 950 | /vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php |
| 951 | /vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php |
| 952 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadataFactory.php |
| 953 | /vendor/doctrine/orm/src/Mapping/ClassMetadata.php |
| 954 | /vendor/doctrine/orm/src/Mapping/ClassMetadataInfo.php |
| 955 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadata.php |
| 956 | /vendor/doctrine/orm/src/Proxy/DefaultProxyClassNameResolver.php |
| 957 | /vendor/doctrine/persistence/src/Persistence/Mapping/ProxyClassNameResolver.php |
| 958 | /vendor/doctrine/orm/src/UnitOfWork.php |
| 959 | /vendor/doctrine/persistence/src/Persistence/PropertyChangedListener.php |
| 960 | /vendor/doctrine/orm/src/Event/ListenersInvoker.php |
| 961 | /vendor/doctrine/orm/src/Utility/IdentifierFlattener.php |
| 962 | /vendor/doctrine/orm/src/Internal/HydrationCompleteHandler.php |
| 963 | /vendor/doctrine/orm/src/Mapping/Reflection/ReflectionPropertiesGetter.php |
| 964 | /vendor/doctrine/persistence/src/Persistence/Mapping/RuntimeReflectionService.php |
| 965 | /vendor/doctrine/persistence/src/Persistence/Mapping/ReflectionService.php |
| 966 | /vendor/doctrine/orm/src/Proxy/ProxyFactory.php |
| 967 | /vendor/doctrine/common/src/Proxy/AbstractProxyFactory.php |
| 968 | /vendor/doctrine/common/src/Proxy/ProxyGenerator.php |
| 969 | /vendor/doctrine/doctrine-bundle/ManagerConfigurator.php |
| 970 | /vendor/doctrine/lexer/src/Token.php |
| 971 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php |
| 972 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/TokenParser.php |
| 973 | /vendor/doctrine/orm/src/Mapping/Table.php |
| 974 | /vendor/doctrine/orm/src/Mapping/MappingAttribute.php |
| 975 | /vendor/doctrine/orm/src/Mapping/Annotation.php |
| 976 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Enum.php |
| 977 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attribute.php |
| 978 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attributes.php |
| 979 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/NamedArgumentConstructor.php |
| 980 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/NamedArgumentConstructorAnnotation.php |
| 981 | /vendor/doctrine/orm/src/Mapping/Entity.php |
| 982 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/Instantiator.php |
| 983 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/InstantiatorInterface.php |
| 984 | /vendor/doctrine/orm/src/Mapping/DefaultTypedFieldMapper.php |
| 985 | /vendor/doctrine/orm/src/Mapping/TypedFieldMapper.php |
| 986 | /vendor/doctrine/orm/src/Mapping/Id.php |
| 987 | /vendor/doctrine/orm/src/Mapping/Column.php |
| 988 | /vendor/doctrine/orm/src/Mapping/GeneratedValue.php |
| 989 | /vendor/doctrine/orm/src/Id/IdentityGenerator.php |
| 990 | /vendor/doctrine/orm/src/Id/AbstractIdGenerator.php |
| 991 | /vendor/doctrine/orm/src/Events.php |
| 992 | /vendor/doctrine/persistence/src/Persistence/Reflection/RuntimeReflectionProperty.php |
| 993 | /vendor/doctrine/dbal/src/Query/QueryBuilder.php |
| 994 | /vendor/doctrine/dbal/src/Query/Expression/CompositeExpression.php |
| 995 | /vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php |
| 996 | /vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php |
| 997 | /vendor/doctrine/dbal/src/Query/SelectQuery.php |
| 998 | /vendor/doctrine/dbal/src/Query/Limit.php |
| 999 | /vendor/doctrine/dbal/src/SQL/Parser.php |
| 1000 | /vendor/doctrine/dbal/src/ExpandArrayParameters.php |
| 1001 | /vendor/doctrine/dbal/src/SQL/Parser/Visitor.php |
| 1002 | /vendor/doctrine/dbal/src/Driver/PDO/Statement.php |
| 1003 | /vendor/doctrine/dbal/src/Driver/Statement.php |
| 1004 | /vendor/doctrine/dbal/src/Driver/PDO/ParameterTypeMap.php |
| 1005 | /vendor/doctrine/dbal/src/Driver/PDO/Result.php |
| 1006 | /vendor/doctrine/dbal/src/Driver/Result.php |
| 1007 | /vendor/doctrine/dbal/src/Result.php |
| 1008 | /vendor/doctrine/dbal/src/FetchMode.php |
| 1009 | /var/cache/dev/smarty/compile/classic/e9/e4/d0/e9e4d0b935584380ea8beb3f467908e1cd2486f5_2.module.productcommentsviewstemplateshookproductlistreviews.tpl.php |
| 1010 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4c/b3/14/4cb314080e1b252ca30f8d1075dfb365e197281e_2.file.product-flags.tpl.php |
| 1011 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/c3/fd/adc3fd8ac679df11ef5518b9efb653d219fa4e8d_2.file.pagination.tpl.php |
| 1012 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/84/cd/59/84cd594f84a611dfe1edf515a4b66731d5cb9767_2.file.products-bottom.tpl.php |
| 1013 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e6/61/1e/e6611ea36bea632bd095134ac92d22b3d2a9bda9_2.file.category-footer.tpl.php |
| 1014 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/6a/3a/63/6a3a63a250822a139041e3f6c6569ef1bace3a2d_2.file.footer.tpl.php |
| 1015 | /var/cache/dev/smarty/compile/classic/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef_2.module.ps_emailsubscriptionviewstemplateshookps_emailsubscription.tpl.php |
| 1016 | /var/cache/dev/smarty/cache/ps_socialfollow/1/1/1/1/2/8/classic/b5/d7/32/b5d732c48019c29e0a52638446d1cac8f2fc79c0.ps_socialfollowps_socialfollow.tpl.php |
| 1017 | /modules/ps_linklist/ps_linklist.php |
| 1018 | /var/cache/dev/translations/catalogue.fr-FR.NXhscRe.php |
| 1019 | /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php |
| 1020 | /modules/ps_linklist/src/Filter/LinkFilter.php |
| 1021 | /modules/ps_linklist/src/Filter/BestSalesRouteFilter.php |
| 1022 | /modules/ps_linklist/src/Filter/RouteFilterInterface.php |
| 1023 | /modules/ps_linklist/src/LegacyLinkBlockRepository.php |
| 1024 | /var/cache/dev/smarty/cache/ps_linklist/displayFooter/1/1/1/1/2/8/classic/6c/35/8b/6c358bea6802140a8a53537d806059f2690d65aa.ps_linklistviewstemplateshooklinkblock.tpl.php |
| 1025 | /modules/ps_customeraccountlinks/ps_customeraccountlinks.php |
| 1026 | /var/cache/dev/smarty/cache/ps_customeraccountlinks/1/1/1/1/2/8/classic/de/6d/62/de6d62704f82d562de48fe67ba834691c50ae647.ps_customeraccountlinksps_customeraccountlinks.tpl.php |
| 1027 | /var/cache/dev/smarty/compile/classic/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d_2.module.ps_contactinfops_contactinfo.tpl.php |
| 1028 | /vendor/smarty/smarty/libs/plugins/function.mailto.php |
| 1029 | /var/cache/dev/smarty/compile/classic/53/1f/f5/531ff5fadbab34ae9adf28c596f08da4ca8fffe0_2.module.blockwishlistviewstemplateshookdisplayHeader.tpl.php |
| 1030 | /var/cache/dev/smarty/compile/classic/b3/9f/fe/b39ffe0e9a6e5e655319605fb4fac018757bed47_2.module.blockwishlistviewstemplatescomponentsmodalsaddtowishlist.tpl.php |
| 1031 | /var/cache/dev/smarty/compile/classic/f9/93/73/f9937302c902c18a7e92f61a7bb91ac32c58d2fe_2.module.blockwishlistviewstemplatescomponentsmodalsdelete.tpl.php |
| 1032 | /var/cache/dev/smarty/compile/classic/d8/d0/86/d8d086f3098974d41bc92b06c33cf9e584313501_2.module.blockwishlistviewstemplatescomponentsmodalscreate.tpl.php |
| 1033 | /var/cache/dev/smarty/compile/classic/99/ff/6f/99ff6f99ecd074931a71deddfe65081482db8401_2.module.blockwishlistviewstemplatescomponentsmodalslogin.tpl.php |
| 1034 | /var/cache/dev/smarty/compile/classic/a6/cf/26/a6cf26c62a3d814aa3a70f19a62034bfdce54c8a_2.module.blockwishlistviewstemplatescomponentstoast.tpl.php |
| 1035 | /modules/ps_facebook/classes/Handler/MessengerHandler.php |
| 1036 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/d2/94/fd/d294fded05805275d2eded4e10335c6be0b76552_2.file.password-policy-template.tpl.php |
| 1037 | /modules/statsdata/statsdata.php |
| 1038 | /classes/Guest.php |
| 1039 | /classes/Connection.php |
| 1040 | /classes/Page.php |
| 1041 | /classes/ConnectionsSource.php |
| 1042 | /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php |
| 1043 | /modules/ps_googleanalytics/classes/Handler/GanalyticsJsHandler.php |
| 1044 | /modules/ps_googleanalytics/classes/Handler/GanalyticsDataHandler.php |
| 1045 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php |
| 1046 | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php |
| 1047 | /modules/ps_googleanalytics/classes/GoogleAnalyticsTools.php |
