基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-12-18 03:28:36 HTTP/1.1 GET : http://cz.baichilou.cn/index/qtmzyf/mzyfconsole?city=cz&xiaoquname=%E7%A6%8F%E6%98%9F%E6%96%B0%E5%9F%8E
- 运行时间 : 0.097463s [ 吞吐率：10.26req/s ] 内存消耗：4,809.21kb 文件加载：148
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=b0dd879a1dde3332779d2c180cbc79ad
- CONNECT:[ UseTime:0.000389s ] mysql:host=127.0.0.1;port=3306;dbname=tp8;charset=utf8
- SHOW FULL COLUMNS FROM `area` [ RunTime:0.001221s ]
- SELECT * FROM `area` WHERE `url` = 'cz' [ RunTime:0.000409s ]
- SELECT * FROM `area` WHERE `url` = 'cz' [ RunTime:0.000404s ]
- SHOW FULL COLUMNS FROM `esf` [ RunTime:0.001705s ]
- SELECT x.id as id,x.title as title,x.esfprice as esfprice,x.esfdanjia as esfdanjia,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,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 `esf` `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`.`cityid` = '33' AND `x`.`mzyf` = '1' AND `x`.`esfleibie` = '2' [ RunTime:0.000492s ]
- SELECT COUNT(*) AS think_count FROM `esf` `x` WHERE `x`.`cityid` = '33' AND `x`.`mzyf` = '1' AND `x`.`esfleibie` = '2' LIMIT 1 [ RunTime:0.000288s ]
- SELECT x.id as id,x.title as title,x.esfprice as esfprice,x.esfdanjia as esfdanjia,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,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 `esf` `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`.`cityid` = '33' AND `x`.`esfleibie` = '2' AND `x`.`shstatus` = '2' ORDER BY `x`.`create_time` DESC LIMIT 1 [ RunTime:0.000520s ]
- SELECT COUNT(*) AS think_count FROM `esf` `x` WHERE `x`.`cityid` = '33' AND `x`.`esfleibie` = '2' AND `x`.`shstatus` = '2' ORDER BY `x`.`create_time` DESC LIMIT 1 [ RunTime:0.000263s ]
- SELECT x.id as id,x.title as title,x.esfprice as esfprice,x.esfdanjia as esfdanjia,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,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 `esf` `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`.`cityid` = '34' AND `x`.`esfleibie` = '2' AND `x`.`shstatus` = '2' ORDER BY `x`.`create_time` DESC LIMIT 1 [ RunTime:0.000527s ]
- SHOW FULL COLUMNS FROM `xiaoqu` [ RunTime:0.001013s ]
- 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` = '2' [ RunTime:0.000276s ]
- SELECT * FROM `area` WHERE `id` = 292 [ RunTime:0.000270s ]
- SHOW FULL COLUMNS FROM `esfurl` [ RunTime:0.000661s ]
- SELECT * FROM `esfurl` WHERE `tpstatus` = 6 AND `esfid` = 497 ORDER BY `id` ASC [ RunTime:0.000438s ]
- SELECT COUNT(*) AS think_count FROM `esfurl` WHERE `tpstatus` = 6 AND `esfid` = 497 LIMIT 1 [ RunTime:0.000283s ]
- SHOW FULL COLUMNS FROM `user` [ RunTime:0.000698s ]
- SELECT * FROM `user` WHERE `id` = 27 [ RunTime:0.000262s ]
- SELECT * FROM `area` WHERE `fenlei` = 1 AND `remen` = 1 ORDER BY `id` ASC [ RunTime:0.000690s ]
- SHOW FULL COLUMNS FROM `zf` [ RunTime:0.000906s ]
- SELECT b.imgurl as imgurl,x.id as id,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` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 1 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '33' ORDER BY `x`.`update_time` DESC LIMIT 4 [ RunTime:0.000624s ]
- SHOW FULL COLUMNS FROM `wenda` [ RunTime:0.000715s ]
- SELECT x.corder as corder, x.pid as pid, x.id as id, b.xiaoquname as xiaoquname, a.name as name, x.tiwen as tiwen, x.create_time as create_time, x.update_time as update_time, (select count(*) from wenda d WHERE d.pid = x.id) as xcount FROM `wenda` `x` INNER JOIN `jjr` `a` ON `x`.`jjrid`=`a`.`id` INNER JOIN `xiaoqu` `b` ON `x`.`xqid`=`b`.`id` WHERE `pid` = 0 AND `x`.`yhleibie` = '1' AND `x`.`shstatus` = '2' AND `x`.`city` = '33' UNION ( ( SELECT x.corder as corder, x.pid as pid, x.id as id, b.xiaoquname as xiaoquname, a.name as name, x.tiwen as tiwen, x.create_time as create_time, x.update_time as update_time, (select count(*) from wenda d WHERE d.pid = x.id) as xcount FROM `wenda` `x` INNER JOIN `user` `a` ON `x`.`userid`=`a`.`id` INNER JOIN `xiaoqu` `b` ON `x`.`xqid`=`b`.`id` WHERE `pid` = 0 AND `x`.`yhleibie` = '2' AND `x`.`shstatus` = '2' AND `x`.`city` = '33' ) ) UNION ( ( SELECT x.corder as corder, x.pid as pid, x.id as id, b.xiaoquname as xiaoquname, x.yhleibie as name, x.tiwen as tiwen, x.create_time as create_time, x.update_time as update_time, (select count(*) from wenda d WHERE d.pid = x.id) as xcount FROM `wenda` `x` INNER JOIN `xiaoqu` `b` ON `x`.`xqid`=`b`.`id` WHERE `pid` = 0 AND `x`.`yhleibie` = '0' AND `x`.`shstatus` = '2' AND `x`.`city` = '33' ) ) ORDER BY `id` DESC LIMIT 4 [ RunTime:0.001284s ]
- SELECT COUNT(*) AS think_count FROM `wenda` `x` WHERE `pid` = 0 AND `x`.`shstatus` = '2' AND `x`.`city` = '33' LIMIT 1 [ RunTime:0.000242s ]
0.105515s
