Art
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
| Load Time | 644.652 ms |
| Querying Time | 77 ms |
| Queries | 227 |
| 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 | 231.766 ms | 231.766 ms | 22.90 Mb | 23.9 Mb |
| __construct | 0.110 ms | 231.876 ms | - Mb | 23.9 Mb |
| init | 43.433 ms | 275.309 ms | 3.26 Mb | 26.2 Mb |
| checkAccess | 0.001 ms | 275.310 ms | - Mb | 26.2 Mb |
| setMedia | 50.288 ms | 325.598 ms | 3.67 Mb | 29.9 Mb |
| postProcess | 0.002 ms | 325.600 ms | - Mb | 29.9 Mb |
| initHeader | 0.002 ms | 325.602 ms | - Mb | 29.9 Mb |
| initContent | 196.792 ms | 522.394 ms | 9.73 Mb | 39.6 Mb |
| initFooter | 0.003 ms | 522.397 ms | - Mb | 39.6 Mb |
| display | 122.255 ms | 644.652 ms | 8.07 Mb | 48.5 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| DisplayHeader | 41.238 ms | 3.98 Mb |
| displayProductListReviews | 39.126 ms | 2.03 Mb |
| ActionFrontControllerSetMedia | 37.756 ms | 2.67 Mb |
| DisplayBeforeBodyClosingTag | 6.479 ms | 0.36 Mb |
| displayLeftColumn | 6.178 ms | 0.33 Mb |
| displayNav2 | 5.987 ms | 0.36 Mb |
| ProductSearchProvider | 3.387 ms | 0.16 Mb |
| displayFooter | 2.996 ms | 0.20 Mb |
| displayTop | 2.968 ms | 0.13 Mb |
| displayNav1 | 2.375 ms | 0.07 Mb |
| DisplayFooter | 2.284 ms | 0.12 Mb |
| displayFooterBefore | 1.728 ms | 0.11 Mb |
| DisplayLeftColumn | 0.341 ms | 0.01 Mb |
| DisplayTop | 0.079 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.009 ms | - Mb |
| DisplayNavFullWidth | 0.007 ms | - Mb |
| DisplayFooterBefore | 0.007 ms | - Mb |
| DisplayFooterAfter | 0.007 ms | - Mb |
| ModuleRoutes | 0.004 ms | - Mb |
| 19 hook(s) | 152.956 ms | 10.53 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| ps_checkout | 57.354 ms | 5.68 Mb |
| blockreassurance | 2.735 ms | 0.22 Mb |
| blockwishlist | 2.996 ms | 0.18 Mb |
| ps_emailsubscription | 3.029 ms | 0.34 Mb |
| ps_socialfollow | 1.543 ms | 0.12 Mb |
| ps_facebook | 18.379 ms | 1.16 Mb |
| ps_emailalerts | 3.360 ms | 0.24 Mb |
| ps_accounts | 2.239 ms | 0.20 Mb |
| ps_shoppingcart | 2.060 ms | 0.13 Mb |
| ps_searchbar | 2.419 ms | 0.08 Mb |
| ps_imageslider | 2.200 ms | 0.21 Mb |
| productcomments | 41.192 ms | 2.22 Mb |
| psshipping | 22.635 ms | 1.81 Mb |
| ps_googleanalytics | 4.211 ms | 0.33 Mb |
| psxmarketingwithgoogle | 4.339 ms | 1.40 Mb |
| ps_facetedsearch | 9.816 ms | 0.62 Mb |
| ps_contactinfo | 4.048 ms | 0.17 Mb |
| ps_languageselector | 1.891 ms | 0.09 Mb |
| ps_currencyselector | 2.668 ms | 0.18 Mb |
| ps_customersignin | 1.286 ms | 0.08 Mb |
| ps_mainmenu | 5.206 ms | 0.34 Mb |
| pagesnotfound | 0.739 ms | 0.05 Mb |
| ps_categorytree | 4.495 ms | 0.25 Mb |
| ps_supplierlist | 1.094 ms | 0.08 Mb |
| ps_brandlist | 2.790 ms | 0.15 Mb |
| ps_linklist | 12.739 ms | 1.93 Mb |
| ps_customeraccountlinks | 1.179 ms | 0.10 Mb |
| statsdata | 3.852 ms | 0.14 Mb |
| 28 module(s) | 222.494 ms | 18.49 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 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=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=20)) GROUP BY pac.id_attribute |
9.258 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 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 = 3 ORDER BY agl.`name` ASC, a.`position` ASC |
3.096 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 84 | 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=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=20)) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>15 AND c.nright<16 GROUP BY cp.id_category |
2.116 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 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) WHERE ((pac.id_attribute=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=20)) |
1.616 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 88 | 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=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=20)) GROUP BY pac.id_attribute |
1.119 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 106 | 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 |
1.038 ms | 374 | /classes/Hook.php:495 | ||
| 105 | 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.015 ms | 0 | /classes/Hook.php:1568 | ||
| 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=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=20)) |
0.985 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 80 | 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=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=20)) AND p.date_add>'2026-02-21 00:00:00' |
0.918 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 16 | 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.899 ms | 150 | Yes | Yes | /classes/Hook.php:1500 |
| 172 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.883 ms | 1 | /classes/module/Module.php:2781 | ||
| 83 | 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.867 ms | 9 | Yes | /classes/Category.php:744 | |
| 95 | 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=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.828 ms | 3 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 81 | 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=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, 1) 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 17:08:18' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-03-12 17:08:18' <= 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=20)) |
0.801 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 91 | 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=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=20)) GROUP BY fp.id_feature_value |
0.786 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 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=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=20)) |
0.784 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 103 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 3 LIMIT 1 |
0.724 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 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=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=20)) GROUP BY fp.id_feature_value |
0.716 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 93 | 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=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=20)) GROUP BY p.id_manufacturer |
0.704 ms | 6 | Yes | /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.701 ms | 510 | /classes/Configuration.php:182 | ||
| 99 | 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=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=20)) GROUP BY pac.id_attribute |
0.686 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 220 | INSERT INTO `dfdu_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('4516', '', 'izzywine.com/en/9-art?q=Brand-Graphic+Corner%2FDimension-60x90cm%2FAvailability-In+stock', '', '2026-03-12 17:08:18') |
0.682 ms | 1 | /classes/ObjectModel.php:535 | ||
| 74 | 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=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.641 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 94 | 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=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=20)) GROUP BY p.condition |
0.638 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 100 | REPLACE INTO dfdu_layered_filter_block (hash, data) VALUES ("76d38b16cb510f7f5b0ed3b96e97fc6c", "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:1:\"$\";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:\"USD\";s:14:\"currencySymbol\";s:1:\"$\";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:4:{s:4:\"name\";s:7:\"40x60cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}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.616 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:209 | ||
| 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) WHERE ((pac.id_attribute=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=20)) |
0.605 ms | 6 | /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) 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.592 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 102 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 0 LIMIT 1 |
0.582 ms | 1 | /classes/SpecificPrice.php:433 | ||
| 177 | 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.582 ms | 9 | Yes | Yes | /classes/Category.php:815 |
| 41 | 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.535 ms | 1 | Yes | Yes | /classes/Category.php:946 |
| 104 | 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.529 ms | 3 | /classes/Product.php:3629 | ||
| 70 | 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.492 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 92 | 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.478 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 101 | 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.478 ms | 3 | /classes/ProductAssembler.php:101 | ||
| 121 | 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.473 ms | 3 | /classes/Product.php:3629 | ||
| 15 | SELECT SQL_NO_CACHE lower(name) as name FROM `dfdu_hook` h WHERE (h.active = 1) |
0.467 ms | 1186 | /classes/Hook.php:1608 | ||
| 18 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` |
0.465 ms | 1186 | /classes/Hook.php:1568 | ||
| 82 | 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 = 1 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=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.456 ms | 3 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 139 | 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 |
0.430 ms | 1 | /classes/Product.php:7216 | ||
| 90 | 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.421 ms | 10 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 203 | 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.413 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 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` = 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.400 ms | 0 | /classes/Cart.php:1450 | ||
| 87 | 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.383 ms | 25 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 71 | 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.355 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 186 | 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.348 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 111 | 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.342 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 147 | 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.340 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 115 | 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.335 ms | 1 | /classes/Product.php:1180 | ||
| 117 | 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.332 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 142 | 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.327 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 68 | 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.326 ms | 4 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 |
| 181 | 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.323 ms | 2 | Yes | /classes/Category.php:1617 | |
| 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 = 1 ORDER BY agl.`name` ASC, a.`position` ASC |
0.322 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 19 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.320 ms | 75 | /classes/module/Module.php:343 | ||
| 196 | 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.312 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 137 | 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.309 ms | 0 | /classes/Cart.php:1450 | ||
| 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` = 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.305 ms | 0 | /classes/Cart.php:1450 | ||
| 21 | 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.304 ms | 43 | Yes | /classes/Dispatcher.php:643 | |
| 107 | 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.303 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 116 | 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.301 ms | 1 | /classes/Product.php:7216 | ||
| 189 | 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.301 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 98 | 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.301 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 130 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 17 |
0.292 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 222 | 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.290 ms | 6 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 | |
| 69 | 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.287 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 | |
| 119 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 14 |
0.285 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 150 | 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.282 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 197 | 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.278 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 204 | 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.278 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 200 | 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.276 ms | 3 | /classes/Product.php:2507 | ||
| 199 | 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.275 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 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.274 ms | 1 | /classes/shop/Shop.php:215 | ||
| 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.270 ms | 1 | Yes | /classes/shop/Shop.php:716 | |
| 114 | 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.268 ms | 0 | /classes/Cart.php:1450 | ||
| 193 | 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.262 ms | 3 | /classes/Product.php:2507 | ||
| 44 | 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.257 ms | 75 | /classes/module/Module.php:343 | ||
| 207 | 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.257 ms | 3 | /classes/Product.php:2507 | ||
| 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.256 ms | 1 | /classes/Language.php:1070 | ||
| 46 | 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.255 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 67 | 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.253 ms | 13 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:57 |
| 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.250 ms | 1 | /classes/Language.php:1204 | ||
| 206 | 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.250 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 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.248 ms | 1 | Yes | /classes/shop/Shop.php:1392 | |
| 58 | 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.248 ms | 2 | Yes | /classes/PrestaShopCollection.php:381 | |
| 128 | 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.247 ms | 1 | /classes/Product.php:7216 | ||
| 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.244 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 178 | 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.239 ms | 1 | /classes/Category.php:2247 | ||
| 22 | 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.238 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 219 | SELECT SQL_NO_CACHE `id_guest` FROM `dfdu_connections` WHERE `id_guest` = 4511 AND `date_add` > '2026-03-12 16:38:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.237 ms | 1 | Yes | /classes/Connection.php:168 | |
| 132 | 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.236 ms | 3 | /classes/Product.php:3629 | ||
| 12 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `iso_code` = 'en' LIMIT 1 |
0.235 ms | 1 | /classes/Language.php:844 | ||
| 154 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_contactinfo" LIMIT 1 |
0.233 ms | 1 | /classes/module/Module.php:2781 | ||
| 192 | 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.233 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 153 | 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.232 ms | 1 | /classes/Cart.php:4072 | ||
| 127 | 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.227 ms | 1 | /classes/Product.php:1180 | ||
| 126 | 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.225 ms | 0 | /classes/Cart.php:1450 | ||
| 198 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 4 AND `id_shop` = 1 |
0.217 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `dfdu_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.216 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 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` = 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.216 ms | 0 | /classes/Cart.php:1450 | ||
| 129 | 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.215 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 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` = 14 ORDER BY ag.`position` ASC, a.`position` ASC |
0.214 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 144 | 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.212 ms | 1 | Yes | /classes/Product.php:3285 | |
| 59 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_facebook" LIMIT 1 |
0.206 ms | 1 | /classes/module/Module.php:2781 | ||
| 20 | SELECT SQL_NO_CACHE name, alias FROM `dfdu_hook_alias` |
0.203 ms | 86 | /classes/Hook.php:371 | ||
| 110 | 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.202 ms | 0 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 148 | 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.202 ms | 1 | Yes | /classes/Product.php:3285 | |
| 162 | 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.199 ms | 1 | Yes | /classes/Currency.php:687 | |
| 72 | 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.198 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 145 | 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.198 ms | 1 | Yes | /classes/Product.php:2668 | |
| 23 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c ORDER BY `iso_code` ASC |
0.195 ms | 1 | Yes | /classes/Currency.php:708 | |
| 66 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.195 ms | 1 | /classes/Category.php:2454 | ||
| 17 | SELECT SQL_NO_CACHE `name`, `alias` FROM `dfdu_hook_alias` |
0.194 ms | 86 | /classes/Hook.php:319 | ||
| 165 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.193 ms | 1 | /classes/module/Module.php:2781 | ||
| 138 | 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.192 ms | 1 | /classes/Product.php:1180 | ||
| 13 | 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.190 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 225 | 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.190 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 188 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.188 ms | 1 | /classes/module/Module.php:2270 | ||
| 125 | 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.188 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 176 | 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.188 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 134 | 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.187 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 75 | SELECT SQL_NO_CACHE data FROM dfdu_layered_filter_block WHERE hash="76d38b16cb510f7f5b0ed3b96e97fc6c" LIMIT 1 |
0.183 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:185 | ||
| 226 | 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.183 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 120 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 4 LIMIT 1 |
0.183 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 179 | 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.181 ms | 1 | /classes/Category.php:1607 | ||
| 10 | SELECT SQL_NO_CACHE domain, domain_ssl FROM dfdu_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.180 ms | 1 | /classes/shop/ShopUrl.php:178 | ||
| 113 | 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.180 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 60 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1 |
0.178 ms | 1 | /classes/module/Module.php:2270 | ||
| 122 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 4 AND `id_group` = 1 LIMIT 1 |
0.178 ms | 0 | /classes/GroupReduction.php:146 | ||
| 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` = 2) LIMIT 1 |
0.177 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 36 | 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.176 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 45 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.176 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 140 | 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.176 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 149 | 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.176 ms | 1 | Yes | /classes/Product.php:2668 | |
| 194 | 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.174 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 205 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 5 AND `id_shop` = 1 |
0.174 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 151 | 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.173 ms | 1 | Yes | /classes/Product.php:3285 | |
| 27 | 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.172 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 152 | 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.169 ms | 1 | Yes | /classes/Product.php:2668 | |
| 157 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.169 ms | 1 | /classes/module/Module.php:2781 | ||
| 170 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_mainmenu" LIMIT 1 |
0.169 ms | 1 | /classes/module/Module.php:2781 | ||
| 47 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.168 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 214 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_linklist" LIMIT 1 |
0.168 ms | 1 | /classes/module/Module.php:2781 | ||
| 167 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.167 ms | 1 | /classes/module/Module.php:2781 | ||
| 131 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 5 LIMIT 1 |
0.166 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 187 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "productcomments" LIMIT 1 |
0.164 ms | 1 | /classes/module/Module.php:2781 | ||
| 190 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 3 AND `id_shop` = 1 |
0.164 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 73 | SELECT SQL_NO_CACHE * FROM `dfdu_category_lang` WHERE `id_category` = 9 AND `id_shop` = 1 |
0.163 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 208 | 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.163 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 221 | SELECT SQL_NO_CACHE data FROM `dfdu_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.162 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39 | ||
| 42 | SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM dfdu_shop s |
0.162 ms | 1 | /classes/shop/Shop.php:922 | ||
| 141 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 20 |
0.161 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 185 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 59 AND `id_shop` = 1 LIMIT 1 |
0.161 ms | 1 | /classes/module/Module.php:2270 | ||
| 118 | 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.161 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `dfdu_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.160 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 43 | SELECT SQL_NO_CACHE * FROM `dfdu_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.160 ms | 1 | /classes/module/Module.php:2171 | ||
| 201 | 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.159 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 218 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.159 ms | 1 | /classes/Country.php:406 | ||
| 63 | 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.158 ms | 1 | /classes/Configuration.php:135 | ||
| 163 | 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.157 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 155 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1 |
0.157 ms | 1 | /classes/module/Module.php:2270 | ||
| 123 | 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.156 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 156 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.156 ms | 1 | /classes/Country.php:406 | ||
| 54 | 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.155 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 210 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.155 ms | 1 | /classes/module/Module.php:2781 | ||
| 109 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_group` WHERE `id_group` = 1 LIMIT 1 |
0.153 ms | 1 | /classes/Group.php:151 | ||
| 169 | SELECT SQL_NO_CACHE SUM(`quantity`) FROM `dfdu_cart_product` WHERE `id_cart` = 0 LIMIT 1 |
0.153 ms | 1 | /classes/Cart.php:1321 | ||
| 57 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM dfdu_required_field |
0.153 ms | 1 | /classes/ObjectModel.php:1437 | ||
| 49 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `suppliers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.152 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 9 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_lang_shop` WHERE `id_lang` = 2 AND id_shop = 1 LIMIT 1 |
0.150 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 108 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 3 AND `id_group` = 1 LIMIT 1 |
0.150 ms | 0 | /classes/GroupReduction.php:146 | ||
| 31 | 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.149 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 133 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1 LIMIT 1 |
0.149 ms | 0 | /classes/GroupReduction.php:146 | ||
| 146 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` |
0.149 ms | 7 | /classes/ImageType.php:161 | ||
| 174 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.149 ms | 1 | /classes/module/Module.php:2781 | ||
| 39 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.148 ms | 1 | /classes/Category.php:2454 | ||
| 61 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.147 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 184 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_brandlist" LIMIT 1 |
0.146 ms | 1 | /classes/module/Module.php:2781 | ||
| 161 | 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.144 ms | 1 | /classes/Currency.php:1120 | ||
| 223 | SELECT SQL_NO_CACHE `name` FROM `dfdu_manufacturer` WHERE `id_manufacturer` = 2 AND `active` = 1 LIMIT 1 |
0.144 ms | 1 | /classes/Manufacturer.php:306 | ||
| 65 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration_lang` WHERE `id_configuration` = 479 |
0.143 ms | 1 | /src/Adapter/EntityMapper.php:82 | ||
| 180 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c WHERE c.`id_category` = 2 LIMIT 1 |
0.143 ms | 1 | /classes/Category.php:1612 | ||
| 24 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.142 ms | 1 | /classes/Language.php:870 | ||
| 143 | 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.142 ms | 1 | /classes/Category.php:1396 | ||
| 166 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.141 ms | 1 | /classes/module/Module.php:2270 | ||
| 182 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_supplierlist" LIMIT 1 |
0.141 ms | 1 | /classes/module/Module.php:2781 | ||
| 48 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `manufacturers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.140 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 52 | SELECT SQL_NO_CACHE format FROM `dfdu_address_format` WHERE `id_country` = 6 LIMIT 1 |
0.140 ms | 1 | /classes/AddressFormat.php:649 | ||
| 164 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 2 |
0.140 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 55 | SELECT SQL_NO_CACHE * FROM `dfdu_country_lang` WHERE `id_country` = 6 |
0.139 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 62 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.139 ms | 1 | /modules/ps_accounts/src/Adapter/Configuration.php:278 | ||
| 209 | 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.139 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 215 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1 |
0.139 ms | 1 | /classes/module/Module.php:2270 | ||
| 25 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.138 ms | 1 | /classes/shop/Shop.php:1211 | ||
| 56 | SELECT SQL_NO_CACHE * FROM `dfdu_state` a WHERE (a.`id_state` = 353) LIMIT 1 |
0.138 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 195 | 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.138 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 202 | 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.138 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 50 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.137 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 136 | 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.136 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 34 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 1 |
0.134 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 40 | 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.134 ms | 1 | /classes/Category.php:1774 | ||
| 28 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.132 ms | 1 | /classes/Language.php:870 | ||
| 38 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.132 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 173 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.132 ms | 1 | /classes/module/Module.php:2270 | ||
| 159 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.132 ms | 1 | /classes/module/Module.php:2781 | ||
| 64 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration` a WHERE (a.`id_configuration` = 479) LIMIT 1 |
0.131 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 51 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `stores` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.130 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 168 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 1 | /classes/module/Module.php:2270 | ||
| 26 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.128 ms | 1 | /classes/Currency.php:893 | ||
| 14 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.127 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 37 | SELECT SQL_NO_CACHE * FROM `dfdu_group_lang` WHERE `id_group` = 1 |
0.127 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 30 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'USD') LIMIT 1 |
0.125 ms | 1 | /classes/Currency.php:893 | ||
| 33 | 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.125 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 213 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.124 ms | 1 | /classes/module/Module.php:2270 | ||
| 175 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.123 ms | 1 | /classes/module/Module.php:2270 | ||
| 191 | 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.123 ms | 0 | /classes/Category.php:1396 | ||
| 211 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.122 ms | 1 | /classes/module/Module.php:2270 | ||
| 53 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.120 ms | 1 | /classes/Country.php:406 | ||
| 183 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 36 AND `id_shop` = 1 LIMIT 1 |
0.119 ms | 1 | /classes/module/Module.php:2270 | ||
| 29 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.118 ms | 1 | /classes/Language.php:870 | ||
| 32 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.118 ms | 1 | /classes/Language.php:870 | ||
| 212 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.118 ms | 1 | /classes/module/Module.php:2781 | ||
| 216 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1 |
0.118 ms | 1 | /classes/module/Module.php:2781 | ||
| 158 | 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 | ||
| 160 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.116 ms | 1 | /classes/module/Module.php:2270 | ||
| 171 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1 |
0.114 ms | 1 | /classes/module/Module.php:2270 | ||
| 35 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.107 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 217 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1 |
0.097 ms | 1 | /classes/module/Module.php:2270 |
| 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=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=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 * FROM `dfdu_lang` a LEFT JOIN `dfdu_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX |
| 2 queries |
SELECT id_shop FROM `dfdu_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX |
| 2 queries |
SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `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=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=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 lang |
| 9 currency |
| 7 currency_shop |
| 7 product_lang |
| 6 lang_shop |
| 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 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: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2] |
| Language | 3 |
/config/config.inc.php:219 (__construct) [id: 2]
/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/1/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/1/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/1/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/1/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 |
