What is the recommended method for measuring the execution time of database queries in PHP?

When measuring the execution time of database queries in PHP, the recommended method is to use the microtime() function to capture the current time before and after executing the query, and then calculate the difference to determine the elapsed time. This method provides an accurate measurement of the time taken by the query to execute.

// Start time
$start_time = microtime(true);

// Database query execution
// Example: $result = mysqli_query($connection, "SELECT * FROM table");

// End time
$end_time = microtime(true);

// Calculate elapsed time
$execution_time = $end_time - $start_time;

// Output execution time
echo "Query execution time: " . $execution_time . " seconds";