亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: 求MYSQL語句優(yōu)化 [打印本頁]

作者: hmlymt 時(shí)間: 2011-12-23 14:04
標(biāo)題: 求MYSQL語句優(yōu)化
小弟不才。。涉及兩個(gè)表的操作。。于是寫了如下冗長的mysql語句，求高手幫忙優(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

作者: 小版主殺手 時(shí)間: 2011-12-23 16:50
能執(zhí)行嗎？explain一下看下效果，是否要索引優(yōu)化

作者: haha8277 時(shí)間: 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這個(gè)庫大么，小這么來行，大的話用聯(lián)合查詢啊，最煩這么長的語句哈哈

作者: kerlion 時(shí)間: 2012-02-13 16:28
提示: 作者被禁止或刪除內(nèi)容自動(dòng)屏蔽

作者: kerlion 時(shí)間: 2012-02-13 16:30
提示: 作者被禁止或刪除內(nèi)容自動(dòng)屏蔽

作者: 方兆國 時(shí)間: 2012-03-19 17:05
你的數(shù)據(jù)表的布局和你的目的貼出來可能大家有些針對性

歡迎光臨 Chinaunix (http://72891.cn/)