Home

Home

List of products by brand JOHNSON & JOHNSON

Active filters

Load Time 386.765 ms
Querying Time 153 ms
Queries 190
Memory Peak Usage 9.2 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.711 ms 2.711 ms 2.19 Mb 2.6 Mb
__construct 0.020 ms 2.731 ms - Mb 2.6 Mb
init 16.459 ms 19.190 ms 0.42 Mb 3.1 Mb
checkAccess 0.002 ms 19.192 ms - Mb 3.1 Mb
setMedia 4.075 ms 23.267 ms 0.18 Mb 3.1 Mb
postProcess 0.001 ms 23.268 ms - Mb 3.1 Mb
initHeader 0.002 ms 23.270 ms - Mb 3.1 Mb
initContent 175.820 ms 199.090 ms 2.64 Mb 5.5 Mb
initFooter 0.005 ms 199.095 ms - Mb 5.5 Mb
display 187.670 ms 386.765 ms 3.40 Mb 9.2 Mb
Hook Time Memory Usage
DisplayHeader 52.082 ms 0.44 Mb
displayLeftColumn 34.797 ms 1.02 Mb
DisplayBeforeBodyClosingTag 16.078 ms 0.32 Mb
DisplayCzHoverImage 14.985 ms 0.15 Mb
DisplayProductListReviews 13.540 ms 0.04 Mb
displayFooter 11.046 ms 0.30 Mb
displayNavFullWidth 10.079 ms 0.56 Mb
displayNav1 7.452 ms 0.16 Mb
DisplayFooter 5.967 ms 0.05 Mb
ProductSearchProvider 4.317 ms - Mb
displayFooterBefore 3.257 ms 0.05 Mb
DisplayLeftColumn 2.874 ms 0.04 Mb
displayNav2 2.803 ms 0.06 Mb
displayTop 2.739 ms 0.15 Mb
displayFooterAfter 2.720 ms 0.05 Mb
DisplayStWishlistButton 2.463 ms 0.01 Mb
DisplayStCompareButton 2.459 ms 0.01 Mb
ActionFrontControllerSetMedia 0.608 ms 0.07 Mb
ActionDispatcherBefore 0.561 ms 0.01 Mb
DisplayStCompareTopLink 0.290 ms 0.01 Mb
DisplayContentWrapperBottom 0.096 ms - Mb
21 hook(s) 191.214 ms 3.51 Mb
Module Time Memory Usage
ps_mbo 5.558 ms 0.06 Mb
blockreassurance 1.562 ms 0.14 Mb
ps_emailsubscription 1.186 ms 0.06 Mb
ps_socialfollow 2.908 ms 0.06 Mb
ps_emailalerts 0.206 ms 0.01 Mb
ps_facebook 49.220 ms 0.29 Mb
ps_shoppingcart 0.786 ms 0.05 Mb
ps_searchbar 1.302 ms 0.05 Mb
ps_googleanalytics 4.743 ms 0.09 Mb
cz_imageslider 0.273 ms 0.01 Mb
czcouponpop 0.138 ms 0.01 Mb
ps_accounts 0.532 ms 0.07 Mb
azameo 0.721 ms 0.02 Mb
psxmarketingwithgoogle 0.599 ms 0.01 Mb
chatyprestashop 0.439 ms 0.01 Mb
cz_verticalmenu 5.771 ms 0.47 Mb
myprestacomments 15.630 ms 0.14 Mb
psproductcountdown 1.185 ms 0.07 Mb
stfeature 6.011 ms 0.05 Mb
ps_facetedsearch 15.751 ms 0.06 Mb
ps_languageselector 2.096 ms 0.05 Mb
ps_currencyselector 0.765 ms 0.05 Mb
cz_navcmsblock 5.131 ms 0.08 Mb
cz_toplink 2.952 ms 0.07 Mb
ps_customersignin 1.334 ms 0.07 Mb
ps_mainmenu 1.798 ms 0.06 Mb
cz_headercmsblock 3.090 ms 0.06 Mb
ps_categorytree 20.110 ms 0.87 Mb
cz_leftbanner 6.305 ms 0.05 Mb
cz_newproducts 10.337 ms 0.12 Mb
cz_imagehover 15.779 ms 0.16 Mb
ldinstagramslider 0.304 ms 0.01 Mb
cz_servicecmsblock 3.416 ms 0.06 Mb
ps_contactinfo 1.635 ms 0.08 Mb
ps_linklist 3.021 ms 0.07 Mb
ps_customeraccountlinks 3.344 ms 0.07 Mb
cz_footercmsblock 2.836 ms 0.06 Mb
czuecookie 6.080 ms 0.06 Mb
statsdata 12.052 ms 0.25 Mb
39 module(s) 216.907 ms 4.01 Mb

Stopwatch SQL - 190 queries

# Query Time (ms) Rows Filesort Group By Location
153 
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.984 ms 4912 Yes /classes/Product.php:3110
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`
 6.845 ms 1248 Yes Yes /classes/Hook.php:1233
2 
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `pharm_configuration` c
LEFT JOIN `pharm_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 6.471 ms 665 /classes/Configuration.php:180
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='151' GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 6.136 ms 88 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
144 
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.301 ms 286 Yes Yes /classes/Category.php:799
155 
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 (828) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 4.546 ms 1 Yes Yes /classes/Product.php:4507
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 = 828
ORDER BY f.position ASC
 4.403 ms 1 Yes /classes/Product.php:6002
175 
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.444 ms 1 /src/Adapter/EntityMapper.php:71
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.348 ms 0 /classes/Hook.php:1292
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.771 ms 468 /classes/Hook.php:456
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.631 ms 102 Yes /classes/Dispatcher.php:654
110 
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` = 828
ORDER BY `position`
 2.538 ms 5 Yes /classes/Product.php:3545
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.411 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
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.399 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
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` = 151) LIMIT 1
 2.395 ms 1 /src/Adapter/EntityMapper.php:71
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` = 828 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` = 828 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2.233 ms 0 /classes/Cart.php:1410
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 (828,826,814,811)
 2.186 ms 4 /classes/ProductAssembler.php:95
48 
SELECT SQL_NO_CACHE format
FROM `pharm_address_format`
WHERE `id_country` = 64 LIMIT 1
 2.111 ms 1 /classes/AddressFormat.php:656
126 
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
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` = 828
AND image_shop.`cover` = 1 LIMIT 1
 1.877 ms 5 /classes/Product.php:3570
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 1.779 ms 1034 /classes/Hook.php:1332
178 
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.686 ms 1 /classes/ObjectModel.php:622
143 
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.477 ms 1 /src/Adapter/EntityMapper.php:71
60 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="fca1f19d5d2390eae277c538f67789a6" LIMIT 1
 1.415 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
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` = 828)
 1.408 ms 1 /classes/Product.php:3860
179 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 403008
AND `date_add` > '2025-01-18 11:26:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.270 ms 1 Yes /classes/Connection.php:168
189 
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 (828,826,814,811) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 1.245 ms 16 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
114 
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` = 826
ORDER BY `position`
 1.196 ms 5 Yes /classes/Product.php:3545
184 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361885', '', 'pharmaciedelalliance.com/en/brand/151-johnson-johnson', '', '2025-01-18 11:56:47')
 1.179 ms 1 /classes/ObjectModel.php:622
112 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.174 ms 1 /classes/FeatureFlag.php:105
21 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pharm_module` m
LEFT JOIN `pharm_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 1.173 ms 104 /classes/module/Module.php:345
156 
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` = 826
ORDER BY `position`
 1.124 ms 5 Yes /classes/Product.php:3545
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 1.123 ms 1034 /classes/Hook.php:1292
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` = 826 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` = 826 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.119 ms 0 /classes/Cart.php:1410
185 
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.101 ms 4096 /classes/DateRange.php:60
181 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 9 AND `id_object` = 151 LIMIT 1
 1.084 ms 1 /classes/Page.php:83
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.069 ms 1 /classes/Cart.php:4192
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` = 826) AND (b.`id_shop` = 1) LIMIT 1
 1.046 ms 1 /src/Adapter/EntityMapper.php:71
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 = 826
ORDER BY f.position ASC
 1.037 ms 1 Yes /classes/Product.php:6002
186 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 1230
AND `id_shop` = 1
 1.010 ms 1 /classes/Page.php:131
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` = 828) AND (b.`id_shop` = 1) LIMIT 1
 0.951 ms 1 /src/Adapter/EntityMapper.php:71
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` = 310 LIMIT 1
 0.941 ms 1 /classes/Category.php:1378
72 
SELECT SQL_NO_CACHE *
FROM `pharm_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 0.939 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.917 ms 104 /classes/module/Module.php:345
183 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361885', '1230', '2025-01-18 11:56:47')
 0.889 ms 1 /classes/Connection.php:122
108 
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` = 811 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` = 811 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.883 ms 0 /classes/Cart.php:1410
180 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'manufacturer' LIMIT 1
 0.848 ms 1 /classes/Page.php:104
98 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 814 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` = 814 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.838 ms 0 /classes/Cart.php:1410
99 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 814
ORDER BY f.position ASC
 0.818 ms 1 Yes /classes/Product.php:6002
73 
SELECT SQL_NO_CACHE *
FROM `pharm_tax_lang`
WHERE `id_tax` = 1
 0.810 ms 2 /src/Adapter/EntityMapper.php:79
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.798 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
109 
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 = 811
ORDER BY f.position ASC
 0.766 ms 1 Yes /classes/Product.php:6002
154 
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` = 828
ORDER BY `position`
 0.755 ms 5 Yes /classes/Product.php:3545
188 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.736 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
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` = 826
AND image_shop.`cover` = 1 LIMIT 1
 0.711 ms 5 /classes/Product.php:3570
93 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 814) AND (b.`id_shop` = 1) LIMIT 1
 0.698 ms 1 /src/Adapter/EntityMapper.php:71
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.684 ms 0 /classes/tax/TaxRulesTaxManager.php:109
74 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 828 AND `id_group` = 1 LIMIT 1
 0.679 ms 0 /classes/GroupReduction.php:156
103 
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` = 811) AND (b.`id_shop` = 1) LIMIT 1
 0.673 ms 1 /src/Adapter/EntityMapper.php:71
6 
SELECT SQL_NO_CACHE *
FROM `pharm_country` a
LEFT JOIN `pharm_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `pharm_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 64) LIMIT 1
 0.604 ms 1 /src/Adapter/EntityMapper.php:71
17 
SELECT SQL_NO_CACHE `name`, `alias` FROM `pharm_hook_alias`
 0.575 ms 88 /classes/Hook.php:287
31 
SELECT SQL_NO_CACHE value FROM `pharm_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.572 ms 1 /classes/shop/Shop.php:1183
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` = 151) LIMIT 1
 0.551 ms 1 /src/Adapter/EntityMapper.php:71
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` = 814
AND image_shop.`cover` = 1 LIMIT 1
 0.541 ms 1 /classes/Product.php:3570
161 
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 (811) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.528 ms 1 Yes Yes /classes/Product.php:4507
157 
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 (826) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.523 ms 1 Yes Yes /classes/Product.php:4507
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.522 ms 1 Yes /classes/shop/Shop.php:1364
120 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.519 ms 1 /classes/module/Module.php:2636
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.517 ms 1 Yes /classes/shop/Shop.php:715
56 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "productcomments" LIMIT 1
 0.506 ms 1 /classes/module/Module.php:2636
159 
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 (814) 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
100 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 811
AND image_shop.`cover` = 1 LIMIT 1
 0.503 ms 1 /classes/Product.php:3570
35 
SELECT SQL_NO_CACHE `id_country`
FROM `pharm_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.470 ms 1 /classes/Country.php:194
40 
SELECT SQL_NO_CACHE *
FROM `pharm_group_lang`
WHERE `id_group` = 1
 0.459 ms 2 /src/Adapter/EntityMapper.php:79
182 
INSERT INTO `pharm_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('403008', '1230', '308350554', '', '1', '1', '2025-01-18 11:56:47')
 0.453 ms 1 /classes/ObjectModel.php:622
116 
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` = 814
ORDER BY `position`
 0.450 ms 1 Yes /classes/Product.php:3545
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` = 826)
 0.444 ms 1 /classes/Product.php:3860
24 
SELECT SQL_NO_CACHE name, alias FROM `pharm_hook_alias`
 0.440 ms 88 /classes/Hook.php:339
104 
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` = 811)
 0.437 ms 1 /classes/Product.php:3860
29 
SELECT SQL_NO_CACHE * FROM `pharm_currency` c ORDER BY `iso_code` ASC
 0.424 ms 1 Yes /classes/Currency.php:709
145 
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.423 ms 2 /classes/Category.php:2242
158 
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` = 814
ORDER BY `position`
 0.421 ms 1 Yes /classes/Product.php:3545
111 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 828
 0.421 ms 1 /classes/Product.php:2902
94 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 814)
 0.418 ms 1 /classes/Product.php:3860
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.417 ms 1 /src/Adapter/EntityMapper.php:71
47 
SELECT SQL_NO_CACHE * FROM `pharm_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.415 ms 7 Yes /classes/ImageType.php:109
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.412 ms 1 /src/Adapter/EntityMapper.php:71
118 
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` = 811
ORDER BY `position`
 0.411 ms 1 Yes /classes/Product.php:3545
149 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_leftbanner" LIMIT 1
 0.408 ms 1 /classes/module/Module.php:2636
160 
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` = 811
ORDER BY `position`
 0.404 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.399 ms 2 /classes/Language.php:1080
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.397 ms 1 /classes/shop/Shop.php:218
148 
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.388 ms 1 /classes/Category.php:1600
3 
SELECT SQL_NO_CACHE *
FROM `pharm_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.382 ms 1 /src/Adapter/EntityMapper.php:71
30 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
 0.382 ms 2 /classes/Language.php:883
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.379 ms 2 /classes/Language.php:1216
121 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1
 0.379 ms 1 /classes/module/Module.php:2109
113 
SELECT SQL_NO_CACHE * FROM `pharm_image_type`
 0.378 ms 7 /classes/ImageType.php:161
51 
SELECT SQL_NO_CACHE *
FROM `pharm_country_lang`
WHERE `id_country` = 64
 0.369 ms 2 /src/Adapter/EntityMapper.php:79
163 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
 0.364 ms 1 /classes/module/Module.php:2109
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.358 ms 1 /src/Adapter/EntityMapper.php:71
127 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_toplink" LIMIT 1
 0.354 ms 1 /classes/module/Module.php:2636
66 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 151
AND `active` = 1 LIMIT 1
 0.345 ms 1 /classes/Manufacturer.php:316
87 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 826) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.334 ms 1 /classes/stock/StockAvailable.php:453
107 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 811) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.333 ms 1 /classes/stock/StockAvailable.php:453
7 
SELECT SQL_NO_CACHE *
FROM `pharm_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.332 ms 1 /src/Adapter/EntityMapper.php:71
150 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 89 AND `id_shop` = 1 LIMIT 1
 0.330 ms 1 /classes/module/Module.php:2109
115 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 826
 0.311 ms 1 /classes/Product.php:2902
128 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 69 AND `id_shop` = 1 LIMIT 1
 0.310 ms 1 /classes/module/Module.php:2109
53 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_facebook" LIMIT 1
 0.310 ms 1 /classes/module/Module.php:2636
77 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 828) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.308 ms 1 /classes/stock/StockAvailable.php:453
91 
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` = 158 LIMIT 1
 0.302 ms 1 /classes/Category.php:1378
52 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pharm_required_field
 0.302 ms 1 /classes/ObjectModel.php:1592
97 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = 814) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.299 ms 1 /classes/stock/StockAvailable.php:453
162 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_servicecmsblock" LIMIT 1
 0.296 ms 1 /classes/module/Module.php:2636
20 
SELECT SQL_NO_CACHE * FROM `pharm_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.295 ms 1 /classes/module/Module.php:2018
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
49 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.288 ms 1 /classes/Country.php:405
176 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_socialfollow" LIMIT 1
 0.287 ms 1 /classes/module/Module.php:2636
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.286 ms 1 /src/Adapter/EntityMapper.php:71
23 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `pharm_module` m
LEFT JOIN `pharm_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.275 ms 1 /modules/ps_mbo/ps_mbo.php:335
101 
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` = 235 LIMIT 1
 0.273 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.271 ms 1 /classes/module/Module.php:2109
82 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 310 LIMIT 1
 0.269 ms 1 /classes/Product.php:5642
75 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_group`
WHERE `id_group` = 1 LIMIT 1
 0.267 ms 1 /classes/Group.php:154
130 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1
 0.259 ms 1 /classes/module/Module.php:2109
22 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.258 ms 1 /modules/ps_mbo/ps_mbo.php:325
32 
SELECT SQL_NO_CACHE c.id_currency
FROM `pharm_currency` c
WHERE (iso_code = 'XAF') LIMIT 1
 0.255 ms 1 /classes/Currency.php:893
177 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1
 0.254 ms 1 /classes/module/Module.php:2109
28 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_manufacturer_shop`
WHERE `id_manufacturer` = 151
AND id_shop = 1 LIMIT 1
 0.254 ms 1 /classes/ObjectModel.php:1729
166 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 0.254 ms 1 /classes/Country.php:405
187 
INSERT INTO `pharm_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('106', '1230', '1', '1', '1')
 0.253 ms 1 /classes/Page.php:142
122 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 0.251 ms 1 /classes/module/Module.php:2636
44 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.249 ms 0 /classes/module/Module.php:2636
26 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `pharm_module` m
LEFT JOIN `pharm_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.244 ms 1 /modules/ps_mbo/ps_mbo.php:335
137 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_mainmenu" LIMIT 1
 0.244 ms 1 /classes/module/Module.php:2636
146 
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.243 ms 1 /classes/Category.php:1585
106 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 811 AND `id_group` = 1 LIMIT 1
 0.242 ms 0 /classes/GroupReduction.php:156
124 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_navcmsblock" LIMIT 1
 0.242 ms 1 /classes/module/Module.php:2636
123 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
 0.240 ms 1 /classes/module/Module.php:2109
125 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 68 AND `id_shop` = 1 LIMIT 1
 0.239 ms 1 /classes/module/Module.php:2109
96 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 814 AND `id_group` = 1 LIMIT 1
 0.238 ms 0 /classes/GroupReduction.php:156
86 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 826 AND `id_group` = 1 LIMIT 1
 0.237 ms 0 /classes/GroupReduction.php:156
117 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 814
 0.228 ms 1 /classes/Product.php:2902
12 
SELECT SQL_NO_CACHE `id_lang` FROM `pharm_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.227 ms 2 /classes/Language.php:854
45 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.227 ms 0 /classes/module/Module.php:2109
129 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.227 ms 1 /classes/module/Module.php:2636
8 
SELECT SQL_NO_CACHE *
FROM `pharm_lang` a
LEFT JOIN `pharm_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.226 ms 1 /src/Adapter/EntityMapper.php:71
57 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
 0.225 ms 0 /classes/module/Module.php:2109
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pharm_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.225 ms 1 /classes/shop/ShopUrl.php:182
92 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 158 LIMIT 1
 0.224 ms 1 /classes/Product.php:5642
119 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pharm_product_attribute`
WHERE `id_product` = 811
 0.215 ms 1 /classes/Product.php:2902
41 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.214 ms 1 /classes/ObjectModel.php:1729
135 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_verticalmenu" LIMIT 1
 0.211 ms 1 /classes/module/Module.php:2636
170 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1
 0.209 ms 1 /classes/module/Module.php:2109
37 
SELECT SQL_NO_CACHE *
FROM `pharm_currency_lang`
WHERE `id_currency` = 1
 0.207 ms 2 /src/Adapter/EntityMapper.php:79
133 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.203 ms 1 /classes/module/Module.php:2636
141 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.200 ms 1 /classes/module/Module.php:2636
105 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 811 AND id_shop=1 LIMIT 1
 0.197 ms 1 /classes/Product.php:6857
151 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_newproducts" LIMIT 1
 0.196 ms 1 /classes/module/Module.php:2636
171 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
 0.194 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.190 ms 2 /classes/Language.php:883
131 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_customersignin" LIMIT 1
 0.190 ms 1 /classes/module/Module.php:2636
147 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `pharm_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.190 ms 1 /classes/Category.php:1591
68 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 828 AND id_shop=1 LIMIT 1
 0.189 ms 1 /classes/Product.php:6857
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
139 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_headercmsblock" LIMIT 1
 0.188 ms 1 /classes/module/Module.php:2636
64 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 310 LIMIT 1
 0.188 ms 1 /classes/Product.php:5642
85 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 826 AND id_shop=1 LIMIT 1
 0.187 ms 1 /classes/Product.php:6857
142 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1
 0.185 ms 1 /classes/module/Module.php:2109
140 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 71 AND `id_shop` = 1 LIMIT 1
 0.183 ms 1 /classes/module/Module.php:2109
134 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
 0.182 ms 1 /classes/module/Module.php:2109
14 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
 0.182 ms 1 /classes/ObjectModel.php:1729
138 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
 0.182 ms 1 /classes/module/Module.php:2109
152 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 76 AND `id_shop` = 1 LIMIT 1
 0.182 ms 1 /classes/module/Module.php:2109
164 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_contactinfo" LIMIT 1
 0.181 ms 1 /classes/module/Module.php:2636
95 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pharm_product_shop`
WHERE `id_product` = 814 AND id_shop=1 LIMIT 1
 0.181 ms 1 /classes/Product.php:6857
102 
SELECT SQL_NO_CACHE name FROM pharm_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 235 LIMIT 1
 0.179 ms 1 /classes/Product.php:5642
173 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "cz_footercmsblock" LIMIT 1
 0.176 ms 1 /classes/module/Module.php:2636
169 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
 0.175 ms 1 /classes/module/Module.php:2636
25 
SELECT SQL_NO_CACHE `active`
FROM `pharm_module`
WHERE `name` = "ps_mbo" LIMIT 1
 0.174 ms 1 /modules/ps_mbo/ps_mbo.php:325
172 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
 0.174 ms 1 /classes/module/Module.php:2109
167 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module` WHERE `name` = "ps_linklist" LIMIT 1
 0.173 ms 1 /classes/module/Module.php:2636
174 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 106 AND `id_shop` = 1 LIMIT 1
 0.169 ms 1 /classes/module/Module.php:2109
136 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 70 AND `id_shop` = 1 LIMIT 1
 0.167 ms 1 /classes/module/Module.php:2109
38 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.165 ms 1 /classes/ObjectModel.php:1729
9 
SELECT SQL_NO_CACHE id_shop
FROM `pharm_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.164 ms 1 /classes/ObjectModel.php:1729
165 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1
 0.164 ms 1 /classes/module/Module.php:2109
168 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1
 0.162 ms 1 /classes/module/Module.php:2109
132 
SELECT SQL_NO_CACHE `id_module` FROM `pharm_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1
 0.154 ms 1 /classes/module/Module.php:2109

Doubles

23 queries 
SELECT `id_module` FROM `pharm_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
8 queries 
            SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
            FROM `pharm_image` i
             INNER JOIN pharm_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
            LEFT JOIN `pharm_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
            WHERE i.`id_product` = XX
            ORDER BY `position`
4 queries 
SELECT image_shop.`id_image`
                    FROM `pharm_image` i
                     INNER JOIN pharm_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
                    WHERE i.`id_product` = XX
                    AND image_shop.`cover` = XX LIMIT XX
4 queries 
SELECT name FROM pharm_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
4 queries 
SELECT *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
4 queries 
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
4 queries 
                            SELECT `id_tax_rules_group`
                            FROM `pharm_product_shop`
                            WHERE `id_product` = XX AND id_shop=XX LIMIT XX
4 queries 
			SELECT `reduction`
			FROM `pharm_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
4 queries 
SELECT SUM(quantity)
FROM `pharm_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries 
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
            COALESCE(SUM(first_level_quantity), XX) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity
          FROM `pharm_cart_product` cp
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
          FROM `pharm_cart_product` cp JOIN `pharm_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pharm_product` pr ON p.`id_product_pack` = pr.`id_product`
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
            pr.`pack_stock_type` = XX
            AND XX = XX
        ))) as q LIMIT XX
4 queries 
                SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value
                FROM pharm_feature_product pf
                LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX)
                LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
                LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
                 INNER JOIN pharm_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX)
                WHERE pf.id_product = XX
                ORDER BY f.position ASC
4 queries 
SELECT `id_product_attribute`
            FROM `pharm_product_attribute`
            WHERE `id_product` = XX
4 queries 
SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
            FROM `pharm_product_attribute` pa
             INNER JOIN pharm_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
            JOIN `pharm_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
            JOIN `pharm_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
            JOIN `pharm_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
            JOIN `pharm_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
3 queries 
			SELECT cl.`link_rewrite`
			FROM `pharm_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
3 queries 
				SELECT tr.*
				FROM `pharm_tax_rule` tr
				JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries 
SELECT *
FROM `pharm_lang` a
LEFT JOIN `pharm_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX
WHERE (a.`id_lang` = XX) LIMIT XX
2 queries 
				SELECT id_shop
				FROM `pharm_lang_shop`
				WHERE `id_lang` = XX
				AND id_shop = XX LIMIT XX
2 queries 
                SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
                FROM `pharm_module` m
                LEFT JOIN `pharm_module_shop` ms
                ON m.`id_module` = ms.`id_module`
                AND ms.`id_shop` = XX
2 queries 
SELECT `active`
        FROM `pharm_module`
        WHERE `name` = "ps_mbo" LIMIT XX
2 queries 
SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active`
        FROM `pharm_module` m
        LEFT JOIN `pharm_module_shop` ms ON m.`id_module` = ms.`id_module`
        WHERE `name` = "ps_mbo" LIMIT XX
2 queries 
SELECT *
FROM `pharm_manufacturer` a
LEFT JOIN `pharm_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = XX
LEFT JOIN `pharm_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = XX
WHERE (a.`id_manufacturer` = XX) LIMIT XX
2 queries 
SELECT `id_lang` FROM `pharm_lang`
                    WHERE `locale` = 'en-us'
                    OR `language_code` = 'en-us' LIMIT XX
2 queries 
			SELECT `need_identification_number`
			FROM `pharm_country`
			WHERE `id_country` = XX LIMIT XX

Tables stress

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

ObjectModel instances

Name Instances Source
Product 16 /classes/Link.php:113 (__construct) [id: 828]
/classes/Link.php:113 (__construct) [id: 826]
/classes/Link.php:113 (__construct) [id: 814]
/classes/Link.php:113 (__construct) [id: 811]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 828]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 826]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 814]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 811]
/classes/Link.php:113 (__construct) [id: 828]
/classes/Link.php:113 (__construct) [id: 826]
/classes/Link.php:113 (__construct) [id: 814]
/classes/Link.php:113 (__construct) [id: 811]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 828]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 826]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 814]
/modules/cz_imagehover/cz_imagehover.php:73 (__construct) [id: 811]
Country 6 /config/config.inc.php:146 (__construct) [id: 64]
/classes/controller/FrontController.php:352 (__construct) [id: 0]
/classes/AddressFormat.php:404 (__construct) [id: 64]
/classes/controller/FrontController.php:1760 (__construct) [id: 64]
/classes/AddressFormat.php:404 (__construct) [id: 64]
/modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 64]
Manufacturer 6 /controllers/front/listing/ManufacturerController.php:65 (__construct) [id: 151]
/classes/Meta.php:421 (__construct) [id: 151]
/classes/Link.php:657 (__construct) [id: 151]
/classes/Link.php:657 (__construct) [id: 151]
/classes/Link.php:657 (__construct) [id: 151]
/classes/Link.php:657 (__construct) [id: 151]
Address 4 /classes/shop/Shop.php:486 (__construct) [id: ]
/classes/Product.php:3694 (initialize) [id: ]
/classes/Product.php:3804 (__construct) [id: ]
/classes/Product.php:5945 (__construct) [id: ]
Language 3 /config/config.inc.php:211 (__construct) [id: 1]
/classes/Tools.php:641 (__construct) [id: 2]
/classes/Tools.php:560 (__construct) [id: 2]
Category 3 /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2]
/modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2]
/modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Tax 2 /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Currency 2 /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1]
/classes/Tools.php:695 (getCurrencyInstance) [id: 1]
Cart 2 /classes/controller/FrontController.php:465 (__construct) [id: ]
/classes/controller/FrontController.php:534 (__construct) [id: ]
AddressFormat 2 /classes/controller/FrontController.php:1754 (generateAddress) [id: ]
/modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
State 2 /classes/controller/FrontController.php:1759 (__construct) [id: 0]
/modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Shop 1 /config/config.inc.php:117 (initialize) [id: 1]
Connection 1 /modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest 1 /modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
CMS 1 /modules/czuecookie/czuecookie.php:135 (__construct) [id: 2]
Risk 1 /classes/controller/FrontController.php:1687 (__construct) [id: ]
Gender 1 /classes/controller/FrontController.php:1684 (__construct) [id: 0]
Group 1 /classes/Cart.php:249 (getCurrent) [id: 1]
Customer 1 /config/config.inc.php:264 (__construct) [id: ]
ShopGroup 1 /classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource 1 /modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

Included Files

# Filename
0 /index.php
1 /config/config.inc.php
2 /config/defines.inc.php
3 /config/autoload.php
4 /vendor/autoload.php
5 /vendor/composer/autoload_real.php
6 /vendor/composer/platform_check.php
7 /vendor/composer/ClassLoader.php
8 /vendor/composer/include_paths.php
9 /vendor/composer/autoload_static.php
10 /vendor/symfony/polyfill-php72/bootstrap.php
11 /vendor/symfony/polyfill-mbstring/bootstrap.php
12 /vendor/symfony/polyfill-mbstring/bootstrap80.php
13 /vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14 /vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15 /vendor/symfony/polyfill-intl-idn/bootstrap.php
16 /vendor/symfony/deprecation-contracts/function.php
17 /vendor/ralouphie/getallheaders/src/getallheaders.php