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 `statement_analysis`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
query db full_scan exec_count err_count warn_count total_latency max_latency avg_latency lock_latency rows_sent rows_sent_avg rows_examined rows_examined_avg rows_affected rows_affected_avg tmp_tables tmp_disk_tables rows_sorted sort_merge_passes digest first_seen last_seen
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys * 2 0 0 1.01 s 1.00 s 502.84 ms 161.00 us 25 13 9420 4710 0 0 9 1 671 1 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2022-08-09 14:50:13.585437 2022-08-09 14:50:13.603716
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... NULL 231 0 0 994.54 ms 127.74 ms 4.31 ms 114.58 ms 470 2 4833 21 0 0 231 0 470 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-08-09 14:47:12.352356 2022-08-09 14:53:02.364060
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql 3 0 0 695.90 ms 692.11 ms 231.97 ms 3.42 ms 99 33 624 208 0 0 1 0 99 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-09 14:47:14.359641 2022-08-09 14:47:15.140753
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila 38 0 0 405.83 ms 306.51 ms 10.68 ms 37.68 ms 119 3 513 14 0 0 1 0 70 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-09 14:46:52.505478 2022-08-09 14:52:32.142980
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sys 1267 0 0 314.08 ms 595.58 us 247.89 us 170.66 ms 1265 1 7596 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2022-08-09 14:50:13.587087 2022-08-09 14:50:14.110271
CREATE TABLE IF NOT EXISTS `CS ... tf8` COLLATE `u... NULL 1 0 2 254.22 ms 254.22 ms 254.22 ms 2.58 ms 0 0 0 0 0 0 0 0 0 0 67446036e4bfd7d028d2c6298763d1bdd0fcef661bab170673... 2022-08-09 14:48:29.410009 2022-08-09 14:48:29.410009
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 231 0 0 215.46 ms 3.87 ms 932.71 us 111.48 ms 1325 6 7621 33 0 0 231 0 1325 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-08-09 14:47:12.348873 2022-08-09 14:53:02.363295
SHOW TABLES FROM `phpmyadmin` NULL 864 864 0 202.53 ms 5.22 ms 234.40 us 81.42 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-08-09 14:46:38.218267 2022-08-09 14:53:03.630891
CREATE TABLE `ALUNO` ( `NOME`  ... L AUTO_INCREMEN... Patricia 1 0 0 186.81 ms 186.81 ms 186.81 ms 195.00 us 0 0 0 0 0 0 0 0 0 0 ecbea690c26de125e4115f9157bd36ce6ca0add31a9f08bec4... 2022-08-09 14:50:57.428812 2022-08-09 14:50:57.428812
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 120 0 0 145.08 ms 6.95 ms 1.21 ms 74.32 ms 573 5 3317 28 0 0 97 0 499 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-08-09 14:46:52.521879 2022-08-09 14:52:32.156800
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 97 0 0 132.23 ms 3.25 ms 1.36 ms 81.82 ms 845 9 5583 58 0 0 0 0 797 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-09 14:46:38.250212 2022-08-09 14:53:02.365412
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 92 0 0 131.78 ms 7.64 ms 1.43 ms 44.83 ms 1181 13 7291 79 0 0 216 0 2198 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-09 14:46:38.241026 2022-08-09 14:53:02.774821
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 148 0 0 122.97 ms 3.84 ms 830.88 us 35.90 ms 148 1 444 3 0 0 888 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-08-09 14:46:38.252614 2022-08-09 14:53:03.190411
INSERT INTO `CSV_DB 34` . `c__ ... 15` ) VALUES (.... NULL 1 0 0 117.73 ms 117.73 ms 117.73 ms 1.16 ms 0 0 0 0 101 101 0 0 0 0 d4b0b24b56bfae2b7dac6615353cd5de71199dec8deb299435... 2022-08-09 14:48:29.618032 2022-08-09 14:48:29.618032
SHOW SESSION VARIABLES LIKE ? sakila * 77 0 0 117.58 ms 7.30 ms 1.53 ms 10.02 ms 77 1 44198 574 0 0 77 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-08-09 14:46:52.598567 2022-08-09 14:52:32.155838
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 33 0 0 105.26 ms 33.19 ms 3.19 ms 21.27 ms 71 2 794 24 0 0 33 0 71 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-08-09 14:46:52.555974 2022-08-09 14:52:32.145042
SHOW SESSION VARIABLES LIKE ? NULL * 68 0 0 95.36 ms 6.89 ms 1.40 ms 8.04 ms 68 1 39032 574 0 0 68 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-08-09 14:46:38.230801 2022-08-09 14:53:03.635136
CREATE SCHEMA `contact.php` DE ... f16` COLLATE `u... NULL 1 0 0 72.38 ms 72.38 ms 72.38 ms 4.84 ms 0 0 0 0 1 1 0 0 0 0 8bb4e97c044113fd3ebf26c8d137d02951cfaf81022c8dd8fa... 2022-08-09 14:47:48.520638 2022-08-09 14:47:48.520638
SELECT @@`version` , @@`version_comment` NULL 432 0 0 59.04 ms 365.18 us 136.66 us 0 ps 432 1 432 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2022-08-09 14:46:38.214853 2022-08-09 14:53:03.629705
CREATE SCHEMA IF NOT EXISTS `C ... tf8` COLLATE `u... NULL 1 0 2 58.59 ms 58.59 ms 58.59 ms 117.00 us 0 0 0 0 1 1 0 0 0 0 20eec70e7ef1e4af8f48d63c2dd33362f71a4116fb0479b1f5... 2022-08-09 14:48:29.139356 2022-08-09 14:48:29.139356
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sakila 77 0 0 56.22 ms 1.45 ms 730.08 us 31.17 ms 0 0 231 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2022-08-09 14:46:52.458932 2022-08-09 14:52:32.141851
SELECT `cat` . `name` AS `CATA ... database` ( `sc... sakila * 68 0 0 55.04 ms 3.36 ms 809.39 us 17.79 ms 748 11 4940 73 0 0 155 0 1385 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-09 14:46:52.611948 2022-08-09 14:52:01.771806
CREATE SCHEMA `Patricia` NULL 1 0 0 54.37 ms 54.37 ms 54.37 ms 43.00 us 0 0 0 0 1 1 0 0 0 0 b91d951b823b21148fb55ba0fac77ac17f22bebce6dbda6306... 2022-08-09 14:47:48.676846 2022-08-09 14:47:48.676846
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 66 0 9 53.84 ms 3.38 ms 815.76 us 19.52 ms 1161 18 4738 72 0 0 123 0 1249 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-09 14:46:40.738773 2022-08-09 14:53:02.003130
CREATE SCHEMA `Portfolio` DEFA ... ` COLLATE `utf8... NULL 1 0 0 50.90 ms 50.90 ms 50.90 ms 139.00 us 0 0 0 0 1 1 0 0 0 0 6029ce7f3c87083a8b271a627fbec3007b7cc84982d7d4efb2... 2022-08-09 14:48:04.201868 2022-08-09 14:48:04.201868
Query results operations