7.9 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 18 ORDER BY `dr_1_xl`.`displayorder` DESC LIMIT 30 |
5.66 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
6.13 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
3.18 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
14.27 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
14.05 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
20.78 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
12.22 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
9.32 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
16.79 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
11.53 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
11.42 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
10.2 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
2.54 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
21.82 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
16.73 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
16.03 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
6.3 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
11.77 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
4.72 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
18.11 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.44 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.41 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.36 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.46 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.31 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.28 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.3 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.28 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.28 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.4 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.34 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.34 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.48 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.35 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.47 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.46 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.46 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.46 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.33 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.47 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.01 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.45 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.44 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.72 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.48 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.87 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.49 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.41 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.4 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.35 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.29 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
7.91 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (1,18,43,19,20,21,22,23,24,44,25,26,27,28,45,29,30,31,32,33,46,34,35,36,47,37,38,40,48,39,41,42,49,50,51,52) ORDER BY RAND() |
4.5 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (1,18,43,19,20,21,22,23,24,44,25,26,27,28,45,29,30,31,32,33,46,34,35,36,47,37,38,40,48,39,41,42,49,50,51,52) ORDER BY RAND() LIMIT 12 |
2.19 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (1,18,43,19,20,21,22,23,24,44,25,26,27,28,45,29,30,31,32,33,46,34,35,36,47,37,38,40,48,39,41,42,49,50,51,52) ORDER BY `dr_1_xl`.`updatetime` DESC LIMIT 8 |
4.19 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (1,18,43,19,20,21,22,23,24,44,25,26,27,28,45,29,30,31,32,33,46,34,35,36,47,37,38,40,48,39,41,42,49,50,51,52) ORDER BY RAND() LIMIT 2 |
4.21 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (1,18,43,19,20,21,22,23,24,44,25,26,27,28,45,29,30,31,32,33,46,34,35,36,47,37,38,40,48,39,41,42,49,50,51,52) ORDER BY RAND() LIMIT 18 |
4.18 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (1,18,43,19,20,21,22,23,24,44,25,26,27,28,45,29,30,31,32,33,46,34,35,36,47,37,38,40,48,39,41,42,49,50,51,52) ORDER BY RAND() LIMIT 11 |
1.5 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (43,19,20,21,22,23,24) ORDER BY RAND() LIMIT 12 |
1 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (46,34,35,36) ORDER BY RAND() LIMIT 12 |
1.2 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (47,37,38,40) ORDER BY RAND() LIMIT 12 |
1.13 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (45,29,30,31,32,33) ORDER BY RAND() LIMIT 12 |
1.03 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (49,50,51,52) ORDER BY RAND() LIMIT 12 |
1.45 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (44,25,26,27,28) ORDER BY RAND() LIMIT 12 |
0.51 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`catid` = 17 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 12 |