WordPress Popular Posts テスト

1. プラグイン状態

WordPress Popular Posts: 有効

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

popularpostsdata テーブル: 存在する

popularpostssummary テーブル: 存在する

3. データ件数

統計データ件数: 1336559

最新の統計データ:

Array
(
    [0] => stdClass Object
        (
            [ID] => 3138376
            [postid] => 16715
            [pageviews] => 1
            [view_date] => 2026-02-18
            [view_datetime] => 2026-02-18 11:25:26
        )

    [1] => stdClass Object
        (
            [ID] => 3138375
            [postid] => 261466
            [pageviews] => 1
            [view_date] => 2026-02-18
            [view_datetime] => 2026-02-18 11:25:26
        )

    [2] => stdClass Object
        (
            [ID] => 3138374
            [postid] => 23153
            [pageviews] => 1
            [view_date] => 2026-02-18
            [view_datetime] => 2026-02-18 11:25:24
        )

    [3] => stdClass Object
        (
            [ID] => 3138373
            [postid] => 20869
            [pageviews] => 1
            [view_date] => 2026-02-18
            [view_datetime] => 2026-02-18 11:25:21
        )

    [4] => stdClass Object
        (
            [ID] => 3138372
            [postid] => 133961
            [pageviews] => 1
            [view_date] => 2026-02-18
            [view_datetime] => 2026-02-18 11:25:18
        )

)

4. WPP Query テスト

取得件数: 10

取得した記事:

ID: 287186 - 高橋文哉主演『ブルーロック』に櫻井海音、高橋恭平らが参戦！激闘の熱気が伝わるティザー映像公開 (Views: 694)
ID: 287397 - 亀梨和也、華麗な“槍術”アクション披露！熱気あふれる撮影現場に密着した『北方謙三水滸伝』メイキング映像 (Views: 617)
ID: 287231 - 萩原利久、声だけで魅せる新たな表現！繊細な声が紡ぐ“ふたりの青春”と、奇跡の花火に託した未来 (Views: 517)
ID: 287335 - 佐久間大介、白スーツで魅せる“踊る殺し屋”に！「フライディ・チャイナタウン」のサビで圧巻のシンクロダンス (Views: 459)
ID: 287061 - 【舞台挨拶⽣中継付き】Huluオリジナル『時計館の殺⼈』完成披露プレミア上映会に5組10名様をご招待！ (Views: 433)
ID: 279425 - 「庄司浩平写真集だから、ぼくは」庄司浩平インタビュー (Views: 346)
ID: 287121 - 【吹替キャスト登壇】『アメリと雨の物語』日本語吹替版完成披露試写会に10組20名様をご招待！ (Views: 341)
ID: 263147 - 『侍タイムスリッパー』安田淳一監督＆沙倉ゆうの (Views: 326)
ID: 261823 - 『年下童貞くんに翻弄されてます』森香澄×柏木悠インタビュー (Views: 324)
ID: 279032 - 町田啓太、石井杏奈と華麗に舞う！ Netflix映画『10DANCE』で“帝王”杉木信也を熱演 (Views: 324)

実行された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-02-12' 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] => 287530 [1] => 287335 [2] => 287723 [3] => 287752 [4] => 287501 [5] => 287512 [6] => 279425 [7] => 287397 [8] => 263147 [9] => 280854 [10] => 280243 [11] => 279032 [12] => 261823 [13] => 279503 [14] => 287364 [15] => 281200 [16] => 281342 [17] => 287370 [18] => 287358 [19] => 119714 )

Weekly: 20 件 - Array ( [0] => 287186 [1] => 287397 [2] => 287231 [3] => 287335 [4] => 287061 [5] => 279425 [6] => 287121 [7] => 263147 [8] => 261823 [9] => 280243 [10] => 279032 [11] => 279503 [12] => 287177 [13] => 280854 [14] => 287370 [15] => 281342 [16] => 281200 [17] => 287364 [18] => 247696 [19] => 287530 )

Monthly: 20 件 - Array ( [0] => 286523 [1] => 286184 [2] => 279425 [3] => 279032 [4] => 280243 [5] => 279503 [6] => 263147 [7] => 261823 [8] => 280854 [9] => 281200 [10] => 281342 [11] => 286925 [12] => 286574 [13] => 286668 [14] => 284993 [15] => 286139 [16] => 286159 [17] => 286492 [18] => 287186 [19] => 286304 )

6. スクリプト読み込み

wpp-js: 登録済み

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

読み込み状態: 有効