Facial care

Active filters

Load Time 972 ms
Querying Time 403 ms
Queries 641
Memory Peak Usage 18.1 Mb
Included Files 1147 files - 12.24 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.496 ms 2.496 ms 2.19 Mb 2.6 Mb
__construct 0.021 ms 2.517 ms - Mb 2.6 Mb
init 20.910 ms 23.427 ms 0.56 Mb 3.1 Mb
checkAccess 0.002 ms 23.429 ms - Mb 3.1 Mb
setMedia 3.324 ms 26.753 ms 0.18 Mb 3.1 Mb
postProcess 0.002 ms 26.755 ms - Mb 3.1 Mb
initHeader 0.001 ms 26.756 ms - Mb 3.1 Mb
initContent 442.631 ms 469.387 ms 8.34 Mb 11.3 Mb
initFooter 0.003 ms 469.390 ms - Mb 11.3 Mb
display 502.846 ms 972 ms 6.26 Mb 18.1 Mb
Hook Time Memory Usage
DisplayCzHoverImage 187.123 ms 1.73 Mb
DisplayProductListReviews 113.350 ms 0.38 Mb
DisplayBeforeBodyClosingTag 21.649 ms 0.38 Mb
displayNavFullWidth 18.840 ms 0.56 Mb
displayLeftColumn 14.248 ms 0.39 Mb
DisplayHeader 11.307 ms 0.44 Mb
DisplayStWishlistButton 8.905 ms 0.04 Mb
DisplayStCompareButton 8.037 ms 0.03 Mb
displayNav1 5.570 ms 0.18 Mb
displayFooter 5.321 ms 0.29 Mb
DisplayFooter 4.347 ms 0.06 Mb
displayTop 2.792 ms 0.16 Mb
displayFooterBefore 1.320 ms 0.05 Mb
displayNav2 1.198 ms 0.05 Mb
displayFooterAfter 1.135 ms 0.05 Mb
ActionFrontControllerSetMedia 0.591 ms 0.01 Mb
ProductSearchProvider 0.540 ms - Mb
ActionDispatcherBefore 0.520 ms 0.01 Mb
DisplayStCompareTopLink 0.342 ms 0.01 Mb
DisplayLeftColumn 0.324 ms - Mb
DisplayContentWrapperBottom 0.102 ms - Mb
21 hook(s) 407.561 ms 4.83 Mb
Module Time Memory Usage
ps_mbo 5.011 ms 0.06 Mb
blockreassurance 1.282 ms 0.14 Mb
ps_emailsubscription 1.252 ms 0.06 Mb
ps_socialfollow 1.342 ms 0.06 Mb
ps_emailalerts 0.196 ms 0.01 Mb
ps_facebook 8.304 ms 0.29 Mb
ps_shoppingcart 0.616 ms 0.06 Mb
ps_searchbar 1.277 ms 0.05 Mb
ps_googleanalytics 9.254 ms 0.15 Mb
cz_imageslider 0.255 ms 0.01 Mb
czcouponpop 0.151 ms 0.01 Mb
ps_accounts 0.255 ms 0.01 Mb
azameo 0.510 ms 0.02 Mb
psxmarketingwithgoogle 0.495 ms 0.01 Mb
chatyprestashop 0.415 ms 0.01 Mb
cz_verticalmenu 6.242 ms 0.47 Mb
myprestacomments 114.826 ms 0.49 Mb
psproductcountdown 1.152 ms 0.07 Mb
stfeature 18.255 ms 0.13 Mb
ps_facetedsearch 1.374 ms 0.02 Mb
ps_languageselector 1.934 ms 0.05 Mb
ps_currencyselector 0.702 ms 0.05 Mb
cz_navcmsblock 3.458 ms 0.10 Mb
cz_toplink 1.366 ms 0.06 Mb
ps_customersignin 1.540 ms 0.07 Mb
ps_mainmenu 11.892 ms 0.06 Mb
cz_headercmsblock 1.356 ms 0.06 Mb
ps_categorytree 5.246 ms 0.24 Mb
cz_leftbanner 1.270 ms 0.05 Mb
cz_newproducts 8.201 ms 0.12 Mb
cz_imagehover 187.482 ms 1.75 Mb
ldinstagramslider 0.310 ms 0.01 Mb
cz_servicecmsblock 1.493 ms 0.06 Mb
ps_contactinfo 1.557 ms 0.08 Mb
ps_linklist 1.193 ms 0.07 Mb
ps_customeraccountlinks 1.132 ms 0.07 Mb
cz_footercmsblock 1.102 ms 0.06 Mb
czuecookie 4.437 ms 0.07 Mb
statsdata 13.080 ms 0.25 Mb
39 module(s) 421.215 ms 5.38 Mb

Stopwatch SQL - 641 queries

# Query Time (ms) Rows Filesort Group By Location
77 
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.reference FROM pharm_product p LEFT JOIN pharm_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pharm_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pharm_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN pharm_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pharm_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pharm_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pharm_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pharm_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=4 AND c.nright<=33 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 33.175 ms 9824 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
16 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pharm_module` m
INNER JOIN pharm_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `pharm_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pharm_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pharm_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 6.948 ms 1248 Yes Yes /classes/Hook.php:1233
540 
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.901 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.064 ms 665 /classes/Configuration.php:180
640 
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 (1001,1000,1004,1003,1002,290,289,1018,1017,1016,1013,1011,1005,794,791,790,777,749,748,537,536,535,534,532,531,524,519,518,517,513,512,511,386,385,287,286) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 5.641 ms 12584 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
542 
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 (1001) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 4.824 ms 1 Yes Yes /classes/Product.php:4507
97 
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 = 1001
ORDER BY f.position ASC
 4.508 ms 1 Yes /classes/Product.php:6002
79 
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 (1001,1000,1004,1003,1002,290,289,1018,1017,1016,1013,1011,1005,794,791,790,777,749,748,537,536,535,534,532,531,524,519,518,517,513,512,511,386,385,287,286)
 3.895 ms 36 /classes/ProductAssembler.php:95
87 
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.673 ms 0 /classes/Hook.php:1292
626 
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.487 ms 1 /src/Adapter/EntityMapper.php:71
88 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `pharm_hook_module` hm
STRAIGHT_JOIN `pharm_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `pharm_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 3.461 ms 468 /classes/Hook.php:456
58 
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.858 ms 1 /classes/Cart.php:4192
433 
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` = 1001
ORDER BY `position`
 2.823 ms 2 Yes /classes/Product.php:3545
89 
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.669 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
96 
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` = 1001 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` = 1001 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2.510 ms 0 /classes/Cart.php:1410
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.451 ms 102 Yes /classes/Dispatcher.php:654
629 
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')
 2.025 ms 1 /classes/ObjectModel.php:622
80 
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` = 1001
AND image_shop.`cover` = 1 LIMIT 1
 1.988 ms 2 /classes/Product.php:3570
513 
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.960 ms 1 /classes/Currency.php:1136
530 
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` = 50 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1 AND c.`level_depth` <= 7 AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
 1.754 ms 15 Yes Yes /classes/Category.php:799
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 1.721 ms 1034 /classes/Hook.php:1332
85 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1001)
 1.671 ms 1 /classes/Product.php:3860
78 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="61f6a6cacd8daba72cff923662de641e" LIMIT 1
 1.635 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
630 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 402922
AND `date_add` > '2025-01-18 10:37:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.606 ms 1 Yes /classes/Connection.php:168
74 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM pharm_layered_category
WHERE controller = 'category'
AND id_category = 50
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 1.598 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
401 
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` = 386 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` = 386 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.525 ms 0 /classes/Cart.php:1410
63 
SELECT SQL_NO_CACHE format
FROM `pharm_address_format`
WHERE `id_country` = 64 LIMIT 1
 1.401 ms 1 /classes/AddressFormat.php:656
632 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 7 AND `id_object` = 50 LIMIT 1
 1.300 ms 1 /classes/Page.php:83
84 
SELECT SQL_NO_CACHE `name`
FROM `pharm_manufacturer`
WHERE `id_manufacturer` = 38
AND `active` = 1 LIMIT 1
 1.273 ms 1 /classes/Manufacturer.php:316
402 
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 = 386
ORDER BY f.position ASC
 1.254 ms 1 Yes /classes/Product.php:6002
435 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.239 ms 1 /classes/FeatureFlag.php:105
631 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'category' LIMIT 1
 1.191 ms 1 /classes/Page.php:104
636 
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.173 ms 4096 /classes/DateRange.php:60
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` = 1000) AND (b.`id_shop` = 1) LIMIT 1
 1.162 ms 1 /src/Adapter/EntityMapper.php:71
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` = 1000 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` = 1000 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.143 ms 0 /classes/Cart.php:1410
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 = 1000
ORDER BY f.position ASC
 1.123 ms 1 Yes /classes/Product.php:6002
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 1.122 ms 1034 /classes/Hook.php:1292
543 
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` = 1000
ORDER BY `position`
 1.091 ms 2 Yes /classes/Product.php:3545
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` = 1001) AND (b.`id_shop` = 1) LIMIT 1
 1.090 ms 1 /src/Adapter/EntityMapper.php:71
389 
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` = 511 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` = 511 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.088 ms 0 /classes/Cart.php:1410
410 
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` = 385 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` = 385 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.055 ms 0 /classes/Cart.php:1410
635 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361811', '', 'pharmaciedelalliance.com/en/50-facial-care', '', '2025-01-18 11:07:44')
 1.046 ms 1 /classes/ObjectModel.php:622
252 
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 = 777
ORDER BY f.position ASC
 0.996 ms 1 Yes /classes/Product.php:6002
432 
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 = 286
ORDER BY f.position ASC
 0.996 ms 1 Yes /classes/Product.php:6002
67 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM pharm_required_field
 0.981 ms 1 /classes/ObjectModel.php:1592
411 
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 = 385
ORDER BY f.position ASC
 0.980 ms 1 Yes /classes/Product.php:6002
431 
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` = 286 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` = 286 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.968 ms 0 /classes/Cart.php:1410
437 
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` = 1000
ORDER BY `position`
 0.965 ms 2 Yes /classes/Product.php:3545
125 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1003 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` = 1003 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.950 ms 0 /classes/Cart.php:1410
226 
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` = 791) AND (b.`id_shop` = 1) LIMIT 1
 0.948 ms 1 /src/Adapter/EntityMapper.php:71
421 
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 = 287
ORDER BY f.position ASC
 0.941 ms 1 Yes /classes/Product.php:6002
233 
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 = 791
ORDER BY f.position ASC
 0.940 ms 1 Yes /classes/Product.php:6002
634 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361811', '24', '2025-01-18 11:07:44')
 0.932 ms 1 /classes/Connection.php:122
221 
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` = 794 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` = 794 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.928 ms 0 /classes/Cart.php:1410
637 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 24
AND `id_shop` = 1
 0.924 ms 1 /classes/Page.php:131
172 
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` = 1017 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` = 1017 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.921 ms 0 /classes/Cart.php:1410
541 
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` = 1001
ORDER BY `position`
 0.919 ms 2 Yes /classes/Product.php:3545
251 
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` = 777 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` = 777 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.919 ms 0 /classes/Cart.php:1410
42 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `pharm_category` c
INNER JOIN pharm_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pharm_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `pharm_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 50
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.910 ms 14 Yes Yes /classes/Category.php:924
232 
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` = 791 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` = 791 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.908 ms 0 /classes/Cart.php:1410
282 
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 = 537
ORDER BY f.position ASC
 0.907 ms 1 Yes /classes/Product.php:6002
241 
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` = 790 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` = 790 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.906 ms 0 /classes/Cart.php:1410
405 
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` = 385) AND (b.`id_shop` = 1) LIMIT 1
 0.892 ms 1 /src/Adapter/EntityMapper.php:71
90 
SELECT SQL_NO_CACHE *
FROM `pharm_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 0.886 ms 1 /src/Adapter/EntityMapper.php:71
201 
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` = 1011 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` = 1011 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.885 ms 0 /classes/Cart.php:1410
117 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1004
ORDER BY f.position ASC
 0.884 ms 1 Yes /classes/Product.php:6002
181 
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` = 1016 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` = 1016 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.881 ms 0 /classes/Cart.php:1410
420 
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` = 287 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` = 287 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.880 ms 0 /classes/Cart.php:1410
326 
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` = 531 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` = 531 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.876 ms 0 /classes/Cart.php:1410
271 
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 = 748
ORDER BY f.position ASC
 0.875 ms 1 Yes /classes/Product.php:6002
98 
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.872 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
299 
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` = 535 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` = 535 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.870 ms 0 /classes/Cart.php:1410
164 
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 = 1018
ORDER BY f.position ASC
 0.869 ms 1 Yes /classes/Product.php:6002
335 
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` = 524 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` = 524 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.867 ms 0 /classes/Cart.php:1410
153 
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` = 289 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` = 289 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.864 ms 0 /classes/Cart.php:1410
163 
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` = 1018 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` = 1018 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.864 ms 0 /classes/Cart.php:1410
191 
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` = 1013 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` = 1013 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.854 ms 0 /classes/Cart.php:1410
281 
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` = 537 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` = 537 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.852 ms 0 /classes/Cart.php:1410
554 
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 (289) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.850 ms 1 Yes Yes /classes/Product.php:4507
173 
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 = 1017
ORDER BY f.position ASC
 0.848 ms 1 Yes /classes/Product.php:6002
300 
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 = 535
ORDER BY f.position ASC
 0.848 ms 1 Yes /classes/Product.php:6002
202 
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 = 1011
ORDER BY f.position ASC
 0.847 ms 1 Yes /classes/Product.php:6002
362 
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` = 517 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` = 517 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.841 ms 0 /classes/Cart.php:1410
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.840 ms 1 /src/Adapter/EntityMapper.php:71
222 
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 = 794
ORDER BY f.position ASC
 0.840 ms 1 Yes /classes/Product.php:6002
126 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1003
ORDER BY f.position ASC
 0.838 ms 1 Yes /classes/Product.php:6002
395 
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` = 386) AND (b.`id_shop` = 1) LIMIT 1
 0.837 ms 1 /src/Adapter/EntityMapper.php:71
403 
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` = 385
AND image_shop.`cover` = 1 LIMIT 1
 0.837 ms 1 /classes/Product.php:3570
116 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1004 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` = 1004 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.833 ms 0 /classes/Cart.php:1410
327 
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 = 531
ORDER BY f.position ASC
 0.833 ms 1 Yes /classes/Product.php:6002
344 
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` = 519 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` = 519 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.833 ms 0 /classes/Cart.php:1410
558 
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 (1017) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.831 ms 1 Yes Yes /classes/Product.php:4507
154 
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 = 289
ORDER BY f.position ASC
 0.830 ms 1 Yes /classes/Product.php:6002
582 
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 (536) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.828 ms 1 Yes Yes /classes/Product.php:4507
336 
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 = 524
ORDER BY f.position ASC
 0.827 ms 1 Yes /classes/Product.php:6002
135 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1002
ORDER BY f.position ASC
 0.824 ms 1 Yes /classes/Product.php:6002
143 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 290 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` = 290 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.821 ms 0 /classes/Cart.php:1410
134 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1002 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` = 1002 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.812 ms 0 /classes/Cart.php:1410
211 
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` = 1005 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` = 1005 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.811 ms 0 /classes/Cart.php:1410
317 
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` = 532 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` = 532 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.811 ms 0 /classes/Cart.php:1410
192 
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 = 1013
ORDER BY f.position ASC
 0.806 ms 1 Yes /classes/Product.php:6002
91 
SELECT SQL_NO_CACHE *
FROM `pharm_tax_lang`
WHERE `id_tax` = 1
 0.805 ms 2 /src/Adapter/EntityMapper.php:79
290 
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` = 536 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` = 536 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.805 ms 0 /classes/Cart.php:1410
242 
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 = 790
ORDER BY f.position ASC
 0.805 ms 1 Yes /classes/Product.php:6002
380 
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` = 512 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` = 512 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.800 ms 0 /classes/Cart.php:1410
353 
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` = 518 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` = 518 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.796 ms 0 /classes/Cart.php:1410
270 
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` = 748 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` = 748 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.793 ms 0 /classes/Cart.php:1410
363 
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 = 517
ORDER BY f.position ASC
 0.791 ms 1 Yes /classes/Product.php:6002
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` = 1000
AND image_shop.`cover` = 1 LIMIT 1
 0.787 ms 2 /classes/Product.php:3570
216 
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` = 794) AND (b.`id_shop` = 1) LIMIT 1
 0.784 ms 1 /src/Adapter/EntityMapper.php:71
129 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1002) AND (b.`id_shop` = 1) LIMIT 1
 0.781 ms 1 /src/Adapter/EntityMapper.php:71
308 
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` = 534 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` = 534 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.778 ms 0 /classes/Cart.php:1410
262 
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 = 749
ORDER BY f.position ASC
 0.776 ms 1 Yes /classes/Product.php:6002
196 
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` = 1011) AND (b.`id_shop` = 1) LIMIT 1
 0.775 ms 1 /src/Adapter/EntityMapper.php:71
371 
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` = 513 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` = 513 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.775 ms 0 /classes/Cart.php:1410
158 
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` = 1018) AND (b.`id_shop` = 1) LIMIT 1
 0.775 ms 1 /src/Adapter/EntityMapper.php:71
176 
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` = 1016) AND (b.`id_shop` = 1) LIMIT 1
 0.774 ms 1 /src/Adapter/EntityMapper.php:71
372 
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 = 513
ORDER BY f.position ASC
 0.770 ms 1 Yes /classes/Product.php:6002
144 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 290
ORDER BY f.position ASC
 0.768 ms 1 Yes /classes/Product.php:6002
182 
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 = 1016
ORDER BY f.position ASC
 0.768 ms 1 Yes /classes/Product.php:6002
291 
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 = 536
ORDER BY f.position ASC
 0.768 ms 1 Yes /classes/Product.php:6002
568 
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 (794) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.766 ms 1 Yes Yes /classes/Product.php:4507
212 
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 = 1005
ORDER BY f.position ASC
 0.765 ms 1 Yes /classes/Product.php:6002
234 
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` = 790
AND image_shop.`cover` = 1 LIMIT 1
 0.765 ms 4 /classes/Product.php:3570
345 
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 = 519
ORDER BY f.position ASC
 0.764 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.764 ms 104 /classes/module/Module.php:345
564 
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 (1011) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.758 ms 1 Yes Yes /classes/Product.php:4507
584 
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 (535) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.756 ms 1 Yes Yes /classes/Product.php:4507
586 
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 (534) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.756 ms 1 Yes Yes /classes/Product.php:4507
390 
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 = 511
ORDER BY f.position ASC
 0.755 ms 1 Yes /classes/Product.php:6002
639 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.755 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
576 
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 (749) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.751 ms 1 Yes Yes /classes/Product.php:4507
556 
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 (1018) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.750 ms 1 Yes Yes /classes/Product.php:4507
357 
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` = 517) AND (b.`id_shop` = 1) LIMIT 1
 0.749 ms 1 /src/Adapter/EntityMapper.php:71
94 
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.749 ms 0 /classes/tax/TaxRulesTaxManager.php:109
381 
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 = 512
ORDER BY f.position ASC
 0.747 ms 1 Yes /classes/Product.php:6002
566 
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 (1005) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.747 ms 1 Yes Yes /classes/Product.php:4507
318 
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 = 532
ORDER BY f.position ASC
 0.746 ms 1 Yes /classes/Product.php:6002
92 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1001 AND `id_group` = 1 LIMIT 1
 0.745 ms 0 /classes/GroupReduction.php:156
574 
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 (777) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.743 ms 1 Yes Yes /classes/Product.php:4507
354 
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 = 518
ORDER BY f.position ASC
 0.741 ms 1 Yes /classes/Product.php:6002
414 
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` = 287) AND (b.`id_shop` = 1) LIMIT 1
 0.741 ms 1 /src/Adapter/EntityMapper.php:71
560 
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 (1016) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.741 ms 1 Yes Yes /classes/Product.php:4507
578 
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 (748) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.740 ms 1 Yes Yes /classes/Product.php:4507
339 
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` = 519) AND (b.`id_shop` = 1) LIMIT 1
 0.738 ms 1 /src/Adapter/EntityMapper.php:71
309 
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 = 534
ORDER BY f.position ASC
 0.736 ms 1 Yes /classes/Product.php:6002
261 
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` = 749 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` = 749 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.735 ms 0 /classes/Cart.php:1410
148 
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` = 289) AND (b.`id_shop` = 1) LIMIT 1
 0.732 ms 1 /src/Adapter/EntityMapper.php:71
303 
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` = 534) AND (b.`id_shop` = 1) LIMIT 1
 0.729 ms 1 /src/Adapter/EntityMapper.php:71
294 
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` = 535) AND (b.`id_shop` = 1) LIMIT 1
 0.725 ms 1 /src/Adapter/EntityMapper.php:71
111 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1004) AND (b.`id_shop` = 1) LIMIT 1
 0.723 ms 1 /src/Adapter/EntityMapper.php:71
167 
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` = 1017) AND (b.`id_shop` = 1) LIMIT 1
 0.719 ms 1 /src/Adapter/EntityMapper.php:71
206 
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` = 1005) AND (b.`id_shop` = 1) LIMIT 1
 0.717 ms 1 /src/Adapter/EntityMapper.php:71
406 
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` = 385)
 0.715 ms 1 /classes/Product.php:3860
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.712 ms 1 Yes /classes/shop/Shop.php:1364
57 
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.712 ms 104 /classes/module/Module.php:345
391 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.711 ms 0 /classes/tax/TaxRulesTaxManager.php:109
330 
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` = 524) AND (b.`id_shop` = 1) LIMIT 1
 0.708 ms 1 /src/Adapter/EntityMapper.php:71
228 
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` = 791)
 0.705 ms 1 /classes/Product.php:3860
120 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1003) AND (b.`id_shop` = 1) LIMIT 1
 0.704 ms 1 /src/Adapter/EntityMapper.php:71
392 
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` = 386
AND image_shop.`cover` = 1 LIMIT 1
 0.704 ms 1 /classes/Product.php:3570
425 
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` = 286) AND (b.`id_shop` = 1) LIMIT 1
 0.703 ms 1 /src/Adapter/EntityMapper.php:71
186 
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` = 1013) AND (b.`id_shop` = 1) LIMIT 1
 0.702 ms 1 /src/Adapter/EntityMapper.php:71
1 
SELECT SQL_NO_CAC