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 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare - bbp

Produse ce potrivesc criteriilor de căutare


MULINETA SAVAGE GEAR SG4 1000 FD 8+1BB / -23%

MULINETA SAVAGE GEAR SG4 1000 FD 8+1BB /

o.sg.74725
Stoc epuizat

206,92Lei(-23%) 159,16Lei

MULINETA SPINNING BARACUDA HAIDON KoSamui MC 2000 FD 5+1BB -26%

MULINETA SPINNING BARACUDA HAIDON KoSamui MC 2000 FD 5+1BB

haidon mc2000
Stoc epuizat

70,17Lei(-26%) 51,59Lei

Mulineta DAM Quick 4 8000 FD, 0.45mm-390m, 5.1:1, 6+1BB -52%

Mulineta DAM Quick 4 8000 FD, 0.45mm-390m, 5.1:1, 6+1BB

svs60856
Stoc epuizat

499,95Lei(-52%) 242,09Lei

Mulineta Colmic Rayton FD 5500 10+1BB -23%

Mulineta Colmic Rayton FD 5500 10+1BB

mulra55
Stoc epuizat

545,00Lei(-23%) 418,88Lei

Mulineta DAM Quick 3 9000 FD, 0.50mm-340m, 5.1:1, 9+1BB -23%

Mulineta DAM Quick 3 9000 FD, 0.50mm-340m, 5.1:1, 9+1BB

svs65700
Stoc epuizat

348,99Lei(-23%) 268,45Lei

Mulineta Colmic Orion FD 3000 7+1BB

Mulineta Colmic Orion FD 3000 7+1BB

mulor30
Stoc epuizat

300,00Lei

Mulineta DAM Nova FD 6000 + Fir Monofilament, 0.40mm-210m, 5.2:1, 1BB -24%

Mulineta DAM Nova FD 6000 + Fir Monofilament, 0.40mm-210m, 5.2:1, 1BB

svs75959
Stoc epuizat

70,00Lei(-24%) 53,36Lei

Mulineta DAM Nova FD 5000 + Fir Monofilament, 0.35mm-220m, 5.2:1, 1BB -24%

Mulineta DAM Nova FD 5000 + Fir Monofilament, 0.35mm-220m, 5.2:1, 1BB

svs75958
Stoc epuizat

66,00Lei(-24%) 50,13Lei

Mulineta DAM Runshift 3QF 4000 BF, 0.28mm-250m, 5.2:1, 2+1BB -30%

Mulineta DAM Runshift 3QF 4000 BF, 0.28mm-250m, 5.2:1, 2+1BB

dam.73037
Stoc epuizat

153,82Lei(-30%) 107,67Lei

Mulineta DAM Quick 2 6000 BF, 0.35mm-340m, 5.1:1, 5+1BB -30%

Mulineta DAM Quick 2 6000 BF, 0.35mm-340m, 5.1:1, 5+1BB

dam.75988
Stoc epuizat

288,61Lei(-30%) 202,01Lei

Mulineta DAM Runshift 3QF 5000 BF, 0.33mm-265m, 5.1:1, 2+1BB -46%

Mulineta DAM Runshift 3QF 5000 BF, 0.33mm-265m, 5.1:1, 2+1BB

dam.73038
Stoc epuizat

163,63Lei(-46%) 88,10Lei

Mulineta DAM Quick 2 4000 BF, 0.25mm-340m, 5.2:1, 5+1BB -30%

Mulineta DAM Quick 2 4000 BF, 0.25mm-340m, 5.2:1, 5+1BB

dam.75986
Stoc epuizat

266,02Lei(-30%) 186,21Lei

Mulineta DAM Quick 2 5000 BF, 0.35mm-200m, 5.1:1, 5+1BB -30%

Mulineta DAM Quick 2 5000 BF, 0.35mm-200m, 5.1:1, 5+1BB

dam.75987
Stoc epuizat

277,15Lei(-30%) 194,01Lei

Mulineta DAM Quick 2 Feeder 4000, 0.22mm-240m, 5.2:1, 5+1BB -23%

Mulineta DAM Quick 2 Feeder 4000, 0.22mm-240m, 5.2:1, 5+1BB

dam.75984
Stoc epuizat

204,14Lei(-23%) 157,03Lei

Mulineta DAM RUnshift 6 6000S BF, 0.33mm-300m, 5.1:1, 5+1BB -23%

Mulineta DAM RUnshift 6 6000S BF, 0.33mm-300m, 5.1:1, 5+1BB

dam.73050
Stoc epuizat

235,72Lei(-23%) 181,31Lei

Mulineta DAM Surf Quick 4 8000 SLS 0.40mm-420m, 4.1:1, 6+1BB -46%

Mulineta DAM Surf Quick 4 8000 SLS 0.40mm-420m, 4.1:1, 6+1BB

svs60862
Stoc epuizat

535,39Lei(-46%) 288,28Lei

Mulineta DAM Runshift 3 6000 BF, 0.35mm-295mm, 5.1:1, 2+1BB -23%

Mulineta DAM Runshift 3 6000 BF, 0.35mm-295mm, 5.1:1, 2+1BB

dam.73034
Stoc epuizat

152,03Lei(-23%) 116,94Lei

Mulineta DAM Runshift 3 5000 BF, 0.33mm-265mm, 5.1:1, 2+1BB -23%

Mulineta DAM Runshift 3 5000 BF, 0.33mm-265mm, 5.1:1, 2+1BB

dam.73033
Stoc epuizat

142,80Lei(-23%) 109,85Lei

Mulineta DAM Quick Fahrenheit 6 3000 S FD, 0.25mm-205m, 5.2:1, 5+1BB -26%

Mulineta DAM Quick Fahrenheit 6 3000 S FD, 0.25mm-205m, 5.2:1, 5+1BB

svs73008
Stoc epuizat

189,34Lei(-26%) 139,90Lei

Mulineta DAM Quick Finessa 8 1000 FD, 0.20mm-220m, 5.2:1, 7+1BB -23%

Mulineta DAM Quick Finessa 8 1000 FD, 0.20mm-220m, 5.2:1, 7+1BB

dam.73017
Stoc epuizat

188,02Lei(-23%) 144,63Lei

Afişare 421 - 440 din 463 (24 pagini)
Queries: 98, Total time: 22.906 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '26659cf338bd3cfd29275a8c82'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.160)
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:837
5 (1.109)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("34546", "2", "1023", "204", "1", "22.690000000000", "1"),("37509", "2", "1019", "204", "1", "22.690000000000", "2"),("34872", "2", "1012", "204", "1", "22.690000000000", "3"),("34903", "2", "1000", "204", "1", "22.690000000000", "4"),("207785", "2", "0", "204", "1", "22.690000000000", "5"),("28988", "2", "1000", "117", "1", "57.980000000000", "6"),("98181", "2", "1000", "177", "1", "32.770000000000", "7"),("170962", "2", "1000", "117", "1", "51.260000000000", "8"),("228841", "2", "1000", "117", "1", "42.860000000000", "9"),("232418", "1", "1000", "117", "1", "34.450000000000", "10"),("10344", "2", "1", "117", "1", "37.820000000000", "11"),("229247", "2", "1000", "117", "1", "37.820000000000", "12"),("219144", "1", "1000", "117", "1", "66.390000000000", "13"),("171175", "2", "1000", "337", "1", "71.430000000000", "14"),("171256", "2", "1000", "388", "1", "29.410000000000", "15"),("234886", "1", "1000", "331", "1", "54.620000000000", "16"),("175614", "1", "1000", "117", "1", "35.290000000000", "17"),("175704", "1", "1", "117", "1", "35.290000000000", "18"),("56452", "2", "3", "98", "1", "100.000000000000", "19"),("206193", "2", "1006", "476", "1", "147.020000000000", "20"),("73908", "2", "1000", "185", "1", "31.090000000000", "21"),("73924", "2", "1000", "185", "1", "32.770000000000", "22"),("152699", "2", "1", "358", "1", "824.340000000000", "23"),("187891", "1", "1000", "656", "1", "33.500000000000", "24"),("187893", "1", "1000", "656", "1", "37.750000000000", "25"),("187895", "1", "1000", "656", "1", "41.990000000000", "26"),("180627", "2", "1000", "364", "1", "138.660000000000", "27"),("72246", "2", "1000", "185", "1", "31.090000000000", "28"),("179509", "-100", "4", "570", "1", "420.130000000000", "29"),("152701", "2", "1", "358", "1", "83.950000000000", "30"),("38275", "2", "1000", "75", "1", "562.180000000000", "31"),("118317", "2", "1000", "105", "1", "18.490000000000", "32"),("178873", "1", "1000", "193", "1", "138.660000000000", "33"),("231598", "2", "1000", "193", "1", "40.340000000000", "34"),("231599", "2", "1000", "193", "1", "40.340000000000", "35"),("84108", "2", "1", "75", "1", "134.450000000000", "36"),("170692", "1", "1000", "123", "1", "45.600000000000", "37"),("234879", "1", "1000", "331", "1", "54.620000000000", "38"),("38301", "2", "1003", "75", "1", "100.840000000000", "39"),("38293", "2", "1000", "75", "1", "268.070000000000", "40"),("108452", "2", "1000", "391", "1", "52.096000000000", "41"),("118461", "2", "1000", "105", "1", "10.080000000000", "42"),("118473", "2", "1000", "105", "1", "14.290000000000", "43"),("118477", "2", "1000", "105", "1", "10.080000000000", "44"),("84111", "2", "1000", "75", "1", "107.560000000000", "45"),("84112", "2", "1000", "75", "1", "109.240000000000", "46"),("178874", "2", "1000", "193", "1", "67.230000000000", "47"),("47199", "2", "1001", "341", "1", "18.070000000000", "48"),("47320", "2", "1", "341", "1", "18.070000000000", "49"),("33000", "2", "1000", "20", "1", "15.480000000000", "50"),("231597", "1", "1000", "193", "1", "64.540000000000", "51"),("32998", "2", "1", "20", "1", "15.480000000000", "52"),("32997", "2", "1000", "20", "1", "15.480000000000", "53"),("229024", "1", "1000", "117", "1", "34.450000000000", "54"),("148779", "2", "1000", "193", "1", "494.960000000000", "55"),("148783", "2", "1000", "193", "1", "545.380000000000", "56"),("148781", "2", "1000", "193", "1", "511.760000000000", "57"),("34128", "2", "1010", "287", "1", "15.970000000000", "58"),("165833", "2", "1002", "67", "1", "83.190000000000", "59"),("20429", "2", "1008", "42", "1", "6.720000000000", "60"),("38270", "2", "1000", "75", "1", "512.610000000000", "61"),("84107", "2", "1000", "75", "1", "164.710000000000", "62"),("129979", "4", "1000", "75", "1", "91.600000000000", "63"),("236011", "2", "1000", "224", "1", "24.370000000000", "64"),("149577", "1", "1003", "299", "1", "7.980000000000", "65"),("20529", "2", "1", "42", "1", "10.100000000000", "66"),("38290", "2", "1000", "75", "1", "259.660000000000", "67"),("38296", "2", "1000", "75", "1", "277.310000000000", "68"),("215779", "2", "1000", "193", "1", "495.800000000000", "69"),("215843", "2", "1000", "193", "1", "21.010000000000", "70"),("215845", "2", "1000", "193", "1", "22.690000000000", "71"),("215847", "2", "1000", "193", "1", "21.010000000000", "72"),("215849", "2", "1000", "193", "1", "22.690000000000", "73"),("34096", "2", "5", "287", "1", "91.600000000000", "74"),("209361", "1", "1005", "670", "1", "15.130000000000", "75"),("59538", "2", "1002", "287", "1", "61.340000000000", "76"),("20257", "2", "1000", "42", "1", "10.080000000000", "77"),("20263", "2", "1000", "42", "1", "10.920000000000", "78"),("20265", "2", "1000", "42", "1", "10.920000000000", "79"),("20266", "2", "1000", "42", "1", "10.920000000000", "80"),("20269", "2", "1000", "42", "1", "10.080000000000", "81"),("20274", "2", "1000", "42", "1", "10.500000000000", "82"),("20278", "2", "1000", "42", "1", "10.920000000000", "83"),("20279", "2", "1000", "42", "1", "10.920000000000", "84"),("20280", "2", "1000", "42", "1", "10.920000000000", "85"),("20284", "2", "1000", "42", "1", "52.100000000000", "86"),("20288", "2", "1000", "42", "1", "52.100000000000", "87"),("20297", "2", "1000", "42", "1", "51.260000000000", "88"),("20300", "2", "1000", "42", "1", "52.100000000000", "89"),("20328", "2", "1000", "42", "1", "52.100000000000", "90"),("20331", "2", "1000", "42", "1", "52.100000000000", "91"),("20335", "2", "1000", "42", "1", "52.100000000000", "92"),("55805", "2", "2", "124", "1", "17.080000000000", "93"),("208603", "1", "1003", "670", "1", "18.490000000000", "94"),("170727", "1", "1000", "96", "1", "75.630000000000", "95"),("10634", "2", "1000", "185", "1", "29.410000000000", "96"),("79580", "2", "18", "369", "1", "208.400000000000", "97"),("210697", "1", "1000", "224", "1", "25.210000000000", "98"),("210727", "1", "1000", "224", "1", "23.530000000000", "99"),("55803", "2", "2", "124", "1", "12.780000000000", "100"),("5826", "2", "2", "42", "1", "82.350000000000", "101"),("97060", "2", "1001", "287", "1", "75.630000000000", "102"),("97059", "2", "1000", "287", "1", "67.230000000000", "103"),("224856", "1", "1000", "729", "1", "174.790000000000", "104"),("214199", "1", "1002", "691", "1", "75.630000000000", "105"),("214223", "1", "1002", "691", "1", "78.150000000000", "106"),("158511", "2", "1000", "401", "1", "30.050000000000", "107"),("158513", "2", "1000", "401", "1", "30.050000000000", "108"),("202087", "1", "1000", "540", "1", "35.290000000000", "109"),("211303", "1", "1000", "224", "1", "41.180000000000", "110"),("210805", "1", "1000", "224", "1", "37.820000000000", "111"),("177321", "2", "1000", "117", "1", "49.580000000000", "112"),("177363", "2", "1000", "117", "1", "49.580000000000", "113"),("177372", "2", "1000", "117", "1", "49.580000000000", "114"),("177384", "2", "1000", "117", "1", "53.780000000000", "115"),("177394", "2", "1000", "117", "1", "53.780000000000", "116"),("177403", "2", "1000", "117", "1", "53.780000000000", "117"),("98762", "2", "3", "123", "1", "19.450000000000", "118"),("131535", "1", "1", "16", "1", "367.230000000000", "119"),("36244", "2", "1002", "105", "1", "16.810000000000", "120"),("214143", "1", "1002", "691", "1", "65.550000000000", "121"),("118128", "2", "1000", "105", "1", "16.810000000000", "122"),("209045", "1", "1000", "476", "1", "22.230000000000", "123"),("209051", "1", "1000", "476", "1", "22.230000000000", "124"),("209055", "1", "1000", "476", "1", "22.230000000000", "125"),("209057", "1", "1000", "476", "1", "22.230000000000", "126"),("135511", "1", "1000", "193", "1", "210.080000000000", "127"),("211515", "1", "1000", "224", "1", "33.610000000000", "128"),("211517", "1", "1000", "224", "1", "33.610000000000", "129"),("223793", "1", "1000", "224", "1", "12.610000000000", "130"),("223762", "1", "1000", "224", "1", "12.610000000000", "131"),("223779", "1", "1000", "224", "1", "12.610000000000", "132"),("182303", "4", "1", "16", "1", "706.720000000000", "133"),("56507", "2", "1000", "287", "1", "61.340000000000", "134"),("209065", "1", "1017", "476", "1", "22.230000000000", "135"),("209063", "1", "1005", "476", "1", "22.230000000000", "136"),("209061", "1", "1003", "476", "1", "22.230000000000", "137"),("118496", "2", "1000", "105", "1", "10.080000000000", "138"),("209059", "1", "1000", "476", "1", "22.230000000000", "139"),("205033", "1", "1000", "150", "1", "1054.220000000000", "140"),("201373", "1", "1000", "224", "1", "20.170000000000", "141"),("178291", "1", "1000", "122", "1", "152.940000000000", "142"),("209077", "1", "1006", "476", "1", "22.230000000000", "143"),("209075", "1", "1005", "476", "1", "22.230000000000", "144"),("129183", "2", "1005", "19", "1", "12.100000000000", "145"),("209071", "1", "1004", "476", "1", "22.230000000000", "146"),("129179", "2", "1004", "19", "1", "12.100000000000", "147"),("130285", "1", "1002", "48", "1", "12.610000000000", "148"),("215807", "1", "1002", "459", "1", "57.980000000000", "149"),("129177", "2", "1002", "19", "1", "12.100000000000", "150"),("129181", "2", "1002", "19", "1", "12.100000000000", "151"),("130261", "1", "1000", "48", "1", "7.140000000000", "152"),("154015", "2", "1000", "553", "1", "2100.000000000000", "153"),("190597", "2", "1000", "287", "1", "142.850000000000", "154"),("205035", "1", "1000", "150", "1", "1073.300000000000", "155"),("224331", "1", "1000", "224", "1", "26.890000000000", "156"),("235352", "1", "1000", "224", "1", "53.780000000000", "157"),("129175", "2", "4", "19", "1", "11.430000000000", "158"),("129173", "2", "1", "19", "1", "11.430000000000", "159"),("108078", "2", "1007", "389", "1", "5.800000000000", "160"),("108073", "2", "1006", "389", "1", "5.800000000000", "161"),("108074", "2", "1004", "389", "1", "5.420000000000", "162"),("95948", "2", "1004", "514", "1", "38.570000000000", "163"),("108077", "2", "1001", "389", "1", "7.640000000000", "164"),("108075", "2", "1000", "389", "1", "7.640000000000", "165"),("108076", "2", "1000", "389", "1", "7.020000000000", "166"),("169823", "1", "1000", "559", "1", "38.660000000000", "167"),("169824", "1", "1000", "559", "1", "38.660000000000", "168"),("224001", "1", "1000", "224", "1", "30.250000000000", "169"),("224002", "1", "1000", "224", "1", "30.250000000000", "170"),("224013", "1", "1000", "224", "1", "30.250000000000", "171"),("130237", "1", "1", "48", "1", "5.880000000000", "172"),("189319", "1", "1010", "436", "1", "25.830400000000", "173"),("189323", "1", "1009", "436", "1", "25.830400000000", "174"),("169825", "1", "1000", "559", "1", "46.220000000000", "175"),("169827", "1", "1000", "559", "1", "46.220000000000", "176"),("225223", "1", "1000", "224", "1", "31.090000000000", "177"),("209035", "1", "1003", "670", "1", "24.370000000000", "178"),("178877", "1", "1000", "193", "1", "441.180000000000", "179"),("189863", "2", "1000", "528", "1", "12.610000000000", "180"),("189865", "2", "1000", "528", "1", "15.550000000000", "181"),("189867", "2", "1000", "528", "1", "11.340000000000", "182"),("224167", "1", "1000", "224", "1", "31.090000000000", "183"),("20421", "2", "1", "42", "1", "7.900000000000", "184"),("20416", "2", "1001", "42", "1", "7.900000000000", "185"),("20425", "2", "1001", "42", "1", "6.720000000000", "186"),("20417", "2", "1000", "42", "1", "7.900000000000", "187"),("20419", "2", "1000", "42", "1", "7.900000000000", "188"),("20420", "2", "1000", "42", "1", "7.900000000000", "189"),("20422", "2", "1000", "42", "1", "7.900000000000", "190"),("20423", "2", "1000", "42", "1", "7.900000000000", "191"),("20426", "2", "1000", "42", "1", "6.720000000000", "192"),("20411", "2", "1000", "42", "1", "7.900000000000", "193"),("20405", "2", "1000", "42", "1", "7.900000000000", "194"),("38958", "2", "3", "287", "1", "41.180000000000", "195"),("38959", "2", "2", "287", "1", "48.740000000000", "196"),("189325", "1", "1009", "436", "1", "25.830400000000", "197"),("20428", "2", "1001", "42", "1", "6.720000000000", "198"),("190747", "1", "1001", "528", "1", "13.870000000000", "199"),("20433", "2", "1000", "42", "1", "8.990000000000", "200"),("20437", "2", "1000", "42", "1", "9.660000000000", "201"),("20438", "2", "1000", "42", "1", "9.660000000000", "202"),("20439", "2", "1000", "42", "1", "9.660000000000", "203"),("20440", "2", "1000", "42", "1", "9.240000000000", "204"),("20443", "2", "1000", "42", "1", "9.240000000000", "205"),("20444", "2", "1000", "42", "1", "9.240000000000", "206"),("20450", "2", "1000", "42", "1", "9.830000000000", "207"),("20451", "2", "1000", "42", "1", "9.830000000000", "208"),("20453", "2", "1000", "42", "1", "9.240000000000", "209"),("20455", "2", "1000", "42", "1", "9.660000000000", "210"),("20456", "2", "1000", "42", "1", "9.660000000000", "211"),("20458", "2", "1000", "42", "1", "9.830000000000", "212"),("20462", "2", "1000", "42", "1", "9.240000000000", "213"),("20464", "2", "1000", "42", "1", "9.240000000000", "214"),("20466", "2", "1000", "42", "1", "9.240000000000", "215"),("20468", "2", "1000", "42", "1", "9.660000000000", "216"),("20470", "2", "1000", "42", "1", "9.830000000000", "217"),("20471", "2", "1000", "42", "1", "9.830000000000", "218"),("20472", "2", "1000", "42", "1", "9.830000000000", "219"),("20448", "2", "1000", "42", "1", "9.660000000000", "220"),("20457", "2", "1000", "42", "1", "9.660000000000", "221"),("20467", "2", "1000", "42", "1", "9.660000000000", "222"),("20469", "2", "1000", "42", "1", "9.660000000000", "223"),("235720", "2", "1000", "492", "1", "25.210000000000", "224"),("227279", "2", "1008", "528", "1", "14.920000000000", "225"),("227280", "2", "1000", "528", "1", "13.240000000000", "226"),("189881", "1", "1000", "528", "1", "10.080000000000", "227"),("236955", "1", "1011", "124", "1", "84.030000000000", "228"),("236954", "1", "1004", "124", "1", "84.030000000000", "229"),("236956", "1", "1000", "124", "1", "76.470000000000", "230"),("236957", "1", "1000", "124", "1", "47.900000000000", "231"),("236958", "1", "1000", "124", "1", "47.900000000000", "232"),("236959", "1", "1000", "124", "1", "44.540000000000", "233"),("240838", "1", "1001", "782", "1", "121.850000000000", "234"),("236951", "1", "1000", "124", "1", "247.060000000000", "235"),("241594", "1", "1000", "782", "1", "125.210000000000", "236"),("241595", "1", "1000", "782", "1", "116.810000000000", "237"),("236926", "1", "1006", "124", "1", "100.000000000000", "238"),("236928", "1", "1003", "124", "1", "96.640000000000", "239"),("201021", "2", "1000", "224", "1", "6.720000000000", "240"),("174511", "1", "1000", "224", "1", "5.880000000000", "241"),("236891", "1", "1000", "124", "1", "134.450000000000", "242"),("236892", "1", "1000", "124", "1", "123.530000000000", "243"),("236894", "1", "1000", "124", "1", "106.720000000000", "244"),("236925", "1", "1000", "124", "1", "106.720000000000", "245"),("236887", "1", "1000", "124", "1", "141.180000000000", "246"),("140683", "1", "2", "47", "1", "263.360000000000", "247"),("16391", "2", "1002", "42", "1", "31.090000000000", "248"),("16388", "2", "1001", "42", "1", "27.730000000000", "249"),("236952", "1", "1001", "124", "1", "151.260000000000", "250"),("16411", "2", "1000", "42", "1", "22.690000000000", "251"),("16414", "2", "1000", "42", "1", "25.210000000000", "252"),("16416", "2", "1000", "42", "1", "28.570000000000", "253"),("79358", "2", "1000", "42", "1", "21.850000000000", "254"),("79359", "2", "1000", "42", "1", "23.530000000000", "255"),("16387", "2", "1000", "42", "1", "23.530000000000", "256"),("236964", "1", "1", "124", "1", "137.820000000000", "257"),("16452", "2", "1002", "42", "1", "23.530000000000", "258"),("16450", "2", "1001", "42", "1", "20.170000000000", "259"),("130417", "2", "1001", "289", "1", "8.400000000000", "260"),("130419", "2", "1001", "289", "1", "8.400000000000", "261"),("16467", "2", "1000", "42", "1", "19.330000000000", "262"),("16468", "2", "1000", "42", "1", "21.850000000000", "263"),("16453", "2", "1000", "42", "1", "24.370000000000", "264"),("201013", "2", "1000", "224", "1", "6.720000000000", "265"),("201015", "2", "1000", "224", "1", "8.400000000000", "266"),("201017", "2", "1000", "224", "1", "8.400000000000", "267"),("201085", "1", "1000", "224", "1", "7.140000000000", "268"),("201105", "2", "1000", "224", "1", "6.720000000000", "269"),("174508", "1", "1000", "224", "1", "5.880000000000", "270"),("16465", "2", "1000", "42", "1", "17.650000000000", "271"),("174509", "1", "1000", "224", "1", "5.880000000000", "272"),("130053", "1", "1001", "124", "1", "41.180000000000", "273"),("168487", "2", "1000", "115", "1", "284.870000000000", "274"),("168488", "2", "1000", "115", "1", "294.120000000000", "275"),("168489", "2", "1000", "115", "1", "302.520000000000", "276"),("168490", "2", "1000", "115", "1", "315.130000000000", "277"),("168491", "2", "1000", "115", "1", "323.530000000000", "278"),("168492", "2", "1000", "115", "1", "331.930000000000", "279"),("168518", "2", "1000", "115", "1", "235.290000000000", "280"),("168519", "2", "1000", "115", "1", "242.860000000000", "281"),("168522", "2", "1000", "115", "1", "268.910000000000", "282"),("168525", "2", "1000", "115", "1", "428.570000000000", "283"),("168530", "2", "1000", "115", "1", "441.180000000000", "284"),("176540", "1", "1000", "124", "1", "252.020000000000", "285"),("236948", "1", "1000", "124", "1", "123.530000000000", "286"),("241592", "1", "1000", "648", "1", "226.050000000000", "287"),("175100", "1", "6", "124", "1", "47.900000000000", "288"),("175101", "1", "6", "124", "1", "52.100000000000", "289"),("196937", "2", "1009", "289", "1", "12.610000000000", "290"),("196943", "2", "1001", "289", "1", "10.080000000000", "291"),("196945", "2", "1001", "289", "1", "12.610000000000", "292"),("176567", "1", "1001", "124", "1", "117.970000000000", "293"),("196939", "2", "1001", "289", "1", "12.610000000000", "294"),("196941", "2", "1001", "289", "1", "12.610000000000", "295"),("114915", "2", "1000", "163", "1", "128.970000000000", "296"),("176561", "1", "1000", "124", "1", "112.310000000000", "297"),("196933", "2", "1000", "289", "1", "12.610000000000", "298"),("196935", "2", "1000", "289", "1", "12.610000000000", "299"),("176533", "2", "1000", "124", "1", "270.450000000000", "300"),("176535", "1", "1000", "124", "1", "189.650000000000", "301"),("176536", "1", "1000", "124", "1", "198.550000000000", "302"),("205257", "2", "1000", "224", "1", "6.720000000000", "303"),("196947", "2", "1000", "289", "1", "12.610000000000", "304"),("176559", "1", "2", "124", "1", "120.420000000000", "305"),("176557", "1", "1", "124", "1", "117.480000000000", "306"),("140685", "1", "1007", "47", "1", "292.600000000000", "307"),("175322", "1", "1002", "124", "1", "173.500000000000", "308"),("140687", "1", "1001", "47", "1", "313.590000000000", "309"),("176581", "1", "1000", "124", "1", "282.690000000000", "310"),("176577", "1", "1000", "124", "1", "330.590000000000", "311"),("128766", "1", "1004", "47", "1", "292.600000000000", "312"),("189007", "1", "1001", "124", "1", "161.340000000000", "313"),("239324", "1", "1001", "648", "1", "226.050000000000", "314"),("155847", "2", "1000", "85", "1", "443.790000000000", "315"),("176541", "2", "1000", "124", "1", "139.020000000000", "316"),("176543", "2", "1000", "124", "1", "150.610000000000", "317"),("176554", "1", "1000", "124", "1", "165.800000000000", "318"),("239314", "1", "1000", "648", "1", "231.090000000000", "319"),("189005", "1", "1000", "124", "1", "154.620000000000", "320"),("189009", "1", "1000", "124", "1", "164.710000000000", "321"),("108970", "4", "1", "163", "1", "70.160000000000", "322"),("239303", "1", "1000", "648", "1", "333.610000000000", "323"),("176588", "1", "1001", "47", "1", "298.660000000000", "324"),("168498", "2", "1000", "115", "1", "252.100000000000", "325"),("168499", "2", "1000", "115", "1", "260.500000000000", "326"),("168501", "2", "1000", "115", "1", "273.110000000000", "327"),("168502", "2", "1000", "115", "1", "281.510000000000", "328"),("138397", "2", "1000", "85", "1", "246.870000000000", "329"),("138399", "2", "1000", "85", "1", "258.080000000000", "330"),("176589", "1", "1000", "47", "1", "298.660000000000", "331"),("176067", "1", "16", "124", "1", "257.140000000000", "332"),("108976", "10", "1", "163", "1", "63.710000000000", "333"),("155843", "1", "1", "47", "1", "337.810000000000", "334"),("176569", "1", "1001", "124", "1", "145.550000000000", "335"),("138599", "2", "1000", "85", "1", "97.580000000000", "336"),("176068", "1", "1000", "124", "1", "135.190000000000", "337"),("108972", "4", "1000", "163", "1", "57.300000000000", "338"),("176584", "1", "1004", "47", "1", "131.850000000000", "339"),("236962", "1", "1000", "124", "1", "178.990000000000", "340"),("236963", "1", "1000", "124", "1", "168.070000000000", "341"),("138605", "2", "1000", "85", "1", "102.340000000000", "342"),("176586", "1", "1000", "47", "1", "153.620000000000", "343"),("176585", "1", "3", "47", "1", "141.090000000000", "344"),("138597", "2", "1000", "85", "1", "101.890000000000", "345"),("240173", "1", "0", "773", "1", "42.020000000000", "346"),("29764", "2", "0", "117", "1", "29.000000000000", "347"),("137563", "2", "0", "581", "1", "17.390000000000", "348"),("137603", "2", "0", "581", "1", "17.390000000000", "349"),("133495", "2", "0", "117", "1", "27.000000000000", "350"),("34786", "2", "0", "177", "1", "18.800000000000", "351"),("207767", "1", "0", "117", "1", "66.390000000000", "352"),("171263", "2", "0", "388", "1", "18.500000000000", "353"),("31140", "2", "0", "117", "1", "27.000000000000", "354"),("114120", "2", "0", "185", "1", "30.190000000000", "355"),("99669", "1", "0", "17", "1", "252.000000000000", "356"),("242781", "2", "0", "476", "1", "264.670000000000", "357"),("98791", "2", "0", "117", "1", "27.000000000000", "358"),("137605", "2", "0", "581", "1", "17.390000000000", "359"),("84110", "2", "0", "75", "1", "81.000000000000", "360"),("38285", "2", "0", "75", "1", "143.000000000000", "361"),("171178", "2", "0", "337", "1", "45.000000000000", "362"),("142793", "1", "0", "17", "1", "262.000000000000", "363"),("224461", "1", "0", "773", "1", "29.410000000000", "364"),("58396", "2", "0", "222", "1", "32.742400000000", "365"),("59751", "2", "0", "67", "1", "39.810000000000", "366"),("59752", "2", "0", "67", "1", "39.810000000000", "367"),("129981", "4", "0", "75", "1", "79.000000000000", "368"),("42245", "2", "0", "67", "1", "62.290000000000", "369"),("20340", "2", "0", "42", "1", "3.360000000000", "370"),("20318", "2", "0", "42", "1", "40.000000000000", "371"),("20320", "2", "0", "42", "1", "40.000000000000", "372"),("20334", "2", "0", "42", "1", "40.000000000000", "373"),("20336", "2", "0", "42", "1", "40.000000000000", "374"),("20371", "2", "0", "42", "1", "2.700000000000", "375"),("20259", "10", "0", "42", "1", "7.600000000000", "376"),("20261", "2", "0", "42", "1", "7.600000000000", "377"),("20272", "2", "0", "42", "1", "7.800000000000", "378"),("20275", "2", "0", "42", "1", "8.000000000000", "379"),("20277", "2", "0", "42", "1", "8.000000000000", "380"),("20282", "2", "0", "42", "1", "40.000000000000", "381"),("20286", "2", "0", "42", "1", "40.000000000000", "382"),("188503", "4", "0", "16", "1", "509.770000000000", "383"),("20283", "2", "0", "42", "1", "40.000000000000", "384"),("20287", "2", "0", "42", "1", "40.000000000000", "385"),("20305", "2", "0", "42", "1", "41.000000000000", "386"),("20312", "2", "0", "42", "1", "41.000000000000", "387"),("20292", "2", "0", "42", "1", "41.000000000000", "388"),("238861", "1", "0", "370", "1", "69.210000000000", "389"),("27366", "2", "0", "49", "1", "7.300000000000", "390"),("34097", "2", "0", "287", "1", "60.020000000000", "391"),("180032", "2", "0", "369", "1", "150.000000000000", "392"),("40353", "2", "0", "42", "1", "40.000000000000", "393"),("40354", "2", "0", "42", "1", "40.000000000000", "394"),("130273", "1", "0", "48", "1", "7.390000000000", "395"),("130249", "1", "0", "48", "1", "4.790000000000", "396"),("239447", "2", "0", "122", "1", "25.700000000000", "397"),("93921", "2", "0", "67", "1", "268.660000000000", "398"),("178878", "1", "0", "193", "1", "270.000000000000", "399"),("20397", "2", "0", "42", "1", "5.400000000000", "400"),("20408", "2", "0", "42", "1", "6.200000000000", "401"),("213343", "1", "0", "16", "1", "203.150000000000", "402"),("237262", "1", "0", "16", "1", "180.060000000000", "403"),("189321", "1", "0", "436", "1", "28.185600000000", "404"),("20454", "2", "0", "42", "1", "7.300000000000", "405"),("235721", "2", "0", "492", "1", "17.710000000000", "406"),("5829", "2", "0", "42", "1", "40.000000000000", "407"),("99179", "1", "0", "469", "1", "5.530000000000", "408"),("99181", "1", "0", "469", "1", "3.840000000000", "409"),("99183", "1", "0", "469", "1", "5.840000000000", "410"),("99175", "1", "0", "469", "1", "13.060000000000", "411"),("99173", "1", "0", "469", "1", "41.320000000000", "412"),("236968", "1", "0", "124", "1", "69.350000000000", "413"),("116987", "2", "0", "280", "1", "47.175000000000", "414"),("236893", "1", "0", "124", "1", "89.730000000000", "415"),("236949", "1", "0", "124", "1", "130.520000000000", "416"),("236950", "1", "0", "124", "1", "102.627000000000", "417"),("114924", "2", "0", "163", "1", "43.650000000000", "418"),("128769", "1", "0", "47", "1", "247.600000000000", "419"),("93924", "2", "0", "67", "1", "364.660000000000", "420"),("138363", "2", "0", "85", "1", "133.750000000000", "421"),("116986", "2", "0", "280", "1", "43.350000000000", "422"),("103067", "2", "0", "124", "1", "203.440000000000", "423"),("168531", "2", "0", "115", "1", "352.000000000000", "424"),("176537", "1", "0", "124", "1", "225.590000000000", "425"),("168520", "2", "0", "115", "1", "252.100000000000", "426"),("130069", "1", "0", "124", "1", "44.840000000000", "427"),("175103", "1", "0", "124", "1", "42.130000000000", "428"),("176565", "1", "0", "124", "1", "90.480000000000", "429"),("156033", "1", "0", "124", "1", "169.760000000000", "430"),("176566", "1", "0", "124", "1", "74.030000000000", "431"),("176529", "1", "0", "124", "1", "156.480000000000", "432"),("176531", "1", "0", "124", "1", "163.030000000000", "433"),("176532", "1", "0", "124", "1", "131.960000000000", "434"),("176570", "1", "0", "124", "1", "152.360000000000", "435"),("176578", "1", "0", "124", "1", "242.250000000000", "436"),("176563", "1", "0", "124", "1", "98.270000000000", "437"),("176562", "1", "0", "124", "1", "92.310000000000", "438"),("176550", "1", "0", "124", "1", "117.560000000000", "439"),("176556", "1", "0", "124", "1", "121.540000000000", "440"),("176560", "1", "0", "124", "1", "145.350000000000", "441"),("138361", "2", "0", "85", "1", "119.520000000000", "442"),("138387", "2", "0", "85", "1", "207.980000000000", "443"),("138389", "2", "0", "85", "1", "151.820000000000", "444"),("138391", "2", "0", "85", "1", "249.510000000000", "445"),("138395", "2", "0", "85", "1", "195.610000000000", "446"),("176548", "1", "0", "124", "1", "97.900000000000", "447"),("176527", "1", "0", "124", "1", "63.560000000000", "448"),("176538", "1", "0", "124", "1", "348.610000000000", "449"),("176583", "1", "0", "124", "1", "238.320000000000", "450"),("108971", "4", "0", "163", "1", "56.330000000000", "451"),("138601", "2", "0", "85", "1", "85.560000000000", "452"),("138603", "2", "0", "85", "1", "89.170000000000", "453"),("206637", "2", "0", "85", "1", "556.680000000000", "454"),("236976", "1", "0", "85", "1", "836.130000000000", "455"),("176580", "1", "0", "124", "1", "276.710000000000", "456"),("176555", "1", "0", "124", "1", "168.030000000000", "457"),("93925", "2", "0", "67", "1", "382.910000000000", "458"),("138583", "2", "0", "85", "1", "93.230000000000", "459"),("108973", "4", "0", "163", "1", "60.680000000000", "460"),("138393", "2", "0", "85", "1", "166.420000000000", "461"),("176587", "1", "0", "47", "1", "164.120000000000", "462"),("138607", "2", "0", "85", "1", "449.820000000000", "463")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
6 (0.168)
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:1593
7 (0.986)
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 420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (0.705)
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 = '138363' 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:51
9 (0.220)
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 = '138363' 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:1297
10 (0.177)
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 = '138363' 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:1302
11 (0.128)
SELECT *
FROM oc_product_image
WHERE product_id = '138363'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
12 (0.739)
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 = '103067' 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:51
13 (0.274)
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 = '103067' 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:1297
14 (0.273)
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 = '103067' 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:1302
15 (0.102)
SELECT *
FROM oc_product_image
WHERE product_id = '103067'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
16 (0.650)
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 = '168531' 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:51
17 (0.215)
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 = '168531' 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:1297
18 (0.239)
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 = '168531' 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:1302
19 (0.142)
SELECT *
FROM oc_product_image
WHERE product_id = '168531'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
20 (0.602)
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 = '176537' 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:51
21 (0.217)
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 = '176537' 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:1297
22 (0.219)
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 = '176537' 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:1302
23 (0.184)
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 = '176537' 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:1302
24 (0.125)
SELECT *
FROM oc_product_image
WHERE product_id = '176537'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
25 (0.546)
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 = '168520' 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:51
26 (0.208)
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 = '168520' 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:1297
27 (0.170)
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 = '168520' 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:1302
28 (0.086)
SELECT *
FROM oc_product_image
WHERE product_id = '168520'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
29 (0.615)
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 = '130069' 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:51
30 (0.213)
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 = '130069' 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:1297
31 (0.219)
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 = '130069' 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:1302
32 (0.118)
SELECT *
FROM oc_product_image
WHERE product_id = '130069'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
33 (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 = '176565' 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:51
34 (0.172)
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 = '176565' 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:1297
35 (0.179)
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 = '176565' 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:1302
36 (0.082)
SELECT *
FROM oc_product_image
WHERE product_id = '176565'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
37 (0.566)
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 = '156033' 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:51
38 (0.170)
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 = '156033' 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:1297
39 (0.175)
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 = '156033' 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:1302
40 (0.139)
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 = '156033' 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:1302
41 (0.076)
SELECT *
FROM oc_product_image
WHERE product_id = '156033'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
42 (0.585)
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 = '176566' 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:51
43 (0.160)
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 = '176566' 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:1297
44 (0.169)
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 = '176566' 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:1302
45 (0.076)
SELECT *
FROM oc_product_image
WHERE product_id = '176566'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
46 (0.559)
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 = '176529' 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:51
47 (0.164)
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 = '176529' 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:1297
48 (0.171)
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 = '176529' 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:1302
49 (0.136)
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 = '176529' 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:1302
50 (0.074)
SELECT *
FROM oc_product_image
WHERE product_id = '176529'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
51 (0.565)
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 = '176531' 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:51
52 (0.163)
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 = '176531' 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:1297
53 (0.170)
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 = '176531' 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:1302
54 (0.135)
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 = '176531' 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:1302
55 (0.073)
SELECT *
FROM oc_product_image
WHERE product_id = '176531'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
56 (0.565)
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 = '176570' 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:51
57 (0.210)
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 = '176570' 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:1297
58 (0.202)
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 = '176570' 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:1302
59 (0.076)
SELECT *
FROM oc_product_image
WHERE product_id = '176570'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
60 (0.569)
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 = '176578' 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:51
61 (0.165)
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 = '176578' 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:1297
62 (0.168)
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 = '176578' 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:1302
63 (0.074)
SELECT *
FROM oc_product_image
WHERE product_id = '176578'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
64 (0.555)
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 = '176563' 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:51
65 (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 = '176563' 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:1297
66 (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 = '176563' 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:1302
67 (0.073)
SELECT *
FROM oc_product_image
WHERE product_id = '176563'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
68 (0.554)
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 = '176562' 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:51
69 (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 = '176562' 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:1297
70 (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 = '176562' 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:1302
71 (0.073)
SELECT *
FROM oc_product_image
WHERE product_id = '176562'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
72 (0.584)
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 = '176550' 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:51
73 (0.194)
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 = '176550' 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:1297
74 (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 = '176550' 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:1302
75 (0.073)
SELECT *
FROM oc_product_image
WHERE product_id = '176550'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
76 (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 = '176556' 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:51
77 (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 = '176556' 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:1297
78 (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 = '176556' 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:1302
79 (0.072)
SELECT *
FROM oc_product_image
WHERE product_id = '176556'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
80 (0.096)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=138363'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
81 (0.094)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
82 (0.092)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=103067'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
83 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=168531'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
84 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176537'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
85 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=168520'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
86 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=130069'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
87 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176565'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
88 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=156033'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
89 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176566'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
90 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176529'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
91 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176531'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
92 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176570'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
93 (0.082)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176578'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
94 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176563'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
95 (0.088)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176562'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
96 (0.083)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176550'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
97 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=176556'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
98 (0.181)
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