8MP (3840x2160) - 30fps / Motorizirana leča 98°–48° / Min. svetloba: 0.0006 LUX / LED domet do 60m / Poraba max. 21.3W / Inteligenca (Prestop linije, vdor), zaznavanje obrazov, štetje ljudi, toplotna mapa / SMD / Dvosmerni avdio / Vgrajen zvočni in svetlo
Glavne značilnosti
• 1/1.8" 8 MP CMOS senzor
• Največ 25/30 fps @ 8 MP (3840 × 2160)
• Vgrajena večjedrna IR + topla LED osvetlitev do 60 m
• Motorizirana P-Iris leča 2.7–12 mm
• WDR 130 dB / 3D NR / HLC / BLC / EIS / Defog
• Napredna AI funkcionalnost (SMD 4.0, AcuPick, Face Detection, People Counting, IVS, Video Metadata)
• Dvosmerna komunikacija (vgrajen dvojni mikrofon + zvočnik)
• AI Rule Assist za samodejno ustvarjanje IVS pravil
• Inteligentno kodiranje AI H.264 / H.265 / Smart H.265+
• Dvojni napajalni vir – 12 VDC / PoE+ / ePoE
• IP67 in IK10 zaščita + ogrevano steklo za odstranjevanje kondenza, ledu in snega
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,0006 lux @ F1.2 (barvno); 0,0003 lux @ F1.2 (Č/B); 0 lux (pri vključenem osvetljevalniku)
• Razmerje signal/šum: >56 dB
• IR razdalja: do 60 m (IR) / do 60 m (topla svetloba)
• Osvetljevalnik: 4× večjedrni (IR + topla svetloba)
• Kotna nastavitev: 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.2
• Tip zaslonke: P-Iris
• Vidni kot: H: 98°–48° / V: 52°–27° / D: 117°–55°
• Najmanjša razdalja ostrenja: 0,16 m
DORI razdalje
• Široki kot (W): zaznavanje 96,6 m, opazovanje 38,6 m, prepoznavanje 19,3 m, identifikacija 9,6 m.
• Tele (T): zaznavanje 186,6 m, opazovanje 74,6 m, prepoznavanje 37,3 m, identifikacija 18,7 m.
DORI (Detect, Observe, Recognize, Identify) je standardni sistem (EN-62676-4), ki določa zmožnost osebe, ki gleda posnetek, da znotraj določenega območja prepozna ljudi ali predmete.
Podane vrednosti predstavljajo teoretične razdalje in ne odražajo učinkov inteligentnih funkcij. Za natančne razdalje pri uporabi AI funkcij glejte navodila za namestitev ali projektno orodje proizvajalca.
Video in zvok
• Video 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
• Podtokovi: do 4 hkratni tokovi
• Dvosmerni zvok: da (vgrajen dvojni mikrofon + zvočnik)
• Zvočna kompresija: G.711a / G.711Mu / PCM / G.726 / G.723
Inteligentne funkcije (AI)
• SMD 4.0 – napredna analiza ljudi, živali in vozil
• AcuPick – hitro iskanje tarč na posnetkih
• IVS – vdor, prehod črte, zadrževanje, parkiranje, gibanje itd.
• Face Detection – prepoznava obraza, zajem, optimizacija slike in atributov
• People Counting – štetje ljudi, območij, čakalnih vrst
• Video Metadata – analiza vozil, oseb in obrazov
• Heat Map – vizualizacija gibanja in zadrževanja
Omrežje in shranjevanje
• Mrežni vmesnik: RJ-45 (10/100 Base-T)
• Protokoli: IPv4/IPv6, RTSP, RTMP, FTP, SFTP, NTP, P2P, ONVIF (S/G/T/M)
• Shranjevanje: microSD do 1 TB / NAS / FTP
• Upravljanje: DSS / DMSS / DoLynk Care
• Mobilna aplikacija: iOS / Android
Alarm in dogodki
• Alarmni vhodi/izhodi: 2 in / 2 out
• Audio: 1 vhod (RCA), 1 izhod (RCA)
• Dogodki: zaznava gibanja, vdor, manipulacija, zvok, napake SD kartice, zaznava ljudi, vozil, čakalnih vrst, defokus ipd.
Napajanje
• Napajanje: 12 VDC (±30%) / PoE+ (802.3at) / ePoE
• Poraba: osnovna 5.3 W, največ 21.3 W (pri IR + sireni + gretju)
• Izhodna moč: 12 VDC, največ 165 mA (700 mA vršno)
• Dvojno napajanje (12V + PoE): samodejno preklapljanje brez ponovnega zagona
Okolje in ohišje
• Delovna temperatura: –40 °C do +60 °C
• Vlažnost: ≤95% (brez kondenzacije)
• Zaščita: IP67 / IK10
• Material ohišja: kovinsko
• Dimenzije: 302.6 × 110.8 × 99.1 mm
• Teža: 1.65 kg (neto)
Dodatne funkcije
• Ogrevano steklo za odstranjevanje ledu, snega in kondenza
• Svetlobno opozorilo (utripajoče ali stalno, 5–30 s)
• Zvočno opozorilo (11 vnaprej določenih + do 10 po meri)
Certifikati
• CE-LVD: EN62368-1
• CE-EMC: 2014/30/EU
| 0.002 | SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/dahua-ipc-hfw5859z-zhe-pv-pro-ip-video-nadzorna-kamera-wizmind-2085.html" |
| 0.257 | 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.001 | SELECT id FROM Category WHERE parentID = 171 |
| 0.001 | SELECT id FROM Category WHERE parentID = 264 |
| 0.001 | SELECT * FROM Category WHERE parentId = 206 |
| 0.001 | SELECT * FROM Category WHERE parentId = 518 |
| 0.002 | SELECT * FROM Category WHERE parentId = 281 |
| 0.001 | SELECT id FROM Category WHERE parentID = 739 |
| 0.001 | SELECT * FROM Category WHERE parentId = 748 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1083 |
| 0.001 | SELECT id FROM Category WHERE parentID = 799 |
| 0.002 | SELECT * FROM Category WHERE parentId = 1008 |
| 0.001 | SELECT id FROM Category WHERE parentID = 426 |
| 0.001 | SELECT id FROM Category WHERE parentID = 861 |
| 0.001 | SELECT id FROM Category WHERE parentID = 853 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1017 |
| 0.001 | SELECT * FROM Category WHERE parentId = 197 |
| 0.001 | SELECT * FROM Category WHERE parentId = 730 |
| 0.001 | SELECT * FROM Category WHERE parentId = 673 |
| 0.001 | SELECT * FROM Category WHERE parentId = 726 |
| 0.003 | SELECT id FROM Category WHERE parentID = 357 |
| 0.001 | SELECT * FROM Category WHERE parentId = 838 |
| 0.001 | SELECT * FROM Category WHERE parentId = 335 |
| 0.001 | SELECT * FROM Category WHERE parentId = 336 |
| 0.001 | SELECT * FROM Category WHERE parentId = 931 |
| 0.001 | SELECT * FROM Category WHERE parentId = 964 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1045 |
| 0.001 | SELECT id FROM Category WHERE parentID = 350 |
| 0.001 | SELECT id FROM Category WHERE parentID = 656 |
| 0.001 | SELECT id FROM Category WHERE parentID = 658 |
| 0.001 | SELECT id FROM Category WHERE parentID = 352 |
| 0.001 | SELECT id FROM Category WHERE parentID = 667 |
| 0.001 | SELECT id FROM Category WHERE parentID = 678 |
| 0.001 | SELECT id FROM Category WHERE parentID = 767 |
| 0.001 | SELECT * FROM Category WHERE parentId = 350 |
| 0.001 | SELECT * FROM Category WHERE parentId = 658 |
| 0.001 | SELECT * FROM Category WHERE parentId = 667 |
| 0.001 | SELECT * FROM Category WHERE parentId = 765 |
| 0.001 | SELECT * FROM Category WHERE parentId = 767 |
| 0.001 | SELECT * FROM Category WHERE parentId = 770 |
| 0.001 | SELECT * FROM Category WHERE parentId = 772 |
| 0.001 | SELECT id FROM Category WHERE parentID = 402 |
| 0.001 | SELECT id FROM Category WHERE parentID = 403 |
| 0.001 | SELECT id FROM Category WHERE parentID = 404 |
| 0.001 | SELECT * FROM Category WHERE parentId = 379 |
| 0.001 | SELECT * FROM Category WHERE parentId = 401 |
| 0.001 | SELECT * FROM Category WHERE parentId = 403 |
| 0.001 | SELECT * FROM Category WHERE parentId = 405 |
| 0.001 | SELECT id FROM Category WHERE parentID = 710 |
| 0.001 | SELECT id FROM Category WHERE parentID = 893 |
| 0.001 | SELECT id FROM Category WHERE parentID = 935 |
| 0.001 | SELECT * FROM Category WHERE parentId = 893 |
| 0.001 | SELECT * FROM Category WHERE parentId = 905 |
| 0.001 | SELECT id FROM Category WHERE parentID = 934 |
| 0.001 | SELECT id FROM Category WHERE parentID = 914 |
| 0.002 | SELECT id FROM Category WHERE parentID = 1207 |
| 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.001 | SELECT * FROM Category WHERE parentId = 1108 |
| 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 = 986 |
| 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.004 | 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 * FROM Category WHERE parentId = 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.001 | SELECT * FROM Category WHERE parentId = 771 |
| 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 = 1052 |
| 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=2085 GROUP BY Product.id |
| 0.001 | SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 2085 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.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 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.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(*) 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' |