WordPress Popular Posts テスト

1. プラグイン状態

WordPress Popular Posts: 有効

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

popularpostsdata テーブル: 存在する

popularpostssummary テーブル: 存在する

3. データ件数

統計データ件数: 1416239

最新の統計データ:

Array
(
    [0] => stdClass Object
        (
            [ID] => 5300172
            [postid] => 217343
            [pageviews] => 1
            [view_date] => 2026-05-25
            [view_datetime] => 2026-05-25 09:48:14
        )

    [1] => stdClass Object
        (
            [ID] => 5300171
            [postid] => 22489
            [pageviews] => 1
            [view_date] => 2026-05-25
            [view_datetime] => 2026-05-25 09:48:03
        )

    [2] => stdClass Object
        (
            [ID] => 5300170
            [postid] => 10270
            [pageviews] => 1
            [view_date] => 2026-05-25
            [view_datetime] => 2026-05-25 09:48:00
        )

    [3] => stdClass Object
        (
            [ID] => 5300169
            [postid] => 22546
            [pageviews] => 1
            [view_date] => 2026-05-25
            [view_datetime] => 2026-05-25 09:47:51
        )

    [4] => stdClass Object
        (
            [ID] => 5300168
            [postid] => 85807
            [pageviews] => 1
            [view_date] => 2026-05-25
            [view_datetime] => 2026-05-25 09:47:48
        )

)

4. WPP Query テスト

取得件数: 10

取得した記事:

ID: 295420 - 【キャスト登壇】『口に関するアンケート』口プレミア試写会に10組20名様をご招待！ (Views: 2386)
ID: 295997 - 本木雅弘、菅田将暉、宮舘涼太がカンヌ初降臨！『黒牢城』フォトコールで世界メディア魅了 (Views: 1079)
ID: 295583 - 妊娠中の岡本多緒、シャネル姿で存在感『ドライブ・マイ・カー』濱口竜介監督最新作カンヌ会見レポート (Views: 628)
ID: 295517 - 永瀬廉「僕にとって思い出があるジャケット」 Diorイベントで語った特別な一着と大阪の記憶 (Views: 532)
ID: 296227 - 永瀬廉と髙橋海人が初のトラベルバラエティでロサンゼルスへ！『King & Princeがまちあわせ in LA』 (Views: 417)
ID: 295525 - 板垣李光人、“はらぺこあおむし”ニットでディオール降臨、杉野遥亮は洗練アイビールック披露 (Views: 407)
ID: 296113 - トニー・ジャー主演『ザ・レイジ』一般試写会に15組30名様をご招待！ (Views: 338)
ID: 295318 - 山下智久、“学生時代”思い出し『正直不動産』劇中歌作詞　岩﨑大昇とのコラボ裏話語る (Views: 297)
ID: 295626 - 山﨑賢人、主演作『殺人の門』をカンヌでアピール！現地プレゼンでコメント映像上映 (Views: 248)
ID: 248190 - 本木雅弘と“元恋人役”小泉今日子が手を繋ぐシーンは本木のアイデア「ラブストーリーの部分をもう一息、わかりやすい形に」 (Views: 238)

実行された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-05-19' 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] => 295583 [1] => 296227 [2] => 295997 [3] => 296028 [4] => 296017 [5] => 296190 [6] => 295420 [7] => 296074 [8] => 296048 [9] => 296060 [10] => 296113 [11] => 296035 [12] => 291410 [13] => 295517 [14] => 73343 [15] => 21037 [16] => 22624 [17] => 21389 [18] => 18587 [19] => 295190 )

Weekly: 20 件 - Array ( [0] => 295420 [1] => 295997 [2] => 295583 [3] => 295517 [4] => 296227 [5] => 295525 [6] => 296113 [7] => 295318 [8] => 295626 [9] => 248190 [10] => 295573 [11] => 295541 [12] => 295483 [13] => 295299 [14] => 295125 [15] => 295103 [16] => 295982 [17] => 296028 [18] => 295242 [19] => 294923 )

Monthly: 20 件 - Array ( [0] => 295420 [1] => 289483 [2] => 295997 [3] => 294580 [4] => 293585 [5] => 294476 [6] => 294105 [7] => 294594 [8] => 294446 [9] => 294453 [10] => 293923 [11] => 291671 [12] => 293439 [13] => 295583 [14] => 294354 [15] => 294020 [16] => 294963 [17] => 294313 [18] => 294976 [19] => 295517 )

6. スクリプト読み込み

wpp-js スクリプトが登録されていません