0.37 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 18 ORDER BY `dr_1_xl`.`displayorder` DESC LIMIT 30 |
0.36 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.37 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
13.38 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
5.21 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.75 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.46 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.27 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.56 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.59 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.32 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.37 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.29 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.34 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.23 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.28 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.1 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.4 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.27 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.31 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.32 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.3 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.32 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.33 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.29 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.3 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.23 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.24 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.24 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.28 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.3 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.44 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.31 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.31 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.42 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.32 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.29 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.42 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.11 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.68 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.45 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.43 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.7 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.57 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.61 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.4 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.51 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.3 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.45 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
12.43 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() |
6.26 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.02 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 |
3.96 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 |
3.95 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 |
3.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() LIMIT 11 |
1.46 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (43,19,20,21,22,23,24) ORDER BY RAND() LIMIT 12 |
0.81 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (46,34,35,36) ORDER BY RAND() LIMIT 12 |
0.78 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (47,37,38,40) ORDER BY RAND() LIMIT 12 |
0.74 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (45,29,30,31,32,33) ORDER BY RAND() LIMIT 12 |
11.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (49,50,51,52) ORDER BY RAND() LIMIT 12 |
1.1 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (44,25,26,27,28) ORDER BY RAND() LIMIT 12 |
11.15 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`catid` = 17 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 12 |