Medical Supplies

Active filters

Load Time 1261 ms
Querying Time 332 ms
Queries 464
Memory Peak Usage 14.1 Mb
Included Files 1119 files - 12.19 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 4.825 ms 4.825 ms 2.19 Mb 2.6 Mb
__construct 0.040 ms 4.865 ms - Mb 2.6 Mb
init 288.285 ms 293.150 ms 0.49 Mb 3.1 Mb
checkAccess 0.002 ms 293.152 ms - Mb 3.1 Mb
setMedia 22.951 ms 316.103 ms 0.18 Mb 3.1 Mb
postProcess 0.003 ms 316.106 ms - Mb 3.1 Mb
initHeader 0.002 ms 316.108 ms - Mb 3.1 Mb
initContent 528.630 ms 845 ms 6.04 Mb 8.9 Mb
initFooter 0.004 ms 845 ms - Mb 8.9 Mb
display 416.579 ms 1261 ms 4.80 Mb 14.1 Mb
Hook Time Memory Usage
DisplayHeader 147.856 ms 0.44 Mb
DisplayProductListReviews 104.490 ms 0.23 Mb
DisplayCzHoverImage 91.765 ms 1.07 Mb
DisplayBeforeBodyClosingTag 27.066 ms 0.35 Mb
displayFooter 20.472 ms 0.29 Mb
displayNavFullWidth 15.529 ms 0.56 Mb
displayLeftColumn 15.043 ms 0.35 Mb
displayNav1 11.672 ms 0.16 Mb
displayTop 9.401 ms 0.15 Mb
ActionFrontControllerSetMedia 7.806 ms 0.01 Mb
DisplayStWishlistButton 7.710 ms 0.02 Mb
DisplayStCompareButton 7.090 ms 0.03 Mb
DisplayFooter 6.804 ms 0.05 Mb
displayFooterBefore 4.622 ms 0.05 Mb
displayNav2 3.734 ms 0.05 Mb
DisplayStCompareTopLink 3.543 ms 0.01 Mb
displayFooterAfter 2.800 ms 0.05 Mb
ActionDispatcherBefore 1.288 ms 0.01 Mb
ProductSearchProvider 0.659 ms - Mb
DisplayContentWrapperBottom 0.657 ms - Mb
DisplayLeftColumn 0.339 ms 0.04 Mb
21 hook(s) 490.346 ms 3.94 Mb
Module Time Memory Usage
ps_mbo 49.666 ms 0.06 Mb
blockreassurance 4.543 ms 0.14 Mb
ps_emailsubscription 5.610 ms 0.06 Mb
ps_socialfollow 4.867 ms 0.06 Mb
ps_emailalerts 1.960 ms 0.01 Mb
ps_facebook 122.605 ms 0.29 Mb
ps_shoppingcart 1.136 ms 0.05 Mb
ps_searchbar 6.696 ms 0.05 Mb
ps_googleanalytics 21.368 ms 0.12 Mb
cz_imageslider 2.454 ms 0.01 Mb
czcouponpop 2.371 ms 0.01 Mb
ps_accounts 3.375 ms 0.01 Mb
azameo 4.796 ms 0.02 Mb
psxmarketingwithgoogle 5.185 ms 0.01 Mb
chatyprestashop 4.917 ms 0.02 Mb
cz_verticalmenu 10.802 ms 0.47 Mb
myprestacomments 109.507 ms 0.34 Mb
psproductcountdown 6.992 ms 0.07 Mb
stfeature 22.063 ms 0.10 Mb
ps_facetedsearch 1.530 ms 0.06 Mb
ps_languageselector 3.747 ms 0.05 Mb
ps_currencyselector 0.935 ms 0.05 Mb
cz_navcmsblock 9.278 ms 0.08 Mb
cz_toplink 4.279 ms 0.06 Mb
ps_customersignin 6.471 ms 0.07 Mb
ps_mainmenu 4.573 ms 0.06 Mb
cz_headercmsblock 5.119 ms 0.06 Mb
ps_categorytree 6.257 ms 0.20 Mb
cz_leftbanner 1.089 ms 0.05 Mb
cz_newproducts 8.142 ms 0.12 Mb
cz_imagehover 92.412 ms 1.09 Mb
ldinstagramslider 1.456 ms 0.01 Mb
cz_servicecmsblock 5.752 ms 0.06 Mb
ps_contactinfo 6.344 ms 0.08 Mb
ps_linklist 9.266 ms 0.07 Mb
ps_customeraccountlinks 3.810 ms 0.07 Mb
cz_footercmsblock 4.935 ms 0.06 Mb
czuecookie 7.177 ms 0.06 Mb
statsdata 14.506 ms 0.25 Mb
39 module(s) 587.991 ms 4.48 Mb

Stopwatch SQL - 464 queries

# Query Time (ms) Rows Filesort Group By Location
69 
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>=409 AND c.nright<=436 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.reference DESC, p.id_product DESC
 31.921 ms 9824 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
16 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pharm_module` m
INNER JOIN pharm_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `pharm_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pharm_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pharm_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 7.383 ms 1248 Yes Yes /classes/Hook.php:1233
389 
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.898 ms 4912 Yes /classes/Product.php:3110
463 
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 (1191,1190,1189,1188,1187,1186,1075,1074,1073,1072,723,722,695,694,693,606,605,604,603,602,601,600,599) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 5.416 ms 12584 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
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`)
 5.066 ms 665 /classes/Configuration.php:180
86 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1191
ORDER BY f.position ASC
 4.469 ms 1 Yes /classes/Product.php:6002
391 
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 (1191) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 4.362 ms 1 Yes Yes /classes/Product.php:4507
308 
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` = 1191
ORDER BY `position`
 4.067 ms 2 Yes /classes/Product.php:3545
71 
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 (1191,1190,1189,1188,1187,1186,1075,1074,1073,1072,723,722,695,694,693,606,605,604,603,602,601,600,599)
 3.717 ms 23 /classes/ProductAssembler.php:95
97 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 1190
 3.654 ms 1 /classes/Product.php:6033
79 
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.418 ms 0 /classes/Hook.php:1292
80 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `pharm_hook_module` hm
STRAIGHT_JOIN `pharm_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `pharm_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 2.889 ms 468 /classes/Hook.php:456
379 
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` = 13 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1 AND c.`level_depth` <= 6 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
 2.696 ms 286 Yes Yes /classes/Category.php:799
449 
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
 2.669 ms 1 /src/Adapter/EntityMapper.php:71
81 
SELECT SQL_NO_CACHE tr.*
FROM `pharm_tax_rule` tr
JOIN `pharm_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 64
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('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.573 ms 0 /classes/tax/TaxRulesTaxManager.php:109
362 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `pharm_currency` c
LEFT JOIN pharm_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
 2.457 ms 1 /classes/Currency.php:1136
41 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM pharm_category_group ctg
WHERE ctg.`id_category` = 13 AND ctg.`id_group` = 1 LIMIT 1
 2.421 ms 1 /classes/Category.php:1754
85 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1191 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` = 1191 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2.332 ms 0 /classes/Cart.php:1410
60 
SELECT SQL_NO_CACHE *
FROM `pharm_category` a0
LEFT JOIN `pharm_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 409) AND (a0.`nright` > 436) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 2.317 ms 572 Yes /classes/PrestaShopCollection.php:383
144 
SELECT SQL_NO_CACHE *
FROM `pharm_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 2.176 ms 1 /src/Adapter/EntityMapper.php:71
440 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pharm_country`
WHERE `id_country` = 64 LIMIT 1
 2.161 ms 1 /classes/Country.php:405
72 
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` = 1191
AND image_shop.`cover` = 1 LIMIT 1
 2.135 ms 2 /classes/Product.php:3570
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `pharm_hook` h
WHERE (h.active = 1)
 2.037 ms 1034 /classes/Hook.php:1332
70 
SELECT SQL_NO_CACHE data FROM pharm_layered_filter_block WHERE hash="8702bc9d4a8bbc40c3c613249d1f6d66" LIMIT 1
 1.916 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
106 
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 = 1189
ORDER BY f.position ASC
 1.897 ms 1 Yes /classes/Product.php:6002
312 
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` = 1190
ORDER BY `position`
 1.742 ms 3 Yes /classes/Product.php:3545
310 
SELECT SQL_NO_CACHE state FROM pharm_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 1.693 ms 1 /classes/FeatureFlag.php:105
452 
INSERT INTO `pharm_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
 1.668 ms 1 /classes/ObjectModel.php:622
77 
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` = 1191)
 1.624 ms 1 /classes/Product.php:3860
149 
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 = 1075
ORDER BY f.position ASC
 1.478 ms 1 Yes /classes/Product.php:6002
105 
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` = 1189 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` = 1189 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.470 ms 0 /classes/Cart.php:1410
148 
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` = 1075 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` = 1075 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.448 ms 0 /classes/Cart.php:1410
190 
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 = 723
ORDER BY f.position ASC
 1.413 ms 1 Yes /classes/Product.php:6002
95 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1190 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` = 1190 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.330 ms 0 /classes/Cart.php:1410
116 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1188
ORDER BY f.position ASC
 1.294 ms 1 Yes /classes/Product.php:6002
90 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1190) AND (b.`id_shop` = 1) LIMIT 1
 1.259 ms 1 /src/Adapter/EntityMapper.php:71
279 
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 = 602
ORDER BY f.position ASC
 1.256 ms 1 Yes /classes/Product.php:6002
220 
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 = 694
ORDER BY f.position ASC
 1.248 ms 1 Yes /classes/Product.php:6002
96 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1190
ORDER BY f.position ASC
 1.246 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 = 1186
ORDER BY f.position ASC
 1.226 ms 1 Yes /classes/Product.php:6002
240 
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 = 606
ORDER BY f.position ASC
 1.206 ms 1 Yes /classes/Product.php:6002
50 
SELECT SQL_NO_CACHE 1 FROM pharm_cart_product cp INNER JOIN pharm_product p
ON (p.id_product = cp.id_product) INNER JOIN pharm_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 1.192 ms 1 /classes/Cart.php:4192
288 
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` = 601 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` = 601 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.187 ms 0 /classes/Cart.php:1410
278 
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` = 602 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` = 602 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.176 ms 0 /classes/Cart.php:1410
230 
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 = 693
ORDER BY f.position ASC
 1.169 ms 1 Yes /classes/Product.php:6002
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
 1.166 ms 102 Yes /classes/Dispatcher.php:654
453 
SELECT SQL_NO_CACHE `id_guest`
FROM `pharm_connections`
WHERE `id_guest` = 402938
AND `date_add` > '2025-01-18 10:46:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 1.164 ms 1 Yes /classes/Connection.php:168
158 
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` = 1074 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` = 1074 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.155 ms 0 /classes/Cart.php:1410
306 
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` = 599 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` = 599 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.147 ms 0 /classes/Cart.php:1410
298 
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 = 600
ORDER BY f.position ASC
 1.144 ms 1 Yes /classes/Product.php:6002
297 
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` = 600 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` = 600 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.131 ms 0 /classes/Cart.php:1410
189 
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` = 723 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` = 723 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.108 ms 0 /classes/Cart.php:1410
115 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1188 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` = 1188 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.107 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` = 1186 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` = 1186 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.106 ms 0 /classes/Cart.php:1410
75 
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` = 1191) AND (b.`id_shop` = 1) LIMIT 1
 1.097 ms 1 /src/Adapter/EntityMapper.php:71
459 
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.089 ms 4096 /classes/DateRange.php:60
458 
INSERT INTO `pharm_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('361827', '', 'pharmaciedelalliance.com/en/13-medical-supplies', '', '2025-01-18 11:16:21')
 1.085 ms 1 /classes/ObjectModel.php:622
164 
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` = 1073)
 1.074 ms 1 /classes/Product.php:3860
159 
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 = 1074
ORDER BY f.position ASC
 1.062 ms 1 Yes /classes/Product.php:6002
289 
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 = 601
ORDER BY f.position ASC
 1.055 ms 1 Yes /classes/Product.php:6002
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` = 13
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 1.043 ms 6 Yes Yes /classes/Category.php:924
169 
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 = 1073
ORDER BY f.position ASC
 1.025 ms 1 Yes /classes/Product.php:6002
307 
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 = 599
ORDER BY f.position ASC
 1.025 ms 1 Yes /classes/Product.php:6002
100 
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` = 1189) AND (b.`id_shop` = 1) LIMIT 1
 1.022 ms 1 /src/Adapter/EntityMapper.php:71
239 
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` = 606 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` = 606 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.021 ms 0 /classes/Cart.php:1410
229 
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` = 693 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` = 693 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.016 ms 0 /classes/Cart.php:1410
219 
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` = 694 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` = 694 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.012 ms 0 /classes/Cart.php:1410
168 
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` = 1073 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` = 1073 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.006 ms 0 /classes/Cart.php:1410
292 
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` = 600) AND (b.`id_shop` = 1) LIMIT 1
 0.995 ms 1 /src/Adapter/EntityMapper.php:71
455 
SELECT SQL_NO_CACHE `id_page`
FROM `pharm_page`
WHERE `id_page_type` = 7 AND `id_object` = 13 LIMIT 1
 0.984 ms 1 /classes/Page.php:83
283 
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` = 601) AND (b.`id_shop` = 1) LIMIT 1
 0.979 ms 1 /src/Adapter/EntityMapper.php:71
280 
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` = 601
AND image_shop.`cover` = 1 LIMIT 1
 0.975 ms 1 /classes/Product.php:3570
301 
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` = 599) AND (b.`id_shop` = 1) LIMIT 1
 0.969 ms 1 /src/Adapter/EntityMapper.php:71
392 
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` = 1190
ORDER BY `position`
 0.946 ms 3 Yes /classes/Product.php:3545
460 
UPDATE `pharm_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 106
AND `id_page` = 82
AND `id_shop` = 1
 0.933 ms 1 /classes/Page.php:131
457 
INSERT IGNORE INTO `pharm_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('361827', '82', '2025-01-18 11:16:21')
 0.919 ms 1 /classes/Connection.php:122
19 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pharm_hook`
 0.912 ms 1034 /classes/Hook.php:1292
179 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 1072
 0.908 ms 1 /classes/Product.php:6033
454 
SELECT SQL_NO_CACHE id_page_type
FROM pharm_page_type
WHERE name = 'category' LIMIT 1
 0.906 ms 1 /classes/Page.php:104
145 
SELECT SQL_NO_CACHE *
FROM `pharm_tax_lang`
WHERE `id_tax` = 1
 0.896 ms 2 /src/Adapter/EntityMapper.php:79
269 
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 = 603
ORDER BY f.position ASC
 0.896 ms 1 Yes /classes/Product.php:6002
210 
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 = 695
ORDER BY f.position ASC
 0.882 ms 1 Yes /classes/Product.php:6002
125 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM pharm_feature_product pf
LEFT JOIN pharm_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pharm_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pharm_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pharm_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1187
ORDER BY f.position ASC
 0.857 ms 1 Yes /classes/Product.php:6002
209 
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` = 695 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` = 695 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.850 ms 0 /classes/Cart.php:1410
268 
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` = 603 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` = 603 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.848 ms 0 /classes/Cart.php:1410
126 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 1187
 0.846 ms 1 /classes/Product.php:6033
153 
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` = 1074) AND (b.`id_shop` = 1) LIMIT 1
 0.846 ms 1 /src/Adapter/EntityMapper.php:71
49 
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.844 ms 104 /classes/module/Module.php:345
82 
SELECT SQL_NO_CACHE `reduction`
FROM `pharm_product_group_reduction_cache`
WHERE `id_product` = 1191 AND `id_group` = 1 LIMIT 1
 0.830 ms 0 /classes/GroupReduction.php:156
248 
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` = 605 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` = 605 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.824 ms 0 /classes/Cart.php:1410
172 
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` = 1072) AND (b.`id_shop` = 1) LIMIT 1
 0.821 ms 1 /src/Adapter/EntityMapper.php:71
110 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1188) AND (b.`id_shop` = 1) LIMIT 1
 0.820 ms 1 /src/Adapter/EntityMapper.php:71
124 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pharm_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1187 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` = 1187 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.818 ms 0 /classes/Cart.php:1410
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.813 ms 1 Yes /classes/shop/Shop.php:1364
88 
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` = 1190
AND image_shop.`cover` = 1 LIMIT 1
 0.812 ms 3 /classes/Product.php:3570
107 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 1189
 0.803 ms 1 /classes/Product.php:6033
249 
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 = 605
ORDER BY f.position ASC
 0.800 ms 1 Yes /classes/Product.php:6002
231 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 693
 0.799 ms 1 /classes/Product.php:6033
462 
SELECT SQL_NO_CACHE data
FROM `pharm_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.796 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
177 
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` = 1072 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` = 1072 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.795 ms 0 /classes/Cart.php:1410
27 
SELECT SQL_NO_CACHE *
FROM `pharm_category` a
LEFT JOIN `pharm_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pharm_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
 0.789 ms 1 /src/Adapter/EntityMapper.php:71
140 
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` = 1075) AND (b.`id_shop` = 1) LIMIT 1
 0.789 ms 1 /src/Adapter/EntityMapper.php:71
6 
SELECT SQL_NO_CACHE *
FROM `pharm_country` a
LEFT JOIN `pharm_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `pharm_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 64) LIMIT 1
 0.788 ms 1 /src/Adapter/EntityMapper.php:71
211 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 695
 0.787 ms 1 /classes/Product.php:6033
198 
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` = 722 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` = 722 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.785 ms 0 /classes/Cart.php:1410
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.784 ms 104 /classes/module/Module.php:345
143 
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
 0.781 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
136 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 1186
 0.780 ms 1 /classes/Product.php:6033
284 
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` = 601)
 0.778 ms 1 /classes/Product.php:3860
178 
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 = 1072
ORDER BY f.position ASC
 0.773 ms 1 Yes /classes/Product.php:6002
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` = 1186) AND (b.`id_shop` = 1) LIMIT 1
 0.770 ms 1 /src/Adapter/EntityMapper.php:71
199 
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 = 722
ORDER BY f.position ASC
 0.769 ms 1 Yes /classes/Product.php:6002
234 
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` = 606) AND (b.`id_shop` = 1) LIMIT 1
 0.767 ms 1 /src/Adapter/EntityMapper.php:71
302 
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` = 599)
 0.767 ms 1 /classes/Product.php:3860
214 
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` = 694) AND (b.`id_shop` = 1) LIMIT 1
 0.766 ms 1 /src/Adapter/EntityMapper.php:71
258 
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` = 604 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` = 604 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.766 ms 0 /classes/Cart.php:1410
87 
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.761 ms 0 /classes/tax/TaxRulesTaxManager.php:109
66 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM pharm_layered_category
WHERE controller = 'category'
AND id_category = 13
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.760 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
150 
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.755 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
221 
SELECT SQL_NO_CACHE *
FROM pharm_product_attachment pa
LEFT JOIN pharm_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN pharm_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 694
 0.752 ms 1 /classes/Product.php:6033
183 
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` = 723) AND (b.`id_shop` = 1) LIMIT 1
 0.746 ms 1 /src/Adapter/EntityMapper.php:71
1 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM pharm_shop_group gs
LEFT JOIN pharm_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pharm_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.745 ms 1 Yes /classes/shop/Shop.php:715
98 
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` = 1189
AND image_shop.`cover` = 1 LIMIT 1
 0.743 ms 3 /classes/Product.php:3570
224 
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` = 693) AND (b.`id_shop` = 1) LIMIT 1
 0.732 ms 1 /src/Adapter/EntityMapper.php:71
108 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1188
AND image_shop.`cover` = 1 LIMIT 1
 0.730 ms 2 /classes/Product.php:3570
259 
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 = 604
ORDER BY f.position ASC
 0.725 ms 1 Yes /classes/Product.php:6002
127 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1186
AND image_shop.`cover` = 1 LIMIT 1
 0.718 ms 3 /classes/Product.php:3570
243 
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` = 605) AND (b.`id_shop` = 1) LIMIT 1
 0.713 ms 1 /src/Adapter/EntityMapper.php:71
299 
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` = 599
AND image_shop.`cover` = 1 LIMIT 1
 0.708 ms 4 /classes/Product.php:3570
193 
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` = 722) AND (b.`id_shop` = 1) LIMIT 1
 0.705 ms 1 /src/Adapter/EntityMapper.php:71
151 
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` = 1074
AND image_shop.`cover` = 1 LIMIT 1
 0.702 ms 2 /classes/Product.php:3570
290 
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` = 600
AND image_shop.`cover` = 1 LIMIT 1
 0.698 ms 4 /classes/Product.php:3570
119 
SELECT SQL_NO_CACHE *
FROM `pharm_product` a
LEFT JOIN `pharm_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pharm_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1187) AND (b.`id_shop` = 1) LIMIT 1
 0.697 ms 1 /src/Adapter/EntityMapper.php:71
270 
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` = 602
AND image_shop.`cover` = 1 LIMIT 1
 0.696 ms 1 /classes/Product.php:3570
191 
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` = 722
AND image_shop.`cover` = 1 LIMIT 1
 0.684 ms 2 /classes/Product.php:3570
293 
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` = 600)
 0.684 ms 1 /classes/Product.php:3860
163 
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` = 1073) AND (b.`id_shop` = 1) LIMIT 1
 0.682 ms 1 /src/Adapter/EntityMapper.php:71
232 
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` = 606
AND image_shop.`cover` = 1 LIMIT 1
 0.673 ms 2 /classes/Product.php:3570
137 
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` = 1075
AND image_shop.`cover` = 1 LIMIT 1
 0.665 ms 1 /classes/Product.php:3570
416 
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` = 694
ORDER BY `position`
 0.665 ms 1 Yes /classes/Product.php:3545
180 
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` = 723
AND image_shop.`cover` = 1 LIMIT 1
 0.663 ms 1 /classes/Product.php:3570
203 
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` = 695) AND (b.`id_shop` = 1) LIMIT 1
 0.663 ms 1 /src/Adapter/EntityMapper.php:71
212 
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` = 694
AND image_shop.`cover` = 1 LIMIT 1
 0.654 ms 1 /classes/Product.php:3570
417 
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 (694) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.654 ms 1 Yes Yes /classes/Product.php:4507
222 
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` = 693
AND image_shop.`cover` = 1 LIMIT 1
 0.653 ms 7 /classes/Product.php:3570
262 
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` = 603) AND (b.`id_shop` = 1) LIMIT 1
 0.653 ms 1 /src/Adapter/EntityMapper.php:71
272 
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` = 602) AND (b.`id_shop` = 1) LIMIT 1
 0.652 ms 1 /src/Adapter/EntityMapper.php:71
253 
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` = 604) AND (b.`id_shop` = 1) LIMIT 1
 0.649 ms 1 /src/Adapter/EntityMapper.php:71
320 
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` = 1186
ORDER BY `position`
 0.648 ms 3 Yes /classes/Product.php:3545
390 
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` = 1191
ORDER BY `position`
 0.644 ms 2 Yes /classes/Product.php:3545
91 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1190)
 0.635 ms 1 /classes/Product.php:3860
314 
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` = 1189
ORDER BY `position`
 0.623 ms 3 Yes /classes/Product.php:3545
170 
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` = 1072
AND image_shop.`cover` = 1 LIMIT 1
 0.619 ms 5 /classes/Product.php:3570
316 
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` = 1188
ORDER BY `position`
 0.618 ms 2 Yes /classes/Product.php:3545
28 
SELECT SQL_NO_CACHE * FROM `pharm_currency` c ORDER BY `iso_code` ASC
 0.610 ms 1 Yes /classes/Currency.php:709
185 
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` = 723)
 0.596 ms 1 /classes/Product.php:3860
117 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pharm_image` i
INNER JOIN pharm_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1187
AND image_shop.`cover` = 1 LIMIT 1
 0.593 ms 3 /classes/Product.php:3570
101 
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` = 1189)
 0.583 ms 1 /classes/Product.php:3860
419 
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 (693) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.581 ms 1 Yes Yes /classes/Product.php:4507
418 
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` = 693
ORDER BY `position`
 0.575 ms 7 Yes /classes/Product.php:3545
401 
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 (1186) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.574 ms 1 Yes Yes /classes/Product.php:4507
241 
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` = 605
AND image_shop.`cover` = 1 LIMIT 1
 0.565 ms 1 /classes/Product.php:3570
435 
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 (599) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.565 ms 1 Yes Yes /classes/Product.php:4507
411 
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 (723) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.561 ms 1 Yes Yes /classes/Product.php:4507
409 
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 (1072) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.558 ms 1 Yes Yes /classes/Product.php:4507
173 
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` = 1072)
 0.557 ms 1 /classes/Product.php:3860
318 
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` = 1187
ORDER BY `position`
 0.550 ms 3 Yes /classes/Product.php:3545
399 
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 (1187) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.548 ms 1 Yes Yes /classes/Product.php:4507
154 
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` = 1074)
 0.547 ms 1 /classes/Product.php:3860
395 
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 (1189) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.544 ms 1 Yes Yes /classes/Product.php:4507
405 
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 (1074) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.542 ms 1 Yes Yes /classes/Product.php:4507
425 
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 (604) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.542 ms 1 Yes Yes /classes/Product.php:4507
111 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1188)
 0.537 ms 1 /classes/Product.php:3860
423 
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 (605) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.534 ms 1 Yes Yes /classes/Product.php:4507
427 
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 (603) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.534 ms 1 Yes Yes /classes/Product.php:4507
225 
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` = 693)
 0.532 ms 1 /classes/Product.php:3860
433 
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 (600) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.530 ms 1 Yes Yes /classes/Product.php:4507
393 
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 (1190) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.528 ms 1 Yes Yes /classes/Product.php:4507
200 
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` = 695
AND image_shop.`cover` = 1 LIMIT 1
 0.526 ms 1 /classes/Product.php:3570
274 
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` = 602)
 0.526 ms 1 /classes/Product.php:3860
130 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1186)
 0.525 ms 1 /classes/Product.php:3860
120 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `pharm_product` p
INNER JOIN `pharm_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pharm_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1187)
 0.524 ms 1 /classes/Product.php:3860
244 
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` = 605)
 0.522 ms 1 /classes/Product.php:3860
141 
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` = 1075)
 0.520 ms 1 /classes/Product.php:3860
254 
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` = 604)
 0.518 ms 1 /classes/Product.php:3860
397 
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 (1188) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.515 ms 1 Yes Yes /classes/Product.php:4507
413 
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 (722) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.515 ms 1 Yes Yes /classes/Product.php:4507
235 
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` = 606)
 0.512 ms 1 /classes/Product.php:3860
429 
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 (602) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.511 ms 1 Yes Yes /classes/Product.php:4507
160 
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` = 1073
AND image_shop.`cover` = 1 LIMIT 1
 0.510 ms 1 /classes/Product.php:3570
403 
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 (1075) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.509 ms 1 Yes Yes /classes/Product.php:4507