List of products by brand AlphaTheta

1245
AlphaTheta Less
Free shipping
Alphatheta WAVE-EIGHT Active Loudspeaker Alphatheta WAVE-EIGHT Active Loudspeaker 2
search
In Stock|check
Free shipping
AlphaTheta Omnis-Duo Portable Battery-Powered DJ controller,alphatheta AlphaTheta Omnis-Duo Portable Battery-Powered DJ controller,alphatheta 2
search
In Stock|check
Free shipping
Alpha Theta Euphonia Professional Rotary Mixer Alpha Theta Euphonia Professional Rotary Mixer 2
search
Available|check
Showing 1-3 of 3 item(s)
Product added to wishlist
Product added to compare.
Cookie consent
Load Time 3256 ms
Querying Time 2767 ms
Queries 805
Memory Peak Usage 26.1 Mb
Included Files 1191 files - 14.76 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 1080 ms 1080 ms 11.02 Mb 11.0 Mb
__construct 0.031 ms 1080 ms - Mb 11.0 Mb
init 171.548 ms 1252 ms 1.12 Mb 12.4 Mb
checkAccess 0.002 ms 1252 ms - Mb 12.4 Mb
setMedia 39.596 ms 1291 ms 0.34 Mb 12.5 Mb
postProcess 0.002 ms 1291 ms - Mb 12.5 Mb
initHeader 0.002 ms 1291 ms - Mb 12.5 Mb
initContent 781.096 ms 2072 ms 4.30 Mb 16.9 Mb
initFooter 0.005 ms 2072 ms - Mb 16.9 Mb
display 1184 ms 3256 ms 8.82 Mb 26.1 Mb
Hook Time Memory Usage
DisplayProductPageCss 566.745 ms 4.06 Mb
DisplayHeader 238.320 ms 0.47 Mb
displayAfterBreadcrumb 133.461 ms 0.04 Mb
DisplayBanner 81.331 ms - Mb
displayFooter 74.535 ms 0.39 Mb
displayNav1 61.671 ms 0.15 Mb
ActionFrontControllerSetMedia 37.140 ms 0.06 Mb
displayBeforeBodyClosingTag 32.888 ms 0.28 Mb
DisplayFooter 22.303 ms 0.05 Mb
displayManufacturerElementor 15.502 ms 0.08 Mb
Header 14.523 ms 0.15 Mb
DisplayGDPRConsent 11.882 ms 0.12 Mb
DisplayBeforeBodyClosingTag 7.006 ms 0.34 Mb
displayMainMenu 4.788 ms 0.69 Mb
displayAfterTitle 3.257 ms 0.10 Mb
renderWidget 2.600 ms 0.06 Mb
ProductSearchProvider 1.575 ms - Mb
displayCustomerLoginFormAfter 1.563 ms 0.07 Mb
DisplayAfterTitle 1.014 ms 0.02 Mb
displayNav2 0.930 ms 0.04 Mb
DisplayNav2 0.726 ms 0.02 Mb
DisplayTop 0.694 ms 0.03 Mb
DisplayAfterBodyOpeningTag 0.650 ms 0.02 Mb
DisplayCustomerLoginFormAfter 0.575 ms 0.03 Mb
ModuleRoutes 0.123 ms 0.01 Mb
DisplayFooterAfter 0.104 ms - Mb
ActionOutputHTMLBefore 0.096 ms - Mb
DisplayProductPriceBlock 0.095 ms 0.01 Mb
DisplayPaCaptcha 0.036 ms - Mb
ActionDispatcher 0.022 ms - Mb
ActionBuildFrontEndObject 0.010 ms - Mb
ActionProductSearchAfter 0.010 ms - Mb
DisplayOverrideTemplate 0.009 ms - Mb
ActionDispatcherBefore 0.007 ms - Mb
DisplayAfterTitleTag 0.004 ms - Mb
35 hook(s) 1316 ms 7.28 Mb
Module Time Memory Usage
ph_simpleblog 26.566 ms 1.93 Mb
gmerchantcenterpro 955 ms 4.42 Mb
cookiesplus 10.875 ms 0.49 Mb
ets_cfultimate 101.614 ms 0.31 Mb
ets_awesomeurl 30.288 ms 0.14 Mb
iqitthemeeditor 4.200 ms 0.12 Mb
thecheckout 25.707 ms 0.10 Mb
ps_emailsubscription 40.032 ms 0.28 Mb
ps_emailalerts 0.424 ms 0.12 Mb
klarnapayment 198.342 ms 0.16 Mb
tbigrpayment 0.382 ms 0.03 Mb
revsliderprestashop 3.845 ms 0.06 Mb
iqitcontactpage 29.560 ms 0.10 Mb
iqitcountdown 0.492 ms 0.02 Mb
iqitsociallogin 1.951 ms 0.09 Mb
ps_shoppingcart 0.235 ms 0.02 Mb
cardlink_checkout 0.431 ms 0.05 Mb
paypal 11.262 ms 0.23 Mb
iqitwishlist 32.107 ms 0.27 Mb
iqitsizecharts 0.528 ms 0.04 Mb
iqitmegamenu 5.467 ms 0.71 Mb
iqitfreedeliverycount 0.289 ms 0.02 Mb
iqitextendedproduct 0.600 ms 0.11 Mb
iqitcompare 1.768 ms 0.07 Mb
iqitelementor 16.553 ms 0.15 Mb
ambjolisearch 51.352 ms 0.34 Mb
ets_advancedcaptcha 0.590 ms 0.03 Mb
simplercheckout 0.789 ms 0.03 Mb
codfee 11.243 ms 0.08 Mb
productlabelsandstickers 567.828 ms 4.19 Mb
skroutzdata 0.899 ms 0.04 Mb
xmlfeeds 1.318 ms 0.05 Mb
cdc_googletagmanager 3.163 ms 0.18 Mb
ps_facetedsearch 3.328 ms 0.04 Mb
djm_tracking 3.668 ms 0.12 Mb
ps_languageselector 18.441 ms 0.08 Mb
iqithtmlandbanners 44.123 ms 0.12 Mb
ps_customersignin 0.286 ms 0.02 Mb
ps_currencyselector 1.175 ms 0.12 Mb
iqitsearch 3.001 ms 0.08 Mb
iqitproductsnav 133.940 ms 0.06 Mb
psgdpr 12.422 ms 0.15 Mb
iqitlinksmanager 6.442 ms 0.12 Mb
43 module(s) 2363 ms 15.86 Mb

Stopwatch SQL - 805 queries

# Query Time (ms) Rows Filesort Group By Location
751
SELECT SQL_NO_CACHE location
FROM `ps43s_stock_available`
WHERE (id_product = 5590) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
190.774 ms 1 /classes/stock/StockAvailable.php:806
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`)
165.895 ms 4910 /classes/Configuration.php:180
608
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
139.721 ms 777 /classes/Hook.php:456
665
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "iqitproductsnav" LIMIT 1
131.759 ms 1 /classes/module/Module.php:2636
21
SELECT SQL_NO_CACHE name, alias FROM `ps43s_hook_alias`
90.529 ms 88 /classes/Hook.php:339
527
SELECT SQL_NO_CACHE * FROM `ps43s_currency` c ORDER BY `iso_code` ASC
88.440 ms 1 Yes /classes/Currency.php:709
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
74.973 ms 1 Yes /classes/shop/Shop.php:715
17
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps43s_hook_alias`
54.658 ms 88 /classes/Hook.php:287
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`
51.609 ms 3445 Yes Yes /classes/Hook.php:1233
587
SELECT SQL_NO_CACHE COUNT(id_contact)
FROM `ps43s_ets_cfu_contact`
WHERE (button_popup_enabled > 0) LIMIT 1
43.003 ms 1 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:246
103
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'MMK') LIMIT 1
39.380 ms 1 /classes/Currency.php:893
654
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "iqithtmlandbanners" LIMIT 1
38.023 ms 1 /classes/module/Module.php:2636
537
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)
33.039 ms 2 /classes/PrestaShopCollection.php:383
641
SELECT SQL_NO_CACHE *
FROM `ps43s_product` a
LEFT JOIN `ps43s_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps43s_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5415) AND (b.`id_shop` = 1) LIMIT 1
32.323 ms 1 /src/Adapter/EntityMapper.php:71
554
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)
28.312 ms 2 /classes/PrestaShopCollection.php:383
588
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";
28.282 ms 2 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:365
763
SELECT SQL_NO_CACHE `excluded_p`
FROM `ps43s_fmm_stickers_rules`
WHERE `fmm_stickers_rules_id` = 2 LIMIT 1
27.435 ms 1 /modules/productlabelsandstickers/models/Rules.php:80
552
SELECT SQL_NO_CACHE * 
FROM `ps43s_ets_awu_manufacturer` 
WHERE id_manufacturer = 560 AND id_shop = 1 AND id_lang = 2 LIMIT 1
27.238 ms 0 /modules/ets_awesomeurl/classes/EtsAwuManufacturer.php:208
793
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "iqitwishlist" LIMIT 1
24.795 ms 1 /classes/module/Module.php:2636
169
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'ETB') LIMIT 1
24.158 ms 1 /classes/Currency.php:893
523
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "xps_checkout" LIMIT 1
23.464 ms 0 /classes/module/Module.php:2636
464
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` = 186) LIMIT 1
23.377 ms 1 /src/Adapter/EntityMapper.php:71
609
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
23.068 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
791
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";
20.400 ms 2 /modules/ets_cfultimate/classes/ETS_CFU_Contact.php:365
74
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'ETB') LIMIT 1
18.927 ms 1 /classes/Currency.php:893
262
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` = 135) LIMIT 1
18.919 ms 1 /src/Adapter/EntityMapper.php:71
782
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 (5590) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
17.812 ms 1 Yes /classes/Product.php:4511
476
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 6 LIMIT 1
17.422 ms 1 /classes/Country.php:252
310
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 25 LIMIT 1
17.313 ms 1 /classes/Country.php:252
348
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` = 13) LIMIT 1
15.953 ms 1 /src/Adapter/EntityMapper.php:71
309
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'SG' LIMIT 1
15.898 ms 1 /classes/Country.php:194
652
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "ps_languageselector" LIMIT 1
15.450 ms 1 /classes/module/Module.php:2636
783
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
14.964 ms 1 /classes/module/Module.php:2636
790
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module_shop` WHERE `id_module` = 67 AND `id_shop` = 1 LIMIT 1
14.903 ms 1 /classes/module/Module.php:2109
166
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'XOF') LIMIT 1
14.260 ms 1 /classes/Currency.php:893
384
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'VND') LIMIT 1
14.153 ms 1 /classes/Currency.php:893
645
SELECT SQL_NO_CACHE *
FROM `ps43s_product` a
LEFT JOIN `ps43s_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps43s_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5281) AND (b.`id_shop` = 1) LIMIT 1
14.059 ms 1 /src/Adapter/EntityMapper.php:71
555
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "ps_searchbar" LIMIT 1
14.035 ms 1 /classes/module/Module.php:2636
150
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'NGN') LIMIT 1
13.568 ms 1 /classes/Currency.php:893
538
SELECT SQL_NO_CACHE 1 FROM ps43s_cart_product cp INNER JOIN ps43s_product p
ON (p.id_product = cp.id_product) INNER JOIN ps43s_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
13.542 ms 1 /classes/Cart.php:4192
62
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'BYN') LIMIT 1
12.997 ms 1 /classes/Currency.php:893
300
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'NZD') LIMIT 1
12.765 ms 1 /classes/Currency.php:893
260
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'MY' LIMIT 1
12.315 ms 1 /classes/Country.php:194
286
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'HKD') LIMIT 1
12.044 ms 1 /classes/Currency.php:893
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps43s_shop_url su
LEFT JOIN ps43s_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'djmania.gr' OR su.domain_ssl = 'djmania.gr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
11.934 ms 1 Yes /classes/shop/Shop.php:1364
217
SELECT SQL_NO_CACHE *
FROM `ps43s_country_lang`
WHERE `id_country` = 24
11.494 ms 2 /src/Adapter/EntityMapper.php:79
331
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'DZD') LIMIT 1
11.072 ms 1 /classes/Currency.php:893
51
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'PAB') LIMIT 1
11.032 ms 1 /classes/Currency.php:893
736
SELECT SQL_NO_CACHE `excluded_p`
FROM `ps43s_fmm_stickers_rules`
WHERE `fmm_stickers_rules_id` = 3 LIMIT 1
10.924 ms 1 /modules/productlabelsandstickers/models/Rules.php:80
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps43s_lang` l
LEFT JOIN `ps43s_lang_shop` ls ON (l.id_lang = ls.id_lang)
10.871 ms 2 /classes/Language.php:1080
439
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'JPY') LIMIT 1
10.844 ms 1 /classes/Currency.php:893
377
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'ILS') LIMIT 1
10.800 ms 1 /classes/Currency.php:893
771
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` = "p_feature"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:30' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:30' <= fsr.`expiry_date`)
)
10.783 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
767
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` = "category"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:30' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:30' <= fsr.`expiry_date`)
)
10.777 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
274
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'SE' LIMIT 1
10.744 ms 1 /classes/Country.php:194
116
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'PYG') LIMIT 1
10.726 ms 1 /classes/Currency.php:893
24
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "pm_advancedpack" LIMIT 1
10.695 ms 0 /classes/module/Module.php:2636
784
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
10.635 ms 1 /classes/module/Module.php:2109
789
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "iqitcontactpage" LIMIT 1
10.606 ms 1 /classes/module/Module.php:2636
54
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'PKR') LIMIT 1
10.597 ms 1 /classes/Currency.php:893
347
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 13 LIMIT 1
10.538 ms 1 /classes/Country.php:252
392
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'KO' LIMIT 1
10.436 ms 1 /classes/Country.php:194
381
SELECT SQL_NO_CACHE *
FROM `ps43s_country_lang`
WHERE `id_country` = 220
10.378 ms 2 /src/Adapter/EntityMapper.php:79
427
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'COP') LIMIT 1
10.369 ms 1 /classes/Currency.php:893
328
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'AED') LIMIT 1
10.217 ms 1 /classes/Currency.php:893
785
SELECT SQL_NO_CACHE psgdpr.active FROM `ps43s_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 22 LIMIT 1
10.177 ms 9 /modules/psgdpr/classes/GDPRConsent.php:132
156
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'DZD') LIMIT 1
9.213 ms 1 /classes/Currency.php:893
648
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps43s_image` i
INNER JOIN ps43s_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps43s_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 5590
ORDER BY `position`
9.211 ms 5 Yes /classes/Product.php:3549
460
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` = 15) LIMIT 1
9.096 ms 1 /src/Adapter/EntityMapper.php:71
516
SELECT SQL_NO_CACHE `type`, `target` FROM `ps43s_ets_awu_redirect` WHERE `url` = 'brands/alphatheta' AND active = 1 AND `id_shop`=1 LIMIT 1
8.275 ms 4084 /modules/ets_awesomeurl/classes/EtsAwuRedirect.php:124
607
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps43s_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps43s_hook_alias` ha
INNER JOIN `ps43s_hook` h ON ha.name = h.name
7.711 ms 0 /classes/Hook.php:1292
590
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "bestkit_opc" LIMIT 1
7.670 ms 0 /classes/module/Module.php:2636
617
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 = 5415
ORDER BY f.position ASC
7.665 ms 11 Yes /classes/Product.php:6006
553
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` = 2
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
7.444 ms 1 /src/Adapter/EntityMapper.php:71
745
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 (5281) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
7.154 ms 1 Yes /classes/Product.php:4511
667
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "iqitelementor" LIMIT 1
7.108 ms 1 /classes/module/Module.php:2636
25
SELECT SQL_NO_CACHE `id_country`
FROM `ps43s_country`
WHERE `iso_code` = 'GR' LIMIT 1
6.999 ms 1 /classes/Country.php:194
517
SELECT SQL_NO_CACHE `type`, `target` FROM `ps43s_ets_awu_redirect` WHERE `url` = 'en/brands/alphatheta' AND active = 1 AND `id_shop`=1 LIMIT 1
6.995 ms 4084 /modules/ets_awesomeurl/classes/EtsAwuRedirect.php:124
669
SELECT SQL_NO_CACHE c.id_elementor FROM ps43s_iqit_elementor_content c LEFT JOIN ps43s_iqit_elementor_content_shop s ON c.id_elementor = s.id_elementor WHERE c.id_object = 560 AND c.hook = 774 AND s.id_shop = 1 LIMIT 1
6.842 ms 1 /modules/iqitelementor/src/IqitElementorContent.php:145
79
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'JOD') LIMIT 1
6.833 ms 1 /classes/Currency.php:893
638
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps43s_stock_available`
WHERE (id_product = 5590) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.445 ms 1 /classes/stock/StockAvailable.php:453
589
SELECT SQL_NO_CACHE `name`
FROM `ps43s_hook`
WHERE `id_hook` = 769 LIMIT 1
6.222 ms 1 /classes/Hook.php:244
447
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'PLN') LIMIT 1
6.203 ms 1 /classes/Currency.php:893
615
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps43s_stock_available`
WHERE (id_product = 5415) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.926 ms 1 /classes/stock/StockAvailable.php:453
45
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'KES') LIMIT 1
5.676 ms 1 /classes/Currency.php:893
634
SELECT SQL_NO_CACHE 1 FROM `ps43s_specific_price` WHERE id_product = 5590 LIMIT 1
5.163 ms 1 /classes/SpecificPrice.php:435
740
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` = "supplier"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:29' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:29' <= fsr.`expiry_date`)
)
5.024 ms 4 /modules/productlabelsandstickers/models/Rules.php:128
218
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'AUD') LIMIT 1
4.975 ms 1 /classes/Currency.php:893
80
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'JOD') LIMIT 1
4.965 ms 1 /classes/Currency.php:893
264
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'MYR') LIMIT 1
4.924 ms 1 /classes/Currency.php:893
321
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'TWD') LIMIT 1
4.913 ms 1 /classes/Currency.php:893
83
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'KZT') LIMIT 1
4.783 ms 1 /classes/Currency.php:893
644
SELECT SQL_NO_CACHE state FROM ps43s_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
4.691 ms 1 /classes/FeatureFlag.php:105
66
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'KHR') LIMIT 1
4.657 ms 1 /classes/Currency.php:893
330
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'DZD') LIMIT 1
4.636 ms 1 /classes/Currency.php:893
787
SELECT SQL_NO_CACHE `id_module` FROM `ps43s_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
4.473 ms 1 /classes/module/Module.php:2636
123
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'RON') LIMIT 1
4.406 ms 1 /classes/Currency.php:893
84
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'KZT') LIMIT 1
4.285 ms 1 /classes/Currency.php:893
452
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'RUB') LIMIT 1
4.206 ms 1 /classes/Currency.php:893
135
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'UZS') LIMIT 1
4.126 ms 1 /classes/Currency.php:893
157
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'DZD') LIMIT 1
4.082 ms 1 /classes/Currency.php:893
255
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` = 23) LIMIT 1
4.081 ms 1 /src/Adapter/EntityMapper.php:71
626
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps43s_stock_available`
WHERE (id_product = 5281) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.018 ms 1 /classes/stock/StockAvailable.php:453
78
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'GHS') LIMIT 1
4.011 ms 1 /classes/Currency.php:893
245
SELECT SQL_NO_CACHE *
FROM `ps43s_country_lang`
WHERE `id_country` = 3
3.976 ms 2 /src/Adapter/EntityMapper.php:79
311
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` = 25) LIMIT 1
3.944 ms 1 /src/Adapter/EntityMapper.php:71
612
SELECT SQL_NO_CACHE `reduction`
FROM `ps43s_product_group_reduction_cache`
WHERE `id_product` = 5415 AND `id_group` = 1 LIMIT 1
3.927 ms 0 /classes/GroupReduction.php:156
184
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'MAD') LIMIT 1
3.855 ms 1 /classes/Currency.php:893
196
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'PYG') LIMIT 1
3.847 ms 1 /classes/Currency.php:893
132
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'UYU') LIMIT 1
3.806 ms 1 /classes/Currency.php:893
127
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'LKR') LIMIT 1
3.689 ms 1 /classes/Currency.php:893
386
SELECT SQL_NO_CACHE `name`
FROM `ps43s_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 204 LIMIT 1
3.681 ms 1 /classes/Country.php:252
122
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'RON') LIMIT 1
3.646 ms 1 /classes/Currency.php:893
633
SELECT SQL_NO_CACHE *
FROM `ps43s_product` a
LEFT JOIN `ps43s_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps43s_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5590) AND (b.`id_shop` = 1) LIMIT 1
3.639 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
3.554 ms 1 /classes/Currency.php:893
433
SELECT SQL_NO_CACHE *
FROM `ps43s_country_lang`
WHERE `id_country` = 10
3.479 ms 2 /src/Adapter/EntityMapper.php:79
629
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 = 5590 LIMIT 1
3.464 ms 1 /classes/Product.php:1110
197
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'PYG') LIMIT 1
3.433 ms 1 /classes/Currency.php:893
81
SELECT SQL_NO_CACHE c.id_currency
FROM `ps43s_currency` c
WHERE (deleted = 0) AND (iso_code = 'JOD') LIMIT 1
3.425 ms 1 /classes/Currency.php:893
781
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` = "stock_l"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:30' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-10-09 20:04:30' <= fsr.`expiry_date`)
)
3.397 ms 4 /modules/productlabelsandstickers/models/Rules.php:128