“La información contenida en este mensaje y/o archivo(s) adjunto(s), enviada desde NEW SPEED SL, es confidencial/privilegiada y está destinada a ser leída sólo por la(s) persona(s) a la(s) que va dirigida. Le recordamos que sus datos han sido incorporados en el sistema de tratamiento de NEW SPEED SL y que siempre y cuando se cumplan los requisitos exigidos por la normativa, usted podrá ejercer sus derechos de acceso, rectificación, limitación de tratamiento, supresión, portabilidad y oposición/revocación, en los términos que establece la normativa vigente en materia de protección de datos, dirigiendo su petición a la dirección postal C/ MONCADA 7 BJ IZQUIERDA 12005, CASTELLON (CASTELLÓN) o bien a través de correo electrónico "info@newspeed.es" Si usted lee este mensaje y no es el destinatario señalado, el empleado o el agente responsable de entregar el mensaje al destinatario, o ha recibido esta comunicación por error, le informamos que está totalmente prohibida, y puede ser ilegal, cualquier divulgación, distribución o reproducción de esta comunicación, y le rogamos que nos lo notifique inmediatamente y nos devuelva el mensaje original a la dirección arriba mencionada. Gracias”.

Load Time 460.825 ms
Querying Time 66 ms
Queries 237
Memory Peak Usage 45.1 Mb
Included Files 973 files - 10.16 Mb
PrestaShop Cache - Mb
Global vars 0.12 Mb
PrestaShop Version 8.1.7
PHP Version 7.2.34
MySQL Version 10.5.26-MariaDB
Memory Limit 256M
Max Execution Time 2000s
Smarty Cache disabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0.008 ms 0.008 ms 12.90 Mb 13.2 Mb
__construct 16.826 ms 16.834 ms 1.94 Mb 15.6 Mb
init 68.832 ms 85.666 ms 6.73 Mb 22.6 Mb
checkAccess 0.001 ms 85.667 ms - Mb 22.6 Mb
setMedia 5.912 ms 91.579 ms 0.69 Mb 22.6 Mb
postProcess 0.001 ms 91.580 ms - Mb 22.6 Mb
initHeader 0.002 ms 91.582 ms - Mb 22.6 Mb
initContent 128.098 ms 219.680 ms 7.73 Mb 30.1 Mb
initFooter 0.003 ms 219.683 ms - Mb 30.1 Mb
display 241.142 ms 460.825 ms 15.05 Mb 45.1 Mb
Hook Time Memory Usage
displayProductListReviews 68.909 ms 4.62 Mb
displayHeaderTop 53.544 ms 5.84 Mb
displayMainMenu 13.993 ms 0.54 Mb
DisplayBeforeBodyClosingTag 9.992 ms 0.38 Mb
displayFooter 5.939 ms 0.32 Mb
displayNav1 5.346 ms 0.42 Mb
ProductSearchProvider 3.113 ms 0.23 Mb
displayLeftColumn 2.148 ms 0.07 Mb
displayVerticalMenu 2.004 ms 0.14 Mb
DisplayHeader 1.809 ms 0.04 Mb
displayBeforeBodyClosingTag 1.501 ms 0.05 Mb
renderWidget 1.281 ms 0.07 Mb
ActionFrontControllerSetMedia 1.171 ms 0.13 Mb
displayNav2 0.772 ms 0.08 Mb
displayAfterBreadcrumb 0.623 ms 0.03 Mb
IsJustElementor 0.414 ms 0.02 Mb
DisplayLeftColumn 0.336 ms 0.01 Mb
DisplayTop 0.066 ms - Mb
ActionDispatcher 0.013 ms - Mb
ActionProductSearchAfter 0.008 ms - Mb
20 hook(s) 172.982 ms 13.00 Mb
Module Time Memory Usage
iqitthemeeditor 7.866 ms 0.61 Mb
ps_emailsubscription 3.783 ms 0.37 Mb
ps_emailalerts 2.232 ms 0.33 Mb
ps_shoppingcart 0.721 ms 0.05 Mb
productcomments 66.141 ms 4.50 Mb
ps_googleanalytics 3.527 ms 0.18 Mb
iqitcontactpage 2.441 ms 0.14 Mb
iqitcookielaw 2.447 ms 0.12 Mb
iqitelementor 64.626 ms 6.73 Mb
iqitmegamenu 26.005 ms 1.36 Mb
iqitreviews 6.633 ms 0.47 Mb
ps_facetedsearch 9.743 ms 0.63 Mb
iqitlinksmanager 10.778 ms 0.78 Mb
ps_languageselector 0.809 ms 0.07 Mb
ps_currencyselector 0.716 ms 0.07 Mb
iqitsearch 1.775 ms 0.11 Mb
ps_customersignin 0.231 ms 0.02 Mb
pagesnotfound 0.520 ms 0.05 Mb
iqitproductsnav 2.598 ms 0.07 Mb
ps_categorytree 3.124 ms 0.14 Mb
statsdata 8.071 ms 0.31 Mb
21 module(s) 224.788 ms 17.10 Mb

Stopwatch SQL - 237 queries

# Query Time (ms) Rows Filesort Group By Location
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 `psm7_configuration` c
LEFT JOIN `psm7_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2.405 ms 1081 /classes/Configuration.php:180
66
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 `psm7_hook_module` hm
STRAIGHT_JOIN `psm7_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `psm7_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.840 ms 370 /classes/Hook.php:456
65
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `psm7_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `psm7_hook_alias` ha
INNER JOIN `psm7_hook` h ON ha.name = h.name
1.815 ms 0 /classes/Hook.php:1326
13
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `psm7_module` m
INNER JOIN psm7_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `psm7_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `psm7_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `psm7_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.685 ms 144 Yes Yes /classes/Hook.php:1267
54
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psm7_product p LEFT JOIN psm7_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psm7_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psm7_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN psm7_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psm7_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psm7_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psm7_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psm7_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=11 AND c.nright<=12 GROUP BY p.id_product) p INNER JOIN psm7_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC
1.217 ms 77 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
236
INSERT INTO `psm7_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('56828', '', 'www.newspeed.es/14-accesorios', '', '2024-09-15 17:38:52')
1.043 ms 1 /classes/ObjectModel.php:622
12
SELECT SQL_NO_CACHE lower(name) as name
FROM `psm7_hook` h
WHERE (h.active = 1)
1.040 ms 950 /classes/Hook.php:1366
188
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 11 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  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
0.952 ms 2 Yes Yes /classes/Category.php:799
190
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 13 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  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
0.923 ms 2 Yes Yes /classes/Category.php:799
189
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 12 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  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
0.899 ms 3 Yes Yes /classes/Category.php:799
184
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM psm7_iqitmegamenu_tabs_shop hs
LEFT JOIN psm7_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN psm7_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 2
ORDER BY hss.position
0.820 ms 16 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
39
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `psm7_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.786 ms 1 Yes Yes /classes/Category.php:924
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psm7_hook`
0.706 ms 950 /classes/Hook.php:1326
216
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `psm7_category` c
INNER JOIN `psm7_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
INNER JOIN `psm7_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 6
AND nleft >= 11 AND nright <= 12
AND c.id_category IN (
SELECT id_category
FROM `psm7_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
0.703 ms 1 Yes /modules/ps_categorytree/ps_categorytree.php:166
191
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 14 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  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
0.687 ms 1 Yes Yes /classes/Category.php:799
58
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (28,29,30,32,33,75)
0.642 ms 6 /classes/ProductAssembler.php:95
213
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM psm7_iqitmegamenu_tabs_shop hs
LEFT JOIN psm7_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN psm7_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 2 AND active = 1
AND hssl.id_lang = 2
ORDER BY hss.position
0.641 ms 16 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
180
SELECT SQL_NO_CACHE *
FROM `psm7_contact` c
LEFT JOIN psm7_contact_shop contact_shop
ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = 1)
LEFT JOIN `psm7_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
WHERE cl.`id_lang` = 2
AND contact_shop.`id_shop` IN (1)
GROUP BY c.`id_contact`
ORDER BY `name` ASC
0.624 ms 8 Yes Yes /classes/Contact.php:100
202
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (28) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.578 ms 1 Yes Yes /classes/Product.php:4520
206
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (30) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.554 ms 1 Yes Yes /classes/Product.php:4520
204
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (29) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.530 ms 1 Yes Yes /classes/Product.php:4520
194
SELECT SQL_NO_CACHE *
FROM `psm7_currency` c
INNER JOIN psm7_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
0.505 ms 2 Yes /classes/Currency.php:694
131
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 75 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 75 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.504 ms 0 /classes/Cart.php:1426
210
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (33) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.504 ms 1 Yes Yes /classes/Product.php:4520
18
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psm7_module` m
LEFT JOIN `psm7_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.495 ms 93 /classes/module/Module.php:345
11
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psm7_lang` l
JOIN psm7_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.486 ms 1 /classes/Language.php:1216
231
INSERT INTO `psm7_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')
0.483 ms 1 /classes/ObjectModel.php:622
208
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (32) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.478 ms 1 Yes Yes /classes/Product.php:4520
137
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 29
ORDER BY `position`
0.468 ms 1 Yes /classes/Product.php:3545
40
SELECT SQL_NO_CACHE 1 FROM psm7_cart_product cp INNER JOIN psm7_product p
ON (p.id_product = cp.id_product) INNER JOIN psm7_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.450 ms 1 /classes/Cart.php:4243
133
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 28
ORDER BY `position`
0.442 ms 1 Yes /classes/Product.php:3545
141
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 32
ORDER BY `position`
0.419 ms 1 Yes /classes/Product.php:3545
124
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 75) AND (b.`id_shop` = 1) LIMIT 1
0.419 ms 1 /src/Adapter/EntityMapper.php:71
76
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 28 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 28 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.413 ms 0 /classes/Cart.php:1426
20
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) AND (b.`id_shop` = 1) LIMIT 1
0.412 ms 1 /src/Adapter/EntityMapper.php:71
67
SELECT SQL_NO_CACHE tr.*
FROM `psm7_tax_rule` tr
JOIN `psm7_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` = 53
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.410 ms 1 /classes/tax/TaxRulesTaxManager.php:109
57
REPLACE INTO psm7_layered_filter_block (hash, data) VALUES ("b30d0e26b102b269b5d67d1f19c71160", "a:1:{s:7:\"filters\";a:0:{}}")
0.402 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
15
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `psm7_meta` m
LEFT JOIN `psm7_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.401 ms 59 Yes /classes/Dispatcher.php:654
51
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM psm7_layered_category
WHERE controller = 'category'
AND id_category = 14
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.400 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
230
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `psm7_category_product` cp
LEFT JOIN `psm7_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `psm7_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` IN (28,29,30,32,33,75) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
0.399 ms 6 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
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 psm7_shop_group gs
LEFT JOIN psm7_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN psm7_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.395 ms 1 Yes /classes/shop/Shop.php:715
212
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (75) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.394 ms 1 Yes Yes /classes/Product.php:4520
63
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 28)
0.390 ms 1 /classes/Product.php:3860
120
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 33 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 33 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.382 ms 0 /classes/Cart.php:1426
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM psm7_shop_url su
LEFT JOIN psm7_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.newspeed.es' OR su.domain_ssl = 'www.newspeed.es')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.382 ms 1 Yes /classes/shop/Shop.php:1364
62
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 28) AND (b.`id_shop` = 1) LIMIT 1
0.381 ms 1 /src/Adapter/EntityMapper.php:71
232
SELECT SQL_NO_CACHE `id_guest`
FROM `psm7_connections`
WHERE `id_guest` = 58087
AND `date_add` > '2024-09-15 17:08:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.381 ms 1 Yes /classes/Connection.php:168
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM psm7_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.379 ms 1 /classes/shop/ShopUrl.php:182
8
SELECT SQL_NO_CACHE *
FROM `psm7_lang` a
LEFT JOIN `psm7_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
0.379 ms 1 /src/Adapter/EntityMapper.php:71
87
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 29 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 29 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.378 ms 0 /classes/Cart.php:1426
98
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 30 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 30 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.376 ms 0 /classes/Cart.php:1426
109
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 32 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 32 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.374 ms 0 /classes/Cart.php:1426
132
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 75
ORDER BY f.position ASC
0.352 ms 2 Yes /classes/Product.php:6017
235
INSERT INTO `psm7_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('58087', '29', '65790478', '', '1', '1', '2024-09-15 17:38:52')
0.350 ms 1 /classes/ObjectModel.php:622
21
SELECT SQL_NO_CACHE * FROM `psm7_currency` c ORDER BY `iso_code` ASC
0.341 ms 2 Yes /classes/Currency.php:709
143
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 33
ORDER BY `position`
0.339 ms 1 Yes /classes/Product.php:3545
34
SELECT SQL_NO_CACHE *
FROM `psm7_group` a
LEFT JOIN `psm7_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.336 ms 1 /src/Adapter/EntityMapper.php:71
139
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 30
ORDER BY `position`
0.326 ms 1 Yes /classes/Product.php:3545
227
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitcookielaw" LIMIT 1
0.316 ms 1 /classes/module/Module.php:2636
169
SELECT SQL_NO_CACHE *
FROM `psm7_iqit_elementor_content` a
LEFT JOIN `psm7_iqit_elementor_content_lang` `b` ON a.`id_elementor` = b.`id_elementor` AND b.`id_lang` = 2
LEFT JOIN `psm7_iqit_elementor_content_shop` `c` ON a.`id_elementor` = c.`id_elementor` AND c.`id_shop` = 1
WHERE (a.`id_elementor` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.314 ms 1 /src/Adapter/EntityMapper.php:71
37
SELECT SQL_NO_CACHE `id_category`
FROM `psm7_category_shop`
WHERE `id_category` = 14
AND `id_shop` = 1 LIMIT 1
0.310 ms 1 /classes/Category.php:2450
77
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 28
ORDER BY f.position ASC
0.309 ms 2 Yes /classes/Product.php:6017
102
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 32) AND (b.`id_shop` = 1) LIMIT 1
0.302 ms 1 /src/Adapter/EntityMapper.php:71
205
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 30 LIMIT 1
0.299 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `psm7_lang` l
LEFT JOIN `psm7_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.299 ms 1 /classes/Language.php:1080
80
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 29) AND (b.`id_shop` = 1) LIMIT 1
0.299 ms 1 /src/Adapter/EntityMapper.php:71
113
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 33) AND (b.`id_shop` = 1) LIMIT 1
0.297 ms 1 /src/Adapter/EntityMapper.php:71
195
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitproductsnav" LIMIT 1
0.296 ms 1 /classes/module/Module.php:2636
91
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 30) AND (b.`id_shop` = 1) LIMIT 1
0.294 ms 1 /src/Adapter/EntityMapper.php:71
197
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "productcomments" LIMIT 1
0.286 ms 1 /classes/module/Module.php:2636
52
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) LIMIT 1
0.286 ms 1 /src/Adapter/EntityMapper.php:71
147
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
0.284 ms 1 /classes/module/Module.php:2636
49
SELECT SQL_NO_CACHE *
FROM `psm7_category` a0
LEFT JOIN `psm7_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 11) AND (a0.`nright` > 12) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.283 ms 2 Yes /classes/PrestaShopCollection.php:383
110
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 32
ORDER BY f.position ASC
0.281 ms 2 Yes /classes/Product.php:6017
88
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 29
ORDER BY f.position ASC
0.281 ms 2 Yes /classes/Product.php:6017
7
SELECT SQL_NO_CACHE *
FROM `psm7_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.281 ms 1 /src/Adapter/EntityMapper.php:71
121
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 33
ORDER BY f.position ASC
0.277 ms 2 Yes /classes/Product.php:6017
99
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 30
ORDER BY f.position ASC
0.276 ms 2 Yes /classes/Product.php:6017
217
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM psm7_iqit_link_block cb
INNER JOIN psm7_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 45
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
0.274 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
192
SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM psm7_iqitmenulinks l
LEFT JOIN psm7_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 2 AND ll.id_shop=1)
LEFT JOIN psm7_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "1"
AND l.id_shop IN (0, 1)
0.274 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
3
SELECT SQL_NO_CACHE *
FROM `psm7_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.272 ms 1 /src/Adapter/EntityMapper.php:71
125
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 75)
0.270 ms 1 /classes/Product.php:3860
41
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.267 ms 0 /classes/module/Module.php:2636
203
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 29 LIMIT 1
0.263 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
181
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitsearch" LIMIT 1
0.261 ms 1 /classes/module/Module.php:2636
146
SELECT SQL_NO_CACHE c.id_elementor FROM psm7_iqit_elementor_category c WHERE c.id_category = 14 LIMIT 1
0.254 ms 1 /modules/iqitelementor/src/IqitElementorCategory.php:87
50
SELECT SQL_NO_CACHE `id_category`
FROM `psm7_category_shop`
WHERE `id_category` = 14
AND `id_shop` = 1 LIMIT 1
0.252 ms 1 /classes/Category.php:2450
214
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "ps_categorytree" LIMIT 1
0.245 ms 1 /classes/module/Module.php:2636
233
SELECT SQL_NO_CACHE id_page_type
FROM psm7_page_type
WHERE name = 'category' LIMIT 1
0.241 ms 1 /classes/Page.php:104
56
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM psm7_layered_category
WHERE controller = 'category'
AND id_category = 14
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.239 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
6
SELECT SQL_NO_CACHE *
FROM `psm7_country` a
LEFT JOIN `psm7_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `psm7_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.234 ms 1 /src/Adapter/EntityMapper.php:71
25
SELECT SQL_NO_CACHE *
FROM `psm7_currency` a
LEFT JOIN `psm7_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `psm7_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
0.232 ms 1 /src/Adapter/EntityMapper.php:71
185
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) AND (b.`id_shop` = 1) LIMIT 1
0.231 ms 1 /src/Adapter/EntityMapper.php:71
229
SELECT SQL_NO_CACHE data
FROM `psm7_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
0.229 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
122
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 75
AND image_shop.`cover` = 1 LIMIT 1
0.227 ms 1 /classes/Product.php:3570
59
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 28
AND image_shop.`cover` = 1 LIMIT 1
0.226 ms 1 /classes/Product.php:3570
201
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 28 LIMIT 1
0.219 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
154
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.218 ms 2 /classes/Meta.php:193
144
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 75
ORDER BY `position`
0.217 ms 1 Yes /classes/Product.php:3545
207
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 32 LIMIT 1
0.215 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
43
SELECT SQL_NO_CACHE * FROM `psm7_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.215 ms 8 Yes /classes/ImageType.php:109
31
SELECT SQL_NO_CACHE *
FROM `psm7_currency` a
LEFT JOIN `psm7_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
0.213 ms 1 /src/Adapter/EntityMapper.php:71
183
SELECT SQL_NO_CACHE `width`, `height`
FROM psm7_image_type
WHERE `name` = 'small_default' LIMIT 1
0.213 ms 1 /classes/Image.php:563
209
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 33 LIMIT 1
0.211 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
221
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.208 ms 2 /classes/Meta.php:193
234
SELECT SQL_NO_CACHE `id_page`
FROM `psm7_page`
WHERE `id_page_type` = 6 AND `id_object` = 14 LIMIT 1
0.205 ms 2 /classes/Page.php:83
81
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 29)
0.202 ms 1 /classes/Product.php:3860
92
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 30)
0.200 ms 1 /classes/Product.php:3860
103
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 32)
0.198 ms 1 /classes/Product.php:3860
114
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 33)
0.198 ms 1 /classes/Product.php:3860
29
SELECT SQL_NO_CACHE *
FROM `psm7_currency` a
LEFT JOIN `psm7_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `psm7_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.196 ms 1 /src/Adapter/EntityMapper.php:71
14
SELECT SQL_NO_CACHE `name`, `alias` FROM `psm7_hook_alias`
0.194 ms 87 /classes/Hook.php:287
55
SELECT SQL_NO_CACHE data FROM psm7_layered_filter_block WHERE hash="b30d0e26b102b269b5d67d1f19c71160" LIMIT 1
0.191 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
199
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitreviews" LIMIT 1
0.190 ms 1 /classes/module/Module.php:2636
186
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 1) LIMIT 1
0.188 ms 1 /src/Adapter/EntityMapper.php:71
211
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 75 LIMIT 1
0.186 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
22
SELECT SQL_NO_CACHE `id_lang` FROM `psm7_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.185 ms 1 /classes/Language.php:883
187
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.182 ms 1 /src/Adapter/EntityMapper.php:71
155
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.181 ms 2 /classes/Meta.php:193
72
SELECT SQL_NO_CACHE tr.*
FROM `psm7_tax_rule` tr
JOIN `psm7_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` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.180 ms 0 /classes/tax/TaxRulesTaxManager.php:109
19
SELECT SQL_NO_CACHE name, alias FROM `psm7_hook_alias`
0.180 ms 87 /classes/Hook.php:339
23
SELECT SQL_NO_CACHE value FROM `psm7_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.179 ms 1 /classes/shop/Shop.php:1183
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM psm7_shop s
LEFT JOIN psm7_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.179 ms 1 /classes/shop/Shop.php:218
159
SELECT SQL_NO_CACHE *
FROM `psm7_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
0.179 ms 1 /src/Adapter/EntityMapper.php:79
53
SELECT SQL_NO_CACHE *
FROM `psm7_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
0.178 ms 1 /src/Adapter/EntityMapper.php:79
78
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 29
AND image_shop.`cover` = 1 LIMIT 1
0.177 ms 1 /classes/Product.php:3570
73
SELECT SQL_NO_CACHE COUNT(*) FROM `psm7_pack` WHERE id_product_pack = 28 LIMIT 1
0.176 ms 1 /classes/Pack.php:89
222
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.174 ms 2 /classes/Meta.php:193
100
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 32
AND image_shop.`cover` = 1 LIMIT 1
0.172 ms 1 /classes/Product.php:3570
149
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `psm7_currency` c
LEFT JOIN psm7_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.171 ms 2 /classes/Currency.php:1136
224
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "my-account"
OR m.page = "myaccount"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.168 ms 2 /classes/Meta.php:193
135
SELECT SQL_NO_CACHE state FROM psm7_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
0.166 ms 1 /classes/FeatureFlag.php:105
89
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 30
AND image_shop.`cover` = 1 LIMIT 1
0.164 ms 1 /classes/Product.php:3570
119
SELECT SQL_NO_CACHE SUM(quantity)
FROM `psm7_stock_available`
WHERE (id_product = 33) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.164 ms 1 /classes/stock/StockAvailable.php:453
150
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM psm7_iqit_link_block cb
INNER JOIN psm7_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 902
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
0.162 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
148
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 80 AND `id_shop` = 1 LIMIT 1
0.161 ms 1 /classes/module/Module.php:2109
130
SELECT SQL_NO_CACHE SUM(quantity)
FROM `psm7_stock_available`
WHERE (id_product = 75) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.160 ms 1 /classes/stock/StockAvailable.php:453
134
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `psm7_product_attribute`
WHERE `id_product` = 28
0.160 ms 1 /classes/Product.php:2902
168
SELECT SQL_NO_CACHE c.id_elementor FROM psm7_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 999
0.160 ms 1 /modules/iqitelementor/src/IqitElementorContent.php:127
193
SELECT SQL_NO_CACHE `width`, `height`
FROM psm7_image_type
WHERE `name` = 'home_default' LIMIT 1
0.157 ms 1 /classes/Image.php:563
35
SELECT SQL_NO_CACHE *
FROM `psm7_group_lang`
WHERE `id_group` = 1
0.156 ms 1 /src/Adapter/EntityMapper.php:79
128
SELECT SQL_NO_CACHE COUNT(*) FROM `psm7_pack` WHERE id_product_pack = 75 LIMIT 1
0.156 ms 1 /classes/Pack.php:89
26
SELECT SQL_NO_CACHE `id_lang` FROM `psm7_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.155 ms 1 /classes/Language.php:883
111
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 33
AND image_shop.`cover` = 1 LIMIT 1
0.153 ms 1 /classes/Product.php:3570
152
SELECT SQL_NO_CACHE *
FROM `psm7_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 2
0.152 ms 1 /src/Adapter/EntityMapper.php:79
117
SELECT SQL_NO_CACHE COUNT(*) FROM `psm7_pack` WHERE id_product_pack = 33 LIMIT 1
0.152 ms 1 /classes/Pack.php:89
160
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) LIMIT 1
0.150 ms 1 /src/Adapter/EntityMapper.php:71
32
SELECT SQL_NO_CACHE *
FROM `psm7_currency_lang`
WHERE `id_currency` = 2
0.146 ms 1 /src/Adapter/EntityMapper.php:79
162
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "ps_languageselector" LIMIT 1
0.145 ms 1 /classes/module/Module.php:2636
136
SELECT SQL_NO_CACHE * FROM `psm7_image_type`
0.145 ms 8 /classes/ImageType.php:161
170
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "revsliderprestashop" LIMIT 1
0.144 ms 1 /classes/module/Module.php:2636
156
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) LIMIT 1
0.143 ms 1 /src/Adapter/EntityMapper.php:71
123
SELECT SQL_NO_CACHE name FROM psm7_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 14 LIMIT 1
0.142 ms 1 /classes/Product.php:5655
163
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1
0.141 ms 1 /classes/module/Module.php:2109
158
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) LIMIT 1
0.141 ms 1 /src/Adapter/EntityMapper.php:71
225
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitcontactpage" LIMIT 1
0.141 ms 1 /classes/module/Module.php:2636
28
SELECT SQL_NO_CACHE c.id_currency
FROM `psm7_currency` c
WHERE (iso_code = 'USD') LIMIT 1
0.141 ms 1 /classes/Currency.php:893
157
SELECT SQL_NO_CACHE *
FROM `psm7_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1
0.141 ms 1 /src/Adapter/EntityMapper.php:79
24
SELECT SQL_NO_CACHE c.id_currency
FROM `psm7_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.139 ms 1 /classes/Currency.php:893
196
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
0.138 ms 1 /classes/module/Module.php:2109
75
SELECT SQL_NO_CACHE SUM(quantity)
FROM `psm7_stock_available`
WHERE (id_product = 28) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.138 ms 1 /classes/stock/StockAvailable.php:453
223
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.137 ms 1 /classes/Meta.php:193
46
SELECT SQL_NO_CACHE *
FROM `psm7_country` a
LEFT JOIN `psm7_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.137 ms 1 /src/Adapter/EntityMapper.php:71
17
SELECT SQL_NO_CACHE * FROM `psm7_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.137 ms 1 /classes/module/Module.php:2018
161
SELECT SQL_NO_CACHE *
FROM `psm7_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
0.135 ms 1 /src/Adapter/EntityMapper.php:79
153
SELECT SQL_NO_CACHE *
FROM `psm7_hook` a
WHERE (a.`id_hook` = 902) LIMIT 1
0.135 ms 1 /src/Adapter/EntityMapper.php:71
198
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
0.133 ms 1 /classes/module/Module.php:2109
172
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitmegamenu" LIMIT 1
0.133 ms 1 /classes/module/Module.php:2636
200
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 85 AND `id_shop` = 1 LIMIT 1
0.131 ms 1 /classes/module/Module.php:2109
126
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `psm7_product_shop`
WHERE `id_product` = 75 AND id_shop=1 LIMIT 1
0.131 ms 1 /classes/Product.php:6872
166
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitelementor" LIMIT 1
0.130 ms 1 /classes/module/Module.php:2636
79
SELECT SQL_NO_CACHE name FROM psm7_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 14 LIMIT 1
0.130 ms 1 /classes/Product.php:5655
182
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
0.129 ms 1 /classes/module/Module.php:2109
9
SELECT SQL_NO_CACHE id_shop
FROM `psm7_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
0.126 ms 1 /classes/ObjectModel.php:1729
228
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 74 AND `id_shop` = 1 LIMIT 1
0.125 ms 1 /classes/module/Module.php:2109
108
SELECT SQL_NO_CACHE SUM(quantity)
FROM `psm7_stock_available`
WHERE (id_product = 32) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.125 ms 1 /classes/stock/StockAvailable.php:453
38
SELECT SQL_NO_CACHE ctg.`id_group`
FROM psm7_category_group ctg
WHERE ctg.`id_category` = 14 AND ctg.`id_group` = 1 LIMIT 1
0.124 ms 1 /classes/Category.php:1754
140
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `psm7_product_attribute`
WHERE `id_product` = 30
0.123 ms 1 /classes/Product.php:2902
129
SELECT SQL_NO_CACHE product_type FROM `psm7_product` WHERE id_product = 75 LIMIT 1
0.122 ms 1 /classes/Pack.php:90
95
SELECT SQL_NO_CACHE COUNT(*) FROM `psm7_pack` WHERE id_product_pack = 30 LIMIT 1
0.122 ms 1 /classes/Pack.php:89
142
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `psm7_product_attribute`
WHERE `id_product` = 32
0.121 ms 1 /classes/Product.php:2902
86
SELECT SQL_NO_CACHE SUM(quantity)
FROM `psm7_stock_available`
WHERE (id_product = 29) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.120 ms 1 /classes/stock/StockAvailable.php:453
47
SELECT SQL_NO_CACHE *
FROM `psm7_country_lang`
WHERE `id_country` = 6
0.120 ms 1 /src/Adapter/EntityMapper.php:79
138
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `psm7_product_attribute`
WHERE `id_product` = 29
0.120 ms 1 /classes/Product.php:2902
68
SELECT SQL_NO_CACHE *
FROM `psm7_tax` a
WHERE (a.`id_tax` = 53) LIMIT 1
0.120 ms 1 /src/Adapter/EntityMapper.php:71
84
SELECT SQL_NO_CACHE COUNT(*) FROM `psm7_pack` WHERE id_product_pack = 29 LIMIT 1
0.119 ms 1 /classes/Pack.php:89
219
SELECT SQL_NO_CACHE *
FROM `psm7_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 1
0.119 ms 1 /src/Adapter/EntityMapper.php:79
97
SELECT SQL_NO_CACHE SUM(quantity)
FROM `psm7_stock_available`
WHERE (id_product = 30) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.119 ms 1 /classes/stock/StockAvailable.php:453
118
SELECT SQL_NO_CACHE product_type FROM `psm7_product` WHERE id_product = 33 LIMIT 1
0.118 ms 1 /classes/Pack.php:90
27
SELECT SQL_NO_CACHE `id_lang` FROM `psm7_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.118 ms 1 /classes/Language.php:883
74
SELECT SQL_NO_CACHE product_type FROM `psm7_product` WHERE id_product = 28 LIMIT 1
0.118 ms 1 /classes/Pack.php:90
145
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `psm7_product_attribute`
WHERE `id_product` = 75
0.117 ms 1 /classes/Product.php:2902
127
SELECT SQL_NO_CACHE `reduction`
FROM `psm7_product_group_reduction_cache`
WHERE `id_product` = 75 AND `id_group` = 1 LIMIT 1
0.117 ms 0 /classes/GroupReduction.php:156
48
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM psm7_required_field
0.116 ms 1 /classes/ObjectModel.php:1592
69
SELECT SQL_NO_CACHE *
FROM `psm7_tax_lang`
WHERE `id_tax` = 53
0.115 ms 1 /src/Adapter/EntityMapper.php:79
64
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `psm7_product_shop`
WHERE `id_product` = 28 AND id_shop=1 LIMIT 1
0.114 ms 1 /classes/Product.php:6872
90
SELECT SQL_NO_CACHE name FROM psm7_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 14 LIMIT 1
0.113 ms 1 /classes/Product.php:5655
42
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.113 ms 0 /classes/module/Module.php:2109
60
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `psm7_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 14 LIMIT 1
0.113 ms 1 /classes/Category.php:1378
101
SELECT SQL_NO_CACHE name FROM psm7_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 14 LIMIT 1
0.112 ms 1