Drop files here

SQL upload ( 0 ) x -

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
Restore default values
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`
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 COUNT ( * ) FROM `perfo ... summary_by_user... performance_schema 1 993.66 us 1 0 100 1 0 1 0 2024-06-16 10:25:30.560182 2024-06-16 10:25:30.560182 ef734a46110304ad27721dc5443f9fee2da6c051f98112cfe2...
SELECT ? FROM `information_schema` . `INNODB_COLUM... information_schema 1 96.51 ms 1 0 100 1 1 1 1 2024-06-16 10:23:48.004279 2024-06-16 10:23:48.004279 548c02dda47c1454923b30fc7f703a1ebf478276c85df39cd2...
SELECT * FROM `ENGINES` LIMIT ?, ... information_schema 1 96.00 us 1 0 100 9 9 9 9 2024-06-16 10:16:50.857827 2024-06-16 10:16:50.857827 ebc3f62be44d4a8273d11d5aef62627225f7e81be12699fbb9...
SELECT `cat` . `name` AS `TRIG ... id` = `trg` . `... b1 2 954.10 us 2 0 100 0 14 0 7 2024-06-16 10:19:02.467317 2024-06-16 10:19:08.717943 45926d3848f4a352ffb3c67bea85c2161a2e8149b70b212a41...
SELECT ? FROM `information_schema` . `INNODB_CMPME... information_schema 1 91.39 us 1 0 100 1 1 1 1 2024-06-16 10:17:16.016252 2024-06-16 10:17:16.016252 e8a10340ff58f564fcb0edb863d518b4a5a8c4a8146b0d48a9...
SELECT * FROM `events_transact ... st_by_event_nam... performance_schema 1 906.66 us 1 0 100 2 2 2 2 2024-06-16 10:19:07.841770 2024-06-16 10:19:07.841770 e7553f147f8d7cd179acc62423b55c1616ba37fdd771a29ee2...
SELECT `cat` . `name` AS `TRIG ... id` = `trg` . `... university 13 9.65 ms 13 0 100 0 69 0 5 2024-06-16 10:23:22.744545 2024-06-16 10:26:55.553080 45926d3848f4a352ffb3c67bea85c2161a2e8149b70b212a41...
SELECT * FROM `session_status` LIMIT ?, ... performance_schema 1 9.30 ms 1 0 100 25 25 25 25 2024-06-16 10:17:21.546929 2024-06-16 10:17:21.546929 0358d97188739cab939e7b5d195ecc23ca693443f8dcc295f0...
SELECT `cat` . `name` AS `EVEN ... ECUTED` , `evt`... university 2 867.49 us 2 0 100 0 0 0 0 2024-06-16 10:23:34.972055 2024-06-16 10:24:50.158834 88dbede231305f241aae78ef7e6986a7e44ea5f199241c5e35...
SELECT * FROM `film` LIMIT ?, ... sakila 3 827.87 us 3 0 100 75 75 25 25 2024-06-16 10:16:45.719252 2024-06-16 10:17:01.177286 bc7c7ea1ea0ee83136859c20a5bac2bb70630a0a8e5c8313da...
SELECT `PLUGIN_NAME` , `PLUGIN ... UGINS` WHERE `P... mysql 11 8.93 ms 11 0 100 44 495 4 45 2024-06-16 10:17:05.788012 2024-06-16 10:23:32.772816 da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... performance_schema 8 8.72 ms 8 0 100 2176 2504 272 313 2024-06-16 10:22:11.911456 2024-06-16 10:24:34.808420 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT * FROM `events_statements_current` LIMIT ?,... performance_schema 9 8.09 ms 9 0 100 35 35 4 4 2024-06-16 10:17:56.077197 2024-06-16 10:25:06.247111 48a66f51b70d4dbcfae28baea5e7e549cd3303a632540a0923...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... university 169 79.47 ms 169 0 100 169 676 1 4 2024-06-16 10:23:18.803331 2024-06-16 10:27:18.040959 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema 2 79.07 ms 2 0 100 50 50 25 25 2024-06-16 10:17:49.289160 2024-06-16 10:19:45.823354 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...
SELECT `PRIVILEGE_TYPE` FROM ` ... ` = ? AND `PRIV... NULL 388 77.65 ms 388 0 100 388 67124 1 173 2024-06-16 10:15:57.253829 2024-06-16 10:27:17.133842 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT * FROM `INNODB_CMPMEM` LIMIT ?, ... information_schema 1 77.46 us 1 0 100 5 5 5 5 2024-06-16 10:17:15.944990 2024-06-16 10:17:15.944990 388f47e9e9cc32a714594d7a18c289a629edd4fddfee9556df...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL 1178 738.46 ms 1178 0 100 4670 27077 4 23 2024-06-16 10:15:57.209554 2024-06-16 10:27:17.118579 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT * FROM `university` . `hod` LIMIT ? university 1 72.07 us 1 0 100 1 1 1 1 2024-06-16 10:24:02.081987 2024-06-16 10:24:02.081987 85c6dc54af27b765274e79e7b92a1215cd0a4df8ed093c7f71...
SELECT * FROM `events_errors_s ... by_host_by_erro... performance_schema 1 716.02 us 1 0 100 25 25 25 25 2024-06-16 10:18:08.239690 2024-06-16 10:18:08.239690 e18fc741e825a585dfbbc85b49ac023a2f0049ad09dd8ddec9...
SELECT `cs` . `name` AS `CHARA ... ation_id` = `co... NULL 13 7.77 ms 13 0 100 533 1066 41 82 2024-06-16 10:15:57.141238 2024-06-16 10:25:08.282816 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... pertemuan 13 4 7.76 ms 4 0 100 1088 1252 272 313 2024-06-16 10:22:18.445251 2024-06-16 10:23:21.868663 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `j` . `word` AS `WORD`  ... served` INTEGER... NULL 1 7.67 ms 1 0 100 1 1 1 1 2024-06-16 10:25:53.945127 2024-06-16 10:25:53.945127 6ec88787580e5f43884c8a7e555fb6a676edc4b6626b15dc3a...
SELECT ? FROM `information_schema` . `INNODB_METRI... information_schema 2 698.41 us 2 0 100 2 2 1 1 2024-06-16 10:16:03.219588 2024-06-16 10:25:04.537450 791aa262412a75e42824e1eb9d8e525966dac6c8b5c6f935cc...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... sys 1376 694.09 ms 1372 0 100 7720 50797 6 37 2024-06-16 10:15:56.166144 2024-06-16 10:25:09.079111 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
Query results operations