• Casquette Rouge Le Glazik Coton Bio
  • Casquette Jaune Le Glazik Coton Bio
  • Casquette Brique Le Glazik Coton Bio
  • Casquette Kermes Le Glazik Coton Bio
  • Casquette Indigo Le Glazik Coton Bio
  • Casquette Navy Le Glazik Coton Bio
  • Casquette Crevette Le Glazik Coton Bio
Casquette Rouge Le Glazik Coton Bio

Casquette, l'authentique du marin breton

20,83 €
TTC Livraison en 3 - 4 jours

La casquette authentique du marin breton fabriquée par la marque Le Glazik depuis 1928.

En vraie toile de marin, la même que celle des vareuses, la casquette Le Glazik est aussi célèbre que la vareuse ou le caban. Renommée sur tout le territoire elle est aussi bien porté par les marins, que par les agriculteurs et bien entendu les plaisanciers, touristes et amoureux des produits authentiques.

Symbole des produits français et produit extrêmement résistant dans le temps, la casquette le glazik est faite pour durer : mode durable et responsable associée au coton bio.

Taille Casquette

Couleur du tissu

Quantité

Ajouter aux produits préférés Ajout à la Comparaison
Description

Description

L'authentique casquette du marin de la Maison Le Glazik depuis 1928.

La casquette du marin breton est devenue, comme l'authentique vareuse et le caban, des symboles des vêtements marins, et un des produits phares de la marque familiale.

Fabriquée dès le lancement des vêtements Le Glazik en 1928, la casquette en toile très résistante est devenue aujourd'hui un produit mode. Déclinée en de très nombreux coloris elle se porte par les marins (qui lui préfèrerons la couleur brique ou rouge ou assortie à la vareuse en fonction du port), les agriculteurs (qui eux penchent plus pour le brique ou la crevette), les plaisanciers, les touristes et les amoureux des beaux produits de qualités qui eux se permettent d'aller vers les couleurs plus originales.

Très agréable à porter la casquette est l'héritage de plus de 90 ans de savoir faire sur les vêtements marins. Tissu de stabilité dimensionnelle absolue au lavage par procédé SANFOR®: elle ne bougera jamais et vous suivra durant toutes vos aventures.

Fabriquée dans la toile authentique, autrefois utilisée pour faire les voiles des bateaux, elle permet aux vêtements d'avoir une longévité supérieure, et de traverser les années en prenant une légère patine qui personnalise un peu plus votre produit, tout en confirmant son authenticité.

Précurseur, la Maison Le Glazik a fait certifier sa toile utilisée depuis 1928 par un organisme "coton bio" il y a plus de 20 ans, quand l'intérêt pour les matières premières de qualité n'étaient pas encore à la mode. Coton garanti bio, les produits sont accompagné du tampon vert pour confirmer la certification.

La casquette fait partie de la mode durable par essence, mode éthique et responsable par nature.

Les tailles des casquettes correspondent au tour de tête en cm.

Composition

100% coton (tissu made in France).

Coton certifié bio par ECOCERT

Tissu de stabilité dimensionnelle absolue au lavage par procédé SANFOR®

Entretien

Chlore / Blanchiment à proscrire Chlore / Blanchiment à proscrire
Lavage en machine à 30° C maximum Lavage en machine à 30° C maximum
Séchage en machine à proscrire Séchage en machine à proscrire
Nettoyage à sec avec solvants usuels Nettoyage à sec avec solvants usuels
Repassage au fer très chaud (200 °C) Repassage au fer très chaud (200 °C)
TB/CO06
Authentique
Modèle fabriqué par Le Glazik depuis 1928
Coton Bio
Coton certifié bio par ECOCERT
Tissu
Authentique toile des marins

Vous aimerez aussi

Vareuse Authentique VAM, fabriquée depuis 1928 par Le Glazik Vam Vareuse Femme made in france Le Glazik

Vareuse Authentique VAM, fabriquée depuis 1928...

Prix 57,50 €
La vareuse authentique Made In France VAM de la Maison Le Glazik. La vareuse est au marin, ce que la voile est au bateau : in-dis-pen-sable. Le Glazik , fournisseur des marins pêcheurs professionnels et référence des amoureux de la mer, propose sa vareuse phare déclinée en de très nombreuses...
Ajouter au panier
Ajouter aux produits préférés Ajout à la Comparaison

1 autre produit dans la même catégorie :

Echarpe Le Glazik

Ecmaille, L'écharpe chic rayée

Prix 15,83 €
Le modèle Ecmaille d'écharpe de la collection Le Glazik. Echarpe colorées elle s'associent avec les cabans, kabig et duffle coat pour terminer en beauté le look parfait du marin.
Ajouter aux produits préférés Ajout à la Comparaison

Les clients qui ont acheté ce produit ont également acheté...

Pornichet Pantalon Homme Le Glazik Brique Poche arriere pantalon pornichet brique homme

Pornichet, L'Authentique Pantalon des marins...

Prix 65,83 €
Pornichet, L'authentique pantalon marin de la Maison Le Glazik. Modèle phare de la marque et préféré des clients homme, ce pantalon est un best seller . Ce modèle est dans la toile iconique de Le Glazik : Coton certifié Bio . Ce pantalon appartient par essence à la mode responsable : fait pour...
Ajouter au panier
Ajouter aux produits préférés Ajout à la Comparaison
Vareuse Authentique VAM, fabriquée depuis 1928 par Le Glazik Vam Vareuse Femme made in france Le Glazik

Vareuse Authentique VAM, fabriquée depuis 1928...

Prix 57,50 €
La vareuse authentique Made In France VAM de la Maison Le Glazik. La vareuse est au marin, ce que la voile est au bateau : in-dis-pen-sable. Le Glazik , fournisseur des marins pêcheurs professionnels et référence des amoureux de la mer, propose sa vareuse phare déclinée en de très nombreuses...
Ajouter au panier
Ajouter aux produits préférés Ajout à la Comparaison
Poche arrière Binic Bermuda coton bio Binic, Bermuda avec revers...

Binic, Bermuda avec revers en toile Bio

Prix 61,67 €
Le Bermuda Binic est un produit majeur dans la collection Homme de la Maison Le Glazik. En coton bio dans la véritable toile authentique Le Glazik, autrefois toile des marins pêcheur utilisé pour les voiles. Ce Bermuda est proposé dans de nombreuses couleurs, rouge, jaune, bleu,... pour...
Ajouter au panier
Ajouter aux produits préférés Ajout à la Comparaison
Load Time663 ms - Unicorn powered webserver!
Querying Time190 ms
Queries614
Memory Peak Usage22.4 Mb
Included Files1020 files - 10.26 Mb
PrestaShop Cache- Mb
Global vars0.77 Mb
PrestaShop Version1.7.6.5
PHP Version7.2.32 (OK)
MySQL Version10.0.38-MariaDB-0+deb8u1 (OK)
Memory Limit256M
Max Execution Time1000s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 97 ms 97 ms 4.80 Mb 4.80 Mb
__construct 0 ms 97 ms - Mb 4.80 Mb
init 79 ms 176 ms 2.64 Mb 7.66 Mb
checkAccess 0 ms 176 ms - Mb 7.66 Mb
setMedia 4 ms 180 ms 0.22 Mb 7.73 Mb
postProcess 0 ms 180 ms - Mb 7.73 Mb
initHeader 0 ms 180 ms - Mb 7.73 Mb
initContent 192 ms 372 ms 5.28 Mb 12.95 Mb
initFooter 0 ms 372 ms - Mb 12.95 Mb
display 292 ms 663 ms 9.11 Mb 22.45 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 614 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `lg_prod_configuration` c
LEFT JOIN `lg_prod_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 4.6 1379 /classes/Configuration.php:160 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `lg_prod_module` m
INNER JOIN lg_prod_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `lg_prod_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `lg_prod_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `lg_prod_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `lg_prod_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 3.9 198 Yes Yes /classes/Hook.php:670 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `lg_prod_product_attribute_image` pai
LEFT JOIN `lg_prod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `lg_prod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 3338, 3339, 3340, 3341, 3342, 3343, 3344, 3345, 3346, 3347, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3358, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 3366, 3367) AND il.`id_lang` = 1 ORDER by i.`position`
 3.4 659 Yes /classes/Product.php:2492 
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(
"2020-09-22 00:00:00",
INTERVAL 0 DAY
)
) > 0 AS new
FROM `lg_prod_accessory`
LEFT JOIN `lg_prod_product` p ON p.`id_product` = `id_product_2`
INNER JOIN lg_prod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `lg_prod_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `lg_prod_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `lg_prod_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `lg_prod_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `lg_prod_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `lg_prod_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN lg_prod_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 104 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 2.8 15 Yes Yes /classes/Product.php:4031 
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 `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN lg_prod_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `lg_prod_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `lg_prod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `lg_prod_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `lg_prod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `lg_prod_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN lg_prod_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 104
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 2.7 49 Yes Yes /classes/Product.php:3942 
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 `lg_prod_hook_module` hm
STRAIGHT_JOIN `lg_prod_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `lg_prod_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 2.5 531 /classes/Hook.php:407 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `lg_prod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `lg_prod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `lg_prod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `lg_prod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (57) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.2 180 Yes Yes /classes/Product.php:3887 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN lg_prod_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 104
 2.1 49 /classes/Product.php:6285 
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `lg_prod_country` c  INNER JOIN lg_prod_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `lg_prod_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `lg_prod_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
 2.1 244 Yes /classes/Country.php:147 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `lg_prod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `lg_prod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `lg_prod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `lg_prod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (57) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2.1 180 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 1.9 56 Yes /classes/Category.php:783 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN lg_prod_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 104
 1.7 49 /classes/Product.php:6285 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `lg_prod_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `lg_prod_hook_alias` ha
INNER JOIN `lg_prod_hook` h ON ha.name = h.name
 1.5 0 /classes/Hook.php:194 
SELECT SQL_NO_CACHE * FROM `lg_prod_state` ORDER BY `name` ASC
 1.1 324 Yes /classes/Country.php:154 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 77 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 1.1 21 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `lg_prod_category` c
INNER JOIN `lg_prod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `lg_prod_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 2
AND nleft >= 2 AND nright <= 111
AND c.id_category IN (
SELECT id_category
FROM `lg_prod_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
 1 8 Yes /modules/ps_categorytree/ps_categorytree.php:117 
SELECT SQL_NO_CACHE `id_product`
FROM lg_prod_product_lang
WHERE `link_rewrite` = "casquette-authentique-marin-breton-coton-bio"
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
 1 117 /override/classes/Dispatcher.php:1292 
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 `lg_prod_product` p
INNER JOIN `lg_prod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `lg_prod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 57)
 1 179 /classes/Product.php:3364 
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 `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `lg_prod_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 75
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.9 1 Yes Yes /classes/Category.php:909 
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `lg_prod_country` c  INNER JOIN lg_prod_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `lg_prod_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `lg_prod_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
 0.9 244 Yes /classes/Country.php:147 
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `lg_prod_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `lg_prod_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `lg_prod_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `lg_prod_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayProductExtraContent') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (1) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
 0.9 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:494 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `lg_prod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `lg_prod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `lg_prod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `lg_prod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (67) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.8 30 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM lg_prod_shop_url su
LEFT JOIN lg_prod_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.leglazik.fr' OR su.domain_ssl = 'www.leglazik.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.8 1 Yes /classes/shop/Shop.php:345 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 71 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.8 19 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `lg_prod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `lg_prod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `lg_prod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `lg_prod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.8 18 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 97 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.8 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `lg_prod_meta` m
LEFT JOIN `lg_prod_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.8 59 Yes /override/classes/Dispatcher.php:212 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product` a
LEFT JOIN `lg_prod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 104) AND (b.`id_shop` = 1) LIMIT 1
 0.8 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 80 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.8 26 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `lg_prod_product_attribute_image` pai
LEFT JOIN `lg_prod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `lg_prod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1521) AND il.`id_lang` = 1 ORDER by i.`position`
 0.7 83 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE * FROM `lg_prod_state` ORDER BY `name` ASC
 0.7 324 Yes /classes/Country.php:154 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 88 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 86 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 23 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `lg_prod_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-22 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.7 1 Yes /classes/SpecificPrice.php:620 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM lg_prod_feature_product pf
LEFT JOIN lg_prod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN lg_prod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN lg_prod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN lg_prod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42
ORDER BY f.position ASC
 0.7 3 Yes /classes/Product.php:5020 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 105 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `lg_prod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `lg_prod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `lg_prod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `lg_prod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (67) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.7 30 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 78 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 25 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 72 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 23 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 81 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 26 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 95 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 93 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 16 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 92 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 19 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 96 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 94 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.7 15 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 87 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 22 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 101 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 90 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 21 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 74 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 22 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 104 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 89 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 20 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 75 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 25 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 91 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 17 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 79 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 20 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 106 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 4 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 76 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 24 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE tr.*
FROM `lg_prod_tax_rule` tr
JOIN `lg_prod_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` = 15
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 1 Yes /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 100 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 18 Yes /classes/Category.php:783 
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 lg_prod_shop_group gs
LEFT JOIN lg_prod_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN lg_prod_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.6 1 Yes /classes/shop/Shop.php:705 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 102 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 14 Yes /classes/Category.php:783 
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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_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` = 42 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:1238 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 103 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 14 Yes /classes/Category.php:783 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lg_prod_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `lg_prod_category` c2 ON c2.`id_category` = 108 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.6 3 Yes /classes/Category.php:783 
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 `lg_prod_product` p
INNER JOIN `lg_prod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `lg_prod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 104)
 0.6 49 /classes/Product.php:3364 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `lg_prod_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `lg_prod_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `lg_prod_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `lg_prod_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.5 18 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `lg_prod_meta` m
LEFT JOIN `lg_prod_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.5 59 Yes /override/classes/Dispatcher.php:212 
SELECT SQL_NO_CACHE pac.`id_product_attribute`
FROM `lg_prod_product_attribute_combination` pac
INNER JOIN `lg_prod_product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute
WHERE id_product = 104 AND id_attribute IN (76)
GROUP BY id_product_attribute
HAVING COUNT(id_product) = 1
 0.5 7 /controllers/front/ProductController.php:666 
SELECT SQL_NO_CACHE DISTINCT h.id_hook as id, h.name as name
FROM lg_prod_hook h
LEFT JOIN lg_prod_hook_module hm
ON(h.id_hook = hm.`id_hook`)
INNER JOIN lg_prod_module m
ON(hm.`id_module` = m.`id_module`)
WHERE (lower(h.`name`) LIKE 'display%')
AND m.`name` = 'jxmegamenu'
ORDER BY h.name ASC
 0.5 25 Yes /modules/jxmegamenu/src/JXMegaMenuRepository.php:205 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `lg_prod_image` i
INNER JOIN lg_prod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `lg_prod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 57
ORDER BY `position`
 0.5 20 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE `id_guest`
FROM `lg_prod_connections`
WHERE `id_guest` = 84144
AND `date_add` > '2020-09-22 08:02:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.5 1 Yes /classes/Connection.php:163 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `lg_prod_product_attribute_image` pai
LEFT JOIN `lg_prod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `lg_prod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2852, 2853, 2854, 2855, 2856, 2857, 2858, 2859, 2860, 2861, 2862, 2863, 2864, 2865) AND il.`id_lang` = 1 ORDER by i.`position`
 0.5 49 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.5 101 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE id_product
FROM lg_prod_product_lang
WHERE link_rewrite = 'casquette-authentique-marin-breton-coton-bio' AND id_lang = 1 AND id_shop = 1 LIMIT 1
 0.5 117 /override/controllers/front/ProductController.php:48 
SELECT SQL_NO_CACHE id_category FROM lg_prod_category_lang
WHERE link_rewrite = "casquette-authentique-marin-breton-coton-bio" AND id_lang = 1 AND id_shop = 1 LIMIT 1
 0.5 133 /override/classes/Dispatcher.php:1240 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `lg_prod_product_attribute_image` pai
LEFT JOIN `lg_prod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `lg_prod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2852, 2853, 2854, 2855, 2856, 2857, 2858, 2859, 2860, 2861, 2862, 2863, 2864, 2865) AND il.`id_lang` = 1 ORDER by i.`position`
 0.5 49 Yes /classes/Product.php:2492 
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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 104 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_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` = 104 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.5 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.5 101 /classes/module/Module.php:307 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 809
AND agl.`id_lang` = 1
 0.5 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.5 101 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM lg_prod_product_attribute pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 104 LIMIT 1
 0.5 49 /classes/Product.php:847 
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `lg_prod_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `lg_prod_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `lg_prod_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `lg_prod_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayAfterProductThumbs') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (1) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
 0.5 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:494 
UPDATE lg_prod_ets_crosssell_product_viewed SET viewed=viewed+1 WHERE id_product=104
 0.5 1 /modules/ets_crosssell/ets_crosssell.php:1192 
SELECT SQL_NO_CACHE tl.`id_unique`, tl.`id_item`
FROM lg_prod_jxmegalayout_items tl
JOIN lg_prod_jxmegalayout t
ON(t.`id_layout`=tl.`id_layout`)
LEFT JOIN lg_prod_jxmegalayout_pages tp
ON(t.`id_layout`=tp.`id_layout`)
WHERE t.`id_shop` = 1
AND (t.`status` = 1 OR tp.`status` = 1)
 0.5 450 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:120 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 80) AND (b.`id_shop` = 1) LIMIT 1
 0.5 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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 67 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_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` = 67 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.5 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `lg_prod_image` i
INNER JOIN lg_prod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `lg_prod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 42
ORDER BY `position`
 0.5 5 Yes /classes/Product.php:3059 
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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 57 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_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` = 57 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.5 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.5 101 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `lg_prod_image` i
INNER JOIN lg_prod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `lg_prod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 67
ORDER BY `position`
 0.4 11 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM lg_prod_feature_product pf
LEFT JOIN lg_prod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN lg_prod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN lg_prod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN lg_prod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 57
ORDER BY f.position ASC
 0.4 5 Yes /classes/Product.php:5020 
SELECT SQL_NO_CACHE id_meta 
FROM lg_prod_meta_lang
WHERE url_rewrite = "accessoires-homme"
AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
 0.4 50 /override/classes/Dispatcher.php:1276 
INSERT INTO `lg_prod_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
 0.4 1 /classes/ObjectModel.php:559 
SELECT SQL_NO_CACHE `id_product`
FROM lg_prod_product_lang
WHERE `link_rewrite` = "casquette-authentique-marin-breton-coton-bio"
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
 0.4 117 /override/classes/Link.php:610 
SELECT SQL_NO_CACHE `id_product`
FROM lg_prod_product_lang
WHERE `link_rewrite` = "casquette-authentique-marin-breton-coton-bio"
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
 0.4 117 /override/classes/Link.php:610 
SELECT SQL_NO_CACHE *
FROM `lg_prod_cms` a
LEFT JOIN `lg_prod_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 989
AND agl.`id_lang` = 1
 0.4 2 /classes/Product.php:6258 
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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 1492
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 67 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1492
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 67 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.4 101 /classes/module/Module.php:307 
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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 809
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 57 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 809
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 57 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product` a
LEFT JOIN `lg_prod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `lg_prod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 104) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.4 101 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN lg_prod_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.4 5 Yes Yes /classes/Category.php:1135 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `lg_prod_product_attribute_image` pai
LEFT JOIN `lg_prod_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `lg_prod_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (398, 399, 400, 401, 402, 403, 404, 405, 406, 2722, 2723, 2724, 2725, 2726, 2727, 2728, 2729, 2730) AND il.`id_lang` = 1 ORDER by i.`position`
 0.4 18 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `lg_prod_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `lg_prod_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `lg_prod_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `lg_prod_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayProductAdditionalInfo') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (1) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
 0.4 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:494 
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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 2221
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 104 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 2221
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 104 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.4 101 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE * FROM `lg_prod_currency` c ORDER BY `iso_code` ASC
 0.4 1 Yes /classes/Currency.php:507 
SELECT SQL_NO_CACHE jx.*, jxl.`title`, jxl.`badge`, jxl.`url`
FROM `lg_prod_jxmegamenu` jx
LEFT JOIN `lg_prod_jxmegamenu_lang` jxl
ON (jx.`id_item` = jxl.`id_item`)
WHERE jx.`id_shop` = 1
AND jx.`hook_name` = "displayTop"
AND jxl.`id_lang` = 1
AND jx.`active` = 1
ORDER BY jx.`sort_order`
 0.4 5 Yes /modules/jxmegamenu/src/MegaMenu.php:159 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `lg_prod_image` i
INNER JOIN lg_prod_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `lg_prod_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 104
ORDER BY `position`
 0.4 7 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM lg_prod_feature_product pf
LEFT JOIN lg_prod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN lg_prod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN lg_prod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN lg_prod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 67
ORDER BY f.position ASC
 0.4 3 Yes /classes/Product.php:5020 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 914
AND agl.`id_lang` = 1
 0.4 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product` a
LEFT JOIN `lg_prod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 67) AND (b.`id_shop` = 1) LIMIT 1
 0.4 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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 42
AND pac.`id_product_attribute` = 398
AND agl.`id_lang` = 1
 0.4 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 75) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `lg_prod_lang` l
JOIN lg_prod_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.4 4 /classes/Language.php:1058 
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 `lg_prod_cart_product` cp
WHERE cp.`id_product_attribute` = 398
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `lg_prod_cart_product` cp JOIN `lg_prod_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lg_prod_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 398
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.4 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM lg_prod_feature_product pf
LEFT JOIN lg_prod_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN lg_prod_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN lg_prod_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN lg_prod_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 104
ORDER BY f.position ASC
 0.4 3 Yes /classes/Product.php:5020 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 67
 0.4 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE p.id_product
FROM `lg_prod_product` p
INNER JOIN lg_prod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 104
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-09-22 00:00:00",
INTERVAL 0 DAY
)
) > 0
 0.4 0 /classes/Product.php:1403 
SELECT SQL_NO_CACHE c.*, cl.*
FROM lg_prod_jxblog_category c
LEFT JOIN lg_prod_jxblog_category_lang cl
ON(c.`id_jxblog_category` = cl.`id_jxblog_category`)
LEFT JOIN lg_prod_jxblog_category_shop cs
ON(c.`id_jxblog_category` = cs.`id_jxblog_category`)
LEFT JOIN lg_prod_jxblog_category_group cg
ON(c.`id_jxblog_category` = cg.`id_jxblog_category`)
WHERE c.id_jxblog_category = 2
AND cs.`id_shop` = 1
AND cg.`id_group` = 1
AND cl.`id_lang` = 1
 0.4 0 /modules/jxblog/classes/JXBlogCategory.php:353 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a0
LEFT JOIN `lg_prod_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 60) AND (a0.`nright` > 61) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 0.4 56 Yes /classes/PrestaShopCollection.php:381 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 3353
AND agl.`id_lang` = 1
 0.4 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE `id_page`
FROM `lg_prod_page`
WHERE `id_page_type` = 10 AND `id_object` = 104 LIMIT 1
 0.4 1 /classes/Page.php:83 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 67
AND pac.`id_product_attribute` = 1510
AND agl.`id_lang` = 1
 0.4 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product` a
LEFT JOIN `lg_prod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 104) LIMIT 1
 0.4 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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 974
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 854
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 104
AND pac.`id_product_attribute` = 2221
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 67
AND pac.`id_product_attribute` = 1492
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 42
AND pac.`id_product_attribute` = 2722
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE id_tab, class_name FROM `lg_prod_tab`
 0.3 188 /classes/Tab.php:320 
SELECT SQL_NO_CACHE `id_attribute` FROM `lg_prod_product_attribute_combination` pac2
WHERE `id_product_attribute` IN (0,2216,2221,2226,2231,2236,2241,2246)
AND id_attribute NOT IN (76)
 0.3 16 /controllers/front/ProductController.php:673 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 899
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 67
AND pac.`id_product_attribute` = 1498
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE `id_product`
FROM lg_prod_product_lang
WHERE `link_rewrite` = "casquette-authentique-marin-breton-coton-bio"
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
 0.3 117 /override/classes/Link.php:610 
SELECT SQL_NO_CACHE *
FROM `lg_prod_country` a
LEFT JOIN `lg_prod_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `lg_prod_product` p
INNER JOIN `lg_prod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `lg_prod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 67)
 0.3 30 /classes/Product.php:3364 
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 `lg_prod_product` p
INNER JOIN `lg_prod_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `lg_prod_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 42)
 0.3 18 /classes/Product.php:3364 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `lg_prod_category_product` cp
INNER JOIN `lg_prod_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 104 AND ctg.`id_group` = 1 LIMIT 1
 0.3 4 /classes/Product.php:5576 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product` a
LEFT JOIN `lg_prod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE tr.*
FROM `lg_prod_tax_rule` tr
JOIN `lg_prod_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.3 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product` a
LEFT JOIN `lg_prod_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 57) AND (b.`id_shop` = 1) LIMIT 1
 0.3 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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 67
AND pac.`id_product_attribute` = 1516
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE `id_product`
FROM lg_prod_product_lang
WHERE `link_rewrite` = "casquette-authentique-marin-breton-coton-bio"
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
 0.3 117 /override/classes/Link.php:610 
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `lg_prod_totcustomfields_input` tcf_i
INNER JOIN `lg_prod_totcustomfields_display_input` `tcf_di` ON tcf_di.id_input = tcf_i.id_input
INNER JOIN `lg_prod_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di.code_display = 'smarty') AND (  tcf_i_s.id_shop IN (1) )
GROUP BY tcf_i.id_input
 0.3 1 Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplaySmarty.php:268 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 959
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE jxl.`id_layout`
FROM lg_prod_jxmegalayout jxl
LEFT JOIN lg_prod_jxmegalayout_pages jxlp
ON(jxl.`id_layout` = jxlp.`id_layout`)
WHERE jxlp.`page_name` = "product"
AND jxl.`id_shop` = 1
AND jxl.`hook_name` = "displayHeader"
AND jxlp.`status` = 1 LIMIT 1
 0.3 1 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:347 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 839
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM lg_prod_jxmegalayout_items
WHERE `id_layout` = 4
 0.3 90 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96 
SELECT SQL_NO_CACHE p.`id_jxblog_post`, pl.`name`, pl.`link_rewrite`
FROM `lg_prod_jxblog_product_post` pp
LEFT JOIN `lg_prod_jxblog_post` p
ON(p.`id_jxblog_post` = pp.`id_jxblog_post`)
LEFT JOIN `lg_prod_jxblog_post_lang` pl
ON(p.`id_jxblog_post` = pl.`id_jxblog_post` AND pl.`id_lang` = 1)
WHERE pp.`id_product` = 104
 0.3 1 /modules/jxblogpostproducts/src/JXBlogPostProductsRepository.php:175 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 3338
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE `id_country`
FROM `lg_prod_country`
WHERE `iso_code` = 'US' LIMIT 1
 0.3 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE *
FROM lg_prod_jxmegalayout_items
WHERE `id_layout` = 2
 0.3 90 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 884
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE * FROM `lg_prod_hook_alias`
 0.3 83 /classes/Hook.php:238 
DELETE FROM `lg_prod_payplug_logger` WHERE `date_add` < "2020-08-22"
 0.3 1 /modules/payplug/classes/PayPlugLogger.php:137 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 67
AND pac.`id_product_attribute` = 1504
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE `id_product`
FROM lg_prod_product_lang
WHERE `link_rewrite` = "casquette-authentique-marin-breton-coton-bio"
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
 0.3 117 /override/classes/Link.php:610 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `lg_prod_specific_price` WHERE `id_product` != 0 LIMIT 1
 0.3 4 /classes/SpecificPrice.php:283 
SELECT SQL_NO_CACHE *
FROM `lg_prod_currency` a
LEFT JOIN `lg_prod_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE p.id_product
FROM lg_prod_product p
WHERE p.active = 1
 0.3 117 /modules/ps_viewedproduct/ps_viewedproduct.php:306 
SELECT SQL_NO_CACHE `id_product`
FROM lg_prod_product_lang
WHERE `link_rewrite` = "casquette-authentique-marin-breton-coton-bio"
AND `id_lang` = 1
AND `id_shop` = 1 LIMIT 1
 0.3 117 /override/classes/Link.php:610 
SELECT SQL_NO_CACHE jeh.*, jehl.*
FROM lg_prod_jxmegalayout_extra_html jeh
LEFT JOIN lg_prod_jxmegalayout_extra_html_lang jehl
ON(jeh.`id_extra_html` = jehl.`id_extra_html`)
WHERE jeh.`id_extra_html` = 1
AND jehl.`id_lang` = 1 LIMIT 1
 0.3 1 /modules/jxmegalayout/classes/extra/JXMegaLayoutExtraHtml.php:71 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `lg_prod_product_attribute`
WHERE `id_product` = 57
 0.3 180 /classes/Product.php:2473 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM lg_prod_tag t
LEFT JOIN lg_prod_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=104
 0.3 1 /classes/Tag.php:229 
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`
FROM `lg_prod_attribute` a
LEFT JOIN `lg_prod_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `lg_prod_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `lg_prod_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `lg_prod_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 57
AND pac.`id_product_attribute` = 824
AND agl.`id_lang` = 1
 0.3 2 /classes/Product.php:6258 
SELECT SQL_NO_CACHE id_required_field
FROM lg_prod_required_field
WHERE field_name = "optin"
AND object_name = 'Customer' LIMIT 1
 0.3 1 /classes/ObjectModel.php:1493 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
 0.3 1 /classes/Category.php:2167 
SELECT SQL_NO_CACHE *
FROM `lg_prod_group` a
LEFT JOIN `lg_prod_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_gender` a0
LEFT JOIN `lg_prod_gender_lang` `a1` ON (a0.`id_gender` = a1.`id_gender`)
WHERE (a1.`id_lang` = 1)
 0.3 2 /classes/PrestaShopCollection.php:381 
SELECT SQL_NO_CACHE jx.*, jxl.`title`, jxl.`badge`, jxl.`url`
FROM `lg_prod_jxmegamenu` jx
LEFT JOIN `lg_prod_jxmegamenu_lang` jxl
ON (jx.`id_item` = jxl.`id_item`)
WHERE jx.`id_shop` = 1
AND jx.`hook_name` = "displayTop"
AND jxl.`id_lang` = 1
AND jx.`active` = 1
ORDER BY jx.`sort_order`
 0.3 5 Yes /modules/jxmegamenu/src/MegaMenu.php:159 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 68) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM lg_prod_manufacturer m,lg_prod_manufacturer_shop ms WHERE m.id_manufacturer= ms.id_manufacturer AND ms.id_shop="1" AND m.active=1 LIMIT 1
 0.3 1 /modules/ets_crosssell/ets_crosssell.php:724 
SELECT SQL_NO_CACHE `id_module` FROM `lg_prod_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.3 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `lg_prod_lang` l
LEFT JOIN `lg_prod_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.3 2 /classes/Language.php:911 
SELECT SQL_NO_CACHE 1 FROM `lg_prod_specific_price` WHERE id_product = 0 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:407 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM lg_prod_product_attribute pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 42 LIMIT 1
 0.3 18 /classes/Product.php:847 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
 0.3 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE * FROM `lg_prod_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.3 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `lg_prod_specific_price_priority`
WHERE `id_product` = 104
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.3 1 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE `id_payplug_logger` FROM `lg_prod_payplug_logger` ORDER BY `id_payplug_logger` DESC LIMIT 499,1
 0.3 29 /modules/payplug/classes/PayPlugLogger.php:141 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 67) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 74) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM lg_prod_jxmegalayout_items
WHERE `id_layout` = 1
 0.3 90 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96 
SELECT SQL_NO_CACHE code_input_type
FROM `lg_prod_totcustomfields_input` tcf_input, `lg_prod_totcustomfields_input_shop` tcf_input_shop
WHERE (tcf_input.id_input = 5) AND (  tcf_input_shop.id_shop IN (1) )
GROUP BY tcf_input.id_input LIMIT 1
 0.3 1 Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Services/CustomFieldsInputService.php:95 
SELECT SQL_NO_CACHE *
FROM `lg_prod_totcustomfields_input_lang`
WHERE `id_input` = 5 AND `id_shop` = 1
 0.3 2 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 92) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM lg_prod_shop s
LEFT JOIN lg_prod_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.3 1 /classes/shop/Shop.php:201 
SELECT SQL_NO_CACHE `id_module` FROM `lg_prod_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.3 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM lg_prod_product_attribute pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 67 LIMIT 1
 0.3 30 /classes/Product.php:847 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 76) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `lg_prod_stock_available`
WHERE (id_product = 104) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.2 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE 1 FROM lg_prod_cart_product cp INNER JOIN lg_prod_product p
ON (p.id_product = cp.id_product) INNER JOIN lg_prod_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.2 1 /classes/Cart.php:4055 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 104
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 94) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product_attribute` a
LEFT JOIN `lg_prod_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 809) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product_lang`
WHERE `id_product` = 104 AND `id_shop` = 1
 0.2 2 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 80
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE `id_module` FROM `lg_prod_module` WHERE `name` = "jxblog" LIMIT 1
 0.2 1 /src/Adapter/Module/ModuleDataProvider.php:198 
SELECT SQL_NO_CACHE jxm.*, jxml.`title`, jxml.`description`
FROM `lg_prod_jxmegamenu_map` jxm
LEFT JOIN `lg_prod_jxmegamenu_map_lang` jxml
ON (jxm.`id_item` = jxml.`id_item`)
WHERE jxm.`id_shop` = 1
AND jxml.`id_lang` = 1
 0.2 1 /modules/jxmegamenu/src/MegaMenuMap.php:71 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM lg_prod_product_attribute pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 104 LIMIT 1
 0.2 49 /classes/Product.php:861 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 70) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
INSERT INTO `lg_prod_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('84144', '40', '583884034', '', '1', '1', '2020-09-22 08:32:44')
 0.2 1 /classes/ObjectModel.php:559 
SELECT SQL_NO_CACHE 1 FROM `lg_prod_specific_price` WHERE `from` BETWEEN '2020-09-22 00:00:00' AND '2020-09-22 23:59:59' LIMIT 1
 0.2 1 /classes/SpecificPrice.php:358 
SELECT SQL_NO_CACHE `settings`
FROM lg_prod_jxmegamenu_items
WHERE `id_tab` = 6
 0.2 21 /modules/jxmegamenu/src/MegaMenu.php:309 
SELECT SQL_NO_CACHE jeh.*, jehl.*
FROM lg_prod_jxmegalayout_extra_html jeh
LEFT JOIN lg_prod_jxmegalayout_extra_html_lang jehl
ON(jeh.`id_extra_html` = jehl.`id_extra_html`)
WHERE jeh.`id_extra_html` = 1
AND jehl.`id_lang` = 1 LIMIT 1
 0.2 1 /modules/jxmegalayout/classes/extra/JXMegaLayoutExtraHtml.php:71 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 67
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 87) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `lg_prod_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.2 3 /classes/module/Module.php:2221 
SELECT SQL_NO_CACHE id_input_value
FROM `lg_prod_totcustomfields_input_image_value`
WHERE (id_input = 5) AND (id_object = 104) AND (id_lang IS NULL) LIMIT 1
 0.2 1 /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Services/CustomFieldsInputImageService.php:53 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 86) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 104) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_country` a
LEFT JOIN `lg_prod_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 96) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 79) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 95) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.id_currency
FROM `lg_prod_currency` c
WHERE (deleted = 0) AND (iso_code = 'EUR') LIMIT 1
 0.2 1 /classes/Currency.php:677 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product_attribute` a
LEFT JOIN `lg_prod_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1492) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 78) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 42
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 101) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 100) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `reduction`
FROM `lg_prod_product_group_reduction_cache`
WHERE `id_product` = 104 AND `id_group` = 1 LIMIT 1
 0.2 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 77) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 77
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 104
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 93) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 89) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * 
FROM lg_prod_jxmegamenu_items
WHERE `id_tab` = 8
AND `row` = 1
AND `is_mega` = 1
ORDER BY `col`
 0.2 21 Yes /modules/jxmegamenu/src/MegaMenu.php:354 
SELECT SQL_NO_CACHE value FROM `lg_prod_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.2 1 /classes/shop/Shop.php:1164 
SELECT SQL_NO_CACHE jxw.`id_wishlist`, jxw.`name`, jxw.`token`
FROM `lg_prod_jxwishlist` jxw
WHERE `id_customer` = 0
AND `id_shop` = 1
ORDER BY jxw.`name` ASC
 0.2 9 Yes /modules/jxwishlist/classes/ClassJxWishlist.php:99 
SELECT SQL_NO_CACHE `id_layout`, `layout_name`, `hook_name`, `status`
FROM lg_prod_jxmegalayout
WHERE `id_shop` = 1
 0.2 5 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:130 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 102) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `lg_prod_category_product` cp
INNER JOIN `lg_prod_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 42 AND ctg.`id_group` = 1 LIMIT 1
 0.2 3 /classes/Product.php:5576 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `lg_prod_stock_available`
WHERE (id_product = 57) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.2 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE *
FROM `lg_prod_state` a
WHERE (a.`id_state` = 12) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 88) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 105) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 81) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 91) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 71
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE pa.`available_date` FROM `lg_prod_product` p LEFT JOIN `lg_prod_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN lg_prod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 57 AND pa.`id_product` = 57 AND pa.`id_product_attribute` = 809 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 72) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 42
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `lg_prod_specific_price` WHERE `id_product` != 0
 0.2 1 /classes/SpecificPrice.php:291 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 69) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 67
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE pa.`available_date` FROM `lg_prod_product` p LEFT JOIN `lg_prod_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN lg_prod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 104 AND pa.`id_product` = 104 AND pa.`id_product_attribute` = 2221 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE jxl.`id_layout`
FROM lg_prod_jxmegalayout jxl
LEFT JOIN lg_prod_jxmegalayout_pages jxlp
ON(jxl.`id_layout` = jxlp.`id_layout`)
WHERE jxlp.`page_name` = "product"
AND jxl.`id_shop` = 1
AND jxl.`hook_name` = "displayFooter"
AND jxlp.`status` = 1 LIMIT 1
 0.2 1 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:347 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 57
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 68
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE id_page_type
FROM lg_prod_page_type
WHERE name = 'product' LIMIT 1
 0.2 1 /classes/Page.php:104 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM lg_prod_product_attribute pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 57 LIMIT 1
 0.2 180 /classes/Product.php:847 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 71) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 103) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE *
FROM `lg_prod_country_lang`
WHERE `id_country` = 21
 0.2 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE *
FROM `lg_prod_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE p.id_product
FROM lg_prod_product p
WHERE p.active = 1
 0.2 117 /modules/ps_viewedproduct/ps_viewedproduct.php:306 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `lg_prod_currency` c
LEFT JOIN lg_prod_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 0.2 1 /classes/Currency.php:858 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 106) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `lg_prod_hook_alias`
 0.2 83 /classes/Hook.php:264 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 90) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 97) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 68
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 67
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE *
FROM `lg_prod_category` a
LEFT JOIN `lg_prod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `lg_prod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 108) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `lg_prod_product_attribute` a
LEFT JOIN `lg_prod_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 398) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 1 FROM `lg_prod_specific_price` WHERE `to` BETWEEN '2020-09-22 00:00:00' AND '2020-09-22 23:59:59' LIMIT 1
 0.2 1 /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE `id_country`
FROM `lg_prod_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.2 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 68
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE *
FROM `lg_prod_jxmegamenu_banner_lang`
WHERE `id_item` = 8
 0.2 2 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM lg_prod_product_attribute pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 57 LIMIT 1
 0.2 180 /classes/Product.php:861 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 67
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE pa.`available_date` FROM `lg_prod_product` p LEFT JOIN `lg_prod_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN lg_prod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 67 AND pa.`id_product` = 67 AND pa.`id_product_attribute` = 1492 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE * 
FROM lg_prod_jxmegamenu_items
WHERE `id_tab` = 6
AND `row` = 1
AND `is_mega` = 1
ORDER BY `col`
 0.2 21 Yes /modules/jxmegamenu/src/MegaMenu.php:354 
SELECT SQL_NO_CACHE pa.`available_date` FROM `lg_prod_product` p LEFT JOIN `lg_prod_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN lg_prod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 42 AND pa.`id_product` = 42 AND pa.`id_product_attribute` = 398 LIMIT 1
 0.2 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE *
FROM `lg_prod_group_lang`
WHERE `id_group` = 1
 0.2 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 67
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `lg_prod_module` m
LEFT JOIN `lg_prod_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "jxblog"
AND ms.`id_shop` IN (1) LIMIT 1
 0.2 1 /src/Adapter/Module/ModuleDataProvider.php:174 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 2
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `lg_prod_category` c
LEFT JOIN `lg_prod_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 )
WHERE c.`id_category` = 70
 0.2 1 /override/classes/Link.php:107 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `lg_prod_product_attribute` pa
INNER JOIN lg_prod_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 2221 LIMIT 1
 0.2 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE * FROM lg_prod_product WHERE id_product = 57
 0.2 1 /src/Adapter/Database.php:48 
SELECT SQL_NO_CACHE *
FROM `lg_prod_jxmegalayout_items` a
WHERE (a.`id_item` = 64) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `name`
FROM `lg_prod_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
 0.2 0 /classes/Manufacturer.php:312 
SELECT SQL_NO_CACHE * 
FROM lg_prod_jxmegamenu_items
WHERE `id_tab` = 7
AND `row` = 1
AND `is_mega` = 1
ORDER BY `col`
 0.2 21 Yes /modules/jxmegamenu/src/MegaMenu.php:354