×

Rollers

Filters
Categories

Sign in

Menu

My Wishlist0

Your cart

There are no more items in your cart
Load Time 1493 ms
Querying Time 711 ms
Queries 834
Memory Peak Usage 33.9 Mb
Included Files 1460 files - 18.59 Mb
PrestaShop Cache - Mb
Global vars 0.59 Mb
PrestaShop Version 1.7.8.11
PHP Version 7.4.3-4ubuntu2.20
MySQL Version 10.3.39-MariaDB-0ubuntu0.20.04.2
Memory Limit 1G
Max Execution Time 1200s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 17 ms 17 ms 5.48 Mb 5.5 Mb
__construct 0 ms 17 ms - Mb 5.5 Mb
init 48 ms 64 ms 1.95 Mb 7.5 Mb
checkAccess 0 ms 64 ms - Mb 7.5 Mb
setMedia 40 ms 104 ms 0.86 Mb 8.5 Mb
postProcess 0 ms 104 ms - Mb 8.5 Mb
initHeader 0 ms 104 ms - Mb 8.5 Mb
initContent 730 ms 834 ms 11.25 Mb 19.6 Mb
initFooter 0 ms 834 ms - Mb 19.6 Mb
display 658 ms 1493 ms 13.83 Mb 33.9 Mb
Hook Time Memory Usage
displayNavFullWidth 374 ms 6.38 Mb
DisplayHeader 245 ms 3.92 Mb
displayFooterPageBuilder 77 ms 0.89 Mb
displayButtonWishList 55 ms 1.14 Mb
DisplayProductListReviews 20 ms 0.64 Mb
DisplayBeforeBodyClosingTag 14 ms 0.41 Mb
displayLeftColumn 13 ms 0.22 Mb
displayCountDown 12 ms 0.33 Mb
Header 11 ms 0.25 Mb
ActionDispatcher 9 ms 0.01 Mb
DisplayBodyBottom 8 ms 0.41 Mb
displayProductListReviews 6 ms 0.08 Mb
DisplayTop 5 ms 0.10 Mb
ActionDispatcherBefore 5 ms 0.16 Mb
DisplayLeftColumn 4 ms 0.16 Mb
DisplayFooter 4 ms 0.18 Mb
DisplayProductPriceBlock 3 ms 0.21 Mb
ActionFrontControllerSetMedia 2 ms 0.01 Mb
displayBeforeBodyClosingTag 2 ms 0.07 Mb
displaySocialLogin 2 ms 0.11 Mb
DisplayAfterBodyOpeningTag 2 ms 0.01 Mb
displayBodyBottom 2 ms 0.16 Mb
ProductSearchProvider 1 ms 0.02 Mb
FilterProductSearch 1 ms 0.02 Mb
ActionOutputHTMLBefore 1 ms 0.01 Mb
ModuleRoutes 1 ms - Mb
displayMyAccountCanVas 1 ms 0.03 Mb
DisplayNavFullWidth 1 ms - Mb
OverrideLayoutTemplate 0 ms - Mb
DisplayOverrideTemplate 0 ms - Mb
displayHeaderCategory 0 ms - Mb
displayFooterBefore 0 ms - Mb
displayFooterCategory 0 ms - Mb
displayFooterAfter 0 ms - Mb
ActionProductSearchAfter 0 ms - Mb
displayFooter 0 ms - Mb
ActionFrontControllerAfterInit 0 ms - Mb
37 hook(s) 878 ms 15.96 Mb
Module Time Memory Usage
smartblog 3 ms 0.02 Mb
productadvicesurvey 1 ms 0.15 Mb
cookiesplus 19 ms 0.34 Mb
seoredirect 6 ms 0.29 Mb
ets_ordermanager 3 ms 0.13 Mb
securitypro 13 ms 0.31 Mb
quantitydiscountpro 14 ms 0.59 Mb
axoncreator 478 ms 7.67 Mb
ps_emailsubscription 0 ms 0.03 Mb
blockreassurance 0 ms 0.10 Mb
ps_emailalerts 0 ms 0.04 Mb
dpdbaltics 39 ms 0.73 Mb
nrtmegamenu 5 ms 0.19 Mb
nrtcountdown 12 ms 0.43 Mb
nrtproductvideo 0 ms 0.03 Mb
nrtreviews 7 ms 0.17 Mb
ets_migrate 1 ms 0.04 Mb
giftcard 1 ms 0.46 Mb
nrtwishlist 60 ms 1.28 Mb
stfacetedsearch 10 ms 0.16 Mb
stalphabeticalbrands 4 ms 0.09 Mb
nrtvariant 1 ms 0.02 Mb
nrtproductslinknav 0 ms 0.02 Mb
nrtsearchbar 2 ms 0.19 Mb
nrtshoppingcart 1 ms 0.02 Mb
nrtsocialbutton 1 ms 0.03 Mb
nrtsociallogin 2 ms 0.25 Mb
nrtzoom 1 ms 0.02 Mb
nrtthemecustomizer 10 ms 0.38 Mb
nrtpopupnewsletter 2 ms 0.05 Mb
paypal 6 ms 0.30 Mb
blockproduct 25 ms 0.88 Mb
ets_integrategooglemarketing 2 ms 0.05 Mb
mijoravenipak 23 ms 0.08 Mb
facebookproductad 182 ms 3.52 Mb
sendinblue 1 ms 0.03 Mb
myprestaloyalty 1 ms 0.04 Mb
omnivaltshipping 1 ms 0.05 Mb
hrxdelivery 9 ms 0.25 Mb
tawkto 1 ms 0.03 Mb
statsdata 6 ms 0.20 Mb
ps_languageselector 0 ms 0.02 Mb
42 module(s) 955 ms 19.67 Mb

Stopwatch SQL - 834 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, sa.id_product_attribute, ps.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=298 AND c.nright<=299 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=21)) GROUP BY fp.id_feature_value
61472 ms 11632 Yes /modules/stfacetedsearch/src/Adapter/MySQL.php:108
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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
20666 ms 6448 /classes/Configuration.php:160
SELECT SQL_NO_CACHE fa.*
FROM ps_st_search_facet_af fa
LEFT JOIN ps_st_search_facet_item fi ON (fa.id_st_search_facet_item = fi.id_st_search_facet_item)
WHERE fi.id_st_search_filter = 9
AND fi.facet_type="feat"
AND fi.facet_item_k=21
ORDER BY fa.position
14264 ms 1212 Yes /modules/stfacetedsearch/src/Filters/Block.php:1051
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 `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
9653 ms 807 /classes/Hook.php:504
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
7482 ms 4239481 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, sa.id_product_attribute, ps.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=298 AND c.nright<=299 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=11)) GROUP BY fp.id_feature_value
6015 ms 124322500 Yes /modules/stfacetedsearch/src/Adapter/MySQL.php:108
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 12355 LIMIT 1
5802 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, sa.id_product_attribute, ps.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=298 AND c.nright<=299 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) GROUP BY p.id_product ORDER BY p.date_add DESC, p.id_product LIMIT 0, 16
5526 ms 124322500 Yes Yes /modules/stfacetedsearch/src/Adapter/MySQL.php:108
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
5194 ms 0 /classes/Hook.php:1243
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-04-20 00:00:00",
INTERVAL 65 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 38 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,16
5146 ms 63 /override/classes/Category.php:113
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, sa.id_product_attribute, ps.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=298 AND c.nright<=299 AND ps.id_shop='1' GROUP BY p.id_product) p
4954 ms 124322500 /modules/stfacetedsearch/src/Adapter/MySQL.php:108
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 758 AND `id_shop` = 1
4824 ms 2877 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, sa.id_product_attribute, ps.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=298 AND c.nright<=299 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute  AND sa_1.id_shop = 1  AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))
4562 ms 124322500 /modules/stfacetedsearch/src/Adapter/MySQL.php:108
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, sa.id_product_attribute, ps.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=298 AND c.nright<=299 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute  AND sa_1.id_shop = 1  AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity>=0 AND sa_1.out_of_stock=1) OR (sa.quantity>0))
3735 ms 124322500 /modules/stfacetedsearch/src/Adapter/MySQL.php:108
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 38 LIMIT 1
3718 ms 1 /classes/Product.php:5622
SELECT SQL_NO_CACHE * FROM `ps_nrt_wishlist_product` WHERE `id_customer` = 0 AND `id_shop` = 1
3363 ms 4805 /modules/nrtwishlist/src/NrtWishlistProduct.php:65
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (3))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
3190 ms 213 Yes Yes /classes/Hook.php:1183
SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, sa.quantity, p.condition, p.weight, p.price, sa.id_product_attribute, ps.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product and pa.default_on=1) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=298 AND c.nright<=299 AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_manufacturer
3161 ms 124322500 Yes /modules/stfacetedsearch/src/Adapter/MySQL.php:108
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 3) AND `id_product` = 12355 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3099 ms 2 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_allow_svg' LIMIT 1
2585 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
UPDATE `ps_smarty_lazy_cache`
SET filepath='pageBuilder/16/17/category/38/1/3/3/1/21/akira/56/5f/a9/565fa91372212de3a2f1bfd1b1a465355e8bd0f9.axoncreatorviewstemplates.php'
WHERE `template_hash`='4cee5ee772c804daa2f39a5e9942bcd9' AND cache_id="pageBuilder|16|17|category|38|1|3|3|1|21" AND compile_id="akira"
2501 ms 1 /classes/Smarty/SmartyCustom.php:184
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7483 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 7483 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2493 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 629 AND id_shop=1 LIMIT 1
2357 ms 1 /classes/Product.php:6759
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-04-20 00:00:00' AND '2024-04-20 23:59:59' LIMIT 1
2332 ms 1 /classes/SpecificPrice.php:362
REPLACE INTO ps_st_search_filter_block (hash, data) VALUES ("677694ae755166fe5f14b6eb3093de19", "a:2:{s:7:\"filters\";a:3:{i:0;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:4:{i:84;a:3:{s:15:\"id_manufacturer\";s:2:\"84\";s:4:\"name\";s:12:\"BaByliss PRO\";s:3:\"nbr\";s:1:\"1\";}i:21;a:3:{s:15:\"id_manufacturer\";s:2:\"21\";s:4:\"name\";s:6:\"Comair\";s:3:\"nbr\";s:2:\"35\";}i:57;a:3:{s:15:\"id_manufacturer\";s:2:\"57\";s:4:\"name\";s:7:\"EFALOCK\";s:3:\"nbr\";s:1:\"5\";}i:23;a:3:{s:15:\"id_manufacturer\";s:2:\"23\";s:4:\"name\";s:13:\"Olivia Garden\";s:3:\"nbr\";s:1:\"6\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:8:\"quantity\";s:4:\"type\";s:8:\"quantity\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:2;}i:1;a:2:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:47;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"21\";s:6:\"values\";a:3:{i:563;a:12:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:10:\"Hair clips\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:6:\"custom\";s:1:\"0\";s:23:\"id_st_search_facet_item\";s:3:\"179\";s:18:\"facet_item_value_k\";s:3:\"563\";s:8:\"position\";s:2:\"10\";s:9:\"zhuangtai\";s:1:\"0\";s:3:\"img\";s:0:\"\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";}i:562;a:12:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:9:\"Hair ties\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:6:\"custom\";s:1:\"0\";s:23:\"id_st_search_facet_item\";s:3:\"179\";s:18:\"facet_item_value_k\";s:3:\"562\";s:8:\"position\";s:1:\"9\";s:9:\"zhuangtai\";s:1:\"0\";s:3:\"img\";s:0:\"\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";}i:558;a:12:{s:3:\"nbr\";s:2:\"44\";s:4:\"name\";s:7:\"Rollers\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:6:\"custom\";s:1:\"0\";s:23:\"id_st_search_facet_item\";s:3:\"179\";s:18:\"facet_item_value_k\";s:3:\"558\";s:8:\"position\";s:1:\"5\";s:9:\"zhuangtai\";s:1:\"0\";s:3:\"img\";s:0:\"\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";}}s:4:\"name\";s:11:\"Accessories\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}s:19:\"id_st_search_filter\";s:1:\"9\";}")
2324 ms 1 /modules/stfacetedsearch/src/Filters/Block.php:231
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12355 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 12355 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2279 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 12355
ORDER BY `position`
2231 ms 3 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 16 AND name = '_elementor_css_id_lang_1' LIMIT 1
2231 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_viewport_md' LIMIT 1
2160 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_disable_color_schemes' LIMIT 1
2144 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_lightbox_ui_color' LIMIT 1
2101 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-20 00:00:00',
INTERVAL 65 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7483
LIMIT 1
2024 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
2004 ms 847 /classes/Hook.php:1283
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-20 00:00:00',
INTERVAL 65 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7485
LIMIT 1
1963 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_default_generic_fonts' LIMIT 1
1961 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_enable_lightbox_in_editor' LIMIT 1
1927 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_global_image_lightbox' LIMIT 1
1826 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-20 00:00:00',
INTERVAL 65 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 12351
LIMIT 1
1816 ms 1 /classes/ProductAssembler.php:106
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12352 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 12352 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1796 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_page_title_selector' LIMIT 1
1789 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_viewport_lg' LIMIT 1
1777 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_lightbox_ui_color_hover' LIMIT 1
1761 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 612 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 612 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1755 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 17 AND name = '_elementor_css_id_lang_1' LIMIT 1
1753 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('4cee5ee772c804daa2f39a5e9942bcd9',"pageBuilder|16|17|category|38|1|3|3|1|21","akira", FROM_UNIXTIME(1713632026))
1729 ms 1 /classes/Smarty/SmartyCustom.php:265
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 17 AND name = '_wp_page_template_id_lang_1' LIMIT 1
1726 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 614 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 614 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1726 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE * 
FROM `ps_axon_creator_related` bc
LEFT JOIN `ps_axon_creator_related_shop` bcs
ON (bc.`id_axon_creator_related` = bcs.`id_axon_creator_related`)
WHERE bcs.`id_shop` = 1
AND bc.`post_type` = 'category'
AND bc.`key_related` = '38' LIMIT 1
1709 ms 26 /modules/axoncreator/src/Wp_Helper.php:1074
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-20 00:00:00',
INTERVAL 65 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7481
LIMIT 1
1708 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-20 00:00:00',
INTERVAL 65 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 12353
LIMIT 1
1704 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-20 00:00:00',
INTERVAL 65 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7482
LIMIT 1
1696 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-04-20 00:00:00',
INTERVAL 65 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 12352
LIMIT 1
1688 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_lightbox_color' LIMIT 1
1657 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7481 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 7481 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1641 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 16 AND name = '_wp_page_template_id_lang_1' LIMIT 1
1636 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7485 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 7485 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1607 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_disable_colorpicker_schemes' LIMIT 1
1603 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 3) AND `id_product` = 12352 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1601 ms 2 Yes /classes/SpecificPrice.php:561
UPDATE `ps_smarty_lazy_cache`
SET filepath='pageBuilder/18/category/38/1/3/3/1/21/akira/56/5f/a9/565fa91372212de3a2f1bfd1b1a465355e8bd0f9.axoncreatorviewstemplates.php'
WHERE `template_hash`='4cee5ee772c804daa2f39a5e9942bcd9' AND cache_id="pageBuilder|18|category|38|1|3|3|1|21" AND compile_id="akira"
1591 ms 1 /classes/Smarty/SmartyCustom.php:184
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 16 AND name = '_wp_page_template_id_lang_1' LIMIT 1
1575 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_viewport_md' LIMIT 1
1574 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_viewport_md' LIMIT 1
1556 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
1549 ms 128 Yes /classes/Manufacturer.php:207
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_disable_typography_schemes' LIMIT 1
1524 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 609 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 609 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1481 ms 0 /classes/Cart.php:1429
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12353 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 12353 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1470 ms 0 /classes/Cart.php:1429
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 600 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 600 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1458 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 3) AND `id_product` = 12353 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-04-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-04-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1454 ms 2 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 612
ORDER BY f.position ASC
1435 ms 1 Yes /classes/Product.php:5905
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 601 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 601 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1418 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE value FROM ps_axon_creator_meta WHERE id = 1 AND name = 'elementor_container_width' LIMIT 1
1411 ms 159 /modules/axoncreator/src/Wp_Helper.php:1188
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7481) AND (b.`id_shop` = 1) LIMIT 1
1407 ms 1 /src/Adapter/EntityMapper.php:76
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7484 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 7484 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1407 ms 0