阅读背景:

使用filesort查询的谷歌云SQL速度较慢

来源:互联网 
mysql> EXPLAIN SELECT * FROM `condominio_boleto` 
INNER JOIN `contrato_contrato` ON (`condominio_boleto`.`contrato_id` = `contrato_contrato`.`id`) 
INNER JOIN `cadastro_imovel` ON (`contrato_contrato`.`imovel_id` = `cadastro_imovel`.`id`) 
INNER JOIN `cadastro_pessoa` ON (`contrato_contrato`.`pessoa_id` = `cadastro_pessoa`.`id`) 
ORDER BY `condominio_boleto`.`id` DESC LIMIT 1;

+----+-------------+-------------------+--------+---------------------------------------------------------------+----------------------------+---------+------------------------------------+------+---------------------------------+
| id | select_type | table             | type   | possible_keys                                                 | key                        | key_len | ref                                | rows | Extra                           |
+----+-------------+-------------------+--------+---------------------------------------------------------------+----------------------------+---------+------------------------------------+------+---------------------------------+
|  1 | SIMPLE      | cadastro_imovel   | ALL    | PRIMARY                                                       | NULL                       | NULL    | NULL                               |  128 | Using temporary; Using filesort |
|  1 | SIMPLE      | contrato_contrato | ref    | PRIMARY,contrato_contrato_33999a20,contrato_contrato_8b5ebd9d | contrato_contrato_33999a20 | 4       | mydb.cadastro_imovel.id            |    1 |                                 |
|  1 | SIMPLE      | cadastro_pessoa   | eq_ref | PRIMARY                                                       | PRIMARY                    | 4       | mydb.contrato_contrato.pessoa_id   |    1 |                                 |
|  1 | SIMPLE      | condominio_boleto | ref    | condominio_boleto_91c8cd68                                    | condominio_boleto_91c8cd68 | 4       | mydb.contrato_contrato.id          |    9 |                                 |
+----+-------------+-------------------+--------+---------------------------------------------------------------+----------------------------+---------+------------------------------------+------+---------------------------------+
4 rows in set (0.00 sec)
mysql> EXPLAIN SELECT * FROM `condominio_boleto



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: