LIVRARE GRATUITĂ LA COMENZI DE PESTE 500 LEI TOATĂ LUNA!
TELEFON: +4 (0737) 166 357
 
Filtre
Preț +{{ activeValues.length-1 }}
- lei
Acumulator +{{ activeValues.length-1 }}
Adancime +{{ activeValues.length-1 }}
Alimentare +{{ activeValues.length-1 }}
Aplicatie mobila +{{ activeValues.length-1 }}
Capacitate incalzie Aer 7 °C / Apă 26 °C / Umiditate 90% +{{ activeValues.length-1 }}
Capacitate incalzie Aer 26°C/ Apă 26°C/ Umiditate 80% +{{ activeValues.length-1 }}
Capacitate incalzie Aer 15°C/ Apă 26°C/ Umiditate 70% +{{ activeValues.length-1 }}
Cantitate +{{ activeValues.length-1 }}
Cablu conectare +{{ activeValues.length-1 }}

Oferte speciale

Abajur lampa sauna Eliga montaj perete
187,00 lei150,00 lei Fără TVA: 150,00 lei

Abajur special conceput pentru sauna, destinat montajului pe perete. Materialul din care este conceput este Pin. Dimensiuni: 280x300x185mm Abajurul nu include lampa si becul aferent. Putere ma..

Adaugă în Coş
Abajur lampa sauna XL montaj perete
225,76 lei169,37 lei Fără TVA: 169,37 lei

Abajur lampa sauna XL montaj perete Date tehnice ale abajurului sauna alungit:Latime aproximativ 230 mmInaltime aproximativ 300 mmAdâncime aproximativ 155 mmGreutate aproximativ 700 grame ..

Adaugă în Coş
Aer conditionat mobil Levita AC7000
1.420,00 lei990,00 lei Fără TVA: 990,00 lei

Temperatură interioară plăcută chiar și în zilele tropicale de vară? Nici o problema! Aparatul de aer condiționat mobil compact LEVITA AC 7000 este potrivit pentru încăperi mai mic..

Adaugă în Coş
Cabina sauna Radiant 120 x 105
23.600,00 lei16.500,00 lei Fără TVA: 16.500,00 lei

O vacanță caldă în casa taCabina cu radiații Harvia Radiant vă permite să vă relaxați în căldură ori de câte ori vă convine cel mai bine. Cabina funcționează pe baza elementelor radiatoare de căl..

Adaugă în Coş
Caramida sare Himalaya 20 x 10 x 5
20,00 lei14,99 lei Fără TVA: 14,99 lei

Cărămizile de sare de Himalaya sunt blocuri solide de sare naturală, extrase din minele de sare din regiunea Himalaya. Acestea sunt cunoscute pentru culoarea lor unică, care variază de la nuanțe de ro..

Adaugă în Coş
Clepsidra cu nisip pentru sauna Harvia Lux
165,00 lei135,00 lei Fără TVA: 135,00 lei

Clepsidra cu nisip Harvia Lux este o notă frumoasă în decorarea saunei dvs. și poate fi folosită pentru a arăta un timp potrivit pentru utilizare sau pur și simplu pentru a vă aminti că timpul trece..

Adaugă în Coş
Clepsidra Harvia din lemn de pin
135,00 lei105,00 lei Fără TVA: 105,00 lei

Clepsidra este gradata si va arata timpul petrecut in sauna.Timpul/Sedinta recomandata este de 15min...

Adaugă în Coş
Clepsidra sauna cu nisip ALB
99,00 lei89,00 lei Fără TVA: 89,00 lei

Clepsidra sauna cu nisip ALB Timp marcat- max 15minCuloare nisip -AlbDimensiuni  60 x 320 x 35 mm  ..

Adaugă în Coş
Clepsidra sauna cu nisip ALBASTRU
99,00 lei89,00 lei Fără TVA: 89,00 lei

Clepsidra sauna cu nisip ALBASTRU Timp marcat- max 15min Culoare nisip -Albastru Dimensiuni  60 x 320 x 35 mm..

Adaugă în Coş
Clepsidra sauna cu nisip NEGRU
99,00 lei89,00 lei Fără TVA: 89,00 lei

Clepsidra sauna cu nisip NEGRUTimp marcat- max 15minCuloare nisip -NegruDimensiuni  60 x 320 x 35 mm..

Adaugă în Coş
Clepsidra sauna cu nisip ROSU
99,00 lei89,00 lei Fără TVA: 89,00 lei

Clepsidra sauna cu nisip ROSU Timp marcat- max 15minCuloare nisip -rosu Dimensiuni  60 x 320 x 35 mm..

Adaugă în Coş
Clepsidra sauna cu nisip VERDE
99,00 lei89,00 lei Fără TVA: 89,00 lei

Clepsidra sauna cu nisip VERDE Timp marcat- max 15minCuloare nisip -VerdeDimensiuni  60 x 320 x 35 mm  ..

Adaugă în Coş
Cristale mentolate pentru sauna Eliga
89,50 lei79,50 lei Fără TVA: 79,50 lei

Cristale mentolate pentru sauna Eliga Cristale mentolate special destinate aromaterapiei in incaperile de saune. Produsul este obtinut prin congelarea uleiului de menta. Așezați câteva cri..

Adaugă în Coş
Derulator prelata pentru piscina cu latime intre 4.00 si 6.50 m
1.650,00 lei1.320,00 lei Fără TVA: 1.320,00 lei

Derulator prelata pentru piscina cu latime intre 4.00 si 6.50 mFaciliteaza manipularea si strangerea prelatelor de vara.Produsul poate fi folosit la orice tip/forma de bazin.Acest model va ofera posib..

Adaugă în Coş
Derulator prelata pentru piscina latime 5.4-7.1
2.653,00 lei1.591,00 lei Fără TVA: 1.591,00 lei

Derulator prelata pentru piscina latime 5.4-7.1Derulator manual pentru prelate piscine.Va ajuta in retragerea prelatei de pe piscina.Se extinde de la 5.4 la 7.1 metri.Diametru tambur 80mm...

Adaugă în Coş
Dozator plutitor standard pentru chimicale
55,00 lei25,00 lei Fără TVA: 25,00 lei

Dozator plutitor standard pentru chimicale  Se foloseste pentru tabletele cu dizolvare lenta.In partea inferioara a dozatorului se poate regla viteza de dizolvare a tabletei.Capacitate produ..

Adaugă în Coş
Duza aeromasaj din inox cu iesire D10mm
85,00 lei65,00 lei Fără TVA: 65,00 lei

Duza aeromasaj din inox cu iesire D10mmUtilizata pentru introducerea aerului din suflante in SPA.Debit de la 5.4 la 7.5 m3/h.Conexiune D10mmMaterial inox..

Adaugă în Coş
Esenta sauna Harvia cu aroma de lamaie
68,50 lei58,50 lei Fără TVA: 58,50 lei

Esenta sauna Harvia cu aroma de lamaieEsenta de sauna Harvia creează o atmosferă care oferă experiențe de saună minunateParfumurile de saună Harvia conțin uleiuri esențiale și creează exact genul..

Adaugă în Coş
Esenta sauna Harvia cu aroma de mar
68,50 lei58,50 lei Fără TVA: 58,50 lei

Esenta sauna Harvia cu aroma de marEsenta de sauna Harvia creează o atmosferă care oferă experiențe de saună minunate.Parfumurile de saună Harvia conțin uleiuri esențiale și creează exact genul..

Adaugă în Coş
Esenta sauna Harvia cu aroma de menta
68,50 lei58,50 lei Fără TVA: 58,50 lei

Esenta sauna Harvia cu aroma de mentaEsenta de sauna Harvia creează o atmosferă care oferă experiențe de saună minunateParfumurile de saună Harvia conțin uleiuri esențiale și creează exact genul ..

Adaugă în Coş
Esenta sauna Harvia cu aroma de mesteacan
68,50 lei58,50 lei Fără TVA: 58,50 lei

Esenta de sauna Harvia creează o atmosferă care oferă experiențe de saună minunateParfumurile de saună Harvia conțin uleiuri esențiale și creează exact genul de atmosferă pe care ți-o dorești în sauna..

Adaugă în Coş
Galeata din lemn de pin 4L pentru sauna
231,31 lei185,00 lei Fără TVA: 185,00 lei

Galeata din lemn de pin 4L pentru saunaGaleata de 4 l de sauna merge cu sauna asa cum apa se duce cu pietrele.Asociați sauna dvs. cu o găleată tradițională din lemn, proiectată și finisată cu mare ate..

Adaugă în Coş
Generator aburi Harvia Helix 11kw
12.995,00 lei11.050,00 lei Fără TVA: 11.050,00 lei

Generator aburi Harvia Helix 11kwSetul include un generator de abur, panou de control, senzor temperatura si o duza de abur.Sunt produse de o calitate superioara, cu un design compact, fiind utilizate..

Adaugă în Coş
Generator aburi Harvia Helix 15kw
14.359,00 lei12.205,00 lei Fără TVA: 12.205,00 lei

Setul include un generator de abur, panou de control, senzor temperatura si o duza de abur.Sunt produse de o calitate superioara, cu un design compact, fiind utilizate atat pentru saune private cat si..

Adaugă în Coş
Generator aburi Harvia Helix 4.5kw
10.027,00 lei8.523,55 lei Fără TVA: 8.523,55 lei

Generator aburi Harvia Helix 4.5kwSetul include un generator de abur, panou de control, senzor temperatura si o duza de abur.Sunt produse de o calitate superioara, cu un design compact, fiind utilizat..

Adaugă în Coş
Generator aburi Harvia Helix 6kw
11.197,80 lei9.520,00 lei Fără TVA: 9.520,00 lei

Generator aburi Harvia Helix 6kwSetul include un generator de abur, panou de control, senzor temperatura si o duza de abur.Sunt produse de o calitate superioara, cu un design compact, fiind utilizate ..

Adaugă în Coş
Generator aburi Harvia Helix 9kw
12.561,00 lei10.650,00 lei Fără TVA: 10.650,00 lei

Generator aburi Harvia Helix 9kwSetul include un generator de abur, panou de control, senzor temperatura si o duza de abur.Sunt produse de o calitate superioara, cu un design compact, fiind utilizate ..

Adaugă în Coş
Grilaj aerisire pentru sauna din Pin Harvia
105,00 lei95,00 lei Fără TVA: 95,00 lei

Grilaj aerisire pentru sauna din Pin Harvia Grila de aerisire pentru sauna Harvia se monteaza in peretele saunei in partea exterioara. Fabricat din lemn tratat sa reziste la temperatura inalta a ..

Adaugă în Coş
Incalzitor sauna Harvia Pro 10,5 Kw
4.282,27 lei3.700,00 lei Fără TVA: 3.700,00 lei

Incalzitor sauna Harvia Pro 10,5 KwSe conecteaza pe o instalatie trifazica.Este destinat saunelor publice.Este necesar conectarea printr-un panou extern de comanda.Rocile vulcanice nu sunt incluse in ..

Adaugă în Coş
Incalzitor sauna Harvia Pro 13,5 Kw
4.710,00 lei3.900,00 lei Fără TVA: 3.900,00 lei

Incalzitor sauna Harvia Pro 13,5 KwSe conecteaza pe o instalatie trifazica.Este destinat saunelor publice.Este necesar conectarea printr-un panou extern de comanda.Rocile vulcanice nu sunt incluse in ..

Adaugă în Coş
Incalzitor sauna Harvia Pro 16,5 Kw
5.006,70 lei4.230,00 lei Fără TVA: 4.230,00 lei

Incalzitor sauna Harvia Pro 16,5 KwSe conecteaza pe o instalatie trifazica.Este destinat saunelor publice.Este necesar conectarea printr-un panou extern de comanda.Rocile vulcanice nu sunt incluse in ..

Adaugă în Coş
Incalzitor sauna Harvia Vega BC 45, comanda exterioara, 4,5kw inox
1.626,60 lei1.275,00 lei Fără TVA: 1.275,00 lei

Harvia Vega este un incalzitor modern si usor de utilizat, fiind produs de catre cel mai mare producator de incalzitoare de sauna din lume.Invelisul exterior este confectionat din otel inoxidabil ce i..

Adaugă în Coş
Incalzitor sauna Harvia Vega BC 45, comanda integrata, 4,5kw inox
1.588,40 lei1.400,00 lei Fără TVA: 1.400,00 lei

Harvia Vega este un incalzitor modern si usor de utilizat, fiind produs de catre cel mai mare producator de incalzitoare de sauna din lume.Invelisul exterior este confectionat din otel inoxidabil ce i..

Adaugă în Coş
Incalzitor sauna Harvia Vega BC 60, comanda exterioara, 6,0kw inox
1.712,50 lei1.450,00 lei Fără TVA: 1.450,00 lei

Harvia Vega este un incalzitor modern si usor de utilizat, fiind produs de catre cel mai mare producator de incalzitoare de sauna din lume.Invelisul exterior este confectionat din otel inoxidabil ce i..

Adaugă în Coş
Incalzitor sauna Harvia Vega BC 60, comanda integrata, 6,0kw inox
2.055,00 lei1.725,00 lei Fără TVA: 1.725,00 lei

Harvia Vega este un incalzitor modern si usor de utilizat, fiind produs de catre cel mai mare producator de incalzitoare de sauna din lume.Invelisul exterior este confectionat din otel inoxidabil ce i..

Adaugă în Coş
Incalzitor sauna Harvia Vega BC 80, comanda exterioara, 8,0kw inox
1.890,40 lei1.350,00 lei Fără TVA: 1.350,00 lei

Harvia Vega este un incalzitor modern si usor de utilizat, fiind produs de catre cel mai mare producator de incalzitoare de sauna din lume.Invelisul exterior este confectionat din otel inoxidabil ce i..

Adaugă în Coş
Incalzitor sauna Harvia Vega BC 90, comanda exterioara, 9,0kw inox
1.925,40 lei1.450,00 lei Fără TVA: 1.450,00 lei

Harvia Vega este un incalzitor modern si usor de utilizat, fiind produs de catre cel mai mare producator de incalzitoare de sauna din lume.Invelisul exterior este confectionat din otel inoxidabil ce i..

Adaugă în Coş
Incalzitor sauna Harvia Vega BC 90, comanda integrata, 9,0kw inox
1.819,44 lei1.725,00 lei Fără TVA: 1.725,00 lei

Harvia Vega este un incalzitor modern si usor de utilizat, fiind produs de catre cel mai mare producator de incalzitoare de sauna din lume.Invelisul exterior este confectionat din otel inoxidabil ce i..

Adaugă în Coş
Incalzitor sauna pe lemne Harvia M3
2.531,20 lei2.199,00 lei Fără TVA: 2.199,00 lei

Cu design clasic, Incalzitorul Harvia M3 atrage privirea și este potrivit pentru o  saună încălzită cu lemne. Căldura uniformă degajată de incalzitor și circulația eficientă a aerului garanteaz..

Adaugă în Coş
Kit filtru cu pompa Gre - 4mc/h
1.190,00 lei952,00 lei Fără TVA: 952,00 lei

Kit filtru cu pompa Gre - 4mc/hGama de filtre cu nisip GRE este o gamă de filtre compacte ușor de instalat și utilizat, care nu necesită o atenție specială și se adaptează oricărei piscine supraterane..

Adaugă în Coş
Kit filtru cu pompa Gre - 6mc/h
1.336,00 lei1.068,80 lei Fără TVA: 1.068,80 lei

Kit filtru cu pompa Gre - 6mc/hGama de filtre cu nisip GRE este o gamă de filtre compacte ușor de instalat și utilizat, care nu necesită o atenție specială și se adaptează oricărei piscine supraterane..

Adaugă în Coş
Kit filtru cu pompa Gre - 8mc/h
2.158,00 lei1.726,40 lei Fără TVA: 1.726,40 lei

Kit filtru cu pompa Gre - 8mc/hGama de filtre cu nisip GRE este o gamă de filtre compacte ușor de instalat și utilizat, care nu necesită o atenție specială și se adaptează oricărei piscine supraterane..

Adaugă în Coş
Kit filtru piscina D600 Galactic cu pompa Sena 12mc/h
2.920,00 lei1.750,00 lei Fără TVA: 1.750,00 lei

Caracteristici : Confectionat din polietilenă de înaltă densitate;Culoare - Gri antracit;Presiune de lucru - 1.2- 1.5bar;Presiune maxima de lucru - 2.4 bar;Pompa Sena monofazata 230 V 50 Hz ..

Adaugă în Coş
Kit sistem iluminat 1 LED RGB pentru jacuzi/ciubar
1.200,00 lei880,00 lei Fără TVA: 880,00 lei

Un sistem de iluminare RGB cu 1 LED pentru jacuzzi sau ciubar este un dispozitiv modern conceput pentru a adăuga o atmosferă vibrantă și personalizată spațiilor de relaxare cu apă. Acesta folosește te..

Adaugă în Coş
Kit sistem iluminat 10 LED-uri RGB pentru jacuzi/ciubar
2.000,00 lei1.350,00 lei Fără TVA: 1.350,00 lei

Un sistem de iluminare RGB cu 10 LED-uri pentru jacuzzi sau ciubar este un dispozitiv modern conceput pentru a adăuga o atmosferă vibrantă și personalizată spațiilor de relaxare cu apă. Acesta foloseș..

Adaugă în Coş
Lambriu pentru sauna molid lungime 2,1m
30,41 lei28,50 lei Fără TVA: 28,50 lei

Produs de inalta calitate, destinat in mod special constructiei sau renovarii incaperilor de sauna traditionale. Lambriul are o structura omogena, finisat pe o latura, cu nut si feter, fiind usor d..

Adaugă în Coş
Lambriu pentru sauna molid lungime 2,4m
34,75 lei31,50 lei Fără TVA: 31,50 lei

Produs de inalta calitate, destinat in mod special constructiei sau renovarii incaperilor de sauna traditionale. Lambriul are o structura omogena, finisat pe o latura, cu nut si feter, fiind usor d..

Adaugă în Coş
Lampa pentru sauna EOS Oval
99,00 lei79,00 lei Fără TVA: 79,00 lei

Lampa de perete, rezistenta la apa si la caldura, cu protectie din sticla si soclu bec din portelan.Rezistenta la temperaturi inalte e pana la 150gr C.Protectie IP54Potrivit pentru:Abajur sauna mic..

Adaugă în Coş
Lampa pentru sauna HARVIA
136,00 lei118,50 lei Fără TVA: 118,50 lei

Lampa pentru sauna HARVIAAceasta lampa pentru sauna este cu un design frumos si usor de montat.Este recomandat ca lampa sa fie utilizata impreuna cu abajurul fabricat din lemn.Puterea maxima a becului..

Adaugă în Coş
Lemn Abachi pentru sauna
40,90 lei36,50 lei Fără TVA: 36,50 lei

Abachi este un lemn de origine Africana utilizat in cabinele de sauna la constructia de banchete, tetiere, spatare, gratar de protectie pentru incalzitorul saunei chiar si abajururi pentru lampi.Lemnu..

Adaugă în Coş
Lingura de lemn pentru sauna
109,38 lei98,50 lei Fără TVA: 98,50 lei

Lingura de lemn pentru saunaDimensiune - 36 cmCu ajutorul acestei linguri va puteti delecta in sauna Dvs. creand abur cu diverse arome.Preturile contin TVA.Poza este cu caracter orientativ...

Adaugă în Coş
Panou de comanda sauna C150
1.776,50 lei1.510,00 lei Fără TVA: 1.510,00 lei

Panou de comanda sauna C150Panou de comanda pentru incalzitoarele electrice cu un consum de maxim 15kw.Design elegant, culoare CREM.Acest panou afisaza temperatura, temperatua setata si timpul de util..

Adaugă în Coş
Panou de comanda sauna C90
1.718,59 lei1.460,00 lei Fără TVA: 1.460,00 lei

Panou de comanda sauna C90Panou de comanda pentru incalzitoarele electrice cu un consum de maxim 9kw.Design elegant, culoare CREM.Acest panou afisaza temperatura, temperatua setata si timpul de utiliz..

Adaugă în Coş
Panou Xenio digital de comanda pentru sauna CX110 2.3 - 11 kw, Harvia
2.840,50 lei2.350,00 lei Fără TVA: 2.350,00 lei

Panou Xenio digital de comanda pentru sauna CX110 2.3-11 kw, HarviaPanoul de control al unitatii de control Xenio ofera o interfata moderna si subtire eleganta pentru controlul saunei, fie ca este vor..

Adaugă în Coş
Pietre pentru incalzitor sauna - roca vulcanica 20kg, Harvia
150,00 lei99,00 lei Fără TVA: 99,00 lei

Este necesara utilizarea acestor pietre pentru incalzitoare electrice sau sobe pe lemne, deoarece acestea pot inmagazina caldura si pot evapora treptat apa.Datorita acestor pietre, durata de viata a r..

Adaugă în Coş
Pietre pentru incalzitor sauna - roca vulcanica Harvia 20kg 10-15cm
145,00 lei120,00 lei Fără TVA: 120,00 lei

Este necesara utilizarea acestor pietre in incalzitoare, deoarece acestea pot inmagazina caldura si pot evapora treptat apa.Datorita acestor pietre, durata de viata a rezistentelor este mare.Aceste pi..

Adaugă în Coş
Piscina 3D gonflabila cu dimensiunea de 305x76cm, accesorii: 2 bucati de ochelari 3D
335,00 lei275,00 lei Fără TVA: 275,00 lei

Piscina pentru copii cu efect 3D uimitor .Inclusiv 2 bucati de ochelari 3D de inot. Ochelari de inot pot fi de asemenea folositi ca o ochelari de inot obisnuiti. O piscina in forma rotunda, care ..

Adaugă în Coş
Pompa de caldura Fairland Inver-X110T volum 90 - 160 mc cu Wifi
39.950,00 lei35.500,00 lei Fără TVA: 35.500,00 lei

Noua generație a pompelor de căldură InverX de la Fairland garantează eficiența energetică a încălzirii piscinelor, cu o performanță COP 20 unică în lume.Mulțumită celor trei moduri de funcț..

Adaugă în Coş
Pompa de caldura Fairland Inver-X26 volum 20 - 40 mc cu Wifi
11.950,00 lei10.200,00 lei Fără TVA: 10.200,00 lei

Noua generație a pompelor de căldură InverX de la Fairland garantează eficiența energetică a încălzirii piscinelor, cu o performanță COP 20 unică în lume.Mulțumită celor trei moduri de funcționare, ..

Adaugă în Coş
Pompa de caldura Fairland Inver-X36 volum 25 - 50 mc cu Wifi
16.450,00 lei14.100,00 lei Fără TVA: 14.100,00 lei

Noua generație a pompelor de căldură InverX de la Fairland garantează eficiența energetică a încălzirii piscinelor, cu o performanță COP 20 unică în lume.Mulțumită celor trei moduri de funcționare, ..

Adaugă în Coş
Pompa de caldura Fairland Inver-X46 volum 30 - 60 mc cu Wifi
20.450,00 lei17.999,00 lei Fără TVA: 17.999,00 lei

Noua generație a pompelor de căldură InverX de la Fairland garantează eficiența energetică a încălzirii piscinelor, cu o performanță COP 20 unică în lume.Mulțumită celor trei moduri de funcționare, ..

Adaugă în Coş
Pompa de caldura Fairland Inver-X56 volum 40 - 75 mc cu Wifi
25.450,00 lei22.500,00 lei Fără TVA: 22.500,00 lei

Noua generație a pompelor de căldură InverX de la Fairland garantează eficiența energetică a încălzirii piscinelor, cu o performanță COP 20 unică în lume.Mulțumită celor trei moduri de funcț..

Adaugă în Coş
Pompa de caldura Fairland Inver-X66 volum 55 - 100 mc cu Wifi
29.950,00 lei26.900,00 lei Fără TVA: 26.900,00 lei

Noua generație a pompelor de căldură InverX de la Fairland garantează eficiența energetică a încălzirii piscinelor, cu o performanță COP 20 unică în lume.Mulțumită celor trei moduri de funcț..

Adaugă în Coş
Pompa de caldura Fairland Inver-X80T volum 65 - 120 mc cu Wifi
33.450,00 lei30.100,00 lei Fără TVA: 30.100,00 lei

Noua generație a pompelor de căldură InverX de la Fairland garantează eficiența energetică a încălzirii piscinelor, cu o performanță COP 20 unică în lume.Mulțumită celor trei moduri de funcț..

Adaugă în Coş
Pompa de caldura Fairland INVERTER Comfortline BPNCR07 volum 15 - 30 mc
5.445,00 lei4.573,00 lei Fără TVA: 4.573,00 lei

Pompele de caldura Inverter PLUS sunt concepute sa functioneze la temperaturi de peste 0gr. celsius; Compresor Inverter DC; Serpentina de titan cu 50% mai lunga, functionare cu 50% mai eficient;&nb..

Adaugă în Coş
Pompa de caldura Fairland INVERTER Comfortline BPNCR09 volum 20 - 35 mc
7.345,00 lei6.800,00 lei Fără TVA: 6.800,00 lei

Pompele de caldura Inverter PLUS sunt concepute sa functioneze la temperaturi de peste 0gr. celsius;Compresor Inverter DC;Serpentina de titan cu 50% mai lunga, functionare cu 50% mai eficient; Ca..

Adaugă în Coş
Pompa de caldura Fairland INVERTER Comfortline BPNCR13 volum 30 - 50 mc
9.995,00 lei8.995,00 lei Fără TVA: 8.995,00 lei

Pompele de caldura Inverter PLUS sunt concepute sa functioneze la temperaturi de peste 0gr. celsius;Compresor Inverter DC;Serpentina de titan cu 50% mai lunga, functionare cu 50% mai eficient; Ca..

Adaugă în Coş
Pompa de caldura Fairland INVERTER Comfortline BPNCR17 volum 35 - 65 mc
12.345,00 lei11.100,00 lei Fără TVA: 11.100,00 lei

Pompele de caldura Inverter PLUS sunt concepute sa functioneze la temperaturi de peste 0gr. celsius;Compresor Inverter DC;Serpentina de titan cu 50% mai lunga, functionare cu 50% mai eficient; Ca..

Adaugă în Coş
Pompa de caldura Fairland INVERTER Comfortline BPNCR21 volum 45 - 80 mc
14.495,00 lei12.999,00 lei Fără TVA: 12.999,00 lei

Pompele de caldura Inverter PLUS sunt concepute sa functioneze la temperaturi de peste 0gr. celsius;Compresor Inverter DC;Serpentina de titan cu 50% mai lunga, functionare cu 50% mai eficient; Ca..

Adaugă în Coş
Pompa de caldura Fairland Mini-SHP03 volum pana la 20 mc
2.825,00 lei2.400,00 lei Fără TVA: 2.400,00 lei

Noile modele de pompe de căldură pentru piscine, Fairland Mini, folosesc un agent refrigerant R32 care are proprietăți îmbunătățite de răcire, reducând consumul de energie. Datorită vâscozității și d..

Adaugă în Coş
Pompa de caldura Fariland Mini-SHP05 volum pana la 28 mc
3.475,00 lei3.000,00 lei Fără TVA: 3.000,00 lei

Noile modele de pompe de caldura pentru piscine Fairland Mini folosesc un agent refrigerant R32 care are proprietati inbunatatite de racire, reducand consumul de energie.Datorita vascozitatii si desni..

Adaugă în Coş
Pompa de caldura Fariland Mini-SHP06 volum pana la 35 mc
3.975,00 lei3.500,00 lei Fără TVA: 3.500,00 lei

Noile modele de pompe de caldura pentru piscine Fairland Mini folosesc un agent refrigerant R32 care are proprietati inbunatatite de racire, reducand consumul de energie.Datorita vascozitatii si desni..

Adaugă în Coş
Pompa de caldura Mountfield BP-30WS volum pana la 18 mc
2.900,00 lei2.300,00 lei Fără TVA: 2.300,00 lei

Pompa de caldura BP-30WS este proiectata exclusiv pentru incalzirea apei din bazin si mentinerea temperaturii sale economice. Prin intermediul unui ciclu de compresie si extinderea fluidului de transf..

Adaugă în Coş
Pompa de caldura Mountfield Inverter Azuro 10 KW + WIFI, volum 30 - 50 mc
7.675,00 lei6.950,00 lei Fără TVA: 6.950,00 lei

Cu ajutorul acestei pompei de căldură inverter Azurro de 10 KW + WIFi puteți crește temperatura apei din piscină și prelungi sezonul de imbaiere.Pompa de caldura este recomandata pentru piscine de pan..

Adaugă în Coş
Pompa de caldura Mountfield Inverter Azuro 12 KW, volum 40 - 60 mc
8.233,31 lei7.400,00 lei Fără TVA: 7.400,00 lei

Cu ajutorul pompei de căldură inverter Azuro de 12 KW puteți crește temperatura apei din piscină și prelungi sezonul de imbaiere.Pompa de caldura este recomandata pentru piscine de pana la 60m3.Reușeș..

Adaugă în Coş
Pompa de caldura Mountfield Inverter Azuro 16 KW, volum 50 - 70 mc
11.872,93 lei10.600,00 lei Fără TVA: 10.600,00 lei

Cu ajutorul pompei de căldură inverter Azurro de 16 KW puteți crește temperatura apei din piscină și prelungi sezonul de imbaiere.Pompa de caldura este recomandata pentru piscine de pana la 70m3.Reușe..

Adaugă în Coş
Regulator nivel apa NIVA 5S
3.100,00 lei2.083,00 lei Fără TVA: 2.083,00 lei

Regulator nivel apa NIVA 5SRegulatorul de nivel Niva 5S se folosesti in cazul piscinelor cu preaplin pentru mentinerea unui nivel costant de apa in bazinul de compensare.Specificatii tehnice: Ali..

Adaugă în Coş
Robot pentru curatarea piscinei Maytronics Dolphin
4.090,00 lei3.050,00 lei Fără TVA: 3.050,00 lei

Robotul de curățare a piscinelor Dolphin, conceput special pentru piscine supraterane sau subterane cu dimensiuni mici și cu fund plat sau în pantă ușoară. Acest robot drop and go este ușor și foa..

Adaugă în Coş
Robot pentru curatarea piscinei Maytronics Dolphin E10
4.215,00 lei2.990,00 lei Fără TVA: 2.990,00 lei

Modelul Dolphin E10 este robotul de vis, la un preț accesibil. Acest tip de robot, deosebit de ușor, este ideal pentru toate tipurile de piscine, inclusiv și pentru piscinele construite deasupra nivel..

Adaugă în Coş
Robot pentru curatarea piscinei Maytronics Dolphin M700
11.545,00 lei8.800,00 lei Fără TVA: 8.800,00 lei

Robotul de curățat piscine M Line, robustețe și performanță, intr-un cuvant DolphinCere ce este mai bun pentru piscina ta. Familia de roboti de curățat pentru piscină Dolphin M Line a fost concepută p..

Adaugă în Coş
Robot pentru curatarea piscinei Maytronics Dolphin S100
5.095,00 lei4.050,00 lei Fără TVA: 4.050,00 lei

Uită de curățarea manuală a podelei piscinei sau eliminarea frunzelor și a mizeriei. Dolphin S100 face totul pentru tine, automat. Apa din piscină rămâne curată, gata pentru a fi utilizată.Avantaje:- ..

Adaugă în Coş
Robot pentru curatarea piscinei Maytronics Dolphin S300I
8.245,00 lei Fără TVA: 8.245,00 lei

Robotul Dolphin S300i este soluția optimă pentru curățirea meticuloasă a piscinei, în orice condiții. Învață cum să navigheze, alegând soluția de detectare cea mai bună, se adaptează la forma pisci..

Adaugă în Coş
Robot pentru curatarea piscinei Maytronics Dolphin Supreme M200
4.845,00 lei3.990,00 lei Fără TVA: 3.990,00 lei

Soluția ideală pentru piscinele rezidențiale cu lungime de până la 10 m. Curăță eficient pardoseala și max.40 cm din pereți. Cablu cu pivotare ce împiedică răsucire a pe timpul funcționării. Ac..

Adaugă în Coş
Robot pentru curatarea piscinei Mountfield Azuro Warrior 2
3.450,00 lei2.999,00 lei Fără TVA: 2.999,00 lei

Proiectat pentru toate tipurile de piscine, robotul Warrion este cel mai exclusivist model din gama de aspiratoare  electrice.Acest aspirator ofera o gama larga de facilitati pentru a mentine apa..

Adaugă în Coş
Sauna Finlandeza LOKI 198x168x211cm
17.460,00 lei13.450,00 lei Fără TVA: 13.450,00 lei

Sauna Finlandeza LOKIModelul de saună cu dimensiuni medii oferă suficient spațiu pentru relaxare confortabilă și tratament cu saună folosind metoda scandinavă pe două șezlonguri cu o lungime de 178..

Adaugă în Coş
Sauna finlandeza ODIN 156x156x211cm
13.935,50 lei11.150,00 lei Fără TVA: 11.150,00 lei

Sauna finlandeza ODINModelul de saună cu dimensiuni medii oferă suficient spațiu pentru relaxare confortabilă și tratament folosind metoda scandinavă pe două șezlonguri. Sauna Odin este fabricată în..

Adaugă în Coş
Sauna Finlandeza THOR 198x198x211cm
18.495,00 lei14.250,00 lei Fără TVA: 14.250,00 lei

Sauna Finlandeza Thor 198x198x211cmModelul Thor oferă suficient spațiu pentru relaxare confortabilă și tratament cu saună folosind metoda scandinavă pe două șezlonguri cu o lungime de 178 cm la o în..

Adaugă în Coş
Sauna Finlandeza VALI 215x215x211cm
20.125,50 lei15.250,00 lei Fără TVA: 15.250,00 lei

Sauna Finlandeza VALI 215x215x211cmModelul Váli cu o cabină foarte spațioasă este soluția ideală, datorită căreia nu trebuie să faceți compromisuri în timpul procedurii de relaxare și saună! Vă pute..

Adaugă în Coş
Sauna Grenada 2 Infrarosu 120x120x194
7.000,00 lei5.945,00 lei Fără TVA: 5.945,00 lei

Sauna Grenada 2 Infrarosu 120x120x194, fabricat din cedru rosu canadian si usa din sticlaInfrasauna modernă Grenada este potrivită pentru una sau două persoane. Această infrasaună oferă patru rad..

Adaugă în Coş
Sauna Infrarosu Mariana 97x87x186cm
5.580,00 lei4.775,60 lei Fără TVA: 4.775,60 lei

Sauna Infrarosu Mariana 97x87x186cm, fabricat din Hemlock canadian si usa din sticlaAceastă infrasaună este poarta de acces la saună - este cel mai ieftin model din oferta noastră. Infrasauna Mar..

Adaugă în Coş
Sauna Lily 2 Infrarosu 130x105x195cm
8.250,00 lei6.965,00 lei Fără TVA: 6.965,00 lei

Sauna Lily 2 Infrarosu 130x105x195cm, fabricat din cedru rosu canadian si usa din sticlaPlacile MDF au fost folosite pentru a face cabina, iar interiorul din lemn  canadian. Culoarea elegant..

Adaugă în Coş
Senzor de temperatura panou comanda sauna Harvia
436,00 lei400,00 lei Fără TVA: 400,00 lei

Acest tip de senzor este compatibil cu urmatoarele tipuri de panouri de comanda: HARVIA C90, HARVIA C150, HARVIA GRIFFIN, HARVIA Griffin Combi, etc.Senzorul Nu include  cablu.Atentie:Verificati c..

Adaugă în Coş
Senzor de temperatura pentru panou comanda Harvia
735,00 lei500,00 lei Fără TVA: 500,00 lei

Acest tip de senzor este compatibil cu urmatoarele tipuri de panouri de comanda: HARVIA C90, HARVIA C150, HARVIA GRIFFIN, HARVIA Griffin Combi, etc.Senzorul include cablu siliconic 2ml.Atentie:Verific..

Adaugă în Coş
Set accesorii pentru sauna din pin alb Round
490,00 lei400,00 lei Fără TVA: 400,00 lei

Design modern si materiale de calitate, fac din acest set cel mai cautat accesoriu pentru saune.Pachetul include:Polonic - 1 buc;Galeata 3l- 1 buc;Termohigrometru - 1 buc;Clepsidra - 1 buc;Reguli lami..

Adaugă în Coş
Set accesorii pentru sauna din pin alb Square
490,00 lei400,00 lei Fără TVA: 400,00 lei

Design modern si materiale de calitate, fac din acest set cel mai cautat accesoriu pentru saune.Pachetul include:Polonic - 1 buc;Galeata 3l- 1 buc;Termohigrometru - 1 buc;Clepsidra - 1 buc;Reguli lami..

Adaugă în Coş
Set accesorii sauna HARVIA
680,50 lei599,99 lei Fără TVA: 599,99 lei

Un accesoriu nelipsit din saune, produse create din pin.Pachetul contine:1- galeata 4l  1 - polonic 1 - termo-higrometru1 - clepsidra..

Adaugă în Coş
Set accesorii sauna Sentiotec
430,00 lei375,00 lei Fără TVA: 375,00 lei

Un accesoriu nelipsit din saune, produse create din pin.Pachetul contine:1- galeata 3l  1 - polonic 1 - termo-higrometru1 - clepsidra..

Adaugă în Coş
Set horn pentru soba pe lemne Harvia WHP 1500
3.000,00 lei2.499,00 lei Fără TVA: 2.499,00 lei

Coșul de fum din oțel este o soluție elegantă si necesara pentru evacuarea fumului.Coșul de fum din oțel rezistă la schimbările extinse de temperatură și a fost proiectat în principal pentru a fi u..

Adaugă în Coş
Sistem inot contracurent 70mc/h
4.400,00 lei2.963,00 lei Fără TVA: 2.963,00 lei

Sistem inot contracurent 70mc/hCu o putere ridicata a jetului, ofera unei piscine de mici dimensiuni mai multe intrebuintari si nu numai.Caracteristici:- performanta 70m3/ora,- monofazic sau trif..

Adaugă în Coş
Soba sauna pe lemne H20PRO, Harvia
4.550,00 lei4.000,00 lei Fără TVA: 4.000,00 lei

Harvia 20 Pro ofera infuzii puternice in saune de dimensiuni medii.Are o camera de piatra mare si o coroana din otel inoxidabil.Prin usa de sticla din fonta, lumina calda a focului poate patrunde in a..

Adaugă în Coş
Talpa aspirare ovala OCEAN
90,00 lei71,50 lei Fără TVA: 71,50 lei

Perie cap aspirator OCEANPeria de aspirat manuala este diferentiata de altele prin greutatea ei de 2kg care ii ofera o stabilitate in functionare.Datorita formei ovale, aceasta se integreaza perfect i..

Adaugă în Coş
Termo-higrometru Harvia din pin pentru sauna
215,00 lei190,00 lei Fără TVA: 190,00 lei

Termo-higrometru Harvia din pin pentru saunaO modalitate simpla si rapida pentru a vedea temperatura si umiditatea din sauna...

Adaugă în Coş
Termometru sauna Basic rotund
95,00 lei85,00 lei Fără TVA: 85,00 lei

Termometru sauna Basic rotund Termometru rotund din plastic rezistent la temperaturi inalte.   Diametru 10cm Termometrele noastre sunt calibrate într-un interval 20-120gr Celsius. A..

Adaugă în Coş
Tester electronic fotometric PoolLab 1.0
1.150,00 lei950,00 lei Fără TVA: 950,00 lei

Testerul electronic PoolLab 1.0 este un fotometru cu trei de lungimi de unda ( 530/ 570/ 620nm ) pentru analiza profesionala a apei din piscinele private si spa-uri. PoolLab 1.0 are gradul de imp..

Adaugă în Coş
Tester electronic fotometric PoolLab 2.0
1.200,00 lei1.000,00 lei Fără TVA: 1.000,00 lei

PoolLab 2.0 este soluția perfectă pentru analiza profesională a apei din piscine și spa-uri. Cuveta de măsurare triplă fixă, dar schimbabilă, permite prelevarea rapidă a probelor prin simpla scufundar..

Adaugă în Coş
Usa ventilatie pentru sauna din Pin Harvia
125,00 lei99,00 lei Fără TVA: 99,00 lei

Grilajul de ventilatie de la Harvia este o soluție convenabilă și funcțională pentru gaura de aerisire a saunei. Ca bonus, sistemul adaugă și o notă elegantă  de decorare a saunei. Grilajul e..

Adaugă în Coş
Afişare 1 - 15 din 106 (8 pagini)
SAL SOL
Queries: 3429, Total time: 510.386 ms [By time] [By id] [By file]
1 (0.233)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/latuapiscina/public_html/catalog/model/design/translation.php:6
2 (0.143)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/latuapiscina/public_html/system/library/openbay.php:61
3 (0.433)
SELECT `data`
FROM `oc_session`
WHERE session_id = '372d201e2323800ef5381f79eb' AND expire > 1708864577
/home/latuapiscina/public_html/system/library/session/db.php:21
4 (0.103)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://latuapiscina.ro/'
/home/latuapiscina/storage/modification/catalog/controller/startup/startup.php:6
5 (2.632)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/latuapiscina/storage/modification/catalog/controller/startup/startup.php:26
6 (0.130)
SELECT *
FROM oc_currency
/home/latuapiscina/public_html/system/library/cart/currency.php:10
7 (0.281)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2692')
ORDER BY tr1.priority ASC
/home/latuapiscina/public_html/system/library/cart/tax.php:16
8 (0.214)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2692')
ORDER BY tr1.priority ASC
/home/latuapiscina/public_html/system/library/cart/tax.php:44
9 (0.166)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/home/latuapiscina/public_html/system/library/cart/weight.php:10
10 (0.148)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/home/latuapiscina/public_html/system/library/cart/length.php:10
11 (0.711)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 MONTH)
/home/latuapiscina/storage/modification/system/library/cart/cart.php:15
12 (0.142)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
13 (0.129)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
14 (0.159)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:440
15 (0.135)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:1050
16 (0.136)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
17 (0.126)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
18 (0.135)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:440
19 (0.132)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:1050
20 (0.129)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
21 (0.126)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
22 (0.138)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:440
23 (0.130)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:1050
24 (0.127)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
25 (0.126)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
26 (0.131)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:440
27 (0.130)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:1050
28 (0.173)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
29 (0.127)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
30 (0.139)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:440
31 (0.131)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:1050
32 (0.127)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
33 (0.126)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
34 (0.139)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:440
35 (0.131)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:1050
36 (0.128)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
37 (0.128)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
38 (0.134)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:440
39 (0.144)
SELECT *
FROM oc_seo_url
WHERE keyword = 'reduceri' AND language_id = 1 AND store_id = 0
/home/latuapiscina/public_html/system/library/google_marketing_tools/master.php:1050
40 (0.111)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/latuapiscina/public_html/system/library/openbay.php:61
41 (0.116)
SELECT *
FROM oc_cart
WHERE session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/catalog/controller/startup/startup.php:231
42 (0.125)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '372d201e2323800ef5381f79eb'
/home/latuapiscina/storage/modification/system/library/cart/cart.php:36
43 (0.319)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/latuapiscina/public_html/catalog/model/setting/event.php:4
44 (0.181)
SELECT redirect, language_id
FROM oc_url_redirect
WHERE query = 'https://latuapiscina.ro/reduceri' OR query = '/reduceri' OR (redirect LIKE 'product/product&product_id=%' AND query = '/reduceri') LIMIT 1
/home/latuapiscina/storage/modification/catalog/controller/startup/seo_url.php:98
45 (0.130)
SELECT *
FROM oc_seo_url
WHERE query LIKE 'route=%' AND keyword = 'reduceri'
/home/latuapiscina/storage/modification/catalog/controller/startup/seo_url.php:263
46 (0.191)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/special' OR route = 'ro-ro')
/home/latuapiscina/public_html/catalog/model/design/translation.php:6
47 (0.138)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'basel/basel_theme' OR route = 'ro-ro')
/home/latuapiscina/public_html/catalog/model/design/translation.php:6
48 (0.132)
SELECT redirect, language_id
FROM oc_url_absolute
WHERE query = 'common/home' AND language_id = '1'
/home/latuapiscina/storage/modification/catalog/controller/startup/seo_url.php:728
49 (0.117)
SELECT redirect, language_id
FROM oc_url_absolute
WHERE query = 'product/special' AND language_id = '1'
/home/latuapiscina/storage/modification/catalog/controller/startup/seo_url.php:728
50 (0.130)
SELECT keyword
FROM oc_seo_url
WHERE `query` = 'route=product/special'
/home/latuapiscina/storage/modification/catalog/controller/startup/seo_url.php:879
51 (0.120)
SELECT redirect, language_id
FROM oc_url_absolute
WHERE query = 'product/compare' AND language_id = '1'
/home/latuapiscina/storage/modification/catalog/controller/startup/seo_url.php:728
52 (0.110)
SELECT keyword
FROM oc_seo_url
WHERE `query` = 'route=product/compare'
/home/latuapiscina/storage/modification/catalog/controller/startup/seo_url.php:879
53 (0.658)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1167' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
54 (0.124)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
55 (0.575)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1160' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
56 (0.113)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
57 (0.541)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1523' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
58 (0.102)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '14' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
59 (0.551)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '904' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
60 (0.101)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
61 (0.587)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '631' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
62 (0.101)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
63 (0.562)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2182' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
64 (0.102)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
65 (0.538)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '628' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
66 (0.102)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
67 (0.539)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1164' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
68 (0.124)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
69 (0.552)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1165' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
70 (0.113)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
71 (0.684)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1962' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
72 (0.102)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
73 (0.516)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1163' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
74 (0.100)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
75 (0.558)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1162' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
76 (0.085)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
77 (0.537)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1166' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
78 (0.081)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '49' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
79 (0.497)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1495' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
80 (0.088)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
81 (0.522)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1572' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
82 (0.072)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
83 (0.496)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '186' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
84 (0.070)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '26' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
85 (0.483)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1599' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
86 (0.069)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
87 (0.482)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2079' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
88 (0.071)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
89 (0.510)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2077' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
90 (0.086)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
91 (0.544)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2078' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
92 (0.070)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
93 (0.507)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '19739' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
94 (0.073)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
95 (0.489)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '624' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
96 (0.081)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
97 (0.507)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1706' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
98 (0.073)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
99 (0.492)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1707' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
100 (0.111)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
101 (0.589)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '636' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
102 (0.106)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
103 (0.529)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1708' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
104 (0.111)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
105 (0.539)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1709' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
106 (0.114)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
107 (0.546)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1180' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
108 (0.108)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
109 (0.571)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '610' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
110 (0.105)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
111 (0.559)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1716' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
112 (0.104)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
113 (0.558)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1717' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
114 (0.104)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
115 (0.575)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '110' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
116 (0.103)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
117 (0.539)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '114' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
118 (0.104)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
119 (0.531)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
120 (0.107)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
121 (0.537)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '113' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
122 (0.103)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
123 (0.547)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
124 (0.099)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
125 (0.760)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '107' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
126 (0.098)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
127 (0.562)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '111' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
128 (0.095)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
129 (0.548)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1178' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
130 (0.096)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
131 (0.526)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1724' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
132 (0.108)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '50' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
133 (0.550)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1725' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
134 (0.106)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '50' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
135 (0.687)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1726' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
136 (0.081)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '50' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
137 (0.505)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1470' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
138 (0.067)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '13' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
139 (0.846)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '19641' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
140 (0.074)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
141 (0.500)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '19639' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
142 (0.066)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
143 (0.495)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1177' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
144 (0.074)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
145 (0.485)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1176' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
146 (0.064)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
147 (0.592)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2185' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
148 (0.079)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '65' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
149 (0.501)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '633' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
150 (0.209)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
151 (0.502)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '630' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
152 (0.070)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
153 (0.480)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '629' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
154 (0.078)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '11' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
155 (0.493)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '615' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
156 (0.064)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
157 (0.489)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '616' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
158 (0.063)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
159 (0.540)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '443' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
160 (0.092)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
161 (0.475)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '627' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
162 (0.064)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
163 (0.564)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2100' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
164 (0.064)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '23' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
165 (0.473)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '216' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
166 (0.066)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '14' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
167 (0.460)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2216' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
168 (0.063)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '31' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
169 (0.583)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2151' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/latuapiscina/storage/modification/catalog/model/catalog/product.php:8
170 (0.091)
SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '31' AND store_id = '0' AND language_id = '1'
/home/latuapiscina/public_html/catalog/model/tool/seo_package.php:371
171 (0.657)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS<