Knee support

Active filters

Load Time 582.569 ms
Querying Time 217 ms
Queries 267
Memory Peak Usage 10.6 Mb
Included Files 1102 files - 12.17 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 3.923 ms 3.923 ms 2.19 Mb 2.6 Mb
__construct 0.025 ms 3.948 ms - Mb 2.6 Mb
init 17.206 ms 21.154 ms 0.43 Mb 3.1 Mb
checkAccess 0.002 ms 21.156 ms - Mb 3.1 Mb
setMedia 3.762 ms 24.918 ms 0.18 Mb 3.1 Mb
postProcess 0.002 ms 24.920 ms - Mb 3.1 Mb
initHeader 0.002 ms 24.922 ms - Mb 3.1 Mb
initContent 245.659 ms 270.581 ms 3.98 Mb 6.8 Mb
initFooter 0.005 ms 270.586 ms - Mb 6.8 Mb
display 311.983 ms 582.569 ms 3.44 Mb 10.6 Mb
Hook Time Memory Usage
DisplayCzHoverImage 67.366 ms 0.48 Mb
DisplayProductListReviews 34.010 ms 0.10 Mb
displayLeftColumn 30.264 ms 0.32 Mb
DisplayBeforeBodyClosingTag 19.755 ms 0.35 Mb
displayFooter 15.540 ms 0.30 Mb
DisplayHeader 13.057 ms 0.44 Mb
displayNavFullWidth 12.631 ms 0.56 Mb
ProductSearchProvider 7.519 ms - Mb
displayNav1 7.100 ms 0.17 Mb
DisplayFooter 6.985 ms 0.05 Mb
DisplayStWishlistButton 5.142 ms 0.01 Mb
DisplayStCompareButton 4.952 ms 0.01 Mb
displayFooterBefore 4.409 ms 0.05 Mb
displayNav2 4.166 ms 0.05 Mb
displayFooterAfter 4.062 ms 0.05 Mb
DisplayLeftColumn 3.533 ms 0.04 Mb
displayTop 2.786 ms 0.15 Mb
ActionFrontControllerSetMedia 0.641 ms 0.01 Mb
ActionDispatcherBefore 0.554 ms 0.01 Mb
DisplayStCompareTopLink 0.311 ms 0.01 Mb
DisplayContentWrapperBottom 0.092 ms - Mb
21 hook(s) 244.874 ms 3.17 Mb
Module Time Memory Usage
ps_mbo 5.217 ms 0.06 Mb
blockreassurance 1.292 ms 0.14 Mb
ps_emailsubscription 1.064 ms 0.06 Mb
ps_socialfollow 4.271 ms 0.06 Mb
ps_emailalerts 0.197 ms 0.01 Mb
ps_facebook 9.693 ms 0.29 Mb
ps_shoppingcart 0.700 ms 0.05 Mb
ps_searchbar 1.378 ms 0.05 Mb
ps_googleanalytics 9.000 ms 0.11 Mb
cz_imageslider 0.296 ms 0.01 Mb
czcouponpop 0.124 ms 0.01 Mb
ps_accounts 0.710 ms 0.01 Mb
azameo 0.600 ms 0.02 Mb
psxmarketingwithgoogle 0.496 ms 0.01 Mb
chatyprestashop 0.420 ms 0.01 Mb
cz_verticalmenu 6.459 ms 0.47 Mb
myprestacomments 36.158 ms 0.20 Mb
psproductcountdown 1.878 ms 0.07 Mb
stfeature 11.319 ms 0.06 Mb
ps_facetedsearch 21.342 ms 0.06 Mb
ps_languageselector 1.696 ms 0.05 Mb
ps_currencyselector 0.597 ms 0.05 Mb
cz_navcmsblock 5.254 ms 0.09 Mb
cz_toplink 4.337 ms 0.06 Mb
ps_customersignin 1.401 ms 0.07 Mb
ps_mainmenu 2.443 ms 0.06 Mb
cz_headercmsblock 4.308 ms 0.06 Mb
ps_categorytree 10.674 ms 0.17 Mb
cz_leftbanner 9.765 ms 0.05 Mb
cz_newproducts 12.393 ms 0.12 Mb
cz_imagehover 68.001 ms 0.49 Mb
ldinstagramslider 0.307 ms 0.01 Mb
cz_servicecmsblock 4.573 ms 0.06 Mb
ps_contactinfo 2.103 ms 0.08 Mb
ps_linklist 4.642 ms 0.07 Mb
ps_customeraccountlinks 4.764 ms 0.07 Mb
cz_footercmsblock 3.847 ms 0.06 Mb
czuecookie 7.074 ms 0.06 Mb
statsdata 11.532 ms 0.26 Mb
39 module(s) 272.325 ms 3.69 Mb

Stopwatch SQL - 267 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>=539 AND c.nright<=540 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 27.957 ms 9824 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
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`
 7.863 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`)
 7.410 ms 665 /classes/Configuration.php:180
218 
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.884 ms 4912 Yes /classes/Product.php:3110
266 
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 (948,947,946,945,944,943,942,941,940,939) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 5.102 ms 12584 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
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 = 948
ORDER BY f.position ASC
 4.744 ms 1 Yes /classes/Product.php:6002
220 
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 (948) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 4.684 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.535 ms 0 /classes/Hook.php:1292
252 
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.433 ms 1 /src/Adapter/EntityMapper.php:71
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.207 ms 102 Yes /classes/Dispatcher.php:654
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 (948,947,946,945,944,943,942,941,940,939)
 3.145 ms 10 /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
 3.040 ms 468 /classes/Hook.php:456
163 
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` = 948
ORDER BY `position`
 2.928 ms 5 Yes /classes/Product.php:3545
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.783 ms 1 /classes/Cart.php:4192
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 2.722 ms 1034 /classes/Hook.php:1332
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.559 ms 0 /classes/tax/TaxRulesTaxManager.php:109
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` = 948 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` = 948 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2.340 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` = 948
AND image_shop.`cover` = 1 LIMIT 1
 2.186 ms 5 /classes/Product.php:3570
60 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM pharm_layered_category
WHERE controller = 'category'
AND id_category = 326
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 2.072 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
64 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="d1e65be91a56d831e7bdc5573ff3837d" LIMIT 1
 1.792 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
208 
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` = 326 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
 1.671 ms 15 Yes Yes /classes/Category.php:799
255 
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.477 ms 1 /classes/ObjectModel.php:622
70 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 112
AND `active` = 1 LIMIT 1
 1.315 ms 1 /classes/Manufacturer.php:316
49 
SELECT SQL_NO_CACHE format
FROM `pharm_address_format`
WHERE `id_country` = 64 LIMIT 1
 1.288 ms 1 /classes/AddressFormat.php:656
165 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.268 ms 1 /classes/FeatureFlag.php:105
90 
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 = 947
ORDER BY f.position ASC
 1.211 ms 1 Yes /classes/Product.php:6002
89 
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` = 947 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` = 947 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.189 ms 0 /classes/Cart.php:1410
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` = 947) AND (b.`id_shop` = 1) LIMIT 1
 1.158 ms 1 /src/Adapter/EntityMapper.php:71
167 
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` = 947
ORDER BY `position`
 1.146 ms 6 Yes /classes/Product.php:3545
256 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 403033
AND `date_add` > '2025-01-18 11:44:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.131 ms 1 Yes /classes/Connection.php:168
261 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361906', '', 'pharmaciedelalliance.com/en/326-knee-support', '', '2025-01-18 12:14:20')
 1.115 ms 1 /classes/ObjectModel.php:622
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 1.099 ms 1034 /classes/Hook.php:1292
221 
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` = 947
ORDER BY `position`
 1.098 ms 6 Yes /classes/Product.php:3545
258 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 7 AND `id_object` = 326 LIMIT 1
 1.085 ms 1 /classes/Page.php:83
262 
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.066 ms 4096 /classes/DateRange.php:60
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` = 948) AND (b.`id_shop` = 1) LIMIT 1
 1.060 ms 1 /src/Adapter/EntityMapper.php:71
161 
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` = 939 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` = 939 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.059 ms 0 /classes/Cart.php:1410
125 
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` = 943 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` = 943 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.056 ms 0 /classes/Cart.php:1410
219 
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` = 948
ORDER BY `position`
 0.996 ms 5 Yes /classes/Product.php:3545
53 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pharm_required_field
 0.974 ms 1 /classes/ObjectModel.php:1592
126 
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 = 943
ORDER BY f.position ASC
 0.940 ms 1 Yes /classes/Product.php:6002
257 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'category' LIMIT 1
 0.936 ms 1 /classes/Page.php:104
162 
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 = 939
ORDER BY f.position ASC
 0.931 ms 1 Yes /classes/Product.php:6002
263 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 1329
AND `id_shop` = 1
 0.912 ms 1 /classes/Page.php:131
116 
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` = 944 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` = 944 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.896 ms 0 /classes/Cart.php:1410
143 
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` = 941 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` = 941 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.896 ms 0 /classes/Cart.php:1410
98 
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` = 946 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` = 946 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.888 ms 0 /classes/Cart.php:1410
117 
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 = 944
ORDER BY f.position ASC
 0.866 ms 1 Yes /classes/Product.php:6002
260 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361906', '1329', '2025-01-18 12:14:20')
 0.858 ms 1 /classes/Connection.php:122
134 
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` = 942 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` = 942 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.850 ms 0 /classes/Cart.php:1410
107 
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` = 945 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` = 945 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.845 ms 0 /classes/Cart.php:1410
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.844 ms 0 /classes/tax/TaxRulesTaxManager.php:109
129 
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` = 942) AND (b.`id_shop` = 1) LIMIT 1
 0.842 ms 1 /src/Adapter/EntityMapper.php:71
76 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 948 AND `id_group` = 1 LIMIT 1
 0.837 ms 0 /classes/GroupReduction.php:156
111 
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` = 944) AND (b.`id_shop` = 1) LIMIT 1
 0.835 ms 1 /src/Adapter/EntityMapper.php:71
135 
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 = 942
ORDER BY f.position ASC
 0.817 ms 1 Yes /classes/Product.php:6002
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` = 948)
 0.816 ms 1 /classes/Product.php:3860
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.807 ms 104 /classes/module/Module.php:345
120 
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` = 943) AND (b.`id_shop` = 1) LIMIT 1
 0.807 ms 1 /src/Adapter/EntityMapper.php:71
152 
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` = 940 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` = 940 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.801 ms 0 /classes/Cart.php:1410
99 
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 = 946
ORDER BY f.position ASC
 0.793 ms 1 Yes /classes/Product.php:6002
144 
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 = 941
ORDER BY f.position ASC
 0.793 ms 1 Yes /classes/Product.php:6002
153 
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 = 940
ORDER BY f.position ASC
 0.790 ms 1 Yes /classes/Product.php:6002
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.786 ms 1 Yes /classes/shop/Shop.php:1364
108 
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 = 945
ORDER BY f.position ASC
 0.783 ms 1 Yes /classes/Product.php:6002
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` = 947
AND image_shop.`cover` = 1 LIMIT 1
 0.777 ms 6 /classes/Product.php:3570
265 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.777 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
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` = 326) AND (b.`id_shop` = 1) LIMIT 1
 0.763 ms 1 /src/Adapter/EntityMapper.php:71
102 
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` = 945) AND (b.`id_shop` = 1) LIMIT 1
 0.755 ms 1 /src/Adapter/EntityMapper.php:71
93 
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` = 946) AND (b.`id_shop` = 1) LIMIT 1
 0.748 ms 1 /src/Adapter/EntityMapper.php:71
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.732 ms 1 /src/Adapter/EntityMapper.php:71
156 
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` = 939) AND (b.`id_shop` = 1) LIMIT 1
 0.694 ms 1 /src/Adapter/EntityMapper.php:71
147 
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` = 940) AND (b.`id_shop` = 1) LIMIT 1
 0.689 ms 1 /src/Adapter/EntityMapper.php:71
118 
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` = 943
AND image_shop.`cover` = 1 LIMIT 1
 0.663 ms 5 /classes/Product.php:3570
138 
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` = 941) AND (b.`id_shop` = 1) LIMIT 1
 0.660 ms 1 /src/Adapter/EntityMapper.php:71
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.646 ms 104 /classes/module/Module.php:345
222 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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 (947) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.645 ms 1 Yes Yes /classes/Product.php:4507
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` < 539) AND (a0.`nright` > 540) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 0.637 ms 18 Yes /classes/PrestaShopCollection.php:383
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.636 ms 1 Yes /classes/shop/Shop.php:715
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` = 326) AND (b.`id_shop` = 1) LIMIT 1
 0.616 ms 1 /src/Adapter/EntityMapper.php:71
109 
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` = 944
AND image_shop.`cover` = 1 LIMIT 1
 0.614 ms 5 /classes/Product.php:3570
191 
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
 0.614 ms 1 /classes/Currency.php:1136
228 
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 (944) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.609 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.596 ms 1 /classes/shop/Shop.php:1183
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` = 326
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.596 ms 1 Yes Yes /classes/Category.php:924
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.594 ms 1 /classes/shop/Shop.php:218
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.581 ms 2 /classes/Language.php:1080
234 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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 (941) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.569 ms 1 Yes Yes /classes/Product.php:4507
17 
SELECT SQL_NO_CACHE `name`, `alias` FROM `pharm_hook_alias`
 0.564 ms 88 /classes/Hook.php:287
136 
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` = 941
AND image_shop.`cover` = 1 LIMIT 1
 0.563 ms 5 /classes/Product.php:3570
230 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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 (943) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.561 ms 1 Yes Yes /classes/Product.php:4507
232 
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 (942) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.561 ms 1 Yes Yes /classes/Product.php:4507
154 
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` = 939
AND image_shop.`cover` = 1 LIMIT 1
 0.550 ms 5 /classes/Product.php:3570
169 
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` = 946
ORDER BY `position`
 0.547 ms 3 Yes /classes/Product.php:3545
236 
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 (940) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.538 ms 1 Yes Yes /classes/Product.php:4507
127 
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` = 942
AND image_shop.`cover` = 1 LIMIT 1
 0.537 ms 6 /classes/Product.php:3570
85 
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` = 947)
 0.530 ms 1 /classes/Product.php:3860
91 
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` = 946
AND image_shop.`cover` = 1 LIMIT 1
 0.526 ms 3 /classes/Product.php:3570
224 
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 (946) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.523 ms 1 Yes Yes /classes/Product.php:4507
112 
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` = 944)
 0.521 ms 1 /classes/Product.php:3860
173 
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` = 944
ORDER BY `position`
 0.518 ms 5 Yes /classes/Product.php:3545
238 
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 (939) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.516 ms 1 Yes Yes /classes/Product.php:4507
20 
SELECT SQL_NO_CACHE * FROM `pharm_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.516 ms 1 /classes/module/Module.php:2018
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.514 ms 1 /src/Adapter/EntityMapper.php:71
24 
SELECT SQL_NO_CACHE name, alias FROM `pharm_hook_alias`
 0.513 ms 88 /classes/Hook.php:339
145 
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` = 940
AND image_shop.`cover` = 1 LIMIT 1
 0.512 ms 5 /classes/Product.php:3570
100 
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` = 945
AND image_shop.`cover` = 1 LIMIT 1
 0.508 ms 4 /classes/Product.php:3570
177 
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` = 942
ORDER BY `position`
 0.507 ms 6 Yes /classes/Product.php:3545
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.503 ms 2 /classes/Language.php:1216
39 
SELECT SQL_NO_CACHE *
FROM `pharm_group_lang`
WHERE `id_group` = 1
 0.487 ms 2 /src/Adapter/EntityMapper.php:79
209 
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.486 ms 2 /classes/Category.php:2242
121 
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` = 943)
 0.486 ms 1 /classes/Product.php:3860
28 
SELECT SQL_NO_CACHE * FROM `pharm_currency` c ORDER BY `iso_code` ASC
 0.485 ms 1 Yes /classes/Currency.php:709
171 
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` = 945
ORDER BY `position`
 0.485 ms 4 Yes /classes/Product.php:3545
175 
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` = 943
ORDER BY `position`
 0.482 ms 5 Yes /classes/Product.php:3545
229 
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` = 943
ORDER BY `position`
 0.479 ms 5 Yes /classes/Product.php:3545
226 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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 (945) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.479 ms 1 Yes Yes /classes/Product.php:4507
259 
INSERT INTO `pharm_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('403033', '1329', '308350554', '', '1', '1', '2025-01-18 12:14:20')
 0.475 ms 1 /classes/ObjectModel.php:622
213 
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` <= 539 AND c.`nright` >= 540 AND c.`nleft` >= 2 AND c.`nright` <= 571 ORDER BY `nleft` DESC
 0.468 ms 18 Yes /classes/Category.php:1600
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` = 326) LIMIT 1
 0.461 ms 1 /src/Adapter/EntityMapper.php:71
130 
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` = 942)
 0.460 ms 1 /classes/Product.php:3860
235 
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` = 940
ORDER BY `position`
 0.456 ms 5 Yes /classes/Product.php:3545
157 
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` = 939)
 0.454 ms 1 /classes/Product.php:3860
231 
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` = 942
ORDER BY `position`
 0.445 ms 6 Yes /classes/Product.php:3545
233 
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` = 941
ORDER BY `position`
 0.440 ms 5 Yes /classes/Product.php:3545
223 
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` = 946
ORDER BY `position`
 0.437 ms 3 Yes /classes/Product.php:3545
78 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 948) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.435 ms 1 /classes/stock/StockAvailable.php:453
94 
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` = 946)
 0.434 ms 1 /classes/Product.php:3860
103 
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` = 945)
 0.432 ms 1 /classes/Product.php:3860
237 
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` = 939
ORDER BY `position`
 0.429 ms 5 Yes /classes/Product.php:3545
3 
SELECT SQL_NO_CACHE *
FROM `pharm_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.422 ms 1 /src/Adapter/EntityMapper.php:71
164 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 948
 0.416 ms 1 /classes/Product.php:2902
227 
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` = 944
ORDER BY `position`
 0.416 ms 5 Yes /classes/Product.php:3545
34 
SELECT SQL_NO_CACHE `id_country`
FROM `pharm_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.413 ms 1 /classes/Country.php:194
88 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 947) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.413 ms 1 /classes/stock/StockAvailable.php:453
48 
SELECT SQL_NO_CACHE * FROM `pharm_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.412 ms 7 Yes /classes/ImageType.php:109
179 
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` = 941
ORDER BY `position`
 0.412 ms 5 Yes /classes/Product.php:3545
181 
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` = 940
ORDER BY `position`
 0.412 ms 5 Yes /classes/Product.php:3545
183 
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` = 939
ORDER BY `position`
 0.412 ms 5 Yes /classes/Product.php:3545
185 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.412 ms 1 /classes/module/Module.php:2636
139 
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` = 941)
 0.411 ms 1 /classes/Product.php:3860
148 
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` = 940)
 0.404 ms 1 /classes/Product.php:3860
41 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM pharm_category_group ctg
WHERE ctg.`id_category` = 326 AND ctg.`id_group` = 1 LIMIT 1
 0.400 ms 1 /classes/Category.php:1754
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.398 ms 1 /src/Adapter/EntityMapper.php:71
225 
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` = 945
ORDER BY `position`
 0.397 ms 4 Yes /classes/Product.php:3545
62 
SELECT SQL_NO_CACHE *
FROM `pharm_category_lang`
WHERE `id_category` = 326 AND `id_shop` = 1
 0.393 ms 2 /src/Adapter/EntityMapper.php:79
7 
SELECT SQL_NO_CACHE *
FROM `pharm_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.388 ms 1 /src/Adapter/EntityMapper.php:71
83 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.388 ms 1 /classes/Product.php:5642
124 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 943) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.378 ms 1 /classes/stock/StockAvailable.php:453
115 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 944) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.377 ms 1 /classes/stock/StockAvailable.php:453
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.367 ms 1 /src/Adapter/EntityMapper.php:71
168 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 947
 0.367 ms 1 /classes/Product.php:2902
52 
SELECT SQL_NO_CACHE *
FROM `pharm_country_lang`
WHERE `id_country` = 64
 0.366 ms 2 /src/Adapter/EntityMapper.php:79
97 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 946) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.366 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.365 ms 2 /classes/Language.php:883
119 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.349 ms 1 /classes/Product.php:5642
110 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.347 ms 1 /classes/Product.php:5642
210 
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.343 ms 1 /src/Adapter/EntityMapper.php:71
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.340 ms 1 /src/Adapter/EntityMapper.php:71
92 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.339 ms 1 /classes/Product.php:5642
166 
SELECT SQL_NO_CACHE * FROM `pharm_image_type`
 0.333 ms 7 /classes/ImageType.php:161
239 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_servicecmsblock" LIMIT 1
 0.326 ms 1 /classes/module/Module.php:2636
45 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.322 ms 0 /classes/module/Module.php:2636
114 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 944 AND `id_group` = 1 LIMIT 1
 0.314 ms 0 /classes/GroupReduction.php:156
160 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 939) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.312 ms 1 /classes/stock/StockAvailable.php:453
50 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.311 ms 1 /classes/Country.php:405
142 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 941) 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
133 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 942) 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
106 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 945) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.301 ms 1 /classes/stock/StockAvailable.php:453
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pharm_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.299 ms 1 /classes/shop/ShopUrl.php:182
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.296 ms 1 /src/Adapter/EntityMapper.php:71
55 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_facebook" LIMIT 1
 0.296 ms 1 /classes/module/Module.php:2636
186 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1
 0.292 ms 1 /classes/module/Module.php:2109
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.289 ms 1 /src/Adapter/EntityMapper.php:71
96 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 946 AND `id_group` = 1 LIMIT 1
 0.288 ms 0 /classes/GroupReduction.php:156
151 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 940) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.287 ms 1 /classes/stock/StockAvailable.php:453
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` = 326 LIMIT 1
 0.283 ms 1 /classes/Category.php:1378
128 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.283 ms 1 /classes/Product.php:5642
87 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 947 AND `id_group` = 1 LIMIT 1
 0.279 ms 0 /classes/GroupReduction.php:156
101 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.278 ms 1 /classes/Product.php:5642
86 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 947 AND id_shop=1 LIMIT 1
 0.274 ms 1 /classes/Product.php:6857
22 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.273 ms 1 /modules/ps_mbo/ps_mbo.php:325
77 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_group`
WHERE `id_group` = 1 LIMIT 1
 0.270 ms 1 /classes/Group.php:154
155 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.270 ms 1 /classes/Product.php:5642
56 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
 0.267 ms 1 /classes/module/Module.php:2109
253 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_socialfollow" LIMIT 1
 0.267 ms 1 /classes/module/Module.php:2636
113 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 944 AND id_shop=1 LIMIT 1
 0.264 ms 1 /classes/Product.php:6857
240 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
 0.264 ms 1 /classes/module/Module.php:2109
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.262 ms 1 /modules/ps_mbo/ps_mbo.php:335
137 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.261 ms 1 /classes/Product.php:5642
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.260 ms 1 /modules/ps_mbo/ps_mbo.php:335
243 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.259 ms 1 /classes/Country.php:405
146 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 326 LIMIT 1
 0.255 ms 1 /classes/Product.php:5642
33 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.254 ms 2 /classes/Language.php:883
123 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 943 AND `id_group` = 1 LIMIT 1
 0.254 ms 0 /classes/GroupReduction.php:156
176 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 943
 0.254 ms 1 /classes/Product.php:2902
254 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1
 0.247 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.245 ms 0 /classes/module/Module.php:2109
159 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 939 AND `id_group` = 1 LIMIT 1
 0.245 ms 0 /classes/GroupReduction.php:156
105 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 945 AND `id_group` = 1 LIMIT 1
 0.240 ms 0 /classes/GroupReduction.php:156
182 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 940
 0.240 ms 1 /classes/Product.php:2902
132 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 942 AND `id_group` = 1 LIMIT 1
 0.239 ms 0 /classes/GroupReduction.php:156
141 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 941 AND `id_group` = 1 LIMIT 1
 0.239 ms 0 /classes/GroupReduction.php:156
58 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "productcomments" LIMIT 1
 0.238 ms 1 /classes/module/Module.php:2636
9 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.236 ms 1 /classes/ObjectModel.php:1729
206 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.235 ms 1 /classes/module/Module.php:2636
150 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 940 AND `id_group` = 1 LIMIT 1
 0.235 ms 0 /classes/GroupReduction.php:156
40 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.232 ms 1 /classes/ObjectModel.php:1729
214 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_leftbanner" LIMIT 1
 0.228 ms 1 /classes/module/Module.php:2636
198 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.226 ms 1 /classes/module/Module.php:2636
202 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_mainmenu" LIMIT 1
 0.223 ms 1 /classes/module/Module.php:2636
211 
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` = 326 LIMIT 1
 0.223 ms 1 /classes/Category.php:1585
216 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_newproducts" LIMIT 1
 0.218 ms 1 /classes/module/Module.php:2636
170 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 946
 0.217 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.214 ms 1 /classes/Currency.php:893
36 
SELECT SQL_NO_CACHE *
FROM `pharm_currency_lang`
WHERE `id_currency` = 1
 0.214 ms 2 /src/Adapter/EntityMapper.php:79
184 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 939
 0.211 ms 1 /classes/Product.php:2902
192 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_toplink" LIMIT 1
 0.211 ms 1 /classes/module/Module.php:2636
14 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
 0.207 ms 1 /classes/ObjectModel.php:1729
195 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1
 0.204 ms 1 /classes/module/Module.php:2109
172 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 945
 0.204 ms 1 /classes/Product.php:2902
174 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 944
 0.203 ms 1 /classes/Product.php:2902
264 
INSERT INTO `pharm_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('106', '1329', '1', '1', '1')
 0.199 ms 1 /classes/Page.php:142