cockpit-source/backend/.server.out.log

 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.997ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[5.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[6.000ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'users' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.996ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.998ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:-] SELECT * FROM `users` LIMIT 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[7.001ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'users' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:19
[0.982ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[2.005ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.997ms] [rows:2]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'users'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:19
[3.002ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[3.995ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19
[2.998ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'users' AND constraint_name = 'uni_users_username'
 
2026/04/02 13:36:19
[1.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[3.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19
[6.000ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'users' AND index_name = 'idx_users_username'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.002ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'users' AND index_name = 'idx_users_username'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.001ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.999ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.999ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'roles' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.984ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.001ms] [rows:-] SELECT * FROM `roles` LIMIT 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.999ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'roles' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:19
[0.998ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[3.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.986ms] [rows:2]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'roles'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:19
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[2.002ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19
[4.005ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'roles' AND constraint_name = 'uni_roles_name'
 
2026/04/02 13:36:19
[1.997ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[3.975ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19
[3.000ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'roles' AND index_name = 'idx_roles_name'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.003ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.005ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.009ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'roles' AND index_name = 'idx_roles_name'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.996ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.987ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.002ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'permissions' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.996ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.995ms] [rows:-] SELECT * FROM `permissions` LIMIT 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.020ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'permissions' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:19
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[3.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.000ms] [rows:2]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'permissions'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:19
[2.001ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[3.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19
[2.000ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'permissions' AND constraint_name = 'uni_permissions_code'
 
2026/04/02 13:36:19
[1.001ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19
[4.000ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19
[3.016ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'permissions' AND index_name = 'idx_permissions_code'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.998ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.018ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'permissions' AND index_name = 'idx_permissions_code'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.999ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'user_roles' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.001ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.997ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.000ms] [rows:-] SELECT * FROM `user_roles` LIMIT 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'user_roles' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.007ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'role_permissions' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.002ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.000ms] [rows:-] SELECT * FROM `role_permissions` LIMIT 1
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.002ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'role_permissions' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:19 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.004ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.998ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'refresh_tokens' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.000ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:-] SELECT * FROM `refresh_tokens` LIMIT 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.685ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'refresh_tokens' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:20
[0.515ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.105ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.003ms] [rows:5]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'refresh_tokens'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:20
[1.002ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.993ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[2.000ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'refresh_tokens' AND constraint_name = 'uni_refresh_tokens_token_hash'
 
2026/04/02 13:36:20
[1.013ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.999ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[3.014ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'refresh_tokens' AND index_name = 'idx_refresh_tokens_token_hash'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.001ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.995ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.992ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'refresh_tokens' AND index_name = 'idx_refresh_tokens_revoked_at'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.999ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.005ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'refresh_tokens' AND index_name = 'idx_refresh_tokens_user_id'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.002ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.000ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'refresh_tokens' AND index_name = 'idx_refresh_tokens_token_hash'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.012ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[5.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.001ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'refresh_tokens' AND index_name = 'idx_refresh_tokens_expires_at'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.000ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.000ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'customers' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.001ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[6.677ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.735ms] [rows:-] SELECT * FROM `customers` LIMIT 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.007ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'customers' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:20
[1.001ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.008ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.991ms] [rows:3]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'customers'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:20
[1.002ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.002ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[2.990ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'customers' AND constraint_name = 'uni_customers_name'
 
2026/04/02 13:36:20
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[1.999ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[2.986ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'customers' AND index_name = 'idx_customers_name'
 
2026/04/02 13:36:20
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[3.000ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.015ms] [rows:3]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'customers'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:20
[0.993ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.997ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[1.995ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'customers' AND constraint_name = 'uni_customers_code'
 
2026/04/02 13:36:20
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.989ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[2.999ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'customers' AND index_name = 'idx_customers_code'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.002ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.995ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'customers' AND index_name = 'idx_customers_name'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.002ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.011ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'customers' AND index_name = 'idx_customers_code'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.001ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.998ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'statuses' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.000ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.003ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.003ms] [rows:-] SELECT * FROM `statuses` LIMIT 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.997ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'statuses' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:20
[1.005ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.993ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.003ms] [rows:2]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'statuses'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:20
[1.004ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[3.998ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[3.000ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'statuses' AND constraint_name = 'uni_statuses_name'
 
2026/04/02 13:36:20
[2.003ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.998ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[6.003ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'statuses' AND index_name = 'idx_statuses_name'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.996ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.005ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.010ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'statuses' AND index_name = 'idx_statuses_name'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.990ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.002ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.000ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'orders' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.013ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.998ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.002ms] [rows:-] SELECT * FROM `orders` LIMIT 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.002ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'orders' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:20
[0.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[3.000ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.005ms] [rows:7]
SELECT
TABLE_NAME,
COLUMN_NAME,
INDEX_NAME,
NON_UNIQUE
FROM
information_schema.STATISTICS
WHERE
TABLE_SCHEMA = 'cockpit'
AND TABLE_NAME = 'orders'
ORDER BY
INDEX_NAME,
SEQ_IN_INDEX
 
2026/04/02 13:36:20
[0.996ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.018ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[3.002ms] [rows:-] SELECT count(*) FROM INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = 'cockpit' AND table_name = 'orders' AND constraint_name = 'uni_orders_order_no'
 
2026/04/02 13:36:20
[1.014ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20
[2.988ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20
[2.003ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'orders' AND index_name = 'idx_orders_order_no'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[178.910ms] [rows:0] ALTER TABLE `orders` MODIFY COLUMN `amount_a` decimal(18,2) NOT NULL DEFAULT '0'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13 SLOW SQL >= 200ms
[260.672ms] [rows:0] ALTER TABLE `orders` MODIFY COLUMN `amount_b` decimal(18,2) NOT NULL DEFAULT '0'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.999ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.154ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.240ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'orders' AND index_name = 'idx_orders_ship_date'
 
2026/04/02 13:36:20 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.671ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.999ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.659ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'orders' AND index_name = 'idx_orders_customer_id'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.981ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.238ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.922ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'orders' AND index_name = 'idx_orders_status_id'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[0.523ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.862ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.303ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'orders' AND index_name = 'idx_orders_created_by'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.737ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.313ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.832ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'orders' AND index_name = 'idx_orders_order_no'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.655ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.364ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.763ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'orders' AND index_name = 'idx_orders_order_date'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.075ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.140ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.710ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'import_jobs' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.570ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.313ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[2.174ms] [rows:-] SELECT * FROM `import_jobs` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.532ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'import_jobs' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.043ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.790ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.561ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'import_jobs' AND index_name = 'idx_import_jobs_created_by'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.090ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.285ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.740ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cockpit' AND table_name = 'import_job_errors' AND table_type = 'BASE TABLE'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.644ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.464ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.471ms] [rows:-] SELECT * FROM `import_job_errors` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[4.466ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'cockpit' AND table_name = 'import_job_errors' ORDER BY ORDINAL_POSITION
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[1.127ms] [rows:-] SELECT DATABASE()
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[3.327ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'cockpit%' ORDER BY SCHEMA_NAME='cockpit' DESC,SCHEMA_NAME limit 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:13
[5.145ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'cockpit' AND table_name = 'import_job_errors' AND index_name = 'idx_import_job_errors_job_id'
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[2.164ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'overview:view' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[1.511ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'orders:read' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[3.579ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'orders:write' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[3.308ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'import:preview' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[3.230ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'import:commit' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[2.875ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'dict:read' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[2.468ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'dict:write' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:47
[2.344ms] [rows:1] SELECT * FROM `permissions` WHERE code = 'admin:*' ORDER BY `permissions`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:57
[1.996ms] [rows:1] SELECT * FROM `roles` WHERE name = 'admin' ORDER BY `roles`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:64
[2.005ms] [rows:1] SELECT * FROM `users` WHERE username = 'admin' ORDER BY `users`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:78
[1.995ms] [rows:1] SELECT * FROM `user_roles` WHERE user_id = 1 AND role_id = 1 ORDER BY `user_roles`.`user_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:84
[4.018ms] [rows:8] SELECT * FROM `permissions`
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[2.417ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 1 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[3.338ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 2 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[2.773ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 3 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[2.929ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 4 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[2.695ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 5 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[2.700ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 6 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[2.521ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 7 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:87
[1.996ms] [rows:1] SELECT * FROM `role_permissions` WHERE role_id = 1 AND permission_id = 8 ORDER BY `role_permissions`.`role_id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:102
[3.000ms] [rows:1] SELECT * FROM `statuses` WHERE name = '未出货' ORDER BY `statuses`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:102
[3.001ms] [rows:1] SELECT * FROM `statuses` WHERE name = '部分出货' ORDER BY `statuses`.`id` LIMIT 1
 
2026/04/02 13:36:21 E:/private_basic/cockpit-source/backend/internal/seed/seed.go:102
[2.993ms] [rows:1] SELECT * FROM `statuses` WHERE name = '已出货' ORDER BY `statuses`.`id` LIMIT 1
[GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
- using env: export GIN_MODE=release
- using code: gin.SetMode(gin.ReleaseMode)
 
[GIN-debug] POST /api/auth/login --> cockpit/internal/api.(*Handler).AuthLogin-fm (3 handlers)
[GIN-debug] POST /api/auth/refresh --> cockpit/internal/api.(*Handler).AuthRefresh-fm (3 handlers)
[GIN-debug] POST /api/auth/logout --> cockpit/internal/api.(*Handler).AuthLogout-fm (3 handlers)
[GIN-debug] GET /api/me --> cockpit/internal/api.(*Handler).Me-fm (4 handlers)
[GIN-debug] GET /api/customers --> cockpit/internal/api.(*Handler).CustomerList-fm (5 handlers)
[GIN-debug] POST /api/customers --> cockpit/internal/api.(*Handler).CustomerCreate-fm (5 handlers)
[GIN-debug] PATCH /api/customers/:id --> cockpit/internal/api.(*Handler).CustomerUpdate-fm (5 handlers)
[GIN-debug] DELETE /api/customers/:id --> cockpit/internal/api.(*Handler).CustomerDelete-fm (5 handlers)
[GIN-debug] GET /api/statuses --> cockpit/internal/api.(*Handler).StatusList-fm (5 handlers)
[GIN-debug] POST /api/statuses --> cockpit/internal/api.(*Handler).StatusCreate-fm (5 handlers)
[GIN-debug] PATCH /api/statuses/:id --> cockpit/internal/api.(*Handler).StatusUpdate-fm (5 handlers)
[GIN-debug] DELETE /api/statuses/:id --> cockpit/internal/api.(*Handler).StatusDelete-fm (5 handlers)
[GIN-debug] GET /api/orders --> cockpit/internal/api.(*Handler).OrderList-fm (5 handlers)
[GIN-debug] GET /api/orders/:id --> cockpit/internal/api.(*Handler).OrderGet-fm (5 handlers)
[GIN-debug] POST /api/orders --> cockpit/internal/api.(*Handler).OrderCreate-fm (5 handlers)
[GIN-debug] PATCH /api/orders/:id --> cockpit/internal/api.(*Handler).OrderUpdate-fm (5 handlers)
[GIN-debug] DELETE /api/orders/:id --> cockpit/internal/api.(*Handler).OrderDelete-fm (5 handlers)
[GIN-debug] GET /api/import/templates/orders.xlsx --> cockpit/internal/api.(*Handler).ImportOrdersTemplate-fm (5 handlers)
[GIN-debug] POST /api/import/orders/preview --> cockpit/internal/api.(*Handler).ImportOrdersPreview-fm (5 handlers)
[GIN-debug] POST /api/import/orders/commit --> cockpit/internal/api.(*Handler).ImportOrdersCommit-fm (5 handlers)
[GIN-debug] POST /api/import/orders/json --> cockpit/internal/api.(*Handler).ImportOrdersJSON-fm (5 handlers)
[GIN-debug] GET /api/import/jobs --> cockpit/internal/api.(*Handler).ImportJobs-fm (5 handlers)
[GIN-debug] GET /api/import/jobs/:id --> cockpit/internal/api.(*Handler).ImportJobGet-fm (5 handlers)
[GIN-debug] GET /api/import/jobs/:id/errors --> cockpit/internal/api.(*Handler).ImportJobErrors-fm (5 handlers)
[GIN-debug] GET /api/overview/kpis --> cockpit/internal/api.(*Handler).OverviewKPIs-fm (5 handlers)
[GIN-debug] GET /api/overview/monthly-trend --> cockpit/internal/api.(*Handler).OverviewMonthlyTrend-fm (5 handlers)
[GIN-debug] GET /api/overview/by-customer --> cockpit/internal/api.(*Handler).OverviewByCustomer-fm (5 handlers)
[GIN-debug] GET /api/overview/topn --> cockpit/internal/api.(*Handler).OverviewTopN-fm (5 handlers)
[GIN-debug] GET /api/overview/status-distribution --> cockpit/internal/api.(*Handler).OverviewStatusDistribution-fm (5 handlers)
 
2026/04/02 13:38:23 E:/private_basic/cockpit-source/backend/internal/auth/service.go:39
[3.680ms] [rows:1] SELECT * FROM `users` WHERE username = 'admin' ORDER BY `users`.`id` LIMIT 1
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/auth/service.go:203
[151.400ms] [rows:1] INSERT INTO `refresh_tokens` (`created_at`,`updated_at`,`user_id`,`token_hash`,`device_id`,`user_agent`,`ip`,`expires_at`,`revoked_at`) VALUES ('2026-04-02 13:38:24.067','2026-04-02 13:38:24.067',1,'49fd957ad8020319dbc01a24e4fb77bd0f5909fb095bbcd6d1c59940045d86db','','','','2026-05-02 13:38:24',NULL)
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.680ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/api/overview.go:178
[2.179ms] [rows:7]
SELECT
YEAR(order_date) AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
GROUP BY YEAR(order_date), MONTH(order_date)
ORDER BY YEAR(order_date), MONTH(order_date)
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/api/overview.go:191
[1.629ms] [rows:0]
SELECT
YEAR(ship_date) AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL
GROUP BY YEAR(ship_date), MONTH(ship_date)
ORDER BY YEAR(ship_date), MONTH(ship_date)
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.627ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.277ms] [rows:5]
SELECT
2025 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[4.599ms] [rows:0]
SELECT
2025 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.141ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[5.441ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.998ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[4.522ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-10-01 00:00:00' AND o.order_date < '2025-11-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:38:24 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[9.533ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-09-01 00:00:00' AND o.order_date < '2025-10-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:39:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:77
[2.999ms] [rows:1] SELECT * FROM `refresh_tokens` WHERE token_hash = 'e07cb04543c05195536356a334cab41b5eb71093254ec52f04e88e6fdec44aad' ORDER BY `refresh_tokens`.`id` LIMIT 1
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:88 SLOW SQL >= 200ms
[302.344ms] [rows:1] UPDATE `refresh_tokens` SET `revoked_at`='2026-04-02 13:39:35.762',`updated_at`='2026-04-02 13:39:35.764' WHERE id = 19
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:203 SLOW SQL >= 200ms
[264.104ms] [rows:1] INSERT INTO `refresh_tokens` (`created_at`,`updated_at`,`user_id`,`token_hash`,`device_id`,`user_agent`,`ip`,`expires_at`,`revoked_at`) VALUES ('2026-04-02 13:39:36.139','2026-04-02 13:39:36.139',1,'ee5c5b29d2c3e9423b24d5e17de9ebbf510446a4e9fbbcd05e557acda8a7f4e6','','','','2026-05-02 13:39:36',NULL)
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.000ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:178
[1.510ms] [rows:7]
SELECT
YEAR(order_date) AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
GROUP BY YEAR(order_date), MONTH(order_date)
ORDER BY YEAR(order_date), MONTH(order_date)
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:191
[3.154ms] [rows:0]
SELECT
YEAR(ship_date) AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL
GROUP BY YEAR(ship_date), MONTH(ship_date)
ORDER BY YEAR(ship_date), MONTH(ship_date)
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.001ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.010ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[11.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[12.006ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[3.991ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[2.998ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.001ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[8.007ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[9.989ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:39:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[2.012ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.514ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.514ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.994ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[4.003ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[11.516ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[4.005ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[14.000ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[15.004ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.996ms] [rows:5]
SELECT
2025 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.878ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[2.873ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.389ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:40:25 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[4.390ms] [rows:0]
SELECT
2025 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.003ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.007ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.994ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.003ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.003ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.001ms] [rows:5]
SELECT
2025 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[8.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.000ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[4.001ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-10-01 00:00:00' AND o.order_date < '2025-11-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[2.997ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[6.004ms] [rows:0]
SELECT
2025 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[6.002ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:40:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[12.001ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-09-01 00:00:00' AND o.order_date < '2025-10-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.062ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.062ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[2.235ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[2.761ms] [rows:5]
SELECT
2025 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.018ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.016ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.018ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.066ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[3.106ms] [rows:0]
SELECT
2025 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[2.824ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[2.816ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[5.275ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:42:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[11.968ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.974ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[1.694ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.183ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[1.670ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.741ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.741ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:178
[2.064ms] [rows:7]
SELECT
YEAR(order_date) AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
GROUP BY YEAR(order_date), MONTH(order_date)
ORDER BY YEAR(order_date), MONTH(order_date)
 
2026/04/02 13:42:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[2.341ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:42:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:191
[1.946ms] [rows:0]
SELECT
YEAR(ship_date) AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL
GROUP BY YEAR(ship_date), MONTH(ship_date)
ORDER BY YEAR(ship_date), MONTH(ship_date)
 
2026/04/02 13:42:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.377ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[11.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:42:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[2.780ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:42:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[4.473ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.099ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.099ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[2.020ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[2.015ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[3.126ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.001ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[0.997ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[1.972ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.777ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/api/import.go:107
[3.392ms] [rows:1] SELECT count(*) FROM `import_jobs` WHERE type = 'orders'
 
2026/04/02 13:43:03 E:/private_basic/cockpit-source/backend/internal/api/import.go:109
[2.785ms] [rows:2] SELECT * FROM `import_jobs` WHERE type = 'orders' ORDER BY id DESC LIMIT 50
 
2026/04/02 13:43:04 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.060ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:04 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.604ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:43:04 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[4.299ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:43:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.063ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:05 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[1.999ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:43:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.849ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[4.629ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:43:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.007ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:43:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.002ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.093ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.072ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[3.453ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.112ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.112ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[4.069ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[2.202ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[3.185ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.183ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:43:06 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[9.111ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.197ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.197ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.658ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.658ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[3.282ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[3.248ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[8.361ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[7.804ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.926ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[4.122ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.857ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[3.258ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.655ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:46:26 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.011ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:02 E:/private_basic/cockpit-source/backend/internal/auth/service.go:109
[85.510ms] [rows:1] UPDATE `refresh_tokens` SET `revoked_at`='2026-04-02 13:47:02.219',`updated_at`='2026-04-02 13:47:02.221' WHERE token_hash = 'ee5c5b29d2c3e9423b24d5e17de9ebbf510446a4e9fbbcd05e557acda8a7f4e6' AND revoked_at IS NULL
 
2026/04/02 13:47:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:39
[2.966ms] [rows:1] SELECT * FROM `users` WHERE username = 'admin' ORDER BY `users`.`id` LIMIT 1
 
2026/04/02 13:47:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:203
[79.622ms] [rows:1] INSERT INTO `refresh_tokens` (`created_at`,`updated_at`,`user_id`,`token_hash`,`device_id`,`user_agent`,`ip`,`expires_at`,`revoked_at`) VALUES ('2026-04-02 13:47:03.523','2026-04-02 13:47:03.523',1,'f8a4b6b3c568819a43d55f1aa88b0e05dd1950be897c88a13653a876912689bd','','','','2026-05-02 13:47:03',NULL)
 
2026/04/02 13:47:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.819ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.000ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.002ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.001ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[4.004ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.599ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.599ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[5.050ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[4.518ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[11.788ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.868ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[2.745ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[2.711ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[2.728ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:47:04 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.208ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:47:09 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.024ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:09 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[2.568ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:47:09 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[5.367ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:47:10 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.803ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:10 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[1.650ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:47:10 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.892ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:10 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[1.687ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 13:47:10 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[2.696ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:39
[3.308ms] [rows:1] SELECT * FROM `users` WHERE username = 'admin' ORDER BY `users`.`id` LIMIT 1
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:203
[141.747ms] [rows:1] INSERT INTO `refresh_tokens` (`created_at`,`updated_at`,`user_id`,`token_hash`,`device_id`,`user_agent`,`ip`,`expires_at`,`revoked_at`) VALUES ('2026-04-02 13:47:26.369','2026-04-02 13:47:26.369',1,'5f9437967eb20d9d3528800b7db54daedc26d5e3d33e9d3718d184f8ce7b7f36','','','','2026-05-02 13:47:26',NULL)
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.889ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.805ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.000ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[3.987ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.515ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[2.196ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.834ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[2.134ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 13:47:26 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[3.328ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.994ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.994ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.001ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[4.000ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.000ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[5.011ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[4.508ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.108ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.931ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[2.963ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[2.821ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.069ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[2.773ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:47:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.894ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:47:30 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.293ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:30 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.690ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:47:30 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[2.910ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:47:34 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[2.992ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[4.070ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.304ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.062ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.062ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[2.142ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[8.375ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.067ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[2.668ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[3.433ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[4.839ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[4.314ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:47:35 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[12.660ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.997ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[7.218ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.643ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[8.568ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[9.769ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[30.631ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[49.105ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[71.011ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[2.047ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.996ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[2.000ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[3.001ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.001ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[11.003ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[4.061ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.857ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[8.853ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[2.997ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[2.985ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[12.847ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[8.004ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:48:05 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[10.006ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[6.000ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.007ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[11.003ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[4.003ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[13.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.997ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[13.995ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[2.998ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[5.007ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[2.998ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[3.004ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[3.998ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:48:13 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[13.995ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.004ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[2.998ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[2.999ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.993ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[4.001ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[3.981ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[4.000ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[2.999ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.003ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[5.017ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.995ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:44 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[4.007ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:48:52 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.579ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:52 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.112ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:52 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.144ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:52 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.588ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:48:52 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.987ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:52 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[4.002ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:48:52 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[2.999ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:48:53 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.006ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:53 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.006ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:53 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[3.003ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:48:53 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[4.008ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:48:53 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.005ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:48:53 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[2.993ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:48:53 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[5.000ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.720ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.329ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.296ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[2.998ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.242ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.006ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[3.640ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.562ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.084ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[4.169ms] [rows:5]
SELECT
2025 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[2.832ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[3.815ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:49:02 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[10.918ms] [rows:0]
SELECT
2025 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.000ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:178
[4.003ms] [rows:7]
SELECT
YEAR(order_date) AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
GROUP BY YEAR(order_date), MONTH(order_date)
ORDER BY YEAR(order_date), MONTH(order_date)
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[4.001ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[14.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[14.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[14.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:191
[2.997ms] [rows:0]
SELECT
YEAR(ship_date) AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL
GROUP BY YEAR(ship_date), MONTH(ship_date)
ORDER BY YEAR(ship_date), MONTH(ship_date)
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.988ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[1.995ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[2.006ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[1.996ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL
 
2026/04/02 13:50:12 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.003ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.842ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.726ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[3.184ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[1.996ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.998ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[1.004ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 13:50:39 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[2.010ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 13:50:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.002ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:40 E:/private_basic/cockpit-source/backend/internal/api/import.go:107
[2.006ms] [rows:1] SELECT count(*) FROM `import_jobs` WHERE type = 'orders'
 
2026/04/02 13:50:40 E:/private_basic/cockpit-source/backend/internal/api/import.go:109
[2.000ms] [rows:2] SELECT * FROM `import_jobs` WHERE type = 'orders' ORDER BY id DESC LIMIT 50
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.845ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.845ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.372ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.149ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[3.125ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[4.759ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.515ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.997ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.998ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[3.004ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.004ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[6.001ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[9.999ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:50:41 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[4.001ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.853ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.853ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[2.880ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.746ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.746ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.746ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.332ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.752ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[3.817ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.563ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_b),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[2.961ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[3.470ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[10.342ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:50:55 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[11.361ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.014ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.997ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.000ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.101ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[2.768ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[4.900ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.257ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.257ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[2.721ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.664ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[2.668ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[2.649ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:51:03 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.349ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.096ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.053ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.350ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.920ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[8.970ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[8.934ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.455ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.370ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[4.009ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.865ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[5.057ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[4.217ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[5.046ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:56:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[11.665ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.002ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.007ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.008ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.999ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[4.997ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[2.999ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.003ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_b),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[2.001ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[2.999ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[2.999ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:36 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[3.995ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.706ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.917ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.326ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.875ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.823ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.917ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[3.011ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.748ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.685ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[6.271ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[3.775ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[5.112ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[11.318ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:57:39 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[11.320ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.820ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.225ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[3.637ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.906ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[1.580ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.390ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[1.207ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 13:57:40 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[2.871ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 13:57:43 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.589ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:43 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.073ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:57:43 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[2.755ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:57:44 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.609ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:44 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[1.654ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:57:44 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.005ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:44 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[1.078ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 13:57:44 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[3.358ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 13:57:49 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.518ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:49 E:/private_basic/cockpit-source/backend/internal/api/import.go:107
[4.987ms] [rows:1] SELECT count(*) FROM `import_jobs` WHERE type = 'orders'
 
2026/04/02 13:57:49 E:/private_basic/cockpit-source/backend/internal/api/import.go:109
[4.556ms] [rows:2] SELECT * FROM `import_jobs` WHERE type = 'orders' ORDER BY id DESC LIMIT 50
 
2026/04/02 13:57:49 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.734ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:49 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.656ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 13:57:49 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[3.804ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 13:57:50 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.346ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:50 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[2.277ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[11.440ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.904ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[5.273ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[23.550ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[9.670ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[28.552ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[28.552ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[7.992ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[9.004ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[6.515ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[14.367ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[17.366ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[5.998ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 13:57:51 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[26.367ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 14:01:23 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.611ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:23 E:/private_basic/cockpit-source/backend/internal/api/import.go:107
[3.982ms] [rows:1] SELECT count(*) FROM `import_jobs` WHERE type = 'orders'
 
2026/04/02 14:01:23 E:/private_basic/cockpit-source/backend/internal/api/import.go:109
[4.473ms] [rows:2] SELECT * FROM `import_jobs` WHERE type = 'orders' ORDER BY id DESC LIMIT 50
 
2026/04/02 14:01:27 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[5.268ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:27 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[2.435ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 14:01:27 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[4.951ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 14:01:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.811ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:29 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[1.658ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[4.825ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[7.879ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.462ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.902ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[6.184ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.270ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[5.317ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[5.845ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[15.536ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[16.067ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[3.434ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[4.203ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[5.378ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 14:01:34 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[7.912ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.950ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.977ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.966ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.472ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[4.037ms] [rows:5]
SELECT
2025 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.589ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[9.589ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[3.487ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[2.806ms] [rows:0]
SELECT
2025 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2025-01-01 00:00:00' AND ship_date < '2026-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[3.476ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[2.651ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2025-01-01 00:00:00' AND order_date < '2026-01-01 00:00:00'
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.699ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 14:01:40 E:/private_basic/cockpit-source/backend/internal/api/overview.go:340
[9.549ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2025-01-01 00:00:00' AND o.order_date < '2026-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.913ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/api/import.go:107
[3.820ms] [rows:1] SELECT count(*) FROM `import_jobs` WHERE type = 'orders'
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/api/import.go:109
[3.348ms] [rows:2] SELECT * FROM `import_jobs` WHERE type = 'orders' ORDER BY id DESC LIMIT 50
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.980ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[2.980ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.069ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/api/statuses.go:15
[1.071ms] [rows:3] SELECT * FROM `statuses` ORDER BY sort_order ASC, id ASC
 
2026/04/02 14:02:00 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[2.740ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 14:02:01 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.207ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:01 E:/private_basic/cockpit-source/backend/internal/api/orders.go:68
[1.073ms] [rows:1] SELECT count(*) FROM `orders`
 
2026/04/02 14:02:01 E:/private_basic/cockpit-source/backend/internal/api/orders.go:70
[2.133ms] [rows:27] SELECT * FROM `orders` ORDER BY id DESC LIMIT 50
 
2026/04/02 14:02:15 E:/private_basic/cockpit-source/backend/internal/auth/service.go:77
[4.234ms] [rows:1] SELECT * FROM `refresh_tokens` WHERE token_hash = 'f8a4b6b3c568819a43d55f1aa88b0e05dd1950be897c88a13653a876912689bd' ORDER BY `refresh_tokens`.`id` LIMIT 1
 
2026/04/02 14:02:15 E:/private_basic/cockpit-source/backend/internal/auth/service.go:88
[151.169ms] [rows:1] UPDATE `refresh_tokens` SET `revoked_at`='2026-04-02 14:02:15.597',`updated_at`='2026-04-02 14:02:15.599' WHERE id = 22
 
2026/04/02 14:02:15 E:/private_basic/cockpit-source/backend/internal/auth/service.go:203
[127.394ms] [rows:1] INSERT INTO `refresh_tokens` (`created_at`,`updated_at`,`user_id`,`token_hash`,`device_id`,`user_agent`,`ip`,`expires_at`,`revoked_at`) VALUES ('2026-04-02 14:02:15.753','2026-04-02 14:02:15.753',1,'d976d4e56dcab00929663994b0104f9b8f00988e28558a4db09672645240b340','','','','2026-05-02 14:02:15',NULL)
 
2026/04/02 14:02:15 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.600ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:15 E:/private_basic/cockpit-source/backend/internal/api/import.go:107
[4.064ms] [rows:1] SELECT count(*) FROM `import_jobs` WHERE type = 'orders'
 
2026/04/02 14:02:15 E:/private_basic/cockpit-source/backend/internal/api/import.go:109
[2.835ms] [rows:2] SELECT * FROM `import_jobs` WHERE type = 'orders' ORDER BY id DESC LIMIT 50
 
2026/04/02 14:02:26 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.470ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:26 E:/private_basic/cockpit-source/backend/internal/api/customers.go:29
[1.066ms] [rows:1] SELECT count(*) FROM `customers`
 
2026/04/02 14:02:26 E:/private_basic/cockpit-source/backend/internal/api/customers.go:31
[2.874ms] [rows:2] SELECT * FROM `customers` ORDER BY id DESC LIMIT 200
 
2026/04/02 14:02:28 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.652ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:28 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[3.263ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 14:02:28 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.783ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[3.268ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.494ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.494ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[2.149ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.297ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[7.297ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[2.652ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[2.849ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[3.349ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[5.277ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 14:02:29 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[11.109ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.993ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[3.000ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:44
[2.999ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.001ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[10.001ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:62
[2.002ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/auth/service.go:181
[12.005ms] [rows:8] SELECT permissions.code as code FROM `permissions` JOIN role_permissions ON role_permissions.permission_id = permissions.id JOIN user_roles ON user_roles.role_id = role_permissions.role_id WHERE user_roles.user_id = 1 GROUP BY `permissions`.`code`
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:283
[9.004ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-04-01 00:00:00' AND o.order_date < '2026-05-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY cnt DESC
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:132
[5.000ms] [rows:2]
SELECT
2026 AS year,
MONTH(order_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'
GROUP BY MONTH(order_date)
ORDER BY MONTH(order_date)
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:478
[4.000ms] [rows:3]
SELECT s.id AS status_id, s.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM statuses s
LEFT JOIN orders o ON o.status_id = s.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY s.id, s.name
ORDER BY cnt DESC
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:434
[2.997ms] [rows:2]
SELECT c.id AS id, c.name AS name,
COALESCE(SUM(o.amount_a),0) AS value,
COUNT(o.id) AS cnt
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01 00:00:00' AND o.order_date < '2027-01-01 00:00:00'
GROUP BY c.id, c.name
ORDER BY value DESC
LIMIT 10
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:145
[2.999ms] [rows:0]
SELECT
2026 AS year,
MONTH(ship_date) AS month,
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NOT NULL AND ship_date >= '2026-01-01 00:00:00' AND ship_date < '2027-01-01 00:00:00'
GROUP BY MONTH(ship_date)
ORDER BY MONTH(ship_date)
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:293
[2.999ms] [rows:2]
SELECT c.id AS customer_id, c.name AS name,
COUNT(o.id) AS cnt,
COALESCE(SUM(o.amount_a),0) AS sum_a,
COALESCE(SUM(o.amount_b),0) AS sum_b
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-03-01 00:00:00' AND o.order_date < '2026-04-01 00:00:00'
GROUP BY c.id, c.name
 
2026/04/02 14:16:31 E:/private_basic/cockpit-source/backend/internal/api/overview.go:80
[9.008ms] [rows:1]
 
SELECT
COALESCE(SUM(amount_a),0) AS sum_a,
COALESCE(SUM(amount_b),0) AS sum_b,
COUNT(*) AS cnt
FROM orders
WHERE ship_date IS NULL AND order_date >= '2026-01-01 00:00:00' AND order_date < '2027-01-01 00:00:00'