基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-02-04 21:28:57 HTTP/1.1 GET : http://www.baichilou.cn/index/qtesf?city=nj&pianquid=306
- 运行时间 : 0.098656s [ 吞吐率：10.14req/s ] 内存消耗：4,925.85kb 文件加载：147
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=1a4676e07171e60a10c6fcd0bdb7b024
- CONNECT:[ UseTime:0.000497s ] mysql:host=127.0.0.1;port=3306;dbname=tp8;charset=utf8
- SHOW FULL COLUMNS FROM `area` [ RunTime:0.000918s ]
- SELECT * FROM `area` WHERE `url` = 'nj' [ RunTime:0.000530s ]
- SELECT * FROM `area` WHERE `id` = 30 [ RunTime:0.000330s ]
- SELECT * FROM `area` WHERE `pid` = 30 ORDER BY `corder` ASC [ RunTime:0.000465s ]
- SELECT * FROM `area` WHERE `fenlei` = 1 AND `remen` = 1 ORDER BY `corder` ASC [ RunTime:0.000445s ]
- SHOW FULL COLUMNS FROM `ditie` [ RunTime:0.001602s ]
- SELECT * FROM `ditie` WHERE `city` = 30 AND `pid` = 1 ORDER BY `corder` ASC [ RunTime:0.000373s ]
- SHOW FULL COLUMNS FROM `xqfenlei` [ RunTime:0.000696s ]
- SELECT * FROM `xqfenlei` WHERE `city` = 30 AND `status` = 0 ORDER BY `corder` ASC [ RunTime:0.000322s ]
- SHOW FULL COLUMNS FROM `esffenlei` [ RunTime:0.000733s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 2 ORDER BY `corder` ASC [ RunTime:0.000323s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 3 ORDER BY `corder` ASC [ RunTime:0.000311s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 5 ORDER BY `corder` ASC [ RunTime:0.000286s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 85 ORDER BY `corder` ASC [ RunTime:0.000346s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 4 ORDER BY `corder` ASC [ RunTime:0.000296s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 86 AND `id` IN (71,72,73,99,100) ORDER BY `corder` ASC [ RunTime:0.000363s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 6 ORDER BY `corder` ASC [ RunTime:0.000312s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 84 ORDER BY `corder` ASC [ RunTime:0.000318s ]
- SELECT * FROM `esffenlei` WHERE `pid` = 7 ORDER BY `corder` ASC [ RunTime:0.000303s ]
- SHOW FULL COLUMNS FROM `esfurl` [ RunTime:0.000761s ]
- SHOW FULL COLUMNS FROM `esf` [ RunTime:0.000690s ]
- SELECT i.name as chaoxiang,l.corder as esfshi,m.corder as esfting,n.corder as esfwei,x.title as title,b.imgurl as imgurl,b.ifshipin as ifshipin,x.esfdanjia as esfdanjia,x.esfprice as esfprice,x.esfshijia as esfshijia,x.esftingjia as esftingjia,x.esfweijia as esfweijia,x.esfmianji as esfmianji,a.xiaoquname as xiaoquname,x.id as id FROM `esf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`id` INNER JOIN `esffenlei` `i` ON `i`.`id`=`x`.`chaoxiang` INNER JOIN `esffenlei` `l` ON `l`.`id`=`x`.`esfshi` INNER JOIN `esffenlei` `m` ON `m`.`id`=`x`.`esfting` INNER JOIN `esffenlei` `n` ON `n`.`id`=`x`.`esfwei` LEFT JOIN ( SELECT * FROM `esfurl` WHERE `fenmian` = 1 AND `tpstatus` = 0 ) `b` ON `b`.`esfid`=`x`.`id` WHERE `x`.`cityid` = '30' AND `x`.`shstatus` = '2' AND `x`.`esfleibie` = '1' AND `x`.`roleid` = '2' ORDER BY `x`.`update_time` DESC LIMIT 0,20 [ RunTime:0.000920s ]
- SELECT COUNT(*) AS think_count FROM `esf` `x` INNER JOIN `xiaoqu` `a` ON `x`.`xiaoquid`=`a`.`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` = '30' AND `x`.`shstatus` = '2' AND `x`.`esfleibie` = '1' AND `x`.`roleid` = '2' LIMIT 1 [ RunTime:0.000672s ]
- SHOW FULL COLUMNS FROM `zixun` [ RunTime:0.001304s ]
- SELECT x.id as id,x.city as city,x.title as title,x.create_time as create_time FROM `zixun` `x` WHERE `x`.`city` = '30' AND `x`.`status` = '1' AND `x`.`shstatus` = '2' ORDER BY `x`.`corder` DESC LIMIT 20 [ RunTime:0.000335s ]
- SELECT COUNT(*) AS think_count FROM `zixun` `x` WHERE `x`.`city` = '30' AND `x`.`status` = '1' AND `x`.`shstatus` = '2' LIMIT 1 [ RunTime:0.000223s ]
0.106406s
