By continuing use this site, you agree to the Terms & Conditions and our use of cookies.
Grace, Petite Graphite, Applique, Elements LightingGrace, Petite Graphite, Applique, Elements Lighting
  • New
Grace, Petite Graphite, Applique, Elements Lighting
€216.67
newGrace, Rubis, Suspension , Elements Lighting
  • New
Grace, Rubis, Suspension , Elements Lighting
€279.17
Grace, Rose Spinelle, Applique, Elements LightingGrace, Rose Spinelle, Applique, Elements Lighting
  • New
Grace, Rose Spinelle, Applique, Elements Lighting
€250.00
Grace Verrine Emeraude, Applique, Elements LightingGrace Verrine Emeraude, Applique, Elements Lighting
  • New
Grace Verrine Emeraude, Applique, Elements Lighting
€250.00
Genova, Bougie parfumée, Lumière du temps, 1400GRcopy of Sensory Delight, Scented Candle, Light of Time, 1400GR
  • New
copy of Sensory Delight, Scented Candle, Light of Time, 1400GR
€141.67
      Ambra Nera, Medium scented candle, Ortigia
      Ambra Nera, Medium scented candle, Ortigia
      Ambra Nera, Medium scented candle, Ortigia

      Ambra Nera, Medium scented candle, Ortigia

      Review (0)
      €31.67
      Tax Included

      A glass candle holder decorated with white wax enriched with a musky, ambery, and spicy fragrance.
      The signature impression of Ortigia creates an enchanting effect as the candle burns.

      Fragrance:

      Amber, Musk, and spices.

      Quantity :
      Write your review
      • DeliveryDelivery
      • Return PolicyReturn Policy

      Candle made with natural fragrances and ingredients: olive oil, vegetable glycerin, and organic colorants. No SLS, nickel, or silicone; products not tested on animals.

      Dimensions: Ø 7 cm x 8.5 cm

      Single wick candle

      Weight: 150g

      Burning time: Approximately 30-35 hours

      Ortigia
      2164

      Specific References

      Write your review

      No customer reviews for the moment.

      Write your review
      Ambra Nera, Medium scented candle, Ortigia
      Ambra Nera, Medium scented candle, Ortigia
      Load Time 117.761 ms
      Querying Time 48 ms
      Queries 366
      Memory Peak Usage 14.8 Mb
      Included Files 1455 files - 15.17 Mb
      PrestaShop Cache - Mb
      Global vars 0.22 Mb
      PrestaShop Version 8.2.0
      PHP Version 8.1.27
      MySQL Version 10.11.9-MariaDB
      Memory Limit 12288M
      Max Execution Time 480s
      Smarty Cache enabled
      Smarty Compilation auto
        Time Cumulated Time Memory Usage Memory Peak Usage
      config 6.909 ms 6.909 ms 3.69 Mb 3.9 Mb
      __construct 0.008 ms 6.917 ms - Mb 3.9 Mb
      init 17.014 ms 23.931 ms 1.60 Mb 5.8 Mb
      checkAccess 0.001 ms 23.932 ms - Mb 5.8 Mb
      setMedia 8.413 ms 32.345 ms 0.46 Mb 5.8 Mb
      postProcess 0.003 ms 32.348 ms - Mb 5.8 Mb
      initHeader 0.001 ms 32.349 ms - Mb 5.8 Mb
      initContent 24.409 ms 56.758 ms 1.57 Mb 7.3 Mb
      initFooter 0.002 ms 56.760 ms - Mb 7.3 Mb
      display 61.001 ms 117.761 ms 7.30 Mb 14.8 Mb
      Hook Time Memory Usage
      DisplayAfterBodyOpeningTag 23.674 ms 2.75 Mb
      ActionFrontControllerSetMedia 7.921 ms 0.41 Mb
      DisplayMegamenu 5.992 ms 0.82 Mb
      FilterProductContent 5.279 ms 0.22 Mb
      displayFooterPart1 4.508 ms 0.87 Mb
      DisplayHeader 3.399 ms 0.13 Mb
      DisplayReviewProductList 3.016 ms 0.47 Mb
      displayMyaccountcblock 2.963 ms 0.19 Mb
      displaySocialMediaBlock 2.524 ms 0.14 Mb
      DisplayBeforeBodyClosingTag 1.996 ms 0.18 Mb
      DisplayFooterCategory 1.400 ms 0.33 Mb
      DisplayNavSearchBlock 1.345 ms 0.13 Mb
      DisplayProductListReviewsTabContent 1.206 ms 0.22 Mb
      displayFooterProduct 0.897 ms 0.11 Mb
      Header 0.863 ms 0.05 Mb
      DisplayCustomsocialblock 0.845 ms 0.14 Mb
      displayNav1 0.762 ms 0.09 Mb
      displayNavLanguageBlock 0.674 ms 0.07 Mb
      displayNavShoppingCartBlock 0.564 ms 0.08 Mb
      displayProductAdditionalInfo 0.503 ms 0.07 Mb
      DisplayProductTabVideo 0.476 ms 0.02 Mb
      displayContactCinfo 0.456 ms 0.04 Mb
      DisplayPaymentIcon 0.449 ms 0.06 Mb
      ActionDispatcher 0.419 ms - Mb
      displayNavCustomerSignInBlock 0.386 ms 0.05 Mb
      ActionDispatcherBefore 0.362 ms 0.01 Mb
      DisplayNavWishlistBlock 0.356 ms 0.10 Mb
      ActionObjectAddAfter 0.349 ms 0.01 Mb
      displayNewslettersubscription 0.327 ms 0.05 Mb
      DisplayReassurance 0.299 ms 0.04 Mb
      DisplayNavWishlistBlocksticky 0.283 ms 0.04 Mb
      displayNavCurrencyBlock 0.192 ms 0.05 Mb
      DisplayProductExtraContent 0.157 ms 0.01 Mb
      DisplayMyAccountBlock 0.147 ms 0.01 Mb
      DisplayNavProductCompareBlock 0.139 ms 0.01 Mb
      DisplayCopyRightText 0.133 ms 0.02 Mb
      DisplayWishlistProductPage 0.131 ms 0.01 Mb
      DisplayCustomtab 0.131 ms 0.02 Mb
      DisplayProductComparesticky 0.130 ms 0.01 Mb
      DisplayProductCompareProductPage 0.118 ms 0.01 Mb
      DisplayProductListReviewsTab 0.109 ms 0.01 Mb
      DisplayFooter 0.094 ms 0.02 Mb
      ModuleRoutes 0.030 ms 0.02 Mb
      DisplayNavFullWidth 0.016 ms - Mb
      DisplayProductAdditionalInfo 0.010 ms - Mb
      DisplayTopOfferText 0.009 ms - Mb
      DisplayDownloadApps 0.006 ms - Mb
      DisplayCustomCss 0.005 ms - Mb
      DisplayProductPageStockIndicator 0.004 ms - Mb
      DisplayCustomJs 0.004 ms - Mb
      50 hook(s) 76.059 ms 8.06 Mb
      Module Time Memory Usage
      pm_advancedsearch4 1.942 ms 0.03 Mb
      tvcmsblog 1.526 ms 0.16 Mb
      ps_checkout 8.513 ms 0.46 Mb
      advancedemailguard 1.395 ms 0.09 Mb
      ps_mbo 2.010 ms 0.05 Mb
      wkpos 1.017 ms 0.04 Mb
      ps_accounts 0.612 ms 0.09 Mb
      blockreassurance 0.423 ms 0.06 Mb
      ps_emailsubscription 0.400 ms 0.06 Mb
      ps_socialfollow 2.584 ms 0.15 Mb
      ps_emailalerts 0.103 ms 0.01 Mb
      tvcmsvideotab 0.712 ms 0.04 Mb
      productcomments 5.420 ms 0.23 Mb
      ps_searchbar 0.178 ms 0.01 Mb
      ps_shoppingcart 0.619 ms 0.09 Mb
      tvcmsadvanceblock 0.133 ms 0.01 Mb
      tvcmsbestsellerproducts 0.110 ms 0.01 Mb
      tvcmsblogdisplayposts 0.133 ms 0.01 Mb
      tvcmsbrandlist 0.116 ms 0.01 Mb
      tvcmscategorychainslider 0.117 ms 0.01 Mb
      tvcmscategoryslider 0.113 ms 0.01 Mb
      tvcmscookiesnotice 0.272 ms 0.08 Mb
      tvcmscustomerservices 0.109 ms 0.01 Mb
      tvcmscustomsetting 1.379 ms 0.20 Mb
      tvcmsfeaturedproducts 0.082 ms 0.01 Mb
      tvcmsfooterlogo 0.066 ms 0.01 Mb
      tvcmsfooterproduct 0.079 ms 0.01 Mb
      tvcmsnewproducts 0.069 ms 0.01 Mb
      tvcmsnewsletterpopup 0.148 ms 0.01 Mb
      tvcmspaymenticon 0.518 ms 0.07 Mb
      tvcmsproductcomments 4.550 ms 0.72 Mb
      tvcmsproductcompare 0.480 ms 0.03 Mb
      tvcmsproductpopup 23.591 ms 2.75 Mb
      tvcmssearch 1.484 ms 0.14 Mb
      tvcmssizechart 0.226 ms 0.02 Mb
      tvcmsslider 0.135 ms 0.01 Mb
      tvcmsspecialproducts 0.074 ms 0.01 Mb
      tvcmsstockinfo 0.101 ms 0.01 Mb
      tvcmstabproducts 0.097 ms 0.01 Mb
      tvcmstestimonial 0.107 ms 0.01 Mb
      tvcmsthemeoptions 0.172 ms 0.01 Mb
      tvcmswishlist 1.036 ms 0.17 Mb
      ps_googleanalytics 0.472 ms 0.03 Mb
      tvcmsinfinitescroll 0.283 ms 0.02 Mb
      tvcmsofferbanner 0.134 ms 0.01 Mb
      tvcmscategoryproduct 0.132 ms 0.01 Mb
      tvcmsmegamenu 6.138 ms 0.82 Mb
      tvcmscustomcssjs 0.088 ms 0.01 Mb
      ps_languageselector 0.726 ms 0.07 Mb
      ps_currencyselector 0.238 ms 0.05 Mb
      ps_customersignin 0.428 ms 0.05 Mb
      ps_contactinfo 1.269 ms 0.14 Mb
      ps_sharebuttons 0.553 ms 0.08 Mb
      ps_crossselling 0.948 ms 0.12 Mb
      tvcmsfootercategory 1.477 ms 0.33 Mb
      ps_linklist 4.709 ms 0.88 Mb
      ps_customeraccountlinks 3.014 ms 0.20 Mb
      statsdata 2.029 ms 0.18 Mb
      dgtranslationall 0.332 ms 0.01 Mb
      59 module(s) 85.920 ms 8.91 Mb

      Stopwatch SQL - 366 queries

      # Query Time (ms) Rows Filesort Group By Location
      139 
      SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
(DATEDIFF(product_shop.`date_add`,
DATE_SUB(
"2024-12-06 00:00:00",
INTERVAL 8 DAY
)
) > 0) as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 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` = 2
LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
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  )
WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`,
DATE_SUB(
"2024-12-06 00:00:00",
INTERVAL 8 DAY
)
) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1)
WHERE cp.`id_product` = p.`id_product`))
ORDER BY product_shop.`date_add` DESC
LIMIT 5
      		 2.920 ms 200448 Yes /classes/Product.php:3110
      2 
      SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
      		 2.139 ms 2115 /classes/Configuration.php:180
      62 
      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
      		 1.288 ms 746 /classes/Hook.php:456
      16 
      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_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 (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
      		 1.134 ms 214 Yes Yes /classes/Hook.php:1267
      61 
      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
      		 0.928 ms 0 /classes/Hook.php:1326
      240 
      SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
      		 0.739 ms 18 Yes /classes/Category.php:799
      88 
      SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 11
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
      		 0.676 ms 1 Yes Yes /classes/Category.php:924
      98 
      SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-06 00:00:00",
INTERVAL 8 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
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_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.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` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
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  )
WHERE `id_product_1` = 143 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
      		 0.435 ms 1 Yes /classes/Product.php:4702
      0 
      SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.hippotigre.com' OR su.domain_ssl = 'www.hippotigre.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
      		 0.432 ms 1 Yes /classes/shop/Shop.php:1364
      112 
      SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 143
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
      		 0.382 ms 1 Yes Yes /classes/Product.php:4598
      187 
      SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-06 00:00:00',
INTERVAL 8 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 = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
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 IN (528)
      		 0.382 ms 1 /classes/ProductAssembler.php:64
      83 
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
      		 0.368 ms 145 /classes/module/Module.php:346
      24 
      SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
      		 0.345 ms 146 Yes /classes/Dispatcher.php:654
      292 
      SELECT SQL_NO_CACHE pcc.`id_tvcmsproduct_comment_criterion`, pccl.`name`
FROM `ps_tvcmsproduct_comment_criterion` pcc
LEFT JOIN `ps_tvcmsproduct_comment_criterion_lang` pccl
ON (pcc.id_tvcmsproduct_comment_criterion = pccl.id_tvcmsproduct_comment_criterion)
LEFT JOIN `ps_tvcmsproduct_comment_criterion_product` pccp
ON (pcc.`id_tvcmsproduct_comment_criterion` = pccp.`id_tvcmsproduct_comment_criterion` AND pccp.`id_product` = 143)
LEFT JOIN `ps_tvcmsproduct_comment_criterion_category` pccc
ON (pcc.`id_tvcmsproduct_comment_criterion` = pccc.`id_tvcmsproduct_comment_criterion`)
LEFT JOIN `ps_product_shop` ps
ON (ps.id_category_default = pccc.id_category AND ps.id_product = 143)
WHERE pccl.`id_lang` = 2
AND (
pccp.id_product IS NOT NULL
OR ps.id_product IS NOT NULL
OR pcc.id_tvcmsproduct_comment_criterion_type = 1
)
AND pcc.active = 1
GROUP BY pcc.id_tvcmsproduct_comment_criterion
      		 0.300 ms 1 Yes /modules/tvcmsproductcomments/tvcmsproductcommentcriterion.php:197
      15 
      SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
      		 0.289 ms 1106 /classes/Hook.php:1366
      131 
      SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
      		 0.268 ms 1 /classes/Cart.php:4255
      18 
      SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
      		 0.259 ms 1106 /classes/Hook.php:1326
      115 
      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` = 143) AND (b.`id_shop` = 1) LIMIT 1
      		 0.256 ms 1 /src/Adapter/EntityMapper.php:71
      214 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 528
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.252 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:224
      100 
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 143 UNION SELECT 0 as first_level_quantity, SUM(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` = 143 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
      		 0.250 ms 0 /classes/Cart.php:1430
      111 
      SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 12) LIMIT 1
      		 0.249 ms 1 /src/Adapter/EntityMapper.php:71
      19 
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
      		 0.241 ms 145 /classes/module/Module.php:346
      97 
      SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 143
      		 0.239 ms 1 /classes/Product.php:7563
      192 
      SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-06 00:00:00',
INTERVAL 8 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 = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
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 IN (527)
      		 0.239 ms 1 /classes/ProductAssembler.php:64
      125 
      SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search`
FROM `ps_pm_advancedsearch` ads
JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1)  WHERE 1  AND ads.`active`=1  ORDER BY ads.`position`
      		 0.236 ms 2 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
      359 
      SELECT SQL_NO_CACHE mainTable.id_tvcmspaymenticon AS code,
mainTable.image,
mainTable.link,
subTable.title
FROM 
`ps_tvcmspaymenticon` mainTable
LEFT JOIN
ps_tvcmspaymenticon_lang subTable
ON
mainTable.id_tvcmspaymenticon = subTable.id_tvcmspaymenticon
WHERE 
mainTable.id_shop_group = 1 
AND 
mainTable.id_shop = 1
AND 
mainTable.status = 1
AND
subTable.id_lang = 2
ORDER BY `position`
      		 0.235 ms 8 Yes /modules/tvcmspaymenticon/tvcmspaymenticon.php:435
      26 
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
      		 0.234 ms 145 /classes/module/Module.php:346
      278 
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
      		 0.234 ms 1 /classes/module/Module.php:2659
      218 
      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 `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (528) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
      		 0.230 ms 1 Yes Yes /classes/Product.php:4524
      281 
      SELECT SQL_NO_CACHE * FROM ps_url_video WHERE id_product='143' AND id_lang='2' AND id_store='1'
      		 0.230 ms 1 /modules/tvcmsvideotab/tvcmsvideotab.php:297
      197 
      SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-06 00:00:00',
INTERVAL 8 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 = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
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 IN (526)
      		 0.229 ms 1 /classes/ProductAssembler.php:64
      21 
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
      		 0.228 ms 145 /classes/module/Module.php:346
      104 
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 143 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 143 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
      		 0.226 ms 0 /classes/Cart.php:1430
      202 
      SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-06 00:00:00',
INTERVAL 8 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 = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
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 IN (525)
      		 0.225 ms 1 /classes/ProductAssembler.php:64
      207 
      SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-06 00:00:00',
INTERVAL 8 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 = 2
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
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 IN (523)
      		 0.225 ms 1 /classes/ProductAssembler.php:64
      185 
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 523 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 523 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
      		 0.223 ms 0 /classes/Cart.php:1430
      282 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 143
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.221 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:224
      22 
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
      		 0.221 ms 145 /classes/module/Module.php:346
      58 
      SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 143) AND (b.`id_shop` = 1) LIMIT 1
      		 0.220 ms 1 /src/Adapter/EntityMapper.php:71
      236 
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
      		 0.217 ms 1 /classes/module/Module.php:2659
      167 
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 526 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 526 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
      		 0.216 ms 0 /classes/Cart.php:1430
      361 
      SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 2268662
AND `date_add` > '2024-12-06 11:38:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
      		 0.216 ms 1 Yes /classes/Connection.php:168
      17 
      SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
      		 0.215 ms 88 /classes/Hook.php:287
      23 
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
      		 0.214 ms 145 /classes/module/Module.php:346
      33 
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
      		 0.212 ms 145 /classes/module/Module.php:346
      1 
      SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
      		 0.209 ms 1 Yes /classes/shop/Shop.php:715
      299 
      SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (143)
ORDER BY o.id_order DESC
LIMIT 400
      		 0.208 ms 1 Yes /modules/ps_crossselling/ps_crossselling.php:257
      234 
      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 `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (523) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
      		 0.208 ms 1 Yes Yes /classes/Product.php:4524
      226 
      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 `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (526) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
      		 0.206 ms 1 Yes Yes /classes/Product.php:4524
      222 
      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 `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (527) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
      		 0.206 ms 1 Yes Yes /classes/Product.php:4524
      89 
      SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
      		 0.204 ms 18 Yes Yes /classes/Category.php:1151
      364 
      INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('2268662', '189', '308350547', '', '1', '1', '2024-12-06 12:08:18')
      		 0.204 ms 1 /classes/ObjectModel.php:622
      230 
      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 `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (525) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
      		 0.203 ms 1 Yes Yes /classes/Product.php:4524
      319 
      SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps_link_block lb
INNER JOIN ps_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 1033 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
      		 0.203 ms 1 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
      149 
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 528 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 528 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
      		 0.202 ms 0 /classes/Cart.php:1430
      140 
      SELECT SQL_NO_CACHE id_product, name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE `id_product` IN (528,527,526,525,523)
ORDER BY f.position ASC
      		 0.199 ms 45 Yes /classes/Product.php:4904
      96 
      SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-06 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-06 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
      		 0.196 ms 2 Yes /classes/SpecificPrice.php:656
      105 
      SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 143
ORDER BY f.position ASC
      		 0.196 ms 1 Yes /classes/Product.php:6021
      365 
      INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('2186061', '', 'www.hippotigre.com/en/scented-candles/143-ambra-nera-medium-scented-candle-ortigia-8052862000171.html', '', '2024-12-06 12:08:18')
      		 0.194 ms 1 /classes/ObjectModel.php:622
      159 
      SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 527
ORDER BY f.position ASC
      		 0.192 ms 1 Yes /classes/Product.php:6021
      176 
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 525 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 525 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
      		 0.184 ms 0 /classes/Cart.php:1430
      254 
      SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 17
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
      		 0.183 ms 5 Yes Yes /classes/Category.php:1151
      158 
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 527 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 527 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
      		 0.181 ms 0 /classes/Cart.php:1430
      63 
      SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
      		 0.180 ms 1 /classes/tax/TaxRulesTaxManager.php:109
      188 
      SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 528) AND (b.`id_shop` = 1) LIMIT 1
      		 0.173 ms 1 /src/Adapter/EntityMapper.php:71
      186 
      SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 523
ORDER BY f.position ASC
      		 0.171 ms 1 Yes /classes/Product.php:6021
      249 
      SELECT SQL_NO_CACHE main.*, ll.*
FROM ps_tvcmsmegamenu_shop main
LEFT JOIN `ps_tvcmsmegamenu_lang` ll ON (ll.`id_tvcmsmegamenu` = main.`id_tvcmsmegamenu` AND main.`id_shop` = ll.`id_shop`)
WHERE main.active = 1 AND ll.id_shop = 1 AND ll.id_lang=2 ORDER BY main.position ASC, main.id_tvcmsmegamenu ASC
      		 0.171 ms 8 Yes /modules/tvcmsmegamenu/classes/tvcmsmegamenuclass.php:265
      106 
      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` = 2)
WHERE i.`id_product` = 143
ORDER BY `position`
      		 0.170 ms 2 Yes /classes/Product.php:3545
      209 
      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` = 2)
WHERE i.`id_product` = 523
ORDER BY `position`
      		 0.169 ms 3 Yes /classes/Product.php:3545
      208 
      SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 523) AND (b.`id_shop` = 1) LIMIT 1
      		 0.167 ms 1 /src/Adapter/EntityMapper.php:71
      339 
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
      		 0.166 ms 1 /classes/module/Module.php:2659
      198 
      SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 526) AND (b.`id_shop` = 1) LIMIT 1
      		 0.165 ms 1 /src/Adapter/EntityMapper.php:71
      203 
      SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 525) AND (b.`id_shop` = 1) LIMIT 1
      		 0.165 ms 1 /src/Adapter/EntityMapper.php:71
      31 
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "wkposloyalty" LIMIT 1
      		 0.164 ms 0 /classes/module/Module.php:2659
      193 
      SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 527) AND (b.`id_shop` = 1) LIMIT 1
      		 0.164 ms 1 /src/Adapter/EntityMapper.php:71
      189 
      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` = 2)
WHERE i.`id_product` = 528
ORDER BY `position`
      		 0.161 ms 2 Yes /classes/Product.php:3545
      291 
      SELECT SQL_NO_CACHE pc.`id_tvcmsproduct_comment`,
(SELECT count(*) FROM `ps_tvcmsproduct_comment_usefulness` pcu WHERE pcu.`id_tvcmsproduct_comment` = pc.`id_tvcmsproduct_comment` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `ps_tvcmsproduct_comment_usefulness` pcu WHERE pcu.`id_tvcmsproduct_comment` = pc.`id_tvcmsproduct_comment`) as total_advice, 
IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `ps_tvcmsproduct_comment` pc
LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 143 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
      		 0.156 ms 1 Yes /modules/tvcmsproductcomments/tvcmsproductcomment.php:138
      168 
      SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 526
ORDER BY f.position ASC
      		 0.154 ms 1 Yes /classes/Product.php:6021
      4 
      SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
      		 0.153 ms 1 /classes/shop/Shop.php:218
      199 
      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` = 2)
WHERE i.`id_product` = 526
ORDER BY `position`
      		 0.152 ms 2 Yes /classes/Product.php:3545
      204 
      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` = 2)
WHERE i.`id_product` = 525
ORDER BY `position`
      		 0.152 ms 2 Yes /classes/Product.php:3545
      194 
      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` = 2)
WHERE i.`id_product` = 527
ORDER BY `position`
      		 0.151 ms 2 Yes /classes/Product.php:3545
      346 
      SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
      		 0.150 ms 1 /classes/Country.php:405
      177 
      SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 525
ORDER BY f.position ASC
      		 0.149 ms 1 Yes /classes/Product.php:6021
      241 
      SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
      		 0.147 ms 4 /classes/Category.php:2242
      150 
      SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 528
ORDER BY f.position ASC
      		 0.147 ms 1 Yes /classes/Product.php:6021
      102 
      SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 143
AND image_shop.`cover` = 1 LIMIT 1
      		 0.144 ms 2 /classes/Product.php:3570
      268 
      SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
      		 0.141 ms 2 /classes/Meta.php:193
      116 
      SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 11 LIMIT 1
      		 0.140 ms 1 /classes/Category.php:1378
      11 
      SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
      		 0.135 ms 16 /classes/Language.php:1216
      271 
      SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 8) AND (b.`id_shop` = 1) LIMIT 1
      		 0.135 ms 1 /src/Adapter/EntityMapper.php:71
      85 
      SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 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
      		 0.134 ms 0 /classes/tax/TaxRulesTaxManager.php:109
      328 
      SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
      		 0.134 ms 4 /src/Adapter/EntityMapper.php:79
      280 
      SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
      		 0.131 ms 1 /classes/Country.php:405
      163 
      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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 526)
      		 0.128 ms 1 /classes/Product.php:3860
      36 
      SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
      		 0.127 ms 3 Yes /classes/Currency.php:709
      81 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) AND (b.`id_shop` = 1) LIMIT 1
      		 0.127 ms 1 /src/Adapter/EntityMapper.php:71
      68 
      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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 143)
      		 0.127 ms 1 /classes/Product.php:3860
      360 
      INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
      		 0.124 ms 1 /classes/ObjectModel.php:622
      132 
      SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2024-12-06 00:00:00" AND date_to <= "2024-12-06 23:59:59") OR (date_from >= "2024-12-06 00:00:00" AND date_from <= "2024-12-06 23:59:59") OR (date_from < "2024-12-06 00:00:00" AND date_to > "2024-12-06 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
      		 0.123 ms 1 /classes/CartRule.php:357
      287 
      SELECT SQL_NO_CACHE * FROM `ps_psreassurance` pr
LEFT JOIN ps_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "2"
AND pr.status = 1
ORDER BY pr.position
      		 0.123 ms 2 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
      250 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) AND (b.`id_shop` = 1) LIMIT 1
      		 0.120 ms 1 /src/Adapter/EntityMapper.php:71
      245 
      SELECT SQL_NO_CACHE count(id_wishlist_product) FROM ps_wishlist w, ps_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=0 LIMIT 1
      		 0.120 ms 8 /modules/tvcmswishlist/tvcmswishlist.php:279
      242 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
      		 0.119 ms 1 /src/Adapter/EntityMapper.php:71
      6 
      SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
      		 0.118 ms 1 /src/Adapter/EntityMapper.php:71
      65 
      SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 143 LIMIT 1
      		 0.118 ms 1 /classes/Product.php:1106
      289 
      SELECT SQL_NO_CACHE pc.`id_tvcmsproduct_comment`, pcg.`grade`, pccl.`name`, pcc.`id_tvcmsproduct_comment_criterion`
FROM `ps_tvcmsproduct_comment` pc
LEFT JOIN `ps_tvcmsproduct_comment_grade` pcg ON (pcg.`id_tvcmsproduct_comment` = pc.`id_tvcmsproduct_comment`)
LEFT JOIN `ps_tvcmsproduct_comment_criterion` pcc ON (pcc.`id_tvcmsproduct_comment_criterion` = pcg.`id_tvcmsproduct_comment_criterion`)
LEFT JOIN `ps_tvcmsproduct_comment_criterion_lang` pccl ON (pccl.`id_tvcmsproduct_comment_criterion` = pcg.`id_tvcmsproduct_comment_criterion`)
WHERE pc.`id_product` = 143
AND pccl.`id_lang` = 2 AND pc.`validate` = 1
      		 0.117 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:197
      122 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 4) AND (a0.`nright` > 5) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
      		 0.116 ms 3 /classes/PrestaShopCollection.php:383
      256 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
      		 0.116 ms 1 /src/Adapter/EntityMapper.php:71
      84 
      SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `ps_pscheckout_funding_source`
WHERE `id_shop` = 1
      		 0.114 ms 12 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:90
      64 
      SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 143
AND DATEDIFF("2024-12-06 00:00:00", product_shop.`date_add`) < 8 LIMIT 1
      		 0.112 ms 0 /classes/Product.php:1732
      145 
      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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 528)
      		 0.112 ms 1 /classes/Product.php:3860
      272 
      SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 8) AND (b.`id_shop` = 1) LIMIT 1
      		 0.112 ms 1 /src/Adapter/EntityMapper.php:71
      80 
      SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 143 AND ctg.`id_group` = 1 LIMIT 1
      		 0.110 ms 2 /classes/Product.php:6740
      253 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) AND (b.`id_shop` = 1) LIMIT 1
      		 0.109 ms 1 /src/Adapter/EntityMapper.php:71
      259 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1
      		 0.109 ms 1 /src/Adapter/EntityMapper.php:71
      66 
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
      		 0.108 ms 1 /classes/SpecificPrice.php:426
      141 
      SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 528
AND image_shop.`cover` = 1 LIMIT 1
      		 0.108 ms 2 /classes/Product.php:3570
      52 
      SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
      		 0.107 ms 1 /src/Adapter/EntityMapper.php:71
      55 
      SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
      		 0.107 ms 1 /src/Adapter/EntityMapper.php:71
      99 
      SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 143
      		 0.106 ms 1 /classes/Product.php:7496
      160 
      SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 526
AND image_shop.`cover` = 1 LIMIT 1
      		 0.106 ms 2 /classes/Product.php:3570
      40 
      SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
      		 0.105 ms 1 /src/Adapter/EntityMapper.php:71
      90 
      SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 143
      		 0.105 ms 1 /classes/Product.php:7496
      109 
      SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
      		 0.104 ms 13 Yes /classes/ImageType.php:109
      235 
      UPDATE `ps_smarty_lazy_cache`
SET filepath='module_tvcmsproductpopup_views_templates_hook_tvcmsproductpopup_footer/1/1/1/2/21/v1_ceramic_42/f0/54/f6/f054f695d8f6f4e463c9111c680d6fa5e6a6d080.tvcmsproductpopup_footer.tpl.php'
WHERE `template_hash`='770c5df71969d131c4a2027243adc9fe' AND cache_id="module:tvcmsproductpopup/views/templates/hook/tvcmsproductpopup_footer|1|1|1|2|21" AND compile_id="v1_ceramic_42"
      		 0.104 ms 1 /classes/Smarty/SmartyCustom.php:184
      262 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) AND (b.`id_shop` = 1) LIMIT 1
      		 0.104 ms 1 /src/Adapter/EntityMapper.php:71
      277 
      UPDATE `ps_smarty_lazy_cache`
SET filepath='tvcmsmegamenu/1/1/1/2/21/v1_ceramic_42/e3/bc/86/e3bc8672c64488dbeb2396b62a81aac9897522bd.tvcmsmegamenuviewstemplateshookdisplay_menu.tpl.php'
WHERE `template_hash`='f17cbc7b703e45236bac963ff24705ac' AND cache_id="tvcmsmegamenu|1|1|1|2|21" AND compile_id="v1_ceramic_42"
      		 0.103 ms 1 /classes/Smarty/SmartyCustom.php:184
      265 
      SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
      		 0.102 ms 1 /src/Adapter/EntityMapper.php:71
      72 
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=143
      		 0.100 ms 1 /classes/Tag.php:244
      73 
      SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 143) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      		 0.099 ms 1 /classes/stock/StockAvailable.php:453
      219 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 527
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.099 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:224
      5 
      SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
      		 0.098 ms 4 /classes/Language.php:1080
      133 
      SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2024-12-06 00:00:00" AND date_to <= "2024-12-06 23:59:59") OR (date_from >= "2024-12-06 00:00:00" AND date_from <= "2024-12-06 23:59:59") OR (date_from < "2024-12-06 00:00:00" AND date_to > "2024-12-06 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
      		 0.098 ms 1 /classes/CartRule.php:357
      169 
      SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 525
AND image_shop.`cover` = 1 LIMIT 1
      		 0.098 ms 2 /classes/Product.php:3570
      178 
      SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 523
AND image_shop.`cover` = 1 LIMIT 1
      		 0.098 ms 3 /classes/Product.php:3570
      223 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 526
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.098 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:224
      38 
      SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
      		 0.097 ms 1 /classes/shop/Shop.php:1183
      137 
      INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('341841b5ecb685baedc68e1a9dc15603',"module:tvcmsproductpopup/views/templates/hook/tvcmsproductpopup_footer|1|1|1|2|21","v1_ceramic_42", FROM_UNIXTIME(1733483298))
      		 0.097 ms 1 /classes/Smarty/SmartyCustom.php:265
      231 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 523
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.097 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:224
      151 
      SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 527
AND image_shop.`cover` = 1 LIMIT 1
      		 0.096 ms 2 /classes/Product.php:3570
      227 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 525
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.096 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:224
      172 
      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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 525)
      		 0.096 ms 1 /classes/Product.php:3860
      39 
      SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'ARS') LIMIT 1
      		 0.095 ms 1 /classes/Currency.php:893
      212 
      SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='770c5df71969d131c4a2027243adc9fe' AND cache_id="module:tvcmsproductpopup/views/templates/hook/tvcmsproductpopup_footer|1|1|1|2|21" AND compile_id="v1_ceramic_42" LIMIT 1
      		 0.095 ms 1 /classes/Smarty/SmartyCustom.php:216
      154 
      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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 527)
      		 0.095 ms 1 /classes/Product.php:3860
      181 
      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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 523)
      		 0.095 ms 1 /classes/Product.php:3860
      215 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 528
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.093 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:212
      248 
      SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `ps_cart_product`
WHERE `id_cart` = 0 LIMIT 1
      		 0.093 ms 1 /classes/Cart.php:1303
      288 
      SELECT SQL_NO_CACHE *
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 143
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
      		 0.093 ms 1 Yes /modules/tvcmsproductcomments/tvcmsproductcomment.php:161
      297 
      INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('9a8a14ff9ef71e4773a81d1e266f729f',"ps_crossselling|143|1|1|1|2|21","v1_ceramic_42", FROM_UNIXTIME(1733483298))
      		 0.092 ms 1 /classes/Smarty/SmartyCustom.php:265
      59 
      SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 12
AND `active` = 1 LIMIT 1
      		 0.091 ms 1 /classes/Manufacturer.php:316
      134 
      SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
      		 0.091 ms 3 /classes/Currency.php:1136
      184 
      SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 523) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      		 0.091 ms 1 /classes/stock/StockAvailable.php:453
      78 
      SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 143
      		 0.091 ms 1 /classes/Product.php:7496
      101 
      SELECT SQL_NO_CACHE * FROM ps_url_video WHERE id_product='143' AND id_lang='2' AND id_store='1'
      		 0.090 ms 1 /modules/tvcmsvideotab/tvcmsvideotab.php:365
      224 
      SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_tvcmsproduct_comment` pc
WHERE pc.`id_product` = 526
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
      		 0.089 ms 1 /modules/tvcmsproductcomments/tvcmsproductcomment.php:212
      338 
      UPDATE `ps_smarty_lazy_cache`
SET filepath='ps_linklist/displayFooterPart1/1/1/1/2/21/v1_ceramic_42/82/18/cb/8218cb27b6e9af58aa63f5d08f1e264cccbb578c.ps_linklistviewstemplateshooklinkblock.tpl.php'
WHERE `template_hash`='14f3e6d3f5719f729bfd1d7275ccfb82' AND cache_id="ps_linklist|displayFooterPart1|1|1|1|2|21" AND compile_id="v1_ceramic_42"
      		 0.089 ms 1 /classes/Smarty/SmartyCustom.php:184