툴팁 제목
툴팁 내용

LLM 모델 순위

필터 옵션

일간 모델 순위 (variant_permaslug 기준) (총 토큰 기준) TOP 10

순위 모델명 총 토큰 입력 토큰 변화율
1 anthropic/claude-3-7-sonnet-20250219 49,375,633,196 48,397,294,446 ↑ 57%
2 google/gemini-2.0-flash-001 39,722,200,310 36,037,701,852 ↑ 41%
3 google/gemini-2.5-flash-preview-04-17 20,726,265,330 19,702,833,486 ↑ 35%
4 deepseek/deepseek-chat-v3-0324:free 20,412,775,511 19,764,177,223 ↑ 43%
5 google/gemini-2.5-pro-exp-03-25 14,871,200,727 14,377,722,007 ↑ 32%
6 google/gemini-2.5-pro-preview-03-25 14,357,676,706 12,717,441,066 ↑ 44%
7 deepseek/deepseek-chat-v3-0324 9,993,833,041 9,322,370,820 ↑ 36%
8 meta-llama/llama-3.3-70b-instruct 9,760,135,167 8,262,593,311 ↓ 18%
9 deepseek/deepseek-r1:free 8,941,823,737 7,778,946,984 ↑ 39%
10 anthropic/claude-3-7-sonnet-20250219:thinking 8,018,550,849 7,665,150,195 ↑ 60%

디버그 정보

Array
(
    [0] => Array
        (
            [rank] => 1
            [name] => anthropic/claude-3-7-sonnet-20250219
            [author] => anthropic
            [total_tokens] => 49375633196
            [prompt_tokens] => 48397294446
            [reasoning_tokens] => 8323983
            [change] => 57
        )

    [1] => Array
        (
            [rank] => 2
            [name] => google/gemini-2.0-flash-001
            [author] => google
            [total_tokens] => 39722200310
            [prompt_tokens] => 36037701852
            [reasoning_tokens] => 8190
            [change] => 41
        )

    [2] => Array
        (
            [rank] => 3
            [name] => google/gemini-2.5-flash-preview-04-17
            [author] => google
            [total_tokens] => 20726265330
            [prompt_tokens] => 19702833486
            [reasoning_tokens] => 14270834
            [change] => 35
        )

    [3] => Array
        (
            [rank] => 4
            [name] => deepseek/deepseek-chat-v3-0324:free
            [author] => deepseek
            [total_tokens] => 20412775511
            [prompt_tokens] => 19764177223
            [reasoning_tokens] => 0
            [change] => 43
        )

    [4] => Array
        (
            [rank] => 5
            [name] => google/gemini-2.5-pro-exp-03-25
            [author] => google
            [total_tokens] => 14871200727
            [prompt_tokens] => 14377722007
            [reasoning_tokens] => 324966074
            [change] => 32
        )

    [5] => Array
        (
            [rank] => 6
            [name] => google/gemini-2.5-pro-preview-03-25
            [author] => google
            [total_tokens] => 14357676706
            [prompt_tokens] => 12717441066
            [reasoning_tokens] => 1309920649
            [change] => 44
        )

    [6] => Array
        (
            [rank] => 7
            [name] => deepseek/deepseek-chat-v3-0324
            [author] => deepseek
            [total_tokens] => 9993833041
            [prompt_tokens] => 9322370820
            [reasoning_tokens] => 0
            [change] => 36
        )

    [7] => Array
        (
            [rank] => 8
            [name] => meta-llama/llama-3.3-70b-instruct
            [author] => meta-llama
            [total_tokens] => 9760135167
            [prompt_tokens] => 8262593311
            [reasoning_tokens] => 0
            [change] => -18
        )

    [8] => Array
        (
            [rank] => 9
            [name] => deepseek/deepseek-r1:free
            [author] => deepseek
            [total_tokens] => 8941823737
            [prompt_tokens] => 7778946984
            [reasoning_tokens] => 411165543
            [change] => 39
        )

    [9] => Array
        (
            [rank] => 10
            [name] => anthropic/claude-3-7-sonnet-20250219:thinking
            [author] => anthropic
            [total_tokens] => 8018550849
            [prompt_tokens] => 7665150195
            [reasoning_tokens] => 101403066
            [change] => 60
        )

)

실행된 SQL 쿼리

SELECT
                current_stats.permaslug,
                current_stats.author,
                current_stats.total_tokens,
                current_stats.prompt_tokens,
                current_stats.reasoning_tokens,
                prev_stats.prev_total_tokens,
                prev_stats.prev_prompt_tokens
            FROM (
                SELECT
                    ds.variant_permaslug as permaslug,
                    (SELECT author FROM release_llm_daily_stats WHERE variant_permaslug = ds.variant_permaslug LIMIT 1) as author,
                    SUM(ds.total_prompt_tokens + ds.total_completion_tokens + ds.total_native_tokens_reasoning) as total_tokens,
                    SUM(ds.total_prompt_tokens) as prompt_tokens,
                    SUM(ds.total_completion_tokens) as completion_tokens,
                    SUM(ds.total_native_tokens_reasoning) as reasoning_tokens
                FROM release_llm_daily_stats ds
                WHERE ds.date >= DATE_SUB('2025-04-28', INTERVAL 1 DAY) AND ds.date <= '2025-04-28'
                
                GROUP BY ds.variant_permaslug
                /* ORDER BY total_tokens DESC -- 서브쿼리 내 정렬은 외부에서 LIMIT과 함께 처리 */
                /* LIMIT 10 -- 서브쿼리에서 LIMIT 제거 */
            ) AS current_stats
            LEFT JOIN (
                SELECT
                    ds_prev.variant_permaslug,
                    SUM(ds_prev.total_prompt_tokens + ds_prev.total_completion_tokens + ds_prev.total_native_tokens_reasoning) as prev_total_tokens,
                    SUM(ds_prev.total_prompt_tokens) as prev_prompt_tokens
                FROM release_llm_daily_stats ds_prev
                WHERE ds_prev.date >= DATE_SUB('2025-04-28', INTERVAL 2 DAY)
                AND ds_prev.date < DATE_SUB('2025-04-28', INTERVAL 1 DAY)
                
                GROUP BY ds_prev.variant_permaslug
            ) AS prev_stats ON current_stats.permaslug = prev_stats.variant_permaslug
            ORDER BY total_tokens DESC
            LIMIT 10