SELECT sql_no_cache pk.pkname as pk_name,pk.id as pkid,pk.case,pk.endtime,pk.case_ctype, g.img, g.name, pker.*,pk.status status, IF( pker.def_score > pker.act_score, 1, 0 ) AS lose, IF( pker.def_score = pker.act_score, 1, 0 ) AS draw FROM ng_game_pker AS pker LEFT JOIN ng_game_pk AS pk ON pk.id = pker.pkid LEFT JOIN ng_game AS g ON pk.gid = g.gid WHERE (pker.act_uid = 1 OR pker.def_uid = 1) AND pk.type = 4 order by pker.pkid desc LIMIT 0, 10 ;

+--------------------+----------+
| Status             | Duration |
+--------------------+----------+
| starting           | 0.000182 |
| Opening tables     | 0.000017 |
| System lock        | 0.000006 |
| Table lock         | 0.000009 |
| init               | 0.000056 |
| optimizing         | 0.000018 |
| statistics         | 0.000065 |
| preparing          | 0.000024 |
| executing          | 0.000005 |
| Sorting result     | 0.161031 |
| Sending data       | 0.004265 |
| end                | 0.000007 |
| query end          | 0.000002 |
| freeing items      | 0.000314 |
| logging slow query | 0.000003 |
| cleaning up        | 0.000003 |
+--------------------+----------+

add INDEX (pkid);

+--------------------+----------+
| Status             | Duration |
+--------------------+----------+
| starting           | 0.000181 |
| Opening tables     | 0.000017 |
| System lock        | 0.000005 |
| Table lock         | 0.000010 |
| init               | 0.000055 |
| optimizing         | 0.000018 |
| statistics         | 0.000069 |
| preparing          | 0.000023 |
| executing          | 0.000004 |
| Sorting result     | 0.000006 |
| Sending data       | 0.285655 |
| end                | 0.000008 |
| query end          | 0.000003 |
| freeing items      | 0.000285 |
| logging slow query | 0.000003 |
| cleaning up        | 0.000003 |
+--------------------+----------+