Cream & Cleansing Milk

Active filters

Load Time 384.631 ms
Querying Time 235 ms
Queries 276
Memory Peak Usage 10.2 Mb
Included Files 1095 files - 12.15 Mb
PrestaShop Cache - Mb
Global vars 0.09 Mb
PrestaShop Version 8.1.4
PHP Version 8.1.30
MySQL Version 8.0.18-9
Memory Limit 256M
Max Execution Time 180s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 2.848 ms 2.848 ms 2.19 Mb 2.6 Mb
__construct 0.021 ms 2.869 ms - Mb 2.6 Mb
init 16.082 ms 18.951 ms 0.43 Mb 3.1 Mb
checkAccess 0.002 ms 18.953 ms - Mb 3.1 Mb
setMedia 3.472 ms 22.425 ms 0.18 Mb 3.1 Mb
postProcess 0.002 ms 22.427 ms - Mb 3.1 Mb
initHeader 0.001 ms 22.428 ms - Mb 3.1 Mb
initContent 190.342 ms 212.770 ms 3.63 Mb 6.5 Mb
initFooter 0.003 ms 212.773 ms - Mb 6.5 Mb
display 171.858 ms 384.631 ms 3.40 Mb 10.2 Mb
Hook Time Memory Usage
DisplayProductListReviews 40.856 ms 0.10 Mb
DisplayCzHoverImage 29.586 ms 0.43 Mb
DisplayBeforeBodyClosingTag 21.422 ms 0.33 Mb
displayLeftColumn 14.485 ms 0.32 Mb
DisplayHeader 11.555 ms 0.44 Mb
displayNavFullWidth 6.713 ms 0.56 Mb
displayFooter 6.424 ms 0.31 Mb
displayNav1 5.750 ms 0.17 Mb
DisplayFooter 5.096 ms 0.06 Mb
displayTop 2.657 ms 0.15 Mb
DisplayStWishlistButton 2.556 ms 0.01 Mb
DisplayStCompareButton 2.236 ms 0.01 Mb
displayFooterBefore 1.415 ms 0.05 Mb
displayFooterAfter 1.373 ms 0.05 Mb
displayNav2 1.162 ms 0.05 Mb
ActionDispatcherBefore 0.648 ms 0.01 Mb
ActionFrontControllerSetMedia 0.565 ms 0.01 Mb
ProductSearchProvider 0.458 ms - Mb
DisplayStCompareTopLink 0.324 ms 0.01 Mb
DisplayLeftColumn 0.319 ms 0.04 Mb
DisplayContentWrapperBottom 0.104 ms - Mb
21 hook(s) 155.704 ms 3.13 Mb
Module Time Memory Usage
ps_mbo 5.550 ms 0.06 Mb
blockreassurance 1.501 ms 0.14 Mb
ps_emailsubscription 1.420 ms 0.06 Mb
ps_socialfollow 1.582 ms 0.06 Mb
ps_emailalerts 0.195 ms 0.01 Mb
ps_facebook 8.445 ms 0.29 Mb
ps_shoppingcart 0.721 ms 0.05 Mb
ps_searchbar 1.237 ms 0.05 Mb
ps_googleanalytics 8.755 ms 0.11 Mb
cz_imageslider 0.259 ms 0.01 Mb
czcouponpop 0.133 ms 0.01 Mb
ps_accounts 0.262 ms 0.01 Mb
azameo 0.521 ms 0.02 Mb
psxmarketingwithgoogle 0.500 ms 0.01 Mb
chatyprestashop 0.417 ms 0.01 Mb
cz_verticalmenu 5.044 ms 0.47 Mb
myprestacomments 42.247 ms 0.20 Mb
psproductcountdown 1.149 ms 0.07 Mb
stfeature 5.903 ms 0.06 Mb
ps_facetedsearch 1.099 ms 0.06 Mb
ps_languageselector 1.617 ms 0.06 Mb
ps_currencyselector 0.661 ms 0.05 Mb
cz_navcmsblock 3.897 ms 0.08 Mb
cz_toplink 1.313 ms 0.06 Mb
ps_customersignin 1.404 ms 0.07 Mb
ps_mainmenu 1.093 ms 0.06 Mb
cz_headercmsblock 1.162 ms 0.06 Mb
ps_categorytree 5.683 ms 0.17 Mb
cz_leftbanner 1.155 ms 0.05 Mb
cz_newproducts 8.062 ms 0.12 Mb
cz_imagehover 29.800 ms 0.44 Mb
ldinstagramslider 0.331 ms 0.01 Mb
cz_servicecmsblock 1.588 ms 0.06 Mb
ps_contactinfo 1.712 ms 0.08 Mb
ps_linklist 1.580 ms 0.07 Mb
ps_customeraccountlinks 1.400 ms 0.08 Mb
cz_footercmsblock 1.458 ms 0.06 Mb
czuecookie 5.230 ms 0.07 Mb
statsdata 13.424 ms 0.25 Mb
39 module(s) 169.511 ms 3.65 Mb

Stopwatch SQL - 276 queries

# Query Time (ms) Rows Filesort Group By Location
63 
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.reference FROM pharm_product p LEFT JOIN pharm_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pharm_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pharm_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 pharm_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pharm_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pharm_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pharm_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pharm_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=323 AND c.nright<=324 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 27.388 ms 9824 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
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 `pharm_configuration` c
LEFT JOIN `pharm_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 9.523 ms 665 /classes/Configuration.php:180
16 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pharm_module` m
INNER JOIN pharm_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 `pharm_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pharm_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pharm_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`
 9.175 ms 1248 Yes Yes /classes/Hook.php:1233
227 
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(
"2025-01-18 00:00:00",
INTERVAL 20 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 `pharm_product` p
INNER JOIN pharm_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
LEFT JOIN `pharm_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 `pharm_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2
LEFT JOIN `pharm_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `pharm_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 pharm_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(
"2025-01-18 00:00:00",
INTERVAL 20 DAY
)
) > 0) AND (EXISTS(SELECT 1 FROM `pharm_category_product` cp
JOIN `pharm_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 3
 6.817 ms 4912 Yes /classes/Product.php:3110
275 
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `pharm_category_product` cp
LEFT JOIN `pharm_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `pharm_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN pharm_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` IN (808,766,753,654,639,636,442,441,423,419) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 5.727 ms 12584 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
229 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (808) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 4.816 ms 1 Yes Yes /classes/Product.php:4507
80 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 808
ORDER BY f.position ASC
 4.548 ms 1 Yes /classes/Product.php:6002
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 4.180 ms 1034 /classes/Hook.php:1332
18 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `pharm_meta` m
LEFT JOIN `pharm_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 3.851 ms 102 Yes /classes/Dispatcher.php:654
261 
SELECT SQL_NO_CACHE *
FROM `pharm_cms` a
LEFT JOIN `pharm_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `pharm_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1
 3.740 ms 1 /src/Adapter/EntityMapper.php:71
73 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `pharm_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `pharm_hook_alias` ha
INNER JOIN `pharm_hook` h ON ha.name = h.name
 3.435 ms 0 /classes/Hook.php:1292
172 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 808
ORDER BY `position`
 3.030 ms 1 Yes /classes/Product.php:3545
74 
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 `pharm_hook_module` hm
STRAIGHT_JOIN `pharm_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `pharm_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 2.842 ms 468 /classes/Hook.php:456
65 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-18 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM pharm_product p
LEFT JOIN pharm_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN pharm_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN pharm_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (808,766,753,654,639,636,442,441,423,419)
 2.728 ms 10 /classes/ProductAssembler.php:95
200 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `pharm_currency` c
LEFT JOIN pharm_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
 2.517 ms 1 /classes/Currency.php:1136
54 
SELECT SQL_NO_CACHE *
FROM `pharm_category` a0
LEFT JOIN `pharm_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 323) AND (a0.`nright` > 324) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 2.480 ms 572 Yes /classes/PrestaShopCollection.php:383
75 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('11526' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '11526')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 2.442 ms 0 /classes/tax/TaxRulesTaxManager.php:109
217 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `pharm_category` c
INNER JOIN pharm_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pharm_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `pharm_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `pharm_category` c2 ON c2.`id_category` = 157 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1 AND c.`level_depth` <= 8 AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
 2.330 ms 286 Yes Yes /classes/Category.php:799
79 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 808 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 808 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2.276 ms 0 /classes/Cart.php:1410
60 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM pharm_layered_category
WHERE controller = 'category'
AND id_category = 157
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 2.257 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
39 
SELECT SQL_NO_CACHE *
FROM `pharm_group_lang`
WHERE `id_group` = 1
 2.253 ms 2 /src/Adapter/EntityMapper.php:79
44 
SELECT SQL_NO_CACHE 1 FROM pharm_cart_product cp INNER JOIN pharm_product p
ON (p.id_product = cp.id_product) INNER JOIN pharm_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 2.073 ms 1 /classes/Cart.php:4192
64 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="787a1d83c6e34f8b290066a1e87c9c29" LIMIT 1
 1.974 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
89 
SELECT SQL_NO_CACHE *
FROM `pharm_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 1.952 ms 1 /src/Adapter/EntityMapper.php:71
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 1.781 ms 1034 /classes/Hook.php:1292
264 
INSERT INTO `pharm_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')
 1.714 ms 1 /classes/ObjectModel.php:622
71 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 808)
 1.584 ms 1 /classes/Product.php:3860
49 
SELECT SQL_NO_CACHE format
FROM `pharm_address_format`
WHERE `id_country` = 64 LIMIT 1
 1.523 ms 1 /classes/AddressFormat.php:656
70 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 14
AND `active` = 1 LIMIT 1
 1.467 ms 1 /classes/Manufacturer.php:316
94 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 766
ORDER BY f.position ASC
 1.465 ms 1 Yes /classes/Product.php:6002
93 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 766 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 766 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.381 ms 0 /classes/Cart.php:1410
265 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 403063
AND `date_add` > '2025-01-18 12:02:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.355 ms 1 Yes /classes/Connection.php:168
0 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM pharm_shop_url su
LEFT JOIN pharm_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'pharmaciedelalliance.com' OR su.domain_ssl = 'pharmaciedelalliance.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 1.299 ms 1 Yes /classes/shop/Shop.php:1364
20 
SELECT SQL_NO_CACHE * FROM `pharm_hook_module_exceptions`
WHERE `id_shop` IN (1)
 1.253 ms 1 /classes/module/Module.php:2018
271 
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `pharm_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `pharm_date_range`) LIMIT 1
 1.246 ms 4096 /classes/DateRange.php:60
270 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361934', '', 'pharmaciedelalliance.com/en/157-cleansing-milk', '', '2025-01-18 12:32:41')
 1.243 ms 1 /classes/ObjectModel.php:622
174 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.230 ms 1 /classes/FeatureFlag.php:105
230 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 766
ORDER BY `position`
 1.182 ms 2 Yes /classes/Product.php:3545
105 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 753
ORDER BY f.position ASC
 1.170 ms 1 Yes /classes/Product.php:6002
267 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 7 AND `id_object` = 157 LIMIT 1
 1.115 ms 1 /classes/Page.php:83
84 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 766) AND (b.`id_shop` = 1) LIMIT 1
 1.109 ms 1 /src/Adapter/EntityMapper.php:71
21 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pharm_module` m
LEFT JOIN `pharm_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 1.091 ms 104 /classes/module/Module.php:345
272 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 706
AND `id_shop` = 1
 1.041 ms 1 /classes/Page.php:131
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 753 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 753 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.021 ms 0 /classes/Cart.php:1410
6 
SELECT SQL_NO_CACHE *
FROM `pharm_country` a
LEFT JOIN `pharm_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `pharm_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 64) LIMIT 1
 1.002 ms 1 /src/Adapter/EntityMapper.php:71
176 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 766
ORDER BY `position`
 1.000 ms 2 Yes /classes/Product.php:3545
266 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'category' LIMIT 1
 0.985 ms 1 /classes/Page.php:104
269 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361934', '706', '2025-01-18 12:32:41')
 0.979 ms 1 /classes/Connection.php:122
114 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 654 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 654 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.948 ms 0 /classes/Cart.php:1410
115 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 654
ORDER BY f.position ASC
 0.909 ms 1 Yes /classes/Product.php:6002
43 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pharm_module` m
LEFT JOIN `pharm_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.905 ms 104 /classes/module/Module.php:345
171 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 419
ORDER BY f.position ASC
 0.897 ms 1 Yes /classes/Product.php:6002
90 
SELECT SQL_NO_CACHE *
FROM `pharm_tax_lang`
WHERE `id_tax` = 1
 0.895 ms 2 /src/Adapter/EntityMapper.php:79
125 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 639
ORDER BY f.position ASC
 0.879 ms 1 Yes /classes/Product.php:6002
76 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 808 AND `id_group` = 1 LIMIT 1
 0.874 ms 0 /classes/GroupReduction.php:156
274 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.874 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
160 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 423 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 423 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.868 ms 0 /classes/Cart.php:1410
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 pharm_shop_group gs
LEFT JOIN pharm_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pharm_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.848 ms 1 Yes /classes/shop/Shop.php:715
170 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 419 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 419 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.847 ms 0 /classes/Cart.php:1410
151 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 441 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 441 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.841 ms 0 /classes/Cart.php:1410
124 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 639 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 639 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.840 ms 0 /classes/Cart.php:1410
66 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 808
AND image_shop.`cover` = 1 LIMIT 1
 0.834 ms 1 /classes/Product.php:3570
228 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 808
ORDER BY `position`
 0.817 ms 1 Yes /classes/Product.php:3545
133 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 636 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 636 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.813 ms 0 /classes/Cart.php:1410
27 
SELECT SQL_NO_CACHE *
FROM `pharm_category` a
LEFT JOIN `pharm_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pharm_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 157) AND (b.`id_shop` = 1) LIMIT 1
 0.810 ms 1 /src/Adapter/EntityMapper.php:71
82 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 766
AND image_shop.`cover` = 1 LIMIT 1
 0.797 ms 2 /classes/Product.php:3570
142 
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 `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 442 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_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` = 442 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.795 ms 0 /classes/Cart.php:1410
42 
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 `pharm_category` c
INNER JOIN pharm_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pharm_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `pharm_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 157
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.788 ms 1 Yes Yes /classes/Category.php:924
152 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 441
ORDER BY f.position ASC
 0.782 ms 1 Yes /classes/Product.php:6002
95 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
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.759 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
161 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 423
ORDER BY f.position ASC
 0.757 ms 1 Yes /classes/Product.php:6002
81 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
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.754 ms 0 /classes/tax/TaxRulesTaxManager.php:109
98 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 753) AND (b.`id_shop` = 1) LIMIT 1
 0.754 ms 1 /src/Adapter/EntityMapper.php:71
134 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 636
ORDER BY f.position ASC
 0.754 ms 1 Yes /classes/Product.php:6002
143 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 442
ORDER BY f.position ASC
 0.738 ms 1 Yes /classes/Product.php:6002
155 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 423) AND (b.`id_shop` = 1) LIMIT 1
 0.716 ms 1 /src/Adapter/EntityMapper.php:71
126 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 636
AND image_shop.`cover` = 1 LIMIT 1
 0.715 ms 1 /classes/Product.php:3570
164 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 419) AND (b.`id_shop` = 1) LIMIT 1
 0.712 ms 1 /src/Adapter/EntityMapper.php:71
106 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 654
AND image_shop.`cover` = 1 LIMIT 1
 0.698 ms 6 /classes/Product.php:3570
3 
SELECT SQL_NO_CACHE *
FROM `pharm_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.687 ms 1 /src/Adapter/EntityMapper.php:71
96 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 753
AND image_shop.`cover` = 1 LIMIT 1
 0.686 ms 1 /classes/Product.php:3570
118 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 639) AND (b.`id_shop` = 1) LIMIT 1
 0.682 ms 1 /src/Adapter/EntityMapper.php:71
5 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `pharm_lang` l
LEFT JOIN `pharm_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.674 ms 2 /classes/Language.php:1080
128 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 636) AND (b.`id_shop` = 1) LIMIT 1
 0.666 ms 1 /src/Adapter/EntityMapper.php:71
137 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 442) AND (b.`id_shop` = 1) LIMIT 1
 0.658 ms 1 /src/Adapter/EntityMapper.php:71
116 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 639
AND image_shop.`cover` = 1 LIMIT 1
 0.655 ms 1 /classes/Product.php:3570
146 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 441) AND (b.`id_shop` = 1) LIMIT 1
 0.654 ms 1 /src/Adapter/EntityMapper.php:71
108 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 654) AND (b.`id_shop` = 1) LIMIT 1
 0.652 ms 1 /src/Adapter/EntityMapper.php:71
222 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `pharm_category` c
LEFT JOIN `pharm_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 323 AND c.`nright` >= 324 AND c.`nleft` >= 2 AND c.`nright` <= 571 ORDER BY `nleft` DESC
 0.635 ms 286 Yes /classes/Category.php:1600
17 
SELECT SQL_NO_CACHE `name`, `alias` FROM `pharm_hook_alias`
 0.615 ms 88 /classes/Hook.php:287
231 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (766) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.603 ms 1 Yes Yes /classes/Product.php:4507
30 
SELECT SQL_NO_CACHE value FROM `pharm_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.599 ms 1 /classes/shop/Shop.php:1183
243 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (441) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.597 ms 1 Yes Yes /classes/Product.php:4507
24 
SELECT SQL_NO_CACHE name, alias FROM `pharm_hook_alias`
 0.591 ms 88 /classes/Hook.php:339
47 
SELECT SQL_NO_CACHE *
FROM `pharm_category` a
LEFT JOIN `pharm_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `pharm_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 157) AND (b.`id_shop` = 1) LIMIT 1
 0.591 ms 1 /src/Adapter/EntityMapper.php:71
4 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM pharm_shop s
LEFT JOIN pharm_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.589 ms 1 /classes/shop/Shop.php:218
153 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 423
AND image_shop.`cover` = 1 LIMIT 1
 0.570 ms 1 /classes/Product.php:3570
245 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (423) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.554 ms 1 Yes Yes /classes/Product.php:4507
62 
SELECT SQL_NO_CACHE *
FROM `pharm_category_lang`
WHERE `id_category` = 157 AND `id_shop` = 1
 0.553 ms 2 /src/Adapter/EntityMapper.php:79
237 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (639) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.551 ms 1 Yes Yes /classes/Product.php:4507
247 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (419) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.547 ms 1 Yes Yes /classes/Product.php:4507
241 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (442) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.546 ms 1 Yes Yes /classes/Product.php:4507
268 
INSERT INTO `pharm_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('403063', '706', '308350554', '', '1', '1', '2025-01-18 12:32:41')
 0.534 ms 1 /classes/ObjectModel.php:622
233 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (753) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.529 ms 1 Yes Yes /classes/Product.php:4507
69 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 808) AND (b.`id_shop` = 1) LIMIT 1
 0.528 ms 1 /src/Adapter/EntityMapper.php:71
162 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 419
AND image_shop.`cover` = 1 LIMIT 1
 0.519 ms 5 /classes/Product.php:3570
244 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 423
ORDER BY `position`
 0.508 ms 1 Yes /classes/Product.php:3545
235 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (654) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.501 ms 1 Yes Yes /classes/Product.php:4507
88 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('11526' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '11526')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.494 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
135 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 442
AND image_shop.`cover` = 1 LIMIT 1
 0.492 ms 1 /classes/Product.php:3570
239 
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 `pharm_product_attribute` pa
INNER JOIN pharm_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 `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (636) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.489 ms 1 Yes Yes /classes/Product.php:4507
144 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 441
AND image_shop.`cover` = 1 LIMIT 1
 0.487 ms 1 /classes/Product.php:3570
246 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 419
ORDER BY `position`
 0.478 ms 5 Yes /classes/Product.php:3545
166 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 419)
 0.473 ms 1 /classes/Product.php:3860
52 
SELECT SQL_NO_CACHE *
FROM `pharm_country_lang`
WHERE `id_country` = 64
 0.462 ms 2 /src/Adapter/EntityMapper.php:79
32 
SELECT SQL_NO_CACHE *
FROM `pharm_currency` a
LEFT JOIN `pharm_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `pharm_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.454 ms 1 /src/Adapter/EntityMapper.php:71
100 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 753)
 0.451 ms 1 /classes/Product.php:3860
11 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `pharm_lang` l
JOIN pharm_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.449 ms 2 /classes/Language.php:1216
86 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 766)
 0.446 ms 1 /classes/Product.php:3860
61 
SELECT SQL_NO_CACHE *
FROM `pharm_category` a
LEFT JOIN `pharm_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 157) LIMIT 1
 0.444 ms 1 /src/Adapter/EntityMapper.php:71
156 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 423)
 0.442 ms 1 /classes/Product.php:3860
85 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 43
AND `active` = 1 LIMIT 1
 0.441 ms 1 /classes/Manufacturer.php:316
41 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM pharm_category_group ctg
WHERE ctg.`id_category` = 157 AND ctg.`id_group` = 1 LIMIT 1
 0.434 ms 1 /classes/Category.php:1754
248 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_servicecmsblock" LIMIT 1
 0.434 ms 1 /classes/module/Module.php:2636
129 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 636)
 0.424 ms 1 /classes/Product.php:3860
234 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 654
ORDER BY `position`
 0.420 ms 6 Yes /classes/Product.php:3545
147 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 441)
 0.420 ms 1 /classes/Product.php:3860
51 
SELECT SQL_NO_CACHE *
FROM `pharm_country` a
LEFT JOIN `pharm_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 64) LIMIT 1
 0.416 ms 1 /src/Adapter/EntityMapper.php:71
120 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 639)
 0.412 ms 1 /classes/Product.php:3860
242 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 441
ORDER BY `position`
 0.412 ms 1 Yes /classes/Product.php:3545
182 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 639
ORDER BY `position`
 0.411 ms 1 Yes /classes/Product.php:3545
38 
SELECT SQL_NO_CACHE *
FROM `pharm_group` a
LEFT JOIN `pharm_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.407 ms 1 /src/Adapter/EntityMapper.php:71
110 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 654)
 0.407 ms 1 /classes/Product.php:3860
180 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 654
ORDER BY `position`
 0.401 ms 6 Yes /classes/Product.php:3545
240 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 442
ORDER BY `position`
 0.399 ms 1 Yes /classes/Product.php:3545
138 
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 `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_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` = 442)
 0.397 ms 1 /classes/Product.php:3860
236 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 639
ORDER BY `position`
 0.390 ms 1 Yes /classes/Product.php:3545
119 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 3
AND `active` = 1 LIMIT 1
 0.387 ms 1 /classes/Manufacturer.php:316
186 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 442
ORDER BY `position`
 0.386 ms 1 Yes /classes/Product.php:3545
238 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 636
ORDER BY `position`
 0.382 ms 1 Yes /classes/Product.php:3545
232 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 753
ORDER BY `position`
 0.378 ms 1 Yes /classes/Product.php:3545
178 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 753
ORDER BY `position`
 0.375 ms 1 Yes /classes/Product.php:3545
192 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 419
ORDER BY `position`
 0.375 ms 5 Yes /classes/Product.php:3545
28 
SELECT SQL_NO_CACHE * FROM `pharm_currency` c ORDER BY `iso_code` ASC
 0.371 ms 1 Yes /classes/Currency.php:709
165 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 21
AND `active` = 1 LIMIT 1
 0.368 ms 1 /classes/Manufacturer.php:316
7 
SELECT SQL_NO_CACHE *
FROM `pharm_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.367 ms 1 /src/Adapter/EntityMapper.php:71
29 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.367 ms 2 /classes/Language.php:883
218 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `pharm_category` c
LEFT JOIN `pharm_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
 0.364 ms 2 /classes/Category.php:2242
194 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.363 ms 1 /classes/module/Module.php:2636
184 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 636
ORDER BY `position`
 0.360 ms 1 Yes /classes/Product.php:3545
67 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pharm_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 157 LIMIT 1
 0.359 ms 1 /classes/Category.php:1378
188 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 441
ORDER BY `position`
 0.358 ms 1 Yes /classes/Product.php:3545
190 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 423
ORDER BY `position`
 0.354 ms 1 Yes /classes/Product.php:3545
48 
SELECT SQL_NO_CACHE * FROM `pharm_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.349 ms 7 Yes /classes/ImageType.php:109
83 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.344 ms 1 /classes/Product.php:5642
99 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 52
AND `active` = 1 LIMIT 1
 0.341 ms 1 /classes/Manufacturer.php:316
34 
SELECT SQL_NO_CACHE `id_country`
FROM `pharm_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.338 ms 1 /classes/Country.php:194
173 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 808
 0.337 ms 1 /classes/Product.php:2902
23 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `pharm_module` m
LEFT JOIN `pharm_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.336 ms 1 /modules/ps_mbo/ps_mbo.php:335
177 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 766
 0.336 ms 1 /classes/Product.php:2902
78 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 808) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.333 ms 1 /classes/stock/StockAvailable.php:453
109 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 10
AND `active` = 1 LIMIT 1
 0.333 ms 1 /classes/Manufacturer.php:316
26 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `pharm_module` m
LEFT JOIN `pharm_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.319 ms 1 /modules/ps_mbo/ps_mbo.php:335
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pharm_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.318 ms 1 /classes/shop/ShopUrl.php:182
219 
SELECT SQL_NO_CACHE *
FROM `pharm_category` a
LEFT JOIN `pharm_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pharm_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.317 ms 1 /src/Adapter/EntityMapper.php:71
150 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 441) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.311 ms 1 /classes/stock/StockAvailable.php:453
262 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_socialfollow" LIMIT 1
 0.309 ms 1 /classes/module/Module.php:2636
8 
SELECT SQL_NO_CACHE *
FROM `pharm_lang` a
LEFT JOIN `pharm_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.307 ms 1 /src/Adapter/EntityMapper.php:71
154 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.307 ms 1 /classes/Product.php:5642
141 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 442) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.306 ms 1 /classes/stock/StockAvailable.php:453
55 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_facebook" LIMIT 1
 0.301 ms 1 /classes/module/Module.php:2636
92 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 766) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.300 ms 1 /classes/stock/StockAvailable.php:453
13 
SELECT SQL_NO_CACHE *
FROM `pharm_lang` a
LEFT JOIN `pharm_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
 0.298 ms 1 /src/Adapter/EntityMapper.php:71
263 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1
 0.292 ms 1 /classes/module/Module.php:2109
159 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 423) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.290 ms 1 /classes/stock/StockAvailable.php:453
123 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 639) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.285 ms 1 /classes/stock/StockAvailable.php:453
249 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
 0.284 ms 1 /classes/module/Module.php:2109
195 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1
 0.283 ms 1 /classes/module/Module.php:2109
169 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 419) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.282 ms 1 /classes/stock/StockAvailable.php:453
103 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 753) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.281 ms 1 /classes/stock/StockAvailable.php:453
113 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 654) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.278 ms 1 /classes/stock/StockAvailable.php:453
117 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.278 ms 1 /classes/Product.php:5642
201 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_toplink" LIMIT 1
 0.277 ms 1 /classes/module/Module.php:2636
132 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 636) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.275 ms 1 /classes/stock/StockAvailable.php:453
175 
SELECT SQL_NO_CACHE * FROM `pharm_image_type`
 0.275 ms 7 /classes/ImageType.php:161
163 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.274 ms 1 /classes/Product.php:5642
97 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.273 ms 1 /classes/Product.php:5642
252 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.270 ms 1 /classes/Country.php:405
107 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.265 ms 1 /classes/Product.php:5642
45 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.264 ms 0 /classes/module/Module.php:2636
145 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.264 ms 1 /classes/Product.php:5642
127 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.263 ms 1 /classes/Product.php:5642
77 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_group`
WHERE `id_group` = 1 LIMIT 1
 0.262 ms 1 /classes/Group.php:154
22 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.260 ms 1 /modules/ps_mbo/ps_mbo.php:325
50 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.260 ms 1 /classes/Country.php:405
136 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.260 ms 1 /classes/Product.php:5642
202 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 69 AND `id_shop` = 1 LIMIT 1
 0.259 ms 1 /classes/module/Module.php:2109
56 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
 0.257 ms 1 /classes/module/Module.php:2109
149 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 441 AND `id_group` = 1 LIMIT 1
 0.254 ms 0 /classes/GroupReduction.php:156
91 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 766 AND `id_group` = 1 LIMIT 1
 0.253 ms 0 /classes/GroupReduction.php:156
31 
SELECT SQL_NO_CACHE c.id_currency
FROM `pharm_currency` c
WHERE (iso_code = 'XAF') LIMIT 1
 0.251 ms 1 /classes/Currency.php:893
72 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 808 AND id_shop=1 LIMIT 1
 0.251 ms 1 /classes/Product.php:6857
158 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 423 AND `id_group` = 1 LIMIT 1
 0.251 ms 0 /classes/GroupReduction.php:156
53 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pharm_required_field
 0.250 ms 1 /classes/ObjectModel.php:1592
68 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 157 LIMIT 1
 0.245 ms 1 /classes/Product.php:5642
220 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `pharm_category` c
LEFT JOIN `pharm_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`id_category` = 157 LIMIT 1
 0.244 ms 1 /classes/Category.php:1585
140 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 442 AND `id_group` = 1 LIMIT 1
 0.242 ms 0 /classes/GroupReduction.php:156
12 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.241 ms 2 /classes/Language.php:854
14 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
 0.239 ms 1 /classes/ObjectModel.php:1729
40 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.239 ms 1 /classes/ObjectModel.php:1729
46 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.239 ms 0 /classes/module/Module.php:2109
181 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 654
 0.238 ms 1 /classes/Product.php:2902
148 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 441 AND id_shop=1 LIMIT 1
 0.237 ms 1 /classes/Product.php:6857
9 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.235 ms 1 /classes/ObjectModel.php:1729
122 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 639 AND `id_group` = 1 LIMIT 1
 0.235 ms 0 /classes/GroupReduction.php:156
25 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.233 ms 1 /modules/ps_mbo/ps_mbo.php:325
59 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
 0.232 ms 0 /classes/module/Module.php:2109
168 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 419 AND `id_group` = 1 LIMIT 1
 0.230 ms 0 /classes/GroupReduction.php:156
102 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 753 AND `id_group` = 1 LIMIT 1
 0.229 ms 0 /classes/GroupReduction.php:156
35 
SELECT SQL_NO_CACHE *
FROM `pharm_currency` a
LEFT JOIN `pharm_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.227 ms 1 /src/Adapter/EntityMapper.php:71
112 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 654 AND `id_group` = 1 LIMIT 1
 0.225 ms 0 /classes/GroupReduction.php:156
131 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 636 AND `id_group` = 1 LIMIT 1
 0.224 ms 0 /classes/GroupReduction.php:156
273 
INSERT INTO `pharm_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('106', '706', '1', '1', '1')
 0.221 ms 1 /classes/Page.php:142
183 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 639
 0.217 ms 1 /classes/Product.php:2902
197 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
 0.215 ms 1 /classes/module/Module.php:2109
251 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1
 0.213 ms 1 /classes/module/Module.php:2109
36 
SELECT SQL_NO_CACHE *
FROM `pharm_currency_lang`
WHERE `id_currency` = 1
 0.204 ms 2 /src/Adapter/EntityMapper.php:79
33 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.202 ms 2 /classes/Language.php:883
58 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "productcomments" LIMIT 1
 0.202 ms 1 /classes/module/Module.php:2636
189 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 441
 0.200 ms 1 /classes/Product.php:2902
179 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 753
 0.198 ms 1 /classes/Product.php:2902
196 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 0.197 ms 1 /classes/module/Module.php:2636