Improvements to the sql debug traces on the web Add $CFG->debugsqltrace = 100; to config.php Download MDL-79312 -sql-debug.php turns debugging on manually from code Run it in a browser without logging in Confirm that the comments are generally before the SQL instead of after. Note some edge cases have the sql somewhere in the middle of the query. Confirm they are sql block comments not inline comments Confirm that the url of the page is present Login and then reload the test script Confirm that the username and user's id are also present in the SQL comments Improvements to the sql debug traces on the CLI On the cli run php MDL-79312 -sql-debug.php Confirm that the script path is present in the comment Test new option to display sql debugging Visit /admin/settings.php?section=debugging&debugsqlfrom=1 and confirm you see the normal admin settings page with no extra debugging Tick debugsql and save Visit /admin/settings.php?section=debugging&debugsqlfrom=1 and confirm you see a large number of raw queries Confirm that for each query you see the bind variables and their values Confirm that the first query contains a reference to itself: * line 18 of / MDL-79312 sql-debug.php ... Confirm that each query has a query number in sequence from 1 to roughly 100. Visit /admin/settings.php?section=debugging&debugsqlfrom=60&debugsqlto=65 and confirm you now see a subset of queries from query 60 to query 65 inclusive