hmlymt 发表于 2011-12-23 14:04

求MYSQL语句优化

小弟不才。。涉及两个表的操作。。于是写了如下冗长的mysql语句，求高手帮忙优化顺便指点下。


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

小版主杀手 发表于 2011-12-23 16:50

能执行吗？explain一下 看下效果，是否要索引优化

haha8277 发表于 2012-01-30 11:12

(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这个库大么，小这么来行，大的话用联合查询啊 ，最烦这么长的语句 哈哈

kerlion 发表于 2012-02-13 16:28

kerlion 发表于 2012-02-13 16:30

方兆国 发表于 2012-03-19 17:05

你的数据表的布局和你的目的贴出来可能大家有些针对性
页: [1]
查看完整版本: 求MYSQL语句优化