Marwan Hatem

SPM by Marwan is a professional-grade diagnostics and intelligence platform designed for WordPress administrators and developers. It provides deep visibility into your WordPress ecosystem, offering real-time monitoring, security auditing, and performance profiling to ensure your site remains fast, secure, and stable.
<h3>The Problem</h3>
Managing a modern WordPress ecosystem is inherently complex. Site owners and developers frequently struggle with:
<ul>
<li>Slow Extensions: Identifying which specific extension is degrading page load times or consuming excessive server resources.</li>
<li>Hidden PHP Errors: Unseen warnings and fatal errors that silently break functionality or create vulnerabilities.</li>
<li>Security Risks: Unmaintained, abandoned, or vulnerable code exposing the site to potential exploits.</li>
<li>Trust Issues: Uncertainty regarding an extension’s origin, development standards, and code quality.</li>
<li>Update Degradation: Performance regressions and unexpected conflicts introduced immediately after updates.</li>
</ul>
<h3>Core Features</h3>
<ul>
<li>Real-Time Monitoring Engine: Actively tracks resource consumption, database queries, and execution times for every active extension. Identifies performance bottlenecks as they happen, preventing systemic slowdowns.</li>
<li>Performance Diagnostics: Deep-dive profiling for individual extensions. Analyzes memory footprint and script execution to provide actionable intelligence on resource utilization.</li>
<li>Security & Integrity Scanner: Proactively audits installed extensions against known vulnerability databases, flags high-risk code patterns, and verifies WordPress core files against official checksums to detect malicious tampering.</li>
<li>Japanese SEO Spam Auto-Fix Engine: A specialized, deep-scanning engine designed to detect and eradicate the notorious “Japanese Keyword Hack”. Features a one-click Auto-Fix that intelligently restores or quarantines hijacked posts to protect your Google ranking without destroying your original content.</li>
</ul>
<h3>Advanced Security: Defeating the Japanese SEO Keyword Hack</h3>
The “Japanese Keyword Hack” is a devastating black-hat SEO attack where hackers exploit vulnerabilities in outdated plugins to inject massive amounts of auto-generated Japanese text and malicious links into your database and core files. This causes Google to flag your site as “hacked,” instantly destroying your SEO ranking.
SPM by Marwan includes a highly specialized engine specifically built to defeat this attack:
<ul>
<li>Deep Database Scanning: Actively crawls your <code>wp_posts</code> and <code>wp_options</code> tables, utilizing advanced Unicode block detection to find injected Japanese Hiragana, Katakana, and Kanji spam hidden within your legitimate content.</li>
<li>Intelligent Auto-Fix (No Data Loss): When you click “Auto-Fix”, the scanner doesn’t just blindly delete your hijacked posts. Instead, it scans the WordPress Revision History for each infected post. It finds the last “clean” version of your post (before the hacker touched it) and seamlessly restores it.</li>
<li>Fail-Safe Quarantining: If a post was created entirely by the hacker (meaning no clean revision exists), or if you have revisions disabled, the engine will safely quarantine the post by setting its status to Draft. This instantly removes the spam from the public internet—stopping the SEO bleed—while preserving the draft in your admin panel so you don’t lose any data.</li>
<li>Orphaned File Detection: Scans your entire server structure to locate and quarantine backdoor PHP scripts that hackers leave behind to reinfect your site after you clean it.</li>
<li>Core Checksum Verification: Verifies every single WordPress core file against the official WordPress.org cryptographic checksums to detect hidden cloaking scripts.</li>
<li>Trust Verification: Evaluates code based on developer reputation, update frequency, repository standing, and code integrity. Establishes a trust score to help you make informed decisions about your technology stack.</li>
<li>Historical Analytics: Maintains a robust ledger of performance and security metrics over time. Visualizes trends to help you understand the long-term impact of specific extensions and updates.</li>
<li>Action Layer (Scan / Safe Mode / Reporting): Provides immediate remediation tools. Execute targeted scans, isolate problematic extensions using Safe Mode, and generate comprehensive diagnostics reports.</li>
</ul>
<h3>External Services</h3>
This plugin utilizes the WordPress.org Plugins API (https://api.wordpress.org) to verify plugin licenses and retrieve information about installed plugins. 
* What data is sent: The names and slugs of your active plugins are sent in the API request. 
* When it is sent: Data is sent when the plugin performs a scheduled background scan or when you manually click “Deep Scan” or “Refresh Now” on the dashboard. 
* Why it is used: To verify that the plugins running on your site are authentic, properly licensed, and available on the official WordPress.org directory, which enhances your site’s security and trust metrics.
For more information, please refer to the <a href="https://wordpress.org/about/privacy/" rel="ugc">WordPress.org Privacy Policy</a>.

SPM by Marwan

Tracks load time and PHP errors for each active extension, storing logs in a custom database table.

tombenner

MySQL Profiler displays debugging information about SQL queries to admin WordPress users. For each query, the profiler displays the time, syntax-highlighted SQL, and a trace of the functions (as well as the file and line number that the functions were called from) that were called.
The list can be sorted by any of its columns, so you can, for example:
<ul>
<li>Order the list by ID to see the chronological order of the queries</li>
<li>Order the list by time to see the slowest queries</li>
<li>Order the list by query to group the queries by type (SELECT, UPDATE, etc)</li>
<li>Order the list by trace to group the queries by similar origins</li>
</ul>
The list can also filtered by typing in the search box, so you can, for example:
<ul>
<li>View all queries that use the wp_posts table</li>
<li>View all queries that are related to the use of a function in taxonomy.php</li>
<li>View all queries that are related to the use of a specific function or class</li>
<li>View all queries that call a specific MySQL function</li>
</ul>
To turn off syntax highlighting, put the following in wp-config.php:
<pre><code>define('MP_HIGHLIGHT_SYNTAX', false);
</code></pre>
To omit the file and line number from the function trace and display the functions as a comma-separated list (to save vertical space), define the following in wp-config.php:
<pre><code>define('MP_DISPLAY_FILES', false);
</code></pre>
This plugin was loosely based on <a href="http://bueltge.de/" rel="nofollow ugc">Frank Bueltge</a>‘s <a href="https://wordpress.org/extend/plugins/debug-queries/" rel="ugc">Debug Queries</a> plugin, so a hearty thanks to him for the development of that.
If you’d like to grab development releases, see what new features are being added, or browse the source code please visit/follow the <a href="http://github.com/tombenner/mysql-profiler" rel="nofollow ugc">GitHub repo</a>.

MySQL Profiler

Displays a list of each page's SQL queries and the functions calling them that can be searched and sorted by time, type, etc.

SPM by Marwan vs MySQL Profiler