-
80%
本科院校毕业
-
30天
严格岗前培训
-
98%
服务满意度
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-08-08 16:02:23 HTTP/1.1 GET : https://xdlive.com/news.html
- 运行时间 : 1.346756s [ 吞吐率:0.74req/s ] 内存消耗:6,214.99kb 文件加载:136
- 查询信息 : 16 queries 0 writes
- 缓存信息 : 11 reads,0 writes
- [ DB ] CONNECT:[ UseTime:0.089559s ] mysql:host=rm-bp17es4jtht1c0y60ao.mysql.rds.aliyuncs.com;dbname=bt;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.059954s ]
- [ SQL ] SELECT `id`,`name`,`domain`,`seo_title`,`seo_keys`,`seo_desc` FROM `fang_city` WHERE `status` = 1 AND `pid` = 0 ORDER BY `ordid` ASC,`id` ASC LIMIT 1 [ RunTime:0.059697s ]
- [ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.059997s ]
- [ SQL ] SELECT * FROM `fang_nav` WHERE `status` = 1 AND `pos` = 1 AND `pid` = 0 ORDER BY `ordid` ASC [ RunTime:0.059953s ]
- [ SQL ] SHOW COLUMNS FROM `fang_article` [ RunTime:0.059883s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_article` WHERE ( `status` = 1 AND `city` IN (0,244) AND `cate_id` NOT IN (7,9) ) AND `fang_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.062168s ]
- [ SQL ] SELECT * FROM `fang_article` WHERE ( `status` = 1 AND `city` IN (0,244) AND `cate_id` NOT IN (7,9) ) AND `fang_article`.`delete_time` IS NULL ORDER BY `ordid` ASC,`hits` DESC,`update_time` DESC LIMIT 0,10 [ RunTime:0.209965s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_article` WHERE ( `status` = 1 AND `city` IN (0,244) AND `cate_id` NOT IN (7,9) ) AND `fang_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.062260s ]
- [ SQL ] SELECT * FROM `fang_article` WHERE ( `status` = 1 AND `city` IN (0,244) AND `cate_id` NOT IN (7,9) ) AND `fang_article`.`delete_time` IS NULL ORDER BY `ordid` ASC,`hits` DESC,`update_time` DESC LIMIT 0,10 [ RunTime:0.151134s ]
- [ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.059884s ]
- [ SQL ] SELECT `h`.`id`,`h`.`is_discount`,`h`.`discount`,`h`.`img`,`h`.`title`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`city`,`h`.`address`,`h`.`nearby`,`h`.`area_addr`,`s`.`min_type`,`s`.`max_type`,`s`.`min_acreage`,`s`.`max_acreage`,`s`.`min_price`,`s`.`max_price` FROM `fang_house` `h` LEFT JOIN `fang_position` `p` ON `p`.`house_id`=`h`.`id` LEFT JOIN `fang_house_search` `s` ON `s`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '13' AND `h`.`status` = '1' AND `p`.`model` = 'house' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') ORDER BY `p`.`ordid` ASC,`h`.`ordid` ASC,`h`.`id` DESC LIMIT 5 [ RunTime:0.060750s ]
- [ SQL ] SHOW COLUMNS FROM `fang_house_type` [ RunTime:0.059835s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1178 AND `status` = 1 GROUP BY `room` [ RunTime:0.059541s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1058 AND `status` = 1 GROUP BY `room` [ RunTime:0.059659s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1030 AND `status` = 1 GROUP BY `room` [ RunTime:0.059557s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1022 AND `status` = 1 GROUP BY `room` [ RunTime:0.059811s ]

1.347606s