0.63 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 18 ORDER BY `dr_1_xl`.`displayorder` DESC LIMIT 30 |
0.69 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.84 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.76 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.79 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.84 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.83 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.56 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.21 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.67 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.91 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.71 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.91 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.78 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.92 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.66 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.61 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.46 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.92 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.79 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.72 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.85 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.72 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.75 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.99 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.72 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.62 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.58 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.63 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.66 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.67 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.78 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.95 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.83 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.86 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.77 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.93 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
4.93 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.27 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.19 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.23 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.5 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.48 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
2.22 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.37 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.44 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.11 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
31.25 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.71 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.56 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.47 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
22.01 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.54 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.99 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.09 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
34.44 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() |
9.41 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.59 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 |
8.6 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 |
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() LIMIT 18 |
8.72 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 |
3.65 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.95 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (46,34,35,36) ORDER BY RAND() LIMIT 12 |
2.12 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (47,37,38,40) ORDER BY RAND() LIMIT 12 |
3.82 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (45,29,30,31,32,33) ORDER BY RAND() LIMIT 12 |
2.07 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (49,50,51,52) ORDER BY RAND() LIMIT 12 |
2.41 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (44,25,26,27,28) ORDER BY RAND() LIMIT 12 |
1.15 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`catid` = 17 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 12 |