Bolas Magneticas
  • Bolas Magneticas
  • zonas de reflexologia manos

Bolas Magneticas

M-Bo

La superficie de las bolas está erizada de cientos de pequeños picos que actúan como agujas en sus puntos de reflexología. Al mismo tiempo, se beneficia de los efectos de la magnetoterapia: vitalidad, alivio del dolor, relajación, porque hay un imán dentro de las bolas. (vendido por pares)

8,00 €
Cantidad

Descripción

Las bolas magnéticas para masaje de manos combinan los beneficios de la reflexología con los de la magnetoterapia.

Este par de bolas magnéticas es súper efectivo para masajear las palmas de las manos, también puedes usarlas en otras partes del cuerpo.

Las bolas magnéticas son fáciles de usar: agarre una bola, o ambas, y gírelas suavemente entre las palmas de sus manos.

Su uso regular mejora la circulación sanguínea y linfática.

VIDEO

Detalles del producto
M-Bo
Nuevo

Ficha técnica

Altura
3 cm
Origen
China
Para
Manos
También podría interesarle

Referencia: M-VM

Masajeador Coche

Este pequeño accesorio de masaje de madera es muy fácil de usar y muy divertido con su forma de coche. ¡Este carro de masaje también será muy popular entre los niños pequeños que disfrutarán rodarlo sobre el cuerpo de su mamá o papá!

Precio 10,00 €
Más
En stock

Referencia: M-LAN

Correa de Masaje

La correa de auto-masaje de espalda se vende con su bolsa de almacenamiento de seda india. Es ideal para aliviar el dolor y liberar la tensión muscular. Muy fácil de usar, se usa para la espalda, el cuello, los glúteos, la parte posterior de los muslos y las pantorrillas ... Puede llegar a todas las zonas de la parte posterior de su cuerpo rápidamente y sin esfuerzo.

Precio 14,90 €
Más
En stock

Referencia: M-MCV

Accessorio de Masaje

Pase este accesorio de masaje de madera de diseño limpio sobre su espalda, brazos y piernas. Tiene la forma de un coche de cuatro ruedas que relajará suavemente tus músculos.

Precio 12,90 €
Más
En stock

Referencia: M-MMP

Masajeador Mano y Pie

Este accesorio de masaje 2 en 1 se compone de 2 partes. La parte con varios puntos destacados es rodar entre las 2 manos, este movimiento estimula los puntos de reflexología de las manos. La otra parte se puede utilizar en las plantas de los pies u otras partes del cuerpo como palo de reflexología.

Precio 12,90 €
Más
En stock

Referencia: M-BM

Palo de Masaje

El palo de madera para reflexología se utiliza tradicionalmente en Tailandia para masajear el arco del pie. También se puede utilizar en otras partes del cuerpo, como manos, brazos, espalda, cara ...

Precio 8,00 €
Más
En stock

Referencia: M-MMB

Masajeador de manos

Coloca el masajeador de manos entre las palmas de tus manos, y gira, para actuar instantáneamente sobre los puntos de reflexología de tus manos.

Precio 8,00 €
Más
En stock

Referencia: M-TD

Vástago Automasaje Duro

Esta varilla de auto masaje es más dura y rígida que la anterior. Sujeta el extremo largo con 2 manos (no levantes los codos que deben quedar a los costados) y el extremo curvo masajea tu espalda en los lugares que desees, en la espalda alta pero también en la espalda baja, pasando la caña por los lados.

Precio 25,00 €
Más
En stock

Referencia: M-TS

Vástago Automasaje Flexible

Con esta barra de automasaje para la espalda podrás masajear tu espalda en profundidad tú mismo y dosificar la presión como desees. Te permite llegar fácilmente a todos los puntos de la espalda, sin levantar los brazos.

Precio 21,25 € Precio base 25,00 €
Más
En stock

Referencia: M-CM

Cruz de Masaje

Utilice este accesorio de masaje para aplicar presión en diferentes partes del cuerpo: pies, manos, brazos, espalda, cuello ... La cruz de masaje es un instrumento de masaje muy popular porque es sólido y permite un buen agarre.

Precio 10,00 €
Más
En stock

Referencia: S-Pds

Buda Oracion

Este Buda de esteatita (o soapstone) muy bonito mide 8 cm de alto. Es el Buda tailandés. La filosofía budista nos aconseja fomentar estados mentales positivos: alegría, paciencia, bondad, sabiduría y compasión. Buda está sentado aquí en la posición de loto, con ambas manos juntas en oración al nivel del chakra del corazón.

Precio 18,00 €
Más
En stock

Referencia: M-GMM

Grande Masajeador de Manos

Este accesorio de masaje es a agarrar y rodar entre las manos. Las pequeñas bolas en movimiento estimularán los puntos de reflexología de las manos. El uso de este instrumento estimula el intelecto y la concentración, así como la circulación de la sangre y la energía.

Precio 14,90 €
Más
En stock

Referencia: CoM

Caja de Masaje

Esta hermosa caja de regalo incluye una correa de masaje, un triángulo de masaje, una pelota de 4 patas, un anillo de masaje y un tutorial para el anillo de masaje. Viene empaquetado en su caja negra y un bonito paquete de regalo. Podemos agregar un mensaje personalizado a pedido.

Precio 32,00 €
Más
En stock

Referencia: M-B100

Lote de 100 Anillos de Masaje

Ideal para terapeutas, masajistas o tiendas de bienestar. Puede regalar los anillos a sus clientes (es un pequeño obsequio muy bienvenido) o revenderlos individualmente. Lote de 100 anillos de masaje de colores variados y aleatorios. El anillo de masaje o anillo de acupuntura previene la artritis y la osteoartritis, estimula los meridianos, activa la circulación y relaja los dedos.

Precio 100,00 €
Más
En stock

Referencia: M-BYa-A

Anillo de Masaje YANG

El anillo de masaje YANG es más apretado que el anillo YIN y es adecuado para la mañana para estimular los dedos. Es particularmente adecuado para personas con dedos finos, o personas que están acostumbradas a usar anillos de masaje y que buscan un efecto más fuerte.

Precio 3,00 €
Más
En stock

Referencia: M-BBM

1 Anillo + 1 Pulsera de Masaje

Cuídese masajeando sus dedos y manos con regularidad. ¡Cuida a los que te rodean dándoles este útil y agradable regalo! Perfecto para masajear y relajar dedos, manos y muñecas.

Precio 10,00 €
Más
En stock

Referencia: M-BoM

Bola de Masaje

La bola de masaje se puede utilizar sobre usted o sobre otra persona. Agarra la bola más grande y haz movimientos circulares y pequeños golpecitos en la mayor parte del cuerpo: espalda, piernas, brazos, estómago, cuello, cabeza ...

Precio 12,00 €
Más
En stock

Referencia: M-TRP

Rodillo de Masaje Pies

Descubre el placer del masaje de pies con la tableta de reflexología, que te proporcionará una relajación profunda y rápida de todo el cuerpo. Póngase cómodo en un sillón o en una silla y quítese los zapatos. Coloque la tableta en el piso, coloque los pies sobre ella y deslícela hacia adelante y hacia atrás.

Precio 27,00 € Precio base 30,00 €
Más
En stock

Referencia: M-MAP

Masajeador de Pies

Este masajeador de pies es muy resistente y eficiente, tiene dos pies con bolas de madera en diferentes áreas de refléxología. Debajo de los pies hay dos grandes resortes que permiten el movimiento hacia arriba y hacia abajo. Monta en el masajeador, descalzo y sube y baja los pies alternativamente.

Precio 39,00 €
Más
En stock
15 otros productos en la misma categoría:

Referencia: M-TRP

Rodillo de Masaje Pies

Descubre el placer del masaje de pies con la tableta de reflexología, que te proporcionará una relajación profunda y rápida de todo el cuerpo. Póngase cómodo en un sillón o en una silla y quítese los zapatos. Coloque la tableta en el piso, coloque los pies sobre ella y deslícela hacia adelante y hacia atrás.

Precio 27,00 € Precio base 30,00 €
Más
En stock

Referencia: CoM

Caja de Masaje

Esta hermosa caja de regalo incluye una correa de masaje, un triángulo de masaje, una pelota de 4 patas, un anillo de masaje y un tutorial para el anillo de masaje. Viene empaquetado en su caja negra y un bonito paquete de regalo. Podemos agregar un mensaje personalizado a pedido.

Precio 32,00 €
Más
En stock

Referencia: M-BBM

1 Anillo + 1 Pulsera de Masaje

Cuídese masajeando sus dedos y manos con regularidad. ¡Cuida a los que te rodean dándoles este útil y agradable regalo! Perfecto para masajear y relajar dedos, manos y muñecas.

Precio 10,00 €
Más
En stock

Referencia: M-B100

Lote de 100 Anillos de Masaje

Ideal para terapeutas, masajistas o tiendas de bienestar. Puede regalar los anillos a sus clientes (es un pequeño obsequio muy bienvenido) o revenderlos individualmente. Lote de 100 anillos de masaje de colores variados y aleatorios. El anillo de masaje o anillo de acupuntura previene la artritis y la osteoartritis, estimula los meridianos, activa la circulación y relaja los dedos.

Precio 100,00 €
Más
En stock

Referencia: M-MAT-B

Massaje de la Cabeza "zen-zen"

Este accesorio de masaje para la cabeza y el cabello produce efectos excepcionales con sus 12 varillas en 2 niveles diferentes que estimulan los millones de terminaciones nerviosas de su cráneo. ¡En unos segundos, te dará una increíble sensación de bienestar y relajación!

Precio 8,00 €
Más
En stock

Referencia: M-TS

Vástago Automasaje Flexible

Con esta barra de automasaje para la espalda podrás masajear tu espalda en profundidad tú mismo y dosificar la presión como desees. Te permite llegar fácilmente a todos los puntos de la espalda, sin levantar los brazos.

Precio 21,25 € Precio base 25,00 €
Más
En stock

Referencia: CoBE

Caja Bienestar

La caja de regalo bienestar Arasia es el regalo perfecto para cualquier persona interesada en el bienestar y el desarrollo personal. Está bellamente presentado en una caja de cartón y listo para regalar. Podemos agregar una nota personal a pedido.

Precio 29,00 €
Más
En stock

Referencia: M-BRA-A

Pulsera Acupresion

La pulsera de acupresión se utiliza para masajear las manos, muñecas, antebrazos y codos. Es un anillo de metal formado por pequeñas púas de forma triangular que masajean y estimulan los puntos de reflexología de tu mano.

Precio 10,00 €
Más
En stock

Referencia: CoAcu

Conjunto de Acupresión

Esta caja de regalo "acu-pressure" incluye 1 caja de madera, 1 pulsera de masaje, 1 anillo de masaje y 1 par de bolas magnéticas. Es el regalo perfecto para manos sanas, para todos y para las personas mayores en particular.

Precio 29,00 €
Más
En stock

Referencia: CoEv

Caja de Regalo Escape

Esta caja de regalo contiene 14 objetos dedicados a su bienestar: 1 estatuilla de Buda, 4 accesorios de masaje (1 masajeador de cabeza, 1 rueda, 1 bola de masaje con 4 patas, 1 anillo de masaje), 3 inciensos naturales diferentes (perfumes aleatorios), 1 porta incienso redondo blanqueado, 3 minerales diferentes, 1 árbol plantado en la India y 1 librito de bienestar que puedes ver AQUÍ.

Precio 49,00 €
Más
En stock

Referencia: M-TD

Vástago Automasaje Duro

Esta varilla de auto masaje es más dura y rígida que la anterior. Sujeta el extremo largo con 2 manos (no levantes los codos que deben quedar a los costados) y el extremo curvo masajea tu espalda en los lugares que desees, en la espalda alta pero también en la espalda baja, pasando la caña por los lados.

Precio 25,00 €
Más
En stock

Referencia: M-TF-Vi

Alfombra de Flores

Nuestra alfombra de flores mide 67 cm por 42 cm, se vende con su almohada (35 cm por 15 cm por 10 cm) y su bolsa de almacenamiento. Ideal para aliviar el dolor y activar la circulación sanguínea y linfática.

Precio 69,00 €
Más
En stock

Referencia: M-BYa-A

Anillo de Masaje YANG

El anillo de masaje YANG es más apretado que el anillo YIN y es adecuado para la mañana para estimular los dedos. Es particularmente adecuado para personas con dedos finos, o personas que están acostumbradas a usar anillos de masaje y que buscan un efecto más fuerte.

Precio 3,00 €
Más
En stock
Load Time982 ms - OK... for a shared hosting
Querying Time490 ms
Queries776
Memory Peak Usage16.9 Mb
Included Files927 files - 10.77 Mb
PrestaShop Cache- Mb
Global vars0.52 Mb
PrestaShop Version1.7.7.2
PHP Version7.3.27 (OK)
MySQL Version5.6.50-log (OK)
Memory Limit512M
Max Execution Time165s
Smarty Cachedisabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 58 ms 58 ms 2.05 Mb 2.08 Mb
__construct 2 ms 60 ms 0.08 Mb 2.13 Mb
init 131 ms 191 ms 2.15 Mb 4.29 Mb
checkAccess 0 ms 191 ms - Mb 4.29 Mb
setMedia 16 ms 207 ms 0.35 Mb 4.87 Mb
postProcess 0 ms 207 ms - Mb 4.87 Mb
initHeader 0 ms 207 ms - Mb 4.87 Mb
initContent 420 ms 627 ms 4.13 Mb 8.79 Mb
initFooter 0 ms 627 ms - Mb 8.79 Mb
display 355 ms 982 ms 7.71 Mb 16.88 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 776 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 649) AND (b.`id_shop` = 2) LIMIT 1
19.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `pod_country` c  INNER JOIN pod_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 2)
LEFT JOIN `pod_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `pod_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
8.4 244 Yes /classes/Country.php:147
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("2021-05-18 00:00:00",
INTERVAL 48 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `pod_category_product` cp
LEFT JOIN `pod_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN pod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2) LEFT JOIN `pod_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=2)
LEFT JOIN pod_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
LEFT JOIN `pod_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 2 )
LEFT JOIN `pod_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 2 )
LEFT JOIN `pod_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=2)
LEFT JOIN `pod_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 2)
LEFT JOIN `pod_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 2
AND cp.`id_category` = 125 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
5.7 16 Yes /classes/Category.php:1056
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(
"2021-05-18 00:00:00",
INTERVAL 48 DAY
)
) > 0 AS new
FROM `pod_accessory`
LEFT JOIN `pod_product` p ON p.`id_product` = `id_product_2`
INNER JOIN pod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_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=2)
LEFT JOIN `pod_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 2 
)
LEFT JOIN `pod_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 2 
)
LEFT JOIN `pod_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=2)
LEFT JOIN `pod_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `pod_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN pod_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 889 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
4.8 25 Yes Yes /classes/Product.php:4137
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `pod_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `pod_hook_alias` ha
INNER JOIN `pod_hook` h ON ha.name = h.name
3.7 0 /classes/Hook.php:1221
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 `pod_configuration` c
LEFT JOIN `pod_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
3.4 1914 /classes/Configuration.php:160
INSERT INTO `pod_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1167074', '190', '598725762', '', '2', '2', '2021-05-18 16:53:07')
2.8 1 /classes/ObjectModel.php:559
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pod_module` m
INNER JOIN pod_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 2 AND module_shop.enable_device & 1)
INNER JOIN `pod_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `pod_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pod_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pod_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 2) AND (mg.id_shop = 2 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.4 156 Yes Yes /classes/Hook.php:1161
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `pod_category` c
INNER JOIN `pod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 2 )
INNER JOIN `pod_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 2)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND c.`id_category` != 111
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 75
AND c.id_category IN (
SELECT id_category
FROM `pod_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
2.4 65 Yes /modules/ps_categorytree/ps_categorytree.php:149
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `pod_category` c
INNER JOIN pod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2)
LEFT JOIN `pod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 2 )
LEFT JOIN `pod_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 125
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 1 Yes Yes /classes/Category.php:918
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM pod_shop_url su
LEFT JOIN pod_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.arasia-shop.com' OR su.domain_ssl = 'www.arasia-shop.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
2 4 Yes /classes/shop/Shop.php:1341
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, active
FROM `pod_hook_module` hm
STRAIGHT_JOIN `pod_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 2)
STRAIGHT_JOIN `pod_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.8 364 /classes/Hook.php:487
INSERT INTO `pod_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')
1.8 1 /classes/ObjectModel.php:559
SELECT SQL_NO_CACHE id_page_type
FROM pod_page_type
WHERE name = 'product' LIMIT 1
1.7 1 /classes/Page.php:104
SELECT SQL_NO_CACHE psgdprl.message FROM `pod_psgdpr_consent` psgdpr
LEFT JOIN pod_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 17 AND psgdprl.id_lang =2 LIMIT 1
1.6 3 /modules/psgdpr/classes/GDPRConsent.php:111
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `pod_lang` l
JOIN pod_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 2)
WHERE l.`active` = 1 LIMIT 1
1.5 25 /classes/Language.php:1123
SELECT SQL_NO_CACHE `id_page`
FROM `pod_page`
WHERE `id_page_type` = 13 AND `id_object` = 889 LIMIT 1
1.5 1 /classes/Page.php:83
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (944) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.4 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1164
1.4 6 /classes/ProductAssembler.php:90
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1107) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.4 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `pod_meta` m
LEFT JOIN `pod_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 2 )
ORDER BY LENGTH(ml.url_rewrite) DESC
1.3 100 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 507
ORDER BY f.position ASC
1.3 6 Yes /classes/Product.php:5195
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1401) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.2 3 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 989
ORDER BY f.position ASC
1.2 6 Yes /classes/Product.php:5195
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1164) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.2 5 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1366
ORDER BY `position`
1.2 3 Yes /classes/Product.php:3096
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (503) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.2 4 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
FROM `pod_angarbanners`
WHERE id_shop = 2 AND id_lang = 2
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
1.1 40 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 769
1.1 8 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pod_hook`
1.1 647 /classes/Hook.php:1221
SELECT SQL_NO_CACHE * FROM `pod_state` ORDER BY `name` ASC
1.1 232 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `pod_specific_price` WHERE `id_product` != 0 LIMIT 1
1.1 1375 /classes/SpecificPrice.php:286
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1210) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.1 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1210
ORDER BY f.position ASC
1.1 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1020 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1401
ORDER BY f.position ASC
1.1 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1164
ORDER BY `position`
1.1 2 Yes /classes/Product.php:3096
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1366) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `pod_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `pod_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 889
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1 1 Yes Yes /classes/Product.php:2434
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (957) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 2 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 550
ORDER BY f.position ASC
1 6 Yes /classes/Product.php:5195
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1244) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 3 Yes /classes/Product.php:3993
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`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
LEFT JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pod_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN pod_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 2)
WHERE pa.`id_product` = 889
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:4048
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (769) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 7 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 769
ORDER BY f.position ASC
1 11 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE * FROM `pod_currency` c ORDER BY `iso_code` ASC
1 4 Yes /classes/Currency.php:695
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 550 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1366
1 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `pod_category` c
LEFT JOIN `pod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 2 )
INNER JOIN pod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2)
WHERE `id_lang` = 2
AND c.`id_parent` = 1
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1 6 Yes Yes /classes/Category.php:1144
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 507 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `pod_product_attribute_image` pai
LEFT JOIN `pod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `pod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (2892, 2893) AND il.`id_lang` = 2 ORDER by i.`position`
1 2 Yes /classes/Product.php:2529
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 943
ORDER BY `position`
1 2 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE psgdpr.active FROM `pod_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 17 LIMIT 1
1 3 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `pod_product_attribute_image` pai
LEFT JOIN `pod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `pod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (3062, 3063, 3064, 3065, 3066) AND il.`id_lang` = 2 ORDER by i.`position`
0.9 5 Yes /classes/Product.php:2529
(SELECT SQL_NO_CACHE * FROM `pod_cart_rule` cr
LEFT JOIN `pod_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2)
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.9 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 943
ORDER BY f.position ASC
0.9 5 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `pod_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `pod_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 889
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.9 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1164
ORDER BY f.position ASC
0.9 10 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 889
ORDER BY f.position ASC
0.9 4 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 17 AND `id_shop` = 2
0.9 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1164
0.9 5 /classes/Product.php:2510
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1259 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 4 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 957
0.9 3 /classes/ProductAssembler.php:90
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 3299
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1401 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3299
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1401 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.9 0 /classes/Cart.php:1404
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 `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
INNER JOIN pod_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 2)
WHERE pa.`id_product` = 889
0.9 1 /classes/Product.php:6462
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1289) 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.9 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 778
ORDER BY f.position ASC
0.9 4 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1116) AND (b.`id_shop` = 2) LIMIT 1
0.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1153
ORDER BY `position`
0.9 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 943 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 5 Yes /classes/SpecificPrice.php:560
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 pod_shop_group gs
LEFT JOIN pod_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pod_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.9 1 Yes /classes/shop/Shop.php:703
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 776
ORDER BY f.position ASC
0.9 5 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1302
ORDER BY `position`
0.9 2 Yes /classes/Product.php:3096
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
FROM `pod_product` p
INNER JOIN `pod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 507)
0.9 1 /classes/Product.php:3401
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 769 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 769 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.9 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1164
ORDER BY `position`
0.9 2 Yes /classes/Product.php:3096
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 778 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 778 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.9 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `pod_category` a
LEFT JOIN `pod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 125) AND (b.`id_shop` = 2) LIMIT 1
0.9 1 /src/Adapter/EntityMapper.php:75
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1154) 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.9 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 944 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 944
ORDER BY f.position ASC
0.9 5 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `pod_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `pod_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 889
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.9 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 889) AND (b.`id_shop` = 2) LIMIT 1
0.9 1 /src/Adapter/EntityMapper.php:75
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1154) 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.8 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3062
AND agl.`id_lang` = 2
0.8 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE *
FROM `pod_group` a
LEFT JOIN `pod_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 2
WHERE (a.`id_group` = 1) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_currency` a
LEFT JOIN `pod_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `pod_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 2
WHERE (a.`id_currency` = 1) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1131) 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.8 1 Yes /classes/Product.php:3993
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 550 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 550 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `pod_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `pod_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 889
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.8 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `pod_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `pod_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 889
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.8 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 769
AND pac.`id_product_attribute` = 2783
AND agl.`id_lang` = 2
0.8 1 /classes/Product.php:6435
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (989) 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.8 1 Yes /classes/Product.php:3993
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1164) 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.8 5 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_lang` FROM `pod_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
0.8 5 /classes/Language.php:790
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 649
ORDER BY f.position ASC
0.8 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1116
ORDER BY f.position ASC
0.8 5 Yes /classes/Product.php:5195
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1116) 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.8 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 503
ORDER BY f.position ASC
0.8 8 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 777
0.8 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE `id_country`
FROM `pod_country`
WHERE `iso_code` = 'US' LIMIT 1
0.8 1 /classes/Country.php:193
SELECT SQL_NO_CACHE value FROM `pod_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.8 1 /classes/shop/Shop.php:1162
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1401) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (943) 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.8 1 Yes /classes/Product.php:3993
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 889 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 889 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1401
AND pac.`id_product_attribute` = 3299
AND agl.`id_lang` = 2
0.8 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE * FROM `pod_psreassurance` pr
LEFT JOIN pod_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "2" 
AND prl.id_shop = "2"
AND pr.status = 1
ORDER BY pr.position
0.8 4 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:186
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1366 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php: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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 507 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 507 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1153) 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.8 1 Yes /classes/Product.php:3993
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 943 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 943 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `pod_country` a
LEFT JOIN `pod_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 2
WHERE (a.`id_country` = 8) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 503) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 944) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 889) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 550) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 503
ORDER BY `position`
0.8 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1259) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1210
ORDER BY `position`
0.8 3 Yes /classes/Product.php:3096
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1107) 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.8 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 503
AND pac.`id_product_attribute` = 2638
AND agl.`id_lang` = 2
0.8 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 14 AND `id_shop` = 2
0.8 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 943
ORDER BY `position`
0.8 2 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1302
0.8 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 778 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 4 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1244
0.8 4 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE *
FROM `pod_category` a
LEFT JOIN `pod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 1) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 777
ORDER BY f.position ASC
0.8 5 Yes /classes/Product.php:5195
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1401 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 1401 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `pod_category` a0
LEFT JOIN `pod_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 22) AND (a0.`nright` > 23) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
0.8 24 /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE *
FROM `pod_product_attribute` a
LEFT JOIN `pod_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 2
WHERE (a.`id_product_attribute` = 2783) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 769) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 889) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1116 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1153
ORDER BY f.position ASC
0.8 8 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 503
0.7 5 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE `id_guest`
FROM `pod_connections`
WHERE `id_guest` = 1167074
AND `date_add` > '2021-05-18 16:23:00'
AND id_shop IN (2) 
ORDER BY `date_add` DESC LIMIT 1
0.7 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1154
ORDER BY f.position ASC
0.7 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3066
AND agl.`id_lang` = 2
0.7 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.7 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `pod_specific_price` WHERE `id_product` != 0
0.7 1374 /classes/SpecificPrice.php:294
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 957
ORDER BY f.position ASC
0.7 8 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1244
ORDER BY f.position ASC
0.7 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE c.id_currency
FROM `pod_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.7 1 /classes/Currency.php:866
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pod_module` m
LEFT JOIN `pod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 2
0.7 91 /classes/module/Module.php:322
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 503
AND pac.`id_product_attribute` = 2636
AND agl.`id_lang` = 2
0.7 1 /classes/Product.php:6435
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
FROM `pod_product` p
INNER JOIN `pod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 1164)
0.7 5 /classes/Product.php:3401
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1366
ORDER BY f.position ASC
0.7 6 Yes /classes/Product.php:5195
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
FROM `pod_product` p
INNER JOIN `pod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 769)
0.7 7 /classes/Product.php:3401
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 957
ORDER BY `position`
0.7 3 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 649 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1259
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1259
ORDER BY f.position ASC
0.7 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 2
0.7 4 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `name`
FROM `pod_hook`
WHERE `id_hook` = 14 LIMIT 1
0.7 1 /classes/Hook.php:222
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1154
0.7 1 /classes/ProductAssembler.php:90
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 944 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 944 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (507) 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.7 1 Yes /classes/Product.php:3993
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1302) 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.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 507 AND `id_group` = 1 LIMIT 1
0.7 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE tr.*
FROM `pod_tax_rule` tr
JOIN `pod_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.7 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `pod_product_attribute_image` pai
LEFT JOIN `pod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `pod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (3062, 3063, 3064, 3065, 3066) AND il.`id_lang` = 2 ORDER by i.`position`
0.7 5 Yes /classes/Product.php:2529
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM pod_link_block cb
WHERE `id_hook` = 12
ORDER by cb.`position`
0.7 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
SELECT SQL_NO_CACHE *
FROM pod_meta m
LEFT JOIN pod_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 2
AND ml.id_shop = 2 LIMIT 1
0.7 1 /classes/Meta.php:189
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 778
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 943
0.7 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 1259
AND image_shop.`cover` = 1 LIMIT 1
0.7 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 550) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 889 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 4 Yes /classes/SpecificPrice.php: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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1210 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 1210 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1131
ORDER BY f.position ASC
0.7 3 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1116
0.7 1 /classes/ProductAssembler.php:90
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 776 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 776 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
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
FROM `pod_product` p
INNER JOIN `pod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 1259)
0.7 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `pod_link_block` a
WHERE (a.`id_link_block` = 1) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 943) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 503
AND pac.`id_product_attribute` = 2637
AND agl.`id_lang` = 2
0.7 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 889 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.7 4 Yes /classes/SpecificPrice.php:623
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1366
0.7 1 /classes/Product.php:2510
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 2783
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 769 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 2783
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 769 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM pod_link_block cb
WHERE `id_hook` = 35
ORDER by cb.`position`
0.7 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1020) 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.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
FROM `pod_currency` a
LEFT JOIN `pod_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `pod_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 2
WHERE (a.`id_currency` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 776) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1289) 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.7 1 Yes /classes/Product.php:3993
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (649) 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.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_country`
FROM `pod_country`
WHERE `iso_code` = 'US' LIMIT 1
0.7 1 /classes/Country.php:193
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1259) 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.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 982
ORDER BY f.position ASC
0.7 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.7 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pod_country`
WHERE `id_country` = 8 LIMIT 1
0.7 1 /classes/Country.php:401
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1401
0.7 6 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1131
0.7 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE *
FROM `pod_link_block_lang`
WHERE `id_link_block` = 1
0.7 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 982
0.7 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 778
ORDER BY `position`
0.7 2 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 507
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 0 /classes/SpecificPrice.php:249
(SELECT SQL_NO_CACHE * FROM `pod_cart_rule` cr
LEFT JOIN `pod_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2)
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.7 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE *
FROM `pod_product_attribute` a
LEFT JOIN `pod_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 2
WHERE (a.`id_product_attribute` = 3299) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_angarbanners`
WHERE id_shop = 2 AND id_lang = 2
AND hook = 'header' AND active = 1
ORDER BY item_order ASC
0.7 40 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1210) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (550) 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.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
FROM `pod_currency_lang`
WHERE `id_currency` = 1
0.7 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1107
ORDER BY f.position ASC
0.7 3 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `pod_lang` l
LEFT JOIN `pod_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.7 5 /classes/Language.php:991
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `pod_product_attribute_image` pai
LEFT JOIN `pod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `pod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (3210, 3230, 3231) AND il.`id_lang` = 2 ORDER by i.`position`
0.7 5 Yes /classes/Product.php:2529
SELECT SQL_NO_CACHE pa.`available_date` FROM `pod_product` p LEFT JOIN `pod_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN pod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2) INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) WHERE p.`id_product` = 769 AND pa.`id_product` = 769 AND pa.`id_product_attribute` = 2783 LIMIT 1
0.7 1 /classes/Product.php:949
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 1116
AND image_shop.`cover` = 1 LIMIT 1
0.7 8 /classes/Product.php:3118
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 776 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1259 AND `id_group` = 1 LIMIT 1
0.7 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 503 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1289
ORDER BY f.position ASC
0.7 5 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE format
FROM `pod_address_format`
WHERE `id_country` = 8 LIMIT 1
0.7 1 /classes/AddressFormat.php:676
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 769 LIMIT 1
0.7 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `pod_currency` c
LEFT JOIN pod_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 2)
WHERE c.`active` = 1 LIMIT 1
0.7 4 /classes/Currency.php:1099
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1116
ORDER BY `position`
0.7 8 Yes /classes/Product.php:3096
(SELECT SQL_NO_CACHE * FROM `pod_cart_rule` cr
LEFT JOIN `pod_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2)
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.7 1 /classes/CartRule.php:403
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 3065
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1164 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3065
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1164 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE pa.`available_date` FROM `pod_product` p LEFT JOIN `pod_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN pod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2) INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) WHERE p.`id_product` = 1401 AND pa.`id_product` = 1401 AND pa.`id_product_attribute` = 3299 LIMIT 1
0.7 1 /classes/Product.php:949
SELECT SQL_NO_CACHE *
FROM `pod_country_lang`
WHERE `id_country` = 21
0.7 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1244
AND pac.`id_product_attribute` = 3210
AND agl.`id_lang` = 2
0.7 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 507) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1154
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1401) AND (id_product_attribute = 3299) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:441
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 503 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 503 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.7 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1153) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 503
AND pac.`id_product_attribute` = 3275
AND agl.`id_lang` = 2
0.7 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1164
0.7 5 /classes/Product.php:2510
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 889
AND image_shop.`cover` = 1 LIMIT 1
0.7 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 989 LIMIT 1
0.7 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_orders` o
LEFT JOIN `pod_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`)
WHERE o.`id_customer` = 0
AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 173 LIMIT 1
0.7 3 /classes/order/Order.php:847
SELECT SQL_NO_CACHE pa.`available_date` FROM `pod_product` p LEFT JOIN `pod_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN pod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2) INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) WHERE p.`id_product` = 1164 AND pa.`id_product` = 1164 AND pa.`id_product_attribute` = 3065 LIMIT 1
0.7 1 /classes/Product.php:949
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 944
0.7 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pod_product_attribute pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
WHERE pa.id_product = 889 LIMIT 1
0.7 1 /classes/Product.php:856
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1366) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1107 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pod_category_product` cp
INNER JOIN `pod_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 889 AND ctg.`id_group` = 1 LIMIT 1
0.7 3 /classes/Product.php:5753
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1210 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 944 LIMIT 1
0.7 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE *
FROM `pod_country` a
LEFT JOIN `pod_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `pod_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 2
WHERE (a.`id_country` = 8) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1020
ORDER BY f.position ASC
0.7 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.7 1 /classes/order/Order.php:1193
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1210) 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.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 507 AND id_shop=2 LIMIT 1
0.6 1 /classes/Product.php:5871
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 777 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 777 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pod_category_product` cp
INNER JOIN `pod_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 1020 AND ctg.`id_group` = 1 LIMIT 1
0.6 3 /classes/Product.php:5753
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1164 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 1164 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 649
AND image_shop.`cover` = 1 LIMIT 1
0.6 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE *
FROM `pod_country_lang`
WHERE `id_country` = 8
0.6 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1302
ORDER BY f.position ASC
0.6 5 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 957
AND pac.`id_product_attribute` = 2893
AND agl.`id_lang` = 2
0.6 1 /classes/Product.php:6435
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (944) 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.6 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 943
AND image_shop.`cover` = 1 LIMIT 1
0.6 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1401 LIMIT 1
0.6 1 /classes/SpecificPrice.php:419
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1302 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 1302 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 503
AND image_shop.`cover` = 1 LIMIT 1
0.6 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 777 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE `id_country`
FROM `pod_address`
WHERE `id_customer` = 0
AND `deleted` = 0
0.6 5 /classes/CartRule.php:471
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.6 1 /classes/order/Order.php:1193
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 `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1259 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_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` = 1259 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
WHERE pa.`id_product_attribute` = 2783 LIMIT 1
0.6 1 /classes/Combination.php:462
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 1131
ORDER BY `position`
0.6 9 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE * FROM `pod_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.6 9 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3063
AND agl.`id_lang` = 2
0.6 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 989 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 982 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 2
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1107
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pod_product_attribute pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
WHERE pa.id_product = 989 LIMIT 1
0.6 1 /classes/Product.php:856
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1210
0.6 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 769
AND pac.`id_product_attribute` = 2784
AND agl.`id_lang` = 2
0.6 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE c.id_currency
FROM `pod_currency` c
WHERE (iso_code = 'GBP') LIMIT 1
0.6 1 /classes/Currency.php:866
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 944
AND image_shop.`cover` = 1 LIMIT 1
0.6 2 /classes/Product.php:3118
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
FROM `pod_product` p
INNER JOIN `pod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 944)
0.6 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.6 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 59 LIMIT 1
0.6 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE *
FROM `pod_angarbanners`
WHERE id_shop = 2 AND id_lang = 2
AND hook = 'left' AND active = 1
ORDER BY item_order ASC
0.6 40 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 769
AND image_shop.`cover` = 1 LIMIT 1
0.6 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE *
FROM `pod_cms` a
LEFT JOIN `pod_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 2
WHERE (a.`id_cms` = 14) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
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 `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_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 = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (776) 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.6 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE ctg.`id_group`
FROM pod_category_group ctg
WHERE ctg.`id_category` = 125 AND ctg.`id_group` = 1 LIMIT 1
0.6 1