105 articles

<< 1 ... 4 5 6 7 8 >>
<< 1 ... 4 5 6 7 8 >>

Search on blog

ENVÍO GRATUITO

Gratis a partir de 45€ (excepto Baleares) y recogida en tienda

DEVOLUCIONES

Dispones de 30 días para devolver tu compra

PAGO SEGURO

Tarjeta bancaria, trasferencia, Paypal y contra reembolso

ATENCIÓN AL CLIENTE

Tfno: 987 802 608. Whatsapp: 690 652 934 Lunes a viernes de 9:00-13:30 y 16:00-19:00

Product added to wishlist
Load Time 474.719 ms
Querying Time 385 ms
Queries 227
Memory Peak Usage 16.6 Mb
Included Files 1288 files - 15.81 Mb
PrestaShop Cache - Mb
Global vars 0.80 Mb
PrestaShop Version 8.2.0
PHP Version 8.1.28
MySQL Version 5.7.44
Memory Limit 256M
Max Execution Time 30s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 9.526 ms 9.526 ms 5.60 Mb 5.7 Mb
__construct 0.014 ms 9.540 ms - Mb 5.7 Mb
init 186.331 ms 195.871 ms 1.17 Mb 6.8 Mb
checkAccess 0.002 ms 195.873 ms - Mb 6.8 Mb
setMedia 40.969 ms 236.842 ms 1.49 Mb 8.7 Mb
postProcess 0.002 ms 236.844 ms - Mb 8.7 Mb
initHeader 0.002 ms 236.846 ms - Mb 8.7 Mb
initContent 46.020 ms 282.866 ms 2.83 Mb 11.1 Mb
initFooter 0.002 ms 282.868 ms - Mb 11.1 Mb
display 191.851 ms 474.719 ms 4.51 Mb 16.6 Mb
Hook Time Memory Usage
DisplayBeforeBodyClosingTag 81.289 ms 0.94 Mb
DisplayLeftColumn 54.107 ms 0.84 Mb
ActionFrontControllerSetMedia 39.430 ms 1.32 Mb
displayLeftColumn 22.341 ms 0.80 Mb
DisplayHeader 15.231 ms 0.77 Mb
displayNav2 2.741 ms 0.16 Mb
ActionObjectAddAfter 2.385 ms 0.11 Mb
displayBeforeBodyClosingTag 2.347 ms 0.16 Mb
DisplayFooter 2.030 ms 0.12 Mb
displayFooter 1.811 ms 0.12 Mb
displayNav1 1.461 ms 0.14 Mb
DisplayTop 1.400 ms 0.08 Mb
ModuleRoutes 1.367 ms 0.06 Mb
displayMainMenu 0.989 ms 0.23 Mb
DisplayNav1 0.921 ms 0.05 Mb
renderWidget 0.874 ms 0.04 Mb
displayCustomerLoginFormAfter 0.868 ms 0.06 Mb
displayWrapperBottomInContainer 0.843 ms 0.05 Mb
Header 0.804 ms 0.04 Mb
ActionDispatcher 0.609 ms - Mb
DisplayBanner 0.572 ms 0.02 Mb
DisplayNav2 0.536 ms 0.02 Mb
DisplayTrustbadge 0.516 ms 0.02 Mb
DisplayWrapperBottom 0.509 ms 0.02 Mb
displayTop 0.202 ms - Mb
DisplayPaCaptcha 0.186 ms 0.01 Mb
OverrideLayoutTemplate 0.020 ms - Mb
DisplaySlider 0.015 ms - Mb
ActionDispatcherBefore 0.010 ms - Mb
displayVerticalMenu 0.007 ms - Mb
ActionFrontControllerAfterInit 0.006 ms - Mb
DisplayNavFullWidth 0.005 ms - Mb
ActionFrontControllerInitAfter 0.003 ms - Mb
33 hook(s) 236.435 ms 6.21 Mb
Module Time Memory Usage
klaviyopsautomation 2.363 ms - Mb
lgseoredirect 3.387 ms 0.09 Mb
prestablog 55.589 ms 1.23 Mb
storelocator 5.137 ms 0.58 Mb
ets_delete_order 0.833 ms 0.04 Mb
iqitthemeeditor 1.010 ms 0.24 Mb
trustedshopseasyintegration 2.705 ms - Mb
quantitydiscountpro 3.604 ms 0.19 Mb
motive 39.727 ms 1.34 Mb
ps_emailsubscription 0.982 ms 0.08 Mb
ps_emailalerts 0.177 ms 0.04 Mb
monei 0.194 ms 0.07 Mb
revsliderprestashop 3.166 ms 0.41 Mb
ps_shoppingcart 0.136 ms 0.02 Mb
psxmarketingwithgoogle 0.422 ms 0.03 Mb
ps_googleanalytics 0.495 ms 0.05 Mb
iqitcontactpage 0.929 ms 0.07 Mb
iqitelementor 1.196 ms 0.18 Mb
iqitfreedeliverycount 0.106 ms 0.02 Mb
iqitmegamenu 1.248 ms 0.29 Mb
iqitsizecharts 0.171 ms 0.04 Mb
iqitwishlist 3.210 ms 0.23 Mb
iqitextendedproduct 0.186 ms 0.05 Mb
iqitsociallogin 1.000 ms 0.08 Mb
whatsappchat 13.160 ms 0.57 Mb
advancedpopupcreator 2.816 ms 0.28 Mb
seosaproductlabels 0.317 ms 0.05 Mb
rcpgtagmanager 2.409 ms 0.20 Mb
sameprice 9.544 ms 0.06 Mb
codfee 1.901 ms 0.06 Mb
linkobfuscator 0.224 ms 0.01 Mb
ets_recaptcha_free 0.375 ms 0.04 Mb
probance_track 0.218 ms 0.02 Mb
probance_pnotif 0.133 ms 0.08 Mb
fspickupatstore 1.090 ms 0.26 Mb
paypal 2.717 ms 0.23 Mb
mdsmartpickup 0.212 ms 0.02 Mb
probance_coupons 0.330 ms 0.07 Mb
iqitlinksmanager 1.935 ms 0.15 Mb
ps_languageselector 0.966 ms 0.06 Mb
ps_currencyselector 0.594 ms 0.06 Mb
iqitsearch 1.139 ms 0.06 Mb
ps_customersignin 0.103 ms 0.02 Mb
pagesnotfound 0.099 ms 0.02 Mb
ps_categorytree 22.439 ms 0.82 Mb
ps_facetedsearch 0.513 ms 0.04 Mb
statsdata 71.855 ms 0.46 Mb
lgproductordered 0.287 ms 0.10 Mb
dgtranslationall 2.647 ms 0.14 Mb
49 module(s) 265.996 ms 9.22 Mb

Stopwatch SQL - 227 queries

# Query Time (ms) Rows Filesort Group By Location
51
SELECT SQL_NO_CACHE count(DISTINCT nl.id_prestablog_news) as `count`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:41' LIMIT 1
144.376 ms 1308 /modules/prestablog/class/news.php:585
214
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('11151112', '13', '308350547', '', '1', '1', '2025-02-11 10:00:42')
54.262 ms 1 /classes/ObjectModel.php:622
63
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
13.034 ms 0 /classes/Hook.php:1326
53
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 255
AND cl.`id_lang` = 2
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
ORDER BY cl.`title`
10.580 ms 96 Yes /modules/prestablog/class/correspondancescategories.php:58
52
SELECT SQL_NO_CACHE DISTINCT(nl.`id_prestablog_news`), n.*, nl.*,
LEFT(nl.`title`, 80) as title,
(
SELECT count(cn.`id_prestablog_commentnews`)
FROM `ps_prestablog_commentnews` cn
WHERE cn.`news` = n.`id_prestablog_news`
AND cn.`actif` = 1
) as count_comments,
n.`id_prestablog_news` as `id`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:41'
ORDER BY n.`date` desc
LIMIT 12, 4
10.523 ms 1308 Yes /modules/prestablog/class/news.php:862
215
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('10434892', '', 'www.revitex.com/pt/blog/12p4', '', '2025-02-11 10:00:42')
10.056 ms 1 /classes/ObjectModel.php:622
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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
8.995 ms 6474 /classes/Configuration.php:180
189
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`nleft` &lt;= 2 AND c.`nright` &gt;= 557 AND c.`nleft` &gt;= 2 AND c.`nright` &lt;= 557 ORDER BY `nleft` DESC
8.827 ms 1 /classes/Category.php:1600
144
SELECT SQL_NO_CACHE DISTINCT(nl.`id_prestablog_news`), n.*, nl.*,
LEFT(nl.`title`, 80) as title,
(
SELECT count(cn.`id_prestablog_commentnews`)
FROM `ps_prestablog_commentnews` cn
WHERE cn.`news` = n.`id_prestablog_news`
AND cn.`actif` = 1
) as count_comments,
n.`id_prestablog_news` as `id`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025/02/11 10:00:42'
ORDER BY n.`date` desc
LIMIT 0, 3
8.076 ms 1308 Yes /modules/prestablog/class/news.php:862
162
SELECT SQL_NO_CACHE COUNT(DISTINCT nl.`id_prestablog_news`) AS `value`
FROM `ps_prestablog_news_lang` as nl
LEFT JOIN `ps_prestablog_correspondancecategorie` as co
ON (co.news = nl.id_prestablog_news)
LEFT JOIN `ps_prestablog_categorie` as c
ON (co.categorie = c.id_prestablog_categorie)
LEFT JOIN `ps_prestablog_news` as n
ON (nl.id_prestablog_news = n.id_prestablog_news)
WHERE n.`actif` = 1
AND nl.`id_lang` = 2
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025/02/11 10:00:42'
AND    c.`actif` = 1
AND    c.id_prestablog_categorie = 4 LIMIT 1
7.941 ms 12 /modules/prestablog/class/categories.php:512
185
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` &gt;= c2.`nleft` AND c.`nright` &lt;= c2.`nright`
WHERE 1 AND c.`level_depth` &lt;= 5 AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
6.584 ms 266 Yes Yes /classes/Category.php:799
64
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 `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
4.606 ms 931 /classes/Hook.php:456
65
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 5
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
4.350 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
62
SELECT SQL_NO_CACHE DISTINCT g.id_tax_rules_group, g.name, g.active FROM `ps_tax_rules_group` g INNER JOIN ps_tax_rules_group_shop tax_rules_group_shop
ON (tax_rules_group_shop.id_tax_rules_group = g.id_tax_rules_group AND tax_rules_group_shop.id_shop = 1) WHERE g.deleted = 0 AND g.`active` = 1 AND g.`active` = 1 ORDER BY name ASC
3.911 ms 11 Yes /classes/tax/TaxRulesGroup.php:201
16
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device &amp; 1)
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_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`
3.026 ms 3432 Yes Yes /classes/Hook.php:1267
160
SELECT SQL_NO_CACHE count(DISTINCT nl.id_prestablog_news) as `count`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND ( cc.`categorie` = 3 )
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:42' LIMIT 1
2.418 ms 404 /modules/prestablog/class/news.php:585
210
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
2.068 ms 1 /classes/ObjectModel.php:622
50
SELECT SQL_NO_CACHE `menu_color`,`read_color`,`hover_color`,`title_color`,`text_color`,`menu_hover`,`menu_link`,`link_read`,`article_title`,`article_text`,`block_categories`,`block_categories_link`,`block_title`,`block_btn`,`categorie_block_background`,`article_background`,`categorie_block_background_hover`,`block_btn_hover`,`ariane_color`,`ariane_color_text`,`ariane_border`,`block_categories_link_btn`
FROM `ps_prestablog_color`
WHERE `id_shop` =1
2.023 ms 1 /modules/prestablog/class/news.php:292
175
SELECT SQL_NO_CACHE count(DISTINCT nl.id_prestablog_news) as `count`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND ( cc.`categorie` = 6 )
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:42' LIMIT 1
1.429 ms 448 /modules/prestablog/class/news.php:585
95
SELECT SQL_NO_CACHE *
FROM `ps_state` a
WHERE (a.`id_state` = 340) LIMIT 1
1.346 ms 1 /src/Adapter/EntityMapper.php:71
155
SELECT SQL_NO_CACHE count(DISTINCT nl.id_prestablog_news) as `count`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND ( cc.`categorie` = 2 )
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:42' LIMIT 1
1.261 ms 296 /modules/prestablog/class/news.php:585
157
SELECT SQL_NO_CACHE COUNT(DISTINCT nl.`id_prestablog_news`) AS `value`
FROM `ps_prestablog_news_lang` as nl
LEFT JOIN `ps_prestablog_correspondancecategorie` as co
ON (co.news = nl.id_prestablog_news)
LEFT JOIN `ps_prestablog_categorie` as c
ON (co.categorie = c.id_prestablog_categorie)
LEFT JOIN `ps_prestablog_news` as n
ON (nl.id_prestablog_news = n.id_prestablog_news)
WHERE n.`actif` = 1
AND nl.`id_lang` = 2
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025/02/11 10:00:42'
AND    c.`actif` = 1
AND    c.id_prestablog_categorie = 3 LIMIT 1
1.258 ms 101 /modules/prestablog/class/categories.php:512
15
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1.183 ms 1159 /classes/Hook.php:1366
55
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 254
AND cl.`id_lang` = 2
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
ORDER BY cl.`title`
1.179 ms 4 Yes /modules/prestablog/class/correspondancescategories.php:58
107
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1
1.173 ms 0 /classes/module/Module.php:2659
172
SELECT SQL_NO_CACHE COUNT(DISTINCT nl.`id_prestablog_news`) AS `value`
FROM `ps_prestablog_news_lang` as nl
LEFT JOIN `ps_prestablog_correspondancecategorie` as co
ON (co.news = nl.id_prestablog_news)
LEFT JOIN `ps_prestablog_categorie` as c
ON (co.categorie = c.id_prestablog_categorie)
LEFT JOIN `ps_prestablog_news` as n
ON (nl.id_prestablog_news = n.id_prestablog_news)
WHERE n.`actif` = 1
AND nl.`id_lang` = 2
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025/02/11 10:00:42'
AND    c.`actif` = 1
AND    c.id_prestablog_categorie = 6 LIMIT 1
1.151 ms 112 /modules/prestablog/class/categories.php:512
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
1.067 ms 1 /src/Adapter/EntityMapper.php:71
66
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 3) LIMIT 1
1.030 ms 1 /src/Adapter/EntityMapper.php:71
188
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
1.004 ms 1 /classes/Category.php:1591
111
SELECT SQL_NO_CACHE s.*,
cl.`name` country,
st.`iso_code` state,
sl.`name`, sl.`address1`, sl.`address2`, sl.`hours`, sl.`note`,
(6371
* acos(
cos(radians(0))
* cos(radians(latitude))
* cos(radians(longitude) - radians(0))
+ sin(radians(0))
* sin(radians(latitude))
)
) distance
FROM ps_store s
INNER JOIN ps_store_shop store_shop
ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1)
LEFT JOIN ps_country_lang cl ON (cl.id_country = s.id_country)
LEFT JOIN ps_state st ON (st.id_state = s.id_state)
LEFT JOIN ps_store_lang sl ON (s.id_store = sl.id_store)
WHERE s.active = 1
AND cl.id_lang = 2
AND sl.id_lang = 2
0.967 ms 36 /modules/storelocator/classes/Locator.php:141
69
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 2
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.936 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
152
SELECT SQL_NO_CACHE COUNT(DISTINCT nl.`id_prestablog_news`) AS `value`
FROM `ps_prestablog_news_lang` as nl
LEFT JOIN `ps_prestablog_correspondancecategorie` as co
ON (co.news = nl.id_prestablog_news)
LEFT JOIN `ps_prestablog_categorie` as c
ON (co.categorie = c.id_prestablog_categorie)
LEFT JOIN `ps_prestablog_news` as n
ON (nl.id_prestablog_news = n.id_prestablog_news)
WHERE n.`actif` = 1
AND nl.`id_lang` = 2
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025/02/11 10:00:42'
AND    c.`actif` = 1
AND    c.id_prestablog_categorie = 2 LIMIT 1
0.877 ms 74 /modules/prestablog/class/categories.php:512
18
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
0.866 ms 1159 /classes/Hook.php:1326
216
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.834 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
54
SELECT SQL_NO_CACHE n.`author_id`
FROM `ps_prestablog_news` n
WHERE n.`id_prestablog_news` =  255
0.773 ms 1 /modules/prestablog/class/author.php:258
180
SELECT SQL_NO_CACHE count(DISTINCT nl.id_prestablog_news) as `count`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND ( cc.`categorie` = 7 )
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:42' LIMIT 1
0.753 ms 72 /modules/prestablog/class/news.php:585
170
SELECT SQL_NO_CACHE count(DISTINCT nl.id_prestablog_news) as `count`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND ( cc.`categorie` = 5 )
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:42' LIMIT 1
0.741 ms 52 /modules/prestablog/class/news.php:585
31
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.700 ms 178 Yes /classes/Dispatcher.php:654
97
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.689 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:214
147
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 272
AND cl.`id_lang` = 2
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
ORDER BY cl.`title`
0.681 ms 4 Yes /modules/prestablog/class/correspondancescategories.php:58
159
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 3
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.666 ms 4 Yes /modules/prestablog/class/categories.php:687
57
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 251
AND cl.`id_lang` = 2
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
ORDER BY cl.`title`
0.665 ms 96 Yes /modules/prestablog/class/correspondancescategories.php:58
106
SELECT SQL_NO_CACHE c.* FROM `ps_sameprice_configuration` c WHERE c.`id_shop` = 1
AND c.`active` = 1
0.658 ms 1 /modules/sameprice/sameprice.php:770
151
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 0
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.652 ms 48 Yes /modules/prestablog/class/categories.php:687
59
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 248
AND cl.`id_lang` = 2
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
ORDER BY cl.`title`
0.648 ms 96 Yes /modules/prestablog/class/correspondancescategories.php:58
71
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 2
0.639 ms 2 /src/Adapter/EntityMapper.php:79
223
SELECT SQL_NO_CACHE *
FROM `ps_advancedpopup`
INNER JOIN `ps_advancedpopup_lang` ON `ps_advancedpopup`.`id_advancedpopup` = `ps_advancedpopup_lang`.`id_advancedpopup`
WHERE `id_shop` = 1 AND `id_lang` = 2 AND `active` = 1
AND (`zones` = ""
OR `zones` IS NULL
OR FIND_IN_SET("9", `zones`))
AND (`date_init` &lt;= "2025-02-11 10:00:42" OR `date_init` = "1970-01-01 01:00:00")
AND (`date_end` &gt;= "2025-02-11 10:00:42" OR `date_end` = "1970-01-01 01:00:00")
AND (`customers` = ""
OR `customers` IS NULL
OR FIND_IN_SET("0", `customers`))
AND (`languages` = ""
OR `languages` IS NULL
OR FIND_IN_SET("2", `languages`))
AND (`display_ip_string` = ""
OR `display_ip_string` IS NULL
OR FIND_IN_SET("18.97.14.83", `display_ip_string`))
AND (`display_url_string` = ""
OR `display_url_string` IS NULL
OR INSTR("www.revitex.com/pt/blog/12p4", `display_url_string`) &gt; 0)
AND (`genders` = ""
OR `genders` IS NULL) AND (`groups` = ""
OR `groups` IS NULL  OR FIND_IN_SET(1, `groups`)) AND `display_desktop` = 1 AND (`cms` = ""
OR `cms` IS NULL) AND (`controller_exceptions` = ""
OR `controller_exceptions` IS NULL
OR FIND_IN_SET("moduleprestablogblog", `controller_exceptions`)) AND (`display_after_cart` = 1
OR `products` = ""
OR `products` IS NULL) AND (`display_after_cart` = 1
OR `categories` = ""
OR `categories` IS NULL) AND (`display_after_cart` = 1
OR `manufacturers` = ""
OR `manufacturers` IS NULL) AND (`display_after_cart` = 1
OR `suppliers` = ""
OR `suppliers` IS NULL) ORDER BY `priority` ASC;
0.624 ms 2 Yes /modules/advancedpopupcreator/classes/AdvancedPopup.php:437
161
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 3
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.601 ms 4 Yes /modules/prestablog/class/categories.php:687
174
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 6
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.593 ms 4 Yes /modules/prestablog/class/categories.php:687
178
SELECT SQL_NO_CACHE c.`id_prestablog_categorie`
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`id_prestablog_categorie` = 7
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.580 ms 1 /modules/prestablog/class/categories.php:645
165
SELECT SQL_NO_CACHE count(DISTINCT nl.id_prestablog_news) as `count`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 2
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND ( cc.`categorie` = 4 )
AND TIMESTAMP(n.`date`) &lt;= '2025-02-11 10:00:42' LIMIT 1
0.567 ms 48 /modules/prestablog/class/news.php:585
77
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 8
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.557 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
19
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.555 ms 145 /classes/module/Module.php:346
164
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 4
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.553 ms 4 Yes /modules/prestablog/class/categories.php:687
74
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
0.545 ms 2 /src/Adapter/EntityMapper.php:79
166
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 4
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.538 ms 4 Yes /modules/prestablog/class/categories.php:687
168
SELECT SQL_NO_CACHE c.`id_prestablog_categorie`
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`id_prestablog_categorie` = 5
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.536 ms 1 /modules/prestablog/class/categories.php:645
34
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.534 ms 145 /classes/module/Module.php:346
29
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.522 ms 145 /classes/module/Module.php:346
21
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.520 ms 145 /classes/module/Module.php:346
27
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.519 ms 145 /classes/module/Module.php:346
73
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
0.516 ms 1 /src/Adapter/EntityMapper.php:71
76
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 6
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.509 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
116
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1
0.501 ms 25 /classes/CartRule.php:423
173
SELECT SQL_NO_CACHE c.`id_prestablog_categorie`
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`id_prestablog_categorie` = 6
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.495 ms 1 /modules/prestablog/class/categories.php:645
167
SELECT SQL_NO_CACHE COUNT(DISTINCT nl.`id_prestablog_news`) AS `value`
FROM `ps_prestablog_news_lang` as nl
LEFT JOIN `ps_prestablog_correspondancecategorie` as co
ON (co.news = nl.id_prestablog_news)
LEFT JOIN `ps_prestablog_categorie` as c
ON (co.categorie = c.id_prestablog_categorie)
LEFT JOIN `ps_prestablog_news` as n
ON (nl.id_prestablog_news = n.id_prestablog_news)
WHERE n.`actif` = 1
AND nl.`id_lang` = 2
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025/02/11 10:00:42'
AND    c.`actif` = 1
AND    c.id_prestablog_categorie = 5 LIMIT 1
0.490 ms 13 /modules/prestablog/class/categories.php:512
33
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.488 ms 145 /classes/module/Module.php:346
163
SELECT SQL_NO_CACHE c.`id_prestablog_categorie`
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`id_prestablog_categorie` = 4
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.487 ms 1 /modules/prestablog/class/categories.php:645
61
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.481 ms 1 /classes/shop/ShopUrl.php:182
35
SELECT SQL_NO_CACHE * FROM ps_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/pt/blog/12p4" OR CONCAT("", url_old) LIKE BINARY "/pt/blog/12p4#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1
0.476 ms 1 /modules/lgseoredirect/lgseoredirect.php:875
145
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 274
AND cl.`id_lang` = 2
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
ORDER BY cl.`title`
0.470 ms 96 Yes /modules/prestablog/class/correspondancescategories.php:58
177
SELECT SQL_NO_CACHE COUNT(DISTINCT nl.`id_prestablog_news`) AS `value`
FROM `ps_prestablog_news_lang` as nl
LEFT JOIN `ps_prestablog_correspondancecategorie` as co
ON (co.news = nl.id_prestablog_news)
LEFT JOIN `ps_prestablog_categorie` as c
ON (co.categorie = c.id_prestablog_categorie)
LEFT JOIN `ps_prestablog_news` as n
ON (nl.id_prestablog_news = n.id_prestablog_news)
WHERE n.`actif` = 1
AND nl.`id_lang` = 2
AND nl.`actif_langue` = 1
AND TIMESTAMP(n.`date`) &lt;= '2025/02/11 10:00:42'
AND    c.`actif` = 1
AND    c.id_prestablog_categorie = 7 LIMIT 1
0.462 ms 18 /modules/prestablog/class/categories.php:512
70
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 2) LIMIT 1
0.442 ms 1 /src/Adapter/EntityMapper.php:71
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.revitex.com' OR su.domain_ssl = 'www.revitex.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.440 ms 1 Yes /classes/shop/Shop.php:1364
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 ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.439 ms 1 Yes /classes/shop/Shop.php:715
26
SELECT SQL_NO_CACHE * FROM ps_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/pt/blog/12p4" OR CONCAT("", url_old) LIKE BINARY "/pt/blog/12p4#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1
0.439 ms 1 /modules/lgseoredirect/lgseoredirect.php:875
182
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
0.425 ms 1 /classes/module/Module.php:2659
84
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 10
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.413 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
149
SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 269
AND cl.`id_lang` = 2
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE cc.`categorie` = pc.`id_prestablog_categorie`
)
ORDER BY cl.`title`
0.412 ms 96 Yes /modules/prestablog/class/correspondancescategories.php:58
192
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 2)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayLeftColumn')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 2)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 1
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.412 ms 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
113
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 1106 LIMIT 1
0.408 ms 1 /classes/Hook.php:244
140
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 2)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayTop')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 2)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 1
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.408 ms 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
158
SELECT SQL_NO_CACHE c.`id_prestablog_categorie`
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`id_prestablog_categorie` = 3
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.406 ms 1 /modules/prestablog/class/categories.php:645
156
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 2
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.404 ms 4 Yes /modules/prestablog/class/categories.php:687
176
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 6
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.396 ms 4 Yes /modules/prestablog/class/categories.php:687
169
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 5
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.391 ms 4 Yes /modules/prestablog/class/categories.php:687
94
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 6
0.389 ms 2 /src/Adapter/EntityMapper.php:79
118
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` &gt; 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
0.387 ms 1 /classes/CartRule.php:423
6
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.387 ms 1 /src/Adapter/EntityMapper.php:71
181
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 7
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.382 ms 4 Yes /modules/prestablog/class/categories.php:687
183
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1
0.375 ms 1 /classes/module/Module.php:2132
115
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to &gt;= "2025-02-11 00:00:00" AND date_to &lt;= "2025-02-11 23:59:59") OR (date_from &gt;= "2025-02-11 00:00:00" AND date_from &lt;= "2025-02-11 23:59:59") OR (date_from &lt; "2025-02-11 00:00:00" AND date_to &gt; "2025-02-11 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
0.366 ms 111 /classes/CartRule.php:357
114
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
0.365 ms 1 /classes/Cart.php:4255
205
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 2)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayFooter')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 2)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 1
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.358 ms 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
141
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "top" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.355 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
68
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 4
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.351 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
124
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
0.349 ms 1 /classes/Currency.php:1136
133
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayNav2" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.347 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
217
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "topWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.344 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
8
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.343 ms 1 /src/Adapter/EntityMapper.php:71
56
SELECT SQL_NO_CACHE n.`author_id`
FROM `ps_prestablog_news` n
WHERE n.`id_prestablog_news` =  254
0.341 ms 1 /modules/prestablog/class/author.php:258
154
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 2
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.341 ms 4 Yes /modules/prestablog/class/categories.php:687
171
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 5
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.338 ms 4 Yes /modules/prestablog/class/categories.php:687
153
SELECT SQL_NO_CACHE c.`id_prestablog_categorie`
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`id_prestablog_categorie` = 2
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.338 ms 1 /modules/prestablog/class/categories.php:645
121
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayBanner" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.337 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
11
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.336 ms 2 /classes/Language.php:1216
220
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.335 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.334 ms 2 /classes/Language.php:1080
117
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to &gt;= "2025-02-11 00:00:00" AND date_to &lt;= "2025-02-11 23:59:59") OR (date_from &gt;= "2025-02-11 00:00:00" AND date_from &lt;= "2025-02-11 23:59:59") OR (date_from &lt; "2025-02-11 00:00:00" AND date_to &gt; "2025-02-11 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
0.334 ms 111 /classes/CartRule.php:357
126
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayNav1" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.332 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
193
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "leftcolumn" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.331 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
179
SELECT SQL_NO_CACHE c.*, cl.*, c.`id_prestablog_categorie` as `id`,
LEFT(cl.`title`, 80) as title
FROM `ps_prestablog_categorie` c
JOIN `ps_prestablog_categorie_lang` cl
ON (c.`id_prestablog_categorie` = cl.`id_prestablog_categorie`)
WHERE cl.`id_lang` = 2
AND c.`parent` = 7
AND c.`id_shop` = 1
AND c.`actif` = 1
AND EXISTS (
SELECT 1
FROM `ps_prestablog_categorie` pc
JOIN `ps_prestablog_categorie_group` pcg
ON (
pc.id_prestablog_categorie = pcg.id_prestablog_categorie
AND pcg.`id_group` = 1
)
WHERE c.`id_prestablog_categorie` = pc.`id_prestablog_categorie`
)
ORDER BY c.`position`
0.330 ms 4 Yes /modules/prestablog/class/categories.php:687
218
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.327 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
75
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 3
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.326 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
100
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayHeader" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.321 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
87
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-prestablog-blog"
OR m.page = "moduleprestablogblog"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.320 ms 2 /classes/Meta.php:193
196
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayWrapperBottom" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.319 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_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
0.314 ms 1 /classes/shop/Shop.php:218
83
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 32
0.314 ms 2 /src/Adapter/EntityMapper.php:79
120
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `ps_quantity_discount_rule` qdr
LEFT JOIN `ps_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 2)
WHERE qdr.`active` = 1 AND `id_family` = 1 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.312 ms 17 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:258
72
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 11
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.311 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
186
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
0.311 ms 1 /classes/Category.php:2242
187
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 2 AND cl.id_shop = 1 ) WHERE c.`id_category` = 2 LIMIT 1
0.309 ms 1 /classes/Category.php:1585
184
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_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
0.308 ms 1 /src/Adapter/EntityMapper.php:71
60
SELECT SQL_NO_CACHE n.`author_id`
FROM `ps_prestablog_news` n
WHERE n.`id_prestablog_news` =  248
0.305 ms 1 /modules/prestablog/class/author.php:258
202
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.303 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
203
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayFooter" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.301 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
30
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "stores"
OR m.page = "stores"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.300 ms 1 /classes/Meta.php:193
81
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 9
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.300 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
221
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayBeforeBodyClosingTag" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.300 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135
112
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.292 ms 1 /src/Adapter/EntityMapper.php:71
190
SELECT SQL_NO_CACHE id_trustedshops_channel
FROM `ps_trustedshops_channel`
WHERE (id_client = '918b454e3890__PrestaShop') AND (id_lang = 2) AND (id_shop = 1) LIMIT 1
0.289 ms 1 /modules/trustedshopseasyintegration/src/Repository/ChannelRepository.php:99
211
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 11151112
AND `date_add` &gt; '2025-02-11 09:30:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.289 ms 1 Yes /classes/Connection.php:168
80
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 7
AND tr.`id_state` IN (0, 340)
AND ('24010' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '24010')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.288 ms 2 Yes /classes/tax/TaxRulesTaxManager.php:109
82
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 32) LIMIT 1
0.287 ms 1 /src/Adapter/EntityMapper.php:71
191
SELECT SQL_NO_CACHE qdrf.*
FROM `ps_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.273 ms 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:75
39
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.270 ms 1 /src/Adapter/EntityMapper.php:71
103
SELECT SQL_NO_CACHE count(*)
FROM `ps_advancedpopup`
INNER JOIN `ps_advancedpopup_lang` ON `ps_advancedpopup`.`id_advancedpopup` = `ps_advancedpopup_lang`.`id_advancedpopup`
WHERE `id_shop` = 1 AND `id_lang` = 2 AND `active` = 1
AND `display_on_exit` = 1 LIMIT 1
0.260 ms 2 /modules/advancedpopupcreator/classes/AdvancedPopup.php:872
20
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.258 ms 88 /classes/Hook.php:339
207
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitsociallogin" LIMIT 1
0.254 ms 1 /classes/module/Module.php:2659
219
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `ps_whatsappchatblock_agent`.`id_whatsappchatblock` = 1 AND `active` = 1 ORDER BY position
0.251 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:78
109
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.250 ms 8 /classes/ImageType.php:161
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.246 ms 1 /classes/shop/ShopUrl.php:182
99
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `active` = 1 ORDER BY position
0.245 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:78
17
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.244 ms 88 /classes/Hook.php:287
90
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.243 ms 8 Yes /classes/ImageType.php:109
36
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.240 ms 1 Yes /classes/Currency.php:709
139
SELECT SQL_NO_CACHE qdrf.*
FROM `ps_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.240 ms 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:75
41
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.239 ms 1 /classes/Country.php:194
122
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
0.237 ms 1 /classes/module/Module.php:2659