| Load time | 687 ms - Unicorn powered webserver! |
| Querying time | 224 ms |
| Queries | 260 |
| Memory peak usage | 10.9 Mb |
| Included files | 356 files - 6.38 Mb |
| thirty bees cache | 1.62 Mb |
| Global vars | 1.52 Mb |
| thirty bees version | 1.4.0 |
| PrestaShop (emulated) version | 1.6.1.999 |
| PHP version | 7.0.33 (OK) |
| MySQL version | 11.8.3-MariaDB-deb12 (OK) |
| Memory limit | 4096M |
| Max execution time | 30s |
| Smarty cache | enabled |
| Smarty Compilation | auto |
| Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
|---|---|---|---|---|
| config | 258 ms | 258 ms | 2.89 Mb | 4.29 Mb |
| __construct | 0 ms | 258 ms | - Mb | 4.29 Mb |
| init | 64 ms | 322 ms | 0.95 Mb | 5.62 Mb |
| checkAccess | 0 ms | 322 ms | - Mb | 5.62 Mb |
| setMedia | 21 ms | 342 ms | 0.44 Mb | 5.62 Mb |
| postProcess | 63 ms | 406 ms | 1.57 Mb | 6.41 Mb |
| initHeader | 0 ms | 406 ms | - Mb | 6.41 Mb |
| initContent | 263 ms | 669 ms | 4.43 Mb | 10.88 Mb |
| initFooter | 19 ms | 687 ms | 0.15 Mb | 10.88 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| __construct | 154 ms | 2.00 Mb |
| hooktop | 107 ms | 2.00 Mb |
| hookheader | 14 ms | 2.00 Mb |
| hookfooter | 12 ms | - Mb |
| hookdisplayHeader | 6 ms | - Mb |
| hookdisplayTop | 6 ms | - Mb |
| hookactionCartSave | 3 ms | - Mb |
| hookdisplayFooter | 2 ms | - Mb |
| hookactionFrontControllerSetMedia | 0 ms | - Mb |
| hookDisplayOverrideTemplate | - ms | - Mb |
| 10 hooks | 303 ms | 6.00 Mb |
| Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|
SELECT SQL_NO_CACHE `id_product` FROM `ps_product_lang` WHERE (`link_rewrite` = 'cart') AND (`id_lang` = 2) AND (`id_shop` = 1) |
109.2 | 124037 | /classes/Dispatcher.php:1427 | ||
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) INNER JOIN `ps_manufacturer_lang` ml ON m.`id_manufacturer` = ml.`id_manufacturer` WHERE (ml.`id_lang` = 2) AND (m.`active` = 1) GROUP BY m.`id_manufacturer` ORDER BY m.`name` ASC |
14.4 | 1294 | Yes | Yes | /classes/Manufacturer.php:185 |
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_lang` WHERE (`link_rewrite` = 'cart') AND (`id_lang` = 2) AND (`id_shop` = 1) |
4.7 | 9732 | /classes/Dispatcher.php:1483 | ||
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop` FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` `cl` ON c.`id_configuration` = cl.`id_configuration` |
3.2 | 647 | /classes/Configuration.php:446 | ||
SELECT SQL_NO_CACHE cl.*, c.*, cl.`name` AS `country`, z.`name` AS `zone` FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1) LEFT JOIN `ps_country_lang` `cl` ON c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2 LEFT JOIN `ps_zone` `z` ON z.`id_zone` = c.`id_zone` ORDER BY cl.`name` ASC |
1.9 | 244 | Yes | /classes/Country.php:603 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 2785 AND c.nright >= 2786) ORDER BY c.nleft |
1.8 | 3551 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 4475 AND c.nright >= 4476) ORDER BY c.nleft |
1.8 | 3551 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") 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.7 | 260 | Yes | Yes | /classes/Hook.php:588 |
SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` AS m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.6 | 356 | /classes/Hook.php:207 | ||
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, 0) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 2 WHERE (cp.`id_cart` = 8785) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC |
1.5 | 6 | /classes/Cart.php:400 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 2785 AND c.nright >= 2786) ORDER BY c.nleft |
1.5 | 3551 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE hs.`id_htmlbanners10_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`, hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image` FROM ps_htmlbanners10 hs LEFT JOIN ps_htmlbanners10_slides hss ON (hs.id_htmlbanners10_slides = hss.id_htmlbanners10_slides) LEFT JOIN ps_htmlbanners10_slides_lang hssl ON (hss.id_htmlbanners10_slides = hssl.id_htmlbanners10_slides) WHERE id_shop = 1 AND hssl.id_lang = 2 AND hss.`active` = 1 ORDER BY hss.position |
1.5 | 1 | Yes | /modules/htmlbanners10/htmlbanners10.php:782 | |
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, 0) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 2 WHERE (cp.`id_cart` = 8785) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC |
1.5 | 6 | /classes/Cart.php:400 | ||
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, 0) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 2 WHERE (cp.`id_cart` = 8785) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC |
1.4 | 6 | /classes/Cart.php:400 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 4475 AND c.nright >= 4476) ORDER BY c.nleft |
1.4 | 3551 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, 0) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 2 WHERE (cp.`id_cart` = 8785) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC |
1.4 | 6 | /classes/Cart.php:400 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 4581 AND c.nright >= 4582) ORDER BY c.nleft |
1.3 | 3551 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 6183 AND c.nright >= 6184) ORDER BY c.nleft |
1.3 | 493 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 4581 AND c.nright >= 4582) ORDER BY c.nleft |
1.3 | 3551 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 6183 AND c.nright >= 6184) ORDER BY c.nleft |
1.3 | 493 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 2 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC |
1.2 | 1 | Yes | Yes | /classes/Supplier.php:168 |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 6201 AND c.nright >= 6202) ORDER BY c.nleft |
1.2 | 484 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 6513 AND c.nright >= 6514) ORDER BY c.nleft |
1.1 | 328 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 6513 AND c.nright >= 6514) ORDER BY c.nleft |
1 | 328 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` AS name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name |
1 | 0 | /classes/Hook.php:731 | ||
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC |
0.9 | 312 | Yes | /classes/Country.php:614 | |
SELECT SQL_NO_CACHE m.`page`, ml.`url_rewrite`, ml.`id_lang` FROM `ps_meta` m LEFT JOIN `ps_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta` AND ml.id_shop = 1 ORDER BY LENGTH(ml.`url_rewrite`) DESC |
0.9 | 153 | Yes | /classes/Dispatcher.php:623 | |
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 2 AND cl.id_shop = 1 WHERE (c.nleft <= 6201 AND c.nright >= 6202) ORDER BY c.nleft |
0.8 | 484 | Yes | /classes/Product.php:7940 | |
SELECT SQL_NO_CACHE hs.`id_htmlbanners5_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`, hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image` FROM ps_htmlbanners5 hs LEFT JOIN ps_htmlbanners5_slides hss ON (hs.id_htmlbanners5_slides = hss.id_htmlbanners5_slides) LEFT JOIN ps_htmlbanners5_slides_lang hssl ON (hss.id_htmlbanners5_slides = hssl.id_htmlbanners5_slides) WHERE id_shop = 1 AND hssl.id_lang = 2 AND hss.`active` = 1 ORDER BY hss.position |
0.8 | 4 | Yes | /modules/htmlbanners5/htmlbanners5.php:809 | |
SELECT SQL_NO_CACHE * FROM `ps_cart` a WHERE (a.`id_cart` = 8785) LIMIT 1 |
0.7 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE hs.`id_htmlbanners11_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`, hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`category`, hssl.`description`, hssl.`image` FROM ps_htmlbanners11 hs LEFT JOIN ps_htmlbanners11_slides hss ON (hs.id_htmlbanners11_slides = hss.id_htmlbanners11_slides) LEFT JOIN ps_htmlbanners11_slides_lang hssl ON (hss.id_htmlbanners11_slides = hssl.id_htmlbanners11_slides) WHERE id_shop = 1 AND hssl.id_lang = 2 AND hss.`active` = 1 ORDER BY hss.position |
0.7 | 1 | Yes | /modules/htmlbanners11/htmlbanners11.php:767 | |
SELECT SQL_NO_CACHE b.content, bh.hook_name FROM ps_tbhtmlblock_lang b LEFT JOIN ps_tbhtmlblock_hook bh ON (bh.id_block = b.id_block) LEFT JOIN ps_tbhtmlblock o ON (o.id_block = b.id_block) WHERE id_lang = 2 AND o.active = 1 GROUP BY b.id_block ORDER BY bh.hook_name, bh.position |
0.7 | 1 | Yes | Yes | /modules/tbhtmlblock/tbhtmlblock.php:292 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` = 0) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.6 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE hs.`id_htmlbanners4_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`, hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image` FROM ps_htmlbanners4 hs LEFT JOIN ps_htmlbanners4_slides hss ON (hs.id_htmlbanners4_slides = hss.id_htmlbanners4_slides) LEFT JOIN ps_htmlbanners4_slides_lang hssl ON (hss.id_htmlbanners4_slides = hssl.id_htmlbanners4_slides) WHERE id_shop = 1 AND hssl.id_lang = 2 AND hss.`active` = 1 ORDER BY hss.position |
0.6 | 1 | Yes | /modules/htmlbanners4/htmlbanners4.php:611 | |
SELECT SQL_NO_CACHE c.*, cl.`delay`, cl.`display_name` FROM `ps_carrier` c LEFT JOIN `ps_carrier_lang` `cl` ON c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 2 AND cl.id_shop = 1 LEFT JOIN `ps_carrier_zone` `cz` ON cz.`id_carrier` = c.`id_carrier` INNER JOIN ps_carrier_shop carrier_shop ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1) LEFT JOIN `ps_zone` `z` ON z.`id_zone` = 1 WHERE (c.`deleted` = 0) AND (cz.`id_zone` = 1) AND (z.`active` = 1) AND (c.`active` = 1) AND (EXISTS (SELECT 1 FROM ps_carrier_group WHERE ps_carrier_group.id_carrier = c.id_carrier AND id_group IN (1))) AND (c.`is_module` = 0 OR c.`need_range` = 1) GROUP BY c.`id_carrier` ORDER BY c.`position` ASC |
0.6 | 2 | Yes | Yes | /classes/Carrier.php:942 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 86)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.6 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 66151) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1 |
0.5 | 71 | /classes/module/Module.php:214 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 86)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.5 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 66304) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` = 0) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.5 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE (`deleted` = 0) ORDER BY `name` ASC |
0.5 | 1 | Yes | /classes/Currency.php:360 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` = 0) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.5 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 86
AND tr.`id_tax_rules_group` = 1
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.5 | 1 | /classes/tax/TaxRulesTaxManager.php:129 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 66151) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 86)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66151 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66151 |
0.4 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 66304) AND (b.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 65432) AND (b.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`) FROM `ps_lang` l INNER JOIN `ps_lang_shop` ls ON ls.`id_lang` = l.`id_lang` WHERE (ls.`id_shop` = 1) AND (l.`active` = 1) LIMIT 1 |
0.4 | 3 | /classes/Language.php:393 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 65432) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE IFNULL(`left_column`, `default_left_column`) AS `left_column`, IFNULL(`right_column`, `default_right_column`) AS `right_column` FROM `ps_theme` t LEFT JOIN `ps_theme_meta` `tm` ON t.`id_theme` = tm.`id_theme` LEFT JOIN `ps_meta` `m` ON m.`id_meta` = tm.`id_meta` WHERE (t.`id_theme` = 4) AND (m.`page` = 'cart') LIMIT 1 |
0.4 | 1 | /classes/Theme.php:396 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 86)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 86)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` = 0) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 27904) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier` c INNER JOIN `ps_carrier_lang` cl ON cl.`id_carrier` = c.`id_carrier` WHERE (c.`id_reference` = 3) AND (c.`deleted` = 0) AND (cl.`id_shop` = 1) ORDER BY c.`id_carrier` DESC |
0.4 | 21 | Yes | /classes/Carrier.php:561 | |
SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 2 AND id_shop = 1 LIMIT 1 |
0.4 | 1 | /classes/ObjectModel.php:1695 | ||
SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` `w` ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 1) AND (8.36 >= w.`delimiter1`) AND (8.36 < w.`delimiter2`) AND (d.`id_carrier` = 6 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter1` ASC LIMIT 1 |
0.4 | 1 | Yes | /classes/Carrier.php:1398 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 27904) AND (b.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.4 | 647 | /classes/shop/Shop.php:1304 | ||
SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 1) AND (d.`id_carrier` = 6 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter2` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/Carrier.php:1005 | |
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 FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_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` = 27904) |
0.4 | 1 | /classes/Product.php:862 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 66304) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` = 0) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 86)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE hs.`id_htmlbanners6_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`, hssl.`customclass`, hssl.`image` FROM ps_htmlbanners6 hs LEFT JOIN ps_htmlbanners6_slides hss ON (hs.id_htmlbanners6_slides = hss.id_htmlbanners6_slides) LEFT JOIN ps_htmlbanners6_slides_lang hssl ON (hss.id_htmlbanners6_slides = hssl.id_htmlbanners6_slides) WHERE id_shop = 1 AND hssl.id_lang = 2 AND hss.`active` = 1 ORDER BY hss.position |
0.4 | 10 | Yes | /modules/htmlbanners6/htmlbanners6.php:680 | |
SELECT SQL_NO_CACHE `name` FROM `ps_image_type` |
0.4 | 10 | /classes/ImageType.php:212 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT c.`id_currency`) FROM `ps_currency` c LEFT JOIN `ps_currency_shop` `cs` ON cs.`id_currency` = c.`id_currency` WHERE (cs.`id_shop` = 1) AND (c.`active` = 1) LIMIT 1 |
0.4 | 1 | /classes/Currency.php:490 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier` c INNER JOIN `ps_carrier_lang` cl ON cl.`id_carrier` = c.`id_carrier` WHERE (c.`id_reference` = 3) AND (c.`deleted` = 0) AND (cl.`id_shop` = 1) ORDER BY c.`id_carrier` DESC |
0.4 | 21 | Yes | /classes/Carrier.php:561 | |
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65432 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65432 |
0.4 | 0 | /override/classes/Product.php:139 | ||
UPDATE `ps_cart` SET `id_cart` = '8785',`id_shop_group` = '1',`id_shop` = '1',`id_carrier` = '0',`delivery_option` = '',`id_lang` = '2',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '161074',`secure_key` = '',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`allow_seperated_package` = '0',`date_add` = '2025-11-11 14:12:56',`date_upd` = '2025-11-11 14:13:00' WHERE `id_cart` = 8785 |
0.3 | 1 | /classes/ObjectModel.php:811 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66304 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66304 |
0.3 | 0 | /override/classes/Product.php:139 | ||
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 FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_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` = 66304) |
0.3 | 1 | /classes/Product.php:862 | ||
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 FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_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` = 66151) |
0.3 | 1 | /classes/Product.php:862 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 86)) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.3 | 1 | Yes | /classes/SpecificPrice.php:254 | |
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_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 = 66304 LIMIT 1 |
0.3 | 1 | /classes/Product.php:1072 | ||
SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE (`id_group` = 1) |
0.3 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
0.3 | 11 | /classes/SpecificPrice.php:388 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` = 0) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-11 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.3 | 1 | Yes | /classes/SpecificPrice.php:254 | |
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 FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_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` = 65432) |
0.3 | 1 | /classes/Product.php:862 | ||
SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 86) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66304 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66304 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 27904 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 27904 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65242 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65242 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` `ls` ON l.`id_lang` = ls.`id_lang` |
0.3 | 3 | /classes/Language.php:176 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 11812 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 11812 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE count(distinct id_address_delivery) FROM `ps_cart_product` cp WHERE (id_cart = 8785) LIMIT 1 |
0.3 | 6 | /classes/Cart.php:2219 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 11812) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66151 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66151 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE * FROM `ps_meta` m LEFT JOIN `ps_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta` WHERE (m.`page` = 'cart' OR m.`page` = 'cart') AND (ml.`id_lang` = 2 AND ml.id_shop = 1 ) LIMIT 1 |
0.3 | 1 | /classes/Meta.php:406 | ||
SELECT SQL_NO_CACHE * FROM `ps_themeconfigurator` WHERE (`id_shop` = 1) AND (`id_lang` = 2) AND (`hook` = 'footer') AND (`active` = 1) ORDER BY `item_order` ASC |
0.3 | 3 | Yes | /modules/themeconfigurator/themeconfigurator.php:1078 | |
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `ps_feature_product` fp LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = 66151 |
0.3 | 1 | /classes/Product.php:7015 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 3094 LIMIT 1 |
0.3 | 0 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 86
AND tr.`id_tax_rules_group` = 0
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.3 | 0 | /classes/tax/TaxRulesTaxManager.php:129 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="5bd4080c91e7df4b3c85646a2da3a1a8") AND (cache_id="blockcontactinfos|1|1|1|2|86") AND (compile_id="") LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:464 | ||
SELECT SQL_NO_CACHE `domain`, `domain_ssl` FROM `ps_shop_url` WHERE (`main` = 1) AND (`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /classes/shop/ShopUrl.php:253 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65242 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65242 |
0.3 | 0 | /override/classes/Product.php:139 | ||
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 `ps_shop_group` gs LEFT JOIN `ps_shop` `s` ON s.`id_shop_group` = gs.`id_shop_group` LEFT JOIN `ps_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.3 | 1 | Yes | /classes/shop/Shop.php:753 | |
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE (`id_cart` = 8785) LIMIT 1 |
0.3 | 6 | /classes/Cart.php:3059 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 27904 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 27904 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66304 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66304 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 11812) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 65242) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 66304 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( "2025-11-11 00:00:00", INTERVAL 20 DAY ) ) > 0 |
0.3 | 1 | /classes/Product.php:558 | ||
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `ps_feature_product` fp LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = 65242 |
0.3 | 1 | /classes/Product.php:7015 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE (`id_shop` IN (1)) |
0.3 | 8 | /classes/module/Module.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE (`deleted` = 0) AND (c.`active` = 1) ORDER BY `name` ASC |
0.3 | 1 | Yes | /classes/Currency.php:360 | |
SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66151 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66151 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65432 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65432 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE id_feature, id_product, id_feature_value FROM `ps_feature_product` WHERE `id_product` IN (66151,65432,27904,65242) |
0.3 | 1 | /classes/Product.php:2733 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66304 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66304 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 2240 LIMIT 1 |
0.3 | 1 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE (`id_product` = 11812) AND (`id_shop` = 1) |
0.3 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 2) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65242 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65242 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65432 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65432 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 66304) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.3 | 1 | /classes/stock/StockAvailable.php:462 | ||
SELECT SQL_NO_CACHE SUM((p.`weight` + pa.`weight`) * cp.`quantity`) AS `nb` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON cp.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute` `pa` ON cp.`id_product_attribute` = pa.`id_product_attribute` WHERE (cp.`id_product_attribute` IS NOT NULL) AND (cp.`id_product_attribute` != 0) AND (cp.`id_cart` = 8785) LIMIT 1 |
0.3 | 6 | /classes/Cart.php:2309 | ||
SELECT SQL_NO_CACHE t.`id_lang`, t.`name` FROM `ps_tag` t LEFT JOIN `ps_product_tag` `pt` ON pt.`id_tag` = t.`id_tag` WHERE (pt.`id_product` = 66304) |
0.3 | 1 | /classes/Tag.php:331 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66304 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66304 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier` a LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1 WHERE (a.`id_carrier` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66304 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66304 |
0.3 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1 WHERE (pc.`id_product` = 65432) AND (pc.`id_shop` = 1) |
0.3 | 1 | /classes/Carrier.php:638 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66151 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66151 |
0.3 | 0 | /override/classes/Product.php:139 | ||
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 FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_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` = 65242) |
0.3 | 1 | /classes/Product.php:862 | ||
SELECT SQL_NO_CACHE id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1 WHERE (pc.`id_product` = 66151) AND (pc.`id_shop` = 1) |
0.3 | 1 | /classes/Carrier.php:638 | ||
SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM `ps_shop` s LEFT JOIN `ps_shop_url` `su` ON s.`id_shop` = su.`id_shop` LEFT JOIN `ps_theme` `t` ON t.`id_theme` = s.`id_theme` WHERE (s.`id_shop` = 1) AND (s.`active` = 1) AND (s.`deleted` = 0) AND (su.`main` = 1) LIMIT 1 |
0.2 | 1 | /classes/shop/Shop.php:179 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier` a LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1 LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1 WHERE (a.`id_carrier` = 1) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 1395 LIMIT 1 |
0.2 | 1 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="464a9a36a0645b3a54c55229b618f18c") AND (cache_id="blockpaymentlogo|1|1|1|2|86") AND (compile_id="") LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:464 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier` a LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1 LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1 WHERE (a.`id_carrier` = 6) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_product_attribute` pa INNER JOIN ps_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` = 66304) LIMIT 1 |
0.2 | 1 | /classes/Product.php:5863 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 27904 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 27904 |
0.2 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE `id_module`, `name` FROM `ps_module` |
0.2 | 71 | /classes/module/Module.php:1754 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE (`id_product` = 27904) AND (`id_shop` = 1) |
0.2 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
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 FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_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` = 11812) |
0.2 | 1 | /classes/Product.php:862 | ||
SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 4) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1 WHERE (pc.`id_product` = 65242) AND (pc.`id_shop` = 1) |
0.2 | 1 | /classes/Carrier.php:638 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = 27904) ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.2 | 0 | /classes/SpecificPrice.php:480 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="72c877bed0b8dce360b8cb56e54fa337") AND (cache_id="blockmyaccountfooter|1|1|1|2|86") AND (compile_id="") LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:464 | ||
SELECT SQL_NO_CACHE s.`id_shop`, CONCAT(su.`physical_uri`, su.`virtual_uri`) AS `uri`, su.`domain`, su.`main` FROM `ps_shop_url` su LEFT JOIN `ps_shop` `s` ON s.`id_shop` = su.`id_shop` WHERE (su.domain = 'cybermarket.ee' OR su.domain_ssl = 'cybermarket.ee') AND (s.`active` = 1) AND (s.`deleted` = 0) ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC |
0.2 | 1 | Yes | /classes/shop/Shop.php:353 | |
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 65432 AND `id_cart` = 8785 LIMIT 1 |
0.2 | 1 | /classes/Product.php:667 | ||
UPDATE `ps_cart` SET `id_cart` = '8785',`id_shop_group` = '1',`id_shop` = '1',`id_carrier` = '0',`delivery_option` = '',`id_lang` = '2',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '161074',`secure_key` = '',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`allow_seperated_package` = '0',`date_add` = '2025-11-11 14:12:56',`date_upd` = '2025-11-11 14:13:00' WHERE `id_cart` = 8785 |
0.2 | 1 | /classes/ObjectModel.php:811 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE (`id_product` = 66304) AND (`id_shop` = 1) |
0.2 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `ps_feature_product` fp LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = 65432 |
0.2 | 1 | /classes/Product.php:7015 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1 WHERE (pc.`id_product` = 11812) AND (pc.`id_shop` = 1) |
0.2 | 1 | /classes/Carrier.php:638 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 65242) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE (`iso_code` = 'et') LIMIT 1 |
0.2 | 1 | /classes/Language.php:691 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = 66151) ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.2 | 0 | /classes/SpecificPrice.php:480 | ||
SELECT SQL_NO_CACHE cp.`quantity` FROM `ps_cart_product` cp WHERE (cp.`id_product` = 66304) AND (cp.`id_product_attribute` = 0) AND (cp.`id_cart` = 8785) LIMIT 1 |
0.2 | 1 | /classes/Cart.php:3533 | ||
SELECT SQL_NO_CACHE out_of_stock FROM `ps_stock_available` WHERE (id_product = 66304) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:832 | ||
SELECT SQL_NO_CACHE ctg.`id_group` FROM `ps_category_product` cp INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = 66304 AND ctg.`id_group` = 1 LIMIT 1 |
0.2 | 2 | /classes/Product.php:6841 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 66151 AND `id_cart` = 8785 LIMIT 1 |
0.2 | 1 | /classes/Product.php:667 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 11812 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 11812 |
0.2 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="474a69f78a163a0ed295839444823472") AND (cache_id="htmlbanners6|1|1|1|2|86") AND (compile_id="") LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:464 | ||
INSERT INTO `ps_bankrefnumber` (`id_cart`, `bankrefnumber`) VALUES (8785, "RF718785") ON DUPLICATE KEY UPDATE `bankrefnumber` = "RF718785" |
0.2 | 1 | /modules/bankrefnumber/bankrefnumber.php:309 | ||
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` WHERE (`id_cart` = 8785) LIMIT 1 |
0.2 | 1 | /classes/Cart.php:2892 | ||
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE (`id_cart` = 8785) LIMIT 1 |
0.2 | 6 | /classes/Cart.php:3059 | ||
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 |
0.2 | 11 | /classes/SpecificPrice.php:398 | ||
SELECT SQL_NO_CACHE * FROM `ps_cart` a WHERE (a.`id_cart` = 8785) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 11812 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 11812 |
0.2 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_cart`) FROM `ps_specific_price` WHERE `id_cart` != 0 LIMIT 1 |
0.2 | 2 | /classes/SpecificPrice.php:388 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier` a LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1 WHERE (a.`id_carrier` = 6) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 65242 AND `id_cart` = 8785 LIMIT 1 |
0.2 | 1 | /classes/Product.php:667 | ||
SELECT SQL_NO_CACHE id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1 WHERE (pc.`id_product` = 27904) AND (pc.`id_shop` = 1) |
0.2 | 1 | /classes/Carrier.php:638 | ||
SELECT SQL_NO_CACHE stock.`out_of_stock`, IFNULL(stock.`quantity`, 0) AS `quantity` FROM `ps_product` p INNER JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (p.`id_product` = 66304) LIMIT 1 |
0.2 | 1 | /classes/Cart.php:3286 | ||
SELECT SQL_NO_CACHE SUM(p.`weight` * cp.`quantity`) AS `nb` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON cp.`id_product` = p.`id_product` WHERE (cp.`id_product_attribute` IS NULL OR cp.`id_product_attribute` = 0) AND (cp.`id_cart` = 8785) LIMIT 1 |
0.2 | 6 | /classes/Cart.php:2321 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 66304 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:1175 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 2240 LIMIT 1 |
0.2 | 0 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="df1ec426c39b272351fd12dd6d1ba2c5") AND (cache_id="htmlbanners4|1|1|1|2|86") AND (compile_id="") LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:464 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65432 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65432 |
0.2 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE * FROM `ps_cart_cart_rule` WHERE (`id_cart` = 8785) |
0.2 | 1 | /classes/Cart.php:1480 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier_lang` WHERE (`id_carrier` = 1) AND (`id_shop` = 1) |
0.2 | 21 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 66304 AND `id_cart` = 8785 LIMIT 1 |
0.2 | 1 | /classes/Product.php:667 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` |
0.2 | 86 | /classes/Hook.php:685 | ||
SELECT SQL_NO_CACHE `id_order` FROM `ps_orders` WHERE (`id_cart` = 8785 AND `id_shop` = 1 ) LIMIT 1 |
0.2 | 1 | /classes/order/Order.php:1414 | ||
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `ps_feature_product` fp LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = 66304 |
0.2 | 1 | /classes/Product.php:7015 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = 65242) AND (`id_group` = 1) LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:111 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE (`id_product` = 65432) AND (`id_shop` = 1) |
0.2 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 65242 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 65242 |
0.2 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="e9c3dc07fbfc6972eea91b9c9f7262ea") AND (cache_id="blocktopmenu|1|1|1|2|86|index") AND (compile_id="") LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:464 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = 1) AND (`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /classes/Carrier.php:342 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = 65242) ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.2 | 0 | /classes/SpecificPrice.php:480 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE (`id_tax` = 1) |
0.2 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 27904 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 27904 |
0.2 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `ps_feature_product` fp LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = 27904 |
0.2 | 1 | /classes/Product.php:7015 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 1395 LIMIT 1 |
0.2 | 0 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = 6) AND (`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /classes/Carrier.php:342 | ||
SELECT SQL_NO_CACHE depends_on_stock FROM `ps_stock_available` WHERE (id_product = 66304) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:803 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE (`id_product` = 66151) AND (`id_shop` = 1) |
0.2 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 86) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE * FROM `ps_carrier_lang` WHERE (`id_carrier` = 6) AND (`id_shop` = 1) |
0.2 | 21 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="97916ab939af07ea0acb2ecf4b7c5498") AND (cache_id="blockcms|2|1|1|1|2|86") AND (compile_id="") LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:464 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 65432 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:1175 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 3259 LIMIT 1 |
0.2 | 1 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps_required_field |
0.2 | 1 | /classes/ObjectModel.php:1596 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = 66304) AND (`id_group` = 1) LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:111 | ||
SELECT SQL_NO_CACHE name FROM `ps_manufacturer` WHERE (`id_manufacturer` = 717) AND (`active` = 1) LIMIT 1 |
0.2 | 1 | /classes/Manufacturer.php:261 | ||
SELECT SQL_NO_CACHE id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1 WHERE (pc.`id_product` = 66304) AND (pc.`id_shop` = 1) |
0.2 | 1 | /classes/Carrier.php:638 | ||
SELECT SQL_NO_CACHE `id_order` FROM `ps_orders` WHERE (`id_cart` = 8785 AND `id_shop` = 1 ) LIMIT 1 |
0.2 | 1 | /classes/order/Order.php:1414 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 11812 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 11812 |
0.2 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = 66151) AND (`id_group` = 1) LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:111 | ||
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = 3259) LIMIT 1 |
0.2 | 1 | /classes/Category.php:1017 | ||
SELECT SQL_NO_CACHE * FROM `ps_cart` a WHERE (a.`id_cart` = 8785) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:80 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.2 | 1 | /classes/ObjectModel.php:1695 | ||
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = 2293) LIMIT 1 |
0.2 | 1 | /classes/Category.php:1017 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.2 | 1 | /classes/ObjectModel.php:1695 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:260 | ||
INSERT INTO `ps_cart_product` (`id_product`, `id_product_attribute`, `id_cart`, `id_address_delivery`, `id_shop`, `quantity`, `date_add`) VALUES ('66304', '0', '8785', '0', '1', '1', '2025-11-11 14:13:00') |
0.2 | 1 | /classes/Cart.php:3313 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = 65432) ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.2 | 0 | /classes/SpecificPrice.php:480 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash="d87742c64a44cada59e2d0edb0d0b7c5") AND (cache_id="blocksearch-top|1|1|1|2|86") AND (compile_id="") LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:464 | ||
SELECT SQL_NO_CACHE a.`id_address` FROM `ps_address` a WHERE (a.`id_address` = 0) LIMIT 1 |
0.2 | 0 | /classes/Address.php:488 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = 65432) AND (`id_group` = 1) LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:111 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 66151) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:462 | ||
SELECT SQL_NO_CACHE p.`ean13` as `ean` FROM `ps_product` p WHERE p.`id_product` = 66304 UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e where e.`product_id` = 66304 |
0.1 | 0 | /override/classes/Product.php:139 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = 11812) ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 0 | /classes/SpecificPrice.php:480 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 1395 LIMIT 1 |
0.1 | 1 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE out_of_stock FROM `ps_stock_available` WHERE (id_product = 66304) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:832 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE (`id_module` = 47) AND (`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:1494 | ||
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 27904 AND `id_cart` = 8785 LIMIT 1 |
0.1 | 1 | /classes/Product.php:667 | ||
SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `ps_feature_product` fp LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = 11812 |
0.1 | 1 | /classes/Product.php:7015 | ||
SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 11812 AND `id_cart` = 8785 LIMIT 1 |
0.1 | 1 | /classes/Product.php:667 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 3094 LIMIT 1 |
0.1 | 1 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:199 | ||
SELECT SQL_NO_CACHE id_feature, id_product, id_feature_value FROM `ps_feature_product` WHERE `id_product` IN (66304) |
0.1 | 1 | /classes/Product.php:2733 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE (`from` BETWEEN '2025-11-11 00:00:00' AND '2025-11-11 23:59:59') LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:336 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = 66304) ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 0 | /classes/SpecificPrice.php:480 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE (`id_product` = 65242) AND (`id_shop` = 1) |
0.1 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 66151 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:1175 | ||
INSERT INTO `ps_bankrefnumber` (`id_cart`, `bankrefnumber`) VALUES (8785, "RF718785") ON DUPLICATE KEY UPDATE `bankrefnumber` = "RF718785" |
0.1 | 1 | /modules/bankrefnumber/bankrefnumber.php:309 | ||
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE (`id_supplier` = 1) LIMIT 1 |
0.1 | 1 | /classes/Supplier.php:265 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = 27904) AND (`id_group` = 1) LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:111 | ||
SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE (`id_country` = 86) |
0.1 | 3 | /Adapter/Adapter_EntityMapper.php:88 | ||
SELECT SQL_NO_CACHE id_feature, id_product, id_feature_value FROM `ps_feature_product` WHERE `id_product` IN (11812) |
0.1 | 1 | /classes/Product.php:2733 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 11812 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:1175 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 65432) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:462 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 3103 LIMIT 1 |
0.1 | 0 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = 2240) LIMIT 1 |
0.1 | 1 | /classes/Category.php:1017 | ||
SELECT SQL_NO_CACHE `iso_code` FROM `ps_country` WHERE (`id_country` = 0) LIMIT 1 |
0.1 | 0 | /classes/Country.php:259 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 65242 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:1175 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 27904 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:1175 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 3259 LIMIT 1 |
0.1 | 0 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 2293 LIMIT 1 |
0.1 | 0 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = 3094) LIMIT 1 |
0.1 | 1 | /classes/Category.php:1017 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE (`id_group` = 1) LIMIT 1 |
0.1 | 1 | /classes/Group.php:224 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 65242) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:462 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 27904) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:462 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 2293 LIMIT 1 |
0.1 | 1 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = 1395) LIMIT 1 |
0.1 | 1 | /classes/Category.php:1017 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 11812) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:462 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 3103 LIMIT 1 |
0.1 | 1 | /classes/Category.php:766 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE (`to` BETWEEN '2025-11-11 00:00:00' AND '2025-11-11 23:59:59') LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:342 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = 11812) AND (`id_group` = 1) LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:111 | ||
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = 3103) LIMIT 1 |
0.1 | 1 | /classes/Category.php:1017 |
| 27 |
SELECT p.`eanXX` as `ean`
FROM `ps_product` p WHERE p.`id_product` = XX
UNION SELECT e.`ean` as `ean` FROM `ps_product_ean` e
where e.`product_id` = XX
|
| 13 | SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX |
| 12 | SELECT * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = XX AND cl.id_shop = XX WHERE (c.nleft <= XX AND c.nright >= XX) ORDER BY c.nleft |
| 7 | SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (XX, XX)) AND (`id_currency` IN (XX, XX)) AND (`id_country` IN (XX, XX)) AND (`id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)) AND (IF(`from_quantity` > XX, `from_quantity`, XX) <= XX) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX |
| 7 | SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_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 |
| 6 | SELECT id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = XX AND c.`active` = XX WHERE (pc.`id_product` = XX) AND (pc.`id_shop` = XX) |
| 6 | SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX |
| 6 | SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (XX, XX)) AND (`id_currency` IN (XX, XX)) AND (`id_country` = XX) AND (`id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)) AND (IF(`from_quantity` > XX, `from_quantity`, XX) <= XX) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX |
| 6 | SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX |
| 6 | 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 FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_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) |
| 6 | SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = XX) ORDER BY `id_specific_price_priority` DESC LIMIT XX |
| 6 | SELECT SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = XX AND `id_cart` = XX LIMIT XX |
| 6 |
SELECT fp.id_feature, fp.id_product, fp.id_feature_value, custom
FROM `ps_feature_product` fp
LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value)
WHERE `id_product` = XX |
| 6 | SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX |
| 6 | SELECT * FROM `ps_product_lang` WHERE (`id_product` = XX) AND (`id_shop` = XX) |
| 6 | SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = XX) AND (`id_group` = XX) LIMIT XX |
| 6 | SELECT `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = XX) LIMIT XX |
| 4 | SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, XX) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, XX, XX), LPAD(IFNULL(cp.`id_product_attribute`, XX), XX, XX), IFNULL(cp.`id_address_delivery`, XX)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`eanXX`, '') = '', p.`eanXX`, pa.`eanXX`) AS eanXX, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > XX, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = XX WHERE (cp.`id_cart` = XX) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC |
| 3 |
SELECT hs.`id_htmlbannersXX_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM ps_htmlbannersXX hs
LEFT JOIN ps_htmlbannersXX_slides hss ON (hs.id_htmlbannersXX_slides = hss.id_htmlbannersXX_slides)
LEFT JOIN ps_htmlbannersXX_slides_lang hssl ON (hss.id_htmlbannersXX_slides = hssl.id_htmlbannersXX_slides)
WHERE id_shop = XX
AND hssl.id_lang = XX AND hss.`active` = XX
ORDER BY hss.position |
| 3 | SELECT * FROM `ps_cart` a WHERE (a.`id_cart` = XX) LIMIT XX |
| 2 |
SELECT id_feature, id_product, id_feature_value
FROM `ps_feature_product`
WHERE `id_product` IN (XX) |
| 2 | SELECT * FROM `ps_carrier` a LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = XX WHERE (a.`id_carrier` = XX) LIMIT XX |
| 2 | SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_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 |
| 2 | SELECT UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE (template_hash=XX) AND (cache_id="htmlbannersXX|XX|XX|XX|XX|XX") AND (compile_id="") LIMIT XX |
| 2 | SELECT SUM(`quantity`) FROM `ps_cart_product` WHERE (`id_cart` = XX) LIMIT XX |
| 2 |
INSERT INTO `ps_bankrefnumber` (`id_cart`, `bankrefnumber`)
VALUES (XX, "RFXX")
ON DUPLICATE KEY UPDATE `bankrefnumber` = "RFXX"
|
| 2 | UPDATE `ps_cart` SET `id_cart` = 'XX',`id_shop_group` = 'XX',`id_shop` = 'XX',`id_carrier` = 'XX',`delivery_option` = '',`id_lang` = 'XX',`id_address_delivery` = 'XX',`id_address_invoice` = 'XX',`id_currency` = 'XX',`id_customer` = 'XX',`id_guest` = 'XX',`secure_key` = '',`recyclable` = 'XX',`gift` = 'XX',`gift_message` = '',`mobile_theme` = 'XX',`allow_seperated_package` = 'XX',`date_add` = 'XX-XX-XX XX:XX:XX',`date_upd` = 'XX-XX-XX XX:XX:XX' WHERE `id_cart` = XX |
| 2 | SELECT * FROM `ps_carrier_lang` WHERE (`id_carrier` = XX) AND (`id_shop` = XX) |
| 2 | SELECT * FROM `ps_carrier` c INNER JOIN `ps_carrier_lang` cl ON cl.`id_carrier` = c.`id_carrier` WHERE (c.`id_reference` = XX) AND (c.`deleted` = XX) AND (cl.`id_shop` = XX) ORDER BY c.`id_carrier` DESC |
| 2 | SELECT `id_order` FROM `ps_orders` WHERE (`id_cart` = XX AND `id_shop` = XX ) LIMIT XX |
| 2 | SELECT * FROM `ps_carrier` a LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = XX LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = XX WHERE (a.`id_carrier` = XX) AND (b.`id_shop` = XX) LIMIT XX |
| 2 | SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX |
| 2 | SELECT `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = XX) AND (`id_shop` = XX) LIMIT XX |
| 54 product |
| 30 product_shop |
| 30 category_lang |
| 27 product_ean |
| 18 specific_price |
| 18 product_lang |
| 18 category |
| 16 cart_product |
| 14 stock_available |
| 13 carrier |
| 12 product_attribute_shop |
| 9 feature_product |
| 8 smarty_lazy_cache |
| 7 carrier_lang |
| 7 product_attribute |
| 6 feature_value |
| 6 specific_price_priority |
| 6 product_group_reduction_cache |
| 6 product_carrier |
| 5 currency_shop |
| 5 carrier_shop |
| 4 image_lang |
| 4 shop_url |
| 4 shop |
| 4 lang |
| 4 lang_shop |
| 4 country |
| 4 product_supplier |
| 4 currency |
| 4 image_shop |
| 4 module |
| 4 module_shop |
| 4 hook |
| 4 delivery |
| 3 country_shop |
| 3 cart |
| 3 orders |
| 3 country_lang |
| 3 theme |
| 3 meta |
| 2 zone |
| 2 smarty_last_flush |
| 2 range_weight |
| 2 carrier_tax_rules_group_shop |
| 2 configuration |
| 2 group |
| 2 hook_alias |
| 2 tax_rules_group |
| 2 manufacturer |
| 2 tax_rule |
| 2 supplier |
| 2 shop_group |
| 2 group_shop |
| 2 meta_lang |
| 2 hook_module |
| 1 manufacturer_shop |
| 1 supplier_shop |
| 1 supplier_lang |
| 1 carrier_zone |
| 1 carrier_group |
| 1 tax_lang |
| 1 module_group |
| 1 cart_cart_rule |
| 1 htmlbanners10_slides |
| 1 image_type |
| 1 htmlbanners6 |
| 1 htmlbanners6_slides |
| 1 htmlbanners6_slides_lang |
| 1 htmlbanners4 |
| 1 htmlbanners4_slides |
| 1 htmlbanners4_slides_lang |
| 1 htmlbanners10_slides_lang |
| 1 htmlbanners5_slides |
| 1 htmlbanners10 |
| 1 theme_meta |
| 1 configuration_lang |
| 1 tag |
| 1 product_tag |
| 1 hook_module_exceptions |
| 1 category_product |
| 1 category_group |
| 1 required_field |
| 1 group_lang |
| 1 address |
| 1 tbhtmlblock_lang |
| 1 htmlbanners5_slides_lang |
| 1 tbhtmlblock_hook |
| 1 tbhtmlblock |
| 1 manufacturer_lang |
| 1 state |
| 1 htmlbanners11 |
| 1 htmlbanners11_slides |
| 1 htmlbanners11_slides_lang |
| 1 htmlbanners5 |
| 1 tax |
| 1 themeconfigurator |
| Name | Instances | Source |
|---|---|---|
| Product | 27 | /controllers/front/CartController.php [160] /classes/Cart.php [3180] /modules/blockviewed/blockviewed.php [211] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Link.php [159] /classes/Link.php [157] /classes/Link.php [159] /classes/Link.php [157] /classes/Link.php [159] /classes/Link.php [157] /classes/Link.php [159] /classes/Link.php [157] /classes/Link.php [159] /classes/Link.php [157] /classes/Link.php [159] /classes/Link.php [157] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] |
| Carrier | 24 | /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [2242] /classes/Cart.php [2010] /modules/mijoravenipak/mijoravenipak.php [506] /classes/Cart.php [2242] /modules/mijoravenipak/mijoravenipak.php [506] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1683] /classes/Cart.php [1344] /classes/Cart.php [2242] /classes/Cart.php [2010] /classes/Cart.php [2242] /classes/Cart.php [1539] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] /classes/Cart.php [4190] |
| Country | 15 | /config/config.inc.php [144] /classes/Carrier.php [620] /modules/mijoravenipak/mijoravenipak.php [2390] /modules/mijoravenipak/mijoravenipak.php [2390] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] /classes/Carrier.php [620] |
| Address | 8 | /modules/bankrefnumber/bankrefnumber.php [334] /classes/Product.php [473] /classes/Product.php [526] /classes/Product.php [800] /classes/Product.php [1443] /modules/bankrefnumber/bankrefnumber.php [334] /modules/mijoravenipak/mijoravenipak.php [2389] /modules/mijoravenipak/mijoravenipak.php [2389] |
| Cart | 3 | /classes/controller/FrontController.php [1564] /modules/bankrefnumber/bankrefnumber.php [332] /modules/bankrefnumber/bankrefnumber.php [332] |
| Language | 2 | /config/config.inc.php [198] /classes/Tools.php [472] |
| Customer | 2 | /config/config.inc.php [223] /classes/Carrier.php [667] |
| Shop | 1 | /config/config.inc.php [122] |
| Theme | 1 | /config/config.inc.php [123] |
| ShopGroup | 1 | /classes/shop/Shop.php [557] |
| Group | 1 | /classes/Cart.php [206] |
| Currency | 1 | /classes/Tools.php [671] |
| Tax | 1 | /classes/tax/TaxRulesTaxManager.php [137] |
| # | Filename |
|---|---|
| 1 | /index.php |
| 2 | /config/config.inc.php |
| 3 | /config/defines_custom.inc.php |
| 4 | /config/defines.inc.php |
| 5 | /config/settings.inc.php |
| 6 | /config/autoload.php |
| 7 | /config/alias.php |
| 8 | /classes/PrestaShopAutoload.php |
| 9 | /vendor/autoload.php |
| 10 | /vendor/composer/autoload_real.php |
| 11 | /vendor/composer/platform_check.php |
| 12 | /vendor/composer/ClassLoader.php |
| 13 | /vendor/composer/include_paths.php |
| 14 | /vendor/composer/autoload_static.php |
| 15 | /vendor/ralouphie/getallheaders/src/getallheaders.php |
| 16 | /vendor/symfony/polyfill-intl-normalizer/bootstrap.php |
| 17 | /vendor/symfony/polyfill-php70/bootstrap.php |
| 18 | /vendor/symfony/polyfill-php72/bootstrap.php |
| 19 | /vendor/symfony/polyfill-php72/Php72.php |
| 20 | /vendor/guzzlehttp/promises/src/functions_include.php |
| 21 | /vendor/guzzlehttp/promises/src/functions.php |
| 22 | /vendor/guzzlehttp/psr7/src/functions_include.php |
| 23 | /vendor/guzzlehttp/psr7/src/functions.php |
| 24 | /vendor/symfony/polyfill-intl-idn/bootstrap.php |
| 25 | /vendor/symfony/polyfill-mbstring/bootstrap.php |
| 26 | /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php |
| 27 | /vendor/guzzlehttp/guzzle/src/functions_include.php |
| 28 | /vendor/guzzlehttp/guzzle/src/functions.php |
| 29 | /vendor/jakeasmith/http_build_url/src/http_build_url.php |
| 30 | /vendor/kint-php/kint/init.php |
| 31 | /vendor/kint-php/kint/src/Kint.php |
| 32 | /vendor/kint-php/kint/src/Utils.php |
| 33 | /vendor/kint-php/kint/init_helpers.php |
| 34 | /vendor/swiftmailer/swiftmailer/lib/swift_required.php |
| 35 | /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php |
| 36 | /cache/class_index.php |
| 37 | /config/bootstrap.php |
| 38 | /classes/core/ServiceLocator.php |
| 39 | /Core/Foundation/IoC/Core_Foundation_IoC_Container.php |
| 40 | /classes/error/response/DebugErrorPage.php |
| 41 | /classes/error/response/AbstractErrorPage.php |
| 42 | /classes/error/response/ErrorResponseInterface.php |
| 43 | /classes/error/ErrorHandler.php |
| 44 | /config/settings_custom.inc.php |
| 45 | /_scripts_/utils/utils.php |
| 46 | /_scripts_/utils/service.class.php |
| 47 | /_scripts_/utils/log.class.php |
| 48 | /_scripts_/utils/xmlExporter.class.php |
| 49 | /classes/controller/Controller.php |
| 50 | /classes/ObjectModel.php |
| 51 | /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php |
| 52 | /classes/db/Db.php |
| 53 | /classes/Tools.php |
| 54 | /classes/Context.php |
| 55 | /classes/shop/Shop.php |
| 56 | /config/db_slave_server.inc.php |
| 57 | /classes/db/DbPDO.php |
| 58 | /classes/Configuration.php |
| 59 | /classes/db/DbQuery.php |
| 60 | /classes/Validate.php |
| 61 | /classes/cache/Cache.php |
| 62 | /Adapter/Adapter_ServiceLocator.php |
| 63 | /Adapter/Adapter_EntityMapper.php |
| 64 | /classes/Theme.php |
| 65 | /config/defines_uri.inc.php |
| 66 | /classes/Language.php |
| 67 | /classes/Country.php |
| 68 | /classes/PrestaShopCollection.php |
| 69 | /classes/shop/ShopGroup.php |
| 70 | /classes/Cookie.php |
| 71 | /classes/Encryptor.php |
| 72 | /classes/PhpEncryption.php |
| 73 | /vendor/defuse/php-encryption/src/Key.php |
| 74 | /vendor/defuse/php-encryption/src/Encoding.php |
| 75 | /vendor/defuse/php-encryption/src/Core.php |
| 76 | /vendor/defuse/php-encryption/src/Crypto.php |
| 77 | /vendor/defuse/php-encryption/src/KeyOrPassword.php |
| 78 | /vendor/defuse/php-encryption/src/RuntimeTests.php |
| 79 | /vendor/defuse/php-encryption/src/DerivedKeys.php |
| 80 | /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php |
| 81 | /vendor/defuse/php-encryption/src/Exception/CryptoException.php |
| 82 | /config/smarty.config.inc.php |
| 83 | /classes/SmartyCustom.php |
| 84 | /vendor/smarty/smarty/libs/Smarty.class.php |
| 85 | /vendor/smarty/smarty/libs/Autoloader.php |
| 86 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php |
| 87 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php |
| 88 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| 89 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php |
| 90 | /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php |
| 91 | /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php |
| 92 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php |
| 93 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php |
| 94 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php |
| 95 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php |
| 96 | /classes/Translate.php |
| 97 | /classes/Customer.php |
| 98 | /classes/Group.php |
| 99 | /classes/Link.php |
| 100 | /classes/shop/ShopUrl.php |
| 101 | /classes/Hook.php |
| 102 | /vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php |
| 103 | /classes/Dispatcher.php |
| 104 | /classes/Supplier.php |
| 105 | /classes/Manufacturer.php |
| 106 | /controllers/front/CartController.php |
| 107 | /classes/controller/FrontController.php |
| 108 | /classes/PageCache.php |
| 109 | /classes/Cart.php |
| 110 | /classes/Currency.php |
| 111 | /classes/module/Module.php |
| 112 | /modules/bankrefnumber/bankrefnumber.php |
| 113 | /modules/bankrefnumber/src/phpIso11649.php |
| 114 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php |
| 115 | /vendor/smarty/smarty/libs/sysplugins/smarty_data.php |
| 116 | /classes/Address.php |
| 117 | /classes/Meta.php |
| 118 | /classes/Product.php |
| 119 | /override/classes/Product.php |
| 120 | /classes/Pack.php |
| 121 | /classes/webservice/WebserviceRequest.php |
| 122 | /classes/ImageManager.php |
| 123 | /classes/Media.php |
| 124 | /modules/montonio/montonio.php |
| 125 | /modules/montonio/vendor/montoniojwt/MontonioJWT.php |
| 126 | /modules/montonio/vendor/montoniojwt/MontonioExpiredException.php |
| 127 | /modules/montonio/vendor/montoniojwt/MontonioSignatureInvalidException.php |
| 128 | /modules/montonio/vendor/montoniojwt/MontonioBeforeValidException.php |
| 129 | /modules/montonio/vendor/abstract/MontonioAbstractApi.php |
| 130 | /modules/montonio/vendor/MontonioStargateApi.php |
| 131 | /modules/montonio/vendor/MontonioPluginTelemetryApi.php |
| 132 | /modules/montonio/vendor/MontonioOrderPrefixManager.php |
| 133 | /modules/montonio/src/loggers/MontonioLogger.php |
| 134 | /modules/montonio/controllers/MontonioAbstractFrontController.php |
| 135 | /classes/controller/ModuleFrontController.php |
| 136 | /modules/montonio/controllers/MontonioAbstractErrorPageHandler.php |
| 137 | /modules/montonio/controllers/MontonioRedirectToErrorPageHandler.php |
| 138 | /modules/montonio/controllers/MontonioReloadCurrentPageHandler.php |
| 139 | /modules/montonio/controllers/MontonioRedirectToCheckoutErrorPageHandler.php |
| 140 | /modules/montonio/src/helpers/MontonioHelper.php |
| 141 | /modules/montonio/src/helpers/MontonioCartHelper.php |
| 142 | /modules/montonio/src/helpers/MontonioOrderHelper.php |
| 143 | /modules/montonio/src/helpers/MontonioCheckoutHelper.php |
| 144 | /modules/montonio/src/helpers/MontonioPaymentMethodHelper.php |
| 145 | /modules/montonio/src/helpers/MontonioRefundHelper.php |
| 146 | /modules/montonio/src/telemetry/MontonioPluginTelemetryService.php |
| 147 | /modules/montonio/src/orderprocessing/MontonioOrderProcessingStrategy.php |
| 148 | /modules/montonio/src/orderprocessing/MontonioAfterPaymentOrderProcessing.php |
| 149 | /modules/montonio/src/orderprocessing/MontonioBeforePaymentOrderProcessing.php |
| 150 | /modules/montonio/src/database/MontonioLocksTableManager.php |
| 151 | /modules/montonio/src/database/MontonioOrdersTableManager.php |
| 152 | /modules/montonio/src/database/MontonioPaymentIntentDraftsTableManager.php |
| 153 | /modules/montonio/src/configuration/MontonioConfiguration.php |
| 154 | /modules/montonio/src/configuration/MontonioConfigurationForm.php |
| 155 | /modules/montonio/src/paymentmethods/traits/MontonioPaymentMethodConfigTrait.php |
| 156 | /modules/montonio/src/paymentmethods/traits/MontonioEmbeddedPaymentMethodConfigTrait.php |
| 157 | /modules/montonio/src/paymentmethods/traits/MontonioEmbeddedPaymentMethodTrait.php |
| 158 | /modules/montonio/src/paymentmethods/traits/MontonioPaymentsCheckoutTrait.php |
| 159 | /modules/montonio/src/paymentmethods/traits/MontonioGrandTotalConstraintTrait.php |
| 160 | /modules/montonio/src/paymentmethods/traits/MontonioRefundablePaymentMethodTrait.php |
| 161 | /modules/montonio/src/paymentmethods/MontonioAbstractPaymentMethod.php |
| 162 | /modules/montonio/src/paymentmethods/registries/MontonioPaymentMethodRegistry.php |
| 163 | /modules/montonio/src/paymentmethods/MontonioBnpl.php |
| 164 | /modules/montonio/src/paymentmethods/MontonioBlik.php |
| 165 | /modules/montonio/src/paymentmethods/MontonioPayments.php |
| 166 | /modules/montonio/src/paymentmethods/MontonioFinancing.php |
| 167 | /modules/montonio/src/paymentmethods/MontonioCardPayments.php |
| 168 | /classes/module/PaymentModule.php |
| 169 | /modules/montonio/translations/et.php |
| 170 | /classes/workqueue/Scheduler.php |
| 171 | /classes/workqueue/WorkQueueClient.php |
| 172 | /classes/tax/TaxManagerFactory.php |
| 173 | /modules/vatnumber/vatnumber.php |
| 174 | /classes/tax/TaxManagerModule.php |
| 175 | /modules/vatnumber/translations/et.php |
| 176 | /modules/vatnumber/VATNumberTaxManager.php |
| 177 | /classes/tax/TaxManagerInterface.php |
| 178 | /classes/tax/TaxRulesTaxManager.php |
| 179 | /Adapter/Adapter_Configuration.php |
| 180 | /Core/Business/Core_Business_ConfigurationInterface.php |
| 181 | /classes/tax/Tax.php |
| 182 | /classes/tax/TaxCalculator.php |
| 183 | /classes/Combination.php |
| 184 | /classes/SpecificPrice.php |
| 185 | /override/classes/SpecificPrice.php |
| 186 | /classes/GroupReduction.php |
| 187 | /classes/Tag.php |
| 188 | /classes/stock/StockAvailable.php |
| 189 | /classes/Category.php |
| 190 | /classes/core/InitializationCallback.php |
| 191 | /classes/Customization.php |
| 192 | /classes/Feature.php |
| 193 | /classes/order/Order.php |
| 194 | /classes/CartRule.php |
| 195 | /modules/thememanager/thememanager.php |
| 196 | /modules/thememanager/translations/et.php |
| 197 | /modules/socialsharing/socialsharing.php |
| 198 | /themes/technostore/modules/socialsharing/translations/et.php |
| 199 | /modules/socialsharing/translations/et.php |
| 200 | /modules/blockbestsellers/blockbestsellers.php |
| 201 | /themes/technostore/modules/blockbestsellers/translations/et.php |
| 202 | /modules/blockbestsellers/translations/et.php |
| 203 | /modules/blockcart/blockcart.php |
| 204 | /themes/technostore/modules/blockcart/translations/et.php |
| 205 | /modules/blockcart/translations/et.php |
| 206 | /modules/blockcurrencies/blockcurrencies.php |
| 207 | /themes/technostore/modules/blockcurrencies/translations/et.php |
| 208 | /modules/blockcurrencies/translations/et.php |
| 209 | /modules/blocklanguages/blocklanguages.php |
| 210 | /themes/technostore/modules/blocklanguages/translations/et.php |
| 211 | /modules/blocklanguages/translations/et.php |
| 212 | /modules/blockcontact/blockcontact.php |
| 213 | /themes/technostore/modules/blockcontact/translations/et.php |
| 214 | /modules/blockmyaccount/blockmyaccount.php |
| 215 | /themes/technostore/modules/blockmyaccount/translations/et.php |
| 216 | /modules/blockmyaccount/translations/et.php |
| 217 | /modules/blockmyaccountfooter/blockmyaccountfooter.php |
| 218 | /themes/technostore/modules/blockmyaccountfooter/translations/et.php |
| 219 | /modules/blockmyaccountfooter/translations/et.php |
| 220 | /modules/blocknewproducts/blocknewproducts.php |
| 221 | /themes/technostore/modules/blocknewproducts/translations/et.php |
| 222 | /modules/blockpaymentlogo/blockpaymentlogo.php |
| 223 | /themes/technostore/modules/blockpaymentlogo/translations/et.php |
| 224 | /modules/blockpaymentlogo/translations/et.php |
| 225 | /modules/blocksearch/blocksearch.php |
| 226 | /themes/technostore/modules/blocksearch/translations/et.php |
| 227 | /modules/blocksearch/translations/et.php |
| 228 | /modules/blockspecials/blockspecials.php |
| 229 | /themes/technostore/modules/blockspecials/translations/et.php |
| 230 | /modules/blockspecials/translations/et.php |
| 231 | /modules/blockcontactinfos/blockcontactinfos.php |
| 232 | /themes/technostore/modules/blockcontactinfos/translations/et.php |
| 233 | /modules/blocksupplier/blocksupplier.php |
| 234 | /themes/technostore/modules/blocksupplier/translations/et.php |
| 235 | /modules/blocksupplier/translations/et.php |
| 236 | /modules/blocktags/blocktags.php |
| 237 | /themes/technostore/modules/blocktags/translations/et.php |
| 238 | /modules/blocktags/translations/et.php |
| 239 | /modules/blockuserinfo/blockuserinfo.php |
| 240 | /themes/technostore/modules/blockuserinfo/translations/et.php |
| 241 | /modules/blockuserinfo/translations/et.php |
| 242 | /modules/blockviewed/blockviewed.php |
| 243 | /themes/technostore/modules/blockviewed/translations/et.php |
| 244 | /modules/blockviewed/translations/et.php |
| 245 | /modules/blockcms/blockcms.php |
| 246 | /modules/blockcms/BlockCMSModel.php |
| 247 | /themes/technostore/modules/blockcms/translations/et.php |
| 248 | /modules/themeconfigurator/themeconfigurator.php |
| 249 | /themes/technostore/modules/themeconfigurator/translations/et.php |
| 250 | /modules/themeconfigurator/translations/et.php |
| 251 | /modules/tbhtmlblock/tbhtmlblock.php |
| 252 | /modules/tbhtmlblock/translations/et.php |
| 253 | /modules/blocklayered/blocklayered.php |
| 254 | /themes/technostore/modules/blocklayered/translations/et.php |
| 255 | /modules/blocklayered/translations/et.php |
| 256 | /modules/customblocknewsletter/customblocknewsletter.php |
| 257 | /themes/technostore/modules/customblocknewsletter/translations/et.php |
| 258 | /modules/customblocknewsletter/translations/et.php |
| 259 | /modules/productprivatedata/productprivatedata.php |
| 260 | /modules/productprivatedata/vendor/autoload.php |
| 261 | /modules/productprivatedata/vendor/composer/autoload_real.php |
| 262 | /modules/productprivatedata/vendor/composer/autoload_static.php |
| 263 | /modules/productprivatedata/ppd.class.php |
| 264 | /modules/productprivatedata/supplierconfig.class.php |
| 265 | /modules/productprivatedata/suppliers.class.php |
| 266 | /modules/productprivatedata/PPD_product.class.php |
| 267 | /modules/suppliermapper/suppliermapper.php |
| 268 | /_scripts_/utils/prestaProduct.php |
| 269 | /_scripts_/utils/googleCustomSearch.class.php |
| 270 | /modules/suppliermapper/src/Importers.php |
| 271 | /modules/suppliermapper/src/SM_Mapper.php |
| 272 | /modules/suppliermapper/src/SM_Feature_Map.php |
| 273 | /modules/suppliermapper/src/SM_Feature_Value.php |
| 274 | /modules/suppliermapper/src/SM_Item.php |
| 275 | /modules/suppliermapper/src/SM_Item_Export.php |
| 276 | /modules/suppliermapper/src/SM_Logger.php |
| 277 | /modules/suppliermapper/src/SM_Map.php |
| 278 | /modules/suppliermapper/src/SM_Supplier.php |
| 279 | /modules/suppliermapper/src/xmlSearch.php |
| 280 | /modules/suppliermapper/translations/et.php |
| 281 | /modules/productprivatedata/et.php |
| 282 | /modules/htmlbanners11/htmlbanners11.php |
| 283 | /modules/htmlbanners11/HtmlBanner11.php |
| 284 | /modules/blocktopmenu/blocktopmenu.php |
| 285 | /modules/blocktopmenu/menutoplinks.class.php |
| 286 | /themes/technostore/modules/blocktopmenu/translations/et.php |
| 287 | /modules/blocktopmenu/translations/et.php |
| 288 | /modules/htmlbanners8/htmlbanners8.php |
| 289 | /modules/htmlbanners8/HtmlBanner8.php |
| 290 | /modules/htmlbanners5/htmlbanners5.php |
| 291 | /modules/htmlbanners5/HtmlBanner5.php |
| 292 | /classes/error/ErrorUtils.php |
| 293 | /modules/htmlbanners4/htmlbanners4.php |
| 294 | /modules/htmlbanners4/HtmlBanner4.php |
| 295 | /modules/htmlbanners10/htmlbanners10.php |
| 296 | /modules/htmlbanners10/HtmlBanner10.php |
| 297 | /modules/htmlbanners7/htmlbanners7.php |
| 298 | /modules/htmlbanners7/HtmlBanner7.php |
| 299 | /modules/mijoravenipak/mijoravenipak.php |
| 300 | /modules/mijoravenipak/classes/MjvpCart.php |
| 301 | /modules/mijoravenipak/classes/MjvpManifest.php |
| 302 | /modules/mijoravenipak/classes/MjvpWarehouse.php |
| 303 | /modules/mijoravenipak/classes/MjvpApi.php |
| 304 | /modules/mijoravenipak/classes/MjvpBase.php |
| 305 | /modules/mijoravenipak/classes/MjvpFiles.php |
| 306 | /modules/mijoravenipak/classes/MjvpDb.php |
| 307 | /modules/mijoravenipak/classes/MjvpHelper.php |
| 308 | /modules/mijoravenipak/classes/MjvpModuleConfig.php |
| 309 | /modules/mijoravenipak/vendor/autoload.php |
| 310 | /modules/mijoravenipak/vendor/composer/autoload_real.php |
| 311 | /modules/mijoravenipak/vendor/composer/autoload_static.php |
| 312 | /classes/module/CarrierModule.php |
| 313 | /modules/mijoravenipak/translations/et.php |
| 314 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php |
| 315 | /cache/smarty/compile/14/18/0f/14180f0a8998b767ba7bb8cb130db9288f8ab081_0.file.blockuserinfo.tpl.php |
| 316 | /Adapter/Adapter_AddressFactory.php |
| 317 | /Adapter/Adapter_ProductPriceCalculator.php |
| 318 | /classes/ProductDownload.php |
| 319 | /classes/Carrier.php |
| 320 | /cache/smarty/compile/e2/d0/d5/e2d0d55706a7c1b0e6a120beabb3db72fdc51686_0.file.blockcart.tpl.php |
| 321 | /vendor/smarty/smarty/libs/plugins/modifier.replace.php |
| 322 | /vendor/smarty/smarty/libs/plugins/function.counter.php |
| 323 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php |
| 324 | /classes/ImageType.php |
| 325 | /classes/Image.php |
| 326 | /modules/statsmodule/statsmodule.php |
| 327 | /classes/module/ModuleStats.php |
| 328 | /modules/statsmodule/translations/et.php |
| 329 | /modules/statsmodule/stats/pagesnotfound.php |
| 330 | /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php |
| 331 | /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php |
| 332 | /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php |
| 333 | /cache/smarty/cache/blocksearch_top/1/1/1/2/86/30/1a/3f/301a3ffc1800af266d58e346123cb0d4637dd6e2.blocksearch-top.tpl.php |
| 334 | /modules/htmlbanners6/htmlbanners6.php |
| 335 | /modules/htmlbanners6/HtmlBanner6.php |
| 336 | /cache/smarty/cache/htmlbanners6/1/1/1/2/86/3d/44/c6/3d44c68651ff9a5b91377b7ea912b6e74f54c0de.hook.tpl.php |
| 337 | /cache/smarty/cache/blocktopmenu/1/1/1/2/86/index/fb/e4/28/fbe428dc068a048011c8730f913289b15b055a36.blocktopmenu.tpl.php |
| 338 | /cache/smarty/cache/htmlbanners4/1/1/1/2/86/f0/ee/74/f0ee74e1982c42d9a056fc3bc68326c8ebb706a8.hook.tpl.php |
| 339 | /cache/smarty/cache/blockcms/2/1/1/1/2/86/22/49/fb/2249fba81763b82611fcb942807f5048e82ef7cc.blockcms.tpl.php |
| 340 | /cache/smarty/cache/blockmyaccountfooter/1/1/1/2/86/aa/27/3f/aa273ffa54ffe5622a9a34d0751dd26531e2b2c9.blockmyaccountfooter.tpl.php |
| 341 | /modules/statsdata/statsdata.php |
| 342 | /themes/technostore/modules/statsdata/translations/et.php |
| 343 | /modules/statsdata/translations/et.php |
| 344 | /classes/Connection.php |
| 345 | /vendor/jaybizzle/crawler-detect/src/CrawlerDetect.php |
| 346 | /vendor/jaybizzle/crawler-detect/src/Fixtures/Crawlers.php |
| 347 | /vendor/jaybizzle/crawler-detect/src/Fixtures/AbstractProvider.php |
| 348 | /vendor/jaybizzle/crawler-detect/src/Fixtures/Exclusions.php |
| 349 | /vendor/jaybizzle/crawler-detect/src/Fixtures/Headers.php |
| 350 | /classes/ConnectionsSource.php |
| 351 | /cache/smarty/cache/blockcontactinfos/1/1/1/2/86/bd/06/d7/bd06d71c67e2e9e78e007fac57a60b2722d8e4d8.blockcontactinfos.tpl.php |
| 352 | /cache/smarty/compile/d4/16/f1/d416f1fa9445076ce6f5f2851ea24d427d237ce7_0.file.hook.tpl.php |