根据模型阶梯扣费SQL

-- 插入消费记录
INSERT INTO `logs` (
    user_id,
    created_at,
    type,
    content,
    username,
    token_name,
    model_name,
    quota,
    prompt_tokens,
    completion_tokens,
    use_time,
    is_stream,
    channel_id,
    channel_name,
    token_id,
    `group`,
    ip,
    request_id,
    other,
    org_id 
) 
SELECT
user_id,
created_at,
`type`,
content,
username,
token_name,
model_name,
quota,
prompt_tokens,
completion_tokens,
use_time,
is_stream,
channel_id,
channel_name,
token_id,
`group`,
ip,
request_id,
other,
org_id 
FROM
    `logs` t 
WHERE
    user_id = 888888961 
    AND t.model_name = 'gpt-5.5' 
    AND t.prompt_tokens > 272000 
    AND created_at >= UNIX_TIMESTAMP(
    CURDATE()) 
    AND created_at < UNIX_TIMESTAMP(
    DATE_ADD( CURDATE(), INTERVAL 1 DAY ));

-- 查询 使用tokensshu
SELECT
user_id,
sum(prompt_tokens) ,
sum(completion_tokens),
sum(JSON_EXTRACT( other, '$.cache_write_tokens' )) AS `cache_write_tokens`,
sum(JSON_EXTRACT( other, '$.cache_tokens' )) AS `cache_tokens` 
FROM
    `logs` t 
WHERE
    user_id = 888888961 
    AND t.model_name = 'gpt-5.5' 
    AND t.prompt_tokens > 272000 
    AND created_at >= UNIX_TIMESTAMP(
    CURDATE()) 
    AND created_at < UNIX_TIMESTAMP(
    DATE_ADD( CURDATE(), INTERVAL 1 DAY ));
    GROUP BY user_id