. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.0) 2026-03-30T02:55:40.995+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] c.s.admin.StarPavilionAdminApplication : Starting StarPavilionAdminApplication v1.0.0 using Java 17.0.18 with PID 3497958 (/root/20260328091842_20260330024322/StarPavilionAdmin/target/admin-1.0.0.jar started by root in /root/20260328091842_20260330024322/StarPavilionAdmin) 2026-03-30T02:55:41.000+08:00 DEBUG 3497958 --- [star-pavilion-admin] [ main] c.s.admin.StarPavilionAdminApplication : Running with Spring Boot v3.2.0, Spring v6.1.1 2026-03-30T02:55:41.001+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] c.s.admin.StarPavilionAdminApplication : No active profile set, falling back to 1 default profile: "default" 2026-03-30T02:55:42.540+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode 2026-03-30T02:55:42.542+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2026-03-30T02:55:42.790+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 232 ms. Found 10 JPA repository interfaces. 2026-03-30T02:55:42.819+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode 2026-03-30T02:55:42.820+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2026-03-30T02:55:42.851+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.AdminRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.851+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.UpgradeLevelRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.852+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.GameCategoryRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.852+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.GameRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.852+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.AnnouncementRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.852+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.WithdrawalRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.853+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.TaskRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.853+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.PushMessageRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.853+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.SystemConfigRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.853+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.starpavilion.admin.repository.AppUserRepository; If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository 2026-03-30T02:55:42.854+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 20 ms. Found 0 Redis repository interfaces. 2026-03-30T02:55:43.558+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8088 (http) 2026-03-30T02:55:43.567+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2026-03-30T02:55:43.567+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.16] 2026-03-30T02:55:43.624+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2026-03-30T02:55:43.625+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2509 ms 2026-03-30T02:55:43.866+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2026-03-30T02:55:43.949+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.3.1.Final 2026-03-30T02:55:44.047+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2026-03-30T02:55:44.344+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2026-03-30T02:55:44.387+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2026-03-30T02:55:44.823+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@1e0294a7 2026-03-30T02:55:44.826+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2026-03-30T02:55:44.894+08:00 WARN 3497958 --- [star-pavilion-admin] [ main] org.hibernate.orm.deprecation : HHH90000025: MySQLDialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default) 2026-03-30T02:55:46.530+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration) Hibernate: create table admin_user ( id bigint not null auto_increment, create_time datetime(6), last_login_time datetime(6), nickname varchar(255), password varchar(255) not null, role varchar(255), status integer, username varchar(255) not null, primary key (id) ) engine=InnoDB Hibernate: create table announcement ( id bigint not null auto_increment, content TEXT, create_time datetime(6), status integer, title varchar(255) not null, type integer, update_time datetime(6), primary key (id) ) engine=InnoDB Hibernate: create table app_user ( id bigint not null auto_increment, avatar varchar(255), create_time datetime(6), invite_code varchar(255), last_login_time datetime(6), level varchar(255), nickname varchar(255), parent_invite_code varchar(255), phone varchar(255), status integer, team_count integer, primary key (id) ) engine=InnoDB Hibernate: create table game ( id bigint not null auto_increment, category_id bigint, create_time datetime(6), description TEXT, developer varchar(255) not null, download_url varchar(255), icon varchar(255), install_count integer, is_top integer, name varchar(255) not null, package_name varchar(255) not null, screenshot_urls JSON, sort_order integer, status integer, tags JSON, update_time datetime(6), version varchar(255) not null, primary key (id) ) engine=InnoDB Hibernate: create table game_category ( id bigint not null auto_increment, create_time datetime(6), icon varchar(255), name varchar(255) not null, sort_order integer, status integer, primary key (id) ) engine=InnoDB Hibernate: create table push_message ( id bigint not null auto_increment, content TEXT, create_time datetime(6), read_count integer, scheduled_time datetime(6), send_count integer, send_time datetime(6), status integer, target_type integer, target_value varchar(255), title varchar(255) not null, type integer, primary key (id) ) engine=InnoDB Hibernate: create table system_config ( id bigint not null auto_increment, config_key varchar(255) not null, config_value varchar(255), create_time datetime(6), description varchar(255), status integer, update_time datetime(6), primary key (id) ) engine=InnoDB Hibernate: create table task ( id bigint not null auto_increment, apply_count integer, category varchar(255), create_time datetime(6), description TEXT, is_top integer, reward decimal(38,2), status integer, title varchar(255) not null, update_time datetime(6), view_count integer, primary key (id) ) engine=InnoDB Hibernate: create table upgrade_level ( id bigint not null auto_increment, benefits TEXT, create_time datetime(6), level varchar(255) not null, name varchar(255), price varchar(255), required_count integer, requirement varchar(255), sort_order integer, status integer, update_time datetime(6), primary key (id) ) engine=InnoDB Hibernate: create table withdrawal ( id bigint not null auto_increment, amount decimal(38,2) not null, bank_account varchar(255), bank_name varchar(255), create_time datetime(6), real_name varchar(255), remark varchar(255), status integer, update_time datetime(6), user_id bigint not null, user_nickname varchar(255), user_phone varchar(255), primary key (id) ) engine=InnoDB Hibernate: alter table admin_user drop index UK_lvod9bfm438ex1071ku1glb70 Hibernate: alter table admin_user add constraint UK_lvod9bfm438ex1071ku1glb70 unique (username) Hibernate: alter table game drop index UK_obpskpxu76abw7ubvvlshi81w Hibernate: alter table game add constraint UK_obpskpxu76abw7ubvvlshi81w unique (package_name) Hibernate: alter table system_config drop index UK_npsxm1erd0lbetjn5d3ayrsof Hibernate: alter table system_config add constraint UK_npsxm1erd0lbetjn5d3ayrsof unique (config_key) Hibernate: alter table upgrade_level drop index UK_rb0ywokn8rv8xvkapi9mb58ja Hibernate: alter table upgrade_level add constraint UK_rb0ywokn8rv8xvkapi9mb58ja unique (level) 2026-03-30T02:55:47.022+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2026-03-30T02:55:47.721+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.s.d.j.r.query.QueryEnhancerFactory : Hibernate is in classpath; If applicable, HQL parser will be used. 上传目录创建成功: uploads/ 2026-03-30T02:55:48.072+08:00 WARN 3497958 --- [star-pavilion-admin] [ main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2026-03-30T02:55:48.976+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8088 (http) with context path '' 2026-03-30T02:55:49.004+08:00 INFO 3497958 --- [star-pavilion-admin] [ main] c.s.admin.StarPavilionAdminApplication : Started StarPavilionAdminApplication in 8.725 seconds (process running for 9.482) 2026-03-30T02:56:29.418+08:00 INFO 3497958 --- [star-pavilion-admin] [0.0-8088-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2026-03-30T02:56:29.419+08:00 INFO 3497958 --- [star-pavilion-admin] [0.0-8088-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2026-03-30T02:56:29.421+08:00 INFO 3497958 --- [star-pavilion-admin] [0.0-8088-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 2 ms Hibernate: select a1_0.id, a1_0.content, a1_0.create_time, a1_0.status, a1_0.title, a1_0.type, a1_0.update_time from announcement a1_0 Hibernate: select a1_0.id, a1_0.content, a1_0.create_time, a1_0.status, a1_0.title, a1_0.type, a1_0.update_time from announcement a1_0 Hibernate: select g1_0.id, g1_0.category_id, g1_0.create_time, g1_0.description, g1_0.developer, g1_0.download_url, g1_0.icon, g1_0.install_count, g1_0.is_top, g1_0.name, g1_0.package_name, g1_0.screenshot_urls, g1_0.sort_order, g1_0.status, g1_0.tags, g1_0.update_time, g1_0.version from game g1_0 order by g1_0.sort_order, g1_0.create_time desc Hibernate: select t1_0.id, t1_0.apply_count, t1_0.category, t1_0.create_time, t1_0.description, t1_0.is_top, t1_0.reward, t1_0.status, t1_0.title, t1_0.update_time, t1_0.view_count from task t1_0 order by t1_0.create_time desc limit ?, ? Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select ul1_0.id, ul1_0.benefits, ul1_0.create_time, ul1_0.level, ul1_0.name, ul1_0.price, ul1_0.required_count, ul1_0.requirement, ul1_0.sort_order, ul1_0.status, ul1_0.update_time from upgrade_level ul1_0 Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select ul1_0.id, ul1_0.benefits, ul1_0.create_time, ul1_0.level, ul1_0.name, ul1_0.price, ul1_0.required_count, ul1_0.requirement, ul1_0.sort_order, ul1_0.status, ul1_0.update_time from upgrade_level ul1_0 Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select ul1_0.id, ul1_0.benefits, ul1_0.create_time, ul1_0.level, ul1_0.name, ul1_0.price, ul1_0.required_count, ul1_0.requirement, ul1_0.sort_order, ul1_0.status, ul1_0.update_time from upgrade_level ul1_0 Hibernate: insert into game_category (create_time, icon, name, sort_order, status) values (?, ?, ?, ?, ?) Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: insert into game_category (create_time, icon, name, sort_order, status) values (?, ?, ?, ?, ?) Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select au1_0.id, au1_0.avatar, au1_0.create_time, au1_0.invite_code, au1_0.last_login_time, au1_0.level, au1_0.nickname, au1_0.parent_invite_code, au1_0.phone, au1_0.status, au1_0.team_count from app_user au1_0 where au1_0.level=? order by au1_0.create_time desc limit ?, ? Hibernate: select t1_0.id, t1_0.apply_count, t1_0.category, t1_0.create_time, t1_0.description, t1_0.is_top, t1_0.reward, t1_0.status, t1_0.title, t1_0.update_time, t1_0.view_count from task t1_0 order by t1_0.create_time desc limit ?, ? Hibernate: select sc1_0.id, sc1_0.config_key, sc1_0.config_value, sc1_0.create_time, sc1_0.description, sc1_0.status, sc1_0.update_time from system_config sc1_0 Hibernate: select sc1_0.id, sc1_0.config_key, sc1_0.config_value, sc1_0.create_time, sc1_0.description, sc1_0.status, sc1_0.update_time from system_config sc1_0 Hibernate: select pm1_0.id, pm1_0.content, pm1_0.create_time, pm1_0.read_count, pm1_0.scheduled_time, pm1_0.send_count, pm1_0.send_time, pm1_0.status, pm1_0.target_type, pm1_0.target_value, pm1_0.title, pm1_0.type from push_message pm1_0 order by pm1_0.create_time desc limit ?, ? Hibernate: select pm1_0.id, pm1_0.content, pm1_0.create_time, pm1_0.read_count, pm1_0.scheduled_time, pm1_0.send_count, pm1_0.send_time, pm1_0.status, pm1_0.target_type, pm1_0.target_value, pm1_0.title, pm1_0.type from push_message pm1_0 Hibernate: select w1_0.id, w1_0.amount, w1_0.bank_account, w1_0.bank_name, w1_0.create_time, w1_0.real_name, w1_0.remark, w1_0.status, w1_0.update_time, w1_0.user_id, w1_0.user_nickname, w1_0.user_phone from withdrawal w1_0 order by w1_0.create_time desc limit ?, ? Hibernate: select w1_0.id, w1_0.amount, w1_0.bank_account, w1_0.bank_name, w1_0.create_time, w1_0.real_name, w1_0.remark, w1_0.status, w1_0.update_time, w1_0.user_id, w1_0.user_nickname, w1_0.user_phone from withdrawal w1_0 Hibernate: select ul1_0.id, ul1_0.benefits, ul1_0.create_time, ul1_0.level, ul1_0.name, ul1_0.price, ul1_0.required_count, ul1_0.requirement, ul1_0.sort_order, ul1_0.status, ul1_0.update_time from upgrade_level ul1_0 Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select g1_0.id, g1_0.category_id, g1_0.create_time, g1_0.description, g1_0.developer, g1_0.download_url, g1_0.icon, g1_0.install_count, g1_0.is_top, g1_0.name, g1_0.package_name, g1_0.screenshot_urls, g1_0.sort_order, g1_0.status, g1_0.tags, g1_0.update_time, g1_0.version from game g1_0 order by g1_0.sort_order, g1_0.create_time desc Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select au1_0.id, au1_0.avatar, au1_0.create_time, au1_0.invite_code, au1_0.last_login_time, au1_0.level, au1_0.nickname, au1_0.parent_invite_code, au1_0.phone, au1_0.status, au1_0.team_count from app_user au1_0 where au1_0.level=? order by au1_0.create_time desc limit ?, ? Hibernate: select a1_0.id, a1_0.content, a1_0.create_time, a1_0.status, a1_0.title, a1_0.type, a1_0.update_time from announcement a1_0 Hibernate: select t1_0.id, t1_0.apply_count, t1_0.category, t1_0.create_time, t1_0.description, t1_0.is_top, t1_0.reward, t1_0.status, t1_0.title, t1_0.update_time, t1_0.view_count from task t1_0 order by t1_0.create_time desc limit ?, ? Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select g1_0.id, g1_0.category_id, g1_0.create_time, g1_0.description, g1_0.developer, g1_0.download_url, g1_0.icon, g1_0.install_count, g1_0.is_top, g1_0.name, g1_0.package_name, g1_0.screenshot_urls, g1_0.sort_order, g1_0.status, g1_0.tags, g1_0.update_time, g1_0.version from game g1_0 order by g1_0.sort_order, g1_0.create_time desc Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order Hibernate: select gc1_0.id, gc1_0.create_time, gc1_0.icon, gc1_0.name, gc1_0.sort_order, gc1_0.status from game_category gc1_0 order by gc1_0.sort_order