En poursuivant votre navigation sur ce site, vous acceptez notre politique de confidentialité et l'utilisation de cookies. Certains cookies sont essentiels au fonctionnement du site. D'autres cookies, soumis à votre consentement préalable, permettent de mesurer la fréquentation, afficher des publicités personnalisées sur le site et sur des sites tiers, personnaliser le contenu et partager des contenus vers les réseaux sociaux.
Grace, Petite Graphite, Applique, Elements LightingGrace, Petite Graphite, Applique, Elements Lighting
  • Nouveau
newGrace, Rubis, Suspension , Elements Lighting
  • Nouveau
279,17 €
Grace, Rose Spinelle, Applique, Elements LightingGrace, Rose Spinelle, Applique, Elements Lighting
  • Nouveau
Grace Perle, Applique, Elements LightingGrace, Perle, Applique, Elements Lighting
  • Nouveau
250,00 €

Editeur français de tissus, papiers peints, revêtements muraux et accessoires de décoration, créé en 2000, CASAMANCE invente les classiques de demain, crée des intemporels pour sublimer les intérieurs avec style.

Ses collections, s’illustrent au travers de gammes coloristiques travaillées dans la plus grande finesse, de motifs variés, et de matières nobles. L’alchimie de ses couleurs habille des espaces architecturés, où s’exprime une vraie élégance à la française. La marque est présente sur les cinq continents au travers de ses 15 filiales et possède 3 Showrooms à Paris, Londres et Culemborg.

>> En savoir plus sur Casamance

7 produits

Grille
Grille 2
Liste
Liste 2
Catalogue
    112,50 €
    Dauphine, papier peint, CasamanceDauphine, papier peint, Casamance
        112,50 €Prix
        Dauphine, papier peint, CasamanceDauphine, papier peint, Casamance
          Le papier peint Dauphine s'inspire de dernière entrée de métro imaginée par Guimard. Ce dessin d'inspiration floral art déco a réalisé selon la technique de l’impression traditionnelle. L’encre est déposée à l’aide de cylindres traditionnels gravés en bois créant des irrégularités révélant l’aspect authentique du « fait main ». Cette technique apporte aux contours du motif un léger relief,...
          112,50 €Prix
          Dauphine, papier peint, CasamanceDauphine, papier peint, Casamance
              Le papier peint Dauphine s'inspire de dernière entrée de métro imaginée par Guimard. Ce dessin d'inspiration floral art déco a réalisé selon la technique de l’impression traditionnelle. L’encre est déposée à l’aide de cylindres traditionnels gravés en bois créant des irrégularités révélant l’aspect authentique du « fait main ». Cette technique apporte aux contours du motif un léger relief,...
              112,50 €Prix
                98,30 € le mètre
                Herbes Folles, Tissu CasamanceHerbes Folles, Tissu Casamance
                    98,30 € le mètrePrix
                    Herbes Folles, Tissu CasamanceHerbes Folles, Tissu Casamance
                      <span style="box-sizing: border-box; margin: 0px; padding: 0px; -webkit-tap-highlight-color: transparent; color: #000000; font-family: Muli, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; widows: 2; word-spacing: 0px;...
                      98,30 € le mètrePrix
                      Herbes Folles, Tissu CasamanceHerbes Folles, Tissu Casamance
                          <span style="box-sizing: border-box; margin: 0px; padding: 0px; -webkit-tap-highlight-color: transparent; color: #000000; font-family: Muli, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; widows: 2; word-spacing: 0px;...
                          98,30 € le mètrePrix
                            128,33 €
                            Lombok, papier peint, CasamanceLombok, papier peint, Casamance
                                128,33 €Prix
                                Lombok, papier peint, CasamanceLombok, papier peint, Casamance
                                  Une sublime marqueterie de paille sur un support en vinyle qui n'est pas sans évoquée les ouvrages artisanaux de l'ile éponyme, dans l'archipel de Bali. Se décline en 5 magnifiques coloris.
                                  128,33 €Prix
                                  Lombok, papier peint, CasamanceLombok, papier peint, Casamance
                                      Une sublime marqueterie de paille sur un support en vinyle qui n'est pas sans évoquée les ouvrages artisanaux de l'ile éponyme, dans l'archipel de Bali. Se décline en 5 magnifiques coloris.
                                      128,33 €Prix
                                        481,67 €
                                        Modelage, papier peint panoramique, CasamanceModelage, papier peint panoramique, Casamance
                                            481,67 €Prix
                                            Modelage, papier peint panoramique, CasamanceModelage, papier peint panoramique, Casamance
                                              Ce magnifique panoramique s'inspire des ateliers du Midi de la France. Il réchauffera votre intérieur comme le ferai une oeuvre texturée en gouache au teintes organiques. Il se décline en 3 teintes.
                                              481,67 €Prix
                                              Modelage, papier peint panoramique, CasamanceModelage, papier peint panoramique, Casamance
                                                  Ce magnifique panoramique s'inspire des ateliers du Midi de la France. Il réchauffera votre intérieur comme le ferai une oeuvre texturée en gouache au teintes organiques. Il se décline en 3 teintes.
                                                  481,67 €Prix
                                                    120,00 €
                                                    Occitan, papier peint, CasamanceOccitan, papier peint, Casamance
                                                        120,00 €Prix
                                                        Occitan, papier peint, CasamanceOccitan, papier peint, Casamance
                                                          Un revêtement en vinyle sur intissé texturé qui reproduit à merveille la trame de la soie sauvage mate. il se decline en 18 coloris.
                                                          120,00 €Prix
                                                          Occitan, papier peint, CasamanceOccitan, papier peint, Casamance
                                                              Un revêtement en vinyle sur intissé texturé qui reproduit à merveille la trame de la soie sauvage mate. il se decline en 18 coloris.
                                                              120,00 €Prix
                                                                691,67 €
                                                                Orme, papier peint panoramique, CasamanceOrme, papier peint panoramique, Casamance
                                                                    691,67 €Prix
                                                                    Orme, papier peint panoramique, CasamanceOrme, papier peint panoramique, Casamance
                                                                      Ce papier peint illustre une forêt stylisée avec des arbres de différentes formes et tailles, dans une palette de couleurs douces et naturelles. Les tons dominants incluent des verts variés, des bleus pastel, des bruns terreux et des jaunes chauds. Les arbres présentent des feuilles et des troncs abstraits, créant un effet artistique. Les formes sont organiques, simplifiées, avec un style de...
                                                                      691,67 €Prix
                                                                      Orme, papier peint panoramique, CasamanceOrme, papier peint panoramique, Casamance
                                                                          Ce papier peint illustre une forêt stylisée avec des arbres de différentes formes et tailles, dans une palette de couleurs douces et naturelles. Les tons dominants incluent des verts variés, des bleus pastel, des bruns terreux et des jaunes chauds. Les arbres présentent des feuilles et des troncs abstraits, créant un effet artistique. Les formes sont organiques, simplifiées, avec un style de...
                                                                          691,67 €Prix
                                                                            Vernissage, papier peint panoramique, CasamanceVernissage, papier peint panoramique, Casamance
                                                                                916,67 €Prix
                                                                                Vernissage, papier peint panoramique, CasamanceVernissage, papier peint panoramique, Casamance
                                                                                  Ce papier peint adopte un style abstrait, composé de formes géométriques irrégulières superposées. Les blocs de couleurs incluent des tons verts, bruns, beige, bleu-gris et terracotta, créant une palette chaleureuse et organique. Les textures évoquent un effet de collage ou de tissu peint à la main, renforçant l’aspect artisanal et contemporain. Idéal pour un espace moderne ou minimaliste,...
                                                                                  916,67 €Prix
                                                                                  Vernissage, papier peint panoramique, CasamanceVernissage, papier peint panoramique, Casamance
                                                                                      Ce papier peint adopte un style abstrait, composé de formes géométriques irrégulières superposées. Les blocs de couleurs incluent des tons verts, bruns, beige, bleu-gris et terracotta, créant une palette chaleureuse et organique. Les textures évoquent un effet de collage ou de tissu peint à la main, renforçant l’aspect artisanal et contemporain. Idéal pour un espace moderne ou minimaliste,...
                                                                                      916,67 €Prix
                                                                                      Load Time 254.237 ms
                                                                                      Querying Time 71 ms
                                                                                      Queries 508
                                                                                      Memory Peak Usage 20.4 Mb
                                                                                      Included Files 1300 files - 14.52 Mb
                                                                                      PrestaShop Cache - Mb
                                                                                      Global vars 0.82 Mb
                                                                                      PrestaShop Version 8.2.0
                                                                                      PHP Version 8.1.27
                                                                                      MySQL Version 10.11.9-MariaDB
                                                                                      Memory Limit 12288M
                                                                                      Max Execution Time 480s
                                                                                      Smarty Cache enabled
                                                                                      Smarty Compilation auto
                                                                                        Time Cumulated Time Memory Usage Memory Peak Usage
                                                                                      config 7.801 ms 7.801 ms 3.78 Mb 3.9 Mb
                                                                                      __construct 0.015 ms 7.816 ms - Mb 3.9 Mb
                                                                                      init 20.499 ms 28.315 ms 0.56 Mb 4.7 Mb
                                                                                      setMedia 6.297 ms 34.612 ms 0.28 Mb 4.7 Mb
                                                                                      postProcess 0.000 ms 34.612 ms - Mb 4.7 Mb
                                                                                      initHeader 0.001 ms 34.613 ms - Mb 4.7 Mb
                                                                                      initContent 64.204 ms 98.817 ms 4.14 Mb 8.8 Mb
                                                                                      initFooter 0.002 ms 98.819 ms - Mb 8.8 Mb
                                                                                      display 155.418 ms 254.237 ms 11.15 Mb 20.4 Mb
                                                                                      Hook Time Memory Usage
                                                                                      DisplayAfterBodyOpeningTag 19.186 ms 2.33 Mb
                                                                                      DisplayReviewProductList 9.743 ms 2.24 Mb
                                                                                      ActionFrontControllerSetMedia 5.679 ms 0.23 Mb
                                                                                      DisplayHeader 4.160 ms 0.21 Mb
                                                                                      DisplayMegamenu 3.794 ms 0.83 Mb
                                                                                      DisplayBeforeBodyClosingTag 2.559 ms 0.20 Mb
                                                                                      DisplayWishlistBtnProductList 2.496 ms 0.03 Mb
                                                                                      DisplayFooterCategory 2.126 ms 0.38 Mb
                                                                                      DisplayProductCompareProductList 2.098 ms 0.03 Mb
                                                                                      DisplayNavSearchBlock 1.428 ms 0.15 Mb
                                                                                      Header 1.298 ms 0.08 Mb
                                                                                      DisplayCustomsocialblock 1.224 ms 0.16 Mb
                                                                                      displayFooterPart1 0.698 ms 0.09 Mb
                                                                                      displaySocialMediaBlock 0.670 ms 0.09 Mb
                                                                                      displayNewslettersubscription 0.639 ms 0.05 Mb
                                                                                      displayNavLanguageBlock 0.611 ms 0.06 Mb
                                                                                      displayMyaccountcblock 0.584 ms 0.09 Mb
                                                                                      displayNav1 0.562 ms 0.09 Mb
                                                                                      displayNavShoppingCartBlock 0.526 ms 0.09 Mb
                                                                                      ActionDispatcher 0.433 ms - Mb
                                                                                      DisplayPaymentIcon 0.418 ms 0.04 Mb
                                                                                      displayContactCinfo 0.412 ms 0.03 Mb
                                                                                      DisplayNavWishlistBlock 0.406 ms 0.04 Mb
                                                                                      displayNavCustomerSignInBlock 0.367 ms 0.05 Mb
                                                                                      ActionObjectAddAfter 0.360 ms - Mb
                                                                                      DisplayNavWishlistBlocksticky 0.316 ms 0.05 Mb
                                                                                      ActionDispatcherBefore 0.271 ms 0.02 Mb
                                                                                      DisplayNavProductCompareBlock 0.189 ms 0.01 Mb
                                                                                      DisplayFooter 0.166 ms 0.01 Mb
                                                                                      displayNavCurrencyBlock 0.137 ms 0.05 Mb
                                                                                      DisplayProductComparesticky 0.135 ms 0.01 Mb
                                                                                      DisplayCopyRightText 0.117 ms 0.01 Mb
                                                                                      ModuleRoutes 0.032 ms 0.02 Mb
                                                                                      DisplayProductListStockIndicator 0.023 ms 0.01 Mb
                                                                                      DisplayNavFullWidth 0.020 ms - Mb
                                                                                      DisplayTopOfferText 0.014 ms - Mb
                                                                                      DisplayCustomCss 0.006 ms - Mb
                                                                                      DisplayDownloadApps 0.004 ms - Mb
                                                                                      DisplayCustomJs 0.004 ms - Mb
                                                                                      ProductSearchProvider 0.002 ms - Mb
                                                                                      40 hook(s) 63.915 ms 7.79 Mb
                                                                                      Module Time Memory Usage
                                                                                      pm_advancedsearch4 2.332 ms 0.05 Mb
                                                                                      tvcmsblog 1.754 ms 0.18 Mb
                                                                                      ps_checkout 6.195 ms 0.31 Mb
                                                                                      advancedemailguard 1.416 ms 0.08 Mb
                                                                                      ps_mbo 1.889 ms 0.05 Mb
                                                                                      wkpos 0.880 ms 0.07 Mb
                                                                                      ps_accounts 0.428 ms 0.06 Mb
                                                                                      blockreassurance 0.237 ms 0.02 Mb
                                                                                      ps_emailsubscription 0.744 ms 0.06 Mb
                                                                                      ps_socialfollow 0.746 ms 0.10 Mb
                                                                                      ps_emailalerts 0.096 ms 0.01 Mb
                                                                                      ps_searchbar 0.174 ms 0.01 Mb
                                                                                      ps_shoppingcart 0.584 ms 0.10 Mb
                                                                                      productcomments 0.102 ms 0.01 Mb
                                                                                      tvcmsadvanceblock 0.179 ms 0.09 Mb
                                                                                      tvcmsbestsellerproducts 0.163 ms 0.01 Mb
                                                                                      tvcmsblogdisplayposts 0.164 ms 0.01 Mb
                                                                                      tvcmsbrandlist 0.144 ms 0.01 Mb
                                                                                      tvcmscategorychainslider 0.145 ms 0.01 Mb
                                                                                      tvcmscategoryslider 0.145 ms 0.01 Mb
                                                                                      tvcmscookiesnotice 0.315 ms 0.02 Mb
                                                                                      tvcmscustomerservices 0.180 ms 0.01 Mb
                                                                                      tvcmscustomsetting 1.980 ms 0.24 Mb
                                                                                      tvcmsfeaturedproducts 0.142 ms 0.01 Mb
                                                                                      tvcmsfooterlogo 0.123 ms 0.01 Mb
                                                                                      tvcmsfooterproduct 0.149 ms 0.01 Mb
                                                                                      tvcmsnewproducts 0.129 ms 0.01 Mb
                                                                                      tvcmsnewsletterpopup 0.237 ms 0.01 Mb
                                                                                      tvcmspaymenticon 0.540 ms 0.05 Mb
                                                                                      tvcmsproductcomments 10.090 ms 2.27 Mb
                                                                                      tvcmsproductcompare 2.574 ms 0.06 Mb
                                                                                      tvcmsproductpopup 19.104 ms 2.33 Mb
                                                                                      tvcmssearch 1.593 ms 0.16 Mb
                                                                                      tvcmssizechart 0.122 ms 0.01 Mb
                                                                                      tvcmsslider 0.152 ms 0.01 Mb
                                                                                      tvcmsspecialproducts 0.101 ms 0.01 Mb
                                                                                      tvcmsstockinfo 0.170 ms 0.02 Mb
                                                                                      tvcmstabproducts 0.129 ms 0.01 Mb
                                                                                      tvcmstestimonial 0.145 ms 0.01 Mb
                                                                                      tvcmsthemeoptions 0.189 ms 0.01 Mb
                                                                                      tvcmswishlist 3.404 ms 0.16 Mb
                                                                                      ps_googleanalytics 0.607 ms 0.09 Mb
                                                                                      tvcmsinfinitescroll 0.798 ms 0.05 Mb
                                                                                      tvcmsofferbanner 0.152 ms - Mb
                                                                                      tvcmscategoryproduct 0.178 ms 0.01 Mb
                                                                                      tvcmsmegamenu 4.003 ms 0.84 Mb
                                                                                      tvcmscustomcssjs 0.160 ms 0.01 Mb
                                                                                      ps_languageselector 0.694 ms 0.06 Mb
                                                                                      ps_currencyselector 0.206 ms 0.06 Mb
                                                                                      ps_customersignin 0.426 ms 0.06 Mb
                                                                                      ps_contactinfo 1.037 ms 0.12 Mb
                                                                                      tvcmsfootercategory 2.300 ms 0.39 Mb
                                                                                      ps_linklist 0.962 ms 0.09 Mb
                                                                                      ps_customeraccountlinks 0.642 ms 0.10 Mb
                                                                                      statsdata 2.590 ms 0.21 Mb
                                                                                      dgtranslationall 0.377 ms 0.03 Mb
                                                                                      56 module(s) 75.219 ms 8.73 Mb

                                                                                      Stopwatch SQL - 508 queries

                                                                                      # Query Time (ms) Rows Filesort Group By Location
                                                                                      242
                                                                                      SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
                                                                                      pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
                                                                                      (DATEDIFF(product_shop.`date_add`,
                                                                                      DATE_SUB(
                                                                                      "2024-12-06 00:00:00",
                                                                                      INTERVAL 8 DAY
                                                                                      )
                                                                                      ) &gt; 0) as new,
                                                                                      product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
                                                                                      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_lang` = 1 AND pl.id_shop = 1 
                                                                                      LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1
                                                                                      LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1
                                                                                      LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
                                                                                      LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1
                                                                                      LEFT JOIN ps_stock_available stock
                                                                                      ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
                                                                                      WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`,
                                                                                      DATE_SUB(
                                                                                      "2024-12-06 00:00:00",
                                                                                      INTERVAL 8 DAY
                                                                                      )
                                                                                      ) &gt; 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp
                                                                                      JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1)
                                                                                      WHERE cp.`id_product` = p.`id_product`))
                                                                                      ORDER BY product_shop.`date_add` DESC
                                                                                      LIMIT 5
                                                                                      3.021 ms 200448 Yes /classes/Product.php:3110
                                                                                      2
                                                                                      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`)
                                                                                      2.184 ms 2115 /classes/Configuration.php:180
                                                                                      81
                                                                                      SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
                                                                                      , pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`,
                                                                                      pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
                                                                                      DATEDIFF(
                                                                                      product_shop.`date_add`,
                                                                                      DATE_SUB(
                                                                                      "2024-12-06 00:00:00",
                                                                                      INTERVAL 8 DAY
                                                                                      )
                                                                                      ) &gt; 0 AS new 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_attribute_shop` product_attribute_shop
                                                                                      ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
                                                                                      LEFT JOIN `ps_product_lang` pl
                                                                                      ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
                                                                                      LEFT JOIN `ps_image_shop` image_shop
                                                                                      ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
                                                                                      LEFT JOIN `ps_image_lang` il
                                                                                      ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_manufacturer` m
                                                                                      ON (m.`id_manufacturer` = p.`id_manufacturer`)
                                                                                      LEFT JOIN ps_stock_available stock
                                                                                      ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )JOIN `ps_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` =1)JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
                                                                                      WHERE p.`id_manufacturer` = 25
                                                                                      AND product_shop.`active` = 1
                                                                                      AND product_shop.`visibility` IN ("both", "catalog")
                                                                                      GROUP BY p.id_product
                                                                                      ORDER BY pl.`name` asc
                                                                                      LIMIT 0,48
                                                                                      2.041 ms 112 Yes Yes /classes/Manufacturer.php:499
                                                                                      14
                                                                                      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 &amp; 1)
                                                                                      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`
                                                                                      1.208 ms 214 Yes Yes /classes/Hook.php:1267
                                                                                      91
                                                                                      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
                                                                                      1.160 ms 746 /classes/Hook.php:456
                                                                                      90
                                                                                      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
                                                                                      0.858 ms 0 /classes/Hook.php:1326
                                                                                      321
                                                                                      SELECT SQL_NO_CACHE c.*, cl.*
                                                                                      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 cl.id_shop = 1 
                                                                                      WHERE 1  AND `id_lang` = 1
                                                                                      AND c.`active` = 1
                                                                                      ORDER BY c.`level_depth` ASC
                                                                                      , category_shop.`position` ASC
                                                                                      0.746 ms 18 Yes /classes/Category.php:799
                                                                                      419
                                                                                      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                                                                                      FROM `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)
                                                                                      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                                                                                      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                                                                                      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
                                                                                      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                                                                                      WHERE pa.`id_product` IN (271) AND ag.`is_color_group` = 1
                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                      ORDER BY a.`position` ASC;
                                                                                      0.640 ms 36 Yes Yes /classes/Product.php:4524
                                                                                      375
                                                                                      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                                                                                      FROM `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)
                                                                                      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                                                                                      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                                                                                      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
                                                                                      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                                                                                      WHERE pa.`id_product` IN (255) AND ag.`is_color_group` = 1
                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                      ORDER BY a.`position` ASC;
                                                                                      0.529 ms 14 Yes Yes /classes/Product.php:4524
                                                                                      359
                                                                                      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                                                                                      FROM `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)
                                                                                      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                                                                                      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                                                                                      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
                                                                                      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                                                                                      WHERE pa.`id_product` IN (209) AND ag.`is_color_group` = 1
                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                      ORDER BY a.`position` ASC;
                                                                                      0.511 ms 12 Yes Yes /classes/Product.php:4524
                                                                                      391
                                                                                      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                                                                                      FROM `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)
                                                                                      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                                                                                      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                                                                                      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
                                                                                      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                                                                                      WHERE pa.`id_product` IN (225) AND ag.`is_color_group` = 1
                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                      ORDER BY a.`position` ASC;
                                                                                      0.482 ms 10 Yes Yes /classes/Product.php:4524
                                                                                      226
                                                                                      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` = 329) AND (b.`id_shop` = 1) LIMIT 1
                                                                                      0.419 ms 1 /src/Adapter/EntityMapper.php:71
                                                                                      377
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 255
                                                                                      AND pac.`id_product_attribute` = 1041
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.373 ms 2 /classes/Product.php:7534
                                                                                      406
                                                                                      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                                                                                      FROM `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)
                                                                                      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                                                                                      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                                                                                      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
                                                                                      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                                                                                      WHERE pa.`id_product` IN (226) AND ag.`is_color_group` = 1
                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                      ORDER BY a.`position` ASC;
                                                                                      0.358 ms 6 Yes Yes /classes/Product.php:4524
                                                                                      203
                                                                                      SELECT SQL_NO_CACHE p.*,
                                                                                      ps.*,
                                                                                      pl.*,
                                                                                      sa.out_of_stock,
                                                                                      IFNULL(sa.quantity, 0) as quantity,
                                                                                      (DATEDIFF(
                                                                                      p.`date_add`,
                                                                                      DATE_SUB(
                                                                                      '2024-12-06 00:00:00',
                                                                                      INTERVAL 8 DAY
                                                                                      )
                                                                                      ) &gt; 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_product_attribute = 0
                                                                                      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 IN (209,255,225,226,271,329,331)
                                                                                      0.350 ms 7 /classes/ProductAssembler.php:95
                                                                                      0
                                                                                      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.hippotigre.com' OR su.domain_ssl = 'www.hippotigre.com')
                                                                                      AND s.active = 1
                                                                                      AND s.deleted = 0
                                                                                      ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
                                                                                      0.349 ms 1 Yes /classes/shop/Shop.php:1364
                                                                                      459
                                                                                      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                                                                                      FROM `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)
                                                                                      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                                                                                      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                                                                                      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
                                                                                      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                                                                                      WHERE pa.`id_product` IN (331) AND ag.`is_color_group` = 1
                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                      ORDER BY a.`position` ASC;
                                                                                      0.330 ms 4 Yes Yes /classes/Product.php:4524
                                                                                      447
                                                                                      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                                                                                      FROM `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)
                                                                                      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                                                                                      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                                                                                      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
                                                                                      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                                                                                      WHERE pa.`id_product` IN (329) AND ag.`is_color_group` = 1
                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                      ORDER BY a.`position` ASC;
                                                                                      0.329 ms 4 Yes Yes /classes/Product.php:4524
                                                                                      225
                                                                                      SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
                                                                                      FROM `ps_product_attribute_image` pai
                                                                                      LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
                                                                                      LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
                                                                                      WHERE pai.`id_product_attribute` IN (1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1524, 1525, 1526, 1527) AND il.`id_lang` = 1 ORDER by i.`position`
                                                                                      0.325 ms 72 Yes /classes/Product.php:2921
                                                                                      22
                                                                                      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
                                                                                      0.316 ms 146 Yes /classes/Dispatcher.php:654
                                                                                      503
                                                                                      SELECT SQL_NO_CACHE `id_guest`
                                                                                      FROM `ps_connections`
                                                                                      WHERE `id_guest` = 2268645
                                                                                      AND `date_add` &gt; '2024-12-06 11:33:00'
                                                                                      AND id_shop IN (1) 
                                                                                      ORDER BY `date_add` DESC LIMIT 1
                                                                                      0.312 ms 1 Yes /classes/Connection.php:168
                                                                                      116
                                                                                      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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
                                                                                      FROM `ps_cart_product` cp
                                                                                      WHERE cp.`id_product_attribute` = 1042
                                                                                      AND cp.`id_cart` = 0 AND cp.`id_product` = 255 UNION SELECT 0 as first_level_quantity, SUM(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` = 1042
                                                                                      AND cp.`id_cart` = 0 AND p.`id_product_item` = 255 AND (pr.`pack_stock_type` IN (1,2) OR (
                                                                                      pr.`pack_stock_type` = 3
                                                                                      AND 0 = 1
                                                                                      ))) as q LIMIT 1
                                                                                      0.303 ms 0 /classes/Cart.php:1430
                                                                                      13
                                                                                      SELECT SQL_NO_CACHE lower(name) as name
                                                                                      FROM `ps_hook` h
                                                                                      WHERE (h.active = 1)
                                                                                      0.296 ms 1106 /classes/Hook.php:1366
                                                                                      376
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 255
                                                                                      AND pac.`id_product_attribute` = 1040
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.293 ms 2 /classes/Product.php:7534
                                                                                      243
                                                                                      SELECT SQL_NO_CACHE id_product, name, value, pf.id_feature
                                                                                      FROM ps_feature_product pf
                                                                                      LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
                                                                                      LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
                                                                                      LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature)
                                                                                      INNER JOIN ps_feature_shop feature_shop
                                                                                      ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
                                                                                      WHERE `id_product` IN (528,527,526,525,523)
                                                                                      ORDER BY f.position ASC
                                                                                      0.284 ms 45 Yes /classes/Product.php:4904
                                                                                      92
                                                                                      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` = 1
                                                                                      AND tr.`id_state` IN (0, 0)
                                                                                      AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
                                                                                      OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
                                                                                      ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
                                                                                      0.283 ms 1 /classes/tax/TaxRulesTaxManager.php:109
                                                                                      5
                                                                                      SELECT SQL_NO_CACHE l.*, ls.`id_shop`
                                                                                      FROM `ps_lang` l
                                                                                      LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
                                                                                      0.279 ms 4 /classes/Language.php:1080
                                                                                      151
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 226
                                                                                      AND pac.`id_product_attribute` = 852
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.271 ms 2 /classes/Product.php:7534
                                                                                      380
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 255
                                                                                      AND pac.`id_product_attribute` = 1045
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.269 ms 2 /classes/Product.php:7534
                                                                                      392
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 225
                                                                                      AND pac.`id_product_attribute` = 827
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.267 ms 2 /classes/Product.php:7534
                                                                                      420
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1492
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.264 ms 2 /classes/Product.php:7534
                                                                                      407
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 226
                                                                                      AND pac.`id_product_attribute` = 847
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.259 ms 2 /classes/Product.php:7534
                                                                                      460
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 331
                                                                                      AND pac.`id_product_attribute` = 1648
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.256 ms 2 /classes/Product.php:7534
                                                                                      213
                                                                                      SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
                                                                                      FROM `ps_product_attribute_image` pai
                                                                                      LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
                                                                                      LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
                                                                                      WHERE pai.`id_product_attribute` IN (1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053) AND il.`id_lang` = 1 ORDER by i.`position`
                                                                                      0.255 ms 58 Yes /classes/Product.php:2921
                                                                                      409
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 226
                                                                                      AND pac.`id_product_attribute` = 849
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.252 ms 2 /classes/Product.php:7534
                                                                                      422
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1494
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.252 ms 2 /classes/Product.php:7534
                                                                                      448
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 329
                                                                                      AND pac.`id_product_attribute` = 1640
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.252 ms 2 /classes/Product.php:7534
                                                                                      433
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1505
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.250 ms 2 /classes/Product.php:7534
                                                                                      291
                                                                                      SELECT SQL_NO_CACHE p.*,
                                                                                      ps.*,
                                                                                      pl.*,
                                                                                      sa.out_of_stock,
                                                                                      IFNULL(sa.quantity, 0) as quantity,
                                                                                      (DATEDIFF(
                                                                                      p.`date_add`,
                                                                                      DATE_SUB(
                                                                                      '2024-12-06 00:00:00',
                                                                                      INTERVAL 8 DAY
                                                                                      )
                                                                                      ) &gt; 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_product_attribute = 0
                                                                                      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 IN (528)
                                                                                      0.249 ms 1 /classes/ProductAssembler.php:64
                                                                                      432
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1504
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.249 ms 2 /classes/Product.php:7534
                                                                                      408
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 226
                                                                                      AND pac.`id_product_attribute` = 848
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.243 ms 2 /classes/Product.php:7534
                                                                                      424
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1496
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.240 ms 2 /classes/Product.php:7534
                                                                                      425
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1497
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.238 ms 2 /classes/Product.php:7534
                                                                                      202
                                                                                      SELECT SQL_NO_CACHE p.`id_product`
                                                                                      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)
                                                                                      WHERE p.id_manufacturer = 25 AND product_shop.`active` = 1
                                                                                      AND product_shop.`visibility` IN ("both", "catalog")
                                                                                      AND EXISTS (
                                                                                      SELECT 1
                                                                                      FROM `ps_category_group` cg
                                                                                      LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
                                                                                      WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` =1
                                                                                      )
                                                                                      0.238 ms 112 /classes/Manufacturer.php:430
                                                                                      506
                                                                                      INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('2268645', '266', '308350547', '', '1', '1', '2024-12-06 12:03:03')
                                                                                      0.238 ms 1 /classes/ObjectModel.php:622
                                                                                      394
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 225
                                                                                      AND pac.`id_product_attribute` = 829
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.237 ms 2 /classes/Product.php:7534
                                                                                      421
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1493
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.236 ms 2 /classes/Product.php:7534
                                                                                      461
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 331
                                                                                      AND pac.`id_product_attribute` = 1649
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.236 ms 2 /classes/Product.php:7534
                                                                                      434
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1506
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.234 ms 2 /classes/Product.php:7534
                                                                                      381
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 255
                                                                                      AND pac.`id_product_attribute` = 1046
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.233 ms 2 /classes/Product.php:7534
                                                                                      378
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 255
                                                                                      AND pac.`id_product_attribute` = 1043
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.233 ms 2 /classes/Product.php:7534
                                                                                      393
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 225
                                                                                      AND pac.`id_product_attribute` = 828
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.232 ms 2 /classes/Product.php:7534
                                                                                      360
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 209
                                                                                      AND pac.`id_product_attribute` = 725
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.231 ms 2 /classes/Product.php:7534
                                                                                      379
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 255
                                                                                      AND pac.`id_product_attribute` = 1044
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.231 ms 2 /classes/Product.php:7534
                                                                                      449
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 329
                                                                                      AND pac.`id_product_attribute` = 1641
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.231 ms 2 /classes/Product.php:7534
                                                                                      97
                                                                                      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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
                                                                                      FROM `ps_cart_product` cp
                                                                                      WHERE cp.`id_product_attribute` = 0
                                                                                      AND cp.`id_cart` = 0 AND cp.`id_product` = 209 UNION SELECT 0 as first_level_quantity, SUM(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_cart` = 0 AND p.`id_product_item` = 209 AND (pr.`pack_stock_type` IN (1,2) OR (
                                                                                      pr.`pack_stock_type` = 3
                                                                                      AND 0 = 1
                                                                                      ))) as q LIMIT 1
                                                                                      0.230 ms 0 /classes/Cart.php:1430
                                                                                      431
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1503
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.230 ms 2 /classes/Product.php:7534
                                                                                      471
                                                                                      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
                                                                                      0.230 ms 1 /classes/module/Module.php:2659
                                                                                      507
                                                                                      INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('2186044', '', 'www.hippotigre.com/fr/brand/25-casamance', '', '2024-12-06 12:03:03')
                                                                                      0.230 ms 1 /classes/ObjectModel.php:622
                                                                                      505
                                                                                      SELECT SQL_NO_CACHE `id_page`
                                                                                      FROM `ps_page`
                                                                                      WHERE `id_page_type` = 10 AND `id_object` = 25 LIMIT 1
                                                                                      0.229 ms 1 /classes/Page.php:83
                                                                                      102
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 209
                                                                                      AND pac.`id_product_attribute` = 735
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.228 ms 2 /classes/Product.php:7534
                                                                                      430
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1502
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.227 ms 2 /classes/Product.php:7534
                                                                                      395
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 225
                                                                                      AND pac.`id_product_attribute` = 830
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.227 ms 2 /classes/Product.php:7534
                                                                                      167
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1527
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.226 ms 2 /classes/Product.php:7534
                                                                                      423
                                                                                      SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
                                                                                      pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
                                                                                      pal.`available_now`, pal.`available_later`
                                                                                      FROM `ps_attribute` a
                                                                                      LEFT JOIN `ps_attribute_lang` al
                                                                                      ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_product_attribute_combination` pac
                                                                                      ON (pac.`id_attribute` = a.`id_attribute`)
                                                                                      LEFT JOIN `ps_product_attribute` pa
                                                                                      ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
                                                                                      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_lang` pal
                                                                                      ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
                                                                                      LEFT JOIN `ps_attribute_group_lang` agl
                                                                                      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
                                                                                      WHERE pa.`id_product` = 271
                                                                                      AND pac.`id_product_attribute` = 1495
                                                                                      AND agl.`id_lang` = 1
                                                                                      0.226 ms 2 /classes/Product.php:7534