8 MP (3840 × 2160) – 25 fps / Leča 105° / Nočni domet do 30 m + barvni nočni vid / Vgrajen zvočnik in mikrofon – dvosmerni zvok / Zaznavanje gibanja, ljudi, vozil in živali / Brezplačna aplikacija za telefon
Pametna zaščita, ki vidi več. Zaznava ljudi, vozila in dogajanje, samodejno prilagodi osvetlitev ter poskrbi za jasno sliko tudi ponoči. Zanesljivo delovanje v vseh vremenskih pogojih – brez kompromisov.
Pametno zaznavanje
Sistem pametnega zaznavanja natančno prepozna širok spekter objektov, vključno z ljudmi, vozili in živalmi. Prav tako zazna nenavadne dogodke, kot sta odstranjen predmet ali pozabljen predmet, kar izboljša situacijsko zaznavo in odziv na varnostne dogodke.
Zaščita perimetra
Funkcija zaščite perimetra omogoča napredno varovanje z natančnim nadzorom določenih območij. Vključuje zaznavanje prehoda črte, zaznavanje vdora v območje ter zaznavanje zadrževanja v varovanih conah. Te funkcije omogočajo proaktivno zaznavanje groženj in hitrejši odziv.
Shranjevanje na microSD kartico do 512 GB
Podpira microSD kartice do 512 GB, kar omogoča dolgotrajno lokalno shranjevanje posnetkov visoke ločljivosti brez potrebe po dodatnih napravah. Večja kapaciteta omogoča daljši čas snemanja in enostaven dostop do posnetkov.
Več načinov osvetlitve
Kamera je opremljena z IR LED diodami in reflektorji, kar omogoča prilagodljive načine osvetlitve. Ponoči samodejno preklopi na infrardeči način za jasno črno-belo sliko pri šibki svetlobi. Ob vklopu bele svetlobe omogoča barvni nočni prikaz. Na voljo so trije načini: stalno vklopljena svetloba, sprožena ob alarmu ali ročni izklop – glede na potrebe varovanja.
Robustna in vremensko odporna zasnova
Kamera je zasnovana za zunanjo uporabo in ima zaščito IP67, ki zagotavlja odpornost proti prahu in vodi. Deluje zanesljivo v temperaturnem območju od –30 °C do +55 °C. Trpežno kovinsko ohišje povečuje odpornost na udarce in zagotavlja dolgoročno stabilno delovanje v vseh vremenskih pogojih.
Specifikacije
Video in avdio
– Senzor slike: 1/2.7" CMOS
– Ločljivost: 3840 × 2160 (8 MP) @25 fps
– Objektiv: f = 2,8 mm; fiksni; F1.6
– Zoom: brez
– Video kompresija: H.265 / H.264
– Frame rate:
– Glavni tok: 2–25 fps (privzeto 25 fps)
– Podtok: 4–15 fps (privzeto 10 fps)
– Bitrate:
– Glavni tok: 2048–9216 kb/s (privzeto 7168 kb/s)
– Podtok: 64–512 kb/s (privzeto 256 kb/s)
– Vidni kot:
– Horizontalno: 105°
– Vertikalno: 56°
– Diagonalno: 125°
– Dan/noč: IR-cut filter s samodejnim preklopom
– Nočni IR vid: do 30 m; 2 × LED (850 nm)
– Barvni nočni vid: reflektor; 6500K; 700 lm
– Avdio: dvosmerni zvok
AI funkcije
– Zaznavanje: osebe; vozila; živali; gibanje
– Pametni dogodki:
– zaznavanje odstranitve predmeta (beta)
– zaznavanje pozabljenega predmeta (beta)
– IVS – inteligentna video analiza:
– zaznavanje prehoda črte
– zaznavanje vdora v območje
– zaznavanje zadrževanja v območju
– Nastavitve zaznavanja: velikost objekta; občutljivost; zamik alarma (osebe; vozila; živali); območje zaznavanja
Programska oprema
– Podprti sistemi: Windows; macOS; iOS; Android
– Protokoli: HTTP; HTTPS; SSL; TCP/IP; UDP; HTTP; IPv4; IPv6; UPnP; RTSP; RTMP; SMTP; NTP; DHCP; DNS; DDNS; FTP; P2P; ONVIF
– Dostop uporabnikov:
– do 20 uporabnikov (1 admin + 19 uporabnikov)
– do 12 sočasnih tokov (2 glavni + 10 podtokov)
Funkcije
– Način snemanja: po gibanju (privzeto); časovno; 24/7
– Pametni dom: Google Assistant
– Time lapse: da
Napajanje
– PoE: IEEE 802.3af; 48 V; aktivni
– DC napajanje: 12 V / 1 A; <12 W
Vmesniki
– Reset gumb: da
– Ethernet: 1 × RJ-45 (10/100 Mb/s)
– Shranjevanje: microSD do 512 GB; Reolink NVR; FTP
– Avdio: vgrajen mikrofon in zvočnik
Okolje
– Delovna temperatura: –30 °C do +55 °C
– Delovna vlažnost: 10–90 %
– Zaščita: IP67
Mehansko
– Dimenzije: Ø117,4 × 103,8 mm
– Teža (brez dodatkov): 526 g
Vsebina pakiranja:
1x kamera RP-PCT8M
1x Ethernet kabel
1x Uporabniški priročnik
| POE: | Da |
| Spletni vmesnik: | Ne |
| Zvočnik: | Da |
| Dvosmerni govor: | Da |
| Mikrofon: | Da |
| SD kartica: | do 512GB |
| Proizvajalec: | Reolink |
| Mobilna aplikacija: | Reolink |
| LED domet: | 30m |
| Ločljivost: | 8MP |
| Senzor: | 1/2.7" CMOS |
| Nočni vid: | Smart Dual Light |
| Kot: | 105° |
| Detekcija gibanja: | Da |
| Zadrževanje: | Da |
| Aktivno odvračanje: | Da |
| Prestop linije: | Da |
| Pametna detekcija gibanja: | Človek + vozilo + žival |
| AcuPick: | Ne |
| Zaznavanje ognja: | Ne |
| IR domet: | 30m |
| Zaščita: | IP67 |
| 0.004 | SELECT * FROM Settings |
| 0.004 | SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/reolink-8mp-video-nadzorna-kamera-rp-pct8m-2473.html" |
| 0.426 | 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.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=2473 GROUP BY Product.id |
| 0.005 | 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=2473 AND definesPackagePart='yes' |
| 0.003 | SELECT * FROM productdiscount WHERE productId=2473 AND priceType='normal' ORDER BY minquantity |
| 0.001 | SELECT * FROM trademark ORDER BY name ASC |
| 0.001 | SELECT id FROM Category WHERE parentID = 1073 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1069 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1071 |
| 0.001 | SELECT id FROM Category WHERE parentID = 776 |
| 0.001 | SELECT * FROM Category WHERE parentId = 979 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1029 |
| 0.008 | SELECT id FROM Category WHERE parentID = 1056 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1035 |
| 0.013 | SELECT * FROM Category WHERE parentId = 600 |
| 0.007 | SELECT * FROM Category WHERE parentId = 552 |
| 0.001 | SELECT * FROM Category WHERE parentId = 554 |
| 0.001 | SELECT * FROM Category WHERE parentId = 516 |
| 0.001 | SELECT * FROM Category WHERE parentId = 515 |
| 0.001 | SELECT * FROM Category WHERE parentId = 799 |
| 0.003 | SELECT * FROM Category WHERE parentId = 800 |
| 0.01 | SELECT * FROM Category WHERE parentId = 960 |
| 0.001 | SELECT id FROM Category WHERE parentID = 956 |
| 0.001 | SELECT * FROM Category WHERE parentId = 939 |
| 0.002 | SELECT * FROM Category WHERE parentId = 1034 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1199 |
| 0.001 | SELECT id FROM Category WHERE parentID = 844 |
| 0.001 | SELECT * FROM Category WHERE parentId = 313 |
| 0.001 | SELECT id FROM Category WHERE parentID = 929 |
| 0.001 | SELECT id FROM Category WHERE parentID = 906 |
| 0.001 | SELECT * FROM Category WHERE parentId = 919 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1178 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1181 |
| 0.008 | 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,1230,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,1230,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.006 | SELECT * FROM Category WHERE parentId = 206 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1072 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1073 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1069 |
| 0.001 | SELECT * FROM Category WHERE parentId = 311 |
| 0.007 | SELECT * FROM Category WHERE parentId = 1057 |
| 0.001 | SELECT * FROM Category WHERE parentId = 498 |
| 0.001 | SELECT * FROM Category WHERE parentId = 587 |
| 0.001 | SELECT * FROM Category WHERE parentId = 503 |
| 0.001 | SELECT * FROM Category WHERE parentId = 472 |
| 0.001 | SELECT * FROM Category WHERE parentId = 514 |
| 0.001 | SELECT * FROM Category WHERE parentId = 514 |
| 0.001 | SELECT * FROM Category WHERE parentId = 602 |
| 0.001 | SELECT * FROM Category WHERE parentId = 475 |
| 0.001 | SELECT * FROM Category WHERE parentId = 552 |
| 0.001 | SELECT * FROM Category WHERE parentId = 756 |
| 0.001 | SELECT * FROM Category WHERE parentId = 797 |
| 0.003 | SELECT * FROM Category WHERE parentId = 1005 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1007 |
| 0.001 | SELECT * FROM Category WHERE parentId = 975 |
| 0.001 | SELECT * FROM Category WHERE parentId = 989 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1138 |
| 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,1227,1226,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,1227,1226,5)) |
| 0.001 | SELECT * FROM Category WHERE parentId = 1088 |
| 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,1217,1218,1219,1228,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,1217,1218,1219,1228,6)) |
| 0.001 | SELECT * FROM Category WHERE parentId = 6 |
| 0.001 | SELECT * FROM Category WHERE parentId = 233 |
| 0.001 | SELECT * FROM Category WHERE parentId = 997 |
| 0.001 | SELECT * FROM Category WHERE parentId = 998 |
| 0.001 | SELECT * FROM Category WHERE parentId = 999 |
| 0.001 | SELECT * FROM Category WHERE parentId = 244 |
| 0.001 | SELECT * FROM Category WHERE parentId = 835 |
| 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,1220,1221,1222,1223,1225,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,1220,1221,1222,1223,1225,408)) |
| 0.001 | SELECT * FROM Category WHERE parentId = 1040 |
| 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,1224,1229,1231,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,1224,1229,1231,197)) |
| 0.001 | SELECT * FROM Category WHERE parentId = 350 |
| 0.001 | SELECT * FROM Category WHERE parentId = 667 |
| 0.001 | SELECT * FROM Category WHERE parentId = 775 |
| 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 * FROM Category WHERE parentId = 914 |
| 0.001 | SELECT * FROM Category WHERE parentId = 916 |
| 0.004 | 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.013 | SELECT * FROM Category WHERE parentId = 1152 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1156 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1212 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1161 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1166 |
| 0.003 | SELECT * FROM Category WHERE parentId = 1168 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1185 |
| 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=2473 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=2473 AND definesPackagePart='yes' |
| 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=2473 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=2473 AND definesPackagePart='yes' |
| 0.001 | SELECT * FROM productproperty WHERE propertyId = "194" AND productId = "2473" |
| 0.003 | SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 2473 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=2192 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=1573 AND definesPackagePart='yes' |
| 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,1230,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,1230,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.004 | 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,1227,1226,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,1227,1226,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,1217,1218,1219,1228,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,1217,1218,1219,1228,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,1220,1221,1222,1223,1225,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,1220,1221,1222,1223,1225,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.004 | 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,1224,1229,1231,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,1224,1229,1231,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.004 | 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 COUNT(*) AS product_count FROM Product WHERE Product.id IN (4,63,88,182,196,241,306,415,561,577,617,640,658,799,1180,1184,1195,1213,1309,1360,1570,1575,1751,1801,1938,2020,2330) 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,182,196,241,306,415,561,577,617,640,658,799,1180,1184,1195,1213,1309,1360,1570,1575,1751,1801,1938,2020,2330) 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=182 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' |