• New
Large Multicolor Aum Hanging
  • Large Multicolor Aum Hanging

Large Multicolor Aum Hanging

TGMA

This large wall hanging is 2.20 meters high and 2.40 meters wide. It represents a yellow aum in the middle of a spiral colored in red, yellow and green.

€30.00
Quantity

Product Details
TGMA

Data sheet

Size
2,20 m * 2,40 m
Origin
India
Textile
Cotton
Weight
0,7 kg
You might also like

Reference: M-MCV

massage tool

Roll this clean design wooden massage accessory over your back, arms and legs. It is shaped like a car with four wheels that will gently relax your muscles.

Price €12.90
More
In stock

Reference: BAGA

Aum Ring

This women's ring represents the AUM symbol, it is silver metal. The Aum is the most sacred symbol of Hinduism, because it represents the primordial vibration from which the universe would have been created.

Price €15.00
More
In stock

Reference: BOTB

White Tibetan Box

This pretty little round box is decorated with inlays of white (howlite) and red (coral) stones and gold metal (brass). It is made in India, in the Daramsala region, by Tibetan refugees. Box diameter 2.5cm, box height 2.5cm.

Price €10.00
More
In stock

Reference: BOI

Indian Earrings

Beautiful Indian earrings, elongated shape. Nice color coppery and elegant details. About 5 cm high.

Price €15.90
More
In stock

Reference: M-BYa-A

YANG Finger Massager

The YANG massage ring is thighter than the YIN ring and is suitable for the morning to stimulate your fingers. It is particularly suitable for people with fine fingers, or people who are using regularly massage rings and who seek a stronger effect.

Price €3.00
More
In stock

Reference: M-BBM

1 Ring + 1 Bracelet Massage

Take care of yourself by massaging your fingers and hands regularly. Take care of those around you by giving them this useful and pleasant gift! Perfect for massaging and relaxing fingers, hands and wrists.

Price €10.00
More
In stock

Reference: S-BP

Thinker Buddha

This Buddha in red and gold resin is represented in the position of the thinker. Both hands are resting on the raised left knee, and the head is resting on the hands. The eyes are closed. This position invites relaxation. Height 19 cm, width 13 cm.

Price €49.00
More
In stock

Reference: BoQG

Qi Qong Balls

Take the two balls with one hand and rotate them, in one direction, then in the other. Repeat with the other hand. Regular use increases the dexterity and flexibility of the hands. Rotate the balls counterclockwise, this is the Yin direction. When you spin the balls in a clockwise direction, it is the Yang direction.

Price €18.00
More
In stock

Reference: S-BCR

Resin Chinese Buddha

This Chinese Buddha in green resin comes from Nepal. Far from presenting the image of an ascetic life, the big Buddha is not the historical Buddha, who was rather slender. This Buddha brings luck and is found in most Chinese homes as well as in many Asian temples and restaurants. It symbolizes the joy of living, abundance and wealth. Height 8 cm

Price €20.00
More
In stock

Reference: BRA-G

Seed Bracelet

This seed and wood beads bracelet is suitable for men and women. Nice natural colors and very solid elastic.

Price €10.00
More
In stock

Reference: BOL

Labradorite Earrings

This pretty pair of earrings is made of zinc alloy and labradorite. They will bring you spiritual elevation, harmony, balance and protection.

Price €15.00
More
In stock

Reference: BOOt

Tiger Eye Earrings

These pretty earrings are made of zinc alloy, with 3 tiger eye beads. The tiger eye is a protective stone with anti-stress properties.

Price €14.90
More
In stock

Reference: BRAP-Ja

Jasper Aum Bracelet

This bracelet is in 8 mm jasper beads, with a Aum pendant (blue, gold and red), and a multicolored pompon. Jasper brings serenity, unity, protection and it helps to remember his dreams. The symbol of Aum is one of the most sacred of Hinduism.

Price €25.00
More
In stock

Reference: COLTC

Colored Tibetan Necklace

This Tibetan-inspired necklace is made in India by Tibetan refugees. It is made of black rope and metal, with colored pearls imitation seeds and turquoise. The rectangle metal medallion measures 4.5 cm by 5.5 cm. Suitable for men and women.

Price €18.00
More
In stock

Reference: S-Ga

Colored Ganesh

This magnificent Ganesh stands approximately 15cm tall and weighs 1.6kg. It is gilt bronze, inlaid with imitation green, red and blue gemstones.

Price €189.00
More
In stock

Reference: BOBM2

Earrings Mango

Those nice and colorful earrings are made of mango wood in the north of Thaïland. There also are cotton thread and small beads. Hand made and fair trade.

Price €8.00
More
In stock

Reference: TPMMM

Multicolor Mandala Wall Hanging

This beautiful multi-colored Indian mandala tapestry measures 2.20m by 1.20m. The colors are orange, yellow, pink, blue, green, on a black background. It can be used as a bedspread for a single bed or it can be hung on the wall, vertically or horizontally.

Price €24.00
More
In stock

Reference: TPMA

Aum Wall Hanging

This beautiful aum cotton hanging measures 2.20m by 1.20m. We see in the center the symbol aum, the Hindu representations of the 7 chakras, and motifs of Celtic inspiration which give on the whole a very pretty mandala.

Price €22.00
More
In stock

Reference: TGMB

Multicolor Buddha Wall Hanging

This beautiful multicolored wall hanging represents the historical Buddha, Siddhartha Gautama. It measures 2.40 m high by 2.20 m wide. In fuchsia, blue, orange and green tones.

Price €30.00
More
In stock
16 other products in the same category:

Reference: TGMAV

Tree of Life Green Hanging

This large green, red and blue wall hanging measures 2.40 m high and 2.20 m wide. It represents a tree of life, flowers and peacocks, in a geometric decoration reminiscent of a porch. Light green, burgundy, navy blue and black colors.

Price €29.00
More
In stock

Reference: TGMBV

Green Buddha Wall Hanging

This large green meditation wall hanging measures 2.40m by 2.20m. It represents the Buddha in meditation in the center of a lotus flower. Sends vibrations of love represented by hearts.

Price €30.00
More
In stock

Reference: TPMMVe

Green Mandala Wall Hanging

This green, purple, blue and white mandala wall hanging measures 2.20 m by 1.20 m. The floral and geometric patterns produce a harmonizing effect in your home. In spiritual traditions, such as Hinduism and Buddhism, the mandala is used to attract and hold the attention of practitioners and adepts, as a support for meditation.

Price €22.00
More
In stock

Reference: TGMEB

Elephant Blue Large Hanging

This large turquoise blue hanging represents an elephant decorated in a Celtic style. It is approximately 2.20 m high and 2.10 m wide. Ideal for giving a feeling of softness, strength and wisdom to your living room or bedroom.

Price €29.00
More
In stock

Reference: TPMEB

Elephant Blue Wall Hanging

This wall hanging represents an elephant under the tree of knowledge, the design is sky blue on a black background. It is 2.20 m high and 1.20 m wide. The elephant is a symbol of strength, courage, longevity and fertility.

Price €22.00
More
In stock

Reference: TGMBO

Buddha Large Wall Hanging

This large orange Buddha wall hanging measures 2.40m by 2.20m. It is in thick cotton with fringes. It shows the historical Buddha, in the position of teaching, sitting under a banyan whose falling leaves represent the time that passes.

Price €29.00
More
In stock

Reference: TPMMB

Blue Mandala Wall Hanging

This very pretty Indian wall hanging represents a blue mandala. It measures 2.20 m by 1.20 m. It is made of cotton in India. The mandala is a geometric graphic that symbolically represents the cosmos, a model of organizational structure that shows the relationship between the infinitely small and the infinitely large.

Price €22.00
More
In stock

Reference: TGMB

Multicolor Buddha Wall Hanging

This beautiful multicolored wall hanging represents the historical Buddha, Siddhartha Gautama. It measures 2.40 m high by 2.20 m wide. In fuchsia, blue, orange and green tones.

Price €30.00
More
In stock

Reference: TPMA

Aum Wall Hanging

This beautiful aum cotton hanging measures 2.20m by 1.20m. We see in the center the symbol aum, the Hindu representations of the 7 chakras, and motifs of Celtic inspiration which give on the whole a very pretty mandala.

Price €22.00
More
In stock

Reference: TPMMR

Red Mandala Wall Hanging

This beautiful mandala wall hanging can be arranged vertically or horizontally. It measures 2.20 m by 1.20 m and represents a red, yellow and white mandala.

Price €22.00
More
In stock

Reference: TPMY

Yin Yang Wall Hanging

This white and black yin and yang wall hanging is made of thick cotton with fringes. It measures approximately 1.20 meters by 2.20 meters. You can hang it on the wall vertically or horizontally. This is also the perfect size to cover a single bed or an armchair.

Price €22.00
More
In stock

Reference: TGMBB

Large White Buddha Hanging

This large white Buddha wall hanging measures 2.40m high by 2.20m wide. It represents Buddha in the lotus position, under a banyan tree.

Price €29.00
More
In stock

Reference: TPMG

Ganesh Wall Hanging

This cotton Ganesh wall hanging measures 2.20m high by 1.20m wide. Its colors are white, black, blue and yellow. Ganesh, the elephant-headed Indian god, is the son of Shiva and Parvati. His home is the Himalayas.

Price €22.00
More
In stock

Reference: TPMMN

Mandala Wall Hanging

This pretty mandala wall hanging with black patterns on a white background measures 2.20 m by 1.20 m. The patterns represent elephants and flowers, in a pretty and very harmonious mandala. This hanging can be arranged vertically or horizontally. It can be hung on the wall, or used as a tablecloth, bed cover, or sofa cover.

Price €22.00
More
In stock

Reference: TGMMB

Mandala Large Hanging

This large "badméri" mandala hanging measures 2.40 meters by 2.20 meters. We see elephants and peacocks, as well as a decoration of leaves and flowers. This cotton hanging is in shades of purple, green, yellow, red and pink.

Price €29.00
More
In stock

Reference: TGMMV

Green Mandala Large Hanging

This large tapestry measures 2.20 meters by 2.40 meters. It shows flowers, elephants and camels decorated in dark green tones, dark blue, red, orange and cream.

Price €29.00
More
In stock
Load Time795 ms - Unicorn powered webserver!
Querying Time485 ms
Queries887
Memory Peak Usage18.1 Mb
Included Files916 files - 10.66 Mb
PrestaShop Cache- Mb
Global vars0.31 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 29 ms 29 ms 2.05 Mb 2.08 Mb
__construct 1 ms 30 ms 0.08 Mb 2.13 Mb
init 96 ms 126 ms 2.15 Mb 4.29 Mb
checkAccess 0 ms 126 ms - Mb 4.29 Mb
setMedia 9 ms 135 ms 0.34 Mb 4.87 Mb
postProcess 0 ms 135 ms - Mb 4.87 Mb
initHeader 0 ms 135 ms - Mb 4.87 Mb
initContent 323 ms 458 ms 4.50 Mb 9.13 Mb
initFooter 0 ms 458 ms - Mb 9.13 Mb
display 337 ms 795 ms 8.61 Mb 18.12 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 887 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, 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` = 5 AND cl.id_shop = 2 )
LEFT JOIN `pod_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 5 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` = 5)
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
4.8 42 Yes /classes/Category.php:1056
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2021-05-18 00:00:00",
INTERVAL 48 DAY
)
) > 0 AS new
FROM `pod_accessory`
LEFT JOIN `pod_product` p ON p.`id_product` = `id_product_2`
INNER JOIN pod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=2)
LEFT JOIN `pod_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 5 AND pl.id_shop = 2 
)
LEFT JOIN `pod_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 5 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` = 5)
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` = 1403 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
4.1 28 Yes Yes /classes/Product.php:4137
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `pod_configuration` c
LEFT JOIN `pod_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
3 1914 /classes/Configuration.php:160
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.8 0 /classes/Hook.php:1221
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` = 5)
LEFT JOIN `pod_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2.3 244 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pod_module` m
INNER JOIN pod_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 2 AND module_shop.enable_device & 1)
INNER JOIN `pod_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `pod_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pod_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pod_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 2) AND (mg.id_shop = 2 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.2 156 Yes Yes /classes/Hook.php:1161
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `pod_category` c
INNER JOIN `pod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 2 )
INNER JOIN `pod_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 2)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND c.`id_category` != 111
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 75
AND c.id_category IN (
SELECT id_category
FROM `pod_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
2.2 65 Yes /modules/ps_categorytree/ps_categorytree.php:149
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')
2.1 1 /classes/ObjectModel.php:559
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
1.8 4 Yes /classes/shop/Shop.php:1341
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1164) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.6 5 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
1.5 25 /classes/Language.php:1123
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.5 364 /classes/Hook.php:487
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` = 5  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
1.4 1 Yes Yes /classes/Category.php:918
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
LEFT JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pod_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN pod_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 2)
WHERE pa.`id_product` = 1403
AND al.`id_lang` = 5
AND agl.`id_lang` = 5
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.3 1 Yes Yes /classes/Product.php:4048
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `pod_meta` m
LEFT JOIN `pod_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 2 )
ORDER BY LENGTH(ml.url_rewrite) DESC
1.3 100 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1377
ORDER BY f.position ASC
1.3 8 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `pod_specific_price` WHERE `id_product` != 0
1.3 1374 /classes/SpecificPrice.php:294
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (27) 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 17 Yes /classes/Product.php:3993
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 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` = 1384 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` = 1384 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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.2 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1354) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1.2 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` = 1380 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.2 2 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1342
ORDER BY f.position ASC
1.1 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` = 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
1.1 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1144
1.1 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
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.1 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1232) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
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` = 1214) AND (b.`id_shop` = 2) LIMIT 1
1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 39 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1 42 /classes/Category.php:985
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1400) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
FROM pod_meta m
LEFT JOIN pod_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "my-account"
OR m.page = "myaccount"
)
AND ml.id_lang = 5
AND ml.id_shop = 2 LIMIT 1
1 2 /classes/Meta.php:189
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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1255
ORDER BY f.position ASC
1 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` = 1214
AND image_shop.`cover` = 1 LIMIT 1
1 2 /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` = 992) AND (b.`id_shop` = 2) LIMIT 1
1 1 /src/Adapter/EntityMapper.php:75
INSERT INTO `pod_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1167092', '411', '598725762', '', '2', '2', '2021-05-18 16:53:49')
1 1 /classes/ObjectModel.php:559
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1225) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
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` = 1348) AND (b.`id_shop` = 2) LIMIT 1
1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE psgdpr.active FROM `pod_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 17 LIMIT 1
1 3 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE 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` = 1342 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` = 1342 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 649
ORDER BY f.position ASC
1 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 951
ORDER BY f.position ASC
1 7 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1210) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
1 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE * FROM `pod_state` ORDER BY `name` ASC
0.9 232 Yes /classes/Country.php:154
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1400) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.9 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE `to` BETWEEN '2021-05-18 00:00:00' AND '2021-05-18 23:59:59' LIMIT 1
0.9 1 /classes/SpecificPrice.php:365
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1380) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.9 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM pod_link_block cb
WHERE `id_hook` = 35
ORDER by cb.`position`
0.9 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1053
ORDER BY f.position ASC
0.9 8 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` = 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
0.9 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1164
ORDER BY f.position ASC
0.9 10 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *, ( 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
0.9 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` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1377) AND (b.`id_shop` = 2) LIMIT 1
0.9 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 803
ORDER BY f.position ASC
0.9 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 47 AND `id_shop` = 2
0.9 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` = 27 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE psgdprl.message FROM `pod_psgdpr_consent` psgdpr
LEFT JOIN pod_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 17 AND psgdprl.id_lang =5 LIMIT 1
0.9 3 /modules/psgdpr/classes/GDPRConsent.php:111
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (769) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.9 7 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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
0.9 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1300
ORDER BY f.position ASC
0.9 8 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 27
ORDER BY f.position ASC
0.9 10 Yes /classes/Product.php:5195
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 = "5" 
AND prl.id_shop = "2"
AND pr.status = 1
ORDER BY pr.position
0.9 4 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:186
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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1400
0.9 1 /classes/ProductAssembler.php:90
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` = 1053 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1301
ORDER BY f.position ASC
0.9 8 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` = 1300 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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
0.9 0 /classes/Cart.php:1404
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` = 1354 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` = 1354 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.9 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 879
ORDER BY f.position ASC
0.9 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `id_guest`
FROM `pod_connections`
WHERE `id_guest` = 1167092
AND `date_add` > '2021-05-18 16:23:00'
AND id_shop IN (2) 
ORDER BY `date_add` DESC LIMIT 1
0.9 1 Yes /classes/Connection.php:163
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
0.9 5 Yes /classes/SpecificPrice.php:560
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` = 5
LEFT JOIN `pod_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 2
WHERE (a.`id_country` = 8) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( 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` = 1342 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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` = 1384)
0.8 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` = 1164 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 4 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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` = 5)
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` = 5)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3062
AND agl.`id_lang` = 5
0.8 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE `id_page`
FROM `pod_page`
WHERE `id_page_type` = 13 AND `id_object` = 1403 LIMIT 1
0.8 1 /classes/Page.php:83
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` = 1342)
0.8 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 953
ORDER BY f.position ASC
0.8 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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
0.8 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1249) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.8 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM pod_shop_group gs
LEFT JOIN pod_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pod_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.8 1 Yes /classes/shop/Shop.php:703
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` = 5)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
WHERE pa.`id_product` = 1403
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.8 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE 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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1214
0.8 1 /classes/ProductAssembler.php:90
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` = 5)
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` = 5)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3066
AND agl.`id_lang` = 5
0.8 1 /classes/Product.php:6435
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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1403
ORDER BY f.position ASC
0.8 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` = 5)
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` = 5)
WHERE pa.`id_product` = 27
AND pac.`id_product_attribute` = 210
AND agl.`id_lang` = 5
0.8 2 /classes/Product.php:6435
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` = 951 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` = 951 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (953) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.8 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE 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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 803
0.8 1 /classes/ProductAssembler.php:90
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` = 27 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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` = 5)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
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` = 1403
0.8 1 /classes/Product.php:6462
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 2
0.8 4 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE id_page_type
FROM pod_page_type
WHERE name = 'product' LIMIT 1
0.8 1 /classes/Page.php:104
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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1254
ORDER BY f.position ASC
0.8 7 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 992
ORDER BY f.position ASC
0.8 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` = 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
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 878
ORDER BY f.position ASC
0.8 7 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` = 1255 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` = 1255 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 769
ORDER BY f.position ASC
0.8 11 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` = 992 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1214 LIMIT 1
0.8 4 /classes/SpecificPrice.php:419
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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 879
0.8 1 /classes/ProductAssembler.php:90
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` = 1225 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1210 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1384) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.8 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM pod_tag t
LEFT JOIN pod_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=1403
0.8 1 /classes/Tag.php:229
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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1349
ORDER BY f.position ASC
0.8 7 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `pod_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `pod_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
WHERE pa.`id_product` = 1403
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.8 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE *
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` = 1300) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pod_hook`
0.8 647 /classes/Hook.php:1221
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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1354
0.8 1 /classes/ProductAssembler.php:90
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` = 5)
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` = 5)
WHERE pa.`id_product` = 27
AND pac.`id_product_attribute` = 1448
AND agl.`id_lang` = 5
0.8 2 /classes/Product.php:6435
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1342) AND (b.`id_shop` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 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
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 998
ORDER BY f.position ASC
0.8 7 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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
0.8 7 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (879) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.8 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *, ( 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` = 1349 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 998
0.8 1 /classes/ProductAssembler.php:90
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` = 5)
LEFT JOIN `pod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
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` = 1403
0.8 1 /classes/Product.php:6462
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` = 951 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1053) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.8 1 Yes /classes/Product.php:3993
(SELECT SQL_NO_CACHE * 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` = 5)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
0.8 1 /classes/CartRule.php:403
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` = 5)
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` = 5)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3063
AND agl.`id_lang` = 5
0.8 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pod_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1214 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *
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` = 1097) AND (b.`id_shop` = 2) LIMIT 1
0.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` = 1053 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` = 1053 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.8 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `pod_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` = 27) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 5)
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` = 5)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3064
AND agl.`id_lang` = 5
0.7 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
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;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 3065
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1164 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3065
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1164 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
INNER JOIN pod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 1210
ORDER BY f.position ASC
0.7 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` = 27 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` = 27 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `pod_product` p
INNER JOIN `pod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `pod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 1349)
0.7 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 5)
WHERE i.`id_product` = 1400
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE `name`, `alias` FROM `pod_hook_alias`
0.7 88 /classes/Hook.php:284
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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (878) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1348
ORDER BY f.position ASC
0.7 7 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1101) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *, ( 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` = 879 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
(SELECT SQL_NO_CACHE * 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` = 5)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
0.7 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1283
ORDER BY f.position ASC
0.7 4 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `name`
FROM `pod_hook`
WHERE `id_hook` = 14 LIMIT 1
0.7 1 /classes/Hook.php:222
SELECT SQL_NO_CACHE 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` = 5)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
WHERE pa.`id_product` = 1403
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.7 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 2783
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 769 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 2783
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 769 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1214) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE 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` = 1225)
0.7 1 /classes/Product.php:3401
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` = 5
AND c.`id_parent` = 1
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.7 6 Yes Yes /classes/Category.php:1144
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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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
0.7 6 Yes /classes/Product.php:5195
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` = 1403 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.7 2 Yes /classes/SpecificPrice.php:623
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 17 AND `id_shop` = 2
0.7 5 /src/Adapter/EntityMapper.php:82
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` = 1100) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1255) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (951) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1100
ORDER BY f.position ASC
0.7 6 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` = 5)
WHERE i.`id_product` = 649
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 951) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1255) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE 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
0.7 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` = 5
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
0.7 1 /src/Adapter/EntityMapper.php:75
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` = 1400
AND image_shop.`cover` = 1 LIMIT 1
0.7 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pod_stock_available`
WHERE (id_product = 1377) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE 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` = 953 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` = 953 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1214
ORDER BY f.position ASC
0.7 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` = 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
0.7 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` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1254) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1232) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1403) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
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` = 1403
AND image_shop.`cover` = 1 LIMIT 1
0.7 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE *
FROM `pod_angarbanners`
WHERE id_shop = 2 AND id_lang = 5
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.7 40 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1342 LIMIT 1
0.7 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` = 1348 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1384) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
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;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `pod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 5)
WHERE i.`id_product` = 1377
ORDER BY `position`
0.7 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `pod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 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
0.7 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` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1053) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
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` = 5)
ORDER BY a0.`nleft` asc
0.7 132 Yes /classes/PrestaShopCollection.php:381
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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1232
ORDER BY f.position ASC
0.7 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` = 649 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *, ( 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` = 714 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *, ( 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` = 1254 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *, ( 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` = 953 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1097
0.7 1 /classes/ProductAssembler.php:90
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 (204, 206, 207, 210, 214, 216, 217, 1448, 1449, 1451, 1452, 1453, 3254, 3263, 3264, 3265, 3306) AND il.`id_lang` = 5 ORDER by i.`position`
0.7 17 Yes /classes/Product.php:2529
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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 714
0.7 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1403
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 1 /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` = 878 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` = 878 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM pod_meta m
LEFT JOIN pod_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 5
AND ml.id_shop = 2 LIMIT 1
0.7 1 /classes/Meta.php:189
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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1384
0.7 1 /classes/ProductAssembler.php:90
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` = 5)
WHERE i.`id_product` = 1097
ORDER BY `position`
0.7 2 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1403 LIMIT 1
0.7 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `pod_specific_price_priority`
WHERE `id_product` = 1349
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.7 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 878
0.7 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1101
0.7 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1342) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *, ( 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` = 1301 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *, ( 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` = 1255 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 1097 LIMIT 1
0.7 4 /classes/SpecificPrice.php:419
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` = 5
LEFT JOIN `pod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 39) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1301) AND (b.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_shop` a
WHERE (a.`id_shop` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pod_feature_product pf
LEFT JOIN pod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1249
ORDER BY f.position ASC
0.7 5 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name FROM pod_category_lang WHERE id_shop = 2 AND id_lang = 5 AND id_category = 134 LIMIT 1
0.7 1 /classes/Product.php:4937
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` = 5)
LEFT JOIN `pod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
WHERE pa.`id_product` = 1403
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.7 1 Yes Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE id_tab, class_name FROM `pod_tab`
0.7 189 /classes/Tab.php:340
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `pod_currency` c
LEFT JOIN pod_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 2)
WHERE c.`active` = 1 LIMIT 1
0.7 4 /classes/Currency.php:1099
SELECT SQL_NO_CACHE 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1377) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE 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` = 1348
AND image_shop.`cover` = 1 LIMIT 1
0.7 1 /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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1301) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.7 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE 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)
0.7 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM pod_link_block cb
WHERE `id_hook` = 12
ORDER by cb.`position`
0.7 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
SELECT SQL_NO_CACHE 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` = 1301 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` = 1301 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE 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` = 992 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` = 992 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1400
ORDER BY f.position ASC
0.6 6 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.6 1 /classes/order/Order.php:1193
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` = 1384 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *, ( 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
0.6 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` = 1403) AND (b.`id_shop` = 2) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product` a
LEFT JOIN `pod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 1210) AND (b.`id_shop` = 2) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (803) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.6 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
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` = 1349) AND (b.`id_shop` = 2) LIMIT 1
0.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` = 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
0.6 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *
FROM `pod_angarbanners`
WHERE id_shop = 2 AND id_lang = 5
AND hook = 'header' AND active = 1
ORDER BY item_order ASC
0.6 40 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-18 00:00:00',
INTERVAL 48 DAY
)
) > 0) as new
FROM pod_product p
LEFT JOIN pod_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 1254
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE * FROM `pod_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.6 9 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE tr.*
FROM `pod_tax_rule` tr
JOIN `pod_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.6 0 /classes/tax/TaxRulesTaxManager.php:109
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
0.6 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (998) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.6 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE 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 = 5
LEFT JOIN pod_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 2
WHERE p.id_product = 992
0.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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1354
ORDER BY f.position ASC
0.6 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` = 1232 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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 = 5)
LEFT JOIN pod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN pod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 1384
ORDER BY f.position ASC
0.6 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` = 1283 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE *
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` = 1384) AND (b.`id_shop` = 2) LIMIT 1
0.6 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` = 1210 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pod_cart_product` cp JOIN `pod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1210 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `pod_attribute` a
LEFT JOIN `pod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 5)
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` = 5)
WHERE pa.`id_product` = 1164
AND pac.`id_product_attribute` = 3065
AND agl.`id_lang` = 5
0.6 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `pod_product_attribute` pa
INNER JOIN pod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2) LEFT JOIN pod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
JOIN `pod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (992) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.6 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.6 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pod_module` m
LEFT JOIN `pod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 2
0.6 91 /classes/module/Module.php:322
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` = 1403 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 2 Yes /classes/SpecificPrice.php:560
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` = 5)
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` = 5)
WHERE pa.`id_product` = 27
AND pac.`id_product_attribute` = 1451
AND agl.`id_lang` = 5
0.6 2 /classes/Product.php:6435
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` = 879 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` = 879 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE 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` = 1254 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` = 1254 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *, ( 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` = 998 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-18 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 5 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (649) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.6 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `pod_image` i
INNER JOIN pod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 951
AND image_shop.`cover` = 1 LIMIT 1
0.6 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` = 5)
JOIN `pod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1349) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
0.6 1 Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
FROM `pod_cms` a
LEFT JOIN `pod_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 2
WHERE (a.`id_cms` = 14) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pod_product_attribute` a
LEFT JOIN `pod_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 2
WHERE (a.`id_product_attribute` = 2783) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM `pod_specific_price` WHERE id_product = 951 LIMIT 1
0.6 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` = 5
LEFT JOIN `pod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 998) AND (b.`id_shop` = 2) LIMIT 1
0.6 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` = 1100 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` = 1100 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE image_shop.`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` = 5)
WHERE i.`id_product` = 1348
ORDER BY `position`
0.6 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE `id_order`
FROM `pod_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
0.6 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `pod_category_lang` cl
WHERE `id_lang` = 5
AND cl.id_shop = 2 
AND cl.`id_category` = 134 LIMIT 1
0.6 1 /classes/Category.php:1369
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
0.6 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE *
FROM `pod_cms_lang`
WHERE `id_cms` = 14 AND `id_shop` = 2
0.6 5 /src/Adapter/EntityMapper.php:82
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` = 769) AND (b.`id_shop` = 2) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `pod_product_shop`
WHERE `id_product` = 1342 AND id_shop=2 LIMIT 1
0.6 1 /classes/Product.php:5871
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` = 5)
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` = 5)
WHERE pa.`id_product` = 27
AND pac.`id_product_attribute` = 3263
AND agl.`id_lang` = 5
0.6 2 /classes/Product.php:6435