• 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é

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
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

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