-
80%
本科院校毕业
-
30天
严格岗前培训
-
98%
服务满意度
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2021-12-05 04:13:22 HTTP/1.1 GET : https://xdlive.com/news.html
- 运行时间 : 0.089427s [ 吞吐率：11.18req/s ] 内存消耗：6,215.72kb 文件加载：138
- 查询信息 : 16 queries 0 writes
- 缓存信息 : 10 reads,1 writes
- [ LANG ] /www/wwwroot/xdlive/thinkphp/lang/zh-cn.php
- [ BIND ] 'home'
- [ ROUTE ] array (
'rule' => 'news',
'route' => 'News/index',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
)
- [ HEADER ] array (
'connection' => 'Keep-Alive',
'host' => 'xdlive.com',
'accept-encoding' => 'br,gzip',
'accept-language' => 'en-US,en;q=0.5',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'city' => '3',
)
- [ DB ] INIT mysql
- [ VIEW ] /www/wwwroot/xdlive/application/home/view/news/index.html [ array (
0 => 'userInfo',
1 => 'menu',
2 => 'seo',
3 => 'site',
4 => 'qq',
5 => 'controller',
6 => 'cityInfo',
7 => 'cur_url',
8 => 'city_all_child',
9 => 'top_nav_city',
10 => 'cityId',
11 => 'mobile_agent',
12 => 'custom_class',
13 => 'hots',
14 => 'house_id',
15 => 'list',
16 => 'cate',
17 => 'cate_id',
18 => 'houses',
) ]
- [ DB ] CONNECT:[ UseTime:0.000469s ] mysql:host=127.0.0.1;dbname=guide;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.001138s ]
- [ 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.000487s ]
- [ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.001009s ]
- [ SQL ] SELECT * FROM `fang_nav` WHERE `status` = 1 AND `pos` = 1 AND `pid` = 0 ORDER BY `ordid` ASC [ RunTime:0.000458s ]
- [ SQL ] SHOW COLUMNS FROM `fang_article` [ RunTime:0.001328s ]
- [ 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.009031s ]
- [ 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.008562s ]
- [ 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.007230s ]
- [ 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.007073s ]
- [ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.001135s ]
- [ 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.001132s ]
- [ SQL ] SHOW COLUMNS FROM `fang_house_type` [ RunTime:0.000976s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1178 AND `status` = 1 GROUP BY `room` [ RunTime:0.000320s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1058 AND `status` = 1 GROUP BY `room` [ RunTime:0.000340s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1030 AND `status` = 1 GROUP BY `room` [ RunTime:0.000324s ]
- [ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1022 AND `status` = 1 GROUP BY `room` [ RunTime:0.000308s ]
0.090234s
