Art
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
Active filters
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
Active filters
| Load Time | 521.037 ms |
| Querying Time | 72 ms |
| Queries | 225 |
| Memory Peak Usage | 48.5 Mb |
| Included Files | 1061 files - 12.79 Mb |
| PrestaShop Cache | - Mb |
| Global vars | 0.14 Mb |
| PrestaShop Version | 9.0.3 |
| PHP Version | 8.4.18 |
| MySQL Version | 10.11.15-MariaDB-log |
| Memory Limit | -1 |
| Max Execution Time | 50000s |
| Smarty Cache | enabled |
| Smarty Compilation | never recompile |
| Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
|---|---|---|---|---|
| config | 158.705 ms | 158.705 ms | 22.89 Mb | 23.9 Mb |
| __construct | 0.052 ms | 158.757 ms | - Mb | 23.9 Mb |
| init | 32.734 ms | 191.491 ms | 3.26 Mb | 26.2 Mb |
| checkAccess | 0.003 ms | 191.494 ms | - Mb | 26.2 Mb |
| setMedia | 36.843 ms | 228.337 ms | 3.67 Mb | 29.9 Mb |
| postProcess | 0.002 ms | 228.339 ms | - Mb | 29.9 Mb |
| initHeader | 0.002 ms | 228.341 ms | - Mb | 29.9 Mb |
| initContent | 174.399 ms | 402.740 ms | 9.73 Mb | 39.6 Mb |
| initFooter | 0.002 ms | 402.742 ms | - Mb | 39.6 Mb |
| display | 118.295 ms | 521.037 ms | 8.07 Mb | 48.5 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| DisplayHeader | 40.160 ms | 3.97 Mb |
| displayProductListReviews | 38.396 ms | 2.03 Mb |
| ActionFrontControllerSetMedia | 25.366 ms | 2.67 Mb |
| DisplayBeforeBodyClosingTag | 6.300 ms | 0.36 Mb |
| displayLeftColumn | 6.033 ms | 0.33 Mb |
| displayNav2 | 5.885 ms | 0.36 Mb |
| displayFooter | 3.402 ms | 0.20 Mb |
| ProductSearchProvider | 3.274 ms | 0.16 Mb |
| DisplayFooter | 2.373 ms | 0.12 Mb |
| displayNav1 | 2.277 ms | 0.07 Mb |
| displayFooterBefore | 2.097 ms | 0.11 Mb |
| displayTop | 2.073 ms | 0.13 Mb |
| DisplayLeftColumn | 0.308 ms | 0.01 Mb |
| DisplayTop | 0.067 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.010 ms | - Mb |
| DisplayFooterAfter | 0.007 ms | - Mb |
| DisplayFooterBefore | 0.007 ms | - Mb |
| DisplayNavFullWidth | 0.006 ms | - Mb |
| ModuleRoutes | 0.004 ms | - Mb |
| 19 hook(s) | 138.045 ms | 10.53 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| ps_checkout | 38.631 ms | 5.68 Mb |
| blockreassurance | 2.103 ms | 0.22 Mb |
| blockwishlist | 2.734 ms | 0.18 Mb |
| ps_emailsubscription | 3.109 ms | 0.34 Mb |
| ps_socialfollow | 1.511 ms | 0.12 Mb |
| ps_facebook | 17.416 ms | 1.16 Mb |
| ps_emailalerts | 2.258 ms | 0.24 Mb |
| ps_accounts | 1.575 ms | 0.20 Mb |
| ps_shoppingcart | 2.386 ms | 0.13 Mb |
| ps_searchbar | 1.412 ms | 0.08 Mb |
| ps_imageslider | 2.587 ms | 0.21 Mb |
| productcomments | 40.792 ms | 2.22 Mb |
| psshipping | 22.103 ms | 1.81 Mb |
| ps_googleanalytics | 4.269 ms | 0.33 Mb |
| psxmarketingwithgoogle | 3.987 ms | 1.40 Mb |
| ps_facetedsearch | 9.648 ms | 0.62 Mb |
| ps_contactinfo | 4.199 ms | 0.17 Mb |
| ps_languageselector | 1.292 ms | 0.09 Mb |
| ps_currencyselector | 2.598 ms | 0.18 Mb |
| ps_customersignin | 1.214 ms | 0.08 Mb |
| ps_mainmenu | 4.205 ms | 0.34 Mb |
| pagesnotfound | 0.653 ms | 0.05 Mb |
| ps_categorytree | 4.500 ms | 0.25 Mb |
| ps_supplierlist | 1.025 ms | 0.08 Mb |
| ps_brandlist | 2.285 ms | 0.15 Mb |
| ps_linklist | 13.086 ms | 1.93 Mb |
| ps_customeraccountlinks | 1.327 ms | 0.10 Mb |
| statsdata | 3.629 ms | 0.14 Mb |
| 28 module(s) | 196.534 ms | 18.49 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 103 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `dfdu_hook_alias` ha INNER JOIN `dfdu_hook` h ON ha.name = h.name |
2.137 ms | 0 | /classes/Hook.php:1568 | ||
| 41 | SELECT SQL_NO_CACHE * FROM `dfdu_hook_module_exceptions` WHERE `id_shop` IN (1) |
1.505 ms | 1 | /classes/module/Module.php:2171 | ||
| 146 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 4 ORDER BY `position` |
1.258 ms | 1 | Yes | /classes/Product.php:3285 | |
| 97 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (20, 21))) GROUP BY pac.id_attribute |
1.079 ms | 24 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 21 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c ORDER BY `iso_code` ASC |
1.077 ms | 1 | Yes | /classes/Currency.php:708 | |
| 76 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) |
1.031 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 175 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `dfdu_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `dfdu_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC |
1.011 ms | 9 | Yes | Yes | /classes/Category.php:815 |
| 78 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND p.date_add>'2026-02-23 00:00:00' |
1.004 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 92 | SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) GROUP BY p.condition |
0.976 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 89 | SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (20, 21))) GROUP BY fp.id_feature_value |
0.959 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 104 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `dfdu_hook_module` hm STRAIGHT_JOIN `dfdu_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `dfdu_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
0.890 ms | 374 | /classes/Hook.php:495 | ||
| 14 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `dfdu_module` m INNER JOIN dfdu_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1) INNER JOIN `dfdu_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `dfdu_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `dfdu_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
0.863 ms | 150 | Yes | Yes | /classes/Hook.php:1500 |
| 91 | SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) GROUP BY p.id_manufacturer |
0.853 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 74 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (20, 21))) |
0.826 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 25 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.800 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 90 | SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `dfdu_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC |
0.769 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 84 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (20, 21))) GROUP BY pac.id_attribute |
0.724 ms | 24 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 82 | SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>15 AND c.nright<16 GROUP BY cp.id_category |
0.716 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 75 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) |
0.690 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 72 | SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) 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.687 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 79 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) 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-14 11:11:55' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-03-14 11:11:55' <= sp.to)
) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (20, 21))) |
0.677 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 2 | SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `dfdu_configuration` c LEFT JOIN `dfdu_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
0.640 ms | 499 | /classes/Configuration.php:182 | ||
| 98 | REPLACE INTO dfdu_layered_filter_block (hash, data) VALUES ("e6a15ead635485f2e6a098142ceb12c9", "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:5:{s:4:\"name\";s:8:\"80x120cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}") |
0.631 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:209 | ||
| 87 | SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (20, 21))) GROUP BY fp.id_feature_value |
0.628 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 218 | INSERT INTO `dfdu_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('6392', '', 'izzywine.com/en/9-art?q=Brand-Graphic+Corner%2FDimension-60x90cm-80x120cm%2FAvailability-In+stock', '', '2026-03-14 11:11:55') |
0.612 ms | 1 | /classes/ObjectModel.php:535 | ||
| 95 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=3)) AND ((sa_1.quantity>0)) GROUP BY pac.id_attribute |
0.611 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 86 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (20, 21))) GROUP BY pac.id_attribute |
0.604 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 165 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.597 ms | 1 | /classes/module/Module.php:2781 | ||
| 77 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='2' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((p.on_sale=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (20, 21))) |
0.589 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 110 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 3 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 3 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.574 ms | 0 | /classes/Cart.php:1450 | ||
| 69 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC |
0.560 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 39 | SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_description` FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `dfdu_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 9 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.547 ms | 1 | Yes | Yes | /classes/Category.php:946 |
| 202 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) LIMIT 1 |
0.530 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 68 | SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `dfdu_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC |
0.514 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 100 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 0 LIMIT 1 |
0.513 ms | 1 | /classes/SpecificPrice.php:433 | ||
| 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.508 ms | 1 | Yes | /classes/shop/Shop.php:1392 | |
| 191 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (13,14,15) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.489 ms | 3 | /classes/Product.php:2507 | ||
| 16 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` |
0.449 ms | 1186 | /classes/Hook.php:1568 | ||
| 13 | SELECT SQL_NO_CACHE lower(name) as name FROM `dfdu_hook` h WHERE (h.active = 1) |
0.444 ms | 1186 | /classes/Hook.php:1608 | ||
| 99 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-03-14 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.438 ms | 3 | /classes/ProductAssembler.php:101 | ||
| 154 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.435 ms | 1 | /classes/Country.php:406 | ||
| 184 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (3) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.435 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 80 | SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM dfdu_product p INNER JOIN dfdu_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 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 IN (20, 21))) 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.422 ms | 3 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 148 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) AND (b.`id_shop` = 1) LIMIT 1 |
0.420 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 93 | SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM dfdu_product p INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (20, 21))) 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.412 ms | 3 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 94 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC |
0.408 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 36 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.404 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 96 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC |
0.399 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 102 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 3) |
0.394 ms | 3 | /classes/Product.php:3629 | ||
| 204 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 5 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.391 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 83 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC |
0.388 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 133 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.386 ms | 0 | /classes/Cart.php:1450 | ||
| 113 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 3 AND pa.`id_product` = 3 AND pa.`id_product_attribute` = 14 LIMIT 1 |
0.374 ms | 1 | /classes/Product.php:1180 | ||
| 85 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC |
0.369 ms | 25 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 88 | SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `dfdu_feature_value` v LEFT JOIN `dfdu_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 1 ORDER BY vl.`value` ASC |
0.368 ms | 10 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 123 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 17) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.360 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 168 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_mainmenu" LIMIT 1 |
0.358 ms | 1 | /classes/module/Module.php:2781 | ||
| 67 | SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `dfdu_feature` f INNER JOIN dfdu_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `dfdu_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `dfdu_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC |
0.348 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 | |
| 65 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM dfdu_layered_category WHERE controller = 'category' AND id_category = 9 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.346 ms | 13 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:57 |
| 66 | SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `dfdu_attribute_group` ag INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `dfdu_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC |
0.343 ms | 4 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 |
| 40 | SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM dfdu_shop s |
0.341 ms | 1 | /classes/shop/Shop.php:922 | ||
| 106 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 3 AND `id_group` = 1 LIMIT 1 |
0.340 ms | 0 | /classes/GroupReduction.php:146 | ||
| 121 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.340 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 126 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 4 AND pac.`id_product_attribute` = 17 AND agl.`id_lang` = 1 |
0.336 ms | 1 | /classes/Product.php:7216 | ||
| 162 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 2 |
0.329 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 129 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 5 LIMIT 1 |
0.325 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 112 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 14 AND cp.`id_cart` = 0 AND cp.`id_product` = 3 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 14 AND cp.`id_cart` = 0 AND p.`id_product_item` = 3 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.324 ms | 0 | /classes/Cart.php:1450 | ||
| 127 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 17) LIMIT 1 |
0.324 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 194 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.323 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 187 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3) LIMIT 1 |
0.321 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 19 | SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `dfdu_meta` m LEFT JOIN `dfdu_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.315 ms | 43 | Yes | /classes/Dispatcher.php:643 | |
| 144 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` |
0.307 ms | 7 | /classes/ImageType.php:161 | ||
| 188 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 3 AND `id_shop` = 1 |
0.305 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 190 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 3 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.305 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 201 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (5) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.304 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 134 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 20) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.303 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 145 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4) AND (b.`id_shop` = 1) LIMIT 1 |
0.302 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 20 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1 |
0.301 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 118 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 4 LIMIT 1 |
0.296 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 119 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 4) |
0.281 ms | 3 | /classes/Product.php:3629 | ||
| 220 | SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `dfdu_category_product` cp LEFT JOIN `dfdu_category` c ON (c.id_category = cp.id_category) LEFT JOIN `dfdu_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (3,4,5) AND cl.`id_lang` = 1 ORDER BY c.`level_depth` DESC |
0.281 ms | 6 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 | |
| 142 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 3 ORDER BY `position` |
0.277 ms | 1 | Yes | /classes/Product.php:3285 | |
| 195 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4) LIMIT 1 |
0.277 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 37 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.276 ms | 1 | /classes/Category.php:2454 | ||
| 150 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 5 AND il.`id_lang` = 1 ORDER by i.`position` |
0.275 ms | 1 | Yes | /classes/Product.php:2668 | |
| 205 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (19,20,21) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.269 ms | 3 | /classes/Product.php:2507 | ||
| 181 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 36 AND `id_shop` = 1 LIMIT 1 |
0.268 ms | 1 | /classes/module/Module.php:2270 | ||
| 209 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.267 ms | 1 | /classes/module/Module.php:2270 | ||
| 17 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.266 ms | 75 | /classes/module/Module.php:343 | ||
| 117 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 14 |
0.266 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 197 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 4 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.266 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 198 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (16,17,18) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.265 ms | 3 | /classes/Product.php:2507 | ||
| 140 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3) AND (b.`id_shop` = 1) LIMIT 1 |
0.263 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 115 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 9
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.262 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 122 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 4 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.254 ms | 0 | /classes/Cart.php:1450 | ||
| 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.252 ms | 1 | /classes/Language.php:1204 | ||
| 114 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 3 AND pac.`id_product_attribute` = 14 AND agl.`id_lang` = 1 |
0.251 ms | 1 | /classes/Product.php:7216 | ||
| 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.247 ms | 1 | /classes/Language.php:1070 | ||
| 135 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 20 AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 20 AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.247 ms | 0 | /classes/Cart.php:1450 | ||
| 18 | SELECT SQL_NO_CACHE name, alias FROM `dfdu_hook_alias` |
0.243 ms | 86 | /classes/Hook.php:371 | ||
| 124 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 17 AND cp.`id_cart` = 0 AND cp.`id_product` = 4 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 17 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.242 ms | 0 | /classes/Cart.php:1450 | ||
| 105 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 9
AND tr.`id_state` IN (0, 353)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.241 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 137 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 5 AND pac.`id_product_attribute` = 20 AND agl.`id_lang` = 1 |
0.241 ms | 1 | /classes/Product.php:7216 | ||
| 56 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a0 LEFT JOIN `dfdu_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 15) AND (a0.`nright` > 16) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.238 ms | 2 | Yes | /classes/PrestaShopCollection.php:381 | |
| 200 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 18) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.238 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 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.237 ms | 1 | Yes | /classes/shop/Shop.php:716 | |
| 179 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 15 AND c.`nright` >= 16 AND c.`nleft` >= 2 AND c.`nright` <= 17 ORDER BY `nleft` DESC |
0.237 ms | 2 | Yes | /classes/Category.php:1617 | |
| 81 | SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position |
0.236 ms | 9 | Yes | /classes/Category.php:744 | |
| 42 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.234 ms | 75 | /classes/module/Module.php:343 | ||
| 138 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 20) LIMIT 1 |
0.234 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 34 | SELECT SQL_NO_CACHE * FROM `dfdu_group` a LEFT JOIN `dfdu_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.232 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 185 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "productcomments" LIMIT 1 |
0.232 ms | 1 | /classes/module/Module.php:2781 | ||
| 222 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 14 ORDER BY ag.`position` ASC, a.`position` ASC |
0.225 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 70 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) LIMIT 1 |
0.223 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 217 | SELECT SQL_NO_CACHE `id_guest` FROM `dfdu_connections` WHERE `id_guest` = 6387 AND `date_add` > '2026-03-14 10:41:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.223 ms | 1 | Yes | /classes/Connection.php:168 | |
| 44 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1 |
0.222 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 73 | SELECT SQL_NO_CACHE data FROM dfdu_layered_filter_block WHERE hash="e6a15ead635485f2e6a098142ceb12c9" LIMIT 1 |
0.222 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:185 | ||
| 206 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 19) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.220 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 125 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 4 AND pa.`id_product` = 4 AND pa.`id_product_attribute` = 17 LIMIT 1 |
0.218 ms | 1 | /classes/Product.php:1180 | ||
| 131 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1 LIMIT 1 |
0.218 ms | 0 | /classes/GroupReduction.php:146 | ||
| 176 | SELECT SQL_NO_CACHE DISTINCT c.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1) WHERE `level_depth` = 1 |
0.218 ms | 1 | /classes/Category.php:2247 | ||
| 163 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.217 ms | 1 | /classes/module/Module.php:2781 | ||
| 54 | SELECT SQL_NO_CACHE * FROM `dfdu_state` a WHERE (a.`id_state` = 353) LIMIT 1 |
0.217 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 160 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c INNER JOIN dfdu_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC |
0.216 ms | 1 | Yes | /classes/Currency.php:687 | |
| 151 | SELECT SQL_NO_CACHE 1 FROM dfdu_cart_product cp INNER JOIN dfdu_product p ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1 |
0.213 ms | 1 | /classes/Cart.php:4072 | ||
| 136 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 5 AND pa.`id_product` = 5 AND pa.`id_product_attribute` = 20 LIMIT 1 |
0.212 ms | 1 | /classes/Product.php:1180 | ||
| 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.209 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 174 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.206 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 223 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 17 ORDER BY ag.`position` ASC, a.`position` ASC |
0.205 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 203 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 5 AND `id_shop` = 1 |
0.204 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 147 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 4 AND il.`id_lang` = 1 ORDER by i.`position` |
0.201 ms | 1 | Yes | /classes/Product.php:2668 | |
| 224 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 20 ORDER BY ag.`position` ASC, a.`position` ASC |
0.201 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 116 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 14) LIMIT 1 |
0.199 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 8 | SELECT SQL_NO_CACHE * FROM `dfdu_lang` a LEFT JOIN `dfdu_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.198 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 212 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_linklist" LIMIT 1 |
0.197 ms | 1 | /classes/module/Module.php:2781 | ||
| 216 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.197 ms | 1 | /classes/Country.php:406 | ||
| 196 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 4 AND `id_shop` = 1 |
0.194 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 132 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.193 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 149 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 5 ORDER BY `position` |
0.192 ms | 1 | Yes | /classes/Product.php:3285 | |
| 199 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 16) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.191 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 57 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_facebook" LIMIT 1 |
0.182 ms | 1 | /classes/module/Module.php:2781 | ||
| 215 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1 |
0.182 ms | 1 | /classes/module/Module.php:2270 | ||
| 10 | SELECT SQL_NO_CACHE domain, domain_ssl FROM dfdu_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.181 ms | 1 | /classes/shop/ShopUrl.php:178 | ||
| 45 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.181 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 143 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 3 AND il.`id_lang` = 1 ORDER by i.`position` |
0.179 ms | 1 | Yes | /classes/Product.php:2668 | |
| 173 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.177 ms | 1 | /classes/module/Module.php:2270 | ||
| 26 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.175 ms | 1 | /classes/Language.php:870 | ||
| 130 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 5) |
0.175 ms | 3 | /classes/Product.php:3629 | ||
| 53 | SELECT SQL_NO_CACHE * FROM `dfdu_country_lang` WHERE `id_country` = 6 |
0.174 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 15 | SELECT SQL_NO_CACHE `name`, `alias` FROM `dfdu_hook_alias` |
0.173 ms | 86 | /classes/Hook.php:319 | ||
| 33 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.172 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 161 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.172 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 192 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 13) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.170 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 207 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 21) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.169 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 152 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_contactinfo" LIMIT 1 |
0.168 ms | 1 | /classes/module/Module.php:2781 | ||
| 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.166 ms | 1 | /classes/shop/Shop.php:215 | ||
| 61 | SELECT SQL_NO_CACHE `id_configuration` FROM `dfdu_configuration` WHERE name = 'PS_ACCOUNTS_SHOP_STATUS' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1 |
0.166 ms | 1 | /classes/Configuration.php:135 | ||
| 59 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.165 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 108 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 353)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.165 ms | 0 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 64 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.164 ms | 1 | /classes/Category.php:2454 | ||
| 193 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 15) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.164 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 71 | 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 | ||
| 29 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.162 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 128 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 17 |
0.162 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 111 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 14) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.161 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 28 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'USD') LIMIT 1 |
0.160 ms | 1 | /classes/Currency.php:893 | ||
| 186 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.160 ms | 1 | /classes/module/Module.php:2270 | ||
| 221 | SELECT SQL_NO_CACHE `name` FROM `dfdu_manufacturer` WHERE `id_manufacturer` = 2 AND `active` = 1 LIMIT 1 |
0.158 ms | 1 | /classes/Manufacturer.php:306 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `dfdu_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.157 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 31 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.156 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 219 | SELECT SQL_NO_CACHE data FROM `dfdu_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.156 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `dfdu_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.155 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 210 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.155 ms | 1 | /classes/module/Module.php:2781 | ||
| 167 | SELECT SQL_NO_CACHE SUM(`quantity`) FROM `dfdu_cart_product` WHERE `id_cart` = 0 LIMIT 1 |
0.154 ms | 1 | /classes/Cart.php:1321 | ||
| 208 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.153 ms | 1 | /classes/module/Module.php:2781 | ||
| 52 | SELECT SQL_NO_CACHE * FROM `dfdu_country` a LEFT JOIN `dfdu_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 6) LIMIT 1 |
0.152 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 159 | SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `dfdu_currency` c LEFT JOIN dfdu_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1 |
0.151 ms | 1 | /classes/Currency.php:1120 | ||
| 177 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 9 LIMIT 1 |
0.150 ms | 1 | /classes/Category.php:1607 | ||
| 170 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.149 ms | 1 | /classes/module/Module.php:2781 | ||
| 60 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.148 ms | 1 | /modules/ps_accounts/src/Adapter/Configuration.php:278 | ||
| 189 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.148 ms | 0 | /classes/Category.php:1396 | ||
| 35 | SELECT SQL_NO_CACHE * FROM `dfdu_group_lang` WHERE `id_group` = 1 |
0.147 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 46 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `manufacturers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.147 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 12 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `iso_code` = 'en' LIMIT 1 |
0.146 ms | 1 | /classes/Language.php:844 | ||
| 23 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.144 ms | 1 | /classes/shop/Shop.php:1211 | ||
| 139 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 20 |
0.143 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 213 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1 |
0.143 ms | 1 | /classes/module/Module.php:2270 | ||
| 169 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1 |
0.142 ms | 1 | /classes/module/Module.php:2270 | ||
| 55 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM dfdu_required_field |
0.142 ms | 1 | /classes/ObjectModel.php:1437 | ||
| 214 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1 |
0.142 ms | 1 | /classes/module/Module.php:2781 | ||
| 157 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.141 ms | 1 | /classes/module/Module.php:2781 | ||
| 43 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.140 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 47 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `suppliers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.139 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 141 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.139 ms | 1 | /classes/Category.php:1396 | ||
| 172 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2781 | ||
| 180 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_supplierlist" LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2781 | ||
| 62 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration` a WHERE (a.`id_configuration` = 479) LIMIT 1 |
0.136 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 211 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.136 ms | 1 | /classes/module/Module.php:2270 | ||
| 48 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.135 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 101 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 3 LIMIT 1 |
0.135 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 50 | SELECT SQL_NO_CACHE format FROM `dfdu_address_format` WHERE `id_country` = 6 LIMIT 1 |
0.135 ms | 1 | /classes/AddressFormat.php:649 | ||
| 109 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.132 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 58 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1 |
0.131 ms | 1 | /classes/module/Module.php:2270 | ||
| 32 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 1 |
0.130 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 22 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.129 ms | 1 | /classes/Language.php:870 | ||
| 153 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 1 | /classes/module/Module.php:2270 | ||
| 30 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.128 ms | 1 | /classes/Language.php:870 | ||
| 182 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_brandlist" LIMIT 1 |
0.127 ms | 1 | /classes/module/Module.php:2781 | ||
| 49 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `stores` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.127 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 63 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration_lang` WHERE `id_configuration` = 479 |
0.126 ms | 1 | /src/Adapter/EntityMapper.php:82 | ||
| 171 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.126 ms | 1 | /classes/module/Module.php:2270 | ||
| 120 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 4 AND `id_group` = 1 LIMIT 1 |
0.126 ms | 0 | /classes/GroupReduction.php:146 | ||
| 24 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.125 ms | 1 | /classes/Currency.php:893 | ||
| 9 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.124 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 164 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.124 ms | 1 | /classes/module/Module.php:2270 | ||
| 38 | SELECT SQL_NO_CACHE ctg.`id_group` FROM dfdu_category_group ctg WHERE ctg.`id_category` = 9 AND ctg.`id_group` = 1 LIMIT 1 |
0.123 ms | 1 | /classes/Category.php:1774 | ||
| 155 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.122 ms | 1 | /classes/module/Module.php:2781 | ||
| 183 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 59 AND `id_shop` = 1 LIMIT 1 |
0.122 ms | 1 | /classes/module/Module.php:2270 | ||
| 27 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.121 ms | 1 | /classes/Language.php:870 | ||
| 166 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.117 ms | 1 | /classes/module/Module.php:2270 | ||
| 158 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.115 ms | 1 | /classes/module/Module.php:2270 | ||
| 107 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_group` WHERE `id_group` = 1 LIMIT 1 |
0.112 ms | 1 | /classes/Group.php:151 | ||
| 178 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c WHERE c.`id_category` = 2 LIMIT 1 |
0.111 ms | 1 | /classes/Category.php:1612 | ||
| 51 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.108 ms | 1 | /classes/Country.php:406 | ||
| 156 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.107 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 IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((a.id_attribute_group=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY pac.id_attribute
|
| 3 queries |
SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX) |
| 3 queries |
SELECT tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = XX
AND tr.`id_country` = XX
AND tr.`id_tax_rules_group` = XX
AND tr.`id_state` IN (XX, XX)
AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
|
| 3 queries |
SELECT `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
| 3 queries |
SELECT pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
|
| 3 queries |
SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `dfdu_attribute` a
LEFT JOIN `dfdu_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `dfdu_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `dfdu_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
LEFT JOIN `dfdu_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX)
LEFT JOIN `dfdu_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
WHERE pa.`id_product` = XX
AND pac.`id_product_attribute` = XX
AND agl.`id_lang` = XX
|
| 3 queries |
SELECT * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX |
| 3 queries |
SELECT * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = XX |
| 3 queries |
SELECT * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX |
| 3 queries |
SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `dfdu_image` i
INNER JOIN dfdu_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
WHERE i.`id_product` = XX
ORDER BY `position`
|
| 3 queries |
SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `dfdu_product_attribute_image` pai
LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
|
| 3 queries |
SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `dfdu_product_attribute` pa
INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
|
| 3 queries |
SELECT * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX |
| 3 queries |
SELECT * FROM `dfdu_product_lang` WHERE `id_product` = XX AND `id_shop` = XX |
| 3 queries |
SELECT pa.*, product_attribute_shop.*
FROM `dfdu_product_attribute` pa
INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
WHERE pa.`id_product` = XX
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
|
| 3 queries |
SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `dfdu_product_attribute_combination` pac
LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
WHERE pac.id_product_attribute IN (XX,XX,XX)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
|
| 3 queries |
SELECT al.`name` AS attribute_name
FROM `dfdu_product_attribute_combination` pac
LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `dfdu_attribute_lang` al ON (
a.`id_attribute` = al.`id_attribute`
AND al.`id_lang` = XX
)
WHERE pac.`id_product_attribute` = XX
ORDER BY ag.`position` ASC, a.`position` ASC
|
| 2 queries |
SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `dfdu_module` m
LEFT JOIN `dfdu_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = XX
|
| 2 queries |
SELECT value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX |
| 2 queries |
SELECT * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX |
| 2 queries |
SELECT * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX |
| 2 queries |
SELECT * FROM `dfdu_currency_lang` WHERE `id_currency` = XX |
| 2 queries |
SELECT `id_category` FROM `dfdu_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX |
| 2 queries |
SELECT `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT XX |
| 2 queries |
SELECT m.*, ml.`description`, ml.`short_description`
FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `dfdu_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
|
| 2 queries |
SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY fp.id_feature_value
|
| 2 queries |
SELECT cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX |
| 73 product_attribute_combination |
| 49 product_attribute |
| 47 stock_available |
| 38 product |
| 33 category |
| 32 product_shop |
| 22 module |
| 22 category_group |
| 21 attribute |
| 21 category_product |
| 19 module_shop |
| 18 product_attribute_shop |
| 17 attribute_lang |
| 16 product_sale |
| 15 attribute_group |
| 14 category_lang |
| 14 cart_product |
| 12 attribute_group_lang |
| 10 category_shop |
| 9 currency |
| 8 lang |
| 7 currency_shop |
| 7 product_lang |
| 6 hook |
| 6 image_type |
| 6 attribute_group_shop |
| 6 pack |
| 6 product_attribute_lang |
| 6 image |
| 6 image_lang |
| 5 shop |
| 5 configuration |
| 5 country |
| 5 attribute_shop |
| 5 layered_indexable_attribute_lang_value |
| 5 specific_price |
| 4 shop_url |
| 4 lang_shop |
| 4 currency_lang |
| 3 hook_alias |
| 3 manufacturer |
| 3 tax_rule |
| 3 tax_rules_group |
| 3 product_group_reduction_cache |
| 3 image_shop |
| 3 product_attribute_image |
| 2 shop_group |
| 2 configuration_lang |
| 2 country_lang |
| 2 country_shop |
| 2 hook_module |
| 2 group |
| 2 group_shop |
| 2 manufacturer_shop |
| 2 manufacturer_lang |
| 2 feature_product |
| 1 module_group |
| 1 meta |
| 1 meta_lang |
| 1 group_lang |
| 1 hook_module_exceptions |
| 1 address_format |
| 1 state |
| 1 required_field |
| 1 layered_category |
| 1 layered_indexable_attribute_group |
| 1 layered_indexable_attribute_group_lang_value |
| 1 feature |
| 1 feature_shop |
| 1 feature_lang |
| 1 layered_indexable_feature |
| 1 layered_indexable_feature_lang_value |
| 1 layered_filter_block |
| 1 layered_price_index |
| 1 feature_value |
| 1 feature_value_lang |
| 1 layered_indexable_feature_value_lang_value |
| 1 connections |
| 1 ganalytics_data |
| Name | Instances | Source |
|---|---|---|
| Category | 17 |
/controllers/front/listing/CategoryController.php:87 (__construct) [id: 9]
/classes/Meta.php:364 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 9] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /src/Adapter/Presenter/Category/CategoryLazyArray.php:112 (__construct) [id: 9] |
| Product | 9 |
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 3]
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 5] /classes/Link.php:114 (__construct) [id: 3] /classes/Link.php:114 (__construct) [id: 4] /classes/Link.php:114 (__construct) [id: 5] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 3] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 4] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 5] |
| Country | 7 |
/config/config.inc.php:154 (__construct) [id: 6]
/classes/AddressFormat.php:402 (__construct) [id: 6] /classes/controller/FrontController.php:1739 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] |
| State | 5 |
/classes/controller/FrontController.php:1738 (__construct) [id: 353]
/modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353] |
| Address | 4 |
/classes/shop/Shop.php:487 (__construct) [id: ]
/classes/Product.php:3454 (initialize) [id: ] /classes/Product.php:3573 (__construct) [id: ] /classes/Product.php:5723 (__construct) [id: ] |
| Currency | 4 |
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2]
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:708 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2] |
| Language | 3 |
/config/config.inc.php:219 (__construct) [id: 1]
/classes/Tools.php:659 (__construct) [id: 1] /classes/Tools.php:553 (__construct) [id: 1] |
| Combination | 3 |
/classes/Product.php:5671 (__construct) [id: 14]
/classes/Product.php:5671 (__construct) [id: 17] /classes/Product.php:5671 (__construct) [id: 20] |
| AddressFormat | 3 |
/classes/controller/FrontController.php:1733 (generateAddress) [id: ]
/modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] |
| Shop | 1 |
/config/config.inc.php:122 (initialize) [id: 1]
|
| Configuration | 1 |
/modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 479]
|
| Gender | 1 |
/classes/controller/FrontController.php:1656 (__construct) [id: 0]
|
| Risk | 1 |
/classes/controller/FrontController.php:1659 (__construct) [id: ]
|
| Group | 1 |
/classes/Cart.php:275 (getCurrent) [id: 1]
|
| Cart | 1 |
/classes/controller/FrontController.php:459 (__construct) [id: ]
|
| Customer | 1 |
/config/config.inc.php:272 (__construct) [id: ]
|
| ShopGroup | 1 |
/classes/shop/Shop.php:562 (__construct) [id: 1]
|
| ConnectionsSource | 1 |
/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
|
| # | Filename |
|---|---|
| 0 | /index.php |
| 1 | /config/config.inc.php |
| 2 | /config/defines.inc.php |
| 3 | /config/autoload.php |
| 4 | /vendor/autoload.php |
| 5 | /vendor/composer/autoload_real.php |
| 6 | /vendor/composer/platform_check.php |
| 7 | /vendor/composer/ClassLoader.php |
| 8 | /vendor/composer/autoload_static.php |
| 9 | /vendor/symfony/deprecation-contracts/function.php |
| 10 | /vendor/symfony/polyfill-mbstring/bootstrap.php |
| 11 | /vendor/symfony/polyfill-mbstring/bootstrap80.php |
| 12 | /vendor/symfony/polyfill-ctype/bootstrap.php |
| 13 | /vendor/symfony/polyfill-ctype/bootstrap80.php |
| 14 | /vendor/symfony/polyfill-php83/bootstrap.php |
| 15 | /vendor/symfony/var-dumper/Resources/functions/dump.php |
| 16 | /vendor/symfony/polyfill-intl-normalizer/bootstrap.php |
| 17 | /vendor/symfony/polyfill-intl-normalizer/bootstrap80.php |
| 18 | /vendor/twig/twig/src/Resources/core.php |
| 19 | /vendor/twig/twig/src/Resources/debug.php |
| 20 | /vendor/twig/twig/src/Resources/escaper.php |
| 21 | /vendor/twig/twig/src/Resources/string_loader.php |
| 22 | /vendor/symfony/polyfill-intl-grapheme/bootstrap.php |
| 23 | /vendor/symfony/polyfill-intl-grapheme/bootstrap80.php |
| 24 | /vendor/symfony/string/Resources/functions.php |
| 25 | /vendor/symfony/polyfill-intl-idn/bootstrap.php |
| 26 | /vendor/symfony/clock/Resources/now.php |
| 27 | /vendor/symfony/polyfill-php80/bootstrap.php |
| 28 | /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php |
| 29 | /vendor/jakeasmith/http_build_url/src/http_build_url.php |
| 30 | /vendor/symfony/polyfill-intl-icu/bootstrap.php |
| 31 | /vendor/ircmaxell/password-compat/lib/password.php |
| 32 | /vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php |
| 33 | /vendor/symfony/polyfill-php73/bootstrap.php |
| 34 | /vendor/symfony/translation/Resources/functions.php |
| 35 | /src/Core/Version.php |
| 36 | /config/alias.php |
| 37 | /vendor/prestashop/autoload/src/PrestashopAutoload.php |
| 38 | /vendor/prestashop/autoload/src/LegacyClassLoader.php |
| 39 | /vendor/symfony/filesystem/Filesystem.php |
| 40 | /vendor/prestashop/autoload/src/Autoloader.php |
| 41 | /config/bootstrap.php |
| 42 | /src/Core/ContainerBuilder.php |
| 43 | /src/Core/Foundation/IoC/Container.php |
| 44 | /src/Adapter/ServiceLocator.php |
| 45 | /var/cache/dev/appParameters.php |
| 48 | /var/cache/dev/class_index.php |
| 49 | /classes/controller/Controller.php |
| 51 | /classes/ObjectModel.php |
| 52 | /src/Core/Foundation/Database/EntityInterface.php |
| 54 | /classes/db/Db.php |
| 56 | /classes/Hook.php |
| 58 | /classes/module/Module.php |
| 59 | /src/Core/Module/Legacy/ModuleInterface.php |
| 61 | /classes/Tools.php |
| 62 | /classes/Context.php |
| 63 | /classes/shop/Shop.php |
| 64 | /src/Core/Security/PasswordGenerator.php |
| 65 | /classes/db/DbPDO.php |
| 66 | /classes/AddressFormat.php |
| 67 | /classes/Configuration.php |
| 68 | /src/Core/Domain/Shop/ValueObject/ShopConstraint.php |
| 69 | /classes/Validate.php |
| 70 | /src/PrestaShopBundle/Form/Admin/Type/FormattedTextareaType.php |
| 71 | /src/PrestaShopBundle/Form/Admin/Type/TranslatorAwareType.php |
| 72 | /src/PrestaShopBundle/Form/Admin/Type/CommonAbstractType.php |
| 73 | /vendor/symfony/form/AbstractType.php |
| 74 | /vendor/symfony/form/FormTypeInterface.php |
| 75 | /classes/cache/Cache.php |
| 76 | /src/Adapter/EntityMapper.php |
| 77 | /classes/db/DbQuery.php |
| 78 | /src/Core/Addon/Theme/ThemeManagerBuilder.php |
| 79 | /vendor/psr/log/src/NullLogger.php |
| 80 | /vendor/psr/log/src/AbstractLogger.php |
| 81 | /vendor/psr/log/src/LoggerTrait.php |
| 82 | /vendor/psr/log/src/LoggerInterface.php |
| 83 | /src/Core/Context/ApiClientContext.php |
| 84 | /src/Adapter/Configuration.php |
| 85 | /vendor/symfony/http-foundation/ParameterBag.php |
| 86 | /src/Core/Domain/Configuration/ShopConfigurationInterface.php |
| 87 | /src/Core/ConfigurationInterface.php |
| 88 | /src/Core/Addon/Theme/ThemeRepository.php |
| 89 | /src/Core/Addon/AddonRepositoryInterface.php |
| 90 | /src/Core/Addon/Theme/Theme.php |
| 91 | /src/Core/Addon/AddonInterface.php |
| 92 | /src/Core/Util/ArrayFinder.php |
| 93 | /vendor/symfony/property-access/PropertyAccess.php |
| 94 | /vendor/symfony/property-access/PropertyAccessorBuilder.php |
| 95 | /vendor/symfony/property-access/PropertyAccessor.php |
| 96 | /vendor/symfony/property-access/PropertyAccessorInterface.php |
| 97 | /vendor/symfony/property-info/Extractor/ReflectionExtractor.php |
| 98 | /vendor/symfony/property-info/PropertyListExtractorInterface.php |
| 99 | /vendor/symfony/property-info/PropertyTypeExtractorInterface.php |
| 100 | /vendor/symfony/property-info/PropertyAccessExtractorInterface.php |
| 101 | /vendor/symfony/property-info/PropertyInitializableExtractorInterface.php |
| 102 | /vendor/symfony/property-info/PropertyReadInfoExtractorInterface.php |
| 103 | /vendor/symfony/property-info/PropertyWriteInfoExtractorInterface.php |
| 104 | /vendor/symfony/property-info/Extractor/ConstructorArgumentTypeExtractorInterface.php |
| 105 | /vendor/symfony/property-info/Type.php |
| 106 | /vendor/symfony/string/Inflector/EnglishInflector.php |
| 107 | /vendor/symfony/string/Inflector/InflectorInterface.php |
| 108 | /vendor/symfony/property-access/PropertyPath.php |
| 109 | /vendor/symfony/property-access/PropertyPathInterface.php |
| 110 | /vendor/symfony/property-access/PropertyPathIteratorInterface.php |
| 111 | /config/defines_uri.inc.php |
| 112 | /classes/Language.php |
| 113 | /src/Core/Language/LanguageInterface.php |
| 114 | /classes/Country.php |
| 115 | /classes/PrestaShopCollection.php |
| 116 | /classes/shop/ShopGroup.php |
| 117 | /classes/Cookie.php |
| 118 | /src/Core/Http/CookieOptions.php |
| 119 | /classes/PhpEncryption.php |
| 120 | /classes/PhpEncryptionEngine.php |
| 121 | /vendor/defuse/php-encryption/src/Key.php |
| 122 | /vendor/defuse/php-encryption/src/Encoding.php |
| 123 | /vendor/defuse/php-encryption/src/Core.php |
| 124 | /vendor/defuse/php-encryption/src/Crypto.php |
| 125 | /vendor/defuse/php-encryption/src/KeyOrPassword.php |
| 126 | /vendor/defuse/php-encryption/src/RuntimeTests.php |
| 127 | /vendor/defuse/php-encryption/src/DerivedKeys.php |
| 128 | /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php |
| 129 | /vendor/defuse/php-encryption/src/Exception/CryptoException.php |
| 130 | /src/Core/Session/SessionHandler.php |
| 131 | /src/Core/Session/SessionHandlerInterface.php |
| 132 | /vendor/symfony/http-foundation/Session/Session.php |
| 133 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBag.php |
| 134 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBagInterface.php |
| 135 | /vendor/symfony/http-foundation/Session/SessionBagInterface.php |
| 136 | /vendor/symfony/http-foundation/Session/Flash/FlashBag.php |
| 137 | /vendor/symfony/http-foundation/Session/Flash/FlashBagInterface.php |
| 138 | /vendor/symfony/http-foundation/Session/SessionBagProxy.php |
| 139 | /vendor/symfony/http-foundation/Session/FlashBagAwareSessionInterface.php |
| 140 | /vendor/symfony/http-foundation/Session/SessionInterface.php |
| 141 | /vendor/symfony/http-foundation/Session/Storage/PhpBridgeSessionStorage.php |
| 142 | /vendor/symfony/http-foundation/Session/Storage/NativeSessionStorage.php |
| 143 | /vendor/symfony/http-foundation/Session/Storage/MetadataBag.php |
| 144 | /vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php |
| 145 | /vendor/symfony/http-foundation/Session/Storage/Handler/AbstractSessionHandler.php |
| 146 | /vendor/symfony/http-foundation/Session/Storage/Proxy/SessionHandlerProxy.php |
| 147 | /vendor/symfony/http-foundation/Session/Storage/Proxy/AbstractProxy.php |
| 148 | /vendor/symfony/http-foundation/Session/Storage/SessionStorageInterface.php |
| 149 | /config/smarty.config.inc.php |
| 150 | /classes/Smarty/SmartyDev.php |
| 151 | /vendor/smarty/smarty/libs/Smarty.class.php |
| 152 | /vendor/smarty/smarty/libs/functions.php |
| 153 | /vendor/smarty/smarty/libs/Autoloader.php |
| 154 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php |
| 155 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php |
| 156 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| 157 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php |
| 158 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php |
| 159 | /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php |
| 160 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php |
| 161 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php |
| 162 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php |
| 163 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerclass.php |
| 164 | /classes/ImageManager.php |
| 165 | /classes/Product.php |
| 166 | /classes/Profile.php |
| 167 | /classes/Tab.php |
| 168 | /config/smartyfront.config.inc.php |
| 169 | /classes/Smarty/SmartyResourceModule.php |
| 170 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php |
| 171 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php |
| 172 | /classes/Smarty/SmartyResourceParent.php |
| 173 | /classes/Smarty/SmartyLazyRegister.php |
| 174 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php |
| 175 | /vendor/smarty/smarty/libs/plugins/modifier.truncate.php |
| 176 | /classes/Customer.php |
| 177 | /classes/Group.php |
| 178 | /classes/Link.php |
| 179 | /classes/shop/ShopUrl.php |
| 180 | /app/FrontKernel.php |
| 181 | /app/AppKernel.php |
| 182 | /vendor/symfony/http-kernel/Kernel.php |
| 183 | /vendor/symfony/config/ConfigCache.php |
| 184 | /vendor/symfony/config/ResourceCheckerConfigCache.php |
| 185 | /vendor/symfony/config/ConfigCacheInterface.php |
| 186 | /vendor/symfony/http-kernel/KernelInterface.php |
| 187 | /vendor/symfony/http-kernel/HttpKernelInterface.php |
| 188 | /vendor/symfony/http-kernel/RebootableInterface.php |
| 189 | /vendor/symfony/http-kernel/TerminableInterface.php |
| 190 | /vendor/symfony/dotenv/Dotenv.php |
| 191 | /classes/Dispatcher.php |
| 192 | /vendor/symfony/http-foundation/Request.php |
| 193 | /vendor/symfony/http-foundation/AcceptHeader.php |
| 194 | /vendor/symfony/http-foundation/AcceptHeaderItem.php |
| 195 | /vendor/symfony/http-foundation/FileBag.php |
| 196 | /vendor/symfony/http-foundation/HeaderBag.php |
| 197 | /vendor/symfony/http-foundation/HeaderUtils.php |
| 198 | /vendor/symfony/http-foundation/InputBag.php |
| 199 | /vendor/symfony/http-foundation/ServerBag.php |
| 200 | /src/Adapter/SymfonyContainer.php |
| 201 | /config/db_slave_server.inc.php |
| 202 | /src/Adapter/ContainerBuilder.php |
| 203 | /src/Adapter/Environment.php |
| 204 | /src/Core/EnvironmentInterface.php |
| 205 | /vendor/symfony/config/Resource/SelfCheckingResourceChecker.php |
| 206 | /vendor/symfony/config/ResourceCheckerInterface.php |
| 207 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/DoctrineProvider.php |
| 208 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php |
| 209 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php |
| 210 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php |
| 211 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php |
| 212 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiOperationCache.php |
| 213 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php |
| 214 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiDeleteCache.php |
| 215 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php |
| 216 | /vendor/symfony/cache/Adapter/ArrayAdapter.php |
| 217 | /vendor/psr/log/src/LoggerAwareTrait.php |
| 218 | /vendor/symfony/cache/Adapter/AdapterInterface.php |
| 219 | /vendor/symfony/cache/CacheItem.php |
| 220 | /vendor/symfony/cache-contracts/ItemInterface.php |
| 221 | /vendor/psr/cache/src/CacheItemInterface.php |
| 222 | /vendor/psr/cache/src/CacheItemPoolInterface.php |
| 223 | /vendor/symfony/cache-contracts/CacheInterface.php |
| 224 | /vendor/psr/log/src/LoggerAwareInterface.php |
| 225 | /vendor/symfony/cache/ResettableInterface.php |
| 226 | /vendor/symfony/service-contracts/ResetInterface.php |
| 227 | /vendor/doctrine/orm/src/Tools/Setup.php |
| 228 | /vendor/doctrine/deprecations/src/Deprecation.php |
| 229 | /vendor/doctrine/orm/src/Configuration.php |
| 230 | /vendor/doctrine/dbal/src/Configuration.php |
| 231 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/CacheAdapter.php |
| 232 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationReader.php |
| 233 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php |
| 234 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php |
| 235 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php |
| 236 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php |
| 237 | /vendor/doctrine/lexer/src/AbstractLexer.php |
| 238 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php |
| 239 | /vendor/doctrine/orm/src/Mapping/Driver/AnnotationDriver.php |
| 240 | /vendor/doctrine/orm/src/Mapping/Driver/CompatibilityAnnotationDriver.php |
| 241 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriver.php |
| 242 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/ColocatedMappingDriver.php |
| 243 | /vendor/doctrine/orm/src/Mapping/Driver/ReflectionBasedDriver.php |
| 244 | /vendor/symfony/cache/Adapter/FilesystemAdapter.php |
| 245 | /vendor/symfony/cache/Adapter/AbstractAdapter.php |
| 246 | /vendor/symfony/cache/Traits/AbstractAdapterTrait.php |
| 247 | /vendor/symfony/cache/Traits/ContractsTrait.php |
| 248 | /vendor/symfony/cache-contracts/CacheTrait.php |
| 249 | /vendor/psr/cache/src/InvalidArgumentException.php |
| 250 | /vendor/psr/cache/src/CacheException.php |
| 251 | /vendor/symfony/cache/Traits/FilesystemTrait.php |
| 252 | /vendor/symfony/cache/Traits/FilesystemCommonTrait.php |
| 253 | /vendor/symfony/cache/PruneableInterface.php |
| 254 | /vendor/symfony/cache/Marshaller/DefaultMarshaller.php |
| 255 | /vendor/symfony/cache/Marshaller/MarshallerInterface.php |
| 256 | /src/Adapter/Module/Repository/CachedModuleRepository.php |
| 257 | /src/Adapter/Module/Repository/ModuleRepository.php |
| 258 | /src/Core/Repository/AbstractObjectModelRepository.php |
| 259 | /vendor/symfony/cache/LockRegistry.php |
| 260 | /modules/ps_facebook/vendor/autoload.php |
| 261 | /modules/ps_facebook/vendor/composer/autoload_real.php |
| 262 | /modules/ps_facebook/vendor/composer/autoload_static.php |
| 263 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment.php |
| 264 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Client.php |
| 265 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer.php |
| 266 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/QueueConsumer.php |
| 267 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/File.php |
| 268 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/ForkCurl.php |
| 269 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/LibCurl.php |
| 270 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/Socket.php |
| 271 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Version.php |
| 272 | /modules/ps_classic_edition/vendor/autoload.php |
| 273 | /modules/ps_classic_edition/vendor/composer/autoload_real.php |
| 274 | /modules/ps_classic_edition/vendor/composer/platform_check.php |
| 275 | /modules/ps_classic_edition/vendor/composer/autoload_static.php |
| 276 | /modules/psshipping/vendor/autoload.php |
| 277 | /modules/psshipping/vendor/composer/autoload_real.php |
| 278 | /modules/psshipping/vendor/composer/autoload_static.php |
| 279 | /modules/psshipping/vendor/ralouphie/getallheaders/src/getallheaders.php |
| 280 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions_include.php |
| 281 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions.php |
| 282 | /modules/psshipping/vendor/clue/stream-filter/src/functions_include.php |
| 283 | /modules/psshipping/vendor/clue/stream-filter/src/functions.php |
| 284 | /modules/psshipping/vendor/php-http/message/src/filters.php |
| 285 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions_include.php |
| 286 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions.php |
| 287 | /modules/ps_eventbus/vendor/autoload.php |
| 288 | /modules/ps_eventbus/vendor/composer/autoload_real.php |
| 289 | /modules/ps_eventbus/vendor/composer/autoload_static.php |
| 290 | /modules/ps_checkout/vendor/autoload.php |
| 291 | /modules/ps_checkout/vendor/composer/autoload_real.php |
| 292 | /modules/ps_checkout/vendor/composer/platform_check.php |
| 293 | /modules/ps_checkout/vendor/composer/autoload_static.php |
| 294 | /modules/ps_checkout/vendor/ramsey/uuid/src/functions.php |
| 295 | /modules/psxmarketingwithgoogle/vendor/autoload.php |
| 296 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_real.php |
| 297 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_static.php |
| 298 | /modules/ps_mbo/vendor/autoload.php |
| 299 | /modules/ps_mbo/vendor/composer/autoload_real.php |
| 300 | /modules/ps_mbo/vendor/composer/platform_check.php |
| 301 | /modules/ps_mbo/vendor/composer/autoload_static.php |
| 302 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions_include.php |
| 303 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions.php |
| 304 | /modules/ps_mbo/vendor/sentry/sentry/src/functions.php |
| 305 | /modules/ps_mbo/bootstrap.php |
| 306 | /modules/ps_mbo/src/Helpers/EnvHelper.php |
| 307 | /modules/ps_accounts/vendor/autoload.php |
| 308 | /modules/ps_accounts/vendor/composer/autoload_real.php |
| 309 | /modules/ps_accounts/vendor/composer/platform_check.php |
| 310 | /modules/ps_accounts/vendor/composer/autoload_static.php |
| 311 | /modules/ps_accounts/vendor/paragonie/random_compat/lib/random.php |
| 312 | /modules/ps_accounts/vendor/symfony/polyfill-ctype/bootstrap.php |
| 313 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/class-aliases.php |
| 314 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Token.php |
| 315 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Signature.php |
| 316 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/json-exception-polyfill.php |
| 317 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php |
| 318 | /modules/ps_accounts/vendor/ramsey/uuid/src/functions.php |
| 319 | /vendor/symfony/config/Resource/FileResource.php |
| 320 | /vendor/symfony/config/Resource/SelfCheckingResourceInterface.php |
| 321 | /vendor/symfony/config/Resource/ResourceInterface.php |
| 322 | /vendor/symfony/config/Resource/ReflectionClassResource.php |
| 323 | /vendor/symfony/config/Resource/DirectoryResource.php |
| 324 | /var/cache/dev/FrontContainer.php |
| 325 | /src/Adapter/Container/LegacyContainer.php |
| 326 | /vendor/symfony/dependency-injection/Container.php |
| 327 | /vendor/symfony/dependency-injection/Argument/RewindableGenerator.php |
| 328 | /vendor/symfony/dependency-injection/Argument/ServiceLocator.php |
| 329 | /vendor/symfony/dependency-injection/ServiceLocator.php |
| 330 | /vendor/symfony/service-contracts/ServiceLocatorTrait.php |
| 331 | /vendor/psr/container/src/ContainerExceptionInterface.php |
| 332 | /vendor/psr/container/src/NotFoundExceptionInterface.php |
| 333 | /vendor/symfony/service-contracts/ServiceProviderInterface.php |
| 334 | /vendor/psr/container/src/ContainerInterface.php |
| 335 | /vendor/symfony/dependency-injection/ContainerInterface.php |
| 336 | /src/Adapter/Container/LegacyContainerInterface.php |
| 337 | /src/PrestaShopBundle/Entity/Repository/FeatureFlagRepository.php |
| 338 | /vendor/doctrine/orm/src/EntityRepository.php |
| 339 | /vendor/doctrine/persistence/src/Persistence/ObjectRepository.php |
| 340 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Selectable.php |
| 341 | /vendor/symfony/var-exporter/LazyProxyTrait.php |
| 342 | /vendor/symfony/var-exporter/Internal/LazyObjectTrait.php |
| 343 | /vendor/symfony/var-exporter/LazyObjectInterface.php |
| 344 | /vendor/symfony/var-exporter/Internal/Hydrator.php |
| 345 | /vendor/symfony/var-exporter/Internal/LazyObjectRegistry.php |
| 346 | /vendor/symfony/var-exporter/Internal/LazyObjectState.php |
| 347 | /src/PrestaShopBundle/Security/Admin/LegacyAdminTokenValidator.php |
| 348 | /vendor/symfony/var-exporter/LazyGhostTrait.php |
| 349 | /src/Core/FeatureFlag/FeatureFlagManager.php |
| 350 | /src/Core/FeatureFlag/FeatureFlagStateCheckerInterface.php |
| 351 | /src/Core/FeatureFlag/Layer/DbLayer.php |
| 352 | /src/Core/FeatureFlag/TypeLayerInterface.php |
| 353 | /src/Core/FeatureFlag/Layer/DotEnvLayer.php |
| 354 | /src/Core/FeatureFlag/Layer/EnvLayer.php |
| 355 | /src/Core/FeatureFlag/Layer/QueryLayer.php |
| 356 | /vendor/symfony/http-foundation/RequestStack.php |
| 357 | /vendor/doctrine/orm/src/EntityManager.php |
| 358 | /vendor/doctrine/orm/src/EntityManagerInterface.php |
| 359 | /vendor/doctrine/persistence/src/Persistence/ObjectManager.php |
| 360 | /src/Core/Hook/HookModuleFilter.php |
| 361 | /src/Core/Hook/HookModuleFilterInterface.php |
| 362 | /modules/ps_checkout/ps_checkout.php |
| 363 | /classes/PaymentModule.php |
| 364 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php |
| 365 | /vendor/smarty/smarty/libs/sysplugins/smarty_data.php |
| 366 | /classes/Translate.php |
| 367 | /modules/ps_checkout/translations/en.php |
| 368 | /src/PrestaShopBundle/Translation/TranslatorComponent.php |
| 369 | /vendor/symfony/translation/Translator.php |
| 370 | /vendor/symfony/translation/MessageCatalogue.php |
| 371 | /vendor/symfony/translation/MessageCatalogueInterface.php |
| 372 | /vendor/symfony/translation/MetadataAwareInterface.php |
| 373 | /vendor/symfony/translation/CatalogueMetadataAwareInterface.php |
| 374 | /vendor/symfony/translation-contracts/TranslatorInterface.php |
| 375 | /vendor/symfony/translation/TranslatorBagInterface.php |
| 376 | /vendor/symfony/translation-contracts/LocaleAwareInterface.php |
| 377 | /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php |
| 378 | /src/PrestaShopBundle/Translation/TranslatorLanguageTrait.php |
| 379 | /src/PrestaShopBundle/Translation/TranslatorInterface.php |
| 380 | /vendor/symfony/translation/Formatter/MessageFormatter.php |
| 381 | /vendor/symfony/translation/Formatter/IntlFormatter.php |
| 382 | /vendor/symfony/translation/Formatter/IntlFormatterInterface.php |
| 383 | /vendor/symfony/translation/Formatter/MessageFormatterInterface.php |
| 384 | /vendor/symfony/translation/IdentityTranslator.php |
| 385 | /vendor/symfony/translation-contracts/TranslatorTrait.php |
| 386 | /vendor/symfony/config/ConfigCacheFactory.php |
| 387 | /vendor/symfony/config/ConfigCacheFactoryInterface.php |
| 388 | /var/cache/dev/translations/catalogue.en-US.NXhscRe.php |
| 389 | /controllers/front/listing/CategoryController.php |
| 390 | /classes/controller/ProductListingFrontController.php |
| 391 | /classes/controller/ProductPresentingFrontController.php |
| 392 | /classes/controller/FrontController.php |
| 393 | /src/Adapter/Presenter/Object/ObjectPresenter.php |
| 394 | /src/Adapter/Presenter/PresenterInterface.php |
| 395 | /src/Adapter/Presenter/Cart/CartPresenter.php |
| 396 | /src/Adapter/Image/ImageRetriever.php |
| 397 | /classes/tax/TaxConfiguration.php |
| 398 | /classes/Smarty/TemplateFinder.php |
| 399 | /classes/assets/StylesheetManager.php |
| 400 | /classes/assets/AbstractAssetManager.php |
| 401 | /src/Adapter/Assets/AssetUrlGeneratorTrait.php |
| 402 | /classes/assets/JavascriptManager.php |
| 403 | /classes/assets/CccReducer.php |
| 404 | /classes/Category.php |
| 405 | /src/Core/Domain/Category/ValueObject/RedirectType.php |
| 406 | /src/Core/Domain/Category/CategorySettings.php |
| 407 | /src/Core/Domain/Category/SeoSettings.php |
| 408 | /classes/webservice/WebserviceRequest.php |
| 409 | /src/Core/Localization/Locale/Repository.php |
| 410 | /src/Core/Localization/Locale/RepositoryInterface.php |
| 411 | /src/Core/Localization/CLDR/LocaleRepository.php |
| 412 | /src/Core/Localization/CLDR/LocaleDataSource.php |
| 413 | /src/Core/Localization/CLDR/DataLayer/LocaleCache.php |
| 414 | /src/Core/Data/Layer/AbstractDataLayer.php |
| 415 | /src/Core/Localization/CLDR/LocaleDataLayerInterface.php |
| 416 | /src/Core/Localization/CLDR/DataLayer/LocaleReference.php |
| 417 | /src/Core/Localization/CLDR/Reader.php |
| 418 | /src/Core/Localization/CLDR/ReaderInterface.php |
| 419 | /src/Core/Localization/Currency/Repository.php |
| 420 | /src/Core/Localization/Currency/RepositoryInterface.php |
| 421 | /src/Core/Localization/Currency/CurrencyDataSource.php |
| 422 | /src/Core/Localization/Currency/DataSourceInterface.php |
| 423 | /src/Core/Localization/Currency/DataLayer/CurrencyCache.php |
| 424 | /src/Core/Localization/Currency/CurrencyDataLayerInterface.php |
| 425 | /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php |
| 426 | /src/Adapter/Currency/CurrencyDataProvider.php |
| 427 | /src/Core/Currency/CurrencyDataProviderInterface.php |
| 428 | /src/Adapter/LegacyContext.php |
| 429 | /src/Adapter/Tools.php |
| 430 | /src/Core/Localization/Currency/DataLayer/CurrencyReference.php |
| 431 | /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php |
| 432 | /vendor/prestashop/decimal/src/Operation/Rounding.php |
| 433 | /src/Core/Localization/Locale.php |
| 434 | /src/Core/Localization/LocaleInterface.php |
| 435 | /src/Core/Localization/Specification/Price.php |
| 436 | /src/Core/Localization/Specification/Number.php |
| 437 | /src/Core/Localization/Specification/NumberInterface.php |
| 438 | /src/Core/Localization/Specification/Factory.php |
| 439 | /src/Core/Localization/CLDR/LocaleData.php |
| 440 | /src/Core/Localization/CLDR/NumberSymbolsData.php |
| 441 | /src/Core/Localization/CLDR/CurrencyData.php |
| 442 | /src/Core/Localization/CLDR/Locale.php |
| 443 | /src/Core/Localization/CLDR/LocaleInterface.php |
| 444 | /src/Core/Localization/Specification/NumberSymbolList.php |
| 445 | /classes/Currency.php |
| 446 | /src/Core/Localization/Currency/LocalizedCurrencyId.php |
| 447 | /src/Core/Localization/Currency/CurrencyData.php |
| 448 | /src/Core/Localization/Currency/CurrencyCollection.php |
| 449 | /src/Core/Localization/Currency.php |
| 450 | /src/Core/Localization/CurrencyInterface.php |
| 451 | /src/Core/Localization/Specification/NumberCollection.php |
| 452 | /src/Core/Localization/Number/Formatter.php |
| 453 | /classes/Cart.php |
| 454 | /src/Adapter/AddressFactory.php |
| 455 | /classes/CartRule.php |
| 456 | /src/Core/Domain/Product/ValueObject/RedirectType.php |
| 457 | /src/Core/Util/DateTime/DateTime.php |
| 458 | /src/Core/Domain/Product/Stock/ValueObject/OutOfStockType.php |
| 459 | /src/Core/Domain/Product/Pack/ValueObject/PackStockType.php |
| 460 | /src/Core/Domain/Product/ValueObject/ProductType.php |
| 461 | /src/Core/Domain/Product/ValueObject/Reference.php |
| 462 | /src/Core/Domain/Product/ValueObject/Gtin.php |
| 463 | /src/Core/Domain/Product/ValueObject/Isbn.php |
| 464 | /src/Core/Domain/Product/ValueObject/Upc.php |
| 465 | /src/Core/Domain/Product/ProductSettings.php |
| 466 | /src/Adapter/Presenter/Category/CategoryPresenter.php |
| 467 | /src/Adapter/Presenter/Category/CategoryLazyArray.php |
| 468 | /src/Adapter/Presenter/AbstractLazyArray.php |
| 469 | /src/Adapter/Presenter/LazyArrayAttribute.php |
| 470 | /src/Core/Util/Inflector.php |
| 471 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/InflectorFactory.php |
| 472 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Language.php |
| 473 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/InflectorFactory.php |
| 474 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/GenericLanguageInflectorFactory.php |
| 475 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/LanguageInflectorFactory.php |
| 476 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Rules.php |
| 477 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Ruleset.php |
| 478 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformations.php |
| 479 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/WordInflector.php |
| 480 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Inflectible.php |
| 481 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformation.php |
| 482 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Pattern.php |
| 483 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Patterns.php |
| 484 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Uninflected.php |
| 485 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitutions.php |
| 486 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitution.php |
| 487 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Word.php |
| 488 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Inflector.php |
| 489 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/CachedWordInflector.php |
| 490 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/RulesetInflector.php |
| 491 | /src/Core/Domain/Shop/ValueObject/ShopId.php |
| 492 | /src/Core/Domain/Shop/ValueObject/ShopIdInterface.php |
| 493 | /vendor/symfony/property-access/Exception/UnexpectedTypeException.php |
| 494 | /vendor/symfony/property-access/Exception/RuntimeException.php |
| 495 | /vendor/symfony/property-access/Exception/ExceptionInterface.php |
| 496 | /modules/blockreassurance/blockreassurance.php |
| 497 | /src/Core/Module/WidgetInterface.php |
| 498 | /src/PrestaShopBundle/Translation/DomainNormalizer.php |
| 499 | /classes/Media.php |
| 500 | /modules/blockwishlist/blockwishlist.php |
| 501 | /modules/ps_emailsubscription/ps_emailsubscription.php |
| 502 | /modules/ps_socialfollow/ps_socialfollow.php |
| 503 | /modules/ps_facebook/ps_facebook.php |
| 504 | /modules/ps_facebook/translations/en.php |
| 505 | /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php |
| 506 | /modules/ps_facebook/vendor/prestashop/module-lib-cache-directory-provider/src/Cache/CacheDirectoryProvider.php |
| 507 | /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ContainerProvider.php |
| 508 | /var/cache/dev/Ps_facebookFrontContainer.php |
| 509 | /modules/ps_facebook/classes/Buffer/TemplateBuffer.php |
| 510 | /modules/ps_emailalerts/ps_emailalerts.php |
| 511 | /modules/ps_emailalerts/MailAlert.php |
| 512 | /var/cache/dev/Ps_checkout9433FrontContainer.php |
| 513 | /modules/ps_checkout/src/Validator/FrontControllerValidator.php |
| 514 | /modules/ps_checkout/src/Validator/MerchantValidator.php |
| 515 | /modules/ps_checkout/src/PayPal/PayPalConfiguration.php |
| 516 | /modules/ps_checkout/src/Configuration/PrestaShopConfiguration.php |
| 517 | /modules/ps_checkout/src/Configuration/PrestaShopConfigurationOptionsResolver.php |
| 518 | /modules/ps_checkout/src/Shop/ShopProvider.php |
| 519 | /vendor/symfony/options-resolver/OptionsResolver.php |
| 520 | /vendor/symfony/options-resolver/Options.php |
| 521 | /modules/ps_checkout/src/Repository/PayPalCodeRepository.php |
| 522 | /modules/ps_checkout/src/Repository/PsAccountRepository.php |
| 523 | /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php |
| 524 | /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Installer.php |
| 525 | /src/Core/Addon/Module/ModuleManagerBuilder.php |
| 526 | /src/Adapter/LegacyLogger.php |
| 527 | /src/Adapter/Module/ModuleDataProvider.php |
| 528 | /src/Adapter/Module/AdminModuleDataProvider.php |
| 529 | /src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php |
| 530 | /src/Adapter/Module/Module.php |
| 531 | /src/Core/Module/ModuleInterface.php |
| 532 | /vendor/symfony/config/FileLocator.php |
| 533 | /vendor/symfony/config/FileLocatorInterface.php |
| 534 | /vendor/symfony/routing/Loader/YamlFileLoader.php |
| 535 | /vendor/symfony/config/Loader/FileLoader.php |
| 536 | /vendor/symfony/config/Loader/Loader.php |
| 537 | /vendor/symfony/config/Loader/LoaderInterface.php |
| 538 | /vendor/symfony/routing/Loader/Configurator/Traits/HostTrait.php |
| 539 | /vendor/symfony/routing/Loader/Configurator/Traits/LocalizedRouteTrait.php |
| 540 | /vendor/symfony/routing/Loader/Configurator/Traits/PrefixTrait.php |
| 541 | /vendor/symfony/routing/Router.php |
| 542 | /vendor/symfony/routing/RouterInterface.php |
| 543 | /vendor/symfony/routing/Matcher/UrlMatcherInterface.php |
| 544 | /vendor/symfony/routing/RequestContextAwareInterface.php |
| 545 | /vendor/symfony/routing/Generator/UrlGeneratorInterface.php |
| 546 | /vendor/symfony/routing/Matcher/RequestMatcherInterface.php |
| 547 | /vendor/symfony/routing/RequestContext.php |
| 548 | /src/Core/Module/ModuleManager.php |
| 549 | /src/Core/Module/ModuleManagerInterface.php |
| 550 | /src/Core/Module/ModuleRepository.php |
| 551 | /src/Core/Module/ModuleRepositoryInterface.php |
| 552 | /src/Adapter/HookManager.php |
| 553 | /src/Core/Context/LanguageContext.php |
| 554 | /src/Core/Module/SourceHandler/SourceHandlerFactory.php |
| 555 | /src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php |
| 556 | /vendor/symfony/event-dispatcher/EventDispatcherInterface.php |
| 557 | /vendor/symfony/event-dispatcher-contracts/EventDispatcherInterface.php |
| 558 | /vendor/psr/event-dispatcher/src/EventDispatcherInterface.php |
| 559 | /src/Core/Hook/HookDispatcherInterface.php |
| 560 | /vendor/symfony/translation/Loader/XliffFileLoader.php |
| 561 | /vendor/symfony/translation/Loader/LoaderInterface.php |
| 562 | /modules/ps_accounts/ps_accounts.php |
| 563 | /modules/ps_accounts/src/Hook/HookableTrait.php |
| 564 | /modules/ps_accounts/src/Module/Install.php |
| 565 | /modules/ps_accounts/src/Settings/SettingsForm.php |
| 566 | /modules/ps_accounts/translations/en.php |
| 567 | /modules/ps_accounts/src/ServiceContainer/PsAccountsContainer.php |
| 568 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/ServiceContainer.php |
| 569 | /modules/ps_accounts/config.php |
| 570 | /modules/ps_accounts/src/Log/Logger.php |
| 571 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Logger.php |
| 572 | /modules/ps_accounts/vendor/psr/log/Psr/Log/LoggerInterface.php |
| 573 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/ResettableInterface.php |
| 574 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/RotatingFileHandler.php |
| 575 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php |
| 576 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php |
| 577 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php |
| 578 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/HandlerInterface.php |
| 579 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Utils.php |
| 580 | /modules/ps_accounts/src/ServiceProvider/ApiClientProvider.php |
| 581 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/Contract/IServiceProvider.php |
| 582 | /modules/ps_accounts/src/ServiceProvider/CommandProvider.php |
| 583 | /modules/ps_accounts/src/ServiceProvider/DefaultProvider.php |
| 584 | /modules/ps_accounts/src/ServiceProvider/OAuth2Provider.php |
| 585 | /modules/ps_accounts/src/ServiceProvider/QueryProvider.php |
| 586 | /modules/ps_accounts/src/ServiceProvider/RepositoryProvider.php |
| 587 | /modules/ps_accounts/src/ServiceProvider/SessionProvider.php |
| 588 | /modules/ps_accounts/src/Service/PsAccountsService.php |
| 589 | /modules/ps_accounts/src/Account/Session/ShopSession.php |
| 590 | /modules/ps_accounts/src/Account/Session/Session.php |
| 591 | /modules/ps_accounts/src/Account/Session/SessionInterface.php |
| 592 | /modules/ps_accounts/src/Repository/ConfigurationRepository.php |
| 593 | /modules/ps_accounts/src/Adapter/Configuration.php |
| 594 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Service.php |
| 595 | /modules/ps_accounts/src/Http/Client/ClientConfig.php |
| 596 | /modules/ps_accounts/src/Http/Client/ConfigObject.php |
| 597 | /modules/ps_accounts/src/Type/Enum.php |
| 598 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Client.php |
| 599 | /modules/ps_accounts/src/Adapter/Link.php |
| 600 | /modules/ps_accounts/src/Context/ShopContext.php |
| 601 | /modules/ps_accounts/vendor/ramsey/uuid/src/Uuid.php |
| 602 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidInterface.php |
| 603 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactory.php |
| 604 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactoryInterface.php |
| 605 | /modules/ps_accounts/vendor/ramsey/uuid/src/FeatureSet.php |
| 606 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Number/DegradedNumberConverter.php |
| 607 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/NumberConverterInterface.php |
| 608 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/DefaultUuidBuilder.php |
| 609 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/UuidBuilderInterface.php |
| 610 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/StringCodec.php |
| 611 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/CodecInterface.php |
| 612 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/FallbackNodeProvider.php |
| 613 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/NodeProviderInterface.php |
| 614 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/SystemNodeProvider.php |
| 615 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/RandomNodeProvider.php |
| 616 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorFactory.php |
| 617 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomBytesGenerator.php |
| 618 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorInterface.php |
| 619 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Time/SystemTimeProvider.php |
| 620 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/TimeProviderInterface.php |
| 621 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorFactory.php |
| 622 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Time/PhpTimeConverter.php |
| 623 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/TimeConverterInterface.php |
| 624 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/DefaultTimeGenerator.php |
| 625 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorInterface.php |
| 626 | /modules/ps_accounts/vendor/ramsey/uuid/src/BinaryUtils.php |
| 627 | /modules/ps_accounts/src/Service/OAuth2/CachedFile.php |
| 628 | /modules/ps_accounts/src/Account/Session/Firebase/ShopSession.php |
| 629 | /modules/ps_accounts/src/Account/Session/Firebase/FirebaseSession.php |
| 630 | /modules/ps_accounts/src/Account/Session/Firebase/OwnerSession.php |
| 631 | /modules/ps_accounts/src/Account/StatusManager.php |
| 632 | /modules/ps_accounts/src/Traits/WithOriginAndSourceTrait.php |
| 633 | /modules/ps_accounts/src/Traits/WithPropertyTrait.php |
| 634 | /modules/ps_accounts/src/Service/Accounts/AccountsService.php |
| 635 | /modules/ps_accounts/src/Service/AnalyticsService.php |
| 636 | /modules/ps_accounts/src/Service/AdminTokenService.php |
| 637 | /modules/ps_checkout/src/ExpressCheckout/ExpressCheckoutConfiguration.php |
| 638 | /modules/ps_checkout/src/PayPal/PayPalPayLaterConfiguration.php |
| 639 | /modules/ps_checkout/src/Version/Version.php |
| 640 | /src/Adapter/Presenter/Cart/CartLazyArray.php |
| 641 | /src/Adapter/Product/PriceFormatter.php |
| 642 | /classes/Gender.php |
| 643 | /src/Core/Domain/Title/ValueObject/Gender.php |
| 644 | /classes/Risk.php |
| 645 | /classes/Meta.php |
| 646 | /classes/Address.php |
| 647 | /classes/ImageType.php |
| 648 | /classes/State.php |
| 649 | /src/Core/Security/PasswordPolicyConfiguration.php |
| 650 | /src/Core/Configuration/DataConfigurationInterface.php |
| 651 | /src/Core/Security/Hashing.php |
| 652 | /src/Core/Filter/FrontEndObject/MainFilter.php |
| 653 | /src/Core/Filter/FilterInterface.php |
| 654 | /src/Core/Filter/FrontEndObject/CartFilter.php |
| 655 | /src/Core/Filter/HashMapWhitelistFilter.php |
| 656 | /src/Core/Filter/CollectionFilter.php |
| 657 | /src/Core/Filter/FrontEndObject/ProductFilter.php |
| 658 | /src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php |
| 659 | /src/Core/Filter/FrontEndObject/CustomerFilter.php |
| 660 | /src/Core/Filter/FrontEndObject/ShopFilter.php |
| 661 | /src/Core/Filter/FrontEndObject/ConfigurationFilter.php |
| 662 | /classes/ProductAssembler.php |
| 663 | /src/Core/Product/Search/ProductSearchContext.php |
| 664 | /modules/ps_shoppingcart/ps_shoppingcart.php |
| 665 | /modules/ps_searchbar/ps_searchbar.php |
| 666 | /modules/ps_imageslider/ps_imageslider.php |
| 667 | /modules/ps_imageslider/Ps_HomeSlide.php |
| 668 | /modules/productcomments/productcomments.php |
| 669 | /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php |
| 670 | /modules/ps_facebook/classes/Config/Env.php |
| 671 | /modules/ps_facebook/classes/Handler/ErrorHandler/ModuleFilteredRavenClient.php |
| 672 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Client.php |
| 673 | /modules/ps_facebook/classes/Config/Config.php |
| 674 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Util.php |
| 675 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Compat.php |
| 676 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor/SanitizeDataProcessor.php |
| 677 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor.php |
| 678 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Context.php |
| 679 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs.php |
| 680 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Serializer.php |
| 681 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ReprSerializer.php |
| 682 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/TransactionStack.php |
| 683 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs/ErrorHandler.php |
| 684 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Stacktrace.php |
| 685 | /modules/ps_accounts/src/Adapter/ConfigurationKeys.php |
| 686 | /modules/ps_accounts/src/Account/CachedShopStatus.php |
| 687 | /modules/ps_accounts/src/Http/Resource/Resource.php |
| 688 | /modules/ps_accounts/src/Type/Dto.php |
| 689 | /modules/ps_accounts/src/Service/Accounts/Resource/ShopStatus.php |
| 690 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ErrorHandler.php |
| 691 | /modules/ps_facebook/classes/Dispatcher/EventDispatcher.php |
| 692 | /modules/ps_facebook/classes/Handler/ApiConversionHandler.php |
| 693 | /modules/ps_facebook/classes/Adapter/ConfigurationAdapter.php |
| 694 | /modules/ps_facebook/classes/Factory/ContextFactory.php |
| 695 | /modules/ps_facebook/classes/API/Client/FacebookClient.php |
| 696 | /modules/ps_facebook/classes/Factory/FacebookEssentialsApiClientFactory.php |
| 697 | /modules/ps_facebook/classes/Factory/ApiClientFactoryInterface.php |
| 698 | /modules/ps_facebook/classes/Provider/AccessTokenProvider.php |
| 699 | /modules/ps_facebook/classes/Factory/PsApiClientFactory.php |
| 700 | /modules/ps_facebook/classes/Handler/ConfigurationHandler.php |
| 701 | /modules/ps_facebook/classes/Http/HttpClient.php |
| 702 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Api.php |
| 703 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Session.php |
| 704 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/SessionInterface.php |
| 705 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/ApiConfig.php |
| 706 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Http/Client.php |
| 707 | /modules/ps_facebook/classes/Handler/PixelHandler.php |
| 708 | /vendor/symfony/http-foundation/Session/Storage/MockFileSessionStorage.php |
| 709 | /vendor/symfony/http-foundation/Session/Storage/MockArraySessionStorage.php |
| 710 | /modules/ps_facebook/classes/Provider/EventDataProvider.php |
| 711 | /modules/ps_facebook/classes/Adapter/ToolsAdapter.php |
| 712 | /modules/ps_facebook/classes/Repository/ProductRepository.php |
| 713 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProvider.php |
| 714 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProviderInterface.php |
| 715 | /modules/ps_facebook/classes/Repository/GoogleCategoryRepository.php |
| 716 | /modules/ps_facebook/classes/Provider/GoogleCategoryProvider.php |
| 717 | /modules/ps_facebook/classes/Provider/GoogleCategoryProviderInterface.php |
| 718 | /modules/psshipping/psshipping.php |
| 719 | /src/Adapter/Localization/LegacyTranslator.php |
| 720 | /var/cache/dev/PsshippingFrontContainer.php |
| 721 | /modules/psshipping/src/Hooks/HookDisplayHeader.php |
| 722 | /modules/psshipping/src/Domain/GelProximity/GelProximityService.php |
| 723 | /modules/psshipping/src/Domain/Carriers/CarrierRepository.php |
| 724 | /src/Adapter/ContainerFinder.php |
| 725 | /vendor/doctrine/dbal/src/Logging/LoggerChain.php |
| 726 | /vendor/doctrine/dbal/src/Logging/SQLLogger.php |
| 727 | /vendor/symfony/doctrine-bridge/Logger/DbalLogger.php |
| 728 | /vendor/doctrine/dbal/src/Logging/DebugStack.php |
| 729 | /vendor/doctrine/doctrine-bundle/ConnectionFactory.php |
| 730 | /src/PrestaShopBundle/DependencyInjection/RuntimeConstEnvVarProcessor.php |
| 731 | /vendor/symfony/dependency-injection/EnvVarProcessorInterface.php |
| 732 | /vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php |
| 733 | /vendor/doctrine/event-manager/src/EventManager.php |
| 734 | /vendor/doctrine/dbal/src/DriverManager.php |
| 735 | /vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php |
| 736 | /vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php |
| 737 | /vendor/doctrine/dbal/src/VersionAwarePlatformDriver.php |
| 738 | /vendor/doctrine/dbal/src/Driver.php |
| 739 | /src/PrestaShopBundle/Doctrine/DatabaseConnection.php |
| 740 | /vendor/doctrine/dbal/src/Connection.php |
| 741 | /vendor/doctrine/dbal/src/ArrayParameterType.php |
| 742 | /vendor/doctrine/dbal/src/ParameterType.php |
| 743 | /vendor/doctrine/dbal/src/Query/Expression/ExpressionBuilder.php |
| 744 | /vendor/doctrine/dbal/src/Schema/LegacySchemaManagerFactory.php |
| 745 | /vendor/doctrine/dbal/src/Schema/SchemaManagerFactory.php |
| 746 | /vendor/doctrine/dbal/src/Driver/PDO/Connection.php |
| 747 | /vendor/doctrine/dbal/src/Driver/ServerInfoAwareConnection.php |
| 748 | /vendor/doctrine/dbal/src/Driver/Connection.php |
| 749 | /vendor/doctrine/dbal/src/Events.php |
| 750 | /vendor/doctrine/dbal/src/Platforms/MariaDb1010Platform.php |
| 751 | /vendor/doctrine/dbal/src/Platforms/MariaDb1060Platform.php |
| 752 | /vendor/doctrine/dbal/src/Platforms/MariaDb1052Platform.php |
| 753 | /vendor/doctrine/dbal/src/Platforms/MariaDb1043Platform.php |
| 754 | /vendor/doctrine/dbal/src/Platforms/MariaDb1027Platform.php |
| 755 | /vendor/doctrine/dbal/src/Platforms/MariaDBPlatform.php |
| 756 | /vendor/doctrine/dbal/src/Platforms/MySQLPlatform.php |
| 757 | /vendor/doctrine/dbal/src/Platforms/AbstractMySQLPlatform.php |
| 758 | /vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php |
| 759 | /vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php |
| 760 | /vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php |
| 761 | /vendor/doctrine/dbal/src/Types/Types.php |
| 762 | /vendor/doctrine/dbal/src/Types/Type.php |
| 763 | /vendor/doctrine/dbal/src/Types/ArrayType.php |
| 764 | /vendor/doctrine/dbal/src/Types/AsciiStringType.php |
| 765 | /vendor/doctrine/dbal/src/Types/StringType.php |
| 766 | /vendor/doctrine/dbal/src/Types/BigIntType.php |
| 767 | /vendor/doctrine/dbal/src/Types/PhpIntegerMappingType.php |
| 768 | /vendor/doctrine/dbal/src/Types/BinaryType.php |
| 769 | /vendor/doctrine/dbal/src/Types/BlobType.php |
| 770 | /vendor/doctrine/dbal/src/Types/BooleanType.php |
| 771 | /vendor/doctrine/dbal/src/Types/DateType.php |
| 772 | /vendor/doctrine/dbal/src/Types/DateImmutableType.php |
| 773 | /vendor/doctrine/dbal/src/Types/DateIntervalType.php |
| 774 | /vendor/doctrine/dbal/src/Types/DateTimeType.php |
| 775 | /vendor/doctrine/dbal/src/Types/PhpDateTimeMappingType.php |
| 776 | /vendor/doctrine/dbal/src/Types/DateTimeImmutableType.php |
| 777 | /vendor/doctrine/dbal/src/Types/DateTimeTzType.php |
| 778 | /vendor/doctrine/dbal/src/Types/DateTimeTzImmutableType.php |
| 779 | /vendor/doctrine/dbal/src/Types/DecimalType.php |
| 780 | /vendor/doctrine/dbal/src/Types/FloatType.php |
| 781 | /vendor/doctrine/dbal/src/Types/GuidType.php |
| 782 | /vendor/doctrine/dbal/src/Types/IntegerType.php |
| 783 | /vendor/doctrine/dbal/src/Types/JsonType.php |
| 784 | /vendor/doctrine/dbal/src/Types/ObjectType.php |
| 785 | /vendor/doctrine/dbal/src/Types/SimpleArrayType.php |
| 786 | /vendor/doctrine/dbal/src/Types/SmallIntType.php |
| 787 | /vendor/doctrine/dbal/src/Types/TextType.php |
| 788 | /vendor/doctrine/dbal/src/Types/TimeType.php |
| 789 | /vendor/doctrine/dbal/src/Types/TimeImmutableType.php |
| 790 | /vendor/doctrine/dbal/src/Types/TypeRegistry.php |
| 791 | /modules/ps_googleanalytics/ps_googleanalytics.php |
| 792 | /modules/ps_googleanalytics/classes/Hook/HookDisplayHeader.php |
| 793 | /modules/ps_googleanalytics/classes/Hook/HookInterface.php |
| 794 | /modules/psxmarketingwithgoogle/psxmarketingwithgoogle.php |
| 795 | /var/cache/dev/PsxmarketingwithgoogleFrontContainer.php |
| 796 | /modules/psxmarketingwithgoogle/classes/Adapter/ConfigurationAdapter.php |
| 797 | /modules/psxmarketingwithgoogle/classes/Factory/ContextFactory.php |
| 798 | /modules/psxmarketingwithgoogle/classes/config/Config.php |
| 799 | /modules/psxmarketingwithgoogle/classes/Handler/RemarketingHookHandler.php |
| 800 | /modules/psxmarketingwithgoogle/classes/Buffer/TemplateBuffer.php |
| 801 | /src/Core/Product/Search/ProductSearchQuery.php |
| 802 | /src/Core/Product/Search/SortOrder.php |
| 803 | /modules/ps_facetedsearch/ps_facetedsearch.php |
| 804 | /modules/ps_facetedsearch/src/HookDispatcher.php |
| 805 | /modules/ps_facetedsearch/src/Hook/Attribute.php |
| 806 | /modules/ps_facetedsearch/src/Hook/AbstractHook.php |
| 807 | /modules/ps_facetedsearch/src/Hook/AttributeGroup.php |
| 808 | /modules/ps_facetedsearch/src/Hook/Category.php |
| 809 | /modules/ps_facetedsearch/src/Hook/Configuration.php |
| 810 | /modules/ps_facetedsearch/src/Hook/Design.php |
| 811 | /modules/ps_facetedsearch/src/Hook/Feature.php |
| 812 | /modules/ps_facetedsearch/src/Form/Feature/FormModifier.php |
| 813 | /modules/ps_facetedsearch/src/Form/Feature/FormDataProvider.php |
| 814 | /modules/ps_facetedsearch/src/Hook/FeatureValue.php |
| 815 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormModifier.php |
| 816 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormDataProvider.php |
| 817 | /modules/ps_facetedsearch/src/Hook/Product.php |
| 818 | /modules/ps_facetedsearch/src/Hook/ProductSearch.php |
| 819 | /modules/ps_facetedsearch/src/Hook/SpecificPrice.php |
| 820 | /modules/ps_facetedsearch/src/Filters/Provider.php |
| 821 | /modules/ps_facetedsearch/src/URLSerializer.php |
| 822 | /modules/ps_facetedsearch/src/Filters/DataAccessor.php |
| 823 | /modules/ps_facetedsearch/src/Product/SearchProvider.php |
| 824 | /src/Core/Product/Search/FacetsRendererInterface.php |
| 825 | /src/Core/Product/Search/ProductSearchProviderInterface.php |
| 826 | /modules/ps_facetedsearch/src/Filters/Converter.php |
| 827 | /modules/ps_facetedsearch/src/Product/SearchFactory.php |
| 828 | /src/Core/Product/Search/ProductSearchResult.php |
| 829 | /modules/ps_facetedsearch/src/Definition/Availability.php |
| 830 | /classes/Combination.php |
| 831 | /classes/Manufacturer.php |
| 832 | /src/Core/Util/String/StringModifier.php |
| 833 | /src/Core/Util/String/StringModifierInterface.php |
| 834 | /modules/ps_facetedsearch/src/Product/Search.php |
| 835 | /modules/ps_facetedsearch/src/Adapter/MySQL.php |
| 836 | /modules/ps_facetedsearch/src/Adapter/AbstractAdapter.php |
| 837 | /modules/ps_facetedsearch/src/Adapter/InterfaceAdapter.php |
| 838 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ArrayCollection.php |
| 839 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Collection.php |
| 840 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ReadableCollection.php |
| 841 | /modules/ps_facetedsearch/src/Filters/Products.php |
| 842 | /classes/stock/StockAvailable.php |
| 843 | /modules/ps_facetedsearch/src/Filters/Block.php |
| 844 | /src/Core/Product/Search/Facet.php |
| 845 | /src/Core/Product/Search/Filter.php |
| 846 | /vendor/prestashop/decimal/src/DecimalNumber.php |
| 847 | /vendor/prestashop/decimal/src/Builder.php |
| 848 | /src/Core/Product/Search/FacetCollection.php |
| 849 | /classes/Pack.php |
| 850 | /src/Core/Localization/CLDR/ComputingPrecision.php |
| 851 | /src/Core/Localization/CLDR/ComputingPrecisionInterface.php |
| 852 | /classes/SpecificPrice.php |
| 853 | /classes/tax/TaxManagerFactory.php |
| 854 | /classes/tax/TaxRulesTaxManager.php |
| 855 | /classes/tax/TaxManagerInterface.php |
| 856 | /classes/tax/TaxCalculator.php |
| 857 | /classes/GroupReduction.php |
| 858 | /classes/order/Order.php |
| 859 | /classes/tax/Tax.php |
| 860 | /src/Core/Domain/Combination/CombinationSettings.php |
| 861 | /classes/ProductPresenterFactory.php |
| 862 | /src/Adapter/Presenter/Product/ProductListingPresenter.php |
| 863 | /src/Adapter/Presenter/Product/ProductPresenter.php |
| 864 | /src/Adapter/Product/ProductColorsRetriever.php |
| 865 | /src/Core/Product/ProductPresentationSettings.php |
| 866 | /src/Adapter/Presenter/Product/ProductListingLazyArray.php |
| 867 | /src/Adapter/Presenter/Product/ProductLazyArray.php |
| 868 | /classes/Image.php |
| 869 | /src/Core/Image/ImageFormatConfiguration.php |
| 870 | /src/Core/Image/ImageFormatConfigurationInterface.php |
| 871 | /classes/Smarty/SmartyDevTemplate.php |
| 872 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php |
| 873 | /var/cache/dev/smarty/compile/classic/d4/1d/65/d41d65d76b9471b5d365fe06cf1737c89a53af9f_2.module.ps_facetedsearchviewstemplatesfrontcatalogfacets.tpl.php |
| 874 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php |
| 875 | /vendor/smarty/smarty/libs/plugins/modifier.count.php |
| 876 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php |
| 877 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php |
| 878 | /var/cache/dev/smarty/compile/classic/2e/80/73/2e807335546cfa2360c36327ac89dd2fcb054379_2.module.ps_facetedsearchviewstemplatesfrontcatalogactivefilters.tpl.php |
| 879 | /src/Core/Product/Search/Pagination.php |
| 880 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/86/9d/f4869d8e54faed02ff5f4e8e04ea23686e5637e3_2.file.category.tpl.php |
| 881 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/10/b2/e3/10b2e360d5a533b2b2934e009fc915731c428e56_2.file.product-list.tpl.php |
| 882 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a7/7f/c0/a77fc0a1c84dbbceae38d0ec8e850b74ffa1815c_2.file.layout-left-column.tpl.php |
| 883 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/77/94/bf779460f8c4c036c7e45504a74d2d8e9d6df3a8_2.file.layout-both-columns.tpl.php |
| 884 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/40/51/23/405123fa2f4c2063b3ba176d243be48e91cdb2d0_2.file.helpers.tpl.php |
| 885 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_tplfunction.php |
| 886 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/61/b5/e061b5502d7c8b36b791de08d0bfd778210f31b0_2.file.head.tpl.php |
| 887 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/e0/43/b3/e043b3d6d608728a976adcef936baafeb245aac5_2.file.head-jsonld.tpl.php |
| 888 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/54/d0/4f/54d04fd4dea589bff29349a97acdeb4e2e258b05_2.file.product-list-jsonld.tpl.php |
| 889 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/19/c2/36/19c23651dd8e5a657986f75ad3e7c7167aa0d27f_2.file.pagination-seo.tpl.php |
| 890 | /vendor/smarty/smarty/libs/plugins/modifier.replace.php |
| 891 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/3c/b4/d4/3cb4d4ec1523b3009b91de48efb2933e74ab325f_2.file.stylesheets.tpl.php |
| 892 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/72/13/62/7213626f86446d34d59453e02af5fb69d97025dd_2.file.javascript.tpl.php |
| 893 | /classes/ProductDownload.php |
| 894 | /src/Core/Cart/Calculator.php |
| 895 | /src/Core/Cart/CartRowCollection.php |
| 896 | /src/Core/Cart/Fees.php |
| 897 | /src/Core/Cart/AmountImmutable.php |
| 898 | /src/Core/Cart/CartRuleCollection.php |
| 899 | /src/Core/Cart/CartRuleCalculator.php |
| 900 | /src/Adapter/Product/PriceCalculator.php |
| 901 | /src/Core/Cart/CartRow.php |
| 902 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/13/38/18/133818d94af85e215f1759076eeb455cecbcb3ee_2.file.product-activation.tpl.php |
| 903 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4d/79/7c/4d797c45b1615515aa294aa9cb1579d3b547a6a2_2.file.header.tpl.php |
| 904 | /modules/ps_contactinfo/ps_contactinfo.php |
| 905 | /var/cache/dev/smarty/compile/classic/0e/b2/11/0eb2119957cbc13b240126b3ccd8fac8f109f1e2_2.module.ps_contactinfonav.tpl.php |
| 906 | /modules/ps_languageselector/ps_languageselector.php |
| 907 | /var/cache/dev/smarty/compile/classic/1c/00/f7/1c00f78dace25d509ec3a1f54176b7ae2000accf_2.module.ps_languageselectorps_languageselector.tpl.php |
| 908 | /modules/ps_currencyselector/ps_currencyselector.php |
| 909 | /var/cache/dev/smarty/compile/classic/b9/77/56/b97756c07f8c7dd53da6530f78f67ddd242f77c9_2.module.ps_currencyselectorps_currencyselector.tpl.php |
| 910 | /modules/ps_customersignin/ps_customersignin.php |
| 911 | /var/cache/dev/smarty/compile/classic/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.ps_customersigninps_customersignin.tpl.php |
| 912 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php |
| 913 | /var/cache/dev/smarty/compile/classic/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.ps_shoppingcartps_shoppingcart.tpl.php |
| 914 | /modules/ps_mainmenu/ps_mainmenu.php |
| 915 | /modules/ps_mainmenu/ps_menutoplinks.class.php |
| 916 | /var/cache/dev/smarty/compile/classic/41/df/19/41df1985130dffd7d3fe4cb369091546a0b40be7_2.module.ps_mainmenups_mainmenu.tpl.php |
| 917 | /var/cache/dev/smarty/compile/classic/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.ps_searchbarps_searchbar.tpl.php |
| 918 | /modules/pagesnotfound/pagesnotfound.php |
| 919 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/1e/09/df/1e09df3ce8dd2fd97424a030609d1924cfb00fef_2.file.notifications.tpl.php |
| 920 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/1b/bc/63/1bbc63d5c323b111a63b8e70f054080de5a08a93_2.file.breadcrumb.tpl.php |
| 921 | /modules/ps_categorytree/ps_categorytree.php |
| 922 | /var/cache/dev/smarty/compile/classic/89/21/00/8921007f54626fc7fe42cbff53f1d70828d3393d_2.module.ps_categorytreeviewstemplateshookps_categorytree.tpl.php |
| 923 | /modules/ps_supplierlist/ps_supplierlist.php |
| 924 | /modules/ps_brandlist/ps_brandlist.php |
| 925 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php |
| 926 | /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php |
| 927 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php |
| 928 | /var/cache/dev/smarty/cache/ps_brandlist/1/1/1/1/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 |
