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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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 `PROCESSLIST` ORDER BY `PROGRESS` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
ID USER HOST DB COMMAND TIME STATE INFO TIME_MS STAGE MAX_STAGE PROGRESS Descending Ascending 1 MEMORY_USED MAX_MEMORY_USED EXAMINED_ROWS QUERY_ID INFO_BINARY TID
43841 root localhost:65171 NULL Sleep 0 NULL 26.565 0 0 0.000 69248 69248 0 2242374 NULL 0
43840 pma localhost:65170 phpmyadmin Query 0 Removing tmp table
SHOW COLUMNS FROM `phpmyadmin`.`pma__column_info` ...
14.432 0 0 0.000 111760 366952 10 2242407 [BLOB - 121 B] 0
43839 root localhost:65169 NULL Sleep 0 NULL 72.614 0 0 0.000 69248 69248 0 2242231 NULL 0
43838 pma localhost:65168 phpmyadmin Query 0 Freeing items
SELECT `tables` FROM `phpmyadmin`.`pma__recent` WH...
12.650 0 0 0.000 59848 366952 1 2242410 [BLOB - 73 B] 0
43837 root localhost:65167 NULL Sleep 0 NULL 53.149 0 0 0.000 69248 69248 0 2242301 NULL 0
43836 pma localhost:65166 phpmyadmin Sleep 0 NULL 0.343 0 0 0.000 59848 366952 0 2242418 NULL 0
43835 root localhost:65165 NULL Sleep 0 NULL 38.077 0 0 0.000 69248 69248 0 2242332 NULL 0
43834 pma localhost:65164 phpmyadmin Query 0 Opening tables
SHOW COLUMNS FROM `phpmyadmin`.`pma__column_info` ...
16.393 0 0 0.000 100704 366952 0 2242403 [BLOB - 121 B] 0
43833 root localhost:65163 NULL Query 0 Opening tables
SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM...
15.171 0 0 0.000 285872 286080 0 2242406 [BLOB - 932 B] 0
43832 root localhost:65162 information_schema Sleep 0 NULL 16.573 0 0 0.000 68192 374744 0 2242396 NULL 0
43831 pma localhost:65161 phpmyadmin Sleep 0 NULL 37.066 0 0 0.000 59848 366952 0 2242329 NULL 0
43830 pma localhost:65160 phpmyadmin Sleep 0 NULL 24.527 0 0 0.000 59848 366952 0 2242378 NULL 0
43829 root localhost:65159 information_schema Query 0 Removing tmp table
SELECT TABLE_NAME FROM information_schema.VIEWS WH...
4.087 0 0 0.000 104408 1363704 0 2242416 [BLOB - 151 B] 0
43828 pma localhost:65158 phpmyadmin Sleep 0 NULL 31.835 0 0 0.000 59848 600840 0 2242352 NULL 0
43827 root localhost:65156 information_schema Sleep 0 NULL 3.183 0 0 0.000 68192 1363704 0 2242413 NULL 0
43826 root localhost:65157 information_schema Query 0 Init
SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I...
0.000 0 0 0.000 68192 1363704 0 2242419 [BLOB - 138 B] 0
43825 root localhost:65155 information_schema Query 0 Opening tables
SHOW  COLUMNS FROM `information_schema`.`INNODB_SY...
3.985 0 0 0.000 109048 372488 0 2242417 [BLOB - 63 B] 0
43824 pma localhost:65154 phpmyadmin Sleep 0 NULL 5.407 0 0 0.000 59848 600840 0 2242414 NULL 0
43823 pma localhost:65153 phpmyadmin Sleep 0 NULL 67.965 0 0 0.000 59848 366952 0 2242250 NULL 0
43822 pma localhost:65152 phpmyadmin Sleep 0 NULL 68.815 0 0 0.000 59848 366952 0 2242240 NULL 0
43821 root localhost:65151 information_schema Query 0 Filling schema table
SELECT * FROM `PROCESSLIST` ORDER BY `PROGRESS` DE...
16.352 0 0 0.000 137160 372488 0 2242404 [BLOB - 64 B] 0
43820 pma localhost:65150 phpmyadmin Sleep 0 NULL 115.803 0 0 0.000 59848 366952 0 2242116 NULL 0
5 system user NULL Daemon 0 InnoDB shutdown handler NULL 0.000 0 0 0.000 23960 23960 0 0 NULL 0
2 system user NULL Daemon 0 InnoDB purge worker NULL 0.000 0 0 0.000 23960 23960 0 0 NULL 0
3 system user NULL Daemon 0 InnoDB purge worker NULL 0.000 0 0 0.000 23960 23960 0 0 NULL 0
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query