Art
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
Framed poster and vector images, all you need to give personality to your walls or bring your creative projects to life.
| Load Time | 620.209 ms |
| Querying Time | 71 ms |
| Queries | 224 |
| Memory Peak Usage | 48.5 Mb |
| Included Files | 1061 files - 12.79 Mb |
| PrestaShop Cache | - Mb |
| Global vars | 0.14 Mb |
| PrestaShop Version | 9.0.3 |
| PHP Version | 8.4.18 |
| MySQL Version | 10.11.15-MariaDB-log |
| Memory Limit | -1 |
| Max Execution Time | 50000s |
| Smarty Cache | enabled |
| Smarty Compilation | never recompile |
| Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
|---|---|---|---|---|
| config | 228.545 ms | 228.545 ms | 22.89 Mb | 23.9 Mb |
| __construct | 0.069 ms | 228.614 ms | - Mb | 23.9 Mb |
| init | 45.801 ms | 274.415 ms | 3.26 Mb | 26.2 Mb |
| checkAccess | 0.002 ms | 274.417 ms | - Mb | 26.2 Mb |
| setMedia | 50.473 ms | 324.890 ms | 3.67 Mb | 29.9 Mb |
| postProcess | 0.002 ms | 324.892 ms | - Mb | 29.9 Mb |
| initHeader | 0.002 ms | 324.894 ms | - Mb | 29.9 Mb |
| initContent | 185.426 ms | 510.320 ms | 9.72 Mb | 39.6 Mb |
| initFooter | 0.003 ms | 510.323 ms | - Mb | 39.6 Mb |
| display | 109.886 ms | 620.209 ms | 8.07 Mb | 48.5 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| DisplayHeader | 41.694 ms | 3.97 Mb |
| ActionFrontControllerSetMedia | 36.371 ms | 2.67 Mb |
| displayProductListReviews | 26.328 ms | 2.03 Mb |
| DisplayBeforeBodyClosingTag | 8.050 ms | 0.36 Mb |
| displayLeftColumn | 7.413 ms | 0.33 Mb |
| displayNav2 | 7.228 ms | 0.36 Mb |
| ProductSearchProvider | 3.233 ms | 0.16 Mb |
| displayNav1 | 3.089 ms | 0.07 Mb |
| displayFooter | 3.044 ms | 0.20 Mb |
| displayTop | 2.316 ms | 0.13 Mb |
| DisplayFooter | 2.248 ms | 0.12 Mb |
| displayFooterBefore | 1.546 ms | 0.11 Mb |
| DisplayLeftColumn | 0.315 ms | 0.01 Mb |
| DisplayTop | 0.114 ms | - Mb |
| DisplayNavFullWidth | 0.010 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.009 ms | - Mb |
| DisplayFooterAfter | 0.008 ms | - Mb |
| DisplayFooterBefore | 0.007 ms | - Mb |
| ModuleRoutes | 0.005 ms | - Mb |
| 19 hook(s) | 143.027 ms | 10.53 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| ps_checkout | 57.010 ms | 5.68 Mb |
| blockreassurance | 2.640 ms | 0.22 Mb |
| blockwishlist | 2.866 ms | 0.18 Mb |
| ps_emailsubscription | 3.809 ms | 0.34 Mb |
| ps_socialfollow | 1.592 ms | 0.12 Mb |
| ps_facebook | 19.078 ms | 1.16 Mb |
| ps_emailalerts | 3.481 ms | 0.24 Mb |
| ps_accounts | 2.195 ms | 0.20 Mb |
| ps_shoppingcart | 2.041 ms | 0.13 Mb |
| ps_searchbar | 1.630 ms | 0.08 Mb |
| ps_imageslider | 2.963 ms | 0.21 Mb |
| productcomments | 28.624 ms | 2.22 Mb |
| psshipping | 23.293 ms | 1.81 Mb |
| ps_googleanalytics | 3.843 ms | 0.33 Mb |
| psxmarketingwithgoogle | 3.984 ms | 1.40 Mb |
| ps_facetedsearch | 8.788 ms | 0.62 Mb |
| ps_contactinfo | 4.883 ms | 0.17 Mb |
| ps_languageselector | 2.622 ms | 0.09 Mb |
| ps_currencyselector | 3.377 ms | 0.18 Mb |
| ps_customersignin | 1.253 ms | 0.08 Mb |
| ps_mainmenu | 5.452 ms | 0.34 Mb |
| pagesnotfound | 0.830 ms | 0.05 Mb |
| ps_categorytree | 6.083 ms | 0.25 Mb |
| ps_supplierlist | 1.157 ms | 0.08 Mb |
| ps_brandlist | 2.528 ms | 0.15 Mb |
| ps_linklist | 8.354 ms | 1.93 Mb |
| ps_customeraccountlinks | 1.236 ms | 0.10 Mb |
| statsdata | 5.718 ms | 0.14 Mb |
| 28 module(s) | 211.330 ms | 18.49 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 102 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `dfdu_hook_alias` ha INNER JOIN `dfdu_hook` h ON ha.name = h.name |
2.331 ms | 0 | /classes/Hook.php:1568 | ||
| 174 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `dfdu_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `dfdu_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC |
1.806 ms | 9 | Yes | Yes | /classes/Category.php:815 |
| 216 | SELECT SQL_NO_CACHE `id_guest` FROM `dfdu_connections` WHERE `id_guest` = 1800 AND `date_add` > '2026-03-11 19:37:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
1.505 ms | 1 | Yes | /classes/Connection.php:168 | |
| 93 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC |
1.283 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 103 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `dfdu_hook_module` hm STRAIGHT_JOIN `dfdu_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `dfdu_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.215 ms | 374 | /classes/Hook.php:495 | ||
| 217 | INSERT INTO `dfdu_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('1803', '', 'izzywine.com/en/9-art?q=Dimension-60x90cm%2FAvailability-In+stock', '', '2026-03-11 20:07:51') |
1.179 ms | 1 | /classes/ObjectModel.php:535 | ||
| 90 | SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) GROUP BY p.id_manufacturer |
1.162 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 94 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=3)) AND ((sa_1.quantity>0)) GROUP BY pac.id_attribute |
1.100 ms | 6 | 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.085 ms | 150 | Yes | Yes | /classes/Hook.php:1500 |
| 100 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 3 LIMIT 1 |
1.013 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 71 | SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC |
0.966 ms | 6 | Yes | /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) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_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-11 20:07:50' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-03-11 20:07:50' <= sp.to)
) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=20)) |
0.946 ms | 12 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 81 | SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>15 AND c.nright<16 GROUP BY cp.id_category |
0.905 ms | 18 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 91 | SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) GROUP BY p.condition |
0.876 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 96 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=20)) GROUP BY pac.id_attribute |
0.874 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 74 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute=20)) |
0.862 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 86 | SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=20)) GROUP BY fp.id_feature_value |
0.857 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 75 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) |
0.807 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 92 | SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM dfdu_product p INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 |
0.747 ms | 3 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 73 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute=20)) |
0.708 ms | 6 | /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) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=20)) GROUP BY fp.id_feature_value |
0.703 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 83 | SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=20)) GROUP BY pac.id_attribute |
0.677 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 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) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=20)) GROUP BY pac.id_attribute |
0.664 ms | 6 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | |
| 143 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` |
0.661 ms | 7 | /classes/ImageType.php:161 | ||
| 95 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC |
0.647 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 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.636 ms | 510 | /classes/Configuration.php:182 | ||
| 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_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((p.on_sale=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute=20)) |
0.622 ms | 6 | /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_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND p.date_add>'2026-02-20 00:00:00' |
0.616 ms | 6 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 97 | REPLACE INTO dfdu_layered_filter_block (hash, data) VALUES ("de92b617fbd1227ca15206d72c90cff6", "a:1:{s:7:\"filters\";a:9:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:2;a:3:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:3;s:7:\"checked\";b:1;}i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:7:\"On sale\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:11:\"New product\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:1:\"$\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"USD\";s:14:\"currencySymbol\";s:1:\"$\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:3;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:1;s:6:\"values\";a:1:{i:6;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:10:\"Matt paper\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:11:\"Composition\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:1:{i:2;a:2:{s:4:\"name\";s:14:\"Graphic Corner\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Condition\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"New\";s:3:\"nbr\";i:3;}s:4:\"used\";a:2:{s:4:\"name\";s:4:\"Used\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Refurbished\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Weight\";s:3:\"max\";d:0.3;s:3:\"min\";d:0.3;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:3;}i:8;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:3;s:4:\"name\";s:9:\"Dimension\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:3:{i:19;a:4:{s:4:\"name\";s:7:\"40x60cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20;a:5:{s:4:\"name\";s:7:\"60x90cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:21;a:4:{s:4:\"name\";s:8:\"80x120cm\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}") |
0.592 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:209 | ||
| 16 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `dfdu_hook` |
0.580 ms | 1186 | /classes/Hook.php:1568 | ||
| 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` = 5 AND il.`id_lang` = 1 ORDER by i.`position` |
0.570 ms | 1 | Yes | /classes/Product.php:2668 | |
| 129 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 5) |
0.553 ms | 3 | /classes/Product.php:3629 | ||
| 123 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 17 AND cp.`id_cart` = 0 AND cp.`id_product` = 4 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 17 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.533 ms | 0 | /classes/Cart.php:1450 | ||
| 39 | SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_description` FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `dfdu_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 9 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.532 ms | 1 | Yes | Yes | /classes/Category.php:946 |
| 144 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4) AND (b.`id_shop` = 1) LIMIT 1 |
0.523 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 13 | SELECT SQL_NO_CACHE lower(name) as name FROM `dfdu_hook` h WHERE (h.active = 1) |
0.523 ms | 1186 | /classes/Hook.php:1608 | ||
| 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` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC |
0.517 ms | 25 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 89 | SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `dfdu_manufacturer` m INNER JOIN dfdu_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `dfdu_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC |
0.501 ms | 4 | Yes | /classes/Manufacturer.php:195 | |
| 79 | SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM dfdu_product p INNER JOIN dfdu_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 6) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN dfdu_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute=20)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=15 AND c.nright<=16 |
0.460 ms | 3 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:85 | ||
| 200 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (5) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.421 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 68 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC |
0.420 ms | 3 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 190 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (13,14,15) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.393 ms | 3 | /classes/Product.php:2507 | ||
| 82 | SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN dfdu_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC |
0.390 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 | |
| 98 | 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-11 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM dfdu_product p LEFT JOIN dfdu_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN dfdu_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN dfdu_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (3,4,5) |
0.390 ms | 3 | /classes/ProductAssembler.php:101 | ||
| 150 | 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.386 ms | 1 | /classes/Cart.php:4072 | ||
| 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.381 ms | 43 | Yes | /classes/Dispatcher.php:643 | |
| 125 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 4 AND pac.`id_product_attribute` = 17 AND agl.`id_lang` = 1 |
0.359 ms | 1 | /classes/Product.php:7216 | ||
| 154 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.349 ms | 1 | /classes/module/Module.php:2781 | ||
| 148 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 5 ORDER BY `position` |
0.347 ms | 1 | Yes | /classes/Product.php:3285 | |
| 152 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1 |
0.345 ms | 1 | /classes/module/Module.php:2270 | ||
| 204 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (19,20,21) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.344 ms | 3 | /classes/Product.php:2507 | ||
| 147 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) AND (b.`id_shop` = 1) LIMIT 1 |
0.340 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 109 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 3 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 3 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.337 ms | 0 | /classes/Cart.php:1450 | ||
| 193 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.326 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 183 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (3) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.324 ms | 12 | Yes | Yes | /classes/Product.php:4304 |
| 66 | SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `dfdu_attribute_group` ag INNER JOIN dfdu_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `dfdu_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC |
0.318 ms | 4 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 |
| 178 | SELECT SQL_NO_CACHE c.*, cl.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 15 AND c.`nright` >= 16 AND c.`nleft` >= 2 AND c.`nright` <= 17 ORDER BY `nleft` DESC |
0.311 ms | 2 | Yes | /classes/Category.php:1617 | |
| 67 | SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `dfdu_feature` f INNER JOIN dfdu_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `dfdu_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `dfdu_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC |
0.309 ms | 4 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 | |
| 139 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3) AND (b.`id_shop` = 1) LIMIT 1 |
0.305 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 203 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 5 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.300 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 121 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 4 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.298 ms | 0 | /classes/Cart.php:1450 | ||
| 196 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 4 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.297 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 194 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4) LIMIT 1 |
0.289 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 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.286 ms | 75 | /classes/module/Module.php:343 | ||
| 113 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 3 AND pac.`id_product_attribute` = 14 AND agl.`id_lang` = 1 |
0.285 ms | 1 | /classes/Product.php:7216 | ||
| 57 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_facebook" LIMIT 1 |
0.282 ms | 1 | /classes/module/Module.php:2781 | ||
| 58 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1 |
0.281 ms | 1 | /classes/module/Module.php:2270 | ||
| 136 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `dfdu_attribute` a LEFT JOIN `dfdu_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 5 AND pac.`id_product_attribute` = 20 AND agl.`id_lang` = 1 |
0.281 ms | 1 | /classes/Product.php:7216 | ||
| 140 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.279 ms | 1 | /classes/Category.php:1396 | ||
| 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.277 ms | 1 | Yes | /classes/shop/Shop.php:716 | |
| 20 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1 |
0.275 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 104 | 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.275 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 189 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `dfdu_product_attribute` pa INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 3 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.275 ms | 3 | Yes | Yes | /classes/Product.php:2492 |
| 42 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `dfdu_module` m LEFT JOIN `dfdu_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.274 ms | 75 | /classes/module/Module.php:343 | ||
| 186 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3) LIMIT 1 |
0.272 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 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.270 ms | 1 | Yes | /classes/shop/Shop.php:1392 | |
| 111 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 14 AND cp.`id_cart` = 0 AND cp.`id_product` = 3 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 14 AND cp.`id_cart` = 0 AND p.`id_product_item` = 3 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.270 ms | 0 | /classes/Cart.php:1450 | ||
| 87 | SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `dfdu_feature_value` v LEFT JOIN `dfdu_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `dfdu_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 1 ORDER BY vl.`value` ASC |
0.267 ms | 10 | Yes | /modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 | |
| 219 | SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `dfdu_category_product` cp LEFT JOIN `dfdu_category` c ON (c.id_category = cp.id_category) LEFT JOIN `dfdu_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (3,4,5) AND cl.`id_lang` = 1 ORDER BY c.`level_depth` DESC |
0.264 ms | 6 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 | |
| 134 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 20 AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 20 AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.260 ms | 0 | /classes/Cart.php:1450 | ||
| 197 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (16,17,18) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.258 ms | 3 | /classes/Product.php:2507 | ||
| 175 | SELECT SQL_NO_CACHE DISTINCT c.* FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1) WHERE `level_depth` = 1 |
0.257 ms | 1 | /classes/Category.php:2247 | ||
| 201 | SELECT SQL_NO_CACHE * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5) LIMIT 1 |
0.255 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 56 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a0 LEFT JOIN `dfdu_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 15) AND (a0.`nright` > 16) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.250 ms | 2 | Yes | /classes/PrestaShopCollection.php:381 | |
| 18 | SELECT SQL_NO_CACHE name, alias FROM `dfdu_hook_alias` |
0.248 ms | 86 | /classes/Hook.php:371 | ||
| 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.247 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 132 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `dfdu_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.246 ms | 0 | /classes/Cart.php:1450 | ||
| 126 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 17) LIMIT 1 |
0.241 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 65 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM dfdu_layered_category WHERE controller = 'category' AND id_category = 9 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.240 ms | 13 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:57 |
| 128 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 5 LIMIT 1 |
0.240 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 141 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 3 ORDER BY `position` |
0.237 ms | 1 | Yes | /classes/Product.php:3285 | |
| 80 | SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `dfdu_category` c INNER JOIN dfdu_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `dfdu_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position |
0.235 ms | 9 | Yes | /classes/Category.php:744 | |
| 222 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 17 ORDER BY ag.`position` ASC, a.`position` ASC |
0.235 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 145 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `dfdu_image` i INNER JOIN dfdu_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 4 ORDER BY `position` |
0.233 ms | 1 | Yes | /classes/Product.php:3285 | |
| 133 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 20) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.233 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 115 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 14) LIMIT 1 |
0.232 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 187 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 3 AND `id_shop` = 1 |
0.232 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 101 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 3) |
0.230 ms | 3 | /classes/Product.php:3629 | ||
| 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.228 ms | 1 | /classes/Language.php:1070 | ||
| 114 | 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.226 ms | 1 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 119 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 4 AND `id_group` = 1 LIMIT 1 |
0.226 ms | 0 | /classes/GroupReduction.php:146 | ||
| 11 | SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `dfdu_lang` l JOIN dfdu_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 |
0.225 ms | 1 | /classes/Language.php:1204 | ||
| 25 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` a LEFT JOIN `dfdu_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 2) LIMIT 1 |
0.225 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 44 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1 |
0.225 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 198 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 16) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.225 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 137 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 20) LIMIT 1 |
0.224 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 221 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 14 ORDER BY ag.`position` ASC, a.`position` ASC |
0.222 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 15 | SELECT SQL_NO_CACHE `name`, `alias` FROM `dfdu_hook_alias` |
0.221 ms | 86 | /classes/Hook.php:319 | ||
| 118 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 4) |
0.221 ms | 3 | /classes/Product.php:3629 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `dfdu_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.220 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 160 | 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.215 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 223 | SELECT SQL_NO_CACHE al.`name` AS attribute_name FROM `dfdu_product_attribute_combination` pac LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `dfdu_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 20 ORDER BY ag.`position` ASC, a.`position` ASC |
0.213 ms | 1 | Yes | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:232 | |
| 10 | SELECT SQL_NO_CACHE domain, domain_ssl FROM dfdu_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.211 ms | 1 | /classes/shop/ShopUrl.php:178 | ||
| 41 | SELECT SQL_NO_CACHE * FROM `dfdu_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.211 ms | 1 | /classes/module/Module.php:2171 | ||
| 69 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 9) LIMIT 1 |
0.210 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 157 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.210 ms | 1 | /classes/module/Module.php:2270 | ||
| 151 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_contactinfo" LIMIT 1 |
0.209 ms | 1 | /classes/module/Module.php:2781 | ||
| 21 | SELECT SQL_NO_CACHE * FROM `dfdu_currency` c ORDER BY `iso_code` ASC |
0.208 ms | 1 | Yes | /classes/Currency.php:708 | |
| 161 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 2 |
0.204 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 220 | SELECT SQL_NO_CACHE `name` FROM `dfdu_manufacturer` WHERE `id_manufacturer` = 2 AND `active` = 1 LIMIT 1 |
0.204 ms | 1 | /classes/Manufacturer.php:306 | ||
| 146 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 4 AND il.`id_lang` = 1 ORDER by i.`position` |
0.202 ms | 1 | Yes | /classes/Product.php:2668 | |
| 173 | SELECT SQL_NO_CACHE * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.200 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 9 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.197 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 72 | SELECT SQL_NO_CACHE data FROM dfdu_layered_filter_block WHERE hash="de92b617fbd1227ca15206d72c90cff6" LIMIT 1 |
0.196 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:185 | ||
| 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.191 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 48 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.191 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 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.190 ms | 1 | /classes/shop/Shop.php:215 | ||
| 112 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 3 AND pa.`id_product` = 3 AND pa.`id_product_attribute` = 14 LIMIT 1 |
0.187 ms | 1 | /classes/Product.php:1180 | ||
| 124 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 4 AND pa.`id_product` = 4 AND pa.`id_product_attribute` = 17 LIMIT 1 |
0.187 ms | 1 | /classes/Product.php:1180 | ||
| 142 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `dfdu_product_attribute_image` pai LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = 3 AND il.`id_lang` = 1 ORDER by i.`position` |
0.184 ms | 1 | Yes | /classes/Product.php:2668 | |
| 64 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.183 ms | 1 | /classes/Category.php:2454 | ||
| 195 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 4 AND `id_shop` = 1 |
0.183 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 70 | SELECT SQL_NO_CACHE * FROM `dfdu_category_lang` WHERE `id_category` = 9 AND `id_shop` = 1 |
0.182 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 159 | 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.182 ms | 1 | Yes | /classes/Currency.php:687 | |
| 12 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `iso_code` = 'en' LIMIT 1 |
0.180 ms | 1 | /classes/Language.php:844 | ||
| 105 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 3 AND `id_group` = 1 LIMIT 1 |
0.180 ms | 0 | /classes/GroupReduction.php:146 | ||
| 8 | SELECT SQL_NO_CACHE * FROM `dfdu_lang` a LEFT JOIN `dfdu_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.179 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` = 1 LEFT JOIN `dfdu_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.179 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 61 | SELECT SQL_NO_CACHE `id_configuration` FROM `dfdu_configuration` WHERE name = 'PS_ACCOUNTS_SHOP_STATUS' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1 |
0.177 ms | 1 | /classes/Configuration.php:135 | ||
| 45 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.176 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 40 | SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM dfdu_shop s |
0.175 ms | 1 | /classes/shop/Shop.php:922 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `dfdu_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.174 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.173 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 135 | SELECT SQL_NO_CACHE pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN dfdu_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 5 AND pa.`id_product` = 5 AND pa.`id_product_attribute` = 20 LIMIT 1 |
0.169 ms | 1 | /classes/Product.php:1180 | ||
| 23 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.168 ms | 1 | /classes/shop/Shop.php:1211 | ||
| 116 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 14 |
0.167 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 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` = 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.166 ms | 0 | /classes/tax/TaxRulesTaxManager.php:97 | ||
| 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.166 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 37 | SELECT SQL_NO_CACHE `id_category` FROM `dfdu_category_shop` WHERE `id_category` = 9 AND `id_shop` = 1 LIMIT 1 |
0.165 ms | 1 | /classes/Category.php:2454 | ||
| 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.165 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 53 | SELECT SQL_NO_CACHE * FROM `dfdu_country_lang` WHERE `id_country` = 6 |
0.165 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 202 | SELECT SQL_NO_CACHE * FROM `dfdu_product_lang` WHERE `id_product` = 5 AND `id_shop` = 1 |
0.165 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 43 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.164 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 47 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `suppliers` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.164 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 110 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 14) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.162 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 22 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.162 ms | 1 | /classes/Language.php:870 | ||
| 122 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 17) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.162 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 153 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.162 ms | 1 | /classes/Country.php:406 | ||
| 54 | SELECT SQL_NO_CACHE * FROM `dfdu_state` a WHERE (a.`id_state` = 353) LIMIT 1 |
0.161 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 120 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.160 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 162 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.160 ms | 1 | /classes/module/Module.php:2781 | ||
| 26 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.159 ms | 1 | /classes/Language.php:870 | ||
| 127 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 17 |
0.159 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 108 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.157 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 138 | SELECT SQL_NO_CACHE * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = 20 |
0.157 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 191 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 13) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.156 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 60 | SELECT SQL_NO_CACHE value FROM `dfdu_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.155 ms | 1 | /modules/ps_accounts/src/Adapter/Configuration.php:278 | ||
| 131 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.155 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 164 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.155 ms | 1 | /classes/module/Module.php:2781 | ||
| 212 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1 |
0.155 ms | 1 | /classes/module/Module.php:2270 | ||
| 24 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.154 ms | 1 | /classes/Currency.php:893 | ||
| 62 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration` a WHERE (a.`id_configuration` = 479) LIMIT 1 |
0.154 ms | 1 | /src/Adapter/EntityMapper.php:74 | ||
| 33 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.153 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 35 | SELECT SQL_NO_CACHE * FROM `dfdu_group_lang` WHERE `id_group` = 1 |
0.153 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 218 | SELECT SQL_NO_CACHE data FROM `dfdu_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.153 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39 | ||
| 99 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 0 LIMIT 1 |
0.152 ms | 1 | /classes/SpecificPrice.php:433 | ||
| 167 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_mainmenu" LIMIT 1 |
0.150 ms | 1 | /classes/module/Module.php:2781 | ||
| 205 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 19) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.150 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 32 | SELECT SQL_NO_CACHE * FROM `dfdu_currency_lang` WHERE `id_currency` = 1 |
0.149 ms | 2 | /src/Adapter/EntityMapper.php:82 | ||
| 55 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM dfdu_required_field |
0.149 ms | 1 | /classes/ObjectModel.php:1437 | ||
| 158 | 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.147 ms | 1 | /classes/Currency.php:1120 | ||
| 199 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 18) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.147 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 211 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_linklist" LIMIT 1 |
0.147 ms | 1 | /classes/module/Module.php:2781 | ||
| 213 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1 |
0.147 ms | 1 | /classes/module/Module.php:2781 | ||
| 30 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.146 ms | 1 | /classes/Language.php:870 | ||
| 36 | SELECT SQL_NO_CACHE id_shop FROM `dfdu_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.146 ms | 1 | /classes/ObjectModel.php:1570 | ||
| 50 | SELECT SQL_NO_CACHE format FROM `dfdu_address_format` WHERE `id_country` = 6 LIMIT 1 |
0.146 ms | 1 | /classes/AddressFormat.php:649 | ||
| 166 | SELECT SQL_NO_CACHE SUM(`quantity`) FROM `dfdu_cart_product` WHERE `id_cart` = 0 LIMIT 1 |
0.145 ms | 1 | /classes/Cart.php:1321 | ||
| 176 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c LEFT JOIN `dfdu_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 9 LIMIT 1 |
0.145 ms | 1 | /classes/Category.php:1607 | ||
| 63 | SELECT SQL_NO_CACHE * FROM `dfdu_configuration_lang` WHERE `id_configuration` = 479 |
0.143 ms | 1 | /src/Adapter/EntityMapper.php:82 | ||
| 28 | SELECT SQL_NO_CACHE c.id_currency FROM `dfdu_currency` c WHERE (iso_code = 'USD') LIMIT 1 |
0.142 ms | 1 | /classes/Currency.php:893 | ||
| 155 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.142 ms | 1 | /classes/module/Module.php:2270 | ||
| 184 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "productcomments" LIMIT 1 |
0.142 ms | 1 | /classes/module/Module.php:2781 | ||
| 192 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 3) AND (id_product_attribute = 15) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.142 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 27 | SELECT SQL_NO_CACHE `id_lang` FROM `dfdu_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT 1 |
0.140 ms | 1 | /classes/Language.php:870 | ||
| 117 | SELECT SQL_NO_CACHE 1 FROM `dfdu_specific_price` WHERE id_product = 4 LIMIT 1 |
0.140 ms | 1 | /classes/SpecificPrice.php:442 | ||
| 38 | SELECT SQL_NO_CACHE ctg.`id_group` FROM dfdu_category_group ctg WHERE ctg.`id_category` = 9 AND ctg.`id_group` = 1 LIMIT 1 |
0.138 ms | 1 | /classes/Category.php:1774 | ||
| 156 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2781 | ||
| 59 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_accounts" LIMIT 1 |
0.137 ms | 1 | /src/Adapter/Module/ModuleDataProvider.php:251 | ||
| 106 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_group` WHERE `id_group` = 1 LIMIT 1 |
0.137 ms | 1 | /classes/Group.php:151 | ||
| 49 | SELECT SQL_NO_CACHE * FROM `dfdu_image_type` WHERE 1 AND `stores` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.137 ms | 7 | Yes | /classes/ImageType.php:109 | |
| 207 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.136 ms | 1 | /classes/module/Module.php:2781 | ||
| 130 | SELECT SQL_NO_CACHE `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1 LIMIT 1 |
0.135 ms | 0 | /classes/GroupReduction.php:146 | ||
| 169 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.133 ms | 1 | /classes/module/Module.php:2781 | ||
| 214 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1 |
0.133 ms | 1 | /classes/module/Module.php:2270 | ||
| 177 | SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `dfdu_category` c WHERE c.`id_category` = 2 LIMIT 1 |
0.133 ms | 1 | /classes/Category.php:1612 | ||
| 171 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.132 ms | 1 | /classes/module/Module.php:2781 | ||
| 168 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1 |
0.131 ms | 1 | /classes/module/Module.php:2270 | ||
| 208 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.131 ms | 1 | /classes/module/Module.php:2270 | ||
| 51 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.130 ms | 1 | /classes/Country.php:406 | ||
| 163 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.130 ms | 1 | /classes/module/Module.php:2270 | ||
| 209 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.127 ms | 1 | /classes/module/Module.php:2781 | ||
| 181 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_brandlist" LIMIT 1 |
0.125 ms | 1 | /classes/module/Module.php:2781 | ||
| 215 | SELECT SQL_NO_CACHE `need_identification_number` FROM `dfdu_country` WHERE `id_country` = 6 LIMIT 1 |
0.124 ms | 1 | /classes/Country.php:406 | ||
| 179 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module` WHERE `name` = "ps_supplierlist" LIMIT 1 |
0.122 ms | 1 | /classes/module/Module.php:2781 | ||
| 206 | SELECT SQL_NO_CACHE SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = 5) AND (id_product_attribute = 21) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.122 ms | 1 | /classes/stock/StockAvailable.php:286 | ||
| 188 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.120 ms | 0 | /classes/Category.php:1396 | ||
| 180 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 36 AND `id_shop` = 1 LIMIT 1 |
0.120 ms | 1 | /classes/module/Module.php:2270 | ||
| 165 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.118 ms | 1 | /classes/module/Module.php:2270 | ||
| 182 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 59 AND `id_shop` = 1 LIMIT 1 |
0.116 ms | 1 | /classes/module/Module.php:2270 | ||
| 210 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.114 ms | 1 | /classes/module/Module.php:2270 | ||
| 185 | 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 | ||
| 172 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.112 ms | 1 | /classes/module/Module.php:2270 | ||
| 170 | SELECT SQL_NO_CACHE `id_module` FROM `dfdu_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.111 ms | 1 | /classes/module/Module.php:2270 |
| 16 queries |
SELECT `id_module` FROM `dfdu_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX |
| 12 queries |
SELECT SUM(quantity) FROM `dfdu_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX |
| 6 queries |
SELECT
COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
COALESCE(SUM(first_level_quantity), XX) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity
FROM `dfdu_cart_product` cp
WHERE cp.`id_product_attribute` = XX
AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `dfdu_cart_product` cp JOIN `dfdu_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `dfdu_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = XX
AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
pr.`pack_stock_type` = XX
AND XX = XX
))) as q LIMIT XX
|
| 5 queries |
SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `dfdu_attribute_group` ag INNER JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `dfdu_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN dfdu_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN dfdu_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `dfdu_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
|
| 4 queries |
SELECT `id_lang` FROM `dfdu_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT XX
|
| 4 queries |
SELECT XX FROM `dfdu_specific_price` WHERE id_product = XX LIMIT XX |
| 3 queries |
SELECT * FROM `dfdu_category` a LEFT JOIN `dfdu_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `dfdu_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX |
| 3 queries |
SELECT `need_identification_number` FROM `dfdu_country` WHERE `id_country` = XX LIMIT XX |
| 3 queries |
SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM dfdu_product p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN dfdu_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN dfdu_category_product cp ON (p.id_product = cp.id_product) INNER JOIN dfdu_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN dfdu_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN dfdu_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity>XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN dfdu_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN dfdu_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((a.id_attribute_group=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute=XX)) GROUP BY pac.id_attribute
|
| 3 queries |
SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `dfdu_product` p INNER JOIN `dfdu_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `dfdu_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX) |
| 3 queries |
SELECT tr.*
FROM `dfdu_tax_rule` tr
JOIN `dfdu_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = XX
AND tr.`id_country` = XX
AND tr.`id_tax_rules_group` = XX
AND tr.`id_state` IN (XX, XX)
AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
|
| 3 queries |
SELECT `reduction` FROM `dfdu_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
| 3 queries |
SELECT pa.`available_date` FROM `dfdu_product` p LEFT JOIN `dfdu_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN dfdu_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
|
| 3 queries |
SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `dfdu_attribute` a
LEFT JOIN `dfdu_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `dfdu_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `dfdu_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
LEFT JOIN `dfdu_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX)
LEFT JOIN `dfdu_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
WHERE pa.`id_product` = XX
AND pac.`id_product_attribute` = XX
AND agl.`id_lang` = XX
|
| 3 queries |
SELECT * FROM `dfdu_product_attribute` a LEFT JOIN `dfdu_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX |
| 3 queries |
SELECT * FROM `dfdu_product_attribute_lang` WHERE `id_product_attribute` = XX |
| 3 queries |
SELECT * FROM `dfdu_product` a LEFT JOIN `dfdu_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX |
| 3 queries |
SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `dfdu_image` i
INNER JOIN dfdu_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
LEFT JOIN `dfdu_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
WHERE i.`id_product` = XX
ORDER BY `position`
|
| 3 queries |
SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `dfdu_product_attribute_image` pai
LEFT JOIN `dfdu_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `dfdu_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
|
| 3 queries |
SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `dfdu_product_attribute` pa
INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
JOIN `dfdu_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `dfdu_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
JOIN `dfdu_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
|
| 3 queries |
SELECT * FROM `dfdu_product` a LEFT JOIN `dfdu_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX |
| 3 queries |
SELECT * FROM `dfdu_product_lang` WHERE `id_product` = XX AND `id_shop` = XX |
| 3 queries |
SELECT pa.*, product_attribute_shop.*
FROM `dfdu_product_attribute` pa
INNER JOIN dfdu_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
WHERE pa.`id_product` = XX
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
|
| 3 queries |
SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `dfdu_product_attribute_combination` pac
LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `dfdu_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
LEFT JOIN `dfdu_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
WHERE pac.id_product_attribute IN (XX,XX,XX)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
|
| 3 queries |
SELECT al.`name` AS attribute_name
FROM `dfdu_product_attribute_combination` pac
LEFT JOIN `dfdu_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `dfdu_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `dfdu_attribute_lang` al ON (
a.`id_attribute` = al.`id_attribute`
AND al.`id_lang` = XX
)
WHERE pac.`id_product_attribute` = XX
ORDER BY ag.`position` ASC, a.`position` ASC
|
| 2 queries |
SELECT 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) WHERE ((sa.quantity>XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN dfdu_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN dfdu_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN dfdu_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN dfdu_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN dfdu_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature=XX)) AND ((sa_XX.quantity>XX)) AND ((pac_XX.id_attribute=XX)) GROUP BY fp.id_feature_value
|
| 2 queries |
SELECT cl.`link_rewrite` FROM `dfdu_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX |
| 73 product_attribute_combination |
| 49 product_attribute |
| 47 stock_available |
| 38 product |
| 33 category |
| 32 product_shop |
| 22 module |
| 22 category_group |
| 21 attribute |
| 21 category_product |
| 19 module_shop |
| 18 product_attribute_shop |
| 17 attribute_lang |
| 16 product_sale |
| 15 attribute_group |
| 14 category_lang |
| 14 cart_product |
| 12 attribute_group_lang |
| 10 category_shop |
| 9 currency |
| 8 lang |
| 7 currency_shop |
| 7 product_lang |
| 6 hook |
| 6 image_type |
| 6 attribute_group_shop |
| 6 pack |
| 6 product_attribute_lang |
| 6 image |
| 6 image_lang |
| 5 shop |
| 5 configuration |
| 5 country |
| 5 attribute_shop |
| 5 layered_indexable_attribute_lang_value |
| 5 specific_price |
| 4 shop_url |
| 4 lang_shop |
| 4 currency_lang |
| 3 hook_alias |
| 3 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 feature_product |
| 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 feature_value |
| 1 feature_value_lang |
| 1 layered_indexable_feature_value_lang_value |
| 1 manufacturer_shop |
| 1 manufacturer_lang |
| 1 connections |
| 1 ganalytics_data |
| Name | Instances | Source |
|---|---|---|
| Category | 17 |
/controllers/front/listing/CategoryController.php:87 (__construct) [id: 9]
/classes/Meta.php:364 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 9] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /classes/Link.php:416 (__construct) [id: 9] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /src/Adapter/Presenter/Category/CategoryLazyArray.php:112 (__construct) [id: 9] |
| Product | 9 |
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 3]
/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 5] /classes/Link.php:114 (__construct) [id: 3] /classes/Link.php:114 (__construct) [id: 4] /classes/Link.php:114 (__construct) [id: 5] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 3] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 4] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 5] |
| Country | 7 |
/config/config.inc.php:154 (__construct) [id: 6]
/classes/AddressFormat.php:402 (__construct) [id: 6] /classes/controller/FrontController.php:1739 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] /classes/AddressFormat.php:402 (__construct) [id: 6] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 6] |
| State | 5 |
/classes/controller/FrontController.php:1738 (__construct) [id: 353]
/modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 353] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 353] |
| Address | 4 |
/classes/shop/Shop.php:487 (__construct) [id: ]
/classes/Product.php:3454 (initialize) [id: ] /classes/Product.php:3573 (__construct) [id: ] /classes/Product.php:5723 (__construct) [id: ] |
| Currency | 4 |
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2]
/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:708 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2] |
| Language | 3 |
/config/config.inc.php:219 (__construct) [id: 1]
/classes/Tools.php:659 (__construct) [id: 1] /classes/Tools.php:553 (__construct) [id: 1] |
| Combination | 3 |
/classes/Product.php:5671 (__construct) [id: 14]
/classes/Product.php:5671 (__construct) [id: 17] /classes/Product.php:5671 (__construct) [id: 20] |
| AddressFormat | 3 |
/classes/controller/FrontController.php:1733 (generateAddress) [id: ]
/modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] |
| Shop | 1 |
/config/config.inc.php:122 (initialize) [id: 1]
|
| Configuration | 1 |
/modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 479]
|
| Gender | 1 |
/classes/controller/FrontController.php:1656 (__construct) [id: 0]
|
| Risk | 1 |
/classes/controller/FrontController.php:1659 (__construct) [id: ]
|
| Group | 1 |
/classes/Cart.php:275 (getCurrent) [id: 1]
|
| Cart | 1 |
/classes/controller/FrontController.php:459 (__construct) [id: ]
|
| Customer | 1 |
/config/config.inc.php:272 (__construct) [id: ]
|
| ShopGroup | 1 |
/classes/shop/Shop.php:562 (__construct) [id: 1]
|
| ConnectionsSource | 1 |
/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
|
| # | Filename |
|---|---|
| 0 | /index.php |
| 1 | /config/config.inc.php |
| 2 | /config/defines.inc.php |
| 3 | /config/autoload.php |
| 4 | /vendor/autoload.php |
| 5 | /vendor/composer/autoload_real.php |
| 6 | /vendor/composer/platform_check.php |
| 7 | /vendor/composer/ClassLoader.php |
| 8 | /vendor/composer/autoload_static.php |
| 9 | /vendor/symfony/deprecation-contracts/function.php |
| 10 | /vendor/symfony/polyfill-mbstring/bootstrap.php |
| 11 | /vendor/symfony/polyfill-mbstring/bootstrap80.php |
| 12 | /vendor/symfony/polyfill-ctype/bootstrap.php |
| 13 | /vendor/symfony/polyfill-ctype/bootstrap80.php |
| 14 | /vendor/symfony/polyfill-php83/bootstrap.php |
| 15 | /vendor/symfony/var-dumper/Resources/functions/dump.php |
| 16 | /vendor/symfony/polyfill-intl-normalizer/bootstrap.php |
| 17 | /vendor/symfony/polyfill-intl-normalizer/bootstrap80.php |
| 18 | /vendor/twig/twig/src/Resources/core.php |
| 19 | /vendor/twig/twig/src/Resources/debug.php |
| 20 | /vendor/twig/twig/src/Resources/escaper.php |
| 21 | /vendor/twig/twig/src/Resources/string_loader.php |
| 22 | /vendor/symfony/polyfill-intl-grapheme/bootstrap.php |
| 23 | /vendor/symfony/polyfill-intl-grapheme/bootstrap80.php |
| 24 | /vendor/symfony/string/Resources/functions.php |
| 25 | /vendor/symfony/polyfill-intl-idn/bootstrap.php |
| 26 | /vendor/symfony/clock/Resources/now.php |
| 27 | /vendor/symfony/polyfill-php80/bootstrap.php |
| 28 | /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php |
| 29 | /vendor/jakeasmith/http_build_url/src/http_build_url.php |
| 30 | /vendor/symfony/polyfill-intl-icu/bootstrap.php |
| 31 | /vendor/ircmaxell/password-compat/lib/password.php |
| 32 | /vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php |
| 33 | /vendor/symfony/polyfill-php73/bootstrap.php |
| 34 | /vendor/symfony/translation/Resources/functions.php |
| 35 | /src/Core/Version.php |
| 36 | /config/alias.php |
| 37 | /vendor/prestashop/autoload/src/PrestashopAutoload.php |
| 38 | /vendor/prestashop/autoload/src/LegacyClassLoader.php |
| 39 | /vendor/symfony/filesystem/Filesystem.php |
| 40 | /vendor/prestashop/autoload/src/Autoloader.php |
| 41 | /config/bootstrap.php |
| 42 | /src/Core/ContainerBuilder.php |
| 43 | /src/Core/Foundation/IoC/Container.php |
| 44 | /src/Adapter/ServiceLocator.php |
| 45 | /var/cache/dev/appParameters.php |
| 48 | /var/cache/dev/class_index.php |
| 49 | /classes/controller/Controller.php |
| 51 | /classes/ObjectModel.php |
| 52 | /src/Core/Foundation/Database/EntityInterface.php |
| 54 | /classes/db/Db.php |
| 56 | /classes/Hook.php |
| 58 | /classes/module/Module.php |
| 59 | /src/Core/Module/Legacy/ModuleInterface.php |
| 61 | /classes/Tools.php |
| 62 | /classes/Context.php |
| 63 | /classes/shop/Shop.php |
| 64 | /src/Core/Security/PasswordGenerator.php |
| 65 | /classes/db/DbPDO.php |
| 66 | /classes/AddressFormat.php |
| 67 | /classes/Configuration.php |
| 68 | /src/Core/Domain/Shop/ValueObject/ShopConstraint.php |
| 69 | /classes/Validate.php |
| 70 | /src/PrestaShopBundle/Form/Admin/Type/FormattedTextareaType.php |
| 71 | /src/PrestaShopBundle/Form/Admin/Type/TranslatorAwareType.php |
| 72 | /src/PrestaShopBundle/Form/Admin/Type/CommonAbstractType.php |
| 73 | /vendor/symfony/form/AbstractType.php |
| 74 | /vendor/symfony/form/FormTypeInterface.php |
| 75 | /classes/cache/Cache.php |
| 76 | /src/Adapter/EntityMapper.php |
| 77 | /classes/db/DbQuery.php |
| 78 | /src/Core/Addon/Theme/ThemeManagerBuilder.php |
| 79 | /vendor/psr/log/src/NullLogger.php |
| 80 | /vendor/psr/log/src/AbstractLogger.php |
| 81 | /vendor/psr/log/src/LoggerTrait.php |
| 82 | /vendor/psr/log/src/LoggerInterface.php |
| 83 | /src/Core/Context/ApiClientContext.php |
| 84 | /src/Adapter/Configuration.php |
| 85 | /vendor/symfony/http-foundation/ParameterBag.php |
| 86 | /src/Core/Domain/Configuration/ShopConfigurationInterface.php |
| 87 | /src/Core/ConfigurationInterface.php |
| 88 | /src/Core/Addon/Theme/ThemeRepository.php |
| 89 | /src/Core/Addon/AddonRepositoryInterface.php |
| 90 | /src/Core/Addon/Theme/Theme.php |
| 91 | /src/Core/Addon/AddonInterface.php |
| 92 | /src/Core/Util/ArrayFinder.php |
| 93 | /vendor/symfony/property-access/PropertyAccess.php |
| 94 | /vendor/symfony/property-access/PropertyAccessorBuilder.php |
| 95 | /vendor/symfony/property-access/PropertyAccessor.php |
| 96 | /vendor/symfony/property-access/PropertyAccessorInterface.php |
| 97 | /vendor/symfony/property-info/Extractor/ReflectionExtractor.php |
| 98 | /vendor/symfony/property-info/PropertyListExtractorInterface.php |
| 99 | /vendor/symfony/property-info/PropertyTypeExtractorInterface.php |
| 100 | /vendor/symfony/property-info/PropertyAccessExtractorInterface.php |
| 101 | /vendor/symfony/property-info/PropertyInitializableExtractorInterface.php |
| 102 | /vendor/symfony/property-info/PropertyReadInfoExtractorInterface.php |
| 103 | /vendor/symfony/property-info/PropertyWriteInfoExtractorInterface.php |
| 104 | /vendor/symfony/property-info/Extractor/ConstructorArgumentTypeExtractorInterface.php |
| 105 | /vendor/symfony/property-info/Type.php |
| 106 | /vendor/symfony/string/Inflector/EnglishInflector.php |
| 107 | /vendor/symfony/string/Inflector/InflectorInterface.php |
| 108 | /vendor/symfony/property-access/PropertyPath.php |
| 109 | /vendor/symfony/property-access/PropertyPathInterface.php |
| 110 | /vendor/symfony/property-access/PropertyPathIteratorInterface.php |
| 111 | /config/defines_uri.inc.php |
| 112 | /classes/Language.php |
| 113 | /src/Core/Language/LanguageInterface.php |
| 114 | /classes/Country.php |
| 115 | /classes/PrestaShopCollection.php |
| 116 | /classes/shop/ShopGroup.php |
| 117 | /classes/Cookie.php |
| 118 | /src/Core/Http/CookieOptions.php |
| 119 | /classes/PhpEncryption.php |
| 120 | /classes/PhpEncryptionEngine.php |
| 121 | /vendor/defuse/php-encryption/src/Key.php |
| 122 | /vendor/defuse/php-encryption/src/Encoding.php |
| 123 | /vendor/defuse/php-encryption/src/Core.php |
| 124 | /vendor/defuse/php-encryption/src/Crypto.php |
| 125 | /vendor/defuse/php-encryption/src/KeyOrPassword.php |
| 126 | /vendor/defuse/php-encryption/src/RuntimeTests.php |
| 127 | /vendor/defuse/php-encryption/src/DerivedKeys.php |
| 128 | /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php |
| 129 | /vendor/defuse/php-encryption/src/Exception/CryptoException.php |
| 130 | /src/Core/Session/SessionHandler.php |
| 131 | /src/Core/Session/SessionHandlerInterface.php |
| 132 | /vendor/symfony/http-foundation/Session/Session.php |
| 133 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBag.php |
| 134 | /vendor/symfony/http-foundation/Session/Attribute/AttributeBagInterface.php |
| 135 | /vendor/symfony/http-foundation/Session/SessionBagInterface.php |
| 136 | /vendor/symfony/http-foundation/Session/Flash/FlashBag.php |
| 137 | /vendor/symfony/http-foundation/Session/Flash/FlashBagInterface.php |
| 138 | /vendor/symfony/http-foundation/Session/SessionBagProxy.php |
| 139 | /vendor/symfony/http-foundation/Session/FlashBagAwareSessionInterface.php |
| 140 | /vendor/symfony/http-foundation/Session/SessionInterface.php |
| 141 | /vendor/symfony/http-foundation/Session/Storage/PhpBridgeSessionStorage.php |
| 142 | /vendor/symfony/http-foundation/Session/Storage/NativeSessionStorage.php |
| 143 | /vendor/symfony/http-foundation/Session/Storage/MetadataBag.php |
| 144 | /vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php |
| 145 | /vendor/symfony/http-foundation/Session/Storage/Handler/AbstractSessionHandler.php |
| 146 | /vendor/symfony/http-foundation/Session/Storage/Proxy/SessionHandlerProxy.php |
| 147 | /vendor/symfony/http-foundation/Session/Storage/Proxy/AbstractProxy.php |
| 148 | /vendor/symfony/http-foundation/Session/Storage/SessionStorageInterface.php |
| 149 | /config/smarty.config.inc.php |
| 150 | /classes/Smarty/SmartyDev.php |
| 151 | /vendor/smarty/smarty/libs/Smarty.class.php |
| 152 | /vendor/smarty/smarty/libs/functions.php |
| 153 | /vendor/smarty/smarty/libs/Autoloader.php |
| 154 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php |
| 155 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php |
| 156 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| 157 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php |
| 158 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php |
| 159 | /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php |
| 160 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php |
| 161 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php |
| 162 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php |
| 163 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerclass.php |
| 164 | /classes/ImageManager.php |
| 165 | /classes/Product.php |
| 166 | /classes/Profile.php |
| 167 | /classes/Tab.php |
| 168 | /config/smartyfront.config.inc.php |
| 169 | /classes/Smarty/SmartyResourceModule.php |
| 170 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php |
| 171 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php |
| 172 | /classes/Smarty/SmartyResourceParent.php |
| 173 | /classes/Smarty/SmartyLazyRegister.php |
| 174 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php |
| 175 | /vendor/smarty/smarty/libs/plugins/modifier.truncate.php |
| 176 | /classes/Customer.php |
| 177 | /classes/Group.php |
| 178 | /classes/Link.php |
| 179 | /classes/shop/ShopUrl.php |
| 180 | /app/FrontKernel.php |
| 181 | /app/AppKernel.php |
| 182 | /vendor/symfony/http-kernel/Kernel.php |
| 183 | /vendor/symfony/config/ConfigCache.php |
| 184 | /vendor/symfony/config/ResourceCheckerConfigCache.php |
| 185 | /vendor/symfony/config/ConfigCacheInterface.php |
| 186 | /vendor/symfony/http-kernel/KernelInterface.php |
| 187 | /vendor/symfony/http-kernel/HttpKernelInterface.php |
| 188 | /vendor/symfony/http-kernel/RebootableInterface.php |
| 189 | /vendor/symfony/http-kernel/TerminableInterface.php |
| 190 | /vendor/symfony/dotenv/Dotenv.php |
| 191 | /classes/Dispatcher.php |
| 192 | /vendor/symfony/http-foundation/Request.php |
| 193 | /vendor/symfony/http-foundation/AcceptHeader.php |
| 194 | /vendor/symfony/http-foundation/AcceptHeaderItem.php |
| 195 | /vendor/symfony/http-foundation/FileBag.php |
| 196 | /vendor/symfony/http-foundation/HeaderBag.php |
| 197 | /vendor/symfony/http-foundation/HeaderUtils.php |
| 198 | /vendor/symfony/http-foundation/InputBag.php |
| 199 | /vendor/symfony/http-foundation/ServerBag.php |
| 200 | /src/Adapter/SymfonyContainer.php |
| 201 | /config/db_slave_server.inc.php |
| 202 | /src/Adapter/ContainerBuilder.php |
| 203 | /src/Adapter/Environment.php |
| 204 | /src/Core/EnvironmentInterface.php |
| 205 | /vendor/symfony/config/Resource/SelfCheckingResourceChecker.php |
| 206 | /vendor/symfony/config/ResourceCheckerInterface.php |
| 207 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/DoctrineProvider.php |
| 208 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php |
| 209 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php |
| 210 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php |
| 211 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php |
| 212 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiOperationCache.php |
| 213 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php |
| 214 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiDeleteCache.php |
| 215 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php |
| 216 | /vendor/symfony/cache/Adapter/ArrayAdapter.php |
| 217 | /vendor/psr/log/src/LoggerAwareTrait.php |
| 218 | /vendor/symfony/cache/Adapter/AdapterInterface.php |
| 219 | /vendor/symfony/cache/CacheItem.php |
| 220 | /vendor/symfony/cache-contracts/ItemInterface.php |
| 221 | /vendor/psr/cache/src/CacheItemInterface.php |
| 222 | /vendor/psr/cache/src/CacheItemPoolInterface.php |
| 223 | /vendor/symfony/cache-contracts/CacheInterface.php |
| 224 | /vendor/psr/log/src/LoggerAwareInterface.php |
| 225 | /vendor/symfony/cache/ResettableInterface.php |
| 226 | /vendor/symfony/service-contracts/ResetInterface.php |
| 227 | /vendor/doctrine/orm/src/Tools/Setup.php |
| 228 | /vendor/doctrine/deprecations/src/Deprecation.php |
| 229 | /vendor/doctrine/orm/src/Configuration.php |
| 230 | /vendor/doctrine/dbal/src/Configuration.php |
| 231 | /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/CacheAdapter.php |
| 232 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationReader.php |
| 233 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php |
| 234 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php |
| 235 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php |
| 236 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php |
| 237 | /vendor/doctrine/lexer/src/AbstractLexer.php |
| 238 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php |
| 239 | /vendor/doctrine/orm/src/Mapping/Driver/AnnotationDriver.php |
| 240 | /vendor/doctrine/orm/src/Mapping/Driver/CompatibilityAnnotationDriver.php |
| 241 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriver.php |
| 242 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/ColocatedMappingDriver.php |
| 243 | /vendor/doctrine/orm/src/Mapping/Driver/ReflectionBasedDriver.php |
| 244 | /vendor/symfony/cache/Adapter/FilesystemAdapter.php |
| 245 | /vendor/symfony/cache/Adapter/AbstractAdapter.php |
| 246 | /vendor/symfony/cache/Traits/AbstractAdapterTrait.php |
| 247 | /vendor/symfony/cache/Traits/ContractsTrait.php |
| 248 | /vendor/symfony/cache-contracts/CacheTrait.php |
| 249 | /vendor/psr/cache/src/InvalidArgumentException.php |
| 250 | /vendor/psr/cache/src/CacheException.php |
| 251 | /vendor/symfony/cache/Traits/FilesystemTrait.php |
| 252 | /vendor/symfony/cache/Traits/FilesystemCommonTrait.php |
| 253 | /vendor/symfony/cache/PruneableInterface.php |
| 254 | /vendor/symfony/cache/Marshaller/DefaultMarshaller.php |
| 255 | /vendor/symfony/cache/Marshaller/MarshallerInterface.php |
| 256 | /src/Adapter/Module/Repository/CachedModuleRepository.php |
| 257 | /src/Adapter/Module/Repository/ModuleRepository.php |
| 258 | /src/Core/Repository/AbstractObjectModelRepository.php |
| 259 | /vendor/symfony/cache/LockRegistry.php |
| 260 | /modules/ps_facebook/vendor/autoload.php |
| 261 | /modules/ps_facebook/vendor/composer/autoload_real.php |
| 262 | /modules/ps_facebook/vendor/composer/autoload_static.php |
| 263 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment.php |
| 264 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Client.php |
| 265 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer.php |
| 266 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/QueueConsumer.php |
| 267 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/File.php |
| 268 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/ForkCurl.php |
| 269 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/LibCurl.php |
| 270 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Consumer/Socket.php |
| 271 | /modules/ps_facebook/vendor/segmentio/analytics-php/lib/Segment/Version.php |
| 272 | /modules/ps_classic_edition/vendor/autoload.php |
| 273 | /modules/ps_classic_edition/vendor/composer/autoload_real.php |
| 274 | /modules/ps_classic_edition/vendor/composer/platform_check.php |
| 275 | /modules/ps_classic_edition/vendor/composer/autoload_static.php |
| 276 | /modules/psshipping/vendor/autoload.php |
| 277 | /modules/psshipping/vendor/composer/autoload_real.php |
| 278 | /modules/psshipping/vendor/composer/autoload_static.php |
| 279 | /modules/psshipping/vendor/ralouphie/getallheaders/src/getallheaders.php |
| 280 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions_include.php |
| 281 | /modules/psshipping/vendor/guzzlehttp/psr7/src/functions.php |
| 282 | /modules/psshipping/vendor/clue/stream-filter/src/functions_include.php |
| 283 | /modules/psshipping/vendor/clue/stream-filter/src/functions.php |
| 284 | /modules/psshipping/vendor/php-http/message/src/filters.php |
| 285 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions_include.php |
| 286 | /modules/psshipping/vendor/guzzlehttp/guzzle/src/functions.php |
| 287 | /modules/ps_eventbus/vendor/autoload.php |
| 288 | /modules/ps_eventbus/vendor/composer/autoload_real.php |
| 289 | /modules/ps_eventbus/vendor/composer/autoload_static.php |
| 290 | /modules/ps_checkout/vendor/autoload.php |
| 291 | /modules/ps_checkout/vendor/composer/autoload_real.php |
| 292 | /modules/ps_checkout/vendor/composer/platform_check.php |
| 293 | /modules/ps_checkout/vendor/composer/autoload_static.php |
| 294 | /modules/ps_checkout/vendor/ramsey/uuid/src/functions.php |
| 295 | /modules/psxmarketingwithgoogle/vendor/autoload.php |
| 296 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_real.php |
| 297 | /modules/psxmarketingwithgoogle/vendor/composer/autoload_static.php |
| 298 | /modules/ps_mbo/vendor/autoload.php |
| 299 | /modules/ps_mbo/vendor/composer/autoload_real.php |
| 300 | /modules/ps_mbo/vendor/composer/platform_check.php |
| 301 | /modules/ps_mbo/vendor/composer/autoload_static.php |
| 302 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions_include.php |
| 303 | /modules/ps_mbo/vendor/guzzlehttp/promises/src/functions.php |
| 304 | /modules/ps_mbo/vendor/sentry/sentry/src/functions.php |
| 305 | /modules/ps_mbo/bootstrap.php |
| 306 | /modules/ps_mbo/src/Helpers/EnvHelper.php |
| 307 | /modules/ps_accounts/vendor/autoload.php |
| 308 | /modules/ps_accounts/vendor/composer/autoload_real.php |
| 309 | /modules/ps_accounts/vendor/composer/platform_check.php |
| 310 | /modules/ps_accounts/vendor/composer/autoload_static.php |
| 311 | /modules/ps_accounts/vendor/paragonie/random_compat/lib/random.php |
| 312 | /modules/ps_accounts/vendor/symfony/polyfill-ctype/bootstrap.php |
| 313 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/class-aliases.php |
| 314 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Token.php |
| 315 | /modules/ps_accounts/vendor/lcobucci/jwt/src/Signature.php |
| 316 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/json-exception-polyfill.php |
| 317 | /modules/ps_accounts/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php |
| 318 | /modules/ps_accounts/vendor/ramsey/uuid/src/functions.php |
| 319 | /vendor/symfony/config/Resource/FileResource.php |
| 320 | /vendor/symfony/config/Resource/SelfCheckingResourceInterface.php |
| 321 | /vendor/symfony/config/Resource/ResourceInterface.php |
| 322 | /vendor/symfony/config/Resource/ReflectionClassResource.php |
| 323 | /vendor/symfony/config/Resource/DirectoryResource.php |
| 324 | /var/cache/dev/FrontContainer.php |
| 325 | /src/Adapter/Container/LegacyContainer.php |
| 326 | /vendor/symfony/dependency-injection/Container.php |
| 327 | /vendor/symfony/dependency-injection/Argument/RewindableGenerator.php |
| 328 | /vendor/symfony/dependency-injection/Argument/ServiceLocator.php |
| 329 | /vendor/symfony/dependency-injection/ServiceLocator.php |
| 330 | /vendor/symfony/service-contracts/ServiceLocatorTrait.php |
| 331 | /vendor/psr/container/src/ContainerExceptionInterface.php |
| 332 | /vendor/psr/container/src/NotFoundExceptionInterface.php |
| 333 | /vendor/symfony/service-contracts/ServiceProviderInterface.php |
| 334 | /vendor/psr/container/src/ContainerInterface.php |
| 335 | /vendor/symfony/dependency-injection/ContainerInterface.php |
| 336 | /src/Adapter/Container/LegacyContainerInterface.php |
| 337 | /src/PrestaShopBundle/Entity/Repository/FeatureFlagRepository.php |
| 338 | /vendor/doctrine/orm/src/EntityRepository.php |
| 339 | /vendor/doctrine/persistence/src/Persistence/ObjectRepository.php |
| 340 | /vendor/doctrine/collections/lib/Doctrine/Common/Collections/Selectable.php |
| 341 | /vendor/symfony/var-exporter/LazyProxyTrait.php |
| 342 | /vendor/symfony/var-exporter/Internal/LazyObjectTrait.php |
| 343 | /vendor/symfony/var-exporter/LazyObjectInterface.php |
| 344 | /vendor/symfony/var-exporter/Internal/Hydrator.php |
| 345 | /vendor/symfony/var-exporter/Internal/LazyObjectRegistry.php |
| 346 | /vendor/symfony/var-exporter/Internal/LazyObjectState.php |
| 347 | /src/PrestaShopBundle/Security/Admin/LegacyAdminTokenValidator.php |
| 348 | /vendor/symfony/var-exporter/LazyGhostTrait.php |
| 349 | /src/Core/FeatureFlag/FeatureFlagManager.php |
| 350 | /src/Core/FeatureFlag/FeatureFlagStateCheckerInterface.php |
| 351 | /src/Core/FeatureFlag/Layer/DbLayer.php |
| 352 | /src/Core/FeatureFlag/TypeLayerInterface.php |
| 353 | /src/Core/FeatureFlag/Layer/DotEnvLayer.php |
| 354 | /src/Core/FeatureFlag/Layer/EnvLayer.php |
| 355 | /src/Core/FeatureFlag/Layer/QueryLayer.php |
| 356 | /vendor/symfony/http-foundation/RequestStack.php |
| 357 | /vendor/doctrine/orm/src/EntityManager.php |
| 358 | /vendor/doctrine/orm/src/EntityManagerInterface.php |
| 359 | /vendor/doctrine/persistence/src/Persistence/ObjectManager.php |
| 360 | /src/Core/Hook/HookModuleFilter.php |
| 361 | /src/Core/Hook/HookModuleFilterInterface.php |
| 362 | /modules/ps_checkout/ps_checkout.php |
| 363 | /classes/PaymentModule.php |
| 364 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php |
| 365 | /vendor/smarty/smarty/libs/sysplugins/smarty_data.php |
| 366 | /classes/Translate.php |
| 367 | /modules/ps_checkout/translations/en.php |
| 368 | /src/PrestaShopBundle/Translation/TranslatorComponent.php |
| 369 | /vendor/symfony/translation/Translator.php |
| 370 | /vendor/symfony/translation/MessageCatalogue.php |
| 371 | /vendor/symfony/translation/MessageCatalogueInterface.php |
| 372 | /vendor/symfony/translation/MetadataAwareInterface.php |
| 373 | /vendor/symfony/translation/CatalogueMetadataAwareInterface.php |
| 374 | /vendor/symfony/translation-contracts/TranslatorInterface.php |
| 375 | /vendor/symfony/translation/TranslatorBagInterface.php |
| 376 | /vendor/symfony/translation-contracts/LocaleAwareInterface.php |
| 377 | /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php |
| 378 | /src/PrestaShopBundle/Translation/TranslatorLanguageTrait.php |
| 379 | /src/PrestaShopBundle/Translation/TranslatorInterface.php |
| 380 | /vendor/symfony/translation/Formatter/MessageFormatter.php |
| 381 | /vendor/symfony/translation/Formatter/IntlFormatter.php |
| 382 | /vendor/symfony/translation/Formatter/IntlFormatterInterface.php |
| 383 | /vendor/symfony/translation/Formatter/MessageFormatterInterface.php |
| 384 | /vendor/symfony/translation/IdentityTranslator.php |
| 385 | /vendor/symfony/translation-contracts/TranslatorTrait.php |
| 386 | /vendor/symfony/config/ConfigCacheFactory.php |
| 387 | /vendor/symfony/config/ConfigCacheFactoryInterface.php |
| 388 | /var/cache/dev/translations/catalogue.en-US.NXhscRe.php |
| 389 | /controllers/front/listing/CategoryController.php |
| 390 | /classes/controller/ProductListingFrontController.php |
| 391 | /classes/controller/ProductPresentingFrontController.php |
| 392 | /classes/controller/FrontController.php |
| 393 | /src/Adapter/Presenter/Object/ObjectPresenter.php |
| 394 | /src/Adapter/Presenter/PresenterInterface.php |
| 395 | /src/Adapter/Presenter/Cart/CartPresenter.php |
| 396 | /src/Adapter/Image/ImageRetriever.php |
| 397 | /classes/tax/TaxConfiguration.php |
| 398 | /classes/Smarty/TemplateFinder.php |
| 399 | /classes/assets/StylesheetManager.php |
| 400 | /classes/assets/AbstractAssetManager.php |
| 401 | /src/Adapter/Assets/AssetUrlGeneratorTrait.php |
| 402 | /classes/assets/JavascriptManager.php |
| 403 | /classes/assets/CccReducer.php |
| 404 | /classes/Category.php |
| 405 | /src/Core/Domain/Category/ValueObject/RedirectType.php |
| 406 | /src/Core/Domain/Category/CategorySettings.php |
| 407 | /src/Core/Domain/Category/SeoSettings.php |
| 408 | /classes/webservice/WebserviceRequest.php |
| 409 | /src/Core/Localization/Locale/Repository.php |
| 410 | /src/Core/Localization/Locale/RepositoryInterface.php |
| 411 | /src/Core/Localization/CLDR/LocaleRepository.php |
| 412 | /src/Core/Localization/CLDR/LocaleDataSource.php |
| 413 | /src/Core/Localization/CLDR/DataLayer/LocaleCache.php |
| 414 | /src/Core/Data/Layer/AbstractDataLayer.php |
| 415 | /src/Core/Localization/CLDR/LocaleDataLayerInterface.php |
| 416 | /src/Core/Localization/CLDR/DataLayer/LocaleReference.php |
| 417 | /src/Core/Localization/CLDR/Reader.php |
| 418 | /src/Core/Localization/CLDR/ReaderInterface.php |
| 419 | /src/Core/Localization/Currency/Repository.php |
| 420 | /src/Core/Localization/Currency/RepositoryInterface.php |
| 421 | /src/Core/Localization/Currency/CurrencyDataSource.php |
| 422 | /src/Core/Localization/Currency/DataSourceInterface.php |
| 423 | /src/Core/Localization/Currency/DataLayer/CurrencyCache.php |
| 424 | /src/Core/Localization/Currency/CurrencyDataLayerInterface.php |
| 425 | /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php |
| 426 | /src/Adapter/Currency/CurrencyDataProvider.php |
| 427 | /src/Core/Currency/CurrencyDataProviderInterface.php |
| 428 | /src/Adapter/LegacyContext.php |
| 429 | /src/Adapter/Tools.php |
| 430 | /src/Core/Localization/Currency/DataLayer/CurrencyReference.php |
| 431 | /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php |
| 432 | /vendor/prestashop/decimal/src/Operation/Rounding.php |
| 433 | /src/Core/Localization/Locale.php |
| 434 | /src/Core/Localization/LocaleInterface.php |
| 435 | /src/Core/Localization/Specification/Price.php |
| 436 | /src/Core/Localization/Specification/Number.php |
| 437 | /src/Core/Localization/Specification/NumberInterface.php |
| 438 | /src/Core/Localization/Specification/Factory.php |
| 439 | /src/Core/Localization/CLDR/LocaleData.php |
| 440 | /src/Core/Localization/CLDR/NumberSymbolsData.php |
| 441 | /src/Core/Localization/CLDR/CurrencyData.php |
| 442 | /src/Core/Localization/CLDR/Locale.php |
| 443 | /src/Core/Localization/CLDR/LocaleInterface.php |
| 444 | /src/Core/Localization/Specification/NumberSymbolList.php |
| 445 | /classes/Currency.php |
| 446 | /src/Core/Localization/Currency/LocalizedCurrencyId.php |
| 447 | /src/Core/Localization/Currency/CurrencyData.php |
| 448 | /src/Core/Localization/Currency/CurrencyCollection.php |
| 449 | /src/Core/Localization/Currency.php |
| 450 | /src/Core/Localization/CurrencyInterface.php |
| 451 | /src/Core/Localization/Specification/NumberCollection.php |
| 452 | /src/Core/Localization/Number/Formatter.php |
| 453 | /classes/Cart.php |
| 454 | /src/Adapter/AddressFactory.php |
| 455 | /classes/CartRule.php |
| 456 | /src/Core/Domain/Product/ValueObject/RedirectType.php |
| 457 | /src/Core/Util/DateTime/DateTime.php |
| 458 | /src/Core/Domain/Product/Stock/ValueObject/OutOfStockType.php |
| 459 | /src/Core/Domain/Product/Pack/ValueObject/PackStockType.php |
| 460 | /src/Core/Domain/Product/ValueObject/ProductType.php |
| 461 | /src/Core/Domain/Product/ValueObject/Reference.php |
| 462 | /src/Core/Domain/Product/ValueObject/Gtin.php |
| 463 | /src/Core/Domain/Product/ValueObject/Isbn.php |
| 464 | /src/Core/Domain/Product/ValueObject/Upc.php |
| 465 | /src/Core/Domain/Product/ProductSettings.php |
| 466 | /src/Adapter/Presenter/Category/CategoryPresenter.php |
| 467 | /src/Adapter/Presenter/Category/CategoryLazyArray.php |
| 468 | /src/Adapter/Presenter/AbstractLazyArray.php |
| 469 | /src/Adapter/Presenter/LazyArrayAttribute.php |
| 470 | /src/Core/Util/Inflector.php |
| 471 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/InflectorFactory.php |
| 472 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Language.php |
| 473 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/InflectorFactory.php |
| 474 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/GenericLanguageInflectorFactory.php |
| 475 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/LanguageInflectorFactory.php |
| 476 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Rules.php |
| 477 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Ruleset.php |
| 478 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformations.php |
| 479 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/WordInflector.php |
| 480 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Inflectible.php |
| 481 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformation.php |
| 482 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Pattern.php |
| 483 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Patterns.php |
| 484 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Uninflected.php |
| 485 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitutions.php |
| 486 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitution.php |
| 487 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Word.php |
| 488 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/Inflector.php |
| 489 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/CachedWordInflector.php |
| 490 | /vendor/doctrine/inflector/lib/Doctrine/Inflector/RulesetInflector.php |
| 491 | /src/Core/Domain/Shop/ValueObject/ShopId.php |
| 492 | /src/Core/Domain/Shop/ValueObject/ShopIdInterface.php |
| 493 | /vendor/symfony/property-access/Exception/UnexpectedTypeException.php |
| 494 | /vendor/symfony/property-access/Exception/RuntimeException.php |
| 495 | /vendor/symfony/property-access/Exception/ExceptionInterface.php |
| 496 | /modules/blockreassurance/blockreassurance.php |
| 497 | /src/Core/Module/WidgetInterface.php |
| 498 | /src/PrestaShopBundle/Translation/DomainNormalizer.php |
| 499 | /classes/Media.php |
| 500 | /modules/blockwishlist/blockwishlist.php |
| 501 | /modules/ps_emailsubscription/ps_emailsubscription.php |
| 502 | /modules/ps_socialfollow/ps_socialfollow.php |
| 503 | /modules/ps_facebook/ps_facebook.php |
| 504 | /modules/ps_facebook/translations/en.php |
| 505 | /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php |
| 506 | /modules/ps_facebook/vendor/prestashop/module-lib-cache-directory-provider/src/Cache/CacheDirectoryProvider.php |
| 507 | /modules/ps_facebook/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ContainerProvider.php |
| 508 | /var/cache/dev/Ps_facebookFrontContainer.php |
| 509 | /modules/ps_facebook/classes/Buffer/TemplateBuffer.php |
| 510 | /modules/ps_emailalerts/ps_emailalerts.php |
| 511 | /modules/ps_emailalerts/MailAlert.php |
| 512 | /var/cache/dev/Ps_checkout9433FrontContainer.php |
| 513 | /modules/ps_checkout/src/Validator/FrontControllerValidator.php |
| 514 | /modules/ps_checkout/src/Validator/MerchantValidator.php |
| 515 | /modules/ps_checkout/src/PayPal/PayPalConfiguration.php |
| 516 | /modules/ps_checkout/src/Configuration/PrestaShopConfiguration.php |
| 517 | /modules/ps_checkout/src/Configuration/PrestaShopConfigurationOptionsResolver.php |
| 518 | /modules/ps_checkout/src/Shop/ShopProvider.php |
| 519 | /vendor/symfony/options-resolver/OptionsResolver.php |
| 520 | /vendor/symfony/options-resolver/Options.php |
| 521 | /modules/ps_checkout/src/Repository/PayPalCodeRepository.php |
| 522 | /modules/ps_checkout/src/Repository/PsAccountRepository.php |
| 523 | /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php |
| 524 | /modules/ps_facebook/vendor/prestashop/prestashop-accounts-installer/src/Installer/Installer.php |
| 525 | /src/Core/Addon/Module/ModuleManagerBuilder.php |
| 526 | /src/Adapter/LegacyLogger.php |
| 527 | /src/Adapter/Module/ModuleDataProvider.php |
| 528 | /src/Adapter/Module/AdminModuleDataProvider.php |
| 529 | /src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php |
| 530 | /src/Adapter/Module/Module.php |
| 531 | /src/Core/Module/ModuleInterface.php |
| 532 | /vendor/symfony/config/FileLocator.php |
| 533 | /vendor/symfony/config/FileLocatorInterface.php |
| 534 | /vendor/symfony/routing/Loader/YamlFileLoader.php |
| 535 | /vendor/symfony/config/Loader/FileLoader.php |
| 536 | /vendor/symfony/config/Loader/Loader.php |
| 537 | /vendor/symfony/config/Loader/LoaderInterface.php |
| 538 | /vendor/symfony/routing/Loader/Configurator/Traits/HostTrait.php |
| 539 | /vendor/symfony/routing/Loader/Configurator/Traits/LocalizedRouteTrait.php |
| 540 | /vendor/symfony/routing/Loader/Configurator/Traits/PrefixTrait.php |
| 541 | /vendor/symfony/routing/Router.php |
| 542 | /vendor/symfony/routing/RouterInterface.php |
| 543 | /vendor/symfony/routing/Matcher/UrlMatcherInterface.php |
| 544 | /vendor/symfony/routing/RequestContextAwareInterface.php |
| 545 | /vendor/symfony/routing/Generator/UrlGeneratorInterface.php |
| 546 | /vendor/symfony/routing/Matcher/RequestMatcherInterface.php |
| 547 | /vendor/symfony/routing/RequestContext.php |
| 548 | /src/Core/Module/ModuleManager.php |
| 549 | /src/Core/Module/ModuleManagerInterface.php |
| 550 | /src/Core/Module/ModuleRepository.php |
| 551 | /src/Core/Module/ModuleRepositoryInterface.php |
| 552 | /src/Adapter/HookManager.php |
| 553 | /src/Core/Context/LanguageContext.php |
| 554 | /src/Core/Module/SourceHandler/SourceHandlerFactory.php |
| 555 | /src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php |
| 556 | /vendor/symfony/event-dispatcher/EventDispatcherInterface.php |
| 557 | /vendor/symfony/event-dispatcher-contracts/EventDispatcherInterface.php |
| 558 | /vendor/psr/event-dispatcher/src/EventDispatcherInterface.php |
| 559 | /src/Core/Hook/HookDispatcherInterface.php |
| 560 | /vendor/symfony/translation/Loader/XliffFileLoader.php |
| 561 | /vendor/symfony/translation/Loader/LoaderInterface.php |
| 562 | /modules/ps_accounts/ps_accounts.php |
| 563 | /modules/ps_accounts/src/Hook/HookableTrait.php |
| 564 | /modules/ps_accounts/src/Module/Install.php |
| 565 | /modules/ps_accounts/src/Settings/SettingsForm.php |
| 566 | /modules/ps_accounts/translations/en.php |
| 567 | /modules/ps_accounts/src/ServiceContainer/PsAccountsContainer.php |
| 568 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/ServiceContainer.php |
| 569 | /modules/ps_accounts/config.php |
| 570 | /modules/ps_accounts/src/Log/Logger.php |
| 571 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Logger.php |
| 572 | /modules/ps_accounts/vendor/psr/log/Psr/Log/LoggerInterface.php |
| 573 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/ResettableInterface.php |
| 574 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/RotatingFileHandler.php |
| 575 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php |
| 576 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php |
| 577 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php |
| 578 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Handler/HandlerInterface.php |
| 579 | /modules/ps_accounts/vendor/monolog/monolog/src/Monolog/Utils.php |
| 580 | /modules/ps_accounts/src/ServiceProvider/ApiClientProvider.php |
| 581 | /modules/ps_accounts/vendor/prestashopcorp/lightweight-container/src/ServiceContainer/Contract/IServiceProvider.php |
| 582 | /modules/ps_accounts/src/ServiceProvider/CommandProvider.php |
| 583 | /modules/ps_accounts/src/ServiceProvider/DefaultProvider.php |
| 584 | /modules/ps_accounts/src/ServiceProvider/OAuth2Provider.php |
| 585 | /modules/ps_accounts/src/ServiceProvider/QueryProvider.php |
| 586 | /modules/ps_accounts/src/ServiceProvider/RepositoryProvider.php |
| 587 | /modules/ps_accounts/src/ServiceProvider/SessionProvider.php |
| 588 | /modules/ps_accounts/src/Service/PsAccountsService.php |
| 589 | /modules/ps_accounts/src/Account/Session/ShopSession.php |
| 590 | /modules/ps_accounts/src/Account/Session/Session.php |
| 591 | /modules/ps_accounts/src/Account/Session/SessionInterface.php |
| 592 | /modules/ps_accounts/src/Repository/ConfigurationRepository.php |
| 593 | /modules/ps_accounts/src/Adapter/Configuration.php |
| 594 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Service.php |
| 595 | /modules/ps_accounts/src/Http/Client/ClientConfig.php |
| 596 | /modules/ps_accounts/src/Http/Client/ConfigObject.php |
| 597 | /modules/ps_accounts/src/Type/Enum.php |
| 598 | /modules/ps_accounts/src/Service/OAuth2/OAuth2Client.php |
| 599 | /modules/ps_accounts/src/Adapter/Link.php |
| 600 | /modules/ps_accounts/src/Context/ShopContext.php |
| 601 | /modules/ps_accounts/vendor/ramsey/uuid/src/Uuid.php |
| 602 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidInterface.php |
| 603 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactory.php |
| 604 | /modules/ps_accounts/vendor/ramsey/uuid/src/UuidFactoryInterface.php |
| 605 | /modules/ps_accounts/vendor/ramsey/uuid/src/FeatureSet.php |
| 606 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Number/DegradedNumberConverter.php |
| 607 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/NumberConverterInterface.php |
| 608 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/DefaultUuidBuilder.php |
| 609 | /modules/ps_accounts/vendor/ramsey/uuid/src/Builder/UuidBuilderInterface.php |
| 610 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/StringCodec.php |
| 611 | /modules/ps_accounts/vendor/ramsey/uuid/src/Codec/CodecInterface.php |
| 612 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/FallbackNodeProvider.php |
| 613 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/NodeProviderInterface.php |
| 614 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/SystemNodeProvider.php |
| 615 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Node/RandomNodeProvider.php |
| 616 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorFactory.php |
| 617 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomBytesGenerator.php |
| 618 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/RandomGeneratorInterface.php |
| 619 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/Time/SystemTimeProvider.php |
| 620 | /modules/ps_accounts/vendor/ramsey/uuid/src/Provider/TimeProviderInterface.php |
| 621 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorFactory.php |
| 622 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/Time/PhpTimeConverter.php |
| 623 | /modules/ps_accounts/vendor/ramsey/uuid/src/Converter/TimeConverterInterface.php |
| 624 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/DefaultTimeGenerator.php |
| 625 | /modules/ps_accounts/vendor/ramsey/uuid/src/Generator/TimeGeneratorInterface.php |
| 626 | /modules/ps_accounts/vendor/ramsey/uuid/src/BinaryUtils.php |
| 627 | /modules/ps_accounts/src/Service/OAuth2/CachedFile.php |
| 628 | /modules/ps_accounts/src/Account/Session/Firebase/ShopSession.php |
| 629 | /modules/ps_accounts/src/Account/Session/Firebase/FirebaseSession.php |
| 630 | /modules/ps_accounts/src/Account/Session/Firebase/OwnerSession.php |
| 631 | /modules/ps_accounts/src/Account/StatusManager.php |
| 632 | /modules/ps_accounts/src/Traits/WithOriginAndSourceTrait.php |
| 633 | /modules/ps_accounts/src/Traits/WithPropertyTrait.php |
| 634 | /modules/ps_accounts/src/Service/Accounts/AccountsService.php |
| 635 | /modules/ps_accounts/src/Service/AnalyticsService.php |
| 636 | /modules/ps_accounts/src/Service/AdminTokenService.php |
| 637 | /modules/ps_checkout/src/ExpressCheckout/ExpressCheckoutConfiguration.php |
| 638 | /modules/ps_checkout/src/PayPal/PayPalPayLaterConfiguration.php |
| 639 | /modules/ps_checkout/src/Version/Version.php |
| 640 | /src/Adapter/Presenter/Cart/CartLazyArray.php |
| 641 | /src/Adapter/Product/PriceFormatter.php |
| 642 | /classes/Gender.php |
| 643 | /src/Core/Domain/Title/ValueObject/Gender.php |
| 644 | /classes/Risk.php |
| 645 | /classes/Meta.php |
| 646 | /classes/Address.php |
| 647 | /classes/ImageType.php |
| 648 | /classes/State.php |
| 649 | /src/Core/Security/PasswordPolicyConfiguration.php |
| 650 | /src/Core/Configuration/DataConfigurationInterface.php |
| 651 | /src/Core/Security/Hashing.php |
| 652 | /src/Core/Filter/FrontEndObject/MainFilter.php |
| 653 | /src/Core/Filter/FilterInterface.php |
| 654 | /src/Core/Filter/FrontEndObject/CartFilter.php |
| 655 | /src/Core/Filter/HashMapWhitelistFilter.php |
| 656 | /src/Core/Filter/CollectionFilter.php |
| 657 | /src/Core/Filter/FrontEndObject/ProductFilter.php |
| 658 | /src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php |
| 659 | /src/Core/Filter/FrontEndObject/CustomerFilter.php |
| 660 | /src/Core/Filter/FrontEndObject/ShopFilter.php |
| 661 | /src/Core/Filter/FrontEndObject/ConfigurationFilter.php |
| 662 | /classes/ProductAssembler.php |
| 663 | /src/Core/Product/Search/ProductSearchContext.php |
| 664 | /modules/ps_shoppingcart/ps_shoppingcart.php |
| 665 | /modules/ps_searchbar/ps_searchbar.php |
| 666 | /modules/ps_imageslider/ps_imageslider.php |
| 667 | /modules/ps_imageslider/Ps_HomeSlide.php |
| 668 | /modules/productcomments/productcomments.php |
| 669 | /modules/ps_facebook/classes/Handler/ErrorHandler/ErrorHandler.php |
| 670 | /modules/ps_facebook/classes/Config/Env.php |
| 671 | /modules/ps_facebook/classes/Handler/ErrorHandler/ModuleFilteredRavenClient.php |
| 672 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Client.php |
| 673 | /modules/ps_facebook/classes/Config/Config.php |
| 674 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Util.php |
| 675 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Compat.php |
| 676 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor/SanitizeDataProcessor.php |
| 677 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Processor.php |
| 678 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Context.php |
| 679 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs.php |
| 680 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Serializer.php |
| 681 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ReprSerializer.php |
| 682 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/TransactionStack.php |
| 683 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Breadcrumbs/ErrorHandler.php |
| 684 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/Stacktrace.php |
| 685 | /modules/ps_accounts/src/Adapter/ConfigurationKeys.php |
| 686 | /modules/ps_accounts/src/Account/CachedShopStatus.php |
| 687 | /modules/ps_accounts/src/Http/Resource/Resource.php |
| 688 | /modules/ps_accounts/src/Type/Dto.php |
| 689 | /modules/ps_accounts/src/Service/Accounts/Resource/ShopStatus.php |
| 690 | /modules/ps_facebook/vendor/sentry/sentry/lib/Raven/ErrorHandler.php |
| 691 | /modules/ps_facebook/classes/Dispatcher/EventDispatcher.php |
| 692 | /modules/ps_facebook/classes/Handler/ApiConversionHandler.php |
| 693 | /modules/ps_facebook/classes/Adapter/ConfigurationAdapter.php |
| 694 | /modules/ps_facebook/classes/Factory/ContextFactory.php |
| 695 | /modules/ps_facebook/classes/API/Client/FacebookClient.php |
| 696 | /modules/ps_facebook/classes/Factory/FacebookEssentialsApiClientFactory.php |
| 697 | /modules/ps_facebook/classes/Factory/ApiClientFactoryInterface.php |
| 698 | /modules/ps_facebook/classes/Provider/AccessTokenProvider.php |
| 699 | /modules/ps_facebook/classes/Factory/PsApiClientFactory.php |
| 700 | /modules/ps_facebook/classes/Handler/ConfigurationHandler.php |
| 701 | /modules/ps_facebook/classes/Http/HttpClient.php |
| 702 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Api.php |
| 703 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Session.php |
| 704 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/SessionInterface.php |
| 705 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/ApiConfig.php |
| 706 | /modules/ps_facebook/vendor/facebook/php-business-sdk/src/FacebookAds/Http/Client.php |
| 707 | /modules/ps_facebook/classes/Handler/PixelHandler.php |
| 708 | /vendor/symfony/http-foundation/Session/Storage/MockFileSessionStorage.php |
| 709 | /vendor/symfony/http-foundation/Session/Storage/MockArraySessionStorage.php |
| 710 | /modules/ps_facebook/classes/Provider/EventDataProvider.php |
| 711 | /modules/ps_facebook/classes/Adapter/ToolsAdapter.php |
| 712 | /modules/ps_facebook/classes/Repository/ProductRepository.php |
| 713 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProvider.php |
| 714 | /modules/ps_facebook/classes/Provider/ProductAvailabilityProviderInterface.php |
| 715 | /modules/ps_facebook/classes/Repository/GoogleCategoryRepository.php |
| 716 | /modules/ps_facebook/classes/Provider/GoogleCategoryProvider.php |
| 717 | /modules/ps_facebook/classes/Provider/GoogleCategoryProviderInterface.php |
| 718 | /modules/psshipping/psshipping.php |
| 719 | /src/Adapter/Localization/LegacyTranslator.php |
| 720 | /var/cache/dev/PsshippingFrontContainer.php |
| 721 | /modules/psshipping/src/Hooks/HookDisplayHeader.php |
| 722 | /modules/psshipping/src/Domain/GelProximity/GelProximityService.php |
| 723 | /modules/psshipping/src/Domain/Carriers/CarrierRepository.php |
| 724 | /src/Adapter/ContainerFinder.php |
| 725 | /vendor/doctrine/dbal/src/Logging/LoggerChain.php |
| 726 | /vendor/doctrine/dbal/src/Logging/SQLLogger.php |
| 727 | /vendor/symfony/doctrine-bridge/Logger/DbalLogger.php |
| 728 | /vendor/doctrine/dbal/src/Logging/DebugStack.php |
| 729 | /vendor/doctrine/doctrine-bundle/ConnectionFactory.php |
| 730 | /src/PrestaShopBundle/DependencyInjection/RuntimeConstEnvVarProcessor.php |
| 731 | /vendor/symfony/dependency-injection/EnvVarProcessorInterface.php |
| 732 | /vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php |
| 733 | /vendor/doctrine/event-manager/src/EventManager.php |
| 734 | /vendor/doctrine/dbal/src/DriverManager.php |
| 735 | /vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php |
| 736 | /vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php |
| 737 | /vendor/doctrine/dbal/src/VersionAwarePlatformDriver.php |
| 738 | /vendor/doctrine/dbal/src/Driver.php |
| 739 | /src/PrestaShopBundle/Doctrine/DatabaseConnection.php |
| 740 | /vendor/doctrine/dbal/src/Connection.php |
| 741 | /vendor/doctrine/dbal/src/ArrayParameterType.php |
| 742 | /vendor/doctrine/dbal/src/ParameterType.php |
| 743 | /vendor/doctrine/dbal/src/Query/Expression/ExpressionBuilder.php |
| 744 | /vendor/doctrine/dbal/src/Schema/LegacySchemaManagerFactory.php |
| 745 | /vendor/doctrine/dbal/src/Schema/SchemaManagerFactory.php |
| 746 | /vendor/doctrine/dbal/src/Driver/PDO/Connection.php |
| 747 | /vendor/doctrine/dbal/src/Driver/ServerInfoAwareConnection.php |
| 748 | /vendor/doctrine/dbal/src/Driver/Connection.php |
| 749 | /vendor/doctrine/dbal/src/Events.php |
| 750 | /vendor/doctrine/dbal/src/Platforms/MariaDb1010Platform.php |
| 751 | /vendor/doctrine/dbal/src/Platforms/MariaDb1060Platform.php |
| 752 | /vendor/doctrine/dbal/src/Platforms/MariaDb1052Platform.php |
| 753 | /vendor/doctrine/dbal/src/Platforms/MariaDb1043Platform.php |
| 754 | /vendor/doctrine/dbal/src/Platforms/MariaDb1027Platform.php |
| 755 | /vendor/doctrine/dbal/src/Platforms/MariaDBPlatform.php |
| 756 | /vendor/doctrine/dbal/src/Platforms/MySQLPlatform.php |
| 757 | /vendor/doctrine/dbal/src/Platforms/AbstractMySQLPlatform.php |
| 758 | /vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php |
| 759 | /vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php |
| 760 | /vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php |
| 761 | /vendor/doctrine/dbal/src/Types/Types.php |
| 762 | /vendor/doctrine/dbal/src/Types/Type.php |
| 763 | /vendor/doctrine/dbal/src/Types/ArrayType.php |
| 764 | /vendor/doctrine/dbal/src/Types/AsciiStringType.php |
| 765 | /vendor/doctrine/dbal/src/Types/StringType.php |
| 766 | /vendor/doctrine/dbal/src/Types/BigIntType.php |
| 767 | /vendor/doctrine/dbal/src/Types/PhpIntegerMappingType.php |
| 768 | /vendor/doctrine/dbal/src/Types/BinaryType.php |
| 769 | /vendor/doctrine/dbal/src/Types/BlobType.php |
| 770 | /vendor/doctrine/dbal/src/Types/BooleanType.php |
| 771 | /vendor/doctrine/dbal/src/Types/DateType.php |
| 772 | /vendor/doctrine/dbal/src/Types/DateImmutableType.php |
| 773 | /vendor/doctrine/dbal/src/Types/DateIntervalType.php |
| 774 | /vendor/doctrine/dbal/src/Types/DateTimeType.php |
| 775 | /vendor/doctrine/dbal/src/Types/PhpDateTimeMappingType.php |
| 776 | /vendor/doctrine/dbal/src/Types/DateTimeImmutableType.php |
| 777 | /vendor/doctrine/dbal/src/Types/DateTimeTzType.php |
| 778 | /vendor/doctrine/dbal/src/Types/DateTimeTzImmutableType.php |
| 779 | /vendor/doctrine/dbal/src/Types/DecimalType.php |
| 780 | /vendor/doctrine/dbal/src/Types/FloatType.php |
| 781 | /vendor/doctrine/dbal/src/Types/GuidType.php |
| 782 | /vendor/doctrine/dbal/src/Types/IntegerType.php |
| 783 | /vendor/doctrine/dbal/src/Types/JsonType.php |
| 784 | /vendor/doctrine/dbal/src/Types/ObjectType.php |
| 785 | /vendor/doctrine/dbal/src/Types/SimpleArrayType.php |
| 786 | /vendor/doctrine/dbal/src/Types/SmallIntType.php |
| 787 | /vendor/doctrine/dbal/src/Types/TextType.php |
| 788 | /vendor/doctrine/dbal/src/Types/TimeType.php |
| 789 | /vendor/doctrine/dbal/src/Types/TimeImmutableType.php |
| 790 | /vendor/doctrine/dbal/src/Types/TypeRegistry.php |
| 791 | /modules/ps_googleanalytics/ps_googleanalytics.php |
| 792 | /modules/ps_googleanalytics/classes/Hook/HookDisplayHeader.php |
| 793 | /modules/ps_googleanalytics/classes/Hook/HookInterface.php |
| 794 | /modules/psxmarketingwithgoogle/psxmarketingwithgoogle.php |
| 795 | /var/cache/dev/PsxmarketingwithgoogleFrontContainer.php |
| 796 | /modules/psxmarketingwithgoogle/classes/Adapter/ConfigurationAdapter.php |
| 797 | /modules/psxmarketingwithgoogle/classes/Factory/ContextFactory.php |
| 798 | /modules/psxmarketingwithgoogle/classes/config/Config.php |
| 799 | /modules/psxmarketingwithgoogle/classes/Handler/RemarketingHookHandler.php |
| 800 | /modules/psxmarketingwithgoogle/classes/Buffer/TemplateBuffer.php |
| 801 | /src/Core/Product/Search/ProductSearchQuery.php |
| 802 | /src/Core/Product/Search/SortOrder.php |
| 803 | /modules/ps_facetedsearch/ps_facetedsearch.php |
| 804 | /modules/ps_facetedsearch/src/HookDispatcher.php |
| 805 | /modules/ps_facetedsearch/src/Hook/Attribute.php |
| 806 | /modules/ps_facetedsearch/src/Hook/AbstractHook.php |
| 807 | /modules/ps_facetedsearch/src/Hook/AttributeGroup.php |
| 808 | /modules/ps_facetedsearch/src/Hook/Category.php |
| 809 | /modules/ps_facetedsearch/src/Hook/Configuration.php |
| 810 | /modules/ps_facetedsearch/src/Hook/Design.php |
| 811 | /modules/ps_facetedsearch/src/Hook/Feature.php |
| 812 | /modules/ps_facetedsearch/src/Form/Feature/FormModifier.php |
| 813 | /modules/ps_facetedsearch/src/Form/Feature/FormDataProvider.php |
| 814 | /modules/ps_facetedsearch/src/Hook/FeatureValue.php |
| 815 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormModifier.php |
| 816 | /modules/ps_facetedsearch/src/Form/FeatureValue/FormDataProvider.php |
| 817 | /modules/ps_facetedsearch/src/Hook/Product.php |
| 818 | /modules/ps_facetedsearch/src/Hook/ProductSearch.php |
| 819 | /modules/ps_facetedsearch/src/Hook/SpecificPrice.php |
| 820 | /modules/ps_facetedsearch/src/Filters/Provider.php |
| 821 | /modules/ps_facetedsearch/src/URLSerializer.php |
| 822 | /modules/ps_facetedsearch/src/Filters/DataAccessor.php |
| 823 | /modules/ps_facetedsearch/src/Product/SearchProvider.php |
| 824 | /src/Core/Product/Search/FacetsRendererInterface.php |
| 825 | /src/Core/Product/Search/ProductSearchProviderInterface.php |
| 826 | /modules/ps_facetedsearch/src/Filters/Converter.php |
| 827 | /modules/ps_facetedsearch/src/Product/SearchFactory.php |
| 828 | /src/Core/Product/Search/ProductSearchResult.php |
| 829 | /modules/ps_facetedsearch/src/Definition/Availability.php |
| 830 | /classes/Combination.php |
| 831 | /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/1/1/6/classic/9c/bf/04/9cbf04ab55718c7bff003722fc883d7d9e0b17b0.ps_brandlistviewstemplateshookps_brandlist.tpl.php |
| 929 | /var/cache/dev/smarty/compile/classic/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.ps_facetedsearchps_facetedsearch.tpl.php |
| 930 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/a5/1a/cb/a51acb3f90d8446b5b2c090c9607a177b24f5f42_2.file.category-header.tpl.php |
| 931 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/d6/ef/f3/d6eff3a0d405786816408d8821e813a37822cb34_2.file.products-top.tpl.php |
| 932 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/9f/36/04/9f360457127a5fb30400b1f5a5417ad0c17a679a_2.file.sort-orders.tpl.php |
| 933 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/34/9e/8b/349e8bbc865dd6cab3c4fa095935c23d898af6c7_2.file.products.tpl.php |
| 934 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/4a/ab/30/4aab30449ad45f88faf385787cc63afb456ed2ad_2.file.productlist.tpl.php |
| 935 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_capture.php |
| 936 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ad/17/84/ad17846cda7a00c523f85c365f5ce311b5e246e4_2.file.product.tpl.php |
| 937 | /modules/productcomments/src/Repository/ProductCommentRepository.php |
| 938 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepository.php |
| 939 | /vendor/doctrine/doctrine-bundle/Repository/ServiceEntityRepositoryInterface.php |
| 940 | /vendor/doctrine/doctrine-bundle/Registry.php |
| 941 | /vendor/symfony/doctrine-bridge/ManagerRegistry.php |
| 942 | /vendor/doctrine/persistence/src/Persistence/AbstractManagerRegistry.php |
| 943 | /vendor/doctrine/persistence/src/Persistence/ManagerRegistry.php |
| 944 | /vendor/doctrine/persistence/src/Persistence/ConnectionRegistry.php |
| 945 | /modules/productcomments/src/Entity/ProductComment.php |
| 946 | /vendor/doctrine/orm/src/Proxy/Proxy.php |
| 947 | /vendor/doctrine/common/src/Proxy/Proxy.php |
| 948 | /vendor/doctrine/persistence/src/Persistence/Proxy.php |
| 949 | /vendor/doctrine/orm/src/Proxy/InternalProxy.php |
| 950 | /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriverChain.php |
| 951 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/ImplicitlyIgnoredAnnotationNames.php |
| 952 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/IgnoreAnnotation.php |
| 953 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/PhpParser.php |
| 954 | /src/PrestaShopBundle/Service/Database/DoctrineNamingStrategy.php |
| 955 | /vendor/doctrine/orm/src/Mapping/UnderscoreNamingStrategy.php |
| 956 | /vendor/doctrine/orm/src/Mapping/NamingStrategy.php |
| 957 | /vendor/doctrine/orm/src/Mapping/DefaultQuoteStrategy.php |
| 958 | /vendor/doctrine/orm/src/Internal/SQLResultCasing.php |
| 959 | /vendor/doctrine/orm/src/Mapping/QuoteStrategy.php |
| 960 | /vendor/doctrine/doctrine-bundle/Mapping/ContainerEntityListenerResolver.php |
| 961 | /vendor/doctrine/doctrine-bundle/Mapping/EntityListenerServiceResolver.php |
| 962 | /vendor/doctrine/orm/src/Mapping/EntityListenerResolver.php |
| 963 | /vendor/doctrine/doctrine-bundle/Repository/ContainerRepositoryFactory.php |
| 964 | /vendor/doctrine/orm/src/Repository/RepositoryFactory.php |
| 965 | /vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php |
| 966 | /vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php |
| 967 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadataFactory.php |
| 968 | /vendor/doctrine/orm/src/Mapping/ClassMetadata.php |
| 969 | /vendor/doctrine/orm/src/Mapping/ClassMetadataInfo.php |
| 970 | /vendor/doctrine/persistence/src/Persistence/Mapping/ClassMetadata.php |
| 971 | /vendor/doctrine/orm/src/Proxy/DefaultProxyClassNameResolver.php |
| 972 | /vendor/doctrine/persistence/src/Persistence/Mapping/ProxyClassNameResolver.php |
| 973 | /vendor/doctrine/orm/src/UnitOfWork.php |
| 974 | /vendor/doctrine/persistence/src/Persistence/PropertyChangedListener.php |
| 975 | /vendor/doctrine/orm/src/Event/ListenersInvoker.php |
| 976 | /vendor/doctrine/orm/src/Utility/IdentifierFlattener.php |
| 977 | /vendor/doctrine/orm/src/Internal/HydrationCompleteHandler.php |
| 978 | /vendor/doctrine/orm/src/Mapping/Reflection/ReflectionPropertiesGetter.php |
| 979 | /vendor/doctrine/persistence/src/Persistence/Mapping/RuntimeReflectionService.php |
| 980 | /vendor/doctrine/persistence/src/Persistence/Mapping/ReflectionService.php |
| 981 | /vendor/doctrine/orm/src/Proxy/ProxyFactory.php |
| 982 | /vendor/doctrine/common/src/Proxy/AbstractProxyFactory.php |
| 983 | /vendor/doctrine/common/src/Proxy/ProxyGenerator.php |
| 984 | /vendor/doctrine/doctrine-bundle/ManagerConfigurator.php |
| 985 | /vendor/doctrine/lexer/src/Token.php |
| 986 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php |
| 987 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/TokenParser.php |
| 988 | /vendor/doctrine/orm/src/Mapping/Table.php |
| 989 | /vendor/doctrine/orm/src/Mapping/MappingAttribute.php |
| 990 | /vendor/doctrine/orm/src/Mapping/Annotation.php |
| 991 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Enum.php |
| 992 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attribute.php |
| 993 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Attributes.php |
| 994 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/NamedArgumentConstructor.php |
| 995 | /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/NamedArgumentConstructorAnnotation.php |
| 996 | /vendor/doctrine/orm/src/Mapping/Entity.php |
| 997 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/Instantiator.php |
| 998 | /vendor/doctrine/instantiator/src/Doctrine/Instantiator/InstantiatorInterface.php |
| 999 | /vendor/doctrine/orm/src/Mapping/DefaultTypedFieldMapper.php |
| 1000 | /vendor/doctrine/orm/src/Mapping/TypedFieldMapper.php |
| 1001 | /vendor/doctrine/orm/src/Mapping/Id.php |
| 1002 | /vendor/doctrine/orm/src/Mapping/Column.php |
| 1003 | /vendor/doctrine/orm/src/Mapping/GeneratedValue.php |
| 1004 | /vendor/doctrine/orm/src/Id/IdentityGenerator.php |
| 1005 | /vendor/doctrine/orm/src/Id/AbstractIdGenerator.php |
| 1006 | /vendor/doctrine/orm/src/Events.php |
| 1007 | /vendor/doctrine/persistence/src/Persistence/Reflection/RuntimeReflectionProperty.php |
| 1008 | /vendor/doctrine/dbal/src/Query/QueryBuilder.php |
| 1009 | /vendor/doctrine/dbal/src/Query/Expression/CompositeExpression.php |
| 1010 | /vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php |
| 1011 | /vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php |
| 1012 | /vendor/doctrine/dbal/src/Query/SelectQuery.php |
| 1013 | /vendor/doctrine/dbal/src/Query/Limit.php |
| 1014 | /vendor/doctrine/dbal/src/SQL/Parser.php |
| 1015 | /vendor/doctrine/dbal/src/ExpandArrayParameters.php |
| 1016 | /vendor/doctrine/dbal/src/SQL/Parser/Visitor.php |
| 1017 | /vendor/doctrine/dbal/src/Driver/PDO/Statement.php |
| 1018 | /vendor/doctrine/dbal/src/Driver/Statement.php |
| 1019 | /vendor/doctrine/dbal/src/Driver/PDO/ParameterTypeMap.php |
| 1020 | /vendor/doctrine/dbal/src/Driver/PDO/Result.php |
| 1021 | /vendor/doctrine/dbal/src/Driver/Result.php |
| 1022 | /vendor/doctrine/dbal/src/Result.php |
| 1023 | /vendor/doctrine/dbal/src/FetchMode.php |
| 1024 | /var/cache/dev/smarty/compile/classic/e9/e4/d0/e9e4d0b935584380ea8beb3f467908e1cd2486f5_2.module.productcommentsviewstemplateshookproductlistreviews.tpl.php |
| 1025 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/bf/28/8d/bf288d1685d28b027337584dcfe13cc294fd57c5_2.file.product-flags.tpl.php |
| 1026 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/26/dd/71/26dd71b5d902204dceb16591f45cf7ea05b3b33d_2.file.pagination.tpl.php |
| 1027 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/ee/f7/e2/eef7e20ffb2913bfe62b0610181c29528d8e4771_2.file.products-bottom.tpl.php |
| 1028 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/39/09/df/3909df7b52439b05e063d2f877f044830bba50c1_2.file.category-footer.tpl.php |
| 1029 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/16/be/17/16be17aaab473eb4ca068d81e52aab7efa157782_2.file.footer.tpl.php |
| 1030 | /var/cache/dev/smarty/compile/classic/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef_2.module.ps_emailsubscriptionviewstemplateshookps_emailsubscription.tpl.php |
| 1031 | /var/cache/dev/smarty/cache/ps_socialfollow/1/1/1/1/1/6/classic/39/00/03/390003729d747f46c5a6fde1e583b35503112607.ps_socialfollowps_socialfollow.tpl.php |
| 1032 | /modules/ps_linklist/ps_linklist.php |
| 1033 | /var/cache/dev/translations/catalogue.es-ES.NXhscRe.php |
| 1034 | /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php |
| 1035 | /modules/ps_linklist/src/Filter/LinkFilter.php |
| 1036 | /modules/ps_linklist/src/Filter/BestSalesRouteFilter.php |
| 1037 | /modules/ps_linklist/src/Filter/RouteFilterInterface.php |
| 1038 | /modules/ps_linklist/src/LegacyLinkBlockRepository.php |
| 1039 | /var/cache/dev/smarty/cache/ps_linklist/displayFooter/1/1/1/1/1/6/classic/7f/31/9c/7f319c4e7a8a11d4f3731c5d7e5d1fbfcd5233e9.ps_linklistviewstemplateshooklinkblock.tpl.php |
| 1040 | /modules/ps_customeraccountlinks/ps_customeraccountlinks.php |
| 1041 | /var/cache/dev/smarty/cache/ps_customeraccountlinks/1/1/1/1/1/6/classic/47/f3/f6/47f3f62b55c89d7584ea8d8da165da39273fcdd0.ps_customeraccountlinksps_customeraccountlinks.tpl.php |
| 1042 | /var/cache/dev/smarty/compile/classic/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d_2.module.ps_contactinfops_contactinfo.tpl.php |
| 1043 | /vendor/smarty/smarty/libs/plugins/function.mailto.php |
| 1044 | /var/cache/dev/smarty/compile/classic/53/1f/f5/531ff5fadbab34ae9adf28c596f08da4ca8fffe0_2.module.blockwishlistviewstemplateshookdisplayHeader.tpl.php |
| 1045 | /var/cache/dev/smarty/compile/classic/b3/9f/fe/b39ffe0e9a6e5e655319605fb4fac018757bed47_2.module.blockwishlistviewstemplatescomponentsmodalsaddtowishlist.tpl.php |
| 1046 | /var/cache/dev/smarty/compile/classic/f9/93/73/f9937302c902c18a7e92f61a7bb91ac32c58d2fe_2.module.blockwishlistviewstemplatescomponentsmodalsdelete.tpl.php |
| 1047 | /var/cache/dev/smarty/compile/classic/d8/d0/86/d8d086f3098974d41bc92b06c33cf9e584313501_2.module.blockwishlistviewstemplatescomponentsmodalscreate.tpl.php |
| 1048 | /var/cache/dev/smarty/compile/classic/99/ff/6f/99ff6f99ecd074931a71deddfe65081482db8401_2.module.blockwishlistviewstemplatescomponentsmodalslogin.tpl.php |
| 1049 | /var/cache/dev/smarty/compile/classic/a6/cf/26/a6cf26c62a3d814aa3a70f19a62034bfdce54c8a_2.module.blockwishlistviewstemplatescomponentstoast.tpl.php |
| 1050 | /modules/ps_facebook/classes/Handler/MessengerHandler.php |
| 1051 | /var/cache/dev/smarty/compile/classiclayouts_layout_left_column_tpl/11/93/51/119351d12df118629c98e937ac45847552344d0d_2.file.password-policy-template.tpl.php |
| 1052 | /modules/statsdata/statsdata.php |
| 1053 | /classes/Connection.php |
| 1054 | /classes/ConnectionsSource.php |
| 1055 | /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php |
| 1056 | /modules/ps_googleanalytics/classes/Handler/GanalyticsJsHandler.php |
| 1057 | /modules/ps_googleanalytics/classes/Handler/GanalyticsDataHandler.php |
| 1058 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php |
| 1059 | /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php |
| 1060 | /modules/ps_googleanalytics/classes/GoogleAnalyticsTools.php |
