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:
- Order the list by ID to see the chronological order of the queries
- Order the list by time to see the slowest queries
- Order the list by query to group the queries by type (SELECT, UPDATE, etc)
- Order the list by trace to group the queries by similar origins
The list can also filtered by typing in the search box, so you can, for example:
- View all queries that use the wp_posts table
- View all queries that are related to the use of a function in taxonomy.php
- View all queries that are related to the use of a specific function or class
- View all queries that call a specific MySQL function
To turn off syntax highlighting, put the following in wp-config.php:
define('MP_HIGHLIGHT_SYNTAX', false);
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:
define('MP_DISPLAY_FILES', false);
This plugin was loosely based on Frank Bueltge's Debug Queries 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 GitHub repo.
Debug Queries
List query-actions only for admins; for debug purposes. See all queries on the frontend of the blog and find the slowest part....
MySQL Monitor
SqlMe will help you with monitoring of MySQL server and understanding what it does when you sleep.
Plugin will show you:
how much queries wordpress does per page
MySQL server process list
database tables, their size and engine types
growth trends - how fast your table growth
MySQL configuration
.........
ABASE
The ABASE shortcode accesses a MySQL database without having to code PHP. Over 30 optional attribute values specify whether a shortcode on a page is replaced with an HTML input form or an SQL query output. Forms to search, insert, update or delete records are easy to specify. Output can be a formatt.........
Query debug info
Adds information about the query to the front end, including page type, post count, query vars, the query string and the
wordpress sites constants
You can track up to 3 queries with this plugin, usefull to debug custom loops....
What's running
Only for development!Now with OPcache memory consumption support
This plugin dumps the colorized filenames and memory consumptions or file sizes after the normal WordPress HTML output,
after the closing html tag.
This generates invalid HTML but gives you an overview of loaded plugins and the curren.........
Adminer
Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. This plugin include this tool in WordPress for a fast management of your database. Adminer is also used without this plu.........
Debug Objects
The Plugin Debug Objects provides the user, which has the appropriate rights, normally the administrator, a large number of information: query, cache, cron, constants, hooks, functions and many many more. Values and content get displayed at the frontend and backend of the blog, to analyze errors but.........
Query Monitor
Query Monitor is a debugging plugin for anyone developing with WordPress. It has some advanced features not available in other debugging plugins, including automatic AJAX debugging, REST API debugging, and the ability to narrow down things by plugin or theme.
For complete information, please see Qu.........
Run SQL Query
This plugin will allow you to execute any type of SQL query into the WordPress's DB connecting through the driver provided by the MySQLi extension without the need to use another tool like phpMyAdmin.
It also gives you the ability to export the results in a CSV format file.
In order to access this.........
Wixiweb FirePHP Queries
Use Firebug with FirePHP to analyze the SQL queries made by WordPress. Ideal for development and avoid performance issues.
...
