汇元江海汇

琼山区 · 海南省海口市琼州大道

在售
参考均价23000.00元/㎡获取最新报价
主力户型
暂无资料
物业类型
板楼 多层
装修情况
毛坯,
开盘时间
待定
交房时间
2022-06-30
开发商
海南江海汇实业有限公司
最新优惠与可售房源

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

电话咨询

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

楼盘信息

信息更新时间:2026-08-11
楼盘名称
汇元江海汇
所属区域
琼山区
参考均价
23000.00 元/㎡
产权年限
普通住宅:70年花园洋房:70年
容积率
1.00
绿化率
40%
物业公司
汇民物业
物业费
暂无资料
停车位
待完善
售楼地址
海南省海口市琼州大道8

项目介绍

汇元·江海汇位于海口市东海岸江东组团龙头位置,由新东大桥、琼州大桥及在建设中的海美大桥三座大桥形成交通网络,从项目出发沿琼山大道经琼州大桥即可到达国兴商圈,这里的生活医疗教育市政配套齐全。
汇元·江海汇可以说是出则繁华入则宁静的世外桃源,项目总占地面积28亩,总建筑面积25455.44㎡,容积率1.0打造高舒适度的品质社区,绿化40%,小区一共由6栋6层高的纯板式洋房组成,总户数147总车位157是1:1.2的比例,地上83个地下74个。
主要户型建面约95㎡的两房两厅两卫; 建面约164㎡的三房两厅三卫(跃层);建面约171㎡的三房两厅两卫(跃层);建面约172㎡的三房两厅三卫(跃层)。
小区采用地中海风格园林景观一步一景,建筑风格为现代风格,项目精装修交付,装修标准做到精益求精的品质。小区内设有无边际泳池,小孩的游乐中心,健身器材等,让您足不出户就能享受到娱乐设施设备。

PROPERTY VIDEOS

楼盘视频

共 2 个
汇元江海汇洋房A户型样板间实景拍摄
汇元江海汇C户型样板间实景拍摄

PROPERTY ALBUM

楼盘相册

共 18 张
样板间图5
样板间图5样板间图
样板间图4
样板间图4样板间图
样板间图3
样板间图3样板间图
样板间图2
样板间图2样板间图
样板间图1
样板间图1样板间图
周边配套图
周边配套图配套图
周边配套
周边配套配套图
周边酒店
周边酒店配套图
周边海鲜大世界
周边海鲜大世界配套图
区位图
区位图交通图
鸟瞰图
鸟瞰图效果图
楼栋效果图
楼栋效果图效果图
楼栋平面分布图
楼栋平面分布图效果图
售楼处实景
售楼处实景实景图
沙盘图
沙盘图实景图
沙盘图 (4)
沙盘图 (4)实景图
沙盘图 (3)
沙盘图 (3)实景图
沙盘图 (2)
沙盘图 (2)实景图

FLOOR PLANS

户型图

共 4 个户型

PROPERTY SANDBOX

楼盘沙盘

共 6 栋
汇元江海汇沙盘图
在售待售售罄点击楼栋查看基本信息
楼栋状态单元层数户数梯户比开盘 / 交房
1#在售1个6层20户2梯4户待定 / 待定
2#在售1个6层20户2梯4户待定 / 待定
3#在售1个6层20户2梯4户待定 / 待定
4#在售1个6层20户2梯4户待定 / 待定
5#在售1个6层20户2梯4户待定 / 待定
6#在售1个6层47户2梯10户待定 / 待定

PROPERTY NEWS

楼盘动态

汇元江海汇在售户型建面约95㎡-172㎡
汇元江海汇在售户型建面约95㎡-172㎡

汇元江海汇位于海口市东海岸江东组团位置,占地面积28亩,总栋数6栋,总户数147户。

2025-02-13
海口
汇元江海汇一梯两户
汇元江海汇一梯两户

汇元江海汇位于海口市东海岸江东组团位置,占地面积28亩,总栋数6栋,总户数147户

2025-01-04
海口
汇元江海汇住宅总价约300万元/套起
汇元江海汇住宅总价约300万元/套起

汇元江海汇位于海口市东海岸江东组团位置,占地面积28亩,总栋数6栋,总户数147户。

2024-12-08
海口
汇元江海汇住宅在售总价约300-500万元/套
汇元江海汇住宅在售总价约300-500万元/套

汇元江海汇位于海口市东海岸江东组团位置,项目由6幢建筑组成,规划户数为147户。构筑了一个高净值人群生态住区。

2024-11-06
海口
汇元江海汇主力在售滨海复式洋房
汇元江海汇主力在售滨海复式洋房

汇元江海汇位于海口市东海岸江东组团位置,项目由6幢建筑组成,规划户数为147户。构筑了一个高净值人群生态住区。

2024-09-23
海口
汇元江海汇住宅在售总价约300万元/套起
汇元江海汇住宅在售总价约300万元/套起

汇元江海汇位于海口市东海岸江东组团位置,项目由6幢建筑组成,规划户数为147户。构筑了一个高净值人群生态住区。

2024-09-02
海口

PROPERTY ADVISORS

专业置业顾问

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

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

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

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

电话咨询
在线问顾问专业顾问 · 快速响应 免费电话咨询获取底价与最新优惠
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-08-20 19:21:35 HTTP/2.0 GET : https://www.doofang.com/loupan/153
  2. 运行时间 : 0.215820s [ 吞吐率:4.63req/s ] 内存消耗:5,208.36kb 文件加载: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.016251s ] mysql:host=127.0.0.1;port=3306;dbname=www.doofang.com;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `properties` [ RunTime:0.008685s ]
  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` = '153' OR `p`.`id` = '153' ) LIMIT 1 [ RunTime:0.001395s ]
  4. SHOW FULL COLUMNS FROM `property_photos` [ RunTime:0.000616s ]
  5. SELECT * FROM `property_photos` WHERE `property_id` = '111' AND `status` = '1' ORDER BY `is_cover` DESC,`sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000499s ]
  6. SHOW FULL COLUMNS FROM `property_floor_plans` [ RunTime:0.000707s ]
  7. SELECT * FROM `property_floor_plans` WHERE `property_id` = '111' AND `status` = '1' ORDER BY `sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000477s ]
  8. SHOW FULL COLUMNS FROM `property_panoramas` [ RunTime:0.000570s ]
  9. SELECT * FROM `property_panoramas` WHERE `property_id` = '111' AND `status` = '1' AND `panorama_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000381s ]
  10. SHOW FULL COLUMNS FROM `property_reviews` [ RunTime:0.000586s ]
  11. SELECT * FROM `property_reviews` WHERE `property_id` = '111' AND `status` = 'published' ORDER BY `sort_order` DESC,`created_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000651s ]
  12. SHOW FULL COLUMNS FROM `property_review_replies` [ RunTime:0.001462s ]
  13. SELECT * FROM `property_review_replies` WHERE `review_id` IN ('481','480','479') AND `status` = 'published' ORDER BY `created_at` ASC,`id` ASC [ RunTime:0.000350s ]
  14. SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000609s ]
  15. SELECT * FROM `property_questions` WHERE `property_id` = '111' AND `status` = 'published' ORDER BY `sort_order` DESC,`asked_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000463s ]
  16. SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.000619s ]
  17. SELECT * FROM `property_promotions` WHERE `property_id` = '111' 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.000555s ]
  19. SELECT * FROM `property_milestones` WHERE `property_id` = '111' AND `status` = '1' ORDER BY `event_date` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000369s ]
  20. SHOW FULL COLUMNS FROM `property_price_histories` [ RunTime:0.000576s ]
  21. SELECT * FROM `property_price_histories` WHERE `property_id` = '111' ORDER BY `recorded_on` ASC,`sort_order` ASC,`id` ASC LIMIT 300 [ RunTime:0.001689s ]
  22. SHOW FULL COLUMNS FROM `property_sandbox_buildings` [ RunTime:0.001318s ]
  23. SELECT * FROM `property_sandbox_buildings` WHERE `property_id` = '111' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC LIMIT 500 [ RunTime:0.001134s ]
  24. SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.002046s ]
  25. SELECT COUNT(*) AS think_count FROM `property_videos` WHERE `property_id` = '111' AND `status` = '1' AND `video_url` <> '' [ RunTime:0.001032s ]
  26. SELECT * FROM `property_videos` WHERE `property_id` = '111' AND `status` = '1' AND `video_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 4 [ RunTime:0.001084s ]
  27. SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.001201s ]
  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` = '111' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.001563s ]
  29. SHOW FULL COLUMNS FROM `regions` [ RunTime:0.001165s ]
  30. SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000926s ]
  31. SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.001078s ]
  32. SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 3 [ RunTime:0.001108s ]
  33. SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.001181s ]
  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:21:35' ) [ RunTime:0.000959s ]
  35. SHOW FULL COLUMNS FROM `sites` [ RunTime:0.001160s ]
  36. SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000941s ]
  37. SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.001093s ]
  38. SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000932s ]
  39. SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000987s ]
  40. SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.001244s ]
  41. SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000931s ]
  42. SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.001199s ]
  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.000791s ]
0.216781s