SELECT x.title as title,x.esfprice as esfprice,a.corder as esfshi,b.corder as esfting,c.corder as esfwei,d.corder as esfchu,f.corder as esfyangtai,x.esfshijia as esfshijia,x.esftingjia as esftingjia,x.esfweijia as esfweijia,x.esfmianji as esfmianji,x.floor as floor,x.userid as userid,x.totalfloor as totalfloor,x.yezhuname as yezhuname,x.yezhuphone as yezhuphone,g.name as zhuangxiuname,h.name as chaoxiangname,x.xiaoquid as xiaoquid,x.dianti as dianti,x.fyteseid as fyteseid,x.yongtu as yongtu,x.cityid as cityid,x.bz as bz,x.countyid as countyid,x.pianquid as pianquid FROM `zf` `x` INNER JOIN `esffenlei` `a` ON `x`.`esfshi`=`a`.`id` INNER JOIN `esffenlei` `b` ON `x`.`esfting`=`b`.`id` INNER JOIN `esffenlei` `c` ON `x`.`esfwei`=`c`.`id` INNER JOIN `esffenlei` `d` ON `x`.`esfchu`=`d`.`id` INNER JOIN `esffenlei` `f` ON `x`.`esfyangtai`=`f`.`id` INNER JOIN `esffenlei` `g` ON `x`.`zhuangxiu`=`g`.`id` INNER JOIN `esffenlei` `h` ON `x`.`chaoxiang`=`h`.`id` WHERE `x`.`id` = '421' [ RunTime:0.001217s ]
SHOW FULL COLUMNS FROM `xiaoqu` [ RunTime:0.001932s ]
SELECT x.xiaoquname as xiaoquname,x.age as age,b.name as cqnxname,x.totalhouses as totalhouses,x.wuyefei as wuyefei,x.totalchewei as totalchewei,x.cheweifei as cheweifei,x.id as id FROM `xiaoqu` `x` INNER JOIN `esffenlei` `b` ON `b`.`id`=`x`.`cqnx` WHERE `x`.`id` = '163' [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `user` [ RunTime:0.001528s ]
SELECT * FROM `user` WHERE `id` = 28 [ RunTime:0.000337s ]
SELECT COUNT(*) AS think_count FROM `user` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `area` [ RunTime:0.000835s ]
SELECT * FROM `area` WHERE `id` = 30 [ RunTime:0.000292s ]
SELECT * FROM `area` WHERE `id` = 227 [ RunTime:0.000275s ]
SELECT * FROM `area` WHERE `id` = 682 [ RunTime:0.000262s ]
SHOW FULL COLUMNS FROM `esfurl` [ RunTime:0.000770s ]
SELECT * FROM `esfurl` WHERE `esfid` = 421 AND `tpstatus` = 2 AND `ifshipin` = 0 AND `ifchanzheng` = 0 ORDER BY `id` ASC [ RunTime:0.000525s ]
SELECT COUNT(*) AS think_count FROM `esfurl` WHERE `esfid` = 421 AND `tpstatus` = 2 AND `ifshipin` = 0 AND `ifchanzheng` = 0 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000393s ]
SELECT * FROM `area` WHERE `fenlei` = 1 AND `remen` = 1 ORDER BY `id` ASC [ RunTime:0.000631s ]
SELECT b.imgurl as imgurl,b.ifshipin as ifshipin,x.id as id,d.xiaoquname as xiaoquname,x.esfprice as esfprice,x.esfmianji as esfmianji,x.title as title,a.name as countyname,c.name as pianquname FROM `zf` `x` INNER JOIN `area` `a` ON `x`.`countyid`=`a`.`id` INNER JOIN `area` `c` ON `x`.`pianquid`=`c`.`id` INNER JOIN `xiaoqu` `d` ON `x`.`xiaoquid`=`d`.`id` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 1 AND `ifshipin` = 0 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`countyid` = '227' AND `x`.`shstatus` = '2' AND `x`.`status` = '1' AND `x`.`zfleibie` = '1' AND `x`.`roleid` = '2' AND `x`.`id` <> '421' ORDER BY `x`.`update_time` DESC LIMIT 5 [ RunTime:0.001935s ]
