DAHUA ASI6214S-PW KONTROLA PRISTOPA

496,00 €

ODKLEPANJE Z OBRAZOM, PRSTNIM ODTISOM, KARTICO, KODO / IC KARTICA / RELE / TAMPER ALARM

  • Blagovna znamka:
    DAHUA
  • Koda:
    ASI6214S-PW
  • Zaloga:
    Ni na zalogi

Opis

> 4.3-palčni stekleni zaslon na dotik z ločljivostjo 272 × 480.
> 2 MP širokokotna kamera z dvojno lečo z IR osvetlitvijo in DWDR.
> Več načinov odklepanja, vključno z obrazom, kartico IC in geslom.
> Podpira 6.000 uporabnikov, 6.000 obrazov, 6.000 gesel, 6.000 prstnih odtisov, 10.000 kartic, 50 skrbnikov in 300.000 zapisov.
> Prepozna obraze, oddaljene od 0,3 m do 1,5 m; stopnja natančnosti prepoznave obraza 99,9 % in primerjalni čas 1:N je 0,2 s na osebo.
> Podpira izboljšano varnost in za zaščito pred nasilnim odpiranjem naprave je podprta razširitev varnostnega modula.
> Ima zaznavanje obrazne maske in zaznavanje varnostne čelade.
> Upravlja udeležbo in izvozi evidenco udeležbe.
> Podpira QR kodo obiskovalca in funkcijo zvonca.
> Podpira opravljanje video klicev in uporabo aplikacije za prejemanje alarmnih obvestil, odklepanje vrat na daljavo in izvajanje drugih opravil.
> Povezava TCP/IP in Wi-Fi.
> PoE napajanje.
> Ocena IP65.


Sistem
Glavni procesor: Vgrajeni procesor
Vrsta gumba: Gumb na dotik
Omrežni protokol: UDP; TCP; IPv4; RTSP; SIP; P2P; RTP
Protokol OSDP: Da
Interoperabilnost: CGI; ONVIF
SDK in API: Da

Osnovno
Vrsta izdelka: Samostojen
Zaslon: 4.3" LCD
Vrsta zaslona: Kapacitivni zaslon na dotik
Ločljivost zaslona: 272 (H) × 480 (V)
Kamera: 2-MP CMOS HD kamera z dvojno lečo
WDR: DWDR
Kompenzacija svetlobe: Auto IR
Glasovni poziv: Da
Brenčalo: Da
Material ohišja: PC+GF

Funkcija
Način odklepanja: Kartica, daljinski upravljalnik, geslo, koda QR, odklepanje z obrazom in kombinacijo
Vrsta kartice: IC kartice
Seznam obdobij: 128 obdobij
Počitniško obdobje: 128 obdobij
Omrežna posodobitev: Da
Prvo uporabniško odklepanje: Da
Preverjanje na daljavo: Da
Omejeni seznam/zaupanja vreden seznam: Da
Wi-Fi: Da
Brezžični standard: IEEE802.11b/802.11g/802.11n
Brezžično frekvenčno območje: 2,4 GHz
Čitalnik perifernih kartic: 1 × čitalnik kartic RS-485; 1 × čitalec kartic Wiegand
Večuporabniška avtentikacija: Da
Spremljanje v realnem času: Da
Večfaktorska avtentikacija: Da
Funkcija zajema: Da
Spletna konfiguracija: Da
Samodejna registracija: Da

Delovanje
Razdalja branja kartice: 0 cm–3 cm
Razpon višine za prepoznavanje obraza: 1,1 m–2,0 m
Razdalja za prepoznavanje obraza: 0,3 m–1,5 m
Natančnost prepoznavanja obraza: 99,9 %
Čas prepoznave obraza: 0,2 s
Čas prepoznave obraza: 0,2 s
Način preverjanja prstnih odtisov: 1:N

Uporabnik
Tip uporabnika (kartica): Navaden uporabnik; VIP uporabniki; patruljni uporabnik; gostujoči uporabnik; uporabnik seznama blokiranih; drug uporabnik; uporabnik po meri 1; uporabnik po meri 2

Zmogljivost
Kapaciteta uporabnikov: 6.000
Kapaviteta slik obraza: 6.000
Kapaciteta prstnih odtisov:6.000
Kapaciteta kartic: 10.000
Kapaciteta gesel: 6.000
Kapaciteta zapisov: 300000

Vrata
RS-485: 1
Wiegand: 1
USB: 1
Omrežna vrata: 1 × RJ-45 10/100 Mbps samoprilagodljiva ethernetna vrata
Alarmni vhod: 1
Alarmni izhod: 1
Povezava alarma: Da
Gumb za izhod: 1
Zaznavanje stanja vrat: 1
Nadzor zaklepanja: 1

Alarm
Anti-pass back: Da
Tamper alarm: Da
Alarm za prisilo: Da
Časovna omejitev senzorja vrat: Da
Vdor: Da
Nezakonita kartica, ki presega prag: Da

Splošno
Napajalnik: Priložen
Napajanje: Stanard PoE; 12 VDC, 1,5 A
Zaščita: IP65
Poraba energije: ≤12 W
Mere izdelka: 180,1 mm × 90,1 mm × 27,0 mm (D × Š × V)
590 mm × 432 mm × 302 mm (D × Š × V, zaščitna škatla)
Delovna temperatura: –30 °C do +60 °C
Delovna vlažnost: 0%–90% (RH), brez kondenzacije
Nadmorska višina delovanja: 0 m–1.300 m
Delovno okolje: Na prostem, notranja
Bruto teža: 0,70 kg
Dodatek: Nosilec za stensko montažo (priložen)
Montaža: Turnsile mount; 86 nosilec ohišja; stenski nosilec; površinska montaža


Specifikacija

Sorodni izdelki

Kategorije

Naj izdelki

50

DAHUA XVR5104HS-4KL-I3 PENTA-BRID SNEMALNIK WizSense
114,00 €
228,00 €
Dodaj v košarico
30

DAHUA HAC-HFW1801CM-IL-A VIDEO NADZORNA KAMERA
69,30 €
99,00 €
Dodaj v košarico
novo

IMOU CRUISER SE+ 3MP VIDEO NADZORNA KAMERA / K7CP-3H1WE
42,70 €
Dodaj v košarico

DAHUA EAP5212-C DOSTOPNA TOČKA
59,50 €
119,00 €
Dodaj v košarico
novo

KALER GEN-ST2 SOS ODDAJNIK Z GUMBOM
29,00 €
Dodaj v košarico
0.002 SELECT * FROM Settings
0.001 SELECT * FROM config_data
0.004 SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/dahua-asi6214s-pw-kontrola-pristopa-1495.html"
0.004 SELECT * FROM Category ORDER BY sequence
0.114 select distinct c.id from Category c, Product p where (p.categoryId=c.id OR p.category2Id=c.id OR p.category3Id=c.id) AND p.active='yes'
0.001 select distinct parentId from Category
0.001 SELECT id FROM Category WHERE parentID = 1
0.001 SELECT id FROM Category WHERE parentID = 2
0.001 SELECT id FROM Category WHERE parentID = 81
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 = 1076
0.001 SELECT id FROM Category WHERE parentID = 333
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 = 785
0.001 SELECT id FROM Category WHERE parentID = 91
0.001 SELECT id FROM Category WHERE parentID = 283
0.002 SELECT id FROM Category WHERE parentID = 324
0.001 SELECT id FROM Category WHERE parentID = 502
0.001 SELECT id FROM Category WHERE parentID = 1036
0.001 SELECT id FROM Category WHERE parentID = 611
0.001 SELECT id FROM Category WHERE parentID = 581
0.001 SELECT id FROM Category WHERE parentID = 857
0.001 SELECT id FROM Category WHERE parentID = 858
0.005 SELECT id FROM Category WHERE parentID = 497
0.001 SELECT id FROM Category WHERE parentID = 498
0.002 SELECT id FROM Category WHERE parentID = 587
0.001 SELECT id FROM Category WHERE parentID = 892
0.001 SELECT id FROM Category WHERE parentID = 601
0.001 SELECT id FROM Category WHERE parentID = 578
0.001 SELECT id FROM Category WHERE parentID = 738
0.001 SELECT id FROM Category WHERE parentID = 680
0.002 SELECT id FROM Category WHERE parentID = 515
0.001 SELECT id FROM Category WHERE parentID = 631
0.002 SELECT id FROM Category WHERE parentID = 639
0.002 SELECT id FROM Category WHERE parentID = 642
0.001 SELECT id FROM Category WHERE parentID = 1201
0.001 SELECT id FROM Category WHERE parentID = 1202
0.001 SELECT id FROM Category WHERE parentID = 712
0.001 SELECT id FROM Category WHERE parentID = 976
0.001 SELECT id FROM Category WHERE parentID = 989
0.002 SELECT id FROM Category WHERE parentID = 1032
0.001 SELECT id FROM Category WHERE parentID = 1108
0.001 SELECT id FROM Category WHERE parentID = 1109
0.001 SELECT id FROM Category WHERE parentID = 1110
0.001 SELECT id FROM Category WHERE parentID = 1112
0.001 SELECT id FROM Category WHERE parentID = 1137
0.001 SELECT id FROM Category WHERE parentID = 597
0.001 SELECT id FROM Category WHERE parentID = 599
0.001 SELECT id FROM Category WHERE parentID = 621
0.001 SELECT id FROM Category WHERE parentID = 743
0.001 SELECT id FROM Category WHERE parentID = 882
0.001 SELECT id FROM Category WHERE parentID = 986
0.001 SELECT id FROM Category WHERE parentID = 891
0.001 SELECT id FROM Category WHERE parentID = 984
0.001 SELECT id FROM Category WHERE parentID = 746
0.001 SELECT id FROM Category WHERE parentID = 1088
0.002 SELECT id FROM Category WHERE parentID = 1128
0.001 SELECT id FROM Category WHERE parentID = 957
0.002 SELECT id FROM Category WHERE parentID = 250
0.001 SELECT id FROM Category WHERE parentID = 244
0.001 SELECT id FROM Category WHERE parentID = 367
0.001 SELECT id FROM Category WHERE parentID = 389
0.001 SELECT id FROM Category WHERE parentID = 1033
0.001 SELECT id FROM Category WHERE parentID = 835
0.001 SELECT id FROM Category WHERE parentID = 940
0.001 SELECT id FROM Category WHERE parentID = 945
0.001 SELECT id FROM Category WHERE parentID = 1030
0.001 SELECT id FROM Category WHERE parentID = 1127
0.001 SELECT id FROM Category WHERE parentID = 84
0.001 SELECT id FROM Category WHERE parentID = 844
0.003 SELECT id FROM Category WHERE parentID = 842
0.001 SELECT id FROM Category WHERE parentID = 1082
0.001 SELECT id FROM Category WHERE parentID = 1017
0.003 SELECT id FROM Category WHERE parentID = 1098
0.001 SELECT id FROM Category WHERE parentID = 1099
0.001 SELECT id FROM Category WHERE parentID = 197
0.002 SELECT id FROM Category WHERE parentID = 724
0.001 SELECT id FROM Category WHERE parentID = 888
0.001 SELECT id FROM Category WHERE parentID = 1020
0.001 SELECT id FROM Category WHERE parentID = 356
0.003 SELECT id FROM Category WHERE parentID = 357
0.001 SELECT id FROM Category WHERE parentID = 385
0.002 SELECT id FROM Category WHERE parentID = 964
0.001 SELECT id FROM Category WHERE parentID = 657
0.001 SELECT id FROM Category WHERE parentID = 678
0.001 SELECT id FROM Category WHERE parentID = 677
0.001 SELECT id FROM Category WHERE parentID = 378
0.001 SELECT id FROM Category WHERE parentID = 379
0.001 SELECT id FROM Category WHERE parentID = 401
0.001 SELECT id FROM Category WHERE parentID = 974
0.001 SELECT id FROM Category WHERE parentID = 1019
0.001 SELECT id FROM Category WHERE parentID = 1084
0.001 SELECT id FROM Category WHERE parentID = 1046
0.001 SELECT id FROM Category WHERE parentID = 1203
0.001 SELECT id FROM Category WHERE parentID = 1199
0.001 SELECT id FROM Category WHERE parentID = 1197
0.001 SELECT id FROM Category WHERE parentID = 967
0.003 SELECT id FROM Category WHERE parentID = 969
0.001 SELECT id FROM Category WHERE parentID = 1048
0.001 SELECT id FROM Category WHERE parentID = 1050
0.001 SELECT id FROM Category WHERE parentID = 1163
0.001 SELECT id FROM Category WHERE parentID = 1206
0.001 SELECT id FROM Category WHERE parentID = 1177
0.004 SELECT id FROM Category WHERE parentID = 1170
0.001 SELECT id FROM Category WHERE parentID = 1169
0.001 SELECT id FROM Category WHERE parentID = 1171
0.001 SELECT id FROM Category WHERE parentID = 1181
0.001 SELECT id FROM Category WHERE parentID = 1187
0.001 SELECT id FROM Category WHERE parentID = 1185
0.001 SELECT id FROM Category WHERE parentID = 1209
0.008 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (2,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,1) OR category2Id IN (2,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,1)) AND active = 'yes'
0.007 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,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,2)) AND active = 'yes'
0.006 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (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,472) OR category2Id IN (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,472)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (690,576,577,578,588,626,708,738,751,752,756,476) OR category2Id IN (690,576,577,578,588,626,708,738,751,752,756,476)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1194) OR category2Id IN (1194)) AND active = 'yes'
0.004 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (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,474) OR category2Id IN (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,474)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (855,856,857,858,481) OR category2Id IN (855,856,857,858,481)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1056,1057,496,497,498,587,709,739,748,750,1083,892,655,482) OR category2Id IN (1056,1057,496,497,498,587,709,739,748,750,1083,892,655,482)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (497) OR category2Id IN (497)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (498) OR category2Id IN (498)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (655) OR category2Id IN (655)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (587) OR category2Id IN (587)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (739) OR category2Id IN (739)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1056) OR category2Id IN (1056)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1057) OR category2Id IN (1057)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1063) OR category2Id IN (1063)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (624) OR category2Id IN (624)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1107,1108,1109,1110,1111,1112,1113,1106) OR category2Id IN (1107,1108,1109,1110,1111,1112,1113,1106)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1109) OR category2Id IN (1109)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1111) OR category2Id IN (1111)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1113) OR category2Id IN (1113)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,630) OR category2Id IN (632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,630)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,631) OR category2Id IN (639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,631)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (640) OR category2Id IN (640)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (641) OR category2Id IN (641)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (642) OR category2Id IN (642)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1041,1042,1043,1200,1201,1202,643) OR category2Id IN (1041,1042,1043,1200,1201,1202,643)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1043) OR category2Id IN (1043)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1202) OR category2Id IN (1202)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1148) OR category2Id IN (1148)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1134,1135,1136,1137,1138,1139,1140,1133) OR category2Id IN (1134,1135,1136,1137,1138,1139,1140,1133)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (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,81) OR category2Id IN (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,81)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1126) OR category2Id IN (1126)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1149) OR category2Id IN (1149)) AND active = 'yes'
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)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (891,984,985,746,747,876,745) OR category2Id IN (891,984,985,746,747,876,745)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1097) OR category2Id IN (1097)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (599,598,740,982,983,621,597) OR category2Id IN (599,598,740,982,983,621,597)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (598) OR category2Id IN (598)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (982,983,740) OR category2Id IN (982,983,740)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (982) OR category2Id IN (982)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (742,743,744,882,986,987,741) OR category2Id IN (742,743,744,882,986,987,741)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (743) OR category2Id IN (743)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1087,1088,1089,1086) OR category2Id IN (1087,1088,1089,1086)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (427) OR category2Id IN (427)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115) OR category2Id IN (115)) AND active = 'yes'
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,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,6)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1129) OR category2Id IN (1129)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (834,835,1002,1003,837,941,940,836,939,1034,773) OR category2Id IN (834,835,1002,1003,837,941,940,836,939,1034,773)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (834) OR category2Id IN (834)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (939) OR category2Id IN (939)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1002) OR category2Id IN (1002)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (940) OR category2Id IN (940)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1030) OR category2Id IN (1030)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (943) OR category2Id IN (943)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (945) OR category2Id IN (945)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (949) OR category2Id IN (949)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (955) OR category2Id IN (955)) AND active = 'yes'
0.007 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)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (860,861,862,863,864,865,977,980,1203,859) OR category2Id IN (860,861,862,863,864,865,977,980,1203,859)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1203) OR category2Id IN (1203)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (860) OR category2Id IN (860)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (862) OR category2Id IN (862)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (864) OR category2Id IN (864)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1038,1039,1040,1198,1199,1197,870) OR category2Id IN (1038,1039,1040,1198,1199,1197,870)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1039) OR category2Id IN (1039)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1040) OR category2Id IN (1040)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1198) OR category2Id IN (1198)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1015) OR category2Id IN (1015)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1191) OR category2Id IN (1191)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1192) OR category2Id IN (1192)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1025) OR category2Id IN (1025)) AND active = 'yes'
0.004 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (872,873,874,981,871) OR category2Id IN (872,873,874,981,871)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (872) OR category2Id IN (872)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (873) OR category2Id IN (873)) AND active = 'yes'
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,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,877,1017,1093,1098,1099,1159,84)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1017) OR category2Id IN (1017)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1082) OR category2Id IN (1082)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1081) OR category2Id IN (1081)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (841) OR category2Id IN (841)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1093) OR category2Id IN (1093)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1099) OR category2Id IN (1099)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1098) OR category2Id IN (1098)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (849,850,853,1026,848) OR category2Id IN (849,850,853,1026,848)) AND active = 'yes'
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,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)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (931) OR category2Id IN (931)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,350) OR category2Id IN (657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,350)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (352) OR category2Id IN (352)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (656) OR category2Id IN (656)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (766,767,768,769,770,771,765) OR category2Id IN (766,767,768,769,770,771,765)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (772) OR category2Id IN (772)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,555) OR category2Id IN (671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,555)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (724,725,726,670) OR category2Id IN (724,725,726,670)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (727,728,729,671) OR category2Id IN (727,728,729,671)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (888) OR category2Id IN (888)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (673) OR category2Id IN (673)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (875) OR category2Id IN (875)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1021) OR category2Id IN (1021)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1044) OR category2Id IN (1044)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (378,379,401,402,403,404,405,377) OR category2Id IN (378,379,401,402,403,404,405,377)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (365,366,364) OR category2Id IN (365,366,364)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (959) OR category2Id IN (959)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1096) OR category2Id IN (1096)) AND active = 'yes'
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)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (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,893) OR category2Id IN (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,893)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (896) OR category2Id IN (896)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (938) OR category2Id IN (938)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,897) OR category2Id IN (899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,897)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (969) OR category2Id IN (969)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (970) OR category2Id IN (970)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (927,928,929,930,919) OR category2Id IN (927,928,929,930,919)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (927) OR category2Id IN (927)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (928) OR category2Id IN (928)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (929) OR category2Id IN (929)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (920) OR category2Id IN (920)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (971) OR category2Id IN (971)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (973) OR category2Id IN (973)) AND active = 'yes'
0.004 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (903) OR category2Id IN (903)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (910) OR category2Id IN (910)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (990) OR category2Id IN (990)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (934,932,933,914,915,916,917,918,961,1024,894) OR category2Id IN (934,932,933,914,915,916,917,918,961,1024,894)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (914) OR category2Id IN (914)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (932) OR category2Id IN (932)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (961) OR category2Id IN (961)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1048,1049,1051,1050,1052,936) OR category2Id IN (1048,1049,1051,1050,1052,936)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (937) OR category2Id IN (937)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1130) OR category2Id IN (1130)) AND active = 'yes'
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,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,1152)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1210) OR category2Id IN (1210)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1176,1177,1178,1175) OR category2Id IN (1176,1177,1178,1175)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1177) OR category2Id IN (1177)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1196) OR category2Id IN (1196)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1181,1182,1183,1180) OR category2Id IN (1181,1182,1183,1180)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1156,1154,1155,1157,1158,1212,1153) OR category2Id IN (1156,1154,1155,1157,1158,1212,1153)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1157) OR category2Id IN (1157)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1158) OR category2Id IN (1158)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1162,1163,1164,1167,1166,1165,1206,1207,1161) OR category2Id IN (1162,1163,1164,1167,1166,1165,1206,1207,1161)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1164) OR category2Id IN (1164)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1165) OR category2Id IN (1165)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1166) OR category2Id IN (1166)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (707,704) OR category2Id IN (707,704)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1206) OR category2Id IN (1206)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1172,1173,1174,1170,1169,1171,1168) OR category2Id IN (1172,1173,1174,1170,1169,1171,1168)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1169) OR category2Id IN (1169)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1171) OR category2Id IN (1171)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1172) OR category2Id IN (1172)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1173) OR category2Id IN (1173)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1181) OR category2Id IN (1181)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1182) OR category2Id IN (1182)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1185) OR category2Id IN (1185)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1186) OR category2Id IN (1186)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1187) OR category2Id IN (1187)) AND active = '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=1495 GROUP BY Product.id
0.001 SELECT * FROM productdiscount WHERE productId=1495 AND priceType='normal' ORDER BY minquantity
0.001 SELECT * FROM productdiscount WHERE productId=1495 AND priceType='gross' ORDER BY minquantity
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,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,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,2))
0.003 SELECT * FROM Category WHERE parentId = 2
0.001 SELECT * FROM Category WHERE parentId = 81
0.001 SELECT * FROM Category WHERE parentId = 470
0.001 SELECT * FROM Category WHERE parentId = 206
0.002 SELECT * FROM Category WHERE parentId = 686
0.001 SELECT * FROM Category WHERE parentId = 687
0.001 SELECT * FROM Category WHERE parentId = 689
0.001 SELECT * FROM Category WHERE parentId = 517
0.001 SELECT * FROM Category WHERE parentId = 683
0.001 SELECT * FROM Category WHERE parentId = 573
0.001 SELECT * FROM Category WHERE parentId = 653
0.001 SELECT * FROM Category WHERE parentId = 788
0.001 SELECT * FROM Category WHERE parentId = 282
0.001 SELECT * FROM Category WHERE parentId = 1037
0.001 SELECT * FROM Category WHERE parentId = 481
0.001 SELECT * FROM Category WHERE parentId = 482
0.002 SELECT * FROM Category WHERE parentId = 498
0.001 SELECT * FROM Category WHERE parentId = 739
0.001 SELECT * FROM Category WHERE parentId = 552
0.001 SELECT * FROM Category WHERE parentId = 751
0.001 SELECT * FROM Category WHERE parentId = 840
0.002 SELECT * FROM Category WHERE parentId = 1194
0.001 SELECT * FROM Category WHERE parentId = 515
0.001 SELECT * FROM Category WHERE parentId = 630
0.001 SELECT * FROM Category WHERE parentId = 793
0.001 SELECT * FROM Category WHERE parentId = 795
0.001 SELECT * FROM Category WHERE parentId = 797
0.001 SELECT * FROM Category WHERE parentId = 960
0.001 SELECT * FROM Category WHERE parentId = 640
0.001 SELECT * FROM Category WHERE parentId = 643
0.001 SELECT * FROM Category WHERE parentId = 644
0.001 SELECT * FROM Category WHERE parentId = 975
0.002 SELECT * FROM Category WHERE parentId = 989
0.003 SELECT * FROM Category WHERE parentId = 1136
0.002 SELECT * FROM Category WHERE parentId = 1137
0.001 SELECT * FROM Category WHERE parentId = 1140
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 = 5
0.003 SELECT * FROM Category WHERE parentId = 740
0.001 SELECT * FROM Category WHERE parentId = 982
0.001 SELECT * FROM Category WHERE parentId = 983
0.001 SELECT * FROM Category WHERE parentId = 621
0.001 SELECT * FROM Category WHERE parentId = 540
0.001 SELECT * FROM Category WHERE parentId = 741
0.001 SELECT * FROM Category WHERE parentId = 882
0.001 SELECT * FROM Category WHERE parentId = 987
0.001 SELECT * FROM Category WHERE parentId = 1087
0.004 SELECT * FROM Category WHERE parentId = 1088
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,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,6))
0.002 SELECT * FROM Category WHERE parentId = 233
0.004 SELECT * FROM Category WHERE parentId = 250
0.003 SELECT * FROM Category WHERE parentId = 950
0.001 SELECT * FROM Category WHERE parentId = 941
0.002 SELECT * FROM Category WHERE parentId = 1034
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408) OR category2Id IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408))
0.002 SELECT * FROM Category WHERE parentId = 866
0.001 SELECT * FROM Category WHERE parentId = 868
0.001 SELECT * FROM Category WHERE parentId = 1038
0.001 SELECT * FROM Category WHERE parentId = 1198
0.001 SELECT * FROM Category WHERE parentId = 871
0.005 SELECT * FROM Category WHERE parentId = 872
0.001 SELECT * FROM Category WHERE parentId = 981
0.001 SELECT * FROM Category WHERE parentId = 1010
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,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,877,1017,1093,1098,1099,1159,84))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197))
0.002 SELECT * FROM Category WHERE parentId = 875
0.001 SELECT * FROM Category WHERE parentId = 888
0.001 SELECT * FROM Category WHERE parentId = 313
0.001 SELECT * FROM Category WHERE parentId = 838
0.002 SELECT * FROM Category WHERE parentId = 334
0.002 SELECT * FROM Category WHERE parentId = 335
0.001 SELECT * FROM Category WHERE parentId = 365
0.001 SELECT * FROM Category WHERE parentId = 770
0.001 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 = 625
0.001 SELECT * FROM Category WHERE parentId = 906
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,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,1152))
0.001 SELECT * FROM Category WHERE parentId = 1161
0.001 SELECT * FROM Category WHERE parentId = 1175
0.001 SELECT * FROM Category WHERE parentId = 1178
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,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,2))
0.001 SELECT * FROM Category WHERE parentId = 2
0.001 SELECT * FROM Category WHERE parentId = 81
0.001 SELECT * FROM Category WHERE parentId = 206
0.001 SELECT * FROM Category WHERE parentId = 1070
0.001 SELECT * FROM Category WHERE parentId = 1072
0.001 SELECT * FROM Category WHERE parentId = 264
0.002 SELECT * FROM Category WHERE parentId = 684
0.001 SELECT * FROM Category WHERE parentId = 688
0.001 SELECT * FROM Category WHERE parentId = 517
0.005 SELECT * FROM Category WHERE parentId = 683
0.001 SELECT * FROM Category WHERE parentId = 502
0.001 SELECT * FROM Category WHERE parentId = 611
0.001 SELECT * FROM Category WHERE parentId = 580
0.001 SELECT * FROM Category WHERE parentId = 581
0.001 SELECT * FROM Category WHERE parentId = 596
0.001 SELECT * FROM Category WHERE parentId = 503
0.001 SELECT * FROM Category WHERE parentId = 472
0.001 SELECT * FROM Category WHERE parentId = 680
0.001 SELECT * FROM Category WHERE parentId = 840
0.001 SELECT * FROM Category WHERE parentId = 794
0.002 SELECT * FROM Category WHERE parentId = 797
0.001 SELECT * FROM Category WHERE parentId = 797
0.002 SELECT * FROM Category WHERE parentId = 798
0.001 SELECT * FROM Category WHERE parentId = 799
0.001 SELECT * FROM Category WHERE parentId = 1042
0.001 SELECT * FROM Category WHERE parentId = 989
0.001 SELECT * FROM Category WHERE parentId = 1137
0.001 SELECT * FROM Category WHERE parentId = 1140
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 = 597
0.004 SELECT * FROM Category WHERE parentId = 598
0.001 SELECT * FROM Category WHERE parentId = 621
0.005 SELECT * FROM Category WHERE parentId = 741
0.001 SELECT * FROM Category WHERE parentId = 743
0.001 SELECT * FROM Category WHERE parentId = 882
0.001 SELECT * FROM Category WHERE parentId = 1086
0.001 SELECT * FROM Category WHERE parentId = 1088
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,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,6))
0.001 SELECT * FROM Category WHERE parentId = 993
0.001 SELECT * FROM Category WHERE parentId = 773
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 = 1038
0.001 SELECT * FROM Category WHERE parentId = 1040
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,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,877,1017,1093,1098,1099,1159,84))
0.001 SELECT * FROM Category WHERE parentId = 844
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 = 671
0.001 SELECT * FROM Category WHERE parentId = 727
0.001 SELECT * FROM Category WHERE parentId = 728
0.001 SELECT * FROM Category WHERE parentId = 672
0.001 SELECT * FROM Category WHERE parentId = 732
0.001 SELECT * FROM Category WHERE parentId = 670
0.001 SELECT * FROM Category WHERE parentId = 724
0.006 SELECT * FROM Category WHERE parentId = 725
0.001 SELECT * FROM Category WHERE parentId = 726
0.001 SELECT * FROM Category WHERE parentId = 354
0.002 SELECT * FROM Category WHERE parentId = 364
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 = 765
0.001 SELECT * FROM Category WHERE parentId = 772
0.003 SELECT * FROM Category WHERE parentId = 707
0.001 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 = 625
0.001 SELECT * FROM Category WHERE parentId = 919
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,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,1152))
0.001 SELECT * FROM Category WHERE parentId = 1206
0.001 SELECT * FROM Category WHERE parentId = 1176
0.001 SELECT * FROM Category WHERE parentId = 1178
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=1495 GROUP BY Product.id
0.001 SELECT Product.*, t.name AS tm_name, t.homepage AS tm_homepage, t.garancijskaDoba as tm_garancija, Product.preorder, count(productdiscount.productId)>0 AS hasqdisc FROM Product LEFT JOIN trademark AS t ON t.id=Product.trademarkId LEFT JOIN productdiscount ON Product.id=productdiscount.productId WHERE Product.id=1495 GROUP BY Product.id
0.001 SELECT * FROM productprice WHERE productId=1495
0.001 SELECT size.* FROM size, productsize WHERE size.id=productsize.sizeId AND productsize.productId=1495 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 ProductColor JOIN ColorTable c on c.id=colorId WHERE productId=1495
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1495
0.001 SELECT * FROM productproperty WHERE propertyId = "158" AND productId = "1495"
0.002 SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 1495 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` = "1017" AND `id` != "1495"AND Product.active = "yes" GROUP BY Product.id ORDER BY unitPrice
0.001 SELECT Product.* FROM Product WHERE `categoryId` = "1017" AND `id` != "1495"AND Product.active = "yes" GROUP BY Product.id ORDER BY unitPrice LIMIT 5
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1253
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=945
0.001 SELECT defaultDiscount FROM Category WHERE id = 1017
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,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,2))
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5) OR category2Id IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,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,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,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,877,1017,1093,1098,1099,1159,84))
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,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,1152))
0.001 SELECT Product.* FROM Product WHERE Product.id IN (4,63,88,196,241,415,617,799,1180,1195) AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 5
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=196
0.004 SELECT defaultDiscount FROM Category WHERE id = 958
0.001 SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=617