xuxu.fr

Log WordPress MySQL queries in csv file (and log file). Useful when you need to improve the performance or debug something.
You can contact me :
<ul>
<li>My blog: https://xuxu.fr/contact</li>
<li>My website : https://www.xuan-nguyen.fr</li>
<li>My Twitter account: https://twitter.com/xuxu</li>
</ul>

SQLog

Log WordPress MySQL queries in csv file (and log file). Useful when you need to improve the performance or debug something.

SeoTune

Seotune Search Insights connects to Google Search Console, stores search analytics in your WordPress database, and provides an admin dashboard with KPIs, reports, and actionable SEO insights.
For setup help, see the <a href="https://seotune.app/documentation/" rel="nofollow ugc">Documentation</a>.
Without external accounts: The plugin installs and activates like any other plugin, but reports and sync require a Google Cloud OAuth client and a Google account with access to a Search Console property for your site. Until you complete connection in Seotune Search Insights → Settings, no Search Console data is fetched and dashboards stay empty.
Features
<ul>
<li>Connection: OAuth connection to GSC; automatic detection of the property matching your site domain (no manual property picker).</li>
<li>Dashboard: Overview with clicks, impressions, CTR, position; charts; top queries and pages; recent alerts.</li>
<li>Keywords: Filterable, sortable report with export to CSV.</li>
<li>Pages: Same for page URLs with export to CSV.</li>
<li>Opportunities: Two reports — high impressions / low CTR, and keywords in positions 8–20 (quick wins); CSV export.</li>
<li>Cannibalization: Queries with multiple pages competing; per-query URL list. Normalized by URL (fragment stripped).</li>
<li>Decay: Pages with declining organic performance vs the previous period; filters, probable-cause hints, CSV export.</li>
<li>Content Refresh: Pages prioritized for refresh (urgency levels) with reasons and metrics; CSV export.</li>
<li>Internal Links: Internal linking opportunities from WordPress content and GSC signals; filters; CSV export.</li>
<li>Question Queries: Question-style search queries with difficulty signals and metrics (from GSC data).</li>
<li>Alerts: Automatic detection of position drop, CTR drop, traffic drop, impressions spike (runs after daily sync); list on the Dashboard and CSV export.</li>
<li>Export: CSV export for queries, pages, opportunities, alerts, decay, content refresh, and internal linking (with filters where applicable; UTF-8 BOM for Excel).</li>
<li>Settings: Google OAuth credentials, connect/disconnect, Sync & Import (auto-import last 28 days on first connection, sync now 3/7 days, import range in background), advanced import tuning, and import diagnostics.</li>
</ul>
Data is synced for the last 3 days on manual run or via a daily cron. After the first successful connection to Google Search Console, Seotune Search Insights automatically imports the last 28 days so that the Dashboard and reports are not empty; you can then use Sync & Import to extend or restart the import for a larger range. After the first import, data is updated automatically every day via cron. Historical data can be imported in background batches (by default 7 days per batch and 1000 rows per DB write) that stay within sensible Google Search Console usage and are tuned for performance; you can adjust these values from Settings → Sync & Import if needed. The Sync & Import card also includes an Import diagnostics panel that shows recent import activity, cron status, and common issues (e.g. cron not running, API quota, PHP/DB limits) without exposing sensitive query data. Custom database tables use a plugin-specific prefix (in addition to your WordPress table prefix).
<h3>Privacy</h3>
This plugin does not send your site’s front-end visitor traffic to Seotune Search Insights or to a proprietary Seotune API. It does not add visitor tracking, advertising pixels, or marketing analytics to the public site.
Declared service data (administrators)
<ul>
<li>Google OAuth 2.0 & Search Console API (required for core features): After you add OAuth credentials and connect, the server communicates with Google to authorize and to read Search Console data you are allowed to access. Tokens and imported metrics are stored in your WordPress database. Google’s terms and privacy policies apply to Google accounts and APIs: <a href="https://policies.google.com/privacy" rel="nofollow ugc">Google Privacy Policy</a>, <a href="https://developers.google.com/terms" rel="nofollow ugc">Google APIs Terms of Service</a>.</li>
<li>Admin UI typography: The dashboard uses the operating system’s UI fonts (system font stack in local CSS) in the WordPress admin only; it does not load third-party font stylesheets for Seotune Search Insights screens.</li>
</ul>
Responsibility: Site owners should inform end users where required by law (e.g. privacy policy, cookie/consent flows) that Search Console-related data is processed when administrators connect Google services.
Technical map (endpoints, when requests run): <code>documentation/network-and-privacy.txt</code>. Narrative guide: <code>documentation/index.html</code> (Privacy & third-party services).
<h3>Troubleshooting</h3>
<h3>Import diagnostics panel</h3>
In Seotune Search Insights → Settings → Sync & Import you will find an Import diagnostics box:
<ul>
<li>A status badge (OK / WARNING / ERROR) with a short message and a hint.</li>
<li>A table of the latest import jobs (manual sync, historical batches, internal links index), showing time, range, rows, duration, and result.</li>
<li>A Copy log for support button that copies a plain-text summary (timestamps, job types, technical messages) which you can paste into a support ticket. No search queries, URLs, or user-identifiable data are included.</li>
</ul>
The panel is read-only and is meant to help you and support quickly understand what is happening on your server.
<h3>Common messages and what to do</h3>
<ul>
<li>
“Cron may not be running regularly” / “No plugin cron jobs have run in the last few hours” 
This usually means WordPress cron is disabled or not being triggered. Check <code>wp-config.php</code> for <code>DISABLE_WP_CRON</code>. If it is set to <code>true</code>, configure a real server cron job that calls <code>wp-cron.php</code> every few minutes, or ask your hosting provider to set this up.
</li>
<li>
“Historical import is marked as running, but no backfill batches have completed yet” 
The backfill state is “running” but no historical batches are logged. This is typically another sign that cron is not firing. Verify the cron configuration as above, then wait a few minutes and refresh the page.
</li>
<li>
“Historical import seems stuck (no progress for a while)” 
If the progress bar stays at 0% or does not move for a long time, use Stop / Reset import in the Sync & Import card, then start a new import with smaller batches (lower “Days per batch”). Also make sure cron is running.
</li>
<li>
Search Console quota / rate limit errors in the log 
If recent log entries mention quota or rate-limit errors from the Google Search Console API, try lowering Days per batch for the historical import, and consider running imports at quieter times of day. If the issue persists, you may need to wait for quotas to reset or use a dedicated Google Cloud project.
</li>
<li>
PHP execution time, memory, or database errors in the log 
Messages mentioning maximum execution time, memory limits, or database connection issues indicate that the server limits are too strict for large imports. Try reducing Days per batch and, if needed, ask your hosting provider to increase PHP <code>memory_limit</code> and <code>max_execution_time</code>, or to relax database limits for background jobs.
</li>
</ul>
<h3>Hosting requirements (for smooth import)</h3>
Seotune Search Insights’ historical import runs in the background via WordPress cron: each cron run processes one batch (a few days of data), then schedules the next. For the import to complete without blocking or stalling, the hosting environment must meet the following.
Default settings (7 days per batch, 60 seconds delay between batches, 1000 rows per DB batch) are chosen to work on most hosting. On servers with more resources you can increase Days per batch and reduce Delay between batches in Seotune Search Insights → Settings → Sync & Import for a faster import.
Minimum (plugin runs, import may be slow or need tuning)
<ul>
<li>PHP: 8.0 or higher (required by the plugin).</li>
<li>PHP memory_limit: at least 128 MB. Lower values can cause out-of-memory errors during import.</li>
<li>PHP max_execution_time: at least 60 seconds for each cron run (single batch). Many shared hosts use 30s; that can be enough for small batches but may cause timeouts on heavier batches.</li>
<li>WordPress cron: Must run regularly (at least every 5–10 minutes). If <code>DISABLE_WP_CRON</code> is set to <code>true</code> in <code>wp-config.php</code>, a system cron job must call <code>wp-cron.php</code> (or trigger WordPress cron) every few minutes; otherwise the import never advances.</li>
<li>MySQL: Standard WordPress requirements; no extra extensions needed. The plugin writes data in batches (configurable: 100–2000 rows per batch).</li>
</ul>
Recommended (smooth, reliable import)
<ul>
<li>PHP memory_limit: 256 MB or more.</li>
<li>PHP max_execution_time: 120–300 seconds for cron/CLI so each batch has enough time to fetch data from Google and write to the database.</li>
<li>Cron: Triggered every 1–2 minutes (e.g. system cron every 2 minutes) so batches run frequently and the import completes in a reasonable time.</li>
<li>Network: Outbound HTTPS to Google APIs (Search Console) without long timeouts or blocks.</li>
</ul>
Restrictive shared hosting (e.g. some Aruba, or low-resource plans)
On hosting with strict limits (low memory, 30s execution time, or cron that rarely runs), the import can block, time out, or appear stuck. To improve reliability:
<ol>
<li>Cron: Ensure WordPress cron actually runs. If the host uses <code>DISABLE_WP_CRON</code>, set up a real cron job (e.g. <code>*/5 * * * *</code> to hit <code>https://yoursite.com/wp-cron.php?doing_wp_cron</code> or run <code>wp cron event run --due-now</code> via WP-CLI every few minutes). Ask the host (e.g. Aruba) how to add a cron job and what the URL/command should be.</li>
<li>Days per batch: In Seotune Search Insights → Settings → Sync & Import, set Days per batch to 3–5 (or even 1 for very slow hosts). Smaller batches reduce memory and execution time per run.</li>
<li>Rows per DB batch: In the same section, set Rows per DB batch to 500 (or 100 if you still see timeouts or DB errors). Lower values reduce load per request.</li>
<li>PHP limits: Ask the hosting provider to raise memory_limit to at least 256 MB and max_execution_time to at least 120 seconds for PHP (or for the cron/CLI context, if they differentiate).</li>
</ol>
If the import still fails or gets stuck, use Import diagnostics in Settings (and Copy log for support) to see whether the cause is cron not running, timeouts, memory, or API quota; then adjust the above or contact the host with the requested limits.
<h3>Development</h3>
Backend (Composer)
<ul>
<li>From the plugin root: <code>composer install</code>.</li>
<li>Keep the <code>vendor/</code> directory when deploying (plugin requires it for the Google API client).</li>
<li>Autoload: <code>composer.json</code> uses a classmap for <code>includes/</code> (no PSR-4 path mismatch warnings).</li>
<li><code>monolog/monolog</code> is required by <code>google/apiclient</code>; it stays in <code>composer.json</code> as <code>^2.9</code> to pin Monolog 2.x and remain compatible with PHP 8.0 (Monolog 3 needs PHP 8.1+).</li>
</ul>
Frontend (React)
<ul>
<li>From <code>admin/react-app</code>: <code>npm install</code> then <code>npm run build</code>.</li>
<li>Build outputs a single <code>admin/assets/js/admin-app.js</code> (IIFE bundle for classic <code>wp_enqueue_script</code>, no <code>import.meta</code>) plus <code>admin/assets/js/admin-app.css</code> (extracted CSS). Deploy both files; without the built JS, a placeholder script is loaded.</li>
<li>WordPress.org / source access: The default release zip includes <code>admin/react-app/</code> (Vite/React sources, <code>package-lock.json</code>; <code>node_modules</code> excluded — run <code>npm ci</code> inside <code>admin/react-app</code> to rebuild). Compiled <code>admin-app.js</code> + <code>admin-app.css</code> are also present. Optional: add a public git mirror URL below for convenience. Details: <code>documentation/source-and-build.txt</code>.</li>
<li>Public source code repository: (Optional — add GitHub/GitLab URL if you publish a mirror; not required for review because sources ship in the plugin package.)</li>
</ul>
Release zip(s) (from plugin root, after <code>composer</code> / <code>npm</code> as needed)
<ul>
<li>Version bump & SVN: see <code>scripts/README-release.txt</code> (Stable tag, version constant in <code>seotune-search-insights.php</code> aligned with the plugin header, changelog, Subversion tag folder).</li>
<li><code>npm run release</code> — creates a zip in <code>dist/</code> (includes <code>admin/react-app</code> sources; excludes <code>node_modules</code> and <code>documentation/</code>).</li>
<li><code>npm run release:src</code> — creates only the <code>*-with-sources.zip</code> variant with the same contents (alias for workflows that expect the filename).</li>
<li><code>npm run release:all</code> — writes both filenames; the archives are identical (duplicate name for compatibility).</li>
</ul>
Translations (i18n)
<ul>
<li>Text domain: <code>seotune-search-insights</code>. PHP uses <code>load_plugin_textdomain</code> with <code>languages/</code>.</li>
<li>Admin UI strings use <code>@wordpress/i18n</code> (<code>__()</code>, <code>sprintf</code>, <code>_n</code>) in JSX; <code>wp_set_script_translations()</code> loads Jed JSON for the built script.</li>
<li>Regenerate templates (from plugin root, WP-CLI): 
 wp i18n make-pot . languages/seotune-search-insights.pot –slug=seotune-search-insights –domain=seotune-search-insights –exclude=vendor,admin/react-app/node_modules,dist,admin/assets,documentation,scripts 
Update <code>languages/seotune-search-insights-en_US.po</code> with <code>wp i18n update-po languages/seotune-search-insights.pot languages/seotune-search-insights-en_US.po</code>. 
Build JS JSON (maps all React sources to the single bundle): 
 wp i18n make-json languages/seotune-search-insights-en_US.po –use-map=languages/wp-i18n-map.json –domain=seotune-search-insights –extensions=jsx,js 
Commit <code>languages/seotune-search-insights.pot</code>, <code>languages/seotune-search-insights-en_US.po</code>, <code>languages/wp-i18n-map.json</code>, and <code>languages/seotune-search-insights-*-*.json</code> with the plugin.</li>
</ul>

Seotune Search Insights

Search Console analytics and SEO insights in your WordPress admin. Connect with OAuth; data stored in your DB. Not affiliated with Google.

SQLog vs Seotune Search Insights