slow SQL

最新推荐文章于 2025-06-23 11:09:04 发布

最新推荐文章于 2025-06-23 11:09:04 发布 · 166 阅读

文章标签：

#SQL #MySQL

SQL 专栏收录该内容

84 篇文章

订阅专栏

mysql> select * from wanyouxi where youxitag='bird' ORDER BY credits desc limit 1;
+-------+------+--------+------------+---------+------------+------+-----+------+
| id    | uid  | gameid | youxitag| credits | dateline   | type | sid | wins |
+-------+------+--------+------------+---------+------------+------+-----+------+
| 49578 | 1155 |      0 | bird|   43830 | 1221623720 |    0 |   6 |    0 | 
+-------+------+--------+------------+---------+------------+------+-----+------+
1 row in set (0.37 sec)

mysql> SELECT * from wanyouxi where youxijifen= (SELECT MAX(youxijifen) FROM cdb_playsgame where youxitag='bird') and youxitag='bird';
+-------+------+--------+------------+---------+------------+------+-----+------+
| id    | uid  | gameid | youxitag| credits | dateline   | type | sid | wins |
+-------+------+--------+------------+---------+------------+------+-----+------+
| 49578 | 1155 |      0 | bird|   43830 | 1221623720 |    0 |   6 |    0 | 
+-------+------+--------+------------+---------+------------+------+-----+------+
1 row in set (0.30 sec)