Request to reduce SQL query count for homepage posts.

### Prerequisites

- [x] I have searched for related issues in the [Issues](https://github.com/halo-dev/halo/issues) list.
- [x] This is a feature related to Halo. If it is not an issue with the project itself, it is recommended to submit it in the [Discussions](https://github.com/halo-dev/halo/discussions).
- [x] If it is a feature suggestion for plugins and themes, please submit it in the respective plugin and theme repositories.

### Your current Halo version

2.21.1

### Describe this feature

From the logs, it appears that each post query generates several user queries, presumably to fetch contributors and authors for each post. Is it possible to optimize this by using indexes to merge user queries?

```log
2025-06-25T17:26:14.185+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c8ee1661-3976] HTTP GET "/"
2025-06-25T17:26:14.189+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.189+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.190+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.w.r.f.s.s.RouterFunctionMapping      : [c8ee1661-3976] Mapped to run.halo.app.theme.router.factories.IndexRouteFactory$$Lambda/0x00007f7950d38a88@4e35a5f1
2025-06-25T17:26:14.191+08:00 DEBUG 587893 --- [r-http-epoll-21] r.h.app.theme.HaloViewResolver$HaloView  : [c8ee1661-3976] View name 'index', model {_templateId=index, posts=MonoMapFuseable, thymeleafWebSession=MonoCacheTime, thymeleafWebExchangePrincipal=MonoMapFuseable, _csrf=MonoPeekTerminal, thymeleafSpringSecurityContext=MonoDefaultIfEmpty}
2025-06-25T17:26:14.193+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.NAME, extensions.DATA, extensions.VERSION FROM extensions WHERE extensions.NAME IN ($1, $2, $3, $4, $5)]
2025-06-25T17:26:14.194+08:00 DEBUG 587893 --- [r-http-epoll-21] r.h.a.e.ReactiveExtensionClientImpl      : Successfully retrieved by names from db for content.halo.run/v1alpha1/Post in 2ms
2025-06-25T17:26:14.194+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.194+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.195+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.196+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.197+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.197+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.198+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.198+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.198+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.199+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.199+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.200+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.200+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.201+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.201+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.202+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.202+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.202+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.203+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.203+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.203+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.203+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.203+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.203+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.203+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.204+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.204+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.204+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.204+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.204+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.205+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.205+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.205+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.205+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.215+08:00 DEBUG 587893 --- [ndedElastic-451] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.NAME, extensions.DATA, extensions.VERSION FROM extensions WHERE extensions.NAME LIKE $1]
2025-06-25T17:26:14.217+08:00 DEBUG 587893 --- [ndedElastic-451] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.NAME, extensions.DATA, extensions.VERSION FROM extensions WHERE extensions.NAME LIKE $1]
2025-06-25T17:26:14.220+08:00 DEBUG 587893 --- [ndedElastic-451] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.220+08:00 DEBUG 587893 --- [ndedElastic-451] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.226+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.NAME, extensions.DATA, extensions.VERSION FROM extensions WHERE extensions.NAME IN ($1, $2)]
2025-06-25T17:26:14.227+08:00 DEBUG 587893 --- [ndedElastic-452] r.h.a.e.ReactiveExtensionClientImpl      : Successfully retrieved all by names from db for content.halo.run/v1alpha1/Category in 1ms
2025-06-25T17:26:14.242+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.NAME, extensions.DATA, extensions.VERSION FROM extensions WHERE extensions.NAME IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)]
2025-06-25T17:26:14.243+08:00 DEBUG 587893 --- [ndedElastic-452] r.h.a.e.ReactiveExtensionClientImpl      : Successfully retrieved by names from db for content.halo.run/v1alpha1/Post in 1ms
2025-06-25T17:26:14.243+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.244+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.245+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.246+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.247+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.248+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.s.adapter.HttpWebHandlerAdapter    : [46d1885d-3977] HTTP GET "/themes/theme-earth/assets/dist/style.css?v=1.12.4"
2025-06-25T17:26:14.248+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3978] HTTP GET "/upload/36231701247141_.pic.jpg"
2025-06-25T17:26:14.248+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.248+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.249+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.r.handler.SimpleUrlHandlerMapping  : [46d1885d-3977] Mapped to ResourceWebHandler []
2025-06-25T17:26:14.249+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.h.codec.ResourceHttpMessageWriter    : [46d1885d-3977] Zero-copy [file [/home/johnniang/halo2-dev/themes/theme-earth/templates/assets/dist/style.css]]
2025-06-25T17:26:14.249+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.250+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.250+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.251+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.251+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.252+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.252+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.252+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.253+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.253+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.253+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.254+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.254+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.254+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.254+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.254+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.255+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.255+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.s.adapter.HttpWebHandlerAdapter    : [46d1885d-3977] Completed 200 OK
2025-06-25T17:26:14.255+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.255+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.s.adapter.HttpWebHandlerAdapter    : [46d1885d-3979] HTTP GET "/plugins/editor-hyperlink-card/assets/static/hyperlink-card.iife.js?version=1.0.3"
2025-06-25T17:26:14.255+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3980] HTTP GET "/plugins/PluginCommentWidget/assets/static/style.css?version=2.6.0"
2025-06-25T17:26:14.255+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.w.s.adapter.HttpWebHandlerAdapter    : [39fc5672-3981] HTTP GET "/themes/theme-earth/assets/dist/main.iife.js?v=1.12.4"
2025-06-25T17:26:14.255+08:00 DEBUG 587893 --- [or-http-epoll-3] o.s.w.s.adapter.HttpWebHandlerAdapter    : [746630ed-3982] HTTP GET "/plugins/PluginCommentWidget/assets/static/comment-widget.iife.js?version=2.6.0"
2025-06-25T17:26:14.256+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.256+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.256+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.r.f.s.s.RouterFunctionMapping      : [46d1885d-3979] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@791b79a0
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-3] o.s.w.r.f.s.s.RouterFunctionMapping      : [746630ed-3982] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@3054cd3e
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.r.f.s.s.RouterFunctionMapping      : [c42201b7-3980] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@7279f617
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.w.r.handler.SimpleUrlHandlerMapping  : [39fc5672-3981] Mapped to ResourceWebHandler []
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.h.codec.ResourceHttpMessageWriter    : [46d1885d-3979] Resource associated with 'text/javascript'
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-3] o.s.h.codec.ResourceHttpMessageWriter    : [746630ed-3982] Resource associated with 'text/javascript'
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.h.codec.ResourceHttpMessageWriter    : [c42201b7-3980] Resource associated with 'text/css'
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.h.codec.ResourceHttpMessageWriter    : [39fc5672-3981] Zero-copy [file [/home/johnniang/halo2-dev/themes/theme-earth/templates/assets/dist/main.iife.js]]
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [ndedElastic-458] o.s.core.codec.ResourceEncoder           : [c42201b7-3980] Writing [class path resource [static/style.css]]
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [ndedElastic-456] o.s.core.codec.ResourceEncoder           : [46d1885d-3979] Writing [class path resource [static/hyperlink-card.iife.js]]
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [ndedElastic-457] o.s.core.codec.ResourceEncoder           : [746630ed-3982] Writing [class path resource [static/comment-widget.iife.js]]
2025-06-25T17:26:14.257+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.258+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.258+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.258+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3980] Completed 200 OK
2025-06-25T17:26:14.258+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.259+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.259+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.259+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3983] HTTP GET "/plugins/editor-hyperlink-card/assets/static/var.css?version=1.0.3"
2025-06-25T17:26:14.259+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.259+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.259+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.s.adapter.HttpWebHandlerAdapter    : [46d1885d-3979] Completed 200 OK
2025-06-25T17:26:14.259+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.260+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.260+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.s.adapter.HttpWebHandlerAdapter    : [46d1885d-3984] HTTP GET "/plugins/PluginSearchWidget/assets/static/search-widget.iife.js?version=1.7.0"
2025-06-25T17:26:14.260+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.260+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.r.f.s.s.RouterFunctionMapping      : [46d1885d-3984] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@19339697
2025-06-25T17:26:14.260+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.r.f.s.s.RouterFunctionMapping      : [c42201b7-3983] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@42e5af1d
2025-06-25T17:26:14.260+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.261+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.h.codec.ResourceHttpMessageWriter    : [46d1885d-3984] Resource associated with 'text/javascript'
2025-06-25T17:26:14.261+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.h.codec.ResourceHttpMessageWriter    : [c42201b7-3983] Resource associated with 'text/css'
2025-06-25T17:26:14.261+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.261+08:00 DEBUG 587893 --- [ndedElastic-464] o.s.core.codec.ResourceEncoder           : [c42201b7-3983] Writing [class path resource [static/var.css]]
2025-06-25T17:26:14.261+08:00 DEBUG 587893 --- [ndedElastic-465] o.s.core.codec.ResourceEncoder           : [46d1885d-3984] Writing [class path resource [static/search-widget.iife.js]]
2025-06-25T17:26:14.261+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.w.r.handler.SimpleUrlHandlerMapping  : [9038c949-3978] Mapped to ResourceWebHandler [URL [file:/home/johnniang/halo2-dev/attachments/upload/], URL [file:/home/johnniang/halo2-dev/attachments/migrate-from-1.x/]]
2025-06-25T17:26:14.261+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3983] Completed 200 OK
2025-06-25T17:26:14.262+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.h.codec.ResourceHttpMessageWriter    : [9038c949-3978] Zero-copy [URL [file:/home/johnniang/halo2-dev/attachments/upload/36231701247141_.pic.jpg]]
2025-06-25T17:26:14.262+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3985] HTTP GET "/plugins/PluginSearchWidget/assets/static/style.css?version=1.7.0"
2025-06-25T17:26:14.262+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.262+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3978] Completed 200 OK
2025-06-25T17:26:14.262+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.262+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3986] HTTP GET "/plugins/footprint/assets/static/css/footprint.css?version=1.0.0"
2025-06-25T17:26:14.262+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.r.f.s.s.RouterFunctionMapping      : [c42201b7-3985] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@3ed788f7
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.r.f.s.s.RouterFunctionMapping      : [9038c949-3986] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@6f22fe47
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.h.codec.ResourceHttpMessageWriter    : [9038c949-3986] Resource associated with 'text/css'
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.263+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.h.codec.ResourceHttpMessageWriter    : [c42201b7-3985] Resource associated with 'text/css'
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [ndedElastic-470] o.s.core.codec.ResourceEncoder           : [c42201b7-3985] Writing [class path resource [static/style.css]]
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [ndedElastic-471] o.s.core.codec.ResourceEncoder           : [9038c949-3986] Writing [class path resource [static/css/footprint.css]]
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.w.s.adapter.HttpWebHandlerAdapter    : [39fc5672-3981] Completed 200 OK
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3985] Completed 200 OK
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.w.s.adapter.HttpWebHandlerAdapter    : [39fc5672-3987] HTTP GET "/plugins/footprint/assets/static/font/result.css?version=1.0.0"
2025-06-25T17:26:14.264+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3988] HTTP GET "/plugins/footprint/assets/static/js/footprint.js?version=1.0.0"
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [or-http-epoll-1] o.s.w.s.adapter.HttpWebHandlerAdapter    : [46d1885d-3984] Completed 200 OK
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [or-http-epoll-3] o.s.w.s.adapter.HttpWebHandlerAdapter    : [746630ed-3982] Completed 200 OK
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3986] Completed 200 OK
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.r.f.s.s.RouterFunctionMapping      : [c42201b7-3988] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@277ff7d7
2025-06-25T17:26:14.265+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.w.r.f.s.s.RouterFunctionMapping      : [39fc5672-3987] Mapped to run.halo.app.plugin.DefaultPluginRouterFunctionRegistry$$Lambda/0x00007f7951066668@5e7159fb
2025-06-25T17:26:14.266+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT users.* FROM users WHERE users.ID = $1 LIMIT 2]
2025-06-25T17:26:14.266+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.h.codec.ResourceHttpMessageWriter    : [c42201b7-3988] Resource associated with 'text/javascript'
2025-06-25T17:26:14.266+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.h.codec.ResourceHttpMessageWriter    : [39fc5672-3987] Resource associated with 'text/css'
2025-06-25T17:26:14.266+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT labels.ID, labels.ENTITY_TYPE, labels.ENTITY_ID, labels.LABEL_NAME, labels.LABEL_VALUE FROM labels WHERE labels.ENTITY_TYPE = $1 AND (labels.ENTITY_ID = $2)]
2025-06-25T17:26:14.266+08:00 DEBUG 587893 --- [ndedElastic-476] o.s.core.codec.ResourceEncoder           : [c42201b7-3988] Writing [class path resource [static/js/footprint.js]]
2025-06-25T17:26:14.266+08:00 DEBUG 587893 --- [ndedElastic-477] o.s.core.codec.ResourceEncoder           : [39fc5672-3987] Writing [class path resource [static/font/result.css]]
2025-06-25T17:26:14.266+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.267+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.267+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.267+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.268+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.268+08:00 DEBUG 587893 --- [or-http-epoll-4] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c42201b7-3988] Completed 200 OK
2025-06-25T17:26:14.268+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:14.272+08:00 DEBUG 587893 --- [or-http-epoll-2] o.s.w.s.adapter.HttpWebHandlerAdapter    : [39fc5672-3987] Completed 200 OK
2025-06-25T17:26:14.272+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.NAME, extensions.DATA, extensions.VERSION FROM extensions WHERE extensions.NAME IN ($1, $2)]
2025-06-25T17:26:14.272+08:00 DEBUG 587893 --- [ndedElastic-452] r.h.a.e.ReactiveExtensionClientImpl      : Successfully retrieved all by names from db for content.halo.run/v1alpha1/Category in 1ms
2025-06-25T17:26:14.275+08:00 DEBUG 587893 --- [ndedElastic-452] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.NAME, extensions.DATA, extensions.VERSION FROM extensions WHERE extensions.NAME IN ($1, $2)]
2025-06-25T17:26:14.275+08:00 DEBUG 587893 --- [ndedElastic-452] r.h.a.e.ReactiveExtensionClientImpl      : Successfully retrieved by names from db for content.halo.run/v1alpha1/Tag in 0ms
2025-06-25T17:26:14.278+08:00 DEBUG 587893 --- [r-http-epoll-21] o.s.w.s.adapter.HttpWebHandlerAdapter    : [c8ee1661-3976] Completed 200 OK
2025-06-25T17:26:14.287+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3989] HTTP GET "/themes/theme-earth/assets/images/default-avatar.svg"
2025-06-25T17:26:14.289+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.r.handler.SimpleUrlHandlerMapping  : [9038c949-3989] Mapped to ResourceWebHandler []
2025-06-25T17:26:14.290+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.h.codec.ResourceHttpMessageWriter    : [9038c949-3989] Zero-copy [file [/home/johnniang/halo2-dev/themes/theme-earth/templates/assets/images/default-avatar.svg]]
2025-06-25T17:26:14.291+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3989] Completed 200 OK
2025-06-25T17:26:14.305+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3990] HTTP GET "/themes/theme-earth/assets/images/default-background.png"
2025-06-25T17:26:14.307+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.r.handler.SimpleUrlHandlerMapping  : [9038c949-3990] Mapped to ResourceWebHandler []
2025-06-25T17:26:14.308+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.h.codec.ResourceHttpMessageWriter    : [9038c949-3990] Zero-copy [file [/home/johnniang/halo2-dev/themes/theme-earth/templates/assets/images/default-background.png]]
2025-06-25T17:26:14.308+08:00 DEBUG 587893 --- [r-http-epoll-22] o.s.w.s.adapter.HttpWebHandlerAdapter    : [9038c949-3990] Completed 200 OK
2025-06-25T17:26:16.184+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.extension.controller.DefaultQueue  : Take request Request[name=c4c814d1-0c2c-456b-8c96-4864965fee94] at 2025-06-25T09:26:16.184800401Z
2025-06-25T17:26:16.184+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.e.controller.DefaultController     : run.halo.app.core.reconciler.MenuItemReconciler-worker-1 >>> Reconciling request Request[name=c4c814d1-0c2c-456b-8c96-4864965fee94] at 2025-06-25T09:26:16.184917335Z
2025-06-25T17:26:16.185+08:00 DEBUG 587893 --- [temReconciler-1] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:16.186+08:00 DEBUG 587893 --- [temReconciler-1] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:16.186+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.e.controller.DefaultController     : run.halo.app.core.reconciler.MenuItemReconciler-worker-1 >>> Reconciled request: Request[name=c4c814d1-0c2c-456b-8c96-4864965fee94] with result: Result[reEnqueue=true, retryAfter=PT1M], usage: 1
2025-06-25T17:26:16.186+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.extension.controller.DefaultQueue  : Adding request Request[name=c4c814d1-0c2c-456b-8c96-4864965fee94] after PT1M
2025-06-25T17:26:16.186+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.extension.controller.DefaultQueue  : Added request Request[name=c4c814d1-0c2c-456b-8c96-4864965fee94] after PT1M
2025-06-25T17:26:16.307+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.extension.controller.DefaultQueue  : Take request Request[name=35869bd3-33b5-448b-91ee-cf6517a59644] at 2025-06-25T09:26:16.307625449Z
2025-06-25T17:26:16.307+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.e.controller.DefaultController     : run.halo.app.core.reconciler.MenuItemReconciler-worker-1 >>> Reconciling request Request[name=35869bd3-33b5-448b-91ee-cf6517a59644] at 2025-06-25T09:26:16.307703769Z
2025-06-25T17:26:16.308+08:00 DEBUG 587893 --- [temReconciler-1] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:16.308+08:00 DEBUG 587893 --- [temReconciler-1] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:16.308+08:00 DEBUG 587893 --- [temReconciler-1] o.s.r2dbc.core.DefaultDatabaseClient     : Executing SQL statement [SELECT extensions.* FROM extensions WHERE extensions.NAME = $1 LIMIT 2]
2025-06-25T17:26:16.308+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.e.controller.DefaultController     : run.halo.app.core.reconciler.MenuItemReconciler-worker-1 >>> Reconciled request: Request[name=35869bd3-33b5-448b-91ee-cf6517a59644] with result: Result[reEnqueue=true, retryAfter=PT1M], usage: 1
2025-06-25T17:26:16.308+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.extension.controller.DefaultQueue  : Adding request Request[name=35869bd3-33b5-448b-91ee-cf6517a59644] after PT1M
2025-06-25T17:26:16.308+08:00 DEBUG 587893 --- [temReconciler-1] r.h.a.extension.controller.DefaultQueue  : Added request Request[name=35869bd3-33b5-448b-91ee-cf6517a59644] after PT1M
```

### Additional information

_No response_

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

Request to reduce SQL query count for homepage posts. #7593

Prerequisites

Your current Halo version

Describe this feature

Additional information

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Uh oh!

Request to reduce SQL query count for homepage posts. #7593

Description

Prerequisites

Your current Halo version

Describe this feature

Additional information

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions