海口湾玉府

海口 · 海口市龙华区海口湾邻近万绿园

待售
参考均价30000.00元/㎡获取最新报价
主力户型
暂无资料
物业类型
高层
装修情况
毛坯,
开盘时间
2021-11-02
交房时间
2023-06-30
开发商
海南昌炜集团有限公司
最新优惠与可售房源

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

电话咨询

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

楼盘信息

信息更新时间:2026-08-11
楼盘名称
海口湾玉府
所属区域
海口
参考均价
30000.00 元/㎡
产权年限
70年
容积率
1.9
绿化率
40%
物业公司
世邦魏理仕
物业费
4元/㎡·月
停车位
632个
售楼地址
海口市龙华区海口湾邻近万绿园

项目介绍

海口湾玉府东起万绿园,西至秀英港,是呈半目合的后住海湾,形似一个的环礁湖项目北琼州海峡,拥有城市海景资源。交通四通八达,从滨海大道、丘海大道、海秀快速路等城市主千道可以通往海口市区各个地方。

PROPERTY VIDEOS

楼盘视频

共 1 个
海口湾玉府楼盘视频

PROPERTY ALBUM

楼盘相册

共 25 张
样板间8
样板间8样板间图
样板间7
样板间7样板间图
样板间6
样板间6样板间图
样板间5
样板间5样板间图
样板间4
样板间4样板间图
样板间3
样板间3样板间图
样板间2
样板间2样板间图
样板间1
样板间1样板间图
效果图4
效果图4效果图
效果图3
效果图3效果图
效果图2
效果图2效果图
效果图1
效果图1效果图
实景图6
实景图6实景图
实景图5
实景图5实景图
实景图4
实景图4实景图
实景图3
实景图3实景图
实景图2
实景图2实景图
实景图1
实景图1实景图
配套图学校操场
配套图学校操场配套图
配套图-学校
配套图-学校配套图
配套图-世纪大桥
配套图-世纪大桥配套图
配套图-白沙门
配套图-白沙门配套图
配套图2
配套图2配套图
鸟瞰图
鸟瞰图效果图
交通图
交通图交通图

FLOOR PLANS

户型图

共 5 个户型

PROPERTY SANDBOX

楼盘沙盘

海口湾玉府沙盘图

PROPERTY NEWS

楼盘动态

海口湾玉府主力户型建筑面积有107㎡-442㎡住宅
海口湾玉府主力户型建筑面积有107㎡-442㎡住宅

海口湾玉府是昌炜集团在海口湾开发打造的住宅项目,项目地处海口湾世贸北路19号。海口玉湾北瞰海口湾,东临万绿园,西接西海岸、假日海滩等旅游度假区,周边路网四通八达,生活配套完善,区域发展大,自住两相宜。

2022-04-22
海口
海口湾玉府预计2023年6月30日A#交房
海口湾玉府预计2023年6月30日A#交房

海口湾玉府是昌炜集团在海口湾开发打造的住宅项目,项目地处海口湾世贸北路19号。海口玉湾北瞰海口湾,东临万绿园,西接西海岸、假日海滩等旅游度假区,周边路网四通八达,生活配套完善,区域发展大,自住两相宜。

2022-04-15
海口
海口湾玉府品质大宅阅享生活
海口湾玉府品质大宅阅享生活

海口湾玉府是昌炜集团在海口湾开发打造的住宅项目,项目地处海口湾世贸北路19号。海口玉湾北瞰海口湾,东临万绿园,西接西海岸、假日海滩等旅游度假区,周边路网四通八达,生活配套完善,区域发展大,自住两相宜。

2022-03-25
海口
海口湾玉府每幢高层均由四个仿若半岛的板块构成
海口湾玉府每幢高层均由四个仿若半岛的板块构成

海口湾玉府是昌炜集团在海口湾开发打造的住宅项目,项目地处海口湾世贸北路19号。海口玉湾北瞰海口湾,东临万绿园,西接西海岸、假日海滩等旅游度假区,周边路网四通八达,生活配套完善,区域发展大,自住两相宜。

2022-02-16
海口
海口湾玉府,与你邂逅城湾醉美风景
海口湾玉府,与你邂逅城湾醉美风景

海口湾玉府是昌炜集团在海口湾开发打造的住宅项目,项目地处海口湾世贸北路19号。海口玉湾北瞰海口湾,东临万绿园,西接西海岸、假日海滩等旅游度假区,周边路网四通八达,生活配套完善,区域发展大,自住两相宜。

2022-02-15
海口
海口湾玉府海景大宅诗意雅居,均价17200元/㎡
海口湾玉府海景大宅诗意雅居,均价17200元/㎡

海口湾玉府是昌炜集团在海口湾开发打造的住宅项目,项目地处海口湾世贸北路19号。海口玉湾北瞰海口湾,东临万绿园,西接西海岸、假日海滩等旅游度假区,周边路网四通八达,生活配套完善,区域发展大,自住两相宜。

2022-01-11
海口

PROPERTY ADVISORS

专业置业顾问

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

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

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

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

电话咨询
在线问顾问专业顾问 · 快速响应 免费电话咨询获取底价与最新优惠
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-08-20 19:43:06 HTTP/2.0 GET : https://www.doofang.com/loupan/1464
  2. 运行时间 : 0.048949s [ 吞吐率:20.43req/s ] 内存消耗:5,196.39kb 文件加载: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.000294s ] mysql:host=127.0.0.1;port=3306;dbname=www.doofang.com;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `properties` [ RunTime:0.000718s ]
  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` = '1464' OR `p`.`id` = '1464' ) LIMIT 1 [ RunTime:0.000708s ]
  4. SHOW FULL COLUMNS FROM `property_photos` [ RunTime:0.000401s ]
  5. SELECT * FROM `property_photos` WHERE `property_id` = '843' AND `status` = '1' ORDER BY `is_cover` DESC,`sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000386s ]
  6. SHOW FULL COLUMNS FROM `property_floor_plans` [ RunTime:0.000462s ]
  7. SELECT * FROM `property_floor_plans` WHERE `property_id` = '843' AND `status` = '1' ORDER BY `sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000352s ]
  8. SHOW FULL COLUMNS FROM `property_panoramas` [ RunTime:0.000388s ]
  9. SELECT * FROM `property_panoramas` WHERE `property_id` = '843' AND `status` = '1' AND `panorama_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000264s ]
  10. SHOW FULL COLUMNS FROM `property_reviews` [ RunTime:0.000403s ]
  11. SELECT * FROM `property_reviews` WHERE `property_id` = '843' AND `status` = 'published' ORDER BY `sort_order` DESC,`created_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000303s ]
  12. SHOW FULL COLUMNS FROM `property_review_replies` [ RunTime:0.000368s ]
  13. SELECT * FROM `property_review_replies` WHERE `review_id` IN ('1258','1259') AND `status` = 'published' ORDER BY `created_at` ASC,`id` ASC [ RunTime:0.000247s ]
  14. SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000398s ]
  15. SELECT * FROM `property_questions` WHERE `property_id` = '843' AND `status` = 'published' ORDER BY `sort_order` DESC,`asked_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000308s ]
  16. SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.000387s ]
  17. SELECT * FROM `property_promotions` WHERE `property_id` = '843' AND `status` = 'published' ORDER BY `sort_order` DESC,`starts_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000297s ]
  18. SHOW FULL COLUMNS FROM `property_milestones` [ RunTime:0.000381s ]
  19. SELECT * FROM `property_milestones` WHERE `property_id` = '843' AND `status` = '1' ORDER BY `event_date` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000291s ]
  20. SHOW FULL COLUMNS FROM `property_price_histories` [ RunTime:0.000378s ]
  21. SELECT * FROM `property_price_histories` WHERE `property_id` = '843' ORDER BY `recorded_on` ASC,`sort_order` ASC,`id` ASC LIMIT 300 [ RunTime:0.000265s ]
  22. SHOW FULL COLUMNS FROM `property_sandbox_buildings` [ RunTime:0.000413s ]
  23. SELECT * FROM `property_sandbox_buildings` WHERE `property_id` = '843' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC LIMIT 500 [ RunTime:0.000267s ]
  24. SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.000391s ]
  25. SELECT COUNT(*) AS think_count FROM `property_videos` WHERE `property_id` = '843' AND `status` = '1' AND `video_url` <> '' [ RunTime:0.000230s ]
  26. SELECT * FROM `property_videos` WHERE `property_id` = '843' AND `status` = '1' AND `video_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 4 [ RunTime:0.000268s ]
  27. SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000433s ]
  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` = '843' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.000529s ]
  29. SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000373s ]
  30. SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000237s ]
  31. SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.000388s ]
  32. SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 3 [ RunTime:0.000310s ]
  33. SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000394s ]
  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:06' ) [ RunTime:0.000228s ]
  35. SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000370s ]
  36. SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000219s ]
  37. SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000360s ]
  38. SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000216s ]
  39. SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000342s ]
  40. SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000385s ]
  41. SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000229s ]
  42. SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000377s ]
  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.000262s ]
0.049522s