|
0.004 |
SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/poe-napajanje-502.html" |
|
0.008 |
SELECT * FROM Category ORDER BY sequence |
|
0.105 |
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 = 2 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 81 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 470 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 787 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 324 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 858 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 476 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 690 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 708 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 797 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 799 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 631 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 115 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 621 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 540 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 428 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 891 |
|
0.007 |
SELECT id FROM Category WHERE parentID = 747 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 837 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 845 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 850 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 671 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 730 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1021 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 357 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 1084 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1096 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 408 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 868 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1013 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1015 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1192 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 898 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 930 |
|
0.005 |
SELECT id FROM Category WHERE parentID = 904 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 906 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 910 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1165 |
|
0.006 |
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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,1)) AND active = 'yes' |
|
0.006 |
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 (1032) OR category2Id IN (1032)) AND active = 'yes' |
|
0.002 |
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 (552) OR category2Id IN (552)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (553) OR category2Id IN (553)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (554) OR category2Id IN (554)) 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 (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 (752) OR category2Id IN (752)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (588) OR category2Id IN (588)) 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 (1194) OR category2Id IN (1194)) AND active = 'yes' |
|
0.003 |
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.001 |
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.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 (1035,1036,1037,502) OR category2Id IN (1035,1036,1037,502)) 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 (504) OR category2Id IN (504)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1062) OR category2Id IN (1062)) AND active = 'yes' |
|
0.003 |
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 (1064) OR category2Id IN (1064)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1065) OR category2Id IN (1065)) AND active = 'yes' |
|
0.002 |
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 (1107) OR category2Id IN (1107)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1108) OR category2Id IN (1108)) 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 (1110) OR category2Id IN (1110)) 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 (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 (640) OR category2Id IN (640)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (642) OR category2Id IN (642)) 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 (1041) OR category2Id IN (1041)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1042) OR category2Id IN (1042)) 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 (1200) OR category2Id IN (1200)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1201) OR category2Id IN (1201)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (644) OR category2Id IN (644)) 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 (1141) OR category2Id IN (1141)) 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.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 (746) OR category2Id IN (746)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (747) OR category2Id IN (747)) 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.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.001 |
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 (987) OR category2Id IN (987)) 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 (1087) OR category2Id IN (1087)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (540,425,426,427,428,424) OR category2Id IN (540,425,426,427,428,424)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (426) OR category2Id IN (426)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (174) OR category2Id IN (174)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1100) OR category2Id IN (1100)) 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.001 |
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.001 |
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 (941) OR category2Id IN (941)) AND active = 'yes' |
|
0.001 |
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 (1034) OR category2Id IN (1034)) 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 (246) OR category2Id IN (246)) AND active = 'yes' |
|
0.001 |
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 (943) OR category2Id IN (943)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957) OR category2Id IN (957)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1127) OR category2Id IN (1127)) AND active = 'yes' |
|
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,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,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 (861) OR category2Id IN (861)) 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 (863) OR category2Id IN (863)) AND active = 'yes' |
|
0.003 |
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.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 (1197) OR category2Id IN (1197)) 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 (1199) OR category2Id IN (1199)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1190) OR category2Id IN (1190)) 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.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1010) OR category2Id IN (1010)) 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 (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 (874) OR category2Id IN (874)) AND active = 'yes' |
|
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,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 (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 (845,846,844) OR category2Id IN (845,846,844)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (845) OR category2Id IN (845)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (846) OR category2Id IN (846)) AND active = 'yes' |
|
0.001 |
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 (1098) OR category2Id IN (1098)) AND active = 'yes' |
|
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,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,197)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (335) OR category2Id IN (335)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (334) OR category2Id IN (334)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (336) OR category2Id IN (336)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (838) OR category2Id IN (838)) 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 (656) OR category2Id IN (656)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (658) OR category2Id IN (658)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (667) OR category2Id IN (667)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (775) OR category2Id IN (775)) 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.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (357) OR category2Id IN (357)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1019) OR category2Id IN (1019)) AND active = 'yes' |
|
0.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1047) OR category2Id IN (1047)) AND active = 'yes' |
|
0.001 |
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 (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.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625)) AND active = 'yes' |
|
0.001 |
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 (938) OR category2Id IN (938)) AND active = 'yes' |
|
0.002 |
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.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.001 |
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.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 (973) OR category2Id IN (973)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1018) OR category2Id IN (1018)) 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.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1049) OR category2Id IN (1049)) AND active = 'yes' |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1156,1154,1155,1157,1158,1153) OR category2Id IN (1156,1154,1155,1157,1158,1153)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1155) OR category2Id IN (1155)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1162,1163,1164,1167,1166,1165,1161) OR category2Id IN (1162,1163,1164,1167,1166,1165,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 (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.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1167) OR category2Id IN (1167)) 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.001 |
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 (1170) OR category2Id IN (1170)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1171) OR category2Id IN (1171)) AND active = 'yes' |
|
0.003 |
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 (1174) OR category2Id IN (1174)) 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 (1178) OR category2Id IN (1178)) 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.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1181) OR category2Id IN (1181)) AND active = 'yes' |
|
0.001 |
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 (1183) OR category2Id IN (1183)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1187,1185,1186,1184) OR category2Id IN (1187,1185,1186,1184)) 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 (1188) OR category2Id IN (1188)) AND active = 'yes' |
|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1195) OR category2Id IN (1195)) AND active = 'yes' |
|
0.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,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 = 470 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 535 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1071 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1068 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 264 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 691 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 518 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 573 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 653 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 776 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 506 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 475 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 797 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 797 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 960 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 976 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1006 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1008 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1133 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1134 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5) OR category2Id IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,5)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 986 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,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 = 139 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 233 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 991 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 773 |
|
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,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,408)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 860 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 980 |
|
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,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,197)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 670 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 887 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1095 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 350 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 657 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 768 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 704 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 893 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 896 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 903 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1024 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1048 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1049 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1051 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1050 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1153 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1163 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 1164 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1165 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 1170 |
|
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.001 |
SELECT * FROM Category WHERE parentId = 2 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 311 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 776 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 833 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 785 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 91 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 482 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 472 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 514 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1202 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 644 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1007 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1106 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1107 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1108 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1133 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1137 |
|
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 = 598 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 740 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 983 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 876 |
|
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 = 250 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 834 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 835 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,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,408)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 859 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 864 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 981 |
|
0.006 |
SELECT * FROM Category WHERE parentId = 1010 |
|
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,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.001 |
SELECT * FROM Category WHERE parentId = 853 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1026 |
|
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,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,197)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 197 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 725 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 357 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 383 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 385 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 931 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 350 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 657 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 658 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 352 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 667 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 766 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 769 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 897 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 898 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 920 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 919 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 973 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1018 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 894 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 916 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 936 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1174 |
|
0.01 |
SELECT COUNT(*) AS product_count FROM Product WHERE (Product.categoryId IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC |
|
0.005 |
SELECT Product.* FROM Product WHERE (Product.categoryId IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 0,20 |
|
0.051 |
SELECT Product.* FROM Product WHERE (Product.categoryId IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC |
|
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.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,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,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,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,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1152)) |
|
0.003 |
SELECT COUNT(*) AS product_count FROM Product WHERE (Product.categoryId IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0)) |
|
0.004 |
SELECT Product.* FROM Product WHERE (Product.categoryId IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,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,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,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,1161,1162,1163,1164,1167,1166,1165,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1524,35,36,37,38,39,40,41,42,43,44,45,46,0)) LIMIT 0,50 |
|
0.004 |
SELECT distinct value, id FROM producttypepropertyvalue where productTypePropertyId=158 and value is not null and value<>'' ORDER BY CAST( value AS SIGNED INTEGER ) ASC, value ASC |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 769 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 760 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 885 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 880 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.007 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 781 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.006 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 778 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 878 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 876 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 772 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 881 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 874 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 918 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 877 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 884 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 903 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 879 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.006 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 936 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 801 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 790 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 864 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 759 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 766 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 862 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 839 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 900 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 786 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 787 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.006 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 767 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 849 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 871 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 896 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 863 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 934 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 845 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 846 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 883 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 750 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 838 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 775 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 768 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT distinct value, id FROM producttypepropertyvalue where productTypePropertyId=160 and value is not null and value<>'' ORDER BY CAST( value AS SIGNED INTEGER ) ASC, value ASC |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 755 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 757 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 793 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 922 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.006 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 800 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 857 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 817 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 795 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 797 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 806 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 804 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 796 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 803 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 816 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 856 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 930 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 931 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 854 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 855 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 889 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 869 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 870 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 890 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 791 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 867 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 868 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 819 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 920 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 897 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 820 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 821 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 898 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 751 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 814 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 792 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 844 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 872 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 873 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 815 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 887 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 784 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 785 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.007 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 888 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 752 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 764 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 832 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 833 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 765 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.008 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 782 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 783 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 891 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 899 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 779 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 860 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 861 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 780 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 812 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 847 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 848 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 813 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 919 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 753 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 798 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 802 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 818 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 805 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 807 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 901 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 902 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 776 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 777 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 754 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 788 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 789 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 925 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 808 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 809 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 773 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 774 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 865 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 866 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 842 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 843 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 810 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 811 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 923 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 924 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 932 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 834 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 835 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 822 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 823 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 933 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 761 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 763 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 794 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 912 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 913 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 840 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 841 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 921 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 892 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 893 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 836 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 837 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 770 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 771 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 826 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 827 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 858 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 859 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 850 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 830 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 831 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 799 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 851 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 908 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 909 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 824 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 825 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 910 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 911 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 906 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 907 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 852 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.005 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 853 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 928 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 929 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 828 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 829 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 904 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 905 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 894 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 895 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 926 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 927 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 914 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 915 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 756 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 916 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 917 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 944 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 938 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 937 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 943 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 935 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 939 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 941 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 940 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 942 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 945 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.002 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 946 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT distinct value, id FROM producttypepropertyvalue where productTypePropertyId=161 and value is not null and value<>'' ORDER BY CAST( value AS SIGNED INTEGER ) ASC, value ASC |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 886 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 882 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 758 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 762 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.009 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 875 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=9 |
|
0.001 |
SELECT defaultDiscount FROM Category WHERE id = 629 |
|
0.001 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=19 |
|
0.003 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=21 |
