Welcome to our new website design! Check out our New ArrivalsSale Items & Free Offers.

Information Banner

Purchase a gift voucher

  

Ramadan Hajj & Zakat 1 product.

Showing 1-1 of 1 item(s)

Active filters

  • Brand: Authentic Statements
4.9 42

Sittings in The Month of Ramadan

And from the virtues of this month is that the good deeds are multiplied. It has been narrated that the optional deeds are equal in reward to the obligatory deeds, and the obligatory deeds have the...

RB11) $21.95 Price
view product

Boxed:

Sticky Add To Cart

Font:

Load Time 287 ms
Querying Time 51 ms
Queries 285
Memory Peak Usage 62.1 Mb
Included Files 1064 files - 12.66 Mb
PrestaShop Cache - Mb
Global vars 0.47 Mb
PrestaShop Version 1.7.8.1
PHP Version 7.2.34
MySQL Version 10.2.41-MariaDB
Memory Limit 5040M
Max Execution Time 1200s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 15 ms 15 ms 17.35 Mb 17.6 Mb
__construct 0 ms 15 ms - Mb 17.6 Mb
init 40 ms 55 ms 7.23 Mb 24.8 Mb
checkAccess 0 ms 55 ms - Mb 24.8 Mb
setMedia 23 ms 78 ms 4.18 Mb 28.8 Mb
postProcess 0 ms 78 ms - Mb 28.8 Mb
initHeader 0 ms 78 ms - Mb 28.8 Mb
initContent 129 ms 207 ms 25.41 Mb 54.5 Mb
initFooter 0 ms 207 ms - Mb 54.5 Mb
display 81 ms 287 ms 7.85 Mb 62.1 Mb
Hook Time Memory Usage
displayTop 13 ms 1.91 Mb
DisplayBeforeBodyClosingTag 9 ms 0.48 Mb
Header 7 ms 3.58 Mb
DisplayLeftColumn 5 ms 0.13 Mb
ActionFrontControllerSetMedia 5 ms 1.28 Mb
Footer 4 ms 1.22 Mb
DisplayCustomBannerMenu 4 ms 0.39 Mb
displayFooter 4 ms 0.53 Mb
DisplayHeader 3 ms 1.43 Mb
DisplayProductPriceBlock 3 ms 0.52 Mb
ProductSearchProvider 2 ms 0.57 Mb
DisplayTop 0 ms 0.05 Mb
DisplayAfterBodyOpeningTag 0 ms 0.04 Mb
DisplayBonCart 0 ms 0.05 Mb
DisplayFooter 0 ms 0.12 Mb
DisplayWrapperBottom 0 ms 0.04 Mb
ModuleRoutes 0 ms 0.02 Mb
DisplayBonWishlist 0 ms 0.01 Mb
ActionDispatcher 0 ms - Mb
ActionProductSearchAfter 0 ms - Mb
DisplayProductButton 0 ms - Mb
FilterCategoryContent 0 ms - Mb
OverrideLayoutTemplate 0 ms - Mb
DisplayFooterAfter 0 ms - Mb
DisplayOverrideTemplate 0 ms - Mb
Top 0 ms - Mb
26 hook(s) 61 ms 12.37 Mb
Module Time Memory Usage
relatedproductspremium 6 ms 2.05 Mb
psitadvcleanurls 9 ms 2.08 Mb
litespeedcache 3 ms 0.57 Mb
ps_emailsubscription 6 ms 0.68 Mb
lgcomments 10 ms 3.45 Mb
ps_checkout 14 ms 1.95 Mb
boncart 1 ms 0.21 Mb
bonsearch 1 ms 0.22 Mb
bontheme 1 ms 0.26 Mb
productbutton 1 ms 0.22 Mb
productpurchase 2 ms 0.46 Mb
productyoutube 1 ms 0.35 Mb
bonwishlist 1 ms 0.22 Mb
usps 5 ms 2.36 Mb
giftcard 27 ms 7.08 Mb
bonjavascript 1 ms 0.11 Mb
op_googleauto 0 ms 0.06 Mb
ps_shoppingcart 2 ms 0.63 Mb
bonban 1 ms 0.54 Mb
bonbanner 1 ms 0.26 Mb
bonbannermenu 5 ms 0.64 Mb
bonbrand 3 ms 0.70 Mb
bonhtmlcontent 1 ms 0.58 Mb
bonnotice 1 ms 0.37 Mb
bonslick 1 ms 0.56 Mb
boninfoban 5 ms 0.65 Mb
hioutofstocknotification 3 ms 0.95 Mb
ups 3 ms 0.65 Mb
onestepcheckout 0 ms 0.04 Mb
ps_facetedsearch 5 ms 0.95 Mb
ps_mainmenu 9 ms 1.20 Mb
ps_customersignin 1 ms 0.17 Mb
ps_languageselector 0 ms 0.07 Mb
ps_currencyselector 2 ms 0.34 Mb
googlecustomsearch 0 ms 0.03 Mb
ps_contactinfo 1 ms 0.12 Mb
ps_socialfollow 2 ms 0.23 Mb
ps_linklist 1 ms 0.19 Mb
ps_customeraccountlinks 1 ms 0.11 Mb
papintegration 1 ms 0.27 Mb
statsdata 9 ms 0.47 Mb
41 module(s) 149 ms 33.06 Mb

Stopwatch SQL - 285 queries

Query Time (ms) Rows Filesort Group By Location
INSERT INTO `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')
2656 ms 1 /classes/ObjectModel.php:578
INSERT INTO `connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1363480', '77', '916388712', '', '1', '1', '2021-11-28 19:57:05')
2055 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE nick, comment, stars, date FROM lgcomments_storecomments WHERE active = 1 AND stars > 6 ORDER BY RAND()
1994 ms 1248 Yes /modules/lgcomments/classes/LGStoreComment.php:171
REPLACE INTO layered_filter_block (hash, data) VALUES ("65783c2be52573fe77326a5cd2dd96ed", "a:1:{s:7:\"filters\";a:5:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:8:\"quantity\";s:4:\"type\";s:8:\"quantity\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:0;}i:1;a:2:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:4:{i:1;a:2:{s:4:\"name\";s:12:\"Dar-us-Salam\";s:3:\"nbr\";s:2:\"17\";}i:34;a:2:{s:4:\"name\";s:17:\"Adly Publications\";s:3:\"nbr\";s:1:\"1\";}i:47;a:2:{s:4:\"name\";s:19:\"Dar-us-Salam Hadith\";s:3:\"nbr\";s:1:\"2\";}i:60;a:3:{s:4:\"name\";s:20:\"Authentic Statements\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:22;s:3:\"min\";d:22;s:4:\"unit\";s:1:\"$\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"USD\";s:14:\"currencySymbol\";s:1:\"$\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:1;s:5:\"value\";N;}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"3\";s:6:\"values\";a:1:{i:2;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:9:\"Paperback\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Binding\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")
1750 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:193
SELECT SQL_NO_CACHE * FROM `state` ORDER BY `name` ASC
1625 ms 315 Yes /classes/Country.php:154
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 `configuration` c
LEFT JOIN `configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1561 ms 1405 /classes/Configuration.php:160
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
1234 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `country` c  INNER JOIN country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1112 ms 245 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `module` m
INNER JOIN 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 `module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
998 ms 154 Yes Yes /classes/Hook.php:1173
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `hook_alias` ha
INNER JOIN `hook` h ON ha.name = h.name
983 ms 0 /classes/Hook.php:1233
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 `hook_module` hm
STRAIGHT_JOIN `hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
777 ms 393 /classes/Hook.php:494
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 FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 ) GROUP BY p.id_product ORDER BY p.quantity DESC, p.id_product DESC LIMIT 0, 28
724 ms 841 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1  AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))
554 ms 841 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute
545 ms 290 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) WHERE c.level_depth<=4 AND c.nleft>52 AND c.nright<53 GROUP BY cp.id_category
543 ms 841 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1  AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity>=0 AND sa_1.out_of_stock=1) OR (sa.quantity>0))
543 ms 841 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute
529 ms 841 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_manufacturer
526 ms 90000 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=3)) GROUP BY fp.id_feature_value
498 ms 841 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN 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 product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1' GROUP BY p.id_product) p
490 ms 841 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `manufacturer` m INNER JOIN manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
479 ms 51 Yes /classes/Manufacturer.php:207
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `attribute_group` ag INNER JOIN `attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC
443 ms 47 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:84
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`
FROM `category` c
INNER JOIN category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.nleft, c.position
396 ms 103 Yes /classes/Category.php:718
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `hook`
379 ms 849 /classes/Hook.php:1233
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM lgcomments_storecomments WHERE active = 1 LIMIT 1
376 ms 1248 /modules/lgcomments/classes/LGStoreComment.php:149
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `manufacturer` m INNER JOIN manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
364 ms 51 Yes /classes/Manufacturer.php:207
SELECT SQL_NO_CACHE COUNT(id_storecomment) AS total FROM lgcomments_storecomments WHERE active = 1 LIMIT 1
343 ms 1248 /modules/lgcomments/classes/LGStoreComment.php:159
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `category` c
INNER JOIN category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
WHERE `id_parent` = 32
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
323 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM product p INNER JOIN layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 21) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer='60' AND c.nleft>=52 AND c.nright<=53 AND ps.id_shop='1'
305 ms 29 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `attribute_group` ag  INNER JOIN attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC
290 ms 14 Yes Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:125
SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `feature_value` v LEFT JOIN `feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 3 ORDER BY vl.`value` ASC
284 ms 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:181
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
269 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
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 `product_attribute` pa
INNER JOIN 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 `product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1662) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
267 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-11-28 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM product p
LEFT JOIN product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 1662
LIMIT 1
267 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `feature` f  INNER JOIN feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
258 ms 11 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM shop_url su
LEFT JOIN shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'dar-us-salam.com' OR su.domain_ssl = 'dar-us-salam.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
258 ms 1 Yes /classes/shop/Shop.php:1350
(SELECT SQL_NO_CACHE * FROM `cart_rule` cr
LEFT JOIN `cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
253 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE *
FROM boninfoban bonb
JOIN boninfoban_lang bonbl
ON bonb.id_tab = bonbl.id_tab
AND bonbl.id_lang = 1
AND bonb.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
242 ms 4 Yes /modules/boninfoban/classes/InfoBan.php:127
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 `cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1662 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cart_product` cp JOIN `pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `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` = 1662 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
234 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `attribute_group` ag INNER JOIN `attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC
233 ms 5 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:84
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
232 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `feature` f  INNER JOIN feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
223 ms 11 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:157
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `module` m
LEFT JOIN `module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
220 ms 84 /classes/module/Module.php:340
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 shop_group gs
LEFT JOIN shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN 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
219 ms 1 Yes /classes/shop/Shop.php:711
(SELECT SQL_NO_CACHE * FROM `cart_rule` cr
LEFT JOIN `cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
216 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM feature_product pf
LEFT JOIN feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1662
ORDER BY f.position ASC
214 ms 8 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
208 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
SELECT SQL_NO_CACHE c.*, cl.*  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 52 AND c.`nright` >= 53 AND c.`nleft` >= 1 AND c.`nright` <= 204 ORDER BY `nleft` DESC
205 ms 102 Yes /classes/Category.php:1586
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `module` m
LEFT JOIN `module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
204 ms 84 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
197 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
196 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
SELECT SQL_NO_CACHE *
FROM bonjavascript bonj
WHERE bonj.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
194 ms 5 Yes /modules/bonjavascript/classes/ClassJavascript.php:100
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `meta` m
LEFT JOIN `meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
191 ms 41 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
186 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
(SELECT SQL_NO_CACHE * FROM `cart_rule` cr
LEFT JOIN `cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
185 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE *
FROM `category` c
LEFT JOIN `category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 52 AND c.nright >= 53)
ORDER BY c.nleft
183 ms 102 Yes /classes/Product.php:7746
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
183 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
183 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
SELECT SQL_NO_CACHE *
FROM bonbannermenu bonbm
JOIN bonbannermenu_lang bonbml
ON bonbm.id_tab = bonbml.id_tab
WHERE bonbml.id_lang = 1
AND bonbm.id_shop =1 AND `status` = 1 ORDER BY `sort_order`
181 ms 4 Yes /modules/bonbannermenu/classes/ClassBannersmenu.php:127
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `module` m
LEFT JOIN `module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
179 ms 84 /classes/module/Module.php:340
SELECT SQL_NO_CACHE tr.*
FROM `tax_rule` tr
JOIN `tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 59
AND tr.`id_state` IN (0, 43)
AND ('77043' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '77043')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
176 ms 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `category` a0
LEFT JOIN `category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 52) AND (a0.`nright` > 53) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
176 ms 102 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE *
FROM `product` a
LEFT JOIN `product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1662) AND (b.`id_shop` = 1) LIMIT 1
172 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 1 FROM cart_product cp INNER JOIN product p
ON (p.id_product = cp.id_product) INNER JOIN product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
169 ms 1 /classes/Cart.php:4218
SELECT SQL_NO_CACHE *
FROM `category` c
LEFT JOIN `category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 52 AND c.nright >= 53)
ORDER BY c.nleft
166 ms 102 Yes /classes/Product.php:7746
SELECT SQL_NO_CACHE c.*, cl.*  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 52 AND c.`nright` >= 53 AND c.`nleft` >= 1 AND c.`nright` <= 204 ORDER BY `nleft` DESC
165 ms 102 Yes /classes/Category.php:1586
SELECT SQL_NO_CACHE c.*, cl.*  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 52 AND c.`nright` >= 53 AND c.`nleft` >= 1 AND c.`nright` <= 204 ORDER BY `nleft` DESC
164 ms 102 Yes /classes/Category.php:1586
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `category` c
LEFT JOIN `category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
164 ms 2 /classes/Category.php:2233
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM layered_category
WHERE id_category = 32
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
163 ms 7 Yes Yes /modules/ps_facetedsearch/src/Filters/Converter.php:247
SELECT SQL_NO_CACHE c.*, cl.*  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 52 AND c.`nright` >= 53 AND c.`nleft` >= 1 AND c.`nright` <= 204 ORDER BY `nleft` DESC
162 ms 102 Yes /classes/Category.php:1586
SELECT SQL_NO_CACHE c.*, cl.*  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 52 AND c.`nright` >= 53 AND c.`nleft` >= 1 AND c.`nright` <= 204 ORDER BY `nleft` DESC
162 ms 102 Yes /classes/Category.php:1586
SELECT SQL_NO_CACHE tr.*
FROM `tax_rule` tr
JOIN `tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 54
AND tr.`id_state` IN (0, 43)
AND ('77043' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '77043')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
159 ms 2 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `image` i
INNER JOIN image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1662
ORDER BY `position`
154 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE tr.*
FROM `tax_rule` tr
JOIN `tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 59
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
146 ms 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE c.*, cl.*  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 27 AND c.`nright` >= 62 AND c.`nleft` >= 1 AND c.`nright` <= 204 ORDER BY `nleft` DESC
145 ms 15 /classes/Category.php:1586
SELECT SQL_NO_CACHE *
FROM bonnotice bonn
JOIN bonnotice_lang bonnl
ON bonn.id_tab = bonnl.id_tab
WHERE bonnl.id_lang = 1
AND bonn.`data_end` >= '2021-11-28 19:57:00'
AND bonn.`data_start` <= '2021-11-28 19:57:00'
AND bonn.id_shop =1
144 ms 1 /modules/bonnotice/classes/ClassNotice.php:63
SELECT SQL_NO_CACHE cl.`id_category` FROM `category_lang` cl LEFT JOIN `category` c ON cl.id_category = c.id_category LEFT JOIN `category_shop` cs ON cl.id_shop = cs.id_shop AND cs.id_category = c.id_category WHERE cl.`id_shop` = '1' AND cs.`id_shop` IS NOT NULL AND cl.`link_rewrite` = 'ramadan-hajj-zakat' AND cl.`id_lang` = '1' LIMIT 2
142 ms 1 /modules/psitadvcleanurls/psitadvcleanurls.php:3563
SELECT SQL_NO_CACHE cl.`id_category` FROM `category_lang` cl LEFT JOIN `category` c ON cl.id_category = c.id_category LEFT JOIN `category_shop` cs ON cl.id_shop = cs.id_shop AND cs.id_category = c.id_category WHERE cl.`id_shop` = '1' AND cs.`id_shop` IS NOT NULL AND cl.`link_rewrite` = 'english' AND c.id_parent = '2' AND cl.`id_lang` = '1' LIMIT 1
139 ms 1 /modules/psitadvcleanurls/psitadvcleanurls.php:3969
SELECT SQL_NO_CACHE *
FROM `currency` c
INNER JOIN currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
139 ms 16 Yes /classes/Currency.php:694
SELECT SQL_NO_CACHE * FROM `currency` c ORDER BY `iso_code` ASC
138 ms 4 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE *
FROM `category` a
LEFT JOIN `category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 32) AND (b.`id_shop` = 1) LIMIT 1
136 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `product` p
INNER JOIN product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 1662
AND DATEDIFF("2021-11-28 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
132 ms 0 /classes/Product.php:1647
SELECT SQL_NO_CACHE `id_guest`
FROM `connections`
WHERE `id_guest` = 1363480
AND `date_add` > '2021-11-28 19:27:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
129 ms 1 Yes /classes/Connection.php:154
SELECT SQL_NO_CACHE pl.*, pll.`title`, pll.`time`
FROM productpurchase pl
JOIN productpurchase_lang pll
ON pl.id_tab = pll.id_tab
WHERE pl.`id_shop` = 1
AND pll.`id_lang` = 1
AND pl.`data_end` >= '2021-11-28 19:57:00'
AND pl.`data_start` <= '2021-11-28 19:57:00'
AND pl.`status` = 1 ORDER BY `sort_order`
127 ms 1 Yes /modules/productpurchase/classes/ClassProductPurchase.php:141
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM tag t
LEFT JOIN product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=1662
126 ms 1 /classes/Tag.php:229
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM layered_category WHERE id_category = 32 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
125 ms 7 Yes Yes /modules/ps_facetedsearch/src/Filters/Block.php:108
SELECT SQL_NO_CACHE COUNT(*) FROM `orders` o
LEFT JOIN `order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`)
WHERE o.`id_customer` = 0
AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 9492 LIMIT 1
124 ms 1 /classes/order/Order.php:857
SELECT SQL_NO_CACHE `id_country`
FROM `country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
123 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE *
FROM `country` a
LEFT JOIN `country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
122 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM product_attribute pa
INNER JOIN product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 1662 LIMIT 1
122 ms 1 /classes/Product.php:1037
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `lang` l
JOIN lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
122 ms 1 /classes/Language.php:1198
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 `product` p
INNER JOIN `product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `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` = 1662)
121 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
119 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE cl.`id_category` FROM `category_lang` cl LEFT JOIN `category` c ON cl.id_category = c.id_category LEFT JOIN `category_shop` cs ON cl.id_shop = cs.id_shop AND cs.id_category = c.id_category WHERE cl.`id_shop` = '1' AND cs.`id_shop` IS NOT NULL AND cl.`link_rewrite` = 'ramadan-hajj-zakat' AND c.id_parent = '3' AND cl.`id_lang` = '1' LIMIT 1
119 ms 1 /modules/psitadvcleanurls/psitadvcleanurls.php:3597
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `image` i
INNER JOIN image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1662
AND image_shop.`cover` = 1 LIMIT 1
116 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `pscheckout_funding_source`
WHERE `id_shop` = 1
113 ms 7 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
SELECT SQL_NO_CACHE *
FROM `category` a
LEFT JOIN `category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
113 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionProductSearchProviderRunQueryBefore") LIMIT 1
112 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `lang` l
LEFT JOIN `lang_shop` ls ON (l.id_lang = ls.id_lang)
111 ms 1 /classes/Language.php:1049
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM shop s
LEFT JOIN shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
107 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `smarty_lazy_cache`
WHERE `template_hash`='058b80ee450a0518c27219c45cd7a0d3' AND cache_id="ps_customeraccountlinks|1|1|21" AND compile_id="FoodStore" LIMIT 1
107 ms 1 /classes/Smarty/SmartyCustom.php:216
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `currency` c
LEFT JOIN currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
107 ms 4 /classes/Currency.php:1126
SELECT SQL_NO_CACHE `id_order`
FROM `orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
106 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `name`, `alias` FROM `hook_alias`
106 ms 88 /classes/Hook.php:291
SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
105 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
105 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `group` a
LEFT JOIN `group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
104 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, alias FROM `hook_alias`
103 ms 88 /classes/Hook.php:343
SELECT SQL_NO_CACHE `id_page`
FROM `page`
WHERE `id_page_type` = 6 AND `id_object` = 32 LIMIT 1
102 ms 2 /classes/Page.php:83
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 32 LIMIT 1
102 ms 1 /classes/Category.php:1571
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
101 ms 1 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE * FROM `image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
100 ms 7 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE *
FROM `category` a
LEFT JOIN `category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 32) LIMIT 1
99 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_page_type
FROM page_type
WHERE name = 'category' LIMIT 1
98 ms 1 /classes/Page.php:104
SELECT SQL_NO_CACHE *
FROM `currency_lang`
WHERE `id_currency` = 2
98 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `need_identification_number`
FROM `country`
WHERE `id_country` = 21 LIMIT 1
97 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "filterProductSearch") LIMIT 1
97 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 0 LIMIT 1
96 ms 1 /classes/SpecificPrice.php:411
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 32 LIMIT 1
96 ms 1 /classes/Category.php:1571
SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
96 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `lang` a
LEFT JOIN `lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
96 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 28 AND `id_shop` = 1 LIMIT 1
95 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "bonfblogin") LIMIT 1
95 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `country` a
LEFT JOIN `country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
94 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
93 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `smarty_lazy_cache`
WHERE `template_hash`='a8764711b3c842f7de5222ce4c150c7c' AND cache_id="ps_socialfollow|1|1|21" AND compile_id="FoodStore" LIMIT 1
93 ms 1 /classes/Smarty/SmartyCustom.php:216
SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
92 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_customersignin" LIMIT 1
92 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "moduleRoutes") LIMIT 1
91 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionFrontControllerInitAfter") LIMIT 1
90 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayBonWishlist") LIMIT 1
89 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 32 LIMIT 1
89 ms 1 /classes/Category.php:1571
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionOutputHTMLBefore") LIMIT 1
88 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `smarty_last_flush` WHERE type='compile' LIMIT 1
88 ms 1 /classes/Smarty/SmartyCustom.php:96
SELECT SQL_NO_CACHE domain, domain_ssl
FROM shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
88 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
87 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 32 LIMIT 1
87 ms 1 /classes/Category.php:1571
SELECT SQL_NO_CACHE *
FROM `currency` a
LEFT JOIN `currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
87 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE location
FROM `stock_available`
WHERE (id_product = 1662) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
86 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 3 LIMIT 1
85 ms 1 /classes/Category.php:1571
SELECT SQL_NO_CACHE *
FROM `category_lang`
WHERE `id_category` = 32 AND `id_shop` = 1
85 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
84 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
84 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayProductListReviews") LIMIT 1
84 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `name`
FROM `manufacturer`
WHERE `id_manufacturer` = 60
AND `active` = 1 LIMIT 1
84 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayBonLogFacebook") LIMIT 1
83 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_languageselector" LIMIT 1
83 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
83 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE SUM(quantity)
FROM `stock_available`
WHERE (id_product = 1662) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
83 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
83 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE value FROM `configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
83 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 32 LIMIT 1
81 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
81 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `category` c
LEFT JOIN `category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 32 LIMIT 1
81 ms 1 /classes/Category.php:1571
SELECT SQL_NO_CACHE *
FROM `tax_lang`
WHERE `id_tax` = 43
81 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `product_attribute`
WHERE `id_product` = 1662
80 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `name`
FROM `hook`
WHERE `id_hook` = 534 LIMIT 1
80 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
79 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
79 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
79 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayFooter") LIMIT 1
79 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "psitadvcleanurls" LIMIT 1
79 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `smarty_lazy_cache`
WHERE `template_hash`='14f3e6d3f5719f729bfd1d7275ccfb82' AND cache_id="ps_linklist|displayFooter|1|1|21" AND compile_id="FoodStore" LIMIT 1
78 ms 1 /classes/Smarty/SmartyCustom.php:216
SELECT SQL_NO_CACHE `name`
FROM `hook`
WHERE `id_hook` = 536 LIMIT 1
78 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE out_of_stock
FROM `stock_available`
WHERE (id_product = 1662) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
78 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
78 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayAfterBodyOpeningTag") LIMIT 1
77 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayContentWrapperTop") LIMIT 1
76 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayBonCart") LIMIT 1
76 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionProductSearchProviderRunQueryAfter") LIMIT 1
76 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `state` a
WHERE (a.`id_state` = 43) LIMIT 1
76 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayGDPRConsent") LIMIT 1
76 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE data FROM layered_filter_block WHERE hash="65783c2be52573fe77326a5cd2dd96ed" LIMIT 1
76 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:168
SELECT SQL_NO_CACHE c.id_currency
FROM `currency` c
WHERE (iso_code = 'SAR') LIMIT 1
76 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
75 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
75 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `group_lang`
WHERE `id_group` = 1
75 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
75 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
75 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectAddAfter") LIMIT 1
75 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "productSearchProvider") LIMIT 1
75 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayBanner") LIMIT 1
74 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayThumbnailsImage") LIMIT 1
74 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
74 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayContentWrapperBottom") LIMIT 1
74 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayProductButton") LIMIT 1
73 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_mainmenu" LIMIT 1
73 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
73 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
73 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionFrontControllerSetMedia") LIMIT 1
73 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectAddAfter") LIMIT 1
73 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
73 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE format
FROM `address_format`
WHERE `id_country` = 21 LIMIT 1
73 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE c.id_currency
FROM `currency` c
WHERE (iso_code = 'CAD') LIMIT 1
73 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionBuildFrontEndObject") LIMIT 1
72 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayLeftColumn") LIMIT 1
72 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM required_field
72 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE *
FROM `country_lang`
WHERE `id_country` = 21
72 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayBeforeBodyClosingTag") LIMIT 1
72 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
72 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
72 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_socialfollow" LIMIT 1
72 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `smarty_last_flush` WHERE type='template' LIMIT 1
72 ms 1 /classes/Smarty/SmartyCustom.php:143
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_contactinfo" LIMIT 1
71 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayCustomBannerMenu") LIMIT 1
71 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
71 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
71 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `currency_lang`
WHERE `id_currency` = 1
71 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `iso_code`
FROM `country`
WHERE `id_country` = 21 LIMIT 1
71 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_shoppingcart" LIMIT 1
71 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `product_shop`
WHERE `id_product` = 1662 AND id_shop=1 LIMIT 1
71 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_linklist" LIMIT 1
70 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
70 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `name`
FROM `hook`
WHERE `id_hook` = 672 LIMIT 1
70 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionDispatcherBefore") LIMIT 1
69 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `category` c
WHERE (c.`id_category` = 32) LIMIT 1
69 ms 1 /classes/Category.php:1957
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
69 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE 1 FROM `specific_price` WHERE id_product = 1662 LIMIT 1
68 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `category` c
WHERE c.`id_category` = 1 LIMIT 1
68 ms 1 /classes/Category.php:1577
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionFrontControllerInitBefore") LIMIT 1
67 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE depends_on_stock
FROM `stock_available`
WHERE (id_product = 1662) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
67 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_emailsubscription" LIMIT 1
67 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectConnectionAddAfter") LIMIT 1
67 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_currencyselector" LIMIT 1
67 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionPresentCart") LIMIT 1
67 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `tax` a
WHERE (a.`id_tax` = 43) LIMIT 1
67 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE ctg.`id_group`
FROM category_group ctg
WHERE ctg.`id_category` = 32 AND ctg.`id_group` = 1 LIMIT 1
67 ms 1 /classes/Category.php:1730
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionFrontControllerSetVariables") LIMIT 1
67 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
67 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionPresentCart") LIMIT 1
67 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 17 AND `id_shop` = 1 LIMIT 1
66 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT 1
66 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
66 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE * FROM `hook_module_exceptions`
WHERE `id_shop` IN (1)
66 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
66 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
66 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_shop
FROM `group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
66 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayNav1") LIMIT 1
65 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.id_currency
FROM `currency` c
WHERE (iso_code = 'GBP') LIMIT 1
65 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectGuestAddAfter") LIMIT 1
65 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `name` FROM `supplier` WHERE `id_supplier` = 0 LIMIT 1
65 ms 0 /classes/Supplier.php:244
SELECT SQL_NO_CACHE `id_product` FROM `giftcardproduct`
65 ms 25 /modules/giftcard/models/GiftCardProduct.php:414
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayWrapperBottom") LIMIT 1
64 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayHeader") LIMIT 1
64 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionProductSearchAfter") LIMIT 1
64 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 16 AND `id_shop` = 1 LIMIT 1
64 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE c.id_currency
FROM `currency` c
WHERE (iso_code = 'USD') LIMIT 1
64 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
63 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayProductPriceBlock") LIMIT 1
63 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
63 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
63 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 18 AND `id_shop` = 1 LIMIT 1
63 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
63 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
62 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_shop
FROM `lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
62 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE id_shop
FROM `currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
62 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayNav2") LIMIT 1
62 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
62 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "DisplayOverrideTemplate") LIMIT 1
62 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionControllerInitBefore") LIMIT 1
61 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 27 AND `id_shop` = 1 LIMIT 1
61 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE name FROM category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 32 LIMIT 1
60 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "displayTop") LIMIT 1
60 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `category` c
WHERE c.`id_category` = 1 LIMIT 1
60 ms 1 /classes/Category.php:1577
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
60 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 14 AND `id_shop` = 1 LIMIT 1
60 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `module` WHERE `name` = "ps_legalcompliance" LIMIT 1
59 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 32 AND `id_shop` = 1 LIMIT 1
59 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
59 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `category` c
WHERE c.`id_category` = 1 LIMIT 1
59 ms 1 /classes/Category.php:1577
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 174 AND `id_shop` = 1 LIMIT 1
59 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
59 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "filterCategoryContent") LIMIT 1
58 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `category` c
WHERE c.`id_category` = 1 LIMIT 1
58 ms 1 /classes/Category.php:1577
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `category` c
WHERE c.`id_category` = 1 LIMIT 1
58 ms 1 /classes/Category.php:1577
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1
57 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
57 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `id_lang` FROM `lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
57 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `id_module` FROM `module_shop` WHERE `id_module` = 31 AND `id_shop` = 1 LIMIT 1
57 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `need_identification_number`
FROM `country`
WHERE `id_country` = 21 LIMIT 1
55 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectGuestAddBefore") LIMIT 1
55 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `category` c
WHERE c.`id_category` = 1 LIMIT 1
55 ms 1 /classes/Category.php:1577
SELECT SQL_NO_CACHE active
FROM `hook` h
WHERE (h.name = "actionObjectConnectionAddBefore") LIMIT 1
51 ms 0 /classes/Hook.php:1270