7 palični barvni zaslon na dotik 1024 x 600 + Android 14 + WiFi + UTP in 2-žična povezava + zvonec + podpora micro SD kartice + možnost alarma
> Naprava deluje na operacijskem sistemu Android 14, ki zagotavlja hitro, stabilno in uporabniku prijazno delovanje.
> Elegantna celostranska zasnova z ultra ozkim črnim robom združuje moderen videz in minimalističen slog za odlično vizualno izkušnjo.
> 7-palčni IPS zaslon na dotik z večtočkovnim upravljanjem omogoča širok vidni kot (do 80° vodoravno in navpično) ter izjemno odzivno in enostavno uporabo.
> Večbarvni LED-indikatorji z “breathing light” funkcijo jasno prikazujejo trenutno stanje naprave.
> Enota se samodejno prebudi ob zaznavi gibanja, kar omogoča tekočo uporabniško izkušnjo.
> Vgrajen svetlobni senzor samodejno prilagaja svetlost zaslona, senzorja temperature in vlage pa omogočata nadzor razmer v prostoru neposredno z domačega zaslona.
> Podpira več komunikacijskih načinov, vključno z IP, Wi-Fi in 2-žično IP povezavo.
Sistem
• Glavni procesor: vgrajen procesor
• Operacijski sistem: Android 14
• Omrežni protokoli: IPv4; RTSP; UDP; DNS; FTP; RTP; TCP; SIP
Osnovno
• Tip zaslona: kapacitivni zaslon na dotik
• Velikost zaslona: 7 palcev
• Ločljivost zaslona: 1024 (H) × 600 (V)
• Zvočno kodiranje: G.711a; G.711u; PCM
• Zvočni vhod: 1 kanal
• Zvočni izhod: vgrajen zvočnik
• Način zvoka: dvosmerna komunikacija
• Izboljšava zvoka: odpravljanje odmeva / digitalno zmanjšanje šuma
• Bitna hitrost zvoka: 16 kHz, 16 bit
Funkcije
• Način komunikacije: popolnoma digitalen
• Obvestila: sprejem in prikaz informacij iz nadzornega centra
• Dvigalo: možnost klica dvigala na svoj nivo
• Video sporočila: da (če je vstavljena SD-kartica v notranji enoti ali vratni postaji)
• Način »Ne moti« (DND): možno nastaviti časovno obdobje
• Število razširitev:
• Vila – 1 glavna notranja enota (VTH) + do 9 razširitev
• Stanovanje – 1 glavna notranja enota (VTH) + do 4 razširitve
• Shranjevanje: podpora microSD kartici (do 512 GB)
Omrežje
• Wi-Fi: da
• Standard: IEEE 802.11 a/b/g/n/ac/ax
• Frekvenčno območje: 2,4 GHz
Vhodi / izhodi
• RS-485: 1
• USB: 1
• Alarmni vhod: 8 kanalov
• Alarmni izhod: 1 kanal
• Napajalni izhod: 1 × 12 V / 200 mA
• Zvonec: da (prek alarmnega vhoda)
• Omrežni priključek: 1 × 10/100 Mbps Ethernet
• 2-žična povezava: 1
Zmogljivost
• Ohišje: PC + ABS plastika
Splošno
• Barva ohišja: siva
• Napajanje: 48 VDC, 0,5 A / Standardni PoE
• Napajalnik: opcijsko
• Način montaže: nadometno (Flush Mount)
• Certifikat: CE
Pribor
• Vključeno: RS-485 in napajalni izhodni kabel, nosilec in alarmni kabel
• Opcijsko: napajalni kabel
Dimenzije in okolje
• Dimenzije (V × Š × G): 176,2 × 103,1 × 32,2 mm
• Delovna temperatura: –10 °C do +55 °C
• Delovna vlažnost: 10–95 % (brez kondenza)
• Največja nadmorska višina: do 3000 m
• Poraba energije: ≤10 W (pripravljenost), ≤14 W (delovanje)
• Bruto teža: 775 g
• Temperatura shranjevanja: 0 °C do +40 °C
• Vlažnost shranjevanja: 30–75 %
• Uporaba: notranja
| 0.009 | SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/dahua-scp3022a-b-notranja-enota-domofona-2091.html" |
| 0.284 | 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.003 | 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=2091 GROUP BY Product.id |
| 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 = 1072 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1102 |
| 0.001 | SELECT id FROM Category WHERE parentID = 784 |
| 0.001 | SELECT * FROM Category WHERE parentId = 81 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1075 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1068 |
| 0.002 | SELECT * FROM Category WHERE parentId = 1076 |
| 0.001 | SELECT * FROM Category WHERE parentId = 264 |
| 0.004 | SELECT * FROM Category WHERE parentId = 691 |
| 0.001 | SELECT * FROM Category WHERE parentId = 686 |
| 0.001 | SELECT * FROM Category WHERE parentId = 688 |
| 0.003 | SELECT * FROM Category WHERE parentId = 689 |
| 0.004 | SELECT * FROM Category WHERE parentId = 683 |
| 0.001 | SELECT * FROM Category WHERE parentId = 534 |
| 0.005 | SELECT * FROM Category WHERE parentId = 787 |
| 0.001 | SELECT * FROM Category WHERE parentId = 788 |
| 0.001 | SELECT * FROM Category WHERE parentId = 979 |
| 0.001 | SELECT * FROM Category WHERE parentId = 802 |
| 0.001 | SELECT id FROM Category WHERE parentID = 281 |
| 0.001 | SELECT id FROM Category WHERE parentID = 474 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1036 |
| 0.001 | SELECT id FROM Category WHERE parentID = 506 |
| 0.001 | SELECT id FROM Category WHERE parentID = 858 |
| 0.001 | SELECT * FROM Category WHERE parentId = 580 |
| 0.001 | SELECT * FROM Category WHERE parentId = 481 |
| 0.001 | SELECT * FROM Category WHERE parentId = 856 |
| 0.001 | SELECT id FROM Category WHERE parentID = 475 |
| 0.001 | SELECT * FROM Category WHERE parentId = 472 |
| 0.001 | SELECT * FROM Category WHERE parentId = 514 |
| 0.001 | SELECT * FROM Category WHERE parentId = 552 |
| 0.005 | SELECT * FROM Category WHERE parentId = 476 |
| 0.001 | SELECT * FROM Category WHERE parentId = 576 |
| 0.001 | SELECT * FROM Category WHERE parentId = 577 |
| 0.001 | SELECT * FROM Category WHERE parentId = 578 |
| 0.001 | SELECT * FROM Category WHERE parentId = 588 |
| 0.003 | SELECT * FROM Category WHERE parentId = 738 |
| 0.001 | SELECT * FROM Category WHERE parentId = 756 |
| 0.001 | SELECT * FROM Category WHERE parentId = 477 |
| 0.001 | SELECT * FROM Category WHERE parentId = 516 |
| 0.003 | SELECT * FROM Category WHERE parentId = 681 |
| 0.001 | SELECT id FROM Category WHERE parentID = 794 |
| 0.001 | SELECT id FROM Category WHERE parentID = 795 |
| 0.001 | SELECT * FROM Category WHERE parentId = 630 |
| 0.002 | SELECT * FROM Category WHERE parentId = 634 |
| 0.001 | SELECT * FROM Category WHERE parentId = 635 |
| 0.001 | SELECT * FROM Category WHERE parentId = 638 |
| 0.002 | SELECT * FROM Category WHERE parentId = 799 |
| 0.001 | SELECT * FROM Category WHERE parentId = 800 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1041 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1042 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1043 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1200 |
| 0.001 | SELECT * FROM Category WHERE parentId = 631 |
| 0.002 | SELECT * FROM Category WHERE parentId = 1140 |
| 0.001 | SELECT id FROM Category WHERE parentID = 876 |
| 0.001 | SELECT * FROM Category WHERE parentId = 747 |
| 0.006 | SELECT id FROM Category WHERE parentID = 1128 |
| 0.001 | SELECT id FROM Category WHERE parentID = 139 |
| 0.001 | SELECT * FROM Category WHERE parentId = 139 |
| 0.002 | SELECT * FROM Category WHERE parentId = 994 |
| 0.001 | SELECT * FROM Category WHERE parentId = 995 |
| 0.001 | SELECT * FROM Category WHERE parentId = 996 |
| 0.002 | SELECT * FROM Category WHERE parentId = 997 |
| 0.001 | SELECT * FROM Category WHERE parentId = 998 |
| 0.002 | SELECT * FROM Category WHERE parentId = 999 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1000 |
| 0.003 | SELECT id FROM Category WHERE parentID = 1067 |
| 0.002 | SELECT id FROM Category WHERE parentID = 244 |
| 0.002 | SELECT id FROM Category WHERE parentID = 245 |
| 0.001 | SELECT id FROM Category WHERE parentID = 246 |
| 0.001 | SELECT * FROM Category WHERE parentId = 244 |
| 0.001 | SELECT * FROM Category WHERE parentId = 367 |
| 0.001 | SELECT * FROM Category WHERE parentId = 245 |
| 0.001 | SELECT * FROM Category WHERE parentId = 246 |
| 0.001 | SELECT id FROM Category WHERE parentID = 1077 |
| 0.001 | SELECT id FROM Category WHERE parentID = 943 |
| 0.001 | SELECT id FROM Category WHERE parentID = 946 |
| 0.005 | SELECT id FROM Category WHERE parentID = 947 |
| 0.001 | SELECT id FROM Category WHERE parentID = 948 |
| 0.001 | SELECT id FROM Category WHERE parentID = 949 |
| 0.001 | SELECT id FROM Category WHERE parentID = 950 |
| 0.001 | SELECT * FROM Category WHERE parentId = 951 |
| 0.001 | SELECT * FROM Category WHERE parentId = 952 |
| 0.001 | SELECT id FROM Category WHERE parentID = 955 |
| 0.002 | SELECT id FROM Category WHERE parentID = 835 |
| 0.001 | SELECT id FROM Category WHERE parentID = 656 |
| 0.001 | SELECT id FROM Category WHERE parentID = 658 |
| 0.002 | SELECT id FROM Category WHERE parentID = 352 |
| 0.001 | SELECT id FROM Category WHERE parentID = 678 |
| 0.001 | SELECT id FROM Category WHERE parentID = 377 |
| 0.004 | SELECT * FROM Category WHERE parentId = 403 |
| 0.001 | SELECT * FROM Category WHERE parentId = 704 |
| 0.002 | SELECT id FROM Category WHERE parentID = 925 |
| 0.003 | SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2)) |
| 0.001 | SELECT * FROM Category WHERE parentId = 2 |
| 0.001 | SELECT * FROM Category WHERE parentId = 324 |
| 0.001 | SELECT * FROM Category WHERE parentId = 581 |
| 0.002 | SELECT * FROM Category WHERE parentId = 482 |
| 0.003 | SELECT * FROM Category WHERE parentId = 750 |
| 0.001 | SELECT * FROM Category WHERE parentId = 475 |
| 0.005 | SELECT * FROM Category WHERE parentId = 690 |
| 0.006 | SELECT * FROM Category WHERE parentId = 576 |
| 0.001 | SELECT * FROM Category WHERE parentId = 578 |
| 0.002 | SELECT * FROM Category WHERE parentId = 708 |
| 0.001 | SELECT * FROM Category WHERE parentId = 797 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1125 |
| 0.002 | SELECT * FROM Category WHERE parentId = 639 |
| 0.001 | SELECT * FROM Category WHERE parentId = 641 |
| 0.003 | SELECT * FROM Category WHERE parentId = 642 |
| 0.001 | SELECT * FROM Category WHERE parentId = 643 |
| 0.001 | SELECT * FROM Category WHERE parentId = 643 |
| 0.002 | SELECT * FROM Category WHERE parentId = 988 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1106 |
| 0.005 | SELECT * FROM Category WHERE parentId = 1133 |
| 0.002 | SELECT * FROM Category WHERE parentId = 1134 |
| 0.002 | SELECT * FROM Category WHERE parentId = 1137 |
| 0.001 | SELECT * FROM Category WHERE parentId = 1140 |
| 0.003 | SELECT id FROM Category WHERE parentID = 5 |
| 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.001 | SELECT * FROM Category WHERE parentId = 5 |
| 0.001 | SELECT * FROM Category WHERE parentId = 740 |
| 0.002 | SELECT * FROM Category WHERE parentId = 427 |
| 0.003 | SELECT * FROM Category WHERE parentId = 984 |
| 0.005 | SELECT * FROM Category WHERE parentId = 1087 |
| 0.013 | SELECT id FROM Category WHERE parentID = 6 |
| 0.006 | 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.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 = 1197 |
| 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 * FROM Category WHERE parentId = 846 |
| 0.002 | SELECT * FROM Category WHERE parentId = 1215 |
| 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.001 | SELECT * FROM Category WHERE parentId = 677 |
| 0.003 | SELECT * FROM Category WHERE parentId = 403 |
| 0.001 | SELECT * FROM Category WHERE parentId = 404 |
| 0.005 | 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 = 897 |
| 0.001 | SELECT * FROM Category WHERE parentId = 896 |
| 0.005 | SELECT * FROM Category WHERE parentId = 903 |
| 0.001 | SELECT * FROM Category WHERE parentId = 961 |
| 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 * FROM Category WHERE parentId = 1157 |
| 0.003 | 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=2091 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=2091 AND definesPackagePart='yes' |
| 0.002 | SELECT * FROM productdiscount WHERE productId=2091 AND priceType='gross' ORDER BY minquantity |
| 0.002 | SELECT * FROM Category WHERE id = "599" |
| 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=2091 AND definesPackagePart='yes' |
| 0.003 | SELECT size.* FROM size, productsize WHERE size.id=productsize.sizeId AND productsize.productId=2091 AND (productsize.stock + productsize.externalStock > 0 OR productsize.stock > 0 AND productsize.externalStock is null OR productsize.externalStock > 0 AND productsize.stock is null) ORDER BY size.sort ASC |
| 0.001 | SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 2091 AND definesPackagePart='no' AND additional_product = '0') AND active='yes' ORDER BY (Product.unitPrice*(1-Product.discount/100)) |
| 0.001 | SELECT COUNT(*) AS product_count FROM Product WHERE `categoryId` = "599" AND `id` != "2091"AND Product.active = "yes" GROUP BY Product.id ORDER BY unitPrice |
| 0.001 | SELECT Product.* FROM Product WHERE `categoryId` = "599" AND `id` != "2091"AND Product.active = "yes" GROUP BY Product.id ORDER BY unitPrice 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=1980 AND definesPackagePart='yes' |
| 0.003 | SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2)) |
| 0.002 | SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5) OR category2Id IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5)) |
| 0.003 | SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,6) OR category2Id IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,6)) |
| 0.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.004 | 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.005 | SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197)) |
| 0.005 | 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.007 | 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' |