Art
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
Active filters
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
Active filters
| Load Time | 455.391 ms |
| Querying Time | 58 ms |
| Queries | 225 |
| Memory Peak Usage | 48.5 Mb |
| Included Files | 1061 files - 12.79 Mb |
| PrestaShop Cache | - Mb |
| Global vars | 0.14 Mb |
| PrestaShop Version | 9.0.3 |
| PHP Version | 8.4.18 |
| MySQL Version | 10.11.15-MariaDB-log |
| Memory Limit | -1 |
| Max Execution Time | 50000s |
| Smarty Cache | enabled |
| Smarty Compilation | never recompile |
| Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
|---|---|---|---|---|
| config | 175.865 ms | 175.865 ms | 22.89 Mb | 23.9 Mb |
| __construct | 0.068 ms | 175.933 ms | - Mb | 23.9 Mb |
| init | 29.647 ms | 205.580 ms | 3.26 Mb | 26.2 Mb |
| checkAccess | 0.002 ms | 205.582 ms | - Mb | 26.2 Mb |
| setMedia | 34.564 ms | 240.146 ms | 3.67 Mb | 29.9 Mb |
| postProcess | 0.002 ms | 240.148 ms | - Mb | 29.9 Mb |
| initHeader | 0.003 ms | 240.151 ms | - Mb | 29.9 Mb |
| initContent | 131.033 ms | 371.184 ms | 9.73 Mb | 39.6 Mb |
| initFooter | 0.003 ms | 371.187 ms | - Mb | 39.6 Mb |
| display | 84.204 ms | 455.391 ms | 8.07 Mb | 48.5 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| DisplayHeader | 30.768 ms | 3.97 Mb |
| displayProductListReviews | 26.246 ms | 2.03 Mb |
| ActionFrontControllerSetMedia | 25.044 ms | 2.67 Mb |
| displayLeftColumn | 5.043 ms | 0.33 Mb |
| DisplayBeforeBodyClosingTag | 4.689 ms | 0.36 Mb |
| displayNav2 | 4.623 ms | 0.36 Mb |
| displayFooter | 2.374 ms | 0.20 Mb |
| ProductSearchProvider | 2.067 ms | 0.16 Mb |
| displayTop | 1.729 ms | 0.13 Mb |
| displayNav1 | 1.630 ms | 0.07 Mb |
| DisplayFooter | 1.499 ms | 0.12 Mb |
| displayFooterBefore | 1.441 ms | 0.11 Mb |
| DisplayLeftColumn | 0.220 ms | 0.01 Mb |
| DisplayTop | 0.052 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.007 ms | - Mb |
| DisplayNavFullWidth | 0.006 ms | - Mb |
| DisplayFooterBefore | 0.006 ms | - Mb |
| DisplayFooterAfter | 0.006 ms | - Mb |
| ModuleRoutes | 0.004 ms | - Mb |
| 19 hook(s) | 107.453 ms | 10.53 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| ps_checkout | 38.475 ms | 5.68 Mb |
| blockreassurance | 1.846 ms | 0.22 Mb |
| blockwishlist | 1.915 ms | 0.18 Mb |
| ps_emailsubscription | 2.689 ms | 0.34 Mb |
| ps_socialfollow | 1.285 ms | 0.12 Mb |
| ps_facebook | 13.036 ms | 1.16 Mb |
| ps_emailalerts | 2.207 ms | 0.24 Mb |
| ps_accounts | 1.498 ms | 0.20 Mb |
| ps_shoppingcart | 1.633 ms | 0.13 Mb |
| ps_searchbar | 1.357 ms | 0.08 Mb |
| ps_imageslider | 1.992 ms | 0.21 Mb |
| productcomments | 27.850 ms | 2.22 Mb |
| psshipping | 17.960 ms | 1.81 Mb |
| ps_googleanalytics | 3.106 ms | 0.33 Mb |
| psxmarketingwithgoogle | 3.008 ms | 1.40 Mb |
| ps_facetedsearch | 6.201 ms | 0.62 Mb |
| ps_contactinfo | 2.921 ms | 0.17 Mb |
| ps_languageselector | 1.291 ms | 0.09 Mb |
| ps_currencyselector | 2.090 ms | 0.18 Mb |
| ps_customersignin | 0.887 ms | 0.08 Mb |
| ps_mainmenu | 3.220 ms | 0.34 Mb |
| pagesnotfound | 0.450 ms | 0.05 Mb |
| ps_categorytree | 3.692 ms | 0.25 Mb |
| ps_supplierlist | 0.819 ms | 0.08 Mb |
| ps_brandlist | 1.888 ms | 0.15 Mb |
| ps_linklist | 8.332 ms | 1.93 Mb |
| ps_customeraccountlinks | 0.924 ms | 0.10 Mb |
| statsdata | 2.655 ms | 0.14 Mb |
| 28 module(s) | 155.226 ms | 18.49 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 137 | 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 `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_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 `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 5 AND pac.`id_product_attribute` = 20 AND agl.`id_lang` = 1 |
3.352 ms | 1 | /classes/Product.php:7216 | ||
| 103 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `dfdu_hook_alias` ha INNER JOIN `dfdu_hook` h ON ha.name = h.name |
1.568 ms | 0 | /classes/Hook.php:1568 | ||
| 84 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20))) GROUP BY pac.id_attribute |
0.947 ms | 24 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 14 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `dfdu_module` m INNER JOIN dfdu_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1) INNER JOIN `dfdu_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `dfdu_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `dfdu_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` |
0.829 ms | 150 | Yes | Yes | /classes/Hook.php:1500 |
| 104 | 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 `dfdu_hook_module` hm STRAIGHT_JOIN `dfdu_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `dfdu_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
0.707 ms | 374 | /classes/Hook.php:495 | ||
| 82 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>15 AND c.nright<16 GROUP BY cp.id_category |
0.695 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 97 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20))) GROUP BY pac.id_attribute |
0.670 ms | 24 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (19, 20))) |
0.664 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 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 `dfdu_configuration` c LEFT JOIN `dfdu_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
0.639 ms | 510 | /classes/Configuration.php:182 | ||
| 72 | SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC |
0.632 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 92 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) GROUP BY p.condition |
0.630 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 87 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20))) GROUP BY fp.id_feature_value |
0.629 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 91 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) GROUP BY p.id_manufacturer |
0.622 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 116 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 14) LIMIT 1 |
0.613 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 89 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20))) GROUP BY fp.id_feature_value |
0.609 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 90 | SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `dfdu_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.607 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 78 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND p.date_add>'2026-02-21 00:00:00' |
0.588 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 79 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_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, 6) 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-03-12 14:01:50' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-03-12 14:01:50' <= sp.to)
) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20))) |
0.582 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 98 | REPLACE INTO dfdu_layered_filter_block (hash, data) VALUES ("bd6a3d311b9f6fcb0d063639d46c2058", "a:1:{s:7:\"filters\";a:9:{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:3:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:3;s:7:\"checked\";b:1;}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:0;}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:6;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:10:\"Matt paper\";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: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:3:{s:4:\"name\";s:14:\"Graphic Corner\";s:3:\"nbr\";i:3;s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;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:7;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:8;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:3;s:4:\"name\";s:9:\"Dimension\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:3:{i:19;a:5:{s:4:\"name\";s:7:\"40x60cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:20;a:5:{s:4:\"name\";s:7:\"60x90cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:21;a:4:{s:4:\"name\";s:8:\"80x120cm\";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.574 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:209 | ||
| 95 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_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 ((a.id_attribute_group=3)) AND ((sa_1.quantity>0)) GROUP BY pac.id_attribute |
0.572 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 86 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20))) GROUP BY pac.id_attribute |
0.571 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 175 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `dfdu_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `dfdu_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.551 ms | 9 | Yes | Yes | /classes/Category.php:815 |
| 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) |
0.545 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 218 | INSERT INTO `dfdu_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('4147', '', 'izzywine.com/en/9-art?q=Availability-In+stock%2FBrand-Graphic+Corner%2FDimension-40x60cm-60x90cm', '', '2026-03-12 14:01:50') |
0.537 ms | 1 | /classes/ObjectModel.php:535 | ||
| 77 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((p.on_sale=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (19, 20))) |
0.518 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 114 | 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 `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_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 `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 3 AND pac.`id_product_attribute` = 14 AND agl.`id_lang` = 1 |
0.516 ms | 1 | /classes/Product.php:7216 | ||
| 76 | 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) |
0.509 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 179 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 15 AND c.`nright` >= 16 AND c.`nleft` >= 2 AND c.`nright` <= 17 ORDER BY `nleft` DESC |
0.503 ms | 2 | Yes | /classes/Category.php:1617 | |
| 39 | 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 `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `dfdu_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 9 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.469 ms | 1 | Yes | Yes | /classes/Category.php:946 |
| 13 | SELECT SQL_NO_CACHE lower(name) as name FROM `dfdu_hook` h WHERE (h.active = 1) |
0.442 ms | 1186 | /classes/Hook.php:1608 | ||
| 16 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` |
0.427 ms | 1186 | /classes/Hook.php:1568 | ||
| 80 | SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM dfdu_product p INNER JOIN dfdu_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 = 6) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 |
0.427 ms | 1 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 68 | SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `dfdu_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.419 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 99 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-03-12 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM dfdu_product p LEFT JOIN dfdu_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN dfdu_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN dfdu_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (3,4,5) |
0.405 ms | 3 | /classes/ProductAssembler.php:101 | ||
| 133 | 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 `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_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` = 5 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.391 ms | 0 | /classes/Cart.php:1450 | ||
| 93 | SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM dfdu_product p INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (19, 20))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 |
0.384 ms | 3 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 170 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.381 ms | 1 | /classes/module/Module.php:2781 | ||
| 88 | 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 `dfdu_feature_value` v LEFT JOIN `dfdu_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `dfdu_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.347 ms | 10 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 85 | 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 `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_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 dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_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.337 ms | 25 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 19 | SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `dfdu_meta` m LEFT JOIN `dfdu_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.336 ms | 43 | Yes | /classes/Dispatcher.php:643 | |
| 94 | 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 `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_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 dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_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.336 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 184 | 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 `dfdu_product_attribute` pa INNER JOIN dfdu_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 `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (3) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.336 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 69 | 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 `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_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 dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_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.331 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 145 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4) AND (b.`id_shop` = 1) LIMIT 1 |
0.321 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 140 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3) AND (b.`id_shop` = 1) LIMIT 1 |
0.313 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 66 | 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 `dfdu_attribute_group` ag INNER JOIN dfdu_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 `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `dfdu_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.301 ms | 4 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 |
| 83 | 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 `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_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 dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_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.300 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 110 | 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 `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 3 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_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` = 3 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.300 ms | 0 | /classes/Cart.php:1450 | ||
| 17 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.294 ms | 75 | /classes/module/Module.php:343 | ||
| 112 | 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 `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 14 AND cp.`id_cart` = 0 AND cp.`id_product` = 3 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 14 AND cp.`id_cart` = 0 AND p.`id_product_item` = 3 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.290 ms | 0 | /classes/Cart.php:1450 | ||
| 187 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3) LIMIT 1 |
0.285 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 202 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) LIMIT 1 |
0.281 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 126 | 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 `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_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 `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 4 AND pac.`id_product_attribute` = 17 AND agl.`id_lang` = 1 |
0.275 ms | 1 | /classes/Product.php:7216 | ||
| 194 | 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 `dfdu_product_attribute` pa INNER JOIN dfdu_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 `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.275 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 96 | 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 `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_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 dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_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.274 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 201 | 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 `dfdu_product_attribute` pa INNER JOIN dfdu_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 `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (5) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.272 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 122 | 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 `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 4 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_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` = 4 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.270 ms | 0 | /classes/Cart.php:1450 | ||
| 148 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) AND (b.`id_shop` = 1) LIMIT 1 |
0.262 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 67 | SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `dfdu_feature` f INNER JOIN dfdu_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `dfdu_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `dfdu_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC |
0.260 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 | |
| 195 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4) LIMIT 1 |
0.257 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 220 | SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `dfdu_category_product` cp LEFT JOIN `dfdu_category` c ON (c.id_category = cp.id_category) LEFT JOIN `dfdu_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (3,4,5) AND cl.`id_lang` = 1 ORDER BY c.`level_depth` DESC |
0.250 ms | 6 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 | |
| 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 dfdu_shop_group gs LEFT JOIN dfdu_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN dfdu_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.250 ms | 1 | Yes | /classes/shop/Shop.php:716 | |
| 56 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a0 LEFT JOIN `dfdu_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 15) AND (a0.`nright` > 16) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.247 ms | 2 | Yes | /classes/PrestaShopCollection.php:381 | |
| 124 | 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 `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 17 AND cp.`id_cart` = 0 AND cp.`id_product` = 4 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 17 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.245 ms | 0 | /classes/Cart.php:1450 | ||
| 81 | SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_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.241 ms | 9 | Yes | /classes/Category.php:744 | |
| 65 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM dfdu_layered_category WHERE controller = 'category' AND id_category = 9 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.239 ms | 13 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:57 |
| 190 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_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` = 3 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.239 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 191 | 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 `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (13,14,15) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.237 ms | 3 | /classes/Product.php:2507 | ||
| 142 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 3 ORDER BY `position` |
0.233 ms | 1 | Yes | /classes/Product.php:3285 | |
| 20 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1 |
0.228 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 205 | 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 `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (19,20,21) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.227 ms | 3 | /classes/Product.php:2507 | ||
| 105 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 9
AND tr.`id_state` IN (0, 353)
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.225 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 0 | SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM dfdu_shop_url su LEFT JOIN dfdu_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'izzywine.com' OR su.domain_ssl = 'izzywine.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.224 ms | 1 | Yes | /classes/shop/Shop.php:1392 | |
| 11 | SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `dfdu_lang` l JOIN dfdu_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.224 ms | 1 | /classes/Language.php:1204 | ||
| 198 | 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 `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (16,17,18) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.224 ms | 3 | /classes/Product.php:2507 | ||
| 102 | 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 `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_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` = 3) |
0.221 ms | 3 | /classes/Product.php:3629 | ||
| 135 | 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 `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 20 AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 20 AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.221 ms | 0 | /classes/Cart.php:1450 | ||
| 204 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_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` = 5 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.220 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 42 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.219 ms | 75 | /classes/module/Module.php:343 | ||
| 44 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1 |
0.218 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 18 | SELECT SQL_NO_CACHE name, alias FROM `dfdu_hook_alias` |
0.217 ms | 86 | /classes/Hook.php:371 | ||
| 115 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
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.217 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 172 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.215 ms | 1 | /classes/module/Module.php:2781 | ||
| 127 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 17) LIMIT 1 |
0.214 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 188 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 3 AND `id_shop` = 1 |
0.212 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 197 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_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` = 4 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.211 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 10 | SELECT SQL_NO_CACHE domain, domain_ssl FROM dfdu_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.207 ms | 1 | /classes/shop/ShopUrl.php:178 | ||
| 176 | SELECT SQL_NO_CACHE DISTINCT c.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1) WHERE `level_depth` = 1 |
0.207 ms | 1 | /classes/Category.php:2247 | ||
| 143 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 3 AND il.`id_lang` = 1 ORDER by i.`position` |
0.206 ms | 1 | Yes | /classes/Product.php:2668 | |
| 160 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c INNER JOIN dfdu_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.204 ms | 1 | Yes | /classes/Currency.php:687 | |
| 151 | SELECT SQL_NO_CACHE 1 FROM dfdu_cart_product cp INNER JOIN dfdu_product p ON (p.id_product = cp.id_product) INNER JOIN dfdu_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.201 ms | 1 | /classes/Cart.php:4072 | ||
| 174 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `dfdu_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.195 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 217 | SELECT SQL_NO_CACHE `id_guest` FROM `dfdu_connections` WHERE `id_guest` = 4142 AND `date_add` > '2026-03-12 13:31:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.192 ms | 1 | Yes | /classes/Connection.php:168 | |
| 138 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 20) LIMIT 1 |
0.188 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 5 | SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `dfdu_lang` l LEFT JOIN `dfdu_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.186 ms | 1 | /classes/Language.php:1070 | ||
| 222 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 14 ORDER BY ag.`position` ASC, a.`position` ASC |
0.184 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 146 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 4 ORDER BY `position` |
0.184 ms | 1 | Yes | /classes/Product.php:3285 | |
| 15 | SELECT SQL_NO_CACHE `name`, `alias` FROM `dfdu_hook_alias` |
0.181 ms | 86 | /classes/Hook.php:319 | ||
| 70 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) LIMIT 1 |
0.181 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 149 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 5 ORDER BY `position` |
0.181 ms | 1 | Yes | /classes/Product.php:3285 | |
| 152 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_contactinfo" LIMIT 1 |
0.181 ms | 1 | /classes/module/Module.php:2781 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `dfdu_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.180 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 165 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.180 ms | 1 | /classes/module/Module.php:2781 | ||
| 6 | SELECT SQL_NO_CACHE * FROM `dfdu_country` a LEFT JOIN `dfdu_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2 LEFT JOIN `dfdu_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 6) LIMIT 1 |
0.179 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 64 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.178 ms | 1 | /classes/Category.php:2454 | ||
| 108 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 353)
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.178 ms | 0 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 57 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_facebook" LIMIT 1 |
0.177 ms | 1 | /classes/module/Module.php:2781 | ||
| 100 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 0 LIMIT 1 |
0.177 ms | 1 | /classes/SpecificPrice.php:433 | ||
| 119 | 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 `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_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` = 4) |
0.174 ms | 3 | /classes/Product.php:3629 | ||
| 150 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 5 AND il.`id_lang` = 1 ORDER by i.`position` |
0.172 ms | 1 | Yes | /classes/Product.php:2668 | |
| 223 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 17 ORDER BY ag.`position` ASC, a.`position` ASC |
0.171 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 8 | SELECT SQL_NO_CACHE * FROM `dfdu_lang` a LEFT JOIN `dfdu_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.169 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 21 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c ORDER BY `iso_code` ASC |
0.169 ms | 1 | Yes | /classes/Currency.php:708 | |
| 113 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_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` = 3 AND pa.`id_product` = 3 AND pa.`id_product_attribute` = 14 LIMIT 1 |
0.168 ms | 1 | /classes/Product.php:1180 | ||
| 45 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.165 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 22 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.163 ms | 1 | /classes/Language.php:870 | ||
| 134 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 20) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.163 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 224 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 20 ORDER BY ag.`position` ASC, a.`position` ASC |
0.163 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 43 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.160 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 111 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 14) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.160 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 203 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 5 AND `id_shop` = 1 |
0.160 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 125 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_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` = 4 AND pa.`id_product` = 4 AND pa.`id_product_attribute` = 17 LIMIT 1 |
0.159 ms | 1 | /classes/Product.php:1180 | ||
| 130 | 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 `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_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` = 5) |
0.158 ms | 3 | /classes/Product.php:3629 | ||
| 147 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 4 AND il.`id_lang` = 1 ORDER by i.`position` |
0.158 ms | 1 | Yes | /classes/Product.php:2668 | |
| 4 | SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM dfdu_shop s LEFT JOIN dfdu_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.157 ms | 1 | /classes/shop/Shop.php:215 | ||
| 196 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 4 AND `id_shop` = 1 |
0.155 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 34 | SELECT SQL_NO_CACHE * FROM `dfdu_group` a LEFT JOIN `dfdu_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.153 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 61 | SELECT SQL_NO_CACHE `id_configuration` FROM `dfdu_configuration` WHERE name = 'PS_ACCOUNTS_SHOP_STATUS' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1 |
0.153 ms | 1 | /classes/Configuration.php:135 | ||
| 180 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_supplierlist" LIMIT 1 |
0.153 ms | 1 | /classes/module/Module.php:2781 | ||
| 186 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.153 ms | 1 | /classes/module/Module.php:2270 | ||
| 161 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.151 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 185 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "productcomments" LIMIT 1 |
0.151 ms | 1 | /classes/module/Module.php:2781 | ||
| 192 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 13) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.151 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 212 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_linklist" LIMIT 1 |
0.150 ms | 1 | /classes/module/Module.php:2781 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `dfdu_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.150 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 132 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.150 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 136 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_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` = 5 AND pa.`id_product` = 5 AND pa.`id_product_attribute` = 20 LIMIT 1 |
0.150 ms | 1 | /classes/Product.php:1180 | ||
| 159 | SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `dfdu_currency` c LEFT JOIN dfdu_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.150 ms | 1 | /classes/Currency.php:1120 | ||
| 167 | SELECT SQL_NO_CACHE SUM(`quantity`) FROM `dfdu_cart_product` WHERE `id_cart` = 0 LIMIT 1 |
0.150 ms | 1 | /classes/Cart.php:1321 | ||
| 12 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `iso_code` = 'en' LIMIT 1 |
0.149 ms | 1 | /classes/Language.php:844 | ||
| 31 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.148 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 153 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1 |
0.148 ms | 1 | /classes/module/Module.php:2270 | ||
| 51 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.148 ms | 1 | /classes/Country.php:406 | ||
| 53 | SELECT SQL_NO_CACHE * FROM `dfdu_country_lang` WHERE `id_country` = 6 |
0.148 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 117 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 14 |
0.146 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 71 | SELECT SQL_NO_CACHE * FROM `dfdu_category_lang` WHERE `id_category` = 9 AND `id_shop` = 1 |
0.146 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 177 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 9 LIMIT 1 |
0.146 ms | 1 | /classes/Category.php:1607 | ||
| 123 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 17) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.145 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 37 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.145 ms | 1 | /classes/Category.php:2454 | ||
| 25 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.144 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 52 | SELECT SQL_NO_CACHE * FROM `dfdu_country` a LEFT JOIN `dfdu_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 6) LIMIT 1 |
0.144 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 120 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 4 AND `id_group` = 1 LIMIT 1 |
0.144 ms | 0 | /classes/GroupReduction.php:146 | ||
| 219 | SELECT SQL_NO_CACHE data FROM `dfdu_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.144 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39 | ||
| 32 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 2 |
0.143 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 46 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `manufacturers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.142 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 128 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 17 |
0.142 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 101 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 3 LIMIT 1 |
0.141 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 58 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1 |
0.141 ms | 1 | /classes/module/Module.php:2270 | ||
| 163 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.141 ms | 1 | /classes/module/Module.php:2781 | ||
| 221 | SELECT SQL_NO_CACHE `name` FROM `dfdu_manufacturer` WHERE `id_manufacturer` = 2 AND `active` = 1 LIMIT 1 |
0.140 ms | 1 | /classes/Manufacturer.php:306 | ||
| 29 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.139 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 73 | SELECT SQL_NO_CACHE data FROM dfdu_layered_filter_block WHERE hash="bd6a3d311b9f6fcb0d063639d46c2058" LIMIT 1 |
0.139 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:185 | ||
| 200 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 18) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.139 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 168 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_mainmenu" LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2781 | ||
| 208 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2781 | ||
| 40 | SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM dfdu_shop s |
0.138 ms | 1 | /classes/shop/Shop.php:922 | ||
| 106 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 3 AND `id_group` = 1 LIMIT 1 |
0.136 ms | 0 | /classes/GroupReduction.php:146 | ||
| 144 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` |
0.136 ms | 7 | /classes/ImageType.php:161 | ||
| 60 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.136 ms | 1 | /modules/ps_accounts/src/Adapter/Configuration.php:278 | ||
| 206 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 19) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.134 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 141 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.133 ms | 1 | /classes/Category.php:1396 | ||
| 155 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.133 ms | 1 | /classes/module/Module.php:2781 | ||
| 139 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 20 |
0.132 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 131 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1 LIMIT 1 |
0.131 ms | 0 | /classes/GroupReduction.php:146 | ||
| 162 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 1 |
0.131 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 199 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 16) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.131 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 59 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.131 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 166 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.130 ms | 1 | /classes/module/Module.php:2270 | ||
| 23 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.130 ms | 1 | /classes/shop/Shop.php:1211 | ||
| 109 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.130 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 9 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.129 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 107 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_group` WHERE `id_group` = 1 LIMIT 1 |
0.129 ms | 1 | /classes/Group.php:151 | ||
| 154 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.128 ms | 1 | /classes/Country.php:406 | ||
| 121 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.128 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 41 | SELECT SQL_NO_CACHE * FROM `dfdu_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.127 ms | 1 | /classes/module/Module.php:2171 | ||
| 171 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.127 ms | 1 | /classes/module/Module.php:2270 | ||
| 182 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_brandlist" LIMIT 1 |
0.127 ms | 1 | /classes/module/Module.php:2781 | ||
| 207 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 21) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.126 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 62 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration` a WHERE (a.`id_configuration` = 479) LIMIT 1 |
0.126 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 164 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.126 ms | 1 | /classes/module/Module.php:2270 | ||
| 118 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 4 LIMIT 1 |
0.125 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 183 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 59 AND `id_shop` = 1 LIMIT 1 |
0.125 ms | 1 | /classes/module/Module.php:2270 | ||
| 30 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.124 ms | 1 | /classes/Language.php:870 | ||
| 47 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `suppliers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.124 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 157 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.124 ms | 1 | /classes/module/Module.php:2781 | ||
| 129 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 5 LIMIT 1 |
0.123 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 181 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 36 AND `id_shop` = 1 LIMIT 1 |
0.123 ms | 1 | /classes/module/Module.php:2270 | ||
| 48 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.122 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 54 | SELECT SQL_NO_CACHE * FROM `dfdu_state` a WHERE (a.`id_state` = 353) LIMIT 1 |
0.122 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 55 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM dfdu_required_field |
0.121 ms | 1 | /classes/ObjectModel.php:1437 | ||
| 26 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.121 ms | 1 | /classes/Language.php:870 | ||
| 193 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 15) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.119 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 27 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.119 ms | 1 | /classes/Language.php:870 | ||
| 35 | SELECT SQL_NO_CACHE * FROM `dfdu_group_lang` WHERE `id_group` = 1 |
0.118 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 189 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.118 ms | 0 | /classes/Category.php:1396 | ||
| 24 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.117 ms | 1 | /classes/Currency.php:893 | ||
| 210 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.117 ms | 1 | /classes/module/Module.php:2781 | ||
| 169 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1 |
0.117 ms | 1 | /classes/module/Module.php:2270 | ||
| 49 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `stores` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.116 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 156 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.116 ms | 1 | /classes/module/Module.php:2270 | ||
| 50 | SELECT SQL_NO_CACHE format FROM `dfdu_address_format` WHERE `id_country` = 6 LIMIT 1 |
0.115 ms | 1 | /classes/AddressFormat.php:649 | ||
| 158 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.115 ms | 1 | /classes/module/Module.php:2270 | ||
| 173 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.115 ms | 1 | /classes/module/Module.php:2270 | ||
| 214 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1 |
0.114 ms | 1 | /classes/module/Module.php:2781 | ||
| 216 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.114 ms | 1 | /classes/Country.php:406 | ||
| 33 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_currency_shop` WHERE `id_currency` = 2 AND id_shop = 1 LIMIT 1 |
0.111 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 63 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration_lang` WHERE `id_configuration` = 479 |
0.111 ms | 1 | /src/Adapter/EntityMapper.php:82 | ||
| 209 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.109 ms | 1 | /classes/module/Module.php:2270 | ||
| 28 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'USD') LIMIT 1 |
0.108 ms | 1 | /classes/Currency.php:893 | ||
| 178 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c WHERE c.`id_category` = 2 LIMIT 1 |
0.104 ms | 1 | /classes/Category.php:1612 | ||
| 38 | SELECT SQL_NO_CACHE ctg.`id_group` FROM dfdu_category_group ctg WHERE ctg.`id_category` = 9 AND ctg.`id_group` = 1 LIMIT 1 |
0.102 ms | 1 | /classes/Category.php:1774 | ||
| 211 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.102 ms | 1 | /classes/module/Module.php:2270 | ||
| 213 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1 |
0.102 ms | 1 | /classes/module/Module.php:2270 | ||
| 215 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1 |
0.101 ms | 1 | /classes/module/Module.php:2270 | ||
| 36 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.100 ms | 1 | /classes/ObjectModel.php:1570 |
| 16 queries |
SELECT `id_module` FROM `dfdu_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX |
| 12 queries |
SELECT SUM(quantity) FROM `dfdu_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 `dfdu_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 `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_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
|
| 5 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 `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN dfdu_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 dfdu_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `dfdu_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 `id_lang` FROM `dfdu_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT XX
|
| 4 queries |
SELECT XX FROM `dfdu_specific_price` WHERE id_product = XX LIMIT XX |
| 3 queries |
SELECT * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `dfdu_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 `dfdu_country` WHERE `id_country` = XX LIMIT XX |
| 3 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((a.id_attribute_group=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY pac.id_attribute
|
| 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 `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `dfdu_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 tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = XX
AND tr.`id_country` = XX
AND tr.`id_tax_rules_group` = XX
AND tr.`id_state` IN (XX, XX)
AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
|
| 3 queries |
SELECT `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
| 3 queries |
SELECT pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN dfdu_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 `dfdu_attribute` a
LEFT JOIN `dfdu_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `dfdu_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `dfdu_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN dfdu_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 `dfdu_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX)
LEFT JOIN `dfdu_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 `dfdu_product_attribute` a LEFT JOIN `dfdu_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 `dfdu_product_attribute_lang` WHERE `id_product_attribute` = XX |
| 3 queries |
SELECT * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `dfdu_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 `dfdu_image` i
INNER JOIN dfdu_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
LEFT JOIN `dfdu_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 `dfdu_product_attribute_image` pai
LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `dfdu_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 `dfdu_product_attribute` pa
INNER JOIN dfdu_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 `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
JOIN `dfdu_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 `dfdu_product` a LEFT JOIN `dfdu_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 `dfdu_product_lang` WHERE `id_product` = XX AND `id_shop` = XX |
| 3 queries |
SELECT pa.*, product_attribute_shop.*
FROM `dfdu_product_attribute` pa
INNER JOIN dfdu_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 `dfdu_product_attribute_combination` pac
LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `dfdu_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)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
|
| 3 queries |
SELECT al.`name` AS attribute_name
FROM `dfdu_product_attribute_combination` pac
LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `dfdu_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 m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `dfdu_module` m
LEFT JOIN `dfdu_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = XX
|
| 2 queries |
SELECT value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX |
| 2 queries |
SELECT * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `dfdu_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 `dfdu_currency` a LEFT JOIN `dfdu_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 `dfdu_currency_lang` WHERE `id_currency` = XX |
| 2 queries |
SELECT `id_category` FROM `dfdu_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX |
| 2 queries |
SELECT `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT XX |
| 2 queries |
SELECT m.*, ml.`description`, ml.`short_description`
FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `dfdu_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
|
| 2 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, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_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 dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY fp.id_feature_value
|
| 2 queries |
SELECT cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX |
| 73 product_attribute_combination |
| 49 product_attribute |
| 47 stock_available |
| 38 product |
| 33 category |
| 32 product_shop |
| 22 module |
| 22 category_group |
| 21 attribute |
| 21 category_product |
| 19 module_shop |
| 18 product_attribute_shop |
| 17 attribute_lang |
| 16 product_sale |
| 15 attribute_group |
| 14 category_lang |
| 14 cart_product |
| 12 attribute_group_lang |
| 10 category_shop |
| 9 currency |
| 8 lang |
| 7 currency_shop |
| 7 product_lang |
| 6 hook |
| 6 image_type |
| 6 attribute_group_shop |
| 6 pack |
| 6 product_attribute_lang |
| 6 image |
| 6 image_lang |
| 5 shop |
| 5 configuration |
| 5 country |
| 5 attribute_shop |
| 5 layered_indexable_attribute_lang_value |
| 5 specific_price |
| 4 shop_url |
| 4 lang_shop |
| 4 currency_lang |
| 3 hook_alias |
| 3 manufacturer |
| 3 tax_rule |
| 3 tax_rules_group |
| 3 product_group_reduction_cache |
| 3 image_shop |
| 3 product_attribute_image |
| 2 shop_group |
| 2 configuration_lang |
| 2 country_lang |
| 2 country_shop |
| 2 hook_module |
| 2 group |
| 2 group_shop |
| 2 manufacturer_shop |
| 2 manufacturer_lang |
| 2 feature_product |
| 1 module_group |
| 1 meta |
| 1 meta_lang |
| 1 group_lang |
| 1 hook_module_exceptions |
| 1 address_format |
| 1 state |
| 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 feature_value |
| 1 feature_value_lang |
| 1 layered_indexable_feature_value_lang_value |
| 1 connections |
| 1 ganalytics_data |
| Name | Instances | Source |
|---|---|---|
| Category | 17 |
/controllers/front/listing/CategoryController.php:87 (__construct) [id: 9]
/classes/Meta.php:364 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 9] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /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: 9] |
| Product | 9 |
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 3]
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 5] /classes/Link.php:114 (__construct) [id: 3] /classes/Link.php:114 (__construct) [id: 4] /classes/Link.php:114 (__construct) [id: 5] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 3] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 4] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 5] |
| Country | 7 |
/config/config.inc.php:154 (__construct) [id: 6]
/classes/AddressFormat.php:402 (__construct) [id: 6] /classes/controller/FrontController.php:1739 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] |
| State | 5 |
/classes/controller/FrontController.php:1738 (__construct) [id: 353]
/modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353] |
| Address | 4 |
/classes/shop/Shop.php:487 (__construct) [id: ]
/classes/Product.php:3454 (initialize) [id: ] /classes/Product.php:3573 (__construct) [id: ] /classes/Product.php:5723 (__construct) [id: ] |
| Currency | 4 |
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2]
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:708 (getCurrencyInstance) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1] |
| Language | 3 |
/config/config.inc.php:219 (__construct) [id: 1]
/classes/Tools.php:659 (__construct) [id: 1] /classes/Tools.php:553 (__construct) [id: 1] |
| Combination | 3 |
/classes/Product.php:5671 (__construct) [id: 14]
/classes/Product.php:5671 (__construct) [id: 17] /classes/Product.php:5671 (__construct) [id: 20] |
| AddressFormat | 3 |
/classes/controller/FrontController.php:1733 (generateAddress) [id: ]
/modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] |
| Shop | 1 |
/config/config.inc.php:122 (initialize) [id: 1]
|
| Configuration | 1 |
/modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 479]
|
| Gender | 1 |
/classes/controller/FrontController.php:1656 (__construct) [id: 0]
|
| Risk | 1 |
/classes/controller/FrontController.php:1659 (__construct) [id: ]
|
| Group | 1 |
/classes/Cart.php:275 (getCurrent) [id: 1]
|
| Cart | 1 |
/classes/controller/FrontController.php:459 (__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 | /vendor/defuse/php-encryption/src/Crypto.php |
| 125 | /vendor/defuse/php-encryption/src/KeyOrPassword.php |
| 126 | /vendor/defuse/php-encryption/src/RuntimeTests.php |
| 127 | /vendor/defuse/php-encryption/src/DerivedKeys.php |
| 128 | /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php |
| 129 | /vendor/defuse/php-encryption/src/Exception/CryptoException.php |
| 130 | /src/Core/Session/SessionHandler.php |
| 131 | /src/Core/Session/SessionHandlerInterface.php |
| 132 | /vendor/symfony/http-foundation/Session/Session.php |
| 133 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBag.php |
| 134 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBagInterface.php |
| 135 | /vendor/symfony/http-foundation/Session/SessionBagInterface.php |
| 136 | /vendor/symfony/http-foundation/Session/Flash/FlashBag.php |
| 137 | /vendor/symfony/http-foundation/Session/Flash/FlashBagInterface.php |
| 138 | /vendor/symfony/http-foundation/Session/SessionBagProxy.php |
| 139 | /vendor/symfony/http-foundation/Session/FlashBagAwareSessionInterface.php |
| 140 | /vendor/symfony/http-foundation/Session/SessionInterface.php |
| 141 | /vendor/symfony/http-foundation/Session/Storage/PhpBridgeSessionStorage.php |
| 142 | /vendor/symfony/http-foundation/Session/Storage/NativeSessionStorage.php |
| 143 | /vendor/symfony/http-foundation/Session/Storage/MetadataBag.php |
| 144 | /vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php |
| 145 | /vendor/symfony/http-foundation/Session/Storage/Handler/AbstractSessionHandler.php |
| 146 | /vendor/symfony/http-foundation/Session/Storage/Proxy/SessionHandlerProxy.php |
| 147 | /vendor/symfony/http-foundation/Session/Storage/Proxy/AbstractProxy.php |
| 148 | /vendor/symfony/http-foundation/Session/Storage/SessionStorageInterface.php |
| 149 | /config/smarty.config.inc.php |
| 150 | /classes/Smarty/SmartyDev.php |
| 151 | /vendor/smarty/smarty/libs/Smarty.class.php |
| 152 | /vendor/smarty/smarty/libs/functions.php |
| 153 | /vendor/smarty/smarty/libs/Autoloader.php |
| 154 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php |
| 155 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php |
| 156 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| 157 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php |
| 158 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php |
| 159 | /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php |
| 160 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php |
| 161 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php |
| 162 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php |
| 163 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerclass.php |
| 164 | /classes/ImageManager.php |
| 165 | /classes/Product.php |
| 166 | /classes/Profile.php |
| 167 | /classes/Tab.php |
| 168 | /config/smartyfront.config.inc.php |
| 169 | /classes/Smarty/SmartyResourceModule.php |
| 170 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php |
| 171 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php |
| 172 | /classes/Smarty/SmartyResourceParent.php |
| 173 | /classes/Smarty/SmartyLazyRegister.php |
| 174 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php |
| 175 | /vendor/smarty/smarty/libs/plugins/modifier.truncate.php |
| 176 | /classes/Customer.php |
| 177 | /classes/Group.php |
| 178 | /classes/Link.php |
| 179 | /classes/shop/ShopUrl.php |
| 180 | /app/FrontKernel.php |
| 181 | /app/AppKernel.php |
| 182 | /vendor/symfony/http-kernel/Kernel.php |
| 183 | /vendor/symfony/config/ConfigCache.php |
| 184 | /vendor/symfony/config/ResourceCheckerConfigCache.php |
| 185 | /vendor/symfony/config/ConfigCacheInterface.php |
| 186 | /vendor/symfony/http-kernel/KernelInterface.php |
| 187 | /vendor/symfony/http-kernel/HttpKernelInterface.php |
| 188 | /vendor/symfony/http-kernel/RebootableInterface.php |
| 189 | /vendor/symfony/http-kernel/TerminableInterface.php |
| 190 | /vendor/symfony/dotenv/Dotenv.php |
| 191 | /classes/Dispatcher.php |
| 192 | /vendor/symfony/http-foundation/Request.php |
| 193 | /vendor/symfony/http-foundation/AcceptHeader.php |
| 194 | /vendor/symfony/http-foundation/AcceptHeaderItem.php |
| 195 | /vendor/symfony/http-foundation/FileBag.php |
| 196 | /vendor/symfony/http-foundation/HeaderBag.php |
| 197 | /vendor/symfony/http-foundation/HeaderUtils.php |
| 198 | /vendor/symfony/http-foundation/InputBag.php |
| 199 | /vendor/symfony/http-foundation/ServerBag.php |
| 200 | /src/Adapter/SymfonyContainer.php |
| 201 | /config/db_slave_server.inc.php |
| 202 | /src/Adapter/ContainerBuilder.php |
| 203 | /src/Adapter/Environment.php |
| 204 | /src/Core/EnvironmentInterface.php |
| 205 | /vendor/symfony/config/Resource/SelfCheckingResourceChecker.php |
| 206 | /vendor/symfony/config/ResourceCheckerInterface.php |
| 207 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/DoctrineProvider.php |
| 208 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php |
| 209 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php |
| 210 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php |
| 211 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php |
| 212 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiOperationCache.php |
| 213 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php |
| 214 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiDeleteCache.php |
| 215 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php |
| 216 | /vendor/symfony/cache/Adapter/ArrayAdapter.php |
| 217 | /vendor/psr/log/src/LoggerAwareTrait.php |
| 218 | /vendor/symfony/cache/Adapter/AdapterInterface.php |
| 219 | /vendor/symfony/cache/CacheItem.php |
| 220 | /vendor/symfony/cache-contracts/ItemInterface.php |
| 221 | /vendor/psr/cache/src/CacheItemInterface.php |
| 222 | /vendor/psr/cache/src/CacheItemPoolInterface.php |
| 223 | /vendor/symfony/cache-contracts/CacheInterface.php |
| 224 | /vendor/psr/log/src/LoggerAwareInterface.php |
| 225 | /vendor/symfony/cache/ResettableInterface.php |
| 226 | /vendor/symfony/service-contracts/ResetInterface.php |
| 227 | /vendor/doctrine/orm/src/Tools/Setup.php |
| 228 | /vendor/doctrine/deprecations/src/Deprecation.php |
| 229 | /vendor/doctrine/orm/src/Configuration.php |
| 230 | /vendor/doctrine/dbal/src/Configuration.php |
| 231 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/CacheAdapter.php |
| 232 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationReader.php |
| 233 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php |
| 234 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php |
| 235 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php |
| 236 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php |
| 237 | /vendor/doctrine/lexer/src/AbstractLexer.php |
| 238 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php |
| 239 | /vendor/doctrine/orm/src/Mapping/Driver/AnnotationDriver.php |
| 240 | /vendor/doctrine/orm/src/Mapping/Driver/CompatibilityAnnotationDriver.php |
| 241 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriver.php |
| 242 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/ColocatedMappingDriver.php |
| 243 | /vendor/doctrine/orm/src/Mapping/Driver/ReflectionBasedDriver.php |
| 244 | /vendor/symfony/cache/Adapter/FilesystemAdapter.php |
| 245 | /vendor/symfony/cache/Adapter/AbstractAdapter.php |
| 246 | /vendor/symfony/cache/Traits/AbstractAdapterTrait.php |
| 247 | /vendor/symfony/cache/Traits/ContractsTrait.php |
| 248 | /vendor/symfony/cache-contracts/CacheTrait.php |
| 249 | /vendor/psr/cache/src/InvalidArgumentException.php |
| 250 | /vendor/psr/cache/src/CacheException.php |
| 251 | /vendor/symfony/cache/Traits/FilesystemTrait.php |
| 252 | /vendor/symfony/cache/Traits/FilesystemCommonTrait.php |
| 253 | /vendor/symfony/cache/PruneableInterface.php |
| 254 | /vendor/symfony/cache/Marshaller/DefaultMarshaller.php |
| 255 | /vendor/symfony/cache/Marshaller/MarshallerInterface.php |
| 256 | /src/Adapter/Module/Repository/CachedModuleRepository.php |
| 257 | /src/Adapter/Module/Repository/ModuleRepository.php |
| 258 | /src/Core/Repository/AbstractObjectModelRepository.php |
| 259 | /vendor/symfony/cache/LockRegistry.php |
| 260 | /modules/ps_facebook/vendor/autoload.php |
| 261 | /modules/ps_facebook/vendor/composer/autoload_real.php |
| 262 | /modules/ps_facebook/vendor/composer/autoload_static.php |
| 263 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment.php |
| 264 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Client.php |
| 265 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer.php |
| 266 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/QueueConsumer.php |
| 267 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/File.php |
| 268 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/ForkCurl.php |
| 269 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/LibCurl.php |
| 270 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/Socket.php |
| 271 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Version.php |
| 272 | /modules/ps_classic_edition/vendor/autoload.php |
| 273 | /modules/ps_classic_edition/vendor/composer/autoload_real.php |
| 274 | /modules/ps_classic_edition/vendor/composer/platform_check.php |
| 275 | /modules/ps_classic_edition/vendor/composer/autoload_static.php |
| 276 | /modules/psshipping/vendor/autoload.php |
| 277 | /modules/psshipping/vendor/composer/autoload_real.php |
| 278 | /modules/psshipping/vendor/composer/autoload_static.php |
| 279 | /modules/psshipping/vendor/ralouphie/getallheaders/src/getallheaders.php |
| 280 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions_include.php |
| 281 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions.php |
| 282 | /modules/psshipping/vendor/clue/stream-filter/src/functions_include.php |
| 283 | /modules/psshipping/vendor/clue/stream-filter/src/functions.php |
| 284 | /modules/psshipping/vendor/php-http/message/src/filters.php |
| 285 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions_include.php |
| 286 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions.php |
| 287 | /modules/ps_eventbus/vendor/autoload.php |
| 288 | /modules/ps_eventbus/vendor/composer/autoload_real.php |
| 289 | /modules/ps_eventbus/vendor/composer/autoload_static.php |
| 290 | /modules/ps_checkout/vendor/autoload.php |
| 291 | /modules/ps_checkout/vendor/composer/autoload_real.php |
| 292 | /modules/ps_checkout/vendor/composer/platform_check.php |
| 293 | /modules/ps_checkout/vendor/composer/autoload_static.php |
| 294 | /modules/ps_checkout/vendor/ramsey/uuid/src/functions.php |
| 295 | /modules/psxmarketingwithgoogle/vendor/autoload.php |
| 296 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_real.php |
| 297 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_static.php |
| 298 | /modules/ps_mbo/vendor/autoload.php |
| 299 | /modules/ps_mbo/vendor/composer/autoload_real.php |
| 300 | /modules/ps_mbo/vendor/composer/platform_check.php |
| 301 | /modules/ps_mbo/vendor/composer/autoload_static.php |
| 302 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions_include.php |
| 303 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions.php |
| 304 | /modules/ps_mbo/vendor/sentry/sentry/src/functions.php |
| 305 | /modules/ps_mbo/bootstrap.php |
| 306 | /modules/ps_mbo/src/Helpers/EnvHelper.php |
| 307 | /modules/ps_accounts/vendor/autoload.php |
| 308 | /modules/ps_accounts/vendor/composer/autoload_real.php |
| 309 | /modules/ps_accounts/vendor/composer/platform_check.php |
| 310 | /modules/ps_accounts/vendor/composer/autoload_static.php |
| 311 | /modules/ps_accounts/vendor/paragonie/random_compat/lib/random.php |
| 312 | /modules/ps_accounts/vendor/symfony/polyfill-ctype/bootstrap.php |
| 313 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/class-aliases.php |
| 314 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Token.php |
| 315 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Signature.php |
| 316 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/json-exception-polyfill.php |
| 317 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php |
| 318 | /modules/ps_accounts/vendor/ramsey/uuid/src/functions.php |
| 319 | /vendor/symfony/config/Resource/FileResource.php |
| 320 | /vendor/symfony/config/Resource/SelfCheckingResourceInterface.php |
| 321 | /vendor/symfony/config/Resource/ResourceInterface.php |
| 322 | /vendor/symfony/config/Resource/ReflectionClassResource.php |
| 323 | /vendor/symfony/config/Resource/DirectoryResource.php |
| 324 | /var/cache/dev/FrontContainer.php |
| 325 | /src/Adapter/Container/LegacyContainer.php |
| 326 | /vendor/symfony/dependency-injection/Container.php |
| 327 | /vendor/symfony/dependency-injection/Argument/RewindableGenerator.php |
| 328 | /vendor/symfony/dependency-injection/Argument/ServiceLocator.php |
| 329 | /vendor/symfony/dependency-injection/ServiceLocator.php |
| 330 | /vendor/symfony/service-contracts/ServiceLocatorTrait.php |
| 331 | /vendor/psr/container/src/ContainerExceptionInterface.php |
| 332 | /vendor/psr/container/src/NotFoundExceptionInterface.php |
| 333 | /vendor/symfony/service-contracts/ServiceProviderInterface.php |
| 334 | /vendor/psr/container/src/ContainerInterface.php |
| 335 | /vendor/symfony/dependency-injection/ContainerInterface.php |
| 336 | /src/Adapter/Container/LegacyContainerInterface.php |
| 337 | /src/PrestaShopBundle/Entity/Repository/FeatureFlagRepository.php |
| 338 | /vendor/doctrine/orm/src/EntityRepository.php |
| 339 | /vendor/doctrine/persistence/src/Persistence/ObjectRepository.php |
| 340 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Selectable.php |
| 341 | /vendor/symfony/var-exporter/LazyProxyTrait.php |
| 342 | /vendor/symfony/var-exporter/Internal/LazyObjectTrait.php |
| 343 | /vendor/symfony/var-exporter/LazyObjectInterface.php |
| 344 | /vendor/symfony/var-exporter/Internal/Hydrator.php |
| 345 | /vendor/symfony/var-exporter/Internal/LazyObjectRegistry.php |
| 346 | /vendor/symfony/var-exporter/Internal/LazyObjectState.php |
| 347 | /src/PrestaShopBundle/Security/Admin/LegacyAdminTokenValidator.php |
| 348 | /vendor/symfony/var-exporter/LazyGhostTrait.php |
| 349 | /src/Core/FeatureFlag/FeatureFlagManager.php |
| 350 | /src/Core/FeatureFlag/FeatureFlagStateCheckerInterface.php |
| 351 | /src/Core/FeatureFlag/Layer/DbLayer.php |
| 352 | /src/Core/FeatureFlag/TypeLayerInterface.php |
| 353 | /src/Core/FeatureFlag/Layer/DotEnvLayer.php |
| 354 | /src/Core/FeatureFlag/Layer/EnvLayer.php |
| 355 | /src/Core/FeatureFlag/Layer/QueryLayer.php |
| 356 | /vendor/symfony/http-foundation/RequestStack.php |
| 357 | /vendor/doctrine/orm/src/EntityManager.php |
| 358 | /vendor/doctrine/orm/src/EntityManagerInterface.php |
| 359 | /vendor/doctrine/persistence/src/Persistence/ObjectManager.php |
| 360 | /src/Core/Hook/HookModuleFilter.php |
| 361 | /src/Core/Hook/HookModuleFilterInterface.php |
| 362 | /modules/ps_checkout/ps_checkout.php |
| 363 | /classes/PaymentModule.php |
| 364 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php |
| 365 | /vendor/smarty/smarty/libs/sysplugins/smarty_data.php |
| 366 | /classes/Translate.php |
| 367 | /modules/ps_checkout/translations/en.php |
| 368 | /src/PrestaShopBundle/Translation/TranslatorComponent.php |
| 369 | /vendor/symfony/translation/Translator.php |
| 370 | /vendor/symfony/translation/MessageCatalogue.php |
| 371 | /vendor/symfony/translation/MessageCatalogueInterface.php |
| 372 | /vendor/symfony/translation/MetadataAwareInterface.php |
| 373 | /vendor/symfony/translation/CatalogueMetadataAwareInterface.php |
| 374 | /vendor/symfony/translation-contracts/TranslatorInterface.php |
| 375 | /vendor/symfony/translation/TranslatorBagInterface.php |
| 376 | /vendor/symfony/translation-contracts/LocaleAwareInterface.php |
| 377 | /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php |
| 378 | /src/PrestaShopBundle/Translation/TranslatorLanguageTrait.php |
| 379 | /src/PrestaShopBundle/Translation/TranslatorInterface.php |
| 380 | /vendor/symfony/translation/Formatter/MessageFormatter.php |
| 381 | /vendor/symfony/translation/Formatter/IntlFormatter.php |
| 382 | /vendor/symfony/translation/Formatter/IntlFormatterInterface.php |
| 383 | /vendor/symfony/translation/Formatter/MessageFormatterInterface.php |
| 384 | /vendor/symfony/translation/IdentityTranslator.php |
| 385 | /vendor/symfony/translation-contracts/TranslatorTrait.php |
| 386 | /vendor/symfony/config/ConfigCacheFactory.php |
| 387 | /vendor/symfony/config/ConfigCacheFactoryInterface.php |
| 388 | /var/cache/dev/translations/catalogue.en-US.NXhscRe.php |
| 389 | /controllers/front/listing/CategoryController.php |
| 390 | /classes/controller/ProductListingFrontController.php |
| 391 | /classes/controller/ProductPresentingFrontController.php |
| 392 | /classes/controller/FrontController.php |
| 393 | /src/Adapter/Presenter/Object/ObjectPresenter.php |
| 394 | /src/Adapter/Presenter/PresenterInterface.php |
| 395 | /src/Adapter/Presenter/Cart/CartPresenter.php |
| 396 | /src/Adapter/Image/ImageRetriever.php |
| 397 | /classes/tax/TaxConfiguration.php |
| 398 | /classes/Smarty/TemplateFinder.php |
| 399 | /classes/assets/StylesheetManager.php |
| 400 | /classes/assets/AbstractAssetManager.php |
| 401 | /src/Adapter/Assets/AssetUrlGeneratorTrait.php |
| 402 | /classes/assets/JavascriptManager.php |
| 403 | /classes/assets/CccReducer.php |
| 404 | /classes/Category.php |
| 405 | /src/Core/Domain/Category/ValueObject/RedirectType.php |
| 406 | /src/Core/Domain/Category/CategorySettings.php |
| 407 | /src/Core/Domain/Category/SeoSettings.php |
| 408 | /classes/webservice/WebserviceRequest.php |
| 409 | /src/Core/Localization/Locale/Repository.php |
| 410 | /src/Core/Localization/Locale/RepositoryInterface.php |
| 411 | /src/Core/Localization/CLDR/LocaleRepository.php |
| 412 | /src/Core/Localization/CLDR/LocaleDataSource.php |
| 413 | /src/Core/Localization/CLDR/DataLayer/LocaleCache.php |
| 414 | /src/Core/Data/Layer/AbstractDataLayer.php |
| 415 | /src/Core/Localization/CLDR/LocaleDataLayerInterface.php |
| 416 | /src/Core/Localization/CLDR/DataLayer/LocaleReference.php |
| 417 | /src/Core/Localization/CLDR/Reader.php |
| 418 | /src/Core/Localization/CLDR/ReaderInterface.php |
| 419 | /src/Core/Localization/Currency/Repository.php |
| 420 | /src/Core/Localization/Currency/RepositoryInterface.php |
| 421 | /src/Core/Localization/Currency/CurrencyDataSource.php |
| 422 | /src/Core/Localization/Currency/DataSourceInterface.php |
| 423 | /src/Core/Localization/Currency/DataLayer/CurrencyCache.php |
| 424 | /src/Core/Localization/Currency/CurrencyDataLayerInterface.php |
| 425 | /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php |
| 426 | /src/Adapter/Currency/CurrencyDataProvider.php |
| 427 | /src/Core/Currency/CurrencyDataProviderInterface.php |
| 428 | /src/Adapter/LegacyContext.php |
| 429 | /src/Adapter/Tools.php |
| 430 | /src/Core/Localization/Currency/DataLayer/CurrencyReference.php |
| 431 | /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php |
| 432 | /vendor/prestashop/decimal/src/Operation/Rounding.php |
| 433 | /src/Core/Localization/Locale.php |
| 434 | /src/Core/Localization/LocaleInterface.php |
| 435 | /src/Core/Localization/Specification/Price.php |
| 436 | /src/Core/Localization/Specification/Number.php |
| 437 | /src/Core/Localization/Specification/NumberInterface.php |
| 438 | /src/Core/Localization/Specification/Factory.php |
| 439 | /src/Core/Localization/CLDR/LocaleData.php |
| 440 | /src/Core/Localization/CLDR/NumberSymbolsData.php |
| 441 | /src/Core/Localization/CLDR/CurrencyData.php |
| 442 | /src/Core/Localization/CLDR/Locale.php |
| 443 | /src/Core/Localization/CLDR/LocaleInterface.php |
| 444 | /src/Core/Localization/Specification/NumberSymbolList.php |
| 445 | /classes/Currency.php |
| 446 | /src/Core/Localization/Currency/LocalizedCurrencyId.php |
| 447 | /src/Core/Localization/Currency/CurrencyData.php |
| 448 | /src/Core/Localization/Currency/CurrencyCollection.php |
| 449 | /src/Core/Localization/Currency.php |
| 450 | /src/Core/Localization/CurrencyInterface.php |
| 451 | /src/Core/Localization/Specification/NumberCollection.php |
| 452 | /src/Core/Localization/Number/Formatter.php |
| 453 | /classes/Cart.php |
| 454 | /src/Adapter/AddressFactory.php |
| 455 | /classes/CartRule.php |
| 456 | /src/Core/Domain/Product/ValueObject/RedirectType.php |
| 457 | /src/Core/Util/DateTime/DateTime.php |
| 458 | /src/Core/Domain/Product/Stock/ValueObject/OutOfStockType.php |
| 459 | /src/Core/Domain/Product/Pack/ValueObject/PackStockType.php |
| 460 | /src/Core/Domain/Product/ValueObject/ProductType.php |
| 461 | /src/Core/Domain/Product/ValueObject/Reference.php |
| 462 | /src/Core/Domain/Product/ValueObject/Gtin.php |
| 463 | /src/Core/Domain/Product/ValueObject/Isbn.php |
| 464 | /src/Core/Domain/Product/ValueObject/Upc.php |
| 465 | /src/Core/Domain/Product/ProductSettings.php |
| 466 | /src/Adapter/Presenter/Category/CategoryPresenter.php |
| 467 | /src/Adapter/Presenter/Category/CategoryLazyArray.php |
| 468 | /src/Adapter/Presenter/AbstractLazyArray.php |
| 469 | /src/Adapter/Presenter/LazyArrayAttribute.php |
| 470 | /src/Core/Util/Inflector.php |
| 471 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/InflectorFactory.php |
| 472 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Language.php |
| 473 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/InflectorFactory.php |
| 474 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/GenericLanguageInflectorFactory.php |
| 475 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/LanguageInflectorFactory.php |
| 476 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Rules.php |
| 477 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Ruleset.php |
| 478 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformations.php |
| 479 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/WordInflector.php |
| 480 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Inflectible.php |
| 481 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformation.php |
| 482 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Pattern.php |
| 483 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Patterns.php |
| 484 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Uninflected.php |
| 485 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitutions.php |
| 486 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitution.php |
| 487 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Word.php |
| 488 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Inflector.php |
| 489 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/CachedWordInflector.php |
| 490 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/RulesetInflector.php |
| 491 | /src/Core/Domain/Shop/ValueObject/ShopId.php |
| 492 | /src/Core/Domain/Shop/ValueObject/ShopIdInterface.php |
| 493 | /vendor/symfony/property-access/Exception/UnexpectedTypeException.php |
| 494 | /vendor/symfony/property-access/Exception/RuntimeException.php |
| 495 | /vendor/symfony/property-access/Exception/ExceptionInterface.php |
| 496 | /modules/blockreassurance/blockreassurance.php |
| 497 | /src/Core/Module/WidgetInterface.php |
| 498 | /src/PrestaShopBundle/Translation/DomainNormalizer.php |
| 499 | /classes/Media.php |
| 500 | /modules/blockwishlist/blockwishlist.php |
| 501 | /modules/ps_emailsubscription/ps_emailsubscription.php |
| 502 | /modules/ps_socialfollow/ps_socialfollow.php |
| 503 | /modules/ps_facebook/ps_facebook.php |
| 504 | /modules/ps_facebook/translations/en.php |
| 505 | /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php |
| 506 | /modules/ps_facebook/vendor/prestashop/module-lib-cache-directory-provider/src/Cache/CacheDirectoryProvider.php |
| 507 | /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ContainerProvider.php |
| 508 | /var/cache/dev/Ps_facebookFrontContainer.php |
| 509 | /modules/ps_facebook/classes/Buffer/TemplateBuffer.php |
| 510 | /modules/ps_emailalerts/ps_emailalerts.php |
| 511 | /modules/ps_emailalerts/MailAlert.php |
| 512 | /var/cache/dev/Ps_checkout9433FrontContainer.php |
| 513 | /modules/ps_checkout/src/Validator/FrontControllerValidator.php |
| 514 | /modules/ps_checkout/src/Validator/MerchantValidator.php |
| 515 | /modules/ps_checkout/src/PayPal/PayPalConfiguration.php |
| 516 | /modules/ps_checkout/src/Configuration/PrestaShopConfiguration.php |
| 517 | /modules/ps_checkout/src/Configuration/PrestaShopConfigurationOptionsResolver.php |
| 518 | /modules/ps_checkout/src/Shop/ShopProvider.php |
| 519 | /vendor/symfony/options-resolver/OptionsResolver.php |
| 520 | /vendor/symfony/options-resolver/Options.php |
| 521 | /modules/ps_checkout/src/Repository/PayPalCodeRepository.php |
| 522 | /modules/ps_checkout/src/Repository/PsAccountRepository.php |
| 523 | /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php |
| 524 | /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Installer.php |
| 525 | /src/Core/Addon/Module/ModuleManagerBuilder.php |
| 526 | /src/Adapter/LegacyLogger.php |
| 527 | /src/Adapter/Module/ModuleDataProvider.php |
| 528 | /src/Adapter/Module/AdminModuleDataProvider.php |
| 529 | /src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php |
| 530 | /src/Adapter/Module/Module.php |
| 531 | /src/Core/Module/ModuleInterface.php |
| 532 | /vendor/symfony/config/FileLocator.php |
| 533 | /vendor/symfony/config/FileLocatorInterface.php |
| 534 | /vendor/symfony/routing/Loader/YamlFileLoader.php |
| 535 | /vendor/symfony/config/Loader/FileLoader.php |
| 536 | /vendor/symfony/config/Loader/Loader.php |
| 537 | /vendor/symfony/config/Loader/LoaderInterface.php |
| 538 | /vendor/symfony/routing/Loader/Configurator/Traits/HostTrait.php |
| 539 | /vendor/symfony/routing/Loader/Configurator/Traits/LocalizedRouteTrait.php |
| 540 | /vendor/symfony/routing/Loader/Configurator/Traits/PrefixTrait.php |
| 541 | /vendor/symfony/routing/Router.php |
| 542 | /vendor/symfony/routing/RouterInterface.php |
| 543 | /vendor/symfony/routing/Matcher/UrlMatcherInterface.php |
| 544 | /vendor/symfony/routing/RequestContextAwareInterface.php |
| 545 | /vendor/symfony/routing/Generator/UrlGeneratorInterface.php |
| 546 | /vendor/symfony/routing/Matcher/RequestMatcherInterface.php |
| 547 | /vendor/symfony/routing/RequestContext.php |
| 548 | /src/Core/Module/ModuleManager.php |
| 549 | /src/Core/Module/ModuleManagerInterface.php |
| 550 | /src/Core/Module/ModuleRepository.php |
| 551 | /src/Core/Module/ModuleRepositoryInterface.php |
| 552 | /src/Adapter/HookManager.php |
| 553 | /src/Core/Context/LanguageContext.php |
| 554 | /src/Core/Module/SourceHandler/SourceHandlerFactory.php |
| 555 | /src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php |
| 556 | /vendor/symfony/event-dispatcher/EventDispatcherInterface.php |
| 557 | /vendor/symfony/event-dispatcher-contracts/EventDispatcherInterface.php |
| 558 | /vendor/psr/event-dispatcher/src/EventDispatcherInterface.php |
| 559 | /src/Core/Hook/HookDispatcherInterface.php |
| 560 | /vendor/symfony/translation/Loader/XliffFileLoader.php |
| 561 | /vendor/symfony/translation/Loader/LoaderInterface.php |
| 562 | /modules/ps_accounts/ps_accounts.php |
| 563 | /modules/ps_accounts/src/Hook/HookableTrait.php |
| 564 | /modules/ps_accounts/src/Module/Install.php |
| 565 | /modules/ps_accounts/src/Settings/SettingsForm.php |
| 566 | /modules/ps_accounts/translations/en.php |
| 567 | /modules/ps_accounts/src/ServiceContainer/PsAccountsContainer.php |
| 568 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/ServiceContainer.php |
| 569 | /modules/ps_accounts/config.php |
| 570 | /modules/ps_accounts/src/Log/Logger.php |
| 571 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Logger.php |
| 572 | /modules/ps_accounts/vendor/psr/log/Psr/Log/LoggerInterface.php |
| 573 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/ResettableInterface.php |
| 574 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/RotatingFileHandler.php |
| 575 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php |
| 576 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php |
| 577 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php |
| 578 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/HandlerInterface.php |
| 579 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Utils.php |
| 580 | /modules/ps_accounts/src/ServiceProvider/ApiClientProvider.php |
| 581 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/Contract/IServiceProvider.php |
| 582 | /modules/ps_accounts/src/ServiceProvider/CommandProvider.php |
| 583 | /modules/ps_accounts/src/ServiceProvider/DefaultProvider.php |
| 584 | /modules/ps_accounts/src/ServiceProvider/OAuth2Provider.php |
| 585 | /modules/ps_accounts/src/ServiceProvider/QueryProvider.php |
| 586 | /modules/ps_accounts/src/ServiceProvider/RepositoryProvider.php |
| 587 | /modules/ps_accounts/src/ServiceProvider/SessionProvider.php |
| 588 | /modules/ps_accounts/src/Service/PsAccountsService.php |
| 589 | /modules/ps_accounts/src/Account/Session/ShopSession.php |
| 590 | /modules/ps_accounts/src/Account/Session/Session.php |
| 591 | /modules/ps_accounts/src/Account/Session/SessionInterface.php |
| 592 | /modules/ps_accounts/src/Repository/ConfigurationRepository.php |
| 593 | /modules/ps_accounts/src/Adapter/Configuration.php |
| 594 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Service.php |
| 595 | /modules/ps_accounts/src/Http/Client/ClientConfig.php |
| 596 | /modules/ps_accounts/src/Http/Client/ConfigObject.php |
| 597 | /modules/ps_accounts/src/Type/Enum.php |
| 598 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Client.php |
| 599 | /modules/ps_accounts/src/Adapter/Link.php |
| 600 | /modules/ps_accounts/src/Context/ShopContext.php |
| 601 | /modules/ps_accounts/vendor/ramsey/uuid/src/Uuid.php |
| 602 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidInterface.php |
| 603 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactory.php |
| 604 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactoryInterface.php |
| 605 | /modules/ps_accounts/vendor/ramsey/uuid/src/FeatureSet.php |
| 606 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Number/DegradedNumberConverter.php |
| 607 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/NumberConverterInterface.php |
| 608 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/DefaultUuidBuilder.php |
| 609 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/UuidBuilderInterface.php |
| 610 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/StringCodec.php |
| 611 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/CodecInterface.php |
| 612 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/FallbackNodeProvider.php |
| 613 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/NodeProviderInterface.php |
| 614 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/SystemNodeProvider.php |
| 615 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/RandomNodeProvider.php |
| 616 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorFactory.php |
| 617 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomBytesGenerator.php |
| 618 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorInterface.php |
| 619 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Time/SystemTimeProvider.php |
| 620 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/TimeProviderInterface.php |
| 621 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorFactory.php |
| 622 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Time/PhpTimeConverter.php |
| 623 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/TimeConverterInterface.php |
| 624 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/DefaultTimeGenerator.php |
| 625 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorInterface.php |
| 626 | /modules/ps_accounts/vendor/ramsey/uuid/src/BinaryUtils.php |
| 627 | /modules/ps_accounts/src/Service/OAuth2/CachedFile.php |
| 628 | /modules/ps_accounts/src/Account/Session/Firebase/ShopSession.php |
| 629 | /modules/ps_accounts/src/Account/Session/Firebase/FirebaseSession.php |
| 630 | /modules/ps_accounts/src/Account/Session/Firebase/OwnerSession.php |
| 631 | /modules/ps_accounts/src/Account/StatusManager.php |
| 632 | /modules/ps_accounts/src/Traits/WithOriginAndSourceTrait.php |
| 633 | /modules/ps_accounts/src/Traits/WithPropertyTrait.php |
| 634 | /modules/ps_accounts/src/Service/Accounts/AccountsService.php |
| 635 | /modules/ps_accounts/src/Service/AnalyticsService.php |
| 636 | /modules/ps_accounts/src/Service/AdminTokenService.php |
| 637 | /modules/ps_checkout/src/ExpressCheckout/ExpressCheckoutConfiguration.php |
| 638 | /modules/ps_checkout/src/PayPal/PayPalPayLaterConfiguration.php |
| 639 | /modules/ps_checkout/src/Version/Version.php |
| 640 | /src/Adapter/Presenter/Cart/CartLazyArray.php |
| 641 | /src/Adapter/Product/PriceFormatter.php |
| 642 | /classes/Gender.php |
| 643 | /src/Core/Domain/Title/ValueObject/Gender.php |
| 644 | /classes/Risk.php |
| 645 | /classes/Meta.php |
| 646 | /classes/Address.php |
| 647 | /classes/ImageType.php |
| 648 | /classes/State.php |
| 649 | /src/Core/Security/PasswordPolicyConfiguration.php |
| 650 | /src/Core/Configuration/DataConfigurationInterface.php |
| 651 | /src/Core/Security/Hashing.php |
| 652 | /src/Core/Filter/FrontEndObject/MainFilter.php |
| 653 | /src/Core/Filter/FilterInterface.php |
| 654 | /src/Core/Filter/FrontEndObject/CartFilter.php |
| 655 | /src/Core/Filter/HashMapWhitelistFilter.php |
| 656 | /src/Core/Filter/CollectionFilter.php |
| 657 | /src/Core/Filter/FrontEndObject/ProductFilter.php |
| 658 | /src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php |
| 659 | /src/Core/Filter/FrontEndObject/CustomerFilter.php |
| 660 | /src/Core/Filter/FrontEndObject/ShopFilter.php |
| 661 | /src/Core/Filter/FrontEndObject/ConfigurationFilter.php |
| 662 | /classes/ProductAssembler.php |
| 663 | /src/Core/Product/Search/ProductSearchContext.php |
| 664 | /modules/ps_shoppingcart/ps_shoppingcart.php |
| 665 | /modules/ps_searchbar/ps_searchbar.php |
| 666 | /modules/ps_imageslider/ps_imageslider.php |
| 667 | /modules/ps_imageslider/Ps_HomeSlide.php |
| 668 | /modules/productcomments/productcomments.php |
| 669 | /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php |
| 670 | /modules/ps_facebook/classes/Config/Env.php |
| 671 | /modules/ps_facebook/classes/Handler/ErrorHandler/ModuleFilteredRavenClient.php |
| 672 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Client.php |
| 673 | /modules/ps_facebook/classes/Config/Config.php |
| 674 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Util.php |
| 675 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Compat.php |
| 676 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor/SanitizeDataProcessor.php |
| 677 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor.php |
| 678 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Context.php |
| 679 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs.php |
| 680 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Serializer.php |
| 681 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ReprSerializer.php |
| 682 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/TransactionStack.php |
| 683 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs/ErrorHandler.php |
| 684 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Stacktrace.php |
| 685 | /modules/ps_accounts/src/Adapter/ConfigurationKeys.php |
| 686 | /modules/ps_accounts/src/Account/CachedShopStatus.php |
| 687 | /modules/ps_accounts/src/Http/Resource/Resource.php |
| 688 | /modules/ps_accounts/src/Type/Dto.php |
| 689 | /modules/ps_accounts/src/Service/Accounts/Resource/ShopStatus.php |
| 690 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ErrorHandler.php |
| 691 | /modules/ps_facebook/classes/Dispatcher/EventDispatcher.php |
| 692 | /modules/ps_facebook/classes/Handler/ApiConversionHandler.php |
| 693 | /modules/ps_facebook/classes/Adapter/ConfigurationAdapter.php |
| 694 | /modules/ps_facebook/classes/Factory/ContextFactory.php |
| 695 | /modules/ps_facebook/classes/API/Client/FacebookClient.php |
| 696 | /modules/ps_facebook/classes/Factory/FacebookEssentialsApiClientFactory.php |
| 697 | /modules/ps_facebook/classes/Factory/ApiClientFactoryInterface.php |
| 698 | /modules/ps_facebook/classes/Provider/AccessTokenProvider.php |
| 699 | /modules/ps_facebook/classes/Factory/PsApiClientFactory.php |
| 700 | /modules/ps_facebook/classes/Handler/ConfigurationHandler.php |
| 701 | /modules/ps_facebook/classes/Http/HttpClient.php |
| 702 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Api.php |
| 703 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Session.php |
| 704 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/SessionInterface.php |
| 705 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/ApiConfig.php |
| 706 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Http/Client.php |
| 707 | /modules/ps_facebook/classes/Handler/PixelHandler.php |
| 708 | /vendor/symfony/http-foundation/Session/Storage/MockFileSessionStorage.php |
| 709 | /vendor/symfony/http-foundation/Session/Storage/MockArraySessionStorage.php |
| 710 | /modules/ps_facebook/classes/Provider/EventDataProvider.php |
| 711 | /modules/ps_facebook/classes/Adapter/ToolsAdapter.php |
| 712 | /modules/ps_facebook/classes/Repository/ProductRepository.php |
| 713 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProvider.php |
| 714 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProviderInterface.php |
| 715 | /modules/ps_facebook/classes/Repository/GoogleCategoryRepository.php |
| 716 | /modules/ps_facebook/classes/Provider/GoogleCategoryProvider.php |
| 717 | /modules/ps_facebook/classes/Provider/GoogleCategoryProviderInterface.php |
| 718 | /modules/psshipping/psshipping.php |
| 719 | /src/Adapter/Localization/LegacyTranslator.php |
| 720 | /var/cache/dev/PsshippingFrontContainer.php |
| 721 | /modules/psshipping/src/Hooks/HookDisplayHeader.php |
| 722 | /modules/psshipping/src/Domain/GelProximity/GelProximityService.php |
| 723 | /modules/psshipping/src/Domain/Carriers/CarrierRepository.php |
| 724 | /src/Adapter/ContainerFinder.php |
| 725 | /vendor/doctrine/dbal/src/Logging/LoggerChain.php |
| 726 | /vendor/doctrine/dbal/src/Logging/SQLLogger.php |
| 727 | /vendor/symfony/doctrine-bridge/Logger/DbalLogger.php |
| 728 | /vendor/doctrine/dbal/src/Logging/DebugStack.php |
| 729 | /vendor/doctrine/doctrine-bundle/ConnectionFactory.php |
| 730 | /src/PrestaShopBundle/DependencyInjection/RuntimeConstEnvVarProcessor.php |
| 731 | /vendor/symfony/dependency-injection/EnvVarProcessorInterface.php |
| 732 | /vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php |
| 733 | /vendor/doctrine/event-manager/src/EventManager.php |
| 734 | /vendor/doctrine/dbal/src/DriverManager.php |
| 735 | /vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php |
| 736 | /vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php |
| 737 | /vendor/doctrine/dbal/src/VersionAwarePlatformDriver.php |
| 738 | /vendor/doctrine/dbal/src/Driver.php |
| 739 | /src/PrestaShopBundle/Doctrine/DatabaseConnection.php |
| 740 | /vendor/doctrine/dbal/src/Connection.php |
| 741 | /vendor/doctrine/dbal/src/ArrayParameterType.php |
| 742 | /vendor/doctrine/dbal/src/ParameterType.php |
| 743 | /vendor/doctrine/dbal/src/Query/Expression/ExpressionBuilder.php |
| 744 | /vendor/doctrine/dbal/src/Schema/LegacySchemaManagerFactory.php |
| 745 | /vendor/doctrine/dbal/src/Schema/SchemaManagerFactory.php |
| 746 | /vendor/doctrine/dbal/src/Driver/PDO/Connection.php |
| 747 | /vendor/doctrine/dbal/src/Driver/ServerInfoAwareConnection.php |
| 748 | /vendor/doctrine/dbal/src/Driver/Connection.php |
| 749 | /vendor/doctrine/dbal/src/Events.php |
| 750 | /vendor/doctrine/dbal/src/Platforms/MariaDb1010Platform.php |
| 751 | /vendor/doctrine/dbal/src/Platforms/MariaDb1060Platform.php |
| 752 | /vendor/doctrine/dbal/src/Platforms/MariaDb1052Platform.php |
| 753 | /vendor/doctrine/dbal/src/Platforms/MariaDb1043Platform.php |
| 754 | /vendor/doctrine/dbal/src/Platforms/MariaDb1027Platform.php |
| 755 | /vendor/doctrine/dbal/src/Platforms/MariaDBPlatform.php |
| 756 | /vendor/doctrine/dbal/src/Platforms/MySQLPlatform.php |
| 757 | /vendor/doctrine/dbal/src/Platforms/AbstractMySQLPlatform.php |
| 758 | /vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php |
| 759 | /vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php |
| 760 | /vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php |
| 761 | /vendor/doctrine/dbal/src/Types/Types.php |
| 762 | /vendor/doctrine/dbal/src/Types/Type.php |
| 763 | /vendor/doctrine/dbal/src/Types/ArrayType.php |
| 764 | /vendor/doctrine/dbal/src/Types/AsciiStringType.php |
| 765 | /vendor/doctrine/dbal/src/Types/StringType.php |
| 766 | /vendor/doctrine/dbal/src/Types/BigIntType.php |
| 767 | /vendor/doctrine/dbal/src/Types/PhpIntegerMappingType.php |
| 768 | /vendor/doctrine/dbal/src/Types/BinaryType.php |
| 769 | /vendor/doctrine/dbal/src/Types/BlobType.php |
| 770 | /vendor/doctrine/dbal/src/Types/BooleanType.php |
| 771 | /vendor/doctrine/dbal/src/Types/DateType.php |
| 772 | /vendor/doctrine/dbal/src/Types/DateImmutableType.php |
| 773 | /vendor/doctrine/dbal/src/Types/DateIntervalType.php |
| 774 | /vendor/doctrine/dbal/src/Types/DateTimeType.php |
| 775 | /vendor/doctrine/dbal/src/Types/PhpDateTimeMappingType.php |
| 776 | /vendor/doctrine/dbal/src/Types/DateTimeImmutableType.php |
| 777 | /vendor/doctrine/dbal/src/Types/DateTimeTzType.php |
| 778 | /vendor/doctrine/dbal/src/Types/DateTimeTzImmutableType.php |
| 779 | /vendor/doctrine/dbal/src/Types/DecimalType.php |
| 780 | /vendor/doctrine/dbal/src/Types/FloatType.php |
| 781 | /vendor/doctrine/dbal/src/Types/GuidType.php |
| 782 | /vendor/doctrine/dbal/src/Types/IntegerType.php |
| 783 | /vendor/doctrine/dbal/src/Types/JsonType.php |
| 784 | /vendor/doctrine/dbal/src/Types/ObjectType.php |
| 785 | /vendor/doctrine/dbal/src/Types/SimpleArrayType.php |
| 786 | /vendor/doctrine/dbal/src/Types/SmallIntType.php |
| 787 | /vendor/doctrine/dbal/src/Types/TextType.php |
| 788 | /vendor/doctrine/dbal/src/Types/TimeType.php |
| 789 | /vendor/doctrine/dbal/src/Types/TimeImmutableType.php |
| 790 | /vendor/doctrine/dbal/src/Types/TypeRegistry.php |
| 791 | /modules/ps_googleanalytics/ps_googleanalytics.php |
| 792 | /modules/ps_googleanalytics/classes/Hook/HookDisplayHeader.php |
| 793 | /modules/ps_googleanalytics/classes/Hook/HookInterface.php |
| 794 | /modules/psxmarketingwithgoogle/psxmarketingwithgoogle.php |
| 795 | /var/cache/dev/PsxmarketingwithgoogleFrontContainer.php |
| 796 | /modules/psxmarketingwithgoogle/classes/Adapter/ConfigurationAdapter.php |
| 797 | /modules/psxmarketingwithgoogle/classes/Factory/ContextFactory.php |
| 798 | /modules/psxmarketingwithgoogle/classes/config/Config.php |
| 799 | /modules/psxmarketingwithgoogle/classes/Handler/RemarketingHookHandler.php |
| 800 | /modules/psxmarketingwithgoogle/classes/Buffer/TemplateBuffer.php |
| 801 | /src/Core/Product/Search/ProductSearchQuery.php |
| 802 | /src/Core/Product/Search/SortOrder.php |
| 803 | /modules/ps_facetedsearch/ps_facetedsearch.php |
| 804 | /modules/ps_facetedsearch/src/HookDispatcher.php |
| 805 | /modules/ps_facetedsearch/src/Hook/Attribute.php |
| 806 | /modules/ps_facetedsearch/src/Hook/AbstractHook.php |
| 807 | /modules/ps_facetedsearch/src/Hook/AttributeGroup.php |
| 808 | /modules/ps_facetedsearch/src/Hook/Category.php |
| 809 | /modules/ps_facetedsearch/src/Hook/Configuration.php |
| 810 | /modules/ps_facetedsearch/src/Hook/Design.php |
| 811 | /modules/ps_facetedsearch/src/Hook/Feature.php |
| 812 | /modules/ps_facetedsearch/src/Form/Feature/FormModifier.php |
| 813 | /modules/ps_facetedsearch/src/Form/Feature/FormDataProvider.php |
| 814 | /modules/ps_facetedsearch/src/Hook/FeatureValue.php |
| 815 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormModifier.php |
| 816 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormDataProvider.php |
| 817 | /modules/ps_facetedsearch/src/Hook/Product.php |
| 818 | /modules/ps_facetedsearch/src/Hook/ProductSearch.php |
| 819 | /modules/ps_facetedsearch/src/Hook/SpecificPrice.php |
| 820 | /modules/ps_facetedsearch/src/Filters/Provider.php |
| 821 | /modules/ps_facetedsearch/src/URLSerializer.php |
| 822 | /modules/ps_facetedsearch/src/Filters/DataAccessor.php |
| 823 | /modules/ps_facetedsearch/src/Product/SearchProvider.php |
| 824 | /src/Core/Product/Search/FacetsRendererInterface.php |
| 825 | /src/Core/Product/Search/ProductSearchProviderInterface.php |
| 826 | /modules/ps_facetedsearch/src/Filters/Converter.php |
| 827 | /modules/ps_facetedsearch/src/Product/SearchFactory.php |
| 828 | /src/Core/Product/Search/ProductSearchResult.php |
| 829 | /modules/ps_facetedsearch/src/Definition/Availability.php |
| 830 | /classes/Combination.php |
| 831 | /classes/Manufacturer.php |
| 832 | /src/Core/Util/String/StringModifier.php |
| 833 | /src/Core/Util/String/StringModifierInterface.php |
| 834 | /modules/ps_facetedsearch/src/Product/Search.php |
| 835 | /modules/ps_facetedsearch/src/Adapter/MySQL.php |
| 836 | /modules/ps_facetedsearch/src/Adapter/AbstractAdapter.php |
| 837 | /modules/ps_facetedsearch/src/Adapter/InterfaceAdapter.php |
| 838 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ArrayCollection.php |
| 839 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Collection.php |
| 840 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ReadableCollection.php |
| 841 | /modules/ps_facetedsearch/src/Filters/Products.php |
| 842 | /classes/stock/StockAvailable.php |
| 843 | /modules/ps_facetedsearch/src/Filters/Block.php |
| 844 | /src/Core/Product/Search/Facet.php |
| 845 | /src/Core/Product/Search/Filter.php |
| 846 | /vendor/prestashop/decimal/src/DecimalNumber.php |
| 847 | /vendor/prestashop/decimal/src/Builder.php |
| 848 | /src/Core/Product/Search/FacetCollection.php |
| 849 | /classes/Pack.php |
| 850 | /src/Core/Localization/CLDR/ComputingPrecision.php |
| 851 | /src/Core/Localization/CLDR/ComputingPrecisionInterface.php |
| 852 | /classes/SpecificPrice.php |
| 853 | /classes/tax/TaxManagerFactory.php |
| 854 | /classes/tax/TaxRulesTaxManager.php |
| 855 | /classes/tax/TaxManagerInterface.php |
| 856 | /classes/tax/TaxCalculator.php |
| 857 | /classes/GroupReduction.php |
| 858 | /classes/order/Order.php |
| 859 | /classes/tax/Tax.php |
| 860 | /src/Core/Domain/Combination/CombinationSettings.php |
| 861 | /classes/ProductPresenterFactory.php |
| 862 | /src/Adapter/Presenter/Product/ProductListingPresenter.php |
| 863 | /src/Adapter/Presenter/Product/ProductPresenter.php |
| 864 | /src/Adapter/Product/ProductColorsRetriever.php |
| 865 | /src/Core/Product/ProductPresentationSettings.php |
| 866 | /src/Adapter/Presenter/Product/ProductListingLazyArray.php |
| 867 | /src/Adapter/Presenter/Product/ProductLazyArray.php |
| 868 | /classes/Image.php |
| 869 | /src/Core/Image/ImageFormatConfiguration.php |
| 870 | /src/Core/Image/ImageFormatConfigurationInterface.php |
| 871 | /classes/Smarty/SmartyDevTemplate.php |
| 872 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php |
| 873 | /var/cache/dev/smarty/compile/classic/d4/1d/65/d41d65d76b9471b5d365fe06cf1737c89a53af9f_2.module.ps_facetedsearchviewstemplatesfrontcatalogfacets.tpl.php |
| 874 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php |
| 875 | /vendor/smarty/smarty/libs/plugins/modifier.count.php |
| 876 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php |
| 877 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php |
| 878 | /var/cache/dev/smarty/compile/classic/2e/80/73/2e807335546cfa2360c36327ac89dd2fcb054379_2.module.ps_facetedsearchviewstemplatesfrontcatalogactivefilters.tpl.php |
| 879 | /src/Core/Product/Search/Pagination.php |
| 880 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php |
| 881 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php |
| 882 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php |
| 883 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php |
| 884 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/40/51/23/405123fa2f4c2063b3ba176d243be48e91cdb2d0_2.file.helpers.tpl.php |
| 885 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_tplfunction.php |
| 886 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/61/b5/e061b5502d7c8b36b791de08d0bfd778210f31b0_2.file.head.tpl.php |
| 887 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/43/b3/e043b3d6d608728a976adcef936baafeb245aac5_2.file.head-jsonld.tpl.php |
| 888 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/54/d0/4f/54d04fd4dea589bff29349a97acdeb4e2e258b05_2.file.product-list-jsonld.tpl.php |
| 889 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/19/c2/36/19c23651dd8e5a657986f75ad3e7c7167aa0d27f_2.file.pagination-seo.tpl.php |
| 890 | /vendor/smarty/smarty/libs/plugins/modifier.replace.php |
| 891 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/3c/b4/d4/3cb4d4ec1523b3009b91de48efb2933e74ab325f_2.file.stylesheets.tpl.php |
| 892 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/72/13/62/7213626f86446d34d59453e02af5fb69d97025dd_2.file.javascript.tpl.php |
| 893 | /classes/ProductDownload.php |
| 894 | /src/Core/Cart/Calculator.php |
| 895 | /src/Core/Cart/CartRowCollection.php |
| 896 | /src/Core/Cart/Fees.php |
| 897 | /src/Core/Cart/AmountImmutable.php |
| 898 | /src/Core/Cart/CartRuleCollection.php |
| 899 | /src/Core/Cart/CartRuleCalculator.php |
| 900 | /src/Adapter/Product/PriceCalculator.php |
| 901 | /src/Core/Cart/CartRow.php |
| 902 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/13/38/18/133818d94af85e215f1759076eeb455cecbcb3ee_2.file.product-activation.tpl.php |
| 903 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php |
| 904 | /modules/ps_contactinfo/ps_contactinfo.php |
| 905 | /var/cache/dev/smarty/compile/classic/0e/b2/11/0eb2119957cbc13b240126b3ccd8fac8f109f1e2_2.module.ps_contactinfonav.tpl.php |
| 906 | /modules/ps_languageselector/ps_languageselector.php |
| 907 | /var/cache/dev/smarty/compile/classic/1c/00/f7/1c00f78dace25d509ec3a1f54176b7ae2000accf_2.module.ps_languageselectorps_languageselector.tpl.php |
| 908 | /modules/ps_currencyselector/ps_currencyselector.php |
| 909 | /var/cache/dev/smarty/compile/classic/b9/77/56/b97756c07f8c7dd53da6530f78f67ddd242f77c9_2.module.ps_currencyselectorps_currencyselector.tpl.php |
| 910 | /modules/ps_customersignin/ps_customersignin.php |
| 911 | /var/cache/dev/smarty/compile/classic/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.ps_customersigninps_customersignin.tpl.php |
| 912 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php |
| 913 | /var/cache/dev/smarty/compile/classic/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.ps_shoppingcartps_shoppingcart.tpl.php |
| 914 | /modules/ps_mainmenu/ps_mainmenu.php |
| 915 | /modules/ps_mainmenu/ps_menutoplinks.class.php |
| 916 | /var/cache/dev/smarty/compile/classic/41/df/19/41df1985130dffd7d3fe4cb369091546a0b40be7_2.module.ps_mainmenups_mainmenu.tpl.php |
| 917 | /var/cache/dev/smarty/compile/classic/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.ps_searchbarps_searchbar.tpl.php |
| 918 | /modules/pagesnotfound/pagesnotfound.php |
| 919 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/1e/09/df/1e09df3ce8dd2fd97424a030609d1924cfb00fef_2.file.notifications.tpl.php |
| 920 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/1b/bc/63/1bbc63d5c323b111a63b8e70f054080de5a08a93_2.file.breadcrumb.tpl.php |
| 921 | /modules/ps_categorytree/ps_categorytree.php |
| 922 | /var/cache/dev/smarty/compile/classic/89/21/00/8921007f54626fc7fe42cbff53f1d70828d3393d_2.module.ps_categorytreeviewstemplateshookps_categorytree.tpl.php |
| 923 | /modules/ps_supplierlist/ps_supplierlist.php |
| 924 | /modules/ps_brandlist/ps_brandlist.php |
| 925 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php |
| 926 | /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php |
| 927 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php |
| 928 | /var/cache/dev/smarty/cache/ps_brandlist/1/1/1/1/2/6/classic/9c/bf/04/9cbf04ab55718c7bff003722fc883d7d9e0b17b0.ps_brandlistviewstemplateshookps_brandlist.tpl.php |
| 929 | /var/cache/dev/smarty/compile/classic/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.ps_facetedsearchps_facetedsearch.tpl.php |
| 930 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a5/1a/cb/a51acb3f90d8446b5b2c090c9607a177b24f5f42_2.file.category-header.tpl.php |
| 931 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/d6/ef/f3/d6eff3a0d405786816408d8821e813a37822cb34_2.file.products-top.tpl.php |
| 932 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/9f/36/04/9f360457127a5fb30400b1f5a5417ad0c17a679a_2.file.sort-orders.tpl.php |
| 933 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/34/9e/8b/349e8bbc865dd6cab3c4fa095935c23d898af6c7_2.file.products.tpl.php |
| 934 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4a/ab/30/4aab30449ad45f88faf385787cc63afb456ed2ad_2.file.productlist.tpl.php |
| 935 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_capture.php |
| 936 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php |
| 937 | /modules/productcomments/src/Repository/ProductCommentRepository.php |
| 938 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepository.php |
| 939 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepositoryInterface.php |
| 940 | /vendor/doctrine/doctrine-bundle/Registry.php |
| 941 | /vendor/symfony/doctrine-bridge/ManagerRegistry.php |
| 942 | /vendor/doctrine/persistence/src/Persistence/AbstractManagerRegistry.php |
| 943 | /vendor/doctrine/persistence/src/Persistence/ManagerRegistry.php |
| 944 | /vendor/doctrine/persistence/src/Persistence/ConnectionRegistry.php |
| 945 | /modules/productcomments/src/Entity/ProductComment.php |
| 946 | /vendor/doctrine/orm/src/Proxy/Proxy.php |
| 947 | /vendor/doctrine/common/src/Proxy/Proxy.php |
| 948 | /vendor/doctrine/persistence/src/Persistence/Proxy.php |
| 949 | /vendor/doctrine/orm/src/Proxy/InternalProxy.php |
| 950 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriverChain.php |
| 951 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/ImplicitlyIgnoredAnnotationNames.php |
| 952 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/IgnoreAnnotation.php |
| 953 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/PhpParser.php |
| 954 | /src/PrestaShopBundle/Service/Database/DoctrineNamingStrategy.php |
| 955 | /vendor/doctrine/orm/src/Mapping/UnderscoreNamingStrategy.php |
| 956 | /vendor/doctrine/orm/src/Mapping/NamingStrategy.php |
| 957 | /vendor/doctrine/orm/src/Mapping/DefaultQuoteStrategy.php |
| 958 | /vendor/doctrine/orm/src/Internal/SQLResultCasing.php |
| 959 | /vendor/doctrine/orm/src/Mapping/QuoteStrategy.php |
| 960 | /vendor/doctrine/doctrine-bundle/Mapping/ContainerEntityListenerResolver.php |
| 961 | /vendor/doctrine/doctrine-bundle/Mapping/EntityListenerServiceResolver.php |
| 962 | /vendor/doctrine/orm/src/Mapping/EntityListenerResolver.php |
| 963 | /vendor/doctrine/doctrine-bundle/Repository/ContainerRepositoryFactory.php |
| 964 | /vendor/doctrine/orm/src/Repository/RepositoryFactory.php |
| 965 | /vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php |
| 966 | /vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php |
| 967 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadataFactory.php |
| 968 | /vendor/doctrine/orm/src/Mapping/ClassMetadata.php |
| 969 | /vendor/doctrine/orm/src/Mapping/ClassMetadataInfo.php |
| 970 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadata.php |
| 971 | /vendor/doctrine/orm/src/Proxy/DefaultProxyClassNameResolver.php |
| 972 | /vendor/doctrine/persistence/src/Persistence/Mapping/ProxyClassNameResolver.php |
| 973 | /vendor/doctrine/orm/src/UnitOfWork.php |
| 974 | /vendor/doctrine/persistence/src/Persistence/PropertyChangedListener.php |
| 975 | /vendor/doctrine/orm/src/Event/ListenersInvoker.php |
| 976 | /vendor/doctrine/orm/src/Utility/IdentifierFlattener.php |
| 977 | /vendor/doctrine/orm/src/Internal/HydrationCompleteHandler.php |
| 978 | /vendor/doctrine/orm/src/Mapping/Reflection/ReflectionPropertiesGetter.php |
| 979 | /vendor/doctrine/persistence/src/Persistence/Mapping/RuntimeReflectionService.php |
| 980 | /vendor/doctrine/persistence/src/Persistence/Mapping/ReflectionService.php |
| 981 | /vendor/doctrine/orm/src/Proxy/ProxyFactory.php |
| 982 | /vendor/doctrine/common/src/Proxy/AbstractProxyFactory.php |
| 983 | /vendor/doctrine/common/src/Proxy/ProxyGenerator.php |
| 984 | /vendor/doctrine/doctrine-bundle/ManagerConfigurator.php |
| 985 | /vendor/doctrine/lexer/src/Token.php |
| 986 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php |
| 987 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/TokenParser.php |
| 988 | /vendor/doctrine/orm/src/Mapping/Table.php |
| 989 | /vendor/doctrine/orm/src/Mapping/MappingAttribute.php |
| 990 | /vendor/doctrine/orm/src/Mapping/Annotation.php |
| 991 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Enum.php |
| 992 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attribute.php |
| 993 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attributes.php |
| 994 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/NamedArgumentConstructor.php |
| 995 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/NamedArgumentConstructorAnnotation.php |
| 996 | /vendor/doctrine/orm/src/Mapping/Entity.php |
| 997 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/Instantiator.php |
| 998 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/InstantiatorInterface.php |
| 999 | /vendor/doctrine/orm/src/Mapping/DefaultTypedFieldMapper.php |
| 1000 | /vendor/doctrine/orm/src/Mapping/TypedFieldMapper.php |
| 1001 | /vendor/doctrine/orm/src/Mapping/Id.php |
| 1002 | /vendor/doctrine/orm/src/Mapping/Column.php |
| 1003 | /vendor/doctrine/orm/src/Mapping/GeneratedValue.php |
| 1004 | /vendor/doctrine/orm/src/Id/IdentityGenerator.php |
| 1005 | /vendor/doctrine/orm/src/Id/AbstractIdGenerator.php |
| 1006 | /vendor/doctrine/orm/src/Events.php |
| 1007 | /vendor/doctrine/persistence/src/Persistence/Reflection/RuntimeReflectionProperty.php |
| 1008 | /vendor/doctrine/dbal/src/Query/QueryBuilder.php |
| 1009 | /vendor/doctrine/dbal/src/Query/Expression/CompositeExpression.php |
| 1010 | /vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php |
| 1011 | /vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php |
| 1012 | /vendor/doctrine/dbal/src/Query/SelectQuery.php |
| 1013 | /vendor/doctrine/dbal/src/Query/Limit.php |
| 1014 | /vendor/doctrine/dbal/src/SQL/Parser.php |
| 1015 | /vendor/doctrine/dbal/src/ExpandArrayParameters.php |
| 1016 | /vendor/doctrine/dbal/src/SQL/Parser/Visitor.php |
| 1017 | /vendor/doctrine/dbal/src/Driver/PDO/Statement.php |
| 1018 | /vendor/doctrine/dbal/src/Driver/Statement.php |
| 1019 | /vendor/doctrine/dbal/src/Driver/PDO/ParameterTypeMap.php |
| 1020 | /vendor/doctrine/dbal/src/Driver/PDO/Result.php |
| 1021 | /vendor/doctrine/dbal/src/Driver/Result.php |
| 1022 | /vendor/doctrine/dbal/src/Result.php |
| 1023 | /vendor/doctrine/dbal/src/FetchMode.php |
| 1024 | /var/cache/dev/smarty/compile/classic/e9/e4/d0/e9e4d0b935584380ea8beb3f467908e1cd2486f5_2.module.productcommentsviewstemplateshookproductlistreviews.tpl.php |
| 1025 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php |
| 1026 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/26/dd/71/26dd71b5d902204dceb16591f45cf7ea05b3b33d_2.file.pagination.tpl.php |
| 1027 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ee/f7/e2/eef7e20ffb2913bfe62b0610181c29528d8e4771_2.file.products-bottom.tpl.php |
| 1028 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/39/09/df/3909df7b52439b05e063d2f877f044830bba50c1_2.file.category-footer.tpl.php |
| 1029 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/16/be/17/16be17aaab473eb4ca068d81e52aab7efa157782_2.file.footer.tpl.php |
| 1030 | /var/cache/dev/smarty/compile/classic/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef_2.module.ps_emailsubscriptionviewstemplateshookps_emailsubscription.tpl.php |
| 1031 | /var/cache/dev/smarty/cache/ps_socialfollow/1/1/1/1/2/6/classic/39/00/03/390003729d747f46c5a6fde1e583b35503112607.ps_socialfollowps_socialfollow.tpl.php |
| 1032 | /modules/ps_linklist/ps_linklist.php |
| 1033 | /var/cache/dev/translations/catalogue.es-ES.NXhscRe.php |
| 1034 | /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php |
| 1035 | /modules/ps_linklist/src/Filter/LinkFilter.php |
| 1036 | /modules/ps_linklist/src/Filter/BestSalesRouteFilter.php |
| 1037 | /modules/ps_linklist/src/Filter/RouteFilterInterface.php |
| 1038 | /modules/ps_linklist/src/LegacyLinkBlockRepository.php |
| 1039 | /var/cache/dev/smarty/cache/ps_linklist/displayFooter/1/1/1/1/2/6/classic/7f/31/9c/7f319c4e7a8a11d4f3731c5d7e5d1fbfcd5233e9.ps_linklistviewstemplateshooklinkblock.tpl.php |
| 1040 | /modules/ps_customeraccountlinks/ps_customeraccountlinks.php |
| 1041 | /var/cache/dev/smarty/cache/ps_customeraccountlinks/1/1/1/1/2/6/classic/47/f3/f6/47f3f62b55c89d7584ea8d8da165da39273fcdd0.ps_customeraccountlinksps_customeraccountlinks.tpl.php |
| 1042 | /var/cache/dev/smarty/compile/classic/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d_2.module.ps_contactinfops_contactinfo.tpl.php |
| 1043 | /vendor/smarty/smarty/libs/plugins/function.mailto.php |
| 1044 | /var/cache/dev/smarty/compile/classic/53/1f/f5/531ff5fadbab34ae9adf28c596f08da4ca8fffe0_2.module.blockwishlistviewstemplateshookdisplayHeader.tpl.php |
| 1045 | /var/cache/dev/smarty/compile/classic/b3/9f/fe/b39ffe0e9a6e5e655319605fb4fac018757bed47_2.module.blockwishlistviewstemplatescomponentsmodalsaddtowishlist.tpl.php |
| 1046 | /var/cache/dev/smarty/compile/classic/f9/93/73/f9937302c902c18a7e92f61a7bb91ac32c58d2fe_2.module.blockwishlistviewstemplatescomponentsmodalsdelete.tpl.php |
| 1047 | /var/cache/dev/smarty/compile/classic/d8/d0/86/d8d086f3098974d41bc92b06c33cf9e584313501_2.module.blockwishlistviewstemplatescomponentsmodalscreate.tpl.php |
| 1048 | /var/cache/dev/smarty/compile/classic/99/ff/6f/99ff6f99ecd074931a71deddfe65081482db8401_2.module.blockwishlistviewstemplatescomponentsmodalslogin.tpl.php |
| 1049 | /var/cache/dev/smarty/compile/classic/a6/cf/26/a6cf26c62a3d814aa3a70f19a62034bfdce54c8a_2.module.blockwishlistviewstemplatescomponentstoast.tpl.php |
| 1050 | /modules/ps_facebook/classes/Handler/MessengerHandler.php |
| 1051 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/11/93/51/119351d12df118629c98e937ac45847552344d0d_2.file.password-policy-template.tpl.php |
| 1052 | /modules/statsdata/statsdata.php |
| 1053 | /classes/Connection.php |
| 1054 | /classes/ConnectionsSource.php |
| 1055 | /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php |
| 1056 | /modules/ps_googleanalytics/classes/Handler/GanalyticsJsHandler.php |
| 1057 | /modules/ps_googleanalytics/classes/Handler/GanalyticsDataHandler.php |
| 1058 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php |
| 1059 | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php |
| 1060 | /modules/ps_googleanalytics/classes/GoogleAnalyticsTools.php |