碧桂园海上大都会右岸

天涯区 · 三亚市三亚湾路

售罄
参考均价35000.00元/㎡获取最新报价
主力户型
暂无资料
物业类型
板塔结合 高层
装修情况
豪装,
开盘时间
2020-12-01
交房时间
2022-05-30
开发商
三亚碧桂园房地产开发有限公司
最新优惠与可售房源

一个月内全款96折优惠,我们竭诚为您提供全岛机场24小时接送服务,永久免费登岛服务,团购报名,需提前2天报名!

电话咨询

专业置业顾问一对一服务 · 不收取咨询费用

楼盘信息

信息更新时间:2026-08-11
楼盘名称
碧桂园海上大都会右岸
所属区域
天涯区
参考均价
35000.00 元/㎡
产权年限
普通住宅:70年;标准写字楼:40年;住宅底商:40年;购物中心:40年;写字楼商铺:40年
容积率
2.85
绿化率
35%
物业公司
碧桂园服务控股有限公司
物业费
5.98元/㎡·月
停车位
1372个
售楼地址
三亚市三亚湾路

项目介绍

碧桂园·海上大都会,是碧桂园集团重点布局海南国际旅游岛的又一非凡之作,项目业态汇聚主题商业街区、主题酒店、商务、金融、文化、 物业为一体的滨海度假综合体,即将重新定义 海居生活方式。
三亚稀缺的一线海景资源,拥有约1公里的纯美海岸线,周边汇聚五星级酒店集群及 成熟社区,是三亚 人群集散地;项目规划引进国际一线品牌,汇聚时尚潮流的艺术、美食、娱乐生活空间,打造主题情景化多元化的潮玩娱教体验及地标性海滨生态 公园,带给三亚全新的 生活方式。

PROPERTY VIDEOS

楼盘视频

查看全部 5 个视频 →
大都会样板间208㎡
大都会样板间139㎡
大都会样板间126㎡
大都会样板间106㎡

VR PANORAMA

VR全景看房

共 1 个场景

PROPERTY ALBUM

楼盘相册

共 16 张
规划图
规划图效果图
实景图3
实景图3实景图
实景图2
实景图2实景图
实景图
实景图实景图
区位图
区位图交通图
样板间5
样板间5样板间图
样板间4
样板间4样板间图
样板间3
样板间3样板间图
样板间2
样板间2样板间图
样板间
样板间样板间图
夜景效果图
夜景效果图效果图
商业效果图
商业效果图效果图
鸟瞰图
鸟瞰图效果图
实景图3
实景图3实景图
实景图2
实景图2实景图
实景图
实景图实景图

FLOOR PLANS

户型图

共 7 个户型

PROPERTY SANDBOX

楼盘沙盘

共 3 栋
碧桂园海上大都会右岸沙盘图
在售待售售罄点击楼栋查看基本信息
楼栋状态单元层数户数梯户比开盘 / 交房
2#待售1个17层60户2梯4户待定 / 待定
3#待售1个17层60户2梯4户待定 / 待定
4#待售1个16层75户2梯5户待定 / 待定

PROPERTY NEWS

楼盘动态

碧桂园海上大都会右岸在售住宅房源
碧桂园海上大都会右岸在售住宅房源

碧桂园海上大都会住宅在售建面约137-144㎡,均价33000元/㎡,特价优惠29000元/㎡

2023-11-22
三亚
海上大都会右岸社区底商、临街现铺特惠在售
海上大都会右岸社区底商、临街现铺特惠在售

碧桂园海上大都会 项目社区底商、临街现铺特惠在售,共推出4套房源,目前已售出1套,还剩3套,户型建筑面积为82㎡-356㎡,其中02-106房,建筑面积为82㎡,原总价307万元,折后总价190万元

2023-09-26
三亚
碧桂园海上大都会右岸住宅在售建面137-144㎡
碧桂园海上大都会右岸住宅在售建面137-144㎡

碧桂园海上大都会在售住宅建面137-144㎡,均价33000元/㎡,特价优惠29000元/㎡

2023-08-13
三亚
碧桂园海上大都会主力户型建筑面积约 59㎡-264㎡
碧桂园海上大都会主力户型建筑面积约 59㎡-264㎡

碧桂园海上大都会房源在售,主力户型建筑面积约 59㎡-264㎡,均价27000元/㎡起, 全款享96折

2023-07-26
三亚
碧桂园海上大都会右岸实景现房和临街商铺在售
碧桂园海上大都会右岸实景现房和临街商铺在售

碧桂园海上大都会位于海南省三亚市三亚湾路190号,北临新城路,南临椰梦长廊三亚湾,东临海虹路。海上大都会项目总占地面积约230亩,位于三亚湾旅游度假区,贯通繁华脉搏。

2023-05-27
三亚
碧桂园海上大都会右岸住宅建面137-144㎡
碧桂园海上大都会右岸住宅建面137-144㎡

碧桂园海上大都会位于海南省三亚市三亚湾路190号,北临新城路,南临椰梦长廊三亚湾,东临海虹路。海上大都会项目总占地面积约230亩,位于三亚湾旅游度假区,贯通繁华脉搏。

2023-04-26
三亚

PROPERTY ADVISORS

专业置业顾问

一对一提供楼盘对比、价格和看房服务
王伟
王伟服务达人 · 海口

安徽蚌埠人,毕业西安交通大学,房地产从业10年,主修别墅、商业地产,对于资产配置有自己独特的见解。熟悉海南90

电话咨询
杨滨
杨滨服务达人 · 海口

河北承德人,毕业于河海大学,从事房地产10年,熟悉房地产交易各个环节,过户、贷款、按揭、抵押、公证、特别对项目

电话咨询
在线问顾问专业顾问 · 快速响应 免费电话咨询获取底价与最新优惠
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-08-20 19:43:33 HTTP/2.0 GET : https://www.doofang.com/loupan/337
  2. 运行时间 : 0.074344s [ 吞吐率:13.45req/s ] 内存消耗:5,225.80kb 文件加载:150
  3. 缓存信息 : 0 reads,0 writes
  1. /www/wwwroot/www.doofang.com/public/index.php ( 0.79 KB )
  2. /www/wwwroot/www.doofang.com/vendor/autoload.php ( 0.17 KB )
  3. /www/wwwroot/www.doofang.com/vendor/composer/autoload_real.php ( 2.49 KB )
  4. /www/wwwroot/www.doofang.com/vendor/composer/platform_check.php ( 0.90 KB )
  5. /www/wwwroot/www.doofang.com/vendor/composer/ClassLoader.php ( 14.03 KB )
  6. /www/wwwroot/www.doofang.com/vendor/composer/autoload_static.php ( 183.26 KB )
  7. /www/wwwroot/www.doofang.com/vendor/symfony/polyfill-mbstring/bootstrap.php ( 0.35 KB )
  8. /www/wwwroot/www.doofang.com/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.81 KB )
  9. /www/wwwroot/www.doofang.com/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  10. /www/wwwroot/www.doofang.com/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.60 KB )
  11. /www/wwwroot/www.doofang.com/vendor/phpunit/phpunit/src/Framework/Assert/Functions.php ( 111.59 KB )
  12. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  13. /www/wwwroot/www.doofang.com/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  14. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  15. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  16. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  17. /www/wwwroot/www.doofang.com/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  18. /www/wwwroot/www.doofang.com/vendor/myclabs/deep-copy/src/DeepCopy/deep_copy.php ( 0.39 KB )
  19. /www/wwwroot/www.doofang.com/vendor/topthink/think-dumper/src/helper.php ( 0.18 KB )
  20. /www/wwwroot/www.doofang.com/vendor/symfony/var-dumper/VarDumper.php ( 4.23 KB )
  21. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  22. /www/wwwroot/www.doofang.com/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  23. /www/wwwroot/www.doofang.com/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  24. /www/wwwroot/www.doofang.com/app/provider.php ( 0.19 KB )
  25. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Http.php ( 6.22 KB )
  26. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  27. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  28. /www/wwwroot/www.doofang.com/app/common.php ( 0.03 KB )
  29. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  30. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  31. /www/wwwroot/www.doofang.com/config/app.php ( 0.95 KB )
  32. /www/wwwroot/www.doofang.com/config/assets.php ( 0.31 KB )
  33. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  34. /www/wwwroot/www.doofang.com/config/auth.php ( 0.58 KB )
  35. /www/wwwroot/www.doofang.com/config/cache.php ( 0.78 KB )
  36. /www/wwwroot/www.doofang.com/config/console.php ( 0.29 KB )
  37. /www/wwwroot/www.doofang.com/config/cookie.php ( 0.56 KB )
  38. /www/wwwroot/www.doofang.com/config/database.php ( 2.83 KB )
  39. /www/wwwroot/www.doofang.com/config/filesystem.php ( 0.61 KB )
  40. /www/wwwroot/www.doofang.com/config/integrations.php ( 0.08 KB )
  41. /www/wwwroot/www.doofang.com/config/lang.php ( 0.91 KB )
  42. /www/wwwroot/www.doofang.com/config/log.php ( 1.35 KB )
  43. /www/wwwroot/www.doofang.com/config/middleware.php ( 0.19 KB )
  44. /www/wwwroot/www.doofang.com/config/route.php ( 1.89 KB )
  45. /www/wwwroot/www.doofang.com/config/session.php ( 0.57 KB )
  46. /www/wwwroot/www.doofang.com/config/trace.php ( 0.34 KB )
  47. /www/wwwroot/www.doofang.com/config/view.php ( 0.82 KB )
  48. /www/wwwroot/www.doofang.com/config/wechat.php ( 0.18 KB )
  49. /www/wwwroot/www.doofang.com/app/event.php ( 0.25 KB )
  50. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  51. /www/wwwroot/www.doofang.com/app/service.php ( 0.13 KB )
  52. /www/wwwroot/www.doofang.com/app/AppService.php ( 0.26 KB )
  53. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  54. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  55. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  56. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  57. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  58. /www/wwwroot/www.doofang.com/vendor/services.php ( 0.18 KB )
  59. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  60. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  61. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  62. /www/wwwroot/www.doofang.com/vendor/topthink/think-migration/src/Service.php ( 1.94 KB )
  63. /www/wwwroot/www.doofang.com/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  64. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  65. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  66. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  67. /www/wwwroot/www.doofang.com/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  68. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  69. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  70. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  71. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  72. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  73. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  74. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  75. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  76. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  77. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  78. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  79. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  80. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  81. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  82. /www/wwwroot/www.doofang.com/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  83. /www/wwwroot/www.doofang.com/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  84. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  85. /www/wwwroot/www.doofang.com/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  86. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  87. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  88. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  89. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  90. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Console.php ( 22.98 KB )
  91. /www/wwwroot/www.doofang.com/app/Request.php ( 0.09 KB )
  92. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  93. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  94. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  95. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  96. /www/wwwroot/www.doofang.com/app/middleware.php ( 0.06 KB )
  97. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  98. /www/wwwroot/www.doofang.com/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  99. /www/wwwroot/www.doofang.com/app/middleware/CorsMiddleware.php ( 1.19 KB )
  100. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  101. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  102. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  103. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  104. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  105. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  106. /www/wwwroot/www.doofang.com/route/app.php ( 12.00 KB )
  107. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  108. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  109. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  110. /www/wwwroot/www.doofang.com/app/controller/Home.php ( 39.72 KB )
  111. /www/wwwroot/www.doofang.com/app/BaseController.php ( 2.05 KB )
  112. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  113. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  114. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  115. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  116. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  117. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  118. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  119. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  120. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  121. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  122. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  123. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  124. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  125. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  126. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  127. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  128. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  129. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  130. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  131. /www/wwwroot/www.doofang.com/vendor/topthink/think-orm/src/db/Raw.php ( 1.30 KB )
  132. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  133. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  134. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  135. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  136. /www/wwwroot/www.doofang.com/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  137. /www/wwwroot/www.doofang.com/app/controller/Visitor.php ( 16.68 KB )
  138. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/View.php ( 1.70 KB )
  139. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  140. /www/wwwroot/www.doofang.com/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  141. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  142. /www/wwwroot/www.doofang.com/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  143. /www/wwwroot/www.doofang.com/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  144. /www/wwwroot/www.doofang.com/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  145. /www/wwwroot/www.doofang.com/runtime/temp/61485e35ac1b46ab3c183a39c6d2527d.php ( 47.67 KB )
  146. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
  147. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  148. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/response/Html.php ( 0.97 KB )
  149. /www/wwwroot/www.doofang.com/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  150. /www/wwwroot/www.doofang.com/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.000434s ] mysql:host=127.0.0.1;port=3306;dbname=www.doofang.com;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `properties` [ RunTime:0.001125s ]
  3. SELECT p.*,r.name region_name,CASE WHEN COALESCE(p.video_url,'')<>'' OR EXISTS (SELECT 1 FROM property_videos pv_badge WHERE pv_badge.property_id=p.id AND pv_badge.status=1 AND COALESCE(pv_badge.video_url,'')<>'') THEN 1 ELSE 0 END has_video,CASE WHEN COALESCE(p.panorama_url,'')<>'' OR EXISTS (SELECT 1 FROM property_panoramas pp_badge WHERE pp_badge.property_id=p.id AND pp_badge.status=1 AND COALESCE(pp_badge.panorama_url,'')<>'') THEN 1 ELSE 0 END has_panorama FROM `properties` `p` LEFT JOIN `regions` `r` ON `r`.`id`=`p`.`region_id` WHERE `p`.`status` = '1' AND ( `p`.`legacy_id` = '337' OR `p`.`id` = '337' ) LIMIT 1 [ RunTime:0.001105s ]
  4. SHOW FULL COLUMNS FROM `property_photos` [ RunTime:0.000628s ]
  5. SELECT * FROM `property_photos` WHERE `property_id` = '463' AND `status` = '1' ORDER BY `is_cover` DESC,`sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000526s ]
  6. SHOW FULL COLUMNS FROM `property_floor_plans` [ RunTime:0.000677s ]
  7. SELECT * FROM `property_floor_plans` WHERE `property_id` = '463' AND `status` = '1' ORDER BY `sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000563s ]
  8. SHOW FULL COLUMNS FROM `property_panoramas` [ RunTime:0.000508s ]
  9. SELECT * FROM `property_panoramas` WHERE `property_id` = '463' AND `status` = '1' AND `panorama_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000374s ]
  10. SHOW FULL COLUMNS FROM `property_reviews` [ RunTime:0.000582s ]
  11. SELECT * FROM `property_reviews` WHERE `property_id` = '463' AND `status` = 'published' ORDER BY `sort_order` DESC,`created_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000431s ]
  12. SHOW FULL COLUMNS FROM `property_review_replies` [ RunTime:0.000523s ]
  13. SELECT * FROM `property_review_replies` WHERE `review_id` IN ('270','271','272') AND `status` = 'published' ORDER BY `created_at` ASC,`id` ASC [ RunTime:0.000326s ]
  14. SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000569s ]
  15. SELECT * FROM `property_questions` WHERE `property_id` = '463' AND `status` = 'published' ORDER BY `sort_order` DESC,`asked_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000427s ]
  16. SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.000601s ]
  17. SELECT * FROM `property_promotions` WHERE `property_id` = '463' AND `status` = 'published' ORDER BY `sort_order` DESC,`starts_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000396s ]
  18. SHOW FULL COLUMNS FROM `property_milestones` [ RunTime:0.000530s ]
  19. SELECT * FROM `property_milestones` WHERE `property_id` = '463' AND `status` = '1' ORDER BY `event_date` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000367s ]
  20. SHOW FULL COLUMNS FROM `property_price_histories` [ RunTime:0.000559s ]
  21. SELECT * FROM `property_price_histories` WHERE `property_id` = '463' ORDER BY `recorded_on` ASC,`sort_order` ASC,`id` ASC LIMIT 300 [ RunTime:0.000355s ]
  22. SHOW FULL COLUMNS FROM `property_sandbox_buildings` [ RunTime:0.000605s ]
  23. SELECT * FROM `property_sandbox_buildings` WHERE `property_id` = '463' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC LIMIT 500 [ RunTime:0.000384s ]
  24. SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.000530s ]
  25. SELECT COUNT(*) AS think_count FROM `property_videos` WHERE `property_id` = '463' AND `status` = '1' AND `video_url` <> '' [ RunTime:0.000342s ]
  26. SELECT * FROM `property_videos` WHERE `property_id` = '463' AND `status` = '1' AND `video_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 4 [ RunTime:0.000402s ]
  27. SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000637s ]
  28. SELECT `a`.`id`,`a`.`legacy_id`,`a`.`property_id`,`a`.`legacy_property_id`,`a`.`region_id`,`a`.`title`,`a`.`summary`,`a`.`cover_image`,`a`.`author`,`a`.`source_name`,`a`.`keywords`,`a`.`view_count`,`a`.`is_recommended`,`a`.`is_pinned`,`a`.`status`,`a`.`published_at`,`a`.`created_at`,`a`.`updated_at`,r.name region_name,p.name property_name,p.cover_image property_cover FROM `property_articles` `a` LEFT JOIN `regions` `r` ON `r`.`id`=`a`.`region_id` LEFT JOIN `properties` `p` ON `p`.`id`=`a`.`property_id` WHERE `a`.`status` = 'published' AND `a`.`property_id` = '463' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.000905s ]
  29. SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000560s ]
  30. SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000319s ]
  31. SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.000573s ]
  32. SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 3 [ RunTime:0.000422s ]
  33. SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000572s ]
  34. SELECT COUNT(*) AS think_count FROM `visitor_blacklist` WHERE ( `ip_address` = '216.73.216.164' ) AND ( `expires_at` IS NULL OR `expires_at` > '2026-08-20 19:43:33' ) [ RunTime:0.000301s ]
  35. SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000578s ]
  36. SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000300s ]
  37. SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000572s ]
  38. SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000297s ]
  39. SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000524s ]
  40. SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000608s ]
  41. SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000307s ]
  42. SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000561s ]
  43. SELECT * FROM `third_party_integrations` WHERE `site_id` = '1' AND `integration_type` = 'customer_service' AND `provider` = '53kf' AND `enabled` = '1' LIMIT 1 [ RunTime:0.000338s ]
0.075263s