求MYSQL語(yǔ)句優(yōu)化

hmlymt

小弟不才。。涉及兩個(gè)表的操作。。于是寫(xiě)了如下冗長(zhǎng)的mysql語(yǔ)句，求高手幫忙優(yōu)化順便指點(diǎn)下。


SELECT id,partner_id,  
(SELECT TITLE FROM partner WHERE id=team.partner_id) as partner_title,  
(SELECT location FROM partner WHERE id=team.partner_id) as partner_location,  
(SELECT longlat FROM partner WHERE id=team.partner_id) as other,  
(SELECT address FROM partner WHERE id=team.partner_id) as partner_address,
(SELECT homepage FROM partner WHERE id=team.partner_id) as homepage,  
((team_price / market_price) *10) as ddd,sort_order,
title, userreview, product,now_number,group_id, FROM_UNIXTIME(expire_time) as expire_time, FROM_UNIXTIME( begin_time) AS begin_time, FROM_UNIXTIME(end_time) AS end_time,
team_price,summary ,market_price,image,summary,notice,detail FROM team  
WHERE id=@id  

小版主殺手

能執(zhí)行嗎？explain一下 看下效果，是否要索引優(yōu)化

haha8277

(SELECT TITLE FROM partner WHERE id=team.partner_id) as partner_title,  
(SELECT location FROM partner WHERE id=team.partner_id) as partner_location,  
(SELECT longlat FROM partner WHERE id=team.partner_id) as other,  
(SELECT address FROM partner WHERE id=team.partner_id) as partner_address,
(SELECT homepage FROM partner WHERE id=team.partner_id) as homepage,

partner這個(gè)庫(kù)大么，小這么來(lái)行，大的話用聯(lián)合查詢啊 ，最煩這么長(zhǎng)的語(yǔ)句 哈哈

方兆國(guó)

你的數(shù)據(jù)表的布局和你的目的貼出來(lái)可能大家有些針對(duì)性