0.003 SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/700mm-671.html"
0.005 SELECT * FROM Category ORDER BY sequence
0.118 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.002 SELECT id FROM Category WHERE parentID = 855
0.001 SELECT id FROM Category WHERE parentID = 482
0.001 SELECT id FROM Category WHERE parentID = 603
0.001 SELECT id FROM Category WHERE parentID = 795
0.001 SELECT id FROM Category WHERE parentID = 1200
0.001 SELECT id FROM Category WHERE parentID = 644
0.001 SELECT id FROM Category WHERE parentID = 988
0.001 SELECT id FROM Category WHERE parentID = 1149
0.001 SELECT id FROM Category WHERE parentID = 1109
0.001 SELECT id FROM Category WHERE parentID = 1081
0.001 SELECT id FROM Category WHERE parentID = 730
0.001 SELECT id FROM Category WHERE parentID = 710
0.002 SELECT id FROM Category WHERE parentID = 1044
0.002 SELECT id FROM Category WHERE parentID = 969
0.001 SELECT id FROM Category WHERE parentID = 972
0.001 SELECT id FROM Category WHERE parentID = 934
0.001 SELECT id FROM Category WHERE parentID = 918
0.006 SELECT id FROM Category WHERE parentID = 1050
0.001 SELECT id FROM Category WHERE parentID = 1052
0.009 SELECT id FROM Category WHERE parentID = 1154
0.005 SELECT id FROM Category WHERE parentID = 1168
0.004 SELECT id FROM Category WHERE parentID = 1181
0.035 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,1214,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,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,1213,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,1214,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,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,1213,1524,1)) AND active = 'yes'
0.039 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.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (281,282,283,324,91) OR category2Id IN (281,282,283,324,91)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1032) OR category2Id IN (1032)) AND active = 'yes'
0.001 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.004 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (553) OR category2Id IN (553)) AND active = 'yes'
0.003 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.004 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (576) OR category2Id IN (576)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (751) OR category2Id IN (751)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (577) OR category2Id IN (577)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (752) OR category2Id IN (752)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (515) OR category2Id IN (515)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (682,680,681,840,1194,516) OR category2Id IN (682,680,681,840,1194,516)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (680) OR category2Id IN (680)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1194) OR category2Id IN (1194)) AND active = 'yes'
0.006 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.008 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (855) OR category2Id IN (855)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (856) OR category2Id IN (856)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (857) OR category2Id IN (857)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (858) OR category2Id IN (858)) AND active = 'yes'
0.003 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 (496) OR category2Id IN (496)) 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 (1083) OR category2Id IN (1083)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (739) OR category2Id IN (739)) AND active = 'yes'
0.009 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 (709) OR category2Id IN (709)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (503) OR category2Id IN (503)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1062) OR category2Id IN (1062)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1063) OR category2Id IN (1063)) AND active = 'yes'
0.005 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (712) OR category2Id IN (712)) 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.001 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.001 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 (629) OR category2Id IN (629)) 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 (794,795,796,793) OR category2Id IN (794,795,796,793)) AND active = 'yes'
0.012 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (798,799,800,797) OR category2Id IN (798,799,800,797)) 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 (639) OR category2Id IN (639)) AND active = 'yes'
0.001 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.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 (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.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 (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 (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.004 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (983) OR category2Id IN (983)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (621) OR category2Id IN (621)) 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 (742) OR category2Id IN (742)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (987) OR category2Id IN (987)) AND active = 'yes'
0.003 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 (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)) 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 (833,783,784,785,786,787,788,979,776) OR category2Id IN (833,783,784,785,786,787,788,979,776)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1003) OR category2Id IN (1003)) AND active = 'yes'
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (953) OR category2Id IN (953)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (952) OR category2Id IN (952)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (943) OR category2Id IN (943)) AND active = 'yes'
0.004 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1127) OR category2Id IN (1127)) AND active = 'yes'
0.006 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 (863) OR category2Id IN (863)) AND active = 'yes'
0.018 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (977) OR category2Id IN (977)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (980) OR category2Id IN (980)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (869) OR category2Id IN (869)) AND active = 'yes'
0.004 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 (1151) OR category2Id IN (1151)) AND active = 'yes'
0.001 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 (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,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)) AND active = 'yes'
0.004 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.006 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.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (838,334,335,336,839,931,964,313) OR category2Id IN (838,334,335,336,839,931,964,313)) 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 (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.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.004 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.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1160) OR category2Id IN (1160)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1204) OR category2Id IN (1204)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1211) OR category2Id IN (1211)) 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.004 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.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 (968) OR category2Id IN (968)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (969) OR category2Id IN (969)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (921,925,926,899) OR category2Id IN (921,925,926,899)) 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.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (930) OR category2Id IN (930)) 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 (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 (1052) OR category2Id IN (1052)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1130) OR category2Id IN (1130)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1179) OR category2Id IN (1179)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1208) OR category2Id IN (1208)) 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 (1176) OR category2Id IN (1176)) 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 (1195) OR category2Id IN (1195)) AND active = 'yes'
0.01 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1188) OR category2Id IN (1188)) AND active = 'yes'
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1181,1182,1183,1180) OR category2Id IN (1181,1182,1183,1180)) AND active = 'yes'
0.011 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 (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 (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 (1163) OR category2Id IN (1163)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1172) OR category2Id IN (1172)) AND active = 'yes'
0.006 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1213) OR category2Id IN (1213)) AND active = 'yes'
0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1215) OR category2Id IN (1215)) AND active = 'yes'
0.008 SELECT * FROM Category WHERE id = "671"
0.001 SELECT * FROM trademark ORDER BY name ASC
0.003 SELECT * FROM Category WHERE parentId = 535
0.001 SELECT * FROM Category WHERE parentId = 206
0.003 SELECT * FROM Category WHERE parentId = 206
0.002 SELECT * FROM Category WHERE parentId = 1075
0.002 SELECT * FROM Category WHERE parentId = 1074
0.001 SELECT * FROM Category WHERE parentId = 1071
0.002 SELECT * FROM Category WHERE parentId = 1076
0.001 SELECT * FROM Category WHERE parentId = 685
0.001 SELECT * FROM Category WHERE parentId = 686
0.001 SELECT * FROM Category WHERE parentId = 687
0.002 SELECT * FROM Category WHERE parentId = 688
0.001 SELECT * FROM Category WHERE parentId = 689
0.002 SELECT * FROM Category WHERE parentId = 683
0.002 SELECT * FROM Category WHERE parentId = 534
0.001 SELECT * FROM Category WHERE parentId = 1101
0.002 SELECT * FROM Category WHERE parentId = 653
0.001 SELECT * FROM Category WHERE parentId = 833
0.001 SELECT * FROM Category WHERE parentId = 783
0.001 SELECT * FROM Category WHERE parentId = 785
0.002 SELECT * FROM Category WHERE parentId = 786
0.001 SELECT * FROM Category WHERE parentId = 787
0.002 SELECT * FROM Category WHERE parentId = 979
0.001 SELECT * FROM Category WHERE parentId = 802
0.001 SELECT * FROM Category WHERE parentId = 281
0.001 SELECT * FROM Category WHERE parentId = 324
0.001 SELECT * FROM Category WHERE parentId = 502
0.003 SELECT * FROM Category WHERE parentId = 1036
0.001 SELECT * FROM Category WHERE parentId = 1037
0.001 SELECT * FROM Category WHERE parentId = 504
0.001 SELECT * FROM Category WHERE parentId = 506
0.003 SELECT * FROM Category WHERE parentId = 506
0.001 SELECT * FROM Category WHERE parentId = 580
0.001 SELECT * FROM Category WHERE parentId = 596
0.001 SELECT * FROM Category WHERE parentId = 856
0.001 SELECT * FROM Category WHERE parentId = 857
0.001 SELECT * FROM Category WHERE parentId = 858
0.001 SELECT * FROM Category WHERE parentId = 482
0.001 SELECT * FROM Category WHERE parentId = 1057
0.002 SELECT * FROM Category WHERE parentId = 496
0.003 SELECT * FROM Category WHERE parentId = 498
0.001 SELECT * FROM Category WHERE parentId = 709
0.001 SELECT * FROM Category WHERE parentId = 739
0.001 SELECT * FROM Category WHERE parentId = 748
0.001 SELECT * FROM Category WHERE parentId = 655
0.001 SELECT * FROM Category WHERE parentId = 503
0.001 SELECT * FROM Category WHERE parentId = 602
0.001 SELECT * FROM Category WHERE parentId = 475
0.001 SELECT * FROM Category WHERE parentId = 553
0.001 SELECT * FROM Category WHERE parentId = 476
0.001 SELECT * FROM Category WHERE parentId = 476
0.001 SELECT * FROM Category WHERE parentId = 690
0.001 SELECT * FROM Category WHERE parentId = 576
0.001 SELECT * FROM Category WHERE parentId = 577
0.002 SELECT * FROM Category WHERE parentId = 578
0.001 SELECT * FROM Category WHERE parentId = 588
0.001 SELECT * FROM Category WHERE parentId = 626
0.001 SELECT * FROM Category WHERE parentId = 708
0.002 SELECT * FROM Category WHERE parentId = 751
0.001 SELECT * FROM Category WHERE parentId = 752
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.001 SELECT * FROM Category WHERE parentId = 516
0.001 SELECT * FROM Category WHERE parentId = 680
0.001 SELECT * FROM Category WHERE parentId = 681
0.001 SELECT * FROM Category WHERE parentId = 840
0.001 SELECT * FROM Category WHERE parentId = 1194
0.001 SELECT * FROM Category WHERE parentId = 630
0.001 SELECT * FROM Category WHERE parentId = 632
0.003 SELECT * FROM Category WHERE parentId = 634
0.001 SELECT * FROM Category WHERE parentId = 635
0.001 SELECT * FROM Category WHERE parentId = 636
0.001 SELECT * FROM Category WHERE parentId = 637
0.004 SELECT * FROM Category WHERE parentId = 793
0.001 SELECT * FROM Category WHERE parentId = 795
0.002 SELECT * FROM Category WHERE parentId = 798
0.001 SELECT * FROM Category WHERE parentId = 640
0.001 SELECT * FROM Category WHERE parentId = 641
0.005 SELECT * FROM Category WHERE parentId = 1041
0.004 SELECT * FROM Category WHERE parentId = 1042
0.006 SELECT * FROM Category WHERE parentId = 1043
0.001 SELECT * FROM Category WHERE parentId = 1200
0.001 SELECT * FROM Category WHERE parentId = 1201
0.001 SELECT * FROM Category WHERE parentId = 1202
0.003 SELECT * FROM Category WHERE parentId = 1005
0.005 SELECT * FROM Category WHERE parentId = 1006
0.001 SELECT * FROM Category WHERE parentId = 1007
0.001 SELECT * FROM Category WHERE parentId = 1008
0.001 SELECT * FROM Category WHERE parentId = 1133
0.008 SELECT * FROM Category WHERE parentId = 1134
0.005 SELECT * FROM Category WHERE parentId = 427
0.001 SELECT * FROM Category WHERE parentId = 984
0.005 SELECT * FROM Category WHERE parentId = 876
0.001 SELECT * FROM Category WHERE parentId = 6
0.001 SELECT * FROM Category WHERE parentId = 250
0.001 SELECT * FROM Category WHERE parentId = 991
0.001 SELECT * FROM Category WHERE parentId = 992
0.001 SELECT * FROM Category WHERE parentId = 993
0.006 SELECT * FROM Category WHERE parentId = 995
0.001 SELECT * FROM Category WHERE parentId = 1000
0.004 SELECT * FROM Category WHERE parentId = 244
0.001 SELECT * FROM Category WHERE parentId = 245
0.001 SELECT * FROM Category WHERE parentId = 246
0.002 SELECT * FROM Category WHERE parentId = 950
0.005 SELECT * FROM Category WHERE parentId = 951
0.001 SELECT * FROM Category WHERE parentId = 408
0.003 SELECT * FROM Category WHERE parentId = 1038
0.001 SELECT * FROM Category WHERE parentId = 1199
0.001 SELECT * FROM Category WHERE parentId = 872
0.001 SELECT * FROM Category WHERE parentId = 873
0.001 SELECT * FROM Category WHERE parentId = 874
0.001 SELECT * FROM Category WHERE parentId = 981
0.001 SELECT * FROM Category WHERE parentId = 1009
0.001 SELECT * FROM Category WHERE parentId = 1010
0.001 SELECT * FROM Category WHERE parentId = 84
0.001 SELECT * FROM Category WHERE parentId = 845
0.001 SELECT * FROM Category WHERE parentId = 846
0.001 SELECT * FROM Category WHERE parentId = 848
0.001 SELECT * FROM Category WHERE parentId = 850
0.001 SELECT * FROM Category WHERE parentId = 1026
0.001 SELECT * FROM Category WHERE parentId = 1215
0.001 SELECT * FROM Category WHERE parentId = 555
0.001 SELECT * FROM Category WHERE parentId = 727
0.001 SELECT * FROM Category WHERE parentId = 729
0.001 SELECT * FROM Category WHERE parentId = 672
0.001 SELECT * FROM Category WHERE parentId = 730
0.001 SELECT * FROM Category WHERE parentId = 732
0.001 SELECT * FROM Category WHERE parentId = 673
0.005 SELECT * FROM Category WHERE parentId = 724
0.001 SELECT * FROM Category WHERE parentId = 931
0.004 SELECT * FROM Category WHERE parentId = 964
0.001 SELECT * FROM Category WHERE parentId = 364
0.001 SELECT * FROM Category WHERE parentId = 656
0.001 SELECT * FROM Category WHERE parentId = 667
0.001 SELECT * FROM Category WHERE parentId = 678
0.001 SELECT * FROM Category WHERE parentId = 775
0.001 SELECT * FROM Category WHERE parentId = 765
0.001 SELECT * FROM Category WHERE parentId = 767
0.001 SELECT * FROM Category WHERE parentId = 768
0.001 SELECT * FROM Category WHERE parentId = 771
0.001 SELECT * FROM Category WHERE parentId = 377
0.001 SELECT * FROM Category WHERE parentId = 379
0.001 SELECT * FROM Category WHERE parentId = 893
0.001 SELECT * FROM Category WHERE parentId = 897
0.002 SELECT * FROM Category WHERE parentId = 899
0.001 SELECT * FROM Category WHERE parentId = 899
0.001 SELECT * FROM Category WHERE parentId = 898
0.001 SELECT * FROM Category WHERE parentId = 895
0.002 SELECT * FROM Category WHERE parentId = 901
0.002 SELECT * FROM Category WHERE parentId = 909
0.001 SELECT * FROM Category WHERE parentId = 910
0.001 SELECT * FROM Category WHERE parentId = 915
0.001 SELECT * FROM Category WHERE parentId = 916
0.001 SELECT * FROM Category WHERE parentId = 1048
0.001 SELECT * FROM Category WHERE parentId = 1050
0.001 SELECT * FROM Category WHERE parentId = 1052
0.001 SELECT * FROM Category WHERE parentId = 1153
0.001 SELECT * FROM Category WHERE parentId = 1156
0.004 SELECT * FROM Category WHERE parentId = 1155
0.002 SELECT * FROM Category WHERE parentId = 1157
0.004 SELECT * FROM Category WHERE parentId = 1158
0.001 SELECT * FROM Category WHERE parentId = 1162
0.001 SELECT * FROM Category WHERE parentId = 1167
0.001 SELECT * FROM Category WHERE parentId = 1175
0.001 SELECT * FROM Category WHERE parentId = 1173
0.002 SELECT * FROM Category WHERE parentId = 1185
0.005 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,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 = 1071
0.001 SELECT * FROM Category WHERE parentId = 1068
0.01 SELECT * FROM Category WHERE parentId = 264
0.001 SELECT * FROM Category WHERE parentId = 311
0.001 SELECT * FROM Category WHERE parentId = 333
0.001 SELECT * FROM Category WHERE parentId = 518
0.002 SELECT * FROM Category WHERE parentId = 734
0.002 SELECT * FROM Category WHERE parentId = 685
0.001 SELECT * FROM Category WHERE parentId = 534
0.001 SELECT * FROM Category WHERE parentId = 653
0.001 SELECT * FROM Category WHERE parentId = 785
0.001 SELECT * FROM Category WHERE parentId = 787
0.002 SELECT * FROM Category WHERE parentId = 788
0.001 SELECT * FROM Category WHERE parentId = 283
0.005 SELECT * FROM Category WHERE parentId = 474
0.002 SELECT * FROM Category WHERE parentId = 502
0.001 SELECT * FROM Category WHERE parentId = 857
0.001 SELECT * FROM Category WHERE parentId = 482
0.001 SELECT * FROM Category WHERE parentId = 496
0.001 SELECT * FROM Category WHERE parentId = 587
0.001 SELECT * FROM Category WHERE parentId = 1083
0.001 SELECT * FROM Category WHERE parentId = 655
0.002 SELECT * FROM Category WHERE parentId = 514
0.001 SELECT * FROM Category WHERE parentId = 552
0.001 SELECT * FROM Category WHERE parentId = 576
0.001 SELECT * FROM Category WHERE parentId = 578
0.008 SELECT * FROM Category WHERE parentId = 588
0.008 SELECT * FROM Category WHERE parentId = 626
0.005 SELECT * FROM Category WHERE parentId = 708
0.002 SELECT * FROM Category WHERE parentId = 738
0.007 SELECT * FROM Category WHERE parentId = 751
0.004 SELECT * FROM Category WHERE parentId = 752
0.005 SELECT * FROM Category WHERE parentId = 756
0.001 SELECT * FROM Category WHERE parentId = 477
0.001 SELECT * FROM Category WHERE parentId = 516
0.002 SELECT * FROM Category WHERE parentId = 516
0.002 SELECT * FROM Category WHERE parentId = 682
0.003 SELECT * FROM Category WHERE parentId = 681
0.006 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.004 SELECT * FROM Category WHERE parentId = 632
0.001 SELECT * FROM Category WHERE parentId = 635
0.001 SELECT * FROM Category WHERE parentId = 637
0.001 SELECT * FROM Category WHERE parentId = 638
0.001 SELECT * FROM Category WHERE parentId = 793
0.002 SELECT * FROM Category WHERE parentId = 793
0.001 SELECT * FROM Category WHERE parentId = 794
0.001 SELECT * FROM Category WHERE parentId = 795
0.001 SELECT * FROM Category WHERE parentId = 796
0.001 SELECT * FROM Category WHERE parentId = 797
0.004 SELECT * FROM Category WHERE parentId = 797
0.001 SELECT * FROM Category WHERE parentId = 798
0.001 SELECT * FROM Category WHERE parentId = 799
0.001 SELECT * FROM Category WHERE parentId = 800
0.001 SELECT * FROM Category WHERE parentId = 960
0.002 SELECT * FROM Category WHERE parentId = 639
0.003 SELECT * FROM Category WHERE parentId = 640
0.001 SELECT * FROM Category WHERE parentId = 641
0.001 SELECT * FROM Category WHERE parentId = 642
0.002 SELECT * FROM Category WHERE parentId = 643
0.001 SELECT * FROM Category WHERE parentId = 643
0.001 SELECT * FROM Category WHERE parentId = 1041
0.002 SELECT * FROM Category WHERE parentId = 1042
0.002 SELECT * FROM Category WHERE parentId = 1043
0.001 SELECT * FROM Category WHERE parentId = 1200
0.001 SELECT * FROM Category WHERE parentId = 1202
0.001 SELECT * FROM Category WHERE parentId = 644
0.001 SELECT * FROM Category WHERE parentId = 976
0.001 SELECT * FROM Category WHERE parentId = 1006
0.001 SELECT * FROM Category WHERE parentId = 1007
0.002 SELECT * FROM Category WHERE parentId = 975
0.001 SELECT * FROM Category WHERE parentId = 1106
0.003 SELECT * FROM Category WHERE parentId = 1107
0.001 SELECT * FROM Category WHERE parentId = 1109
0.001 SELECT * FROM Category WHERE parentId = 1110
0.001 SELECT * FROM Category WHERE parentId = 1111
0.001 SELECT * FROM Category WHERE parentId = 1112
0.001 SELECT * FROM Category WHERE parentId = 1113
0.001 SELECT * FROM Category WHERE parentId = 1133
0.002 SELECT * FROM Category WHERE parentId = 1134
0.001 SELECT * FROM Category WHERE parentId = 1135
0.002 SELECT * FROM Category WHERE parentId = 1136
0.001 SELECT * FROM Category WHERE parentId = 1137
0.001 SELECT * FROM Category WHERE parentId = 1139
0.001 SELECT * FROM Category WHERE parentId = 1140
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 = 597
0.001 SELECT * FROM Category WHERE parentId = 598
0.001 SELECT * FROM Category WHERE parentId = 740
0.001 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.002 SELECT * FROM Category WHERE parentId = 424
0.002 SELECT * FROM Category WHERE parentId = 425
0.001 SELECT * FROM Category WHERE parentId = 426
0.003 SELECT * FROM Category WHERE parentId = 427
0.001 SELECT * FROM Category WHERE parentId = 743
0.002 SELECT * FROM Category WHERE parentId = 744
0.001 SELECT * FROM Category WHERE parentId = 882
0.002 SELECT * FROM Category WHERE parentId = 986
0.001 SELECT * FROM Category WHERE parentId = 745
0.001 SELECT * FROM Category WHERE parentId = 747
0.002 SELECT * FROM Category WHERE parentId = 876
0.001 SELECT * FROM Category WHERE parentId = 1086
0.002 SELECT * FROM Category WHERE parentId = 1088
0.002 SELECT * FROM Category WHERE parentId = 1089
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.002 SELECT * FROM Category WHERE parentId = 6
0.002 SELECT * FROM Category WHERE parentId = 233
0.001 SELECT * FROM Category WHERE parentId = 250
0.001 SELECT * FROM Category WHERE parentId = 991
0.001 SELECT * FROM Category WHERE parentId = 992
0.001 SELECT * FROM Category WHERE parentId = 994
0.001 SELECT * FROM Category WHERE parentId = 996
0.001 SELECT * FROM Category WHERE parentId = 998
0.001 SELECT * FROM Category WHERE parentId = 999
0.001 SELECT * FROM Category WHERE parentId = 1000
0.001 SELECT * FROM Category WHERE parentId = 244
0.002 SELECT * FROM Category WHERE parentId = 367
0.001 SELECT * FROM Category WHERE parentId = 950
0.002 SELECT * FROM Category WHERE parentId = 951
0.001 SELECT * FROM Category WHERE parentId = 952
0.001 SELECT * FROM Category WHERE parentId = 953
0.001 SELECT * FROM Category WHERE parentId = 773
0.001 SELECT * FROM Category WHERE parentId = 834
0.001 SELECT * FROM Category WHERE parentId = 835
0.002 SELECT * FROM Category WHERE parentId = 1002
0.001 SELECT * FROM Category WHERE parentId = 1003
0.001 SELECT * FROM Category WHERE parentId = 836
0.001 SELECT * FROM Category WHERE parentId = 939
0.006 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408) OR category2Id IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408))
0.002 SELECT * FROM Category WHERE parentId = 408
0.007 SELECT * FROM Category WHERE parentId = 859
0.002 SELECT * FROM Category WHERE parentId = 860
0.001 SELECT * FROM Category WHERE parentId = 861
0.002 SELECT * FROM Category WHERE parentId = 862
0.003 SELECT * FROM Category WHERE parentId = 863
0.001 SELECT * FROM Category WHERE parentId = 977
0.001 SELECT * FROM Category WHERE parentId = 1203
0.001 SELECT * FROM Category WHERE parentId = 866
0.003 SELECT * FROM Category WHERE parentId = 868
0.001 SELECT * FROM Category WHERE parentId = 870
0.001 SELECT * FROM Category WHERE parentId = 1039
0.001 SELECT * FROM Category WHERE parentId = 1040
0.001 SELECT * FROM Category WHERE parentId = 1198
0.001 SELECT * FROM Category WHERE parentId = 1199
0.001 SELECT * FROM Category WHERE parentId = 1197
0.001 SELECT * FROM Category WHERE parentId = 873
0.001 SELECT * FROM Category WHERE parentId = 874
0.001 SELECT * FROM Category WHERE parentId = 1009
0.001 SELECT * FROM Category WHERE parentId = 1011
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.004 SELECT * FROM Category WHERE parentId = 84
0.001 SELECT * FROM Category WHERE parentId = 844
0.001 SELECT * FROM Category WHERE parentId = 846
0.004 SELECT * FROM Category WHERE parentId = 848
0.001 SELECT * FROM Category WHERE parentId = 1215
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))
0.002 SELECT * FROM Category WHERE parentId = 197
0.002 SELECT * FROM Category WHERE parentId = 555
0.001 SELECT * FROM Category WHERE parentId = 671
0.001 SELECT * FROM Category WHERE parentId = 727
0.001 SELECT * FROM Category WHERE parentId = 730
0.005 SELECT * FROM Category WHERE parentId = 731
0.001 SELECT * FROM Category WHERE parentId = 732
0.001 SELECT * FROM Category WHERE parentId = 670
0.001 SELECT * FROM Category WHERE parentId = 670
0.001 SELECT * FROM Category WHERE parentId = 724
0.001 SELECT * FROM Category WHERE parentId = 726
0.001 SELECT * FROM Category WHERE parentId = 887
0.002 SELECT * FROM Category WHERE parentId = 889
0.001 SELECT * FROM Category WHERE parentId = 1020
0.002 SELECT * FROM Category WHERE parentId = 1021
0.001 SELECT * FROM Category WHERE parentId = 1095
0.002 SELECT * FROM Category WHERE parentId = 354
0.003 SELECT * FROM Category WHERE parentId = 356
0.001 SELECT * FROM Category WHERE parentId = 359
0.001 SELECT * FROM Category WHERE parentId = 358
0.001 SELECT * FROM Category WHERE parentId = 383
0.001 SELECT * FROM Category WHERE parentId = 384
0.001 SELECT * FROM Category WHERE parentId = 385
0.001 SELECT * FROM Category WHERE parentId = 313
0.001 SELECT * FROM Category WHERE parentId = 838
0.001 SELECT * FROM Category WHERE parentId = 334
0.001 SELECT * FROM Category WHERE parentId = 335
0.001 SELECT * FROM Category WHERE parentId = 839
0.003 SELECT * FROM Category WHERE parentId = 931
0.001 SELECT * FROM Category WHERE parentId = 964
0.001 SELECT * FROM Category WHERE parentId = 364
0.001 SELECT * FROM Category WHERE parentId = 656
0.001 SELECT * FROM Category WHERE parentId = 667
0.001 SELECT * FROM Category WHERE parentId = 775
0.001 SELECT * FROM Category WHERE parentId = 765
0.001 SELECT * FROM Category WHERE parentId = 766
0.001 SELECT * FROM Category WHERE parentId = 772
0.002 SELECT * FROM Category WHERE parentId = 378
0.001 SELECT * FROM Category WHERE parentId = 402
0.001 SELECT * FROM Category WHERE parentId = 405
0.001 SELECT * FROM Category WHERE parentId = 704
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 = 927
0.001 SELECT * FROM Category WHERE parentId = 968
0.001 SELECT * FROM Category WHERE parentId = 972
0.001 SELECT * FROM Category WHERE parentId = 895
0.001 SELECT * FROM Category WHERE parentId = 910
0.001 SELECT * FROM Category WHERE parentId = 938
0.001 SELECT * FROM Category WHERE parentId = 933
0.001 SELECT * FROM Category WHERE parentId = 961
0.005 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 = 1153
0.001 SELECT * FROM Category WHERE parentId = 1155
0.001 SELECT * FROM Category WHERE parentId = 1157
0.001 SELECT * FROM Category WHERE parentId = 1158
0.001 SELECT * FROM Category WHERE parentId = 1161
0.001 SELECT * FROM Category WHERE parentId = 1162
0.001 SELECT * FROM Category WHERE parentId = 1166
0.001 SELECT * FROM Category WHERE parentId = 1207
0.002 SELECT COUNT(*) AS product_count FROM Product WHERE (Product.categoryId IN (727,728,729,671) OR Product.category2Id IN (727,728,729,671))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC
0.001 SELECT Product.* FROM Product WHERE (Product.categoryId IN (727,728,729,671) OR Product.category2Id IN (727,728,729,671))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 0,20
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=1016 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=1018 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=1019 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=1020 AND definesPackagePart='yes'
0.002 SELECT Product.* FROM Product WHERE (Product.categoryId IN (727,728,729,671) OR Product.category2Id IN (727,728,729,671))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC
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=1016 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=1017 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=1019 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=1020 AND definesPackagePart='yes'
0.005 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,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.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.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.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84) OR category2Id IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84))
0.003 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197))
0.002 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625))
0.003 SELECT 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.004 SELECT COUNT(*) AS product_count FROM Product WHERE (Product.categoryId IN (727,728,729,671) OR Product.category2Id IN (727,728,729,671))
0.001 SELECT Product.* FROM Product WHERE (Product.categoryId IN (727,728,729,671) OR Product.category2Id IN (727,728,729,671)) LIMIT 0,50
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=1016 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=1019 AND definesPackagePart='yes'
0.002 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=1020 AND definesPackagePart='yes'
0.001 SELECT * FROM producttypeproperty WHERE productTypeId=0 ORDER BY sort ASC