sqlite-web 0.7.2
gitea.db
action_run_job
Create
Query
access
access_token
action
action_artifact
action_run
action_run_index
action_run_job
action_runner
action_runner_token
action_schedule
action_schedule_spec
action_task
action_task_output
action_task_step
action_tasks_version
action_variable
app_state
attachment
auth_token
badge
branch
collaboration
comment
commit_status
commit_status_index
commit_status_summary
commit_sync_log
commit_sync_status
dbfs_data
dbfs_meta
deploy_key
email_address
email_hash
external_login_user
follow
gpg_key
gpg_key_import
hook_task
issue
issue_assignees
issue_content_history
issue_dependency
issue_index
issue_label
issue_pin
issue_user
issue_watch
label
language_stat
lfs_lock
lfs_meta_object
login_source
milestone
mirror
notice
notification
oauth2_application
oauth2_authorization_code
oauth2_grant
org_user
package
package_blob
package_blob_upload
package_cleanup_rule
package_file
package_property
package_version
project
project_board
project_issue
protected_branch
protected_tag
public_key
pull_auto_merge
pull_request
push_mirror
reaction
release
renamed_branch
repo_archiver
repo_hidden_file
repo_indexer_status
repo_license
repo_redirect
repo_topic
repo_transfer
repo_unit
repository
review
review_state
secret
session
sqlite_sequence
star
stopwatch
system_setting
task
team
team_invite
team_repo
team_unit
team_user
topic
tracked_time
two_factor
upload
user
user_badge
user_blocking
user_open_id
user_redirect
user_setting
version
watch
webauthn_credential
webhook
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Delete row 7832 from action_run_job
id
7832
run_id
6702
repo_id
6
owner_id
5
commit_sha
e112d45af414e4862c0328abad7c4df74d3c1dbf
is_fork_pull_request
0
name
⚡ N+1 查询检测
attempt
1
workflow_payload
name: Database Security Audit "on": pu
name: Database Security Audit "on": push: branches: [main, develop] paths: - 'backend/src/**/*.ts' - 'backend/prisma/**' pull_request: branches: [main, develop] paths: - 'backend/src/**/*.ts' - 'backend/prisma/**' schedule: # 每天凌晨 2 点执行完整审计 - cron: '0 2 * * *' workflow_dispatch: inputs: full_audit: description: '执行完整审计(包含 RLS 迁移建议)' required: false default: 'false' type: boolean env: NODE_VERSION: "18" jobs: n1-query-detection: name: ⚡ N+1 查询检测 runs-on: ubuntu-latest steps: - name: "\U0001F4E5 Checkout code" uses: actions/checkout@v4 - name: "\U0001F7E2 Setup Node.js" uses: actions/setup-node@v4 with: node-version: ${{ env.NODE_VERSION }} - name: "\U0001F4E6 Setup pnpm" uses: pnpm/action-setup@v2 with: version: "8" - name: "\U0001F4E5 Install dependencies" run: pnpm install --frozen-lockfile - id: n1-audit name: "\U0001F50D N+1 查询检测" run: | cd backend npm run audit:n1 --fix 2>&1 | tee n1-audit.log # 提取 HIGH 问题数量 HIGH_COUNT=$(grep -c "HIGH" n1-audit.log || echo "0") echo "high_count=$HIGH_COUNT" >> $GITHUB_OUTPUT - name: "\U0001F4CA 上传 N+1 报告" uses: actions/upload-artifact@v4 with: name: n1-query-report path: backend/n1-audit.log - if: steps.n1-audit.outputs.high_count > 0 name: ⚠️ N+1 问题警告 run: | echo "::warning::发现 ${{ steps.n1-audit.outputs.high_count }} 个 HIGH 级别 N+1 查询问题" timeout-minutes: "10"
...
job_id
n1-query-detection
needs
null
runs_on
["ubuntu-latest"]
task_id
6745
status
2
started
1773832209
stopped
1773832229
created
1773831748
updated
1773832229
raw_concurrency
is_concurrency_evaluated
0
concurrency_group
concurrency_cancel
0
Delete
Cancel