articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Mulineta PENN Spinfisher VII Long Cast, 7500
Exclusiv online!

Mulineta PENN Spinfisher VII Long Cast, 7500

1595352
Livrare 14-21 zile

1.207,89Lei

Mulineta PENN Spinfisher VII Long Cast, 6500
Exclusiv online!

Mulineta PENN Spinfisher VII Long Cast, 6500

1595351
Livrare 14-21 zile

1.118,90Lei

Mulineta PENN Spinfisher VII Long Cast, 5500
Exclusiv online!

Mulineta PENN Spinfisher VII Long Cast, 5500

1595350
Livrare 14-21 zile

1.073,90Lei

Centura PENN Gimbal Belt
Exclusiv online!

Centura PENN Gimbal Belt

1589214
Livrare 14-21 zile

152,90Lei

Lanseta PENN Overseas II Boat Rod, 2.10m, 400g, 4seg
Exclusiv online!

Lanseta PENN Overseas II Boat Rod, 2.10m, 400g, 4seg

1579599
Livrare 14-21 zile

566,90Lei

Lanseta PENN Overseas II Boat Rod, 2.10m, 300g, 4seg
Exclusiv online!

Lanseta PENN Overseas II Boat Rod, 2.10m, 300g, 4seg

1579598
Livrare 14-21 zile

566,90Lei

Lanseta PENN Overseas II Boat Rod, 2.10m, 200g, 4seg
Exclusiv online!

Lanseta PENN Overseas II Boat Rod, 2.10m, 200g, 4seg

1579597
Livrare 14-21 zile

522,90Lei

Mulineta Penn Wrath BX, 2500

Mulineta Penn Wrath BX, 2500

1596327
Livrare imediată!

283,90Lei

Mulineta Penn Wrath BX, 3000

Mulineta Penn Wrath BX, 3000

1596328
Livrare imediată!

304,90Lei

Mulineta Penn Wrath BX, 6000

Mulineta Penn Wrath BX, 6000

1595357
Livrare imediată!

348,90Lei

Mulineta PENN Vantage Spod 8000

Mulineta PENN Vantage Spod 8000

1639273
Livrare imediată!

833,90Lei

Mulineta Penn Wrath BX, 4000

Mulineta Penn Wrath BX, 4000

1596329
Livrare imediată!

304,90Lei

Mulineta PENN Slammer Classic 260

Mulineta PENN Slammer Classic 260

1601677
Livrare imediată!

435,90Lei

Mulineta Penn Rival Gold 7000LC
Exclusiv online!

Mulineta Penn Rival Gold 7000LC

1524486
Livrare 14-21 zile

566,90Lei

Mulineta PENN Authority Spinning 5500HS
Exclusiv online!

Mulineta PENN Authority Spinning 5500HS

1613901
Livrare 14-21 zile

2.460,90Lei

Mulineta PENN Slammer Classic 360
Exclusiv online!

Mulineta PENN Slammer Classic 360

1601678
Livrare 14-21 zile

479,90Lei

Mulineta PENN Spinfisher VII, 10500
Exclusiv online!

Mulineta PENN Spinfisher VII, 10500

1612620
Livrare 14-21 zile

971,90Lei

Mulineta PENN Spinfisher VII, 4500
Exclusiv online!

Mulineta PENN Spinfisher VII, 4500

1612614
Livrare 14-21 zile

786,90Lei

Mulineta PENN Spinfisher VII, 5500
Exclusiv online!

Mulineta PENN Spinfisher VII, 5500

1612615
Livrare 14-21 zile

833,90Lei

Lanseta PENN Carnage II Viking Edition Halibuster, 2.21m, 50lbs, 1+1buc
Exclusiv online!

Lanseta PENN Carnage II Viking Edition Halibuster, 2.21m, 50lbs, 1+1buc

1620443
Livrare 14-21 zile

1.604,90Lei

Afişare 1 - 20 din 500 (25 pagini)
Consimtamant
Detalii
Despre

Acest site utilizeaza cookie-uri

Pentru scopuri precum afisarea de continut personalizat, folosim module cookie sau tehnologii similare. Apasand Accept, esti de acord sa permiti colectarea de informatii prin cookie-uri sau tehnologii similare. Afla in sectiunea Prelucrarea datelor GDPR mai multe despre cookie-uri, inclusiv despre posibilitatea retragerii acordului.
Folosim cookie-uri pentru functionarea corecta a site-ului si, cu acordul tau, pentru personalizarea continutului si a reclamelor, precum si pentru analiza de trafic. Poti alege ce tipuri de cookie-uri accepti, iar setarile pot fi modificate oricand. Afla cum foloseste Google datele tale si consults Politica noastra de confidentialitate

Necesare Activat

Cookie-urile necesare ajuta la functionarea corecta a site-ului (navigare, autentificare, cos de cumparaturi, limba).
Durata: sesiune - 1 an
Furnizor: claumarpescar.ro
Tip: HTTP / Local Storage


Preferinte Nesetat

Memoreaza alegerile utilizatorului (limba, locatie, moneda, filtrare produse, sesiuni preferate).
Durata: 1 an
Furnizor: claumarpescar.ro
Tip: HTTP / Local Storage


Statistici Nesetat

Colecteaza date anonime despre utilizarea site-ului pentru a imbunatati experienta (ex: pagini vizitate, durata sesiunii).
Durata: 1 an
Furnizor: Google Analytics, Google Tag Manager
Tip: HTTP / Pixel


Marketing Nesetat

Utilizeaza cookie-uri pentru publicitate personalizata (remarketing, conversii, masurare campanii).
Durata: 1 an
Furnizor: Google Ads, Meta (Facebook), TikTok Ads
Tip: Pixel / HTTP / Local Storage

Cookie-urile sunt mici fisiere de text ce pot fi utilizate de catre site-urile web pentru a face utilizarea lor mai eficienta.
Legea stipuleaza ca putem stoca cookie-uri pe dispozitivul dvs., in cazul in care ele sunt strict necesare pentru operarea acestui site. Pentru toate celelalte tipuri de cookie-uri avem nevoie de permisiunea dvs.
Acest site utilizeaza diferite tipuri de cookie-uri. Unele cookie-uri sunt plasate de catre servicii parti terte care apar pe paginile noastre.
Puteti, in orice moment, sa modificati sau sa va retrageti acordul din Declaratia privind modulele cookie de pe website-ul nostru.
Aflati mai multe despre cine suntem, cum ne puteti contacta si cum procesam datele personale in Politica noastra de confidentialitate.
Cand ne contactati in legatura cu consimtamantul dvs., va rugam sa precizati ID-ul si data consimtamantului dat.
In conformitate cu Regulamentul (UE) 2016/679 (GDPR), Legea nr. 190/2018 si Legea nr. 506/2004, prelucrarea datelor personale prin cookie-uri se face doar cu acordul tau. Pentru mai multe detalii privind modul in care Google utilizeaza datele colectate prin serviciile sale (Google Ads, Analytics etc.), te rugam sa consulti aceasta pagina oficiala Google.

💬
WhatsApp Chat
👋 Salut! Cu ce va pot ajuta?

Pot raspunde la intrebari despre:
✅ Comenzi si status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 125, Total time: 31.274 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '7850ea86c0c14562626a7531db'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.122)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1016
3 (1.118)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("256716", "1", "1000", "88", "1", "998.26", "1"),("256717", "1", "1000", "88", "1", "924.71", "2"),("255921", "1", "1000", "88", "1", "887.52", "3"),("257642", "1", "1000", "88", "1", "126.36", "4"),("257659", "1", "1000", "88", "1", "468.51", "5"),("257661", "1", "1000", "88", "1", "468.51", "6"),("257663", "1", "1000", "88", "1", "432.15", "7"),("191505", "1", "1002", "88", "1", "234.63", "8"),("191509", "1", "1002", "88", "1", "251.98", "9"),("191513", "1", "1002", "88", "1", "288.35", "10"),("252720", "1", "1002", "88", "1", "689.17", "11"),("191511", "1", "1001", "88", "1", "251.98", "12"),("259160", "1", "1001", "88", "1", "360.25", "13"),("141195", "1", "1000", "88", "1", "468.51", "14"),("259071", "1", "1000", "88", "1", "2033.8", "15"),("259147", "1", "1000", "88", "1", "396.61", "16"),("255918", "1", "1000", "88", "1", "803.22", "17"),("255919", "1", "1000", "88", "1", "650.33", "18"),("255920", "1", "1000", "88", "1", "689.17", "19"),("258925", "1", "1000", "88", "1", "1326.36", "20"),("258927", "1", "1000", "88", "1", "1326.36", "21"),("258929", "1", "1000", "88", "1", "1326.36", "22"),("255924", "1", "1000", "88", "1", "180.08", "23"),("256709", "1", "1000", "88", "1", "765.21", "24"),("256710", "1", "1000", "88", "1", "727.19", "25"),("256711", "1", "1000", "88", "1", "650.33", "26"),("256712", "1", "1000", "88", "1", "612.31", "27"),("150899", "1", "1", "88", "1", "278.43", "28"),("259032", "1", "1000", "88", "1", "765.21", "29"),("259033", "1", "1000", "88", "1", "765.21", "30"),("259034", "1", "1000", "88", "1", "765.21", "31"),("259035", "1", "1000", "88", "1", "765.21", "32"),("227945", "2", "1000", "88", "1", "689.17", "33"),("257187", "1", "1000", "88", "1", "468.51", "34"),("257188", "1", "1000", "88", "1", "468.51", "35"),("257189", "1", "1000", "88", "1", "432.15", "36"),("257656", "1", "1000", "88", "1", "468.51", "37"),("257657", "1", "1000", "88", "1", "468.51", "38"),("257658", "1", "1000", "88", "1", "432.15", "39"),("260187", "1", "1000", "88", "1", "348.68", "40"),("260189", "1", "1000", "88", "1", "243.72", "41"),("256723", "1", "1001", "88", "1", "813.97", "42"),("178294", "2", "1000", "88", "1", "739.59", "43"),("258743", "1", "1000", "88", "1", "1294.13", "44"),("258744", "1", "1000", "88", "1", "2958.6", "45"),("258745", "1", "1000", "88", "1", "2773.47", "46"),("258746", "1", "1000", "88", "1", "2588.35", "47"),("256713", "1", "1000", "88", "1", "765.21", "48"),("256715", "1", "1000", "88", "1", "650.33", "49"),("256719", "1", "1000", "88", "1", "924.71", "50"),("256720", "1", "1000", "88", "1", "887.52", "51"),("256722", "1", "1000", "88", "1", "887.52", "52"),("256724", "1", "1000", "88", "1", "776.78", "53"),("257155", "1", "1000", "88", "1", "1664.38", "54"),("257185", "1", "1000", "88", "1", "468.51", "55"),("257186", "1", "1000", "88", "1", "432.15", "56"),("178293", "2", "1000", "88", "1", "666.03", "57"),("233552", "1", "1000", "88", "1", "612.31", "58"),("233553", "1", "1000", "88", "1", "612.31", "59"),("254191", "1", "1031", "88", "1", "396.61", "60"),("254193", "1", "1021", "88", "1", "432.15", "61"),("254192", "1", "1014", "88", "1", "396.61", "62"),("197387", "1", "1015", "88", "1", "703.22", "63"),("197395", "1", "1010", "88", "1", "739.59", "64"),("197397", "1", "1009", "88", "1", "776.78", "65"),("258840", "1", "1000", "88", "1", "650.33", "66"),("258841", "1", "1000", "88", "1", "612.31", "67"),("259024", "1", "1000", "88", "1", "765.21", "68"),("259029", "1", "1000", "88", "1", "689.17", "69"),("259030", "1", "1000", "88", "1", "689.17", "70"),("259031", "1", "1000", "88", "1", "689.17", "71"),("259036", "1", "1000", "88", "1", "765.21", "72"),("259056", "1", "1000", "88", "1", "765.21", "73"),("259057", "1", "1000", "88", "1", "765.21", "74"),("256464", "2", "1000", "88", "1", "432.15", "75"),("256467", "1", "1000", "88", "1", "432.15", "76"),("256468", "1", "1000", "88", "1", "396.61", "77"),("256658", "1", "1000", "88", "1", "650.33", "78"),("256659", "1", "1000", "88", "1", "612.31", "79"),("256660", "1", "1000", "88", "1", "540.41", "80"),("257153", "1", "1000", "88", "1", "650.33", "81"),("257154", "1", "1000", "88", "1", "650.33", "82"),("257648", "1", "1000", "88", "1", "504.05", "83"),("257649", "1", "1000", "88", "1", "504.05", "84"),("257650", "1", "1000", "88", "1", "468.51", "85"),("257651", "1", "1000", "88", "1", "468.51", "86"),("257652", "1", "1000", "88", "1", "468.51", "87"),("257654", "1", "1000", "88", "1", "432.15", "88"),("257655", "1", "1000", "88", "1", "396.61", "89"),("256453", "1", "1000", "88", "1", "396.61", "90"),("256481", "1", "1001", "88", "1", "162.73", "91"),("259027", "1", "1000", "88", "1", "650.33", "92"),("256471", "1", "1000", "88", "1", "198.26", "93"),("256473", "1", "1000", "88", "1", "162.73", "94"),("256474", "1", "1000", "88", "1", "270.17", "95"),("256475", "1", "1000", "88", "1", "251.98", "96"),("256480", "1", "1000", "88", "1", "180.08", "97"),("256661", "1", "1000", "88", "1", "468.51", "98"),("256663", "1", "1000", "88", "1", "432.15", "99"),("256665", "1", "1000", "88", "1", "504.05", "100"),("256667", "1", "1000", "88", "1", "468.51", "101"),("235405", "1", "1000", "88", "1", "157.77", "102"),("235406", "1", "1000", "88", "1", "157.77", "103"),("257148", "1", "1000", "88", "1", "650.33", "104"),("257149", "1", "1000", "88", "1", "612.31", "105"),("257151", "1", "1000", "88", "1", "650.33", "106"),("257152", "1", "1000", "88", "1", "612.31", "107"),("258766", "1", "1000", "88", "1", "480.91", "108"),("211065", "1", "1027", "88", "1", "998.26", "109"),("197399", "1", "1020", "88", "1", "998.26", "110"),("197391", "1", "1019", "88", "1", "961.9", "111"),("197401", "1", "1011", "88", "1", "1035.45", "112"),("225517", "2", "1000", "88", "1", "689.17", "113"),("258842", "1", "1000", "88", "1", "468.51", "114"),("258843", "1", "1000", "88", "1", "1479.26", "115"),("259061", "1", "1000", "88", "1", "803.22", "116"),("256646", "1", "1000", "88", "1", "1479.26", "117"),("256649", "1", "1000", "88", "1", "1479.26", "118"),("256652", "1", "1000", "88", "1", "1479.26", "119"),("257150", "1", "1000", "88", "1", "650.33", "120"),("150841", "1", "1002", "88", "1", "468.51", "121"),("150845", "1", "1000", "88", "1", "432.15", "122"),("150839", "1", "5", "88", "1", "432.15", "123"),("150843", "1", "4", "88", "1", "504.05", "124"),("254194", "1", "1002", "88", "1", "306.53", "125"),("254198", "1", "1002", "88", "1", "324.71", "126"),("254199", "1", "1002", "88", "1", "324.71", "127"),("256389", "1", "1000", "88", "1", "765.21", "128"),("256390", "1", "1000", "88", "1", "765.21", "129"),("256391", "1", "1000", "88", "1", "765.21", "130"),("256461", "1", "1000", "88", "1", "198.26", "131"),("256476", "1", "1000", "88", "1", "251.98", "132"),("256477", "1", "1000", "88", "1", "234.63", "133"),("256478", "1", "1000", "88", "1", "216.45", "134"),("256639", "1", "1000", "88", "1", "650.33", "135"),("256640", "1", "1000", "88", "1", "612.31", "136"),("256641", "1", "1000", "88", "1", "612.31", "137"),("256642", "1", "1000", "88", "1", "540.41", "138"),("256645", "1", "1000", "88", "1", "612.31", "139"),("256726", "1", "1000", "88", "1", "612.31", "140"),("257177", "1", "1000", "88", "1", "432.15", "141"),("257179", "1", "1000", "88", "1", "396.61", "142"),("257183", "1", "1000", "88", "1", "612.31", "143"),("254195", "1", "1000", "88", "1", "360.25", "144"),("254196", "1", "1000", "88", "1", "360.25", "145"),("254197", "1", "1000", "88", "1", "396.61", "146"),("256455", "1", "1000", "88", "1", "432.15", "147"),("257182", "1", "1000", "88", "1", "612.31", "148"),("257184", "1", "1000", "88", "1", "432.15", "149"),("120333", "1", "1000", "88", "1", "432.15", "150"),("198995", "1", "1002", "88", "1", "468.51", "151"),("177269", "1", "1001", "88", "1", "2218.93", "152"),("198993", "1", "1001", "88", "1", "432.15", "153"),("177216", "1", "1000", "88", "1", "1072.64", "154"),("177219", "1", "1000", "88", "1", "1109.83", "155"),("177221", "1", "1000", "88", "1", "1294.13", "156"),("177223", "1", "1000", "88", "1", "1294.13", "157"),("177224", "1", "1000", "88", "1", "1294.13", "158"),("177253", "1", "1000", "88", "1", "1664.38", "159"),("177260", "1", "1000", "88", "1", "1664.38", "160"),("177261", "1", "1000", "88", "1", "1848.68", "161"),("177262", "1", "1000", "88", "1", "1848.68", "162"),("177263", "1", "1000", "88", "1", "1848.68", "163"),("177264", "1", "1000", "88", "1", "2033.8", "164"),("177265", "1", "1000", "88", "1", "2033.8", "165"),("177266", "1", "1000", "88", "1", "2033.8", "166"),("177267", "1", "1000", "88", "1", "2218.93", "167"),("177268", "1", "1000", "88", "1", "2218.93", "168"),("177270", "1", "1000", "88", "1", "2218.93", "169"),("198997", "1", "1000", "88", "1", "504.05", "170"),("177220", "1", "2", "88", "1", "1109.83", "171"),("259026", "1", "1000", "88", "1", "650.33", "172"),("256443", "1", "1000", "88", "1", "468.51", "173"),("256444", "1", "1000", "88", "1", "432.15", "174"),("256445", "1", "1000", "88", "1", "468.51", "175"),("256446", "1", "1000", "88", "1", "432.15", "176"),("256447", "1", "1000", "88", "1", "396.61", "177"),("256448", "1", "1000", "88", "1", "468.51", "178"),("256449", "1", "1000", "88", "1", "432.15", "179"),("256451", "1", "1000", "88", "1", "432.15", "180"),("256452", "1", "1000", "88", "1", "396.61", "181"),("256454", "1", "1000", "88", "1", "468.51", "182"),("256457", "1", "1000", "88", "1", "468.51", "183"),("256458", "1", "1000", "88", "1", "468.51", "184"),("256460", "1", "1000", "88", "1", "468.51", "185"),("232350", "1", "1000", "88", "1", "504.05", "186"),("120335", "1", "1000", "88", "1", "529.67", "187"),("141193", "1", "1000", "88", "1", "563.55", "188"),("196045", "1", "1000", "88", "1", "591.65", "189"),("196047", "1", "1000", "88", "1", "628.84", "190"),("178324", "1", "1001", "88", "1", "650.33", "191"),("198299", "1", "1001", "88", "1", "727.19", "192"),("176737", "2", "1000", "88", "1", "3202.4", "193"),("176738", "2", "1000", "88", "1", "3403.22", "194"),("176739", "2", "1000", "88", "1", "3403.22", "195"),("176740", "2", "1000", "88", "1", "3603.22", "196"),("176741", "2", "1000", "88", "1", "3603.22", "197"),("176744", "2", "1000", "88", "1", "4604.05", "198"),("176745", "2", "1000", "88", "1", "6204.88", "199"),("176746", "2", "1000", "88", "1", "3202.4", "200"),("176748", "2", "1000", "88", "1", "3202.4", "201"),("176754", "2", "1000", "88", "1", "3202.4", "202"),("176756", "2", "1000", "88", "1", "3202.4", "203"),("176757", "2", "1000", "88", "1", "3202.4", "204"),("176759", "2", "1000", "88", "1", "3403.22", "205"),("176760", "2", "1000", "88", "1", "3403.22", "206"),("176761", "2", "1000", "88", "1", "3603.22", "207"),("176762", "2", "1000", "88", "1", "4604.05", "208"),("176763", "2", "1000", "88", "1", "6204.88", "209"),("178927", "1", "1000", "88", "1", "689.17", "210"),("178929", "1", "1000", "88", "1", "803.22", "211"),("178930", "1", "1000", "88", "1", "842.07", "212"),("196627", "2", "1000", "88", "1", "851.16", "213"),("232359", "1", "1000", "88", "1", "114.79", "214"),("232360", "1", "1000", "88", "1", "114.79", "215"),("232361", "1", "1000", "88", "1", "114.79", "216"),("232362", "1", "1000", "88", "1", "95.79", "217"),("232363", "1", "1000", "88", "1", "95.79", "218"),("232364", "1", "1000", "88", "1", "95.79", "219"),("168781", "2", "1", "88", "1", "113.14", "220"),("177039", "2", "1000", "88", "1", "1294.13", "221"),("178989", "2", "1000", "88", "1", "851.16", "222"),("178991", "2", "1000", "88", "1", "887.52", "223"),("178995", "2", "1000", "88", "1", "924.71", "224"),("178999", "2", "1000", "88", "1", "1035.45", "225"),("179022", "2", "1000", "88", "1", "1294.13", "226"),("189189", "1", "1000", "88", "1", "418.1", "227"),("195227", "1", "1000", "88", "1", "924.71", "228"),("195229", "1", "1000", "88", "1", "924.71", "229"),("195231", "1", "1000", "88", "1", "998.26", "230"),("195233", "1", "1000", "88", "1", "1035.45", "231"),("195235", "1", "1000", "88", "1", "1109.83", "232"),("195237", "1", "1000", "88", "1", "1032.98", "233"),("195239", "1", "1000", "88", "1", "1035.45", "234"),("232369", "1", "1000", "88", "1", "480.91", "235"),("232370", "1", "1000", "88", "1", "480.91", "236"),("232371", "1", "1000", "88", "1", "480.91", "237"),("169519", "1", "1002", "88", "1", "468.51", "238"),("188661", "1", "1001", "88", "1", "612.31", "239"),("176676", "2", "1000", "88", "1", "1294.13", "240"),("176677", "2", "1000", "88", "1", "1294.13", "241"),("176678", "2", "1000", "88", "1", "1294.13", "242"),("225514", "1", "1000", "88", "1", "650.33", "243"),("178256", "2", "1000", "88", "1", "1035.45", "244"),("178257", "2", "1000", "88", "1", "1109.83", "245"),("179019", "2", "1000", "88", "1", "1109.83", "246"),("179020", "2", "1000", "88", "1", "1109.83", "247"),("185685", "2", "1000", "88", "1", "360.25", "248"),("185689", "2", "1000", "88", "1", "396.61", "249"),("185691", "2", "1000", "88", "1", "432.15", "250"),("192599", "1", "1000", "88", "1", "612.31", "251"),("192713", "1", "1000", "88", "1", "650.33", "252"),("195241", "1", "1000", "88", "1", "924.71", "253"),("195243", "1", "1000", "88", "1", "998.26", "254"),("195245", "1", "1000", "88", "1", "1035.45", "255"),("195247", "1", "1000", "88", "1", "924.71", "256"),("195249", "1", "1000", "88", "1", "1035.45", "257"),("196573", "1", "1000", "88", "1", "727.19", "258"),("236157", "1", "1000", "88", "1", "468.51", "259"),("236158", "1", "1000", "88", "1", "468.51", "260"),("233545", "1", "1000", "88", "1", "504.05", "261"),("233546", "1", "1000", "88", "1", "504.05", "262"),("233547", "1", "1000", "88", "1", "504.05", "263"),("169527", "2", "1", "88", "1", "39.59", "264"),("234717", "1", "1014", "88", "1", "157.77", "265"),("197389", "1", "1007", "88", "1", "739.59", "266"),("234719", "1", "1003", "88", "1", "157.77", "267"),("187329", "1", "1002", "88", "1", "396.61", "268"),("187351", "1", "1001", "88", "1", "468.51", "269"),("195503", "1", "1001", "88", "1", "887.52", "270"),("176680", "2", "1000", "88", "1", "1109.83", "271"),("176681", "2", "1000", "88", "1", "1294.13", "272"),("176682", "2", "1000", "88", "1", "1294.13", "273"),("176765", "2", "1000", "88", "1", "1294.13", "274"),("176766", "2", "1000", "88", "1", "1294.13", "275"),("177249", "1", "1000", "88", "1", "1479.26", "276"),("177250", "1", "1000", "88", "1", "1479.26", "277"),("177251", "1", "1000", "88", "1", "1479.26", "278"),("198375", "2", "1000", "88", "1", "504.05", "279"),("198377", "2", "1000", "88", "1", "468.51", "280"),("179021", "2", "1000", "88", "1", "1294.13", "281"),("179026", "2", "1000", "88", "1", "998.26", "282"),("187331", "1", "1000", "88", "1", "396.61", "283"),("187343", "1", "1000", "88", "1", "396.61", "284"),("187349", "1", "1000", "88", "1", "432.15", "285"),("187353", "1", "1000", "88", "1", "468.51", "286"),("187355", "1", "1000", "88", "1", "504.05", "287"),("189139", "1", "1000", "88", "1", "432.15", "288"),("195495", "1", "1000", "88", "1", "813.97", "289"),("195501", "1", "1000", "88", "1", "887.52", "290"),("234718", "1", "1000", "88", "1", "157.77", "291"),("234720", "1", "1000", "88", "1", "157.77", "292"),("158481", "1", "1010", "88", "1", "54.46", "293"),("235713", "1", "1008", "88", "1", "157.77", "294"),("177246", "1", "1000", "88", "1", "1479.26", "295"),("177247", "1", "1000", "88", "1", "1479.26", "296"),("198379", "2", "1000", "88", "1", "540.41", "297"),("225515", "1", "1000", "88", "1", "765.21", "298"),("189095", "1", "1000", "88", "1", "468.51", "299"),("189349", "1", "1000", "88", "1", "504.05", "300"),("192595", "1", "1000", "88", "1", "612.31", "301"),("192707", "1", "1000", "88", "1", "612.31", "302"),("235672", "1", "1000", "88", "1", "432.15", "303"),("235673", "1", "1000", "88", "1", "396.61", "304"),("235674", "1", "1000", "88", "1", "360.25", "305"),("235675", "1", "1000", "88", "1", "324.71", "306"),("235712", "1", "1000", "88", "1", "157.77", "307"),("232355", "1", "1000", "88", "1", "295.79", "308"),("232356", "1", "1000", "88", "1", "295.79", "309"),("232357", "1", "1000", "88", "1", "295.79", "310"),("232358", "1", "1000", "88", "1", "295.79", "311"),("232365", "1", "1000", "88", "1", "259.42", "312"),("232366", "1", "1000", "88", "1", "259.42", "313"),("232367", "1", "1000", "88", "1", "259.42", "314"),("232368", "1", "1000", "88", "1", "259.42", "315"),("158479", "2", "13", "88", "1", "36.28", "316"),("189263", "1", "2", "88", "1", "278.43", "317"),("189151", "1", "1", "88", "1", "243.72", "318"),("189353", "1", "1", "88", "1", "341.24", "319"),("169513", "1", "1", "88", "1", "371.82", "320"),("187533", "1", "1001", "88", "1", "432.15", "321"),("187535", "1", "1000", "88", "1", "432.15", "322"),("187539", "1", "1000", "88", "1", "504.05", "323"),("192441", "1", "1000", "88", "1", "540.41", "324"),("192443", "1", "1000", "88", "1", "540.41", "325"),("192583", "1", "1000", "88", "1", "396.61", "326"),("195337", "1", "1000", "88", "1", "727.19", "327"),("195339", "1", "1000", "88", "1", "765.21", "328"),("195341", "1", "1000", "88", "1", "765.21", "329"),("195343", "1", "1000", "88", "1", "765.21", "330"),("196051", "2", "1000", "88", "1", "591.65", "331"),("196053", "2", "1000", "88", "1", "628.84", "332"),("196055", "2", "1000", "88", "1", "628.84", "333"),("196057", "2", "1000", "88", "1", "703.22", "334"),("196059", "2", "1000", "88", "1", "628.84", "335"),("196061", "2", "1000", "88", "1", "628.84", "336"),("196063", "2", "1000", "88", "1", "703.22", "337"),("196579", "1", "1000", "88", "1", "880.08", "338"),("196581", "1", "1000", "88", "1", "880.08", "339"),("196595", "2", "1000", "88", "1", "703.22", "340"),("196611", "2", "1000", "88", "1", "813.97", "341"),("196613", "2", "1000", "88", "1", "776.78", "342"),("196633", "1", "1000", "88", "1", "689.17", "343"),("232314", "1", "1000", "88", "1", "432.15", "344"),("232315", "1", "1000", "88", "1", "468.51", "345"),("232316", "1", "1000", "88", "1", "468.51", "346"),("233555", "1", "1000", "88", "1", "1326.36", "347"),("233556", "1", "1000", "88", "1", "1326.36", "348"),("233557", "1", "1000", "88", "1", "1326.36", "349"),("188655", "1", "7", "88", "1", "483.39", "350"),("187537", "1", "2", "88", "1", "468.51", "351"),("176606", "1", "1000", "88", "1", "1338.76", "352"),("176607", "1", "1000", "88", "1", "1530.5", "353"),("166910", "1", "1022", "88", "1", "72.64", "354"),("238568", "1", "1000", "88", "1", "803.22", "355"),("238569", "1", "1000", "88", "1", "803.22", "356"),("238570", "1", "1000", "88", "1", "803.22", "357"),("166288", "2", "1000", "88", "1", "54.46", "358"),("179527", "1", "1000", "88", "1", "689.17", "359"),("179528", "1", "1000", "88", "1", "727.19", "360"),("179529", "1", "1000", "88", "1", "689.17", "361"),("179530", "1", "1000", "88", "1", "689.17", "362"),("179532", "1", "1000", "88", "1", "765.21", "363"),("192429", "1", "1000", "88", "1", "540.41", "364"),("192431", "1", "1000", "88", "1", "650.33", "365"),("192433", "1", "1000", "88", "1", "650.33", "366"),("192559", "1", "1000", "88", "1", "540.41", "367"),("192561", "1", "1000", "88", "1", "540.41", "368"),("192717", "1", "1000", "88", "1", "540.41", "369"),("196583", "1", "1000", "88", "1", "765.21", "370"),("236047", "1", "1000", "88", "1", "306.53", "371"),("236088", "1", "1000", "88", "1", "306.53", "372"),("236089", "1", "1000", "88", "1", "288.35", "373"),("236090", "1", "1000", "88", "1", "324.71", "374"),("232317", "1", "1000", "88", "1", "650.33", "375"),("232318", "1", "1000", "88", "1", "650.33", "376"),("232319", "1", "1000", "88", "1", "689.17", "377"),("232320", "1", "1000", "88", "1", "689.17", "378"),("232321", "1", "1000", "88", "1", "727.19", "379"),("232342", "1", "1000", "88", "1", "540.41", "380"),("232343", "1", "1000", "88", "1", "612.31", "381"),("232345", "1", "1000", "88", "1", "650.33", "382"),("232375", "1", "1000", "88", "1", "396.61", "383"),("232376", "1", "1000", "88", "1", "432.15", "384"),("232377", "1", "1000", "88", "1", "468.51", "385"),("233592", "2", "1000", "88", "1", "540.41", "386"),("192445", "1", "3", "88", "1", "418.93", "387"),("178230", "1", "1000", "88", "1", "880.08", "388"),("194001", "2", "1003", "88", "1", "54.46", "389"),("233595", "2", "1002", "88", "1", "540.41", "390"),("232372", "1", "1001", "88", "1", "432.15", "391"),("238571", "1", "1000", "88", "1", "803.22", "392"),("238572", "1", "1000", "88", "1", "803.22", "393"),("238573", "1", "1000", "88", "1", "803.22", "394"),("179534", "1", "1000", "88", "1", "842.07", "395"),("179535", "1", "1000", "88", "1", "842.07", "396"),("179536", "1", "1000", "88", "1", "842.07", "397"),("196341", "2", "1000", "88", "1", "90", "398"),("232344", "1", "1000", "88", "1", "612.31", "399"),("232351", "1", "1000", "88", "1", "504.05", "400"),("232352", "1", "1000", "88", "1", "540.41", "401"),("232353", "1", "1000", "88", "1", "540.41", "402"),("232354", "1", "1000", "88", "1", "540.41", "403"),("232373", "1", "1000", "88", "1", "468.51", "404"),("232374", "1", "1000", "88", "1", "504.05", "405"),("233593", "2", "1000", "88", "1", "612.31", "406"),("233594", "2", "1000", "88", "1", "650.33", "407"),("233600", "1", "1000", "88", "1", "612.31", "408"),("233601", "1", "1000", "88", "1", "650.33", "409"),("188417", "1", "5", "88", "1", "418.93", "410"),("240314", "1", "1001", "88", "1", "803.22", "411"),("236045", "2", "1001", "88", "1", "162.73", "412"),("232348", "1", "1001", "88", "1", "468.51", "413"),("178207", "1", "1000", "88", "1", "612.31", "414"),("235895", "2", "1000", "88", "1", "198.26", "415"),("236043", "2", "1000", "88", "1", "198.26", "416"),("236044", "2", "1000", "88", "1", "180.08", "417"),("236046", "2", "1000", "88", "1", "234.63", "418"),("232347", "1", "1000", "88", "1", "432.15", "419"),("233596", "1", "1000", "88", "1", "689.17", "420"),("233597", "1", "1000", "88", "1", "727.19", "421"),("233598", "1", "1000", "88", "1", "612.31", "422"),("233599", "1", "1000", "88", "1", "689.17", "423"),("183259", "1", "1", "88", "1", "292.48", "424"),("230942", "1", "1002", "88", "1", "504.05", "425"),("230943", "1", "1002", "88", "1", "540.41", "426"),("230941", "1", "1000", "88", "1", "468.51", "427"),("192403", "1", "1000", "88", "1", "504.05", "428"),("169514", "1", "1000", "88", "1", "1072.64", "429"),("233540", "1", "1000", "88", "1", "612.31", "430"),("233541", "1", "1000", "88", "1", "540.41", "431"),("233542", "1", "1000", "88", "1", "468.51", "432"),("233543", "1", "1000", "88", "1", "504.05", "433"),("233544", "1", "1000", "88", "1", "540.41", "434"),("196625", "1", "1000", "88", "1", "1109.83", "435"),("196629", "2", "1000", "88", "1", "887.52", "436"),("257032", "1", "1000", "124", "1", "551.16", "437"),("257033", "1", "1000", "124", "1", "514.79", "438"),("255922", "1", "0", "88", "1", "484.5", "439"),("256483", "1", "0", "88", "1", "143.98", "440"),("93912", "2", "0", "88", "1", "528.79", "441"),("150901", "1", "0", "88", "1", "271.99", "442"),("188379", "1", "0", "88", "1", "231.19", "443"),("256714", "1", "0", "88", "1", "459", "444"),("256721", "1", "0", "88", "1", "586.5", "445"),("233554", "1", "0", "88", "1", "433.5", "446"),("256728", "1", "0", "88", "1", "724.74", "447"),("256469", "1", "0", "88", "1", "155.98", "448"),("256470", "1", "0", "88", "1", "143.98", "449"),("256472", "1", "0", "88", "1", "119.99", "450"),("256653", "1", "0", "88", "1", "335.99", "451"),("256657", "1", "0", "88", "1", "312", "452"),("256651", "1", "0", "88", "1", "1020", "453"),("257639", "1", "0", "88", "1", "459", "454"),("257640", "1", "0", "88", "1", "433.5", "455"),("257641", "1", "0", "88", "1", "505.7", "456"),("150805", "1", "0", "88", "1", "148.19", "457"),("93910", "2", "0", "88", "1", "485.14", "458"),("93911", "2", "0", "88", "1", "512.25", "459"),("256637", "1", "0", "88", "1", "922.2", "460"),("256727", "1", "0", "88", "1", "803.2", "461"),("257176", "1", "0", "88", "1", "326.39", "462"),("257178", "1", "0", "88", "1", "288.01", "463"),("257180", "1", "0", "88", "1", "326.39", "464"),("256479", "1", "0", "88", "1", "131.99", "465"),("257175", "1", "0", "88", "1", "516.79", "466"),("257181", "1", "0", "88", "1", "433.5", "467"),("150833", "1", "0", "88", "1", "356.71", "468"),("150849", "1", "0", "88", "1", "203.97", "469"),("177226", "1", "0", "88", "1", "1020", "470"),("188229", "2", "0", "88", "1", "29.99", "471"),("196575", "1", "0", "88", "1", "335.99", "472"),("256450", "1", "0", "88", "1", "288.01", "473"),("176758", "2", "0", "88", "1", "2617.36", "474"),("198367", "2", "0", "88", "1", "50", "475"),("198371", "1", "0", "88", "1", "34.26", "476"),("178926", "1", "0", "88", "1", "459", "477"),("178928", "1", "0", "88", "1", "510", "478"),("173689", "1", "0", "88", "1", "312.07", "479"),("168782", "2", "0", "88", "1", "116.95", "480"),("176764", "1", "0", "88", "1", "922.2", "481"),("166299", "2", "0", "88", "1", "59.83", "482"),("178986", "1", "0", "88", "1", "743.7", "483"),("178987", "1", "0", "88", "1", "803.2", "484"),("178988", "1", "0", "88", "1", "862.7", "485"),("178990", "2", "0", "88", "1", "612", "486"),("178997", "2", "0", "88", "1", "663", "487"),("179000", "2", "0", "88", "1", "765", "488"),("179284", "2", "0", "88", "1", "713.95", "489"),("195313", "1", "0", "88", "1", "41.93", "490"),("196065", "2", "0", "88", "1", "20", "491"),("196623", "1", "0", "88", "1", "765", "492"),("93929", "2", "0", "88", "1", "811.1", "493"),("176768", "1", "0", "88", "1", "1287.52", "494"),("176769", "1", "0", "88", "1", "1351.16", "495"),("238492", "1", "0", "88", "1", "216", "496"),("238501", "1", "0", "88", "1", "192", "497"),("178303", "2", "0", "88", "1", "416.45", "498"),("178950", "1", "0", "88", "1", "584.7", "499"),("185697", "2", "0", "88", "1", "288.01", "500")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1025
4 (0.144)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1617
5 (0.200)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:198
6 (0.681)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '256716' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
7 (0.218)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '256716' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
8 (0.172)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '256716' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
9 (0.132)
SELECT *
FROM oc_product_image
WHERE product_id = '256716'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
10 (0.630)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '256717' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
11 (0.201)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '256717' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
12 (0.165)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '256717' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
13 (0.074)
SELECT *
FROM oc_product_image
WHERE product_id = '256717'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
14 (0.535)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '255921' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
15 (0.219)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '255921' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
16 (0.165)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '255921' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
17 (0.074)
SELECT *
FROM oc_product_image
WHERE product_id = '255921'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
18 (0.529)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '257642' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
19 (0.184)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '257642' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
20 (0.125)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '257642' AND a.attribute_group_id = '10' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
21 (0.066)
SELECT *
FROM oc_product_image
WHERE product_id = '257642'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
22 (0.576)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '257659' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
23 (0.156)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '257659' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
24 (0.158)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '257659' AND a.attribute_group_id = '7' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
25 (0.122)
SELECT *
FROM oc_product_image
WHERE product_id = '257659'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
26 (0.562)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '257661' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
27 (0.198)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '257661' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
28 (0.161)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '257661' AND a.attribute_group_id = '7' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
29 (0.123)
SELECT *
FROM oc_product_image
WHERE product_id = '257661'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
30 (0.577)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '257663' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
31 (0.200)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '257663' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
32 (0.160)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '257663' AND a.attribute_group_id = '7' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
33 (0.125)
SELECT *
FROM oc_product_image
WHERE product_id = '257663'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
34 (0.537)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '191505' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
35 (0.203)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '191505' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
36 (0.166)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '191505' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
37 (0.132)
SELECT *
FROM oc_product_image
WHERE product_id = '191505'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
38 (0.582)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '191509' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
39 (0.201)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '191509' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
40 (0.164)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '191509' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
41 (0.130)
SELECT *
FROM oc_product_image
WHERE product_id = '191509'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
42 (0.531)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '191513' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
43 (0.157)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '191513' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
44 (0.166)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '191513' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
45 (0.077)
SELECT *
FROM oc_product_image
WHERE product_id = '191513'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
46 (0.533)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '252720' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
47 (0.155)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '252720' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
48 (0.157)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '252720' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
49 (0.076)
SELECT *
FROM oc_product_image
WHERE product_id = '252720'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
50 (0.522)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '191511' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
51 (0.156)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '191511' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
52 (0.211)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '191511' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
53 (0.078)
SELECT *
FROM oc_product_image
WHERE product_id = '191511'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
54 (0.529)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '259160' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
55 (0.156)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '259160' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
56 (0.161)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '259160' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
57 (0.076)
SELECT *
FROM oc_product_image
WHERE product_id = '259160'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
58 (0.532)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '141195' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
59 (0.168)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '141195' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
60 (0.164)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '141195' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
61 (0.140)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '141195' AND a.attribute_group_id = '59' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
62 (0.080)
SELECT *
FROM oc_product_image
WHERE product_id = '141195'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
63 (0.540)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '259071' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
64 (0.155)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '259071' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
65 (0.163)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '259071' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
66 (0.086)
SELECT *
FROM oc_product_image
WHERE product_id = '259071'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
67 (0.621)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '259147' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
68 (0.192)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '259147' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
69 (0.207)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '259147' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
70 (0.113)
SELECT *
FROM oc_product_image
WHERE product_id = '259147'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
71 (0.560)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '255918' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
72 (0.193)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '255918' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
73 (0.200)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '255918' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
74 (0.077)
SELECT *
FROM oc_product_image
WHERE product_id = '255918'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
75 (0.522)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '255919' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
76 (0.156)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '255919' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
77 (0.162)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '255919' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
78 (0.091)
SELECT *
FROM oc_product_image
WHERE product_id = '255919'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
79 (0.558)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '255920' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
80 (0.177)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '255920' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
81 (0.165)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '255920' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
82 (0.074)
SELECT *
FROM oc_product_image
WHERE product_id = '255920'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
83 (0.531)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '258925' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:53
84 (0.155)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '258925' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1311
85 (0.160)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '258925' AND a.attribute_group_id = '7' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1316
86 (0.077)
SELECT *
FROM oc_product_image
WHERE product_id = '258925'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1412
87 (0.078)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
88 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=256716'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
89 (0.071)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
90 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=256717'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
91 (0.069)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
92 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=255921'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
93 (0.069)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
94 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=257642'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
95 (0.069)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
96 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=257659'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
97 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
98 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=257661'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
99 (0.068)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
100 (0.062)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=257663'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
101 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=191505'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
102 (0.061)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=191509'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
103 (0.061)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=191513'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
104 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=252720'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
105 (0.061)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=191511'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
106 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=259160'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
107 (0.068)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
108 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=141195'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
109 (0.068)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
110 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=259071'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
111 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
112 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=259147'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
113 (0.072)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
114 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=255918'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
115 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
116 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=255919'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
117 (0.067)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
118 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=255920'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
119 (0.104)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
120 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=258925'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
121 (0.330)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1630
122 (0.064)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1658
123 (0.107)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1385
124 (6.439)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1283
125 (0.119)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37