Banners informativos

Vuelta al cole

Mochilas, meriendas y esenciales para volver con ganas

Los más vendidos

Ver los más vendidos

Marcas que nos encantan

Ver todas las marcas
Product added to wishlist
Configuración de cookies
Load Time 382.760 ms
Querying Time 57 ms
Queries 231
Memory Peak Usage 16.1 Mb
Included Files 1384 files - 19.23 Mb
PrestaShop Cache - Mb
Global vars 1.19 Mb
PrestaShop Version 9.1.4
PHP Version 8.4.25
MySQL Version 10.11.19-MariaDB
Memory Limit 512M
Max Execution Time 260s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 98.339 ms 98.339 ms 3.11 Mb 3.1 Mb
__construct 0.014 ms 98.353 ms - Mb 3.1 Mb
init 16.341 ms 114.694 ms 0.43 Mb 4.0 Mb
checkAccess 0.001 ms 114.695 ms - Mb 4.0 Mb
setMedia 39.110 ms 153.805 ms 0.48 Mb 4.2 Mb
postProcess 0.002 ms 153.807 ms - Mb 4.2 Mb
initHeader 0.002 ms 153.809 ms - Mb 4.2 Mb
initContent 107.191 ms 261.000 ms 4.02 Mb 8.1 Mb
initFooter 0.002 ms 261.002 ms - Mb 8.1 Mb
display 121.758 ms 382.760 ms 6.12 Mb 16.1 Mb
Hook Time Memory Usage
DisplayHeader 58.470 ms 1.79 Mb
DisplayBeforeBodyClosingTag 41.089 ms 1.41 Mb
ActionFrontControllerSetMedia 33.302 ms 0.39 Mb
DisplayAfterBodyOpeningTag 22.616 ms 0.82 Mb
DisplayHome 13.591 ms 0.63 Mb
displayBeforeBodyClosingTag 13.237 ms 0.49 Mb
ActionDispatcherBefore 5.965 ms 0.10 Mb
DisplayTop 3.164 ms 0.18 Mb
DisplayMainMenu 2.972 ms 0.43 Mb
DisplayFooterAfter 2.632 ms 0.21 Mb
ModuleRoutes 2.619 ms 0.02 Mb
displayHome 1.911 ms 0.78 Mb
displayCustomerLoginFormAfter 1.847 ms 0.07 Mb
displayTop 1.778 ms 0.43 Mb
DisplayNappyBabySelector 1.675 ms 0.04 Mb
DisplayCustomerLoginFormAfter 1.481 ms 0.02 Mb
ActionDispatcher 1.259 ms - Mb
displayHeaderButtons 0.967 ms 0.07 Mb
DisplaySearch 0.565 ms 0.01 Mb
DisplayBanner 0.560 ms - Mb
displayCartAjaxInfo 0.531 ms 0.07 Mb
renderWidget 0.327 ms 0.06 Mb
DisplayFooterBefore 0.278 ms 0.03 Mb
ActionObjectAddAfter 0.021 ms - Mb
OverrideLayoutTemplate 0.018 ms - Mb
ActionFrontControllerAfterInit 0.006 ms - Mb
26 hook(s) 212.881 ms 8.07 Mb
Module Time Memory Usage
ps_checkout 28.686 ms 0.14 Mb
ph_simpleblog 6.102 ms 0.08 Mb
lgseoredirect 6.663 ms 0.07 Mb
gsnippetsreviews 19.895 ms 0.81 Mb
nappyseoparity 2.321 ms - Mb
tig_cookies 14.662 ms 0.46 Mb
tig_loginascustomer 0.848 ms 0.02 Mb
tig_loginsocial 11.695 ms 0.26 Mb
tig_exitpopup 4.062 ms 0.23 Mb
iqitthemeeditor 1.446 ms 0.10 Mb
tig_quantitydiscount 3.188 ms 0.24 Mb
ps_emailsubscription 0.413 ms 0.01 Mb
ps_accounts 0.776 ms - Mb
ps_emailalerts 0.428 ms 0.01 Mb
ps_facebook 11.754 ms 0.20 Mb
iqitproductvariants 0.975 ms 0.01 Mb
tig_subscription 0.331 ms 0.01 Mb
tig_boughttogether 3.824 ms 0.20 Mb
tig_elementor_promos 3.952 ms 0.30 Mb
tig_mobilemenu 35.284 ms 1.17 Mb
nappybabyprofile 2.732 ms 0.05 Mb
revsliderprestashop 3.112 ms 0.04 Mb
ps_shoppingcart 0.309 ms 0.01 Mb
tigestionpayments 0.515 ms 0.02 Mb
psshipping 8.331 ms 0.06 Mb
psxmarketingwithgoogle 1.699 ms - Mb
ps_googleanalytics 2.947 ms 0.06 Mb
iqitcontactpage 0.291 ms 0.01 Mb
iqitcountdown 0.726 ms 0.01 Mb
iqitelementor 4.077 ms 0.79 Mb
iqitfreedeliverycount 0.814 ms 0.08 Mb
iqitmegamenu 1.689 ms 0.03 Mb
iqitreviews 0.350 ms 0.01 Mb
iqitsizecharts 0.611 ms 0.01 Mb
iqitwishlist 9.855 ms 0.23 Mb
iqitextendedproduct 0.791 ms 0.01 Mb
iqitsociallogin 2.467 ms 0.08 Mb
tig_megamenu 8.599 ms 1.47 Mb
ps_searchbar 0.151 ms 0.01 Mb
ps_customersignin 0.083 ms 0.01 Mb
crisp 1.497 ms 0.02 Mb
correosoficial 6.266 ms 0.40 Mb
sequra 5.868 ms 0.07 Mb
senderglobal 1.234 ms 0.03 Mb
tig_filters 0.659 ms 0.19 Mb
tig_searchfinder 1.924 ms 0.04 Mb
tig_topbanner 18.857 ms 0.72 Mb
lggooglereviews 0.500 ms - Mb
tig_productpacks 0.346 ms 0.01 Mb
paypalfeeplus 1.816 ms 0.08 Mb
alcagtmplus 2.804 ms 0.12 Mb
iqitsearch 0.638 ms 0.06 Mb
ps_mainmenu 1.945 ms 0.44 Mb
pagesnotfound 0.122 ms 0.01 Mb
statsdata 4.303 ms 0.19 Mb
55 module(s) 256.233 ms 9.47 Mb

Stopwatch SQL - 231 queries

# Query Time (ms) Rows Filesort Group By Location
228
SELECT SQL_NO_CACHE c.*, cl.*
FROM `np_category` c
INNER JOIN np_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `np_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `np_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.295 ms 218 Yes /classes/Category.php:795
25
SELECT SQL_NO_CACHE * FROM np_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/" OR CONCAT("", url_old) LIKE BINARY "/#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1
2.071 ms 1 /modules/lgseoredirect/lgseoredirect.php:877
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 `np_configuration` c
LEFT JOIN `np_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2.010 ms 1939 /classes/Configuration.php:162
13
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `np_module` m
INNER JOIN np_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1)
INNER JOIN `np_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `np_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `np_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`
1.825 ms 194 Yes Yes /classes/Hook.php:1497
168
SELECT SQL_NO_CACHE 1 FROM `np_cart_rule` WHERE ((date_to >= "2026-09-21 00:00:00" AND date_to <= "2026-09-21 23:59:59") OR (date_from >= "2026-09-21 00:00:00" AND date_from <= "2026-09-21 23:59:59") OR (date_from < "2026-09-21 00:00:00" AND date_to > "2026-09-21 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
1.685 ms 1984 /classes/CartRule.php:380
59
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `np_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `np_hook_alias` ha
INNER JOIN `np_hook` h ON ha.name = h.name
1.574 ms 0 /classes/Hook.php:1565
169
SELECT SQL_NO_CACHE * FROM `np_cart_rule` cr
LEFT JOIN `np_cart_rule_lang` crl
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) 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
1.449 ms 133 /classes/CartRule.php:446
30
SELECT SQL_NO_CACHE * FROM np_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/" OR CONCAT("", url_old) LIKE BINARY "/#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1
1.445 ms 1 /modules/lgseoredirect/lgseoredirect.php:877
170
SELECT SQL_NO_CACHE 1 FROM `np_cart_rule` WHERE ((date_to >= "2026-09-21 00:00:00" AND date_to <= "2026-09-21 23:59:59") OR (date_from >= "2026-09-21 00:00:00" AND date_from <= "2026-09-21 23:59:59") OR (date_from < "2026-09-21 00:00:00" AND date_to > "2026-09-21 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
1.231 ms 1984 /classes/CartRule.php:380
43
SELECT SQL_NO_CACHE * FROM np_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/" OR CONCAT("", url_old) LIKE BINARY "/#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1
1.198 ms 1 /modules/lgseoredirect/lgseoredirect.php:877
215
INSERT INTO `np_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', '', '0')
1.003 ms 1 /classes/ObjectModel.php:524
65
SELECT SQL_NO_CACHE GROUP_CONCAT(`canvas_json` SEPARATOR " ")
FROM `np_tig_elementor_promos_design`
WHERE `active` = 1 AND `status` = "published" LIMIT 1
0.917 ms 22 /modules/tig_elementor_promos/tig_elementor_promos.php:97
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM np_shop_url su
LEFT JOIN np_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'nappy.es' OR su.domain_ssl = 'nappy.es')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.682 ms 1 Yes /classes/shop/Shop.php:1372
15
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `np_hook`
0.681 ms 1278 /classes/Hook.php:1565
12
SELECT SQL_NO_CACHE lower(name) as name
FROM `np_hook` h
WHERE (h.active = 1)
0.521 ms 1278 /classes/Hook.php:1605
219
INSERT INTO `np_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('8605067', '1', '3628718150', '', '1', '1', '2026-09-21 23:39:40')
0.495 ms 1 /classes/ObjectModel.php:524
27
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `np_meta` m
LEFT JOIN `np_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.491 ms 65 Yes /classes/Dispatcher.php:623
16
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.471 ms 97 /classes/module/Module.php:325
20
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.459 ms 97 /classes/module/Module.php:325
100
SHOW COLUMNS FROM `np_correos_oficial_saved_orders` LIKE 'label'
0.455 ms 1 /modules/correosoficial/correosoficial.php:233
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 np_shop_group gs
LEFT JOIN np_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN np_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.429 ms 1 Yes /classes/shop/Shop.php:696
127
SELECT SQL_NO_CACHE `id_design`
FROM `np_tig_elementor_promos_design`
WHERE `active` = 1
AND `status` = "published"
AND `hook_name` = "displayHome"
AND (`date_start` IS NULL OR `date_start` = "0000-00-00 00:00:00" OR `date_start` <= "2026-09-21 23:39:40")
AND (`date_end` IS NULL OR `date_end` = "0000-00-00 00:00:00" OR `date_end` >= "2026-09-21 23:39:40")
ORDER BY `priority` DESC, `id_design` DESC
0.429 ms 1 /modules/tig_elementor_promos/tig_elementor_promos.php:669
220
INSERT INTO `np_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('211096', '', 'nappy.es/', '', '2026-09-21 23:39:40')
0.428 ms 1 /classes/ObjectModel.php:524
99
SHOW TABLES LIKE "np_correos_oficial_saved_orders"
0.420 ms 1 /modules/correosoficial/correosoficial.php:223
208
SELECT SQL_NO_CACHE `id_cart_rule` FROM `np_cart_rule` WHERE `code` = 'BIENVENIDA3' LIMIT 1
0.416 ms 21645 /classes/CartRule.php:352
31
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.392 ms 97 /classes/module/Module.php:325
19
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.368 ms 97 /classes/module/Module.php:325
185
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `np_quantity_discount_rule` qdr
INNER JOIN `np_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `np_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayTop')
INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
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.355 ms 1 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:310
42
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.350 ms 97 /classes/module/Module.php:325
101
SHOW COLUMNS FROM `np_correos_oficial_saved_returns` LIKE 'label'
0.350 ms 1 /modules/correosoficial/correosoficial.php:234
41
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.339 ms 97 /classes/module/Module.php:325
171
SELECT SQL_NO_CACHE * FROM `np_cart_rule` cr
LEFT JOIN `np_cart_rule_lang` crl
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND (cr.`quantity` > 0 OR cr.`quantity` is null) AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
0.339 ms 1 /classes/CartRule.php:446
26
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.335 ms 97 /classes/module/Module.php:325
129
SELECT SQL_NO_CACHE *
FROM `np_product` a
LEFT JOIN `np_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5908) LIMIT 1
0.334 ms 1 /src/Adapter/EntityMapper.php:54
119
SELECT SQL_NO_CACHE *
FROM `np_order_state` os
LEFT JOIN `np_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) WHERE deleted = 0 ORDER BY `name` ASC
0.318 ms 35 Yes /classes/order/OrderState.php:112
40
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.315 ms 97 /classes/module/Module.php:325
184
SELECT SQL_NO_CACHE qdrf.*
FROM `np_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.312 ms 3 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRuleFamily.php:75
68
SELECT SQL_NO_CACHE *
FROM np_meta m
LEFT JOIN np_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.299 ms 1 /classes/Meta.php:161
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `np_lang` l
LEFT JOIN `np_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.297 ms 2 /classes/Language.php:1050
11
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `np_lang` l
JOIN np_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.296 ms 4 /classes/Language.php:1184
69
SELECT SQL_NO_CACHE * FROM `np_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.293 ms 8 Yes /classes/ImageType.php:89
216
SELECT SQL_NO_CACHE `id_guest`
FROM `np_connections`
WHERE `id_guest` = 8605067
AND `date_add` > '2026-09-21 23:09:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.287 ms 1 Yes /classes/Connection.php:148
6
SELECT SQL_NO_CACHE *
FROM `np_country` a
LEFT JOIN `np_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `np_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.281 ms 1 /src/Adapter/EntityMapper.php:54
39
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.279 ms 97 /classes/module/Module.php:325
156
SELECT SQL_NO_CACHE *
FROM `np_product` a
LEFT JOIN `np_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5920) LIMIT 1
0.277 ms 1 /src/Adapter/EntityMapper.php:54
173
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `np_quantity_discount_rule` qdr
LEFT JOIN `np_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
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.275 ms 140 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:261
8
SELECT SQL_NO_CACHE *
FROM `np_lang` a
LEFT JOIN `np_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.274 ms 1 /src/Adapter/EntityMapper.php:54
29
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `np_module` m
LEFT JOIN `np_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.273 ms 97 /classes/module/Module.php:325
167
SELECT SQL_NO_CACHE 1 FROM np_cart_product cp INNER JOIN np_product p
ON (p.id_product = cp.id_product) INNER JOIN np_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.270 ms 1 /classes/Cart.php:4360
191
SELECT SQL_NO_CACHE sn.*, snl.title, snl.link
FROM `np_tig_mm_secondary_nav` sn
INNER JOIN `np_tig_mm_secondary_nav_shop` sns 
ON (sn.id_secondary_nav = sns.id_secondary_nav AND sns.id_shop='1')
LEFT JOIN `np_tig_mm_secondary_nav_lang` snl
ON sn.id_secondary_nav = snl.id_secondary_nav 
AND snl.id_lang=1
WHERE 1  AND sn.enabled=1
ORDER BY sn.sort_order ASC
0.268 ms 2 Yes /modules/tig_megamenu/classes/MM_SecondaryNav.php:68
128
SELECT SQL_NO_CACHE *
FROM `np_bt_spr_products_reviews` pr
WHERE (pr.`id_shop` = 1) AND (pr.`review_status` = 1)
ORDER BY pr.`date_add` DESC
LIMIT 3
0.262 ms 117 Yes /modules/gsnippetsreviews/models/Reviews.php:204
176
SELECT SQL_NO_CACHE *
FROM `np_fbpsc_connector_position` fcp
0.245 ms 5 /modules/tig_loginsocial/models/connectorPosition.php:167
18
SELECT SQL_NO_CACHE value FROM `np_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.243 ms 1 /classes/shop/Shop.php:1191
172
SELECT SQL_NO_CACHE qdrf.*
FROM `np_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.240 ms 3 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRuleFamily.php:75
212
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "iqitsociallogin" LIMIT 1
0.239 ms 1 /classes/module/Module.php:2778
17
SELECT SQL_NO_CACHE name, alias FROM `np_hook_alias`
0.231 ms 86 /classes/Hook.php:364
188
SELECT SQL_NO_CACHE `id_design`
FROM `np_tig_elementor_promos_design`
WHERE `active` = 1
AND `status` = "published"
AND `hook_name` = "displayTop"
AND (`date_start` IS NULL OR `date_start` = "0000-00-00 00:00:00" OR `date_start` <= "2026-09-21 23:39:40")
AND (`date_end` IS NULL OR `date_end` = "0000-00-00 00:00:00" OR `date_end` >= "2026-09-21 23:39:40")
ORDER BY `priority` DESC, `id_design` DESC
0.228 ms 1 /modules/tig_elementor_promos/tig_elementor_promos.php:669
198
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.227 ms 1 /src/Adapter/EntityMapper.php:54
103
SELECT SQL_NO_CACHE t.id_template, t.template_filters AS filters, t.additional_settings, tl.data AS lang
FROM np_af_templates t
LEFT JOIN np_af_templates_lang tl
ON tl.id_template = t.id_template AND tl.id_shop = t.id_shop AND tl.id_lang = 1
WHERE t.active = 1 AND t.template_controller = 'index'
AND t.id_shop = 1
ORDER BY  t.id_template DESC LIMIT 1
0.222 ms 1 /modules/tig_filters/tig_filters.php:3689
223
SELECT SQL_NO_CACHE t1.`id_TIGCOOKIES_type` as `id_TIGCOOKIES_type`,  t2.`name` as `name`,  t2.`description` as `description`,  t1.`condicion` as `condicion`,  t1.`id_shop` as `id_shop`,  t2.id_lang as id_lang  FROM `np_TIGCOOKIES_type` t1 INNER JOIN np_TIGCOOKIES_type_lang t2 on  t2.id_TIGCOOKIES_type= t1.id_TIGCOOKIES_type WHERE  ( id_lang= 1 ) AND t1.id_shop = 1
0.222 ms 16 /modules/tig_cookies/src/ApmTools/ApmLibs.php:515
32
SELECT SQL_NO_CACHE id_tab, class_name FROM `np_tab`
0.219 ms 250 /classes/Tab.php:334
87
SELECT SQL_NO_CACHE id_block FROM `np_tig_mm_block` WHERE enabled=1 AND show_clock=1 AND block_type="PRODUCT" LIMIT 1
0.217 ms 1 /modules/tig_megamenu/classes/MM_Block.php:661
124
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `np_quantity_discount_rule` qdr
INNER JOIN `np_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `np_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayHome')
INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
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.217 ms 1 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:310
186
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `np_quantity_discount_rule` qdr
INNER JOIN `np_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `np_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayTop')
INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 2
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.215 ms 1 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:310
224
SELECT SQL_NO_CACHE t1.`id_tigcookies` as `id_tigcookies`,  t1.`active` as `active`,  t1.`cookie` as `cookie`,  t1.`type` as `type`,  t2.`description` as `description`,  t1.`provider` as `provider`,  t2.`expiration` as `expiration`,  t1.`id_shop` as `id_shop`,  t2.id_lang as id_lang  FROM `np_tig_cookies` t1 INNER JOIN np_tig_cookies_lang t2 on  t2.id_tig_cookies= t1.id_tigcookies WHERE  ( id_lang= 1 AND t1.type = 1 AND t1.active = 1 ) AND t1.id_shop = 1
0.214 ms 30 /modules/tig_cookies/src/ApmTools/ApmLibs.php:515
229
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "nappybabyprofile" LIMIT 1
0.212 ms 1 /classes/module/Module.php:2778
121
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
0.211 ms 1 /classes/module/Module.php:2267
143
SELECT SQL_NO_CACHE *
FROM `np_product` a
LEFT JOIN `np_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7397) LIMIT 1
0.208 ms 1 /src/Adapter/EntityMapper.php:54
76
SELECT SQL_NO_CACHE *
FROM `np_country` a
LEFT JOIN `np_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.203 ms 1 /src/Adapter/EntityMapper.php:54
71
SELECT SQL_NO_CACHE * FROM `np_image_type` WHERE 1 AND `suppliers` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.200 ms 8 Yes /classes/ImageType.php:89
21
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "pagesnotfound" LIMIT 1
0.198 ms 1 /classes/module/Module.php:2778
123
SELECT SQL_NO_CACHE qdrf.*
FROM `np_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.193 ms 3 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRuleFamily.php:75
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM np_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.192 ms 1 /classes/shop/ShopUrl.php:158
78
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM np_required_field
0.191 ms 4 /classes/ObjectModel.php:1443
72
SELECT SQL_NO_CACHE * FROM `np_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.190 ms 8 Yes /classes/ImageType.php:89
24
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 157 AND `id_shop` = 1 LIMIT 1
0.189 ms 1 /classes/module/Module.php:2267
97
SHOW INDEX FROM np_correos_oficial_codes WHERE Key_name = 'company';
0.189 ms 1 /modules/correosoficial/upgrade/multicliente.php:11
70
SELECT SQL_NO_CACHE * FROM `np_image_type` WHERE 1 AND `manufacturers` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.188 ms 8 Yes /classes/ImageType.php:89
133
SELECT SQL_NO_CACHE *
FROM `np_category` a
LEFT JOIN `np_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `np_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1033) AND (b.`id_shop` = 1) LIMIT 1
0.188 ms 1 /src/Adapter/EntityMapper.php:54
79
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ps_facebook" LIMIT 1
0.186 ms 1 /classes/module/Module.php:2778
83
SELECT SQL_NO_CACHE `id_configuration`
FROM `np_configuration`
WHERE name = 'PS_ACCOUNTS_SHOP_STATUS'
AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1
0.181 ms 1 /classes/Configuration.php:115
44
SELECT SQL_NO_CACHE * FROM `np_currency` c ORDER BY `iso_code` ASC
0.180 ms 1 Yes /classes/Currency.php:688
47
SELECT SQL_NO_CACHE *
FROM `np_currency` a
LEFT JOIN `np_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `np_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.179 ms 1 /src/Adapter/EntityMapper.php:54
197
SELECT SQL_NO_CACHE `id_design`
FROM `np_tig_elementor_promos_design`
WHERE `active` = 1
AND `status` = "published"
AND `hook_name` = "displayFooterBefore"
AND (`date_start` IS NULL OR `date_start` = "0000-00-00 00:00:00" OR `date_start` <= "2026-09-21 23:39:40")
AND (`date_end` IS NULL OR `date_end` = "0000-00-00 00:00:00" OR `date_end` >= "2026-09-21 23:39:40")
ORDER BY `priority` DESC, `id_design` DESC
0.178 ms 1 /modules/tig_elementor_promos/tig_elementor_promos.php:669
23
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "lgseoredirect" LIMIT 1
0.178 ms 1 /classes/module/Module.php:2778
94
SELECT SQL_NO_CACHE count(name) as c FROM np_correos_oficial_configuration WHERE name='ShowShippingStatusProcess' LIMIT 1
0.175 ms 1 /modules/correosoficial/correosoficial.php:116
77
SELECT SQL_NO_CACHE *
FROM `np_country_lang`
WHERE `id_country` = 6
0.174 ms 1 /src/Adapter/EntityMapper.php:62
131
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `np_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 1033 LIMIT 1
0.172 ms 0 /classes/Category.php:1376
187
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `np_quantity_discount_rule` qdr
INNER JOIN `np_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `np_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayTop')
INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 3
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.172 ms 1 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:310
194
SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `np_cart_product`
WHERE `id_cart` = 0 LIMIT 1
0.171 ms 1 /classes/Cart.php:1389
144
SELECT SQL_NO_CACHE *
FROM `np_product_lang`
WHERE `id_product` = 7397 AND `id_shop` = 1
0.170 ms 2 /src/Adapter/EntityMapper.php:62
57
SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group FROM np_shop s
0.168 ms 1 /classes/shop/Shop.php:902
174
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `np_quantity_discount_rule` qdr
LEFT JOIN `np_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
WHERE qdr.`active` = 1 AND `id_family` = 2 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.167 ms 140 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:261
82
SELECT SQL_NO_CACHE value FROM `np_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.165 ms 1 /modules/ps_accounts/src/Adapter/Configuration.php:278
66
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "gsnippetsreviews" LIMIT 1
0.165 ms 1 /classes/module/Module.php:2778
130
SELECT SQL_NO_CACHE *
FROM `np_product_lang`
WHERE `id_product` = 5908 AND `id_shop` = 1
0.164 ms 2 /src/Adapter/EntityMapper.php:62
134
SELECT SQL_NO_CACHE cp.id_criteria_product
FROM `np_bt_spr_criteria_product` cp
WHERE (cp.`id_review` = 132) AND (cp.`id_shop` = 1)
0.162 ms 1 /modules/gsnippetsreviews/models/CriteriaProduct.php:53
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM np_shop s
LEFT JOIN np_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.161 ms 1 /classes/shop/Shop.php:195
122
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `np_currency` c
LEFT JOIN np_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.161 ms 1 /classes/Currency.php:1100
38
SELECT SQL_NO_CACHE `type`
FROM `np_tigcookie_module_especial`
WHERE `id_shop` = 1
AND `name` = "Google consent Remarketing"
ORDER BY `id_tigcookie_module_especial` DESC LIMIT 1
0.159 ms 1 /modules/tig_cookies/tig_cookies.php:367
64
SELECT SQL_NO_CACHE * FROM np_hook_module
WHERE `id_hook` = 590
AND `id_module` = 132
AND `id_shop` = 1
0.159 ms 1 /classes/Hook.php:562
147
SELECT SQL_NO_CACHE *
FROM `np_category` a
LEFT JOIN `np_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `np_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 963) AND (b.`id_shop` = 1) LIMIT 1
0.157 ms 1 /src/Adapter/EntityMapper.php:54
33
SELECT SQL_NO_CACHE id_TIGCOOKIES_type as id, condicion FROM np_TIGCOOKIES_type WHERE id_shop = 1
0.155 ms 4 /modules/tig_cookies/src/Classes/UsersConfig.php:293
98
UPDATE `np_module` SET `version` = '1.4.0' WHERE name="correosoficial"
0.155 ms 1 /modules/correosoficial/correosoficial.php:169
60
SELECT SQL_NO_CACHE * FROM np_hook_module
WHERE `id_hook` = 40
AND `id_module` = 132
AND `id_shop` = 1
0.154 ms 1 /classes/Hook.php:562
142
SELECT SQL_NO_CACHE *
FROM `np_customer` a
WHERE (a.`id_customer` = 123652) LIMIT 1
0.153 ms 1 /src/Adapter/EntityMapper.php:54
157
SELECT SQL_NO_CACHE *
FROM `np_product_lang`
WHERE `id_product` = 5920 AND `id_shop` = 1
0.153 ms 2 /src/Adapter/EntityMapper.php:62
177
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang` WHERE `iso_code` = 'en' LIMIT 1
0.153 ms 2 /classes/Language.php:824
104
SELECT SQL_NO_CACHE qdr.`id_quantity_discount_rule`, qdrc.`id_quantity_discount_rule_condition`
FROM `np_quantity_discount_rule` qdr
INNER JOIN  `np_quantity_discount_rule_condition` qdrc ON (qdr.`id_quantity_discount_rule` = qdrc.`id_quantity_discount_rule`)
WHERE qdrc.`id_type` = 27 AND qdr.`id_shop` = 1
0.152 ms 39 /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:279
84
SELECT SQL_NO_CACHE *
FROM `np_configuration` a
WHERE (a.`id_configuration` = 1318) LIMIT 1
0.152 ms 1 /src/Adapter/EntityMapper.php:54
89
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1
0.152 ms 1 /classes/module/Module.php:2267
73
SELECT SQL_NO_CACHE * FROM `np_image_type` WHERE 1 AND `stores` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.150 ms 8 Yes /classes/ImageType.php:89
7
SELECT SQL_NO_CACHE *
FROM `np_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.150 ms 1 /src/Adapter/EntityMapper.php:54
58
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ps_accounts" LIMIT 1
0.150 ms 1 /src/Adapter/Module/ModuleDataProvider.php:231
86
SELECT SQL_NO_CACHE * FROM np_revslider_sliders
0.150 ms 1 /modules/revsliderprestashop/includes/revslider_db.class.php:214
102
SELECT SQL_NO_CACHE * FROM np_tigcookie_module_especial WHERE id_shop = 1
0.150 ms 3 /modules/tig_cookies/src/Classes/ModulesEspecial.php:118
138
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 132) AND (svr.`vote` = 1) AND (svr.`id_shop` = 1)
0.150 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:65
175
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `np_quantity_discount_rule` qdr
LEFT JOIN `np_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
WHERE qdr.`active` = 1 AND `id_family` = 3 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.150 ms 140 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:261
214
SELECT SQL_NO_CACHE data
FROM `np_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
0.148 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:39
217
SELECT SQL_NO_CACHE id_page_type
FROM np_page_type
WHERE name = 'index' LIMIT 1
0.148 ms 1 /classes/Page.php:80
14
SELECT SQL_NO_CACHE `name`, `alias` FROM `np_hook_alias`
0.146 ms 86 /classes/Hook.php:312
3
SELECT SQL_NO_CACHE *
FROM `np_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.146 ms 1 /src/Adapter/EntityMapper.php:54
125
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `np_quantity_discount_rule` qdr
INNER JOIN `np_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `np_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayHome')
INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 2
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.145 ms 1 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:310
36
SELECT SQL_NO_CACHE id_TIGCOOKIES_type as id FROM np_TIGCOOKIES_type WHERE `condicion` = 1 AND id_shop = 1
0.144 ms 4 /modules/tig_cookies/src/Classes/TypesCookie.php:110
225
SELECT SQL_NO_CACHE t1.`id_tigcookies` as `id_tigcookies`,  t1.`active` as `active`,  t1.`cookie` as `cookie`,  t1.`type` as `type`,  t2.`description` as `description`,  t1.`provider` as `provider`,  t2.`expiration` as `expiration`,  t1.`id_shop` as `id_shop`,  t2.id_lang as id_lang  FROM `np_tig_cookies` t1 INNER JOIN np_tig_cookies_lang t2 on  t2.id_tig_cookies= t1.id_tigcookies WHERE  ( id_lang= 1 AND t1.type = 2 AND t1.active = 1 ) AND t1.id_shop = 1
0.144 ms 30 /modules/tig_cookies/src/ApmTools/ApmLibs.php:515
209
SELECT SQL_NO_CACHE *
FROM `np_cart_rule` a
WHERE (a.`id_cart_rule` = 589250) LIMIT 1
0.142 ms 1 /src/Adapter/EntityMapper.php:54
230
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 144 AND `id_shop` = 1 LIMIT 1
0.142 ms 1 /classes/module/Module.php:2267
28
SELECT SQL_NO_CACHE * FROM `np_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.141 ms 1 /classes/module/Module.php:2168
75
SELECT SQL_NO_CACHE `need_identification_number`
FROM `np_country`
WHERE `id_country` = 6 LIMIT 1
0.141 ms 1 /classes/Country.php:386
199
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.141 ms 1 /src/Adapter/EntityMapper.php:54
136
SELECT SQL_NO_CACHE * FROM `np_image_shop` image_shop
WHERE image_shop.`id_product` = 5908
AND image_shop.`cover`= 1 LIMIT 1
0.137 ms 5 /classes/Image.php:374
189
SELECT SQL_NO_CACHE id_lang FROM `np_lang` WHERE is_rtl=0 AND active=1 LIMIT 1
0.135 ms 2 /modules/tig_megamenu/classes/MM_Obj.php:499
34
SELECT SQL_NO_CACHE cookie FROM np_tig_cookies WHERE type IN (2,3,4) AND id_shop = 1
0.135 ms 30 /modules/tig_cookies/src/Classes/UsersConfig.php:309
161
SELECT SQL_NO_CACHE *
FROM `np_bt_spr_report_reviews` srr
WHERE (srr.`id_review` = 125) AND (srr.`id_customer` = 0) AND (srr.`id_shop` = 1) LIMIT 1
0.135 ms 1 /modules/gsnippetsreviews/models/ReviewReport.php:49
88
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
0.134 ms 1 /classes/module/Module.php:2778
126
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `np_quantity_discount_rule` qdr
INNER JOIN `np_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `np_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayHome')
INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 3
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.133 ms 1 Yes /modules/tig_quantitydiscount/classes/QuantityDiscountRule.php:310
213
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 104 AND `id_shop` = 1 LIMIT 1
0.133 ms 1 /classes/module/Module.php:2267
37
SELECT SQL_NO_CACHE id_module as id FROM np_tigcookie_module WHERE  type IN (2,3,4) AND  type NOT IN (1)
0.131 ms 1 /modules/tig_cookies/src/Classes/ModulesCookie.php:143
206
SELECT SQL_NO_CACHE *
FROM `np_group` a
LEFT JOIN `np_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 5) LIMIT 1
0.130 ms 1 /src/Adapter/EntityMapper.php:54
192
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "iqitwishlist" LIMIT 1
0.129 ms 1 /classes/module/Module.php:2778
180
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "iqitsearch" LIMIT 1
0.128 ms 1 /classes/module/Module.php:2778
221
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "tig_cookies" LIMIT 1
0.128 ms 1 /classes/module/Module.php:2778
132
SELECT SQL_NO_CACHE product_shop.`id_category_default`
FROM `np_product` p
INNER JOIN np_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.`id_product` = 5908 LIMIT 1
0.126 ms 1 /classes/Product.php:7554
201
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 18) AND (b.`id_shop` = 1) LIMIT 1
0.126 ms 1 /src/Adapter/EntityMapper.php:54
146
SELECT SQL_NO_CACHE product_shop.`id_category_default`
FROM `np_product` p
INNER JOIN np_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.`id_product` = 7397 LIMIT 1
0.125 ms 1 /classes/Product.php:7554
202
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.125 ms 1 /src/Adapter/EntityMapper.php:54
155
SELECT SQL_NO_CACHE *
FROM `np_customer` a
WHERE (a.`id_customer` = 94214) LIMIT 1
0.124 ms 1 /src/Adapter/EntityMapper.php:54
74
SELECT SQL_NO_CACHE format
FROM `np_address_format`
WHERE `id_country` = 6 LIMIT 1
0.123 ms 1 /classes/AddressFormat.php:629
110
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "bestkit_opc" LIMIT 1
0.123 ms 0 /classes/module/Module.php:2778
135
SELECT SQL_NO_CACHE * FROM `np_image_type`
0.123 ms 8 /classes/ImageType.php:141
145
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `np_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 963 LIMIT 1
0.123 ms 0 /classes/Category.php:1376
105
SELECT SQL_NO_CACHE *
FROM `np_fbpsc_connector_position` fcp
0.122 ms 5 /modules/tig_loginsocial/models/connectorPosition.php:167
52
SELECT SQL_NO_CACHE *
FROM `np_group` a
LEFT JOIN `np_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.121 ms 1 /src/Adapter/EntityMapper.php:54
150
SELECT SQL_NO_CACHE *
FROM `np_bt_spr_report_reviews` srr
WHERE (srr.`id_review` = 126) AND (srr.`id_customer` = 0) AND (srr.`id_shop` = 1) LIMIT 1
0.120 ms 1 /modules/gsnippetsreviews/models/ReviewReport.php:49
181
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 94 AND `id_shop` = 1 LIMIT 1
0.120 ms 0 /classes/module/Module.php:2267
166
SELECT SQL_NO_CACHE id_review,customer_name,verified_buyer FROM `np_nappy_review_origin`
0.117 ms 117 /modules/gsnippetsreviews/src/ReviewsUtils.php:939
226
SELECT SQL_NO_CACHE t1.`id_tigcookies` as `id_tigcookies`,  t1.`active` as `active`,  t1.`cookie` as `cookie`,  t1.`type` as `type`,  t2.`description` as `description`,  t1.`provider` as `provider`,  t2.`expiration` as `expiration`,  t1.`id_shop` as `id_shop`,  t2.id_lang as id_lang  FROM `np_tig_cookies` t1 INNER JOIN np_tig_cookies_lang t2 on  t2.id_tig_cookies= t1.id_tigcookies WHERE  ( id_lang= 1 AND t1.type = 3 AND t1.active = 1 ) AND t1.id_shop = 1
0.116 ms 30 /modules/tig_cookies/src/ApmTools/ApmLibs.php:515
200
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.116 ms 1 /src/Adapter/EntityMapper.php:54
193
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
0.115 ms 1 /classes/module/Module.php:2267
22
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 34 AND `id_shop` = 1 LIMIT 1
0.115 ms 1 /classes/module/Module.php:2267
45
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.115 ms 2 /classes/Language.php:850
149
SELECT SQL_NO_CACHE * FROM `np_image_shop` image_shop
WHERE image_shop.`id_product` = 7397
AND image_shop.`cover`= 1 LIMIT 1
0.114 ms 3 /classes/Image.php:374
158
SELECT SQL_NO_CACHE product_shop.`id_category_default`
FROM `np_product` p
INNER JOIN np_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.`id_product` = 5920 LIMIT 1
0.113 ms 1 /classes/Product.php:7554
137
SELECT SQL_NO_CACHE *
FROM `np_bt_spr_report_reviews` srr
WHERE (srr.`id_review` = 132) AND (srr.`id_customer` = 0) AND (srr.`id_shop` = 1) LIMIT 1
0.112 ms 1 /modules/gsnippetsreviews/models/ReviewReport.php:49
164
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 125) AND (svr.`id_customer` = 0) AND (svr.`vote` = 1) AND (svr.`id_shop` = 1) LIMIT 1
0.112 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:80
203
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 28) AND (b.`id_shop` = 1) LIMIT 1
0.111 ms 1 /src/Adapter/EntityMapper.php:54
218
SELECT SQL_NO_CACHE `id_page`
FROM `np_page`
WHERE `id_page_type` = 1 LIMIT 1
0.110 ms 1 /classes/Page.php:63
35
SELECT SQL_NO_CACHE cookie as c FROM np_tig_cookies WHERE type IN (2,3,4)
0.108 ms 30 /modules/tig_cookies/tig_cookies.php:883
95
SELECT SQL_NO_CACHE count(name) as c FROM np_correos_oficial_products WHERE codigoProducto='44' LIMIT 1
0.108 ms 25 /modules/correosoficial/correosoficial.php:124
120
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "iqitelementor" LIMIT 1
0.107 ms 1 /classes/module/Module.php:2778
49
SELECT SQL_NO_CACHE *
FROM `np_currency` a
LEFT JOIN `np_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.106 ms 1 /src/Adapter/EntityMapper.php:54
210
SELECT SQL_NO_CACHE *
FROM `np_cart_rule_lang`
WHERE `id_cart_rule` = 589250
0.106 ms 2 /src/Adapter/EntityMapper.php:62
195
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "iqitfreedeliverycount" LIMIT 1
0.106 ms 1 /classes/module/Module.php:2778
222
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 117 AND `id_shop` = 1 LIMIT 1
0.105 ms 1 /classes/module/Module.php:2267
196
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
0.104 ms 1 /classes/module/Module.php:2267
46
SELECT SQL_NO_CACHE c.id_currency
FROM `np_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.103 ms 1 /classes/Currency.php:873
106
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang` WHERE `iso_code` = 'en' LIMIT 1
0.103 ms 2 /classes/Language.php:824
204
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.103 ms 1 /src/Adapter/EntityMapper.php:54
205
SELECT SQL_NO_CACHE *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 25) AND (b.`id_shop` = 1) LIMIT 1
0.103 ms 1 /src/Adapter/EntityMapper.php:54
227
SELECT SQL_NO_CACHE t1.`id_tigcookies` as `id_tigcookies`,  t1.`active` as `active`,  t1.`cookie` as `cookie`,  t1.`type` as `type`,  t2.`description` as `description`,  t1.`provider` as `provider`,  t2.`expiration` as `expiration`,  t1.`id_shop` as `id_shop`,  t2.id_lang as id_lang  FROM `np_tig_cookies` t1 INNER JOIN np_tig_cookies_lang t2 on  t2.id_tig_cookies= t1.id_tigcookies WHERE  ( id_lang= 1 AND t1.type = 4 AND t1.active = 1 ) AND t1.id_shop = 1
0.103 ms 30 /modules/tig_cookies/src/ApmTools/ApmLibs.php:515
160
SELECT SQL_NO_CACHE * FROM `np_image_shop` image_shop
WHERE image_shop.`id_product` = 5920
AND image_shop.`cover`= 1 LIMIT 1
0.102 ms 5 /classes/Image.php:374
207
SELECT SQL_NO_CACHE *
FROM `np_group_lang`
WHERE `id_group` = 5
0.101 ms 2 /src/Adapter/EntityMapper.php:62
148
SELECT SQL_NO_CACHE cp.id_criteria_product
FROM `np_bt_spr_criteria_product` cp
WHERE (cp.`id_review` = 126) AND (cp.`id_shop` = 1)
0.099 ms 1 /modules/gsnippetsreviews/models/CriteriaProduct.php:53
80
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 50 AND `id_shop` = 1 LIMIT 1
0.099 ms 1 /classes/module/Module.php:2267
62
SELECT SQL_NO_CACHE * FROM np_hook_module
WHERE `id_hook` = 7
AND `id_module` = 132
AND `id_shop` = 1
0.094 ms 1 /classes/Hook.php:562
67
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 158 AND `id_shop` = 1 LIMIT 1
0.093 ms 1 /classes/module/Module.php:2267
178
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang` WHERE `iso_code` = 'fr' LIMIT 1
0.093 ms 2 /classes/Language.php:824
48
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.091 ms 2 /classes/Language.php:850
61
SELECT SQL_NO_CACHE * FROM np_hook_module
WHERE `id_hook` = 70
AND `id_module` = 132
AND `id_shop` = 1
0.091 ms 1 /classes/Hook.php:562
139
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 132) AND (svr.`vote` = 0) AND (svr.`id_shop` = 1)
0.091 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:65
190
SELECT SQL_NO_CACHE id_lang FROM `np_lang` WHERE is_rtl=1 AND active=1 LIMIT 1
0.091 ms 2 /modules/tig_megamenu/classes/MM_Obj.php:499
182
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ps_mainmenu" LIMIT 1
0.090 ms 1 /classes/module/Module.php:2778
211
SELECT SQL_NO_CACHE `id_group` FROM `np_cart_rule_group`
WHERE `id_cart_rule` = 589250
0.090 ms 1 /modules/tig_exitpopup/tig_exitpopup.php:437
53
SELECT SQL_NO_CACHE *
FROM `np_group_lang`
WHERE `id_group` = 1
0.089 ms 2 /src/Adapter/EntityMapper.php:62
81
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ps_accounts" LIMIT 1
0.089 ms 1 /src/Adapter/Module/ModuleDataProvider.php:231
85
SELECT SQL_NO_CACHE *
FROM `np_configuration_lang`
WHERE `id_configuration` = 1318
0.089 ms 1 /src/Adapter/EntityMapper.php:62
140
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 132) AND (svr.`id_customer` = 0) AND (svr.`vote` = 1) AND (svr.`id_shop` = 1) LIMIT 1
0.089 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:80
63
SELECT SQL_NO_CACHE * FROM np_hook_module
WHERE `id_hook` = 586
AND `id_module` = 132
AND `id_shop` = 1
0.088 ms 1 /classes/Hook.php:562
162
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 125) AND (svr.`vote` = 1) AND (svr.`id_shop` = 1)
0.088 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:65
159
SELECT SQL_NO_CACHE cp.id_criteria_product
FROM `np_bt_spr_criteria_product` cp
WHERE (cp.`id_review` = 125) AND (cp.`id_shop` = 1)
0.087 ms 1 /modules/gsnippetsreviews/models/CriteriaProduct.php:53
50
SELECT SQL_NO_CACHE *
FROM `np_currency_lang`
WHERE `id_currency` = 1
0.086 ms 1 /src/Adapter/EntityMapper.php:62
90
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ps_searchbar" LIMIT 1
0.083 ms 1 /classes/module/Module.php:2778
183
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
0.082 ms 1 /classes/module/Module.php:2267
151
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 126) AND (svr.`vote` = 1) AND (svr.`id_shop` = 1)
0.082 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:65
141
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 132) AND (svr.`id_customer` = 0) AND (svr.`vote` = 0) AND (svr.`id_shop` = 1) LIMIT 1
0.079 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:80
179
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang` WHERE `iso_code` = 'it' LIMIT 1
0.079 ms 2 /classes/Language.php:824
152
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 126) AND (svr.`vote` = 0) AND (svr.`id_shop` = 1)
0.079 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:65
111
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.078 ms 0 /classes/module/Module.php:2267
115
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.078 ms 0 /classes/module/Module.php:2267
9
SELECT SQL_NO_CACHE id_shop
FROM `np_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.077 ms 1 /classes/ObjectModel.php:1576
165
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 125) AND (svr.`id_customer` = 0) AND (svr.`vote` = 0) AND (svr.`id_shop` = 1) LIMIT 1
0.076 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:80
153
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 126) AND (svr.`id_customer` = 0) AND (svr.`vote` = 1) AND (svr.`id_shop` = 1) LIMIT 1
0.075 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:80
163
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 125) AND (svr.`vote` = 0) AND (svr.`id_shop` = 1)
0.074 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:65
51
SELECT SQL_NO_CACHE id_shop
FROM `np_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.072 ms 1 /classes/ObjectModel.php:1576
55
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "tig_quantitydiscount" LIMIT 1
0.072 ms 1 /classes/module/Module.php:2778
154
SELECT SQL_NO_CACHE id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = 126) AND (svr.`id_customer` = 0) AND (svr.`vote` = 0) AND (svr.`id_shop` = 1) LIMIT 1
0.071 ms 1 /modules/gsnippetsreviews/models/ReviewVote.php:80
54
SELECT SQL_NO_CACHE id_shop
FROM `np_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.070 ms 1 /classes/ObjectModel.php:1576
91
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
0.068 ms 0 /classes/module/Module.php:2267
112
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "onepagecheckoutps" LIMIT 1
0.068 ms 0 /classes/module/Module.php:2778
56
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 137 AND `id_shop` = 1 LIMIT 1
0.068 ms 1 /classes/module/Module.php:2267
118
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "pm_repairabilityscore" LIMIT 1
0.068 ms 0 /classes/module/Module.php:2778
113
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.067 ms 0 /classes/module/Module.php:2267
117
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.067 ms 0 /classes/module/Module.php:2267
92
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ps_customersignin" LIMIT 1
0.064 ms 1 /classes/module/Module.php:2778
96
SELECT SQL_NO_CACHE count(name) as c FROM np_correos_oficial_configuration WHERE name='GDPR' LIMIT 1
0.064 ms 1 /modules/correosoficial/correosoficial.php:145
93
SELECT SQL_NO_CACHE `id_module` FROM `np_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1
0.061 ms 1 /classes/module/Module.php:2267
107
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang` WHERE `iso_code` = 'fr' LIMIT 1
0.058 ms 2 /classes/Language.php:824
114
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "steasycheckout" LIMIT 1
0.057 ms 0 /classes/module/Module.php:2778
116
SELECT SQL_NO_CACHE `id_module` FROM `np_module` WHERE `name` = "ets_onepagecheckout" LIMIT 1
0.056 ms 0 /classes/module/Module.php:2778
108
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang` WHERE `iso_code` = 'it' LIMIT 1
0.054 ms 2 /classes/Language.php:824
109
SELECT SQL_NO_CACHE `id_lang` FROM `np_lang` WHERE `iso_code` = 'es' LIMIT 1
0.054 ms 2 /classes/Language.php:824

Doubles

20 queries
SELECT `id_module` FROM `np_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries
                SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
                FROM `np_module` m
                LEFT JOIN `np_module_shop` ms
                ON m.`id_module` = ms.`id_module`
                AND ms.`id_shop` = XX
8 queries
SELECT *
FROM `np_cms` a
LEFT JOIN `np_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX
LEFT JOIN `np_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX
WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
6 queries
SELECT id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = XX) AND (svr.`vote` = XX) AND (svr.`id_shop` = XX)
6 queries
SELECT id_vote
FROM `np_bt_spr_vote_reviews` svr
WHERE (svr.`id_review` = XX) AND (svr.`id_customer` = XX) AND (svr.`vote` = XX) AND (svr.`id_shop` = XX) LIMIT XX
5 queries
SELECT * FROM np_hook_module
                  WHERE `id_hook` = XX
                  AND `id_module` = XX
                  AND `id_shop` = XX
4 queries
SELECT  tXX.`id_tigcookies` as `id_tigcookies`,  tXX.`active` as `active`,  tXX.`cookie` as `cookie`,  tXX.`type` as `type`,  tXX.`description` as `description`,  tXX.`provider` as `provider`,  tXX.`expiration` as `expiration`,  tXX.`id_shop` as `id_shop`,  tXX.id_lang as id_lang  FROM `np_tig_cookies` tXX INNER JOIN np_tig_cookies_lang tXX on  tXX.id_tig_cookies= tXX.id_tigcookies WHERE  ( id_lang= XX AND tXX.type = XX AND tXX.active = XX ) AND tXX.id_shop = XX
3 queries
SELECT * FROM np_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/" OR CONCAT("", url_old) LIKE BINARY "/#%") AND id_shop = "XX" ORDER BY id DESC LIMIT XX
3 queries
SELECT qdrf.*
            FROM `np_quantity_discount_rule_family` qdrf
            WHERE XX
                 AND qdrf.active = XX AND qdrf.`id_shop` = XX ORDER BY qdrf.priority ASC;
3 queries
SELECT DISTINCT(qdr.`id_quantity_discount_rule`)
                FROM `np_quantity_discount_rule` qdr
                INNER JOIN `np_quantity_discount_rule_lang` qdrl
                    ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX)
                INNER JOIN `np_quantity_discount_rule_message` qdrm
                    ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayHome')
                INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
                    ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX)
                WHERE qdr.`active` = XX
                    AND qdr.`id_shop` = XX AND `id_family` = XX
                ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
3 queries
SELECT *
FROM `np_product` a
LEFT JOIN `np_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) LIMIT XX
3 queries
SELECT *
							FROM `np_product_lang`
							WHERE `id_product` = XX AND `id_shop` = XX
3 queries
SELECT product_shop.`id_category_default`
            FROM `np_product` p
             INNER JOIN np_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX)
            WHERE p.`id_product` = XX LIMIT XX
3 queries
SELECT cp.id_criteria_product
FROM `np_bt_spr_criteria_product` cp
WHERE (cp.`id_review` = XX) AND (cp.`id_shop` = XX)
3 queries
			SELECT * FROM `np_image_shop` image_shop
			WHERE image_shop.`id_product` = XX
			AND image_shop.`cover`= XX LIMIT XX
3 queries
SELECT *
FROM `np_bt_spr_report_reviews` srr
WHERE (srr.`id_review` = XX) AND (srr.`id_customer` = XX) AND (srr.`id_shop` = XX) LIMIT XX
3 queries
SELECT *, qdrl.`name`, '' as id_customer
                FROM `np_quantity_discount_rule` qdr
                LEFT JOIN `np_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX)
                WHERE qdr.`active` = XX AND `id_family` = XX AND `code` != '' AND `highlight` = XX ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
3 queries
SELECT DISTINCT(qdr.`id_quantity_discount_rule`)
                FROM `np_quantity_discount_rule` qdr
                INNER JOIN `np_quantity_discount_rule_lang` qdrl
                    ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = XX)
                INNER JOIN `np_quantity_discount_rule_message` qdrm
                    ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayTop')
                INNER JOIN `np_quantity_discount_rule_message_lang` qdrml
                    ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = XX)
                WHERE qdr.`active` = XX
                    AND qdr.`id_shop` = XX AND `id_family` = XX
                ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
2 queries
SELECT value FROM `np_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX
2 queries
SELECT `id_lang` FROM `np_lang`
                    WHERE `locale` = 'es-es'
                    OR `language_code` = 'es-es' LIMIT XX
2 queries
SELECT *
FROM `np_group` a
LEFT JOIN `np_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = XX
WHERE (a.`id_group` = XX) LIMIT XX
2 queries
SELECT *
							FROM `np_group_lang`
							WHERE `id_group` = XX
2 queries
SELECT `id_module` FROM `np_module` WHERE `name` = "ps_accounts" LIMIT XX
2 queries
SELECT *
FROM `np_fbpsc_connector_position` fcp
2 queries
SELECT `id_lang` FROM `np_lang` WHERE `iso_code` = 'en' LIMIT XX
2 queries
SELECT `id_lang` FROM `np_lang` WHERE `iso_code` = 'fr' LIMIT XX
2 queries
SELECT `id_lang` FROM `np_lang` WHERE `iso_code` = 'it' LIMIT XX
2 queries
			SELECT cl.`link_rewrite`
			FROM `np_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
2 queries
SELECT *
FROM `np_category` a
LEFT JOIN `np_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `np_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
2 queries
SELECT *
FROM `np_customer` a
WHERE (a.`id_customer` = XX) LIMIT XX
2 queries
SELECT XX FROM `np_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries
SELECT id_lang FROM `np_lang` WHERE is_rtl=XX AND active=XX LIMIT XX

Tables stress

34 module
31 module_shop
14 lang
12 bt_spr_vote_reviews
10 quantity_discount_rule
9 quantity_discount_rule_lang
8 cms
8 cms_lang
8 cms_shop
7 product
7 product_shop
6 hook_module
6 tig_cookies
6 image_type
6 quantity_discount_rule_message
6 quantity_discount_rule_message_lang
6 cart_rule
5 shop
5 configuration
5 hook
5 currency
5 category_lang
4 shop_url
4 lang_shop
4 currency_shop
4 tig_elementor_promos_design
4 category
4 tig_cookies_lang
3 country
3 hook_alias
3 lgseoredirect
3 TIGCOOKIES_type
3 group_shop
3 quantity_discount_rule_family
3 product_lang
3 category_shop
3 bt_spr_criteria_product
3 image_shop
3 bt_spr_report_reviews
3 cart_rule_lang
2 shop_group
2 configuration_lang
2 country_lang
2 country_shop
2 meta
2 meta_lang
2 tigcookie_module_especial
2 currency_lang
2 group
2 group_lang
2 correos_oficial_configuration
2 fbpsc_connector_position
2 customer
2 cart_product
1 module_group
1 hook_module_exceptions
1 tab
1 tigcookie_module
1 address_format
1 required_field
1 revslider_sliders
1 tig_mm_block
1 correos_oficial_products
1 correos_oficial_codes
1 correos_oficial_saved_orders
1 correos_oficial_saved_returns
1 af_templates
1 af_templates_lang
1 quantity_discount_rule_condition
1 order_state
1 order_state_lang
1 bt_spr_products_reviews
1 nappy_review_origin
1 tig_mm_secondary_nav
1 tig_mm_secondary_nav_shop
1 tig_mm_secondary_nav_lang
1 cart_rule_group
1 ganalytics_data
1 connections
1 page_type
1 page
1 TIGCOOKIES_type_lang

ObjectModel instances

Name Instances Source
CMS 26 /classes/Link.php:1570 (__construct) [id: 2]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 1]
/classes/Link.php:1570 (__construct) [id: 18]
/classes/Link.php:1570 (__construct) [id: 4]
/classes/Link.php:1570 (__construct) [id: 2]
/classes/Link.php:1570 (__construct) [id: 18]
/classes/Link.php:1570 (__construct) [id: 28]
/classes/Link.php:1570 (__construct) [id: 3]
/classes/Link.php:1570 (__construct) [id: 2]
/classes/Link.php:1570 (__construct) [id: 1]
/classes/Link.php:1570 (__construct) [id: 2]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 25]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 5]
/classes/Link.php:1570 (__construct) [id: 1]
/classes/Link.php:1570 (__construct) [id: 3]
/classes/Link.php:1570 (__construct) [id: 18]
/classes/Link.php:1570 (__construct) [id: 28]
/classes/Link.php:1570 (__construct) [id: 2]
/classes/Link.php:554 (__construct) [id: 28]
PrestaShop\Module\TigCookies\Classes\CookieDescription 4 /modules/tig_cookies/src/ApmTools/ApmLibs.php:116 (__construct) [id: ]
/modules/tig_cookies/src/ApmTools/ApmLibs.php:116 (__construct) [id: ]
/modules/tig_cookies/src/ApmTools/ApmLibs.php:116 (__construct) [id: ]
/modules/tig_cookies/src/ApmTools/ApmLibs.php:116 (__construct) [id: ]
Country 4 /config/config.inc.php:135 (__construct) [id: 6]
/classes/controller/FrontController.php:306 (__construct) [id: 6]
/classes/AddressFormat.php:382 (__construct) [id: 6]
/classes/controller/FrontController.php:1750 (__construct) [id: 6]
Customer 4 /config/config.inc.php:253 (__construct) [id: ]
/modules/gsnippetsreviews/src/ReviewsUtils.php:124 (__construct) [id: 0]
/modules/gsnippetsreviews/src/ReviewsUtils.php:124 (__construct) [id: 123652]
/modules/gsnippetsreviews/src/ReviewsUtils.php:124 (__construct) [id: 94214]
Category 3 /modules/gsnippetsreviews/src/ReviewsUtils.php:126 (__construct) [id: 1033]
/modules/gsnippetsreviews/src/ReviewsUtils.php:126 (__construct) [id: 963]
/modules/gsnippetsreviews/src/ReviewsUtils.php:126 (__construct) [id: 1033]
QuantityDiscountRule 3 /override/classes/CartRule.php:38 (__construct) [id: ]
/override/classes/CartRule.php:53 (__construct) [id: ]
/override/classes/CartRule.php:113 (__construct) [id: ]
Product 3 /modules/gsnippetsreviews/src/ReviewsUtils.php:125 (__construct) [id: 5908]
/modules/gsnippetsreviews/src/ReviewsUtils.php:125 (__construct) [id: 7397]
/modules/gsnippetsreviews/src/ReviewsUtils.php:125 (__construct) [id: 5920]
Currency 2 /src/Adapter/Currency/CurrencyDataProvider.php:81 (__construct) [id: 1]
/classes/Tools.php:693 (getCurrencyInstance) [id: 1]
PrestaShop\Module\TigCookies\Classes\UsersConfig 2 /modules/tig_cookies/src/ApmTools/ApmLibs.php:116 (__construct) [id: ]
/modules/tig_cookies/src/ApmTools/ApmLibs.php:116 (__construct) [id: ]
Language 2 /config/config.inc.php:200 (__construct) [id: 1]
/classes/Tools.php:533 (__construct) [id: 1]
State 2 /classes/AddressFormat.php:382 (__construct) [id: 0]
/classes/controller/FrontController.php:1749 (__construct) [id: 0]
Group 2 /classes/Cart.php:262 (getCurrent) [id: 1]
/modules/tig_exitpopup/tig_exitpopup.php:383 (__construct) [id: 5]
ConnectionsSource 1 /modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
Connection 1 /modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest 1 /modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
CartRule 1 /modules/tig_exitpopup/tig_exitpopup.php:432 (__construct) [id: 589250]
PrestaShop\Module\TigCookies\Classes\TypesCookie 1 /modules/tig_cookies/src/ApmTools/ApmLibs.php:116 (__construct) [id: ]
Shop 1 /config/config.inc.php:103 (initialize) [id: 1]
Configuration 1 /modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 1318]
AddressFormat 1 /classes/controller/FrontController.php:1744 (generateAddress) [id: ]
Risk 1 /classes/controller/FrontController.php:1670 (__construct) [id: ]
Gender 1 /classes/controller/FrontController.php:1667 (__construct) [id: 0]
Cart 1 /classes/controller/FrontController.php:441 (__construct) [id: ]
ShopGroup 1 /classes/shop/Shop.php:542 (__construct) [id: 1]
Address 1 /classes/shop/Shop.php:467 (__construct) [id: ]