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.jjrid as jjrid,x.totalfloor as totalfloor,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.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` = '345' [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `xiaoqu` [ RunTime:0.000697s ]
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` = '5' [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `jjr` [ RunTime:0.001494s ]
SELECT * FROM `jjr` WHERE `id` = 1 [ RunTime:0.000297s ]
SELECT COUNT(*) AS think_count FROM `jjr` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000183s ]
SHOW FULL COLUMNS FROM `area` [ RunTime:0.000549s ]
SELECT * FROM `area` WHERE `id` = 34 [ RunTime:0.000225s ]
SELECT * FROM `area` WHERE `id` = 292 [ RunTime:0.000218s ]
SELECT * FROM `area` WHERE `id` = 310 [ RunTime:0.000218s ]
SHOW FULL COLUMNS FROM `esfurl` [ RunTime:0.000723s ]
SELECT * FROM `esfurl` WHERE `esfid` = 345 AND `tpstatus` = 1 ORDER BY `id` ASC [ RunTime:0.000299s ]
SELECT COUNT(*) AS think_count FROM `esfurl` WHERE `esfid` = 345 AND `tpstatus` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000263s ]
SELECT * FROM `area` WHERE `fenlei` = 1 AND `remen` = 1 ORDER BY `id` ASC [ RunTime:0.000380s ]
