Upper arm blood pressure monitors

Active filters

Load Time 415.037 ms
Querying Time 196 ms
Queries 208
Memory Peak Usage 8.8 Mb
Included Files 1090 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.916 ms 2.916 ms 2.19 Mb 2.6 Mb
__construct 0.023 ms 2.939 ms - Mb 2.6 Mb
init 20.638 ms 23.577 ms 0.43 Mb 3.1 Mb
checkAccess 0.002 ms 23.579 ms - Mb 3.1 Mb
setMedia 3.942 ms 27.521 ms 0.18 Mb 3.1 Mb
postProcess 0.002 ms 27.523 ms - Mb 3.1 Mb
initHeader 0.002 ms 27.525 ms - Mb 3.1 Mb
initContent 191.645 ms 219.170 ms 2.82 Mb 5.7 Mb
initFooter 0.004 ms 219.174 ms - Mb 5.7 Mb
display 195.863 ms 415.037 ms 2.88 Mb 8.8 Mb
Hook Time Memory Usage
displayLeftColumn 25.092 ms 0.32 Mb
DisplayCzHoverImage 22.010 ms 0.20 Mb
displayFooter 17.314 ms 0.30 Mb
DisplayProductListReviews 16.560 ms 0.05 Mb
DisplayBeforeBodyClosingTag 15.262 ms 0.32 Mb
DisplayHeader 14.776 ms 0.44 Mb
displayNavFullWidth 10.317 ms 0.56 Mb
displayNav1 8.445 ms 0.16 Mb
DisplayFooter 6.858 ms 0.05 Mb
ProductSearchProvider 6.207 ms - Mb
displayFooterAfter 4.216 ms 0.05 Mb
displayFooterBefore 3.985 ms 0.05 Mb
displayNav2 3.567 ms 0.05 Mb
displayTop 2.671 ms 0.15 Mb
DisplayLeftColumn 1.986 ms 0.04 Mb
DisplayStWishlistButton 1.276 ms 0.01 Mb
DisplayStCompareButton 1.233 ms 0.01 Mb
ActionFrontControllerSetMedia 0.583 ms 0.01 Mb
ActionDispatcherBefore 0.520 ms 0.01 Mb
DisplayStCompareTopLink 0.329 ms 0.01 Mb
DisplayContentWrapperBottom 0.097 ms - Mb
21 hook(s) 163.304 ms 2.81 Mb
Module Time Memory Usage
ps_mbo 6.298 ms 0.06 Mb
blockreassurance 1.377 ms 0.14 Mb
ps_emailsubscription 1.189 ms 0.06 Mb
ps_socialfollow 4.400 ms 0.06 Mb
ps_emailalerts 0.212 ms 0.01 Mb
ps_facebook 11.905 ms 0.29 Mb
ps_shoppingcart 0.648 ms 0.05 Mb
ps_searchbar 1.324 ms 0.05 Mb
ps_googleanalytics 3.701 ms 0.10 Mb
cz_imageslider 0.304 ms 0.01 Mb
czcouponpop 0.152 ms 0.01 Mb
ps_accounts 0.689 ms 0.01 Mb
azameo 0.551 ms 0.02 Mb
psxmarketingwithgoogle 0.599 ms 0.01 Mb
chatyprestashop 0.520 ms 0.01 Mb
cz_verticalmenu 5.210 ms 0.47 Mb
myprestacomments 18.511 ms 0.15 Mb
psproductcountdown 1.206 ms 0.07 Mb
stfeature 3.683 ms 0.05 Mb
ps_facetedsearch 17.114 ms 0.06 Mb
ps_languageselector 1.855 ms 0.05 Mb
ps_currencyselector 0.598 ms 0.05 Mb
cz_navcmsblock 6.474 ms 0.08 Mb
cz_toplink 3.754 ms 0.06 Mb
ps_customersignin 1.408 ms 0.07 Mb
ps_mainmenu 1.130 ms 0.06 Mb
cz_headercmsblock 4.615 ms 0.06 Mb
ps_categorytree 8.825 ms 0.17 Mb
cz_leftbanner 8.154 ms 0.05 Mb
cz_newproducts 10.023 ms 0.12 Mb
cz_imagehover 22.200 ms 0.21 Mb
ldinstagramslider 0.315 ms 0.01 Mb
cz_servicecmsblock 4.195 ms 0.06 Mb
ps_contactinfo 4.184 ms 0.08 Mb
ps_linklist 4.882 ms 0.07 Mb
ps_customeraccountlinks 3.940 ms 0.07 Mb
cz_footercmsblock 4.305 ms 0.06 Mb
czuecookie 6.984 ms 0.06 Mb
statsdata 12.472 ms 0.27 Mb
39 module(s) 189.906 ms 3.34 Mb

Stopwatch SQL - 208 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>=411 AND c.nright<=412 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 27.950 ms 9824 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
169 
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.716 ms 4912 Yes /classes/Product.php:3110
83 
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 = 1073
ORDER BY f.position ASC
 6.330 ms 1 Yes /classes/Product.php:6002
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`
 5.825 ms 1248 Yes Yes /classes/Hook.php:1233
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`)
 5.682 ms 665 /classes/Configuration.php:180
94 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 1072
 5.024 ms 1 /classes/Product.php:6033
171 
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 (1073) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 4.479 ms 1 Yes Yes /classes/Product.php:4507
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.401 ms 0 /classes/Hook.php:1292
82 
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` = 1073 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` = 1073 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 3.150 ms 0 /classes/Cart.php:1410
124 
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` = 1073
ORDER BY `position`
 2.857 ms 1 Yes /classes/Product.php:3545
193 
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
 2.797 ms 1 /src/Adapter/EntityMapper.php:71
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 (1073,1072,603,602,599)
 2.777 ms 5 /classes/ProductAssembler.php:95
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.756 ms 468 /classes/Hook.php:456
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 2.739 ms 1034 /classes/Hook.php:1332
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` < 411) AND (a0.`nright` > 412) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 2.577 ms 572 Yes /classes/PrestaShopCollection.php:383
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
 2.572 ms 102 Yes /classes/Dispatcher.php:654
142 
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.434 ms 1 /classes/Currency.php:1136
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` = 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
 2.375 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
159 
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` = 249 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.314 ms 286 Yes Yes /classes/Category.php:799
104 
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 = 603
ORDER BY f.position ASC
 2.114 ms 1 Yes /classes/Product.php:6002
184 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 2.070 ms 1 /classes/Country.php:405
39 
SELECT SQL_NO_CACHE *
FROM `pharm_group_lang`
WHERE `id_group` = 1
 2.031 ms 2 /src/Adapter/EntityMapper.php:79
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` = 1073)
 1.880 ms 1 /classes/Product.php:3860
60 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM pharm_layered_category
WHERE controller = 'category'
AND id_category = 249
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 1.863 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
196 
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.838 ms 1 /classes/ObjectModel.php:622
64 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="689a9ef6fb24ce2a3c74137e6c22be07" LIMIT 1
 1.807 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
20 
SELECT SQL_NO_CACHE * FROM `pharm_hook_module_exceptions`
WHERE `id_shop` IN (1)
 1.729 ms 1 /classes/module/Module.php:2018
92 
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` = 1072 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` = 1072 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.591 ms 0 /classes/Cart.php:1410
49 
SELECT SQL_NO_CACHE format
FROM `pharm_address_format`
WHERE `id_country` = 64 LIMIT 1
 1.567 ms 1 /classes/AddressFormat.php:656
103 
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` = 603 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` = 603 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.563 ms 0 /classes/Cart.php:1410
93 
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 = 1072
ORDER BY f.position ASC
 1.509 ms 1 Yes /classes/Product.php:6002
87 
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` = 1072) AND (b.`id_shop` = 1) LIMIT 1
 1.463 ms 1 /src/Adapter/EntityMapper.php:71
97 
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` = 603) AND (b.`id_shop` = 1) LIMIT 1
 1.432 ms 1 /src/Adapter/EntityMapper.php:71
207 
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 (1073,1072,603,602,599) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 1.267 ms 20 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
197 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 402930
AND `date_add` > '2025-01-18 10:42:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.229 ms 1 Yes /classes/Connection.php:168
126 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.204 ms 1 /classes/FeatureFlag.php:105
122 
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` = 599 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` = 599 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.162 ms 0 /classes/Cart.php:1410
199 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 7 AND `id_object` = 249 LIMIT 1
 1.159 ms 1 /classes/Page.php:83
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 1.113 ms 1034 /classes/Hook.php:1292
203 
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.097 ms 4096 /classes/DateRange.php:60
123 
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 = 599
ORDER BY f.position ASC
 1.097 ms 1 Yes /classes/Product.php:6002
41 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM pharm_category_group ctg
WHERE ctg.`id_category` = 249 AND ctg.`id_group` = 1 LIMIT 1
 1.085 ms 1 /classes/Category.php:1754
128 
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` = 1072
ORDER BY `position`
 1.055 ms 5 Yes /classes/Product.php:3545
202 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361819', '', 'pharmaciedelalliance.com/en/249-upper-arm-blood-pressure-monitors', '', '2025-01-18 11:12:50')
 1.053 ms 1 /classes/ObjectModel.php:622
84 
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
 1.037 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
53 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pharm_required_field
 1.009 ms 1 /classes/ObjectModel.php:1592
95 
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` = 603
AND image_shop.`cover` = 1 LIMIT 1
 0.998 ms 2 /classes/Product.php:3570
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` = 1072
ORDER BY `position`
 0.997 ms 5 Yes /classes/Product.php:3545
204 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 584
AND `id_shop` = 1
 0.953 ms 1 /classes/Page.php:131
201 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361819', '584', '2025-01-18 11:12:50')
 0.937 ms 1 /classes/Connection.php:122
198 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'category' LIMIT 1
 0.935 ms 1 /classes/Page.php:104
85 
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` = 1072
AND image_shop.`cover` = 1 LIMIT 1
 0.928 ms 5 /classes/Product.php:3570
114 
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 = 602
ORDER BY f.position ASC
 0.912 ms 1 Yes /classes/Product.php:6002
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
 0.898 ms 1 /classes/Cart.php:4192
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` = 1073
AND image_shop.`cover` = 1 LIMIT 1
 0.889 ms 1 /classes/Product.php:3570
76 
SELECT SQL_NO_CACHE *
FROM `pharm_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 0.888 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
 0.888 ms 104 /classes/module/Module.php:345
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` = 249
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.884 ms 1 Yes Yes /classes/Category.php:924
113 
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` = 602 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` = 602 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.866 ms 0 /classes/Cart.php:1410
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.809 ms 104 /classes/module/Module.php:345
77 
SELECT SQL_NO_CACHE *
FROM `pharm_tax_lang`
WHERE `id_tax` = 1
 0.800 ms 2 /src/Adapter/EntityMapper.php:79
206 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.784 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
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
 0.769 ms 1 Yes /classes/shop/Shop.php:1364
105 
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` = 602
AND image_shop.`cover` = 1 LIMIT 1
 0.769 ms 1 /classes/Product.php:3570
99 
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` = 603)
 0.766 ms 1 /classes/Product.php:3860
115 
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` = 599
AND image_shop.`cover` = 1 LIMIT 1
 0.698 ms 4 /classes/Product.php:3570
88 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, 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` = 1072)
 0.697 ms 1 /classes/Product.php:3860
80 
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
 0.696 ms 0 /classes/tax/TaxRulesTaxManager.php:109
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
 0.689 ms 1 /src/Adapter/EntityMapper.php:71
107 
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` = 602) AND (b.`id_shop` = 1) LIMIT 1
 0.688 ms 1 /src/Adapter/EntityMapper.php:71
117 
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` = 599) AND (b.`id_shop` = 1) LIMIT 1
 0.687 ms 1 /src/Adapter/EntityMapper.php:71
78 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1073 AND `id_group` = 1 LIMIT 1
 0.668 ms 0 /classes/GroupReduction.php:156
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.668 ms 1 Yes /classes/shop/Shop.php:715
170 
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` = 1073
ORDER BY `position`
 0.642 ms 1 Yes /classes/Product.php:3545
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` = 249) AND (b.`id_shop` = 1) LIMIT 1
 0.636 ms 1 /src/Adapter/EntityMapper.php:71
177 
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 (602) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.598 ms 1 Yes Yes /classes/Product.php:4507
164 
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` <= 411 AND c.`nright` >= 412 AND c.`nleft` >= 2 AND c.`nright` <= 571 ORDER BY `nleft` DESC
 0.578 ms 82 Yes /classes/Category.php:1600
136 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.577 ms 1 /classes/module/Module.php:2636
179 
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 (599) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.550 ms 1 Yes Yes /classes/Product.php:4507
175 
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 (603) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.532 ms 1 Yes Yes /classes/Product.php:4507
109 
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` = 602)
 0.525 ms 1 /classes/Product.php:3860
173 
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 (1072) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.518 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` = 1073) AND (b.`id_shop` = 1) LIMIT 1
 0.516 ms 1 /src/Adapter/EntityMapper.php:71
118 
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` = 599)
 0.516 ms 1 /classes/Product.php:3860
200 
INSERT INTO `pharm_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('402930', '584', '308350554', '', '1', '1', '2025-01-18 11:12:50')
 0.514 ms 1 /classes/ObjectModel.php:622
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.504 ms 1 /src/Adapter/EntityMapper.php:71
24 
SELECT SQL_NO_CACHE name, alias FROM `pharm_hook_alias`
 0.503 ms 88 /classes/Hook.php:339
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` = 249) LIMIT 1
 0.475 ms 1 /src/Adapter/EntityMapper.php:71
30 
SELECT SQL_NO_CACHE value FROM `pharm_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.474 ms 1 /classes/shop/Shop.php:1183
98 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 114
AND `active` = 1 LIMIT 1
 0.471 ms 1 /classes/Manufacturer.php:316
17 
SELECT SQL_NO_CACHE `name`, `alias` FROM `pharm_hook_alias`
 0.467 ms 88 /classes/Hook.php:287
52 
SELECT SQL_NO_CACHE *
FROM `pharm_country_lang`
WHERE `id_country` = 64
 0.464 ms 2 /src/Adapter/EntityMapper.php:79
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` = 599
ORDER BY `position`
 0.464 ms 4 Yes /classes/Product.php:3545
121 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 599) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.463 ms 1 /classes/stock/StockAvailable.php:453
134 
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` = 599
ORDER BY `position`
 0.458 ms 4 Yes /classes/Product.php:3545
130 
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` = 603
ORDER BY `position`
 0.441 ms 2 Yes /classes/Product.php:3545
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` = 602
ORDER BY `position`
 0.440 ms 1 Yes /classes/Product.php:3545
132 
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` = 602
ORDER BY `position`
 0.433 ms 1 Yes /classes/Product.php:3545
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.428 ms 1 /src/Adapter/EntityMapper.php:71
81 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1073) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.419 ms 1 /classes/stock/StockAvailable.php:453
180 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_servicecmsblock" LIMIT 1
 0.418 ms 1 /classes/module/Module.php:2636
70 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 112
AND `active` = 1 LIMIT 1
 0.416 ms 1 /classes/Manufacturer.php:316
182 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_contactinfo" LIMIT 1
 0.415 ms 1 /classes/module/Module.php:2636
91 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1072) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.414 ms 1 /classes/stock/StockAvailable.php:453
174 
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` = 603
ORDER BY `position`
 0.396 ms 2 Yes /classes/Product.php:3545
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.390 ms 2 /classes/Language.php:1080
102 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 603) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.387 ms 1 /classes/stock/StockAvailable.php:453
108 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 113
AND `active` = 1 LIMIT 1
 0.386 ms 1 /classes/Manufacturer.php:316
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.383 ms 1 /classes/shop/Shop.php:218
48 
SELECT SQL_NO_CACHE * FROM `pharm_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.376 ms 7 Yes /classes/ImageType.php:109
62 
SELECT SQL_NO_CACHE *
FROM `pharm_category_lang`
WHERE `id_category` = 249 AND `id_shop` = 1
 0.364 ms 2 /src/Adapter/EntityMapper.php:79
160 
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.362 ms 2 /classes/Category.php:2242
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.353 ms 1 /src/Adapter/EntityMapper.php:71
129 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1072
 0.347 ms 1 /classes/Product.php:2902
34 
SELECT SQL_NO_CACHE `id_country`
FROM `pharm_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.345 ms 1 /classes/Country.php:194
194 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_socialfollow" LIMIT 1
 0.345 ms 1 /classes/module/Module.php:2636
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.344 ms 2 /classes/Language.php:1216
28 
SELECT SQL_NO_CACHE * FROM `pharm_currency` c ORDER BY `iso_code` ASC
 0.344 ms 1 Yes /classes/Currency.php:709
55 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_facebook" LIMIT 1
 0.332 ms 1 /classes/module/Module.php:2636
127 
SELECT SQL_NO_CACHE * FROM `pharm_image_type`
 0.331 ms 7 /classes/ImageType.php:161
86 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 249 LIMIT 1
 0.329 ms 1 /classes/Product.php:5642
90 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1072 AND `id_group` = 1 LIMIT 1
 0.329 ms 0 /classes/GroupReduction.php:156
96 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 249 LIMIT 1
 0.326 ms 1 /classes/Product.php:5642
101 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 603 AND `id_group` = 1 LIMIT 1
 0.313 ms 0 /classes/GroupReduction.php:156
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` = 249) AND (b.`id_shop` = 1) LIMIT 1
 0.311 ms 1 /src/Adapter/EntityMapper.php:71
56 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
 0.310 ms 1 /classes/module/Module.php:2109
125 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1073
 0.310 ms 1 /classes/Product.php:2902
50 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.309 ms 1 /classes/Country.php:405
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` = 249 LIMIT 1
 0.308 ms 1 /classes/Category.php:1378
137 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1
 0.295 ms 1 /classes/module/Module.php:2109
161 
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.294 ms 1 /src/Adapter/EntityMapper.php:71
3 
SELECT SQL_NO_CACHE *
FROM `pharm_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.293 ms 1 /src/Adapter/EntityMapper.php:71
112 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 602) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.292 ms 1 /classes/stock/StockAvailable.php:453
29 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.285 ms 2 /classes/Language.php:883
135 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 599
 0.279 ms 1 /classes/Product.php:2902
143 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_toplink" LIMIT 1
 0.275 ms 1 /classes/module/Module.php:2636
181 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
 0.274 ms 1 /classes/module/Module.php:2109
106 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 249 LIMIT 1
 0.272 ms 1 /classes/Product.php:5642
185 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_linklist" LIMIT 1
 0.270 ms 1 /classes/module/Module.php:2636
195 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1
 0.268 ms 1 /classes/module/Module.php:2109
116 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 249 LIMIT 1
 0.266 ms 1 /classes/Product.php:5642
144 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 69 AND `id_shop` = 1 LIMIT 1
 0.262 ms 1 /classes/module/Module.php:2109
40 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.259 ms 1 /classes/ObjectModel.php:1729
131 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 603
 0.259 ms 1 /classes/Product.php:2902
58 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "productcomments" LIMIT 1
 0.257 ms 1 /classes/module/Module.php:2636
7 
SELECT SQL_NO_CACHE *
FROM `pharm_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.256 ms 1 /src/Adapter/EntityMapper.php:71
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.255 ms 1 /modules/ps_mbo/ps_mbo.php:335
186 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1
 0.254 ms 1 /classes/module/Module.php:2109
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.254 ms 1 /src/Adapter/EntityMapper.php:71
79 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_group`
WHERE `id_group` = 1 LIMIT 1
 0.249 ms 1 /classes/Group.php:154
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.244 ms 1 /modules/ps_mbo/ps_mbo.php:335
89 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1072 AND id_shop=1 LIMIT 1
 0.236 ms 1 /classes/Product.php:6857
100 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 603 AND id_shop=1 LIMIT 1
 0.234 ms 1 /classes/Product.php:6857
111 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 602 AND `id_group` = 1 LIMIT 1
 0.234 ms 0 /classes/GroupReduction.php:156
120 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 599 AND `id_group` = 1 LIMIT 1
 0.232 ms 0 /classes/GroupReduction.php:156
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pharm_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.229 ms 1 /classes/shop/ShopUrl.php:182
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.224 ms 1 /src/Adapter/EntityMapper.php:71
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.223 ms 1 /src/Adapter/EntityMapper.php:71
59 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
 0.222 ms 0 /classes/module/Module.php:2109
162 
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` = 249 LIMIT 1
 0.215 ms 1 /classes/Category.php:1585
205 
INSERT INTO `pharm_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('106', '584', '1', '1', '1')
 0.212 ms 1 /classes/Page.php:142
183 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1
 0.208 ms 1 /classes/module/Module.php:2109
22 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.201 ms 1 /modules/ps_mbo/ps_mbo.php:325
165 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_leftbanner" LIMIT 1
 0.199 ms 1 /classes/module/Module.php:2636
57 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_accounts" LIMIT 1
 0.197 ms 1 /src/Adapter/Module/ModuleDataProvider.php:257
68 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 249 LIMIT 1
 0.197 ms 1 /classes/Product.php:5642
133 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 602
 0.196 ms 1 /classes/Product.php:2902
31 
SELECT SQL_NO_CACHE c.id_currency
FROM `pharm_currency` c
WHERE (iso_code = 'XAF') LIMIT 1
 0.195 ms 1 /classes/Currency.php:893
187 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
 0.192 ms 1 /classes/module/Module.php:2636
36 
SELECT SQL_NO_CACHE *
FROM `pharm_currency_lang`
WHERE `id_currency` = 1
 0.190 ms 2 /src/Adapter/EntityMapper.php:79
72 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1073 AND id_shop=1 LIMIT 1
 0.185 ms 1 /classes/Product.php:6857
33 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.184 ms 2 /classes/Language.php:883
153 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_mainmenu" LIMIT 1
 0.183 ms 1 /classes/module/Module.php:2636
167 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_newproducts" LIMIT 1
 0.183 ms 1 /classes/module/Module.php:2636
189 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
 0.183 ms 1 /classes/module/Module.php:2636
145 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.182 ms 1 /classes/module/Module.php:2636
110 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 602 AND id_shop=1 LIMIT 1
 0.182 ms 1 /classes/Product.php:6857
188 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1
 0.179 ms 1 /classes/module/Module.php:2109
166 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 89 AND `id_shop` = 1 LIMIT 1
 0.178 ms 1 /classes/module/Module.php:2109
119 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 599 AND id_shop=1 LIMIT 1
 0.177 ms 1 /classes/Product.php:6857
148 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1
 0.177 ms 1 /classes/module/Module.php:2109
147 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_customersignin" LIMIT 1
 0.176 ms 1 /classes/module/Module.php:2636
157 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.176 ms 1 /classes/module/Module.php:2636
191 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_footercmsblock" LIMIT 1
 0.176 ms 1 /classes/module/Module.php:2636
25 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.175 ms 1 /modules/ps_mbo/ps_mbo.php:325
138 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 0.175 ms 1 /classes/module/Module.php:2636
12 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.173 ms 2 /classes/Language.php:854
149 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.173 ms 1 /classes/module/Module.php:2636
37 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.169 ms 1 /classes/ObjectModel.php:1729
168 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 76 AND `id_shop` = 1 LIMIT 1
 0.169 ms 1 /classes/module/Module.php:2109
9 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.167 ms 1 /classes/ObjectModel.php:1729
45 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.167 ms 0 /classes/module/Module.php:2636
146 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1
 0.167 ms 1 /classes/module/Module.php:2109
14 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
 0.165 ms 1 /classes/ObjectModel.php:1729
156 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 71 AND `id_shop` = 1 LIMIT 1
 0.165 ms 1 /classes/module/Module.php:2109
140 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_navcmsblock" LIMIT 1
 0.164 ms 1 /classes/module/Module.php:2636
190 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
 0.164 ms 1 /classes/module/Module.php:2109
139 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
 0.163 ms 1 /classes/module/Module.php:2109
155 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_headercmsblock" LIMIT 1
 0.163 ms 1 /classes/module/Module.php:2636
151 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_verticalmenu" LIMIT 1
 0.162 ms 1 /classes/module/Module.php:2636
192 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 106 AND `id_shop` = 1 LIMIT 1
 0.161 ms 1 /classes/module/Module.php:2109
154 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
 0.160 ms 1 /classes/module/Module.php:2109
163 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `pharm_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.160 ms 1 /classes/Category.php:1591
141 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 68 AND `id_shop` = 1 LIMIT 1
 0.159 ms 1 /classes/module/Module.php:2109
150 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
 0.159 ms 1 /classes/module/Module.php:2109
152 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 70 AND `id_shop` = 1 LIMIT 1
 0.158 ms 1 /classes/module/Module.php:2109
158 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1
 0.158 ms 1 /classes/module/Module.php:2109
46 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.157 ms 0 /classes/module/Module.php:2109

Doubles

23 queries 
SELECT `id_module` FROM `pharm_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries 
            SELECT 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 = XX)
            LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
            WHERE i.`id_product` = XX
            ORDER BY `position`
5 queries 
SELECT 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 = XX)
                    WHERE i.`id_product` = XX
                    AND image_shop.`cover` = XX LIMIT XX
5 queries 
SELECT name FROM pharm_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
5 queries 
SELECT *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
5 queries 
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, 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 = XX)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
5 queries 
                            SELECT `id_tax_rules_group`
                            FROM `pharm_product_shop`
                            WHERE `id_product` = XX AND id_shop=XX LIMIT XX
5 queries 
			SELECT `reduction`
			FROM `pharm_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
5 queries 
SELECT SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
5 queries 
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
            COALESCE(SUM(first_level_quantity), XX) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity
          FROM `pharm_cart_product` cp
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX 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` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
            pr.`pack_stock_type` = XX
            AND XX = XX
        ))) as q LIMIT XX
5 queries 
                SELECT 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 = XX)
                LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
                LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
                 INNER JOIN pharm_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX)
                WHERE pf.id_product = XX
                ORDER BY f.position ASC
5 queries 
SELECT `id_product_attribute`
            FROM `pharm_product_attribute`
            WHERE `id_product` = XX
5 queries 
SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX 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 = XX)
            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` = XX)
            JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
3 queries 
SELECT *
FROM `pharm_category` a
LEFT JOIN `pharm_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `pharm_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
3 queries 
				SELECT `name`
				FROM `pharm_manufacturer`
				WHERE `id_manufacturer` = XX
				AND `active` = XX LIMIT XX
3 queries 
				SELECT 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` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries 
SELECT *
FROM `pharm_lang` a
LEFT JOIN `pharm_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX
WHERE (a.`id_lang` = XX) LIMIT XX
2 queries 
				SELECT id_shop
				FROM `pharm_lang_shop`
				WHERE `id_lang` = XX
				AND id_shop = XX LIMIT XX
2 queries 
                SELECT 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` = XX
2 queries 
SELECT `active`
        FROM `pharm_module`
        WHERE `name` = "ps_mbo" LIMIT XX
2 queries 
SELECT 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 XX
2 queries 
SELECT `id_lang` FROM `pharm_lang`
                    WHERE `locale` = 'en-us'
                    OR `language_code` = 'en-us' LIMIT XX
2 queries 
			SELECT `need_identification_number`
			FROM `pharm_country`
			WHERE `id_country` = XX LIMIT XX

Tables stress

32 module
28 module_shop
19 product
19 product_shop
17 category_lang
16 image_shop
15 image
14 category
11 cart_product
11 product_attribute
11 product_attribute_shop
11 image_lang
8 stock_available
7 lang
7 category_shop
7 product_lang
6 lang_shop
6 hook
6 product_attribute_combination
5 country
5 currency
5 category_group
5 product_group_reduction_cache
5 pack
5 feature_product
5 feature_lang
5 feature_value_lang
5 feature
5 feature_shop
5 attribute
5 attribute_lang
5 attribute_group
4 shop_url
4 shop
4 currency_shop
4 manufacturer
3 hook_alias
3 category_product
3 tax_rule
3 tax_rules_group
2 shop_group
2 configuration
2 country_lang
2 country_shop
2 hook_module
2 currency_lang
2 group
2 group_shop
2 image_type
2 date_range
1 configuration_lang
1 module_group
1 meta
1 meta_lang
1 hook_module_exceptions
1 group_lang
1 address_format
1 required_field
1 layered_category
1 product_sale
1 layered_filter_block
1 tax
1 tax_lang
1 product_attachment
1 attachment
1 attachment_lang
1 feature_flag
1 cms
1 cms_lang
1 cms_shop
1 connections
1 page_type
1 page
1 ganalytics_data

ObjectModel instances

Name Instances Source
Product 20 /classes/Link.php:113 (__construct) [id: 1073]
/classes/Link.php:113 (__construct) [id: 1072]
/classes/Link.php:113 (__construct) [id: 603]
/classes/Link.php:113 (__construct) [id: 602]
/classes/Link.php:113 (__construct) [id: 599]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1073]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1072]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 603]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 602]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 599]
/classes/Link.php:113 (__construct) [id: 1073]
/classes/Link.php:113 (__construct) [id: 1072]
/classes/Link.php:113 (__construct) [id: 603]
/classes/Link.php:113 (__construct) [id: 602]
/classes/Link.php:113 (__construct) [id: 599]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1073]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 1072]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 603]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 602]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 599]
Category 12 /controllers/front/listing/CategoryController.php:78 (__construct) [id: 249]
/classes/Meta.php:380 (__construct) [id: 249]