Benchmarks
Plugin footprint 82% from 16 tests
Installer Passed 1 test
🔺 Critical test (weight: 50) | Verifying that this plugin installs correctly without errors
Install script ran successfully
Server metrics [RAM: ▲0.05MB] [CPU: ▼2.75ms] Passed 4 tests
Server-side resources used by SQLog
Normal server usage
| Page | Memory (MB) | CPU Time (ms) |
|---|---|---|
| Home / | 3.50 ▲0.04 | 40.05 ▼4.54 |
| Dashboard /wp-admin | 3.36 ▲0.06 | 49.34 ▼1.10 |
| Posts /wp-admin/edit.php | 3.48 ▲0.13 | 46.08 ▼1.77 |
| Add New Post /wp-admin/post-new.php | 5.94 ▲0.06 | 89.69 ▼3.58 |
| Media Library /wp-admin/upload.php | 3.27 ▲0.04 | 38.70 ▲8.39 |
Server storage [IO: ▲0.04MB] [DB: ▲0.00MB] 67% from 3 tests
Input-output and database impact of this plugin
Please fix the following
- There were 2 files (0.86KB) illegally modified outside of "wp-content/plugins/sqlog/" and "wp-content/uploads/"
- (new file) wp-content/mu-plugins/sqlog.php
- (modified) .htaccess
Filesystem: 13 new files
Database: no new tables, 11 new options
| New WordPress options |
|---|
| widget_recent-posts |
| sqlog_purge_interval |
| sqlog_install |
| can_compress_scripts |
| db_upgraded |
| widget_recent-comments |
| sqlog_plugin_version |
| sqlog_install_date |
| theysaidso_admin_options |
| widget_theysaidso_widget |
| ... |
Browser metrics Passed 4 tests
This is an overview of browser requirements for SQLog
Minimal impact on browser resources
| Page | Nodes | Memory (MB) | Script (ms) | Layout (ms) |
|---|---|---|---|---|
| Home / | 3,076 ▲330 | 15.09 ▲0.67 | 5.64 ▲3.40 | 41.80 ▼11.91 |
| Dashboard /wp-admin | 2,368 ▲177 | 6.48 ▲0.62 | 127.52 ▲21.59 | 39.35 ▼0.14 |
| Posts /wp-admin/edit.php | 2,280 ▲191 | 3.41 ▲1.41 | 53.58 ▲11.15 | 31.20 ▼3.63 |
| Add New Post /wp-admin/post-new.php | 1,689 ▲156 | 22.28 ▼0.86 | 549.26 ▼131.10 | 29.38 ▼21.83 |
| Media Library /wp-admin/upload.php | 1,413 ▲25 | 4.12 ▼0.11 | 81.39 ▼15.18 | 42.52 ▲0.71 |
Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 75% from 4 tests
🔸 Tests weight: 35 | All plugins must uninstall correctly, removing their source code and extra database tables they might have created
The following items require your attention
- This plugin did not uninstall successfully, leaving 11 options in the database
- widget_theysaidso_widget
- sqlog_install
- can_compress_scripts
- sqlog_purge_interval
- widget_recent-comments
- widget_recent-posts
- theysaidso_admin_options
- db_upgraded
- sqlog_uninstall_date
- sqlog_plugin_version
- ...
Smoke tests 50% from 4 tests
Server-side errors Passed 1 test
🔹 Test weight: 20 | A smoke test targeting server-side errors
Good news, no errors were detected
SRP 0% from 2 tests
🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
Please fix the following
- 1× PHP files perform the action of outputting non-empty strings when accessed directly:
- > /wp-content/plugins/sqlog/rewrites/sqlog.php
- 5× PHP files trigger server-side errors or warnings when accessed directly:
- > PHP Warning
Use of undefined constant SQLOG_PLUGIN_VERSION - assumed 'SQLOG_PLUGIN_VERSION' (this will throw an Error in a future version of PHP) in wp-content/plugins/sqlog/rewrites/sqlog.php on line 1
- > PHP Fatal error
Uncaught Error: Call to undefined function get_option() in wp-content/plugins/sqlog/mu-plugin-template/sqlog.php:3
- > PHP Warning
Use of undefined constant SQLOG_SLUG_CAMELCASE - assumed 'SQLOG_SLUG_CAMELCASE' (this will throw an Error in a future version of PHP) in wp-content/plugins/sqlog/rewrites/sqlog-process.php on line 1
- > PHP Fatal error
Uncaught Error: Call to undefined function plugin_dir_url() in wp-content/plugins/sqlog/sqlog.php:15
- > PHP Fatal error
Uncaught Error: Call to undefined function get_query_var() in wp-content/plugins/sqlog/rewrites/sqlog-process.php:1
- > PHP Warning
User-side errors Passed 1 test
🔹 Test weight: 20 | This is a shallow check for browser errors
Everything seems fine on the user side
Optimizations
Plugin configuration Passed 29 tests
readme.txt Passed 16 tests
You should put a lot of thought into formatting readme.txt as it is used by WordPress.org to prepare the public listing of your plugin
8 plugin tags: sql, csv, log, queries, mysql...
sqlog/sqlog.php Passed 13 tests
The entry point to "SQLog" version 1.0.0 is a PHP file that has certain tags in its header comment area
123 characters long description:
Log WordPress MySQL queries in csv file (and log file). Useful when you need to improve the performance or debug something.
Code Analysis Passed 3 tests
File types Passed 1 test
🔸 Test weight: 35 | This is a short overview of programming languages used in this plugin, detecting executable files
No dangerous file extensions were detected982 lines of code in 12 files:
| Language | Files | Blank lines | Comment lines | Lines of code |
|---|---|---|---|---|
| PHP | 7 | 166 | 130 | 973 |
| Markdown | 1 | 5 | 0 | 6 |
| JavaScript | 2 | 0 | 0 | 2 |
| CSS | 2 | 1 | 0 | 1 |
PHP code Passed 2 tests
Cyclomatic complexity and code structure are the fingerprint of this plugin
No complexity issues detected
| Cyclomatic complexity | |
|---|---|
| Average complexity per logical line of code | 0.29 |
| Average class complexity | 122.00 |
| ▷ Minimum class complexity | 122.00 |
| ▷ Maximum class complexity | 122.00 |
| Average method complexity | 3.76 |
| ▷ Minimum method complexity | 1.00 |
| ▷ Maximum method complexity | 14.00 |
| Code structure | ||
|---|---|---|
| Namespaces | 0 | |
| Interfaces | 0 | |
| Traits | 0 | |
| Classes | 1 | |
| ▷ Abstract classes | 0 | 0.00% |
| ▷ Concrete classes | 1 | 100.00% |
| ▷ Final classes | 0 | 0.00% |
| Methods | 40 | |
| ▷ Static methods | 14 | 35.00% |
| ▷ Public methods | 40 | 100.00% |
| ▷ Protected methods | 0 | 0.00% |
| ▷ Private methods | 0 | 0.00% |
| Functions | 2 | |
| ▷ Named functions | 0 | 0.00% |
| ▷ Anonymous functions | 2 | 100.00% |
| Constants | 9 | |
| ▷ Global constants | 9 | 100.00% |
| ▷ Class constants | 0 | 0.00% |
| ▷ Public constants | 0 | 0.00% |
Plugin size Passed 2 tests
Image compression Passed 2 tests
Using a strong compression for your PNG files is a great way to speed-up your plugin
No PNG files were detected