Home

Home

List of products by brand DANONE

Active filters

Load Time 299.709 ms
Querying Time 169 ms
Queries 226
Memory Peak Usage 9.9 Mb
Included Files 1088 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.820 ms 2.820 ms 2.19 Mb 2.6 Mb
__construct 0.020 ms 2.840 ms - Mb 2.6 Mb
init 17.541 ms 20.381 ms 0.42 Mb 3.1 Mb
checkAccess 0.002 ms 20.383 ms - Mb 3.1 Mb
setMedia 3.449 ms 23.832 ms 0.18 Mb 3.1 Mb
postProcess 0.002 ms 23.834 ms - Mb 3.1 Mb
initHeader 0.001 ms 23.835 ms - Mb 3.1 Mb
initContent 141.015 ms 164.850 ms 3.04 Mb 5.9 Mb
initFooter 0.004 ms 164.854 ms - Mb 5.9 Mb
display 134.855 ms 299.709 ms 3.68 Mb 9.9 Mb
Hook Time Memory Usage
DisplayProductListReviews 25.947 ms 0.07 Mb
displayLeftColumn 25.748 ms 1.02 Mb
DisplayHeader 14.116 ms 0.44 Mb
DisplayBeforeBodyClosingTag 14.082 ms 0.30 Mb
displayNavFullWidth 7.008 ms 0.56 Mb
DisplayCzHoverImage 6.726 ms 0.27 Mb
displayNav1 5.887 ms 0.16 Mb
displayFooter 5.244 ms 0.32 Mb
DisplayFooter 4.258 ms 0.05 Mb
displayTop 3.508 ms 0.15 Mb
DisplayStWishlistButton 1.709 ms 0.01 Mb
DisplayStCompareButton 1.560 ms 0.01 Mb
displayNav2 1.454 ms 0.05 Mb
displayFooterBefore 1.222 ms 0.05 Mb
displayFooterAfter 1.086 ms 0.05 Mb
ActionFrontControllerSetMedia 0.605 ms 0.07 Mb
ProductSearchProvider 0.597 ms - Mb
ActionDispatcherBefore 0.579 ms 0.01 Mb
DisplayStCompareTopLink 0.496 ms 0.01 Mb
DisplayLeftColumn 0.359 ms 0.04 Mb
DisplayContentWrapperBottom 0.090 ms - Mb
21 hook(s) 122.282 ms 3.66 Mb
Module Time Memory Usage
ps_mbo 6.229 ms 0.06 Mb
blockreassurance 1.344 ms 0.14 Mb
ps_emailsubscription 1.123 ms 0.07 Mb
ps_socialfollow 1.286 ms 0.06 Mb
ps_emailalerts 0.210 ms 0.01 Mb
ps_facebook 10.786 ms 0.29 Mb
ps_shoppingcart 0.741 ms 0.05 Mb
ps_searchbar 1.564 ms 0.06 Mb
ps_googleanalytics 3.610 ms 0.10 Mb
cz_imageslider 0.276 ms 0.01 Mb
czcouponpop 0.146 ms 0.01 Mb
ps_accounts 0.350 ms 0.07 Mb
azameo 0.530 ms 0.02 Mb
psxmarketingwithgoogle 0.653 ms 0.01 Mb
chatyprestashop 0.470 ms 0.01 Mb
cz_verticalmenu 5.265 ms 0.47 Mb
myprestacomments 27.491 ms 0.17 Mb
psproductcountdown 1.207 ms 0.07 Mb
stfeature 4.574 ms 0.06 Mb
ps_facetedsearch 1.873 ms 0.06 Mb
ps_languageselector 2.043 ms 0.05 Mb
ps_currencyselector 0.784 ms 0.05 Mb
cz_navcmsblock 3.758 ms 0.08 Mb
cz_toplink 1.709 ms 0.06 Mb
ps_customersignin 1.949 ms 0.07 Mb
ps_mainmenu 1.286 ms 0.06 Mb
cz_headercmsblock 1.214 ms 0.06 Mb
ps_categorytree 16.742 ms 0.87 Mb
cz_leftbanner 1.461 ms 0.05 Mb
cz_newproducts 8.074 ms 0.12 Mb
cz_imagehover 6.963 ms 0.28 Mb
ldinstagramslider 0.306 ms 0.01 Mb
cz_servicecmsblock 1.400 ms 0.06 Mb
ps_contactinfo 1.643 ms 0.08 Mb
ps_linklist 1.286 ms 0.07 Mb
ps_customeraccountlinks 1.049 ms 0.07 Mb
cz_footercmsblock 1.148 ms 0.06 Mb
czuecookie 4.357 ms 0.06 Mb
statsdata 11.268 ms 0.23 Mb
39 module(s) 138.167 ms 4.17 Mb

Stopwatch SQL - 226 queries

# Query Time (ms) Rows Filesort Group By Location
184 
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.852 ms 4912 Yes /classes/Product.php:3110
2 
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `pharm_configuration` c
LEFT JOIN `pharm_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 6.454 ms 665 /classes/Configuration.php:180
16 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pharm_module` m
INNER JOIN pharm_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `pharm_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pharm_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pharm_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 5.899 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='92' GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 5.652 ms 56 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
175 
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
 5.350 ms 286 Yes Yes /classes/Category.php:799
79 
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 = 499
ORDER BY f.position ASC
 4.592 ms 1 Yes /classes/Product.php:6002
186 
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 (499) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 4.511 ms 1 Yes Yes /classes/Product.php:4507
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
 3.392 ms 0 /classes/Hook.php:1292
212 
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.378 ms 1 /src/Adapter/EntityMapper.php:71
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` = 1
AND tr.`id_state` IN (0, 0)
AND ('11526' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '11526')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 2.924 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 2.907 ms 1034 /classes/Hook.php:1332
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
 2.892 ms 1 /classes/Cart.php:4192
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
 2.791 ms 468 /classes/Hook.php:456
78 
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` = 499 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` = 499 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2.695 ms 0 /classes/Cart.php:1410
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` = 499
ORDER BY `position`
 2.574 ms 1 Yes /classes/Product.php:3545
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.539 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 (499,498,497,496,495,494,493)
 2.491 ms 7 /classes/ProductAssembler.php:95
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
 1.994 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
157 
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
 1.943 ms 1 /classes/Currency.php:1136
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` = 499)
 1.645 ms 1 /classes/Product.php:3860
174 
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
 1.566 ms 1 /src/Adapter/EntityMapper.php:71
60 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="d074f666b10cec63cc35839874882cec" LIMIT 1
 1.528 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
215 
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.526 ms 1 /classes/ObjectModel.php:622
137 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.265 ms 1 /classes/FeatureFlag.php:105
48 
SELECT SQL_NO_CACHE format
FROM `pharm_address_format`
WHERE `id_country` = 64 LIMIT 1
 1.256 ms 1 /classes/AddressFormat.php:656
88 
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` = 498 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` = 498 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.255 ms 0 /classes/Cart.php:1410
225 
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 (499,498,497,496,495,494,493) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 1.244 ms 21 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
89 
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 = 498
ORDER BY f.position ASC
 1.241 ms 1 Yes /classes/Product.php:6002
83 
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` = 498) AND (b.`id_shop` = 1) LIMIT 1
 1.236 ms 1 /src/Adapter/EntityMapper.php:71
216 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 403009
AND `date_add` > '2025-01-18 11:27:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.182 ms 1 Yes /classes/Connection.php:168
222 
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.114 ms 4096 /classes/DateRange.php:60
139 
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` = 498
ORDER BY `position`
 1.072 ms 1 Yes /classes/Product.php:3545
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 1.072 ms 1034 /classes/Hook.php:1292
223 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 625
AND `id_shop` = 1
 1.059 ms 1 /classes/Page.php:131
72 
SELECT SQL_NO_CACHE *
FROM `pharm_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 1.041 ms 1 /src/Adapter/EntityMapper.php:71
218 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 9 AND `id_object` = 92 LIMIT 1
 1.021 ms 1 /classes/Page.php:83
221 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361886', '', 'pharmaciedelalliance.com/en/brand/92-danone', '', '2025-01-18 11:57:20')
 1.010 ms 1 /classes/ObjectModel.php:622
187 
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` = 498
ORDER BY `position`
 0.976 ms 1 Yes /classes/Product.php:3545
73 
SELECT SQL_NO_CACHE *
FROM `pharm_tax_lang`
WHERE `id_tax` = 1
 0.950 ms 2 /src/Adapter/EntityMapper.php:79
220 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361886', '625', '2025-01-18 11:57:20')
 0.945 ms 1 /classes/Connection.php:122
106 
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` = 496 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` = 496 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.933 ms 0 /classes/Cart.php:1410
80 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.914 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
97 
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` = 497 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` = 497 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.891 ms 0 /classes/Cart.php:1410
133 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 493 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` = 493 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.887 ms 0 /classes/Cart.php:1410
124 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 494 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` = 494 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.882 ms 0 /classes/Cart.php:1410
98 
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 = 497
ORDER BY f.position ASC
 0.864 ms 1 Yes /classes/Product.php:6002
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.855 ms 104 /classes/module/Module.php:345
107 
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 = 496
ORDER BY f.position ASC
 0.853 ms 1 Yes /classes/Product.php:6002
217 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'manufacturer' LIMIT 1
 0.846 ms 1 /classes/Page.php:104
115 
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` = 495 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` = 495 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.836 ms 0 /classes/Cart.php:1410
74 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 499 AND `id_group` = 1 LIMIT 1
 0.834 ms 0 /classes/GroupReduction.php:156
81 
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` = 498
AND image_shop.`cover` = 1 LIMIT 1
 0.829 ms 1 /classes/Product.php:3570
76 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('11526' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '11526')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.801 ms 0 /classes/tax/TaxRulesTaxManager.php:109
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` = 499
AND image_shop.`cover` = 1 LIMIT 1
 0.799 ms 1 /classes/Product.php:3570
134 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 493
ORDER BY f.position ASC
 0.791 ms 1 Yes /classes/Product.php:6002
125 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 494
ORDER BY f.position ASC
 0.786 ms 1 Yes /classes/Product.php:6002
92 
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` = 497) AND (b.`id_shop` = 1) LIMIT 1
 0.778 ms 1 /src/Adapter/EntityMapper.php:71
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` = 92) LIMIT 1
 0.772 ms 1 /src/Adapter/EntityMapper.php:71
224 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.765 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
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` = 92) LIMIT 1
 0.759 ms 1 /src/Adapter/EntityMapper.php:71
116 
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 = 495
ORDER BY f.position ASC
 0.758 ms 1 Yes /classes/Product.php:6002
119 
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` = 494) AND (b.`id_shop` = 1) LIMIT 1
 0.753 ms 1 /src/Adapter/EntityMapper.php:71
101 
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` = 496) AND (b.`id_shop` = 1) LIMIT 1
 0.750 ms 1 /src/Adapter/EntityMapper.php:71
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.727 ms 1 Yes /classes/shop/Shop.php:1364
128 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 493) AND (b.`id_shop` = 1) LIMIT 1
 0.696 ms 1 /src/Adapter/EntityMapper.php:71
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.689 ms 104 /classes/module/Module.php:345
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.684 ms 1 Yes /classes/shop/Shop.php:715
110 
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` = 495) AND (b.`id_shop` = 1) LIMIT 1
 0.681 ms 1 /src/Adapter/EntityMapper.php:71
185 
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` = 499
ORDER BY `position`
 0.666 ms 1 Yes /classes/Product.php:3545
99 
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` = 496
AND image_shop.`cover` = 1 LIMIT 1
 0.663 ms 1 /classes/Product.php:3570
90 
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` = 497
AND image_shop.`cover` = 1 LIMIT 1
 0.606 ms 1 /classes/Product.php:3570
102 
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` = 496)
 0.604 ms 1 /classes/Product.php:3860
126 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 493
AND image_shop.`cover` = 1 LIMIT 1
 0.553 ms 1 /classes/Product.php:3570
31 
SELECT SQL_NO_CACHE value FROM `pharm_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.552 ms 1 /classes/shop/Shop.php:1183
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` = 499) AND (b.`id_shop` = 1) LIMIT 1
 0.548 ms 1 /src/Adapter/EntityMapper.php:71
117 
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` = 494
AND image_shop.`cover` = 1 LIMIT 1
 0.542 ms 1 /classes/Product.php:3570
194 
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 (495) 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
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.523 ms 1 /src/Adapter/EntityMapper.php:71
188 
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 (498) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.506 ms 1 Yes Yes /classes/Product.php:4507
192 
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 (496) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.503 ms 1 Yes Yes /classes/Product.php:4507
108 
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` = 495
AND image_shop.`cover` = 1 LIMIT 1
 0.499 ms 1 /classes/Product.php:3570
198 
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 (493) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.497 ms 1 Yes Yes /classes/Product.php:4507
190 
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 (497) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.493 ms 1 Yes Yes /classes/Product.php:4507
24 
SELECT SQL_NO_CACHE name, alias FROM `pharm_hook_alias`
 0.491 ms 88 /classes/Hook.php:339
111 
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` = 495)
 0.491 ms 1 /classes/Product.php:3860
40 
SELECT SQL_NO_CACHE *
FROM `pharm_group_lang`
WHERE `id_group` = 1
 0.485 ms 2 /src/Adapter/EntityMapper.php:79
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.482 ms 1 /src/Adapter/EntityMapper.php:71
196 
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 (494) 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
17 
SELECT SQL_NO_CACHE `name`, `alias` FROM `pharm_hook_alias`
 0.469 ms 88 /classes/Hook.php:287
120 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 494)
 0.463 ms 1 /classes/Product.php:3860
84 
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` = 498)
 0.458 ms 1 /classes/Product.php:3860
29 
SELECT SQL_NO_CACHE * FROM `pharm_currency` c ORDER BY `iso_code` ASC
 0.453 ms 1 Yes /classes/Currency.php:709
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.448 ms 1 /classes/shop/Shop.php:218
93 
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` = 497)
 0.446 ms 1 /classes/Product.php:3860
219 
INSERT INTO `pharm_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('403009', '625', '308350554', '', '1', '1', '2025-01-18 11:57:20')
 0.442 ms 1 /classes/ObjectModel.php:622
47 
SELECT SQL_NO_CACHE * FROM `pharm_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.436 ms 7 Yes /classes/ImageType.php:109
66 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 92
AND `active` = 1 LIMIT 1
 0.433 ms 1 /classes/Manufacturer.php:316
77 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 499) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.433 ms 1 /classes/stock/StockAvailable.php:453
129 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 493)
 0.425 ms 1 /classes/Product.php:3860
141 
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` = 497
ORDER BY `position`
 0.412 ms 1 Yes /classes/Product.php:3545
5 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `pharm_lang` l
LEFT JOIN `pharm_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.410 ms 2 /classes/Language.php:1080
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` = 181 LIMIT 1
 0.408 ms 1 /classes/Category.php:1378
143 
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` = 496
ORDER BY `position`
 0.407 ms 1 Yes /classes/Product.php:3545
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.403 ms 1 /src/Adapter/EntityMapper.php:71
151 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.403 ms 1 /classes/module/Module.php:2636
105 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 496) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.397 ms 1 /classes/stock/StockAvailable.php:453
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.384 ms 2 /classes/Language.php:1216
176 
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.380 ms 2 /classes/Category.php:2242
149 
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` = 493
ORDER BY `position`
 0.379 ms 1 Yes /classes/Product.php:3545
189 
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` = 497
ORDER BY `position`
 0.379 ms 1 Yes /classes/Product.php:3545
147 
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` = 494
ORDER BY `position`
 0.379 ms 1 Yes /classes/Product.php:3545
179 
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.378 ms 1 /classes/Category.php:1600
191 
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` = 496
ORDER BY `position`
 0.378 ms 1 Yes /classes/Product.php:3545
145 
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` = 495
ORDER BY `position`
 0.374 ms 1 Yes /classes/Product.php:3545
195 
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` = 494
ORDER BY `position`
 0.372 ms 1 Yes /classes/Product.php:3545
197 
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` = 493
ORDER BY `position`
 0.372 ms 1 Yes /classes/Product.php:3545
82 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 181 LIMIT 1
 0.371 ms 1 /classes/Product.php:5642
100 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 181 LIMIT 1
 0.371 ms 1 /classes/Product.php:5642
51 
SELECT SQL_NO_CACHE *
FROM `pharm_country_lang`
WHERE `id_country` = 64
 0.370 ms 2 /src/Adapter/EntityMapper.php:79
104 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 496 AND `id_group` = 1 LIMIT 1
 0.369 ms 0 /classes/GroupReduction.php:156
193 
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` = 495
ORDER BY `position`
 0.364 ms 1 Yes /classes/Product.php:3545
30 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.361 ms 2 /classes/Language.php:883
180 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_leftbanner" LIMIT 1
 0.358 ms 1 /classes/module/Module.php:2636
35 
SELECT SQL_NO_CACHE `id_country`
FROM `pharm_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.348 ms 1 /classes/Country.php:194
140 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 498
 0.348 ms 1 /classes/Product.php:2902
114 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 495) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.341 ms 1 /classes/stock/StockAvailable.php:453
75 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_group`
WHERE `id_group` = 1 LIMIT 1
 0.341 ms 1 /classes/Group.php:154
91 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 181 LIMIT 1
 0.339 ms 1 /classes/Product.php:5642
136 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 499
 0.339 ms 1 /classes/Product.php:2902
199 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_servicecmsblock" LIMIT 1
 0.332 ms 1 /classes/module/Module.php:2636
87 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 498) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.330 ms 1 /classes/stock/StockAvailable.php:453
44 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.328 ms 0 /classes/module/Module.php:2636
53 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_facebook" LIMIT 1
 0.328 ms 1 /classes/module/Module.php:2636
96 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 497) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.328 ms 1 /classes/stock/StockAvailable.php:453
20 
SELECT SQL_NO_CACHE * FROM `pharm_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.326 ms 1 /classes/module/Module.php:2018
45 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.323 ms 0 /classes/module/Module.php:2109
49 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.321 ms 1 /classes/Country.php:405
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.320 ms 1 /modules/ps_mbo/ps_mbo.php:335
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.320 ms 1 /src/Adapter/EntityMapper.php:71
123 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 494) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.318 ms 1 /classes/stock/StockAvailable.php:453
127 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 181 LIMIT 1
 0.316 ms 1 /classes/Product.php:5642
138 
SELECT SQL_NO_CACHE * FROM `pharm_image_type`
 0.314 ms 7 /classes/ImageType.php:161
52 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pharm_required_field
 0.305 ms 1 /classes/ObjectModel.php:1592
113 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 495 AND `id_group` = 1 LIMIT 1
 0.300 ms 0 /classes/GroupReduction.php:156
132 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 493) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.289 ms 1 /classes/stock/StockAvailable.php:453
152 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1
 0.289 ms 1 /classes/module/Module.php:2109
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.288 ms 1 /src/Adapter/EntityMapper.php:71
122 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 494 AND `id_group` = 1 LIMIT 1
 0.288 ms 0 /classes/GroupReduction.php:156
37 
SELECT SQL_NO_CACHE *
FROM `pharm_currency_lang`
WHERE `id_currency` = 1
 0.279 ms 2 /src/Adapter/EntityMapper.php:79
158 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_toplink" LIMIT 1
 0.279 ms 1 /classes/module/Module.php:2636
3 
SELECT SQL_NO_CACHE *
FROM `pharm_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.276 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.274 ms 1 /src/Adapter/EntityMapper.php:71
109 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 181 LIMIT 1
 0.268 ms 1 /classes/Product.php:5642
159 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 69 AND `id_shop` = 1 LIMIT 1
 0.268 ms 1 /classes/module/Module.php:2109
213 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_socialfollow" LIMIT 1
 0.266 ms 1 /classes/module/Module.php:2636
32 
SELECT SQL_NO_CACHE c.id_currency
FROM `pharm_currency` c
WHERE (iso_code = 'XAF') LIMIT 1
 0.265 ms 1 /classes/Currency.php:893
85 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 498 AND id_shop=1 LIMIT 1
 0.263 ms 1 /classes/Product.php:6857
181 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 89 AND `id_shop` = 1 LIMIT 1
 0.262 ms 1 /classes/module/Module.php:2109
200 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
 0.262 ms 1 /classes/module/Module.php:2109
203 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.262 ms 1 /classes/Country.php:405
118 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 181 LIMIT 1
 0.261 ms 1 /classes/Product.php:5642
64 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 181 LIMIT 1
 0.257 ms 1 /classes/Product.php:5642
7 
SELECT SQL_NO_CACHE *
FROM `pharm_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.253 ms 1 /src/Adapter/EntityMapper.php:71
103 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 496 AND id_shop=1 LIMIT 1
 0.253 ms 1 /classes/Product.php:6857
214 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1
 0.252 ms 1 /classes/module/Module.php:2109
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.251 ms 1 /modules/ps_mbo/ps_mbo.php:335
56 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "productcomments" LIMIT 1
 0.251 ms 1 /classes/module/Module.php:2636
86 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 498 AND `id_group` = 1 LIMIT 1
 0.251 ms 0 /classes/GroupReduction.php:156
121 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 494 AND id_shop=1 LIMIT 1
 0.250 ms 1 /classes/Product.php:6857
54 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
 0.250 ms 1 /classes/module/Module.php:2109
131 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 493 AND `id_group` = 1 LIMIT 1
 0.244 ms 0 /classes/GroupReduction.php:156
22 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.243 ms 1 /modules/ps_mbo/ps_mbo.php:325
146 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 495
 0.242 ms 1 /classes/Product.php:2902
57 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
 0.241 ms 0 /classes/module/Module.php:2109
95 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 497 AND `id_group` = 1 LIMIT 1
 0.239 ms 0 /classes/GroupReduction.php:156
142 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 497
 0.239 ms 1 /classes/Product.php:2902
28 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_manufacturer_shop`
WHERE `id_manufacturer` = 92
AND id_shop = 1 LIMIT 1
 0.238 ms 1 /classes/ObjectModel.php:1729
25 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.233 ms 1 /modules/ps_mbo/ps_mbo.php:325
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pharm_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.230 ms 1 /classes/shop/ShopUrl.php:182
55 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_accounts" LIMIT 1
 0.229 ms 1 /src/Adapter/Module/ModuleDataProvider.php:257
150 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 493
 0.229 ms 1 /classes/Product.php:2902
177 
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.224 ms 1 /classes/Category.php:1585
144 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 496
 0.222 ms 1 /classes/Product.php:2902
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.208 ms 1 /src/Adapter/EntityMapper.php:71
153 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 0.207 ms 1 /classes/module/Module.php:2636
148 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 494
 0.206 ms 1 /classes/Product.php:2902
112 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 495 AND id_shop=1 LIMIT 1
 0.199 ms 1 /classes/Product.php:6857
160 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.199 ms 1 /classes/module/Module.php:2636
34 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.194 ms 2 /classes/Language.php:883
162 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_customersignin" LIMIT 1
 0.193 ms 1 /classes/module/Module.php:2636
68 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 499 AND id_shop=1 LIMIT 1
 0.193 ms 1 /classes/Product.php:6857
211 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 106 AND `id_shop` = 1 LIMIT 1
 0.192 ms 1 /classes/module/Module.php:2109
163 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1
 0.191 ms 1 /classes/module/Module.php:2109
155 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_navcmsblock" LIMIT 1
 0.188 ms 1 /classes/module/Module.php:2636
94 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 497 AND id_shop=1 LIMIT 1
 0.186 ms 1 /classes/Product.php:6857
130 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 493 AND id_shop=1 LIMIT 1
 0.186 ms 1 /classes/Product.php:6857
156 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 68 AND `id_shop` = 1 LIMIT 1
 0.186 ms 1 /classes/module/Module.php:2109
161 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1
 0.186 ms 1 /classes/module/Module.php:2109
41 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.184 ms 1 /classes/ObjectModel.php:1729
168 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_mainmenu" LIMIT 1
 0.184 ms 1 /classes/module/Module.php:2636
154 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
 0.183 ms 1 /classes/module/Module.php:2109
164 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.181 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.180 ms 1 /classes/ObjectModel.php:1729
165 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
 0.175 ms 1 /classes/module/Module.php:2109
166 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_verticalmenu" LIMIT 1
 0.175 ms 1 /classes/module/Module.php:2636
182 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_newproducts" LIMIT 1
 0.173 ms 1 /classes/module/Module.php:2636
204 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_linklist" LIMIT 1
 0.173 ms 1 /classes/module/Module.php:2636
38 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.173 ms 1 /classes/ObjectModel.php:1729
12 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.172 ms 2 /classes/Language.php:854
201 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_contactinfo" LIMIT 1
 0.171 ms 1 /classes/module/Module.php:2636