DAHUA IPC-PT2849C1-S-PV-PRO IP VRTLJIVA KAMERA

324,00 €
226,80 €

8 MP (3840×2160) / Leča: 3.6 mm / Pan: 33,8°/s, Tilt: 36,3°/s / Nočni vid: 30m / IVA (prestop linije, vdor, zaznavanje ljudi in vozil) / SMD / Samodejno sledenje / Aktivno odvračanje / AI ISP

  • Blagovna znamka:
    DAHUA
  • Koda:
    DH-IPC-PT2849C1-S-PV-PRO
  • Zaloga:
    Ni na zalogi

Opis

- 1/1.8" 8 MP CMOS senzor
- WizColor tehnologija
- Največ 20 fps @ 8MP
- Kodiranje H.265
- SMD 3.0
- Zaščita oboda (Perimeter Protection)
- Dvosmerna komunikacija
- Auto Tracking Lite
- Tour funkcija
- IP66 zaščita
 

Kamera
- Senzor slike: 1/1.8" CMOS
- Ločljivost: 8 MP
- Največja ločljivost: 3840 (H) × 2160 (V)
- ROM: 256 MB
- RAM: 256 MB
- Elektronska zaklopka: 1 s – 1/100.000 s
- Sistem skeniranja: progresiven
- Minimalna osvetlitev: 0,0005 lux @ F1.0 (barvno, 30 IRE); 0 lux (pri vključenem osvetljevalcu)
- Razdalja osvetlitve (3,6 mm): do 30 m (topla svetloba)
- Krmiljenje osvetljevalca: avtomatsko / ročno / izklop
- Število osvetljevalcev: 4 (topla svetloba)

Objektiv
- Goriščna razdalja: 3,6 mm
- Največja zaslonka: F1.0
- Vidni kot: H: 93°; V: 49°; D: 110°
- Najmanjša razdalja ostrenja: 3,5 m
- DORI razdalje (3,6 mm):
•    Detekcija: 72,0 m
•    Opazovanje: 28,4 m
•    Prepoznavanje: 14,4 m
•    Identifikacija: 7,2 m
(DORI je standard EN-62676-4 za določanje zmogljivosti kamere.)

PTZ
- Območje premikanja: Pan: 0°–345°; Tilt: 0°–90°
- Ročna hitrost: Pan 0,1°–34,5°/s; Tilt 0,1°–36,4°/s
- Hitrost prednastavitev: Pan 0,1°–33,8°/s; Tilt 0,1°–36,3°/s
- Število prednastavitev: 80
- Tour: 8 (do 6 prednastavitev/tour; trajanje 60–360 s; interval 900–3600 s)
- Spomin ob izpadu napajanja: da
- Idle Motion: Prednastavitev; Tour

Pametni dogodki
- IVS: črta prečkanja, vdor
- Detekcija ljudi: da
- Detekcija vozil: da

Inteligenca
- Pametno sledenje: Auto Tracking Lite
- SMD: SMD 3.0

Aktivno odvračanje
- Svetlobno opozorilo: utripajoča topla svetloba (5–30 s, frekvenca nizka/srednja/visoka)
- Zvočno opozorilo: 3 alarmni zvoki; nastavitev glasnosti 0–100 %; ponavljanje 1–10×

Video
- Kompresija: Smart H.265+, H.265, Smart H.264+, H.264B/M/H, MJPEG (substream)
- Tokovi: 2 toka
- Ločljivosti: 8M (3840×2160); 6M (3072×2048); 5M (3072×1728/2880×1620); 4M (2688×1520); 3M (2048×1536/2304×1296); 1080p; 1.3M (1280×960); 720p; D1; VGA; CIF
- Hitrost sličic:
•    Glavni tok: 3840×2160 (1–20 fps); 2688×1520 (1–25/30 fps)
•    Podtok: 704×576 (1–25 fps); 704×480 (1–30 fps)
- Bit Rate Control: CBR/VBR
- Bit Rate: H.264 (8 kbps–8192 kbps); H.265 (3 kbps–8192 kbps)
- Dan/noč: barvno / črno-belo
- BLC: da
- WDR: 120 dB
- HLC: da
- White Balance: avtomatsko / notranje / zunanje / ročno / sledenje / natrijeva svetilka / naravna svetloba / ulična svetilka
- Nadzor ojačitve: avtomatsko / ročno / prednost ojačitve
- Odstranjevanje šuma: 2D NR, 3D NR
- Detekcija gibanja: da
- RoI: da
- Defog: elektronski
- Digitalni zoom: 16×
- Rotacija slike: 180°
- Razmerje S/N: ≥55 dB

Avdio
- Kompresija: PCM, G.711A, G.711Mu
- Vgrajen mikrofon: da
- Vgrajen zvočnik: da

Omrežje
- Omrežni priključek: RJ-45 (10/100 Base-T)
- Protokoli: HTTP, HTTPS, TCP/IP, IPv4, RTSP, UDP, NTP, DHCP, DNS, DDNS, IPv6, SSL, QoS, FTP, ICMP, IGMP, ARP, RTCP, RTP, RTMP
- Interoperabilnost: ONVIF (Profile S/G/T), CGI, SDK
- Način prenosa: unicast/multicast
- Uporabniki: do 20 (skupna pasovna širina 64 M)
- Shranjevanje: MicroSD (do 512 GB), FTP
- Brskalniki: IE 7+, Chrome, Firefox, Safari
- Programska oprema: DMSS, NVR
- Mobilni odjemalci: iOS, Android

Funkcije
- Alarm na nenavaden zvok: da

Certifikati
- CE

Vhodi/izhodi
- Avdio vhod: 1 kanal (vgrajen mikrofon)
- Avdio izhod: 1 kanal (vgrajen zvočnik)
- Povezava alarmov: zajem slike, snemanje, avdio, svetloba
- Alarmni dogodki: zaznava gibanja, sabotaža, zaznava zvoka, izpad omrežja, konflikt IP, stanje pomnilniške kartice, zaznava prostora

Napajanje
- Napajanje: 12 VDC (1 A ± 10 %), PoE (802.3af)
- Poraba: osnovno 3,6 W; največ 9,5 W (osvetljevalec + PTZ)
- Napajalnik: opcijsko

Okolje
- Delovna temperatura: –30 °C do +55 °C
- Vlažnost: ≤95 %
- Zaščita: IP66, TVS 2000 V (proti udarom strele, prenapetosti, prehodnim napetostim)

Ohišje
- Dimenzije: 153,5 × Φ129,3 mm
- Neto teža: 0,8 kg
- Bruto teža: 1,2 kg

 


Specifikacija

Sorodni izdelki

Kategorije

Naj izdelki

50

DAHUA XVR5104HS-4KL-I3 PENTA-BRID SNEMALNIK WizSense
114,00 €
228,00 €
Dodaj v košarico
40

DAHUA HAC-HFW1801CM-IL-A VIDEO NADZORNA KAMERA
59,40 €
99,00 €
Dodaj v košarico
50

DAHUA EAP5212-C DOSTOPNA TOČKA
59,50 €
119,00 €

KALER GEN-ST2 SOS ODDAJNIK Z GUMBOM
29,00 €

EUROKONUS VIJAK REITER 16x3/4
2,50 €
Dodaj v košarico
0.002 SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/dahua-ipc-pt2849c1-s-pv-pro-ip-vrtljiva-kamera-2086.html"
0.286 SELECT c.id AS category_id, c.CategoryTree, COUNT(DISTINCT p.id) AS product_count FROM Category c JOIN Product p ON ( p.categoryId = c.id OR p.category2Id = c.id OR p.category3Id = c.id OR p.category4Id = c.id OR p.category5Id = c.id OR p.category6Id = c.id ) WHERE p.active = 'yes' GROUP BY c.id ORDER BY c.CategoryTree DESC
0.004 SELECT * FROM Category ORDER BY sequence
0.002 SELECT * FROM Settings
0.003 SELECT * FROM config_data
0.009 SELECT Product.*, t.name AS tm_name, t.homepage AS tm_homepage, t.garancijskaDoba as tm_garancija, Product.preorder, count(productdiscount.productId)>0 AS hasqdisc FROM Product LEFT JOIN trademark AS t ON t.id=Product.trademarkId LEFT JOIN productdiscount ON Product.id=productdiscount.productId WHERE Product.id=2086 GROUP BY Product.id
0.001 SELECT id FROM Category WHERE parentID = 517
0.003 SELECT * FROM Category WHERE parentId = 1075
0.007 SELECT * FROM Category WHERE parentId = 1068
0.001 SELECT * FROM Category WHERE parentId = 684
0.01 SELECT id FROM Category WHERE parentID = 611
0.001 SELECT id FROM Category WHERE parentID = 655
0.002 SELECT id FROM Category WHERE parentID = 1064
0.001 SELECT * FROM Category WHERE parentId = 552
0.002 SELECT * FROM Category WHERE parentId = 690
0.005 SELECT * FROM Category WHERE parentId = 840
0.006 SELECT id FROM Category WHERE parentID = 793
0.002 SELECT * FROM Category WHERE parentId = 799
0.006 SELECT id FROM Category WHERE parentID = 1008
0.009 SELECT * FROM Category WHERE parentId = 1006
0.002 SELECT * FROM Category WHERE parentId = 989
0.002 SELECT id FROM Category WHERE parentID = 1133
0.002 SELECT * FROM Category WHERE parentId = 1136
0.001 SELECT id FROM Category WHERE parentID = 621
0.002 SELECT * FROM Category WHERE parentId = 891
0.009 SELECT id FROM Category WHERE parentID = 1088
0.004 SELECT id FROM Category WHERE parentID = 946
0.001 SELECT id FROM Category WHERE parentID = 950
0.001 SELECT * FROM Category WHERE parentId = 1002
0.001 SELECT * FROM Category WHERE parentId = 940
0.001 SELECT id FROM Category WHERE parentID = 1030
0.003 SELECT id FROM Category WHERE parentID = 1129
0.006 SELECT id FROM Category WHERE parentID = 862
0.004 SELECT id FROM Category WHERE parentID = 865
0.001 SELECT id FROM Category WHERE parentID = 980
0.002 SELECT id FROM Category WHERE parentID = 1203
0.001 SELECT id FROM Category WHERE parentID = 869
0.003 SELECT id FROM Category WHERE parentID = 1040
0.001 SELECT * FROM Category WHERE parentId = 1197
0.001 SELECT id FROM Category WHERE parentID = 874
0.002 SELECT id FROM Category WHERE parentID = 966
0.002 SELECT id FROM Category WHERE parentID = 1013
0.003 SELECT * FROM Category WHERE parentId = 1012
0.001 SELECT * FROM Category WHERE parentId = 844
0.001 SELECT * FROM Category WHERE parentId = 846
0.001 SELECT id FROM Category WHERE parentID = 1081
0.002 SELECT id FROM Category WHERE parentID = 848
0.002 SELECT * FROM Category WHERE parentId = 1026
0.001 SELECT id FROM Category WHERE parentID = 729
0.001 SELECT id FROM Category WHERE parentID = 1021
0.001 SELECT * FROM Category WHERE parentId = 673
0.001 SELECT * FROM Category WHERE parentId = 670
0.003 SELECT * FROM Category WHERE parentId = 889
0.001 SELECT * FROM Category WHERE parentId = 888
0.001 SELECT id FROM Category WHERE parentID = 356
0.002 SELECT id FROM Category WHERE parentID = 357
0.002 SELECT id FROM Category WHERE parentID = 383
0.002 SELECT * FROM Category WHERE parentId = 359
0.001 SELECT id FROM Category WHERE parentID = 336
0.003 SELECT id FROM Category WHERE parentID = 839
0.001 SELECT * FROM Category WHERE parentId = 364
0.001 SELECT id FROM Category WHERE parentID = 678
0.001 SELECT id FROM Category WHERE parentID = 769
0.001 SELECT * FROM Category WHERE parentId = 677
0.001 SELECT id FROM Category WHERE parentID = 378
0.001 SELECT id FROM Category WHERE parentID = 405
0.001 SELECT * FROM Category WHERE parentId = 379
0.002 SELECT * FROM Category WHERE parentId = 401
0.001 SELECT id FROM Category WHERE parentID = 1096
0.001 SELECT id FROM Category WHERE parentID = 969
0.001 SELECT id FROM Category WHERE parentID = 905
0.001 SELECT id FROM Category WHERE parentID = 906
0.001 SELECT * FROM Category WHERE parentId = 935
0.001 SELECT * FROM Category WHERE parentId = 920
0.001 SELECT * FROM Category WHERE parentId = 919
0.001 SELECT id FROM Category WHERE parentID = 915
0.001 SELECT * FROM Category WHERE parentId = 918
0.001 SELECT id FROM Category WHERE parentID = 1049
0.001 SELECT id FROM Category WHERE parentID = 1153
0.001 SELECT * FROM Category WHERE parentId = 1154
0.003 SELECT * FROM Category WHERE parentId = 1158
0.002 SELECT * FROM Category WHERE parentId = 1212
0.005 SELECT id FROM Category WHERE parentID = 1207
0.002 SELECT * FROM Category WHERE parentId = 1161
0.002 SELECT * FROM Category WHERE parentId = 1168
0.001 SELECT id FROM Category WHERE parentID = 1183
0.001 SELECT * FROM Category WHERE parentId = 1184
0.001 SELECT * FROM Category WHERE parentId = 1185
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2))
0.001 SELECT * FROM Category WHERE parentId = 2
0.001 SELECT * FROM Category WHERE parentId = 1075
0.001 SELECT * FROM Category WHERE parentId = 1071
0.001 SELECT * FROM Category WHERE parentId = 684
0.001 SELECT * FROM Category WHERE parentId = 517
0.001 SELECT * FROM Category WHERE parentId = 786
0.001 SELECT * FROM Category WHERE parentId = 91
0.001 SELECT * FROM Category WHERE parentId = 282
0.001 SELECT * FROM Category WHERE parentId = 581
0.003 SELECT * FROM Category WHERE parentId = 481
0.001 SELECT * FROM Category WHERE parentId = 857
0.001 SELECT * FROM Category WHERE parentId = 482
0.002 SELECT * FROM Category WHERE parentId = 472
0.001 SELECT * FROM Category WHERE parentId = 514
0.003 SELECT * FROM Category WHERE parentId = 588
0.005 SELECT * FROM Category WHERE parentId = 626
0.001 SELECT * FROM Category WHERE parentId = 752
0.001 SELECT * FROM Category WHERE parentId = 635
0.001 SELECT * FROM Category WHERE parentId = 636
0.001 SELECT * FROM Category WHERE parentId = 637
0.001 SELECT * FROM Category WHERE parentId = 641
0.001 SELECT * FROM Category WHERE parentId = 1008
0.001 SELECT * FROM Category WHERE parentId = 1137
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5) OR category2Id IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5))
0.001 SELECT * FROM Category WHERE parentId = 5
0.001 SELECT * FROM Category WHERE parentId = 597
0.003 SELECT * FROM Category WHERE parentId = 740
0.001 SELECT * FROM Category WHERE parentId = 741
0.001 SELECT * FROM Category WHERE parentId = 986
0.001 SELECT * FROM Category WHERE parentId = 891
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,6) OR category2Id IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,6))
0.007 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408) OR category2Id IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408))
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84) OR category2Id IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84))
0.001 SELECT * FROM Category WHERE parentId = 846
0.005 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197))
0.001 SELECT * FROM Category WHERE parentId = 555
0.003 SELECT * FROM Category WHERE parentId = 732
0.001 SELECT * FROM Category WHERE parentId = 724
0.001 SELECT * FROM Category WHERE parentId = 725
0.001 SELECT * FROM Category WHERE parentId = 726
0.001 SELECT * FROM Category WHERE parentId = 887
0.001 SELECT * FROM Category WHERE parentId = 889
0.001 SELECT * FROM Category WHERE parentId = 1021
0.001 SELECT * FROM Category WHERE parentId = 354
0.001 SELECT * FROM Category WHERE parentId = 356
0.001 SELECT * FROM Category WHERE parentId = 357
0.001 SELECT * FROM Category WHERE parentId = 359
0.001 SELECT * FROM Category WHERE parentId = 383
0.001 SELECT * FROM Category WHERE parentId = 383
0.001 SELECT * FROM Category WHERE parentId = 313
0.001 SELECT * FROM Category WHERE parentId = 335
0.001 SELECT * FROM Category WHERE parentId = 336
0.001 SELECT * FROM Category WHERE parentId = 839
0.001 SELECT * FROM Category WHERE parentId = 364
0.001 SELECT * FROM Category WHERE parentId = 365
0.001 SELECT * FROM Category WHERE parentId = 656
0.001 SELECT * FROM Category WHERE parentId = 677
0.001 SELECT * FROM Category WHERE parentId = 768
0.011 SELECT * FROM Category WHERE parentId = 772
0.002 SELECT * FROM Category WHERE parentId = 377
0.003 SELECT * FROM Category WHERE parentId = 378
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625))
0.001 SELECT * FROM Category WHERE parentId = 898
0.002 SELECT * FROM Category WHERE parentId = 927
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152))
0.001 SELECT * FROM Category WHERE parentId = 1158
0.001 SELECT * FROM Category WHERE parentId = 1161
0.001 SELECT * FROM Category WHERE parentId = 1163
0.001 SELECT * FROM Category WHERE parentId = 1167
0.001 SELECT * FROM Category WHERE parentId = 1166
0.002 SELECT * FROM Category WHERE parentId = 1168
0.001 SELECT * FROM Category WHERE parentId = 1182
0.001 SELECT Product.*, t.name AS tm_name, t.homepage AS tm_homepage, t.garancijskaDoba as tm_garancija, Product.preorder, count(productdiscount.productId)>0 AS hasqdisc FROM Product LEFT JOIN trademark AS t ON t.id=Product.trademarkId LEFT JOIN productdiscount ON Product.id=productdiscount.productId WHERE Product.id=2086 GROUP BY Product.id
0.001 SELECT ColorTable.* FROM ColorTable, ProductColor WHERE ColorTable.id=ProductColor.colorId AND ProductColor.productId=2086 ORDER BY id
0.001 SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 2086 AND definesPackagePart='no' AND additional_product = '0') AND active='yes' ORDER BY (Product.unitPrice*(1-Product.discount/100))
0.001 SELECT COUNT(*) AS product_count FROM Product WHERE `categoryId` = "587" AND `id` != "2086"AND Product.active = "yes" GROUP BY Product.id ORDER BY unitPrice
0.001 SELECT Product.* FROM Product WHERE `categoryId` = "587" AND `id` != "2086"AND Product.active = "yes" GROUP BY Product.id ORDER BY unitPrice LIMIT 5
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=188
0.005 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5) OR category2Id IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5))
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,6) OR category2Id IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,6))
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408) OR category2Id IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84) OR category2Id IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84))
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625))
0.006 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152))
0.001 SELECT COUNT(*) AS product_count FROM Product WHERE Product.id IN (4,63,88,196,241,415,617,799,1180,1184,1195,1309,1360,1575,1938) AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC
0.001 SELECT Product.* FROM Product WHERE Product.id IN (4,63,88,196,241,415,617,799,1180,1184,1195,1309,1360,1575,1938) AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 5
0.001 SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=63 AND definesPackagePart='yes'
0.001 SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=241 AND definesPackagePart='yes'
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=63
0.001 SELECT defaultDiscount FROM Category WHERE id = 667
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1180