0.69 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 18 ORDER BY `dr_1_xl`.`displayorder` DESC LIMIT 30 |
0.62 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.62 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 19 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.65 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.71 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 20 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.65 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.79 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 21 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.53 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 22 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
1.04 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.77 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 23 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.68 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.68 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 24 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.65 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.74 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 25 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.59 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.59 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 26 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.26 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.83 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 27 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.61 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.64 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 28 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.67 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.66 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 29 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.64 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.69 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 30 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.57 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.61 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 31 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.56 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.56 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 32 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.59 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.59 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 33 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.69 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.68 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 34 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.7 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.78 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 35 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.63 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.76 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 36 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.65 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.76 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 37 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.7 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.8 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 38 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.67 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.72 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 40 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
1.21 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.78 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 39 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.65 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.69 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 41 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.88 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.77 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 42 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.84 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.82 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 50 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.63 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.66 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 51 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
0.51 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 1 |
0.52 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` = 52 ORDER BY `dr_1_xl`.`displayorder` ASC LIMIT 2,40 |
9.48 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() |
22.76 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 |
12.76 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.06 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.38 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.89 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.07 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.32 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (46,34,35,36) ORDER BY RAND() LIMIT 12 |
2.82 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (47,37,38,40) ORDER BY RAND() LIMIT 12 |
1.28 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (45,29,30,31,32,33) ORDER BY RAND() LIMIT 12 |
1.18 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (49,50,51,52) ORDER BY RAND() LIMIT 12 |
1.22 ms |
SELECT * FROM `dr_1_xl` WHERE `dr_1_xl`.`catid` IN (44,25,26,27,28) ORDER BY RAND() LIMIT 12 |
0.68 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`catid` = 17 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 12 |