查询执行时间

SHOW PROFILE for query 67

SHOW PROFILES

SELECT * from users

SET @query_id = 127;
SELECT
state,
sum( DURATION ) AS Total_r,
round(
100 * sum( DURATION ) / (
SELECT
sum( DURATION )
FROM
information_schema.PROFILING
WHERE
query_id = @query_id
),
2
) AS Pct_r,
count( * ) AS Calls,
Sum( DURATION ) / count( * ) AS “R/Call”
FROM
information_schema.PROFILING
WHERE
query_id = @query_id
GROUP BY
state
ORDER BY
Total_r DESC