EXPLAIN? EXTENDED

1先執行 EXPLAIN? EXTENDED

2 show warnings；

EXPLAIN EXTENDED

SELECT*FROM

`receivable_application_relation` d

WHERE d.`application_id` IN

(SELECT

id

FROM

application

WHERE application_code IN ('ZYHT20190305192721001','ZYHT20190309152839001','ZYHT20190309152904001'));

SHOW WARNINGS;

查看優化后最終執行的sql

In 并不是走的子查詢 而是 join ，這個是 從上面的畫紅線的地方copy 出來的

SELECT

`cf_receivables_financing`.`d`.`id` AS `id`,

`cf_receivables_financing`.`d`.`application_id` AS `application_id`,

`cf_receivables_financing`.`d`.`receivable_id` AS `receivable_id`,

`cf_receivables_financing`.`d`.`update_time` AS `update_time`,

`cf_receivables_financing`.`d`.`create_time` AS `create_time`,

`cf_receivables_financing`.`d`.`deleted` AS `deleted`

FROM

`cf_receivables_financing`.`application`

JOIN `cf_receivables_financing`.`receivable_application_relation` `d`

WHERE (

(

`cf_receivables_financing`.`d`.`application_id`=`cf_receivables_financing`.`application`.`id`

)

AND (

`cf_receivables_financing`.`application`.`application_code` IN ('ZYHT20190305192721001','ZYHT20190309152839001','ZYHT20190309152904001')

)

)

EXPLAIN EXTENDED

SELECT

d.*FROM

`receivable_application_relation` d

INNER JOIN application a

ON d.`application_id`=a.id

WHERE a.application_code IN ('ZYHT20190305192721001','ZYHT20190309152839001','ZYHT20190309152904001');

查看優化后的sql

SELECT

`cf_receivables_financing`.`d`.`id` AS `id`,

`cf_receivables_financing`.`d`.`application_id` AS `application_id`,

`cf_receivables_financing`.`d`.`receivable_id` AS `receivable_id`,

`cf_receivables_financing`.`d`.`update_time` AS `update_time`,

`cf_receivables_financing`.`d`.`create_time` AS `create_time`,

`cf_receivables_financing`.`d`.`deleted` AS `deleted`

FROM

`cf_receivables_financing`.`receivable_application_relation` `d`

JOIN `cf_receivables_financing`.`application` `a`

WHERE (

(

`cf_receivables_financing`.`d`.`application_id`=`cf_receivables_financing`.`a`.`id`

)

AND (

`cf_receivables_financing`.`a`.`application_code` IN ('ZYHT20190305192721001','ZYHT20190309152839001','ZYHT20190309152904001')

)

);

總結

以上是生活随笔為你收集整理的mysql查看优化后的语句_Mysql查看优化后的SQL 语句的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。