Preferred Method of debugging a wordpress SQL calls?

Turn on define( 'WP_DEBUG', true ); and define( 'SAVEQUERIES', true ); .

I prefer the format of the debug bar, http://wordpress.org/extend/plugins/debug-bar/ , which can be combined with the console, http://wordpress.org/extend/plugins/debug-bar-console/ .

This script is great for profiling, Best Collection of Code for your functions.php file

There are some other plugins that might help, like Debug Queries, but you probably going to have to use a debugger like xdebug to get more fine grained details.

Related Posts:

  1. Does the debug.log do log rotation?
  2. Same log message keeps on printing to debug.log file thousand of times
  3. How to fix the admin menu margin-top bug in WordPress 5.5?
  4. error_log() output for print_r() appearing on page
  5. Transaction when using WP functions rather than vanilla SQL?
  6. $wpdb->get_results(…) returns empty array despite correct query
  7. How to get the list of WooCommerce product image of a certain category from database?
  8. How to make WordPress plugin check for database changes and then do something?
  9. Debugging an error: wp_enqueue_style was called incorrectly
  10. Alter query on edit.php
  11. How to auto login user again after change user_login
  12. How to display multiple Post meta_key/meta_values by SQL query
  13. How to Join two tables from separate databases within WordPress
  14. count number of user comments with a specific comment meta value
  15. Where exactly do I write define( ‘WP_DEBUG’, true ) in wp-config file
  16. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  17. Utilize WP-CLI from inside WordPress, not SSH
  18. error_log is not working as expected in functions.php file
  19. WPDB: how to get the value of a field in a custom database table
  20. Database “Migration” for Plugins?
  21. Using FirePHP with WordPress
  22. Debugging PHP object during Ajax call in WordPress
  23. my function doesn’t return my post from today
  24. “Notice: Undefined variable: content” is showing [closed]
  25. Enhanced WordPress Search
  26. Automatically generate Post/Page from searched Database item?
  27. List of posts by day of the week
  28. register_activation_hook isn’t adding table to DB
  29. mysqli_real_connect() – authentication method unknown to the client Warnings
  30. How to display posts of specific category using a custom Query in WordPress?
  31. How to debug php code in hostgator cPanel
  32. how to trace notice warning on core function is_page() & is_singular in class-wp-query.php
  33. What SQL / WordPress queries would need a nonce?
  34. Renaming post IDs – Okay to do?
  35. How to generate page content from database the right way?
  36. phpMyAdmin displays error when importing database
  37. Huge debug.log because of “undefined offset in media.php”
  38. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  39. Get stock by custom meta field on all Woocommerce variable products
  40. Transferring working local PHP site to wordpress – with database (MySQL)
  41. how to delete 30 day old data using PHP [closed]
  42. Display fields as values in array from external SQL DB
  43. How to find error in my code when the error message is pointing to WP core file?
  44. Importing Geo data into wordpress database
  45. Detect session/cookie variable in wordpress to prevent access to documents
  46. Querying wpdb using PHP
  47. Mute Debug Messages from Plugins
  48. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  49. XAMPP-VM Mac OS Mojave wordpress debugging using XDebug
  50. How to debug my custom login form looping intermittently
  51. Archive post by meta value + 24hours
  52. Genesis framework comments broken?
  53. $wpdb->insert() does not Insert record in a table
  54. Databases – Submitting data from inputs to database [closed]
  55. “Undefined index” error when saving empty array with checkboxes
  56. I restricted wordpress by logged users. It’s possible exclude a page?
  57. Site throws 500 error after upgrading from PHP 5.6 to 7.X
  58. Is it best to avoid using $wpdb for security issues?
  59. dynamic page using php from sql database
  60. Use $wpdb or other PHP script method to find/replace in WP database
  61. How to Update post_modified of all wordpress post
  62. Correct PHP to output a single result of a Function with SQL Query
  63. How can I add a new row in a separate database when someone registers via WordPress?
  64. How to display SQL query that ran in WC_Order_Query?
  65. How can I find the cause of a 500 server error?
  66. PHP -> SQL Query with Summing
  67. Lost in trying to create user database system
  68. Pull MySQL data from multiple tables and merge into 1 PHP array
  69. Hooks for post saving make a post-new.php to load latest post’s data
  70. Filter results from a serialized string to use on statistics
  71. wordpress site – using custom database and PHP
  72. Searching Posts Programmatically in a WordPress Plugin
  73. add button to specific post
  74. Use variable in SQL statement
  75. Why my query does not run with prepare
  76. wpdb getting avatars and author url
  77. mySQL queries are executed twice on wordpress website
  78. making php value numeric
  79. Using color schemes with Color Picker
  80. WordPress SQL JOIN query
  81. Fetching review value using wpdb class
  82. Remove password protection from all posts
  83. quotes problem in very simple sql
  84. wordpress sql posts query won’t display the latest post in a specific category
  85. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  86. WP_Query: How to get results from both meta_key options?
  87. Publish button now showing content after saving
  88. get_terms with specific id order
  89. Database SQL query error
  90. get different meta-data of a complicated query at the same time
  91. WordPress SQL Prepare
  92. Build A Custom SQL Query for WordPress Search
  93. How to run complex query using PHP
  94. Storing huge number of users in wordpress
  95. add role on WordPress in PHP on a second database
  96. Trying to create a shortcode to display categories with a specific product tag
  97. Fetch Data from an external MSSQL Database in a Managed WP hosting
  98. Run a sql (update) after 12 hours after the user login. Woocommerce users
  99. Creating multiple tables with Plugin
  100. var_dump() and print_r() display null in php
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)