Drop files here

SQL upload ( 0 ) x-

Server: localhost
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
Filters
ProcessesIDUserHostDatabaseCommandTimeStatusProgressSQL queryShow Full Queries
Kill948pmalocalhostNoneSleep0---0.000---
Kill949rootlocalhosthmisQuery0Sending data0.000
SELECT COUNT(*) FROM `hmis`.`ipadmissions`
Kill984pmalocalhostNoneSleep0---0.000---
Kill985rootlocalhosthmisQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1034pmalocalhostphpmyadminSleep0---0.000---
Kill1035rootlocalhostherpQuery0closing tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1038pmalocalhostNoneSleep0---0.000---
Kill1039rootlocalhostherpQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1044pmalocalhostphpmyadminSleep0---0.000---
Kill1045rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1046pmalocalhostNoneSleep0---0.000---
Kill1047rootlocalhostherpQuery0closing tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1076pmalocalhostphpmyadminSleep0---0.000---
Kill1077rootlocalhosthmisQuery0Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1082pmalocalhostNoneSleep0---0.000---
Kill1083rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1133pmalocalhostphpmyadminSleep0---0.000---
Kill1134rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1150pmalocalhostNoneSleep11---0.000---
Kill1151rootlocalhosthmisQuery0removing tmp table0.000
SHOW FULL COLUMNS FROM `hmis`.`patienttransfers`
Kill1158pmalocalhostphpmyadminSleep0---0.000---
Kill1159rootlocalhosthmisQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1160pmalocalhostphpmyadminSleep0---0.000---
Kill1163rootlocalhosthmisQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1175pmalocalhostNoneSleep11---0.000---
Kill1176rootlocalhostherpQuery0Opening tables0.000
SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'herp' LIMIT 1
Kill1182pmalocalhostNoneSleep9---0.000---
Kill1183pmalocalhostphpmyadminSleep9---0.000---
Kill1184rootlocalhosthmisQuery4Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1185rootlocalhostherpQuery3Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1186pmalocalhostphpmyadminSleep7---0.000---
Kill1187rootlocalhostherpQuery1Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1192pmalocalhostphpmyadminQuery0Opening tables0.000
SELECT `tables` FROM `phpmyadmin`.`pma__favorite` WHERE `username` = 'root'
Kill1193rootlocalhostherpSleep0---0.000---
Kill1194pmalocalhostNoneSleep5---0.000---
Kill1195rootlocalhosthmisSleep0---0.000---
Kill1196pmalocalhostNoneSleep3---0.000---
Kill1197rootlocalhostherpQuery2Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1198pmalocalhostNoneSleep3---0.000---
Kill1199rootlocalhosthmisQuery2closing tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1200pmalocalhostphpmyadminSleep2---0.000---
Kill1201rootlocalhosthmisQuery2Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`
Kill1202pmalocalhostNoneSleep0---0.000---
Kill1203rootlocalhostmysqlSleep0---0.000---
Kill1206pmalocalhostphpmyadminSleep0---0.000---
Kill1207rootlocalhostmysqlSleep0---0.000---
Kill1208pmalocalhostphpmyadminSleep0---0.000---
Kill1209rootlocalhosttestSleep0---0.000---
Kill1210pmalocalhostphpmyadminSleep0---0.000---
Kill1211rootlocalhostmysqlQuery0init0.000
SHOW PROCESSLIST
Note: Enabling the auto refresh here might cause heavy traffic between the web server and the MySQL server.
Start auto refresh