El voleibol en la playa es una de las actividades deportivas más emocionantes y gratificantes que se pueden disfrutar en un entorno al aire libre. Con el sonido del mar de fondo y la arena bajo nuestros pies, este deporte nos brinda una experiencia única llena de diversión y competencia amistosa.

Sin embargo, para sacar el máximo provecho de cada partido y asegurar una experiencia inolvidable, es esencial contar con el equipamiento adecuado. En este artículo, veremos en detalle el equipamiento esencial necesario para jugar voleibol en la playa. Desde la configuración de la cancha hasta la selección del balón, la protección solar y el calzado adecuado.

La Cancha de Voleibol en la Playa

Una de las características más distintivas del voleibol en la playa es la configuración de la cancha. A diferencia de las canchas tradicionales en pista cubierta, la cancha de voleibol en la playa tiene unas dimensiones específicas y se establece en la arena, lo que agrega un desafío adicional y un ambiente único al juego.

La cancha de voleibol en la playa mide 16 metros de largo por 8 metros de ancho. Está dividida en dos campos de juego separados por una red central. La red tiene una altura de 2,43 metros para los hombres y 2,24 metros para las mujeres, lo que es ligeramente más bajo que en las canchas cubiertas. La red debe estar bien tensada y asegurada en postes que se clavan en la arena.

La Red de Voley Playa

La red de voleibol de playa está diseñada para soportar las condiciones del ambiente marítimo y la arena. Generalmente, está fabricada con materiales resistentes a la intemperie y la corrosión, como nylon o poliéster, que permiten una durabilidad óptima en condiciones de humedad y sol.

El montaje y la tensión adecuada de la red son fundamentales para asegurar un juego justo. Suelen venir con correas de tensión que se aseguran a postes colocados en el suelo. Estos postes deben clavarse firmemente en la arena para garantizar que la red esté bien tensada y en posición vertical durante los partidos.

Balones de Voley Playa

El balón de voleibol de playa es el corazón del juego en la arena. Su diseño específico y características distintivas lo hacen ideal para los partidos bajo el sol y en la playa. Elegir el balón adecuado es esencial para un juego óptimo y una experiencia placentera, ya que su tamaño, peso y textura tienen un impacto significativo en la forma en que se juega en la arena. En SPS-Sport disponemos de una amplia selección de balones para que puedas encontrar el que más te guste.

Calzado y Vestimenta Adecuados

Calzado para Voleibol Playa

Al jugar voleibol en la playa, se recomienda usar calzado diseñado específicamente para este entorno. Los zapatos de voleibol de playa están diseñados para ofrecer una buena tracción en superficies arenosas y para proteger los pies de la abrasión y el calor.

Estos calzados suelen tener suelas de goma con un patrón de tracción profundo que permite un buen agarre en la arena. Además, son ligeros y transpirables para evitar que la arena se acumule en los zapatos y brindar comodidad durante largos partidos.

Vestimenta Ligera y Transpirable

La elección de la vestimenta adecuada también es esencial para jugar voleibol en la playa. Se recomienda usar ropa ligera y transpirable que permita la libertad de movimiento y evite el sobrecalentamiento. Camisetas de manga corta, tops sin mangas y pantalones cortos son opciones populares para los jugadores.

Además, es importante protegerse del sol, por lo que se recomienda utilizar protector solar y vestir gorras o sombreros para proteger la cabeza y el rostro.

Ropa de Recambio y Toallas

Es recomendable llevar ropa de recambio para después de los partidos, ya que el contacto con la arena y el sudor pueden dejar la ropa húmeda y sucia. Además, es útil llevar una toalla para secarse después de jugar y para limpiar el exceso de arena antes de ponerse los zapatos y la ropa de calle.

Protección Solar y Accesorios Útiles

Cuando se juega voleibol en la playa, la exposición prolongada al sol es inevitable. Por ello, es fundamental tomar precauciones y protegerse adecuadamente contra los rayos ultravioleta. Además de la protección solar, existen algunos accesorios útiles que pueden mejorar la experiencia de juego y brindar comodidad adicional durante los partidos en la arena.

Una gorra o sombrero de ala ancha es un accesorio útil para proteger la cabeza, la cara y el cuello del sol. Si vas a pasar un día completo en la playa jugando voleibol, considera llevar una sombrilla o una tienda de campaña portátil para tener un refugio sombreado entre los partidos. También es recomendable llevar contigo botellas de agua y mantenerlas cerca de la cancha para hidratarte regularmente y evitar la deshidratación.

Tu tienda especializada en Voleibol Playa

Prepararse adecuadamente para jugar voleibol en la playa es la clave para disfrutar al máximo de este deporte bajo el sol y junto al mar. El equipamiento esencial incluye: una red de voley playa adecuada, balones diseñados para la arena, calzado específico y ropa cómoda.

En SPS-Sport, tu tienda especializada en artículos deportivos, encontrarás todo el equipamiento necesario para disfrutar plenamente del voleibol en la playa. Desde redes y balones de voleibol de playa de alta calidad hasta calzado específico y accesorios útiles, tenemos todo lo que necesitas para disfrutar de este deporte junto al mar.

Necesitas ayuda?
Load Time 312 ms
Querying Time 197 ms
Queries 786
Memory Peak Usage 55.0 Mb
Included Files 1264 files - 17.29 Mb
PrestaShop Cache - Mb
Global vars 1.54 Mb
PrestaShop Version 1.7.8.8
PHP Version 7.4.33
MySQL Version 10.3.39-MariaDB
Memory Limit 512M
Max Execution Time 200s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 9 ms 9 ms 14.18 Mb 33.4 Mb
__construct 0 ms 9 ms - Mb 33.4 Mb
init 21 ms 30 ms 1.51 Mb 33.4 Mb
checkAccess 0 ms 30 ms - Mb 33.4 Mb
setMedia 2 ms 32 ms 0.32 Mb 33.4 Mb
postProcess 0 ms 32 ms - Mb 33.4 Mb
initHeader 0 ms 32 ms - Mb 33.4 Mb
initContent 89 ms 121 ms 7.17 Mb 42.8 Mb
initFooter 0 ms 121 ms - Mb 42.8 Mb
display 191 ms 312 ms 31.52 Mb 55.0 Mb
Hook Time Memory Usage
displayCMSDisputeInformation 151 ms 28.97 Mb
DisplayProductListReviews 46 ms 12.33 Mb
DisplayHeader 42 ms 2.34 Mb
Header 24 ms 1.28 Mb
DisplayBeforeBodyClosingTag 14 ms 0.67 Mb
DisplayProductPriceBlock 5 ms 0.74 Mb
ActionObjectAddAfter 4 ms 0.21 Mb
displayFooter 2 ms 0.08 Mb
Footer 1 ms 0.09 Mb
renderWidget 1 ms 0.05 Mb
displayMainMenu 1 ms 0.23 Mb
DisplayTop 1 ms 0.02 Mb
displayNav1 1 ms 0.05 Mb
DisplayNav1 1 ms 0.05 Mb
displayFooterBefore 1 ms 0.01 Mb
DisplayFooterBefore 1 ms - Mb
DisplayBanner 1 ms 0.03 Mb
DisplayAfterTitleTag 0 ms 0.07 Mb
displayHeaderButtons 0 ms 0.01 Mb
displayHeaderButtonsMobile 0 ms 0.02 Mb
displayBelowHeader 0 ms 0.01 Mb
DisplayFooterAfter 0 ms 0.02 Mb
DisplayAfterBodyOpeningTag 0 ms 0.01 Mb
displayWrapperTop 0 ms 0.01 Mb
ModuleRoutes 0 ms 0.01 Mb
Top 0 ms 0.03 Mb
displayAfterBreadcrumb 0 ms 0.03 Mb
ActionFrontControllerSetMedia 0 ms - Mb
ActionOutputHTMLBefore 0 ms - Mb
ActionDispatcherBefore 0 ms - Mb
OverrideLayoutTemplate 0 ms - Mb
DisplayNavFullWidth 0 ms - Mb
ActionDispatcher 0 ms - Mb
33 hook(s) 298 ms 47.41 Mb
Module Time Memory Usage
ph_simpleblog 3 ms 0.18 Mb
pm_advancedsearch4 15 ms 1.26 Mb
onepagecheckoutps 5 ms 0.40 Mb
ps_mbo 1 ms 0.07 Mb
iqitthemeeditor 1 ms 0.11 Mb
ps_emailsubscription 0 ms 0.03 Mb
wkcombinationcustomize 0 ms 0.03 Mb
paytpv 1 ms 0.25 Mb
revsliderprestashop 2 ms 0.63 Mb
iqitsociallogin 0 ms 0.02 Mb
codfee 1 ms 0.13 Mb
easyloginascustomer 0 ms 0.02 Mb
dynamicproduct 3 ms 0.13 Mb
ets_banneranywhere 3 ms 0.19 Mb
productlistpics 47 ms 12.35 Mb
cdc_googletagmanager 2 ms 0.30 Mb
ps_imageslider 0 ms 0.09 Mb
ps_emailalerts 0 ms 0.04 Mb
bongooglereviews 0 ms 0.01 Mb
storeggmap 0 ms 0.02 Mb
ps_googleanalytics 1 ms 0.04 Mb
iqitmegamenu 1 ms 0.35 Mb
eicaptcha 0 ms 0.02 Mb
ifeedback 3 ms 0.16 Mb
sequrapayment 1 ms 0.05 Mb
paypalwithfee 0 ms 0.10 Mb
ambjolisearch 3 ms 0.30 Mb
groupinc 5 ms 0.86 Mb
psaffiliate 16 ms 16.05 Mb
pm_crosssellingoncart 19 ms - Mb
ps_shoppingcart 0 ms 0.02 Mb
iqitelementor 152 ms 29.10 Mb
iqitfreedeliverycount 0 ms 0.02 Mb
iqitsizecharts 0 ms 0.03 Mb
redsys 1 ms 0.10 Mb
ets_superspeed 6 ms 0.30 Mb
whatsappchat 6 ms 0.40 Mb
bannerlateralhorario 1 ms 0.08 Mb
bonban 1 ms 0.05 Mb
bavideotab 1 ms 0.03 Mb
iqithtmlandbanners 4 ms 0.16 Mb
iqitsearch 1 ms 0.07 Mb
ps_customersignin 0 ms 0.02 Mb
iqitproductsnav 1 ms 0.05 Mb
iqitlinksmanager 1 ms 0.10 Mb
statsdata 11 ms 0.50 Mb
sequracheckout 0 ms 0.03 Mb
47 module(s) 323 ms 51.41 Mb

Stopwatch SQL - 786 queries

Query Time (ms) Rows Filesort Group By Location
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 `sps_configuration` c
LEFT JOIN `sps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
62234 ms 60836 /classes/Configuration.php:160
SELECT SQL_NO_CACHE *
FROM `sps_cms` c
INNER JOIN `sps_cms_lang` `l` ON c.id_cms = l.id_cms AND l.id_lang = 1
WHERE (c.active = 1)
ORDER BY position
5984 ms 258 Yes /classes/CMS.php:311
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-08-19 00:00:00",
INTERVAL 60 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `sps_category_product` cp
LEFT JOIN `sps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `sps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN sps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `sps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `sps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `sps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `sps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `sps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 47 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`date_add` ASC
LIMIT 0,5
5882 ms 203 Yes /classes/Category.php:1057
SELECT SQL_NO_CACHE *
FROM `sps_cms` c
INNER JOIN `sps_cms_lang` `l` ON c.id_cms = l.id_cms AND l.id_lang = 1
WHERE (c.active = 1)
ORDER BY position
5844 ms 258 Yes /classes/CMS.php:311
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `sps_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `sps_date_range`) LIMIT 1
2715 ms 72692676 /classes/DateRange.php:60
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product_attribute` FROM `sps_specific_price` WHERE `id_product_attribute` != 0 GROUP BY id_product ) AS counted LIMIT 1
2100 ms 14323048 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `sps_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
1920 ms 7645225 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `sps_module` m
INNER JOIN sps_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 `sps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `sps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `sps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `sps_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`
1786 ms 327 Yes Yes /classes/Hook.php:1183
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-08-19 00:00:00",
INTERVAL 60 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `sps_category_product` cp
LEFT JOIN `sps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `sps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN sps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `sps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `sps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `sps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `sps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `sps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 124 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 5
1451 ms 21 Yes /classes/Category.php:1057
INSERT INTO `sps_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')
1369 ms 1 /classes/ObjectModel.php:578
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 `sps_hook_module` hm
STRAIGHT_JOIN `sps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `sps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1316 ms 708 /classes/Hook.php:504
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 137
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1181 ms 54 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-08-19 00:00:00",
INTERVAL 60 DAY)) > 0 AS new,
product_shop.price AS orderprice
FROM `sps_product` p
LEFT JOIN `sps_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN sps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `sps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `sps_category_lang` cl ON (
p.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `sps_image` i ON (p.`id_product` = i.`id_product`)
LEFT JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `sps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `sps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `sps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
AND tr.`id_country` = 21
AND tr.`id_state` = 0
)
LEFT JOIN `sps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `sps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 1)
WHERE product_shop.`id_shop` = 1
AND product_shop.`active` = 1
AND product_shop.`available_for_order` = 1
AND product_shop.`id_product` IN (397,7508,7512,8135)
AND product_shop.`visibility` IN ("both", "catalog") 
AND IF (
(stock.`id_product_attribute` = 0 AND pa.`id_product_attribute` IS NULL)
OR
(product_attribute_shop.`id_product_attribute` IS NOT NULL AND stock.`id_product_attribute`=product_attribute_shop.`id_product_attribute`), 1, 0
)
AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 1 = 1, stock.`out_of_stock` = 1))
GROUP BY product_shop.`id_product`
ORDER BY FIELD(product_shop.`id_product`, 397,7508,7512,8135)
1165 ms 20 Yes /modules/pm_crosssellingoncart/pm_crosssellingoncart.php:853
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (147) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1051 ms 40 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 147
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1034 ms 40 Yes Yes /classes/Product.php:2792
SHOW TABLES LIKE "sps_ets_superspeed_cache_page"
1023 ms 1 /modules/ets_superspeed/ets_superspeed.php:975
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (137) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
981 ms 54 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `sps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `sps_hook_alias` ha
INNER JOIN `sps_hook` h ON ha.name = h.name
939 ms 0 /classes/Hook.php:1243
SHOW TABLES LIKE "sps_ets_superspeed_cache_page"
811 ms 1 /modules/ets_superspeed/ets_superspeed.php:975
SHOW TABLES LIKE "sps_ets_superspeed_cache_page"
781 ms 1 /modules/ets_superspeed/classes/cache.php:271
SHOW TABLES LIKE "sps_ets_superspeed_cache_page"
780 ms 1 /modules/ets_superspeed/classes/cache.php:271
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `sps_specific_price` WHERE `id_product_attribute` != 0
726 ms 2591 /classes/SpecificPrice.php:295
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 149
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
666 ms 24 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (149) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
652 ms 24 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `sps_meta` m
LEFT JOIN `sps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
548 ms 126 Yes /classes/Dispatcher.php:650
SELECT SQL_NO_CACHE *
FROM `sps_contact` c
LEFT JOIN sps_contact_shop contact_shop
ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = 1)
LEFT JOIN `sps_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
WHERE cl.`id_lang` = 1
AND contact_shop.`id_shop` IN (1)
GROUP BY c.`id_contact`
ORDER BY `name` ASC
533 ms 2 Yes Yes /classes/Contact.php:99
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 47 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
509 ms 203 /classes/Category.php:986
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2667) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
499 ms 1 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8767) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
491 ms 1 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE * FROM `sps_ets_baw_banner` b
LEFT JOIN `sps_ets_baw_banner_lang` bl ON (b.id_ets_baw_banner = bl.id_ets_baw_banner AND bl.id_lang="1")
LEFT JOIN `sps_ets_baw_banner_position` bp ON (bp.id_ets_baw_banner = b.id_ets_baw_banner)
WHERE b.active=1 AND bp.position = "displayBeforeLeftColumn" ORDER BY bp.sort ASC
478 ms 1 Yes /modules/ets_banneranywhere/classes/ets_baw_banner.php:308
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (7508) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
475 ms 1 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE * FROM `sps_ets_baw_banner` b
LEFT JOIN `sps_ets_baw_banner_lang` bl ON (b.id_ets_baw_banner = bl.id_ets_baw_banner AND bl.id_lang="1")
LEFT JOIN `sps_ets_baw_banner_position` bp ON (bp.id_ets_baw_banner = b.id_ets_baw_banner)
WHERE b.active=1 AND bp.position = "displayFooterBefore" ORDER BY bp.sort ASC
472 ms 1 Yes /modules/ets_banneranywhere/classes/ets_baw_banner.php:308
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 149
LIMIT 1
469 ms 25 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5188) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
463 ms 2 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 5188
LIMIT 1
454 ms 5 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (155) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
452 ms 1 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:13" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:13" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
449 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 155
LIMIT 1
441 ms 2 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8754) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
431 ms 1 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 147
LIMIT 1
431 ms 41 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE lower(name) as name
FROM `sps_hook` h
WHERE (h.active = 1)
424 ms 776 /classes/Hook.php:1283
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10054) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
417 ms 1 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 2667
LIMIT 1
412 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7508
LIMIT 1
404 ms 1 /classes/ProductAssembler.php:106
(SELECT SQL_NO_CACHE * FROM `sps_cart_rule` cr
LEFT JOIN `sps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
393 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN sps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
JOIN `sps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `sps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `sps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (178) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
390 ms 1 Yes /classes/Product.php:4486
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 137
LIMIT 1
379 ms 27 /classes/ProductAssembler.php:106
(SELECT SQL_NO_CACHE * FROM `sps_cart_rule` cr
LEFT JOIN `sps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
378 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sps_module` m
LEFT JOIN `sps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
376 ms 119 /classes/module/Module.php:340
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 10054
LIMIT 1
374 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE * FROM `sps_ets_baw_banner` b
LEFT JOIN `sps_ets_baw_banner_lang` bl ON (b.id_ets_baw_banner = bl.id_ets_baw_banner AND bl.id_lang="1")
LEFT JOIN `sps_ets_baw_banner_position` bp ON (bp.id_ets_baw_banner = b.id_ets_baw_banner)
WHERE b.active=1 AND bp.position = "displayNav1" ORDER BY bp.sort ASC
373 ms 1 Yes /modules/ets_banneranywhere/classes/ets_baw_banner.php:308
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 178
LIMIT 1
370 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *
FROM `sps_order_state` os
LEFT JOIN `sps_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
363 ms 62 Yes /classes/order/OrderState.php:132
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:14" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:14" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
361 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sps_module` m
LEFT JOIN `sps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
352 ms 119 /classes/module/Module.php:340
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sps_module` m
LEFT JOIN `sps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
351 ms 119 /classes/module/Module.php:340
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 8767
LIMIT 1
348 ms 2 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-08-19 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM sps_product p
LEFT JOIN sps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN sps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_shop_group = 1 LEFT JOIN sps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 8754
LIMIT 1
344 ms 1 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE acg.*, acgl.*
FROM `sps_pm_advancedsearch_criterion_group_1` acg
LEFT JOIN `sps_pm_advancedsearch_criterion_group_1_lang` acgl ON (acg.`id_criterion_group` = acgl.`id_criterion_group` AND acgl.`id_lang` = 1 )
WHERE acg.`id_search` = 1
ORDER BY `position`
333 ms 10 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5188
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
332 ms 2 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayBanner" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
328 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
(SELECT SQL_NO_CACHE * FROM `sps_cart_rule` cr
LEFT JOIN `sps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
327 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `sps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 155 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 10 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
325 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 155
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
322 ms 1 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 149
ORDER BY `position`
322 ms 8 Yes /classes/Product.php:3517
INSERT INTO `sps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('10824864', '11', '308349356', '', '1', '1', '2026-08-19 23:28:14')
321 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE * FROM `sps_ets_baw_banner` b
LEFT JOIN `sps_ets_baw_banner_lang` bl ON (b.id_ets_baw_banner = bl.id_ets_baw_banner AND bl.id_lang="1")
LEFT JOIN `sps_ets_baw_banner_position` bp ON (bp.id_ets_baw_banner = b.id_ets_baw_banner)
WHERE b.active=1 AND bp.position = "displayFooterAfter" ORDER BY bp.sort ASC
320 ms 1 Yes /modules/ets_banneranywhere/classes/ets_baw_banner.php:308
UPDATE `sps_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 10037
AND `id_page` = 11
AND `id_shop` = 1
320 ms 1 /classes/Page.php: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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 13565
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 137 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 13565
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 137 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
314 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13565, 13566, 13567, 13568, 13569, 13570, 13571, 13572, 13573, 13575, 13576, 13577, 13578, 13579, 13580, 13581, 13582, 13583, 13585, 13586, 13587, 13588, 13589, 13590, 13591, 13592, 13593, 13595, 13596, 13597, 13598, 13599, 13600, 13601, 13602, 13603, 13605, 13606, 13607, 13608, 13609, 13610, 13611, 13612, 13613, 13615, 13616, 13617, 13618, 13619, 13620, 13621, 13622, 13623) AND il.`id_lang` = 1 ORDER by i.`position`
309 ms 54 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13819, 13820, 13821, 13822, 13823, 13824, 13825, 13826, 13827, 13828, 13829, 13830, 13831, 13832, 13833, 13834, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13852, 13853, 13854, 13855, 13856, 13857, 13858) AND il.`id_lang` = 1 ORDER by i.`position`
308 ms 40 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `sps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 7508 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
305 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 8767
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
299 ms 1 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8767 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8767 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
297 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sps_module` m
LEFT JOIN `sps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
295 ms 119 /classes/module/Module.php:340
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 137
AND image_shop.`cover` = 1 LIMIT 1
295 ms 13 /classes/Product.php:3542
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `sps_hook`
293 ms 776 /classes/Hook.php:1243
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10054 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10054 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
292 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 2667
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
291 ms 1 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:14" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:14" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
288 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13981, 13982, 13983, 13984, 13985, 13986, 13987, 13988, 13989, 13990, 13991, 13992, 13993, 13994, 13995, 13996, 13997, 13998, 13999, 14000, 14001, 14002, 14003, 14004) AND il.`id_lang` = 1 ORDER by i.`position`
288 ms 24 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `sps_module` m
LEFT JOIN `sps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
287 ms 119 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `sps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 178 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
287 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 137 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 137 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
286 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5188 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5188 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
281 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE tr.*
FROM `sps_tax_rule` tr
JOIN `sps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 11
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
280 ms 1 /classes/tax/TaxRulesTaxManager.php: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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 147 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 147 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
279 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8754 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8754 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
278 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 10054
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
277 ms 1 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:13" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:13" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
276 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search`
FROM `sps_pm_advancedsearch` ads
JOIN `sps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1)  WHERE 1  AND ads.`active`=1  ORDER BY ads.`position`
276 ms 1 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
INSERT IGNORE INTO `sps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('9484344', '11', '2026-08-19 23:28:14')
275 ms 1 /classes/Connection.php:122
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 2667
ORDER BY `position`
273 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `sps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 155 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-08-19 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
271 ms 1 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sps_category_product` cp
INNER JOIN `sps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 8029 AND ctg.`id_group` = 1 LIMIT 1
270 ms 1 /classes/Product.php:6624
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 149 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 149 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
270 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 155 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 155 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
270 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2667 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2667 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
268 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:13" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:13" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
268 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:13" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:13" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
268 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:14" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:14" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
267 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE value FROM `sps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
265 ms 2 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 124 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
263 ms 21 /classes/Category.php:986
SELECT SQL_NO_CACHE * FROM `sps_ets_baw_banner` b
LEFT JOIN `sps_ets_baw_banner_lang` bl ON (b.id_ets_baw_banner = bl.id_ets_baw_banner AND bl.id_lang="1")
LEFT JOIN `sps_ets_baw_banner_position` bp ON (bp.id_ets_baw_banner = b.id_ets_baw_banner)
WHERE b.active=1 AND bp.position = "displayBeforeRightColumn" ORDER BY bp.sort ASC
259 ms 1 Yes /modules/ets_banneranywhere/classes/ets_baw_banner.php:308
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 8754
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
259 ms 1 Yes Yes /classes/Product.php:2792
(SELECT 1 FROM `sps_cart_rule` WHERE date_to >= "2026-08-19 00:00:00" AND date_to <= "2026-08-19 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sps_cart_rule` WHERE date_from >= "2026-08-19 00:00:00" AND date_from <= "2026-08-19 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sps_cart_rule` WHERE date_from < "2026-08-19 00:00:00" AND date_to > "2026-08-19 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
256 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7508 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 7508 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
255 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 178 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 178 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
254 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE c.*, c.id_ifb_criterion as id, cl.name, ct.type, ct.payment, ct.shipping
FROM `sps_ifb_criterion` c
INNER JOIN `sps_ifb_criterion_lang` `cl` ON cl.id_ifb_criterion = c.id_ifb_criterion AND cl.id_lang = 1
INNER JOIN `sps_ifb_criterion_type` `ct` ON ct.id_ifb_criterion = c.id_ifb_criterion
WHERE (c.default = 0) AND (c.deleted = 0) AND (ct.type = 1)
GROUP BY c.id_ifb_criterion
253 ms 1 Yes /modules/ifeedback/classes/CriterionClass.php:134
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 137) AND (b.`id_shop` = 1) LIMIT 1
253 ms 1 /src/Adapter/EntityMapper.php:76
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 sps_shop_group gs
LEFT JOIN sps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN sps_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
250 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 10054
ORDER BY `position`
249 ms 8 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13565, 13566, 13567, 13568, 13569, 13570, 13571, 13572, 13573, 13575, 13576, 13577, 13578, 13579, 13580, 13581, 13582, 13583, 13585, 13586, 13587, 13588, 13589, 13590, 13591, 13592, 13593, 13595, 13596, 13597, 13598, 13599, 13600, 13601, 13602, 13603, 13605, 13606, 13607, 13608, 13609, 13610, 13611, 13612, 13613, 13615, 13616, 13617, 13618, 13619, 13620, 13621, 13622, 13623) AND il.`id_lang` = 1 ORDER by i.`position`
248 ms 54 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `sps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `sps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `sps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 178
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
247 ms 1 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE *
FROM `sps_cms` a
LEFT JOIN `sps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `sps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 104) AND (b.`id_shop` = 1) LIMIT 1
243 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM sps_shop_url su
LEFT JOIN sps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'sps-sport.com' OR su.domain_ssl = 'sps-sport.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
243 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 13820
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 147 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 13820
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 147 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
241 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13819, 13820, 13821, 13822, 13823, 13824, 13825, 13826, 13827, 13828, 13829, 13830, 13831, 13832, 13833, 13834, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13852, 13853, 13854, 13855, 13856, 13857, 13858) AND il.`id_lang` = 1 ORDER by i.`position`
241 ms 40 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:13" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:13" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
240 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE id_tab, class_name FROM `sps_tab`
240 ms 287 /classes/Tab.php:359
SELECT SQL_NO_CACHE *
FROM `sps_whatsappchatblock_agent` LEFT JOIN `sps_whatsappchatblock_agent_lang` ON (`sps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `sps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `active` = 1 ORDER BY position
239 ms 2 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 80416
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8767 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 80416
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8767 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
238 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `sps_simpleblog_category` c
LEFT JOIN `sps_simpleblog_category_lang` cl ON (c.`id_simpleblog_category` = cl.`id_simpleblog_category` AND cl.`id_lang` = 1)
WHERE 1=1
AND c.`active` = 1
ORDER BY c.position ASC
236 ms 1 Yes /modules/ph_simpleblog/models/SimpleBlogCategory.php:362
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 137)
234 ms 54 /classes/Product.php:3829
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 85656
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5188 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 85656
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5188 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
232 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 8767
ORDER BY `position`
231 ms 4 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `sps_lang` l
JOIN sps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
225 ms 25 /classes/Language.php:1198
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 155
ORDER BY `position`
225 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:14" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:14" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
223 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 13982
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 149 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 13982
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 149 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
223 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 8767
AND pac.`id_product_attribute` = 80416
AND agl.`id_lang` = 1
223 ms 1 /classes/Product.php:7407
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
222 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE * FROM `sps_currency` c ORDER BY `iso_code` ASC
221 ms 2 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
221 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5188
ORDER BY `position`
219 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10054) AND (b.`id_shop` = 1) LIMIT 1
219 ms 1 /src/Adapter/EntityMapper.php:76
(SELECT 1 FROM `sps_cart_rule` WHERE date_to >= "2026-08-19 00:00:00" AND date_to <= "2026-08-19 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sps_cart_rule` WHERE date_from >= "2026-08-19 00:00:00" AND date_from <= "2026-08-19 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sps_cart_rule` WHERE date_from < "2026-08-19 00:00:00" AND date_to > "2026-08-19 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
219 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5188) AND (b.`id_shop` = 1) LIMIT 1
217 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
217 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayNav1" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
216 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `sps_cart_product` cp
WHERE cp.`id_product_attribute` = 14391
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 155 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `sps_cart_product` cp JOIN `sps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 14391
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 155 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
215 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi  WHERE (date_from <= "2026-08-19 23:28:13" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2026-08-19 23:28:13" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
214 ms 29 /modules/groupinc/classes/GroupincConfiguration.php:2505
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 2667
AND image_shop.`cover` = 1 LIMIT 1
214 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2667) AND (b.`id_shop` = 1) LIMIT 1
213 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_lang` a
LEFT JOIN `sps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
212 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 137
ORDER BY `position`
209 ms 13 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 7508
ORDER BY `position`
209 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 8754
ORDER BY f.position ASC
209 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7508) AND (b.`id_shop` = 1) LIMIT 1
206 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 137
AND pac.`id_product_attribute` = 13565
AND agl.`id_lang` = 1
205 ms 2 /classes/Product.php:7407
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8754) AND (b.`id_shop` = 1) LIMIT 1
203 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 1 FROM sps_cart_product cp INNER JOIN sps_product p
ON (p.id_product = cp.id_product) INNER JOIN sps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
203 ms 3 /classes/Cart.php:4218
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 155) AND (b.`id_shop` = 1) LIMIT 1
202 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 178
ORDER BY `position`
202 ms 7 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 147
ORDER BY `position`
201 ms 8 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 155
ORDER BY f.position ASC
201 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE * FROM `sps_aff_configuration`;
201 ms 46 /modules/psaffiliate/classes/AffConf.php:955
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10054
ORDER BY f.position ASC
200 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8767) AND (b.`id_shop` = 1) LIMIT 1
199 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 147
AND pac.`id_product_attribute` = 13820
AND agl.`id_lang` = 1
198 ms 2 /classes/Product.php:7407
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `sps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 8754
ORDER BY `position`
198 ms 2 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "top" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
198 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 149
AND pac.`id_product_attribute` = 13982
AND agl.`id_lang` = 1
197 ms 2 /classes/Product.php:7407
SELECT SQL_NO_CACHE format
FROM `sps_address_format`
WHERE `id_country` = 6 LIMIT 1
196 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2667
ORDER BY f.position ASC
196 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `sps_lang` l
LEFT JOIN `sps_lang_shop` ls ON (l.id_lang = ls.id_lang)
195 ms 5 /classes/Language.php:1049
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 5188
AND pac.`id_product_attribute` = 85656
AND agl.`id_lang` = 1
195 ms 1 /classes/Product.php:7407
SELECT SQL_NO_CACHE *
FROM `sps_category` a
LEFT JOIN `sps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 124) LIMIT 1
195 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE DISTINCT g.`id_group`, g.`reduction`, g.`price_display_method`, g.`show_prices`, gl.`name`
FROM `sps_group` g
LEFT JOIN `sps_group_lang` AS gl ON (g.`id_group` = gl.`id_group` AND gl.`id_lang` = 1)
ORDER BY g.`id_group` ASC
186 ms 5 /classes/Group.php:111
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 149) AND (b.`id_shop` = 1) LIMIT 1
186 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 147) AND (b.`id_shop` = 1) LIMIT 1
185 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 7508
ORDER BY f.position ASC
185 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `sps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `sps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `sps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 155
AND pac.`id_product_attribute` = 14391
AND agl.`id_lang` = 1
185 ms 1 /classes/Product.php:7407
SELECT SQL_NO_CACHE gi.* FROM `sps_groupinc_configuration` gi WHERE gi.`id_shop` = 1
AND gi.`active` = 1
182 ms 29 /modules/groupinc/groupinc.php:1037
SELECT SQL_NO_CACHE s.`seo_key`, s.`id_seo`, sl.`seo_url`
FROM `sps_pm_advancedsearch_seo` s
JOIN `sps_pm_advancedsearch_seo_lang` sl ON (s.`id_seo`=sl.`id_seo` AND sl.`id_lang`=1)
WHERE s.`seo_key` IN ("6b6b4f834a148adf99e64d0666726126")
AND s.`deleted`=0
181 ms 0 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE domain, domain_ssl
FROM sps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
181 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (13981, 13982, 13983, 13984, 13985, 13986, 13987, 13988, 13989, 13990, 13991, 13992, 13993, 13994, 13995, 13996, 13997, 13998, 13999, 14000, 14001, 14002, 14003, 14004) AND il.`id_lang` = 1 ORDER by i.`position`
180 ms 24 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE *
FROM `sps_product` a
LEFT JOIN `sps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `sps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 178) AND (b.`id_shop` = 1) LIMIT 1
180 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 8767
ORDER BY f.position ASC
179 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 178
ORDER BY f.position ASC
179 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE *
FROM `sps_cms_lang`
WHERE `id_cms` = 104 AND `id_shop` = 1
179 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE pa.`available_date` FROM `sps_product` p LEFT JOIN `sps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 137 AND pa.`id_product` = 137 AND pa.`id_product_attribute` = 13565 LIMIT 1
178 ms 1 /classes/Product.php:1138
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 147)
178 ms 40 /classes/Product.php:3829
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "revsliderprestashop" LIMIT 1
177 ms 1 /classes/module/Module.php:2840
(SELECT SQL_NO_CACHE * FROM `sps_cart_rule` cr
LEFT JOIN `sps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
176 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "creativeelements" LIMIT 1
175 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 137
ORDER BY f.position ASC
175 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE `name`, `alias` FROM `sps_hook_alias`
175 ms 83 /classes/Hook.php:301
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 147
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
174 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "header" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
173 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5188
ORDER BY f.position ASC
171 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE * FROM `sps_image_type`
171 ms 8 /classes/ImageType.php:147
SELECT SQL_NO_CACHE *
FROM `sps_whatsappchatblock_agent` LEFT JOIN `sps_whatsappchatblock_agent_lang` ON (`sps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `sps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `sps_whatsappchatblock_agent`.`id_whatsappchatblock` = 1 AND `active` = 1 ORDER BY position
170 ms 2 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
SELECT SQL_NO_CACHE * FROM `sps_ets_superspeed_cache_page`
WHERE 1  AND page="guest" AND id_object="10824864"
169 ms 1 /modules/ets_superspeed/classes/cache.php:284
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 149)
169 ms 24 /classes/Product.php:3829
SELECT SQL_NO_CACHE * FROM sps_revslider_sliders
169 ms 1 /modules/revsliderprestashop/includes/revslider_db.class.php:214
SELECT SQL_NO_CACHE *
FROM `sps_cms_category` a
LEFT JOIN `sps_cms_category_shop` `c` ON a.`id_cms_category` = c.`id_cms_category` AND c.`id_shop` = 1
WHERE (a.`id_cms_category` = 5) LIMIT 1
168 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_country` a
LEFT JOIN `sps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `sps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
167 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ets_superspeed" LIMIT 1
167 ms 1 /modules/ets_superspeed/ets_superspeed.php:3811
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ifeedback" LIMIT 1
167 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM sps_shop s
LEFT JOIN sps_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
167 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 147
ORDER BY f.position ASC
165 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 147 LIMIT 1
163 ms 40 /classes/Product.php:1040
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM sps_feature_product pf
LEFT JOIN sps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN sps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN sps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN sps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 149
ORDER BY f.position ASC
161 ms 1 Yes /classes/Product.php:5904
SELECT SQL_NO_CACHE name, alias FROM `sps_hook_alias`
159 ms 83 /classes/Hook.php:353
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 7508
AND image_shop.`cover` = 1 LIMIT 1
158 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE pa.`available_date` FROM `sps_product` p LEFT JOIN `sps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 5188 AND pa.`id_product` = 5188 AND pa.`id_product_attribute` = 85656 LIMIT 1
156 ms 1 /classes/Product.php:1138
SELECT SQL_NO_CACHE ads.* , adsl.*, ads.`id_search`
FROM `sps_pm_advancedsearch` ads
LEFT JOIN `sps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 1 )
WHERE ads.`id_search` = 1
AND `active` = 1
LIMIT 1
156 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 155)
155 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE `id_guest`
FROM `sps_connections`
WHERE `id_guest` = 10824864
AND `date_add` > '2026-08-19 22:58:00'
AND id_shop_group = 1 
ORDER BY `date_add` DESC LIMIT 1
154 ms 1 Yes /classes/Connection.php:154
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 10054)
154 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (85656, 85657) AND il.`id_lang` = 1 ORDER by i.`position`
150 ms 2 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 5188
AND image_shop.`cover` = 1 LIMIT 1
149 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE *
FROM `sps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
149 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "iqitproductsnav" LIMIT 1
148 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
148 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE c.*, cl.*
FROM `sps_cms_category` c
LEFT JOIN `sps_cms_category_lang` cl ON (c.`id_cms_category` = cl.`id_cms_category` AND `id_lang` = 1)
WHERE c.`id_cms_category` = 5 AND c.`id_parent` != 0
148 ms 5 /classes/CMSCategory.php:631
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "shiptopay" LIMIT 1
147 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 5188
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
147 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE `name`
FROM `sps_hook`
WHERE `id_hook` = 905 LIMIT 1
146 ms 1 /classes/Hook.php:239
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 5188)
146 ms 2 /classes/Product.php:3829
SELECT SQL_NO_CACHE * FROM `sps_ets_superspeed_cache_page`
WHERE 1  AND page="connection" AND id_object="9484344"
145 ms 1 /modules/ets_superspeed/classes/cache.php:284
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 8754
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
145 ms 0 /classes/Product.php:1651
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 7508)
145 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10054
AND image_shop.`cover` = 1 LIMIT 1
145 ms 8 /classes/Product.php:3542
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE `from` BETWEEN '2026-08-19 00:00:00' AND '2026-08-19 23:59:59' LIMIT 1
145 ms 1 /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 149
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
144 ms 0 /classes/Product.php:1651
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 2667)
143 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE pa.`available_date` FROM `sps_product` p LEFT JOIN `sps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 8767 AND pa.`id_product` = 8767 AND pa.`id_product_attribute` = 80416 LIMIT 1
143 ms 1 /classes/Product.php:1138
SELECT SQL_NO_CACHE *
FROM `sps_category` a
LEFT JOIN `sps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 47) LIMIT 1
143 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`available_date` FROM `sps_product` p LEFT JOIN `sps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 147 AND pa.`id_product` = 147 AND pa.`id_product_attribute` = 13820 LIMIT 1
143 ms 1 /classes/Product.php:1138
SELECT SQL_NO_CACHE `name`
FROM `sps_hook`
WHERE `id_hook` = 14 LIMIT 1
143 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "footer" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
142 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 8767)
141 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "bestkit_opc" LIMIT 1
139 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `width`, `height`
FROM sps_image_type
WHERE `name` = 'home_default' LIMIT 1
138 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (85656, 85657) AND il.`id_lang` = 1 ORDER by i.`position`
138 ms 2 Yes /classes/Product.php:2898
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 8754)
137 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE *
FROM `sps_simpleblog_category` sbc
LEFT JOIN `sps_simpleblog_category_lang` sbcl
ON (sbc.`id_simpleblog_category` = sbcl.`id_simpleblog_category` AND sbcl.`id_lang` = 1)
WHERE sbc.`id_parent` = 1 AND sbc.active = 1
ORDER BY sbc.`position` ASC
137 ms 1 Yes /modules/ph_simpleblog/models/SimpleBlogCategory.php:203
SELECT SQL_NO_CACHE *
FROM `sps_currency` a
LEFT JOIN `sps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `sps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
137 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 2667
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
136 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 8754
AND image_shop.`cover` = 1 LIMIT 1
136 ms 2 /classes/Product.php:3542
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayBeforeBodyClosingTag" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
135 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (80416) AND il.`id_lang` = 1 ORDER by i.`position`
135 ms 1 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (80416) AND il.`id_lang` = 1 ORDER by i.`position`
134 ms 1 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=5188
134 ms 7 /classes/Tag.php:229
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 149
AND image_shop.`cover` = 1 LIMIT 1
133 ms 8 /classes/Product.php:3542
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 8767
AND image_shop.`cover` = 1 LIMIT 1
133 ms 4 /classes/Product.php:3542
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 8767
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
132 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (14391) AND il.`id_lang` = 1 ORDER by i.`position`
131 ms 1 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
131 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE `iso_code`
FROM `sps_country`
WHERE `id_country` = 6 LIMIT 1
131 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
130 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE ads.* , adsl.*, ads.`id_search`
FROM `sps_pm_advancedsearch` ads
LEFT JOIN `sps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 1 )
WHERE ads.`id_search` IN (1)
ORDER BY ads.`position`
130 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 5188 LIMIT 1
129 ms 2 /classes/Product.php:1040
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 137
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
129 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 178
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
128 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE id_customer
FROM `sps_customer`
WHERE (email = "noreply@sps-sport.com.test") LIMIT 1
127 ms 1 /modules/onepagecheckoutps/onepagecheckoutps.php:1073
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=147
127 ms 3 /classes/Tag.php:229
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10054
126 ms 10 /classes/Tag.php:229
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `sps_product_attribute_image` pai
LEFT JOIN `sps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `sps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (14391) AND il.`id_lang` = 1 ORDER by i.`position`
126 ms 1 Yes /classes/Product.php:2898
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 13565 LIMIT 1
126 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE pa.`available_date` FROM `sps_product` p LEFT JOIN `sps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 149 AND pa.`id_product` = 149 AND pa.`id_product_attribute` = 13982 LIMIT 1
126 ms 1 /classes/Product.php:1138
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10054
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
126 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `sps_currency` c
LEFT JOIN sps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
125 ms 2 /classes/Currency.php:1126
SELECT SQL_NO_CACHE pa.`available_date` FROM `sps_product` p LEFT JOIN `sps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 155 AND pa.`id_product` = 155 AND pa.`id_product_attribute` = 14391 LIMIT 1
124 ms 1 /classes/Product.php:1138
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=155
122 ms 9 /classes/Tag.php:229
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=8767
122 ms 7 /classes/Tag.php:229
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 147
122 ms 40 /classes/Product.php:2879
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 8754 LIMIT 1
122 ms 1 /classes/Product.php:1040
SELECT SQL_NO_CACHE *
FROM `sps_category_lang`
WHERE `id_category` = 124 AND `id_shop` = 1
122 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13819) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
121 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "iqithtmlandbanners" LIMIT 1
121 ms 1 /classes/module/Module.php:2840
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 `sps_product` p
INNER JOIN `sps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `sps_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` = 178)
120 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13566) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
120 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 2667 LIMIT 1
120 ms 1 /classes/Product.php:1040
SELECT SQL_NO_CACHE DISTINCT g.`id_group`, g.`reduction`, g.`price_display_method`, g.`show_prices`, gl.`name`
FROM `sps_group` g
LEFT JOIN `sps_group_lang` AS gl ON (g.`id_group` = gl.`id_group` AND gl.`id_lang` = 1)
ORDER BY g.`id_group` ASC
119 ms 5 /classes/Group.php:111
SELECT SQL_NO_CACHE *
FROM `sps_cms_category_lang`
WHERE `id_cms_category` = 5 AND `id_shop` = 1
119 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 8767 LIMIT 1
117 ms 1 /classes/Product.php:1040
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 0 LIMIT 1
117 ms 1 /classes/SpecificPrice.php:411
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10054 LIMIT 1
117 ms 1 /classes/Product.php:1040
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 85656 LIMIT 1
116 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `sps_product` p
INNER JOIN sps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 155
AND DATEDIFF("2026-08-19 00:00:00", product_shop.`date_add`) < 60 LIMIT 1
116 ms 0 /classes/Product.php:1651
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 232) LIMIT 1
115 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13995) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
115 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=137
114 ms 5 /classes/Tag.php:229
SELECT SQL_NO_CACHE * FROM `sps_whatsappchatblock` LEFT JOIN `sps_whatsappchatblock_lang` ON (`sps_whatsappchatblock`.`id_whatsappchatblock` = `sps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
114 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 258) LIMIT 1
114 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`
FROM `sps_manufacturer`
WHERE `id_manufacturer` = 54
AND `active` = 1 LIMIT 1
113 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE domain
FROM `sps_shop_url`
WHERE (main = 1) AND (active = 1)
AND id_shop IN (1)
112 ms 1 /classes/shop/Shop.php:801
SELECT SQL_NO_CACHE `name`
FROM `sps_manufacturer`
WHERE `id_manufacturer` = 26
AND `active` = 1 LIMIT 1
112 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE id_page_type
FROM sps_page_type
WHERE name = 'cms' LIMIT 1
111 ms 1 /classes/Page.php:104
SELECT SQL_NO_CACHE *
FROM `sps_product_attribute` a
LEFT JOIN `sps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 80416) LIMIT 1
111 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `sps_hook_module_exceptions`
WHERE `id_shop` IN (1)
111 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE *
FROM `sps_category_lang`
WHERE `id_category` = 47 AND `id_shop` = 1
110 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
110 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `sps_customer_group`
WHERE (id_customer = 15243)
110 ms 1 /modules/onepagecheckoutps/onepagecheckoutps.php:1106
SELECT SQL_NO_CACHE `name`
FROM `sps_manufacturer`
WHERE `id_manufacturer` = 4
AND `active` = 1 LIMIT 1
109 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 149
109 ms 24 /classes/Product.php:2879
SELECT SQL_NO_CACHE s.`seo_key`, s.`id_seo`, sl.`seo_url`
FROM `sps_pm_advancedsearch_seo` s
JOIN `sps_pm_advancedsearch_seo_lang` sl ON (s.`id_seo`=sl.`id_seo` AND sl.`id_lang`=1)
WHERE s.`seo_key` IN ("91639ee4bdb5881decd1b946cb795ce1")
AND s.`deleted`=0
108 ms 0 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE *
FROM `sps_country` a
LEFT JOIN `sps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
108 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 155
AND image_shop.`cover` = 1 LIMIT 1
108 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 256) LIMIT 1
108 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_product_attribute` a
LEFT JOIN `sps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 85656) LIMIT 1
108 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=178
107 ms 3 /classes/Tag.php:229
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 137 LIMIT 1
107 ms 54 /classes/Product.php:1040
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
107 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 147
AND image_shop.`cover` = 1 LIMIT 1
107 ms 8 /classes/Product.php:3542
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sps_category_product` cp
INNER JOIN `sps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 397 AND ctg.`id_group` = 1 LIMIT 1
107 ms 2 /classes/Product.php:6624
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `sps_specific_price_priority`
WHERE `id_product` = 155
ORDER BY `id_specific_price_priority` DESC LIMIT 1
107 ms 1 /classes/SpecificPrice.php:250
SELECT SQL_NO_CACHE *
FROM `sps_product_attribute` a
LEFT JOIN `sps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 13982) LIMIT 1
106 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 235) LIMIT 1
106 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=2667
105 ms 1 /classes/Tag.php:229
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=8754
105 ms 8 /classes/Tag.php:229
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "iqitmegamenu" LIMIT 1
105 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `sps_cms` a
LEFT JOIN `sps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 104) LIMIT 1
104 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE tr.*
FROM `sps_tax_rule` tr
JOIN `sps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
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
104 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 8754
AND `required` = 1 AND `is_deleted` = 0
104 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE *
FROM `sps_product_attribute` a
LEFT JOIN `sps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 13820) LIMIT 1
103 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
103 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
102 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 137 LIMIT 1
102 ms 54 /classes/Product.php:1054
SELECT SQL_NO_CACHE name, value
FROM `sps_dynamicproduct_config`
WHERE (id_product = 8767)
102 ms 18 /modules/dynamicproduct/classes/models/DynamicConfig.php:132
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 147 LIMIT 1
101 ms 40 /classes/Product.php:1054
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 5188 LIMIT 1
101 ms 2 /classes/Product.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13981) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
100 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 137 LIMIT 1
100 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 149 LIMIT 1
100 ms 24 /classes/Product.php:1040
SELECT SQL_NO_CACHE 1 FROM sps_cart_product cp INNER JOIN sps_product p
ON (p.is_virtual = 0 AND p.id_product = cp.id_product) INNER JOIN sps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
100 ms 3 /classes/Cart.php:4235
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 37) LIMIT 1
99 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 7508
AND `required` = 1 AND `is_deleted` = 0
99 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
99 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 80416 LIMIT 1
99 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
98 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE c.*, c.id_ifb_criterion as id, cl.name, ct.type, ct.payment, ct.shipping
FROM `sps_ifb_criterion` c
INNER JOIN `sps_ifb_criterion_lang` `cl` ON cl.id_ifb_criterion = c.id_ifb_criterion AND cl.id_lang = 1
INNER JOIN `sps_ifb_criterion_type` `ct` ON ct.id_ifb_criterion = c.id_ifb_criterion
WHERE (c.default = 0) AND (c.deleted = 0) AND (ct.type = 2)
GROUP BY c.id_ifb_criterion
98 ms 1 Yes /modules/ifeedback/classes/CriterionClass.php:134
SELECT SQL_NO_CACHE `name`
FROM `sps_hook`
WHERE `id_hook` = 904 LIMIT 1
98 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE name, value
FROM `sps_dynamicproduct_config`
WHERE (id_product = 5188)
98 ms 18 /modules/dynamicproduct/classes/models/DynamicConfig.php:132
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 137
AND `required` = 1 AND `is_deleted` = 0
98 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "iqitsearch" LIMIT 1
98 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `sps_product_attribute` a
LEFT JOIN `sps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 13565) LIMIT 1
98 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `sps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
97 ms 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE name, value
FROM `sps_dynamicproduct_config`
WHERE (id_product = 10054)
97 ms 18 /modules/dynamicproduct/classes/models/DynamicConfig.php:132
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
97 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_country`
FROM `sps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
97 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 263 AND `id_shop` = 1 LIMIT 1
96 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 255) LIMIT 1
96 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 39) LIMIT 1
96 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13820) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
95 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `sps_image` i
INNER JOIN sps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 178
AND image_shop.`cover` = 1 LIMIT 1
95 ms 7 /classes/Product.php:3542
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 2) LIMIT 1
94 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 2667
AND `required` = 1 AND `is_deleted` = 0
94 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 10054
AND `required` = 1 AND `is_deleted` = 0
94 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
94 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 149 AND id_shop=1 LIMIT 1
93 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 5188
AND `required` = 1 AND `is_deleted` = 0
93 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE *
FROM `sps_product_attribute` a
LEFT JOIN `sps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 14391) LIMIT 1
93 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 8767 LIMIT 1
93 ms 1 /classes/Product.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13573) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
93 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 258
92 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `sps_country` a
LEFT JOIN `sps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
92 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 8767
AND `required` = 1 AND `is_deleted` = 0
92 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 10054 LIMIT 1
92 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 47 LIMIT 1
92 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE * FROM `sps_aff_configuration_lang`;
92 ms 3 /modules/psaffiliate/classes/AffConf.php:958
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 178 LIMIT 1
92 ms 1 /classes/Product.php:1040
SELECT SQL_NO_CACHE *
FROM `sps_country` a
LEFT JOIN `sps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `sps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
91 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
91 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_page`
FROM `sps_page`
WHERE `id_page_type` = 10 LIMIT 1
91 ms 1 /classes/Page.php:83
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 8754 LIMIT 1
90 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE `name`
FROM `sps_manufacturer`
WHERE `id_manufacturer` = 17
AND `active` = 1 LIMIT 1
90 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 2667 LIMIT 1
89 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE *
FROM `sps_simpleblog_category` sbc
LEFT JOIN `sps_simpleblog_category_lang` sbcl
ON (sbc.`id_simpleblog_category` = sbcl.`id_simpleblog_category` AND sbcl.`id_lang` = 1)
WHERE sbc.`id_parent` = 2 AND sbc.active = 1
ORDER BY sbc.`position` ASC
89 ms 1 Yes /modules/ph_simpleblog/models/SimpleBlogCategory.php:203
SELECT SQL_NO_CACHE * from sps_paytpv_terminal where id_shop=1 order by id LIMIT 1
88 ms 1 /modules/paytpv/classes/PaytpvTerminal.php:41
SELECT SQL_NO_CACHE * FROM `sps_aff_configuration`;
88 ms 46 /modules/psaffiliate/classes/AffConf.php:955
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 5188) AND (id_product_attribute = 85656) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
88 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE *
FROM `sps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
88 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 155 LIMIT 1
88 ms 1 /classes/Product.php:1040
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM sps_tag t
LEFT JOIN sps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=149
87 ms 6 /classes/Tag.php:229
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ets_superspeed" LIMIT 1
87 ms 1 /modules/ets_superspeed/ets_superspeed.php:3811
SELECT SQL_NO_CACHE *
FROM `sps_state` a
WHERE (a.`id_state` = 344) LIMIT 1
87 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`
FROM `sps_manufacturer`
WHERE `id_manufacturer` = 2
AND `active` = 1 LIMIT 1
86 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 137 LIMIT 1
86 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE name, value
FROM `sps_dynamicproduct_config`
WHERE (id_product = 7508)
85 ms 18 /modules/dynamicproduct/classes/models/DynamicConfig.php:132
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
85 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 155
85 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 257) LIMIT 1
85 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
85 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ps_searchbar" LIMIT 1
85 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
84 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 14391 LIMIT 1
84 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 147
AND `required` = 1 AND `is_deleted` = 0
84 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sps_category_product` cp
INNER JOIN `sps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 7508 AND ctg.`id_group` = 1 LIMIT 1
84 ms 2 /classes/Product.php:6624
SELECT SQL_NO_CACHE *
FROM `sps_module_shop` m
WHERE (m.id_module = 288) AND (m.enable_device & 1) AND (m.id_shop = 1)
84 ms 1 /modules/onepagecheckoutps/classes/OPCCore.php:617
SELECT SQL_NO_CACHE id_shop
FROM `sps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
84 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE name, value
FROM `sps_dynamicproduct_config`
WHERE (id_product = 8754)
84 ms 18 /modules/dynamicproduct/classes/models/DynamicConfig.php:132
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 8767 LIMIT 1
83 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 13982 LIMIT 1
83 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
83 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
83 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 3) LIMIT 1
83 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 235
83 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 8754
83 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
83 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 155
AND `required` = 1 AND `is_deleted` = 0
82 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 232
82 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 137
82 ms 54 /classes/Product.php:2879
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 8754) LIMIT 1
82 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 8767) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
82 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13619) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
82 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 5188) AND (id_product_attribute = 85657) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
82 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 2667) LIMIT 1
82 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
81 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `sps_country_lang`
WHERE `id_country` = 6
81 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 155 LIMIT 1
81 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE * FROM sps_bannerlateralhorario WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
81 ms 1 /modules/bannerlateralhorario/bannerlateralhorario.php:775
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 5188) AND (id_product_attribute = 85656) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
81 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 10054) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
81 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 149
AND `required` = 1 AND `is_deleted` = 0
81 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 38) LIMIT 1
81 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 2667
81 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13565) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
81 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 256
80 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 2667
80 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sps_category_product` cp
INNER JOIN `sps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 8135 AND ctg.`id_group` = 1 LIMIT 1
80 ms 2 /classes/Product.php:6624
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 178 LIMIT 1
80 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE c.*, c.id_ifb_criterion as id, cl.name, ct.type, ct.payment, ct.shipping
FROM `sps_ifb_criterion` c
INNER JOIN `sps_ifb_criterion_lang` `cl` ON cl.id_ifb_criterion = c.id_ifb_criterion AND cl.id_lang = 1
INNER JOIN `sps_ifb_criterion_type` `ct` ON ct.id_ifb_criterion = c.id_ifb_criterion
WHERE (c.default = 0) AND (c.deleted = 0) AND (ct.type = 3)
GROUP BY c.id_ifb_criterion
79 ms 1 Yes /modules/ifeedback/classes/CriterionClass.php:134
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 8767) AND (id_product_attribute = 80416) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
79 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `name`
FROM `sps_manufacturer`
WHERE `id_manufacturer` = 12
AND `active` = 1 LIMIT 1
79 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 5188 LIMIT 1
79 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE `id_attribute_group` FROM `sps_attribute_group` WHERE `is_color_group`=1
79 ms 42 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
79 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE *
FROM `sps_currency` a
LEFT JOIN `sps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `sps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
79 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_lang` FROM `sps_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
79 ms 5 /classes/Language.php:853
SELECT SQL_NO_CACHE id_category FROM `sps_pm_advancedsearch_category` WHERE id_search=1
79 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
79 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 7508 AND id_shop=1 LIMIT 1
79 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 236) LIMIT 1
79 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 7508 LIMIT 1
79 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 37
78 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sps_category_product` cp
INNER JOIN `sps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 7512 AND ctg.`id_group` = 1 LIMIT 1
78 ms 4 /classes/Product.php:6624
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 5188
78 ms 2 /classes/Product.php:2879
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 178 LIMIT 1
78 ms 5 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 2667) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
78 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE name, value
FROM `sps_dynamicproduct_config`
WHERE (id_product = 2667)
78 ms 18 /modules/dynamicproduct/classes/models/DynamicConfig.php:132
SELECT SQL_NO_CACHE `need_identification_number`
FROM `sps_country`
WHERE `id_country` = 6 LIMIT 1
77 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 137 AND `id_group` = 1 LIMIT 1
77 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 5188) LIMIT 1
77 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1
77 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 149 LIMIT 1
77 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 2667) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
77 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 10054) LIMIT 1
77 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE `id_lang` FROM `sps_lang` WHERE `iso_code` = 'es' LIMIT 1
77 ms 5 /classes/Language.php:824
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sps_category_product` cp
INNER JOIN `sps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 6986 AND ctg.`id_group` = 1 LIMIT 1
77 ms 1 /classes/Product.php:6624
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 8767
76 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `sps_product_attribute` pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 13820 LIMIT 1
76 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `sps_category_product` cp
INNER JOIN `sps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 2116 AND ctg.`id_group` = 1 LIMIT 1
76 ms 1 /classes/Product.php:6624
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 8767) LIMIT 1
76 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 47 LIMIT 1
75 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE *
FROM `sps_module_shop` m
WHERE (m.id_module = 288) AND (m.enable_device & 1) AND (m.id_shop = 1)
75 ms 1 /modules/onepagecheckoutps/classes/OPCCore.php:617
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 8754) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
75 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ybc_blog" LIMIT 1
75 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 7508) LIMIT 1
75 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13982) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
75 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 10054) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
75 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 149 LIMIT 1
75 ms 24 /classes/Product.php:1054
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
74 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 5188) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
74 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 251 AND `id_shop` = 1 LIMIT 1
74 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 155) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
74 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 8754) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
74 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "marketplace" LIMIT 1
74 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 10054
74 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 149 LIMIT 1
74 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE id_shop
FROM `sps_cms_shop`
WHERE `id_cms` = 104
AND id_shop = 1 LIMIT 1
74 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 10054) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
74 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
73 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 5188 LIMIT 1
73 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 5188) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
73 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 7508) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
73 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "tmsearch" LIMIT 1
73 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `name`
FROM `sps_manufacturer`
WHERE `id_manufacturer` = 7
AND `active` = 1 LIMIT 1
73 ms 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
73 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 39
72 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 155) AND (id_product_attribute = 14391) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
72 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_country_lang`
WHERE `id_country` = 21
72 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 137
72 ms 54 /classes/Product.php:2879
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `sps_specific_price_priority`
WHERE `id_product` = 7508
ORDER BY `id_specific_price_priority` DESC LIMIT 1
72 ms 1 /classes/SpecificPrice.php:250
SELECT SQL_NO_CACHE ctg.`id_group`
FROM sps_category_group ctg
WHERE ctg.`id_category` = 124 AND ctg.`id_group` = 1 LIMIT 1
72 ms 1 /classes/Category.php:1730
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 8767 LIMIT 1
72 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM sps_product_attribute pa
INNER JOIN sps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 155 LIMIT 1
72 ms 1 /classes/Product.php:1054
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 10054 LIMIT 1
71 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 137 AND id_shop=1 LIMIT 1
71 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 8754 LIMIT 1
71 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 155 LIMIT 1
71 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE * FROM `sps_bannerlateralhorario_files` where `id_store`=1 and `id_lang`=1 LIMIT 1
71 ms 1 /modules/bannerlateralhorario/bannerlateralhorario.php:796
SELECT SQL_NO_CACHE *
FROM `sps_group` a
LEFT JOIN `sps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
71 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 38
71 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 2667 LIMIT 1
70 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `sps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 124 LIMIT 1
70 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 8767) AND (id_product_attribute = 80416) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
70 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 147
70 ms 40 /classes/Product.php:2879
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `sps_customization_field`
WHERE `id_product` = 178
AND `required` = 1 AND `is_deleted` = 0
70 ms 1 /classes/Product.php:6503
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 46) LIMIT 1
69 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 7508
69 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13820) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
69 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 255
68 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 5188
68 ms 2 /classes/Product.php:2879
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 8767) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
68 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 7508 LIMIT 1
68 ms 2 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
67 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13575) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
67 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE name, value
FROM `sps_dynamicproduct_config`
WHERE (id_product = 10173)
67 ms 18 /modules/dynamicproduct/classes/models/DynamicConfig.php:132
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
67 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13982) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
67 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13596) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
67 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 124 LIMIT 1
67 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 253 AND `id_shop` = 1 LIMIT 1
67 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 155) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
67 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
67 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE `id_order`
FROM `sps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
66 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "winamic_linkobfuscator" LIMIT 1
66 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
66 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE *
FROM `sps_tax` a
WHERE (a.`id_tax` = 31) LIMIT 1
66 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
66 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 265 AND `id_shop` = 1 LIMIT 1
66 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 124 LIMIT 1
66 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 237) LIMIT 1
66 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 117 AND `id_shop` = 1 LIMIT 1
66 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "iqitelementor" LIMIT 1
65 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE c.id_ifb_criterion
FROM `sps_ifb_criterion` c
WHERE (c.default = 1) LIMIT 1
65 ms 0 /modules/ifeedback/classes/CriterionClass.php:105
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 8754
65 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "dynamicproduct" LIMIT 1
65 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 8767
65 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE ctg.`id_group`
FROM sps_category_group ctg
WHERE ctg.`id_category` = 47 AND ctg.`id_group` = 1 LIMIT 1
65 ms 1 /classes/Category.php:1730
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 10054
65 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE *
FROM `sps_tax_lang`
WHERE `id_tax` = 31
64 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 178
64 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13608) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
64 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 47 LIMIT 1
64 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 40) LIMIT 1
64 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 47 LIMIT 1
64 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 178) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
64 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13622) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
64 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 10054) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
64 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 124 LIMIT 1
64 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 268 AND `id_shop` = 1 LIMIT 1
64 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE c.id_currency
FROM `sps_currency` c
WHERE (iso_code = 'AED') LIMIT 1
63 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13576) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
63 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13577) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
63 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 178) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
63 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 2667) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
63 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM sps_required_field
62 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13565) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
62 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
62 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_currency` a
LEFT JOIN `sps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
62 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 8754) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
61 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13578) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
61 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13597) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
61 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
61 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 238
61 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 18 AND `id_shop` = 1 LIMIT 1
61 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 5188 AND id_shop=1 LIMIT 1
61 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 10054 AND id_shop=1 LIMIT 1
61 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE `to` BETWEEN '2026-08-19 00:00:00' AND '2026-08-19 23:59:59' LIMIT 1
61 ms 1 /classes/SpecificPrice.php:366
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13592) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
61 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE 1 FROM `sps_specific_price` WHERE id_product = 147 LIMIT 1
61 ms 1 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13601) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13599) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13612) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13581) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13579) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13600) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 43) LIMIT 1
60 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 147) LIMIT 1
60 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 155 AND id_shop=1 LIMIT 1
60 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13586) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13609) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 8767) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13595) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 5188) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13598) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
60 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 7508 AND `id_group` = 1 LIMIT 1
60 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 8754) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13606) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13607) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13593) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13582) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 8767 AND id_shop=1 LIMIT 1
59 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 178
59 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 8767) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `name` FROM `sps_supplier` WHERE `id_supplier` = 0 LIMIT 1
59 ms 0 /classes/Supplier.php:244
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13583) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13590) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13589) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13591) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13588) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13585) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13611) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13602) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 149) LIMIT 1
59 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13616) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13618) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "amazonpay" LIMIT 1
59 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13605) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 2667) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13603) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13580) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
59 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 8754 AND id_shop=1 LIMIT 1
58 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13623) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
58 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13587) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
58 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
58 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13617) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
58 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13615) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
58 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13613) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
58 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 3
58 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13610) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
58 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ps_imageslider" LIMIT 1
57 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 5188) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
57 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 124 LIMIT 1
57 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 155
57 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 2667 AND id_shop=1 LIMIT 1
57 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE * FROM `sps_aff_configuration_lang`;
57 ms 3 /modules/psaffiliate/classes/AffConf.php:958
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 421) LIMIT 1
56 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_group_lang`
WHERE `id_group` = 1
56 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 155) AND (id_product_attribute = 14391) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
56 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `sps_product_attribute`
WHERE `id_product` = 149
55 ms 24 /classes/Product.php:2879
SELECT SQL_NO_CACHE *
FROM `sps_currency_lang`
WHERE `id_currency` = 1
55 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 214 AND `id_shop` = 1 LIMIT 1
55 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 5188 AND `id_group` = 1 LIMIT 1
55 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE id_supplier FROM `sps_pm_advancedsearch_suppliers` WHERE id_search=1
55 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 149 AND `id_group` = 1 LIMIT 1
55 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 8767 AND `id_group` = 1 LIMIT 1
54 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 155 AND `id_group` = 1 LIMIT 1
54 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 44) LIMIT 1
54 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE out_of_stock
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
54 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE COUNT(*) FROM `sps_pack` WHERE id_product_pack = 147 LIMIT 1
54 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE id_category FROM `sps_pm_advancedsearch_products_cat` WHERE id_search=1
54 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 259) LIMIT 1
54 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "contactform" LIMIT 1
54 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 259 AND `id_shop` = 1 LIMIT 1
54 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13844) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
54 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
53 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 56 AND `id_shop` = 1 LIMIT 1
53 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 47 LIMIT 1
53 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 2
53 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 1) LIMIT 1
53 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
52 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 2667 AND `id_group` = 1 LIMIT 1
52 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 8754 AND `id_group` = 1 LIMIT 1
52 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "leoproductsearch" LIMIT 1
52 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE name FROM sps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 47 LIMIT 1
52 ms 1 /classes/Product.php:5621
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13821) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
52 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `reduction`
FROM `sps_product_group_reduction_cache`
WHERE `id_product` = 10054 AND `id_group` = 1 LIMIT 1
52 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_zone`
FROM `sps_country`
WHERE `id_country` = 21 LIMIT 1
52 ms 1 /classes/Country.php:223
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 155) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
51 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 40
51 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 46
51 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `sps_specific_price_priority`
WHERE `id_product` = 178
ORDER BY `id_specific_price_priority` DESC LIMIT 1
51 ms 1 /classes/SpecificPrice.php:250
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 273 AND `id_shop` = 1 LIMIT 1
51 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 42) LIMIT 1
51 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 237
51 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 44
51 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_lang` FROM `sps_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
51 ms 5 /classes/Language.php:853
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13983) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
51 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
51 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 15 AND `id_shop` = 1 LIMIT 1
51 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `sps_attribute` a
LEFT JOIN `sps_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = 1
WHERE (a.`id_attribute` = 238) LIMIT 1
51 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 43
51 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE id_cms FROM `sps_pm_advancedsearch_cms` WHERE id_search=1
51 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 155) LIMIT 1
50 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13567) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
50 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 259
49 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13620) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
49 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 236
49 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13991) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
49 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE id_manufacturer FROM `sps_pm_advancedsearch_manufacturers` WHERE id_search=1
49 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
49 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13845) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
49 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 421
49 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE page FROM `sps_pm_advancedsearch_special_pages` WHERE id_search=1
49 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 147 AND id_shop=1 LIMIT 1
48 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE id_product FROM `sps_pm_advancedsearch_products` WHERE id_search=1
48 ms 1 /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
48 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 178) LIMIT 1
48 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE `reduction`
FROM `sps_group`
WHERE `id_group` = 1 LIMIT 1
48 ms 1 /classes/Group.php:154
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 257
47 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13985) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
47 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 178) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
47 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 42
47 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 155) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
47 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "spsearchpro" LIMIT 1
47 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE c.id_currency
FROM `sps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
46 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ps_banner" LIMIT 1
46 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `sps_product_shop`
WHERE `id_product` = 178 AND id_shop=1 LIMIT 1
46 ms 1 /classes/Product.php:6760
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13854) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
46 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `sps_attribute_lang`
WHERE `id_attribute` = 1
46 ms 5 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13846) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
45 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "blockbanner" LIMIT 1
45 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 178) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
45 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13858) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
45 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13829) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
45 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13842) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
45 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13838) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
45 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
44 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13984) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
44 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13837) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
44 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE id_product_source
FROM `sps_dynamicproduct_product_config_link`
WHERE (id_product = 137) LIMIT 1
44 ms 152 /modules/dynamicproduct/classes/models/DynamicProductConfigLink.php:76
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
44 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13621) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
43 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_lang` FROM `sps_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
43 ms 5 /classes/Language.php:853
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13568) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
43 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13986) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
43 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
43 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE depends_on_stock
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
43 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13822) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
43 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "blocksearch_mod" LIMIT 1
43 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "tvcmssearch" LIMIT 1
42 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13572) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13987) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13852) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13569) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13847) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
42 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE id_shop
FROM `sps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
42 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
42 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13996) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13855) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13857) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13992) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
42 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE id_shop
FROM `sps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
41 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 137) AND (id_product_attribute = 13570) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "labsearch" LIMIT 1
41 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
41 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
41 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13988) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 14004) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
41 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13834) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13839) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13823) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13848) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13851) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "ttblocksearch" LIMIT 1
41 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "jmsajaxsearch" LIMIT 1
41 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
41 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
41 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "stsearchbar" LIMIT 1
41 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
41 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE location
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "labblocksearch" LIMIT 1
41 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13989) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 14001) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 13997) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
41 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `sps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
41 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `sps_module` WHERE `name` = "tdsearchblock" LIMIT 1
40 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 14000) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
40 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13827) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
40 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13830) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
40 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `sps_stock_available`
WHERE (id_product = 147) AND (id_product_attribute = 13831) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
40 ms 1 /classes/stock/StockAvailable.php:453