totoLes meilleures enclumes à prix imbattables - Michel Vaillant

Enclume

Que vous soyez un passionné de forge occasionnel ou un professionnel chevronné, notre sélection d'enclumes est soigneusement conçue pour répondre à une gamme variée
de besoins. Pour les amateurs, nous proposons des enclumes légères et polyvalentes, idéales pour les projets de forge débutants. Pour les utilisateurs intermédiaires, nos enclumes en acier allié fournissent une résistance accrue et une surface de travail stable. Pour les professionnels, notre sélection comprend des enclumes en acier trempé de qualité supérieure, conçues pour résister à des charges de travail intenses, offrant durabilité et précision.

Les ENCLUMES Michel Vaillant

Pour les débutants, nos enclumes légères offrent une introduction aisée à la forge, favorisant un apprentissage progressif.
Les artisans intermédiaires bénéficieront de modèles en acier allié, alliant robustesse et polyvalence pour des projets variés.
Les professionnels trouveront dans notre sélection des enclumes haut de gamme en acier trempé, conçues pour résister à des exigences de travail intensives.
Quel que soit votre niveau, notre collection vise à accompagner chaque étape de votre parcours dans l'art de la forge.

Filtrer par

Prix

Prix

  • 115,00 € - 3 700,00 €

Marque

Marque

Offrir une carte cadeau

  
Affichage 1-12 de 14 article(s)

Filtres actifs

    Enclume PERUN SMART 100 kg

    Enclume PERUN SMART 100 kg

    Enclume de forge Permet de réaliser beaucoup d'opérations différentes. Très polyvalente.
    2 050,00 € 2 050,00 €

    Vous êtes débutant ?

    La forge suscite un engouement croissant auprès des passionnés du travail des métaux.

    La forge permet de travailler les métaux en les chauffant et en les martelant afin de leur donner forme.
    C’est un processus fascinant qui nécessite un certain savoir-faire et une connaissance approfondie des techniques de forge.

    Load Time 6127 ms
    Querying Time 5351 ms
    Queries 885
    Memory Peak Usage 56.2 Mb
    Included Files 1601 files - 22.00 Mb
    PrestaShop Cache - Mb
    Global vars 3.40 Mb
    PrestaShop Version 1.7.8.8
    PHP Version 7.4.33
    MySQL Version 10.11.6-MariaDB-0+deb12u1-log
    Memory Limit 2048M
    Max Execution Time 6000s
    Smarty Cache enabled
    Smarty Compilation auto
      Time Cumulated Time Memory Usage Memory Peak Usage
    config 19 ms 19 ms 7.56 Mb 10.2 Mb
    __construct 0 ms 19 ms - Mb 10.2 Mb
    init 11 ms 30 ms 1.62 Mb 10.2 Mb
    checkAccess 0 ms 30 ms - Mb 10.2 Mb
    setMedia 5 ms 35 ms 0.75 Mb 10.5 Mb
    postProcess 0 ms 35 ms - Mb 10.5 Mb
    initHeader 0 ms 35 ms - Mb 10.5 Mb
    initContent 5369 ms 5403 ms 12.56 Mb 22.6 Mb
    initFooter 0 ms 5403 ms - Mb 22.6 Mb
    display 723 ms 6127 ms 30.41 Mb 56.2 Mb
    Hook Time Memory Usage
    OverrideLayoutTemplate 361 ms 19.63 Mb
    displayNavFullWidth 52 ms 4.03 Mb
    DisplayCategoryBottom 47 ms 2.04 Mb
    DisplayBlock 44 ms 3.43 Mb
    DisplayCategoryTop 33 ms 1.47 Mb
    DisplayHeader 32 ms 3.02 Mb
    ActionOutputHTMLBefore 14 ms 0.14 Mb
    ModuleRoutes 10 ms 1.58 Mb
    DisplayProductPriceBlock 10 ms 1.91 Mb
    Header 4 ms 0.22 Mb
    displayLeftColumn 4 ms 0.43 Mb
    displayFlagProduct 4 ms 0.09 Mb
    DisplayFooter 4 ms 0.23 Mb
    DisplayBeforeBodyClosingTag 3 ms 0.15 Mb
    DisplayLeftColumn 1 ms 0.08 Mb
    ActionGetProductPropertiesAfter 1 ms 0.08 Mb
    ActionFrontControllerSetMedia 1 ms - Mb
    LeftColumn 1 ms 0.06 Mb
    ProductSearchProvider 1 ms 0.01 Mb
    DisplayCustomMenu 0 ms 0.01 Mb
    DisplayWrapperBottom 0 ms 0.02 Mb
    ActionObjectAddAfter 0 ms - Mb
    ActionObjectUpdateAfter 0 ms - Mb
    ActionFrontControllerInitAfter 0 ms - Mb
    DisplayContentWrapperTop 0 ms - Mb
    DisplayAfterBodyOpeningTag 0 ms - Mb
    ActionDispatcherBefore 0 ms - Mb
    ActionObjectAddBefore 0 ms - Mb
    ActionObjectUpdateBefore 0 ms - Mb
    DisplayOverrideTemplate 0 ms - Mb
    30 hook(s) 628 ms 38.58 Mb
    Module Time Memory Usage
    ybc_instagram 4 ms 0.34 Mb
    colissimo 1 ms 0.48 Mb
    hiupsell 3 ms 0.22 Mb
    ets_marketplace 9 ms - Mb
    ets_contactform7 12 ms 4.06 Mb
    dpdfrance 1 ms - Mb
    ets_awesomeurl 1 ms 0.17 Mb
    ets_extraoptions 1 ms 0.10 Mb
    creativeelements 450 ms 24.17 Mb
    blockwishlist 2 ms 0.11 Mb
    ps_emailsubscription 2 ms 0.13 Mb
    blockreassurance 0 ms 0.03 Mb
    allinone_rewards 9 ms 2.27 Mb
    mondialrelay 0 ms 0.13 Mb
    ps_emailalerts 0 ms 0.04 Mb
    ets_superspeed 16 ms 0.23 Mb
    productcomments 0 ms 0.03 Mb
    ps_imageslider 0 ms 0.03 Mb
    ps_searchbar 0 ms 0.02 Mb
    ps_shoppingcart 0 ms 0.03 Mb
    layerslider 3 ms 0.07 Mb
    ets_megamenu 101 ms 8.81 Mb
    ps_customersignin 0 ms 0.06 Mb
    tacartreminder 0 ms 0.10 Mb
    creativepopup 2 ms 0.07 Mb
    seq_smarty 0 ms 0.12 Mb
    upsshipping 1 ms 0.06 Mb
    whatsappchat 6 ms 0.36 Mb
    sizechart 0 ms 0.02 Mb
    giftcard 1 ms 0.49 Mb
    psxmarketingwithgoogle 1 ms 0.03 Mb
    paypal 4 ms 0.25 Mb
    payplug 16 ms 0.39 Mb
    estimateshippingcosts 0 ms 0.02 Mb
    pdfquotation 0 ms - Mb
    minpurchase 1 ms 0.15 Mb
    sendinblue 1 ms 0.03 Mb
    ps_facetedsearch 1 ms 0.05 Mb
    psgdpr 0 ms 0.04 Mb
    lgcookieslaw 1 ms 0.18 Mb
    seq_categoryfields 0 ms 0.02 Mb
    ps_categorytree 5 ms 0.45 Mb
    seq_caracs 4 ms 0.11 Mb
    43 module(s) 660 ms 42.23 Mb

    Stopwatch SQL - 885 queries

    Query Time (ms) Rows Filesort Group By Location
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute
    1180701 ms 1152 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute
    1000290 ms 72 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute
    993353 ms 96 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=5)) GROUP BY pac.id_attribute
    857295 ms 408 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=10)) GROUP BY pac.id_attribute
    855908 ms 240 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=16)) GROUP BY pac.id_attribute
    88781 ms 408 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=18)) GROUP BY pac.id_attribute
    87231 ms 72 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=35)) GROUP BY pac.id_attribute
    36586 ms 168 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=37)) GROUP BY pac.id_attribute
    34960 ms 168 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=36)) GROUP BY pac.id_attribute
    34850 ms 696 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=11)) GROUP BY fp.id_feature_value
    11431 ms 324 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=7)) GROUP BY pac.id_attribute
    8914 ms 360 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    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 `ps_configuration` c
    LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
    5791 ms 4099 /classes/Configuration.php:160
    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 `ps_configuration` c
    LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
    5329 ms 4099 /classes/Configuration.php:160
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=21)) GROUP BY pac.id_attribute
    5028 ms 648 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=17)) GROUP BY pac.id_attribute
    4372 ms 192 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=13)) GROUP BY fp.id_feature_value
    3594 ms 828 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=10)) GROUP BY fp.id_feature_value
    2937 ms 564 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
    FROM `ps_module` m
    INNER JOIN ps_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 `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
    INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
    INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
    LEFT JOIN `ps_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`
    1795 ms 240 Yes Yes /classes/Hook.php:1183
    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, m.active
    FROM `ps_hook_module` hm
    STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
    STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
    ORDER BY hm.position
    1721 ms 838 /classes/Hook.php:504
    SELECT SQL_NO_CACHE DISTINCT g.id_tax_rules_group, g.name, g.active, t.rate FROM `ps_tax_rules_group` g
    INNER JOIN ps_tax_rule tr
    ON g.id_tax_rules_group = tr.id_tax_rules_group
    INNER JOIN ps_tax t
    ON tr.id_tax = t.id_tax
    INNER JOIN ps_tax_rules_group_shop tax_rules_group_shop
    ON (tax_rules_group_shop.id_tax_rules_group = g.id_tax_rules_group AND tax_rules_group_shop.id_shop = 1) WHERE g.deleted = 0 AND g.`active` = 1 ORDER BY name ASC
    1166 ms 1890 Yes /classes/tax/TaxRulesGroup.php:196
    SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
    FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
    ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
    LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
    LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
    WHERE 1
    ORDER BY cl.name ASC
    1016 ms 241 Yes /classes/Country.php:147
    (SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
    LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
    WHERE (cr.`id_customer` = 0
    OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
    AND NOW() BETWEEN cr.date_from AND cr.date_to
    AND cr.`active` = 1
    AND free_shipping = 1 AND carrier_restriction = 1)
    934 ms 1 /classes/CartRule.php:444
    SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
    INNER JOIN `ps_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` <= 5
    AND nleft >= 2 AND nright <= 385
    AND c.id_category IN (
    SELECT id_category
    FROM `ps_category_group`
    WHERE `id_group` IN (1)
    )
    ORDER BY `level_depth` ASC, cs.`position` ASC
    899 ms 193 Yes /modules/creativeelements/includes/base/widget-category-base.php:146
    SELECT SQL_NO_CACHE `id_hook`, `name`
    FROM `ps_hook`
    UNION
    SELECT `id_hook`, ha.`alias` as name
    FROM `ps_hook_alias` ha
    INNER JOIN `ps_hook` h ON ha.name = h.name
    877 ms 0 /classes/Hook.php:1243
    SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 12
    722 ms 9980928 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p
    659 ms 3326976 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
    INNER JOIN `ps_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` <= 8
    AND nleft >= 281 AND nright <= 282
    AND c.id_category IN (
    SELECT id_category
    FROM `ps_category_group`
    WHERE `id_group` IN (1)
    )
    ORDER BY `level_depth` ASC, cs.`position` ASC
    607 ms 193 Yes /modules/ps_categorytree/ps_categorytree.php:166
    SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_manufacturer
    606 ms 3326976 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
    FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop
    ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
    600 ms 62 Yes /classes/Manufacturer.php:207
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC
    504 ms 48 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    DELETE FROM `ps_configuration_lang`
    WHERE `id_configuration` IN (
    SELECT `id_configuration`
    FROM `ps_configuration`
    WHERE `name` = "PS_ROUTE_etsmpshops"
    )
    499 ms 1 /classes/Configuration.php:570
    DELETE FROM `ps_configuration_lang`
    WHERE `id_configuration` IN (
    SELECT `id_configuration`
    FROM `ps_configuration`
    WHERE `name` = "PS_ROUTE_etsmpshopsseller"
    )
    471 ms 1 /classes/Configuration.php:570
    SELECT SQL_NO_CACHE p.*, product_shop.*, pl.* , m.`name` AS manufacturer_name, s.`name` AS supplier_name
    FROM `ps_product` p
    INNER JOIN ps_product_shop product_shop
    ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
    LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product`  AND pl.id_shop = 1 )
    LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
    LEFT JOIN `ps_supplier` s ON (s.`id_supplier` = p.`id_supplier`)LEFT JOIN `ps_category_product` c ON (c.`id_product` = p.`id_product`)
    WHERE pl.`id_lang` = 1 AND c.`id_category` = 39 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1
    ORDER BY p.`id_product` ASC
    466 ms 14 Yes /classes/Product.php:1595
    SELECT SQL_NO_CACHE lower(name) as name
    FROM `ps_hook` h
    WHERE (h.active = 1)
    466 ms 948 /classes/Hook.php:1283
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC
    460 ms 17 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 16 ORDER BY agl.`name` ASC, a.`position` ASC
    456 ms 17 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE a.id_ce_content as id FROM ps_ce_content a
    LEFT JOIN ps_ce_content_lang AS b ON a.id_ce_content = b.id_ce_content
    LEFT JOIN ps_ce_content_shop sa ON sa.id_ce_content = a.id_ce_content AND sa.id_shop = b.id_shop
    WHERE b.id_lang = 1 AND sa.id_shop = 1 AND a.hook LIKE 'displayCategoryTop' AND (a.id_category = 0 OR a.id_category = 39) AND a.active = 1 ORDER BY a.id_product DESC
    455 ms 229 Yes /modules/creativeelements/classes/CEContent.php:177
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 2334
    LIMIT 1
    438 ms 4 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
    438 ms 352 Yes /classes/Country.php:154
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 2718
    LIMIT 1
    432 ms 1 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=22 
    ORDER BY b.sort_order asc,bl.title asc
    428 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    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 `ps_category` c
    INNER JOIN ps_category_shop category_shop
    ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
    LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
    LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
    WHERE `id_parent` = 39
    AND `active` = 1
    AND cg.`id_group` =1
    GROUP BY c.`id_category`
    ORDER BY `level_depth` ASC, category_shop.`position` ASC
    413 ms 1 Yes Yes /classes/Category.php:919
    INSERT INTO `ps_ets_superspeed_cache_page` (`page`, `id_object`, `id_product_attribute`, `ip`, `file_cache`, `request_uri`, `id_shop`, `id_lang`, `id_currency`, `id_country`, `has_customer`, `has_cart`, `file_size`, `user_agent`, `date_add`) VALUES ('category', '39', '0', '3.237.15.145', 'b9e6ac83214080d016e454b8d07de06f', '/fr/39-enclume', '1', '1', '1', '21', '0', '0', '0', '', '2024-10-05 05:27:16')
    412 ms 1 /classes/ObjectModel.php:578
    SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=16)) GROUP BY fp.id_feature_value
    411 ms 12 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 21) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1'
    407 ms 912 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=281 AND c.nright<=282 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=17)) GROUP BY fp.id_feature_value
    405 ms 12 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 21 ORDER BY agl.`name` ASC, a.`position` ASC
    402 ms 27 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 36 ORDER BY agl.`name` ASC, a.`position` ASC
    395 ms 29 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE a.id_ce_content as id FROM ps_ce_content a
    LEFT JOIN ps_ce_content_lang AS b ON a.id_ce_content = b.id_ce_content
    LEFT JOIN ps_ce_content_shop sa ON sa.id_ce_content = a.id_ce_content AND sa.id_shop = b.id_shop
    WHERE b.id_lang = 1 AND sa.id_shop = 1 AND a.hook LIKE 'displayCategoryBottom' AND (a.id_category = 0 OR a.id_category = 39) AND a.active = 1 ORDER BY a.id_product DESC
    394 ms 229 Yes /modules/creativeelements/classes/CEContent.php:177
    SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
    FROM `ps_meta` m
    LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
    ORDER BY LENGTH(ml.url_rewrite) DESC
    390 ms 81 Yes /classes/Dispatcher.php:650
    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 `ps_category` c
    INNER JOIN ps_category_shop category_shop
    ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
    LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 0  AND cl.id_shop = 1 )
    LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
    WHERE `id_parent` = 32
    AND `active` = 1
    AND cg.`id_group` =1
    GROUP BY c.`id_category`
    ORDER BY `level_depth` ASC, category_shop.`position` ASC
    387 ms 5 Yes Yes /classes/Category.php:919
    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 `ps_category` c
    INNER JOIN ps_category_shop category_shop
    ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
    LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 0  AND cl.id_shop = 1 )
    LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
    WHERE `id_parent` = 32
    AND `active` = 1
    AND cg.`id_group` =1
    GROUP BY c.`id_category`
    ORDER BY `level_depth` ASC, category_shop.`position` ASC
    377 ms 5 Yes Yes /classes/Category.php:919
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 2185
    LIMIT 1
    376 ms 2 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps_attribute_group` ag  INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC
    375 ms 39 Yes Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:137
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 2312
    LIMIT 1
    372 ms 3 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 10 ORDER BY agl.`name` ASC, a.`position` ASC
    358 ms 10 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=23 
    ORDER BY b.sort_order asc,bl.title asc
    354 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=19 
    ORDER BY b.sort_order asc,bl.title asc
    353 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=10 
    ORDER BY b.sort_order asc,bl.title asc
    351 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 7 ORDER BY agl.`name` ASC, a.`position` ASC
    343 ms 15 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 1484
    LIMIT 1
    332 ms 4 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
    328 ms 948 /classes/Hook.php:1243
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 17 ORDER BY agl.`name` ASC, a.`position` ASC
    327 ms 8 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    (SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-10-05 00:00:00" AND date_to <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-10-05 00:00:00" AND date_from <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-10-05 00:00:00" AND date_to > "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
    316 ms 1 /classes/CartRule.php:383
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 35 ORDER BY agl.`name` ASC, a.`position` ASC
    310 ms 7 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 37 ORDER BY agl.`name` ASC, a.`position` ASC
    309 ms 7 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=8 
    ORDER BY b.sort_order asc,bl.title asc
    305 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=20 
    ORDER BY b.sort_order asc,bl.title asc
    303 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=1 
    ORDER BY b.sort_order asc,bl.title asc
    301 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=21 
    ORDER BY b.sort_order asc,bl.title asc
    299 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=25 
    ORDER BY b.sort_order asc,bl.title asc
    294 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=24 
    ORDER BY b.sort_order asc,bl.title asc
    293 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 2832
    LIMIT 1
    293 ms 3 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=9 
    ORDER BY b.sort_order asc,bl.title asc
    292 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    292 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=6 
    ORDER BY b.sort_order asc,bl.title asc
    292 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=7 
    ORDER BY b.sort_order asc,bl.title asc
    291 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
    FROM `ps_ets_mm_block` b
    LEFT JOIN `ps_ets_mm_block_lang` bl
    ON b.id_block=bl.id_block AND bl.id_lang=1
    WHERE 1  AND b.id_column=17 
    ORDER BY b.sort_order asc,bl.title asc
    290 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:617
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    290 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    289 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    289 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    287 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(247,56,58,183,60,184)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    286 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    286 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 18 ORDER BY agl.`name` ASC, a.`position` ASC
    281 ms 3 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(217,218,219,220)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    280 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC
    279 ms 3 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop
    ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN ps_attribute_shop attribute_shop
    ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC
    278 ms 4 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:96
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(39,40,41,42,43)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    277 ms 5 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(44,45,46,47,48,49,50)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    275 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE m.*,ml.title,ml.link,ml.bubble_text
    FROM `ps_ets_mm_menu` m
    INNER JOIN `ps_ets_mm_menu_shop` ms ON (m.id_menu =ms.id_menu AND ms.id_shop='1')            
    LEFT JOIN `ps_ets_mm_menu_lang` ml
    ON m.id_menu=ml.id_menu AND ml.id_lang=1
    WHERE 1  AND m.enabled=1 
    GROUP BY m.id_menu
    ORDER BY m.sort_order asc,ml.title asc
    268 ms 4 Yes Yes /modules/ets_megamenu/classes/MM_Menu.php:500
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 224
    LIMIT 1
    265 ms 6 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(7,28,177,178,185,29,211)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    260 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    (SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
    LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
    WHERE (cr.`id_customer` = 0
    OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
    AND NOW() BETWEEN cr.date_from AND cr.date_to
    AND cr.`active` = 1
    AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
    259 ms 1 /classes/CartRule.php:444
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 1493
    LIMIT 1
    257 ms 2 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    255 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    254 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    253 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    252 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    252 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 1490
    LIMIT 1
    252 ms 6 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(18,23,22,20,19,21)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    251 ms 6 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    251 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    250 ms 193 Yes /classes/PrestaShopCollection.php:381
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 1483 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 1483 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    247 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    246 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
    ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
    245 ms 36 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:171
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(12,13,264,266,212,15,182)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    245 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 224 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 224 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    245 ms 0 /classes/Cart.php:1429
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 1492 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 1492 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    244 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE tr.*
    FROM `ps_tax_rule` tr
    JOIN `ps_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` = 22
    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
    241 ms 1 /classes/tax/TaxRulesTaxManager.php:109
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    241 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    240 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 1492) AND (b.`id_shop` = 1) LIMIT 1
    240 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 1483) AND (b.`id_shop` = 1) LIMIT 1
    239 ms 1 /src/Adapter/EntityMapper.php:76
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 2832 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 2832 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    238 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 2544) AND (b.`id_shop` = 1) LIMIT 1
    237 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE id_cache_page FROM `ps_ets_superspeed_cache_page`
    WHERE page="category" 
    AND id_lang="1"
    AND id_country = "21"
    AND id_currency = "1"
    AND id_shop="1"
    AND date_add > "2024-10-05 05:12:16"AND id_object="39" AND has_customer=0 AND has_cart=0 LIMIT 1
    237 ms 1 /modules/ets_superspeed/classes/cache.php:278
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(51,52,53,55)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    237 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(226,227,228,229)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    237 ms 4 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 1483
    LIMIT 1
    235 ms 2 /classes/ProductAssembler.php:106
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 2185 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 2185 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    234 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 1492
    LIMIT 1
    234 ms 2 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 2718) AND (b.`id_shop` = 1) LIMIT 1
    233 ms 1 /src/Adapter/EntityMapper.php:76
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 1484 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 1484 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    233 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(231,232,233)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    231 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(36,37,38)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    231 ms 3 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE *
    FROM `ps_order_state` os
    LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) WHERE deleted = 0
    230 ms 35 /override/classes/order/OrderState.php:42
    SELECT SQL_NO_CACHE it.*,itl.name, itl.meta_title, itl.link_rewrite, itl.meta_keywords, itl.meta_description
    FROM `ps_ets_instagram_tag` it 
    LEFT JOIN `ps_ets_instagram_tag_lang` itl ON (it.id_ets_instagram_tag = itl.id_ets_instagram_tag) 
    WHERE it.id_shop = 1 AND itl.id_lang = 1 AND it.status = 1 AND it.featured = 1 GROUP BY it.id_ets_instagram_tag  HAVING 1 
    ORDER BY position LIMIT 0, 15
    229 ms 1 Yes Yes /modules/ybc_instagram/classes/INS_Presenter.php:64
    SELECT SQL_NO_CACHE * FROM `ps_rewards_template_config` WHERE `value`=1 AND `name`='RSPONSORSHIP_ACTIVE' LIMIT 1
    229 ms 1 /modules/allinone_rewards/models/RewardsTemplateModel.php:138
    SELECT SQL_NO_CACHE p.*,
    ps.*,
    pl.*,
    sa.out_of_stock,
    IFNULL(sa.quantity, 0) as quantity,
    (DATEDIFF(
    p.`date_add`,
    DATE_SUB(
    '2024-10-05 00:00:00',
    INTERVAL 0 DAY
    )
    ) > 0) as new
    FROM ps_product p
    LEFT JOIN ps_product_lang pl
    ON pl.id_product = p.id_product
    AND pl.id_shop = 1
    AND pl.id_lang = 1
    LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
    AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
    ON ps.id_product = p.id_product
    AND ps.id_shop = 1
    WHERE p.id_product = 2544
    LIMIT 1
    228 ms 2 /classes/ProductAssembler.php:106
    SELECT SQL_NO_CACHE *
    FROM `ps_order_state` os
    LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) WHERE deleted = 0
    227 ms 35 /override/classes/order/OrderState.php:42
    SELECT SQL_NO_CACHE *
    FROM `ps_order_state` os
    LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) WHERE deleted = 0
    226 ms 35 /override/classes/order/OrderState.php:42
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 1493) AND (b.`id_shop` = 1) LIMIT 1
    222 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 224) AND (b.`id_shop` = 1) LIMIT 1
    222 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a
    LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
    WHERE (a.`id_category` = 32) LIMIT 1
    221 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    218 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    218 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    218 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    217 ms 193 Yes /classes/PrestaShopCollection.php:381
    (SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-10-05 00:00:00" AND date_to <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-10-05 00:00:00" AND date_from <= "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-10-05 00:00:00" AND date_to > "2024-10-05 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
    216 ms 1 /classes/CartRule.php:383
    SELECT SQL_NO_CACHE *
    FROM `ps_order_state` os
    LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) WHERE deleted = 0
    216 ms 35 /override/classes/order/OrderState.php:42
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    216 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
    FROM ps_shop_url su
    LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
    WHERE (su.domain = 'www.michel-vaillant.com' OR su.domain_ssl = 'www.michel-vaillant.com')
    AND s.active = 1
    AND s.deleted = 0
    ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
    215 ms 1 Yes /classes/shop/Shop.php:1350
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(213,294,214,215,247,170,296)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    213 ms 7 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 39 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
    212 ms 20 Yes Yes /modules/ps_facetedsearch/src/Filters/Block.php:121
    SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
    FROM `ps_image` i
    INNER JOIN ps_image_shop image_shop
    ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
    LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
    WHERE i.`id_product` = 1493
    ORDER BY `position`
    211 ms 5 Yes /classes/Product.php:3517
    SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
    FROM `ps_category` c
    INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
    LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
    LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
    WHERE c.active=1 
    AND  c.id_category IN(9,11,10,118,208)
    AND cg.`id_group` IN (1)
    GROUP BY c.id_category ORDER BY c.position ASC,c.id_category ASC
    210 ms 5 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:178
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a0
    LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
    WHERE (a0.`nleft` < 281) AND (a0.`nright` > 282) AND (a1.`id_lang` = 1)
    ORDER BY a0.`nleft` asc
    209 ms 193 Yes /classes/PrestaShopCollection.php:381
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    208 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
    FROM `ps_module` m
    LEFT JOIN `ps_module_shop` ms
    ON m.`id_module` = ms.`id_module`
    AND ms.`id_shop` = 1
    208 ms 107 /classes/module/Module.php:340
    SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
    a.`id_attribute`, a.`position`
    FROM `ps_product_attribute` pa
    INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
    LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
    LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
    LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
    LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
    WHERE pa.`id_product` = 2334
    AND pa.`id_product_attribute` = 14053
    GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
    ORDER BY pa.`id_product_attribute`
    208 ms 1 Yes /classes/Product.php:2839
    SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
    205 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
    SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
    a.`id_attribute`, a.`position`
    FROM `ps_product_attribute` pa
    INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
    LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
    LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
    LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
    LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
    WHERE pa.`id_product` = 1484
    AND pa.`id_product_attribute` = 12626
    GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
    ORDER BY pa.`id_product_attribute`
    205 ms 1 Yes /classes/Product.php:2839
    SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
    a.`id_attribute`, a.`position`
    FROM `ps_product_attribute` pa
    INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
    LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
    LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
    LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
    LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
    WHERE pa.`id_product` = 2312
    AND pa.`id_product_attribute` = 14040
    GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
    ORDER BY pa.`id_product_attribute`
    203 ms 1 Yes /classes/Product.php:2839
    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 ps_shop_group gs
    LEFT JOIN ps_shop s
    ON s.id_shop_group = gs.id_shop_group
    LEFT JOIN ps_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
    201 ms 1 Yes /classes/shop/Shop.php:711
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a
    LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
    LEFT JOIN `ps_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
    201 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 2334) AND (b.`id_shop` = 1) LIMIT 1
    200 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE *
    FROM `ps_order_state` os
    LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) WHERE deleted = 0
    200 ms 35 /override/classes/order/OrderState.php:42
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 1493 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 1493 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    200 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
    a.`id_attribute`, a.`position`
    FROM `ps_product_attribute` pa
    INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
    LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
    LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
    LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
    LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
    WHERE pa.`id_product` = 1490
    AND pa.`id_product_attribute` = 12630
    GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
    ORDER BY pa.`id_product_attribute`
    200 ms 1 Yes /classes/Product.php:2839
    SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
    a.`id_attribute`, a.`position`
    FROM `ps_product_attribute` pa
    INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
    LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
    LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
    LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
    LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
    WHERE pa.`id_product` = 2832
    AND pa.`id_product_attribute` = 14919
    GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
    ORDER BY pa.`id_product_attribute`
    200 ms 1 Yes /classes/Product.php:2839
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 2718 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 2718 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    199 ms 0 /classes/Cart.php:1429
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 12626
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 1484 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
    WHERE cp.`id_product_attribute` = 12626
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND p.`id_product_item` = 1484 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    199 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
    a.`id_attribute`, a.`position`
    FROM `ps_product_attribute` pa
    INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
    LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
    LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
    LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
    LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
    WHERE pa.`id_product` = 224
    AND pa.`id_product_attribute` = 12351
    GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
    ORDER BY pa.`id_product_attribute`
    199 ms 1 Yes /classes/Product.php:2839
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 2544 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 2544 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    198 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE *
    FROM `ps_ce_theme` a
    LEFT JOIN `ps_ce_theme_lang` `b` ON a.`id_ce_theme` = b.`id_ce_theme` AND b.`id_lang` = 1
    LEFT JOIN `ps_ce_theme_shop` `c` ON a.`id_ce_theme` = c.`id_ce_theme` AND c.`id_shop` = 1
    WHERE (a.`id_ce_theme` = 4) AND (b.`id_shop` = 1) LIMIT 1
    197 ms 1 /src/Adapter/EntityMapper.php:76
    SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
    a.`id_attribute`, a.`position`
    FROM `ps_product_attribute` pa
    INNER JOIN ps_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 `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
    LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
    LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
    LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
    LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
    WHERE pa.`id_product` = 2718
    AND pa.`id_product_attribute` = 0
    GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
    ORDER BY pa.`id_product_attribute`
    197 ms 0 Yes /classes/Product.php:2839
    SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayBeforeBodyClosingTag" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
    196 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 2334 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 2334 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    196 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
    195 ms 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
    SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
    ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
    ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
    195 ms 1 /classes/Cart.php:4218
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 1484) AND (b.`id_shop` = 1) LIMIT 1
    194 ms 1 /src/Adapter/EntityMapper.php:76
    REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("5f85c92f2e598eb2bc27670b7a18bad2", "a:1:{s:7:\"filters\";a:2:{i:0;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Prix\";s:3:\"max\";d:3700;s:3:\"min\";d:115;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:14;s:5:\"value\";N;}i:1;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:5:{i:1;a:2:{s:4:\"name\";s:15:\"Michel Vaillant\";s:3:\"nbr\";s:1:\"2\";}i:9;a:2:{s:4:\"name\";s:4:\"Sell\";s:3:\"nbr\";s:1:\"2\";}i:12;a:2:{s:4:\"name\";s:5:\"Perun\";s:3:\"nbr\";s:1:\"3\";}i:20;a:2:{s:4:\"name\";s:5:\"Kanca\";s:3:\"nbr\";s:1:\"3\";}i:39;a:2:{s:4:\"name\";s:6:\"Angele\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")
    194 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:206
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 14040
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 2312 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
    WHERE cp.`id_product_attribute` = 14040
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND p.`id_product_item` = 2312 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    194 ms 0 /classes/Cart.php:1429
    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 `ps_cart_product` cp
    WHERE cp.`id_product_attribute` = 0
    AND cp.`id_customization` = 0
    AND cp.`id_cart` = 0 AND cp.`id_product` = 2312 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
    FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_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` = 2312 AND (pr.`pack_stock_type` IN (1,2) OR (
    pr.`pack_stock_type` = 3
    AND 0 = 1
    ))) as q LIMIT 1
    193 ms 0 /classes/Cart.php:1429
    SELECT SQL_NO_CACHE image_shop.`id_image`
    FROM `ps_image` i
    INNER JOIN ps_image_shop image_shop
    ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
    WHERE i.`id_product` = 2832
    AND image_shop.`cover` = 1 LIMIT 1
    193 ms 2 /classes/Product.php:3542