tapiz de pared buda blanco
  • tapiz de pared buda blanco
  • Colgando buddha blanco

Tapiz de Pared Buda Blanco

TPMB

Este tapiz es de color blanco y negro, fabricado en algodón grueso con flecos y mide aproximadamente 2,20 m de alto por 1,20 m de ancho. Representa a Buda meditando bajo la higuera sagrada o árbol Bodhi. Este árbol es de hecho un baniano, muy común en los templos o pagodas de los países asiáticos.

22,00 €
Cantidad

Detalles del producto
TPMB
Nuevo

Ficha técnica

Tamano
1,20 m * 2,20 m
Origen
India
Material Textil
Algodon grueso
Peso
0.5 kg
También podría interesarle

Referencia: TPMBO

Tapiz de Pared Buda Naranja

Este tapiz de pared color mármol naranja con patrones de inspiración celta representa a Buda en meditación debajo de un árbol. ¡Traerá un toque de refinada espiritualidad asiática a su interior! Se le pregunta a Buda "¿Qué has ganado de la meditación?" Él responde "Nada, por otro lado déjame decirte lo que perdí: ira, ansiedad, depresión, inseguridad, miedo al envejecimiento y miedo a la muerte"

Precio 22,00 €
Más
En stock

Referencia: EnRo

Incienso Rosa

Arasia ofrece el incienso natural Auroshikha Rose que intensifica los sentimientos positivos de amor y amistad. Déjese seducir por este penetrante y voluptuoso olor a ramo de flores. El aroma de las rosas frescas se obtiene mezclando la rosa absoluta con aceites esenciales de geranio, ylang-ylang y gaiacwood. ¡Este delicado perfume embruja y despierta la libido!

Precio 2,50 €
Más
En stock

Referencia: TGMBV

Tapiz de Pared Buda Verde

Este gran tapiz de pared "Meditación" color verde mide 2,40 m por 2,20 m. Representa a Buda en meditación en el centro de una flor de loto. Esta envíando vibraciones de amor representadas por corazones.

Precio 30,00 €
Más
En stock

Referencia: PAB-O

Pergamino Buda

Esta decoración de pared proviene de Tailandia y representa una cabeza de Buda. Se enrolla y se despliega como un pergamino. Hay una cuerda para colgarlo a un clavo, por ejemplo.

Precio 26,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: PRQr

Cuarzo Rosa

El cuarzo rosa es la piedra del amor universal. Aporta suavidad y cura los dolores de corazón (muy útiles para los niños pequeños). Deslice-la debajo de la almohada para un sueño reparador. El cuarzo rosa soporta la auto-realización. Esta piedra es excelente para impulsar su creatividad!

Precio 4,00 €
Más
En stock

Referencia: TGMBB

Grande Tapiz Buda Blanco

Este gran tapiz de pared Buda blanco mide 2,40 m de alto por 2,20 m de ancho. Representa a Buda en posición de loto, bajo un árbol de higuera.

Precio 29,00 €
Más
En stock

Referencia: S-BR

Buda de Resina Negra

Este Buda de resina negra mide aproximadamente 13 cm y pesa aproximadamente 140 gramos. Sentado en la posición de loto, realiza con su mano derecha el gesto de tomar la tierra como testigo, y su mano izquierda sostiene un vajra o dorje.

Precio 20,00 €
Más
En stock

Referencia: TGMBO

Grande Tapiz de Pared Buda

Este gran tapiz de pared naranja de Buda mide 2.40m por 2.20m. Es de algodón grueso con flecos. Muestra al Buda histórico, en posición de enseñanza, sentado debajo de un banian cuyas hojas caen y representan al tiempo que pasa.

Precio 29,00 €
Más
En stock

Referencia: S-CB

Buda Chino de Bronce

Este Buda chino de bronce (o Buda sonriente) es una representación de Butai o Putai, un monje budista zen chino que vivió durante la última dinastía Liang de China. Su nombre budista, Quieci, significa promesa en chino. Altura 14 cm.

Precio 108,00 €
Más
En stock

Referencia: S-BM

Buda Bronce

Este Buda de bronce está sentado en posición de loto con un frasco de ungüento en sus manos. Es Bhaishajyaguru, el Buda de la Medicina, o "Maestro Sanador de la Luz". Se especializa en curar el cuerpo y la mente. Su altura es de 14 cm.

Precio 89,00 €
Más
En stock

Referencia: S-BP

Buda Pensador

Este Buda en resina roja y dorada está representado en la posición del pensador. Ambas manos descansan sobre la rodilla izquierda levantada y la cabeza descansa sobre las manos. Los ojos estan cerrados. Esta posición invita a la relajación. Alto 19 cm, ancho 13 cm.

Precio 49,00 €
Más
En stock

Referencia: S-BCR

Buda Chino en Resina

Este Buda chino de resina verde procede de Nepal. Lejos de presentar la imagen de una vida ascética, el Buda chino no es el Buda histórico, que era bastante delgado. Este Buda trae la suerte y se encuentra en la mayoría de los hogares chinos, así como en muchos templos y restaurantes asiáticos. Simboliza la alegría de vivir, la abundancia y la riqueza. Altura 8 cm

Precio 20,00 €
Más
En stock

Referencia: BRAP-Qr

Pulsera de Cuarzo Rosa

Esta pulsera está hecha de cuentas de cuarzo rosa natural. Diámetro de cuentas 8 mm. Esta pulsera te traerá inspiración para una vida plena. El cuarzo rosa es una piedra de amor y dulzura, trae paz y cura las penas. Promueve la armonía y la confianza.

Precio 20,00 €
Más
En stock

Referencia: TPMBB

Tapiz de Pared Buda Azul

Este tapiz de pared de Buda azul y burdeos está hecho de algodón y mide aproximadamente 110 cm de alto por 70 cm de ancho. Representa a Buda meditando en medio de una flor de loto y corazones. Este colgante simboliza la ligereza de la flor de loto que se eleva sobre la superficie del agua, y del Buda, tan ligero que descansa como una mariposa sobre el loto.

Precio 15,00 €
Más
En stock

Referencia: BO-B

Pendientes Buda

Estos bonitos pendientes de latón representan cabezas de Buda tailandés. Altura de pendientes: 5 cm. Los ojos cerrados simbolizan la meditación profunda y las orejas largas simbolizan la escucha atenta.

Precio 14,90 €
Más
En stock
16 otros productos en la misma categoría:

Referencia: TPMMVi

Tapiz de Pared Mandala Violeta

Este tapiz mandala de algodón morado, rosa y blanco mide aproximadamente 110 cm por 70 cm. Está fabricado en India y 100% algodón. Puedes colgarlo en la pared, vertical u horizontalmente. También puedes usarlo como mantel para una mesa pequeña. El mandala ha sido un símbolo de sabiduría desde la antigüedad.

Precio 15,00 €
Más
En stock

Referencia: TGMEV

TAPIZ de pared ELEFANTE VERDE

Este gran tapiz de pared elefante verde claro mide aproximadamente 220 cm de alto por 210 cm de ancho. Ideal para colgar en una pared grande, o como colcha. En la India, el elefante es sagrado porque lleva sobre su espalda el mundo del que representa los 4 pilares.

Precio 29,00 €
Más
En stock

Referencia: TPMY

Tapiz de Pared Yin Yang

Este tapiz de pared Yin Yang blanco y negro está hecho de algodón grueso con flecos. Mide aproximadamente 1,20 metros por 2,20 metros. Puedes colgarlo en la pared de forma vertical u horizontal. Tambien es el tamaño perfecto para cubrir una cama individual o un sillón.

Precio 22,00 €
Más
En stock

Referencia: TGMMV

Gran Tapiz Mandala Verde

Este gran colgante de pared mide 2,20 metros por 2,40 metros. Hay rondas de flores, elefantes y camellos decorados en tonos de verde oscuro, azul oscuro, rojo, naranja y crema.

Precio 29,00 €
Más
En stock

Referencia: TGMBV

Tapiz de Pared Buda Verde

Este gran tapiz de pared "Meditación" color verde mide 2,40 m por 2,20 m. Representa a Buda en meditación en el centro de una flor de loto. Esta envíando vibraciones de amor representadas por corazones.

Precio 30,00 €
Más
En stock

Referencia: TMMeV

Tapiz de Pared Meditacion Verde

Este tapiz de algodón mide aproximadamente 110 cm por 70 cm, es verde y negra. Vemos a un yogui meditando en la posición de loto, con la representación en sánscrito de los siete chakras, y rodeado de estrellas.

Precio 15,00 €
Más
En stock

Referencia: TGMBO

Grande Tapiz de Pared Buda

Este gran tapiz de pared naranja de Buda mide 2.40m por 2.20m. Es de algodón grueso con flecos. Muestra al Buda histórico, en posición de enseñanza, sentado debajo de un banian cuyas hojas caen y representan al tiempo que pasa.

Precio 29,00 €
Más
En stock

Referencia: TGMER

Tapiz de Pared Elefante Rojo

Este gran tapiz indio rojo 100% algodón representa un elefante. Mide aproximadamente 2,20 m por 2,10 m. El elefante fue domesticado por primera vez hace más de 4.500 años en el valle del Indo.

Precio 29,00 €
Más
En stock

Referencia: TPMEB

Tapiz de Pared Elefante Azul

Este tapiz de pared representa un elefante bajo el árbol del conocimiento, el diseño es azul cielo sobre fondo negro. Tiene 2,20 m de altura y 1,20 m de ancho. El elefante es un símbolo de fuerza, coraje, longevidad y fertilidad.

Precio 22,00 €
Más
En stock

Referencia: TGMEO

Grande Tapiz Elefante

Este gran tapiz de pared con flecos gruesos presenta un gran elefante en un círculo, en el centro y muchos elefantes más pequeños alrededor. Sus colores muy naturales son rojo, marrón, naranja, negro y verde. Tambien se puede usar como colcha.

Precio 29,00 €
Más
En stock

Referencia: TGMMB

Grande Tapiz Mandala

Este gran tapiz de pared mandala mide 2,40 metros por 2,20 metros. Vemos elefantes y pavos reales, así como una decoración de hojas y flores. Este tapiz de algodón está en tonos violeta, verde, amarillo, rojo y rosa.

Precio 29,00 €
Más
En stock

Referencia: TMMV

Pequeno Tapiz Mandala

Este tapiz de pared indio de algodón mide 110 cm por 70 cm. Vemos un mandala de flores muy bonito en tonos rosa y verde sobre un fondo blanco. El mandala prodiga diferentes virtudes: apaciguamiento, seguridad, reenfoque ...

Precio 15,00 €
Más
En stock

Referencia: TPMAO

Tapiz Arbol de la Vida Naranja

Este tapiz de pared árbol de la vida naranja mide 2,20 m de alto y 1,20 m de ancho. El árbol de la vida es un poderoso símbolo en muchas religiones y tradiciones filosóficas de todo el mundo y a través de los siglos.

Precio 22,00 €
Más
En stock

Referencia: TMMeO

Tapiz de Pared Meditacion Naranja

Este tapiz de algodón naranja representa a un yogui meditando en posición de loto. Vemos las representaciones en sánscrito de los siete chakras principales. Mide 110 cm de alto por 70 cm de ancho.

Precio 15,00 €
Más
En stock
Load Time1165 ms - OK... for a shared hosting
Querying Time932 ms
Queries760
Memory Peak Usage16.9 Mb
Included Files925 files - 10.75 Mb
PrestaShop Cache- Mb
Global vars0.51 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 46 ms 46 ms 2.05 Mb 2.08 Mb
__construct 1 ms 48 ms 0.08 Mb 2.13 Mb
init 101 ms 149 ms 2.15 Mb 4.29 Mb
checkAccess 0 ms 149 ms - Mb 4.29 Mb
setMedia 14 ms 162 ms 0.35 Mb 4.87 Mb
postProcess 0 ms 162 ms - Mb 4.87 Mb
initHeader 0 ms 162 ms - Mb 4.87 Mb
initContent 499 ms 662 ms 3.68 Mb 8.34 Mb
initFooter 0 ms 662 ms - Mb 8.34 Mb
display 503 ms 1165 ms 8.22 Mb 16.91 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 760 queries

Query Time (ms) Rows Filesort Group By Location
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` = 1098 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
6.9 26 Yes Yes /classes/Product.php:4137
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` = 39 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
6.8 42 Yes /classes/Category.php:1056
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`)
6.1 1914 /classes/Configuration.php:160
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
4.6 65 Yes /modules/ps_categorytree/ps_categorytree.php:149
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`
3.8 156 Yes Yes /classes/Hook.php:1161
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
3.7 244 Yes /classes/Country.php:147
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` = 283) AND (b.`id_shop` = 2) LIMIT 1
3 1 /src/Adapter/EntityMapper.php:75
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
2.9 0 /classes/Hook.php:1221
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 (987) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
2.9 4 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 (714) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
2.7 1 Yes /classes/Product.php:3993
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` = 1097)
2.7 1 /classes/Product.php:3401
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)
2.6 5 /classes/Language.php:991
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 17 AND `id_shop` = 2
2.5 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1286 AND `id_group` = 1 LIMIT 1
2.4 0 /classes/GroupReduction.php:156
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` = 1266 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` = 1266 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2.4 0 /classes/Cart.php:1404
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
2.4 4 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:186
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` = 1134
ORDER BY `position`
2.4 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 (1269) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
2.4 1 Yes /classes/Product.php:3993
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
2.4 25 /classes/Language.php:1123
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1134 AND id_shop=2 LIMIT 1
2.4 1 /classes/Product.php:5871
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 = 1193
ORDER BY f.position ASC
2.3 7 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` = 1286 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
2.3 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1286 LIMIT 1
2.3 1 /classes/Pack.php:85
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
2.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 (1314) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
2.2 1 Yes /classes/Product.php:3993
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.2 4 Yes /classes/shop/Shop.php:1341
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1286
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.2 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1286) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
2.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM pod_link_block cb
WHERE `id_hook` = 12
ORDER by cb.`position`
2.2 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1193 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` = 1193 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2.2 0 /classes/Cart.php:1404
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` = 1097 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
2.2 5 Yes /classes/SpecificPrice.php:560
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` = 39
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2.2 1 Yes Yes /classes/Category.php:918
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
2.2 40 Yes /modules/angarbanners/angarbanners.php:312
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` = 1134 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
2.1 5 Yes /classes/SpecificPrice.php:560
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` = 1144) AND (b.`id_shop` = 2) LIMIT 1
2.1 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` = 1266) AND (b.`id_shop` = 2) LIMIT 1
2.1 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 = 1267
ORDER BY f.position ASC
2.1 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` = 987
AND pac.`id_product_attribute` = 3029
AND agl.`id_lang` = 2
2.1 1 /classes/Product.php:6435
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` = 1266
AND image_shop.`cover` = 1 LIMIT 1
2.1 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE `id_lang` FROM `pod_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
2.1 5 /classes/Language.php:790
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1193 AND id_shop=2 LIMIT 1
2.1 1 /classes/Product.php:5871
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 = 1144
ORDER BY f.position ASC
2.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` = 732 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
2.1 5 Yes /classes/SpecificPrice.php:560
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` = 1225
AND image_shop.`cover` = 1 LIMIT 1
2.1 2 /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` = 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
2 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` = 1098 AND ctg.`id_group` = 1 LIMIT 1
2 4 /classes/Product.php:5753
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` = 1098) AND (b.`id_shop` = 2) LIMIT 1
2 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` = 1207) AND (b.`id_shop` = 2) LIMIT 1
2 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 (1260) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
2 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 = 1314
ORDER BY f.position ASC
2 8 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
2 1 /classes/order/Order.php:1193
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 = 1178
ORDER BY f.position ASC
2 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 = 1225
ORDER BY f.position ASC
2 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` = 1400 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.9 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, alias FROM `pod_hook_alias`
1.9 88 /classes/Hook.php:336
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 (267) 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.9 1 Yes /classes/Product.php:3993
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` = 1134) AND (b.`id_shop` = 2) LIMIT 1
1.9 1 /src/Adapter/EntityMapper.php:75
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` = 732)
1.9 1 /classes/Product.php:3401
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` = 210 LIMIT 1
1.9 2 /classes/order/Order.php:847
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` = 1411)
1.9 1 /classes/Product.php:3401
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;
1.9 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` = 987
AND pac.`id_product_attribute` = 3030
AND agl.`id_lang` = 2
1.9 1 /classes/Product.php:6435
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 = 714
1.9 1 /classes/ProductAssembler.php:90
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` = 1098 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
1.9 5 Yes /classes/SpecificPrice.php:623
SELECT SQL_NO_CACHE * FROM `pod_state` ORDER BY `name` ASC
1.9 232 Yes /classes/Country.php:154
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` = 1207
AND image_shop.`cover` = 1 LIMIT 1
1.9 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.9 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE *
FROM `pod_category` a
LEFT JOIN `pod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 39) LIMIT 1
1.9 1 /src/Adapter/EntityMapper.php:75
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` = 1134 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` = 1134 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.9 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1097 AND id_shop=2 LIMIT 1
1.9 1 /classes/Product.php:5871
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.9 1 /classes/ObjectModel.php:559
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` = 1225) AND (b.`id_shop` = 2) LIMIT 1
1.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pod_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 2 
AND cl.`id_category` = 39 LIMIT 1
1.9 1 /classes/Category.php:1369
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.9 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pod_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 2 
AND cl.`id_category` = 74 LIMIT 1
1.8 1 /classes/Category.php:1369
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 = 1134
ORDER BY f.position ASC
1.8 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM pod_shop s
LEFT JOIN pod_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 2
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
1.8 1 /classes/shop/Shop.php:201
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1193 AND `id_group` = 1 LIMIT 1
1.8 0 /classes/GroupReduction.php:156
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` = 1134)
1.8 1 /classes/Product.php:3401
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 (283) 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.8 1 Yes /classes/Product.php:3993
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` = 1098
1.8 1 /classes/Product.php:6462
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1134) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.8 1 /classes/stock/StockAvailable.php:441
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` = 1269) AND (b.`id_shop` = 2) LIMIT 1
1.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` = 1097) AND (b.`id_shop` = 2) LIMIT 1
1.8 1 /src/Adapter/EntityMapper.php:75
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` = 1314 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` = 1314 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.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` = 1098
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1.8 1 Yes Yes /classes/Product.php:2434
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` = 1011 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.8 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` = 283
ORDER BY `position`
1.8 3 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE `id_guest`
FROM `pod_connections`
WHERE `id_guest` = 1167060
AND `date_add` > '2021-05-18 16:22:00'
AND id_shop IN (2) 
ORDER BY `date_add` DESC LIMIT 1
1.8 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 = 1207
ORDER BY f.position ASC
1.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 = 283
ORDER BY f.position ASC
1.8 5 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 = 732
ORDER BY f.position ASC
1.8 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1134 AND `id_group` = 1 LIMIT 1
1.8 0 /classes/GroupReduction.php:156
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 = 1011
ORDER BY f.position ASC
1.8 4 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `pod_category` a0
LEFT JOIN `pod_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 28) AND (a0.`nright` > 29) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
1.8 132 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1269 LIMIT 1
1.8 4 /classes/SpecificPrice.php:419
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` = 989) AND (b.`id_shop` = 2) LIMIT 1
1.8 1 /src/Adapter/EntityMapper.php:75
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
1.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` = 1011) AND (b.`id_shop` = 2) LIMIT 1
1.8 1 /src/Adapter/EntityMapper.php:75
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` = 1178)
1.7 1 /classes/Product.php:3401
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` = 1267 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.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 39 LIMIT 1
1.7 1 /classes/Product.php:4937
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 = 987
ORDER BY f.position ASC
1.7 9 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` = 987 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` = 987 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.7 0 /classes/Cart.php:1404
(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_%")
1.7 1 /classes/CartRule.php:403
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` = 1269 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.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 39 LIMIT 1
1.7 1 /classes/Product.php:4937
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 = 1286
ORDER BY f.position ASC
1.7 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 732 AND `id_group` = 1 LIMIT 1
1.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` = 1178 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.7 5 Yes /classes/SpecificPrice.php:560
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` = 1269)
1.7 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1269 AND `id_group` = 1 LIMIT 1
1.7 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_lang` FROM `pod_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
1.7 5 /classes/Language.php:790
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` = 1098
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1.7 1 Yes Yes /classes/Product.php:2434
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
1.7 4 /classes/Currency.php:1099
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1314 AND `id_group` = 1 LIMIT 1
1.7 0 /classes/GroupReduction.php:156
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` = 987) AND (b.`id_shop` = 2) LIMIT 1
1.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` = 1193) AND (b.`id_shop` = 2) LIMIT 1
1.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 = 1101
ORDER BY f.position ASC
1.7 6 Yes /classes/Product.php:5195
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` = 1144
AND image_shop.`cover` = 1 LIMIT 1
1.7 2 /classes/Product.php:3118
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 = 1266
ORDER BY f.position ASC
1.7 7 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` = 1144
ORDER BY `position`
1.7 2 Yes /classes/Product.php:3096
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` = 1011
ORDER BY `position`
1.7 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` = 1314 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.7 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` = 1267 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` = 1267 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.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
1.7 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` = 1207 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` = 1207 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1286 AND id_shop=2 LIMIT 1
1.7 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1178 LIMIT 1
1.7 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 732 LIMIT 1
1.7 1 /classes/Pack.php:85
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` = 1286) AND (b.`id_shop` = 2) LIMIT 1
1.7 1 /src/Adapter/EntityMapper.php:75
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 = 1101
1.7 1 /classes/ProductAssembler.php:90
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` = 1193)
1.7 1 /classes/Product.php:3401
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` = 1249
AND image_shop.`cover` = 1 LIMIT 1
1.7 2 /classes/Product.php:3118
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 (1100) 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 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` = 1193 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.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1097) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.7 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_module` FROM `pod_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
1.6 0 /classes/module/Module.php:2820
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.6 364 /classes/Hook.php:487
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1097 AND `id_group` = 1 LIMIT 1
1.6 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1144
1.6 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` = 1411 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.6 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1225 AND `id_group` = 1 LIMIT 1
1.6 0 /classes/GroupReduction.php:156
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` = 714
ORDER BY `position`
1.6 2 Yes /classes/Product.php:3096
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` = 1011
AND image_shop.`cover` = 1 LIMIT 1
1.6 1 /classes/Product.php:3118
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 = 714
ORDER BY f.position ASC
1.6 7 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1098 LIMIT 1
1.6 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1134
1.6 1 /classes/Product.php:2510
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` = 732) AND (b.`id_shop` = 2) LIMIT 1
1.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 74 LIMIT 1
1.6 1 /classes/Product.php:4937
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 = 1269
ORDER BY f.position ASC
1.6 6 Yes /classes/Product.php:5195
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` = 1097
AND image_shop.`cover` = 1 LIMIT 1
1.6 2 /classes/Product.php:3118
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 = 1260
ORDER BY f.position ASC
1.6 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1400
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.6 0 /classes/SpecificPrice.php:249
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 = 1292
ORDER BY f.position ASC
1.6 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 732
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.6 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pod_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 2 
AND cl.`id_category` = 134 LIMIT 1
1.6 1 /classes/Category.php:1369
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
1.6 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` = 878) AND (b.`id_shop` = 2) LIMIT 1
1.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 22 LIMIT 1
1.6 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1144 LIMIT 1
1.6 1 /classes/Pack.php:85
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
1.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1011 LIMIT 1
1.6 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 989 AND `id_group` = 1 LIMIT 1
1.6 0 /classes/GroupReduction.php:156
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 6 Yes Yes /classes/Category.php:1144
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 = 1144
1.6 1 /classes/ProductAssembler.php:90
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 = 1097
ORDER BY f.position ASC
1.6 6 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` = 989 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` = 989 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1144 AND `id_group` = 1 LIMIT 1
1.6 0 /classes/GroupReduction.php:156
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` = 1354) AND (b.`id_shop` = 2) LIMIT 1
1.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 989
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.6 0 /classes/SpecificPrice.php:249
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 (1011) 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.6 1 Yes /classes/Product.php:3993
(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)
1.6 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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1286 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` = 1286 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.6 0 /classes/Cart.php:1404
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` = 2
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
1.6 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` = 803 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.6 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1134 LIMIT 1
1.6 1 /classes/Pack.php:85
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 = 267
ORDER BY f.position ASC
1.6 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 732 AND id_shop=2 LIMIT 1
1.6 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1286 LIMIT 1
1.5 4 /classes/SpecificPrice.php:419
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` = 1354)
1.5 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1314 AND id_shop=2 LIMIT 1
1.5 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1269 AND id_shop=2 LIMIT 1
1.5 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.5 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 0 LIMIT 1
1.5 1 /classes/SpecificPrice.php:410
SELECT SQL_NO_CACHE `id_page`
FROM `pod_page`
WHERE `id_page_type` = 13 AND `id_object` = 1098 LIMIT 1
1.5 1 /classes/Page.php:83
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` = 1144 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 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 989 LIMIT 1
1.5 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1207 LIMIT 1
1.5 4 /classes/SpecificPrice.php:419
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` = 1286)
1.5 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 39 LIMIT 1
1.5 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1266) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.5 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE *
FROM `pod_category_lang`
WHERE `id_category` = 39 AND `id_shop` = 2
1.5 4 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE ctg.`id_group`
FROM pod_category_group ctg
WHERE ctg.`id_category` = 39 AND ctg.`id_group` = 1 LIMIT 1
1.5 1 /classes/Category.php:1700
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pod_country`
WHERE `id_country` = 8 LIMIT 1
1.5 1 /classes/Country.php:401
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `pod_category` c
WHERE (c.`id_category` = 1) LIMIT 1
1.5 1 /classes/Category.php:1919
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.5 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 = 22 LIMIT 1
1.5 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 714
1.5 1 /classes/Product.php:2510
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` = 1098
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1.5 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.5 1 /classes/order/Order.php:1193
INSERT INTO `pod_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1167060', '281', '598725762', '', '2', '2', '2021-05-18 16:52:26')
1.5 1 /classes/ObjectModel.php:559
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` = 267 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 5 Yes /classes/SpecificPrice.php:560
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 (1295) 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.5 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 (1207) 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.5 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1097
1.5 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 22 LIMIT 1
1.5 1 /classes/Product.php:4937
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` = 1354 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 5 Yes /classes/SpecificPrice.php:560
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` = 1098) AND (b.`id_shop` = 2) LIMIT 1
1.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 732) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.5 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1134 LIMIT 1
1.5 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 989
1.5 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 878
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.5 0 /classes/SpecificPrice.php:249
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` = 1097 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` = 1097 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.5 0 /classes/Cart.php:1404
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` = 1178) AND (b.`id_shop` = 2) LIMIT 1
1.5 1 /src/Adapter/EntityMapper.php:75
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` = 3039 LIMIT 1
1.5 1 /classes/Combination.php:462
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` = 878
AND image_shop.`cover` = 1 LIMIT 1
1.5 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1193 LIMIT 1
1.5 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1400 LIMIT 1
1.5 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1134
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.5 0 /classes/SpecificPrice.php:249
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` = 803 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` = 803 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.5 0 /classes/Cart.php:1404
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` = 987 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 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1266 LIMIT 1
1.5 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1178 AND id_shop=2 LIMIT 1
1.5 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1269
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.5 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.4 1 /classes/order/Order.php:1193
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` = 1098
ORDER BY `position`
1.4 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` = 1011)
1.4 1 /classes/Product.php:3401
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` = 1193
AND image_shop.`cover` = 1 LIMIT 1
1.4 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1097 LIMIT 1
1.4 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1354 LIMIT 1
1.4 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1178) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 283
1.4 1 /classes/Product.php:2510
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 = 1266
1.4 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1097
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.4 0 /classes/SpecificPrice.php:249
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 (1097) 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 name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 39 LIMIT 1
1.4 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 989 AND id_shop=2 LIMIT 1
1.4 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1193) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE *
FROM `pod_shop_group` a
WHERE (a.`id_shop_group` = 2) LIMIT 1
1.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 283 AND `id_group` = 1 LIMIT 1
1.4 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1267) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1011
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.4 0 /classes/SpecificPrice.php:249
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` = 47) LIMIT 1
1.4 1 /src/Adapter/EntityMapper.php:75
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` = 989)
1.4 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1011 AND id_shop=2 LIMIT 1
1.4 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 1266
1.4 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1178 AND `id_group` = 1 LIMIT 1
1.4 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1225 LIMIT 1
1.4 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1097 LIMIT 1
1.4 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 989) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:441
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 (3029, 3030, 3039, 3040) AND il.`id_lang` = 2 ORDER by i.`position`
1.4 4 Yes /classes/Product.php:2529
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 (1411) 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 name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 39 LIMIT 1
1.4 1 /classes/Product.php:4937
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` = 1178 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` = 1178 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.4 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` = 1097
ORDER BY `position`
1.4 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` = 1144)
1.4 1 /classes/Product.php:3401
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` = 1178
AND image_shop.`cover` = 1 LIMIT 1
1.4 2 /classes/Product.php:3118
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` = 987
AND image_shop.`cover` = 1 LIMIT 1
1.4 5 /classes/Product.php:3118
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` = 1098) AND (b.`id_shop` = 2) LIMIT 1
1.4 1 /src/Adapter/EntityMapper.php:75
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` = 1098
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1.4 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1178
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.4 0 /classes/SpecificPrice.php:249
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` = 1098
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1.4 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE format
FROM `pod_address_format`
WHERE `id_country` = 8 LIMIT 1
1.4 1 /classes/AddressFormat.php:676
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` = 1178
ORDER BY `position`
1.4 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 (714) 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 `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1266 AND `id_group` = 1 LIMIT 1
1.4 0 /classes/GroupReduction.php:156
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` = 1100)
1.4 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 120 LIMIT 1
1.4 1 /classes/Product.php:4937
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` = 207 LIMIT 1
1.4 3 /classes/order/Order.php:847
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 = 1267
1.4 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` = 1144 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` = 1144 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.4 0 /classes/Cart.php:1404
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` = 267) AND (b.`id_shop` = 2) LIMIT 1
1.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 878 LIMIT 1
1.4 4 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 732 LIMIT 1
1.4 4 /classes/SpecificPrice.php:419
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` = 1266 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.4 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` = 714 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` = 714 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.4 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` = 1400)
1.4 1 /classes/Product.php:3401
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 = 1411
1.4 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 989 LIMIT 1
1.4 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 47 AND `id_shop` = 2
1.4 5 /src/Adapter/EntityMapper.php:82
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` = 878 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.4 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE id_group FROM pod_cart_rule_group WHERE id_cart_rule = 210
1.4 3 /classes/CartRule.php:414
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.4 100 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 39 LIMIT 1
1.4 1 /classes/Product.php:4937
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` = 267)
1.3 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1266 LIMIT 1
1.3 4 /classes/SpecificPrice.php:419
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 (1134) 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 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` = 732
AND image_shop.`cover` = 1 LIMIT 1
1.3 1 /classes/Product.php:3118
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` = 1101 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` = 1101 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.3 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE id_page_type
FROM pod_page_type
WHERE name = 'product' LIMIT 1
1.3 1 /classes/Page.php:104
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1207
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.3 0 /classes/SpecificPrice.php:249
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 (1144) 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 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pod_product_attribute`
WHERE `id_product` = 987
1.3 4 /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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 267 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` = 267 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.3 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 22 LIMIT 1
1.3 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1144) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.3 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `pod_specific_price` WHERE `id_product` != 0 LIMIT 1
1.3 1375 /classes/SpecificPrice.php:286
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1249 AND `id_group` = 1 LIMIT 1
1.3 0 /classes/GroupReduction.php:156
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` = 1225 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` = 1225 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.3 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 39 LIMIT 1
1.3 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1314 LIMIT 1
1.3 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `reduction`
FROM `pod_product_group_reduction_cache`
WHERE `id_product` = 1011 AND `id_group` = 1 LIMIT 1
1.3 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` = 1249 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.3 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pod_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 2 
AND cl.`id_category` = 120 LIMIT 1
1.3 1 /classes/Category.php:1369
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` = 987
ORDER BY `position`
1.3 5 Yes /classes/Product.php:3096
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` = 267
ORDER BY `position`
1.3 2 Yes /classes/Product.php:3096
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` = 1134
AND image_shop.`cover` = 1 LIMIT 1
1.3 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` = 1314)
1.3 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
1.3 1 /classes/order/Order.php:1193
(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_%")
1.3 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `pod_pack` where id_product_pack = 1098
1.3 1 /classes/Pack.php:160
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1314) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
1.3 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` = 1249 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` = 1249 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.3 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 (1144) 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 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.3 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
1.3 1 /classes/order/Order.php:1193
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` = 1267)
1.3 1 /classes/Product.php:3401
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` = 1100
AND image_shop.`cover` = 1 LIMIT 1
1.3 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE COUNT(*) FROM `pod_pack` WHERE id_product_pack = 1400 LIMIT 1
1.3 1 /classes/Pack.php:85
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` = 1266)
1.3 1 /classes/Product.php:3401
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` = 1100 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.3 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 2 AND id_category = 22 LIMIT 1
1.3 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1354 AND id_shop=2 LIMIT 1
1.3 1 /classes/Product.php:5871
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
1.3 1 Yes /classes/shop/Shop.php:703
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` = 1269 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` = 1269 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.3 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1193
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.3 0 /classes/SpecificPrice.php:249
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 = 1295
ORDER BY f.position ASC
1.3 7 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` = 283 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.3 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` = 3039
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 987 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` = 3039
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 987 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.3 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` = 1267
ORDER BY `position`
1.3 1 Yes /classes/Product.php:3096