Hazers

Free shipping
ADJ ENTOUR FAZE JR ADJ ENTOUR FAZE JR 2
search
Add to whishlist
Make compaire
In Stock|check
Hazers
090567

ADJ ENTOUR FAZE JR

American DJ
€241.20
In Stock - Delivery in 1-2 days
• 200W Faze μηχανή • Τεχνολογία ταχείας θέρμανσης - έτοιμη για χρήση σε 70 δευτερόλεπτα • Χρησιμοποιεί τυπικό υγρό ομίχλης με βάση το νερό
Free shipping
ADJ ENTOUR FAZE ADJ ENTOUR FAZE 2
search
Add to whishlist
Make compaire
In Stock|check
Hazers
090339

ADJ ENTOUR FAZE

American DJ
€289.00
In Stock - Also available in physical store
•450W faze μηχανή με DMX protocol •Τεχνολογία ταχείας θέρμανσης - έτοιμη για χρήση σε 45 δευτερόλεπτα •Χρησιμοποιεί τυπικό υγρό ομίχλης με βάση το νερό
Free shipping
Entour Venue Entour Venue 2
search
Add to whishlist
Make compaire
In Stock|check
Hazers
090006

Entour Venue

American DJ
€633.00
In Stock - Delivery in 1-2 days
Free shipping
Entourage Entourage 2
search
Add to whishlist
Make compaire
In Stock|check
Hazers
090007

Entourage

American DJ
€888.00
In Stock - Delivery in 1-2 days
Showing 1-4 of 4 item(s)
Product added to wishlist
Product added to compare.
Cookie consent
Load Time 8551 ms
Querying Time 7400 ms
Queries 891
Memory Peak Usage 29.0 Mb
Included Files 1200 files - 14.84 Mb
PrestaShop Cache - Mb
Global vars 0.55 Mb
PrestaShop Version 8.1.3
PHP Version 8.1.23
MySQL Version 5.7.39-log
Memory Limit 2048M
Max Execution Time 30s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 2847 ms 2847 ms 11.00 Mb 11.0 Mb
__construct 0.033 ms 2847 ms - Mb 11.0 Mb
init 427.474 ms 3274 ms 1.16 Mb 12.5 Mb
checkAccess 0.003 ms 3274 ms - Mb 12.5 Mb
setMedia 262.091 ms 3537 ms 0.34 Mb 12.5 Mb
postProcess 0.003 ms 3537 ms - Mb 12.5 Mb
initHeader 0.019 ms 3537 ms - Mb 12.5 Mb
initContent 2124 ms 5660 ms 4.52 Mb 17.2 Mb
initFooter 0.004 ms 5660 ms - Mb 17.2 Mb
display 2891 ms 8551 ms 11.43 Mb 29.0 Mb
Hook Time Memory Usage
DisplayHeader 953 ms 0.40 Mb
DisplayProductPageCss 796.556 ms 5.05 Mb
DisplayAfterTitle 308.794 ms 1.12 Mb
ActionFrontControllerSetMedia 259.304 ms 0.06 Mb
IsJustElementor 239.599 ms 0.02 Mb
displayFooter 157.947 ms 0.40 Mb
displayBeforeBodyClosingTag 133.808 ms 0.34 Mb
displayLeftColumn 116.515 ms 0.08 Mb
DisplayTop 98.859 ms 0.03 Mb
displayNav1 89.794 ms 0.15 Mb
DisplayBeforeBodyClosingTag 67.358 ms 0.34 Mb
DisplayGDPRConsent 54.804 ms 0.12 Mb
DisplayFooter 39.357 ms 0.05 Mb
renderWidget 25.763 ms 0.06 Mb
displayCustomerLoginFormAfter 15.649 ms 0.07 Mb
DisplayCustomerLoginFormAfter 12.135 ms 0.03 Mb
Header 9.661 ms 0.09 Mb
DisplayLeftColumn 7.586 ms 0.03 Mb
displayNav2 5.106 ms 0.05 Mb
displayMainMenu 4.601 ms 0.69 Mb
displayAfterTitle 3.301 ms 0.10 Mb
displayCategoryElementor 1.596 ms 0.08 Mb
ProductSearchProvider 1.059 ms - Mb
DisplayNav2 0.819 ms 0.02 Mb
DisplayBanner 0.664 ms 0.06 Mb
displayAfterBreadcrumb 0.621 ms 0.04 Mb
DisplayAfterBodyOpeningTag 0.395 ms 0.02 Mb
ModuleRoutes 0.111 ms 0.01 Mb
DisplayFooterAfter 0.111 ms - Mb
DisplayProductPriceBlock 0.099 ms 0.01 Mb
ActionOutputHTMLBefore 0.098 ms - Mb
ActionDispatcher 0.041 ms - Mb
DisplayPaCaptcha 0.041 ms - Mb
displayVerticalMenu 0.036 ms - Mb
ActionBuildFrontEndObject 0.012 ms - Mb
ActionProductSearchAfter 0.009 ms - Mb
DisplayOverrideTemplate 0.008 ms - Mb
ActionDispatcherBefore 0.005 ms - Mb
DisplayAfterTitleTag 0.003 ms - Mb
39 hook(s) 3405 ms 9.52 Mb
Module Time Memory Usage
ph_simpleblog 338.893 ms 1.87 Mb
gmerchantcenterpro 2675 ms 4.42 Mb
cookiesplus 71.959 ms 0.49 Mb
ets_cfultimate 303.931 ms 0.33 Mb
ets_awesomeurl 3.335 ms 0.14 Mb
iqitthemeeditor 2.324 ms 0.12 Mb
thecheckout 3.164 ms 0.10 Mb
ps_emailsubscription 58.728 ms 0.28 Mb
ps_emailalerts 0.462 ms 0.06 Mb
klarnapayment 756.478 ms 0.23 Mb
tbigrpayment 0.542 ms 0.03 Mb
revsliderprestashop 73.894 ms 0.06 Mb
iqitcontactpage 95.613 ms 0.10 Mb
iqitcountdown 0.745 ms 0.02 Mb
iqitsociallogin 16.344 ms 0.09 Mb
ps_shoppingcart 0.361 ms 0.02 Mb
cardlink_checkout 0.744 ms 0.05 Mb
paypal 6.710 ms 0.23 Mb
iqitwishlist 130.385 ms 0.33 Mb
iqitsizecharts 0.693 ms 0.04 Mb
iqitmegamenu 5.839 ms 0.77 Mb
iqitfreedeliverycount 0.487 ms 0.02 Mb
iqitextendedproduct 0.864 ms 0.05 Mb
iqitcompare 5.063 ms 0.07 Mb
iqitelementor 242.974 ms 0.17 Mb
ambjolisearch 172.416 ms 0.34 Mb
ets_advancedcaptcha 0.659 ms 0.03 Mb
simplercheckout 0.955 ms 0.03 Mb
codfee 4.557 ms 0.14 Mb
productlabelsandstickers 797.556 ms 5.12 Mb
skroutzdata 1.253 ms 0.04 Mb
xmlfeeds 1.244 ms 0.05 Mb
cdc_googletagmanager 310.617 ms 1.28 Mb
ps_facetedsearch 6.600 ms 0.05 Mb
djm_tracking 3.765 ms 0.12 Mb
ps_languageselector 1.838 ms 0.08 Mb
iqithtmlandbanners 88.612 ms 0.12 Mb
ps_customersignin 0.233 ms 0.02 Mb
ps_currencyselector 5.283 ms 0.07 Mb
iqitsearch 26.183 ms 0.08 Mb
iqitproductsnav 0.991 ms 0.06 Mb
ps_categorytree 116.876 ms 0.10 Mb
psgdpr 55.238 ms 0.15 Mb
iqitlinksmanager 5.519 ms 0.12 Mb
44 module(s) 6396 ms 18.06 Mb

Stopwatch SQL - 891 queries

# Query Time (ms) Rows Filesort Group By Location
603 
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps43s_manufacturer` m INNER JOIN ps43s_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps43s_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
 303.002 ms 541 Yes /classes/Manufacturer.php:211
391 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'THB') LIMIT 1
 272.663 ms 1 /classes/Currency.php:893
540 
SELECT SQL_NO_CACHE *
FROM `ps43s_currency` a0
LEFT JOIN `ps43s_currency_lang` `a1` ON (a0.`id_currency` = a1.`id_currency`)
WHERE (a0.`id_currency` = 1)
 254.597 ms 2 /classes/PrestaShopCollection.php:383
688 
SELECT SQL_NO_CACHE DISTINCT pl.name as name
FROM `ps43s_product_lang` pl
WHERE (pl.id_product = 2239) AND (pl.id_lang = 2 AND pl.id_shop = 1 ) LIMIT 1
 249.410 ms 1 /classes/Product.php:7711
667 
SELECT SQL_NO_CACHE c.id_elementor FROM ps43s_iqit_elementor_category c WHERE c.id_category = 1816 LIMIT 1
 239.291 ms 1 /modules/iqitelementor/src/IqitElementorCategory.php:87
353 
SELECT SQL_NO_CACHE *
FROM `ps43s_country_lang`
WHERE `id_country` = 209
 233.110 ms 2 /src/Adapter/EntityMapper.php:79
828 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps43s_product_attribute` pa
INNER JOIN ps43s_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps43s_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps43s_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps43s_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps43s_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps43s_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1450) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 191.866 ms 1 Yes /classes/Product.php:4511
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 `ps43s_configuration` c
LEFT JOIN `ps43s_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 182.240 ms 4910 /classes/Configuration.php:180
792 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps43s_product_attribute` pa
INNER JOIN ps43s_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps43s_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps43s_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps43s_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps43s_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps43s_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2239) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 175.641 ms 1 Yes /classes/Product.php:4511
571 
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "labsearch" LIMIT 1
 153.164 ms 0 /classes/module/Module.php:2636
756 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps43s_product_attribute` pa
INNER JOIN ps43s_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps43s_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps43s_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps43s_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps43s_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps43s_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2619) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 147.666 ms 1 Yes /classes/Product.php:4511
558 
SELECT SQL_NO_CACHE *
FROM `ps43s_currency` a0
LEFT JOIN `ps43s_currency_lang` `a1` ON (a0.`id_currency` = a1.`id_currency`)
WHERE (a0.`id_currency` = 1)
 124.676 ms 2 /classes/PrestaShopCollection.php:383
3 
SELECT SQL_NO_CACHE *
FROM `ps43s_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 121.500 ms 1 /src/Adapter/EntityMapper.php:71
516 
SELECT SQL_NO_CACHE `type`, `target` FROM `ps43s_ets_awu_redirect` WHERE `url` = 'hazer' AND active = 1 AND `id_shop`=1 LIMIT 1
 118.783 ms 4084 /modules/ets_awesomeurl/classes/EtsAwuRedirect.php:124
839 
SELECT SQL_NO_CACHE fsr.*
FROM `ps43s_fmm_stickers_rules` fsr
LEFT JOIN `ps43s_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`)
WHERE fsr.`status` = 1
AND fsr.`rule_type` = "new"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:09' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:09' <= fsr.`expiry_date`)
)
 109.246 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
711 
SELECT SQL_NO_CACHE c.id_contact FROM `ps43s_ets_cfu_contact` c
INNER JOIN `ps43s_ets_cfu_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps43s_ets_cfu_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 
AND c.hook LIKE "%displayTop%" 
AND cs.id_shop="1";
 98.722 ms 2 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:365
633 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps43s_product_shop`
WHERE `id_product` = 2239 AND id_shop=1 LIMIT 1
 96.079 ms 1 /classes/Product.php:6861
24 
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "pm_advancedpack" LIMIT 1
 85.047 ms 0 /classes/module/Module.php:2636
772 
SELECT SQL_NO_CACHE fsr.*
FROM `ps43s_fmm_stickers_rules` fsr
LEFT JOIN `ps43s_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`)
WHERE fsr.`status` = 1
AND fsr.`rule_type` = "price_less"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:08' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:08' <= fsr.`expiry_date`)
)
 72.960 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
555 
SELECT SQL_NO_CACHE * FROM ps43s_revslider_sliders
 71.233 ms 1 /modules/revsliderprestashop/includes/revslider_db.class.php:214
395 
SELECT SQL_NO_CACHE *
FROM `ps43s_country` a
LEFT JOIN `ps43s_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 44) LIMIT 1
 67.927 ms 1 /src/Adapter/EntityMapper.php:71
864 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps43s_product_attribute` pa
INNER JOIN ps43s_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps43s_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps43s_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps43s_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps43s_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps43s_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1451) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 67.669 ms 1 Yes /classes/Product.php:4511
592 
SELECT SQL_NO_CACHE c.id_contact FROM `ps43s_ets_cfu_contact` c
INNER JOIN `ps43s_ets_cfu_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps43s_ets_cfu_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 
AND c.hook LIKE "%header%" 
AND cs.id_shop="1";
 67.327 ms 2 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:365
618 
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 `ps43s_hook_module` hm
STRAIGHT_JOIN `ps43s_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps43s_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 61.443 ms 777 /classes/Hook.php:456
591 
SELECT SQL_NO_CACHE COUNT(id_contact)
FROM `ps43s_ets_cfu_contact`
WHERE (button_popup_enabled > 0) LIMIT 1
 61.254 ms 1 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:246
23 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps43s_module` m
LEFT JOIN `ps43s_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 56.477 ms 129 /classes/module/Module.php:345
546 
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 54.537 ms 0 /classes/module/Module.php:2636
70 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'XOF') LIMIT 1
 50.832 ms 1 /classes/Currency.php:893
871 
SELECT SQL_NO_CACHE psgdpr.active FROM `ps43s_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 22 LIMIT 1
 47.187 ms 9 /modules/psgdpr/classes/GDPRConsent.php:132
865 
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "ps_categorytree" LIMIT 1
 45.780 ms 1 /classes/module/Module.php:2636
867 
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps43s_category` c
INNER JOIN `ps43s_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
INNER JOIN `ps43s_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 8
AND nleft >= 647 AND nright <= 648
AND c.id_category IN (
SELECT id_category
FROM `ps43s_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
 42.937 ms 43 Yes /modules/ps_categorytree/ps_categorytree.php:166
16 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps43s_module` m
INNER JOIN ps43s_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 `ps43s_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps43s_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps43s_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`
 41.660 ms 3445 Yes Yes /classes/Hook.php:1233
439 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'JPY') LIMIT 1
 40.191 ms 1 /classes/Currency.php:893
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 ps43s_shop_group gs
LEFT JOIN ps43s_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps43s_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
 39.601 ms 1 Yes /classes/shop/Shop.php:715
619 
SELECT SQL_NO_CACHE tr.*
FROM `ps43s_tax_rule` tr
JOIN `ps43s_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 9
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 358)
AND ('15232' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '15232')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 39.590 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
480 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'GTQ') LIMIT 1
 37.648 ms 1 /classes/Currency.php:893
448 
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'RU' LIMIT 1
 36.620 ms 1 /classes/Country.php:194
360 
SELECT SQL_NO_CACHE *
FROM `ps43s_country_lang`
WHERE `id_country` = 30
 35.637 ms 2 /src/Adapter/EntityMapper.php:79
358 
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 30 LIMIT 1
 35.474 ms 1 /classes/Country.php:252
68 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'XAF') LIMIT 1
 34.826 ms 1 /classes/Currency.php:893
844 
SELECT SQL_NO_CACHE fsr.*
FROM `ps43s_fmm_stickers_rules` fsr
LEFT JOIN `ps43s_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`)
WHERE fsr.`status` = 1
AND fsr.`rule_type` = "price_less"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:09' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:09' <= fsr.`expiry_date`)
)
 33.971 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
604 
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, p.on_sale, p.date_add FROM ps43s_product p LEFT JOIN ps43s_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps43s_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps43s_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 ps43s_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps43s_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps43s_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps43s_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps43s_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 cp.id_category='1816' GROUP BY p.id_product) p GROUP BY p.id_manufacturer
 33.324 ms 8 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
542 
SELECT SQL_NO_CACHE 1 FROM `ps43s_cart_rule` WHERE ((date_to >= "2024-10-09 00:00:00" AND date_to <= "2024-10-09 23:59:59") OR (date_from >= "2024-10-09 00:00:00" AND date_from <= "2024-10-09 23:59:59") OR (date_from < "2024-10-09 00:00:00" AND date_to > "2024-10-09 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
 31.258 ms 4 /classes/CartRule.php:357
628 
SELECT SQL_NO_CACHE tr.*
FROM `ps43s_tax_rule` tr
JOIN `ps43s_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 9
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
 28.820 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
655 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps43s_feature_product pf
LEFT JOIN ps43s_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps43s_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps43s_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps43s_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1451
ORDER BY f.position ASC
 27.957 ms 1 Yes /classes/Product.php:6006
14 
SELECT SQL_NO_CACHE id_shop
FROM `ps43s_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
 27.730 ms 1 /classes/ObjectModel.php:1729
605 
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps43s_product p INNER JOIN ps43s_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 = 9) INNER JOIN ps43s_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps43s_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps43s_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps43s_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 cp.id_category='1816'
 27.182 ms 4 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
357 
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'ZA' LIMIT 1
 27.046 ms 1 /classes/Country.php:194
457 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'GEL') LIMIT 1
 26.638 ms 1 /classes/Currency.php:893
626 
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 `ps43s_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2619 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps43s_cart_product` cp JOIN `ps43s_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps43s_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` = 2619 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 26.131 ms 0 /classes/Cart.php:1410
394 
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 44 LIMIT 1
 26.026 ms 1 /classes/Country.php:252
646 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps43s_feature_product pf
LEFT JOIN ps43s_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps43s_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps43s_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps43s_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1450
ORDER BY f.position ASC
 25.662 ms 1 Yes /classes/Product.php:6006
452 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'RUB') LIMIT 1
 25.486 ms 1 /classes/Currency.php:893
886 
SELECT SQL_NO_CACHE *
FROM ps43s_cookiesplus_finality cf LEFT JOIN ps43s_cookiesplus_finality_lang cfl on cf.`id_cookiesplus_finality` = cfl.`id_cookiesplus_finality`
WHERE
cfl.`id_lang` = 2 AND cf.`active` = 1 AND cf.`id_shop` = 1
ORDER BY `position`;
 25.233 ms 4 Yes /modules/cookiesplus/classes/CookiesPlusFinality.php:96
25 
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'GR' LIMIT 1
 24.657 ms 1 /classes/Country.php:194
554 
SELECT SQL_NO_CACHE *
FROM `ps43s_category` a0
LEFT JOIN `ps43s_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 647) AND (a0.`nright` > 648) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 24.546 ms 46 Yes /classes/PrestaShopCollection.php:383
422 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'CLP') LIMIT 1
 24.373 ms 1 /classes/Currency.php:893
15 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps43s_hook` h
WHERE (h.active = 1)
 23.485 ms 1068 /classes/Hook.php:1332
450 
SELECT SQL_NO_CACHE *
FROM `ps43s_country` a
LEFT JOIN `ps43s_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 175) LIMIT 1
 23.447 ms 1 /src/Adapter/EntityMapper.php:71
271 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'RP') LIMIT 1
 23.036 ms 1 /classes/Currency.php:893
753 
SELECT SQL_NO_CACHE fsr.*
FROM `ps43s_fmm_stickers_rules` fsr
LEFT JOIN `ps43s_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`)
WHERE fsr.`status` = 1
AND fsr.`rule_type` = "customer"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:08' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:08' <= fsr.`expiry_date`)
)
 22.579 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
6 
SELECT SQL_NO_CACHE *
FROM `ps43s_country` a
LEFT JOIN `ps43s_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps43s_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 9) LIMIT 1
 22.479 ms 1 /src/Adapter/EntityMapper.php:71
418 
SELECT SQL_NO_CACHE *
FROM `ps43s_country` a
LEFT JOIN `ps43s_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 68) LIMIT 1
 22.322 ms 1 /src/Adapter/EntityMapper.php:71
80 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'JOD') LIMIT 1
 22.215 ms 1 /classes/Currency.php:893
26 
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 9 LIMIT 1
 21.874 ms 1 /classes/Country.php:252
120 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'PEN') LIMIT 1
 21.836 ms 1 /classes/Currency.php:893
8 
SELECT SQL_NO_CACHE *
FROM `ps43s_lang` a
LEFT JOIN `ps43s_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 21.278 ms 1 /src/Adapter/EntityMapper.php:71
845 
SELECT SQL_NO_CACHE fsr.*
FROM `ps43s_fmm_stickers_rules` fsr
LEFT JOIN `ps43s_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`)
WHERE fsr.`status` = 1
AND fsr.`rule_type` = "price_greater"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:09' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:08:09' <= fsr.`expiry_date`)
)
 20.711 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
43 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'KES') LIMIT 1
 20.554 ms 1 /classes/Currency.php:893
689 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps43s_product_attribute pa
INNER JOIN ps43s_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 = 2239 LIMIT 1
 20.534 ms 1 /classes/Product.php:1110
91 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'MGA') LIMIT 1
 20.363 ms 1 /classes/Currency.php:893
757 
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps43s_category_product` cp
LEFT JOIN `ps43s_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps43s_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps43s_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 2239
AND cl.`id_lang` = 2
 20.227 ms 1 /classes/Product.php:3463
537 
SELECT SQL_NO_CACHE state FROM ps43s_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 20.155 ms 1 /classes/FeatureFlag.php:105
878 
SELECT SQL_NO_CACHE c.id_contact 
FROM `ps43s_ets_cfu_contact` c
INNER JOIN `ps43s_ets_cfu_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps43s_ets_cfu_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 
AND c.button_popup_enabled = 1 
AND cs.id_shop="1"
 20.017 ms 2 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:382
442 
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 14 LIMIT 1
 20.015 ms 1 /classes/Country.php:252
485 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'KAS') LIMIT 1
 19.911 ms 1 /classes/Currency.php:893
812 
SELECT SQL_NO_CACHE `title`
FROM `ps43s_fmm_stickers_lang`
WHERE `sticker_id` = 3 AND `id_lang` = 2 LIMIT 1
 19.902 ms 1 /modules/productlabelsandstickers/models/Stickers.php:293
432 
SELECT SQL_NO_CACHE *
FROM `ps43s_country` a
LEFT JOIN `ps43s_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 10) LIMIT 1
 19.835 ms 1 /src/Adapter/EntityMapper.php:71
879 
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "iqitwishlist" LIMIT 1
 19.694 ms 1 /classes/module/Module.php:2636
606 
REPLACE INTO ps43s_layered_filter_block (hash, data) VALUES ("9a73e78c9d2796d32b2d276c4c6c8a2a", "a:1:{s:7:\"filters\";a:2:{i:0;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:1:{i:86;a:2:{s:4:\"name\";s:11:\"American DJ\";s:3:\"nbr\";i:4;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;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:888;s:3:\"min\";d:241;s:4:\"unit\";s:3:\"€\";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:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";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:4;s:5:\"value\";N;}}}")
 19.685 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
651 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps43s_product_shop`
WHERE `id_product` = 1451 AND id_shop=1 LIMIT 1
 19.622 ms 1 /classes/Product.php:6861
441 
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'PL' LIMIT 1
 19.499 ms 1 /classes/Country.php:194
83 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'KZT') LIMIT 1
 19.432 ms 1 /classes/Currency.php:893
71 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'XOF') LIMIT 1
 19.386 ms 1 /classes/Currency.php:893
830 
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps43s_product` p
INNER JOIN ps43s_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 1451
AND DATEDIFF("2024-10-09 00:00:00", product_shop.`date_add`) < 0 LIMIT 1
 19.314 ms 0 /classes/Product.php:1736
832 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps43s_stock_available`
WHERE (id_product = 1451) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 19.313 ms 1 /classes/stock/StockAvailable.php:778
653 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps43s_stock_available`
WHERE (id_product = 1451) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 19.277 ms 1 /classes/stock/StockAvailable.php:453
763 
SELECT SQL_NO_CACHE `id_category` FROM `ps43s_category_product`
WHERE `id_product` = 2239
 19.210 ms 1 /classes/Product.php:3427
515 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps43s_meta` m
LEFT JOIN `ps43s_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 19.208 ms 152 Yes /classes/Dispatcher.php:654
649 
SELECT SQL_NO_CACHE 1 FROM `ps43s_specific_price` WHERE id_product = 1451 LIMIT 1
 19.038 ms 1 /classes/SpecificPrice.php:435
877 
SELECT SQL_NO_CACHE c.id_contact FROM `ps43s_ets_cfu_contact` c
INNER JOIN `ps43s_ets_cfu_contact_shop` cs ON (c.id_contact= cs.id_contact)
LEFT JOIN `ps43s_ets_cfu_contact_lang` cl on (c.id_contact= cl.id_contact AND cl.id_lang="2")
WHERE c.active=1 
AND c.hook LIKE "%footer_page%" 
AND cs.id_shop="1";
 18.726 ms 2 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:365