Accesorios para el hogar
Details matter! Liven up your interior with our selection of home accessories.
Filtros activos
Details matter! Liven up your interior with our selection of home accessories.
Filtros activos
| Load Time | 513.032 ms |
| Querying Time | 85 ms |
| Queries | 227 |
| Memory Peak Usage | 48.4 Mb |
| Included Files | 1062 files - 12.79 Mb |
| PrestaShop Cache | - Mb |
| Global vars | 0.15 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 | 157.960 ms | 157.960 ms | 23.03 Mb | 24.1 Mb |
| __construct | 0.060 ms | 158.020 ms | - Mb | 24.1 Mb |
| init | 33.619 ms | 191.639 ms | 3.26 Mb | 26.4 Mb |
| checkAccess | 0.001 ms | 191.640 ms | - Mb | 26.4 Mb |
| setMedia | 35.200 ms | 226.840 ms | 3.67 Mb | 30.0 Mb |
| postProcess | 0.002 ms | 226.842 ms | - Mb | 30.0 Mb |
| initHeader | 0.003 ms | 226.845 ms | - Mb | 30.0 Mb |
| initContent | 158.691 ms | 385.536 ms | 9.76 Mb | 39.8 Mb |
| initFooter | 0.003 ms | 385.539 ms | - Mb | 39.8 Mb |
| display | 127.493 ms | 513.032 ms | 8.00 Mb | 48.4 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| DisplayHeader | 29.009 ms | 3.91 Mb |
| displayProductListReviews | 25.411 ms | 2.03 Mb |
| ActionFrontControllerSetMedia | 25.234 ms | 2.67 Mb |
| displayNav2 | 5.666 ms | 0.36 Mb |
| displayLeftColumn | 5.415 ms | 0.33 Mb |
| DisplayBeforeBodyClosingTag | 5.140 ms | 0.36 Mb |
| displayFooter | 2.680 ms | 0.20 Mb |
| ProductSearchProvider | 2.108 ms | 0.16 Mb |
| displayTop | 2.089 ms | 0.13 Mb |
| displayNav1 | 1.944 ms | 0.07 Mb |
| DisplayFooter | 1.523 ms | 0.12 Mb |
| displayFooterBefore | 1.396 ms | 0.11 Mb |
| DisplayLeftColumn | 0.212 ms | 0.01 Mb |
| DisplayTop | 0.114 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.011 ms | - Mb |
| DisplayNavFullWidth | 0.008 ms | - Mb |
| DisplayFooterAfter | 0.006 ms | - Mb |
| ModuleRoutes | 0.005 ms | - Mb |
| DisplayFooterBefore | 0.005 ms | - Mb |
| 19 hook(s) | 107.976 ms | 10.47 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| ps_checkout | 38.739 ms | 5.81 Mb |
| blockreassurance | 1.958 ms | 0.22 Mb |
| blockwishlist | 1.997 ms | 0.18 Mb |
| ps_emailsubscription | 2.769 ms | 0.34 Mb |
| ps_socialfollow | 1.247 ms | 0.12 Mb |
| ps_facebook | 13.671 ms | 1.16 Mb |
| ps_emailalerts | 2.287 ms | 0.24 Mb |
| ps_accounts | 1.510 ms | 0.20 Mb |
| ps_shoppingcart | 1.629 ms | 0.13 Mb |
| ps_searchbar | 1.524 ms | 0.08 Mb |
| ps_imageslider | 1.920 ms | 0.21 Mb |
| productcomments | 26.934 ms | 2.22 Mb |
| psshipping | 15.434 ms | 1.74 Mb |
| ps_googleanalytics | 4.468 ms | 1.64 Mb |
| psxmarketingwithgoogle | 2.033 ms | 0.15 Mb |
| ps_facetedsearch | 6.321 ms | 0.62 Mb |
| ps_contactinfo | 3.725 ms | 0.17 Mb |
| ps_languageselector | 1.418 ms | 0.09 Mb |
| ps_currencyselector | 2.760 ms | 0.18 Mb |
| ps_customersignin | 1.269 ms | 0.08 Mb |
| ps_mainmenu | 5.813 ms | 0.34 Mb |
| pagesnotfound | 0.890 ms | 0.05 Mb |
| ps_categorytree | 4.562 ms | 0.32 Mb |
| ps_supplierlist | 0.838 ms | 0.08 Mb |
| ps_brandlist | 1.777 ms | 0.15 Mb |
| ps_linklist | 7.849 ms | 1.81 Mb |
| ps_customeraccountlinks | 1.032 ms | 0.10 Mb |
| statsdata | 2.889 ms | 0.14 Mb |
| 28 module(s) | 159.263 ms | 18.56 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 85 | 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN dfdu_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=11)) AND ((fp_3.id_feature_value=1)) AND ((fp_4.id_feature_value=9)) GROUP BY pac.id_attribute |
4.196 ms | 81 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 37 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 8 AND `id_shop` = 1 LIMIT 1 |
2.895 ms | 1 | /classes/Category.php:2454 | ||
| 93 | SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) GROUP BY p.id_manufacturer |
2.863 ms | 729 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 83 | 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>12 AND c.nright<13 GROUP BY cp.id_category |
2.259 ms | 81 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 80 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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 23:36:48' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-03-14 23:36:48' <= 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) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN dfdu_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=11)) AND ((fp_3.id_feature_value=1)) AND ((fp_4.id_feature_value=9)) |
2.178 ms | 729 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 88 | 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=11)) AND ((fp_3.id_feature_value=9)) GROUP BY fp.id_feature_value |
2.130 ms | 18 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 94 | SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) GROUP BY p.condition |
1.848 ms | 729 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 99 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN dfdu_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=11)) AND ((fp_3.id_feature_value=1)) AND ((fp_4.id_feature_value=9)) GROUP BY pac.id_attribute |
1.791 ms | 81 | 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND p.date_add>'2026-02-23 00:00:00' |
1.789 ms | 729 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN dfdu_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((p.on_sale=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=11)) AND ((fp_3.id_feature_value=1)) AND ((fp_4.id_feature_value=9)) |
1.788 ms | 729 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 97 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN dfdu_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((a.id_attribute_group=3)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=11)) AND ((fp_3.id_feature_value=1)) AND ((fp_4.id_feature_value=9)) GROUP BY pac.id_attribute |
1.786 ms | 18 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 14 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `dfdu_module` m INNER JOIN dfdu_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1) INNER JOIN `dfdu_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `dfdu_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `dfdu_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
1.653 ms | 150 | Yes | Yes | /classes/Hook.php:1500 |
| 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 |
1.606 ms | 1 | /classes/Language.php:1204 | ||
| 73 | 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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 |
1.535 ms | 81 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 90 | 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=11)) AND ((fp_3.id_feature_value=1)) GROUP BY fp.id_feature_value |
1.422 ms | 144 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 87 | 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value=1)) AND ((fp_2.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) GROUP BY pac.id_attribute |
1.325 ms | 729 | 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) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute=11)) AND ((fp_1.id_feature_value=1)) AND ((fp_2.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) |
1.285 ms | 729 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 95 | SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM dfdu_product p INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 |
1.236 ms | 9 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 76 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute=11)) AND ((fp_1.id_feature_value=1)) AND ((fp_2.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) |
1.179 ms | 729 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 77 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute=11)) AND ((fp_1.id_feature_value=1)) AND ((fp_2.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) |
1.173 ms | 729 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 105 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `dfdu_hook_alias` ha INNER JOIN `dfdu_hook` h ON ha.name = h.name |
1.159 ms | 0 | /classes/Hook.php:1568 | ||
| 81 | 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) LEFT JOIN dfdu_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN dfdu_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=11)) AND ((fp_2.id_feature_value=1)) AND ((fp_3.id_feature_value=9)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 |
1.041 ms | 9 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 106 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `dfdu_hook_module` hm STRAIGHT_JOIN `dfdu_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `dfdu_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
0.758 ms | 374 | /classes/Hook.php:495 | ||
| 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.750 ms | 499 | /classes/Configuration.php:182 | ||
| 220 | INSERT INTO `dfdu_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('7046', '', 'izzywine.com/8-home-accessories?q=Disponibilidad-En+stock%2FComposici%C3%B3n-Poli%C3%A9ster%2FPropiedad-Funda+extra%C3%ADble%2FColor-Negro', '', '2026-03-14 23:36:48') |
0.726 ms | 1 | /classes/ObjectModel.php:535 | ||
| 86 | 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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC |
0.671 ms | 25 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 100 | REPLACE INTO dfdu_layered_filter_block (hash, data) VALUES ("d1953d0bec141650e55ccd315963b90d", "a:1:{s:7:\"filters\";a:10:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilidad\";s:6:\"values\";a:2:{i:2;a:3:{s:4:\"name\";s:8:\"En stock\";s:3:\"nbr\";i:3;s:7:\"checked\";b:1;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";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:11:\"Selecciones\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:9:\"En oferta\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:13:\"Con descuento\";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:6:\"Precio\";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:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##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:11:\"Categorías\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:2;s:4:\"name\";s:5:\"Color\";s:14:\"is_color_group\";b:1;s:6:\"values\";a:2:{i:8;a:5:{s:4:\"name\";s:6:\"Blanco\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ffffff\";}i:11;a:6:{s:4:\"name\";s:5:\"Negro\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#434A54\";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;}i:5;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:1;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:10:\"Poliéster\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:12:\"Composición\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:2;s:6:\"values\";a:1:{i:9;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:16:\"Funda extraíble\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:9:\"Propiedad\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;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:\"Marca\";s:6:\"values\";a:1:{i:1;a:2:{s:4:\"name\";s:13:\"Studio Design\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:8;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:6:\"Estado\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";i:3;}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usado\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:15:\"Reacondicionado\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:9;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:4:\"Peso\";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;}}}") |
0.641 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:209 | ||
| 64 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 8 AND `id_shop` = 1 LIMIT 1 |
0.627 ms | 1 | /classes/Category.php:2454 | ||
| 177 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `dfdu_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `dfdu_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC |
0.616 ms | 9 | Yes | Yes | /classes/Category.php:815 |
| 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` = 2 AND cl.id_shop = 1 ) LEFT JOIN `dfdu_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 8 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.600 ms | 1 | Yes | Yes | /classes/Category.php:946 |
| 92 | SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `dfdu_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC |
0.499 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 89 | 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` = 2) LEFT JOIN `dfdu_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 1 ORDER BY vl.`value` ASC |
0.456 ms | 10 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 13 | SELECT SQL_NO_CACHE lower(name) as name FROM `dfdu_hook` h WHERE (h.active = 1) |
0.453 ms | 1186 | /classes/Hook.php:1608 | ||
| 194 | 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pac.id_product_attribute IN (22,23) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.450 ms | 2 | /classes/Product.php:2507 | ||
| 142 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9) AND (b.`id_shop` = 1) LIMIT 1 |
0.438 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 128 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2) 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 10 AND pac.`id_product_attribute` = 25 AND agl.`id_lang` = 2 |
0.421 ms | 1 | /classes/Product.php:7216 | ||
| 147 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10) AND (b.`id_shop` = 1) LIMIT 1 |
0.414 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 101 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-03-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 = 2 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 (9,10,11) |
0.408 ms | 3 | /classes/ProductAssembler.php:101 | ||
| 16 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` |
0.401 ms | 1186 | /classes/Hook.php:1568 | ||
| 178 | SELECT SQL_NO_CACHE DISTINCT c.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2) WHERE `level_depth` = 1 |
0.395 ms | 1 | /classes/Category.php:2247 | ||
| 196 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (10) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.382 ms | 2 | Yes | Yes | /classes/Product.php:4304 |
| 67 | 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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC |
0.375 ms | 25 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 190 | 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` = 9) LIMIT 1 |
0.363 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 154 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_contactinfo" LIMIT 1 |
0.356 ms | 1 | /classes/module/Module.php:2781 | ||
| 91 | 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` = 2) LEFT JOIN `dfdu_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 2 ORDER BY vl.`value` ASC |
0.341 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 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.340 ms | 1 | /classes/Language.php:1070 | ||
| 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` = 2) 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` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC |
0.340 ms | 4 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 |
| 112 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 9 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` = 9 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.330 ms | 0 | /classes/Cart.php:1450 | ||
| 17 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.320 ms | 75 | /classes/module/Module.php:343 | ||
| 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` < 12) AND (a0.`nright` > 13) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.319 ms | 9 | Yes | /classes/PrestaShopCollection.php:381 | |
| 204 | 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` = 2) 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 11 AND pac.`id_product_attribute` = 26 AND agl.`id_lang` = 2 |
0.318 ms | 1 | /classes/Product.php:7216 | ||
| 186 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (9) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.317 ms | 2 | Yes | Yes | /classes/Product.php:4304 |
| 84 | 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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC |
0.316 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 65 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM dfdu_layered_category WHERE controller = 'category' AND id_category = 8 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.314 ms | 13 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:57 |
| 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.314 ms | 43 | Yes | /classes/Dispatcher.php:643 | |
| 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.313 ms | 1 | Yes | /classes/shop/Shop.php:716 | |
| 187 | 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` = 2) 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 9 AND pac.`id_product_attribute` = 22 AND agl.`id_lang` = 2 |
0.308 ms | 1 | /classes/Product.php:7216 | ||
| 207 | 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` = 11 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.303 ms | 2 | Yes | Yes | /classes/Product.php:2492 |
| 150 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 11) AND (b.`id_shop` = 1) LIMIT 1 |
0.293 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 41 | SELECT SQL_NO_CACHE * FROM `dfdu_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.290 ms | 1 | /classes/module/Module.php:2171 | ||
| 50 | SELECT SQL_NO_CACHE format FROM `dfdu_address_format` WHERE `id_country` = 6 LIMIT 1 |
0.288 ms | 1 | /classes/AddressFormat.php:649 | ||
| 98 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC |
0.287 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 203 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (11) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.276 ms | 2 | Yes | Yes | /classes/Product.php:4304 |
| 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` = 2 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 8) AND (b.`id_shop` = 1) LIMIT 1 |
0.276 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 116 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2) 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 9 AND pac.`id_product_attribute` = 23 AND agl.`id_lang` = 2 |
0.274 ms | 1 | /classes/Product.php:7216 | ||
| 122 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 10 AND `id_group` = 1 LIMIT 1 |
0.273 ms | 0 | /classes/GroupReduction.php:146 | ||
| 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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC |
0.268 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 68 | 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` = 2) 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` = 2) ORDER BY f.`position` ASC |
0.267 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 | |
| 222 | SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `dfdu_category_product` cp LEFT JOIN `dfdu_category` c ON (c.id_category = cp.id_category) LEFT JOIN `dfdu_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (9,10,11) AND cl.`id_lang` = 2 ORDER BY c.`level_depth` DESC |
0.267 ms | 9 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 | |
| 197 | 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` = 2) 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 10 AND pac.`id_product_attribute` = 24 AND agl.`id_lang` = 2 |
0.263 ms | 1 | /classes/Product.php:7216 | ||
| 223 | SELECT SQL_NO_CACHE `name` FROM `dfdu_manufacturer` WHERE `id_manufacturer` = 1 AND `active` = 1 LIMIT 1 |
0.259 ms | 1 | /classes/Manufacturer.php:306 | ||
| 135 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 11 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` = 11 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 | ||
| 82 | 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` = 2 AND c.`active` = 1 ORDER BY c.nleft, c.position |
0.253 ms | 9 | Yes | /classes/Category.php:744 | |
| 114 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 23 AND cp.`id_cart` = 0 AND cp.`id_product` = 9 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` = 23 AND cp.`id_cart` = 0 AND p.`id_product_item` = 9 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.252 ms | 0 | /classes/Cart.php:1450 | ||
| 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.251 ms | 75 | /classes/module/Module.php:343 | ||
| 126 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 25 AND cp.`id_cart` = 0 AND cp.`id_product` = 10 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` = 25 AND cp.`id_cart` = 0 AND p.`id_product_item` = 10 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.250 ms | 0 | /classes/Cart.php:1450 | ||
| 201 | 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pac.id_product_attribute IN (24,25) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.249 ms | 2 | /classes/Product.php:2507 | ||
| 0 | SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM dfdu_shop_url su LEFT JOIN dfdu_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'izzywine.com' OR su.domain_ssl = 'izzywine.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.248 ms | 1 | Yes | /classes/shop/Shop.php:1392 | |
| 124 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 10 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` = 10 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.248 ms | 0 | /classes/Cart.php:1450 | ||
| 107 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 9
AND tr.`id_state` IN (0, 353)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.245 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 71 | 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` = 8) LIMIT 1 |
0.243 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 225 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2 ) WHERE pac.`id_product_attribute` = 25 ORDER BY ag.`position` ASC, a.`position` ASC |
0.240 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 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` = 1 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 8) AND (b.`id_shop` = 1) LIMIT 1 |
0.239 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 157 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.234 ms | 1 | /classes/module/Module.php:2781 | ||
| 181 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 12 AND c.`nright` >= 13 AND c.`nleft` >= 2 AND c.`nright` <= 17 ORDER BY `nleft` DESC |
0.233 ms | 9 | Yes | /classes/Category.php:1617 | |
| 214 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_linklist" LIMIT 1 |
0.229 ms | 1 | /classes/module/Module.php:2781 | ||
| 139 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2) 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 11 AND pac.`id_product_attribute` = 27 AND agl.`id_lang` = 2 |
0.227 ms | 1 | /classes/Product.php:7216 | ||
| 198 | 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` = 10) LIMIT 1 |
0.227 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 69 | 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` = 2) LEFT JOIN `dfdu_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 1 ORDER BY vl.`value` ASC |
0.226 ms | 10 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 118 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 23) LIMIT 1 |
0.226 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 200 | 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` = 10 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.225 ms | 2 | Yes | Yes | /classes/Product.php:2492 |
| 208 | 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` = 2) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pac.id_product_attribute IN (26,27) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.224 ms | 2 | /classes/Product.php:2507 | ||
| 137 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 27 AND cp.`id_cart` = 0 AND cp.`id_product` = 11 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` = 27 AND cp.`id_cart` = 0 AND p.`id_product_item` = 11 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.220 ms | 0 | /classes/Cart.php:1450 | ||
| 141 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 27 |
0.220 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 117 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 9
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.219 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 205 | 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` = 11) LIMIT 1 |
0.218 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 148 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) WHERE i.`id_product` = 10 ORDER BY `position` |
0.215 ms | 2 | Yes | /classes/Product.php:3285 | |
| 63 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration_lang` WHERE `id_configuration` = 479 |
0.215 ms | 1 | /src/Adapter/EntityMapper.php:82 | ||
| 193 | 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` = 9 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.213 ms | 2 | Yes | Yes | /classes/Product.php:2492 |
| 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.212 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 153 | SELECT SQL_NO_CACHE 1 FROM dfdu_cart_product cp INNER JOIN dfdu_product p ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1 |
0.212 ms | 1 | /classes/Cart.php:4072 | ||
| 18 | SELECT SQL_NO_CACHE name, alias FROM `dfdu_hook_alias` |
0.212 ms | 86 | /classes/Hook.php:371 | ||
| 151 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) WHERE i.`id_product` = 11 ORDER BY `position` |
0.211 ms | 2 | Yes | /classes/Product.php:3285 | |
| 206 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 11 AND `id_shop` = 1 |
0.211 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 176 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 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.210 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 219 | SELECT SQL_NO_CACHE `id_guest` FROM `dfdu_connections` WHERE `id_guest` = 7041 AND `date_add` > '2026-03-14 23:06:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.209 ms | 1 | Yes | /classes/Connection.php:168 | |
| 166 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.203 ms | 1 | /classes/module/Module.php:2270 | ||
| 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.200 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 155 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1 |
0.198 ms | 1 | /classes/module/Module.php:2270 | ||
| 57 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_facebook" LIMIT 1 |
0.197 ms | 1 | /classes/module/Module.php:2781 | ||
| 144 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) WHERE i.`id_product` = 9 ORDER BY `position` |
0.197 ms | 2 | Yes | /classes/Product.php:3285 | |
| 15 | SELECT SQL_NO_CACHE `name`, `alias` FROM `dfdu_hook_alias` |
0.196 ms | 86 | /classes/Hook.php:319 | ||
| 43 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.194 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 162 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c INNER JOIN dfdu_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC |
0.193 ms | 1 | Yes | /classes/Currency.php:687 | |
| 191 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 9 AND `id_shop` = 1 |
0.192 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 24 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.189 ms | 1 | /classes/Currency.php:893 | ||
| 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.189 ms | 1 | /classes/Configuration.php:135 | ||
| 70 | 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` = 2) LEFT JOIN `dfdu_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 2 ORDER BY vl.`value` ASC |
0.188 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 115 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 9 AND pa.`id_product` = 9 AND pa.`id_product_attribute` = 23 LIMIT 1 |
0.184 ms | 1 | /classes/Product.php:1180 | ||
| 72 | SELECT SQL_NO_CACHE * FROM `dfdu_category_lang` WHERE `id_category` = 8 AND `id_shop` = 1 |
0.183 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 129 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 25) LIMIT 1 |
0.183 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` = 2) LIMIT 1 |
0.181 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 145 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 9 AND il.`id_lang` = 2 ORDER by i.`position` |
0.181 ms | 2 | Yes | /classes/Product.php:2668 | |
| 121 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10) |
0.180 ms | 2 | /classes/Product.php:3629 | ||
| 45 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.179 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 10 | SELECT SQL_NO_CACHE domain, domain_ssl FROM dfdu_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.176 ms | 1 | /classes/shop/ShopUrl.php:178 | ||
| 21 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c ORDER BY `iso_code` ASC |
0.176 ms | 1 | Yes | /classes/Currency.php:708 | |
| 104 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 9) |
0.176 ms | 2 | /classes/Product.php:3629 | ||
| 74 | SELECT SQL_NO_CACHE data FROM dfdu_layered_filter_block WHERE hash="d1953d0bec141650e55ccd315963b90d" LIMIT 1 |
0.173 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:185 | ||
| 127 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 10 AND pa.`id_product` = 10 AND pa.`id_product_attribute` = 25 LIMIT 1 |
0.173 ms | 1 | /classes/Product.php:1180 | ||
| 152 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 11 AND il.`id_lang` = 2 ORDER by i.`position` |
0.173 ms | 2 | Yes | /classes/Product.php:2668 | |
| 173 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.169 ms | 1 | /classes/module/Module.php:2270 | ||
| 172 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.168 ms | 1 | /classes/module/Module.php:2781 | ||
| 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` = 2 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.167 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 140 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 27) LIMIT 1 |
0.167 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 199 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 10 AND `id_shop` = 1 |
0.165 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 102 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 0 LIMIT 1 |
0.164 ms | 1 | /classes/SpecificPrice.php:433 | ||
| 110 | SELECT SQL_NO_CACHE tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 353)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.163 ms | 0 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 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` = 2 ) WHERE pac.`id_product_attribute` = 23 ORDER BY ag.`position` ASC, a.`position` ASC |
0.163 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 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.162 ms | 1 | /classes/shop/Shop.php:215 | ||
| 161 | SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `dfdu_currency` c LEFT JOIN dfdu_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1 |
0.162 ms | 1 | /classes/Currency.php:1120 | ||
| 149 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 10 AND il.`id_lang` = 2 ORDER by i.`position` |
0.162 ms | 2 | Yes | /classes/Product.php:2668 | |
| 226 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2 ) WHERE pac.`id_product_attribute` = 27 ORDER BY ag.`position` ASC, a.`position` ASC |
0.160 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 159 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.160 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.159 ms | 1 | /modules/ps_accounts/src/Adapter/Configuration.php:278 | ||
| 108 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 9 AND `id_group` = 1 LIMIT 1 |
0.159 ms | 0 | /classes/GroupReduction.php:146 | ||
| 138 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 11 AND pa.`id_product` = 11 AND pa.`id_product_attribute` = 27 LIMIT 1 |
0.159 ms | 1 | /classes/Product.php:1180 | ||
| 113 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 9) AND (id_product_attribute = 23) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.157 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 217 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1 |
0.157 ms | 1 | /classes/module/Module.php:2270 | ||
| 170 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_mainmenu" LIMIT 1 |
0.156 ms | 1 | /classes/module/Module.php:2781 | ||
| 132 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 11) |
0.155 ms | 2 | /classes/Product.php:3629 | ||
| 163 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.155 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 210 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.154 ms | 1 | /classes/module/Module.php:2781 | ||
| 146 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` |
0.152 ms | 7 | /classes/ImageType.php:161 | ||
| 179 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`id_category` = 8 LIMIT 1 |
0.151 ms | 1 | /classes/Category.php:1607 | ||
| 12 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `iso_code` = 'es' LIMIT 1 |
0.151 ms | 1 | /classes/Language.php:844 | ||
| 40 | SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM dfdu_shop s |
0.150 ms | 1 | /classes/shop/Shop.php:922 | ||
| 125 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 10) AND (id_product_attribute = 25) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.150 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 175 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.150 ms | 1 | /classes/module/Module.php:2270 | ||
| 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.149 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 188 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "productcomments" LIMIT 1 |
0.147 ms | 1 | /classes/module/Module.php:2781 | ||
| 51 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.146 ms | 1 | /classes/Country.php:406 | ||
| 111 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 9) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.146 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 182 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_supplierlist" LIMIT 1 |
0.146 ms | 1 | /classes/module/Module.php:2781 | ||
| 54 | SELECT SQL_NO_CACHE * FROM `dfdu_state` a WHERE (a.`id_state` = 353) LIMIT 1 |
0.145 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 119 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 23 |
0.145 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 174 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.145 ms | 1 | /classes/module/Module.php:2781 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `dfdu_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.144 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 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` = 2 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.144 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 38 | SELECT SQL_NO_CACHE ctg.`id_group` FROM dfdu_category_group ctg WHERE ctg.`id_category` = 8 AND ctg.`id_group` = 1 LIMIT 1 |
0.143 ms | 1 | /classes/Category.php:1774 | ||
| 59 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.143 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 35 | SELECT SQL_NO_CACHE * FROM `dfdu_group_lang` WHERE `id_group` = 1 |
0.142 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 167 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.141 ms | 1 | /classes/module/Module.php:2781 | ||
| 136 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 11) AND (id_product_attribute = 27) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.139 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 165 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.139 ms | 1 | /classes/module/Module.php:2781 | ||
| 109 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_group` WHERE `id_group` = 1 LIMIT 1 |
0.138 ms | 1 | /classes/Group.php:151 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `dfdu_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.137 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 123 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 10) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.137 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 169 | SELECT SQL_NO_CACHE SUM(`quantity`) FROM `dfdu_cart_product` WHERE `id_cart` = 0 LIMIT 1 |
0.137 ms | 1 | /classes/Cart.php:1321 | ||
| 209 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 11) AND (id_product_attribute = 26) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.137 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 164 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 2 |
0.137 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 202 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 10) AND (id_product_attribute = 24) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.136 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 218 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.136 ms | 1 | /classes/Country.php:406 | ||
| 120 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 10 LIMIT 1 |
0.135 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 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.134 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 46 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `manufacturers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.134 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 221 | SELECT SQL_NO_CACHE data FROM `dfdu_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.134 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39 | ||
| 22 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT 1 |
0.133 ms | 1 | /classes/Language.php:870 | ||
| 23 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.132 ms | 1 | /classes/shop/Shop.php:1211 | ||
| 47 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `suppliers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.131 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 143 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 8 LIMIT 1 |
0.129 ms | 1 | /classes/Category.php:1396 | ||
| 180 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c WHERE c.`id_category` = 2 LIMIT 1 |
0.128 ms | 1 | /classes/Category.php:1612 | ||
| 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 | |
| 192 | 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` = 8 LIMIT 1 |
0.127 ms | 0 | /classes/Category.php:1396 | ||
| 26 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT 1 |
0.127 ms | 1 | /classes/Language.php:870 | ||
| 216 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1 |
0.126 ms | 1 | /classes/module/Module.php:2781 | ||
| 48 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.124 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 55 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM dfdu_required_field |
0.124 ms | 1 | /classes/ObjectModel.php:1437 | ||
| 134 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 11) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.124 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 212 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.122 ms | 1 | /classes/module/Module.php:2781 | ||
| 131 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 11 LIMIT 1 |
0.120 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 9 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_lang_shop` WHERE `id_lang` = 2 AND id_shop = 1 LIMIT 1 |
0.119 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 32 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 1 |
0.119 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 158 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.119 ms | 1 | /classes/module/Module.php:2270 | ||
| 171 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1 |
0.119 ms | 1 | /classes/module/Module.php:2270 | ||
| 215 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1 |
0.119 ms | 1 | /classes/module/Module.php:2270 | ||
| 62 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration` a WHERE (a.`id_configuration` = 479) LIMIT 1 |
0.118 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 58 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1 |
0.117 ms | 1 | /classes/module/Module.php:2270 | ||
| 156 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.117 ms | 1 | /classes/Country.php:406 | ||
| 160 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.117 ms | 1 | /classes/module/Module.php:2270 | ||
| 184 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_brandlist" LIMIT 1 |
0.117 ms | 1 | /classes/module/Module.php:2781 | ||
| 211 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.116 ms | 1 | /classes/module/Module.php:2270 | ||
| 130 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 25 |
0.115 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 53 | SELECT SQL_NO_CACHE * FROM `dfdu_country_lang` WHERE `id_country` = 6 |
0.115 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 36 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.114 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 30 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT 1 |
0.113 ms | 1 | /classes/Language.php:870 | ||
| 103 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 9 LIMIT 1 |
0.113 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 189 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.113 ms | 1 | /classes/module/Module.php:2270 | ||
| 183 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 36 AND `id_shop` = 1 LIMIT 1 |
0.111 ms | 1 | /classes/module/Module.php:2270 | ||
| 27 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT 1 |
0.110 ms | 1 | /classes/Language.php:870 | ||
| 28 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'USD') LIMIT 1 |
0.110 ms | 1 | /classes/Currency.php:893 | ||
| 195 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 9) AND (id_product_attribute = 22) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.110 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 133 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 11 AND `id_group` = 1 LIMIT 1 |
0.108 ms | 0 | /classes/GroupReduction.php:146 | ||
| 168 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.107 ms | 1 | /classes/module/Module.php:2270 | ||
| 213 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.107 ms | 1 | /classes/module/Module.php:2270 | ||
| 33 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.105 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 185 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 59 AND `id_shop` = 1 LIMIT 1 |
0.102 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 |
| 9 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
|
| 6 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
|
| 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` = 'es-es'
OR `language_code` = 'es-es' LIMIT XX
|
| 4 queries |
SELECT v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `dfdu_feature_value` v LEFT JOIN `dfdu_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `dfdu_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC |
| 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) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((sa.quantity>XX)) AND ((pac_XX.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN 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) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((fp_XX.id_feature_value=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 * 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)
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 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) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((sa.quantity>XX)) AND ((pac_XX.id_attribute=XX)) AND ((fp_XX.id_feature_value=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN 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) LEFT JOIN dfdu_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute=XX)) AND ((fp_XX.id_feature_value=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 |
| 76 product_attribute_combination |
| 64 feature_product |
| 52 product_attribute |
| 44 stock_available |
| 38 product |
| 33 category |
| 32 product_shop |
| 24 attribute |
| 22 module |
| 22 category_group |
| 21 category_product |
| 21 product_attribute_shop |
| 20 attribute_lang |
| 19 module_shop |
| 16 product_sale |
| 15 attribute_group |
| 15 attribute_group_lang |
| 14 category_lang |
| 14 cart_product |
| 10 category_shop |
| 9 currency |
| 9 product_attribute_lang |
| 8 lang |
| 7 currency_shop |
| 7 product_lang |
| 6 hook |
| 6 image_type |
| 6 attribute_group_shop |
| 6 pack |
| 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 |
| 4 feature_value |
| 4 feature_value_lang |
| 4 layered_indexable_feature_value_lang_value |
| 3 hook_alias |
| 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 |
| 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 manufacturer_shop |
| 1 manufacturer_lang |
| 1 connections |
| 1 ganalytics_data |
| Name | Instances | Source |
|---|---|---|
| Category | 18 |
/controllers/front/listing/CategoryController.php:87 (__construct) [id: 8]
/classes/Meta.php:364 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 8] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /classes/Link.php:416 (__construct) [id: 8] /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: 8] |
| Product | 15 |
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 9]
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 10] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 11] /classes/Link.php:114 (__construct) [id: 9] /classes/Link.php:114 (__construct) [id: 10] /classes/Link.php:114 (__construct) [id: 11] /classes/Link.php:114 (__construct) [id: 9] /classes/Link.php:114 (__construct) [id: 9] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 9] /classes/Link.php:114 (__construct) [id: 10] /classes/Link.php:114 (__construct) [id: 10] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 10] /classes/Link.php:114 (__construct) [id: 11] /classes/Link.php:114 (__construct) [id: 11] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 11] |
| 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: ] |
| Language | 4 |
/config/config.inc.php:219 (__construct) [id: 2]
/classes/Dispatcher.php:553 (__construct) [id: 2] /classes/Tools.php:659 (__construct) [id: 2] /classes/Tools.php:553 (__construct) [id: 2] |
| 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] |
| Combination | 3 |
/classes/Product.php:5671 (__construct) [id: 23]
/classes/Product.php:5671 (__construct) [id: 25] /classes/Product.php:5671 (__construct) [id: 27] |
| 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/es.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.es-ES.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/es.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/es.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 | /var/cache/dev/PsshippingFrontContainer.php |
| 720 | /modules/psshipping/src/Hooks/HookDisplayHeader.php |
| 721 | /modules/psshipping/src/Domain/GelProximity/GelProximityService.php |
| 722 | /modules/psshipping/src/Domain/Carriers/CarrierRepository.php |
| 723 | /src/Adapter/ContainerFinder.php |
| 724 | /vendor/doctrine/dbal/src/Logging/LoggerChain.php |
| 725 | /vendor/doctrine/dbal/src/Logging/SQLLogger.php |
| 726 | /vendor/symfony/doctrine-bridge/Logger/DbalLogger.php |
| 727 | /vendor/doctrine/dbal/src/Logging/DebugStack.php |
| 728 | /vendor/doctrine/doctrine-bundle/ConnectionFactory.php |
| 729 | /src/PrestaShopBundle/DependencyInjection/RuntimeConstEnvVarProcessor.php |
| 730 | /vendor/symfony/dependency-injection/EnvVarProcessorInterface.php |
| 731 | /vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php |
| 732 | /vendor/doctrine/event-manager/src/EventManager.php |
| 733 | /vendor/doctrine/dbal/src/DriverManager.php |
| 734 | /vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php |
| 735 | /vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php |
| 736 | /vendor/doctrine/dbal/src/VersionAwarePlatformDriver.php |
| 737 | /vendor/doctrine/dbal/src/Driver.php |
| 738 | /src/PrestaShopBundle/Doctrine/DatabaseConnection.php |
| 739 | /vendor/doctrine/dbal/src/Connection.php |
| 740 | /vendor/doctrine/dbal/src/ArrayParameterType.php |
| 741 | /vendor/doctrine/dbal/src/ParameterType.php |
| 742 | /vendor/doctrine/dbal/src/Query/Expression/ExpressionBuilder.php |
| 743 | /vendor/doctrine/dbal/src/Schema/LegacySchemaManagerFactory.php |
| 744 | /vendor/doctrine/dbal/src/Schema/SchemaManagerFactory.php |
| 745 | /vendor/doctrine/dbal/src/Driver/PDO/Connection.php |
| 746 | /vendor/doctrine/dbal/src/Driver/ServerInfoAwareConnection.php |
| 747 | /vendor/doctrine/dbal/src/Driver/Connection.php |
| 748 | /vendor/doctrine/dbal/src/Events.php |
| 749 | /vendor/doctrine/dbal/src/Platforms/MariaDb1010Platform.php |
| 750 | /vendor/doctrine/dbal/src/Platforms/MariaDb1060Platform.php |
| 751 | /vendor/doctrine/dbal/src/Platforms/MariaDb1052Platform.php |
| 752 | /vendor/doctrine/dbal/src/Platforms/MariaDb1043Platform.php |
| 753 | /vendor/doctrine/dbal/src/Platforms/MariaDb1027Platform.php |
| 754 | /vendor/doctrine/dbal/src/Platforms/MariaDBPlatform.php |
| 755 | /vendor/doctrine/dbal/src/Platforms/MySQLPlatform.php |
| 756 | /vendor/doctrine/dbal/src/Platforms/AbstractMySQLPlatform.php |
| 757 | /vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php |
| 758 | /vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php |
| 759 | /vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php |
| 760 | /vendor/doctrine/dbal/src/Types/Types.php |
| 761 | /vendor/doctrine/dbal/src/Types/Type.php |
| 762 | /vendor/doctrine/dbal/src/Types/ArrayType.php |
| 763 | /vendor/doctrine/dbal/src/Types/AsciiStringType.php |
| 764 | /vendor/doctrine/dbal/src/Types/StringType.php |
| 765 | /vendor/doctrine/dbal/src/Types/BigIntType.php |
| 766 | /vendor/doctrine/dbal/src/Types/PhpIntegerMappingType.php |
| 767 | /vendor/doctrine/dbal/src/Types/BinaryType.php |
| 768 | /vendor/doctrine/dbal/src/Types/BlobType.php |
| 769 | /vendor/doctrine/dbal/src/Types/BooleanType.php |
| 770 | /vendor/doctrine/dbal/src/Types/DateType.php |
| 771 | /vendor/doctrine/dbal/src/Types/DateImmutableType.php |
| 772 | /vendor/doctrine/dbal/src/Types/DateIntervalType.php |
| 773 | /vendor/doctrine/dbal/src/Types/DateTimeType.php |
| 774 | /vendor/doctrine/dbal/src/Types/PhpDateTimeMappingType.php |
| 775 | /vendor/doctrine/dbal/src/Types/DateTimeImmutableType.php |
| 776 | /vendor/doctrine/dbal/src/Types/DateTimeTzType.php |
| 777 | /vendor/doctrine/dbal/src/Types/DateTimeTzImmutableType.php |
| 778 | /vendor/doctrine/dbal/src/Types/DecimalType.php |
| 779 | /vendor/doctrine/dbal/src/Types/FloatType.php |
| 780 | /vendor/doctrine/dbal/src/Types/GuidType.php |
| 781 | /vendor/doctrine/dbal/src/Types/IntegerType.php |
| 782 | /vendor/doctrine/dbal/src/Types/JsonType.php |
| 783 | /vendor/doctrine/dbal/src/Types/ObjectType.php |
| 784 | /vendor/doctrine/dbal/src/Types/SimpleArrayType.php |
| 785 | /vendor/doctrine/dbal/src/Types/SmallIntType.php |
| 786 | /vendor/doctrine/dbal/src/Types/TextType.php |
| 787 | /vendor/doctrine/dbal/src/Types/TimeType.php |
| 788 | /vendor/doctrine/dbal/src/Types/TimeImmutableType.php |
| 789 | /vendor/doctrine/dbal/src/Types/TypeRegistry.php |
| 790 | /modules/ps_googleanalytics/ps_googleanalytics.php |
| 791 | /modules/ps_googleanalytics/classes/Hook/HookDisplayHeader.php |
| 792 | /modules/ps_googleanalytics/classes/Hook/HookInterface.php |
| 793 | /modules/psxmarketingwithgoogle/psxmarketingwithgoogle.php |
| 794 | /modules/psxmarketingwithgoogle/translations/es.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 | /modules/ps_facetedsearch/src/Product/Search.php |
| 832 | /modules/ps_facetedsearch/src/Adapter/MySQL.php |
| 833 | /modules/ps_facetedsearch/src/Adapter/AbstractAdapter.php |
| 834 | /modules/ps_facetedsearch/src/Adapter/InterfaceAdapter.php |
| 835 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ArrayCollection.php |
| 836 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Collection.php |
| 837 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/ReadableCollection.php |
| 838 | /modules/ps_facetedsearch/src/Filters/Products.php |
| 839 | /classes/stock/StockAvailable.php |
| 840 | /modules/ps_facetedsearch/src/Filters/Block.php |
| 841 | /classes/Manufacturer.php |
| 842 | /src/Core/Util/String/StringModifier.php |
| 843 | /src/Core/Util/String/StringModifierInterface.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/2/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 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/f4/7d/f4/f47df452f998c0ea226f625730c9f49c8c9d905a_2.file.variant-links.tpl.php |
| 938 | /modules/productcomments/src/Repository/ProductCommentRepository.php |
| 939 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepository.php |
| 940 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepositoryInterface.php |
| 941 | /vendor/doctrine/doctrine-bundle/Registry.php |
| 942 | /vendor/symfony/doctrine-bridge/ManagerRegistry.php |
| 943 | /vendor/doctrine/persistence/src/Persistence/AbstractManagerRegistry.php |
| 944 | /vendor/doctrine/persistence/src/Persistence/ManagerRegistry.php |
| 945 | /vendor/doctrine/persistence/src/Persistence/ConnectionRegistry.php |
| 946 | /modules/productcomments/src/Entity/ProductComment.php |
| 947 | /vendor/doctrine/orm/src/Proxy/Proxy.php |
| 948 | /vendor/doctrine/common/src/Proxy/Proxy.php |
| 949 | /vendor/doctrine/persistence/src/Persistence/Proxy.php |
| 950 | /vendor/doctrine/orm/src/Proxy/InternalProxy.php |
| 951 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriverChain.php |
| 952 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/ImplicitlyIgnoredAnnotationNames.php |
| 953 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/IgnoreAnnotation.php |
| 954 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/PhpParser.php |
| 955 | /src/PrestaShopBundle/Service/Database/DoctrineNamingStrategy.php |
| 956 | /vendor/doctrine/orm/src/Mapping/UnderscoreNamingStrategy.php |
| 957 | /vendor/doctrine/orm/src/Mapping/NamingStrategy.php |
| 958 | /vendor/doctrine/orm/src/Mapping/DefaultQuoteStrategy.php |
| 959 | /vendor/doctrine/orm/src/Internal/SQLResultCasing.php |
| 960 | /vendor/doctrine/orm/src/Mapping/QuoteStrategy.php |
| 961 | /vendor/doctrine/doctrine-bundle/Mapping/ContainerEntityListenerResolver.php |
| 962 | /vendor/doctrine/doctrine-bundle/Mapping/EntityListenerServiceResolver.php |
| 963 | /vendor/doctrine/orm/src/Mapping/EntityListenerResolver.php |
| 964 | /vendor/doctrine/doctrine-bundle/Repository/ContainerRepositoryFactory.php |
| 965 | /vendor/doctrine/orm/src/Repository/RepositoryFactory.php |
| 966 | /vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php |
| 967 | /vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php |
| 968 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadataFactory.php |
| 969 | /vendor/doctrine/orm/src/Mapping/ClassMetadata.php |
| 970 | /vendor/doctrine/orm/src/Mapping/ClassMetadataInfo.php |
| 971 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadata.php |
| 972 | /vendor/doctrine/orm/src/Proxy/DefaultProxyClassNameResolver.php |
| 973 | /vendor/doctrine/persistence/src/Persistence/Mapping/ProxyClassNameResolver.php |
| 974 | /vendor/doctrine/orm/src/UnitOfWork.php |
| 975 | /vendor/doctrine/persistence/src/Persistence/PropertyChangedListener.php |
| 976 | /vendor/doctrine/orm/src/Event/ListenersInvoker.php |
| 977 | /vendor/doctrine/orm/src/Utility/IdentifierFlattener.php |
| 978 | /vendor/doctrine/orm/src/Internal/HydrationCompleteHandler.php |
| 979 | /vendor/doctrine/orm/src/Mapping/Reflection/ReflectionPropertiesGetter.php |
| 980 | /vendor/doctrine/persistence/src/Persistence/Mapping/RuntimeReflectionService.php |
| 981 | /vendor/doctrine/persistence/src/Persistence/Mapping/ReflectionService.php |
| 982 | /vendor/doctrine/orm/src/Proxy/ProxyFactory.php |
| 983 | /vendor/doctrine/common/src/Proxy/AbstractProxyFactory.php |
| 984 | /vendor/doctrine/common/src/Proxy/ProxyGenerator.php |
| 985 | /vendor/doctrine/doctrine-bundle/ManagerConfigurator.php |
| 986 | /vendor/doctrine/lexer/src/Token.php |
| 987 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php |
| 988 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/TokenParser.php |
| 989 | /vendor/doctrine/orm/src/Mapping/Table.php |
| 990 | /vendor/doctrine/orm/src/Mapping/MappingAttribute.php |
| 991 | /vendor/doctrine/orm/src/Mapping/Annotation.php |
| 992 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Enum.php |
| 993 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attribute.php |
| 994 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attributes.php |
| 995 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/NamedArgumentConstructor.php |
| 996 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/NamedArgumentConstructorAnnotation.php |
| 997 | /vendor/doctrine/orm/src/Mapping/Entity.php |
| 998 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/Instantiator.php |
| 999 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/InstantiatorInterface.php |
| 1000 | /vendor/doctrine/orm/src/Mapping/DefaultTypedFieldMapper.php |
| 1001 | /vendor/doctrine/orm/src/Mapping/TypedFieldMapper.php |
| 1002 | /vendor/doctrine/orm/src/Mapping/Id.php |
| 1003 | /vendor/doctrine/orm/src/Mapping/Column.php |
| 1004 | /vendor/doctrine/orm/src/Mapping/GeneratedValue.php |
| 1005 | /vendor/doctrine/orm/src/Id/IdentityGenerator.php |
| 1006 | /vendor/doctrine/orm/src/Id/AbstractIdGenerator.php |
| 1007 | /vendor/doctrine/orm/src/Events.php |
| 1008 | /vendor/doctrine/persistence/src/Persistence/Reflection/RuntimeReflectionProperty.php |
| 1009 | /vendor/doctrine/dbal/src/Query/QueryBuilder.php |
| 1010 | /vendor/doctrine/dbal/src/Query/Expression/CompositeExpression.php |
| 1011 | /vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php |
| 1012 | /vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php |
| 1013 | /vendor/doctrine/dbal/src/Query/SelectQuery.php |
| 1014 | /vendor/doctrine/dbal/src/Query/Limit.php |
| 1015 | /vendor/doctrine/dbal/src/SQL/Parser.php |
| 1016 | /vendor/doctrine/dbal/src/ExpandArrayParameters.php |
| 1017 | /vendor/doctrine/dbal/src/SQL/Parser/Visitor.php |
| 1018 | /vendor/doctrine/dbal/src/Driver/PDO/Statement.php |
| 1019 | /vendor/doctrine/dbal/src/Driver/Statement.php |
| 1020 | /vendor/doctrine/dbal/src/Driver/PDO/ParameterTypeMap.php |
| 1021 | /vendor/doctrine/dbal/src/Driver/PDO/Result.php |
| 1022 | /vendor/doctrine/dbal/src/Driver/Result.php |
| 1023 | /vendor/doctrine/dbal/src/Result.php |
| 1024 | /vendor/doctrine/dbal/src/FetchMode.php |
| 1025 | /var/cache/dev/smarty/compile/classic/e9/e4/d0/e9e4d0b935584380ea8beb3f467908e1cd2486f5_2.module.productcommentsviewstemplateshookproductlistreviews.tpl.php |
| 1026 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php |
| 1027 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/26/dd/71/26dd71b5d902204dceb16591f45cf7ea05b3b33d_2.file.pagination.tpl.php |
| 1028 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ee/f7/e2/eef7e20ffb2913bfe62b0610181c29528d8e4771_2.file.products-bottom.tpl.php |
| 1029 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/39/09/df/3909df7b52439b05e063d2f877f044830bba50c1_2.file.category-footer.tpl.php |
| 1030 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/16/be/17/16be17aaab473eb4ca068d81e52aab7efa157782_2.file.footer.tpl.php |
| 1031 | /var/cache/dev/smarty/compile/classic/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef_2.module.ps_emailsubscriptionviewstemplateshookps_emailsubscription.tpl.php |
| 1032 | /var/cache/dev/smarty/cache/ps_socialfollow/1/1/1/2/1/6/classic/39/00/03/390003729d747f46c5a6fde1e583b35503112607.ps_socialfollowps_socialfollow.tpl.php |
| 1033 | /modules/ps_linklist/ps_linklist.php |
| 1034 | /var/cache/dev/translations/catalogue.en-US.NXhscRe.php |
| 1035 | /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php |
| 1036 | /modules/ps_linklist/src/Filter/LinkFilter.php |
| 1037 | /modules/ps_linklist/src/Filter/BestSalesRouteFilter.php |
| 1038 | /modules/ps_linklist/src/Filter/RouteFilterInterface.php |
| 1039 | /modules/ps_linklist/src/LegacyLinkBlockRepository.php |
| 1040 | /var/cache/dev/smarty/cache/ps_linklist/displayFooter/1/1/1/2/1/6/classic/7f/31/9c/7f319c4e7a8a11d4f3731c5d7e5d1fbfcd5233e9.ps_linklistviewstemplateshooklinkblock.tpl.php |
| 1041 | /modules/ps_customeraccountlinks/ps_customeraccountlinks.php |
| 1042 | /var/cache/dev/smarty/cache/ps_customeraccountlinks/1/1/1/2/1/6/classic/47/f3/f6/47f3f62b55c89d7584ea8d8da165da39273fcdd0.ps_customeraccountlinksps_customeraccountlinks.tpl.php |
| 1043 | /var/cache/dev/smarty/compile/classic/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d_2.module.ps_contactinfops_contactinfo.tpl.php |
| 1044 | /vendor/smarty/smarty/libs/plugins/function.mailto.php |
| 1045 | /var/cache/dev/smarty/compile/classic/53/1f/f5/531ff5fadbab34ae9adf28c596f08da4ca8fffe0_2.module.blockwishlistviewstemplateshookdisplayHeader.tpl.php |
| 1046 | /var/cache/dev/smarty/compile/classic/b3/9f/fe/b39ffe0e9a6e5e655319605fb4fac018757bed47_2.module.blockwishlistviewstemplatescomponentsmodalsaddtowishlist.tpl.php |
| 1047 | /var/cache/dev/smarty/compile/classic/f9/93/73/f9937302c902c18a7e92f61a7bb91ac32c58d2fe_2.module.blockwishlistviewstemplatescomponentsmodalsdelete.tpl.php |
| 1048 | /var/cache/dev/smarty/compile/classic/d8/d0/86/d8d086f3098974d41bc92b06c33cf9e584313501_2.module.blockwishlistviewstemplatescomponentsmodalscreate.tpl.php |
| 1049 | /var/cache/dev/smarty/compile/classic/99/ff/6f/99ff6f99ecd074931a71deddfe65081482db8401_2.module.blockwishlistviewstemplatescomponentsmodalslogin.tpl.php |
| 1050 | /var/cache/dev/smarty/compile/classic/a6/cf/26/a6cf26c62a3d814aa3a70f19a62034bfdce54c8a_2.module.blockwishlistviewstemplatescomponentstoast.tpl.php |
| 1051 | /modules/ps_facebook/classes/Handler/MessengerHandler.php |
| 1052 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/11/93/51/119351d12df118629c98e937ac45847552344d0d_2.file.password-policy-template.tpl.php |
| 1053 | /modules/statsdata/statsdata.php |
| 1054 | /classes/Connection.php |
| 1055 | /classes/ConnectionsSource.php |
| 1056 | /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php |
| 1057 | /modules/ps_googleanalytics/classes/Handler/GanalyticsJsHandler.php |
| 1058 | /modules/ps_googleanalytics/classes/Handler/GanalyticsDataHandler.php |
| 1059 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php |
| 1060 | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php |
| 1061 | /modules/ps_googleanalytics/classes/GoogleAnalyticsTools.php |
