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