Skip to content

Instantly share code, notes, and snippets.

@rh101

rh101/log.txt Secret

Created May 8, 2023 05:21
Show Gist options
  • Save rh101/8912193d230f8f89a9cc6437620f8795 to your computer and use it in GitHub Desktop.
Save rh101/8912193d230f8f89a9cc6437620f8795 to your computer and use it in GitHub Desktop.
gitea log 20230508
2023/05/08 05:14:38 ...dules/setting/log.go:331:initLogFrom() [I] Gitea Log Mode: File(File:debug)
2023/05/08 05:14:38 ...dules/setting/log.go:337:initLogFrom() [I] According to the configuration, subsequent logs will not be printed to the console
2023/05/08 05:14:38 ...dules/setting/log.go:286:generateNamedLogger() [I] Router Log: Console(console:debug)
2023/05/08 05:14:38 ...les/setting/cache.go:75:loadCacheFrom() [I] Cache Service Enabled
2023/05/08 05:14:38 ...les/setting/cache.go:90:loadCacheFrom() [I] Last Commit Cache Service Enabled
2023/05/08 05:14:38 ...s/setting/session.go:74:loadSessionFrom() [I] Session Service Enabled
2023/05/08 05:14:38 ...g/config_provider.go:30:deprecatedSetting() [E] Deprecated fallback `[mailer]` `MAILER_TYPE` present. Use `[mailer]` `PROTOCOL` instead. This fallback will be/has been removed in v1.19.0
2023/05/08 05:14:38 ...g/config_provider.go:30:deprecatedSetting() [E] Deprecated fallback `[mailer]` `IS_TLS_ENABLED` present. Use `[mailer]` `PROTOCOL` instead. This fallback will be/has been removed in v1.19.0
2023/05/08 05:14:38 ...es/setting/mailer.go:236:loadMailerFrom() [I] Mail Service Enabled
2023/05/08 05:14:38 ...es/setting/mailer.go:258:loadNotifyMailFrom() [I] Notify Mail Service Enabled
2023/05/08 05:14:38 ...s/storage/storage.go:175:initAttachments() [I] Initialising Attachment storage with type:
2023/05/08 05:14:38 ...les/storage/local.go:45:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/attachments
2023/05/08 05:14:38 ...s/storage/storage.go:165:initAvatars() [I] Initialising Avatar storage with type:
2023/05/08 05:14:38 ...les/storage/local.go:45:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/avatars
2023/05/08 05:14:38 ...s/storage/storage.go:191:initRepoAvatars() [I] Initialising Repository Avatar storage with type:
2023/05/08 05:14:38 ...les/storage/local.go:45:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/repo-avatars
2023/05/08 05:14:38 ...s/storage/storage.go:185:initLFS() [I] Initialising LFS storage with type:
2023/05/08 05:14:38 ...les/storage/local.go:45:NewLocalStorage() [I] Creating new Local Storage at /data/git/lfs
2023/05/08 05:14:38 ...s/storage/storage.go:197:initRepoArchives() [I] Initialising Repository Archive storage with type:
2023/05/08 05:14:38 ...les/storage/local.go:45:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/repo-archive
2023/05/08 05:14:38 ...s/storage/storage.go:207:initPackages() [I] Initialising Packages storage with type:
2023/05/08 05:14:38 ...les/storage/local.go:45:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/packages
2023/05/08 05:14:38 ...ueue_disk_channel.go:159:Run() [D] [6458853e-22] PersistableChannelQueue: mail Starting
2023/05/08 05:14:38 ...ueue_disk_channel.go:196:Run() [D] [6458853e-22] PersistableChannelQueue: mail Skipping running the empty level queue
2023/05/08 05:14:38 ...ue/queue_bytefifo.go:334:Shutdown() [D] [6458853e-22] level: mail-level Shutdown
2023/05/08 05:14:38 ...ueue_disk_channel.go:159:Run() [D] [6458853e-24] PersistableChannelQueue: notification-service Starting
2023/05/08 05:14:38 ...ueue_disk_channel.go:196:Run() [D] [6458853e-24] PersistableChannelQueue: notification-service Skipping running the empty level queue
2023/05/08 05:14:38 ...ue/queue_bytefifo.go:334:Shutdown() [D] [6458853e-24] level: notification-service-level Shutdown
2023/05/08 05:14:38 ...ueue_disk_channel.go:188:Run() [D] [6458853e-26] PersistableChannelUniqueQueue: repo-archive Starting
2023/05/08 05:14:38 ...ueue_disk_channel.go:234:Run() [D] [6458853e-26] PersistableChannelUniqueQueue: repo-archive Skipping running the empty level queue
2023/05/08 05:14:38 ...ue/queue_bytefifo.go:334:Shutdown() [D] [6458853e-26] unique-level: repo-archive-level Shutdown
2023/05/08 05:14:38 routers/init.go:143:GlobalInitInstalled() [I] SQLite3 support is enabled
2023/05/08 05:14:38 routers/common/db.go:21:InitDBEngine() [I] Beginning ORM engine initialization.
2023/05/08 05:14:38 routers/common/db.go:28:InitDBEngine() [I] ORM engine initialization attempt #1/10...
2023/05/08 05:14:38 cmd/web.go:163:runWeb() [I] PING DATABASE postgres
2023/05/08 05:14:38 routers/common/db.go:44:migrateWithSetting() [I] [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 3.937363ms
2023/05/08 05:14:38 ...ations/migrations.go:518:Migrate() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [version public] - 23.186984ms
2023/05/08 05:14:38 ...ations/migrations.go:518:Migrate() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [version public] - 3.396827ms
2023/05/08 05:14:38 ...bfc5ce9830/engine.go:1244:Get() [I] [SQL] SELECT "id", "version" FROM "version" WHERE "id"=$1 LIMIT 1 [1] - 1.091797ms
2023/05/08 05:14:38 models/db/engine.go:194:InitEngineWithMigration() [I] [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 1.665671ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [app_state public] - 15.173352ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [app_state public] - 2.072669ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [notice public] - 16.95461ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [notice public] - 1.958802ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [system_setting public] - 15.384618ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [system_setting public] - 2.072713ms
2023/05/08 05:14:38 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [email_hash public] - 16.26069ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [email_hash public] - 2.251417ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [oauth2_application public] - 16.24327ms
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [oauth2_application public] - 2.462961ms
2023/05/08 05:14:38 routers/init.go:148:GlobalInitInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE
2023/05/08 05:14:38 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [oauth2_authorization_code public] - 15.698575ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [oauth2_authorization_code public] - 2.225905ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [oauth2_grant public] - 15.861946ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [oauth2_grant public] - 2.337769ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [session public] - 15.382204ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [session public] - 2.067025ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [login_source public] - 15.738362ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [login_source public] - 2.464239ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [access_token public] - 15.928135ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [access_token public] - 2.426345ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [two_factor public] - 16.022427ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [two_factor public] - 2.242062ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [webauthn_credential public] - 16.642878ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [webauthn_credential public] - 2.539865ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [badge public] - 16.038573ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [badge public] - 2.12888ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [user_badge public] - 15.441052ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [user_badge public] - 2.185711ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [email_address public] - 15.638999ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [email_address public] - 2.322291ms
2023/05/08 05:14:39 routers/init.go:148:GlobalInitInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [external_login_user public] - 16.441898ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [external_login_user public] - 2.202995ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [follow public] - 15.179238ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [follow public] - 2.163423ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [user_open_id public] - 15.416231ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [user_open_id public] - 2.228676ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [user_redirect public] - 15.485686ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [user_redirect public] - 2.14551ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [user_setting public] - 15.247786ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [user_setting public] - 2.260319ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [user public] - 20.491528ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [user public] - 2.546038ms
2023/05/08 05:14:39 routers/init.go:148:GlobalInitInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [repo_archiver public] - 15.393253ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [repo_archiver public] - 2.366309ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [attachment public] - 15.915144ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [attachment public] - 2.568387ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [collaboration public] - 15.38934ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [collaboration public] - 2.461801ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [language_stat public] - 15.935574ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [language_stat public] - 2.447732ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [mirror public] - 16.039279ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [mirror public] - 2.221342ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [push_mirror public] - 16.038867ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [push_mirror public] - 2.079292ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [repo_redirect public] - 15.204768ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [repo_redirect public] - 2.120816ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [release public] - 16.339726ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [release public] - 2.675564ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [repository public] - 20.563488ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [repository public] - 3.502655ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [repo_indexer_status public] - 16.506332ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [repo_indexer_status public] - 2.210848ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [repo_unit public] - 15.655136ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [repo_unit public] - 2.276328ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [star public] - 15.710112ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [star public] - 2.228626ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [topic public] - 15.75216ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [topic public] - 2.292655ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [repo_topic public] - 15.159155ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [repo_topic public] - 2.243855ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [upload public] - 16.469762ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [upload public] - 2.238225ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [watch public] - 16.072459ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [watch public] - 2.335727ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [gpg_key public] - 16.415354ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [gpg_key public] - 2.273073ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [gpg_key_import public] - 15.152145ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [gpg_key_import public] - 2.167877ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [public_key public] - 16.284923ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [public_key public] - 2.224275ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [deploy_key public] - 16.686161ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [deploy_key public] - 2.340115ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [secret public] - 16.483693ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [secret public] - 2.270831ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [org_user public] - 15.208458ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [org_user public] - 2.460885ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [team public] - 16.322509ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [team public] - 2.154106ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [team_user public] - 15.284242ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [team_user public] - 2.272143ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [team_repo public] - 15.412431ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [team_repo public] - 2.328891ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [team_unit public] - 15.455757ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [team_unit public] - 2.297664ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [team_invite public] - 15.940393ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [team_invite public] - 2.607461ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [access public] - 15.372778ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [access public] - 2.181374ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [deleted_branch public] - 15.585339ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [deleted_branch public] - 2.412513ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [renamed_branch public] - 15.851649ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [renamed_branch public] - 2.135262ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [commit_status public] - 16.222902ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [commit_status public] - 2.730387ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [commit_status_index public] - 16.192842ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [commit_status_index public] - 2.297321ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [lfs_meta_object public] - 15.549811ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [lfs_meta_object public] - 2.490242ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [lfs_lock public] - 15.358621ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [lfs_lock public] - 2.131587ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [protected_branch public] - 17.637632ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [protected_branch public] - 2.128032ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [protected_tag public] - 15.608052ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [protected_tag public] - 1.978322ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [project_board public] - 15.768988ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [project_board public] - 2.226653ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [project_issue public] - 15.410992ms
2023/05/08 05:14:39 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [project_issue public] - 2.263542ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [project public] - 16.272312ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [project public] - 2.5514ms
2023/05/08 05:14:40 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INTEGER, struct type is BIGINT
2023/05/08 05:14:40 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT
2023/05/08 05:14:40 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is
2023/05/08 05:14:40 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/05/08 05:14:40 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INTEGER, struct type is BIGINT
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [pull_auto_merge public] - 15.990376ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [pull_auto_merge public] - 2.035538ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [review_state public] - 16.248522ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [review_state public] - 2.208468ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue_assignees public] - 15.226315ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue_assignees public] - 2.11071ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [comment public] - 18.675387ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [comment public] - 2.813062ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue_content_history public] - 15.559053ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue_content_history public] - 2.193864ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue_dependency public] - 16.353427ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue_dependency public] - 2.161986ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue public] - 16.973513ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue public] - 2.852558ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue_index public] - 15.463142ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue_index public] - 2.343198ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue_user public] - 15.704117ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue_user public] - 2.153694ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue_watch public] - 15.638498ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue_watch public] - 2.179397ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [label public] - 15.971228ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [label public] - 2.376759ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [issue_label public] - 15.25491ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [issue_label public] - 2.431048ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [milestone public] - 16.1565ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [milestone public] - 2.195413ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [pull_request public] - 16.865222ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [pull_request public] - 2.51901ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [reaction public] - 15.842485ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [reaction public] - 2.960375ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [review public] - 17.793841ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [review public] - 2.446956ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [stopwatch public] - 16.565475ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [stopwatch public] - 2.377449ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [tracked_time public] - 16.237614ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [tracked_time public] - 2.347049ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action_run public] - 16.670397ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action_run public] - 2.542051ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action_run_index public] - 15.027637ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action_run_index public] - 2.129088ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action_run_job public] - 16.591044ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action_run_job public] - 2.547885ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action_runner public] - 16.495869ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action_runner public] - 2.522062ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action_runner_token public] - 16.259782ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action_runner_token public] - 2.284245ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action_task public] - 17.04719ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action_task public] - 2.837784ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action_task_step public] - 16.407084ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action_task_step public] - 2.489947ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [hook_task public] - 16.163352ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [hook_task public] - 2.213467ms
2023/05/08 05:14:40 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [webhook public] - 16.539267ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [webhook public] - 2.469516ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [action public] - 16.117917ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [action public] - 2.841902ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [notification public] - 16.322337ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [notification public] - 2.841652ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [task public] - 16.035209ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [task public] - 2.424494ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [dbfs_meta public] - 15.707687ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [dbfs_meta public] - 2.181291ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [dbfs_data public] - 15.552022ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [dbfs_data public] - 2.20276ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [repo_transfer public] - 15.787165ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [repo_transfer public] - 2.228595ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [package public] - 16.812103ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [package public] - 2.541489ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [package_blob public] - 15.834665ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [package_blob public] - 2.660074ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [package_blob_upload public] - 15.732797ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [package_blob_upload public] - 2.200478ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [package_cleanup_rule public] - 16.566537ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [package_cleanup_rule public] - 2.42599ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [package_file public] - 15.782784ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [package_file public] - 2.647371ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [package_property public] - 15.893656ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [package_property public] - 2.408229ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r'::char AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [package_version public] - 15.992354ms
2023/05/08 05:14:40 models/db/engine.go:125:SyncAllTables() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [package_version public] - 2.470751ms
2023/05/08 05:14:40 routers/init.go:149:GlobalInitInstalled() [I] ORM engine initialization successful!
2023/05/08 05:14:40 ...odels/auth/oauth2.go:539:GetActiveOAuth2ProviderSources() [I] [SQL] SELECT "id", "type", "name", "is_active", "is_sync_enabled", "cfg", "created_unix", "updated_unix" FROM "login_source" WHERE (is_active = $1 and type = $2) [true OAuth2] - 1.45581ms
2023/05/08 05:14:40 ...ls/system/setting.go:134:GetSettings() [I] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 1.13366ms
2023/05/08 05:14:40 ...ls/system/setting.go:134:GetSettings() [I] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 740.558µs
2023/05/08 05:14:40 ...ls/system/setting.go:134:GetSettings() [I] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 788.402µs
2023/05/08 05:14:40 ...ls/system/setting.go:134:GetSettings() [I] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 754.288µs
2023/05/08 05:14:40 ...ueue_disk_channel.go:159:Run() [D] [64588540] PersistableChannelQueue: push_update Starting
2023/05/08 05:14:40 ...ueue_disk_channel.go:196:Run() [D] [64588540] PersistableChannelQueue: push_update Skipping running the empty level queue
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:334:Shutdown() [D] [64588540] level: push_update-level Shutdown
2023/05/08 05:14:40 ...er/issues/indexer.go:173:func2() [I] [64588540-3] PID 17: Initializing Issue Indexer: bleve
2023/05/08 05:14:40 ...ueue_disk_channel.go:188:Run() [D] [64588540-5] PersistableChannelUniqueQueue: repo_stats_update Starting
2023/05/08 05:14:40 ...ueue_disk_channel.go:234:Run() [D] [64588540-5] PersistableChannelUniqueQueue: repo_stats_update Skipping running the empty level queue
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:334:Shutdown() [D] [64588540-5] unique-level: repo_stats_update-level Shutdown
2023/05/08 05:14:40 ...xer/stats/indexer.go:38:populateRepoIndexer() [I] Populating the repo stats indexer with existing repositories
2023/05/08 05:14:40 ...ueue_disk_channel.go:188:Run() [D] [64588540-9] PersistableChannelUniqueQueue: webhook_sender Starting
2023/05/08 05:14:40 ...ueue_disk_channel.go:234:Run() [D] [64588540-9] PersistableChannelUniqueQueue: webhook_sender Skipping running the empty level queue
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:334:Shutdown() [D] [64588540-9] unique-level: webhook_sender-level Shutdown
2023/05/08 05:14:40 ...ueue_disk_channel.go:188:Run() [D] [64588540-7] PersistableChannelUniqueQueue: mirror Starting
2023/05/08 05:14:40 ...ueue_disk_channel.go:234:Run() [D] [64588540-7] PersistableChannelUniqueQueue: mirror Skipping running the empty level queue
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:334:Shutdown() [D] [64588540-7] unique-level: mirror-level Shutdown
2023/05/08 05:14:40 ...er/issues/indexer.go:203:func2() [D] [64588540-3] Created Bleve Indexer
2023/05/08 05:14:40 ...er/issues/indexer.go:269:func3() [I] [64588540-3] Issue Indexer Initialization took 1.341927ms
2023/05/08 05:14:40 ...ueue_disk_channel.go:188:Run() [D] [64588540-13] PersistableChannelUniqueQueue: pr_auto_merge Starting
2023/05/08 05:14:40 ...ueue_disk_channel.go:159:Run() [D] [64588540-15] PersistableChannelQueue: task Starting
2023/05/08 05:14:40 ...ueue_disk_channel.go:188:Run() [D] [64588540-11] PersistableChannelUniqueQueue: pr_patch_checker Starting
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:158:Run() [D] [64588540-4] level: issue_indexer Starting
2023/05/08 05:14:40 ...ueue_disk_channel.go:234:Run() [D] [64588540-13] PersistableChannelUniqueQueue: pr_auto_merge Skipping running the empty level queue
2023/05/08 05:14:40 ...ueue_disk_channel.go:196:Run() [D] [64588540-15] PersistableChannelQueue: task Skipping running the empty level queue
2023/05/08 05:14:40 ...ueue_disk_channel.go:234:Run() [D] [64588540-11] PersistableChannelUniqueQueue: pr_patch_checker Skipping running the empty level queue
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:334:Shutdown() [D] [64588540-15] level: task-level Shutdown
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:334:Shutdown() [D] [64588540-13] unique-level: pr_auto_merge-level Shutdown
2023/05/08 05:14:40 ...ue/queue_bytefifo.go:334:Shutdown() [D] [64588540-11] unique-level: pr_patch_checker-level Shutdown
2023/05/08 05:14:40 .../runtime/asm_amd64.s:1598:goexit() [I] [SQL] SELECT 1 FROM "repository" LIMIT 1 [] - 3.901192ms
2023/05/08 05:14:40 models/db/engine.go:286:GetMaxID() [I] [SQL] SELECT MAX(id) FROM "repository" LIMIT 1 [] - 1.57938ms
2023/05/08 05:14:40 .../issues/pull_list.go:128:GetPullRequestIDsByCheckStatus() [I] [SQL] SELECT "pull_request"."id" FROM "pull_request" WHERE (status=$1) [CHECKING] - 7.851971ms
2023/05/08 05:14:40 ...repo/repo_indexer.go:61:GetUnindexedRepos() [I] [SQL] SELECT "repository"."id" FROM "repository" LEFT OUTER JOIN "repo_indexer_status" ON repository.id = repo_indexer_status.repo_id AND repo_indexer_status.indexer_type = $1 WHERE repo_indexer_status.id IS NULL AND repository.is_empty=$2 AND repository.id<=$3 ORDER BY "repository"."id" DESC LIMIT 50 [1 false 20] - 3.066261ms
2023/05/08 05:14:40 ...xer/stats/indexer.go:84:populateRepoIndexer() [I] Done (re)populating the repo stats indexer with existing repositories
2023/05/08 05:14:40 ...bfc5ce9830/engine.go:1244:Get() [I] [SQL] SELECT "id", "revision", "content" FROM "app_state" WHERE "id"=$1 LIMIT 1 [runtime-state] - 9.455168ms
2023/05/08 05:14:40 .../webhook/hooktask.go:185:FindUndeliveredHookTaskIDs() [I] [64588540-17] [SQL] SELECT id FROM "hook_task" WHERE (is_delivered=$1) AND (id > $2) ORDER BY "id" ASC LIMIT 100 [false 0] - 9.173959ms
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: update_mirrors
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: repo_health_check
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: check_repo_stats
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: archive_cleanup
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: sync_external_users
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: deleted_branches_cleanup
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: update_migration_poster_id
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: cleanup_hook_task_table
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: cleanup_packages
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: delete_inactive_accounts
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: delete_repo_archives
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: git_gc_repos
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: resync_all_sshkeys
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: resync_all_sshprincipals
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: resync_all_hooks
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: reinit_missing_repos
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: delete_missing_repos
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: delete_generated_repository_avatars
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: delete_old_actions
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: update_checker
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: delete_old_system_notices
2023/05/08 05:14:40 ...rvices/cron/tasks.go:147:RegisterTask() [D] [64588540-19] Registering task: gc_lfs
2023/05/08 05:14:40 routers/init.go:185:NormalRoutes() [D] Creating static HTML Renderer
2023/05/08 05:14:40 ...rvices/cron/tasks.go:99:func2() [I] [64588540-20] [SQL] DELETE FROM "deleted_branch" WHERE (deleted_unix < $1) [1683436480] - 5.295931ms
2023/05/08 05:14:40 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [64588540-21] [SQL] SELECT "external_id", "user_id", "login_source_id", "raw_data", "provider", "email", "name", "first_name", "last_name", "nick_name", "description", "avatar_url", "location", "access_token", "access_token_secret", "refresh_token", "expires_at" FROM "external_login_user" WHERE provider=$1 ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [github] - 5.970507ms
2023/05/08 05:14:40 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [64588540-21] [SQL] SELECT "external_id", "user_id", "login_source_id", "raw_data", "provider", "email", "name", "first_name", "last_name", "nick_name", "description", "avatar_url", "location", "access_token", "access_token_secret", "refresh_token", "expires_at" FROM "external_login_user" WHERE provider=$1 ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gitlab] - 1.232364ms
2023/05/08 05:14:40 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [64588540-21] [SQL] SELECT "external_id", "user_id", "login_source_id", "raw_data", "provider", "email", "name", "first_name", "last_name", "nick_name", "description", "avatar_url", "location", "access_token", "access_token_secret", "refresh_token", "expires_at" FROM "external_login_user" WHERE provider=$1 ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gitea] - 1.088862ms
2023/05/08 05:14:40 ...els/repo/archiver.go:142:FindRepoArchives() [I] [64588540-24] [SQL] SELECT "id", "repo_id", "type", "status", "commit_id", "created_unix" FROM "repo_archiver" WHERE created_unix<$1 ORDER BY "created_unix" ASC LIMIT 50 [1683436480] - 9.198518ms
2023/05/08 05:14:40 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [64588540-21] [SQL] SELECT "external_id", "user_id", "login_source_id", "raw_data", "provider", "email", "name", "first_name", "last_name", "nick_name", "description", "avatar_url", "location", "access_token", "access_token_secret", "refresh_token", "expires_at" FROM "external_login_user" WHERE provider=$1 ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gogs] - 1.260567ms
2023/05/08 05:14:40 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [64588540-21] [SQL] SELECT "external_id", "user_id", "login_source_id", "raw_data", "provider", "email", "name", "first_name", "last_name", "nick_name", "description", "avatar_url", "location", "access_token", "access_token_secret", "refresh_token", "expires_at" FROM "external_login_user" WHERE provider=$1 ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [onedev] - 3.707329ms
2023/05/08 05:14:40 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [64588540-21] [SQL] SELECT "external_id", "user_id", "login_source_id", "raw_data", "provider", "email", "name", "first_name", "last_name", "nick_name", "description", "avatar_url", "location", "access_token", "access_token_secret", "refresh_token", "expires_at" FROM "external_login_user" WHERE provider=$1 ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gitbucket] - 4.695155ms
2023/05/08 05:14:40 ...rvices/cron/tasks.go:99:func2() [I] [64588540-22] [SQL] BEGIN TRANSACTION [] - 19.703724ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT repo.id FROM "repository" repo WHERE repo.num_watches!=(SELECT COUNT(*) FROM "watch" WHERE repo_id=repo.id AND mode<>2) [] - 22.824232ms
2023/05/08 05:14:40 ...ternal_login_user.go:195:FindExternalUsersByProvider() [I] [64588540-21] [SQL] SELECT "external_id", "user_id", "login_source_id", "raw_data", "provider", "email", "name", "first_name", "last_name", "nick_name", "description", "avatar_url", "location", "access_token", "access_token_secret", "refresh_token", "expires_at" FROM "external_login_user" WHERE provider=$1 ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [codebase] - 4.956466ms
2023/05/08 05:14:40 models/db/iterate.go:24:]() [I] [64588540-22] [SQL] SELECT "id", "enabled", "owner_id", "type", "keep_count", "keep_pattern", "remove_days", "remove_pattern", "match_full_name", "created_unix", "updated_unix" FROM "package_cleanup_rule" WHERE enabled=$1 LIMIT 50 [true] - 5.800103ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT repo.id FROM "repository" repo WHERE repo.num_stars!=(SELECT COUNT(*) FROM "star" WHERE repo_id=repo.id) [] - 3.886755ms
2023/05/08 05:14:40 ...ckage_blob_upload.go:78:FindExpiredBlobUploads() [I] [64588540-22] [SQL] SELECT "id", "bytes_received", "hash_state_bytes", "created_unix", "updated_unix" FROM "package_blob_upload" WHERE (updated_unix < $1) [1683436480] - 3.702669ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT repo.id FROM "repository" repo WHERE repo.num_issues!=(SELECT COUNT(*) FROM "issue" WHERE repo_id=repo.id AND is_pull=$1) [false] - 9.721287ms
2023/05/08 05:14:40 .../container/search.go:252:SearchExpiredUploadedBlobs() [I] [64588540-22] [SQL] SELECT * FROM "package_file" INNER JOIN "package_version" ON package_version.id = package_file.version_id INNER JOIN "package" ON package.id = package_version.package_id WHERE package.type=$1 AND package_version.is_internal=$2 AND package_version.lower_version=$3 AND package_file.created_unix<$4 [container true _upload 1683436480] - 7.578546ms
2023/05/08 05:14:40 ...s/package_version.go:295:SearchVersions() [I] [64588540-22] [SQL] SELECT * FROM "package_version" INNER JOIN "package" ON package.id = package_version.package_id WHERE package_version.is_internal=$1 AND package.type=$2 AND package_version.lower_version=$3 AND NOT EXISTS (SELECT package_file.id FROM package_file WHERE package_file.version_id = package_version.id) ORDER BY "package_version"."created_unix" DESC [true container _upload] - 2.579918ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT repo.id FROM "repository" repo WHERE repo.num_closed_issues!=(SELECT COUNT(*) FROM "issue" WHERE repo_id=repo.id AND is_closed=$1 AND is_pull=$2) [true false] - 4.259593ms
2023/05/08 05:14:40 ...s/package_version.go:295:SearchVersions() [I] [64588540-22] [SQL] SELECT count(*) FROM "package_version" INNER JOIN "package" ON package.id = package_version.package_id WHERE package_version.is_internal=$1 AND package.type=$2 AND package_version.lower_version=$3 AND NOT EXISTS (SELECT package_file.id FROM package_file WHERE package_file.version_id = package_version.id) [true container _upload] - 1.798212ms
2023/05/08 05:14:40 .../packages/package.go:256:FindUnreferencedPackages() [I] [64588540-22] [SQL] SELECT "id", "owner_id", "repo_id", "type", "name", "lower_name", "semver_compatible" FROM "package" WHERE package.id IN (SELECT id FROM (SELECT package.id FROM package LEFT JOIN package_version ON package_version.package_id = package.id WHERE package_version.id IS NULL) temp) [] - 1.936939ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT repo.id FROM "repository" repo WHERE repo.num_pulls!=(SELECT COUNT(*) FROM "issue" WHERE repo_id=repo.id AND is_pull=$1) [true] - 3.994847ms
2023/05/08 05:14:40 ...ages/package_blob.go:78:FindExpiredUnreferencedBlobs() [I] [64588540-22] [SQL] SELECT * FROM "package_blob" LEFT JOIN "package_file" ON package_file.blob_id = package_blob.id WHERE (package_file.id IS NULL AND package_blob.created_unix < $1) [1683436480] - 2.259531ms
2023/05/08 05:14:40 .../graceful/manager.go:114:RunWithShutdownContext() [I] [64588540-22] [SQL] COMMIT [] - 368.028µs
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT repo.id FROM "repository" repo WHERE repo.num_closed_pulls!=(SELECT COUNT(*) FROM "issue" WHERE repo_id=repo.id AND is_closed=$1 AND is_pull=$2) [true true] - 4.207343ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT label.id FROM "label" WHERE label.num_issues!=(SELECT COUNT(*) FROM "issue_label" WHERE label_id=label.id) [] - 2.604681ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT "label".id FROM "label" WHERE "label".num_closed_issues!=(SELECT COUNT(*) FROM "issue_label","issue" WHERE "issue_label".label_id="label".id AND "issue_label".issue_id="issue".id AND "issue".is_closed=$1) [true] - 7.677983ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT "milestone".id FROM "milestone" WHERE "milestone".num_closed_issues!=(SELECT COUNT(*) FROM "issue" WHERE "issue".milestone_id="milestone".id AND "issue".is_closed=$1) OR "milestone".num_issues!=(SELECT COUNT(*) FROM "issue" WHERE "issue".milestone_id="milestone".id) [true] - 2.044213ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT "user".id FROM "user" WHERE "user".num_repos!=(SELECT COUNT(*) FROM "repository" WHERE owner_id="user".id) [] - 2.47529ms
2023/05/08 05:14:40 models/repo.go:529:CheckRepoStats() [I] [64588540-23] [SQL] SELECT "issue".id FROM "issue" WHERE "issue".num_comments!=(SELECT COUNT(*) FROM "comment" WHERE issue_id="issue".id AND type=0) [] - 5.607429ms
2023/05/08 05:14:40 ...rvices/cron/tasks.go:99:func2() [I] [64588540-23] [SQL] SELECT repo.id FROM "repository" repo WHERE repo.num_forks!=(SELECT COUNT(*) FROM "repository" WHERE fork_id=repo.id) [] - 1.26855ms
2023/05/08 05:14:41 cmd/web.go:220:listen() [I] [64588541-2] Listen: http://0.0.0.0:3000
2023/05/08 05:14:41 cmd/web.go:224:listen() [I] [64588541-2] AppURL(ROOT_URL): https://mssgmserver.ddns.net:3001/
2023/05/08 05:14:41 cmd/web.go:227:listen() [I] [64588541-2] LFS server enabled
2023/05/08 05:14:41 ...s/graceful/server.go:62:NewServer() [I] [64588541-2] Starting new Web server: tcp:0.0.0.0:3000 on PID: 17
2023/05/08 05:14:41 ...s/graceful/server.go:75:func1() [D] [64588541-2] Starting server on tcp:0.0.0.0:3000 (PID: 17)
2023/05/08 05:14:47 models/user/user.go:933:GetUserByID() [I] [64588547] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 2.258182ms
2023/05/08 05:14:47 .../issues/stopwatch.go:139:HasUserStopwatch() [I] [64588547] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (user_id = $1) LIMIT 1 [2] - 1.370123ms
2023/05/08 05:14:47 models/user/user.go:962:GetUserByName() [I] [64588547] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "lower_name"=$1 LIMIT 1 [test_org] - 1.190067ms
2023/05/08 05:14:47 ...bfc5ce9830/engine.go:1244:Get() [I] [64588547] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 [3 axmol] - 2.109444ms
2023/05/08 05:14:47 ...epo/collaboration.go:84:IsCollaborator() [I] [64588547] [SQL] SELECT "id", "repo_id", "user_id", "mode", "created_unix", "updated_unix" FROM "collaboration" WHERE "repo_id"=$1 AND "user_id"=$2 LIMIT 1 [11 2] - 1.646466ms
2023/05/08 05:14:47 ...ls/repo/repo_unit.go:223:getUnitsByRepoID() [I] [64588547] [SQL] SELECT "id", "repo_id", "type", "config", "created_unix" FROM "repo_unit" WHERE (repo_id = $1) [11] - 1.307663ms
2023/05/08 05:14:47 ...s/repo/pushmirror.go:117:GetPushMirrorsByRepoID() [I] [64588547] [SQL] SELECT "id", "repo_id", "remote_name", "sync_on_commit", "interval", "created_unix", "last_update", "last_error" FROM "push_mirror" WHERE (repo_id = $1) [11] - 1.481977ms
2023/05/08 05:14:47 ...s/repo/pushmirror.go:117:GetPushMirrorsByRepoID() [I] [64588547] [SQL] SELECT count(*) FROM "push_mirror" WHERE (repo_id = $1) [11] - 909.41µs
2023/05/08 05:14:47 ...ules/context/repo.go:542:RepoAssignment() [I] [64588547] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND sha1<>$2 [11 ] - 2.155754ms
2023/05/08 05:14:47 ...ules/context/repo.go:551:RepoAssignment() [I] [64588547] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND is_draft=$2 AND is_tag=$3 [11 false false] - 1.186998ms
2023/05/08 05:14:47 ...ules/context/repo.go:567:RepoAssignment() [I] [64588547] [SQL] SELECT 1 FROM "repository" WHERE (owner_id=$1 AND fork_id=$2) LIMIT 1 [2 11] - 1.180063ms
2023/05/08 05:14:47 models/repo/fork.go:47:GetUserFork() [I] [64588547] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE (fork_id = $1) AND (owner_id = $2) LIMIT 1 [11 2] - 1.49297ms
2023/05/08 05:14:47 models/repo/fork.go:93:FindUserOrgForks() [I] [64588547] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE fork_id=$1 AND owner_id IN (SELECT org_id FROM org_user WHERE uid=$2) [11 2] - 2.51277ms
2023/05/08 05:14:47 ...bfc5ce9830/engine.go:1244:Get() [I] [64588547] [SQL] SELECT "id", "user_id", "repo_id", "mode", "created_unix", "updated_unix" FROM "watch" WHERE "user_id"=$1 AND "repo_id"=$2 LIMIT 1 [2 11] - 1.484982ms
2023/05/08 05:14:47 models/repo/star.go:70:IsStaring() [I] [64588547] [SQL] SELECT "id", "uid", "repo_id", "created_unix" FROM "star" WHERE "uid"=$1 AND "repo_id"=$2 LIMIT 1 [2 11] - 1.276871ms
2023/05/08 05:14:47 models/repo/repo.go:664:GetRepositoryByID() [I] [64588547] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id"=$1 LIMIT 1 [10] - 1.171657ms
2023/05/08 05:14:47 models/user/user.go:933:GetUserByID() [I] [64588547] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.14755ms
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/tags/ --sort=-taggerdate
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/heads/ --sort=-committerdate
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-list --count 7e1f67ca1a1d000f58684383b727d36df5f505e9
2023/05/08 05:14:47 ...ers/web/repo/view.go:712:Home() [I] [64588547] [SQL] UPDATE "notification" SET "status" = $1, "updated_unix" = $2 WHERE repo_id=$3 AND source=$4 AND status=$5 AND user_id=$6 [2 1683522887 2 4 1 11] - 2.039408ms
2023/05/08 05:14:47 models/repo/topic.go:206:FindTopics() [I] [64588547] [SQL] SELECT topic.* FROM "topic" INNER JOIN "repo_topic" ON repo_topic.topic_id = topic.id WHERE repo_topic.repo_id=$1 ORDER BY topic.name [11] - 2.07727ms
2023/05/08 05:14:47 models/repo/topic.go:206:FindTopics() [I] [64588547] [SQL] SELECT count(*) FROM "topic" INNER JOIN "repo_topic" ON repo_topic.topic_id = topic.id WHERE repo_topic.repo_id=$1 [11] - 1.026514ms
2023/05/08 05:14:47 ...po/language_stats.go:104:GetLanguageStats() [I] [64588547] [SQL] SELECT "id", "repo_id", "commit_id", "is_primary", "language", "size", "created_unix" FROM "language_stat" WHERE ("repo_id" = $1) ORDER BY "size" DESC [11] - 1.641549ms
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z 7e1f67ca1a1d000f58684383b727d36df5f505e9 -- .clang-format .editorconfig .gitattributes .github .gitignore APPENDIX.md AUTHORS CHANGELOG CMakeLists.txt CMakeOptions.md CONTRIBUTING.md LICENSE README.md README_CN.md RENAMED_TYPES.md cmake core docs extensions fix-git-status.bat install-deps-linux.sh setup.py templates tests thirdparty tools
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:cmake:902ee8cec05c448af999f6df8f4f8308265eca3b]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9::902ee8cec05c448af999f6df8f4f8308265eca3b]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:thirdparty:902ee8cec05c448af999f6df8f4f8308265eca3b]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:core:e06d293a006621b01f0ed7f9143b2a1d9be37e3c]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:extensions:0e4665e92ed3d90ce63d81ddf2c6400a4060651b]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:README.md:6d63c66d09327f0b10a74ce23cd33943ad99c3cc]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:templates:ffeccb789ced7f3cb96bcd7f46ef9ac5baccd642]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:tests:ffeccb789ced7f3cb96bcd7f46ef9ac5baccd642]
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z ffeccb789ced7f3cb96bcd7f46ef9ac5baccd642 -- .clang-format .editorconfig .gitattributes .github .gitignore APPENDIX.md AUTHORS CHANGELOG CMakeLists.txt CMakeOptions.md CONTRIBUTING.md LICENSE README_CN.md RENAMED_TYPES.md docs fix-git-status.bat install-deps-linux.sh setup.py tools
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:tools:1d29be8613211c3e4703869e8f83fa86114e96dd]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:install-deps-linux.sh:74f4832120e42c5e1a83bda97bdd2d02682d2221]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:.github:7a24a89ca867d7681d83f9b5034e877a336e6838]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:.gitignore:7a24a89ca867d7681d83f9b5034e877a336e6838]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:README_CN.md:7a24a89ca867d7681d83f9b5034e877a336e6838]
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z 7a24a89ca867d7681d83f9b5034e877a336e6838 -- .clang-format .editorconfig .gitattributes APPENDIX.md AUTHORS CHANGELOG CMakeLists.txt CMakeOptions.md CONTRIBUTING.md LICENSE RENAMED_TYPES.md docs fix-git-status.bat setup.py
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:CMakeOptions.md:1671ac462c08d4592b5b95a90ad265c4a02dbf55]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:CMakeLists.txt:1a537a7a988e10a0a451d161e3eb9056dbd125f0]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:fix-git-status.bat:b46417809d0a8344f609050538899870c7bc78a2]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:CHANGELOG:76630577b2c25ff3221d3dbcd2ca9428d5ce0456]
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z 76630577b2c25ff3221d3dbcd2ca9428d5ce0456 -- .clang-format .editorconfig .gitattributes APPENDIX.md AUTHORS CONTRIBUTING.md LICENSE RENAMED_TYPES.md docs setup.py
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:.clang-format:1e1f0568ac8f8b9cb48db78a284d94611d95eac7]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:setup.py:b5cde53994d20aaa32d432b3bd68751b382a293f]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:docs:3f0df4a3480f34d2668c1996c83edbdca6b5b595]
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z 3f0df4a3480f34d2668c1996c83edbdca6b5b595 -- .editorconfig .gitattributes APPENDIX.md AUTHORS CONTRIBUTING.md LICENSE RENAMED_TYPES.md
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:APPENDIX.md:5645bb241e83586bc634dcd567818f4359ccb60c]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:CONTRIBUTING.md:5645bb241e83586bc634dcd567818f4359ccb60c]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:RENAMED_TYPES.md:5645bb241e83586bc634dcd567818f4359ccb60c]
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z 5645bb241e83586bc634dcd567818f4359ccb60c -- .editorconfig .gitattributes AUTHORS LICENSE
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:.editorconfig:8c359917f79e8145a71fee2c98f066329046691f]
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:AUTHORS:8c359917f79e8145a71fee2c98f066329046691f]
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z 8c359917f79e8145a71fee2c98f066329046691f -- .gitattributes LICENSE
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:LICENSE:4aed0766cc491dc1c8a64151dc0131cfe6b9475c]
2023/05/08 05:14:47 ...dules/git/command.go:255:Run() [D] [64588547] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --name-status -c --format=commit%x00%H %P%x00 --parents --no-renames -t -z 4aed0766cc491dc1c8a64151dc0131cfe6b9475c -- .gitattributes
2023/05/08 05:14:47 ...last_commit_cache.go:58:Put() [D] [64588547] LastCommitCache save: [7e1f67ca1a1d000f58684383b727d36df5f505e9:.gitattributes:9c99f3160a49fd2f26f27158049f7a8377c15915]
2023/05/08 05:14:47 models/user/user.go:1113:GetUserByEmail() [I] [64588547] [SQL] SELECT "id", "uid", "email", "lower_email", "is_activated", "is_primary" FROM "email_address" WHERE "lower_email"=$1 LIMIT 1 [EMAIL@REMOVED] - 1.450333ms
2023/05/08 05:14:47 models/user/user.go:933:GetUserByID() [I] [64588547] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.177501ms
2023/05/08 05:14:47 models/user/user.go:1113:GetUserByEmail() [I] [64588547] [SQL] SELECT "id", "uid", "email", "lower_email", "is_activated", "is_primary" FROM "email_address" WHERE "lower_email"=$1 LIMIT 1 [EMAIL@REMOVED] - 832.482µs
2023/05/08 05:14:47 models/user/user.go:933:GetUserByID() [I] [64588547] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.133355ms
2023/05/08 05:14:47 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588547] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 7e1f67ca1a1d000f58684383b727d36df5f505e9] - 2.163248ms
2023/05/08 05:14:47 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588547] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 7e1f67ca1a1d000f58684383b727d36df5f505e9] - 1.054274ms
2023/05/08 05:14:47 ...ers/web/repo/view.go:100:findReadmeFileInEntries() [D] [64588547] Potential readme file: README.md
2023/05/08 05:14:47 ...s/charset/charset.go:153:DetectEncoding() [D] [64588547] Detected encoding: utf-8 (fast)
2023/05/08 05:14:47 models/repo/repo.go:433:ComposeMetas() [I] [64588547] [SQL] SELECT team.lower_name FROM "team_repo" INNER JOIN "team" ON team.id = team_repo.team_id WHERE (team_repo.repo_id = $1) ORDER BY team.lower_name [11] - 1.880393ms
2023/05/08 05:14:47 models/user/user.go:962:GetUserByName() [I] [64588547] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "lower_name"=$1 LIMIT 1 [pietpukkel] - 1.176714ms
2023/05/08 05:14:47 ...s/context/context.go:222:HTML() [D] [64588547] Template: repo/home
2023/05/08 05:14:47 ...ls/system/setting.go:134:GetSettings() [I] [64588547] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 1.750483ms
2023/05/08 05:14:47 ...user/notification.go:45:func1() [I] [64588547] [SQL] SELECT count(*) FROM "notification" WHERE (user_id = $1) AND (status = $2) [2 1] - 929.445µs
2023/05/08 05:14:48 models/user/user.go:933:GetUserByID() [I] [64588548] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.257424ms
2023/05/08 05:14:48 .../issues/stopwatch.go:139:HasUserStopwatch() [I] [64588548] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (user_id = $1) LIMIT 1 [2] - 797.298µs
2023/05/08 05:14:49 models/user/user.go:933:GetUserByID() [I] [64588549] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.253354ms
2023/05/08 05:14:49 .../issues/stopwatch.go:139:HasUserStopwatch() [I] [64588549] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (user_id = $1) LIMIT 1 [2] - 772.636µs
2023/05/08 05:14:49 models/user/user.go:962:GetUserByName() [I] [64588549] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "lower_name"=$1 LIMIT 1 [test_org] - 1.123556ms
2023/05/08 05:14:49 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 [3 axmol] - 1.246008ms
2023/05/08 05:14:49 ...epo/collaboration.go:84:IsCollaborator() [I] [64588549] [SQL] SELECT "id", "repo_id", "user_id", "mode", "created_unix", "updated_unix" FROM "collaboration" WHERE "repo_id"=$1 AND "user_id"=$2 LIMIT 1 [11 2] - 825.416µs
2023/05/08 05:14:49 ...ls/repo/repo_unit.go:223:getUnitsByRepoID() [I] [64588549] [SQL] SELECT "id", "repo_id", "type", "config", "created_unix" FROM "repo_unit" WHERE (repo_id = $1) [11] - 799.513µs
2023/05/08 05:14:49 ...s/repo/pushmirror.go:117:GetPushMirrorsByRepoID() [I] [64588549] [SQL] SELECT "id", "repo_id", "remote_name", "sync_on_commit", "interval", "created_unix", "last_update", "last_error" FROM "push_mirror" WHERE (repo_id = $1) [11] - 798.524µs
2023/05/08 05:14:49 ...s/repo/pushmirror.go:117:GetPushMirrorsByRepoID() [I] [64588549] [SQL] SELECT count(*) FROM "push_mirror" WHERE (repo_id = $1) [11] - 797.411µs
2023/05/08 05:14:49 ...ules/context/repo.go:542:RepoAssignment() [I] [64588549] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND sha1<>$2 [11 ] - 872.219µs
2023/05/08 05:14:49 ...ules/context/repo.go:551:RepoAssignment() [I] [64588549] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND is_draft=$2 AND is_tag=$3 [11 false false] - 855.265µs
2023/05/08 05:14:49 ...ules/context/repo.go:567:RepoAssignment() [I] [64588549] [SQL] SELECT 1 FROM "repository" WHERE (owner_id=$1 AND fork_id=$2) LIMIT 1 [2 11] - 857.039µs
2023/05/08 05:14:49 models/repo/fork.go:47:GetUserFork() [I] [64588549] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE (fork_id = $1) AND (owner_id = $2) LIMIT 1 [11 2] - 1.201065ms
2023/05/08 05:14:49 models/repo/fork.go:93:FindUserOrgForks() [I] [64588549] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE fork_id=$1 AND owner_id IN (SELECT org_id FROM org_user WHERE uid=$2) [11 2] - 1.654635ms
2023/05/08 05:14:49 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "user_id", "repo_id", "mode", "created_unix", "updated_unix" FROM "watch" WHERE "user_id"=$1 AND "repo_id"=$2 LIMIT 1 [2 11] - 810.68µs
2023/05/08 05:14:49 models/repo/star.go:70:IsStaring() [I] [64588549] [SQL] SELECT "id", "uid", "repo_id", "created_unix" FROM "star" WHERE "uid"=$1 AND "repo_id"=$2 LIMIT 1 [2 11] - 782.213µs
2023/05/08 05:14:49 models/repo/repo.go:664:GetRepositoryByID() [I] [64588549] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id"=$1 LIMIT 1 [10] - 1.123306ms
2023/05/08 05:14:49 models/user/user.go:933:GetUserByID() [I] [64588549] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.122916ms
2023/05/08 05:14:49 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2023/05/08 05:14:49 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/tags/ --sort=-taggerdate
2023/05/08 05:14:49 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2023/05/08 05:14:49 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2023/05/08 05:14:49 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/heads/ --sort=-committerdate
2023/05/08 05:14:49 ...rs/web/repo/issue.go:420:Issues() [I] [64588549] [SQL] SELECT 1 FROM "repository" WHERE (owner_id=$1 AND fork_id=$2) LIMIT 1 [2 11] - 910.944µs
2023/05/08 05:14:49 ...dels/issues/issue.go:1627:GetIssueStats() [I] [64588549] [SQL] SELECT count(*) FROM "issue" WHERE (issue.repo_id = $1) AND (issue.is_pull=$2) AND (issue.is_closed = $3) [11 true false] - 1.195805ms
2023/05/08 05:14:49 ...dels/issues/issue.go:1627:GetIssueStats() [I] [64588549] [SQL] SELECT count(*) FROM "issue" WHERE (issue.repo_id = $1) AND (issue.is_pull=$2) AND (issue.is_closed = $3) [11 true true] - 1.169951ms
2023/05/08 05:14:49 ...dels/issues/issue.go:1522:Issues() [I] [64588549] [SQL] SELECT * FROM "issue" INNER JOIN "repository" ON "issue".repo_id = "repository".id WHERE issue.repo_id=$1 AND (issue.is_closed=$2) AND (issue.is_pull=$3) ORDER BY "issue"."created_unix" DESC, "issue"."id" DESC LIMIT 20 [11 true true] - 3.115432ms
2023/05/08 05:14:49 ...issues/issue_list.go:52:LoadRepositories() [I] [64588549] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id" IN ($1) [11] - 1.093912ms
2023/05/08 05:14:49 ...issues/issue_list.go:110:getPosters() [I] [64588549] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id" IN ($1) [2] - 1.034947ms
2023/05/08 05:14:49 ...issues/issue_list.go:536:loadAttributes() [I] [64588549] [SQL] SELECT * FROM "label" LEFT JOIN "issue_label" ON issue_label.label_id = label.id WHERE "issue_label"."issue_id" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ORDER BY "label"."name" ASC [523 522 499 498 497 496 494 493 491 490 489 488 487 486 485 484 483 482 481 480] - 1.489456ms
2023/05/08 05:14:49 ...issues/issue_list.go:218:loadMilestones() [I] [64588549] [SQL] SELECT "id", "repo_id", "name", "content", "is_closed", "num_issues", "num_closed_issues", "completeness", "created_unix", "updated_unix", "deadline_unix", "closed_date_unix" FROM "milestone" WHERE "id" IN ($1) [0] - 1.030824ms
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [523] - 1.304995ms
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [522] - 710.654µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [499] - 688.955µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [498] - 668.599µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [497] - 730.59µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [496] - 720.302µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [494] - 614.149µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [493] - 530.165µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [491] - 695.699µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [490] - 733.79µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [489] - 697.607µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [488] - 591.76µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [487] - 456.163µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [486] - 759.687µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [485] - 781.095µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [484] - 724.931µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [483] - 734.056µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [482] - 731.08µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [481] - 771.906µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [480] - 717.908µs
2023/05/08 05:14:49 ...issues/issue_list.go:255:loadProjects() [I] [64588549] [SQL] SELECT "id", "title", "description", "owner_id", "repo_id", "creator_id", "is_closed", "board_type", "card_type", "type", "created_unix", "updated_unix", "closed_date_unix" FROM "project" WHERE "id" IN ($1) [0] - 1.747457ms
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [523] - 812.175µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [522] - 802.171µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [499] - 734.443µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [498] - 790.242µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [497] - 624.395µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [496] - 710.076µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [494] - 762.081µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [493] - 706.329µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [491] - 1.568886ms
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [490] - 760.083µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [489] - 737.29µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [488] - 705.752µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [487] - 724.107µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [486] - 723.924µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [485] - 723.038µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [484] - 754.273µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [483] - 747.469µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [482] - 727.191µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [481] - 708.833µs
2023/05/08 05:14:49 ...ues/issue_project.go:37:projectID() [I] [64588549] [SQL] SELECT "id", "issue_id", "project_id", "project_board_id", "sorting" FROM "project_issue" WHERE (issue_id=$1) LIMIT 1 [480] - 716.329µs
2023/05/08 05:14:49 ...issues/issue_list.go:548:loadAttributes() [I] [64588549] [SQL] SELECT * FROM "issue_assignees" INNER JOIN "user" ON "user".id = "issue_assignees".assignee_id WHERE "issue_assignees"."issue_id" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ORDER BY name [523 522 499 498 497 496 494 493 491 490 489 488 487 486 485 484 483 482 481 480] - 2.226712ms
2023/05/08 05:14:49 ...issues/issue_list.go:552:loadAttributes() [I] [64588549] [SQL] SELECT "id", "type", "status", "conflicted_files", "commits_ahead", "commits_behind", "changed_protected_files", "issue_id", "index", "head_repo_id", "base_repo_id", "head_branch", "base_branch", "merge_base", "allow_maintainer_edit", "has_merged", "merged_commit_id", "merger_id", "merged_unix", "flow" FROM "pull_request" WHERE "issue_id" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) [523 522 499 498 497 496 494 493 491 490 489 488 487 486 485 484 483 482 481 480] - 2.325451ms
2023/05/08 05:14:49 ...ls/repo/repo_unit.go:223:getUnitsByRepoID() [I] [64588549] [SQL] SELECT "id", "repo_id", "type", "config", "created_unix" FROM "repo_unit" WHERE (repo_id = $1) [11] - 799.633µs
2023/05/08 05:14:49 ...issues/issue_list.go:556:loadAttributes() [I] [64588549] [SQL] SELECT issue_id, sum(time) as time FROM "tracked_time" WHERE (deleted = $1) AND "issue_id" IN ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21) GROUP BY issue_id [false 523 522 499 498 497 496 494 493 491 490 489 488 487 486 485 484 483 482 481 480] - 1.654608ms
2023/05/08 05:14:49 ...issues/issue_list.go:593:GetApprovalCounts() [I] [64588549] [SQL] SELECT issue_id, type, count(id) as "count" FROM "review" WHERE "issue_id" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) AND (official = $21 AND dismissed = $22) GROUP BY issue_id, type ORDER BY issue_id [523 522 499 498 497 496 494 493 491 490 489 488 487 486 485 484 483 482 481 480 true false] - 2.175474ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 523] - 1.491683ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 522] - 1.432719ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 499] - 1.007581ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 498] - 904.798µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 497] - 929.083µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 496] - 935.501µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 494] - 1.056095ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 493] - 1.07613ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 491] - 912.27µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 490] - 875.732µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 489] - 981.019µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 488] - 912.858µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 487] - 954.444µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 486] - 938.485µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 485] - 929.004µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 484] - 1.062753ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 483] - 1.009657ms
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 482] - 917.193µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 481] - 877.671µs
2023/05/08 05:14:50 ...bfc5ce9830/engine.go:1244:Get() [I] [64588549] [SQL] SELECT "id", "uid", "issue_id", "is_read", "is_mentioned" FROM "issue_user" WHERE "uid"=$1 AND "issue_id"=$2 LIMIT 1 [2 480] - 995.441µs
2023/05/08 05:14:50 ...issues/issue_list.go:52:LoadRepositories() [I] [64588549] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id" IN ($1,$2) [11 10] - 1.747633ms
2023/05/08 05:14:50 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2023/05/08 05:14:50 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2023/05/08 05:14:50 ...dules/git/command.go:255:Run() [D] [64588549] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 7e1f67ca1a1d000f58684383b727d36df5f505e9] - 2.239116ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 7e1f67ca1a1d000f58684383b727d36df5f505e9] - 988.806µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 902ee8cec05c448af999f6df8f4f8308265eca3b] - 1.162171ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 902ee8cec05c448af999f6df8f4f8308265eca3b] - 1.070015ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 bc97e583480135819b0571a43382e25ef5186c40] - 1.082511ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 bc97e583480135819b0571a43382e25ef5186c40] - 937.533µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 cb9f8d969515c6dc33edab7882057abd8731b4c4] - 1.039773ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 cb9f8d969515c6dc33edab7882057abd8731b4c4] - 1.060498ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 6eaa600d214d673a6c3cf3c46169a75536161e50] - 1.072668ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 6eaa600d214d673a6c3cf3c46169a75536161e50] - 1.026375ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 175a9499d138c99c35ef9ddfe9ef99020de5d698] - 1.042246ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 175a9499d138c99c35ef9ddfe9ef99020de5d698] - 965.928µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 e5d2ca69be703ddf7f4d1492657dc38efaa111d6] - 1.049501ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 e5d2ca69be703ddf7f4d1492657dc38efaa111d6] - 1.006473ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 b76db451288bd521abb9896544f3f0023903de8e] - 1.020153ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 b76db451288bd521abb9896544f3f0023903de8e] - 1.015707ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 94160a8b5bece68848b9b8f3859af4b3528631e1] - 1.028074ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 94160a8b5bece68848b9b8f3859af4b3528631e1] - 967.126µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 8f7711b1d885d1fe024ada34ecc07e2f1dfc0655] - 1.048243ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 8f7711b1d885d1fe024ada34ecc07e2f1dfc0655] - 982.384µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 49294ced7105481e4fee292c477d1d91a65c4747] - 1.035021ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 49294ced7105481e4fee292c477d1d91a65c4747] - 972.766µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 eb906e9c69a08a7b1b03d72ed942a3bf5e1d4362] - 1.091552ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 eb906e9c69a08a7b1b03d72ed942a3bf5e1d4362] - 1.268826ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 55ab656f7f8a60c1f65255d8165223736c9fe4a2] - 1.058796ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 55ab656f7f8a60c1f65255d8165223736c9fe4a2] - 884.976µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 73b56fab9138fa1b675c2c44b79a7591a6fe9d4d] - 1.020398ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 73b56fab9138fa1b675c2c44b79a7591a6fe9d4d] - 920.909µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 d5a987f466b60fb66d32a9eea5d6d485ed697444] - 1.006647ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 d5a987f466b60fb66d32a9eea5d6d485ed697444] - 851.615µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 6ad21523331ae5bbe0b1619ccf06f69774fde901] - 1.061999ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 6ad21523331ae5bbe0b1619ccf06f69774fde901] - 871.834µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 a9e609e27dec2b18129e5dc1bfe535567777c159] - 941.198µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 a9e609e27dec2b18129e5dc1bfe535567777c159] - 867.239µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 ee2de093a71ead88c2de6f914b4ce517849eb7be] - 994.783µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 ee2de093a71ead88c2de6f914b4ce517849eb7be] - 920.692µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 cd59b5ceee6df4a6744f6ffc2d47a943ee1e5592] - 1.020221ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 cd59b5ceee6df4a6744f6ffc2d47a943ee1e5592] - 938.797µs
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT max( id ) as id FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash ORDER BY max( id ) desc LIMIT 30 [11 872693b5e029599dc98e322f18f2686b57a88a4d] - 1.024436ms
2023/05/08 05:14:50 ...git/commit_status.go:232:GetLatestCommitStatus() [I] [64588549] [SQL] SELECT count(*) FROM (SELECT context_hash FROM "commit_status" WHERE (repo_id = $1) AND (sha = $2) GROUP BY context_hash) sub [11 872693b5e029599dc98e322f18f2686b57a88a4d] - 918.959µs
2023/05/08 05:14:50 ...ls/repo/user_repo.go:73:GetRepoAssignees() [I] [64588549] [SQL] SELECT user_id FROM "access" WHERE (repo_id = $1 AND mode >= $2) [11 write] - 1.299696ms
2023/05/08 05:14:50 ...ls/repo/user_repo.go:84:GetRepoAssignees() [I] [64588549] [SQL] SELECT DISTINCT "team_user".uid FROM "team_user" INNER JOIN "team_repo" ON "team_repo".team_id = "team_user".team_id INNER JOIN "team_unit" ON "team_unit".team_id = "team_user".team_id WHERE ("team_repo".repo_id = $1 AND "team_unit".access_mode >= $2) [11 write] - 2.111451ms
2023/05/08 05:14:50 ...ls/repo/user_repo.go:96:GetRepoAssignees() [I] [64588549] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id" IN ($1) ORDER BY name [2] - 1.259385ms
2023/05/08 05:14:50 ...ls/repo/user_repo.go:167:GetIssuePosters() [I] [64588549] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "user".id IN (SELECT poster_id FROM issue WHERE repo_id=$1 AND is_pull=$2 GROUP BY poster_id) ORDER BY name [11 true] - 2.251536ms
2023/05/08 05:14:50 .../organization/org.go:129:FindOrgTeams() [I] [64588549] [SQL] SELECT "id", "org_id", "lower_name", "name", "description", "authorize", "num_repos", "num_members", "includes_all_repositories", "can_create_org_repo" FROM "team" WHERE (org_id=$1) ORDER BY CASE WHEN name LIKE 'Owners' THEN '' ELSE name END [3] - 1.314419ms
2023/05/08 05:14:50 ...dels/issues/label.go:415:GetLabelsByRepoID() [I] [64588549] [SQL] SELECT "id", "repo_id", "org_id", "name", "exclusive", "description", "color", "num_issues", "num_closed_issues", "created_unix", "updated_unix" FROM "label" WHERE (repo_id = $1) ORDER BY "name" ASC [11] - 1.070013ms
2023/05/08 05:14:50 ...dels/issues/label.go:518:GetLabelsByOrgID() [I] [64588549] [SQL] SELECT "id", "repo_id", "org_id", "name", "exclusive", "description", "color", "num_issues", "num_closed_issues", "created_unix", "updated_unix" FROM "label" WHERE (org_id = $1) ORDER BY "name" ASC [3] - 844.726µs
2023/05/08 05:14:50 ...rs/web/repo/issue.go:505:retrieveProjects() [I] [64588549] [SQL] SELECT count(*) FROM "project" WHERE repo_id=$1 AND is_closed=$2 AND type=$3 [11 false 2] - 878.609µs
2023/05/08 05:14:50 ...s/project/project.go:246:FindProjects() [I] [64588549] [SQL] SELECT "id", "title", "description", "owner_id", "repo_id", "creator_id", "is_closed", "board_type", "card_type", "type", "created_unix", "updated_unix", "closed_date_unix" FROM "project" WHERE repo_id=$1 AND is_closed=$2 AND type=$3 ORDER BY "created_unix" ASC [11 false 2] - 791.477µs
2023/05/08 05:14:50 ...rs/web/repo/issue.go:515:retrieveProjects() [I] [64588549] [SQL] SELECT count(*) FROM "project" WHERE is_closed=$1 AND type=$2 AND owner_id=$3 [false 3 3] - 702.688µs
2023/05/08 05:14:50 ...s/project/project.go:246:FindProjects() [I] [64588549] [SQL] SELECT "id", "title", "description", "owner_id", "repo_id", "creator_id", "is_closed", "board_type", "card_type", "type", "created_unix", "updated_unix", "closed_date_unix" FROM "project" WHERE is_closed=$1 AND type=$2 AND owner_id=$3 ORDER BY "created_unix" ASC [false 3 3] - 888.818µs
2023/05/08 05:14:50 ...rs/web/repo/issue.go:528:retrieveProjects() [I] [64588549] [SQL] SELECT count(*) FROM "project" WHERE repo_id=$1 AND is_closed=$2 AND type=$3 [11 true 2] - 861.645µs
2023/05/08 05:14:50 ...s/project/project.go:246:FindProjects() [I] [64588549] [SQL] SELECT "id", "title", "description", "owner_id", "repo_id", "creator_id", "is_closed", "board_type", "card_type", "type", "created_unix", "updated_unix", "closed_date_unix" FROM "project" WHERE repo_id=$1 AND is_closed=$2 AND type=$3 ORDER BY "created_unix" ASC [11 true 2] - 931.242µs
2023/05/08 05:14:50 ...rs/web/repo/issue.go:538:retrieveProjects() [I] [64588549] [SQL] SELECT count(*) FROM "project" WHERE is_closed=$1 AND type=$2 AND owner_id=$3 [true 3 3] - 901.618µs
2023/05/08 05:14:50 ...s/project/project.go:246:FindProjects() [I] [64588549] [SQL] SELECT "id", "title", "description", "owner_id", "repo_id", "creator_id", "is_closed", "board_type", "card_type", "type", "created_unix", "updated_unix", "closed_date_unix" FROM "project" WHERE is_closed=$1 AND type=$2 AND owner_id=$3 ORDER BY "created_unix" ASC [true 3 3] - 955.991µs
2023/05/08 05:14:50 .../issues/milestone.go:400:GetMilestones() [I] [64588549] [SQL] SELECT "id", "repo_id", "name", "content", "is_closed", "num_issues", "num_closed_issues", "completeness", "created_unix", "updated_unix", "deadline_unix", "closed_date_unix" FROM "milestone" WHERE repo_id=$1 ORDER BY "deadline_unix" ASC, "id" ASC [11] - 827.816µs
2023/05/08 05:14:50 .../issues/milestone.go:400:GetMilestones() [I] [64588549] [SQL] SELECT count(*) FROM "milestone" WHERE repo_id=$1 [11] - 750.519µs
2023/05/08 05:14:50 ...s/context/context.go:222:HTML() [D] [64588549] Template: repo/issue/list
2023/05/08 05:14:50 ...user/notification.go:45:func1() [I] [64588549] [SQL] SELECT count(*) FROM "notification" WHERE (user_id = $1) AND (status = $2) [2 1] - 1.019472ms
2023/05/08 05:14:50 models/user/user.go:933:GetUserByID() [I] [6458854a-4] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.276484ms
2023/05/08 05:14:50 .../issues/stopwatch.go:139:HasUserStopwatch() [I] [6458854a-4] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (user_id = $1) LIMIT 1 [2] - 785.958µs
2023/05/08 05:14:50 ...ties/notification.go:740:GetUIDsAndNotificationCounts() [I] [64588540-18] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1683522878 1683522888 1] - 2.265786ms
2023/05/08 05:14:50 .../issues/stopwatch.go:85:GetUIDsAndStopwatch() [I] [64588540-18] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (issue_id != 0) [] - 635.252µs
2023/05/08 05:14:51 models/user/user.go:933:GetUserByID() [I] [6458854b] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.236838ms
2023/05/08 05:14:51 .../issues/stopwatch.go:139:HasUserStopwatch() [I] [6458854b] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (user_id = $1) LIMIT 1 [2] - 806.793µs
2023/05/08 05:14:51 models/user/user.go:962:GetUserByName() [I] [6458854b] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "lower_name"=$1 LIMIT 1 [test_org] - 1.161881ms
2023/05/08 05:14:51 ...bfc5ce9830/engine.go:1244:Get() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 [3 axmol] - 1.234662ms
2023/05/08 05:14:51 ...epo/collaboration.go:84:IsCollaborator() [I] [6458854b] [SQL] SELECT "id", "repo_id", "user_id", "mode", "created_unix", "updated_unix" FROM "collaboration" WHERE "repo_id"=$1 AND "user_id"=$2 LIMIT 1 [11 2] - 788.408µs
2023/05/08 05:14:51 ...ls/repo/repo_unit.go:223:getUnitsByRepoID() [I] [6458854b] [SQL] SELECT "id", "repo_id", "type", "config", "created_unix" FROM "repo_unit" WHERE (repo_id = $1) [11] - 637.303µs
2023/05/08 05:14:51 ...s/repo/pushmirror.go:117:GetPushMirrorsByRepoID() [I] [6458854b] [SQL] SELECT "id", "repo_id", "remote_name", "sync_on_commit", "interval", "created_unix", "last_update", "last_error" FROM "push_mirror" WHERE (repo_id = $1) [11] - 723.877µs
2023/05/08 05:14:51 ...s/repo/pushmirror.go:117:GetPushMirrorsByRepoID() [I] [6458854b] [SQL] SELECT count(*) FROM "push_mirror" WHERE (repo_id = $1) [11] - 648.323µs
2023/05/08 05:14:51 ...ules/context/repo.go:542:RepoAssignment() [I] [6458854b] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND sha1<>$2 [11 ] - 879.957µs
2023/05/08 05:14:51 ...ules/context/repo.go:551:RepoAssignment() [I] [6458854b] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND is_draft=$2 AND is_tag=$3 [11 false false] - 796.427µs
2023/05/08 05:14:51 ...ules/context/repo.go:567:RepoAssignment() [I] [6458854b] [SQL] SELECT 1 FROM "repository" WHERE (owner_id=$1 AND fork_id=$2) LIMIT 1 [2 11] - 815.978µs
2023/05/08 05:14:52 models/repo/fork.go:47:GetUserFork() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE (fork_id = $1) AND (owner_id = $2) LIMIT 1 [11 2] - 1.157919ms
2023/05/08 05:14:52 models/repo/fork.go:93:FindUserOrgForks() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE fork_id=$1 AND owner_id IN (SELECT org_id FROM org_user WHERE uid=$2) [11 2] - 1.968556ms
2023/05/08 05:14:52 ...bfc5ce9830/engine.go:1244:Get() [I] [6458854b] [SQL] SELECT "id", "user_id", "repo_id", "mode", "created_unix", "updated_unix" FROM "watch" WHERE "user_id"=$1 AND "repo_id"=$2 LIMIT 1 [2 11] - 1.19244ms
2023/05/08 05:14:52 models/repo/star.go:70:IsStaring() [I] [6458854b] [SQL] SELECT "id", "uid", "repo_id", "created_unix" FROM "star" WHERE "uid"=$1 AND "repo_id"=$2 LIMIT 1 [2 11] - 861.343µs
2023/05/08 05:14:52 models/repo/repo.go:664:GetRepositoryByID() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id"=$1 LIMIT 1 [10] - 1.112666ms
2023/05/08 05:14:52 models/user/user.go:933:GetUserByID() [I] [6458854b] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.143099ms
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/tags/ --sort=-taggerdate
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/heads/ --sort=-committerdate
2023/05/08 05:14:52 .../repo/middlewares.go:58:SetDiffViewStyle() [I] [6458854b] [SQL] UPDATE "user" SET "diff_view_style" = $1, "updated_unix" = $2 WHERE "id"=$3 [split 1683522892 2] - 95.851451ms
2023/05/08 05:14:52 ...bfc5ce9830/engine.go:1244:Get() [I] [6458854b] [SQL] SELECT "id", "user_id", "setting_key", "setting_value" FROM "user_setting" WHERE "user_id"=$1 AND "setting_key"=$2 LIMIT 1 [2 diff.whitespace_behaviour] - 1.503764ms
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file -e dev
2023/05/08 05:14:52 models/repo/repo.go:664:GetRepositoryByID() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id"=$1 LIMIT 1 [10] - 1.33619ms
2023/05/08 05:14:52 models/repo/fork.go:28:GetForkedRepo() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE (owner_id=$1 AND fork_id=$2) LIMIT 1 [2 11] - 1.384745ms
2023/05/08 05:14:52 models/repo/fork.go:28:GetForkedRepo() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE (owner_id=$1 AND fork_id=$2) LIMIT 1 [3 11] - 1.532701ms
2023/05/08 05:14:52 models/repo/fork.go:28:GetForkedRepo() [I] [6458854b] [SQL] SELECT "id", "owner_id", "owner_name", "lower_name", "name", "description", "website", "original_service_type", "original_url", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "num_projects", "num_closed_projects", "num_action_runs", "num_closed_action_runs", "is_private", "is_empty", "is_archived", "is_mirror", "status", "is_fork", "fork_id", "is_template", "template_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "trust_model", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE (owner_id=$1 AND fork_id=$2) LIMIT 1 [3 10] - 1.468781ms
2023/05/08 05:14:52 ...epo/collaboration.go:84:IsCollaborator() [I] [6458854b] [SQL] SELECT "id", "repo_id", "user_id", "mode", "created_unix", "updated_unix" FROM "collaboration" WHERE "repo_id"=$1 AND "user_id"=$2 LIMIT 1 [11 2] - 1.016944ms
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file -e dev
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/dev
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= merge-base -- refs/heads/dev refs/heads/dev
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/dev
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --pretty=format:%H 7e1f67ca1a1d000f58684383b727d36df5f505e9...refs/heads/dev --
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff -z --name-only refs/heads/dev...refs/heads/dev --
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/tags/ --sort=-taggerdate
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/heads/ --sort=-committerdate
2023/05/08 05:14:52 ...dules/git/command.go:255:Run() [D] [6458854b] /data/git/repositories/test_org/axmol.git: /usr/bin/git -c protocol.version=2 -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= for-each-ref --format=%(objectname) %(refname) refs/tags/ --sort=-taggerdate
2023/05/08 05:14:52 ...odels/issues/pull.go:571:GetUnmergedPullRequest() [I] [6458854b] [SQL] SELECT * FROM "pull_request" INNER JOIN "issue" ON issue.id=pull_request.issue_id WHERE (head_repo_id=$1 AND head_branch=$2 AND base_repo_id=$3 AND base_branch=$4 AND has_merged=$5 AND flow = $6 AND issue.is_closed=$7) LIMIT 1 [11 dev 11 dev false 0 false] - 1.850682ms
2023/05/08 05:14:52 ...dels/issues/label.go:415:GetLabelsByRepoID() [I] [6458854b] [SQL] SELECT "id", "repo_id", "org_id", "name", "exclusive", "description", "color", "num_issues", "num_closed_issues", "created_unix", "updated_unix" FROM "label" WHERE (repo_id = $1) ORDER BY "name" ASC [11] - 1.00931ms
2023/05/08 05:14:52 ...dels/issues/label.go:518:GetLabelsByOrgID() [I] [6458854b] [SQL] SELECT "id", "repo_id", "org_id", "name", "exclusive", "description", "color", "num_issues", "num_closed_issues", "created_unix", "updated_unix" FROM "label" WHERE (org_id = $1) ORDER BY "name" ASC [3] - 936.513µs
2023/05/08 05:14:52 ...s/context/context.go:222:HTML() [D] [6458854b] Template: repo/diff/compare
2023/05/08 05:14:52 ...user/notification.go:45:func1() [I] [6458854b] [SQL] SELECT count(*) FROM "notification" WHERE (user_id = $1) AND (status = $2) [2 1] - 1.161028ms
2023/05/08 05:14:52 models/user/user.go:933:GetUserByID() [I] [6458854c-16] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password", "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admin", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_members", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme", "keep_activity_private" FROM "user" WHERE "id"=$1 LIMIT 1 [2] - 1.212666ms
2023/05/08 05:14:52 .../issues/stopwatch.go:139:HasUserStopwatch() [I] [6458854c-16] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (user_id = $1) LIMIT 1 [2] - 810.43µs
2023/05/08 05:15:00 ...ties/notification.go:740:GetUIDsAndNotificationCounts() [I] [64588540-18] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1683522888 1683522898 1] - 1.88508ms
2023/05/08 05:15:00 .../issues/stopwatch.go:85:GetUIDsAndStopwatch() [I] [64588540-18] [SQL] SELECT "id", "issue_id", "user_id", "created_unix" FROM "stopwatch" WHERE (issue_id != 0) [] - 582.898µs
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment