WordPress Popular Posts テスト

1. プラグイン状態

WordPress Popular Posts: 有効

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

popularpostsdata テーブル: 存在する

popularpostssummary テーブル: 存在する

3. データ件数

統計データ件数: 1341081

最新の統計データ:

Array
(
    [0] => stdClass Object
        (
            [ID] => 4099983
            [postid] => 167778
            [pageviews] => 1
            [view_date] => 2026-04-04
            [view_datetime] => 2026-04-04 14:06:12
        )

    [1] => stdClass Object
        (
            [ID] => 4099982
            [postid] => 25906
            [pageviews] => 1
            [view_date] => 2026-04-04
            [view_datetime] => 2026-04-04 14:05:58
        )

    [2] => stdClass Object
        (
            [ID] => 4099981
            [postid] => 291510
            [pageviews] => 1
            [view_date] => 2026-04-04
            [view_datetime] => 2026-04-04 14:05:55
        )

    [3] => stdClass Object
        (
            [ID] => 4099980
            [postid] => 49169
            [pageviews] => 1
            [view_date] => 2026-04-04
            [view_datetime] => 2026-04-04 14:05:51
        )

    [4] => stdClass Object
        (
            [ID] => 4099979
            [postid] => 167350
            [pageviews] => 1
            [view_date] => 2026-04-04
            [view_datetime] => 2026-04-04 14:05:46
        )

)

4. WPP Query テスト

取得件数: 10

取得した記事:

ID: 290243 - 小林薫『深夜食堂』再開に喜び「ご来店をお待ちしています」7年ぶり新シリーズ決定 (Views: 12657)
ID: 291428 - 永瀬廉×吉川愛の純愛に絶賛の声が続出！『鬼の花嫁』実写映画1位の大ヒット (Views: 1466)
ID: 291088 - 「Snow Manのコンサートに行ったときに……」小沢仁志が応援グッズを持って佐久間大介を応援？ (Views: 1188)
ID: 291269 - 【キャスト登壇】『ミステリー・アリーナ』完成披露試写会に5組10名様をご招待！ (Views: 566)
ID: 291450 - 永瀬廉「戸惑っている玲夜も出したかった」『鬼の花嫁』座談会で語る役作りの核心 (Views: 432)
ID: 22110 - 「Toshl 新バンド結成」の真相がついに明らかに！ (Views: 431)
ID: 291410 - 斎藤工・田中圭・三吉彩花ら新キャスト10名参戦！『キングダム魂の決戦』合従軍の全貌が明らかに (Views: 404)
ID: 279032 - 町田啓太、石井杏奈と華麗に舞う！ Netflix映画『10DANCE』で“帝王”杉木信也を熱演 (Views: 339)
ID: 291418 - 永瀬廉「自称・八尾の神です！」地元トークで笑い誘う『鬼の花嫁』大阪舞台挨拶 (Views: 337)
ID: 283071 - 『透明な夜に駆ける君と、目に見えない恋をした。』藤原大祐インタビュー (Views: 333)

実行された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 >= '2026-03-29' 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] => 291428 [1] => 243337 [2] => 291450 [3] => 291410 [4] => 270821 [5] => 291418 [6] => 283071 [7] => 55357 [8] => 280243 [9] => 22607 [10] => 281200 [11] => 291510 [12] => 263147 [13] => 279503 [14] => 279425 [15] => 279032 [16] => 278361 [17] => 261823 [18] => 280854 [19] => 281342 )

Weekly: 20 件 - Array ( [0] => 290243 [1] => 291428 [2] => 291088 [3] => 291269 [4] => 291450 [5] => 22110 [6] => 291410 [7] => 279032 [8] => 291418 [9] => 283071 [10] => 263147 [11] => 290978 [12] => 280243 [13] => 279425 [14] => 278361 [15] => 281342 [16] => 261823 [17] => 279503 [18] => 281200 [19] => 280854 )

Monthly: 20 件 - Array ( [0] => 290243 [1] => 288757 [2] => 290726 [3] => 288977 [4] => 279425 [5] => 291428 [6] => 279032 [7] => 290187 [8] => 263147 [9] => 280243 [10] => 261823 [11] => 280854 [12] => 281342 [13] => 279503 [14] => 281200 [15] => 283071 [16] => 278361 [17] => 291088 [18] => 288701 [19] => 289514 )

6. スクリプト読み込み

wpp-js: 登録済み

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

読み込み状態: 有効