Load Time 1280 ms
Querying Time 401 ms
Queries 732
Memory Peak Usage 23.7 Mb
Included Files 976 files - 9.08 Mb
PrestaShop Cache - Mb
Global vars 0.46 Mb
PrestaShop Version 1.7.8.3
PHP Version 7.4.33
MySQL Version 5.5.62-38.14-log
Memory Limit 256M
Max Execution Time 300s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 4 ms 4 ms 2.52 Mb 2.5 Mb
__construct 0 ms 4 ms - Mb 2.5 Mb
init 260 ms 264 ms 1.84 Mb 4.4 Mb
checkAccess 0 ms 264 ms - Mb 4.4 Mb
setMedia 10 ms 273 ms 0.68 Mb 5.0 Mb
postProcess 0 ms 273 ms - Mb 5.0 Mb
initHeader 0 ms 273 ms - Mb 5.0 Mb
initContent 612 ms 885 ms 8.93 Mb 14.0 Mb
initFooter 0 ms 885 ms - Mb 14.0 Mb
display 395 ms 1280 ms 9.44 Mb 23.7 Mb
Hook Time Memory Usage
displayProductListReviews 105 ms 0.71 Mb
DisplayFooter 29 ms 0.05 Mb
displayNav2 22 ms 0.65 Mb
Header 22 ms 0.27 Mb
displayFooter 21 ms 0.17 Mb
DisplayBeforeBodyClosingTag 13 ms 0.36 Mb
displayTop 11 ms 0.17 Mb
displayFooterBefore 9 ms 0.13 Mb
ProductSearchProvider 7 ms 0.48 Mb
displayLeftColumn 6 ms 0.06 Mb
displayNav1 5 ms 0.07 Mb
DisplayHeader 3 ms 0.68 Mb
ActionFrontControllerSetMedia 2 ms 0.38 Mb
DisplayLeftColumn 2 ms - Mb
DisplayNavFullWidth 2 ms - Mb
DisplayTop 1 ms - Mb
ActionDispatcherBefore 0 ms - Mb
DisplayFooterBefore 0 ms - Mb
DisplayAfterBodyOpeningTag 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
20 hook(s) 260 ms 4.20 Mb
Module Time Memory Usage
ps_mbo 16 ms 0.12 Mb
blockwishlist 33 ms 0.34 Mb
blockreassurance 2 ms 0.15 Mb
ps_socialfollow 10 ms 0.22 Mb
ps_imageslider 2 ms 0.19 Mb
ps_searchbar 7 ms 0.38 Mb
ps_shoppingcart 9 ms 0.46 Mb
productcomments 108 ms 0.97 Mb
paypal 31 ms 0.44 Mb
ps_facetedsearch 19 ms 0.53 Mb
ps_contactinfo 11 ms 0.12 Mb
ps_languageselector 3 ms 0.06 Mb
ps_currencyselector 9 ms 0.18 Mb
ps_customersignin 5 ms 0.06 Mb
ps_mainmenu 7 ms 0.15 Mb
pagesnotfound 2 ms 0.02 Mb
ps_categorytree 7 ms 0.08 Mb
ps_linklist 13 ms 0.10 Mb
ps_customeraccountlinks 8 ms 0.08 Mb
statsdata 14 ms 0.38 Mb
20 module(s) 316 ms 5.03 Mb

Stopwatch SQL - 732 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, pl.name FROM ps93_product p LEFT JOIN ps93_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps93_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps93_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps93_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps93_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 2) INNER JOIN ps93_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps93_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps93_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps93_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=47 AND c.nright<=48 GROUP BY p.id_product) p INNER JOIN ps93_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 2) GROUP BY p.id_product ORDER BY p.name ASC, p.id_product DESC LIMIT 0, 24
10200 ms 294084 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, pl.name FROM ps93_product p LEFT JOIN ps93_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps93_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps93_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps93_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps93_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 2) INNER JOIN ps93_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps93_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps93_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps93_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=47 AND c.nright<=48 GROUP BY p.id_product) p
6615 ms 294084 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps93_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps93_hook_alias` ha
INNER JOIN `ps93_hook` h ON ha.name = h.name
6516 ms 0 /classes/Hook.php:1233
SELECT SQL_NO_CACHE `id_guest`
FROM `ps93_connections`
WHERE `id_guest` = 1711077
AND `date_add` > '2023-09-24 12:21:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
3480 ms 1 Yes /classes/Connection.php:154
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps93_hook_module` hm
STRAIGHT_JOIN `ps93_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps93_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2839 ms 284 /classes/Hook.php:494
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps93_module` m
INNER JOIN ps93_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 `ps93_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps93_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps93_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps93_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2053 ms 128 Yes Yes /classes/Hook.php:1173
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps93_configuration` c
LEFT JOIN `ps93_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1747 ms 565 /classes/Configuration.php:160
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps93_category` c
INNER JOIN `ps93_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
INNER JOIN `ps93_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 6
AND nleft >= 47 AND nright <= 48
AND c.id_category IN (
SELECT id_category
FROM `ps93_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cl.`name` ASC
1654 ms 1 Yes /modules/ps_categorytree/ps_categorytree.php:166
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16638
LIMIT 1
1547 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16655) AND (b.`id_shop` = 1) LIMIT 1
1514 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_searchbar" LIMIT 1
1383 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16638) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1381 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 30 AND `id_shop` = 1 LIMIT 1
1342 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_mainmenu" LIMIT 1
1334 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16655
LIMIT 1
1254 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps93_layered_category
WHERE controller = 'category'
AND id_category = 38
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
1182 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "productSearchProvider") LIMIT 1
1180 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE tr.*
FROM `ps93_tax_rule` tr
JOIN `ps93_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
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
1147 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16641
LIMIT 1
1131 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_category` a
LEFT JOIN `ps93_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 38) LIMIT 1
1116 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
1109 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_order`
FROM `ps93_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1108 ms 1 /classes/order/Order.php:1203
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 ps93_shop_group gs
LEFT JOIN ps93_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps93_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
1107 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps93_hook`
1101 ms 887 /classes/Hook.php:1233
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16638) AND (b.`id_shop` = 1) LIMIT 1
1095 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductSearchProviderRunQueryBefore") LIMIT 1
1094 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_categorytree" LIMIT 1
1079 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 16655
AND image_shop.`cover` = 1 LIMIT 1
1074 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE `reduction`
FROM `ps93_group`
WHERE `id_group` = 1 LIMIT 1
1074 ms 1 /classes/Group.php:154
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16653
LIMIT 1
1067 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 13 AND `id_shop` = 1 LIMIT 1
1067 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16657
LIMIT 1
1057 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_category_lang`
WHERE `id_category` = 38 AND `id_shop` = 1
1055 ms 2 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
1055 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps93_category` c
INNER JOIN ps93_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps93_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps93_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 38
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1044 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE `reduction`
FROM `ps93_product_group_reduction_cache`
WHERE `id_product` = 16638 AND `id_group` = 1 LIMIT 1
1043 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16638 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16638 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1030 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16641) AND (b.`id_shop` = 1) LIMIT 1
1023 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
1021 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayLeftColumn") LIMIT 1
1000 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16643) AND (b.`id_shop` = 1) LIMIT 1
1000 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps93_meta` m
LEFT JOIN `ps93_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
983 ms 39 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16654
ORDER BY `position`
969 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16659
LIMIT 1
968 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_currency` c
INNER JOIN ps93_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
963 ms 2 Yes /classes/Currency.php:694
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16638)
961 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16651 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16651 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
954 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps93_currency_lang`
WHERE `id_currency` = 1
951 ms 2 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps93_currency` c
LEFT JOIN ps93_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
943 ms 2 /classes/Currency.php:1126
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16649) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
943 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayTop") LIMIT 1
941 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16638) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
940 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE name FROM ps93_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 38 LIMIT 1
935 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayNav1") LIMIT 1
922 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16638
ORDER BY f.position ASC
921 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
918 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16656
LIMIT 1
918 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
911 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16661
LIMIT 1
908 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16652
LIMIT 1
904 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_currency` a
LEFT JOIN `ps93_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
903 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16645
LIMIT 1
898 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
897 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps93_lang` l
JOIN ps93_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
896 ms 4 /classes/Language.php:1198
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16641)
895 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionPresentCart") LIMIT 1
892 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductListReviews") LIMIT 1
888 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
887 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16639
LIMIT 1
887 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16642
LIMIT 1
884 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16646
LIMIT 1
883 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayBanner") LIMIT 1
880 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16644
LIMIT 1
880 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps93_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
877 ms 2 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayAfterBodyOpeningTag") LIMIT 1
876 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16641 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16641 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
868 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16660
LIMIT 1
867 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
866 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 16638
AND image_shop.`cover` = 1 LIMIT 1
862 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps93_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 38 LIMIT 1
859 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16655)
858 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 16653
AND image_shop.`cover` = 1 LIMIT 1
855 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
854 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16658) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
842 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16658
LIMIT 1
841 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16654
LIMIT 1
841 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16640
LIMIT 1
841 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16653) AND (b.`id_shop` = 1) LIMIT 1
837 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 32 AND `id_shop` = 1 LIMIT 1
837 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 17 AND `id_shop` = 1 LIMIT 1
835 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16649
LIMIT 1
832 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_category` a
LEFT JOIN `ps93_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps93_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 38) AND (b.`id_shop` = 1) LIMIT 1
830 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16651) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
830 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16643
LIMIT 1
826 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_currencyselector" LIMIT 1
822 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
820 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
819 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE data FROM ps93_layered_filter_block WHERE hash="2d04120ffa011fbf7c81e62368eaa34c" LIMIT 1
815 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
813 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16654
ORDER BY f.position ASC
809 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
806 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
803 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_lang` a
LEFT JOIN `ps93_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
803 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_customersignin" LIMIT 1
801 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps93_product_attribute`
WHERE `id_product` = 16654
789 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16651
LIMIT 1
789 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16647
LIMIT 1
786 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16652) AND (b.`id_shop` = 1) LIMIT 1
785 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16648
LIMIT 1
783 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 27 AND `id_shop` = 1 LIMIT 1
779 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
778 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT 1
776 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps93_product_attribute`
WHERE `id_product` = 16652
771 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `reduction`
FROM `ps93_product_group_reduction_cache`
WHERE `id_product` = 16655 AND `id_group` = 1 LIMIT 1
771 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16641) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
766 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_languageselector" LIMIT 1
761 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayNav2") LIMIT 1
761 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16655 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16655 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
759 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16640) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
758 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16655) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
757 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16642) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
755 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16657 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16657 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
755 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductSearchProviderRunQueryAfter") LIMIT 1
755 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16639) AND (b.`id_shop` = 1) LIMIT 1
752 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16639) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
747 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16659) AND (b.`id_shop` = 1) LIMIT 1
746 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-09-24 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps93_product p
LEFT JOIN ps93_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps93_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ps93_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 16650
LIMIT 1
746 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_order`
FROM `ps93_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
741 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16652
ORDER BY f.position ASC
739 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps93_product_shop`
WHERE `id_product` = 16638 AND id_shop=1 LIMIT 1
739 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16651) AND (b.`id_shop` = 1) LIMIT 1
738 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16657) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
736 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
736 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16656) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
734 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16643 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16643 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
734 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16645) AND (b.`id_shop` = 1) LIMIT 1
733 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16655
ORDER BY f.position ASC
733 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
733 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16661) AND (b.`id_shop` = 1) LIMIT 1
733 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16643) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
733 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
732 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps93_country`
WHERE `id_country` = 10 LIMIT 1
730 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "moduleRoutes") LIMIT 1
728 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16641) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
727 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module` WHERE `name` = "ps_contactinfo" LIMIT 1
717 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `ps93_module_shop` WHERE `id_module` = 15 AND `id_shop` = 1 LIMIT 1
713 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16640 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16640 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
713 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16656) AND (b.`id_shop` = 1) LIMIT 1
711 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps93_product_shop`
WHERE `id_product` = 16641 AND id_shop=1 LIMIT 1
709 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16654 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16654 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
708 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16646) AND (b.`id_shop` = 1) LIMIT 1
706 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16640) AND (b.`id_shop` = 1) LIMIT 1
706 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16653) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
706 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionFrontControllerInitBefore") LIMIT 1
701 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionOutputHTMLBefore") LIMIT 1
700 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16654) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
700 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16661 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16661 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
699 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16659
ORDER BY f.position ASC
698 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16655) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
697 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_order`
FROM `ps93_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
694 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16661) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
692 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16648) AND (b.`id_shop` = 1) LIMIT 1
692 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16654) AND (b.`id_shop` = 1) LIMIT 1
690 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16657) AND (b.`id_shop` = 1) LIMIT 1
690 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16651
ORDER BY f.position ASC
685 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE * FROM `ps93_currency` c ORDER BY `iso_code` ASC
682 ms 2 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16660) AND (b.`id_shop` = 1) LIMIT 1
681 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16642) AND (b.`id_shop` = 1) LIMIT 1
679 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16652) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
678 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
677 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE name FROM ps93_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 38 LIMIT 1
675 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16644) AND (b.`id_shop` = 1) LIMIT 1
672 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16651) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
670 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16650) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
670 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
664 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16650) AND (b.`id_shop` = 1) LIMIT 1
662 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps93_module` m
LEFT JOIN `ps93_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
660 ms 65 /classes/module/Module.php:340
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
657 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16645) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
655 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16658 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16658 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
650 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16644) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
650 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
645 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16658) AND (b.`id_shop` = 1) LIMIT 1
645 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16661
ORDER BY f.position ASC
643 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16647) AND (b.`id_shop` = 1) LIMIT 1
642 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16642
ORDER BY `position`
641 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16656 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16656 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
640 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps93_product_shop`
WHERE `id_product` = 16655 AND id_shop=1 LIMIT 1
639 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 16641
AND image_shop.`cover` = 1 LIMIT 1
635 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionControllerInitBefore") LIMIT 1
634 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16646) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
633 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16643)
632 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE name FROM ps93_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 38 LIMIT 1
632 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT 1
628 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayAfterTitleTag") LIMIT 1
627 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16659) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
627 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ps93_product` a
LEFT JOIN `ps93_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps93_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16649) AND (b.`id_shop` = 1) LIMIT 1
626 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
626 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16647) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
622 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductListReviews") LIMIT 1
622 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_category` a0
LEFT JOIN `ps93_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 47) AND (a0.`nright` > 48) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
619 ms 2 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps93_module` m
LEFT JOIN `ps93_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
617 ms 65 /classes/module/Module.php:340
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16661
ORDER BY `position`
616 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16660 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16660 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
616 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
614 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16646 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16646 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
612 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16648) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
607 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `reduction`
FROM `ps93_product_group_reduction_cache`
WHERE `id_product` = 16641 AND `id_group` = 1 LIMIT 1
606 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
604 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16652 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16652 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
601 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionObjectConnectionAddAfter") LIMIT 1
601 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16653
ORDER BY `position`
599 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE name FROM ps93_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 38 LIMIT 1
590 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16659 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16659 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
588 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
587 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16640)
585 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
577 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16643
ORDER BY `position`
572 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps93_product_shop`
WHERE `id_product` = 16643 AND id_shop=1 LIMIT 1
571 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
571 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps93_product_attribute` pa
INNER JOIN ps93_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps93_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps93_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps93_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps93_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16660) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
571 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "filterProductSearch") LIMIT 1
570 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16657
ORDER BY f.position ASC
568 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16646
ORDER BY f.position ASC
568 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16649 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16649 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
565 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductListReviews") LIMIT 1
562 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps93_shop_url su
LEFT JOIN ps93_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.stampastampa.com' OR su.domain_ssl = 'www.stampastampa.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
561 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16653 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16653 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
560 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name FROM ps93_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 38 LIMIT 1
557 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16652
ORDER BY `position`
556 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16654)
555 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16642
ORDER BY f.position ASC
554 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16651)
553 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16653)
550 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductSearchAfter") LIMIT 1
550 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 16647
AND image_shop.`cover` = 1 LIMIT 1
549 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16658
ORDER BY f.position ASC
548 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16640
ORDER BY f.position ASC
548 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps93_product_attribute`
WHERE `id_product` = 16661
548 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16654) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
547 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16647 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16647 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
546 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16656
ORDER BY `position`
544 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
543 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16648 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16648 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
539 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_lang` FROM `ps93_lang`
WHERE `locale` = 'it-it'
OR `language_code` = 'it-it' LIMIT 1
539 ms 2 /classes/Language.php:853
SELECT SQL_NO_CACHE `reduction`
FROM `ps93_product_group_reduction_cache`
WHERE `id_product` = 16651 AND `id_group` = 1 LIMIT 1
538 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_country`
FROM `ps93_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
535 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
532 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
530 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16643) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
529 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16645 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16645 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
529 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16643
ORDER BY f.position ASC
528 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ps93_currency` a
LEFT JOIN `ps93_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `ps93_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
528 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
527 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16661)
526 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16640) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
526 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16642 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16642 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
526 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16644
ORDER BY f.position ASC
525 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ps93_currency` a
LEFT JOIN `ps93_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `ps93_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
525 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "DisplayOverrideTemplate") LIMIT 1
525 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps93_country` a
LEFT JOIN `ps93_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps93_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
524 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `ps93_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
522 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16639 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16639 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
522 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16660
ORDER BY f.position ASC
521 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_order`
FROM `ps93_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
521 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE name, alias FROM `ps93_hook_alias`
519 ms 88 /classes/Hook.php:343
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16638
ORDER BY `position`
519 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16658) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
518 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16644 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16644 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
517 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
517 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
514 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps93_product_shop`
WHERE `id_product` = 16654 AND id_shop=1 LIMIT 1
512 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps93_hook_alias`
511 ms 88 /classes/Hook.php:291
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16656
ORDER BY f.position ASC
511 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16641
ORDER BY `position`
510 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_order`
FROM `ps93_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
509 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
507 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16651
ORDER BY `position`
507 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
506 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
505 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps93_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16650 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps93_cart_product` cp JOIN `ps93_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps93_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16650 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
505 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
503 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16657
ORDER BY `position`
503 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16658
ORDER BY `position`
501 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16659)
501 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `id_lang` FROM `ps93_lang`
WHERE `locale` = 'it-it'
OR `language_code` = 'it-it' LIMIT 1
501 ms 2 /classes/Language.php:853
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps93_product` p
INNER JOIN `ps93_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps93_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` = 16642)
501 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps93_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
499 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16639
ORDER BY `position`
498 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `reduction`
FROM `ps93_product_group_reduction_cache`
WHERE `id_product` = 16643 AND `id_group` = 1 LIMIT 1
496 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps93_stock_available`
WHERE (id_product = 16652) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
496 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16644
ORDER BY `position`
494 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE active
FROM `ps93_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
493 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 16654
AND image_shop.`cover` = 1 LIMIT 1
492 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16655
ORDER BY `position`
489 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps93_product_shop`
WHERE `id_product` = 16653 AND id_shop=1 LIMIT 1
488 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16645
ORDER BY f.position ASC
486 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps93_image` i
INNER JOIN ps93_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps93_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 16659
ORDER BY `position`
486 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `ps93_country` a
LEFT JOIN `ps93_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps93_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 10) LIMIT 1
485 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `ps93_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
483 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16647
ORDER BY f.position ASC
481 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps93_feature_product pf
LEFT JOIN ps93_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps93_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps93_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps93_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16653
ORDER BY f.position ASC
480 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps93_product_shop`
WHERE `id_product` = 16651 AND id_shop=1 LIMIT 1
480 ms 1 /classes/Product.php:6751