DAHUA IPC-HFW5859E1-ZE-IL IP VIDEO NADZORNA KAMERA WizMind

790,00 €

8MP (3840x2160) - 30fps / Motorizirana leča 113°–47° / Min. svetloba: 0.0008 LUX / LED domet do 60m / Poraba max. 12.9W / Inteligenca (Prestop linije, vdor), zaznavanje obrazov, štetje ljudi, toplotna mapa / SMD / Dvosmerni avdio / Vgrajen zvočni in svetl

  • Blagovna znamka:
    DAHUA
  • Koda:
    IPC-HFW5859E1-ZE-IL
  • Zaloga:
    Ni na zalogi

Opis

Glavne značilnosti
•    1/1.8" 8 MP CMOS senzor
•    Največ 25/30 fps @ 8 MP (3840 × 2160)
•    IR osvetlitev do 60 m in topla LED osvetlitev do 60 m
•    Motorizirana P-Iris leča 2.7–12 mm
•    WDR 120 dB / 3D NR / HLC / BLC / EIS / Defog
•    Napredni Xinghan AI modeli za izboljšano zaznavanje in prepoznavanje objektov
•    SMD 4.0 / AcuPick / IVS / Face Detection / People Counting / Video Metadata
•    Podpora za MicroSD do 1 TB
•    Dvosmerna avdio povezava (vhod + izhod)
•    12 VDC / PoE+ / ePoE
•    IP67 in IK10 zaščita
 

Tehnične specifikacije
Kamera
•    Senzor slike: 1/1.8" CMOS
•    Ločljivost: 8 MP (3840 × 2160)
•    Sistem skeniranja: progresiven
•    Elektronska zaklopka: 1/3 s – 1/100.000 s
•    Minimalna osvetlitev: 0,0008 lux @ F1.6 (barvno), 0,0004 lux @ F1.6 (Č/B), 0 lux (pri vključenem IR)
•    Razmerje signal/šum: >56 dB
•    IR razdalja: do 60 m
•    Topla osvetlitev: do 60 m
•    Osvetljevalnik: 4× večjedrni (IR + topla svetloba)
•    Nastavitev kota: Pan 0°–360° / Tilt 0°–90° / Rotacija 0°–360°

Leča
•    Tip leče: motorizirana vari-fokalna
•    Goriščna razdalja: 2.7–12 mm
•    Največja zaslonka: F1.8
•    Tip zaslonke: P-Iris (samodejna)
•    Vidni kot: H: 113°–47°; V: 60°–23°; D: 133°–53°
•    Najmanjša razdalja ostrenja: 0,13 m
•    DORI razdalje (Detect – Observe – Recognize – Identify)
     •    Široki kot (W) – zaznavanje: 83 m – opazovanje: 33 m – prepoznavanje: 16 m – identifikacija: 8 m
     •    Tele (T) – zaznavanje: 189 m – opazovanje: 75 m – prepoznavanje: 37 m – identifikacija: 19 m
DORI (EN-62676-4) določa sposobnost opazovalca, da na posnetku prepozna osebe ali predmete.
Podane vrednosti so teoretične in ne odražajo razdalj inteligentnih funkcij. Za natančne vrednosti glejte navodila za namestitev ali projektno orodje proizvajalca.

Video in zvok
•    Kompresija: H.265 / H.264 / MJPEG (sub stream)
•    AI kodiranje: AI H.265 / AI H.264 / Smart H.265+
•    Glavni tok: 3840 × 2160 @25/30 fps
•    Dodatni tokovi: do 4 hkratni tokovi
•    Dvosmerni zvok: da (1× vhod RCA, 1× izhod RCA)
•    Zvočna kompresija: G.711a / G.711Mu / PCM / G.726 / G.723

Inteligentne funkcije (AI)
•    SMD 4.0 – napredna detekcija ljudi, živali in vozil
•    AcuPick – hitro iskanje in primerjava tarč v živo ali na posnetkih
•    IVS – inteligentna video analiza: vdor, prehod črte, parkiranje, gibanje, zadrževanje, zbiranje ljudi
•    Face Detection – zaznavanje in zajem obraza, optimizacija, atributi in filtriranje
•    People Counting – štetje ljudi, območij in čakalnih vrst (poročila dnevno/teden/mesec/leto)
•    Video Metadata – analiza in atributi vozil, ljudi, obrazov in teles
•    Heat Map – prikaz koncentracije gibanja

Omrežje in shranjevanje
•    Mrežni vmesnik: RJ-45 (10/100 Base-T)
•    Protokoli: IPv4/IPv6, HTTP, TCP/UDP, RTSP, RTMP, FTP, SFTP, SNMP, P2P, ONVIF (S/G/T/M)
•    Uporabniki: do 20 hkratnih povezav (80 Mbit/s skupno)
•    Shranjevanje: MicroSD do 1 TB / NAS / FTP
•    Upravljanje: DSS / DMSS / DoLynk Care
•    Mobilna aplikacija: iOS / Android

Alarmi in dogodki
•    Alarmni vhodi/izhodi: 2 in / 1 out
•    Dogodki: zaznava gibanja, manipulacija, prehod črte, vdor, zvok, napaka SD, detekcija obrazov, ljudi, čakalnih vrst, defokus, IP konflikt, nepooblaščen dostop, varnostne izjeme

Napajanje
•    Napajanje: 12 VDC (±30%) / PoE+ (802.3at) / ePoE
•    Poraba: osnovna 3,7 W (12 VDC), največ 12,9 W (IR + WDR + AI aktivno)
•    Dvojno napajanje: kamera deluje brez ponovnega zagona ob preklopu vira

Ohišje in okolje
•    Material: kovinsko ohišje
•    Zaščita: IP67 / IK10
•    Temperaturno območje: –40 °C do +60 °C
•    Vlažnost: ≤95 % (brez kondenzacije)
•    Dimenzije: 279,8 × 96,7 × 94,9 mm
•    Teža: 1,09 kg (neto)

Certifikati
•    CE-LVD: EN62368-1
•    CE-EMC: 2014/30/EU

 


Specifikacija

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.007 SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/dahua-ipc-hfw5859e1-ze-il-ip-video-nadzorna-kamera-wizmind-2084.html"
0.224 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.008 SELECT * FROM Category ORDER BY sequence
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=2084 GROUP BY Product.id
0.003 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=2084 AND definesPackagePart='yes'
0.001 SELECT id FROM Category WHERE parentID = 518
0.001 SELECT id FROM Category WHERE parentID = 686
0.001 SELECT id FROM Category WHERE parentID = 687
0.003 SELECT id FROM Category WHERE parentID = 688
0.003 SELECT id FROM Category WHERE parentID = 689
0.001 SELECT id FROM Category WHERE parentID = 534
0.001 SELECT id FROM Category WHERE parentID = 1101
0.001 SELECT id FROM Category WHERE parentID = 1102
0.001 SELECT id FROM Category WHERE parentID = 645
0.001 SELECT id FROM Category WHERE parentID = 653
0.001 SELECT id FROM Category WHERE parentID = 776
0.002 SELECT id FROM Category WHERE parentID = 833
0.001 SELECT id FROM Category WHERE parentID = 783
0.001 SELECT id FROM Category WHERE parentID = 784
0.001 SELECT id FROM Category WHERE parentID = 785
0.001 SELECT id FROM Category WHERE parentID = 786
0.001 SELECT id FROM Category WHERE parentID = 787
0.001 SELECT id FROM Category WHERE parentID = 788
0.001 SELECT id FROM Category WHERE parentID = 979
0.001 SELECT id FROM Category WHERE parentID = 802
0.001 SELECT * FROM Category WHERE parentId = 81
0.001 SELECT * FROM Category WHERE parentId = 171
0.001 SELECT * FROM Category WHERE parentId = 470
0.001 SELECT id FROM Category WHERE parentID = 596
0.001 SELECT id FROM Category WHERE parentID = 481
0.001 SELECT id FROM Category WHERE parentID = 855
0.001 SELECT id FROM Category WHERE parentID = 1056
0.001 SELECT id FROM Category WHERE parentID = 1057
0.001 SELECT id FROM Category WHERE parentID = 496
0.001 SELECT id FROM Category WHERE parentID = 498
0.001 SELECT id FROM Category WHERE parentID = 739
0.001 SELECT id FROM Category WHERE parentID = 750
0.001 SELECT * FROM Category WHERE parentId = 502
0.001 SELECT * FROM Category WHERE parentId = 611
0.001 SELECT * FROM Category WHERE parentId = 596
0.001 SELECT * FROM Category WHERE parentId = 481
0.001 SELECT * FROM Category WHERE parentId = 855
0.001 SELECT * FROM Category WHERE parentId = 482
0.001 SELECT * FROM Category WHERE parentId = 1057
0.001 SELECT * FROM Category WHERE parentId = 496
0.001 SELECT * FROM Category WHERE parentId = 498
0.001 SELECT * FROM Category WHERE parentId = 709
0.006 SELECT * FROM Category WHERE parentId = 739
0.003 SELECT * FROM Category WHERE parentId = 750
0.001 SELECT * FROM Category WHERE parentId = 1083
0.001 SELECT id FROM Category WHERE parentID = 514
0.001 SELECT id FROM Category WHERE parentID = 602
0.001 SELECT id FROM Category WHERE parentID = 552
0.001 SELECT id FROM Category WHERE parentID = 553
0.001 SELECT id FROM Category WHERE parentID = 476
0.001 SELECT id FROM Category WHERE parentID = 690
0.002 SELECT id FROM Category WHERE parentID = 576
0.001 SELECT id FROM Category WHERE parentID = 708
0.001 SELECT id FROM Category WHERE parentID = 738
0.002 SELECT id FROM Category WHERE parentID = 680
0.002 SELECT id FROM Category WHERE parentID = 515
0.001 SELECT * FROM Category WHERE parentId = 603
0.001 SELECT * FROM Category WHERE parentId = 475
0.001 SELECT * FROM Category WHERE parentId = 475
0.001 SELECT * FROM Category WHERE parentId = 476
0.001 SELECT * FROM Category WHERE parentId = 576
0.001 SELECT * FROM Category WHERE parentId = 756
0.001 SELECT * FROM Category WHERE parentId = 516
0.002 SELECT * FROM Category WHERE parentId = 840
0.001 SELECT id FROM Category WHERE parentID = 960
0.001 SELECT id FROM Category WHERE parentID = 1125
0.001 SELECT * FROM Category WHERE parentId = 632
0.001 SELECT * FROM Category WHERE parentId = 635
0.001 SELECT * FROM Category WHERE parentId = 636
0.001 SELECT * FROM Category WHERE parentId = 793
0.001 SELECT * FROM Category WHERE parentId = 794
0.001 SELECT * FROM Category WHERE parentId = 796
0.001 SELECT * FROM Category WHERE parentId = 797
0.002 SELECT id FROM Category WHERE parentID = 631
0.001 SELECT id FROM Category WHERE parentID = 640
0.001 SELECT id FROM Category WHERE parentID = 641
0.002 SELECT id FROM Category WHERE parentID = 642
0.002 SELECT id FROM Category WHERE parentID = 1041
0.001 SELECT * FROM Category WHERE parentId = 631
0.001 SELECT * FROM Category WHERE parentId = 641
0.004 SELECT * FROM Category WHERE parentId = 642
0.001 SELECT * FROM Category WHERE parentId = 643
0.002 SELECT * FROM Category WHERE parentId = 1043
0.002 SELECT * FROM Category WHERE parentId = 976
0.001 SELECT * FROM Category WHERE parentId = 1007
0.001 SELECT id FROM Category WHERE parentID = 1149
0.001 SELECT * FROM Category WHERE parentId = 1108
0.001 SELECT * FROM Category WHERE parentId = 1110
0.001 SELECT * FROM Category WHERE parentId = 1133
0.001 SELECT * FROM Category WHERE parentId = 1135
0.001 SELECT * FROM Category WHERE parentId = 1136
0.004 SELECT * FROM Category WHERE parentId = 1139
0.001 SELECT id FROM Category WHERE parentID = 1141
0.001 SELECT id FROM Category WHERE parentID = 1216
0.002 SELECT id FROM Category WHERE parentID = 115
0.004 SELECT id FROM Category WHERE parentID = 598
0.001 SELECT id FROM Category WHERE parentID = 540
0.001 SELECT * FROM Category WHERE parentId = 424
0.002 SELECT id FROM Category WHERE parentID = 743
0.002 SELECT id FROM Category WHERE parentID = 744
0.001 SELECT * FROM Category WHERE parentId = 741
0.001 SELECT * FROM Category WHERE parentId = 876
0.001 SELECT id FROM Category WHERE parentID = 1089
0.001 SELECT id FROM Category WHERE parentID = 1097
0.001 SELECT id FROM Category WHERE parentID = 1128
0.003 SELECT * FROM Category WHERE parentId = 6
0.001 SELECT id FROM Category WHERE parentID = 956
0.001 SELECT id FROM Category WHERE parentID = 991
0.001 SELECT id FROM Category WHERE parentID = 993
0.002 SELECT id FROM Category WHERE parentID = 997
0.001 SELECT * FROM Category WHERE parentId = 1000
0.001 SELECT id FROM Category WHERE parentID = 1067
0.001 SELECT id FROM Category WHERE parentID = 246
0.001 SELECT * FROM Category WHERE parentId = 367
0.001 SELECT * FROM Category WHERE parentId = 950
0.001 SELECT id FROM Category WHERE parentID = 955
0.001 SELECT id FROM Category WHERE parentID = 1033
0.004 SELECT id FROM Category WHERE parentID = 939
0.001 SELECT * FROM Category WHERE parentId = 837
0.001 SELECT * FROM Category WHERE parentId = 941
0.001 SELECT id FROM Category WHERE parentID = 945
0.001 SELECT id FROM Category WHERE parentID = 1127
0.001 SELECT * FROM Category WHERE parentId = 862
0.001 SELECT * FROM Category WHERE parentId = 864
0.001 SELECT id FROM Category WHERE parentID = 869
0.001 SELECT id FROM Category WHERE parentID = 1038
0.002 SELECT * FROM Category WHERE parentId = 1040
0.009 SELECT id FROM Category WHERE parentID = 872
0.001 SELECT id FROM Category WHERE parentID = 874
0.001 SELECT * FROM Category WHERE parentId = 1012
0.002 SELECT * FROM Category WHERE parentId = 1013
0.001 SELECT id FROM Category WHERE parentID = 843
0.001 SELECT id FROM Category WHERE parentID = 844
0.002 SELECT id FROM Category WHERE parentID = 846
0.001 SELECT * FROM Category WHERE parentId = 845
0.001 SELECT * FROM Category WHERE parentId = 846
0.001 SELECT * FROM Category WHERE parentId = 848
0.001 SELECT id FROM Category WHERE parentID = 731
0.001 SELECT id FROM Category WHERE parentID = 889
0.001 SELECT id FROM Category WHERE parentID = 888
0.001 SELECT id FROM Category WHERE parentID = 1020
0.008 SELECT id FROM Category WHERE parentID = 1021
0.002 SELECT * FROM Category WHERE parentId = 555
0.001 SELECT * FROM Category WHERE parentId = 672
0.001 SELECT * FROM Category WHERE parentId = 726
0.001 SELECT * FROM Category WHERE parentId = 889
0.001 SELECT * FROM Category WHERE parentId = 1021
0.001 SELECT * FROM Category WHERE parentId = 1095
0.007 SELECT id FROM Category WHERE parentID = 354
0.001 SELECT id FROM Category WHERE parentID = 385
0.001 SELECT id FROM Category WHERE parentID = 366
0.001 SELECT * FROM Category WHERE parentId = 401
0.001 SELECT id FROM Category WHERE parentID = 1078
0.006 SELECT * FROM Category WHERE parentId = 899
0.001 SELECT * FROM Category WHERE parentId = 973
0.001 SELECT * FROM Category WHERE parentId = 914
0.001 SELECT * FROM Category WHERE parentId = 1183
0.004 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 = 502
0.001 SELECT * FROM Category WHERE parentId = 856
0.001 SELECT * FROM Category WHERE parentId = 475
0.001 SELECT * FROM Category WHERE parentId = 576
0.001 SELECT * FROM Category WHERE parentId = 756
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 = 740
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.002 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.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.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 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=2084 GROUP BY Product.id
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=2084 GROUP BY Product.id
0.001 SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 2084 AND definesPackagePart='no' AND additional_product = '0') AND active='yes' ORDER BY (Product.unitPrice*(1-Product.discount/100))
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=386 AND definesPackagePart='yes'
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.003 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.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.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.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.002 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.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 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'