Home

Home

List of products by brand PHYSIOLAC

Active filters

Load Time 316.143 ms
Querying Time 205 ms
Queries 213
Memory Peak Usage 9.7 Mb
Included Files 1087 files - 12.14 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.437 ms 2.437 ms 2.19 Mb 2.6 Mb
__construct 0.020 ms 2.457 ms - Mb 2.6 Mb
init 17.131 ms 19.588 ms 0.42 Mb 3.1 Mb
checkAccess 0.001 ms 19.589 ms - Mb 3.1 Mb
setMedia 3.561 ms 23.150 ms 0.18 Mb 3.1 Mb
postProcess 0.002 ms 23.152 ms - Mb 3.1 Mb
initHeader 0.001 ms 23.153 ms - Mb 3.1 Mb
initContent 147.073 ms 170.226 ms 2.93 Mb 5.8 Mb
initFooter 0.004 ms 170.230 ms - Mb 5.8 Mb
display 145.913 ms 316.143 ms 3.60 Mb 9.7 Mb
Hook Time Memory Usage
displayLeftColumn 36.572 ms 1.02 Mb
DisplayProductListReviews 23.231 ms 0.06 Mb
DisplayBeforeBodyClosingTag 16.346 ms 0.32 Mb
DisplayHeader 11.995 ms 0.44 Mb
DisplayCzHoverImage 7.059 ms 0.22 Mb
displayNavFullWidth 7.050 ms 0.56 Mb
displayFooter 5.465 ms 0.30 Mb
displayNav1 5.348 ms 0.16 Mb
DisplayFooter 4.959 ms 0.06 Mb
displayTop 2.692 ms 0.15 Mb
displayFooterBefore 1.531 ms 0.05 Mb
DisplayStWishlistButton 1.519 ms 0.01 Mb
DisplayStCompareButton 1.381 ms 0.01 Mb
displayFooterAfter 1.203 ms 0.05 Mb
displayNav2 1.109 ms 0.05 Mb
ActionFrontControllerSetMedia 0.593 ms 0.07 Mb
ProductSearchProvider 0.590 ms - Mb
ActionDispatcherBefore 0.504 ms 0.01 Mb
DisplayLeftColumn 0.340 ms 0.04 Mb
DisplayStCompareTopLink 0.319 ms 0.01 Mb
DisplayContentWrapperBottom 0.102 ms - Mb
21 hook(s) 129.908 ms 3.61 Mb
Module Time Memory Usage
ps_mbo 5.366 ms 0.06 Mb
blockreassurance 1.455 ms 0.14 Mb
ps_emailsubscription 1.150 ms 0.06 Mb
ps_socialfollow 1.452 ms 0.06 Mb
ps_emailalerts 0.218 ms 0.01 Mb
ps_facebook 8.687 ms 0.29 Mb
ps_shoppingcart 0.616 ms 0.05 Mb
ps_searchbar 1.416 ms 0.05 Mb
ps_googleanalytics 4.020 ms 0.10 Mb
cz_imageslider 0.308 ms 0.01 Mb
czcouponpop 0.125 ms 0.01 Mb
ps_accounts 0.271 ms 0.07 Mb
azameo 0.493 ms 0.02 Mb
psxmarketingwithgoogle 0.571 ms 0.01 Mb
chatyprestashop 0.445 ms 0.01 Mb
cz_verticalmenu 5.131 ms 0.47 Mb
myprestacomments 24.594 ms 0.16 Mb
psproductcountdown 1.151 ms 0.07 Mb
stfeature 4.098 ms 0.05 Mb
ps_facetedsearch 1.543 ms 0.06 Mb
ps_languageselector 1.630 ms 0.05 Mb
ps_currencyselector 0.687 ms 0.05 Mb
cz_navcmsblock 3.490 ms 0.08 Mb
cz_toplink 1.257 ms 0.06 Mb
ps_customersignin 1.435 ms 0.07 Mb
ps_mainmenu 1.261 ms 0.06 Mb
cz_headercmsblock 1.233 ms 0.06 Mb
ps_categorytree 22.730 ms 0.86 Mb
cz_leftbanner 1.536 ms 0.05 Mb
cz_newproducts 12.797 ms 0.12 Mb
cz_imagehover 7.253 ms 0.23 Mb
ldinstagramslider 0.337 ms 0.01 Mb
cz_servicecmsblock 1.709 ms 0.06 Mb
ps_contactinfo 1.643 ms 0.08 Mb
ps_linklist 1.349 ms 0.07 Mb
ps_customeraccountlinks 1.112 ms 0.07 Mb
cz_footercmsblock 1.119 ms 0.06 Mb
czuecookie 5.049 ms 0.07 Mb
statsdata 13.056 ms 0.27 Mb
39 module(s) 143.793 ms 4.14 Mb

Stopwatch SQL - 213 queries

# Query Time (ms) Rows Filesort Group By Location
172 
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
 11.383 ms 4912 Yes /classes/Product.php:3110
163 
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` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1 AND c.`level_depth` <= 5 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
 10.458 ms 286 Yes Yes /classes/Category.php:799
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`)
 8.841 ms 665 /classes/Configuration.php:180
76 
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 = 1240
ORDER BY f.position ASC
 8.006 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`
 7.945 ms 1248 Yes Yes /classes/Hook.php:1233
59 
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 p.id_manufacturer='158' GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 7.811 ms 48 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
70 
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
 6.001 ms 468 /classes/Hook.php:456
69 
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
 5.525 ms 0 /classes/Hook.php:1292
174 
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 (1240) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 5.390 ms 1 Yes Yes /classes/Product.php:4507
71 
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
 4.821 ms 0 /classes/tax/TaxRulesTaxManager.php:109
198 
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
 4.000 ms 1 /src/Adapter/EntityMapper.php:71
75 
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` = 1240 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` = 1240 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 3.627 ms 0 /classes/Cart.php:1410
62 
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` = 1240
AND image_shop.`cover` = 1 LIMIT 1
 3.362 ms 1 /classes/Product.php:3570
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.979 ms 102 Yes /classes/Dispatcher.php:654
61 
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 (1240,1239,1238,1237,1236,1235)
 2.970 ms 6 /classes/ProductAssembler.php:95
27 
SELECT SQL_NO_CACHE *
FROM `pharm_manufacturer` a
LEFT JOIN `pharm_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `pharm_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 158) LIMIT 1
 2.895 ms 1 /src/Adapter/EntityMapper.php:71
125 
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` = 1240
ORDER BY `position`
 2.744 ms 1 Yes /classes/Product.php:3545
162 
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
 2.483 ms 1 /src/Adapter/EntityMapper.php:71
48 
SELECT SQL_NO_CACHE format
FROM `pharm_address_format`
WHERE `id_country` = 64 LIMIT 1
 2.417 ms 1 /classes/AddressFormat.php:656
67 
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` = 1240)
 2.312 ms 1 /classes/Product.php:3860
58 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM pharm_layered_category
WHERE controller = 'manufacturer'
AND id_category = 0
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 2.185 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
145 
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.175 ms 1 /classes/Currency.php:1136
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 2.020 ms 1034 /classes/Hook.php:1332
201 
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.804 ms 1 /classes/ObjectModel.php:622
60 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="e446440205886b1811243c261e5d3bd9" LIMIT 1
 1.704 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
80 
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` = 1239) AND (b.`id_shop` = 1) LIMIT 1
 1.531 ms 1 /src/Adapter/EntityMapper.php:71
212 
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 (1240,1239,1238,1237,1236,1235) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 1.483 ms 24 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
202 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 403105
AND `date_add` > '2025-01-18 12:23:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.411 ms 1 Yes /classes/Connection.php:168
0 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM pharm_shop_url su
LEFT JOIN pharm_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'pharmaciedelalliance.com' OR su.domain_ssl = 'pharmaciedelalliance.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 1.381 ms 1 Yes /classes/shop/Shop.php:1364
208 
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.350 ms 4096 /classes/DateRange.php:60
72 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1240 AND `id_group` = 1 LIMIT 1
 1.316 ms 0 /classes/GroupReduction.php:156
85 
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` = 1239 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` = 1239 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.314 ms 0 /classes/Cart.php:1410
65 
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` = 1240) AND (b.`id_shop` = 1) LIMIT 1
 1.313 ms 1 /src/Adapter/EntityMapper.php:71
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` = 1239
ORDER BY `position`
 1.276 ms 1 Yes /classes/Product.php:3545
204 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 9 AND `id_object` = 158 LIMIT 1
 1.276 ms 1 /classes/Page.php:83
63 
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` = 134 LIMIT 1
 1.271 ms 1 /classes/Category.php:1378
43 
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
 1.258 ms 1 /classes/Cart.php:4192
86 
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 = 1239
ORDER BY f.position ASC
 1.256 ms 1 Yes /classes/Product.php:6002
127 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.210 ms 1 /classes/FeatureFlag.php:105
207 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361970', '', 'pharmaciedelalliance.com/en/brand/158-physiolac', '', '2025-01-18 12:53:49')
 1.195 ms 1 /classes/ObjectModel.php:622
6 
SELECT SQL_NO_CACHE *
FROM `pharm_country` a
LEFT JOIN `pharm_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `pharm_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 64) LIMIT 1
 1.182 ms 1 /src/Adapter/EntityMapper.php:71
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 1.179 ms 1034 /classes/Hook.php:1292
209 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 2099
AND `id_shop` = 1
 1.025 ms 1 /classes/Page.php:131
206 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361970', '2099', '2025-01-18 12:53:49')
 1.018 ms 1 /classes/Connection.php:122
203 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'manufacturer' LIMIT 1
 1.005 ms 1 /classes/Page.php:104
211 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.986 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
78 
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` = 1239
AND image_shop.`cover` = 1 LIMIT 1
 0.983 ms 1 /classes/Product.php:3570
77 
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.980 ms 0 /classes/tax/TaxRulesTaxManager.php:109
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` = 1240
ORDER BY `position`
 0.963 ms 1 Yes /classes/Product.php:3545
129 
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` = 1239
ORDER BY `position`
 0.929 ms 1 Yes /classes/Product.php:3545
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.890 ms 1 Yes /classes/shop/Shop.php:715
42 
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.863 ms 104 /classes/module/Module.php:345
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.860 ms 104 /classes/module/Module.php:345
81 
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` = 1239)
 0.809 ms 1 /classes/Product.php:3860
105 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1237
ORDER BY f.position ASC
 0.799 ms 1 Yes /classes/Product.php:6002
95 
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` = 1238 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` = 1238 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.795 ms 0 /classes/Cart.php:1410
104 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1237 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` = 1237 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.789 ms 0 /classes/Cart.php:1410
123 
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` = 1235 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` = 1235 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.787 ms 0 /classes/Cart.php:1410
114 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1236 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` = 1236 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.783 ms 0 /classes/Cart.php:1410
124 
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 = 1235
ORDER BY f.position ASC
 0.763 ms 1 Yes /classes/Product.php:6002
96 
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 = 1238
ORDER BY f.position ASC
 0.761 ms 1 Yes /classes/Product.php:6002
115 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1236
ORDER BY f.position ASC
 0.750 ms 1 Yes /classes/Product.php:6002
109 
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` = 1236) AND (b.`id_shop` = 1) LIMIT 1
 0.699 ms 1 /src/Adapter/EntityMapper.php:71
90 
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` = 1238) AND (b.`id_shop` = 1) LIMIT 1
 0.686 ms 1 /src/Adapter/EntityMapper.php:71
39 
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.682 ms 1 /src/Adapter/EntityMapper.php:71
33 
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.660 ms 1 /src/Adapter/EntityMapper.php:71
118 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1235) AND (b.`id_shop` = 1) LIMIT 1
 0.660 ms 1 /src/Adapter/EntityMapper.php:71
99 
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` = 1237) AND (b.`id_shop` = 1) LIMIT 1
 0.657 ms 1 /src/Adapter/EntityMapper.php:71
178 
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 (1238) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.648 ms 1 Yes Yes /classes/Product.php:4507
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.627 ms 2 /classes/Language.php:1080
31 
SELECT SQL_NO_CACHE value FROM `pharm_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.613 ms 1 /classes/shop/Shop.php:1183
176 
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 (1239) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.600 ms 1 Yes Yes /classes/Product.php:4507
91 
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` = 1238)
 0.597 ms 1 /classes/Product.php:3860
46 
SELECT SQL_NO_CACHE *
FROM `pharm_manufacturer` a
LEFT JOIN `pharm_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `pharm_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 158) LIMIT 1
 0.564 ms 1 /src/Adapter/EntityMapper.php:71
167 
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` <= 2 AND c.`nright` >= 571 AND c.`nleft` >= 2 AND c.`nright` <= 571 ORDER BY `nleft` DESC
 0.561 ms 1 /classes/Category.php:1600
29 
SELECT SQL_NO_CACHE * FROM `pharm_currency` c ORDER BY `iso_code` ASC
 0.557 ms 1 Yes /classes/Currency.php:709
119 
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` = 1235)
 0.553 ms 1 /classes/Product.php:3860
180 
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 (1237) 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
87 
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` = 1238
AND image_shop.`cover` = 1 LIMIT 1
 0.540 ms 1 /classes/Product.php:3570
66 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 158
AND `active` = 1 LIMIT 1
 0.536 ms 1 /classes/Manufacturer.php:316
184 
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 (1235) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.534 ms 1 Yes Yes /classes/Product.php:4507
164 
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.533 ms 2 /classes/Category.php:2242
182 
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 (1236) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.533 ms 1 Yes Yes /classes/Product.php:4507
185 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_servicecmsblock" LIMIT 1
 0.527 ms 1 /classes/module/Module.php:2636
110 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1236)
 0.524 ms 1 /classes/Product.php:3860
20 
SELECT SQL_NO_CACHE * FROM `pharm_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.523 ms 1 /classes/module/Module.php:2018
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` = 1236
ORDER BY `position`
 0.523 ms 1 Yes /classes/Product.php:3545
100 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1237)
 0.519 ms 1 /classes/Product.php:3860
205 
INSERT INTO `pharm_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('403105', '2099', '308350554', '', '1', '1', '2025-01-18 12:53:49')
 0.516 ms 1 /classes/ObjectModel.php:622
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` = 1237
ORDER BY `position`
 0.513 ms 1 Yes /classes/Product.php:3545
73 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_group`
WHERE `id_group` = 1 LIMIT 1
 0.511 ms 1 /classes/Group.php:154
47 
SELECT SQL_NO_CACHE * FROM `pharm_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.506 ms 7 Yes /classes/ImageType.php:109
40 
SELECT SQL_NO_CACHE *
FROM `pharm_group_lang`
WHERE `id_group` = 1
 0.503 ms 2 /src/Adapter/EntityMapper.php:79
97 
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` = 1237
AND image_shop.`cover` = 1 LIMIT 1
 0.503 ms 1 /classes/Product.php:3570
17 
SELECT SQL_NO_CACHE `name`, `alias` FROM `pharm_hook_alias`
 0.502 ms 88 /classes/Hook.php:287
116 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1235
AND image_shop.`cover` = 1 LIMIT 1
 0.498 ms 1 /classes/Product.php:3570
106 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1236
AND image_shop.`cover` = 1 LIMIT 1
 0.493 ms 1 /classes/Product.php:3570
74 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1240) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.478 ms 1 /classes/stock/StockAvailable.php:453
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` = 1238
ORDER BY `position`
 0.463 ms 1 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` = 1235
ORDER BY `position`
 0.462 ms 1 Yes /classes/Product.php:3545
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.436 ms 1 /classes/shop/Shop.php:218
51 
SELECT SQL_NO_CACHE *
FROM `pharm_country_lang`
WHERE `id_country` = 64
 0.436 ms 2 /src/Adapter/EntityMapper.php:79
79 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 134 LIMIT 1
 0.421 ms 1 /classes/Product.php:5642
84 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1239) 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
50 
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.411 ms 1 /src/Adapter/EntityMapper.php:71
35 
SELECT SQL_NO_CACHE `id_country`
FROM `pharm_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.396 ms 1 /classes/Country.php:194
30 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.393 ms 2 /classes/Language.php:883
131 
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` = 1238
ORDER BY `position`
 0.386 ms 1 Yes /classes/Product.php:3545
3 
SELECT SQL_NO_CACHE *
FROM `pharm_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.383 ms 1 /src/Adapter/EntityMapper.php:71
168 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_leftbanner" LIMIT 1
 0.383 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.380 ms 2 /classes/Language.php:1216
139 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.370 ms 1 /classes/module/Module.php:2636
133 
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` = 1237
ORDER BY `position`
 0.367 ms 1 Yes /classes/Product.php:3545
137 
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` = 1235
ORDER BY `position`
 0.361 ms 1 Yes /classes/Product.php:3545
135 
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` = 1236
ORDER BY `position`
 0.358 ms 1 Yes /classes/Product.php:3545
83 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1239 AND `id_group` = 1 LIMIT 1
 0.356 ms 0 /classes/GroupReduction.php:156
199 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_socialfollow" LIMIT 1
 0.356 ms 1 /classes/module/Module.php:2636
52 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pharm_required_field
 0.340 ms 1 /classes/ObjectModel.php:1592
169 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 89 AND `id_shop` = 1 LIMIT 1
 0.328 ms 1 /classes/module/Module.php:2109
122 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1235) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.327 ms 1 /classes/stock/StockAvailable.php:453
98 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 133 LIMIT 1
 0.325 ms 1 /classes/Product.php:5642
165 
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` = 2 LIMIT 1
 0.310 ms 1 /classes/Category.php:1585
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.305 ms 1 /modules/ps_mbo/ps_mbo.php:335
126 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1240
 0.304 ms 1 /classes/Product.php:2902
24 
SELECT SQL_NO_CACHE name, alias FROM `pharm_hook_alias`
 0.301 ms 88 /classes/Hook.php:339
113 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1236) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.297 ms 1 /classes/stock/StockAvailable.php:453
130 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1239
 0.294 ms 1 /classes/Product.php:2902
186 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
 0.293 ms 1 /classes/module/Module.php:2109
94 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1238) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.291 ms 1 /classes/stock/StockAvailable.php:453
128 
SELECT SQL_NO_CACHE * FROM `pharm_image_type`
 0.289 ms 7 /classes/ImageType.php:161
88 
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` = 133 LIMIT 1
 0.285 ms 1 /classes/Category.php:1378
54 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
 0.283 ms 1 /classes/module/Module.php:2109
7 
SELECT SQL_NO_CACHE *
FROM `pharm_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.281 ms 1 /src/Adapter/EntityMapper.php:71
140 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1
 0.279 ms 1 /classes/module/Module.php:2109
32 
SELECT SQL_NO_CACHE c.id_currency
FROM `pharm_currency` c
WHERE (iso_code = 'XAF') LIMIT 1
 0.278 ms 1 /classes/Currency.php:893
103 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 1237) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.275 ms 1 /classes/stock/StockAvailable.php:453
34 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.274 ms 2 /classes/Language.php:883
53 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_facebook" LIMIT 1
 0.271 ms 1 /classes/module/Module.php:2636
189 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.267 ms 1 /classes/Country.php:405
117 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 132 LIMIT 1
 0.265 ms 1 /classes/Product.php:5642
210 
INSERT INTO `pharm_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('106', '2099', '1', '1', '1')
 0.265 ms 1 /classes/Page.php:142
82 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1239 AND id_shop=1 LIMIT 1
 0.260 ms 1 /classes/Product.php:6857
146 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_toplink" LIMIT 1
 0.260 ms 1 /classes/module/Module.php:2636
49 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.259 ms 1 /classes/Country.php:405
107 
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` = 132 LIMIT 1
 0.259 ms 1 /classes/Category.php:1378
200 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1
 0.258 ms 1 /classes/module/Module.php:2109
64 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 134 LIMIT 1
 0.251 ms 1 /classes/Product.php:5642
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.250 ms 1 /src/Adapter/EntityMapper.php:71
147 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 69 AND `id_shop` = 1 LIMIT 1
 0.249 ms 1 /classes/module/Module.php:2109
121 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1235 AND `id_group` = 1 LIMIT 1
 0.244 ms 0 /classes/GroupReduction.php:156
170 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_newproducts" LIMIT 1
 0.243 ms 1 /classes/module/Module.php:2636
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pharm_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.242 ms 1 /classes/shop/ShopUrl.php:182
38 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.241 ms 1 /classes/ObjectModel.php:1729
68 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1240 AND id_shop=1 LIMIT 1
 0.240 ms 1 /classes/Product.php:6857
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.238 ms 1 /modules/ps_mbo/ps_mbo.php:335
157 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
 0.238 ms 1 /classes/module/Module.php:2109
93 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1238 AND `id_group` = 1 LIMIT 1
 0.231 ms 0 /classes/GroupReduction.php:156
160 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.230 ms 1 /classes/module/Module.php:2636
112 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1236 AND `id_group` = 1 LIMIT 1
 0.230 ms 0 /classes/GroupReduction.php:156
156 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_mainmenu" LIMIT 1
 0.229 ms 1 /classes/module/Module.php:2636
158 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_headercmsblock" LIMIT 1
 0.228 ms 1 /classes/module/Module.php:2636
36 
SELECT SQL_NO_CACHE *
FROM `pharm_currency` a
LEFT JOIN `pharm_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.227 ms 1 /src/Adapter/EntityMapper.php:71
142 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
 0.227 ms 1 /classes/module/Module.php:2109
102 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1237 AND `id_group` = 1 LIMIT 1
 0.226 ms 0 /classes/GroupReduction.php:156
161 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1
 0.224 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.221 ms 1 /src/Adapter/EntityMapper.php:71
171 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 76 AND `id_shop` = 1 LIMIT 1
 0.217 ms 1 /classes/module/Module.php:2109
159 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 71 AND `id_shop` = 1 LIMIT 1
 0.216 ms 1 /classes/module/Module.php:2109
166 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `pharm_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.216 ms 1 /classes/Category.php:1591
37 
SELECT SQL_NO_CACHE *
FROM `pharm_currency_lang`
WHERE `id_currency` = 1
 0.212 ms 2 /src/Adapter/EntityMapper.php:79
132 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1238
 0.210 ms 1 /classes/Product.php:2902
187 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_contactinfo" LIMIT 1
 0.205 ms 1 /classes/module/Module.php:2636
22 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.203 ms 1 /modules/ps_mbo/ps_mbo.php:325
120 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1235 AND id_shop=1 LIMIT 1
 0.202 ms 1 /classes/Product.php:6857
141 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 0.197 ms 1 /classes/module/Module.php:2636
138 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1235
 0.197 ms 1 /classes/Product.php:2902
134 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1237
 0.193 ms 1 /classes/Product.php:2902
136 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 1236
 0.191 ms 1 /classes/Product.php:2902
55 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_accounts" LIMIT 1
 0.188 ms 1 /src/Adapter/Module/ModuleDataProvider.php:257
57 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
 0.186 ms 0 /classes/module/Module.php:2109
12 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.184 ms 2 /classes/Language.php:854
56 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "productcomments" LIMIT 1
 0.184 ms 1 /classes/module/Module.php:2636
44 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.183 ms 0 /classes/module/Module.php:2636
143 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_navcmsblock" LIMIT 1
 0.181 ms 1 /classes/module/Module.php:2636
153 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
 0.181 ms 1 /classes/module/Module.php:2109
192 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
 0.181 ms 1 /classes/module/Module.php:2636
92 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1238 AND id_shop=1 LIMIT 1
 0.180 ms 1 /classes/Product.php:6857
9 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.179 ms 1 /classes/ObjectModel.php:1729
28 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_manufacturer_shop`
WHERE `id_manufacturer` = 158
AND id_shop = 1 LIMIT 1
 0.177 ms 1 /classes/ObjectModel.php:1729
190 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_linklist" LIMIT 1
 0.176 ms 1 /classes/module/Module.php:2636
188 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1
 0.175 ms 1 /classes/module/Module.php:2109
101 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1237 AND id_shop=1 LIMIT 1
 0.174 ms 1 /classes/Product.php:6857
89 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 133 LIMIT 1
 0.173 ms 1 /classes/Product.php:5642
191 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1
 0.173 ms 1 /classes/module/Module.php:2109
111 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 1236 AND id_shop=1 LIMIT 1
 0.173 ms 1 /classes/Product.php:6857
144 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 68 AND `id_shop` = 1 LIMIT 1
 0.172 ms 1 /classes/module/Module.php:2109
148 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.172 ms 1 /classes/module/Module.php:2636
150 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_customersignin" LIMIT 1
 0.171 ms 1 /classes/module/Module.php:2636
25 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.170 ms 1 /modules/ps_mbo/ps_mbo.php:325
41 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.169 ms 1 /classes/ObjectModel.php:1729
196 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_footercmsblock" LIMIT 1
 0.167 ms 1 /classes/module/Module.php:2636
108 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 132 LIMIT 1
 0.165 ms 1 /classes/Product.php:5642
151 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1
 0.165 ms 1 /classes/module/Module.php:2109