DAHUA ITC831-KW4F ANPR VIDEO NADZORNA KAMERA Z RADARJEM

2.022,00 €

4Mp (3840 × 2160) - 30fps / Motorizirana leča 42°–15° / Min. svetloba: 0.0001 LUX / LED domet do 23-30m / Pokritost: do 3 vozne pasove / Poraba max. 17W / Prepoznava vozil / ANPR / Zaznavanje prometnega toka / Vgrajen radar

  • Blagovna znamka:
    DAHUA
  • Koda:
    ITC831-KW4F
  • Zaloga:
    Ni na zalogi

Opis

Glavne značilnosti
•    Slikovni senzor: 1/1.8" 8 MP Starlight CMOS
•    Največja ločljivost: 3840 × 2160 @ 30 sličic/s
•    Video kompresija: H.265 / H.264M / H.264H / MJPEG
•    Napredna tehnologija slike za delovanje v izjemno slabih svetlobnih pogojih in popolni temi
•    Vgrajen milimetrski radarski modul za merjenje hitrosti
•    Dvojna LED osvetlitev (topla svetloba 3500 K ali IR 850 nm) z možnostjo preklopa
•    Motorno nastavljiva varifokalna leča 8–32 mm (F1.6)
•    Zaščita ohišja: IP68 / IK10
•    Delovna temperatura: –30 °C do +65 °C
•    Moč merjenja hitrosti vozil: 5 km/h–180 km/h
•    Pokritost: do 3 vozne pasove

 

Kamera
•    Senzor slike: 1/1.8" CMOS
•    Ločljivost: 8 MP
•    Način zaklopa: enojni zaklop
•    Elektronski zaklop: 1/50 s – 1/100.000 s (samodejno ali ročno)
•    Dinamični razpon (WDR): 140 dB
•    Razmerje signal/šum: > 56 dB
•    Zmanjševanje šuma: 3D NR
•    Minimalna osvetlitev: 0,0001 lux

Osvetljevalnik
•    Število LED: 3 (IR 850 nm ali 3500 K topla svetloba)
•    Svetilnost: nastavljiva
•    Domet osvetlitve: 23–30 m (nastavljiva svetlost)
•    Pokritost: 1–3 vozni pasovi

Leča
•    Tip leče: motorizirana varifokalna
•    Goriščna razdalja: 8–32 mm
•    Največja zaslonka: F1.6
•    Vidni kot:
     – Horizontalno: 42°–15°
     – Vertikalno: 22,8°–8,4°
     – Diagonalno: 48,7°–17,1°
•    Način osvetlitve: samodejno / ročno

DORI razdalje
•    Široki kot (W):
     – Zaznavanje: 218 m
     – Opazovanje: 87,2 m
     – Prepoznavanje: 43,6 m
     – Identifikacija: 21,8 m
•    Telefoto (T):
     – Zaznavanje: 580 m
     – Opazovanje: 232 m
     – Prepoznavanje: 116 m
     – Identifikacija: 58 m

Radar
•    Frekvenčno območje: 61–62 GHz
•    Natančnost merjenja hitrosti: ±2 km/h
•    Razpon zaznavanja hitrosti: 5–180 km/h
•    Število zaznanih tarč: do 32

Funkcije
•    Način sprožitve: video ali radar
•    OSD prikaz: čas, naslov, serijska številka naprave, številka pasu, registrska tablica, barva tablice, znamka in tip vozila, barva vozila, velikost, hitrost, država/regija, ime dogodka (kršitev), atributi motornega kolesa (tip, število oseb, čelada)
•    Dogodki alarma: polna ali poškodovana shramba, zunanji alarm, manjkajoča kartica, črna lista, nepooblaščen dostop, prekinjena povezava, IP konflikt, vdor, neregistrirano vozilo
•    ANR funkcija: samodejno shranjevanje na TF kartico ob izpadu povezave
•    Samodejna registracija: podprta
•    Seznam dovoljenih in prepovedanih registracij: po 10.000 zapisov

Pametne funkcije
•    Zaznavanje ciljev: motorna vozila, motorna kolesa
•    ANPR (prepoznavanje tablic): z algoritmi globokega učenja
•    Prepoznavanje vrste vozila (spredaj in zadaj): SUV, avtobus, osebno vozilo, lahek ali težek tovornjak, kombi, MPV, pickup
•    Prepoznavanje barve vozila: bela, roza, črna, rdeča, rumena, siva, modra, zelena, temno oranžna, vijolična, rjava, srebrno siva
•    Prepoznavanje znamke/logotipa vozila: podpora več kot 60 proizvajalcem (Audi, BMW, Mercedes, Toyota, Volkswagen, Tesla itd.)
•    Zaznavanje prometnih prekrškov motornih vozil: prekoračitev hitrosti, počasna vožnja, vožnja v napačno smer, menjava pasu
•    Zaznavanje prekrškov motoristov: brez čelade, vožnja v napačno smer, prevoz potnikov
•    Zaznavanje prometnega toka: do 4 pasovi, statistika prometa (pretok, povprečna hitrost, vrsta vozila, zasedenost pasu, čakalna vrsta, stanje ceste)
•    Zaznavanje dogodkov: nelegalno parkiranje, zastoje

Video
•    Kodiranje: H.265 / H.264M / H.264H / MJPEG
•    Ločljivost: 8MP (3840×2160) / 1080p / 720p
•    Hitrost sličic: do 25 fps (50 Hz) / 30 fps (60 Hz)
•    Bitrate: 32–32768 kbps (CBR/VBR)
•    Nastavitve slike: avtomatsko uravnavanje beline, HLC, BLC, korekcija slabih pik, ojačitev slike
•    Združene slike: podpora sestavljanju do 3 virov + bližnji posnetek
•    Format slike: JPEG
•    Digitalni vodni žig: da

Omrežje
•    Vmesnik: 1 × RJ-45 Ethernet
•    Podprti protokoli: IPv4 / IPv6 / DHCP / NTP / HTTP / UDP / TCP
•    Varnost: geslo, MAC vezava, HTTPS, nadzor dostopa
•    Standardi ONVIF: Profile S / G / T / M
•    Podpora SDK in API
•    Shranjevanje: 1 × TF kartica do 1 TB

Vmesniki
•    RS-485: 1
•    RS-232: 1
•    Alarmni vhod: 1
•    Alarmni izhod: 2

Splošno
•    Napajanje: PoE / 12 VDC
•    Poraba energije:
     – brez luči < 8 W
     – IR luč < 12 W
     – topla luč < 17 W
•    Delovna temperatura: –30 °C do +65 °C
•    Vlažnost delovanja: 10–90 % (brez kondenza)
•    Odpornost proti udarcem in vremenskim vplivom: IK10 / IP68
•    Stopnja protikorozijske zaščite: osnovna
•    Certifikati: CE-LVD, CE-EMC, CE-RED, EN62368-1, EN61000-3-3, EN301908-13, EN305550-2, EN62311
•    Dimenzije izdelka: 350 × 109 × 150 mm (D × Š × V)
•    Dimenzije pakiranja: 400 × 197 × 171 mm
•    Neto teža: 1,88 kg
•    Bruto teža: 2,52 kg
•    Način montaže: univerzalni nosilec ali montaža ob strani

 


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-itc831-kw4f-anpr-video-nadzorna-kamera-z-radarjem-2089.html"
0.199 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.005 SELECT * FROM Category ORDER BY sequence
0.005 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=2089 GROUP BY Product.id
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=2089 AND definesPackagePart='yes'
0.001 SELECT * FROM productdiscount WHERE productId=2089 AND priceType='normal' ORDER BY minquantity
0.002 SELECT * FROM productdiscount WHERE productId=2089 AND priceType='gross' ORDER BY minquantity
0.001 SELECT * FROM trademark ORDER BY name ASC
0.001 SELECT * FROM Category WHERE parentId = 2
0.001 SELECT id FROM Category WHERE parentID = 470
0.003 SELECT id FROM Category WHERE parentID = 206
0.001 SELECT id FROM Category WHERE parentID = 1074
0.009 SELECT id FROM Category WHERE parentID = 1071
0.002 SELECT id FROM Category WHERE parentID = 1076
0.001 SELECT id FROM Category WHERE parentID = 691
0.001 SELECT id FROM Category WHERE parentID = 686
0.002 SELECT id FROM Category WHERE parentID = 689
0.001 SELECT id FROM Category WHERE parentID = 683
0.001 SELECT id FROM Category WHERE parentID = 645
0.001 SELECT id FROM Category WHERE parentID = 776
0.001 SELECT id FROM Category WHERE parentID = 785
0.001 SELECT id FROM Category WHERE parentID = 787
0.001 SELECT id FROM Category WHERE parentID = 979
0.002 SELECT * FROM Category WHERE parentId = 206
0.001 SELECT * FROM Category WHERE parentId = 1074
0.001 SELECT * FROM Category WHERE parentId = 684
0.001 SELECT * FROM Category WHERE parentId = 517
0.002 SELECT * FROM Category WHERE parentId = 683
0.001 SELECT * FROM Category WHERE parentId = 534
0.001 SELECT * FROM Category WHERE parentId = 1102
0.001 SELECT * FROM Category WHERE parentId = 645
0.001 SELECT * FROM Category WHERE parentId = 776
0.005 SELECT * FROM Category WHERE parentId = 787
0.001 SELECT id FROM Category WHERE parentID = 281
0.001 SELECT * FROM Category WHERE parentId = 91
0.001 SELECT * FROM Category WHERE parentId = 282
0.001 SELECT * FROM Category WHERE parentId = 283
0.001 SELECT * FROM Category WHERE parentId = 324
0.001 SELECT id FROM Category WHERE parentID = 474
0.005 SELECT id FROM Category WHERE parentID = 506
0.001 SELECT id FROM Category WHERE parentID = 482
0.001 SELECT id FROM Category WHERE parentID = 496
0.009 SELECT id FROM Category WHERE parentID = 497
0.001 SELECT id FROM Category WHERE parentID = 498
0.001 SELECT id FROM Category WHERE parentID = 587
0.002 SELECT id FROM Category WHERE parentID = 709
0.001 SELECT id FROM Category WHERE parentID = 739
0.001 SELECT id FROM Category WHERE parentID = 748
0.001 SELECT * FROM Category WHERE parentId = 1035
0.001 SELECT * FROM Category WHERE parentId = 496
0.004 SELECT * FROM Category WHERE parentId = 497
0.004 SELECT * FROM Category WHERE parentId = 750
0.002 SELECT id FROM Category WHERE parentID = 751
0.003 SELECT id FROM Category WHERE parentID = 756
0.002 SELECT id FROM Category WHERE parentID = 477
0.001 SELECT id FROM Category WHERE parentID = 840
0.001 SELECT * FROM Category WHERE parentId = 600
0.003 SELECT * FROM Category WHERE parentId = 1194
0.002 SELECT * FROM Category WHERE parentId = 515
0.001 SELECT id FROM Category WHERE parentID = 636
0.002 SELECT id FROM Category WHERE parentID = 637
0.001 SELECT id FROM Category WHERE parentID = 644
0.002 SELECT id FROM Category WHERE parentID = 1005
0.005 SELECT * FROM Category WHERE parentId = 424
0.007 SELECT * FROM Category WHERE parentId = 425
0.001 SELECT * FROM Category WHERE parentId = 1087
0.003 SELECT * FROM Category WHERE parentId = 952
0.006 SELECT id FROM Category WHERE parentID = 773
0.004 SELECT id FROM Category WHERE parentID = 834
0.007 SELECT id FROM Category WHERE parentID = 1034
0.001 SELECT * FROM Category WHERE parentId = 939
0.002 SELECT id FROM Category WHERE parentID = 869
0.005 SELECT id FROM Category WHERE parentID = 1199
0.001 SELECT * FROM Category WHERE parentId = 1198
0.002 SELECT id FROM Category WHERE parentID = 1011
0.001 SELECT * FROM Category WHERE parentId = 1010
0.002 SELECT * FROM Category WHERE parentId = 1011
0.001 SELECT * FROM Category WHERE parentId = 1013
0.001 SELECT * FROM Category WHERE parentId = 84
0.003 SELECT id FROM Category WHERE parentID = 843
0.001 SELECT * FROM Category WHERE parentId = 846
0.001 SELECT id FROM Category WHERE parentID = 841
0.001 SELECT id FROM Category WHERE parentID = 847
0.004 SELECT * FROM Category WHERE parentId = 848
0.002 SELECT id FROM Category WHERE parentID = 1095
0.001 SELECT * FROM Category WHERE parentId = 671
0.001 SELECT * FROM Category WHERE parentId = 887
0.001 SELECT * FROM Category WHERE parentId = 889
0.003 SELECT id FROM Category WHERE parentID = 356
0.001 SELECT * FROM Category WHERE parentId = 383
0.003 SELECT id FROM Category WHERE parentID = 336
0.001 SELECT id FROM Category WHERE parentID = 350
0.008 SELECT * FROM Category WHERE parentId = 667
0.001 SELECT * FROM Category WHERE parentId = 677
0.001 SELECT * FROM Category WHERE parentId = 772
0.003 SELECT id FROM Category WHERE parentID = 377
0.001 SELECT id FROM Category WHERE parentID = 959
0.001 SELECT id FROM Category WHERE parentID = 1090
0.003 SELECT id FROM Category WHERE parentID = 1096
0.003 SELECT id FROM Category WHERE parentID = 972
0.001 SELECT id FROM Category WHERE parentID = 938
0.007 SELECT * FROM Category WHERE parentId = 897
0.003 SELECT * FROM Category WHERE parentId = 899
0.001 SELECT * FROM Category WHERE parentId = 921
0.002 SELECT * FROM Category WHERE parentId = 898
0.002 SELECT * FROM Category WHERE parentId = 930
0.001 SELECT * FROM Category WHERE parentId = 971
0.001 SELECT * FROM Category WHERE parentId = 905
0.002 SELECT * FROM Category WHERE parentId = 990
0.001 SELECT * FROM Category WHERE parentId = 1018
0.001 SELECT id FROM Category WHERE parentID = 918
0.001 SELECT id FROM Category WHERE parentID = 1024
0.006 SELECT * FROM Category WHERE parentId = 1024
0.001 SELECT id FROM Category WHERE parentID = 1157
0.001 SELECT id FROM Category WHERE parentID = 1163
0.002 SELECT * FROM Category WHERE parentId = 1164
0.008 SELECT * FROM Category WHERE parentId = 1167
0.001 SELECT * FROM Category WHERE parentId = 1178
0.001 SELECT id FROM Category WHERE parentID = 1168
0.001 SELECT * FROM Category WHERE parentId = 1182
0.002 SELECT id FROM Category WHERE parentID = 1184
0.001 SELECT id FROM Category WHERE parentID = 1188
0.009 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 = 81
0.004 SELECT * FROM Category WHERE parentId = 171
0.002 SELECT * FROM Category WHERE parentId = 535
0.001 SELECT * FROM Category WHERE parentId = 206
0.004 SELECT * FROM Category WHERE parentId = 1070
0.001 SELECT * FROM Category WHERE parentId = 1073
0.002 SELECT * FROM Category WHERE parentId = 1069
0.001 SELECT * FROM Category WHERE parentId = 1075
0.003 SELECT * FROM Category WHERE parentId = 264
0.001 SELECT * FROM Category WHERE parentId = 518
0.003 SELECT * FROM Category WHERE parentId = 734
0.002 SELECT * FROM Category WHERE parentId = 685
0.002 SELECT * FROM Category WHERE parentId = 687
0.001 SELECT * FROM Category WHERE parentId = 688
0.002 SELECT * FROM Category WHERE parentId = 689
0.001 SELECT * FROM Category WHERE parentId = 517
0.006 SELECT * FROM Category WHERE parentId = 683
0.003 SELECT * FROM Category WHERE parentId = 1101
0.001 SELECT * FROM Category WHERE parentId = 776
0.001 SELECT * FROM Category WHERE parentId = 783
0.001 SELECT * FROM Category WHERE parentId = 91
0.004 SELECT * FROM Category WHERE parentId = 1036
0.002 SELECT * FROM Category WHERE parentId = 602
0.002 SELECT * FROM Category WHERE parentId = 552
0.004 SELECT * FROM Category WHERE parentId = 476
0.005 SELECT * FROM Category WHERE parentId = 738
0.001 SELECT * FROM Category WHERE parentId = 752
0.003 SELECT * FROM Category WHERE parentId = 793
0.001 SELECT * FROM Category WHERE parentId = 976
0.002 SELECT * FROM Category WHERE parentId = 1108
0.002 SELECT * FROM Category WHERE parentId = 1109
0.002 SELECT * FROM Category WHERE parentId = 1138
0.003 SELECT id FROM Category WHERE parentID = 5
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.002 SELECT * FROM Category WHERE parentId = 597
0.002 SELECT * FROM Category WHERE parentId = 986
0.001 SELECT * FROM Category WHERE parentId = 984
0.002 SELECT * FROM Category WHERE parentId = 876
0.001 SELECT * FROM Category WHERE parentId = 1088
0.001 SELECT * FROM Category WHERE parentId = 1089
0.001 SELECT id FROM Category WHERE parentID = 6
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.001 SELECT * FROM Category WHERE parentId = 6
0.001 SELECT * FROM Category WHERE parentId = 139
0.001 SELECT * FROM Category WHERE parentId = 233
0.004 SELECT * FROM Category WHERE parentId = 250
0.001 SELECT * FROM Category WHERE parentId = 993
0.001 SELECT * FROM Category WHERE parentId = 998
0.004 SELECT * FROM Category WHERE parentId = 1000
0.001 SELECT * FROM Category WHERE parentId = 246
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 * FROM Category WHERE parentId = 408
0.001 SELECT * FROM Category WHERE parentId = 860
0.001 SELECT * FROM Category WHERE parentId = 863
0.002 SELECT * FROM Category WHERE parentId = 868
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.001 SELECT * FROM Category WHERE parentId = 84
0.003 SELECT * FROM Category WHERE parentId = 850
0.006 SELECT * FROM Category WHERE parentId = 853
0.003 SELECT * FROM Category WHERE parentId = 1026
0.001 SELECT * FROM Category WHERE parentId = 1215
0.001 SELECT id FROM Category WHERE parentID = 197
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.001 SELECT * FROM Category WHERE parentId = 197
0.001 SELECT * FROM Category WHERE parentId = 671
0.002 SELECT * FROM Category WHERE parentId = 671
0.002 SELECT * FROM Category WHERE parentId = 727
0.001 SELECT * FROM Category WHERE parentId = 728
0.001 SELECT * FROM Category WHERE parentId = 731
0.002 SELECT * FROM Category WHERE parentId = 732
0.001 SELECT * FROM Category WHERE parentId = 673
0.002 SELECT * FROM Category WHERE parentId = 725
0.001 SELECT * FROM Category WHERE parentId = 726
0.001 SELECT * FROM Category WHERE parentId = 875
0.001 SELECT * FROM Category WHERE parentId = 887
0.001 SELECT * FROM Category WHERE parentId = 889
0.002 SELECT * FROM Category WHERE parentId = 1021
0.002 SELECT * FROM Category WHERE parentId = 1095
0.003 SELECT * FROM Category WHERE parentId = 354
0.001 SELECT * FROM Category WHERE parentId = 356
0.003 SELECT * FROM Category WHERE parentId = 359
0.002 SELECT * FROM Category WHERE parentId = 358
0.001 SELECT * FROM Category WHERE parentId = 383
0.002 SELECT * FROM Category WHERE parentId = 384
0.001 SELECT * FROM Category WHERE parentId = 385
0.004 SELECT * FROM Category WHERE parentId = 313
0.001 SELECT * FROM Category WHERE parentId = 838
0.001 SELECT * FROM Category WHERE parentId = 335
0.002 SELECT * FROM Category WHERE parentId = 839
0.002 SELECT * FROM Category WHERE parentId = 931
0.003 SELECT * FROM Category WHERE parentId = 964
0.001 SELECT * FROM Category WHERE parentId = 365
0.004 SELECT * FROM Category WHERE parentId = 366
0.002 SELECT * FROM Category WHERE parentId = 350
0.001 SELECT * FROM Category WHERE parentId = 657
0.001 SELECT * FROM Category WHERE parentId = 656
0.001 SELECT * FROM Category WHERE parentId = 658
0.003 SELECT * FROM Category WHERE parentId = 667
0.001 SELECT * FROM Category WHERE parentId = 765
0.004 SELECT * FROM Category WHERE parentId = 767
0.003 SELECT * FROM Category WHERE parentId = 768
0.002 SELECT * FROM Category WHERE parentId = 769
0.001 SELECT * FROM Category WHERE parentId = 770
0.001 SELECT * FROM Category WHERE parentId = 377
0.002 SELECT * FROM Category WHERE parentId = 378
0.001 SELECT * FROM Category WHERE parentId = 379
0.001 SELECT * FROM Category WHERE parentId = 403
0.004 SELECT * FROM Category WHERE parentId = 707
0.004 SELECT id FROM Category WHERE parentID = 625
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.003 SELECT * FROM Category WHERE parentId = 625
0.002 SELECT * FROM Category WHERE parentId = 893
0.003 SELECT * FROM Category WHERE parentId = 935
0.001 SELECT * FROM Category WHERE parentId = 897
0.001 SELECT * FROM Category WHERE parentId = 897
0.001 SELECT * FROM Category WHERE parentId = 921
0.001 SELECT * FROM Category WHERE parentId = 925
0.001 SELECT * FROM Category WHERE parentId = 926
0.001 SELECT * FROM Category WHERE parentId = 898
0.001 SELECT * FROM Category WHERE parentId = 920
0.001 SELECT * FROM Category WHERE parentId = 919
0.002 SELECT * FROM Category WHERE parentId = 930
0.001 SELECT * FROM Category WHERE parentId = 969
0.001 SELECT * FROM Category WHERE parentId = 970
0.001 SELECT * FROM Category WHERE parentId = 971
0.001 SELECT * FROM Category WHERE parentId = 972
0.001 SELECT * FROM Category WHERE parentId = 938
0.003 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 = 1164
0.001 SELECT * FROM Category WHERE parentId = 1169
0.001 SELECT * FROM productprice WHERE productId=2089
0.002 SELECT * FROM productoptionvalue WHERE productId=2089 ORDER BY value
0.001 SELECT * FROM productprice WHERE productId=2089
0.003 SELECT ColorTable.* FROM ColorTable, ProductColor WHERE ColorTable.id=ProductColor.colorId AND ProductColor.productId=2089 ORDER BY id
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=2089
0.001 SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 2089 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=118 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.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.013 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.003 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(*), `productId` FROM `OrderItem` WHERE `productId` != 0 GROUP BY `productId`
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 defaultDiscount FROM Category WHERE id = 958
0.001 SELECT defaultDiscount FROM Category WHERE id = 667