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 €

Osborne & Little est un fabricant et détaillant britannique de papiers peints et de tissus haut de gamme. Elle a été créée en 1968 et possède désormais des salles d'exposition dans le monde entier. Elle faisait partie des marques incluses dans l' exposition British Design 1948-2012: Innovation in the Modern Age du Victoria and Albert Museum en 2012

Créée dans le Londres des Swinging Sixties, la toute première collection primée d'Osborne & Little de papiers peints imprimés à la main a élargi les horizons du design et a remporté un succès instantané.

Depuis, elle est devenue une entreprise internationale dynamique. L'approche imaginative d'Osborne & Little, qui explore diverses sources d'inspiration pour produire des créations qui embrassent à la fois les styles classiques et contemporains, est essentielle au succès de la marque. Depuis un demi-siècle, ses designs distinctifs et attrayants, à travers des tissus imprimés, des tissages et des passementeries, sont au cœur des tendances d'intérieur. De nombreuses créations sont désormais conservées dans des collections de musées tels que le Victoria & Albert à Londres, le Cooper Hewitt à New York et le Chicago Institute of Art.

Osborne & Little chérit sa réputation d'innovation et de qualité et est aujourd'hui plus inspiré et énergique que jamais, créant un flux constant de nouvelles collections qui repoussent les limites.

Osborne & Little est fier d'être le distributeur de deux marques distinguées ; les collections d'ameublement de la décoratrice d'intérieur de renommée internationale NINA CAMPBELL et du créateur de mode britannique MATTHEW WILLIAMSON. Nina Campbell travaille avec O&L depuis 1989 et Matthew Williamson depuis 2013. Avec Osborne & Little, ils forment un formidable partenariat.

11 produits

Grille
Grille 2
Liste
Liste 2
Catalogue
    109,17 €
    Alberti, papier peint, Osborne & LittleAlberti, papier peint, Osborne & Little
        109,17 €Prix
        Alberti, papier peint, Osborne & LittleAlberti, papier peint, Osborne & Little
          Le papier peint Alberti signé Osborne & Little incarne l'élégance intemporelle avec ses larges rayures sophistiquées, rehaussées par un fin accent de rayures plus étroites. Mélange subtil de contrastes, ce motif associe des tons neutres et modernes, parfaits pour apporter profondeur et structure à vos murs. Idéal pour les intérieurs classiques ou contemporains, il s'adapte parfaitement...
          109,17 €Prix
          Alberti, papier peint, Osborne & LittleAlberti, papier peint, Osborne & Little
              Le papier peint Alberti signé Osborne & Little incarne l'élégance intemporelle avec ses larges rayures sophistiquées, rehaussées par un fin accent de rayures plus étroites. Mélange subtil de contrastes, ce motif associe des tons neutres et modernes, parfaits pour apporter profondeur et structure à vos murs. Idéal pour les intérieurs classiques ou contemporains, il s'adapte parfaitement...
              109,17 €Prix
                Coastline, papier peint panoramique, Osborne & LittleCoastline, papier peint panoramique, Osborne & Little
                    Coastline, papier peint panoramique, Osborne & LittleCoastline, papier peint panoramique, Osborne & Little
                      Une scène côtière où s'élèvent cèdres majestueux, sur un promontoire parsemé de digitales, surplombant une baie aux îles rocheuses. Ce papier peint a été conçu exclusivement pour Osborne & Little par Joanna Charlotte.
                      383,33 €Prix
                      Coastline, papier peint panoramique, Osborne & LittleCoastline, papier peint panoramique, Osborne & Little
                          Une scène côtière où s'élèvent cèdres majestueux, sur un promontoire parsemé de digitales, surplombant une baie aux îles rocheuses. Ce papier peint a été conçu exclusivement pour Osborne & Little par Joanna Charlotte.
                          383,33 €Prix
                            183,30 € le mètre
                            Pelangi Velvet, Tissu Osborne and Littlecopy of Pelangi Velvet, Tissu Osborne and Little
                                183,30 € le mètrePrix
                                Pelangi Velvet, Tissu Osborne and Littlecopy of Pelangi Velvet, Tissu Osborne and Little
                                  Une magnifique réinterprétation de ce motif best-seller d'Osborne & Little sur un support en velours coupé. Se décline dans 3 coloris différents. Pour les commandes de tissus, merci de renseigner la quantité en décimètres, 10 pour 1m, 11 pour 1m10, 12 pour 1m20 (Minimum de commande 1...
                                  183,30 € le mètrePrix
                                  Pelangi Velvet, Tissu Osborne and Littlecopy of Pelangi Velvet, Tissu Osborne and Little
                                      Une magnifique réinterprétation de ce motif best-seller d'Osborne & Little sur un support en velours coupé. Se décline dans 3 coloris différents. Pour les commandes de tissus, merci de renseigner la quantité en décimètres, 10 pour 1m, 11 pour 1m10, 12 pour 1m20 (Minimum de commande 1...
                                      183,30 € le mètrePrix
                                        184,00 €
                                        Foresta, papier peint, Osborne & LittleForesta, papier peint, Osborne & Little
                                            184,00 €Prix
                                            Foresta, papier peint, Osborne & LittleForesta, papier peint, Osborne & Little
                                              Une charmante représentation d’arbres indiens stylisés. Les coloris englobent diverses nuances de vert avec des accents dorés, capturant une ambiance naturelle.
                                              184,00 €Prix
                                              Foresta, papier peint, Osborne & LittleForesta, papier peint, Osborne & Little
                                                  Une charmante représentation d’arbres indiens stylisés. Les coloris englobent diverses nuances de vert avec des accents dorés, capturant une ambiance naturelle.
                                                  184,00 €Prix
                                                    184,00 €
                                                    Mayani, papier peint, Osborne & LittleMayani, papier peint, Osborne & Little
                                                        184,00 €Prix
                                                        Mayani, papier peint, Osborne & LittleMayani, papier peint, Osborne & Little
                                                          De magnifiques oiseaux décoratifs sont comme peints et se perchent sur des branches feuillues. Une des déclinaisons représentes ces charmants volatiles sur un fond doré saisissant. La papier peint Mayani fait référence aux fameux un sanctuaire d'oiseaux en Inde.
                                                          184,00 €Prix
                                                          Mayani, papier peint, Osborne & LittleMayani, papier peint, Osborne & Little
                                                              De magnifiques oiseaux décoratifs sont comme peints et se perchent sur des branches feuillues. Une des déclinaisons représentes ces charmants volatiles sur un fond doré saisissant. La papier peint Mayani fait référence aux fameux un sanctuaire d'oiseaux en Inde.
                                                              184,00 €Prix
                                                                130,80 € le mètre
                                                                Orchard Linen, Tissu Osborne & LittleOrchard Linen, Tissu Osborne & Little
                                                                    130,80 € le mètrePrix
                                                                    Orchard Linen, Tissu Osborne & LittleOrchard Linen, Tissu Osborne & Little
                                                                      <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;...
                                                                      130,80 € le mètrePrix
                                                                      Orchard Linen, Tissu Osborne & LittleOrchard Linen, Tissu Osborne & Little
                                                                          <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;...
                                                                          130,80 € le mètrePrix
                                                                            220,00 € le mètre
                                                                            Orchard Velvet, Velours imprimé Osborne & LittleOrchard Velvet, Velours imprimé Osborne & Little
                                                                                220,00 € le mètrePrix
                                                                                Orchard Velvet, Velours imprimé Osborne & LittleOrchard Velvet, Velours imprimé Osborne & Little
                                                                                  <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;...
                                                                                  220,00 € le mètrePrix
                                                                                  Orchard Velvet, Velours imprimé Osborne & LittleOrchard Velvet, Velours imprimé Osborne & Little
                                                                                      <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;...
                                                                                      220,00 € le mètrePrix
                                                                                        339,17 €
                                                                                        Orchard, papier peint Osborne & LittleOrchard, papier peint Osborne & Little
                                                                                            339,17 €Prix
                                                                                            Orchard, papier peint Osborne & LittleOrchard, papier peint Osborne & Little
                                                                                              Un sublime mélange de fruits ; grenades, figues, groseilles, prunes, fruits à pain, melons et gousses de pois de senteur sont disposés dans un motif traînant coloré. Il se décline en 6 teintes.
                                                                                              339,17 €Prix
                                                                                              Orchard, papier peint Osborne & LittleOrchard, papier peint Osborne & Little
                                                                                                  Un sublime mélange de fruits ; grenades, figues, groseilles, prunes, fruits à pain, melons et gousses de pois de senteur sont disposés dans un motif traînant coloré. Il se décline en 6 teintes.
                                                                                                  339,17 €Prix
                                                                                                    183,30 € le mètre
                                                                                                    Pelangi Velvet, Tissu Osborne and LittlePelangi Velvet, Tissu Osborne and Little
                                                                                                        183,30 € le mètrePrix
                                                                                                        Pelangi Velvet, Tissu Osborne and LittlePelangi Velvet, Tissu Osborne and Little
                                                                                                          Une magnifique réinterprétation de ce motif best-seller d'Osborne &amp; Little sur un support en velours coupé. Se décline dans 3 coloris différents. Pour les commandes de tissus, merci de renseigner la quantité en décimètres, 10 pour 1m, 11 pour 1m10, 12 pour 1m20 (Minimum de commande 1...
                                                                                                          183,30 € le mètrePrix
                                                                                                          Pelangi Velvet, Tissu Osborne and LittlePelangi Velvet, Tissu Osborne and Little
                                                                                                              Une magnifique réinterprétation de ce motif best-seller d'Osborne &amp; Little sur un support en velours coupé. Se décline dans 3 coloris différents. Pour les commandes de tissus, merci de renseigner la quantité en décimètres, 10 pour 1m, 11 pour 1m10, 12 pour 1m20 (Minimum de commande 1...
                                                                                                              183,30 € le mètrePrix
                                                                                                                245,00 €
                                                                                                                Rhapsody, papier peint, Osborne & LittleRhapsody, papier peint, Osborne & Little
                                                                                                                    245,00 €Prix
                                                                                                                    Rhapsody, papier peint, Osborne & LittleRhapsody, papier peint, Osborne & Little
                                                                                                                      Le papier-peint rhapsody représente treillis imaginatif composé de fleurs de fruits de la passion, de gousses et de courges décoratives.
                                                                                                                      245,00 €Prix
                                                                                                                      Rhapsody, papier peint, Osborne & LittleRhapsody, papier peint, Osborne & Little
                                                                                                                          Le papier-peint rhapsody représente treillis imaginatif composé de fleurs de fruits de la passion, de gousses et de courges décoratives.
                                                                                                                          245,00 €Prix
                                                                                                                            126,50 € le mètre
                                                                                                                            Shalimar, Tissu Osborne & LittleShalimar, Tissu Osborne & Little
                                                                                                                                126,50 € le mètrePrix
                                                                                                                                Shalimar, Tissu Osborne & LittleShalimar, Tissu Osborne & Little
                                                                                                                                  <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;...
                                                                                                                                  126,50 € le mètrePrix
                                                                                                                                  Shalimar, Tissu Osborne & LittleShalimar, Tissu Osborne & Little
                                                                                                                                      <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;...
                                                                                                                                      126,50 € le mètrePrix
                                                                                                                                      Load Time 210.595 ms
                                                                                                                                      Querying Time 90 ms
                                                                                                                                      Queries 630
                                                                                                                                      Memory Peak Usage 22.9 Mb
                                                                                                                                      Included Files 1269 files - 14.21 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.488 ms 7.488 ms 3.78 Mb 3.9 Mb
                                                                                                                                      __construct 0.011 ms 7.499 ms - Mb 3.9 Mb
                                                                                                                                      init 20.630 ms 28.129 ms 0.56 Mb 4.7 Mb
                                                                                                                                      checkAccess 0.001 ms 28.130 ms - Mb 4.7 Mb
                                                                                                                                      setMedia 6.186 ms 34.316 ms 0.28 Mb 4.7 Mb
                                                                                                                                      postProcess 0.000 ms 34.316 ms - Mb 4.7 Mb
                                                                                                                                      initHeader 0.001 ms 34.317 ms - Mb 4.7 Mb
                                                                                                                                      initContent 76.622 ms 110.939 ms 5.14 Mb 9.8 Mb
                                                                                                                                      initFooter 0.002 ms 110.941 ms - Mb 9.8 Mb
                                                                                                                                      display 99.654 ms 210.595 ms 12.44 Mb 22.9 Mb
                                                                                                                                      Hook Time Memory Usage
                                                                                                                                      DisplayAfterBodyOpeningTag 19.009 ms 2.30 Mb
                                                                                                                                      DisplayReviewProductList 14.878 ms 3.50 Mb
                                                                                                                                      ActionFrontControllerSetMedia 5.583 ms 0.23 Mb
                                                                                                                                      DisplayMegamenu 4.698 ms 0.89 Mb
                                                                                                                                      DisplayWishlistBtnProductList 3.695 ms 0.05 Mb
                                                                                                                                      DisplayHeader 3.626 ms 0.21 Mb
                                                                                                                                      DisplayProductCompareProductList 3.299 ms 0.04 Mb
                                                                                                                                      DisplayBeforeBodyClosingTag 2.199 ms 0.21 Mb
                                                                                                                                      DisplayFooterCategory 1.564 ms 0.38 Mb
                                                                                                                                      DisplayNavSearchBlock 1.394 ms 0.15 Mb
                                                                                                                                      Header 1.307 ms 0.08 Mb
                                                                                                                                      DisplayCustomsocialblock 0.913 ms 0.17 Mb
                                                                                                                                      displayNavShoppingCartBlock 0.594 ms 0.09 Mb
                                                                                                                                      displayFooterPart1 0.583 ms 0.09 Mb
                                                                                                                                      displayNav1 0.574 ms 0.09 Mb
                                                                                                                                      DisplayPaymentIcon 0.566 ms 0.04 Mb
                                                                                                                                      displayNavLanguageBlock 0.562 ms 0.06 Mb
                                                                                                                                      displayMyaccountcblock 0.552 ms 0.09 Mb
                                                                                                                                      displaySocialMediaBlock 0.503 ms 0.15 Mb
                                                                                                                                      ActionDispatcher 0.433 ms - Mb
                                                                                                                                      displayNavCustomerSignInBlock 0.386 ms 0.05 Mb
                                                                                                                                      DisplayNavWishlistBlock 0.362 ms 0.04 Mb
                                                                                                                                      displayNewslettersubscription 0.359 ms 0.05 Mb
                                                                                                                                      displayContactCinfo 0.346 ms 0.03 Mb
                                                                                                                                      DisplayNavWishlistBlocksticky 0.290 ms 0.05 Mb
                                                                                                                                      ActionDispatcherBefore 0.255 ms 0.02 Mb
                                                                                                                                      ActionObjectAddAfter 0.246 ms 0.01 Mb
                                                                                                                                      displayNavCurrencyBlock 0.198 ms 0.05 Mb
                                                                                                                                      DisplayNavProductCompareBlock 0.150 ms 0.01 Mb
                                                                                                                                      DisplayProductComparesticky 0.128 ms 0.01 Mb
                                                                                                                                      DisplayCopyRightText 0.109 ms 0.01 Mb
                                                                                                                                      DisplayFooter 0.092 ms 0.01 Mb
                                                                                                                                      DisplayProductListStockIndicator 0.035 ms 0.01 Mb
                                                                                                                                      ModuleRoutes 0.031 ms 0.02 Mb
                                                                                                                                      DisplayNavFullWidth 0.017 ms - Mb
                                                                                                                                      DisplayTopOfferText 0.010 ms - Mb
                                                                                                                                      DisplayCustomCss 0.005 ms - Mb
                                                                                                                                      DisplayDownloadApps 0.004 ms - Mb
                                                                                                                                      DisplayCustomJs 0.004 ms - Mb
                                                                                                                                      ProductSearchProvider 0.002 ms - Mb
                                                                                                                                      40 hook(s) 69.563 ms 9.19 Mb
                                                                                                                                      Module Time Memory Usage
                                                                                                                                      pm_advancedsearch4 2.006 ms 0.05 Mb
                                                                                                                                      tvcmsblog 2.081 ms 0.18 Mb
                                                                                                                                      ps_checkout 6.153 ms 0.31 Mb
                                                                                                                                      advancedemailguard 1.411 ms 0.08 Mb
                                                                                                                                      ps_mbo 2.122 ms 0.05 Mb
                                                                                                                                      wkpos 0.873 ms 0.07 Mb
                                                                                                                                      ps_accounts 0.450 ms 0.06 Mb
                                                                                                                                      blockreassurance 0.188 ms 0.02 Mb
                                                                                                                                      ps_emailsubscription 0.469 ms 0.06 Mb
                                                                                                                                      ps_socialfollow 0.578 ms 0.16 Mb
                                                                                                                                      ps_emailalerts 0.116 ms 0.01 Mb
                                                                                                                                      ps_searchbar 0.182 ms 0.01 Mb
                                                                                                                                      ps_shoppingcart 0.654 ms 0.10 Mb
                                                                                                                                      productcomments 0.105 ms 0.01 Mb
                                                                                                                                      tvcmsadvanceblock 0.199 ms 0.09 Mb
                                                                                                                                      tvcmsbestsellerproducts 0.161 ms 0.01 Mb
                                                                                                                                      tvcmsblogdisplayposts 0.160 ms 0.01 Mb
                                                                                                                                      tvcmsbrandlist 0.147 ms 0.01 Mb
                                                                                                                                      tvcmscategorychainslider 0.147 ms 0.01 Mb
                                                                                                                                      tvcmscategoryslider 0.154 ms 0.01 Mb
                                                                                                                                      tvcmscookiesnotice 0.321 ms 0.02 Mb
                                                                                                                                      tvcmscustomerservices 0.151 ms 0.01 Mb
                                                                                                                                      tvcmscustomsetting 1.504 ms 0.25 Mb
                                                                                                                                      tvcmsfeaturedproducts 0.112 ms 0.01 Mb
                                                                                                                                      tvcmsfooterlogo 0.092 ms 0.01 Mb
                                                                                                                                      tvcmsfooterproduct 0.113 ms 0.01 Mb
                                                                                                                                      tvcmsnewproducts 0.097 ms 0.01 Mb
                                                                                                                                      tvcmsnewsletterpopup 0.185 ms 0.01 Mb
                                                                                                                                      tvcmspaymenticon 0.658 ms 0.05 Mb
                                                                                                                                      tvcmsproductcomments 15.182 ms 3.54 Mb
                                                                                                                                      tvcmsproductcompare 3.740 ms 0.07 Mb
                                                                                                                                      tvcmsproductpopup 18.929 ms 2.30 Mb
                                                                                                                                      tvcmssearch 1.567 ms 0.16 Mb
                                                                                                                                      tvcmssizechart 0.124 ms 0.01 Mb
                                                                                                                                      tvcmsslider 0.153 ms 0.01 Mb
                                                                                                                                      tvcmsspecialproducts 0.100 ms 0.01 Mb
                                                                                                                                      tvcmsstockinfo 0.187 ms 0.03 Mb
                                                                                                                                      tvcmstabproducts 0.134 ms 0.01 Mb
                                                                                                                                      tvcmstestimonial 0.151 ms 0.01 Mb
                                                                                                                                      tvcmsthemeoptions 0.203 ms 0.01 Mb
                                                                                                                                      tvcmswishlist 4.560 ms 0.18 Mb
                                                                                                                                      ps_googleanalytics 0.573 ms 0.09 Mb
                                                                                                                                      tvcmsinfinitescroll 0.750 ms 0.05 Mb
                                                                                                                                      tvcmsofferbanner 0.244 ms - Mb
                                                                                                                                      tvcmscategoryproduct 0.199 ms 0.01 Mb
                                                                                                                                      tvcmsmegamenu 4.962 ms 0.90 Mb
                                                                                                                                      tvcmscustomcssjs 0.155 ms 0.01 Mb
                                                                                                                                      ps_languageselector 0.621 ms 0.06 Mb
                                                                                                                                      ps_currencyselector 0.253 ms 0.06 Mb
                                                                                                                                      ps_customersignin 0.442 ms 0.06 Mb
                                                                                                                                      ps_contactinfo 0.971 ms 0.12 Mb
                                                                                                                                      tvcmsfootercategory 1.720 ms 0.39 Mb
                                                                                                                                      ps_linklist 0.824 ms 0.10 Mb
                                                                                                                                      ps_customeraccountlinks 0.593 ms 0.09 Mb
                                                                                                                                      statsdata 2.231 ms 0.22 Mb
                                                                                                                                      dgtranslationall 0.272 ms 0.03 Mb
                                                                                                                                      56 module(s) 81.428 ms 10.15 Mb

                                                                                                                                      Stopwatch SQL - 630 queries

                                                                                                                                      # Query Time (ms) Rows Filesort Group By Location
                                                                                                                                      320
                                                                                                                                      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
                                                                                                                                      2.915 ms 200448 Yes /classes/Product.php:3110
                                                                                                                                      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` = 18
                                                                                                                                      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.170 ms 154 Yes Yes /classes/Manufacturer.php:499
                                                                                                                                      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.109 ms 2115 /classes/Configuration.php:180
                                                                                                                                      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.228 ms 746 /classes/Hook.php:456
                                                                                                                                      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.173 ms 214 Yes Yes /classes/Hook.php:1267
                                                                                                                                      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.875 ms 0 /classes/Hook.php:1326
                                                                                                                                      399
                                                                                                                                      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.741 ms 18 Yes /classes/Category.php:799
                                                                                                                                      266
                                                                                                                                      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 = 18 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.592 ms 4158 /classes/Manufacturer.php:430
                                                                                                                                      267
                                                                                                                                      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 (359,207,486,202,203,268,267,233,125,273,259)
                                                                                                                                      0.577 ms 11 /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.521 ms 1 Yes /classes/shop/Shop.php:1364
                                                                                                                                      437
                                                                                                                                      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 (359) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.410 ms 22 Yes Yes /classes/Product.php:4524
                                                                                                                                      537
                                                                                                                                      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 (233) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.408 ms 12 Yes Yes /classes/Product.php:4524
                                                                                                                                      512
                                                                                                                                      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 (268) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.407 ms 8 Yes Yes /classes/Product.php:4524
                                                                                                                                      500
                                                                                                                                      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` = 203
                                                                                                                                      AND pac.`id_product_attribute` = 665
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.402 ms 2 /classes/Product.php:7534
                                                                                                                                      553
                                                                                                                                      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 (125) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.397 ms 12 Yes Yes /classes/Product.php:4524
                                                                                                                                      271
                                                                                                                                      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 (1746, 1747, 1748, 1749, 1750, 1751, 1752, 1753, 1754, 1755, 1756, 1757, 1758, 1759, 1760, 1761, 1762, 1763, 1764, 1765, 1766, 1767) AND il.`id_lang` = 1 ORDER by i.`position`
                                                                                                                                      0.391 ms 44 Yes /classes/Product.php:2921
                                                                                                                                      349
                                                                                                                                      SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
                                                                                                                                      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 AND fl.id_lang = 1)
                                                                                                                                      INNER JOIN ps_feature_shop feature_shop
                                                                                                                                      ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
                                                                                                                                      WHERE pf.id_product = 526
                                                                                                                                      ORDER BY f.position ASC
                                                                                                                                      0.372 ms 1 Yes /classes/Product.php:6021
                                                                                                                                      555
                                                                                                                                      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` = 125
                                                                                                                                      AND pac.`id_product_attribute` = 811
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.364 ms 2 /classes/Product.php:7534
                                                                                                                                      274
                                                                                                                                      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` = 207) AND (b.`id_shop` = 1) LIMIT 1
                                                                                                                                      0.352 ms 1 /src/Adapter/EntityMapper.php:71
                                                                                                                                      623
                                                                                                                                      SELECT SQL_NO_CACHE mainTable.id_tvcmspaymenticon AS code,
                                                                                                                                      mainTable.image,
                                                                                                                                      mainTable.link,
                                                                                                                                      subTable.title
                                                                                                                                      FROM 
                                                                                                                                      `ps_tvcmspaymenticon` mainTable
                                                                                                                                      LEFT JOIN
                                                                                                                                      ps_tvcmspaymenticon_lang subTable
                                                                                                                                      ON
                                                                                                                                      mainTable.id_tvcmspaymenticon = subTable.id_tvcmspaymenticon
                                                                                                                                      WHERE 
                                                                                                                                      mainTable.id_shop_group = 1 
                                                                                                                                      AND 
                                                                                                                                      mainTable.id_shop = 1
                                                                                                                                      AND 
                                                                                                                                      mainTable.status = 1
                                                                                                                                      AND
                                                                                                                                      subTable.id_lang = 1
                                                                                                                                      ORDER BY `position`
                                                                                                                                      0.348 ms 8 Yes /modules/tvcmspaymenticon/tvcmspaymenticon.php:435
                                                                                                                                      348
                                                                                                                                      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` = 526 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` = 526 AND (pr.`pack_stock_type` IN (1,2) OR (
                                                                                                                                      pr.`pack_stock_type` = 3
                                                                                                                                      AND 0 = 1
                                                                                                                                      ))) as q LIMIT 1
                                                                                                                                      0.345 ms 0 /classes/Cart.php:1430
                                                                                                                                      502
                                                                                                                                      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` = 203
                                                                                                                                      AND pac.`id_product_attribute` = 669
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.344 ms 2 /classes/Product.php:7534
                                                                                                                                      306
                                                                                                                                      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` = 273) AND (b.`id_shop` = 1) LIMIT 1
                                                                                                                                      0.341 ms 1 /src/Adapter/EntityMapper.php:71
                                                                                                                                      471
                                                                                                                                      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 (486) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.341 ms 12 Yes Yes /classes/Product.php:4524
                                                                                                                                      130
                                                                                                                                      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
                                                                                                                                      COALESCE(SUM(first_level_quantity), 0) as quantity
                                                                                                                                      FROM (SELECT 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` = 486 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` = 486 AND (pr.`pack_stock_type` IN (1,2) OR (
                                                                                                                                      pr.`pack_stock_type` = 3
                                                                                                                                      AND 0 = 1
                                                                                                                                      ))) as q LIMIT 1
                                                                                                                                      0.339 ms 0 /classes/Cart.php:1430
                                                                                                                                      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.335 ms 146 Yes /classes/Dispatcher.php:654
                                                                                                                                      486
                                                                                                                                      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 (202) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.334 ms 4 Yes Yes /classes/Product.php:4524
                                                                                                                                      162
                                                                                                                                      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` = 203 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` = 203 AND (pr.`pack_stock_type` IN (1,2) OR (
                                                                                                                                      pr.`pack_stock_type` = 3
                                                                                                                                      AND 0 = 1
                                                                                                                                      ))) as q LIMIT 1
                                                                                                                                      0.328 ms 0 /classes/Cart.php:1430
                                                                                                                                      268
                                                                                                                                      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` = 359) AND (b.`id_shop` = 1) LIMIT 1
                                                                                                                                      0.312 ms 1 /src/Adapter/EntityMapper.php:71
                                                                                                                                      525
                                                                                                                                      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 (267) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.307 ms 4 Yes Yes /classes/Product.php:4524
                                                                                                                                      314
                                                                                                                                      SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
                                                                                                                                      ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
                                                                                                                                      ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
                                                                                                                                      0.304 ms 1 /classes/Cart.php:4255
                                                                                                                                      13
                                                                                                                                      SELECT SQL_NO_CACHE lower(name) as name
                                                                                                                                      FROM `ps_hook` h
                                                                                                                                      WHERE (h.active = 1)
                                                                                                                                      0.297 ms 1106 /classes/Hook.php:1366
                                                                                                                                      458
                                                                                                                                      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 (207) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.288 ms 6 Yes Yes /classes/Product.php:4524
                                                                                                                                      513
                                                                                                                                      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` = 268
                                                                                                                                      AND pac.`id_product_attribute` = 1383
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.271 ms 2 /classes/Product.php:7534
                                                                                                                                      554
                                                                                                                                      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` = 125
                                                                                                                                      AND pac.`id_product_attribute` = 809
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.269 ms 2 /classes/Product.php:7534
                                                                                                                                      498
                                                                                                                                      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 (203) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.266 ms 8 Yes Yes /classes/Product.php:4524
                                                                                                                                      526
                                                                                                                                      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` = 267
                                                                                                                                      AND pac.`id_product_attribute` = 1376
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.264 ms 2 /classes/Product.php:7534
                                                                                                                                      538
                                                                                                                                      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` = 233
                                                                                                                                      AND pac.`id_product_attribute` = 883
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.264 ms 2 /classes/Product.php:7534
                                                                                                                                      15
                                                                                                                                      SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
                                                                                                                                      0.263 ms 88 /classes/Hook.php:287
                                                                                                                                      515
                                                                                                                                      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` = 268
                                                                                                                                      AND pac.`id_product_attribute` = 1385
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.262 ms 2 /classes/Product.php:7534
                                                                                                                                      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` = 359
                                                                                                                                      AND pac.`id_product_attribute` = 1757
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.261 ms 2 /classes/Product.php:7534
                                                                                                                                      20
                                                                                                                                      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
                                                                                                                                      FROM `ps_module` m
                                                                                                                                      LEFT JOIN `ps_module_shop` ms
                                                                                                                                      ON m.`id_module` = ms.`id_module`
                                                                                                                                      AND ms.`id_shop` = 1
                                                                                                                                      0.260 ms 145 /classes/module/Module.php:346
                                                                                                                                      487
                                                                                                                                      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` = 202
                                                                                                                                      AND pac.`id_product_attribute` = 655
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.260 ms 2 /classes/Product.php:7534
                                                                                                                                      568
                                                                                                                                      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 (273) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.259 ms 6 Yes Yes /classes/Product.php:4524
                                                                                                                                      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` = 359 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` = 359 AND (pr.`pack_stock_type` IN (1,2) OR (
                                                                                                                                      pr.`pack_stock_type` = 3
                                                                                                                                      AND 0 = 1
                                                                                                                                      ))) as q LIMIT 1
                                                                                                                                      0.254 ms 0 /classes/Cart.php:1430
                                                                                                                                      369
                                                                                                                                      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.252 ms 1 /classes/ProductAssembler.php:64
                                                                                                                                      427
                                                                                                                                      SELECT SQL_NO_CACHE *
                                                                                                                                      FROM ps_meta m
                                                                                                                                      LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
                                                                                                                                      WHERE (
                                                                                                                                      m.page = "best-sales"
                                                                                                                                      OR m.page = "bestsales"
                                                                                                                                      )
                                                                                                                                      AND ml.id_lang = 1
                                                                                                                                      AND ml.id_shop = 1 LIMIT 1
                                                                                                                                      0.252 ms 2 /classes/Meta.php:193
                                                                                                                                      514
                                                                                                                                      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` = 268
                                                                                                                                      AND pac.`id_product_attribute` = 1384
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.249 ms 2 /classes/Product.php:7534
                                                                                                                                      488
                                                                                                                                      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` = 202
                                                                                                                                      AND pac.`id_product_attribute` = 657
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.246 ms 2 /classes/Product.php:7534
                                                                                                                                      438
                                                                                                                                      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` = 359
                                                                                                                                      AND pac.`id_product_attribute` = 1746
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.243 ms 2 /classes/Product.php:7534
                                                                                                                                      501
                                                                                                                                      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` = 203
                                                                                                                                      AND pac.`id_product_attribute` = 667
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.243 ms 2 /classes/Product.php:7534
                                                                                                                                      99
                                                                                                                                      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` = 1757
                                                                                                                                      AND cp.`id_cart` = 0 AND cp.`id_product` = 359 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` = 1757
                                                                                                                                      AND cp.`id_cart` = 0 AND p.`id_product_item` = 359 AND (pr.`pack_stock_type` IN (1,2) OR (
                                                                                                                                      pr.`pack_stock_type` = 3
                                                                                                                                      AND 0 = 1
                                                                                                                                      ))) as q LIMIT 1
                                                                                                                                      0.241 ms 0 /classes/Cart.php:1430
                                                                                                                                      118
                                                                                                                                      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` = 207
                                                                                                                                      AND pac.`id_product_attribute` = 722
                                                                                                                                      AND agl.`id_lang` = 1
                                                                                                                                      0.241 ms 2 /classes/Product.php:7534
                                                                                                                                      305
                                                                                                                                      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 (809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820) AND il.`id_lang` = 1 ORDER by i.`position`
                                                                                                                                      0.239 ms 36 Yes /classes/Product.php:2921
                                                                                                                                      581
                                                                                                                                      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 (259) AND ag.`is_color_group` = 1
                                                                                                                                      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                                                                                                                                      ORDER BY a.`position` ASC;
                                                                                                                                      0.238 ms 6 Yes Yes /classes/Product.php:4524
                                                                                                                                      374
                                                                                                                                      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 (527)
                                                                                                                                      0.235 ms 1 /classes/ProductAssembler.php:64
                                                                                                                                      472
                                                                                                                                      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_attrib