首页 > 碧桂园海上大都会 > 楼盘详情

效果图

样板间

实景图

交通配套

周边配套

碧桂园海上大都会

南省三亚市天涯区三亚湾路国光豪生酒店左侧滨海展厅 均价 25700元/㎡ | 有效期：2023/06/28 在售 洋房花园养生宜居 访客：171769

价格变动请通知~

楼盘类型：高层
开盘时间：2019-03-31
预售证号： 三房预许字【2019】71号
主力户型：（建筑面积）59-264㎡（商办）

报名看房

楼盘首页户型图相册实景视频楼盘资讯楼盘问答

数据参数

楼盘名称 碧桂园海上大都会

住宅类型高层

房屋特色 洋房花园养生宜居

楼盘均价 25700元/平方米

所属区域 海南-三亚

公交路线 海坡公交首末站、华源酒店、芒果村、新城路口、凤凰市场、新开田村、国光酒店、京海假日酒店、海韵酒店、国光滨海花园

开盘时间 2019-03-31

交房时间 2021-06-30

开发商 三亚碧海锦诚商业管理有限公司

售楼电话 15298914180

装修情况 毛坯非毛坯

物业公司 广东碧桂园物业服务有限公司三亚分公司

物业费 5.98元/㎡·月

规划面积 153524

建筑面积 574979

总栋数 16栋

规划户数户

容积率 2.0

绿化率 40%

楼盘地址 南省三亚市天涯区三亚湾路国光豪生酒店左侧滨海展厅

楼盘介绍

【品牌实力】碧桂园集团布局海南国际旅游岛的又一作，贴心服务，安心物业，营造共建、和谐、安全、舒适的社区生活。
【核心卖点】集办公、商业、会议中心、精品酒店、高端住宅于一体的海景综合体项目。未来，项目还将引进主题 MALL、文化秀场、多国风情街、创意产业等多种体验式业态，带动区域的商业活力。
【区域优势】城脉主轴，多重交通贯彻繁华脉搏：距凤凰机场约6公里，距高铁站及市中心约8公里，畅享无忧度假生活。
【资源配套】项目自身规划约5万平的滨海商业综合体，未来将引入主题MALL、文化秀场、多国风情街、创意产业等多种体验式业态。幼儿园、小学、社区居委会、快递柜、超市、健身设施、儿童游乐场、游泳池。（资料来源网络）

主推户型

楼盘配套

学校希望之星幼儿园(羊新路)、金蓓蕾幼儿园、海虹幼儿园(海虹路)、佳佳幼儿园(羊新路)、凤凰镇启蒙幼儿园、三亚市凤凰镇中心学校、三亚市天涯区回辉小学、凤凰中学、三亚乔森幼儿园、三亚市天涯区凤凰小学

购物三亚凤凰新生热带水果、三亚湾银苑-商场、海南特产万家超市、世纪华联超市(三亚湾店)、惠廉超市、伊购超市、壹家人超市(海虹路)、红亚红超市(凤凰二店)、福佳超市(凤凰路)、宏健超市(凤凰店)

医院凤凰镇卫生院、力合康复医院

生活阿福海鲜大排档(口碑老店)、活粒养生粥(三亚湾分店)、阿浪海鲜(凤凰海鲜广场)、海南美宴烧烤、东北小厨、三姐妹海鲜加工、香港喜喜港式茶餐厅(海坡店)、肯德基(海虹DT餐厅)、三亚凤凰海鲜广场、辣妹子大

酒店三亚康年酒店、玉海国际度假酒店、三亚海居铂尔曼度假酒店、三亚辰光克拉码头酒店、三亚景利莱度假酒店、三亚丽禾温德姆酒店、三亚海韵度假酒店、三亚京海国际假日酒店(全日制自助餐厅)、三亚国光豪生度假酒店(三

交通海坡公交首末站、华源酒店、芒果村、新城路口、凤凰市场、新开田村、国光酒店、京海假日酒店、海韵酒店、国光滨海花园

项目区位

推荐楼盘

甄选优质楼盘真实信息准确同步

三亚新闻中心

主力户型：

养生宜居

均价 35000元/㎡

天来泉

主力户型：（建筑面积）36㎡（一居）、78.82㎡（二居）

约43.8万元/套

石梅半岛

主力户型：（建筑面积）73㎡（二居）、82㎡（二居）

公寓商铺

均价 23500元/㎡

免费看房团

房贷计算器

选择户型：

右岸瞰海洋房四房两厅约208㎡ 0m² 海印三房两厅约106㎡ 0m² 右岸瞰海洋房四房两厅约126㎡ 0m² 右岸瞰海洋房四房两厅约139㎡ 0m²

右岸瞰海洋房四房两厅约208㎡/0㎡
海印三房两厅约106㎡/0㎡
右岸瞰海洋房四房两厅约126㎡/0㎡
右岸瞰海洋房四房两厅约139㎡/0㎡

估算总价：

按揭成数：

7成

1成
2成
3成
4成
5成
6成
7成
8成
9成

贷款类别：

商业贷款：

商业贷款
公积金贷款
组合贷款

贷款金额：

公积金万元不能为空！

商业性万元不能为空！

贷款时间：

20年（240个月）

1年（12期）
2年（24期）
3年（36期）
4年（48期）
5年（60期）
6年（72期）
7年（84期）
8年（96期）
9年（108期）
10年（120期）
11年（132期）
12年（144期）
13年（156期）
14年（168期）
15年（180期）
16年（192期）
17年（204期）
18年（216期）
19年（228期）
20年（240期）
21年（252期）
22年（264期）
23年（276期）
24年（288期）
25年（300期）
26年（312期）
27年（324期）
28年（336期）
29年（348期）
30年（360期）

开始计算

月均还款： - （元）

备注：计算结果仅供参考

碧桂园海上大都会|最新动态：

--- 暂无 ---

房产资讯更多

D:\wwwroot\public\index.php ( 0.94 KB )
D:\wwwroot\thinkphp\start.php ( 0.72 KB )
D:\wwwroot\thinkphp\base.php ( 2.60 KB )
D:\wwwroot\thinkphp\library\think\Loader.php ( 21.07 KB )
D:\wwwroot\vendor\composer\autoload_static.php ( 1.08 KB )
D:\wwwroot\thinkphp\library\think\Error.php ( 3.75 KB )
D:\wwwroot\thinkphp\library\think\Config.php ( 6.38 KB )
D:\wwwroot\thinkphp\convention.php ( 10.37 KB )
D:\wwwroot\thinkphp\library\think\App.php ( 21.51 KB )
D:\wwwroot\thinkphp\library\think\Request.php ( 49.78 KB )
D:\wwwroot\clinapp\config.php ( 9.56 KB )
D:\wwwroot\clinapp\database.php ( 2.12 KB )
D:\wwwroot\thinkphp\library\think\Hook.php ( 4.71 KB )
D:\wwwroot\clinapp\tags.php ( 0.99 KB )
D:\wwwroot\clinapp\common.php ( 15.92 KB )
D:\wwwroot\thinkphp\library\think\Env.php ( 1.21 KB )
D:\wwwroot\thinkphp\helper.php ( 17.30 KB )
D:\wwwroot\thinkphp\library\think\Lang.php ( 7.23 KB )
D:\wwwroot\thinkphp\library\think\Log.php ( 6.05 KB )
D:\wwwroot\thinkphp\lang\zh-cn.php ( 11.81 KB )
D:\wwwroot\clinapp\route.php ( 5.47 KB )
D:\wwwroot\thinkphp\library\think\Route.php ( 60.23 KB )
D:\wwwroot\clinapp\index\controller\House.php ( 9.61 KB )
D:\wwwroot\clinapp\index\controller\Action.php ( 2.48 KB )
D:\wwwroot\thinkphp\library\think\Controller.php ( 6.07 KB )
D:\wwwroot\thinkphp\library\traits\controller\Jump.php ( 4.90 KB )
D:\wwwroot\thinkphp\library\think\View.php ( 6.77 KB )
D:\wwwroot\thinkphp\library\think\view\driver\Think.php ( 5.64 KB )
D:\wwwroot\thinkphp\library\think\Template.php ( 44.90 KB )
D:\wwwroot\thinkphp\library\think\template\driver\File.php ( 2.24 KB )
D:\wwwroot\thinkphp\library\think\Db.php ( 6.67 KB )
D:\wwwroot\thinkphp\library\think\db\connector\Mysql.php ( 3.89 KB )
D:\wwwroot\thinkphp\library\think\db\Connection.php ( 29.97 KB )
D:\wwwroot\thinkphp\library\think\db\Query.php ( 93.74 KB )
D:\wwwroot\thinkphp\library\think\db\builder\Mysql.php ( 4.53 KB )
D:\wwwroot\thinkphp\library\think\db\Builder.php ( 31.55 KB )
D:\wwwroot\thinkphp\library\think\Debug.php ( 7.13 KB )
D:\wwwroot\clinapp\index\model\Ad.php ( 0.95 KB )
D:\wwwroot\thinkphp\library\think\Model.php ( 69.14 KB )
D:\wwwroot\clinapp\index\model\News.php ( 2.64 KB )
D:\wwwroot\clinapp\index\model\Type.php ( 0.77 KB )
D:\wwwroot\clinapp\index\model\City.php ( 1.48 KB )
D:\wwwroot\clinapp\index\model\House.php ( 12.19 KB )
D:\wwwroot\thinkphp\library\think\Cache.php ( 6.10 KB )
D:\wwwroot\thinkphp\library\think\cache\driver\File.php ( 7.27 KB )
D:\wwwroot\thinkphp\library\think\cache\Driver.php ( 5.98 KB )
D:\wwwroot\thinkphp\library\think\Response.php ( 8.28 KB )
D:\wwwroot\thinkphp\library\think\response\View.php ( 2.43 KB )
D:\wwwroot\runtime\temp\d5bee82b16d995d8d0145b2c24a57fc9.php ( 49.64 KB )
D:\wwwroot\thinkphp\library\think\Url.php ( 12.72 KB )
D:\wwwroot\thinkphp\library\think\Session.php ( 10.86 KB )
D:\wwwroot\thinkphp\library\think\db\Expression.php ( 1.11 KB )
D:\wwwroot\thinkphp\library\think\debug\Html.php ( 4.17 KB )

[ DB ] CONNECT:[ UseTime:0.001058s ] mysql:host=localhost;dbname=www_beikefangcha;charset=utf8
[ SQL ] SHOW COLUMNS FROM `mo_website` [ RunTime:0.000857s ]
[ SQL ] SELECT * FROM `mo_website` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000379s ]
[ SQL ] SHOW COLUMNS FROM `mo_ad` [ RunTime:0.000613s ]
[ SQL ] SELECT * FROM `mo_ad` WHERE `cid` = 378 ORDER BY `vieworder` ASC,`id` DESC LIMIT 11 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `mo_ad` WHERE `cid` = 378 ORDER BY `vieworder` ASC,`id` DESC LIMIT 11 [ RunTime:0.000180s ]
[ SQL ] SHOW COLUMNS FROM `mo_link` [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `mo_link` ORDER BY `vieworder` ASC [ RunTime:0.000159s ]
[ SQL ] SHOW COLUMNS FROM `mo_news` [ RunTime:0.000596s ]
[ SQL ] SELECT * FROM `mo_news` WHERE `cid` = 65 ORDER BY `addtime` DESC LIMIT 10 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `mo_news` WHERE `cid` = 10 ORDER BY `addtime` DESC LIMIT 10 [ RunTime:0.000218s ]
[ SQL ] SHOW COLUMNS FROM `mo_type` [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 16 ORDER BY `vieworder` ASC [ RunTime:0.000183s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 22 ORDER BY `vieworder` ASC [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 26 ORDER BY `vieworder` ASC [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 31 ORDER BY `vieworder` ASC [ RunTime:0.000168s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 36 ORDER BY `vieworder` ASC [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 9 ORDER BY `vieworder` ASC [ RunTime:0.000168s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 46 ORDER BY `vieworder` ASC [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 53 ORDER BY `vieworder` ASC [ RunTime:0.000165s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 70 ORDER BY `vieworder` ASC [ RunTime:0.000173s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 353 ORDER BY `vieworder` ASC [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 357 ORDER BY `vieworder` ASC [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 393 ORDER BY `vieworder` ASC [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 429 ORDER BY `vieworder` ASC [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 430 ORDER BY `vieworder` ASC [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 421 ORDER BY `vieworder` ASC [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `mo_type` WHERE `cid` = 409 ORDER BY `vieworder` ASC [ RunTime:0.000173s ]
[ SQL ] SHOW COLUMNS FROM `mo_city` [ RunTime:0.000520s ]
[ SQL ] SELECT * FROM `mo_city` WHERE `keyid` = 0 AND `display` = 1 ORDER BY `sort` ASC [ RunTime:0.000203s ]
[ SQL ] SELECT `a`.*,b.domain as pdomain FROM `mo_city` `a` LEFT JOIN `mo_city` `b` ON `a`.`keyid`=`b`.`id` WHERE `a`.`sitetype` = 1 ORDER BY `a`.`sort` ASC,`a`.`sitetype` DESC,`a`.`id` ASC [ RunTime:0.000201s ]
[ SQL ] SELECT * FROM `mo_city` WHERE `keyid` = 0 AND `display` = 1 ORDER BY `sort` ASC [ RunTime:0.000187s ]
[ SQL ] SELECT `id`,`name` FROM `mo_city` WHERE `keyid` = 9 AND `sitetype` = 1 ORDER BY `sort` ASC [ RunTime:0.000189s ]
[ SQL ] SHOW COLUMNS FROM `mo_about` [ RunTime:0.000512s ]
[ SQL ] SELECT `id`,`name` FROM `mo_about` WHERE `cid` = 7 ORDER BY `vieworder` [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`name` FROM `mo_about` WHERE `cid` = 8 ORDER BY `vieworder` [ RunTime:0.000155s ]
[ SQL ] SHOW COLUMNS FROM `mo_house` [ RunTime:0.000698s ]
[ SQL ] UPDATE `mo_house` SET `hits`=`hits`+1 WHERE `id` = 2613 [ RunTime:0.001925s ]
[ SQL ] SELECT `a`.*,`e`.*,b.name as pname,c.name as cname,d.name as zname,f.filepath as filepath,g.filepath as filepaths,g.video_imgpath as video_imgpath,h.filepath as filepathvr,h.video_imgpath as vr_imgpath,`i`.*,a.id as id,`f`.`voice_content` FROM `mo_house` `a` LEFT JOIN `mo_city` `b` ON `a`.`proid`=`b`.`id` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` LEFT JOIN `mo_type` `d` ON `a`.`sales_type`=`d`.`id` LEFT JOIN `mo_house_c` `e` ON `a`.`id`=`e`.`id` LEFT JOIN `mo_house_voice` `f` ON `a`.`id`=`f`.`id` LEFT JOIN `mo_house_video` `g` ON `a`.`id`=`g`.`house_id` LEFT JOIN `mo_house_vr` `h` ON `a`.`id`=`h`.`house_id` LEFT JOIN `mo_house_b` `i` ON `a`.`id`=`i`.`id` WHERE `a`.`id` = '2613' LIMIT 1 [ RunTime:0.001714s ]
[ SQL ] SELECT `a`.`id`,`a`.`name`,`a`.`description`,`a`.`addtime`,b.name as cname FROM `mo_news` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '2613' ORDER BY `a`.`id` DESC LIMIT 3 [ RunTime:0.000381s ]
[ SQL ] SHOW COLUMNS FROM `mo_house_hx` [ RunTime:0.000806s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_hx` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '2613' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000195s ]
[ SQL ] SHOW COLUMNS FROM `mo_house_xc` [ RunTime:0.000741s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_xc` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '2613' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000194s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`unit_price` = 25700 AND `a`.`id` <> '2613' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000928s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`cityid` = 121 AND `a`.`id` <> '2613' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000552s ]
[ SQL ] SHOW COLUMNS FROM `mo_house_x` [ RunTime:0.000787s ]
[ SQL ] SELECT * FROM `mo_house_x` WHERE `house_id` = 2613 ORDER BY `id` DESC [ RunTime:0.000186s ]
[ SQL ] SHOW COLUMNS FROM `mo_house_pl` [ RunTime:0.000739s ]
[ SQL ] SELECT * FROM `mo_house_pl` WHERE `house_id` = 2613 AND `status` = 1 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000189s ]
[ SQL ] SELECT * FROM `mo_news` WHERE `house_id` = 2613 ORDER BY `addtime` DESC LIMIT 10 [ RunTime:0.000324s ]
[ SQL ] SHOW COLUMNS FROM `mo_online` [ RunTime:0.000761s ]
[ SQL ] SELECT * FROM `mo_online` WHERE `cityid` = 121 [ RunTime:0.000169s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 189 LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 170 LIMIT 1 [ RunTime:0.000152s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `mo_house_xc` WHERE `cid` = 47 AND `house_id` = 2613 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mo_house_xc` WHERE `cid` = 47 AND `house_id` = 2613 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT * FROM `mo_house_xc` WHERE `cid` = 49 AND `house_id` = 2613 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mo_house_xc` WHERE `cid` = 49 AND `house_id` = 2613 LIMIT 1 [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `mo_house_xc` WHERE `cid` = 48 AND `house_id` = 2613 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mo_house_xc` WHERE `cid` = 48 AND `house_id` = 2613 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `mo_house_xc` WHERE `cid` = 51 AND `house_id` = 2613 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mo_house_xc` WHERE `cid` = 51 AND `house_id` = 2613 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `mo_house_xc` WHERE `cid` = 52 AND `house_id` = 2613 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000170s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mo_house_xc` WHERE `cid` = 52 AND `house_id` = 2613 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `mo_house_xc` WHERE `cid` = 50 AND `house_id` = 2613 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mo_house_xc` WHERE `cid` = 50 AND `house_id` = 2613 LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `mo_online` WHERE `cityid` = 121 [ RunTime:0.000157s ]
[ SQL ] SHOW COLUMNS FROM `mo_city_tel` [ RunTime:0.000746s ]
[ SQL ] SELECT * FROM `mo_city_tel` WHERE `cityid` = 121 [ RunTime:0.000168s ]
[ SQL ] SHOW COLUMNS FROM `mo_recommend` [ RunTime:0.001258s ]
[ SQL ] SELECT * FROM `mo_recommend` WHERE `cid` = 456 [ RunTime:0.000281s ]
[ SQL ] UPDATE `mo_house` SET `hits`=`hits`+1 WHERE `id` = 2585 [ RunTime:0.001300s ]
[ SQL ] SELECT `a`.*,`e`.*,b.name as pname,c.name as cname,d.name as zname,f.filepath as filepath,g.filepath as filepaths,g.video_imgpath as video_imgpath,h.filepath as filepathvr,h.video_imgpath as vr_imgpath,`i`.*,a.id as id,`f`.`voice_content` FROM `mo_house` `a` LEFT JOIN `mo_city` `b` ON `a`.`proid`=`b`.`id` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` LEFT JOIN `mo_type` `d` ON `a`.`sales_type`=`d`.`id` LEFT JOIN `mo_house_c` `e` ON `a`.`id`=`e`.`id` LEFT JOIN `mo_house_voice` `f` ON `a`.`id`=`f`.`id` LEFT JOIN `mo_house_video` `g` ON `a`.`id`=`g`.`house_id` LEFT JOIN `mo_house_vr` `h` ON `a`.`id`=`h`.`house_id` LEFT JOIN `mo_house_b` `i` ON `a`.`id`=`i`.`id` WHERE `a`.`id` = '2585' LIMIT 1 [ RunTime:0.000980s ]
[ SQL ] SELECT `a`.`id`,`a`.`name`,`a`.`description`,`a`.`addtime`,b.name as cname FROM `mo_news` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '2585' ORDER BY `a`.`id` DESC LIMIT 3 [ RunTime:0.000193s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_hx` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '2585' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000454s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_xc` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '2585' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000194s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`unit_price` = 35000 AND `a`.`id` <> '2585' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000903s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`cityid` = 121 AND `a`.`id` <> '2585' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000577s ]
[ SQL ] SELECT * FROM `mo_house_x` WHERE `house_id` = 2585 ORDER BY `id` DESC [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `mo_house_pl` WHERE `house_id` = 2585 AND `status` = 1 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000449s ]
[ SQL ] UPDATE `mo_house` SET `hits`=`hits`+1 WHERE `id` = 591 [ RunTime:0.001290s ]
[ SQL ] SELECT `a`.*,`e`.*,b.name as pname,c.name as cname,d.name as zname,f.filepath as filepath,g.filepath as filepaths,g.video_imgpath as video_imgpath,h.filepath as filepathvr,h.video_imgpath as vr_imgpath,`i`.*,a.id as id,`f`.`voice_content` FROM `mo_house` `a` LEFT JOIN `mo_city` `b` ON `a`.`proid`=`b`.`id` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` LEFT JOIN `mo_type` `d` ON `a`.`sales_type`=`d`.`id` LEFT JOIN `mo_house_c` `e` ON `a`.`id`=`e`.`id` LEFT JOIN `mo_house_voice` `f` ON `a`.`id`=`f`.`id` LEFT JOIN `mo_house_video` `g` ON `a`.`id`=`g`.`house_id` LEFT JOIN `mo_house_vr` `h` ON `a`.`id`=`h`.`house_id` LEFT JOIN `mo_house_b` `i` ON `a`.`id`=`i`.`id` WHERE `a`.`id` = '591' LIMIT 1 [ RunTime:0.000586s ]
[ SQL ] SELECT `a`.`id`,`a`.`name`,`a`.`description`,`a`.`addtime`,b.name as cname FROM `mo_news` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '591' ORDER BY `a`.`id` DESC LIMIT 3 [ RunTime:0.000192s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_hx` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '591' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000208s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_xc` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '591' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000176s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`unit_price` = 0 AND `a`.`id` <> '591' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000938s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`cityid` = 131 AND `a`.`id` <> '591' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000668s ]
[ SQL ] SELECT * FROM `mo_house_x` WHERE `house_id` = 591 ORDER BY `id` DESC [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `mo_house_pl` WHERE `house_id` = 591 AND `status` = 1 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000181s ]
[ SQL ] UPDATE `mo_house` SET `hits`=`hits`+1 WHERE `id` = 505 [ RunTime:0.001518s ]
[ SQL ] SELECT `a`.*,`e`.*,b.name as pname,c.name as cname,d.name as zname,f.filepath as filepath,g.filepath as filepaths,g.video_imgpath as video_imgpath,h.filepath as filepathvr,h.video_imgpath as vr_imgpath,`i`.*,a.id as id,`f`.`voice_content` FROM `mo_house` `a` LEFT JOIN `mo_city` `b` ON `a`.`proid`=`b`.`id` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` LEFT JOIN `mo_type` `d` ON `a`.`sales_type`=`d`.`id` LEFT JOIN `mo_house_c` `e` ON `a`.`id`=`e`.`id` LEFT JOIN `mo_house_voice` `f` ON `a`.`id`=`f`.`id` LEFT JOIN `mo_house_video` `g` ON `a`.`id`=`g`.`house_id` LEFT JOIN `mo_house_vr` `h` ON `a`.`id`=`h`.`house_id` LEFT JOIN `mo_house_b` `i` ON `a`.`id`=`i`.`id` WHERE `a`.`id` = '505' LIMIT 1 [ RunTime:0.000600s ]
[ SQL ] SELECT `a`.`id`,`a`.`name`,`a`.`description`,`a`.`addtime`,b.name as cname FROM `mo_news` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '505' ORDER BY `a`.`id` DESC LIMIT 3 [ RunTime:0.000190s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_hx` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '505' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000193s ]
[ SQL ] SELECT `a`.*,b.name as cname FROM `mo_house_xc` `a` LEFT JOIN `mo_type` `b` ON `a`.`cid`=`b`.`id` WHERE `a`.`house_id` = '505' ORDER BY `a`.`sort` ASC LIMIT 15 [ RunTime:0.000183s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`unit_price` = 23500 AND `a`.`id` <> '505' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000842s ]
[ SQL ] SELECT `a`.`id`,`a`.`unit_price`,`a`.`total_price`,`a`.`name`,`a`.`imgpath1`,c.name as cname FROM `mo_house` `a` LEFT JOIN `mo_city` `c` ON `a`.`cityid`=`c`.`id` WHERE `a`.`cityid` = 134 AND `a`.`id` <> '505' AND `a`.`ifopen` = 1 ORDER BY `a`.`addtime` DESC LIMIT 6 [ RunTime:0.000696s ]
[ SQL ] SELECT * FROM `mo_house_x` WHERE `house_id` = 505 ORDER BY `id` DESC [ RunTime:0.000199s ]
[ SQL ] SELECT * FROM `mo_house_pl` WHERE `house_id` = 505 AND `status` = 1 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000175s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 170 LIMIT 1 [ RunTime:0.000163s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 171 LIMIT 1 [ RunTime:0.000179s ]
[ SQL ] SELECT `name` FROM `mo_type` WHERE `id` = 174 LIMIT 1 [ RunTime:0.000148s ]

碧桂园海上大都会