Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `statements_with_full_table_scans`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
query db exec_count total_latency no_index_used_count no_good_index_used_count no_index_used_pct rows_sent rows_examined rows_sent_avg rows_examined_avg first_seen last_seen digest
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema 1 892.58 us 1 0 100 272 313 272 313 2022-07-01 21:48:05.111297 2022-07-01 21:48:05.111297 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... PRUEBA 3 8.82 ms 3 0 100 816 939 272 313 2022-07-01 21:46:46.919934 2022-07-01 21:48:13.578613 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... information_schema 2 710.43 us 2 0 100 2 6 1 3 2022-07-01 21:46:59.101184 2022-07-01 21:48:05.118931 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...
SELECT `PRIVILEGE_TYPE` FROM ` ... ` = ? AND `PRIV... NULL 16 7.93 ms 16 0 100 16 2768 1 173 2022-07-01 21:46:46.706131 2022-07-01 21:48:06.712959 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... mysql 12 7.05 ms 12 0 100 12 36 1 3 2022-07-01 21:46:35.437841 2022-07-01 21:48:10.444546 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...
SELECT `cs` . `name` AS `CHARA ... ation_id` = `co... mysql 10 6.64 ms 10 0 100 410 820 41 82 2022-07-01 21:46:50.388992 2022-07-01 21:48:10.439253 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... sakila 5 5.00 ms 5 0 100 5 15 1 3 2022-07-01 21:46:30.885533 2022-07-01 21:48:04.996181 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... sakila 2 4.81 ms 2 0 100 544 626 272 313 2022-07-01 21:47:49.847193 2022-07-01 21:47:52.373212 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `PLUGIN_NAME` , `PLUGIN ... UGINS` WHERE `P... mysql 2 4.71 ms 2 0 100 8 90 4 45 2022-07-01 21:46:35.469836 2022-07-01 21:46:35.478430 da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql 27 37.65 ms 27 0 100 346 1900 13 70 2022-07-01 21:46:35.463552 2022-07-01 21:47:49.335619 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL 39 33.05 ms 39 0 100 39 117 1 3 2022-07-01 21:46:31.233748 2022-07-01 21:48:16.857556 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...
SELECT ? FROM `INFORMATION_SCH ... ? AND ? LIKE `G... mysql 2 328.62 us 2 0 100 2 290 1 145 2022-07-01 21:46:35.438230 2022-07-01 21:47:04.831580 9071920946be0ae7e686bb45c4e0754a815b9d355b39baa11b...
( SELECT DISTINCTROW `Db` FROM ... `Host` = ? ) OR... mysql 1 252.41 us 1 0 100 0 2 0 2 2022-07-01 21:46:35.440611 2022-07-01 21:46:35.440611 2079cf6b3b7085a1f0a0c40460e6c92cd7eadc3d4df10b82c1...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL 18 22.10 ms 18 0 100 221 1358 12 75 2022-07-01 21:46:59.523966 2022-07-01 21:48:05.641187 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... performance_schema 1 2.73 ms 1 0 100 272 313 272 313 2022-07-01 21:47:09.839826 2022-07-01 21:47:09.839826 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... performance_schema 2 2.31 ms 2 0 100 2 6 1 3 2022-07-01 21:47:09.868061 2022-07-01 21:47:46.661210 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... PRUEBA 3 2.23 ms 3 0 100 3 9 1 3 2022-07-01 21:46:47.023457 2022-07-01 21:48:13.591258 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... sys 1 2.16 ms 1 0 100 1 3 1 3 2022-07-01 21:46:33.820569 2022-07-01 21:46:33.820569 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql 10 18.14 ms 10 0 100 2720 3130 272 313 2022-07-01 21:46:50.393849 2022-07-01 21:48:10.440219 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT * , IF ( `authenticatio ... DER BY `User` A... mysql 1 176.67 us 1 0 100 9 18 9 18 2022-07-01 21:47:04.832290 2022-07-01 21:47:04.832290 7e35898f02101bb4b68e88cb043db562a54aa4e9dc32262467...
SELECT `substring_index` ( `pe ... read` , `perfor... sys 1 14.81 ms 1 0 100 1 50 1 50 2022-07-01 21:46:33.804649 2022-07-01 21:46:33.804649 001acad6df77536b50a4fdc21354e9426aaa898fdbc82e1b9a...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema 8 11.92 ms 8 0 100 66 442 8 55 2022-07-01 21:47:09.851279 2022-07-01 21:47:46.643611 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT * FROM `actor` LIMIT ?, ... sakila 3 11.12 ms 3 0 100 75 75 25 25 2022-07-01 21:46:30.713290 2022-07-01 21:48:04.975560 74cbd054819a94d3c9bf9156ca8e47dc3bde5b31caf0b6d709...
SELECT * , IF ( `authenticatio ... . ) AS ? FROM `... mysql 1 105.44 us 1 0 100 9 9 9 9 2022-07-01 21:47:04.832562 2022-07-01 21:47:04.832562 ba2fc1ea30a8cc4fea039713c45ea5981e639304d48732fceb...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema 4 1.89 ms 4 0 100 33 219 8 55 2022-07-01 21:46:59.092417 2022-07-01 21:46:59.097828 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
Query results operations