-
80%
本科院校毕业
-
30天
严格岗前培训
-
98%
服务满意度
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-08-08 15:51:09 HTTP/1.1 GET : https://xdlive.com/loupan/d3_g5.html
- 运行时间 : 1.022701s [ 吞吐率:0.98req/s ] 内存消耗:6,072.54kb 文件加载:135
- 查询信息 : 15 queries 0 writes
- 缓存信息 : 22 reads,0 writes
- [ DB ] CONNECT:[ UseTime:0.087031s ] mysql:host=rm-bp17es4jtht1c0y60ao.mysql.rds.aliyuncs.com;dbname=bt;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.058712s ]
- [ 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.058387s ]
- [ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.058951s ]
- [ SQL ] SELECT * FROM `fang_nav` WHERE `status` = 1 AND `pos` = 1 AND `pid` = 0 ORDER BY `ordid` ASC [ RunTime:0.058234s ]
- [ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.058538s ]
- [ 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`.`code` = '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.058696s ]
- [ 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`,`h`.`update_time`,`h`.`create_time`,`h`.`ceng`,`h`.`xing`,`h`.`mian`,`h`.`chao`,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`.`code` = '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.058969s ]
- [ SQL ] SHOW COLUMNS FROM `fang_metro` [ RunTime:0.058169s ]
- [ SQL ] SELECT * FROM `fang_metro` WHERE `status` = 1 AND `city` = 244 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.057890s ]
- [ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.058246s ]
- [ 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.058663s ]
- [ 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.059138s ]
- [ 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.059208s ]
- [ 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.059314s ]
- [ 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.059430s ]

1.023567s