Silla de Ruedas Linus 500 Rueda Grande 43R/G, 46R/G y 49 R/G
search
  • Silla de Ruedas Linus 500 Rueda Grande 43R/G, 46R/G y 49 R/G

Silla de Ruedas Linus 500 Rueda Grande 43R/G, 46R/G y 49 R/G

Silla de ruedas Ligera y manual con respaldo. Tapicería de nylon, ignífuga e impermeable. Se puede desmontar y lavar.
Ruedas traseras grandes extraibles con sistema Quick Release (fácil extracción).
Hasta 115 kg.

¡SOLO ESTA SEMANA! -5% en todos los productos
(no acumulable a otras promos y ofertas, excluidos medicamentos y test COVID). El descuento se aplica automáticamente en el carrito.

  • Solo disponible en Tenerife, La Palma, La Gomera y El Hiero (Canarias, España).
  • ¡Muestras gratis en tu pedido de +59€!
  • ¿Necesitas más unidades? ¿No encuentras lo que buscas? Contáctanos
  • Confianza Online Pago seguro Métodos de pago

Silla de ruedas manual autopropulsable y plegable. Fabricada en material ligero, es de aluminio y aguanta un peso de hasta 115 Kg. La tapicería es de nylon, ignífuga, desmontable y lavable. Ruedas delanteras y traseras macizas.

Cuenta con:

  • Reposabrazos desmontables y/o abatibles
  • Reposapiés abatibles y regulables
  • Ruedas de desmontaje rápido “quick release”

 En función del Radio de rueda tenemos:

M
odelo
C.I. Color Longitud total
cm
Ancho total
cm
Alto total
cm
Ancho total silla plegada
cm
Ancho asiento
cm
Prof. asiento
cm
Altura respaldo
cm
Altura suelo-asiento
cm
Peso máx. usuario
kg
Diam. rueda delantera
mm
Diam. rueda trasera
mm
Peso sin reposapiés
kg
Material Freno Acompañante
43 R/G 561027 gris 84 62 93 30 43  41 46 44 115 200 600 16 Acero NO
600101 azul 84 62 93 30 43  41 46 44 115 200 600 16 Acero NO
600413 gris 84 62 93 30 43  41 46 44 115 200 600 16 Acero SI
46 R/G 600103 gris 84 65 93 30 46  41 46 44 115 200 600 16 Acero NO
600102 azul 84 65 93 30 46  41 46 44 115 200 600 16 Acero NO
600414 gris 84 65 93 30 46  41 46 44 115 200 600 16 Acero SI
49 R/G 600104 gris 84 68 93 30 48  41 46 44 115 200 600 16 Acero NO

*Si lo desea este modelo cuenta con Recambios y Accesorios que puede solicitar con coste adicional:

Ref. Recambios y accesorios
AC SILLA 01 Asiento anatómico 43
AC SILLA 02 Asiento anatómico 46
AC SILLA 03 Asiento inodoro anatómico 43
AC SILLA 04 Asiento inodoro anatómico 46
AC SILLA 05 Respaldo anatómico 43
AC SILLA 06 Respaldo anatómico 46
600146 Reposacabezas estándar
600148 Reposacabezas anatómico
600108 Reposabrazos
600109-Azul Reposabrazos
600110-Cromado Reposabrazos
600112 Reposapiés elevable
600119 Ruedas antivuelco
600121 Lateral plástico
559187 Soporta bastones
599753 Bolsa silla
600124 Horquilla
600118 Rueda trasera pequeña
600115 Rueda delantera
600117 Rueda trasera grande
600122 Freno rueda grande
600123 Freno rueda pequeña
600120 Empuñadura

La Farmacia Online Farmaten envía gratis sus productos a toda España incluyendo Albacete, Ciudad Real, Cuenca, Guadalajara y Toledo.

Costes de Envío
Canarias
Islas Canarias
Gratis (pedidos 34,99€)
Entrega 24h/72h
Península
Península
Gratis (pedidos 54,99€)
Entrega 5-12 días
No se envían medicamentos
Portugal
Portugal y Baleares
Gratis (pedidos 69,99€)
Entrega 5-12 días
No se envían medicamentos
Farmacia Finca España, en La Laguna, Tenerife
Recogida Tienda
Aparcamiento fácil. Sin colas
¡Te avisamos cuando está listo!
Sin pedido mínimo
Canarias Península Baleares Portugal (Continental)
Sólo Parafarmacia y medicamentos veterinarios Con Medicamentos para humanos Parafarmacia Parafarmacia Parafarmacia
Importe →
↓ Peso
≤ 34,99 € > 34,99 € ≤ 79,99 € > 79,99 € ≤ 54,99 € > 54,99 € ≤ 69,99 € > 69,99 € ≤ 69,99 € > 69,99 €
0-5 kg 7,50 € Gratis 13,00 € Gratis 12,50 € Gratis 17,00 € Gratis 18,00 € Gratis
5-10 kg 11,99 € 11,99 € 13,00 € Gratis 22,00 € 12,00 € 32,00 € 21,00 € 36,00 € 25,00 €
10-15 kg 16,00 € 16,00 € 13,00 € Gratis 26,00 € 16,00 € 38,00 € 27,00 € 42,00 € 31,00 €
15 o más kg +1 €/kg +1 €/kg +1 €/kg Gratis +1 €/kg +1 €/kg +1 €/kg +1 €/kg +1,24 €/kg +1,24 €/kg

No realizamos envíos a apartados de correos.
Los tiempos de envío se contabilizan desde el siguiente día laborable al de realización del pedido.

Pagos
SSL
Pagos seguros: usamos SSL
SSL (Secure Socket Layer) es un estándar que permite las transacciones financieras electrónicas seguras en Internet. Esta tecnología está incorporada en nuestros servidores y usa una encriptación compleja de los datos.
TPV
Tarjeta de crédito o débito
Utilizamos la pasarela de pago segura del Banco Cajasiete. Sus datos son encriptados por medio del protocolo SSL 128 bits y en ningún momento almacenaremos ningún dato bancario de su tarjeta de crédito.
PayPal Logo
PayPal
También puede utilizar el servicio de pago de Paypal, líder internacional en soluciones de pagos por Internet.
Transferencia
Transferencia bancaria
Los datos para realizar la transferencia los recibirá en su correo electrónico al finalizar el pedido. Su pedido será preparado una vez nos llegue el pago. Tenga en cuenta que el abono puede tardar de 24 a 72 horas hábiles.
Bizum
Bizum
También puede utilizar Bizum para pagar cómodamente desde su móvil, tan sólo tiene que tener activado el servicio en su banco, introducir su número de móvil y validar la compra introduciendo su clave Bizum o en la aplicación móvil de su banco.

Cambios

Para realizar cualquier cambio del producto recibido deberá ponerse en contacto con nosotros en un plazo máximo de 14 días naturales después de la llegada del pedido.

Excepto en medicamentos y productos precintados según la normativa vigente. Puede consultar todas las condiciones en las Condiciones de Compra.

Desistimiento

El plazo de desistimiento expirará a los 14 días naturales del día que usted o un tercero por usted indicado, distinto del transportista, adquirió la posesión material de los bienes comprados.

Excepto en medicamentos y otras excepciones recogidas en la normativa vigente. Puede consultar todas las condiciones en las Condiciones de Compra.

Cancelación

Se podrá cancelar sin coste cualquier pedido que no haya sido enviado. Si el pedido ya ha sido enviado, no se podrá aceptar su cancelación si contiene medicamentos o productos que no admiten devolución.

Puede consultar todas las condiciones en las Condiciones de Compra.

Impuestos

Los precios de compra vigentes en el momento en que se realiza el pedido son los que aparecen en pantalla, salvo error tipográfico. Los precios se indican en euros e incluyen el IVA cuando se ha seleccionado la compra para la Península Ibérica, Islas Baleares y Portugal continental. Cuando se ha seleccionado la compra para las Islas Canarias, los precios incluyen el IGIC. Por este motivo, si cambia de destino para su compra, los precios de los productos pueden verse alterados debido a que se aplican impuestos diferentes.

En general, cualquier impuesto, tasa, tributo, despacho de aduanas y corretaje que se devengue como consecuencia de la compraventa de productos, así como cuales quiera otros gastos que se deriven de la misma, serán por cuenta y cargo del Usuario/Comprador.

Seguridad

En Farmaten contamos con el Certificado de Responsabilidad Social Corporativa de Confianza Online desde el año 2019. Esto implica nuestro compromiso con las normas acerca de la publicidad digital, el comercio electrónico con consumidores, la protección de datos y de menores en Internet.

Úsalo también con…

group_work Consentimiento de cookies
Load Time 257.840 ms
Querying Time 119 ms
Queries 858
Memory Peak Usage 73.7 Mb
Included Files 1113 files - 14.64 Mb
PrestaShop Cache - Mb
Global vars 1.21 Mb
PrestaShop Version 8.1.4
PHP Version 8.1.31
MySQL Version 10.6.22-MariaDB-log
Memory Limit 512M
Max Execution Time 60s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 7.762 ms 7.762 ms 16.76 Mb 16.8 Mb
__construct 2.592 ms 10.354 ms 3.35 Mb 20.9 Mb
init 42.789 ms 53.143 ms 12.54 Mb 32.7 Mb
setMedia 2.107 ms 55.250 ms 0.11 Mb 32.8 Mb
postProcess 0.002 ms 55.252 ms - Mb 32.8 Mb
initHeader 0.001 ms 55.253 ms - Mb 32.8 Mb
initContent 69.872 ms 125.125 ms 15.14 Mb 48.2 Mb
initFooter 0.001 ms 125.126 ms - Mb 48.2 Mb
display 132.714 ms 257.840 ms 25.52 Mb 73.7 Mb
Hook Time Memory Usage
displayFooterProduct 67.795 ms 14.22 Mb
DisplayProductListReviews 28.298 ms 5.31 Mb
DisplayProductAdditionalInfo 24.230 ms 4.38 Mb
DisplayHeader 13.764 ms 1.41 Mb
DisplayBeforeBodyClosingTag 11.633 ms 4.15 Mb
DisplayReassurance 3.397 ms 0.52 Mb
DisplayNav2 3.022 ms 0.25 Mb
ActionGetProductPropertiesAfterUnitPrice 2.926 ms 0.31 Mb
ActionGetProductPropertiesAfter 2.212 ms 0.44 Mb
Header 1.996 ms 0.04 Mb
displayNav1 1.775 ms 0.20 Mb
DisplayProductExtraContent 1.550 ms 0.14 Mb
DisplayMegaMenu 1.532 ms 0.34 Mb
ActionOutputHTMLBefore 1.228 ms 0.01 Mb
ActionFrontControllerSetMedia 1.100 ms 0.04 Mb
DisplayFooterProduct 0.948 ms 0.06 Mb
ActionFrontControllerInitAfter 0.889 ms 0.02 Mb
DisplayBanner 0.617 ms 0.03 Mb
DisplayFooter 0.560 ms 0.03 Mb
DisplayNav1 0.531 ms 0.02 Mb
displayTop 0.521 ms 0.02 Mb
displayFooter 0.515 ms 0.07 Mb
DisplayAfterProductThumbs 0.479 ms 0.03 Mb
DisplayFooterAfter 0.470 ms 0.02 Mb
DisplayFooterBefore 0.461 ms 0.02 Mb
DisplayTop 0.458 ms 0.02 Mb
DisplayProductRating 0.443 ms 0.05 Mb
DisplayOverrideTemplate 0.397 ms 0.05 Mb
displayNav2 0.370 ms 0.01 Mb
ActionFrontControllerSetVariables 0.315 ms 0.02 Mb
displayFooterAfter 0.268 ms 0.02 Mb
ModuleRoutes 0.267 ms 0.01 Mb
displayReassurance 0.241 ms 0.04 Mb
displayWrapperTop 0.107 ms 0.02 Mb
displayNavFullWidth 0.097 ms 0.02 Mb
ActionProductFlagsModifier 0.025 ms - Mb
ActionDispatcher 0.010 ms - Mb
ActionObjectAddAfter 0.008 ms - Mb
DisplayWrapperBottom 0.007 ms - Mb
FilterProductContent 0.006 ms - Mb
ActionPresentProduct 0.005 ms - Mb
DisplayAfterBodyOpeningTag 0.004 ms - Mb
ActionFrontControllerAfterInit 0.002 ms - Mb
ActionFilterDeliveryOptionList 0.001 ms - Mb
44 hook(s) 175.480 ms 32.35 Mb
Module Time Memory Usage
revi 3.549 ms 0.27 Mb
cookiesplus 7.067 ms 3.70 Mb
ets_geolocation 4.020 ms 0.31 Mb
quantitydiscountpro 48.776 ms 9.34 Mb
fc_farmaten 6.048 ms 0.81 Mb
fc_farmaten_app 0.324 ms 0.02 Mb
fc_medicamentos 3.665 ms 0.40 Mb
fc_specialbrands 0.205 ms 0.02 Mb
sociallogin 2.134 ms 0.22 Mb
ps_emailsubscription 0.574 ms 0.03 Mb
fc_cartintegrate 2.553 ms 0.15 Mb
freshwordpress 0.204 ms 0.02 Mb
fc_inflamables 1.355 ms 0.27 Mb
productvideo 4.427 ms 3.54 Mb
dwfproductextrafields 1.401 ms 0.15 Mb
rcpgtagmanager 8.691 ms 0.34 Mb
ets_superspeed 1.305 ms 0.11 Mb
ps_shoppingcart 0.369 ms 0.02 Mb
ps_searchbar 0.566 ms 0.02 Mb
fc_farmaten_sync 0.224 ms 0.02 Mb
freshfixedheader 0.295 ms 0.02 Mb
ets_htmlbox 5.528 ms 0.30 Mb
ets_recaptcha_free 0.322 ms 0.03 Mb
ets_megamenu 5.013 ms 4.83 Mb
ps_customersignin 0.361 ms 0.02 Mb
whatsappchat 2.189 ms 0.21 Mb
paypal 4.495 ms 0.35 Mb
correosoficial 4.460 ms 3.76 Mb
sendinblue 1.187 ms 0.08 Mb
autoloyalty 0.880 ms 0.06 Mb
ps_languageselector 1.587 ms 0.16 Mb
ps_categoryproducts 67.237 ms 14.14 Mb
ps_crossselling 0.754 ms 0.10 Mb
ps_viewedproduct 0.312 ms 0.06 Mb
ps_linklist 2.268 ms 0.12 Mb
statsdata 5.350 ms 3.66 Mb
amazzingfilter 0.846 ms 3.37 Mb
37 module(s) 200.541 ms 51.05 Mb

Stopwatch SQL - 858 queries

# Query Time (ms) Rows Filesort Group By Location
405
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 277
AND 8 != o.current_state LIMIT 1
1.867 ms 1043 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
76
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.593 ms 607 /classes/Hook.php:456
2
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1.413 ms 1465 /classes/Configuration.php:180
75
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.361 ms 0 /classes/Hook.php:1292
16
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
1.242 ms 204 Yes Yes /classes/Hook.php:1233
127
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-06-18 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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 `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 8122 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.189 ms 3 Yes /classes/Product.php:4685
849
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('4005045', '', 'www.farmaten.com/es/ortopedia/ayudas-dinamicas-ortopedia/andadores-y-sillas/silla-de-ruedas-linus-500-rueda-grande-43rg-46rg-y-49-rg.html', '', '2025-06-18 05:45:38')
1.162 ms 1 /classes/ObjectModel.php:622
516
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("2025-06-18 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_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 ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_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 `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 755 AND  p.id_category_default not in (341,763,362,360,764,795,765,766,364,767,768,366,769,770,771,367,772,773,774,365,775,776,777,778,1125,1190) AND stock.quantity > 0 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 9
0.959 ms 26 Yes /override/classes/Category.php:151
149
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 341 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  
AND c.`active` = 1
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.860 ms 137 Yes Yes /classes/Category.php:799
28
SELECT SQL_NO_CACHE cl.id_category FROM ps_category_lang cl
LEFT JOIN ps_category c ON c.id_category =cl.id_category 
LEFT JOIN ps_category_lang cl2 ON cl2.id_category =c.id_parent 
WHERE cl.link_rewrite = "silla-de-ruedas-linus-500-rueda-grande-43rg-46rg-y-49-rg.html" AND cl.id_lang = 1 AND cl.id_shop = 1
AND cl2.id_lang = 1 AND cl2.id_shop = 1 AND cl2.link_rewrite = "andadores-y-sillas" LIMIT 1
0.856 ms 437 /override/classes/Dispatcher.php:1348
72
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8122) AND (b.`id_shop` = 1) LIMIT 1
0.853 ms 1 /src/Adapter/EntityMapper.php:71
214
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8122
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.630 ms 1 Yes Yes /classes/Product.php:4581
848
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('5020017', '6304', '308350555', '', '1', '1', '2025-06-18 05:45:38')
0.569 ms 1 /classes/ObjectModel.php:622
151
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 1190 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  
AND c.`active` = 1
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.550 ms 138 Yes Yes /classes/Category.php:799
851
UPDATE `ps_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 147
AND `id_page` = 6304
AND `id_shop` = 1
0.545 ms 1 /classes/Page.php:131
115
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 755
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.427 ms 1 Yes Yes /classes/Category.php:924
216
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-06-18 00:00:00" AND date_to <= "2025-06-18 23:59:59") OR (date_from >= "2025-06-18 00:00:00" AND date_from <= "2025-06-18 23:59:59") OR (date_from < "2025-06-18 00:00:00" AND date_to > "2025-06-18 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
0.402 ms 827 /classes/CartRule.php:357
217
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 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
0.395 ms 189 /classes/CartRule.php:418
97
SHOW TABLES LIKE "%ps_social_login_%"
0.394 ms 1 /modules/sociallogin/src/Helpers/SocialLoginInstall.php:103
29
SELECT SQL_NO_CACHE id_category FROM ps_category_lang
WHERE link_rewrite = "silla-de-ruedas-linus-500-rueda-grande-43rg-46rg-y-49-rg.html" AND id_lang = 1 AND id_shop = 1 LIMIT 1
0.392 ms 874 /override/classes/Dispatcher.php:1348
505
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5117) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.392 ms 1 Yes /classes/Product.php:4507
201
SELECT SQL_NO_CACHE pef.id_product_extra_field 
FROM ps_product_extra_field pef WHERE pef.id_product = 8122 LIMIT 1
0.379 ms 823 /modules/dwfproductextrafields/models/ProductExtraField.php(143) : eval()'d code:43
119
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.376 ms 494 /classes/SpecificPrice.php:310
39
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.366 ms 346 /classes/module/Module.php:2018
218
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-06-18 00:00:00" AND date_to <= "2025-06-18 23:59:59") OR (date_from >= "2025-06-18 00:00:00" AND date_from <= "2025-06-18 23:59:59") OR (date_from < "2025-06-18 00:00:00" AND date_to > "2025-06-18 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
0.342 ms 827 /classes/CartRule.php:357
15
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
0.331 ms 1097 /classes/Hook.php:1332
96
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.319 ms 437 Yes /classes/Product.php:7834
295
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 2
ORDER BY hb.`id_ets_hb_html_box` ASC
0.317 ms 1 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
137
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.313 ms 437 Yes /classes/Product.php:7834
824
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 12
ORDER BY hb.`id_ets_hb_html_box` ASC
0.310 ms 1 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
174
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.309 ms 437 Yes /classes/Product.php:7834
204
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.309 ms 437 Yes /classes/Product.php:7834
155
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.303 ms 437 Yes /classes/Product.php:7834
299
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.298 ms 437 Yes /classes/Product.php:7834
728
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5118) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.291 ms 1 Yes /classes/Product.php:4507
302
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 1
ORDER BY hb.`id_ets_hb_html_box` ASC
0.287 ms 2 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
501
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 11
ORDER BY hb.`id_ets_hb_html_box` ASC
0.285 ms 1 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
40
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.283 ms 114 /classes/module/Module.php:345
507
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5118) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.280 ms 1 Yes /classes/Product.php:4507
21
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.278 ms 114 /classes/module/Module.php:345
24
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.276 ms 47 Yes /override/classes/Dispatcher.php:186
205
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8122 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 8122 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.274 ms 0 /classes/Cart.php:1410
504
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.266 ms 437 Yes /classes/Product.php:7834
658
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5118)
0.263 ms 1 /classes/ProductAssembler.php:64
649
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5114)
0.258 ms 1 /classes/ProductAssembler.php:64
792
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5113) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.256 ms 1 Yes /classes/Product.php:4507
145
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5117 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 5117 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.255 ms 0 /classes/Cart.php:1410
1
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.254 ms 1 Yes /classes/shop/Shop.php:715
361
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductAdditionalInfo')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 4
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.253 ms 36 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
603
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.251 ms 437 Yes /classes/Product.php:7834
834
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 5
ORDER BY hb.`id_ets_hb_html_box` ASC
0.251 ms 4 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
674
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5114) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.250 ms 1 Yes /classes/Product.php:4507
322
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 9
ORDER BY hb.`id_ets_hb_html_box` ASC
0.250 ms 1 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
794
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (9272) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.248 ms 1 Yes /classes/Product.php:4507
648
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 755 AND  p.id_category_default not in (341,763,362,360,764,795,765,766,364,767,768,366,769,770,771,367,772,773,774,365,775,776,777,778,1125,1190) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.247 ms 26 /override/classes/Category.php:77
726
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12717 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 12717 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.247 ms 0 /classes/Cart.php:1410
124
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8122
0.244 ms 1 /classes/Product.php:7544
831
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 25
ORDER BY hb.`id_ets_hb_html_box` ASC
0.244 ms 2 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
312
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 26
ORDER BY hb.`id_ets_hb_html_box` ASC
0.243 ms 1 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
123
SELECT SQL_NO_CACHE *,
( IF (`id_shop` = 1, 2, 0) +  IF (`id_country` = 245, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_group` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 245) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-06-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-06-18 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.243 ms 1 Yes /classes/SpecificPrice.php:656
264
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.243 ms 437 Yes /classes/Product.php:7834
678
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (12717) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.241 ms 1 Yes /classes/Product.php:4507
263
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`, stock.location FROM `ps_product_attribute` pa  INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 8122 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`
0.239 ms 1 Yes Yes /classes/Product.php:2815
670
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (9272)
0.239 ms 1 /classes/ProductAssembler.php:64
655
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (12717)
0.238 ms 1 /classes/ProductAssembler.php:64
306
SELECT SQL_NO_CACHE r.*   
FROM `ps_ets_geo_rule` r 
LEFT JOIN `ps_ets_geo_country_rule` cr ON (r.`id_rule` = cr.`id_rule` AND cr.`id_country_rule` = 21)  
WHERE r.`enabled` = 1  AND (cr.id_rule is NOT NULL) AND r.id_shop = 1
GROUP BY r.`id_rule` 
ORDER BY r.`priority`, r.`id_rule` LIMIT 1
0.238 ms 1 Yes Yes /modules/ets_geolocation/classes/Geo_rules.php:108
315
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 27
ORDER BY hb.`id_ets_hb_html_box` ASC
0.238 ms 1 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
761
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (11474) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.237 ms 1 Yes /classes/Product.php:4507
676
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5112) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.236 ms 1 Yes /classes/Product.php:4507
509
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8123) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.235 ms 1 Yes /classes/Product.php:4507
691
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductListReviews')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 4
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.235 ms 36 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
661
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (8324)
0.234 ms 1 /classes/ProductAssembler.php:64
544
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5112 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 5112 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.232 ms 0 /classes/Cart.php:1410
166
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5118 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 5118 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.231 ms 0 /classes/Cart.php:1410
830
SELECT SQL_NO_CACHE hbl.html,hb.style,hbl.id_lang
FROM `ps_ets_hb_html_box` hb
LEFT JOIN `ps_ets_hb_html_box_lang` hbl 
ON (hb.`id_ets_hb_html_box` = hbl.`id_ets_hb_html_box` AND hbl.`id_lang` = 1)
JOIN `ps_ets_hb_html_box_position` hbp 
ON (hbp.`id_ets_hb_html_box` = hb.`id_ets_hb_html_box`)
WHERE hb.active = 1
AND hbp.`position` = 4
ORDER BY hb.`id_ets_hb_html_box` ASC
0.231 ms 1 Yes /modules/ets_htmlbox/classes/HBHtmlbox.php:274
730
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 `ps_product_attribute` pa
INNER JOIN ps_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 ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8324) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.231 ms 1 Yes /classes/Product.php:4507
652
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5112)
0.228 ms 1 /classes/ProductAssembler.php:64
182
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8123 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 8123 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.225 ms 0 /classes/Cart.php:1410
584
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.224 ms 437 Yes /classes/Product.php:7834
116
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.222 ms 15 Yes Yes /classes/Category.php:1151
325
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductAdditionalInfo')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 1
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.221 ms 13 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
611
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5113 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 5113 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.221 ms 0 /classes/Cart.php:1410
667
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5113)
0.221 ms 1 /classes/ProductAssembler.php:64
520
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.220 ms 437 Yes /classes/Product.php:7834
664
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-06-18 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (11474)
0.220 ms 1 /classes/ProductAssembler.php:64
681
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductListReviews')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 1
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.218 ms 13 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
18
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
0.217 ms 1097 /classes/Hook.php:1292
675
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.215 ms 437 Yes /classes/Product.php:7834
301
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 5 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.215 ms 437 Yes /classes/Product.php:7834
843
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.215 ms 437 Yes /classes/Product.php:7834
791
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.214 ms 437 Yes /classes/Product.php:7834
528
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5114 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 5114 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.213 ms 0 /classes/Cart.php:1410
506
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.213 ms 437 Yes /classes/Product.php:7834
673
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.211 ms 437 Yes /classes/Product.php:7834
760
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.211 ms 437 Yes /classes/Product.php:7834
841
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.210 ms 437 Yes /classes/Product.php:7834
228
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.209 ms 437 Yes /classes/Product.php:7834
823
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 9272 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 9272 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.209 ms 0 /classes/Cart.php:1410
19
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.208 ms 114 /classes/module/Module.php:345
677
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.208 ms 437 Yes /classes/Product.php:7834
759
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8324 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 8324 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.208 ms 0 /classes/Cart.php:1410
790
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 11474 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 11474 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.208 ms 0 /classes/Cart.php:1410
568
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.207 ms 437 Yes /classes/Product.php:7834
536
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.206 ms 437 Yes /classes/Product.php:7834
727
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.206 ms 437 Yes /classes/Product.php:7834
59
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA'
AND `id_country` = 21 LIMIT 1
0.205 ms 56 /classes/State.php:147
602
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5113) AND (b.`id_shop` = 1) LIMIT 1
0.205 ms 1 /src/Adapter/EntityMapper.php:71
619
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.205 ms 437 Yes /classes/Product.php:7834
793
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.204 ms 437 Yes /classes/Product.php:7834
635
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.203 ms 437 Yes /classes/Product.php:7834
576
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8324 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 8324 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.199 ms 0 /classes/Cart.php:1410
146
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5117
ORDER BY f.position ASC
0.198 ms 3 Yes /classes/Product.php:6002
643
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13244 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 13244 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.197 ms 0 /classes/Cart.php:1410
729
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.197 ms 437 Yes /classes/Product.php:7834
840
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 561 AND c.`nright` >= 562 AND c.`nleft` >= 2 AND c.`nright` <= 873 ORDER BY `nleft` DESC
0.196 ms 437 Yes /classes/Category.php:1600
79
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 78
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.196 ms 1 /classes/tax/TaxRulesTaxManager.php:109
242
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 561) AND (a0.`nright` > 562) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.196 ms 437 Yes /classes/PrestaShopCollection.php:383
508
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.196 ms 437 Yes /classes/Product.php:7834
627
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 9272 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 9272 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.194 ms 0 /classes/Cart.php:1410
231
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.192 ms 437 Yes /classes/Product.php:7834
595
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 11474 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 11474 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.191 ms 0 /classes/Cart.php:1410
235
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 5 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.190 ms 437 Yes /classes/Product.php:7834
552
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.190 ms 437 Yes /classes/Product.php:7834
713
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3416
ORDER BY `id_quantity_discount_rule_condition` ASC
0.190 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
842
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 561 AND c.nright >= 562)
ORDER BY c.nleft
0.190 ms 437 Yes /classes/Product.php:7834
560
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 `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12717 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 12717 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.189 ms 0 /classes/Cart.php:1410
206
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 8122
ORDER BY f.position ASC
0.188 ms 3 Yes /classes/Product.php:6002
262
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 561 AND c.`nright` >= 562 AND c.`nleft` >= 2 AND c.`nright` <= 873 ORDER BY `nleft` DESC
0.185 ms 437 Yes /classes/Category.php:1600
551
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12717) AND (b.`id_shop` = 1) LIMIT 1
0.185 ms 1 /src/Adapter/EntityMapper.php:71
255
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 560 AND c.`nright` >= 567 AND c.`nleft` >= 2 AND c.`nright` <= 873 ORDER BY `nleft` DESC
0.184 ms 437 Yes /classes/Category.php:1600
233
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8122) AND (b.`id_shop` = 1) LIMIT 1
0.184 ms 1 /src/Adapter/EntityMapper.php:71
618
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9272) AND (b.`id_shop` = 1) LIMIT 1
0.184 ms 1 /src/Adapter/EntityMapper.php:71
136
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5117) AND (b.`id_shop` = 1) LIMIT 1
0.183 ms 1 /src/Adapter/EntityMapper.php:71
23
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.183 ms 47 Yes /override/classes/Dispatcher.php:186
173
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8123) AND (b.`id_shop` = 1) LIMIT 1
0.183 ms 1 /src/Adapter/EntityMapper.php:71
249
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 559 AND c.`nright` >= 582 AND c.`nleft` >= 2 AND c.`nright` <= 873 ORDER BY `nleft` DESC
0.183 ms 437 Yes /classes/Category.php:1600
183
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 8123
ORDER BY f.position ASC
0.182 ms 3 Yes /classes/Product.php:6002
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.farmaten.com' OR su.domain_ssl = 'www.farmaten.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.181 ms 1 Yes /classes/shop/Shop.php:1364
600
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 5113
AND image_shop.`cover` = 1 LIMIT 1
0.181 ms 1 /classes/Product.php:3570
167
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5118
ORDER BY f.position ASC
0.176 ms 3 Yes /classes/Product.php:6002
13
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.175 ms 4 /classes/Language.php:1216
753
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.175 ms 4 /classes/Product.php:3459
154
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5118) AND (b.`id_shop` = 1) LIMIT 1
0.174 ms 1 /src/Adapter/EntityMapper.php:71
697
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductListReviews')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 3
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.169 ms 22 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
402
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductAdditionalInfo')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 5
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.168 ms 11 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
561
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 12717
ORDER BY f.position ASC
0.168 ms 3 Yes /classes/Product.php:6002
644
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13244
ORDER BY f.position ASC
0.168 ms 3 Yes /classes/Product.php:6002
27
SELECT SQL_NO_CACHE id_meta 
FROM ps_meta_lang
WHERE url_rewrite = "ortopedia"
AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
0.167 ms 40 /override/classes/Dispatcher.php:1376
455
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3359
ORDER BY `id_quantity_discount_rule_condition` ASC
0.165 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
708
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.165 ms 3 /classes/Product.php:3459
813
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.165 ms 8 /classes/Product.php:3459
401
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductAdditionalInfo')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 3
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.164 ms 22 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
535
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5112) AND (b.`id_shop` = 1) LIMIT 1
0.164 ms 1 /src/Adapter/EntityMapper.php:71
192
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5118
ORDER BY `position`
0.162 ms 1 Yes /classes/Product.php:3545
853
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.162 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
628
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 9272
ORDER BY f.position ASC
0.161 ms 3 Yes /classes/Product.php:6002
84
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 8122)
0.161 ms 1 /classes/Product.php:3860
529
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5114
ORDER BY f.position ASC
0.161 ms 3 Yes /classes/Product.php:6002
292
SELECT SQL_NO_CACHE qdr.`id_quantity_discount_rule`, qdrc.`id_quantity_discount_rule_condition`
FROM `ps_quantity_discount_rule` qdr
INNER JOIN  `ps_quantity_discount_rule_condition` qdrc ON (qdr.`id_quantity_discount_rule` = qdrc.`id_quantity_discount_rule`)
WHERE qdrc.`id_type` = 27 AND qdr.`id_shop` = 1
0.160 ms 181 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:276
219
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE ((cr.`id_customer` = 0 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_%"
0.160 ms 1 /classes/CartRule.php:418
583
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 11474) AND (b.`id_shop` = 1) LIMIT 1
0.160 ms 1 /src/Adapter/EntityMapper.php:71
803
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.160 ms 8 /classes/Product.php:3459
815
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.160 ms 8 /classes/Product.php:3459
22
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_finality cf LEFT JOIN ps_cookiesplus_finality_lang cfl on cf.`id_cookiesplus_finality` = cfl.`id_cookiesplus_finality`
WHERE
cfl.`id_lang` = 1 AND cf.`active` = 1 AND cf.`id_shop` = 1
ORDER BY `position`;
0.159 ms 4 Yes /modules/cookiesplus/classes/CookiesPlusFinality.php:98
194
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 8123
ORDER BY `position`
0.159 ms 1 Yes /classes/Product.php:3545
596
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 11474
ORDER BY f.position ASC
0.159 ms 3 Yes /classes/Product.php:6002
704
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.158 ms 3 /classes/Product.php:3459
746
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3416
ORDER BY `id_quantity_discount_rule_condition` ASC
0.158 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
634
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13244) AND (b.`id_shop` = 1) LIMIT 1
0.157 ms 1 /src/Adapter/EntityMapper.php:71
78
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA'
AND `id_country` = 21 LIMIT 1
0.157 ms 56 /classes/State.php:147
519
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5114) AND (b.`id_shop` = 1) LIMIT 1
0.156 ms 1 /src/Adapter/EntityMapper.php:71
732
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3407
ORDER BY `id_quantity_discount_rule_condition` ASC
0.156 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
764
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 11474) LIMIT 1
0.156 ms 1 /src/Adapter/EntityMapper.php:71
411
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.155 ms 3 /classes/Product.php:3459
612
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5113
ORDER BY f.position ASC
0.155 ms 3 Yes /classes/Product.php:6002
200
SELECT SQL_NO_CACHE *
FROM `ps_dwfproductextrafields` a0
LEFT JOIN `ps_dwfproductextrafields_lang` `a1` ON (a0.`id_dwfproductextrafields` = a1.`id_dwfproductextrafields`)
WHERE (a0.`active` = 1)
ORDER BY a0.`position` asc
0.154 ms 5 Yes /classes/PrestaShopCollection.php:383
800
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3341
ORDER BY `id_quantity_discount_rule_condition` ASC
0.154 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
8
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 245) LIMIT 1
0.153 ms 1 /src/Adapter/EntityMapper.php:71
161
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 76
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.153 ms 1 /classes/tax/TaxRulesTaxManager.php:109
360
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductAdditionalInfo')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 2
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.153 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
459
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 625
ORDER BY `id_quantity_discount_rule_group` ASC
0.153 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
577
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 8324
ORDER BY f.position ASC
0.153 ms 3 Yes /classes/Product.php:6002
698
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductListReviews')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 5
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.153 ms 11 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
567
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8324) AND (b.`id_shop` = 1) LIMIT 1
0.153 ms 1 /src/Adapter/EntityMapper.php:71
289
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8122) LIMIT 1
0.152 ms 1 /src/Adapter/EntityMapper.php:71
460
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3427
ORDER BY `id_quantity_discount_rule_condition` ASC
0.151 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
718
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.151 ms 3 /classes/Product.php:3459
105
SELECT SQL_NO_CACHE cc.name
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 1
AND ccl.`id_lang` = 1 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
0.150 ms 65 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118
545
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5112
ORDER BY f.position ASC
0.150 ms 3 Yes /classes/Product.php:6002
570
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 8324)
0.150 ms 1 /classes/Product.php:3860
690
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `ps_quantity_discount_rule` qdr
INNER JOIN `ps_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
INNER JOIN `ps_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductListReviews')
INNER JOIN `ps_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 1)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 1 AND `id_family` = 2
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.149 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:307
668
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5113
ORDER BY `position`
0.148 ms 1 Yes /classes/Product.php:3545
590
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 79
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.147 ms 1 /classes/tax/TaxRulesTaxManager.php:109
723
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3275
ORDER BY `id_quantity_discount_rule_condition` ASC
0.147 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.147 ms 1 /classes/shop/Shop.php:218
409
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3879
0.147 ms 283 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
706
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.147 ms 3 /classes/Product.php:3459
854
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.147 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
197
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 24) AND (b.`id_shop` = 1) LIMIT 1
0.146 ms 1 /src/Adapter/EntityMapper.php:71
656
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 12717
ORDER BY `position`
0.146 ms 2 Yes /classes/Product.php:3545
703
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3341
ORDER BY `id_quantity_discount_rule_condition` ASC
0.146 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
799
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.146 ms 8 /classes/Product.php:3459
850
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `ps_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1
0.146 ms 17424 /classes/DateRange.php:60
805
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.145 ms 8 /classes/Product.php:3459
807
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.145 ms 8 /classes/Product.php:3459
836
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 3
AND ccl.`id_lang` = 1 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
0.145 ms 65 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118
699
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3407
ORDER BY `id_quantity_discount_rule_condition` ASC
0.145 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
702
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.145 ms 3 /classes/Product.php:3459
801
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.145 ms 8 /classes/Product.php:3459
808
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3426
ORDER BY `id_quantity_discount_rule_condition` ASC
0.145 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
844
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
0.145 ms 1 /classes/ObjectModel.php:622
637
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 13244)
0.144 ms 1 /classes/Product.php:3860
716
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.144 ms 3 /classes/Product.php:3459
106
SELECT SQL_NO_CACHE cc.name
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 3
AND ccl.`id_lang` = 1 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
0.143 ms 65 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118
448
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.143 ms 3 /classes/Product.php:3459
789
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.143 ms 3 /classes/Product.php:3459
845
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 5020017
AND `date_add` > '2025-06-18 05:15:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.143 ms 1 Yes /classes/Connection.php:168
285
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayHeader" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.143 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
458
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.143 ms 3 /classes/Product.php:3459
796
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3407
ORDER BY `id_quantity_discount_rule_condition` ASC
0.143 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
221
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `ps_quantity_discount_rule` qdr
LEFT JOIN `ps_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
WHERE qdr.`active` = 1 AND `id_family` = 1 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.142 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:258
735
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.142 ms 4 /classes/Product.php:3459
810
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3416
ORDER BY `id_quantity_discount_rule_condition` ASC
0.142 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
835
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 1
AND ccl.`id_lang` = 1 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
0.142 ms 65 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.142 ms 2 /classes/Language.php:1080
407
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3417
ORDER BY `id_quantity_discount_rule_condition` ASC
0.142 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
737
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.142 ms 4 /classes/Product.php:3459
811
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.142 ms 8 /classes/Product.php:3459
819
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.142 ms 8 /classes/Product.php:3459
757
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3188
ORDER BY `id_quantity_discount_rule_condition` ASC
0.141 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
785
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3409
ORDER BY `id_quantity_discount_rule_condition` ASC
0.141 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
855
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.141 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
700
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12717) LIMIT 1
0.141 ms 1 /src/Adapter/EntityMapper.php:71
712
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.141 ms 3 /classes/Product.php:3459
751
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.140 ms 4 /classes/Product.php:3459
187
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5117
ORDER BY `position`
0.140 ms 1 Yes /classes/Product.php:3545
428
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.140 ms 3 /classes/Product.php:3459
682
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 495
AND 8 != o.current_state LIMIT 1
0.140 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
705
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3307
ORDER BY `id_quantity_discount_rule_condition` ASC
0.140 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
756
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3275
ORDER BY `id_quantity_discount_rule_condition` ASC
0.140 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
846
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.140 ms 1 /classes/Page.php:104
650
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5114
ORDER BY `position`
0.139 ms 1 Yes /classes/Product.php:3545
662
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 8324
ORDER BY `position`
0.139 ms 1 Yes /classes/Product.php:3545
818
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3409
ORDER BY `id_quantity_discount_rule_condition` ASC
0.139 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
733
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8324) LIMIT 1
0.138 ms 1 /src/Adapter/EntityMapper.php:71
763
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3407
ORDER BY `id_quantity_discount_rule_condition` ASC
0.138 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
769
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3307
ORDER BY `id_quantity_discount_rule_condition` ASC
0.138 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
820
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3275
ORDER BY `id_quantity_discount_rule_condition` ASC
0.138 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
468
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.138 ms 3 /classes/Product.php:3459
665
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 11474
ORDER BY `position`
0.138 ms 1 Yes /classes/Product.php:3545
755
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.138 ms 4 /classes/Product.php:3459
7
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 112 AND `id_shop` = 1 LIMIT 1
0.137 ms 1 /classes/module/Module.php:2109
330
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 495
AND 8 != o.current_state LIMIT 1
0.137 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
809
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.137 ms 8 /classes/Product.php:3459
107
SELECT SQL_NO_CACHE cc.name
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 4
AND ccl.`id_lang` = 1 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
0.137 ms 65 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118
804
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3410
ORDER BY `id_quantity_discount_rule_condition` ASC
0.137 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
822
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.137 ms 8 /classes/Product.php:3459
9
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.136 ms 1 /src/Adapter/EntityMapper.php:71
725
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.136 ms 3 /classes/Product.php:3459
778
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.136 ms 3 /classes/Product.php:3459
817
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 9272
AND cl.`id_lang` = 1
0.136 ms 8 /classes/Product.php:3459
211
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 8122
ORDER BY `position`
0.136 ms 1 Yes /classes/Product.php:3545
766
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.136 ms 3 /classes/Product.php:3459
773
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3414
ORDER BY `id_quantity_discount_rule_condition` ASC
0.135 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
797
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9272) LIMIT 1
0.135 ms 1 /src/Adapter/EntityMapper.php:71
741
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.135 ms 4 /classes/Product.php:3459
313
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 12) AND (b.`id_shop` = 1) LIMIT 1
0.134 ms 1 /src/Adapter/EntityMapper.php:71
653
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5112
ORDER BY `position`
0.134 ms 1 Yes /classes/Product.php:3545
692
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 577
AND 8 != o.current_state LIMIT 1
0.134 ms 2 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
768
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.134 ms 3 /classes/Product.php:3459
415
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3407
ORDER BY `id_quantity_discount_rule_condition` ASC
0.133 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
418
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.133 ms 3 /classes/Product.php:3459
450
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3403
ORDER BY `id_quantity_discount_rule_condition` ASC
0.133 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
456
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3778) LIMIT 1
0.133 ms 1 /src/Adapter/EntityMapper.php:71
538
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5112)
0.133 ms 1 /classes/Product.php:3860
758
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.133 ms 4 /classes/Product.php:3459
453
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.132 ms 3 /classes/Product.php:3459
719
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3427
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
724
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3188
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
736
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3341
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
739
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.132 ms 4 /classes/Product.php:3459
748
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3403
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
752
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3427
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
754
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3409
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
414
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 640
ORDER BY `id_quantity_discount_rule_group` ASC
0.132 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
470
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3275
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
780
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.132 ms 3 /classes/Product.php:3459
783
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3427
ORDER BY `id_quantity_discount_rule_condition` ASC
0.132 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
345
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 625
AND 8 != o.current_state LIMIT 1
0.131 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
366
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 577
AND 8 != o.current_state LIMIT 1
0.131 ms 2 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
423
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.131 ms 3 /classes/Product.php:3459
671
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 9272
ORDER BY `position`
0.131 ms 1 Yes /classes/Product.php:3545
743
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.131 ms 4 /classes/Product.php:3459
771
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3410
ORDER BY `id_quantity_discount_rule_condition` ASC
0.131 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
776
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.131 ms 3 /classes/Product.php:3459
717
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3359
ORDER BY `id_quantity_discount_rule_condition` ASC
0.131 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
770
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.131 ms 3 /classes/Product.php:3459
786
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.131 ms 3 /classes/Product.php:3459
465
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3409
ORDER BY `id_quantity_discount_rule_condition` ASC
0.130 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
744
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3426
ORDER BY `id_quantity_discount_rule_condition` ASC
0.130 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
745
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.130 ms 4 /classes/Product.php:3459
774
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.130 ms 3 /classes/Product.php:3459
10
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.130 ms 1 /src/Adapter/EntityMapper.php:71
348
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 626
AND 8 != o.current_state LIMIT 1
0.130 ms 6 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
463
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.130 ms 3 /classes/Product.php:3459
659
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 5118
ORDER BY `position`
0.130 ms 1 Yes /classes/Product.php:3545
767
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3341
ORDER BY `id_quantity_discount_rule_condition` ASC
0.130 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
777
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3416
ORDER BY `id_quantity_discount_rule_condition` ASC
0.130 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
802
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3307
ORDER BY `id_quantity_discount_rule_condition` ASC
0.130 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
215
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
0.129 ms 1 /classes/Cart.php:4192
435
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3414
ORDER BY `id_quantity_discount_rule_condition` ASC
0.129 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
477
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.129 ms 3 /classes/Product.php:3459
589
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA'
AND `id_country` = 21 LIMIT 1
0.129 ms 56 /classes/State.php:147
707
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3410
ORDER BY `id_quantity_discount_rule_condition` ASC
0.129 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
709
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3414
ORDER BY `id_quantity_discount_rule_condition` ASC
0.129 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
742
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3414
ORDER BY `id_quantity_discount_rule_condition` ASC
0.129 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
750
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3359
ORDER BY `id_quantity_discount_rule_condition` ASC
0.129 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
772
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.129 ms 3 /classes/Product.php:3459
812
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3403
ORDER BY `id_quantity_discount_rule_condition` ASC
0.129 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.128 ms 1 /src/Adapter/EntityMapper.php:71
430
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3410
ORDER BY `id_quantity_discount_rule_condition` ASC
0.128 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
443
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.128 ms 3 /classes/Product.php:3459
710
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.128 ms 3 /classes/Product.php:3459
711
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3426
ORDER BY `id_quantity_discount_rule_condition` ASC
0.128 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
714
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.128 ms 3 /classes/Product.php:3459
715
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3403
ORDER BY `id_quantity_discount_rule_condition` ASC
0.128 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
738
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3307
ORDER BY `id_quantity_discount_rule_condition` ASC
0.128 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
749
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.128 ms 4 /classes/Product.php:3459
779
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3403
ORDER BY `id_quantity_discount_rule_condition` ASC
0.128 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
814
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3359
ORDER BY `id_quantity_discount_rule_condition` ASC
0.128 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
12
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.128 ms 1 /classes/shop/ShopUrl.php:182
290
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 8122 AND `id_shop` = 1
0.127 ms 2 /src/Adapter/EntityMapper.php:79
333
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 552
AND 8 != o.current_state LIMIT 1
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
340
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 600
AND 8 != o.current_state LIMIT 1
0.127 ms 2 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
433
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.127 ms 3 /classes/Product.php:3459
683
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 552
AND 8 != o.current_state LIMIT 1
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
685
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 625
AND 8 != o.current_state LIMIT 1
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
740
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3410
ORDER BY `id_quantity_discount_rule_condition` ASC
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
747
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8324
AND cl.`id_lang` = 1
0.127 ms 4 /classes/Product.php:3459
775
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3426
ORDER BY `id_quantity_discount_rule_condition` ASC
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
781
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3359
ORDER BY `id_quantity_discount_rule_condition` ASC
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
787
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3275
ORDER BY `id_quantity_discount_rule_condition` ASC
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
788
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3188
ORDER BY `id_quantity_discount_rule_condition` ASC
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
816
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3427
ORDER BY `id_quantity_discount_rule_condition` ASC
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
425
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3307
ORDER BY `id_quantity_discount_rule_condition` ASC
0.127 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
686
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 626
AND 8 != o.current_state LIMIT 1
0.127 ms 6 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
720
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.127 ms 3 /classes/Product.php:3459
438
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 8122
AND cl.`id_lang` = 1
0.126 ms 3 /classes/Product.php:3459
721
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3409
ORDER BY `id_quantity_discount_rule_condition` ASC
0.126 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
222
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `ps_quantity_discount_rule` qdr
LEFT JOIN `ps_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
WHERE qdr.`active` = 1 AND `id_family` = 2 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.126 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:258
243
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
0.126 ms 1 /classes/Category.php:2242
420
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3341
ORDER BY `id_quantity_discount_rule_condition` ASC
0.126 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
440
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3426
ORDER BY `id_quantity_discount_rule_condition` ASC
0.126 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
806
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3414
ORDER BY `id_quantity_discount_rule_condition` ASC
0.126 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
821
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3188
ORDER BY `id_quantity_discount_rule_condition` ASC
0.126 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
111
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA'
AND `id_country` = 21 LIMIT 1
0.125 ms 56 /classes/State.php:147
445
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3416
ORDER BY `id_quantity_discount_rule_condition` ASC
0.125 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
621
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 9272)
0.125 ms 1 /classes/Product.php:3860
837
SELECT SQL_NO_CACHE *
FROM ps_cookiesplus_cookie cc LEFT JOIN ps_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 4
AND ccl.`id_lang` = 1 AND cc.`active` = 1 AND cc.`id_shop` =  1 ORDER BY cc.`name`;
0.125 ms 65 Yes /modules/cookiesplus/classes/CookiesPlusCookie.php:118
856
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.125 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
80
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 8122
AND DATEDIFF("2025-06-18 00:00:00", product_shop.`date_add`) < 30 LIMIT 1
0.124 ms 0 /classes/Product.php:1732
112
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 4
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.124 ms 0 /classes/tax/TaxRulesTaxManager.php:109
160
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA'
AND `id_country` = 21 LIMIT 1
0.124 ms 56 /classes/State.php:147
225
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `ps_quantity_discount_rule` qdr
LEFT JOIN `ps_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
WHERE qdr.`active` = 1 AND `id_family` = 5 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.124 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:258
419
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 617
ORDER BY `id_quantity_discount_rule_group` ASC
0.124 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
424
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 601
ORDER BY `id_quantity_discount_rule_group` ASC
0.124 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
454
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 626
ORDER BY `id_quantity_discount_rule_group` ASC
0.124 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
469
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 552
ORDER BY `id_quantity_discount_rule_group` ASC
0.124 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
474
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_condition` t
WHERE `id_quantity_discount_rule_group` = 3188
ORDER BY `id_quantity_discount_rule_condition` ASC
0.124 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleGroup.php:48
605
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5113)
0.124 ms 1 /classes/Product.php:3860
722
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 12717
AND cl.`id_lang` = 1
0.124 ms 3 /classes/Product.php:3459
782
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.124 ms 3 /classes/Product.php:3459
157
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5118)
0.123 ms 1 /classes/Product.php:3860
784
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 11474
AND cl.`id_lang` = 1
0.123 ms 3 /classes/Product.php:3459
48
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.122 ms 1 /src/Adapter/EntityMapper.php:71
284
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `active` = 1 ORDER BY position
0.122 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
406
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 277
ORDER BY `id_quantity_discount_rule_group` ASC
0.122 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
517
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 5114
AND image_shop.`cover` = 1 LIMIT 1
0.122 ms 1 /classes/Product.php:3570
376
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 601
AND 8 != o.current_state LIMIT 1
0.122 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
684
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 600
AND 8 != o.current_state LIMIT 1
0.122 ms 2 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
139
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5117)
0.121 ms 1 /classes/Product.php:3860
353
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 639
AND 8 != o.current_state LIMIT 1
0.121 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
369
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 578
AND 8 != o.current_state LIMIT 1
0.121 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
383
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 617
AND 8 != o.current_state LIMIT 1
0.121 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
539
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5112 AND id_shop=1 LIMIT 1
0.121 ms 1 /classes/Product.php:6857
388
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 640
AND 8 != o.current_state LIMIT 1
0.121 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
466
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3871) LIMIT 1
0.121 ms 1 /src/Adapter/EntityMapper.php:71
693
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 578
AND 8 != o.current_state LIMIT 1
0.120 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
176
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 8123)
0.120 ms 1 /classes/Product.php:3860
439
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 643
ORDER BY `id_quantity_discount_rule_group` ASC
0.120 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
152
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 5118
AND image_shop.`cover` = 1 LIMIT 1
0.119 ms 1 /classes/Product.php:3570
473
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 495
ORDER BY `id_quantity_discount_rule_group` ASC
0.119 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
30
SELECT SQL_NO_CACHE `id_product`
FROM ps_product_lang
WHERE `link_rewrite` = "silla-de-ruedas-linus-500-rueda-grande-43rg-46rg-y-49-rg"
AND link_rewrite != ''
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
0.119 ms 1 /override/classes/Dispatcher.php:1389
104
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 755) AND (b.`id_shop` = 1) LIMIT 1
0.119 ms 1 /src/Adapter/EntityMapper.php:71
128
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 5117 AND ctg.`id_group` = 1 LIMIT 1
0.119 ms 3 /classes/Product.php:6721
213
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 258) LIMIT 1
0.119 ms 1 /src/Adapter/EntityMapper.php:71
429
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 578
ORDER BY `id_quantity_discount_rule_group` ASC
0.119 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
444
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 642
ORDER BY `id_quantity_discount_rule_group` ASC
0.119 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
464
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 600
ORDER BY `id_quantity_discount_rule_group` ASC
0.119 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
827
SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (8122)
ORDER BY o.id_order DESC
LIMIT 400
0.119 ms 1 Yes /override/modules/ps_crossselling/ps_crossselling.php:19
857
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayBeforeBodyClosingTag" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
0.119 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
43
SELECT SQL_NO_CACHE id_product
FROM ps_product_lang
WHERE link_rewrite = 'silla-de-ruedas-linus-500-rueda-grande-43rg-46rg-y-49-rg' AND id_lang = 1 AND id_shop = 1 AND `link_rewrite` != '' LIMIT 1
0.118 ms 1 /override/controllers/front/ProductController.php:46
223
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `ps_quantity_discount_rule` qdr
LEFT JOIN `ps_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
WHERE qdr.`active` = 1 AND `id_family` = 4 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.118 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:258
434
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 577
ORDER BY `id_quantity_discount_rule_group` ASC
0.118 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
449
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_group` t
WHERE `id_quantity_discount_rule` = 639
ORDER BY `id_quantity_discount_rule_group` ASC
0.118 ms 655 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:154
131
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 5118 LIMIT 1
0.118 ms 1 /classes/Product.php:1106
522
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 5114)
0.117 ms 1 /classes/Product.php:3860
696
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 640
AND 8 != o.current_state LIMIT 1
0.117 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
356
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 642
AND 8 != o.current_state LIMIT 1
0.116 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
695
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 617
AND 8 != o.current_state LIMIT 1
0.116 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
554
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 12717)
0.116 ms 1 /classes/Product.php:3860
324
SELECT SQL_NO_CACHE qdrf.*
FROM `ps_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.115 ms 5 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:75
471
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3693) LIMIT 1
0.115 ms 1 /src/Adapter/EntityMapper.php:71
586
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 `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 11474)
0.115 ms 1 /classes/Product.php:3860
69
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.114 ms 1 /classes/Country.php:194
224
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `ps_quantity_discount_rule` qdr
LEFT JOIN `ps_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 1)
WHERE qdr.`active` = 1 AND `id_family` = 3 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.114 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:258
277
SELECT SQL_NO_CACHE id_block FROM `ps_ets_mm_block` WHERE enabled=1 AND show_clock=1 AND block_type="PRODUCT" LIMIT 1
0.114 ms 1 /modules/ets_megamenu/classes/MM_Block.php:661
310
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA'
AND `id_country` = 21 LIMIT 1
0.114 ms 56 /classes/State.php:147
451
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3865) LIMIT 1
0.114 ms 1 /src/Adapter/EntityMapper.php:71
461
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3897) LIMIT 1
0.114 ms 1 /src/Adapter/EntityMapper.php:71
687
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 639
AND 8 != o.current_state LIMIT 1
0.114 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
6
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ets_geolocation" LIMIT 1
0.113 ms 1 /classes/module/Module.php:2636
202
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 8122
AND image_shop.`cover` = 1 LIMIT 1
0.113 ms 1 /classes/Product.php:3570
408
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3879) LIMIT 1
0.113 ms 1 /src/Adapter/EntityMapper.php:71
446
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3878) LIMIT 1
0.113 ms 1 /src/Adapter/EntityMapper.php:71
487
SELECT SQL_NO_CACHE c.id_carrier
FROM ps_carrier c
INNER JOIN ps_carrier_zone cz ON c.id_carrier = cz.id_carrier
INNER JOIN ps_zone z ON cz.id_zone = z.id_zone
INNER JOIN ps_country co ON co.id_zone = z.id_zone
WHERE co.id_country = 21
AND c.active = 1
AND c.deleted = 0
ORDER BY c.position ASC, c.id_carrier ASC LIMIT 1
0.113 ms 0 /modules/orderfees_shipping/classes/ShippingRule.php:2053
680
SELECT SQL_NO_CACHE qdrf.*
FROM `ps_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.113 ms 5 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:75
81
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 8122 LIMIT 1
0.112 ms 1 /classes/Product.php:1106
251
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 353
0.112 ms 1 /override/classes/Link.php:139
441
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3896) LIMIT 1
0.112 ms 1 /src/Adapter/EntityMapper.php:71
533
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 5112
AND image_shop.`cover` = 1 LIMIT 1
0.112 ms 1 /classes/Product.php:3570
694
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 601
AND 8 != o.current_state LIMIT 1
0.112 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
288
SELECT SQL_NO_CACHE * FROM ps_product_videos WHERE id_product = 8122 AND id_lang = 1 AND id_shop = 1 ORDER BY position ASC
0.111 ms 1 Yes /modules/productvideo/productvideo.php:3079
632
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13244
AND image_shop.`cover` = 1 LIMIT 1
0.111 ms 1 /classes/Product.php:3570
103
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 8122 AND ctg.`id_group` = 1 LIMIT 1
0.111 ms 3 /classes/Product.php:6721
134
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 5117
AND image_shop.`cover` = 1 LIMIT 1
0.111 ms 1 /classes/Product.php:3570
196
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_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` = 8122
0.111 ms 1 /classes/Product.php:7477
426
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3726) LIMIT 1
0.111 ms 1 /src/Adapter/EntityMapper.php:71
64
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.110 ms 1 /src/Adapter/EntityMapper.php:71
431
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3872) LIMIT 1
0.110 ms 1 /src/Adapter/EntityMapper.php:71
359
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 643
AND 8 != o.current_state LIMIT 1
0.110 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
502
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "fc_medicamentos" LIMIT 1
0.110 ms 1 /classes/module/Module.php:2636
565
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 8324
AND image_shop.`cover` = 1 LIMIT 1
0.110 ms 1 /classes/Product.php:3570
52
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
0.109 ms 1 /src/Adapter/EntityMapper.php:71
421
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3760) LIMIT 1
0.109 ms 1 /src/Adapter/EntityMapper.php:71
436
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3876) LIMIT 1
0.109 ms 1 /src/Adapter/EntityMapper.php:71
475
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3579) LIMIT 1
0.109 ms 1 /src/Adapter/EntityMapper.php:71
688
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 642
AND 8 != o.current_state LIMIT 1
0.109 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
88
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=8122
0.109 ms 3 /classes/Tag.php:244
171
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 8123
AND image_shop.`cover` = 1 LIMIT 1
0.109 ms 1 /classes/Product.php:3570
244
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.109 ms 1 /src/Adapter/EntityMapper.php:71
300
SELECT SQL_NO_CACHE id_meta 
FROM ps_meta
WHERE page = "product" LIMIT 1
0.109 ms 1 /override/classes/Link.php:786
616
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 9272
AND image_shop.`cover` = 1 LIMIT 1
0.109 ms 1 /classes/Product.php:3570
416
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_condition` a
WHERE (a.`id_quantity_discount_rule_condition` = 3869) LIMIT 1
0.108 ms 1 /src/Adapter/EntityMapper.php:71
689
SELECT SQL_NO_CACHE count(distinct(o.`id_order`))
FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule od ON o.id_order = od.id_order
INNER JOIN ps_quantity_discount_rule_order qdro ON od.id_cart_rule = qdro.id_cart_rule
WHERE qdro.id_quantity_discount_rule = 643
AND 8 != o.current_state LIMIT 1
0.108 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:4217
847
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 6 AND `id_object` = 8122 LIMIT 1
0.108 ms 1 /classes/Page.php:83
549
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 12717
AND image_shop.`cover` = 1 LIMIT 1
0.107 ms 2 /classes/Product.php:3570
510
SELECT SQL_NO_CACHE * FROM ps_revi_products WHERE id_product = '8122'
0.106 ms 1 /modules/revi/models/reviProductsModel.php:44
581
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 11474
AND image_shop.`cover` = 1 LIMIT 1
0.105 ms 1 /classes/Product.php:3570
599
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 11474
0.105 ms 3 /classes/Product.php:3423
486
SELECT SQL_NO_CACHE *
FROM `ps_of_shipping_rule` a
WHERE (a.`id_of_shipping_rule` = 3) LIMIT 1
0.104 ms 1 /src/Adapter/EntityMapper.php:71
220
SELECT SQL_NO_CACHE qdrf.*
FROM `ps_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 1 ORDER BY qdrf.priority ASC;
0.104 ms 5 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:75
309
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.104 ms 1 /src/Adapter/EntityMapper.php:71
493
SELECT SQL_NO_CACHE c.id_carrier
FROM ps_carrier c
INNER JOIN ps_carrier_zone cz ON c.id_carrier = cz.id_carrier
INNER JOIN ps_zone z ON cz.id_zone = z.id_zone
INNER JOIN ps_country co ON co.id_zone = z.id_zone
WHERE co.id_country = 21
AND c.active = 1
AND c.deleted = 0
ORDER BY c.position ASC, c.id_carrier ASC LIMIT 1
0.103 ms 0 /modules/orderfees_shipping/classes/ShippingRule.php:2053
838
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 755 LIMIT 1
0.103 ms 1 /classes/Category.php:1585
54
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
0.102 ms 1 /classes/Country.php:194
74
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.102 ms 0 /classes/Supplier.php:243
130
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 5118 AND ctg.`id_group` = 1 LIMIT 1
0.102 ms 5 /classes/Product.php:6721
44
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.101 ms 2 Yes /classes/Currency.php:709
624
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 9272 LIMIT 1
0.101 ms 1 /classes/Pack.php:89
94
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_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` = 8122
0.101 ms 1 /classes/Product.php:7477
490
SELECT SQL_NO_CACHE c.id_carrier
FROM ps_carrier c
INNER JOIN ps_carrier_zone cz ON c.id_carrier = cz.id_carrier
INNER JOIN ps_zone z ON cz.id_zone = z.id_zone
INNER JOIN ps_country co ON co.id_zone = z.id_zone
WHERE co.id_country = 21
AND c.active = 1
AND c.deleted = 0
ORDER BY c.position ASC, c.id_carrier ASC LIMIT 1
0.101 ms 0 /modules/orderfees_shipping/classes/ShippingRule.php:2053
412
SELECT SQL_NO_CACHE * FROM `ps_quantity_discount_rule_message` t
WHERE `id_quantity_discount_rule` = 277
AND `hook_name` = 'hookDisplayProductAdditionalInfo'
0.100 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:227
46
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.100 ms 1 /classes/shop/Shop.php:1183
61
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.099 ms 1 /src/Adapter/EntityMapper.php:71
117
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_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` = 8122
0.099 ms 1 /classes/Product.php:7477
132
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 8123 AND ctg.`id_group` = 1 LIMIT 1
0.099 ms 3 /classes/Product.php:6721
229
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_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` = 8122
0.099 ms 1 /classes/Product.php:7477
250
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 401
0.099 ms 1 /override/classes/Link.php:139
413
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_message` a
LEFT JOIN `ps_quantity_discount_rule_message_lang` `b` ON a.`id_quantity_discount_rule_message` = b.`id_quantity_discount_rule_message` AND b.`id_lang` = 1
WHERE (a.`id_quantity_discount_rule_message` = 4856) LIMIT 1
0.099 ms 1 /src/Adapter/EntityMapper.php:71
499
SELECT SQL_NO_CACHE c.id_carrier
FROM ps_carrier c
INNER JOIN ps_carrier_zone cz ON c.id_carrier = cz.id_carrier
INNER JOIN ps_zone z ON cz.id_zone = z.id_zone
INNER JOIN ps_country co ON co.id_zone = z.id_zone
WHERE co.id_country = 21
AND c.active = 1
AND c.deleted = 0
ORDER BY c.position ASC, c.id_carrier ASC LIMIT 1
0.099 ms 0 /modules/orderfees_shipping/classes/ShippingRule.php:2053
56
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.098 ms 1 /src/Adapter/EntityMapper.php:71
210
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_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` = 8122
0.098 ms 1 /classes/Product.php:7477
557
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 12717 LIMIT 1
0.098 ms 1 /classes/Pack.php:89
265
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.097 ms 1 /classes/Country.php:194
631
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 9272
0.097 ms 8 /classes/Product.php:3423
701
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 12717 AND `id_shop` = 1
0.097 ms 2 /src/Adapter/EntityMapper.php:79
798
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 9272 AND `id_shop` = 1
0.097 ms 2 /src/Adapter/EntityMapper.php:79
246
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
0.096 ms 1 /override/classes/Link.php:139
257
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 401
0.096 ms 1 /override/classes/Link.php:139
492
SELECT SQL_NO_CACHE *
FROM `ps_of_shipping_rule` a
WHERE (a.`id_of_shipping_rule` = 9) LIMIT 1
0.096 ms 1 /src/Adapter/EntityMapper.php:71
513
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 755) LIMIT 1
0.096 ms 1 /src/Adapter/EntityMapper.php:71
89
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 8122) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.096 ms 1 /classes/stock/StockAvailable.php:453
521
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5114 LIMIT 1
0.095 ms 1 /classes/SpecificPrice.php:435
734
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 8324 AND `id_shop` = 1
0.095 ms 2 /src/Adapter/EntityMapper.php:79
256
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 755
0.095 ms 1 /override/classes/Link.php:139
318
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
0.095 ms 2 /classes/Currency.php:1136
496
SELECT SQL_NO_CACHE c.id_carrier
FROM ps_carrier c
INNER JOIN ps_carrier_zone cz ON c.id_carrier = cz.id_carrier
INNER JOIN ps_zone z ON cz.id_zone = z.id_zone
INNER JOIN ps_country co ON co.id_zone = z.id_zone
WHERE co.id_country = 21
AND c.active = 1
AND c.deleted = 0
ORDER BY c.position ASC, c.id_carrier ASC LIMIT 1
0.095 ms 0 /modules/orderfees_shipping/classes/ShippingRule.php:2053
765
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 11474 AND `id_shop` = 1
0.094 ms 2 /src/Adapter/EntityMapper.php:79
245
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 353
0.094 ms 1 /override/classes/Link.php:139
410
SELECT SQL_NO_CACHE id_category_excluded
FROM `ps_quantity_discount_rule_condition_category_excluded`
WHERE `id_quantity_discount_rule_condition` = 3879
0.093 ms 43 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
82
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
0.093 ms 1 /classes/SpecificPrice.php:426
307
SELECT SQL_NO_CACHE * FROM `ps_ets_geo_rule` WHERE `enabled` = 1 AND `all_countries` = 1 AND `id_shop` = 1 ORDER BY `priority` LIMIT 1
0.093 ms 1 Yes /modules/ets_geolocation/classes/Geo_rules.php:111
368
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 578
0.093 ms 2 /src/Adapter/EntityMapper.php:79
608
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 5113 LIMIT 1
0.093 ms 1 /classes/Pack.php:89
316
SELECT SQL_NO_CACHE `id_hook`
FROM `ps_social_login_position`
WHERE (`id_shop`=1) AND (`active`= 1)
0.092 ms 4 /modules/sociallogin/models/SocialLoginPosition.php:266
472
SELECT SQL_NO_CACHE id_product
FROM `ps_quantity_discount_rule_condition_product`
WHERE `id_quantity_discount_rule_condition` = 3693
0.092 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
73
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 258
AND `active` = 1 LIMIT 1
0.091 ms 1 /classes/Manufacturer.php:316
258
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 353
0.091 ms 1 /override/classes/Link.php:139
298
SELECT SQL_NO_CACHE id_meta 
FROM ps_meta
WHERE page = "product" LIMIT 1
0.091 ms 1 /override/classes/Link.php:786
731
SELECT SQL_NO_CACHE * FROM ps_revi_products WHERE id_product = '8324'
0.091 ms 1 /modules/revi/models/reviProductsModel.php:44
129
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 5117 LIMIT 1
0.091 ms 1 /classes/Product.php:1106
462
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3897
0.091 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
485
SELECT SQL_NO_CACHE id_of_shipping_rule FROM ps_of_shipping_rule WHERE type IN (257,513)
0.091 ms 13 /modules/orderfees_shipping/classes/ShippingRule.php:1946
77
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
0.090 ms 1 /classes/Country.php:194
252
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
0.090 ms 1 /override/classes/Link.php:139
362
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 564) LIMIT 1
0.090 ms 1 /src/Adapter/EntityMapper.php:71
385
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 623
0.090 ms 2 /src/Adapter/EntityMapper.php:79
615
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5113
0.090 ms 4 /classes/Product.php:3423
190
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.090 ms 7 Yes /classes/ImageType.php:109
305
SELECT SQL_NO_CACHE `id_hook`
FROM `ps_social_login_position`
WHERE (`id_shop`=1) AND (`active`= 1)
0.090 ms 4 /modules/sociallogin/models/SocialLoginPosition.php:266
314
SELECT SQL_NO_CACHE `id_hook`
FROM `ps_social_login_position`
WHERE (`id_shop`=1) AND (`active`= 1)
0.090 ms 4 /modules/sociallogin/models/SocialLoginPosition.php:266
394
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 609
0.089 ms 2 /src/Adapter/EntityMapper.php:79
489
SELECT SQL_NO_CACHE *
FROM `ps_of_shipping_rule` a
WHERE (a.`id_of_shipping_rule` = 6) LIMIT 1
0.089 ms 1 /src/Adapter/EntityMapper.php:71
238
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 245) LIMIT 1
0.089 ms 1 /src/Adapter/EntityMapper.php:71
259
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
0.089 ms 1 /override/classes/Link.php:139
323
SELECT SQL_NO_CACHE * FROM ps_revi_products WHERE id_product = '8122'
0.089 ms 1 /modules/revi/models/reviProductsModel.php:44
514
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 755 AND `id_shop` = 1
0.089 ms 2 /src/Adapter/EntityMapper.php:79
239
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 245
0.088 ms 2 /src/Adapter/EntityMapper.php:79
452
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3865
0.088 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
503
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 67 AND `id_shop` = 1 LIMIT 1
0.088 ms 1 /classes/module/Module.php:2109
541
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 5112 LIMIT 1
0.088 ms 1 /classes/Pack.php:89
604
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5113 LIMIT 1
0.088 ms 1 /classes/SpecificPrice.php:435
326
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 581) LIMIT 1
0.087 ms 1 /src/Adapter/EntityMapper.php:71
417
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3869
0.087 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
93
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 755 LIMIT 1
0.087 ms 1 /classes/Category.php:1378
209
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 8122
0.087 ms 3 /classes/Product.php:3423
55
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
0.086 ms 1 /classes/Country.php:194
118
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.086 ms 494 /classes/SpecificPrice.php:297
467
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3871
0.086 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
495
SELECT SQL_NO_CACHE *
FROM `ps_of_shipping_rule` a
WHERE (a.`id_of_shipping_rule` = 12) LIMIT 1
0.086 ms 1 /src/Adapter/EntityMapper.php:71
647
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 13244
0.086 ms 3 /classes/Product.php:3423
679
SELECT SQL_NO_CACHE * FROM ps_revi_products WHERE id_product = '12717'
0.086 ms 1 /modules/revi/models/reviProductsModel.php:44
98
SELECT SQL_NO_CACHE `id_hook`
FROM `ps_social_login_position`
WHERE (`id_shop`=1) AND (`active`= 1)
0.086 ms 4 /modules/sociallogin/models/SocialLoginPosition.php:266
437
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3876
0.086 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
457
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3778
0.086 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
60
SELECT SQL_NO_CACHE `id_zone`
FROM `ps_state`
WHERE `id_state` = 49 LIMIT 1
0.085 ms 1 /classes/State.php:251
498
SELECT SQL_NO_CACHE *
FROM `ps_of_shipping_rule` a
WHERE (a.`id_of_shipping_rule` = 13) LIMIT 1
0.085 ms 1 /src/Adapter/EntityMapper.php:71
67
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "quantitydiscountpro" LIMIT 1
0.085 ms 1 /classes/module/Module.php:2636
578
SELECT SQL_NO_CACHE is_voluminoso from ps_product_farmaten_option Where id = 8324 LIMIT 1
0.085 ms 1 /modules/fc_farmaten/src/Services/VoluminosoService.php:15
620
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 9272 LIMIT 1
0.085 ms 1 /classes/SpecificPrice.php:435
636
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 13244 LIMIT 1
0.085 ms 1 /classes/SpecificPrice.php:435
642
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13244) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.085 ms 1 /classes/stock/StockAvailable.php:453
825
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_crossselling" LIMIT 1
0.085 ms 1 /classes/module/Module.php:2636
65
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.084 ms 2 /src/Adapter/EntityMapper.php:79
133
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 8123 LIMIT 1
0.084 ms 1 /classes/Product.php:1106
287
SELECT SQL_NO_CACHE * FROM ps_product_videos_providers
0.084 ms 2 /modules/productvideo/classes/ThumbNail.php:149
427
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3726
0.084 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
442
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3896
0.084 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
672
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 9272
0.084 ms 1 /classes/Product.php:2902
45
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.084 ms 2 /classes/Language.php:883
57
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 21
0.084 ms 2 /src/Adapter/EntityMapper.php:79
175
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 8123 LIMIT 1
0.084 ms 1 /classes/SpecificPrice.php:435
293
SELECT SQL_NO_CACHE *
FROM `ps_shop_url` a0
0.084 ms 1 /classes/PrestaShopCollection.php:383
321
SELECT SQL_NO_CACHE `id_hook`
FROM `ps_social_login_position`
WHERE (`id_shop`=1) AND (`active`= 1)
0.084 ms 4 /modules/sociallogin/models/SocialLoginPosition.php:266
422
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3760
0.084 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
476
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3579
0.084 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
569
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 8324 LIMIT 1
0.084 ms 1 /classes/SpecificPrice.php:435
198
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "dwfproductextrafields" LIMIT 1
0.083 ms 1 /src/Adapter/Module/ModuleDataProvider.php:257
432
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3872
0.083 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
573
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 8324 LIMIT 1
0.083 ms 1 /classes/Pack.php:89
186
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 8123
0.083 ms 3 /classes/Product.php:3423
253
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 401 LIMIT 1
0.083 ms 1 /classes/Category.php:1585
511
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categoryproducts" LIMIT 1
0.083 ms 1 /classes/module/Module.php:2636
512
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 57 AND `id_shop` = 1 LIMIT 1
0.083 ms 1 /classes/module/Module.php:2109
537
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5112 LIMIT 1
0.083 ms 1 /classes/SpecificPrice.php:435
553
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 12717 LIMIT 1
0.083 ms 1 /classes/SpecificPrice.php:435
666
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 11474
0.083 ms 1 /classes/Product.php:2902
126
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 8122 LIMIT 1
0.082 ms 1 /classes/Pack.php:432
189
SELECT SQL_NO_CACHE state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
0.082 ms 1 /classes/FeatureFlag.php:105
296
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
0.082 ms 1 /classes/module/Module.php:2636
308
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
0.082 ms 1 /classes/Country.php:194
327
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 581
0.082 ms 2 /src/Adapter/EntityMapper.php:79
331
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 552) LIMIT 1
0.082 ms 1 /src/Adapter/EntityMapper.php:71
370
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 582) LIMIT 1
0.082 ms 1 /src/Adapter/EntityMapper.php:71
379
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 615) LIMIT 1
0.082 ms 1 /src/Adapter/EntityMapper.php:71
404
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 277
0.082 ms 2 /src/Adapter/EntityMapper.php:79
447
SELECT SQL_NO_CACHE id_category
FROM `ps_quantity_discount_rule_condition_category`
WHERE `id_quantity_discount_rule_condition` = 3878
0.082 ms 1 /modules/quantitydiscountpro/classes/QuantityDiscountRuleCondition.php:488
564
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 12717
0.082 ms 3 /classes/Product.php:3423
598
SELECT SQL_NO_CACHE is_inflamable FROM ps_product_farmaten_option WHERE id = 11474 LIMIT 1
0.082 ms 1 /modules/fc_inflamables/src/Services/InflamanbleService.php:15
247
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 353 LIMIT 1
0.082 ms 1 /classes/Category.php:1585
172
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 755 LIMIT 1
0.081 ms 1 /classes/Product.php:5642
260
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 755 LIMIT 1
0.081 ms 1 /classes/Category.php:1585
278
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
0.081 ms 1 /classes/module/Module.php:2636
328
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 495) LIMIT 1
0.081 ms 1 /src/Adapter/EntityMapper.php:71
364
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 577) LIMIT 1
0.081 ms 1 /src/Adapter/EntityMapper.php:71
391
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 592) LIMIT 1
0.081 ms 1 /src/Adapter/EntityMapper.php:71
403
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 277) LIMIT 1
0.081 ms 1 /src/Adapter/EntityMapper.php:71
341
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 619) LIMIT 1
0.081 ms 1 /src/Adapter/EntityMapper.php:71
852
INSERT INTO `ps_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('147', '6304', '1', '1', '1')
0.081 ms 1 /classes/Page.php:142
90
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 8122) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.080 ms 1 /classes/stock/StockAvailable.php:778
207
SELECT SQL_NO_CACHE is_voluminoso from ps_product_farmaten_option Where id = 8122 LIMIT 1
0.080 ms 1 /modules/fc_farmaten/src/Services/VoluminosoService.php:15
610
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5113) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.080 ms 1 /classes/stock/StockAvailable.php:453
640
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 13244 LIMIT 1
0.080 ms 1 /classes/Pack.php:89
17
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.080 ms 88 /classes/Hook.php:287
20
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.080 ms 88 /classes/Hook.php:339
125
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 8122
0.080 ms 1 /classes/Pack.php:187
150
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5117
0.080 ms 3 /classes/Product.php:3423
193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5118
0.080 ms 1 /classes/Product.php:2902
334
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 596) LIMIT 1
0.080 ms 1 /src/Adapter/EntityMapper.php:71
367
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 578) LIMIT 1
0.080 ms 1 /src/Adapter/EntityMapper.php:71
585
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 11474 LIMIT 1
0.080 ms 1 /classes/SpecificPrice.php:435
156
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5118 LIMIT 1
0.079 ms 1 /classes/SpecificPrice.php:435
195
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 8123
0.079 ms 1 /classes/Product.php:2902
268
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1
0.079 ms 0 /classes/module/Module.php:2636
291
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 755 LIMIT 1
0.079 ms 0 /classes/Category.php:1378
346
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 626) LIMIT 1
0.079 ms 1 /src/Adapter/EntityMapper.php:71
377
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 603) LIMIT 1
0.079 ms 1 /src/Adapter/EntityMapper.php:71
592
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 11474 LIMIT 1
0.079 ms 1 /classes/Pack.php:89
270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ybc_blog" LIMIT 1
0.079 ms 0 /classes/module/Module.php:2636
336
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 599) LIMIT 1
0.079 ms 1 /src/Adapter/EntityMapper.php:71
342
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 619
0.079 ms 2 /src/Adapter/EntityMapper.php:79
343
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 625) LIMIT 1
0.079 ms 1 /src/Adapter/EntityMapper.php:71
349
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 627) LIMIT 1
0.079 ms 1 /src/Adapter/EntityMapper.php:71
363
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 564
0.079 ms 2 /src/Adapter/EntityMapper.php:79
384
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 623) LIMIT 1
0.079 ms 1 /src/Adapter/EntityMapper.php:71
480
SELECT SQL_NO_CACHE *
FROM `ps_shop_url` a0
0.079 ms 1 /classes/PrestaShopCollection.php:383
540
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5112 AND `id_group` = 1 LIMIT 1
0.079 ms 0 /classes/GroupReduction.php:156
558
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 12717 LIMIT 1
0.079 ms 1 /classes/Pack.php:90
594
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 11474) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.079 ms 1 /classes/stock/StockAvailable.php:453
626
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9272) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.079 ms 1 /classes/stock/StockAvailable.php:453
638
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 13244 AND id_shop=1 LIMIT 1
0.079 ms 1 /classes/Product.php:6857
350
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 627
0.078 ms 2 /src/Adapter/EntityMapper.php:79
354
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 642) LIMIT 1
0.078 ms 1 /src/Adapter/EntityMapper.php:71
357
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 643) LIMIT 1
0.078 ms 1 /src/Adapter/EntityMapper.php:71
532
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5114
0.078 ms 2 /classes/Product.php:3423
147
SELECT SQL_NO_CACHE is_voluminoso from ps_product_farmaten_option Where id = 5117 LIMIT 1
0.078 ms 1 /modules/fc_farmaten/src/Services/VoluminosoService.php:15
226
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.078 ms 0 /classes/module/Module.php:2636
303
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "sociallogin" LIMIT 1
0.078 ms 1 /classes/module/Module.php:2636
319
SELECT SQL_NO_CACHE id_lang FROM `ps_lang` WHERE is_rtl=0 AND active=1 LIMIT 1
0.078 ms 2 /modules/ets_megamenu/classes/MM_Obj.php:516
351
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 639) LIMIT 1
0.078 ms 1 /src/Adapter/EntityMapper.php:71
371
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 582
0.078 ms 2 /src/Adapter/EntityMapper.php:79
374
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 601) LIMIT 1
0.078 ms 1 /src/Adapter/EntityMapper.php:71
381
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 617) LIMIT 1
0.078 ms 1 /src/Adapter/EntityMapper.php:71
389
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 590) LIMIT 1
0.078 ms 1 /src/Adapter/EntityMapper.php:71
488
SELECT SQL_NO_CACHE srca.id_of_shipping_rule
FROM ps_of_shipping_rule_carrier srca
LEFT JOIN ps_carrier ca ON ca.id_reference = srca.id_carrier
WHERE srca.id_of_shipping_rule = 3
AND ca.id_carrier = 3 LIMIT 1
0.078 ms 0 /modules/orderfees_shipping/classes/ShippingRule.php:2065
525
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 5114 LIMIT 1
0.078 ms 1 /classes/Pack.php:89
580
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 8324
0.078 ms 4 /classes/Product.php:3423
651
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5114
0.078 ms 1 /classes/Product.php:2902
762
SELECT SQL_NO_CACHE * FROM ps_revi_products WHERE id_product = '11474'
0.078 ms 1 /modules/revi/models/reviProductsModel.php:44
832
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
0.078 ms 1 /classes/module/Module.php:2636
70
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA' LIMIT 1
0.077 ms 392 /classes/State.php:147
83
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 8122 LIMIT 1
0.077 ms 1 /classes/SpecificPrice.php:435
108
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 8122 LIMIT 1
0.077 ms 1 /classes/Pack.php:89
230
SELECT SQL_NO_CACHE id_meta 
FROM ps_meta
WHERE page = "product" LIMIT 1
0.077 ms 1 /override/classes/Link.php:786
234
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 5
AND cl.id_shop = 1 
AND cl.`id_category` = 755 LIMIT 1
0.077 ms 1 /classes/Category.php:1378
237
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 245 LIMIT 1
0.077 ms 1 /classes/Country.php:405
317
SELECT SQL_NO_CACHE `id_hook`
FROM `ps_social_login_position`
WHERE (`id_shop`=1) AND (`active`= 1)
0.077 ms 4 /modules/sociallogin/models/SocialLoginPosition.php:266
332
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 552
0.077 ms 2 /src/Adapter/EntityMapper.php:79
335
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 596
0.077 ms 2 /src/Adapter/EntityMapper.php:79
338
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 600) LIMIT 1
0.077 ms 1 /src/Adapter/EntityMapper.php:71
344
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 625
0.077 ms 2 /src/Adapter/EntityMapper.php:79
355
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 642
0.077 ms 2 /src/Adapter/EntityMapper.php:79
358
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 643
0.077 ms 2 /src/Adapter/EntityMapper.php:79
372
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 597) LIMIT 1
0.077 ms 1 /src/Adapter/EntityMapper.php:71
386
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 640) LIMIT 1
0.077 ms 1 /src/Adapter/EntityMapper.php:71
393
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 609) LIMIT 1
0.077 ms 1 /src/Adapter/EntityMapper.php:71
543
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5112) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.077 ms 1 /classes/stock/StockAvailable.php:453
559
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 12717) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.077 ms 1 /classes/stock/StockAvailable.php:453
588
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
0.077 ms 1 /classes/Country.php:194
654
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5112
0.077 ms 1 /classes/Product.php:2902
669
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5113
0.077 ms 1 /classes/Product.php:2902
795
SELECT SQL_NO_CACHE * FROM ps_revi_products WHERE id_product = '9272'
0.077 ms 1 /modules/revi/models/reviProductsModel.php:44
41
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_edition_basic" LIMIT 1
0.076 ms 0 /classes/module/Module.php:2636
49
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.076 ms 2 /classes/Language.php:883
51
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'GBP') LIMIT 1
0.076 ms 1 /classes/Currency.php:893
138
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5117 LIMIT 1
0.076 ms 1 /classes/SpecificPrice.php:435
236
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 245 LIMIT 1
0.076 ms 1 /classes/AddressFormat.php:656
347
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 626
0.076 ms 2 /src/Adapter/EntityMapper.php:79
352
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 639
0.076 ms 2 /src/Adapter/EntityMapper.php:79
365
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 577
0.076 ms 2 /src/Adapter/EntityMapper.php:79
378
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 603
0.076 ms 2 /src/Adapter/EntityMapper.php:79
382
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 617
0.076 ms 2 /src/Adapter/EntityMapper.php:79
390
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 590
0.076 ms 2 /src/Adapter/EntityMapper.php:79
396
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 611
0.076 ms 2 /src/Adapter/EntityMapper.php:79
397
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 613) LIMIT 1
0.076 ms 1 /src/Adapter/EntityMapper.php:71
399
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 620) LIMIT 1
0.076 ms 1 /src/Adapter/EntityMapper.php:71
515
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 755 AND ctg.`id_group` = 1 LIMIT 1
0.076 ms 1 /classes/Category.php:1754
527
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5114) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.076 ms 1 /classes/stock/StockAvailable.php:453
548
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5112
0.076 ms 1 /classes/Product.php:3423
660
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5118
0.076 ms 1 /classes/Product.php:2902
663
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 8324
0.076 ms 1 /classes/Product.php:2902
329
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 495
0.076 ms 2 /src/Adapter/EntityMapper.php:79
240
SELECT SQL_NO_CACHE *
FROM `ps_state` a
WHERE (a.`id_state` = 351) LIMIT 1
0.075 ms 1 /src/Adapter/EntityMapper.php:71
279
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1
0.075 ms 1 /classes/module/Module.php:2109
373
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 597
0.075 ms 2 /src/Adapter/EntityMapper.php:79
375
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 601
0.075 ms 2 /src/Adapter/EntityMapper.php:79
387
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule_lang`
WHERE `id_quantity_discount_rule` = 640
0.075 ms 2 /src/Adapter/EntityMapper.php:79
395
SELECT SQL_NO_CACHE *
FROM `ps_quantity_discount_rule` a
WHERE (a.`id_quantity_discount_rule` = 611) LIMIT 1
0.075 ms 1 /src/Adapter/EntityMapper.php:71
491
SELECT SQL_NO_CACHE srca.id_of_shipping_rule
FROM ps_of_shipping_rule_carrier srca
LEFT JOIN ps_carrier ca ON ca.id_reference = srca.id_carrier
WHERE srca.id_of_shipping_rule = 6
AND ca.id_carrier = 3 LIMIT 1
0.075 ms 0 /modules/orderfees_shipping/classes/ShippingRule.php:2065
530
SELECT SQL_NO_CACHE is_voluminoso from ps_product_farmaten_option Where id = 5114 LIMIT 1
0.075 ms 1 /modules/fc_farmaten/src/Services/VoluminosoService.php:15
575
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 8324) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.075 ms 1 /classes/stock/StockAvailable.php:453
657
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 12717
0.075 ms 1 /classes/Product.php:2902
95
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 755) LIMIT 1
0.075 ms 1 /classes/Category.php:1974
170
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5118
0.075 ms 5 /classes/Product.php:3423
266
SELECT SQL_NO_CACHE `id_state`
FROM `ps_state`
WHERE `iso_code` = 'VA' LIMIT 1
0.075 ms 392 /classes/State.php:147