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 `a` . `actor_id` AS `ac ... irst_name` , `a... sakila * 10 0 0 1.33 s 283.61 ms 133.12 ms 2.01 ms 77 8 1614466 161447 0 0 15 0 1003 0 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... 2022-08-20 08:05:53.979090 2022-08-20 08:08:18.702163
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... NULL 103 0 0 948.71 ms 104.09 ms 9.21 ms 59.21 ms 196 2 2055 20 0 0 103 0 196 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-08-20 08:01:55.300096 2022-08-20 08:12:28.993916
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila 16 0 0 405.79 ms 384.16 ms 25.36 ms 12.27 ms 170 11 737 46 0 0 2 0 165 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-20 08:01:50.741887 2022-08-20 08:13:54.650265
SHOW TABLES FROM `phpmyadmin` NULL 1258 1258 0 251.90 ms 4.61 ms 200.24 us 107.73 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-08-20 08:01:43.379314 2022-08-20 08:14:12.531577
CREATE TABLE `ssk` ( `sn` INTE ... HARACTER (?) , ... students 1 0 0 228.85 ms 228.85 ms 228.85 ms 196.00 us 0 0 0 0 0 0 0 0 0 0 c203dd671ccf168fe96c7f7f200d2f85687ca96f4f49380130... 2022-08-20 08:04:11.908384 2022-08-20 08:04:11.908384
CREATE TABLE `CUSTOMERS` ( `ID ... (...) , PRIMARY... FAIZ 1 0 0 227.36 ms 227.36 ms 227.36 ms 198.00 us 0 0 0 0 0 0 0 0 0 0 e25f25641af6c68a5ae5ffc404fdc147a3656753d6d2ec24b0... 2022-08-20 08:11:50.712866 2022-08-20 08:11:50.712866
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sakila 694 0 0 161.97 ms 1.35 ms 233.38 us 86.89 ms 675 1 4107 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2022-08-20 08:03:30.986428 2022-08-20 08:13:54.651756
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 103 0 0 107.31 ms 6.18 ms 1.04 ms 49.92 ms 558 5 3257 32 0 0 101 0 556 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-08-20 08:01:55.249708 2022-08-20 08:12:28.993031
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 75 0 0 96.52 ms 3.05 ms 1.29 ms 60.88 ms 452 6 2894 39 0 0 2 0 414 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-20 08:01:48.073209 2022-08-20 08:13:28.033096
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... students 23 0 0 88.67 ms 32.76 ms 3.86 ms 23.84 ms 23 1 130 6 0 0 2 0 11 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-20 08:02:24.146022 2022-08-20 08:12:22.318901
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 86 0 0 82.39 ms 5.49 ms 957.97 us 28.43 ms 967 11 6068 71 0 0 202 0 1822 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-20 08:01:44.086210 2022-08-20 08:13:46.441164
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 102 0 0 80.44 ms 1.79 ms 788.61 us 23.35 ms 102 1 306 3 0 0 612 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-08-20 08:01:44.093119 2022-08-20 08:13:55.190528
CREATE SCHEMA `FAIZ` NULL 1 0 0 78.76 ms 78.76 ms 78.76 ms 932.00 us 0 0 0 0 1 1 0 0 0 0 ac298e7336e550ef70fd72175a3849558de8c4d3da10244c66... 2022-08-20 08:10:16.387167 2022-08-20 08:10:16.387167
SELECT @@`version` , @@`version_comment` NULL 629 0 0 76.02 ms 961.51 us 120.86 us 0 ps 629 1 629 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2022-08-20 08:01:43.373662 2022-08-20 08:14:12.529498
SHOW SESSION VARIABLES LIKE ? students * 20 0 0 74.36 ms 31.03 ms 3.72 ms 1.62 ms 20 1 11480 574 0 0 20 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-08-20 08:02:33.012357 2022-08-20 08:12:22.314024
SHOW SESSION VARIABLES LIKE ? NULL * 52 0 0 63.75 ms 4.61 ms 1.23 ms 4.94 ms 52 1 29848 574 0 0 52 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-08-20 08:01:46.734923 2022-08-20 08:14:12.535836
SET `lc_messages` = ? NULL 629 0 0 61.89 ms 6.58 ms 98.39 us 0 ps 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2022-08-20 08:01:43.375570 2022-08-20 08:14:12.529932
INSERT INTO `actor` VALUES (...) sakila 1 0 0 57.94 ms 57.94 ms 57.94 ms 527.00 us 0 0 0 0 1 1 0 0 0 0 4bfc7dfaa8ccd4cb52a69da93360c817a88249cad86142ba8f... 2022-08-20 08:07:47.484130 2022-08-20 08:07:47.484130
SHOW SESSION VARIABLES LIKE ? sakila * 44 0 0 56.68 ms 3.81 ms 1.29 ms 4.67 ms 44 1 25256 574 0 0 44 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-08-20 08:01:53.299505 2022-08-20 08:13:54.662327
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 51 0 4 52.69 ms 9.13 ms 1.03 ms 18.21 ms 695 14 3478 68 0 0 108 0 969 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-20 08:01:43.400895 2022-08-20 08:13:47.483987
DELETE FROM `actor` WHERE `actor` . `actor_id` = ? sakila 1 1 0 48.63 ms 48.63 ms 48.63 ms 1.56 ms 0 0 1 1 0 0 0 0 0 0 d26dc89d8839ce10a3cca49cdb75a6823decc8a091c491dfcb... 2022-08-20 08:06:47.729100 2022-08-20 08:06:47.729100
SELECT `rtn` . `name` AS `SPEC ...  . `name` ) WHE... NULL 26 0 0 48.38 ms 16.64 ms 1.86 ms 22.90 ms 26 1 268 10 0 0 0 0 0 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2022-08-20 08:01:48.095213 2022-08-20 08:13:12.866410
SET NAMES ? COLLATE ? NULL 629 0 0 43.84 ms 416.68 us 69.70 us 0 ps 0 0 0 0 0 0 0 0 0 0 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... 2022-08-20 08:01:43.374775 2022-08-20 08:14:12.529759
SET `collation_connection` = ? NULL 629 0 0 42.37 ms 243.10 us 67.35 us 0 ps 0 0 0 0 0 0 0 0 0 0 d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... 2022-08-20 08:01:43.381129 2022-08-20 08:14:12.531211
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 15 0 0 35.49 ms 5.16 ms 2.37 ms 4.07 ms 4080 272 4695 313 0 0 15 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-08-20 08:01:43.406513 2022-08-20 08:13:47.475514
Query results operations