价格：
单价
总价
户型：
不限
一居室
二居室
三居室
四居室
五居室
六居室以上
您已选择：
大兴区
瀛海
共有1个符合要求的北京楼盘
大兴区旧忠路合生me悦
户型：2室/3室/3室/4室
建面：72-120㎡
开盘时间：2021-07-25
交通便利
舒适安静
没有噪声
6.5万元/㎡（均价）
总价468-780（万/套）
咨询
请联系您的专属经纪人进行咨询
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-12-23 14:20:56 HTTP/2.0 GET : https://fapaifangchan.com/index/NewFloor/newfloor.html?district=110115&trade_id=260
- 运行时间 : 0.157969s [ 吞吐率：6.33req/s ] 内存消耗：5,154.29kb 文件加载：179
- 查询信息 : 88 queries
- 缓存信息 : 1 reads,0 writes
- 会话信息 : SESSION_ID=5b6c6f9e2847f16bb0349a43c6f39329
- CONNECT:[ UseTime:0.000732s ] mysql:host=127.0.0.1;port=3306;dbname=fapaifangchan_co;charset=utf8mb4
- SHOW FULL COLUMNS FROM `cms_conf` [ RunTime:0.002041s ]
- SELECT `value`,`field` FROM `cms_conf` [ RunTime:0.000390s ]
- SHOW FULL COLUMNS FROM `cms_region` [ RunTime:0.001513s ]
- SELECT * FROM `cms_region` WHERE `type` = 3 AND `status` = 1 AND `pid` = 110100 ORDER BY `sort` DESC [ RunTime:0.000636s ]
- SHOW FULL COLUMNS FROM `cms_subway` [ RunTime:0.001380s ]
- SELECT * FROM `cms_subway` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000486s ]
- SELECT * FROM `cms_region` WHERE `type` = 3 AND `status` = 1 AND `pid` = 110100 AND `is_hot` = 1 ORDER BY `sort` DESC LIMIT 16 [ RunTime:0.000622s ]
- SHOW FULL COLUMNS FROM `cms_trade` [ RunTime:0.001439s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `is_hot` = 1 ORDER BY `sort` DESC LIMIT 16 [ RunTime:0.000763s ]
- SHOW FULL COLUMNS FROM `cms_region_trade` [ RunTime:0.001337s ]
- SELECT `region_id` FROM `cms_region_trade` WHERE `trade_id` = 1 LIMIT 1 [ RunTime:0.000403s ]
- SELECT `region_id` FROM `cms_region_trade` WHERE `trade_id` = 3 LIMIT 1 [ RunTime:0.000337s ]
- SELECT `region_id` FROM `cms_region_trade` WHERE `trade_id` = 8 LIMIT 1 [ RunTime:0.000323s ]
- SELECT `region_id` FROM `cms_region_trade` WHERE `trade_id` = 24 LIMIT 1 [ RunTime:0.000322s ]
- SELECT `region_id` FROM `cms_region_trade` WHERE `trade_id` = 33 LIMIT 1 [ RunTime:0.000308s ]
- SELECT `region_id` FROM `cms_region_trade` WHERE `trade_id` = 48 LIMIT 1 [ RunTime:0.000326s ]
- SELECT `region_id` FROM `cms_region_trade` WHERE `trade_id` = 51 LIMIT 1 [ RunTime:0.000307s ]
- SHOW FULL COLUMNS FROM `cms_community` [ RunTime:0.002139s ]
- SELECT * FROM `cms_community` WHERE `delete_time` = 0 AND `status` = 1 AND `is_hot` = 1 ORDER BY `sort` DESC LIMIT 16 [ RunTime:0.018504s ]
- SHOW FULL COLUMNS FROM `cms_new_floor` [ RunTime:0.002183s ]
- SELECT * FROM `cms_new_floor` WHERE `status` = 1 AND `is_hot` = 1 AND `is_delete` = 0 ORDER BY `sort` DESC LIMIT 16 [ RunTime:0.000762s ]
- SHOW FULL COLUMNS FROM `cms_nav` [ RunTime:0.001507s ]
- SELECT * FROM `cms_nav` WHERE `status` = 1 AND `position` = 1 ORDER BY `sort` ASC [ RunTime:0.000530s ]
- SELECT * FROM `cms_region` WHERE `pid` = 110100 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000506s ]
- SHOW FULL COLUMNS FROM `cms_foreclosure_room` [ RunTime:0.001364s ]
- SELECT `room`,`type`,`id` FROM `cms_foreclosure_room` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000424s ]
- SHOW FULL COLUMNS FROM `cms_third` [ RunTime:0.001280s ]
- SELECT `value` FROM `cms_third` WHERE `key` = 'amap_account' LIMIT 1 [ RunTime:0.000367s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_huxing` [ RunTime:0.001589s ]
- SELECT `floor_id` FROM `cms_new_floor_huxing` WHERE `status` = 1 [ RunTime:0.000449s ]
- SELECT `floor_id` FROM `cms_new_floor_huxing` WHERE `status` = 1 AND `status` = 1 [ RunTime:0.000398s ]
- SELECT COUNT(*) AS think_count FROM `cms_new_floor` WHERE ( `status` = 1 AND `is_delete` = 0 ) AND `district` = '110115' AND `trade_id` = 260 LIMIT 1 [ RunTime:0.000465s ]
- SELECT * FROM `cms_new_floor` WHERE ( `status` = 1 AND `is_delete` = 0 ) AND `district` = '110115' AND `trade_id` = 260 ORDER BY `sort` DESC,`id` DESC LIMIT 0,5 [ RunTime:0.000586s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_building` [ RunTime:0.001356s ]
- SELECT * FROM `cms_new_floor_building` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000384s ]
- SELECT * FROM `cms_new_floor_huxing` WHERE `status` = 1 AND `floor_id` = 26 ORDER BY `sort` DESC [ RunTime:0.000504s ]
- SELECT MIN(`total`) AS think_min FROM `cms_new_floor_huxing` WHERE `status` = 1 AND `floor_id` = 26 LIMIT 1 [ RunTime:0.000419s ]
- SELECT MAX(`total`) AS think_max FROM `cms_new_floor_huxing` WHERE `status` = 1 AND `floor_id` = 26 LIMIT 1 [ RunTime:0.000384s ]
- SELECT MIN(`areaSpace`) AS think_min FROM `cms_new_floor_huxing` WHERE `status` = 1 AND `floor_id` = 26 LIMIT 1 [ RunTime:0.000372s ]
- SELECT MAX(`areaSpace`) AS think_max FROM `cms_new_floor_huxing` WHERE `status` = 1 AND `floor_id` = 26 LIMIT 1 [ RunTime:0.000370s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_sale` [ RunTime:0.001338s ]
- SELECT * FROM `cms_new_floor_sale` WHERE `is_recommend` = 1 AND `floor_id` = 26 LIMIT 1 [ RunTime:0.000436s ]
- SELECT COUNT(*) AS think_count FROM `cms_new_floor` WHERE ( `status` = 1 AND `is_delete` = 0 ) AND `district` = '110115' AND `trade_id` = 260 LIMIT 1 [ RunTime:0.000439s ]
- SELECT * FROM `cms_new_floor` WHERE `is_hot` = 1 AND `is_delete` = 0 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.000657s ]
- SELECT * FROM `cms_new_floor_building` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000333s ]
- SELECT * FROM `cms_new_floor_building` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000304s ]
- SELECT `trade_id` FROM `cms_region_trade` WHERE `region_id` = 110115 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000461s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 264 LIMIT 1 [ RunTime:0.000376s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 263 LIMIT 1 [ RunTime:0.000333s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 262 LIMIT 1 [ RunTime:0.000348s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 261 LIMIT 1 [ RunTime:0.000274s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 260 LIMIT 1 [ RunTime:0.000325s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 259 LIMIT 1 [ RunTime:0.000249s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 258 LIMIT 1 [ RunTime:0.000327s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 257 LIMIT 1 [ RunTime:0.000278s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 256 LIMIT 1 [ RunTime:0.000279s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 255 LIMIT 1 [ RunTime:0.000263s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 254 LIMIT 1 [ RunTime:0.000328s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 253 LIMIT 1 [ RunTime:0.000322s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 252 LIMIT 1 [ RunTime:0.000339s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 251 LIMIT 1 [ RunTime:0.000294s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 250 LIMIT 1 [ RunTime:0.000273s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 249 LIMIT 1 [ RunTime:0.000258s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 248 LIMIT 1 [ RunTime:0.000266s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 247 LIMIT 1 [ RunTime:0.000246s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 246 LIMIT 1 [ RunTime:0.000255s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 245 LIMIT 1 [ RunTime:0.000246s ]
- SELECT * FROM `cms_trade` WHERE `status` = 1 AND `id` = 244 LIMIT 1 [ RunTime:0.000298s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_price` [ RunTime:0.001015s ]
- SELECT * FROM `cms_new_floor_price` WHERE `type` = 2 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000338s ]
- SELECT * FROM `cms_new_floor_price` WHERE `type` = 1 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000324s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_house` [ RunTime:0.000980s ]
- SELECT * FROM `cms_new_floor_house` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000302s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_area` [ RunTime:0.000926s ]
- SELECT * FROM `cms_new_floor_area` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000324s ]
- SELECT * FROM `cms_new_floor_building` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000266s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_opentime` [ RunTime:0.000906s ]
- SELECT * FROM `cms_new_floor_opentime` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000281s ]
- SHOW FULL COLUMNS FROM `cms_new_floor_renovation` [ RunTime:0.000896s ]
- SELECT * FROM `cms_new_floor_renovation` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000294s ]
- SELECT `id`,`name` FROM `cms_region` WHERE `id` = 110115 [ RunTime:0.000242s ]
- SELECT `id`,`name` FROM `cms_trade` WHERE `id` = 260 [ RunTime:0.000225s ]
- SELECT `id`,`name` FROM `cms_subway` WHERE 0 = 1 [ RunTime:0.000192s ]
- SHOW FULL COLUMNS FROM `cms_station` [ RunTime:0.000818s ]
- SELECT `id`,`name` FROM `cms_station` WHERE 0 = 1 [ RunTime:0.000218s ]
- SELECT * FROM `cms_new_floor_house` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000219s ]
- SELECT * FROM `cms_new_floor_building` WHERE `status` = 1 AND `id` = 0 LIMIT 1 [ RunTime:0.000249s ]
- SELECT * FROM `cms_new_floor_renovation` WHERE `status` = 1 AND `id` = 0 LIMIT 1 [ RunTime:0.000253s ]
0.166248s
