|
0.002 |
SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/akcija.html" |
|
0.4 |
SELECT
c.id AS category_id,
c.CategoryTree,
COUNT(DISTINCT p.id) AS product_count
FROM Category c
JOIN Product p
ON (
p.categoryId = c.id OR
p.category2Id = c.id OR
p.category3Id = c.id OR
p.category4Id = c.id OR
p.category5Id = c.id OR
p.category6Id = c.id
)
WHERE p.active = 'yes'
GROUP BY c.id
ORDER BY c.CategoryTree DESC |
|
0.004 |
SELECT * FROM Category ORDER BY sequence |
|
0.005 |
SELECT * FROM trademark ORDER BY name ASC |
|
0.001 |
SELECT * FROM Category WHERE parentId = 2 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 81 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 691 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 534 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 1101 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 645 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 833 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1029 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 81 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 470 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 206 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1070 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1073 |
|
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 = 311 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 518 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 684 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 685 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 686 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 683 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 534 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1101 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 573 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 653 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 776 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 783 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 786 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 787 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 788 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1029 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 281 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 283 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 324 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 506 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 611 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 580 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 581 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 481 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 856 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 858 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1056 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 496 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 655 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 474 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 502 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1035 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1036 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 504 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 506 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 506 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 580 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 581 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 481 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 481 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 856 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 858 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1056 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1057 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 496 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 498 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 587 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 709 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 748 |
|
0.005 |
SELECT id FROM Category WHERE parentID = 1063 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 553 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 554 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 476 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 576 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 588 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 626 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 708 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 738 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 840 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 515 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 472 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 514 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 588 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 516 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 682 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1194 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1062 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 632 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 634 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 635 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 637 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 638 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 793 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 794 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 798 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 800 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1125 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 634 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 635 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 797 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 798 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 800 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 960 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1125 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 631 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 639 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1200 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 639 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 643 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1202 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 644 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 712 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1005 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1008 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 975 |
|
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 = 1149 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1108 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1112 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1106 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1110 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1112 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1113 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1133 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1135 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 1138 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1140 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1134 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 5 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 115 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 174 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 597 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 599 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 598 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 621 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 597 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 599 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 598 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 740 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 740 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 983 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 424 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 987 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 745 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 891 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 984 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 985 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 747 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 745 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 891 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 984 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 985 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1087 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1086 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1087 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1089 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1097 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1100 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 6 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1000 |
|
0.013 |
SELECT id FROM Category WHERE parentID = 244 |
|
0.012 |
SELECT id FROM Category WHERE parentID = 245 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 943 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 952 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 950 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 953 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 1033 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 773 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 1002 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 837 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 940 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1034 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 945 |
|
0.011 |
SELECT id FROM Category WHERE parentID = 1129 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 408 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1004 |
|
0.011 |
SELECT id FROM Category WHERE parentID = 861 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 862 |
|
0.01 |
SELECT id FROM Category WHERE parentID = 1203 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 859 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 860 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 862 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 864 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 865 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 866 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 1038 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 1040 |
|
0.005 |
SELECT * FROM Category WHERE parentId = 870 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1038 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 1039 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1040 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1198 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1199 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1197 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 981 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 966 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1009 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 1151 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1193 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1190 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1205 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 84 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 845 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 846 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 845 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 846 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 847 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 849 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 850 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 853 |
|
0.005 |
SELECT * FROM Category WHERE parentId = 1026 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1215 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 672 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 730 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 731 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 732 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 673 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 670 |
|
0.002 |
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 = 888 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 354 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 356 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 359 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 385 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 357 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 359 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 383 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 383 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 384 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 274 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 313 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 334 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 336 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 931 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 336 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 364 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 365 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 352 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 775 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 707 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 1090 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 1211 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 920 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 910 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 913 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 938 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 893 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 897 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 899 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 898 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 970 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 905 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 909 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 910 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 938 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 918 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 961 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 936 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1048 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1049 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1052 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1153 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1157 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1158 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1212 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1153 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1154 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1155 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1158 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1212 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1161 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 1165 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1165 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1206 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1176 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1177 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1175 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1168 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1170 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1169 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1179 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1180 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1182 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1183 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1184 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1187 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1185 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1184 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1189 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 1195 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1196 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1210 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1209 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1208 |
|
0.002 |
SELECT id FROM Category WHERE parentID = 2 |
|
0.011 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2)) |
|
0.004 |
SELECT * FROM Category WHERE parentId = 2 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 81 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 171 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 470 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 206 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 206 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1075 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1076 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 311 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 691 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 518 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 518 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 684 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 688 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 689 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 517 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1101 |
|
0.012 |
SELECT * FROM Category WHERE parentId = 645 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 653 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 786 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 787 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 788 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 502 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1037 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 611 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 481 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 750 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 892 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 475 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 552 |
|
0.011 |
SELECT * FROM Category WHERE parentId = 553 |
|
0.005 |
SELECT * FROM Category WHERE parentId = 554 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 476 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 630 |
|
0.012 |
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 = 796 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 639 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 643 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1006 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 975 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1109 |
|
0.01 |
SELECT * FROM Category WHERE parentId = 1133 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1134 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1135 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1136 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1137 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1138 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1139 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1140 |
|
0.004 |
SELECT id FROM Category WHERE parentID = 5 |
|
0.006 |
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 * FROM Category WHERE parentId = 5 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 597 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 599 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 598 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 740 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 740 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 982 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 983 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 621 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 424 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 540 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 425 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 426 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 427 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 428 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 741 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 742 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 743 |
|
0.005 |
SELECT * FROM Category WHERE parentId = 744 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 986 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 745 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 747 |
|
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.005 |
SELECT * FROM Category WHERE parentId = 6 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 233 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 250 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 991 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 997 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 950 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 951 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 953 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 834 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1002 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1003 |
|
0.005 |
SELECT * FROM Category WHERE parentId = 939 |
|
0.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408) OR category2Id IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,408)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 408 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 864 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 980 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 870 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1039 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1199 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 871 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1011 |
|
0.002 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84) OR category2Id IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 84 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 846 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 848 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1026 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 197 |
|
0.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,197)) |
|
0.001 |
SELECT * FROM Category WHERE parentId = 197 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 727 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 672 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 731 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 724 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 384 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 365 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 366 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 658 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 352 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 775 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 765 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 765 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 766 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 767 |
|
0.006 |
SELECT * FROM Category WHERE parentId = 768 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 769 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 772 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 378 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 401 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 402 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 403 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 404 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 405 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 625 |
|
0.006 |
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.004 |
SELECT * FROM Category WHERE parentId = 893 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 897 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 899 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 899 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 921 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 925 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 926 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 898 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 919 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 919 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 927 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 928 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 929 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 967 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 968 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 970 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 971 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 972 |
|
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.002 |
SELECT * FROM Category WHERE parentId = 901 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 903 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 905 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 906 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 909 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 910 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 913 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 990 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 894 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 916 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 917 |
|
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 = 936 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1048 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1051 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1050 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1052 |
|
0.003 |
SELECT id FROM Category WHERE parentID = 1152 |
|
0.007 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152)) |
|
0.005 |
SELECT * FROM Category WHERE parentId = 1152 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1156 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1154 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1155 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1212 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 1161 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1162 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1163 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1164 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1167 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1165 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1207 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1178 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1168 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1172 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1174 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1170 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1169 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1171 |
|
0.003 |
SELECT * FROM Category WHERE parentId = 1180 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1181 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1182 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1183 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1184 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1187 |
|
0.004 |
SELECT * FROM Category WHERE parentId = 1185 |
|
0.005 |
SELECT * FROM Category WHERE parentId = 1186 |
|
0.001 |
SELECT * FROM `promotion` WHERE `id` = "1" |
|
0.008 |
SELECT COUNT(*) AS product_count FROM Product WHERE Product.active = "yes" AND `active` = "yes" AND `discount` > 0 AND Product.trademarkId = "23" GROUP BY Product.id ORDER BY Product.sequence ASC |
|
0.005 |
SELECT Product.* FROM Product WHERE Product.active = "yes" AND `active` = "yes" AND `discount` > 0 AND Product.trademarkId = "23" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 0,20 |
|
0.004 |
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=1068 AND definesPackagePart='yes' |
|
0.006 |
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=1073 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=1077 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=1081 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=1082 AND definesPackagePart='yes' |
|
0.004 |
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=1089 AND definesPackagePart='yes' |
|
0.003 |
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=1094 AND definesPackagePart='yes' |
|
0.006 |
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=1095 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=1097 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=1098 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=1099 AND definesPackagePart='yes' |
|
0.009 |
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=1100 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=1102 AND definesPackagePart='yes' |
|
0.002 |
SELECT Product.* FROM Product WHERE Product.active = "yes" AND `active` = "yes" AND `discount` > 0 AND Product.trademarkId = "23" GROUP BY Product.id ORDER BY Product.sequence ASC |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=1104 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=1106 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=1115 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=1131 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=1132 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=1136 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=1138 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=1141 AND definesPackagePart='yes' |
|
0.003 |
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=1149 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=1152 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=1172 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=1545 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=1546 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=1577 AND definesPackagePart='yes' |
|
0.003 |
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=1728 AND definesPackagePart='yes' |
|
0.005 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2)) |
|
0.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.012 |
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.006 |
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.007 |
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.006 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625)) |
|
0.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152)) |
|
0.011 |
SELECT COUNT(*) AS product_count FROM Product WHERE Product.active = "yes" AND `active` = "yes" AND `discount` > 0 |
|
0.004 |
SELECT Product.* FROM Product WHERE Product.active = "yes" AND `active` = "yes" AND `discount` > 0 LIMIT 0,50 |
|
0.01 |
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=2044 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=737 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=1061 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=1631 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=1668 AND definesPackagePart='yes' |
|
0.005 |
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=551 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=79 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=107 AND definesPackagePart='yes' |
|
0.003 |
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=115 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=130 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=131 AND definesPackagePart='yes' |
|
0.004 |
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=161 AND definesPackagePart='yes' |
|
0.004 |
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=163 AND definesPackagePart='yes' |
|
0.003 |
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=164 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=169 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=228 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=238 AND definesPackagePart='yes' |
|
0.003 |
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=308 AND definesPackagePart='yes' |
|
0.003 |
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=373 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=414 AND definesPackagePart='yes' |
|
0.003 |
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=448 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=450 AND definesPackagePart='yes' |
|
0.003 |
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=492 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=515 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=516 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=517 AND definesPackagePart='yes' |
|
0.006 |
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=530 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=531 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=532 AND definesPackagePart='yes' |
|
0.004 |
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=534 AND definesPackagePart='yes' |
|
0.003 |
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=535 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=536 AND definesPackagePart='yes' |
|
0.005 |
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=537 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=618 AND definesPackagePart='yes' |
|
0.003 |
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=645 AND definesPackagePart='yes' |
|
0.003 |
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=646 AND definesPackagePart='yes' |
|
0.004 |
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=658 AND definesPackagePart='yes' |
|
0.003 |
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=796 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=901 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=974 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=1149 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=1191 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=1280 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=1289 AND definesPackagePart='yes' |
|
0.001 |
SELECT * FROM trademark WHERE id=3 |
|
0.001 |
SELECT * FROM trademark WHERE id=25 |
|
0.001 |
SELECT * FROM trademark WHERE id=55 |
|
0.002 |
SELECT * FROM trademark WHERE id=5 |
|
0.002 |
SELECT * FROM trademark WHERE id=18 |
|
0.001 |
SELECT * FROM trademark WHERE id=7 |
|
0.004 |
SELECT * FROM trademark WHERE id=33 |
|
0.001 |
SELECT * FROM trademark WHERE id=23 |
|
0.001 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1068 |
|
0.001 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1086 |
|
0.003 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1094 |
|
0.003 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1095 |
|
0.002 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1097 |
|
0.001 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1098 |
|
0.004 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1099 |
|
0.001 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1100 |
|
0.001 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1102 |
|
0.002 |
SELECT * FROM productsize JOIN size s on s.id=sizeId WHERE productId=1104 |
