0.99 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 18 ORDER BY `dr_1_xl`.`displayorder` DESC LIMIT 30 |
1.33 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.17 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.22 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.98 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.06 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.48 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.05 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.92 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.11 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.16 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.02 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.53 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.24 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.47 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.05 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.77 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.88 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.3 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.27 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.35 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.23 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.16 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.03 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.98 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.91 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.94 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.19 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.26 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.87 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.16 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.16 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.16 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.33 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.51 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.29 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.19 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.96 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.12 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.35 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.2 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.96 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.14 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.99 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.35 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.17 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.6 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.49 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.29 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.39 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.72 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.14 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.15 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.95 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.31 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
10.9 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() |
5.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 12 |
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 `dr_1_xl`.`updatetime` DESC LIMIT 8 |
5.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 2 |
5.7 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 |
5.67 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 |
2.86 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.65 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (46,34,35,36) ORDER BY RAND() LIMIT 12 |
1.74 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (47,37,38,40) ORDER BY RAND() LIMIT 12 |
1.79 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (45,29,30,31,32,33) ORDER BY RAND() LIMIT 12 |
1.79 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (49,50,51,52) ORDER BY RAND() LIMIT 12 |
1.71 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (44,25,26,27,28) ORDER BY RAND() LIMIT 12 |
1.12 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`catid` = 17 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 12 |