WordPress Popular Posts テスト

1. プラグイン状態

WordPress Popular Posts: 有効

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

popularpostsdata テーブル: 存在する

popularpostssummary テーブル: 存在する

3. データ件数

統計データ件数: 1338522

最新の統計データ:

Array
(
    [0] => stdClass Object
        (
            [ID] => 3156425
            [postid] => 14320
            [pageviews] => 1
            [view_date] => 2026-02-19
            [view_datetime] => 2026-02-19 06:02:12
        )

    [1] => stdClass Object
        (
            [ID] => 3156424
            [postid] => 200229
            [pageviews] => 1
            [view_date] => 2026-02-19
            [view_datetime] => 2026-02-19 06:01:44
        )

    [2] => stdClass Object
        (
            [ID] => 3156423
            [postid] => 188324
            [pageviews] => 1
            [view_date] => 2026-02-19
            [view_datetime] => 2026-02-19 06:01:42
        )

    [3] => stdClass Object
        (
            [ID] => 3156422
            [postid] => 62152
            [pageviews] => 1
            [view_date] => 2026-02-19
            [view_datetime] => 2026-02-19 06:01:41
        )

    [4] => stdClass Object
        (
            [ID] => 3156421
            [postid] => 206770
            [pageviews] => 1
            [view_date] => 2026-02-19
            [view_datetime] => 2026-02-19 06:01:20
        )

)

4. WPP Query テスト

取得件数: 10

取得した記事:

ID: 287397 - 亀梨和也、華麗な“槍術”アクション披露！熱気あふれる撮影現場に密着した『北方謙三水滸伝』メイキング映像 (Views: 771)
ID: 287335 - 佐久間大介、白スーツで魅せる“踊る殺し屋”に！「フライディ・チャイナタウン」のサビで圧巻のシンクロダンス (Views: 563)
ID: 287186 - 高橋文哉主演『ブルーロック』に櫻井海音、高橋恭平らが参戦！激闘の熱気が伝わるティザー映像公開 (Views: 513)
ID: 287231 - 萩原利久、声だけで魅せる新たな表現！繊細な声が紡ぐ“ふたりの青春”と、奇跡の花火に託した未来 (Views: 479)
ID: 287121 - 【吹替キャスト登壇】『アメリと雨の物語』日本語吹替版完成披露試写会に10組20名様をご招待！ (Views: 371)
ID: 287370 - JAEJOONG「最近色々な国に行っているので…」 “手に入れたい能力”を告白!? 『神社悪魔のささやき』来日舞台挨拶 (Views: 357)
ID: 287364 - 東方神起、新曲「IDENTITY」配信スタート！ 20年の軌跡と絆を刻むアニバーサリーソング (Views: 352)
ID: 279425 - 「庄司浩平写真集だから、ぼくは」庄司浩平インタビュー (Views: 332)
ID: 263147 - 『侍タイムスリッパー』安田淳一監督＆沙倉ゆうの (Views: 315)
ID: 261823 - 『年下童貞くんに翻弄されてます』森香澄×柏木悠インタビュー (Views: 315)

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

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

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

6. スクリプト読み込み

wpp-js: 登録済み

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

読み込み状態: 有効