-
80%
本科院校毕业
-
30天
严格岗前培训
-
98%
服务满意度
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-01-27 19:59:55 HTTP/1.1 GET : https://xdlive.com/loupan/d3_g5.html
- 运行时间 : 0.061608s [ 吞吐率：16.23req/s ] 内存消耗：6,069.70kb 文件加载：137
- 查询信息 : 15 queries 0 writes
- 缓存信息 : 21 reads,1 writes
- [ LANG ] /www/wwwroot/xdlive/thinkphp/lang/zh-cn.php
- [ BIND ] 'home'
- [ ROUTE ] array (
'rule' => 'loupan/<param?>',
'route' => 'House/index',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
'param' => 'd3_g5',
),
)
- [ 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',
'param' => 'd3_g5',
)
- [ DB ] INIT mysql
- [ VIEW ] /www/wwwroot/xdlive/application/home/view/house/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 => 'action',
14 => 'param',
15 => 'search',
16 => 'metro',
17 => 'area',
18 => 'special',
19 => 'type',
20 => 'status',
21 => 'renovation',
22 => 'lists',
23 => 'pages',
24 => 'position',
25 => 'storage_open',
26 => 'interest',
27 => 'sides',
28 => 'sort',
) ]
- [ DB ] CONNECT:[ UseTime:0.000426s ] mysql:host=127.0.0.1;dbname=guide;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.001106s ]
- [ 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.000410s ]
- [ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.000939s ]
- [ SQL ] SELECT * FROM `fang_nav` WHERE `status` = 1 AND `pos` = 1 AND `pid` = 0 ORDER BY `ordid` ASC [ RunTime:0.000384s ]
- [ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.001022s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fang_house` `h` LEFT JOIN `fang_house_type` `t` ON `h`.`id`=`t`.`house_id` WHERE `h`.`status` = '1' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') AND `h`.`sale_status` = '5' AND `t`.`room` = '3' GROUP BY `h`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000721s ]
- [ SQL ] SELECT `h`.`id`,`h`.`title`,`h`.`video`,`h`.`img`,`h`.`sale_status`,`h`.`nearby`,`h`.`city`,`h`.`address`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`area_addr`,MIN(t.room) AS min_type,MAX(t.room) AS max_type,MIN(t.acreage) AS min_acreage,MAX(t.acreage) AS max_acreage,MIN(t.price) AS min_price,MAX(t.price) AS max_price FROM `fang_house` `h` LEFT JOIN `fang_house_type` `t` ON `h`.`id`=`t`.`house_id` WHERE `h`.`status` = '1' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') AND `h`.`sale_status` = '5' AND `t`.`room` = '3' GROUP BY `h`.`id` ORDER BY `h`.`ordid` ASC,`h`.`id` DESC LIMIT 0,10 [ RunTime:0.000793s ]
- [ SQL ] SHOW COLUMNS FROM `fang_metro` [ RunTime:0.000773s ]
- [ SQL ] SELECT * FROM `fang_metro` WHERE `status` = 1 AND `city` = 244 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.000230s ]
- [ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.000789s ]
- [ SQL ] SELECT h.id,h.img,h.title,(case h.price when 0 then '待定' else h.price end) as price,h.unit,h.city,h.area_addr,h.address FROM `fang_position` `p` INNER JOIN `fang_house` `h` ON `p`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '4' 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`.`id` DESC LIMIT 6 [ RunTime:0.001019s ]
- [ 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` = '5' 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.001032s ]
- [ 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` = '15' 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.001043s ]
- [ 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.000999s ]
- [ 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` = '14' 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.000997s ]
0.062419s
