WordPress Popular Posts テスト

1. プラグイン状態

WordPress Popular Posts: 有効

2. データベーステーブル

popularpostsdata テーブル: 存在する

popularpostssummary テーブル: 存在する

3. データ件数

統計データ件数: 1103934

最新の統計データ:

Array
(
    [0] => stdClass Object
        (
            [ID] => 1105979
            [postid] => 280854
            [pageviews] => 1
            [view_date] => 2025-11-17
            [view_datetime] => 2025-11-17 09:49:47
        )

    [1] => stdClass Object
        (
            [ID] => 1105978
            [postid] => 216692
            [pageviews] => 1
            [view_date] => 2025-11-17
            [view_datetime] => 2025-11-17 09:49:33
        )

    [2] => stdClass Object
        (
            [ID] => 1105977
            [postid] => 153214
            [pageviews] => 1
            [view_date] => 2025-11-17
            [view_datetime] => 2025-11-17 09:49:23
        )

    [3] => stdClass Object
        (
            [ID] => 1105976
            [postid] => 280854
            [pageviews] => 1
            [view_date] => 2025-11-17
            [view_datetime] => 2025-11-17 09:49:20
        )

    [4] => stdClass Object
        (
            [ID] => 1105975
            [postid] => 24215
            [pageviews] => 1
            [view_date] => 2025-11-17
            [view_datetime] => 2025-11-17 09:49:20
        )

)

4. WPP Query テスト

取得件数: 10

取得した記事:

ID: 280854 - 吉沢亮主演『国宝』興収170億円突破！中村鴈治郎×中村壱太郎×李相日が“舞台裏”語る副音声上映決定 (Views: 6343)
ID: 280860 - 向井康二「Snow Manでは甘えちゃうけど、今回は言わなきゃと思った」舞台裏で見せた“男気” (Views: 2326)
ID: 280534 - 庄司浩平「僕はちょっと枠からはみ出すタイプ」ブレイク後のリアルな素顔とは？話題の記事をピックアップ (Views: 2237)
ID: 279572 - 大森元貴「曲書くよ、と気軽に言えた」新曲制作＆素顔の対話まで“剥き出しのミセス”を公開 (Views: 1643)
ID: 280821 - 町田啓太、静と情熱の狭間で舞う！ Netflix映画『10DANCE』で魅せる“愛と闘志”のダンス (Views: 804)
ID: 279610 - 向井康二、感情を解き放つ歌声に注目！ “たった一人のための曲”を披露するライブシーン初公開 (Views: 641)
ID: 280689 - JUNON演じる“この学年で一番やべえ人”！『WIND BREAKER』本編映像で光る圧倒的存在感 (Views: 552)
ID: 279425 - 「庄司浩平写真集だから、ぼくは」庄司浩平インタビュー (Views: 532)
ID: 280328 - 宮本浩次の魂の歌唱に震えろ！『爆弾』未発表含む本編＆主題歌「I AM HERO」融合のスペシャルMV (Views: 446)
ID: 279503 - 庄司浩平のサイン入りチェキを1名様にプレゼント！ (Views: 429)

実行されたSQL:

SELECT p.ID AS id, p.post_title AS title, p.post_author AS uid, v.pageviews FROM `wp_posts` p INNER JOIN (SELECT SUM(pageviews) AS pageviews, postid FROM `wp_popularpostssummary` WHERE view_date >= '2025-11-11' GROUP BY postid) v ON p.ID = v.postid WHERE 1 = 1 AND p.post_type IN('post', 'interview', 'movie', 'present') AND p.post_password = '' AND p.post_status = 'publish'  ORDER BY pageviews DESC LIMIT 10 OFFSET 0;

5. Transient キャッシュ

Daily: 20 件 - Array ( [0] => 280854 [1] => 280821 [2] => 278916 [3] => 280838 [4] => 280826 [5] => 275501 [6] => 197502 [7] => 280860 [8] => 280871 [9] => 265545 [10] => 281024 [11] => 280702 [12] => 279503 [13] => 280796 [14] => 280944 [15] => 265194 [16] => 263536 [17] => 281011 [18] => 228454 [19] => 279425 )

Weekly: 20 件 - Array ( [0] => 280854 [1] => 280860 [2] => 280534 [3] => 279572 [4] => 280821 [5] => 279610 [6] => 280689 [7] => 279425 [8] => 280328 [9] => 279503 [10] => 280770 [11] => 280702 [12] => 280302 [13] => 278916 [14] => 280801 [15] => 280826 [16] => 280592 [17] => 280285 [18] => 275501 [19] => 245822 )

Monthly: 20 件 - Array ( [0] => 278632 [1] => 279425 [2] => 279032 [3] => 278916 [4] => 280854 [5] => 279503 [6] => 279511 [7] => 280534 [8] => 277950 [9] => 279572 [10] => 280860 [11] => 279610 [12] => 278540 [13] => 280821 [14] => 279010 [15] => 280243 [16] => 278843 [17] => 279195 [18] => 279202 [19] => 278848 )

6. スクリプト読み込み

wpp-js: 登録済み

URL: https://www.moviecollection.jp/wp/wp-content/plugins/wordpress-popular-posts/assets/js/wpp.min.js

読み込み状態: 有効