合肥
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-05-19 21:44:24 HTTP/1.1 GET : http://hf.615.cn/jjr/all-73-0.html
- 运行时间 : 0.154883s [ 吞吐率:6.46req/s ] 内存消耗:4,914.28kb 文件加载:132
- 查询信息 : 16 queries 0 writes
- 缓存信息 : 6 reads,1 writes
- [ LANG ] /newsite/2184/fangcms/615.cn/thinkphp/lang/zh-cn.php
- [ BIND ] 'home'
- [ BIND ] 'home'
- [ ROUTE ] array (
'rule' => 'jjr/<alias>-<tags>-<sort>',
'route' => 'Broker/index',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
'alias' => 'all',
'tags' => '73',
'sort' => '0',
),
)
- [ HEADER ] array (
'host' => 'hf.615.cn',
'accept-encoding' => 'gzip, br, zstd, deflate',
'cookie' => 'city_ids=think%3A%5B%22129%22%5D; city_info=%7B%22id%22%3A129%2C%22province_id%22%3A13%2C%22name%22%3A%22%E5%90%88%E8%82%A5%22%2C%22alias%22%3A%22hf%22%2C%22pid%22%3A0%2C%22spid%22%3Anull%2C%22ordid%22%3A53%2C%22status%22%3A1%2C%22seo_title%22%3A%22%22%2C%22seo_keys%22%3A%22%22%2C%22seo_desc%22%3A%22%22%2C%22img%22%3Anull%2C%22domain%22%3A%22hf%22%2C%22is_hot%22%3A0%2C%22is_default%22%3A0%2C%22is_index%22%3A0%2C%22lat%22%3A%22117.322834%22%2C%22lng%22%3A%2231.892133%22%2C%22data%22%3A%7B%22phone%22%3A%22%22%2C%22address%22%3A%22%22%2C%22online_consulting%22%3A%22%22%2C%22pc_js%22%3A%22%22%2C%22mobile_js%22%3A%22%22%7D%2C%22city_code%22%3Anull%2C%22hits%22%3A0%2C%22old_parentid%22%3A0%7D; city_id=129; PHPSESSID=bbo453vv3vfdan5bs8b5mivtb3',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept' => '*/*',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'alias' => 'all',
'tags' => '73',
'sort' => '0',
)
- [ DB ] INIT mysql
- [ VIEW ] /newsite/2184/fangcms/615.cn/application/home/view/broker/index.html [ array (
0 => 'userInfo',
1 => 'seo',
2 => 'menu',
3 => 'site',
4 => 'city_list',
5 => 'hot_city',
6 => 'city_data',
7 => 'az',
8 => 'city_info',
9 => 'controller',
10 => 'nav_controller',
11 => 'keyword',
12 => 'action',
13 => 'second_list',
14 => 'house_count',
15 => 'arr',
16 => 'tags',
) ]
- [ DB ] CONNECT:[ UseTime:0.000298s ] mysql:host=localhost;dbname=fcmslyw;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.007141s ]
- [ SQL ] SELECT * FROM `fang_city` WHERE `status` = 1 AND `domain` = 'hf' LIMIT 1 [ RunTime:0.000393s ]
- [ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.006490s ]
- [ SQL ] SELECT * FROM `fang_nav` WHERE `model` = 'Broker' LIMIT 1 [ RunTime:0.000226s ]
- [ SQL ] SELECT `spid` FROM `fang_city` WHERE `id` = 129 LIMIT 1 [ RunTime:0.000230s ]
- [ SQL ] SELECT `id` FROM `fang_city` WHERE `spid` LIKE '129|%' [ RunTime:0.000115s ]
- [ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.005422s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_house` WHERE `status` = 1 AND `broker_id` = 0 LIMIT 1 [ RunTime:0.000156s ]
- [ SQL ] SHOW COLUMNS FROM `fang_second_house` [ RunTime:0.005645s ]
- [ SQL ] SELECT * FROM `fang_second_house` WHERE `status` = 1 AND `rec_position` = 1 AND `broker_id` = 0 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.035287s ]
- [ SQL ] SHOW COLUMNS FROM `fang_rental` [ RunTime:0.004081s ]
- [ SQL ] SHOW COLUMNS FROM `fang_user` [ RunTime:0.003799s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_user` `u` INNER JOIN `fang_user_info` `d` ON `u`.`id`=`d`.`user_id` WHERE `u`.`status` = '1' AND `u`.`city` IN ('129','0') AND `u`.`model` <> '1' AND ( find_in_set(73,d.tags) ) LIMIT 1 [ RunTime:0.000486s ]
- [ SQL ] SELECT u.id,u.user_name,u.nick_name,u.mobile,u.cate_id,d.service_area,d.company,d.history_complate,d.tags,d.point,(FORMAT((d.point/5)*100,0)) as goods,( SELECT count(id) as second_total FROM `fang_second_house` WHERE `broker_id` = u.id AND `status` = 1 ) as second_total,( SELECT count(id) as second_total FROM `fang_rental` WHERE `broker_id` = u.id AND `status` = 1 ) as rental_total FROM `fang_user` `u` INNER JOIN `fang_user_info` `d` ON `u`.`id`=`d`.`user_id` WHERE `u`.`status` = '1' AND `u`.`city` IN ('129','0') AND `u`.`model` <> '1' AND ( find_in_set(73,d.tags) ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000406s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_user` `u` INNER JOIN `fang_user_info` `d` ON `u`.`id`=`d`.`user_id` WHERE `u`.`status` = '1' AND `u`.`city` IN ('129','0') AND `u`.`model` <> '1' AND ( find_in_set(73,d.tags) ) LIMIT 1 [ RunTime:0.000193s ]
- [ SQL ] SELECT * FROM `fang_city` WHERE `status` = 1 AND `pid` = 129 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.000151s ]
0.176236s