国厦海澜湾

澄迈 · 海南省澄迈县老城镇北二环和北一环交汇处

在售
参考均价10000.00元/㎡获取最新报价
主力户型
暂无资料
物业类型
板楼 小高层
装修情况
豪装,
开盘时间
2021-12-10
交房时间
2023-09-30
开发商
澄迈海厦房地产开发有限公司
最新优惠与可售房源

我们竭诚为您提供全岛机场24小时接送服务,永久免费登岛服务,团购报名,需提前2天报名!

电话咨询

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

楼盘信息

信息更新时间:2026-08-11
楼盘名称
国厦海澜湾
所属区域
澄迈
参考均价
10000.00 元/㎡
产权年限
70年
容积率
1.80
绿化率
45%
物业公司
北京国瑞物业服务管理有限公司
物业费
2.4元/㎡·月
停车位
856(地上77个,地下779个)
售楼地址
海南省澄迈县老城镇北二环和北一环交汇处

项目介绍

海澜国际项目位于海南省澄迈县老城镇,北二环路以南与美朗路交汇处。项目总占地约4.94万㎡,约 74 亩,总建筑面积约 12万㎡,容积率1.8,绿化率大于等于45%,规划总户数774户,商铺共34套,车位共有856个,所有楼栋落位均坐北朝南,南北通透,一梯两户,是海南少有的纯板楼构造。

项目共分为三期开发,12栋9-11层的法式建筑风格小高层;目前一、二期楼栋已全部封顶,103-105㎡阔绰户型即将面世推售。作为一个“低密度、高绿化”的标杆社区,海澜国际项目将秉承“健康生活,人文生态”的理念,致力打造为学休养一体化的宜居社区。

PROPERTY VIDEOS

楼盘视频

共 2 个
国厦海澜湾B户型样板间实景赏析
国厦海澜湾A2户型样板间实景赏析

PROPERTY ALBUM

楼盘相册

共 17 张
A2户型 主卧独卫
A2户型 主卧独卫样板间图
A2户型 主卧
A2户型 主卧样板间图
A2户型 卧室
A2户型 卧室样板间图
A2户型 卫生间
A2户型 卫生间样板间图
A2户型 入户
A2户型 入户样板间图
A2户型 客厅2
A2户型 客厅2样板间图
A2户型 客厅
A2户型 客厅样板间图
A2户型 次卧
A2户型 次卧样板间图
A2户型 厨房
A2户型 厨房样板间图
A2户型 餐厅
A2户型 餐厅样板间图
区位图
区位图交通图
配套-商业街
配套-商业街配套图
规划图
规划图效果图
效果图2
效果图2效果图
效果图1
效果图1效果图
鸟瞰图
鸟瞰图效果图
交通图
交通图交通图

FLOOR PLANS

户型图

共 4 个户型

PROPERTY SANDBOX

楼盘沙盘

共 5 栋
国厦海澜湾沙盘图
在售待售售罄点击楼栋查看基本信息
楼栋状态单元层数户数梯户比开盘 / 交房
1#在售2个9层34户1梯2户2021-03-28 / 2023-06-30
2#在售2个11层44户1梯2户2021-03-28 / 2023-06-30
3#在售2个11层44户1梯2户2021-03-28 / 2023-06-30
4#在售3个11层66户1梯2户2021-03-28 / 2023-06-30
6#在售2个11层42户1梯2户2021-03-28 / 2023-06-30

PROPERTY NEWS

楼盘动态

国厦海澜湾板式住宅总价约110万元/套起
国厦海澜湾板式住宅总价约110万元/套起

国厦海澜湾项目位于海南省澄迈县老城镇,北二环路以南与美朗路交汇处。楼栋落位均坐北朝南,南北通透,一梯两户,纯板楼构造。

2025-02-18
海口
国厦海澜湾醇熟配套环伺 繁华繁花尽享
国厦海澜湾醇熟配套环伺 繁华繁花尽享

国厦海澜湾项目位于海南省澄迈县老城镇,北二环路以南与美朗路交汇处。楼栋落位均坐北朝南,南北通透,一梯两户,纯板楼构造。

2024-12-31
澄迈
国厦海澜湾南北通透,风与光恣意入室
国厦海澜湾南北通透,风与光恣意入室

国厦海澜湾项目位于海南省澄迈县老城镇,北二环路以南与美朗路交汇处。楼栋落位均坐北朝南,南北通透,一梯两户,纯板楼构造。

2024-10-22
澄迈
国厦海澜湾住宅在售总价约110万元/套起
国厦海澜湾住宅在售总价约110万元/套起

国厦海澜湾项目位于海南省澄迈县老城镇,北二环路以南与美朗路交汇处。楼栋落位均坐北朝南,南北通透,一梯两户,纯板楼构造。

2024-08-12
澄迈
国厦海澜湾一梯两户,享私人静谧
国厦海澜湾一梯两户,享私人静谧

国厦海澜湾项目位于海南省澄迈县老城镇,北二环路以南与美朗路交汇处。楼栋落位均坐北朝南,南北通透,一梯两户,纯板楼构造。

2024-07-25
澄迈
国厦海澜湾双海湾好房在售
国厦海澜湾双海湾好房在售

国厦海澜湾项目位于海南省澄迈县老城镇,北二环路以南与美朗路交汇处。楼栋落位均坐北朝南,南北通透,一梯两户,纯板楼构造。

2024-07-09
澄迈

PROPERTY ADVISORS

专业置业顾问

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

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

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

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

电话咨询
在线问顾问专业顾问 · 快速响应 免费电话咨询获取底价与最新优惠
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-08-20 20:36:29 HTTP/2.0 GET : https://www.doofang.com/loupan/1513
  2. 运行时间 : 0.048739s [ 吞吐率:20.52req/s ] 内存消耗:5,192.27kb 文件加载: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.000344s ] mysql:host=127.0.0.1;port=3306;dbname=www.doofang.com;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `properties` [ RunTime:0.000759s ]
  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` = '1513' OR `p`.`id` = '1513' ) LIMIT 1 [ RunTime:0.000722s ]
  4. SHOW FULL COLUMNS FROM `property_photos` [ RunTime:0.000395s ]
  5. SELECT * FROM `property_photos` WHERE `property_id` = '888' AND `status` = '1' ORDER BY `is_cover` DESC,`sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000354s ]
  6. SHOW FULL COLUMNS FROM `property_floor_plans` [ RunTime:0.000451s ]
  7. SELECT * FROM `property_floor_plans` WHERE `property_id` = '888' AND `status` = '1' ORDER BY `sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000324s ]
  8. SHOW FULL COLUMNS FROM `property_panoramas` [ RunTime:0.000396s ]
  9. SELECT * FROM `property_panoramas` WHERE `property_id` = '888' AND `status` = '1' AND `panorama_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000260s ]
  10. SHOW FULL COLUMNS FROM `property_reviews` [ RunTime:0.000370s ]
  11. SELECT * FROM `property_reviews` WHERE `property_id` = '888' AND `status` = 'published' ORDER BY `sort_order` DESC,`created_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000281s ]
  12. SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000375s ]
  13. SELECT * FROM `property_questions` WHERE `property_id` = '888' AND `status` = 'published' ORDER BY `sort_order` DESC,`asked_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000296s ]
  14. SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.000382s ]
  15. SELECT * FROM `property_promotions` WHERE `property_id` = '888' AND `status` = 'published' ORDER BY `sort_order` DESC,`starts_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000288s ]
  16. SHOW FULL COLUMNS FROM `property_milestones` [ RunTime:0.000365s ]
  17. SELECT * FROM `property_milestones` WHERE `property_id` = '888' AND `status` = '1' ORDER BY `event_date` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000271s ]
  18. SHOW FULL COLUMNS FROM `property_price_histories` [ RunTime:0.000387s ]
  19. SELECT * FROM `property_price_histories` WHERE `property_id` = '888' ORDER BY `recorded_on` ASC,`sort_order` ASC,`id` ASC LIMIT 300 [ RunTime:0.000246s ]
  20. SHOW FULL COLUMNS FROM `property_sandbox_buildings` [ RunTime:0.000421s ]
  21. SELECT * FROM `property_sandbox_buildings` WHERE `property_id` = '888' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC LIMIT 500 [ RunTime:0.000304s ]
  22. SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.000393s ]
  23. SELECT COUNT(*) AS think_count FROM `property_videos` WHERE `property_id` = '888' AND `status` = '1' AND `video_url` <> '' [ RunTime:0.000246s ]
  24. SELECT * FROM `property_videos` WHERE `property_id` = '888' AND `status` = '1' AND `video_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 4 [ RunTime:0.000270s ]
  25. SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000446s ]
  26. 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` = '888' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.000718s ]
  27. SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000386s ]
  28. SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000234s ]
  29. SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.000388s ]
  30. SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 3 [ RunTime:0.000310s ]
  31. SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000397s ]
  32. 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 20:36:29' ) [ RunTime:0.000226s ]
  33. SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000372s ]
  34. SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000218s ]
  35. SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000346s ]
  36. SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000215s ]
  37. SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000332s ]
  38. SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000384s ]
  39. SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000227s ]
  40. SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000375s ]
  41. SELECT * FROM `third_party_integrations` WHERE `site_id` = '1' AND `integration_type` = 'customer_service' AND `provider` = '53kf' AND `enabled` = '1' LIMIT 1 [ RunTime:0.000265s ]
0.049319s