SELECT
f.appName,
f.projectName,
f.appId AS id,
f.projectId,
DATE_FORMAT(d.create_date, "%Y-%m-%d") AS createDate
FROM
device d
LEFT JOIN (
SELECT DISTINCT
projects_has_apps.partner_project_id AS projectId,
app.id AS appId,
app.app_name AS appName,
partner_project.project_name AS projectName
FROM
projects_has_apps,
partner_project,
partner,
partner_has_partner_project,
app
WHERE
partner_project.id = projects_has_apps.partner_project_id
AND projects_has_apps.app_id = app.id
AND partner.id = partner_has_partner_project.partner_id
AND partner_has_partner_project.partner_project_id = partner_project.id
AND partner.id = 1
AND projects_has_apps.app_id = app.id
) f ON d.project_name = f.projectName这句sql的性能好差 请大神帮忙优化一下 刚刚接触这方便不知道怎么优化
f.appName,
f.projectName,
f.appId AS id,
f.projectId,
DATE_FORMAT(d.create_date, "%Y-%m-%d") AS createDate
FROM
device d
LEFT JOIN (
SELECT DISTINCT
projects_has_apps.partner_project_id AS projectId,
app.id AS appId,
app.app_name AS appName,
partner_project.project_name AS projectName
FROM
projects_has_apps,
partner_project,
partner,
partner_has_partner_project,
app
WHERE
partner_project.id = projects_has_apps.partner_project_id
AND projects_has_apps.app_id = app.id
AND partner.id = partner_has_partner_project.partner_id
AND partner_has_partner_project.partner_project_id = partner_project.id
AND partner.id = 1
AND projects_has_apps.app_id = app.id
) f ON d.project_name = f.projectName这句sql的性能好差 请大神帮忙优化一下 刚刚接触这方便不知道怎么优化
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货