0.4 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 1 |
2 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (3,302,303,304,305) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 1 |
0.79 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (2,319,320,323) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 4 |
0.27 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 5 |
4.27 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (7,34,378,35,36,37,39,40,41,42,43,45,46,47,48,49,65,108,110,192,193,194,195,196,198,199,242,269,270,271,272,276,277,278,279,330,332,333,334,335,336,338,341,347,348,351,352,353,354,358,361,362,363,364,365,366,367,370,372,377,379,380,383,385,389,390,395,397,398,400,401,402,404,408,452,453,454,455,461,462,463,464,477,487,44,200,345,349,350,357,359,360,387,394,415,450,451,468,469,470,471,472,473,474,475,476,478,479,480,481,482,486,488,489,490,491,492,493,494,495,496,497,498,501,502,503,504,505,506,507,508,510,511,513,514,515,516,517,518,610,612,613,603,604,605,606,607,611) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 1 |
3.28 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (7,34,378,35,36,37,39,40,41,42,43,45,46,47,48,49,65,108,110,192,193,194,195,196,198,199,242,269,270,271,272,276,277,278,279,330,332,333,334,335,336,338,341,347,348,351,352,353,354,358,361,362,363,364,365,366,367,370,372,377,379,380,383,385,389,390,395,397,398,400,401,402,404,408,452,453,454,455,461,462,463,464,477,487,44,200,345,349,350,357,359,360,387,394,415,450,451,468,469,470,471,472,473,474,475,476,478,479,480,481,482,486,488,489,490,491,492,493,494,495,496,497,498,501,502,503,504,505,506,507,508,510,511,513,514,515,516,517,518,610,612,613,603,604,605,606,607,611) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 4 |
1.04 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (19,20,21,51,52,67,68,76,77,203,204,280,281,282,283,284,285,310,311,312,313,314,315,322,325,326,339,662,667) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 1 |
9.75 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (19,20,21,51,52,67,68,76,77,203,204,280,281,282,283,284,285,310,311,312,313,314,315,322,325,326,339,662,667) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 4 |
0.33 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` = 12 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 5 |
1.57 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (3,302,303,304,305) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 1 |
7.22 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (3,302,303,304,305) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 15 |
1.29 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`thumb`<>'' AND `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (22,23,24) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 1 |
0.83 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` IN (22,23,24) ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 5 |
0.23 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 3 |
0.29 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 AND `dr_1_article`.`catid` = 678 ORDER BY `dr_1_article`.`updatetime` DESC LIMIT 3 |
0.35 ms |
SELECT * FROM `dr_1_article` WHERE `dr_1_article`.`status` = 9 ORDER BY `dr_1_article`.`hits` DESC LIMIT 5 |