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 ... me` AS UNSIGNED... sakila 14 0 0 324.72 ms 226.06 ms 23.19 ms 9.83 ms 146 10 566 40 0 0 2 0 138 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-09 16:01:47.646888 2022-08-09 16:03:00.635945
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 8 0 0 167.28 ms 60.29 ms 20.91 ms 3.82 ms 18 2 197 25 0 0 8 0 18 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-08-09 16:01:47.713342 2022-08-09 16:03:00.679123
CREATE SCHEMA `bases de datos` ... f8` COLLATE `ut... NULL 1 0 2 151.61 ms 151.61 ms 151.61 ms 87.00 us 0 0 0 0 1 1 0 0 0 0 f6cbc284466c7c51d59e9eab15347661a385e267ce26a15d3f... 2022-08-09 16:03:01.616044 2022-08-09 16:03:01.616044
SHOW SESSION VARIABLES LIKE ? NULL * 37 0 0 95.94 ms 17.06 ms 2.59 ms 7.92 ms 37 1 21238 574 0 0 37 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-08-09 16:01:47.560114 2022-08-09 16:03:02.413771
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 28 0 0 50.02 ms 5.90 ms 1.79 ms 27.31 ms 173 6 1567 56 0 0 0 0 149 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-08-09 16:02:25.772696 2022-08-09 16:02:44.240488
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 30 0 0 42.86 ms 4.78 ms 1.43 ms 15.71 ms 408 14 2458 82 0 0 73 0 782 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-09 16:01:54.370836 2022-08-09 16:03:02.038742
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 26 0 0 40.72 ms 3.08 ms 1.57 ms 4.93 ms 297 11 1363 52 0 0 26 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-08-09 16:02:43.921719 2022-08-09 16:02:53.326850
SHOW TABLES FROM `phpmyadmin` NULL 154 154 0 39.99 ms 4.56 ms 259.64 us 15.51 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-08-09 16:01:38.150319 2022-08-09 16:03:02.395668
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 31 0 0 36.81 ms 3.00 ms 1.19 ms 18.70 ms 179 6 980 32 0 0 24 0 144 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-08-09 16:01:47.652599 2022-08-09 16:03:00.710679
SELECT `rtn` . `name` AS `SPEC ...  . `name` ) WHE... NULL 18 0 0 34.85 ms 15.60 ms 1.94 ms 14.08 ms 18 1 324 18 0 0 0 0 0 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2022-08-09 16:02:25.799576 2022-08-09 16:02:44.234518
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 39 0 0 32.54 ms 1.80 ms 834.30 us 9.58 ms 39 1 117 3 0 0 234 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-08-09 16:01:38.155954 2022-08-09 16:03:02.045162
SELECT `cat` . `name` AS `CATA ... database` ( `sc... sakila * 33 0 0 27.55 ms 3.21 ms 834.95 us 10.36 ms 294 9 1955 59 0 0 71 0 540 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-09 16:01:47.851121 2022-08-09 16:02:55.717975
SELECT * FROM `customer` LIMIT ?, ... sakila * 2 0 0 26.70 ms 26.58 ms 13.35 ms 387.00 us 50 25 50 25 0 0 0 0 0 0 16a97f91ffa1f99dd3a69cefeefd2a63504f2848d2051bfdd7... 2022-08-09 16:01:47.589898 2022-08-09 16:02:55.682030
SELECT `address` FROM `sakila` ... ddress` WHERE `... sakila 50 0 0 26.70 ms 19.31 ms 533.92 us 3.51 ms 50 1 50 1 0 0 0 0 0 0 413816d48c3d4174a38c40aca2eba0efe3e8df4d2349f92267... 2022-08-09 16:01:47.767157 2022-08-09 16:02:55.709882
SELECT COUNT ( * ) FROM `sakila` . `payment` sakila 2 0 0 26.56 ms 22.11 ms 13.28 ms 223.00 us 2 1 0 0 0 0 0 0 0 0 9da2fa260c610f34271704b0700c0e4b5ffb71aa503961d442... 2022-08-09 16:02:23.896851 2022-08-09 16:02:30.223551
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 11 0 1 23.62 ms 6.75 ms 2.15 ms 7.68 ms 156 14 754 69 0 0 23 0 210 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-08-09 16:01:55.215283 2022-08-09 16:02:35.999689
SELECT COUNT ( * ) FROM `sakila` . `rental` sakila 2 0 0 21.79 ms 17.04 ms 10.90 ms 307.00 us 2 1 0 0 0 0 0 0 0 0 7d97a6c70d81c712aeb910da01c9e0bb4d9626c9e5f74fc847... 2022-08-09 16:02:23.914413 2022-08-09 16:02:30.229470
SELECT COUNT ( * ) FROM `sakila` . `inventory` sakila 2 0 0 18.26 ms 16.45 ms 9.13 ms 274.00 us 2 1 0 0 0 0 0 0 0 0 e8b9dc02013b7a40f3555a35d3ba101a8f4ba0215180510cf0... 2022-08-09 16:02:23.869864 2022-08-09 16:02:30.215828
SELECT COUNT ( * ) FROM `sakila` . `film` sakila 2 0 0 18.01 ms 16.64 ms 9.01 ms 485.00 us 2 1 0 0 0 0 0 0 0 0 e2bad0048e4fda42275285c56959cc02c3180254cb5c949816... 2022-08-09 16:02:23.842502 2022-08-09 16:02:30.207254
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 4 0 0 18.01 ms 8.60 ms 4.50 ms 3.11 ms 1088 272 1252 313 0 0 4 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-08-09 16:01:55.185780 2022-08-09 16:02:54.724362
SET `lc_messages` = ? NULL 77 0 0 15.72 ms 4.29 ms 204.11 us 0 ps 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2022-08-09 16:01:38.149500 2022-08-09 16:03:02.390080
SHOW SESSION VARIABLES LIKE ? mysql * 5 0 0 14.83 ms 6.90 ms 2.97 ms 1.01 ms 5 1 2870 574 0 0 5 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-08-09 16:01:54.595087 2022-08-09 16:02:54.726558
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 57 0 0 12.82 ms 1.16 ms 224.90 us 5.97 ms 57 1 57 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2022-08-09 16:01:38.153139 2022-08-09 16:03:02.410415
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema 10 0 0 12.10 ms 1.55 ms 1.21 ms 7.07 ms 0 0 30 3 0 0 10 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-08-09 16:02:29.140540 2022-08-09 16:02:53.329913
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sakila 16 0 0 11.85 ms 3.52 ms 740.48 us 4.96 ms 0 0 48 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2022-08-09 16:01:47.594114 2022-08-09 16:03:00.637372
Query results operations