- 二手房
- 租房
- 新房
- 小区
- 问答
- 资讯
- 集市
- 经纪人
- 经纪公司
- 每周一房
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-02-04 10:16:59 HTTP/2.0 GET : https://baichilou.cn/
- 运行时间 : 0.094451s [ 吞吐率：10.59req/s ] 内存消耗：4,565.15kb 文件加载：147
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=e41b3d61dfea4bba0c1e154d75922741
- CONNECT:[ UseTime:0.000484s ] mysql:host=127.0.0.1;port=3306;dbname=tp8;charset=utf8
- SHOW FULL COLUMNS FROM `area` [ RunTime:0.000869s ]
- SELECT * FROM `area` WHERE `url` = 'suzhou' [ RunTime:0.000620s ]
- SHOW FULL COLUMNS FROM `esfurl` [ RunTime:0.000810s ]
- SHOW FULL COLUMNS FROM `esf` [ RunTime:0.000856s ]
- SELECT i.name as chaoxiang,x.title as title,b.imgurl as imgurl,b.ifshipin as ifshipin,x.esfdanjia as esfdanjia,x.esfprice as esfprice,x.esfmianji as esfmianji,a.xiaoquname as xiaoquname,c.name as countyname,d.name as pianquname,x.esfshi as esfshi,x.esfting as esfting,x.esfshijia as esfshijia,x.esftingjia as esftingjia,x.id as id FROM `esf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`id` INNER JOIN `area` `c` ON `x`.`countyid`=`c`.`id` INNER JOIN `area` `d` ON `x`.`pianquid`=`d`.`id` INNER JOIN `esffenlei` `i` ON `i`.`id`=`x`.`chaoxiang` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 0 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '34' AND `x`.`shstatus` = '2' AND `x`.`esfleibie` = '1' AND `x`.`roleid` = '2' ORDER BY `x`.`update_time` DESC LIMIT 4 [ RunTime:0.001145s ]
- SELECT COUNT(*) AS think_count FROM `esf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`id` INNER JOIN `area` `c` ON `x`.`countyid`=`c`.`id` INNER JOIN `area` `d` ON `x`.`pianquid`=`d`.`id` INNER JOIN `esffenlei` `i` ON `i`.`id`=`x`.`chaoxiang` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 0 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '34' AND `x`.`shstatus` = '2' AND `x`.`esfleibie` = '1' AND `x`.`roleid` = '2' LIMIT 1 [ RunTime:0.000894s ]
- SHOW FULL COLUMNS FROM `zf` [ RunTime:0.000814s ]
- SELECT i.name as chaoxiang,x.title as title,b.imgurl as imgurl,b.ifshipin as ifshipin,x.esfprice as esfprice,x.esfmianji as esfmianji,a.xiaoquname as xiaoquname,c.name as countyname,d.name as pianquname,x.esfshi as esfshi,x.esfting as esfting,x.esfshijia as esfshijia,x.esftingjia as esftingjia,x.id as id FROM `zf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`id` INNER JOIN `area` `c` ON `x`.`countyid`=`c`.`id` INNER JOIN `area` `d` ON `x`.`pianquid`=`d`.`id` INNER JOIN `esffenlei` `i` ON `i`.`id`=`x`.`chaoxiang` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 1 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '34' AND `x`.`shstatus` = '2' AND `x`.`zfleibie` = '1' AND `x`.`roleid` = '2' ORDER BY `x`.`update_time` DESC LIMIT 4 [ RunTime:0.001002s ]
- SELECT COUNT(*) AS think_count FROM `zf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`id` INNER JOIN `area` `c` ON `x`.`countyid`=`c`.`id` INNER JOIN `area` `d` ON `x`.`pianquid`=`d`.`id` INNER JOIN `esffenlei` `i` ON `i`.`id`=`x`.`chaoxiang` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 1 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '34' AND `x`.`shstatus` = '2' AND `x`.`zfleibie` = '1' AND `x`.`roleid` = '2' LIMIT 1 [ RunTime:0.000860s ]
- SHOW FULL COLUMNS FROM `xf` [ RunTime:0.000793s ]
- SELECT i.name as chaoxiang,d.name as countyname,c.name as pianquname,x.title as title,b.imgurl as imgurl,b.ifshipin as ifshipin,x.esfprice as esfprice,x.xfzprice as xfzprice,x.esfmianji as esfmianji,a.xiaoquname as xiaoquname,x.id as id,x.address as address,x.onsale as onsale FROM `xf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`id` INNER JOIN `esffenlei` `i` ON `i`.`id`=`x`.`chaoxiang` INNER JOIN `area` `d` ON `x`.`countyid`=`d`.`id` INNER JOIN `area` `c` ON `x`.`pianquid`=`c`.`id` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 3 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '34' AND `x`.`shstatus` = '2' ORDER BY `x`.`update_time` DESC LIMIT 4 [ RunTime:0.000920s ]
- SELECT COUNT(*) AS think_count FROM `xf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`id` INNER JOIN `esffenlei` `i` ON `i`.`id`=`x`.`chaoxiang` INNER JOIN `area` `d` ON `x`.`countyid`=`d`.`id` INNER JOIN `area` `c` ON `x`.`pianquid`=`c`.`id` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 3 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '34' AND `x`.`shstatus` = '2' LIMIT 1 [ RunTime:0.000850s ]
- SELECT * FROM `area` WHERE `esflb` = 1 ORDER BY `corder` ASC [ RunTime:0.000353s ]
- SELECT * FROM `area` WHERE `zflb` = 1 ORDER BY `corder` ASC [ RunTime:0.000324s ]
- SELECT * FROM `area` WHERE `xflb` = 1 ORDER BY `corder` ASC [ RunTime:0.000345s ]
- SHOW FULL COLUMNS FROM `yqlj` [ RunTime:0.000618s ]
- SELECT * FROM `yqlj` WHERE `city` = 34 ORDER BY `corder` ASC [ RunTime:0.000267s ]
- SELECT COUNT(*) AS think_count FROM `yqlj` WHERE `city` = 34 LIMIT 1 [ RunTime:0.000203s ]
- SELECT * FROM `area` WHERE `fenlei` = 1 AND `remen` = 1 ORDER BY `corder` ASC [ RunTime:0.000383s ]
- SELECT * FROM `esfurl` WHERE `esfid` = 34 AND `tpstatus` = 9 ORDER BY `id` ASC [ RunTime:0.000331s ]
- SELECT COUNT(*) AS think_count FROM `esfurl` WHERE `esfid` = 34 AND `tpstatus` = 9 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000325s ]
0.103046s
