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
Kill672pmalocalhostphpmyadminSleep0---0.000---
Kill673rootlocalhosthmisQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill676pmalocalhostphpmyadminSleep0---0.000---
Kill677rootlocalhosthmisQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill748pmalocalhostNoneSleep0---0.000---
Kill749rootlocalhostherpSleep0---0.000---
Kill762pmalocalhostphpmyadminSleep0---0.000---
Kill763rootlocalhosthmisQuery0Sending data0.000
SELECT COUNT(*) FROM `hmis`.`drugissues`
Kill780pmalocalhostphpmyadminSleep0---0.000---
Kill781rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill800pmalocalhostphpmyadminSleep0---0.000---
Kill803rootlocalhosthmisQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill807pmalocalhostphpmyadminSleep0---0.000---
Kill809rootlocalhostherpQuery0Writing to net0.000
SELECT COUNT(*) FROM `herp`.`daily_attendance`
Kill844pmalocalhostphpmyadminSleep0---0.000---
Kill845rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill846pmalocalhostphpmyadminSleep0---0.000---
Kill847rootlocalhostherpQuery0closing tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill850pmalocalhostphpmyadminSleep0---0.000---
Kill851rootlocalhosthmisQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill866pmalocalhostphpmyadminSleep0---0.000---
Kill867rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill884pmalocalhostphpmyadminSleep0---0.000---
Kill886rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill903pmalocalhostphpmyadminSleep0---0.000---
Kill906rootlocalhostherpQuery0closing tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill918pmalocalhostphpmyadminSleep0---0.000---
Kill919rootlocalhostherpQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill953pmalocalhostphpmyadminSleep0---0.000---
Kill957pmalocalhostNoneSleep1---0.000---
Kill958rootlocalhostherpQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill959rootlocalhostherpQuery0closing tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill973pmalocalhostphpmyadminSleep0---0.000---
Kill975rootlocalhostherpQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1006pmalocalhostNoneSleep0---0.000---
Kill1007pmalocalhostphpmyadminSleep0---0.000---
Kill1008rootlocalhosthmisQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1009rootlocalhostinformation_schemaSleep0---0.000---
Kill1019pmalocalhostphpmyadminSleep31---0.000---
Kill1020rootlocalhostherpQuery21Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1032pmalocalhostNoneSleep0---0.000---
Kill1033rootlocalhostinformation_schemaQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1042pmalocalhostNoneSleep0---0.000---
Kill1043rootlocalhostinformation_schemaQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1048pmalocalhostphpmyadminSleep3---0.000---
Kill1050rootlocalhosthmisQuery3Sending data0.000
SELECT COUNT(*) FROM `hmis`.`addresses`
Kill1068pmalocalhostphpmyadminSleep0---0.000---
Kill1069rootlocalhostperformance_schemaQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1070pmalocalhostphpmyadminSleep22---0.000---
Kill1072rootlocalhostherpQuery21Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1074pmalocalhostphpmyadminSleep0---0.000---
Kill1075pmalocalhostNoneSleep15---0.000---
Kill1076rootlocalhostmysqlSleep0---0.000---
Kill1077rootlocalhostherpSleep0---0.000---
Kill1078pmalocalhostNoneSleep0---0.000---
Kill1081rootlocalhostinformation_schemaQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1086pmalocalhostNoneSleep14---0.000---
Kill1088rootlocalhostherpSleep15---0.000---
Kill1094pmalocalhostNoneSleep0---0.000---
Kill1095rootlocalhostmysqlSleep0---0.000---
Kill1096pmalocalhostphpmyadminSleep0---0.000---
Kill1097rootlocalhostmysqlSleep0---0.000---
Kill1107pmalocalhostphpmyadminSleep16---0.000---
Kill1109rootlocalhostherpQuery15Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1110pmalocalhostphpmyadminSleep16---0.000---
Kill1111rootlocalhosthmisQuery6Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1125pmalocalhostNoneSleep0---0.000---
Kill1129pmalocalhostphpmyadminSleep0---0.000---
Kill1131rootlocalhostinformation_schemaQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1133rootlocalhostinformation_schemaQuery0Writing to net0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1140pmalocalhostphpmyadminSleep3---0.000---
Kill1141rootlocalhostherpSleep4---0.000---
Kill1142pmalocalhostNoneSleep0---0.000---
Kill1143rootlocalhostperformance_schemaQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1144pmalocalhostphpmyadminSleep9---0.000---
Kill1145rootlocalhostherpQuery8Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1148pmalocalhostphpmyadminSleep8---0.000---
Kill1151rootlocalhostherpQuery7Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1157pmalocalhostphpmyadminSleep7---0.000---
Kill1159pmalocalhostphpmyadminSleep2---0.000---
Kill1160rootlocalhostherpSleep2---0.000---
Kill1161rootlocalhostherpQuery6Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1164pmalocalhostNoneSleep0---0.000---
Kill1165rootlocalhostperformance_schemaQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1166pmalocalhostphpmyadminSleep0---0.000---
Kill1168rootlocalhostphpmyadminQuery0checking permissions0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1170pmalocalhostphpmyadminSleep0---0.000---
Kill1172pmalocalhostphpmyadminSleep0---0.000---
Kill1173rootlocalhostperformance_schemaQuery0Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1174pmalocalhostphpmyadminSleep0---0.000---
Kill1175pmalocalhostphpmyadminSleep1---0.000---
Kill1176rootlocalhostNoneSleep1---0.000---
Kill1177pmalocalhostphpmyadminSleep0---0.000---
Kill1178rootlocalhostherpQuery1Opening tables0.000
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`        
Kill1179rootlocalhostmysqlSleep0---0.000---
Kill1180pmalocalhostphpmyadminSleep0---0.000---
Kill1181pmalocalhostphpmyadminSleep0---0.000---
Kill1182rootlocalhostNoneSleep0---0.000---
Kill1183rootlocalhostNoneSleep1---0.000---
Kill1184pmalocalhostphpmyadminSleep1---0.000---
Kill1185rootlocalhostNoneSleep1---0.000---
Kill1186pmalocalhostNoneSleep1---0.000---
Kill1187rootlocalhostmysqlQuery0init0.000
SHOW PROCESSLIST
Kill1188pmalocalhostphpmyadminSleep0---0.000---
Kill1189pmalocalhostphpmyadminSleep0---0.000---
Kill1190rootlocalhostNoneSleep0---0.000---
Kill1191rootlocalhostNoneSleep0---0.000---
Kill1192pmalocalhostphpmyadminSleep0---0.000---
Kill1193rootlocalhostNoneSleep0---0.000---
Kill1194pmalocalhostNoneSleep0---0.000---
Kill1195pmalocalhostNoneSleep0---0.000---
Kill1196pmalocalhostNoneSleep0---0.000---
Kill1197rootlocalhostNoneSleep0---0.000---
Kill1198rootlocalhostNoneSleep0---0.000---
Kill1199unauthenticated userlocalhostNoneConnect0Reading from net0.000---
Kill1200rootlocalhostNoneSleep0---0.000---
Note: Enabling the auto refresh here might cause heavy traffic between the web server and the MySQL server.