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 `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... NULL 190 0 0 981.09 ms 189.92 ms 5.16 ms 81.79 ms 382 2 3950 21 0 0 190 0 382 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-01 17:33:08.509761 2022-12-01 17:44:00.898367
CREATE TABLE `reward` ( `Emplo ... `Employee` ( `E... employee 1 0 0 428.21 ms 428.21 ms 428.21 ms 385.00 us 0 0 0 0 0 0 0 0 0 0 76e2f806a9de298f8fa61bc8d3a6910a7de0800c0354561748... 2022-12-01 17:32:27.754864 2022-12-01 17:32:27.754864
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila * 35 0 0 355.07 ms 197.36 ms 10.14 ms 18.77 ms 255 7 10480 299 0 0 16 0 947 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-01 17:33:14.322423 2022-12-01 17:43:58.751953
CREATE TABLE `Employee` ( `Emp ... epartement` VAR... employee 1 0 0 248.42 ms 248.42 ms 248.42 ms 598.00 us 0 0 0 0 0 0 0 0 0 0 8c159c72e16b9823e13c5003a53ed3efe51a21947765611e39... 2022-12-01 17:32:27.301328 2022-12-01 17:32:27.301328
SHOW TABLES FROM `phpmyadmin` NULL 1086 1086 0 234.41 ms 4.65 ms 215.84 us 102.67 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-12-01 17:32:10.390043 2022-12-01 17:44:02.946717
INSERT INTO `Employee` ( `Empl ... , `Departement`... employee 7 0 0 222.73 ms 36.37 ms 31.82 ms 841.00 us 0 0 0 0 7 1 0 0 0 0 d91cf3c363f979bfbe810a03f2f0b8c5def1c6e0fa2202ee9a... 2022-12-01 17:32:27.797107 2022-12-01 17:32:28.063555
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 246 0 1 208.19 ms 3.63 ms 846.31 us 70.54 ms 2734 11 17808 72 0 0 571 0 5052 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-01 17:32:13.270568 2022-12-01 17:43:53.691348
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 184 0 0 183.88 ms 7.99 ms 999.37 us 64.19 ms 1712 9 11306 61 0 0 419 0 3158 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-01 17:32:10.448704 2022-12-01 17:42:31.036885
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 83 0 0 163.09 ms 60.96 ms 1.96 ms 27.22 ms 146 2 1549 19 0 0 83 0 146 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-01 17:33:14.351561 2022-12-01 17:43:58.754672
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 79 0 0 156.46 ms 5.75 ms 1.98 ms 21.42 ms 21488 272 24727 313 0 0 79 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-12-01 17:32:13.273311 2022-12-01 17:43:53.682876
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 61 0 0 156.33 ms 81.76 ms 2.56 ms 45.16 ms 657 11 4897 80 0 0 0 0 1371 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-01 17:32:10.485858 2022-12-01 17:44:00.899652
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 190 0 0 155.87 ms 3.41 ms 820.36 us 74.95 ms 1075 6 6200 33 0 0 190 0 1075 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-01 17:33:08.506367 2022-12-01 17:44:00.897464
CREATE SCHEMA `employee` DEFAU ... ` COLLATE `utf8... NULL 1 0 0 148.76 ms 148.76 ms 148.76 ms 91.00 us 0 0 0 0 1 1 0 0 0 0 4befc9546d65372737c16817dcb3e6ad0e2d9852cc5afca776... 2022-12-01 17:32:16.885439 2022-12-01 17:32:16.885439
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 173 0 0 147.17 ms 2.74 ms 850.68 us 78.69 ms 891 5 4604 27 0 0 114 0 571 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-01 17:33:14.326614 2022-12-01 17:43:58.774170
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... Table_insertion * 3 0 0 145.10 ms 141.55 ms 48.37 ms 3.70 ms 21 7 1236 412 0 0 0 0 388 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-01 17:39:42.154995 2022-12-01 17:39:42.390496
INSERT INTO `reward` ( `Employ ... ard` , `amount`... employee 4 0 0 135.49 ms 43.61 ms 33.87 ms 959.00 us 0 0 0 0 4 1 0 0 0 0 ca12d83024a503aa1fa306fa158d0d6560e7ffc7e769670707... 2022-12-01 17:32:28.115229 2022-12-01 17:32:28.270852
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 146 0 0 121.38 ms 5.93 ms 831.34 us 38.68 ms 146 1 438 3 0 0 876 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-12-01 17:32:10.491586 2022-12-01 17:44:00.901059
SHOW SESSION VARIABLES LIKE ? employee * 61 0 0 117.27 ms 7.15 ms 1.92 ms 12.89 ms 61 1 35014 574 0 0 61 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-01 17:32:20.329865 2022-12-01 17:42:52.142231
SHOW SESSION VARIABLES LIKE ? mysql * 79 0 0 112.95 ms 5.89 ms 1.43 ms 8.60 ms 79 1 45346 574 0 0 79 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-01 17:32:19.600102 2022-12-01 17:43:53.684754
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sku * 3 0 0 94.89 ms 91.98 ms 31.63 ms 2.42 ms 15 5 1214 405 0 0 0 0 384 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-01 17:34:00.989163 2022-12-01 17:34:01.131683
SELECT @@`version` , @@`version_comment` NULL 588 0 0 79.92 ms 4.22 ms 135.93 us 0 ps 588 1 588 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2022-12-01 17:32:10.203303 2022-12-01 17:44:02.939225
SHOW SESSION VARIABLES LIKE ? sakila * 82 0 0 75.52 ms 2.93 ms 920.96 us 6.45 ms 82 1 47068 574 0 0 82 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-01 17:33:14.429126 2022-12-01 17:43:58.773292
SET `lc_messages` = ? NULL 584 0 0 72.68 ms 4.34 ms 124.46 us 0 ps 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2022-12-01 17:32:10.205057 2022-12-01 17:44:02.941088
SHOW SESSION VARIABLES LIKE ? NULL * 40 0 0 69.21 ms 17.99 ms 1.73 ms 6.30 ms 40 1 22960 574 0 0 40 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-01 17:32:10.432772 2022-12-01 17:44:02.963860
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... test19 1 0 0 53.91 ms 53.91 ms 53.91 ms 315.00 us 4 4 24 24 0 0 1 0 4 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-01 17:39:21.756276 2022-12-01 17:39:21.756276
Query results operations